<?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]]';
}
