<?php require '/Includes/XCRED.php'; $iTennantId = $_POST['TennantId']; $iUserId = $_POST['UserId']; $iGroupId = $_POST['GroupId']; $sName = $_POST['Name']; $sDescription = $_POST['Description']; $sGroupLogo = $_POST['GroupLogo']; $SQL = 'call spDAInsUpdGroup (' . $iUserId . ',' . $iTennantId . ',' . $iGroupId . ',\'' . $sName . '\',\'' . $sDescription . '\',\'' . $sGroupLogo . '\',0)'; $result = mysql_query($SQL); $num_rows = mysql_num_rows($result); if ($num_rows > 0) { $iCnt = 0; $sDADoc = 'var oDAGroups=Array();'; while ($row = mysql_fetch_array($result)) { $iGroupId = $row['GroupId']; $sGroupLogo = $row['GroupLogo']; $sName = $row['Name']; $sDADoc .= "oDAGroups[" . $iCnt . "]= new Object();"; $sDADoc .= "oDAGroups[" . $iCnt . "]['GroupId']='" . fTidyJSON($iGroupId, 1) . "';"; $sDADoc .= "oDAGroups[" . $iCnt . "]['GroupLogo']='" . fTidyJSON($sGroupLogo, 1) . "';"; $sDADoc .= "oDAGroups[" . $iCnt . "]['Name']='" . fTidyJSON($sName, 1) . "';"; $iCnt = $iCnt + 1; } echo $sDADoc; }
if ($num_rows > 0) { echo '<div id="divTennantContainer">'; while ($row = mysql_fetch_array($result)) { $sSiteTitle = $row['SiteTitle']; $sShortDesc = $row['ShortDesc']; $sPageImageURL = $row['PageImageURL']; $iTennantId = $row['TennantId']; if (strlen($sPageImageURL) < 1) { $sPageImageURL = '/images/OneXPageDefSiteImage.gif'; } //echo '<div id="divTR_'.$iTennantId.'" class="divTennantRow">'; //echo '<div class="divTRInner">'; //echo '<div class="divTPageImage"><img onclick="self.location=\'/OXP_PAGELIST?tnt='.$iTennantId.'\'" src="'.$sPageImageURL.'"/></div>'; //echo '<div class="divTPageDesc"><span>'.$sShortDesc.'</span></div>'; //echo '<div class="EditControls" title="Edit Site"><a class="Edit" href="/OXP_PAGELIST?tnt='.$iTennantId.'"><img src="/images/spacer.gif">Edit Site</a></div>'; //echo '</div></div>'; $sDADoc .= "oDATennants[" . $iCnt . "]= new Object();"; $sDADoc .= "oDATennants[" . $iCnt . "]['TennantId']='" . fTidyJSON($iTennantId, 1) . "';"; $sDADoc .= "oDATennants[" . $iCnt . "]['PageImageURL']='" . fTidyJSON($sPageImageURL, 1) . "';"; $sDADoc .= "oDATennants[" . $iCnt . "]['ShortDesc']='" . fTidyJSON($sShortDesc, 1) . "';"; $sDADoc .= "oDATennants[" . $iCnt . "]['Title']='" . fTidyJSON($sSiteTitle, 1) . "';"; $iCnt = $iCnt + 1; } echo '<div class="WaitNote">One moment while we retrieve your XPage sites...</div>'; echo '<div id="divTntJSONDoc" style="display:none;">' . $sDADoc . '</div>'; } echo '</div>'; ?>
<?php //Build JSON Documentation $sDADoc = 'var oDANav=Array();'; $iCnt = 0; $SQL = ' select p.PageId, p.Title, n.Active+0 as Active, o.Type, o.OrderNum ' . ' from DA_Pages p ' . ' left join DA_Order o on o.EntityId=p.PageId and o.Type=0 ' . ' left join DA_Nav n on n.PageId=p.PageId ' . ' where p.TennantId=\'' . $iTennantId . '\' and p.active is not null' . ' order by Type, OrderNum, Title'; $result = mysql_query($SQL); $num_rows = mysql_num_rows($result); if ($num_rows > 0) { while ($row = mysql_fetch_array($result)) { $iPageId = $row['PageId']; $sTitle = $row['Title']; $bActive = $row['Active']; $iSortType = $row['Type']; $sDADoc .= "oDANav[" . $iCnt . "]= new Object();"; $sDADoc .= "oDANav[" . $iCnt . "]['PageId']='" . fTidyJSON($iPageId, 1) . "';"; $sDADoc .= "oDANav[" . $iCnt . "]['Title']='" . fTidyJSON($sTitle, 1) . "';"; $sDADoc .= "oDANav[" . $iCnt . "]['Active']='" . fTidyJSON($bActive, 1) . "';"; $sDADoc .= "oDANav[" . $iCnt . "]['SortType']='" . fTidyJSON($iSortType, 1) . "';"; $iCnt = $iCnt + 1; } } echo '<div id="divJSONDoc" style="display:none;">' . $sDADoc . '</div>'; echo '<script>'; echo 'if (window.addEventListener) '; echo ' window.addEventListener("load",function() {fBuildNav(1,0);});'; echo 'else if (window.attachEvent)'; echo ' window.attachEvent(\'onload\', function() {fBuildNav(1,0)});'; echo '</script>';
if (strlen($iTennantId) < 1) { $iTennantId = $_COOKIE["CCtnt"]; } echo '<div id="divRSSList">'; $SQL = 'select r.Title, r.Description, r.AttrAuthor, r.AttrURL, r.FeedURL, r.RSSID, r.TennantId, r.RSSImage from DA_RSS r ' . ' where r.TennantId=\'' . $iTennantId . '\'' . ' order by rand();'; $result = mysql_query($SQL); $num_rows = mysql_num_rows($result); $sDARSS = 'var oDARSS=Array();'; $iCnt = 0; if ($num_rows > 0) { echo '<div id="divRSSBlockContainer">'; while ($row = mysql_fetch_array($result)) { $sTitle = $row['Title']; $sDescription = $row['Description']; $sFeedURL = $row['FeedURL']; $sAttrAuthor = $row['AttrAuthor']; $sAttrURL = $row['AttrURL']; $iRSSID = $row['RSSID']; $sRSSImage = $row['RSSImage']; $sDARSS = $sDARSS . 'oDARSS[' . $iCnt . ']= new Object();' . "oDARSS[" . $iCnt . "]['RSSID']='" . fTidyJSON($iRSSID, 1) . "';" . "oDARSS[" . $iCnt . "]['Title']='" . fTidyJSON($sTitle, 1) . "';" . "oDARSS[" . $iCnt . "]['Description']='" . fTidyJSON($sDescription, 1) . "';" . "oDARSS[" . $iCnt . "]['AttrAuthor']='" . fTidyJSON($sAttrAuthor, 1) . "';" . "oDARSS[" . $iCnt . "]['AttrURL']='" . fTidyJSON($sAttrURL, 1) . "';" . "oDARSS[" . $iCnt . "]['FeedURL']='" . fTidyJSON($sFeedURL, 1) . "';" . "oDARSS[" . $iCnt . "]['RSSImage']='" . fTidyJSON($sRSSImage, 1) . "';" . "oDARSS[" . $iCnt . "]['RSSCOLS']='" . fTidyJSON($sSmartCodeOptions, 1) . "';"; $iCnt = $iCnt + 1; } echo '<div class="WaitNote">One moment while we retrieve your feeds sites...</div>'; echo '<div id="divRSSJSONDoc" style="display:none;">' . $sDARSS . '</div>'; echo '</div>'; } echo '</div>'; ?>
<?php require '/Includes/XCRED.php'; //$iTennantId=$Persist_LoggedInTennantId; $iTennantId = $_COOKIE["CCtnt"]; $SQL = 'select ifnull(a.AdminId,0) as Admin, g.GroupLogo, g.Name, g.GroupId, g.Description from DA_Residence r' . ' join DA_Group g on g.GroupId=r.EntityId and g.Active=1' . ' join DA_Like f on f.EntityId=g.GroupId and f.UserId=' . $Persist_UserId . ' and f.Type=1' . ' left join DA_Administration a on a.EntityId=g.GroupId and a.UserId=' . $Persist_UserId . ' and a.AdminType=0' . ' where r.TennantId=' . $iTennantId . ' order by Name;'; //echo $SQL; $result = mysql_query($SQL); $num_rows = mysql_num_rows($result); if ($num_rows > 0) { $iCnt = 0; $sDADoc = 'var oDAGroups=Array();'; while ($row = mysql_fetch_array($result)) { $iGroupId = $row['GroupId']; $sGroupLogo = $row['GroupLogo']; $sName = $row['Name']; $iAdmin = $row['Admin']; $sDADoc .= "oDAGroups[" . $iCnt . "]= new Object();"; $sDADoc .= "oDAGroups[" . $iCnt . "]['GroupId']='" . fTidyJSON($iGroupId, 1) . "';"; $sDADoc .= "oDAGroups[" . $iCnt . "]['GroupLogo']='" . fTidyJSON($sGroupLogo, 1) . "';"; $sDADoc .= "oDAGroups[" . $iCnt . "]['Name']='" . fTidyJSON($sName, 1) . "';"; $sDADoc .= "oDAGroups[" . $iCnt . "]['Admin']='" . fTidyJSON($iAdmin, 1) . "';"; $iCnt = $iCnt + 1; } echo $sDADoc; }
} $sDADoc .= "oDAWall[" . $iCnt . "]= new Object();"; $sDADoc .= "oDAWall[" . $iCnt . "]['TennantId']='" . fTidyJSON($iTennantId, 1) . "';"; $sDADoc .= "oDAWall[" . $iCnt . "]['WMID']='" . fTidyJSON($iWMID, 1) . "';"; $sDADoc .= "oDAWall[" . $iCnt . "]['EntityId']='" . fTidyJSON($iEntityId, 1) . "';"; $sDADoc .= "oDAWall[" . $iCnt . "]['UserId']='" . fTidyJSON($iUserId, 1) . "';"; $sDADoc .= "oDAWall[" . $iCnt . "]['CreateDate']='" . fTidyJSON($dCreateDate, 1) . "';"; $sDADoc .= "oDAWall[" . $iCnt . "]['UserImage']='" . fTidyJSON($sUserImage, 1) . "';"; $sDADoc .= "oDAWall[" . $iCnt . "]['FirstName']='" . fTidyJSON($sFirstName, 1) . "';"; $sDADoc .= "oDAWall[" . $iCnt . "]['LastName']='" . fTidyJSON($sLastName, 1) . "';"; $sDADoc .= "oDAWall[" . $iCnt . "]['CompanyName']='" . fTidyJSON($sCompanyName, 1) . "';"; $sDADoc .= "oDAWall[" . $iCnt . "]['EntityImage']='" . fTidyJSON($sEntityURL, 1) . "';"; $sDADoc .= "oDAWall[" . $iCnt . "]['EntityId2']='" . fTidyJSON($iEntityId2, 1) . "';"; $sDADoc .= "oDAWall[" . $iCnt . "]['EntityName2']='" . fTidyJSON($sEntityName2, 1) . "';"; $sDADoc .= "oDAWall[" . $iCnt . "]['Message']='" . fTidyJSON($sMessage, 1) . "';"; $sDADoc .= "oDAWall[" . $iCnt . "]['MsgType']='" . fTidyJSON($sMsgType, 1) . "';"; $iCnt = $iCnt + 1; } mysql_free_result($result); } } else { echo '[[LOGGEDOUT]]'; } if ($_GET['Refresh'] != 1) { //echo '<div id="MainWallMsgs"></div>'; //echo '<div style="display:none;" id="WallMsgJSON">'.$sDADoc.'</div>'; } else { echo $sDADoc; } ?>
$sAddr1 = $row['Addr1']; $sAddr2 = $row['Addr2']; $sAddr3 = $row['Addr3']; $sCity = $row['City=']; $sState = $row['State']; $sPostalCode = $row['PostalCode']; $sCountry = $row['Country']; $sLongLat = $row['LongLat']; if (strlen($sPhotoURL) < 1) { $sPhotoURL = '/images/NoAvatar.png'; } $sDADoc .= "oDAProfile[" . $iCnt . "]= new Object();"; $sDADoc .= "oDAProfile[" . $iCnt . "]['UserId']='" . fTidyJSON($iUserId, 1) . "';"; $sDADoc .= "oDAProfile[" . $iCnt . "]['LastName']='" . fTidyJSON($sLastName, 1) . "';"; $sDADoc .= "oDAProfile[" . $iCnt . "]['FirstName']='" . fTidyJSON($sFirstName, 1) . "';"; $sDADoc .= "oDAProfile[" . $iCnt . "]['CreateDate']='" . fTidyJSON($dCreateDate, 1) . "';"; $sDADoc .= "oDAProfile[" . $iCnt . "]['PhotoURL']='" . fTidyJSON($sPhotoURL, 1) . "';"; $sDADoc .= "oDAProfile[" . $iCnt . "]['Email']='" . fTidyJSON($sEmail, 1) . "';"; $sDADoc .= "oDAProfile[" . $iCnt . "]['TennantIdRow']='" . fTidyJSON($iTennantIdRow, 1) . "';"; $sDADoc .= "oDAProfile[" . $iCnt . "]['Addr1']='" . fTidyJSON($sAddr1, 1) . "';"; $sDADoc .= "oDAProfile[" . $iCnt . "]['Addr2']='" . fTidyJSON($sAddr2, 1) . "';"; $sDADoc .= "oDAProfile[" . $iCnt . "]['Addr3']='" . fTidyJSON($sAddr3, 1) . "';"; $sDADoc .= "oDAProfile[" . $iCnt . "]['City']='" . fTidyJSON($sCity, 1) . "';"; $sDADoc .= "oDAProfile[" . $iCnt . "]['State']='" . fTidyJSON($sState, 1) . "';"; $sDADoc .= "oDAProfile[" . $iCnt . "]['PostalCode']='" . fTidyJSON($sPostalCode, 1) . "';"; $sDADoc .= "oDAProfile[" . $iCnt . "]['Country']='" . fTidyJSON($sCountry, 1) . "';"; $sDADoc .= "oDAProfile[" . $iCnt . "]['LongLat']='" . fTidyJSON($sLongLat, 1) . "';"; $iCnt = $iCnt + 1; } echo $sDADoc; }
<?php $Persist_UserId = $_COOKIE["CCrdlUID"]; $PWDHash = $_COOKIE["CCrdl"]; $iTennantId = $_GET['tnt']; if (strlen($iTennantId) < 1) { $iTennantId = $_COOKIE["CCtnt"]; } $SQL = 'select ifnull(f.LikeId,0) as FollowStatus,' . ' (select count(*) from DA_Like l where l.EntityId=g.GroupId and l.Type=1) as TotFollowers,' . ' g.GroupLogo, g.Name, g.GroupId, g.Description from DA_Residence r' . ' join DA_Group g on g.GroupId=r.EntityId and g.Active=1' . ' left join DA_Like f on f.EntityId=g.GroupId and f.UserId=' . $Persist_UserId . ' and f.Type=1' . ' where r.TennantId=' . $iTennantId . ' order by Name'; // echo $SQL; $result = mysql_query($SQL); $num_rows = mysql_num_rows($result); $sDAGroups = 'var oDAGroupDirectory=Array();'; $iCnt = 0; if ($num_rows > 0) { while ($row = mysql_fetch_array($result)) { $sName = $row['Name']; $sDescription = $row['Description']; $iGroupId = $row['GroupId']; $sGroupLogo = $row['GroupLogo']; $iTotFollowers = $row['TotFollowers']; $iFollowStatus = $row['FollowStatus']; $sDAGroups = $sDAGroups . 'oDAGroupDirectory[' . $iCnt . ']= new Object();' . "oDAGroupDirectory[" . $iCnt . "]['GroupId']='" . fTidyJSON($iGroupId, 1) . "';" . "oDAGroupDirectory[" . $iCnt . "]['Name']='" . fTidyJSON($sName, 1) . "';" . "oDAGroupDirectory[" . $iCnt . "]['Description']='" . nl2br(fTidyJSON($sDescription, 0)) . "';" . "oDAGroupDirectory[" . $iCnt . "]['GroupLogo']='" . fTidyJSON($sGroupLogo, 1) . "';" . "oDAGroupDirectory[" . $iCnt . "]['TotFollowers']='" . fTidyJSON($iTotFollowers, 1) . "';" . "oDAGroupDirectory[" . $iCnt . "]['FollowStatus']='" . $iFollowStatus . "';"; $iCnt = $iCnt + 1; } } echo $sDAGroups;
<?php $Persist_UserId = $_COOKIE["CCrdlUID"]; $iTennantId = $_GET['tnt']; if (strlen($iTennantId) < 1) { $iTennantId = $_COOKIE["CCtnt"]; } $sSearch = $_GET['s']; $iCnt = 0; $sDAGroups = 'var oDAGroupDirectory=Array();'; $sDAJSON = 'var oDASearch=Array();'; $SQL = 'call spDASearch (' . $iTennantId . ',' . $Persist_UserId . ',\'' . $sSearch . '\');'; $result = mysql_query($SQL); $num_rows = mysql_num_rows($result); if ($num_rows > 0) { while ($row = mysql_fetch_array($result)) { $iType = $row['Type']; $sName = $row['Name']; $iEntityId = $row['EntityId']; $sLogo = $row['Logo']; if (strlen($sLogo) < 1) { $sLogo = '/images/NoAvatar.png'; } $sDAJSON = $sDAJSON . 'oDASearch[' . $iCnt . ']= new Object();' . "oDASearch[" . $iCnt . "]['Type']='" . fTidyJSON($iType, 1) . "';" . "oDASearch[" . $iCnt . "]['Name']='" . fTidyJSON($sName, 1) . "';" . "oDASearch[" . $iCnt . "]['Logo']='" . fTidyJSON($sLogo, 1) . "';" . "oDASearch[" . $iCnt . "]['EntityId']='" . fTidyJSON($iEntityId, 1) . "';"; $iCnt = $iCnt + 1; } echo $sDAJSON; } else { echo '[[LOGGEDOUT]]'; }