function _getAllTables($data = false) { $Query = "SHOW TABLES"; $Result = db_res($Query); while ($Row = $Result->fetch(PDO::FETCH_NUM)) { $this->_getTableStruct($Row[0], $data); } }
/** * page code function */ function PageCompPageMainCode() { global $site; global $prof; $query = "\n\t\tSELECT\n\t\t\t`id_poll`,\n\t\t\t`id_profile`,\n\t\t\t`poll_question`,\n\t\t\t`Profiles`.*\n\t\tFROM `ProfilesPolls`\n\t\tLEFT JOIN `Profiles` ON\n\t\t\t`id_profile` = `Profiles`.`ID`\n\t\tWHERE\n\t\t\t`poll_status` = 'active'\n\t\t\tAND `poll_approval`\n\t\tORDER BY `id_poll` DESC\n\t\t"; //$query = "SELECT `ID`, `Question` FROM `polls_q` WHERE `Active` = 'on' ORDER BY `Question`"; $res = db_res($query); if ($res and mysql_num_rows($res)) { $ret = '<div class="clear_both"></div>'; while ($arr = mysql_fetch_array($res)) { $age_str = _t("_y/o", age($arr['DateOfBirth'])); $y_o_sex = $age_str . ' ' . _t("_" . $arr['Sex']); $poll_coutry = _t("__" . $prof['countries'][$arr['Country']]); $ret .= '<div class="pollBody">'; $ret .= '<div class="clear_both"></div>'; $ret .= '<div class="pollInfo">'; $ret .= get_member_icon($arr['id_profile'], 'left'); $ret .= '<div class="pollInfo_nickname">'; $ret .= _t('_Submitted by', $arr['NickName']); $ret .= '</div>'; $ret .= '<div class="pollInfo_info">'; $ret .= $y_o_sex . '<br />' . $poll_coutry; $ret .= '</div>'; $ret .= '</div>'; $ret .= '<div class="clear_both"></div>'; $ret .= ShowPoll($arr['id_poll']); $ret .= '<div class="clear_both"></div>'; $ret .= '</div>'; } $ret .= '<div class="clear_both"></div>'; } else { $ret = "<div align=center>" . _t("_No polls available") . "</div>\n"; } return $ret; }
function compile() { $sEval = "return array(\n"; $aFields = array('Caption', 'Name', 'Icon', 'Link', 'Script', 'Target', 'Order', 'Visible'); $sQuery = "SELECT `ID`, `" . implode('`, `', $aFields) . "` FROM `" . $this->sDbTable . "` WHERE `Active`='1' ORDER BY `Order`"; $rMenu = db_res($sQuery); while ($aItem = $rMenu->fetch()) { $sEval .= " " . str_pad($aItem['ID'], 2) . " => array(\n"; foreach ($aFields as $sKey => $sField) { $sCont = $aItem[$sField]; $sCont = str_replace('\\', '\\\\', $sCont); $sCont = str_replace('"', '\\"', $sCont); $sCont = str_replace('$', '\\$', $sCont); $sCont = str_replace("\n", '', $sCont); $sCont = str_replace("\r", '', $sCont); $sCont = str_replace("\t", '', $sCont); $sEval .= " " . str_pad("'{$sField}'", 11) . " => \"{$sCont}\",\n"; } $sEval .= " ),\n"; } $sEval .= ");\n"; $aResult = eval($sEval); $oCache = $GLOBALS['MySQL']->getDbCacheObject(); return $oCache->setData($GLOBALS['MySQL']->genDbCacheKey($this->sCacheKey), $aResult); }
function getNewsList($iLimit = 0) { $sqlQuery = "SELECT `News`.`ID` AS `newsID`,\r\n\t\t\t\t\t\t`Header`,\r\n\t\t\t\t\t\t`NewsUri`,\r\n\t\t\t\t\t\t`Snippet`,\r\n\t\t\t\t\t\tUNIX_TIMESTAMP( `Date` ) AS 'Date'\r\n\t\t\t\t FROM `News`\r\n\t\t\t\t ORDER BY `Date`DESC"; $sqlLimit = $iLimit > 0 ? " LIMIT {$iLimit}" : ""; $rNews = db_res($sqlQuery . $sqlLimit); return $rNews; }
function PageCompSearchResults() { global $dir; global $tmpl; $keyword = process_db_input($_REQUEST['keyword']); $sMembersQuery = "\n\t\tSELECT *\n\t\tFROM `Profiles`\n\t\tWHERE\n\t\t" . (is_numeric($keyword) ? "`ID` = '{$keyword}'" : "`NickName` LIKE '%{$keyword}%'") . ""; $rMembers = db_res($sMembersQuery); if (!mysql_num_rows($rMembers)) { return '<div class="qsearch_notfound">' . _t('_Sorry, no members found') . '</div>'; } $sRowTmpl = file_get_contents("{$dir['root']}templates/tmpl_{$tmpl}/qsearch_row.html"); $ret = ''; while ($aMember = mysql_fetch_assoc($rMembers)) { $aRowTmpl = array(); $aRowTmpl['thumbnail'] = get_member_thumbnail($aMember['ID'], 'none'); $aRowTmpl['NickName'] = "<a href=\"" . getProfileLink($aMember['ID']) . "\" target=\"_blank\">" . htmlspecialchars_adv($aMember['NickName']) . "</a>"; $aRowTmpl['actions'] = "<a href=\"javascript:void(0);\" onclick=\"hMemberAction({$aMember['ID']}, '{$aMember['NickName']}')\">" . _t('_Add member') . "</a>"; $sRow = $sRowTmpl; foreach ($aRowTmpl as $what => $to) { $sRow = str_replace("__{$what}__", $to, $sRow); } $ret .= $sRow; } return $ret; }
function getProfileInfoExtra() { $oPrivacy = new BxDolPrivacy('sys_page_compose_privacy', 'id', 'user_id'); $aRet = array(); $r = db_res("SELECT `pc`.`Caption`, `pc`.`Content`, `pc`.`Func`, `pc`.`ID` AS `BlockID`\n FROM `sys_profile_fields` AS `pf` \n INNER JOIN `sys_page_compose` AS `pc` \n ON ((`pc`.`Func` = 'PFBlock' AND `pc`.`Content` = `pf`.`ID`) OR (`pc`.`Func` = 'GeneralInfo' AND " . BX_BLOCK_GENERALINFO . " = `pf`.`ID`) OR (`pc`.`Func` = 'AdditionalInfo' AND " . BX_BLOCK_ADDITIONALINFO . " = `pf`.`ID`))\n WHERE `pc`.`Page` = 'profile_info' AND `pf`.`Type` = 'block' AND `pc`.`Column` != 0 \n ORDER BY `pc`.`Column`, `pc`.`Order`"); while ($a = $r->fetch()) { $iPrivacyId = (int) $GLOBALS['MySQL']->getOne("SELECT `id` FROM `sys_page_compose_privacy` WHERE `user_id`='" . $this->_iProfileID . "' AND `block_id`='" . $a['BlockID'] . "' LIMIT 1"); if ($iPrivacyId != 0 && !$oPrivacy->check('view_block', $iPrivacyId, $this->_iViewerId)) { continue; } switch ($a['Func']) { case 'GeneralInfo': $i = BX_BLOCK_GENERALINFO; break; case 'AdditionalInfo': $i = BX_BLOCK_ADDITIONALINFO; break; default: $i = $a['Content']; } $aBlock = $this->getProfileInfoBlock($a['Caption'], $i); if (false === $aBlock) { continue; } $aRet[] = $aBlock; } if ($this->_iViewerId == $this->_iProfileID) { $aOwnInfo[] = new xmlrpcval(array('Caption' => new xmlrpcval(_t('_E-mail')), 'Type' => new xmlrpcval('text'), 'Value1' => new xmlrpcval($this->_aProfile['Email'])), "struct"); $aOwnInfo[] = new xmlrpcval(array('Caption' => new xmlrpcval(_t('_Membership2')), 'Type' => new xmlrpcval('text'), 'Value1' => new xmlrpcval(strip_tags(GetMembershipStatus($this->_iProfileID, false, false)))), "struct"); $aOwnInfo[] = new xmlrpcval(array('Caption' => new xmlrpcval(_t('_Status')), 'Type' => new xmlrpcval('text'), 'Value1' => new xmlrpcval(_t('__' . $this->_aProfile['Status']))), "struct"); $aRet[] = new xmlrpcval(array('Info' => new xmlrpcval($aOwnInfo, "array"), 'Title' => new xmlrpcval(_t('_Account Info'))), "struct"); } return new xmlrpcval($aRet, "array"); }
function _getAllTables($data = false) { $Query = "SHOW TABLES"; $Result = db_res($Query); while ($Row = mysql_fetch_row($Result)) { $this->_getTableStruct($Row[0], $data); } }
function storeTags($iID, $sTags, $sType) { $aTags = explodeTags($sTags); db_res("DELETE FROM `sys_tags` WHERE `ID` = ? AND `Type` = ?", [$iID, $sType]); //re-store if exist foreach ($aTags as $sTag) { $sTag = addslashes($sTag); db_res("INSERT INTO `sys_tags` VALUES ( ?, ?, ?, CURRENT_TIMESTAMP )", [$sTag, $iID, $sType]); } }
function storeTags($iID, $sTags, $sType) { $aTags = explodeTags($sTags); db_res("DELETE FROM `sys_tags` WHERE `ID` = {$iID} AND `Type` = '{$sType}'"); //re-store if exist foreach ($aTags as $sTag) { $sTag = addslashes($sTag); db_res("INSERT INTO `sys_tags` VALUES ( '{$sTag}', {$iID}, '{$sType}', CURRENT_TIMESTAMP )", 0); } }
function MemberEditNews() { global $max_l; global $max_h; $news_id = (int) $_POST['edit_id']; $news_text = strlen($_POST['text']) > $max_l ? "LEFT ( '" . process_db_input($_POST['text']) . "', {$max_l} )" : "'" . process_db_input($_POST['text']) . "'"; $news_header = strlen($_POST['header']) > $max_h ? "LEFT ( '" . process_db_input($_POST['header']) . "', {$max_h} )" : "'" . process_db_input($_POST['header']) . "'"; $news_snippet = "'" . process_db_input($_POST['snippet']) . "'"; $res = db_res("UPDATE `News` SET `Date` = NOW(), `Header` = {$news_header}, `Text` = {$news_text}, `Snippet`={$news_snippet} WHERE `ID` = {$news_id}"); return $res; }
function generateUserNewPwd($ID) { $sPwd = genRndPwd(); $sSalt = genRndSalt(); $sQuery = "\n UPDATE `Profiles`\n SET\n `Password` = '" . encryptUserPwd($sPwd, $sSalt) . "',\n `Salt` = '{$sSalt}'\n WHERE\n `ID`='{$ID}'\n "; db_res($sQuery); createUserDataFile($ID); require_once BX_DIRECTORY_PATH_CLASSES . 'BxDolAlerts.php'; $oZ = new BxDolAlerts('profile', 'edit', $ID); $oZ->alert(); return $sPwd; }
/** * Update existing or create new template ; * * @param $sTemplateName (string) - name of template ; * @param $sTemplateSubj (string) - subject of template ; * @param $sTemplateBody (string) - text of template ; * @param $iLangID (integer) - needed language's ID; * @return HTML presentation data ; */ function setTemplate($sTemplateName, $sTemplateSubj, $sTemplateBody, $iLangID) { if (!db_value("SELECT `ID` FROM `sys_email_templates` WHERE `Name` = '" . process_db_input($sTemplateName) . "' AND `LangID` = '{$iLangID}'")) { $sQuery = " \r\n\t\t\t\tINSERT INTO \r\n\t\t\t\t\t`sys_email_templates` (`Name`, `Subject`, `Body`, `LangID`) \r\n\t\t\t\tVALUES\r\n\t\t\t\t\t(\r\n\t\t\t\t\t\t'" . process_db_input($sTemplateName) . "', \r\n\t\t\t\t\t\t'" . process_db_input($sTemplateSubj) . "',\r\n\t\t\t\t\t\t'" . process_db_input($sTemplateBody) . "',\r\n\t\t\t\t\t\t'" . (int) $iLangID . "'\r\n\t\t\t\t\t)\r\n\t\t\t"; $sMessage = 'Template was created'; } else { $sQuery = " \r\n\t\t\t\tUPDATE \r\n\t\t\t\t\t`sys_email_templates` \r\n\t\t\t\tSET \r\n\t\t\t\t\t`Subject` = '" . process_db_input($sTemplateSubj) . "',\r\n\t\t\t\t\t`Body` = '" . process_db_input($sTemplateBody) . "'\r\n\t\t\t\tWHERE \r\n\t\t\t\t\t`Name` = '" . process_db_input($sTemplateName) . "'\r\n\t\t\t\t\t\tAND\r\n\t\t\t\t\t`LangID` = '" . (int) $iLangID . "'\r\n\t\t\t\tLIMIT 1 \r\n\t\t\t"; $sMessage = 'Template was updated'; } db_res($sQuery); return $this->genTemplatesForm($sTemplateName, $iLangID, $sMessage); }
/** * Update existing or create new template ; * * @param $sTemplateName (string) - name of template ; * @param $sTemplateSubj (string) - subject of template ; * @param $sTemplateBody (string) - text of template ; * @param $iLangID (integer) - needed language's ID; * @return HTML presentation data ; */ function setTemplate($sTemplateName, $sTemplateSubj, $sTemplateBody, $iLangID) { if (!db_value("SELECT `ID` FROM `sys_email_templates` WHERE `Name` = '" . process_db_input($sTemplateName) . "' AND `LangID` = '{$iLangID}'")) { $sQuery = "\n INSERT INTO\n `sys_email_templates` (`Name`, `Subject`, `Body`, `LangID`)\n VALUES\n (\n '" . process_db_input($sTemplateName) . "',\n '" . process_db_input($sTemplateSubj) . "',\n '" . process_db_input($sTemplateBody) . "',\n '" . (int) $iLangID . "'\n )\n "; $sMessage = 'Template was created'; } else { $sQuery = "\n UPDATE\n `sys_email_templates`\n SET\n `Subject` = '" . process_db_input($sTemplateSubj) . "',\n `Body` = '" . process_db_input($sTemplateBody) . "'\n WHERE\n `Name` = '" . process_db_input($sTemplateName) . "'\n AND\n `LangID` = '" . (int) $iLangID . "'\n LIMIT 1\n "; $sMessage = 'Template was updated'; } db_res($sQuery); return $this->genTemplatesForm($sTemplateName, $iLangID, $sMessage); }
function getFriendRequests($sUser, $sPwd, $sLang) { if (!($iId = BxDolXMLRPCUtil::checkLogin($sUser, $sPwd))) { return new xmlrpcresp(new xmlrpcval(array('error' => new xmlrpcval(1, "int")), "struct")); } BxDolXMLRPCUtil::setLanguage($sLang); $r = db_res("\n SELECT `Profiles`.* FROM `sys_friend_list`\n LEFT JOIN `Profiles` ON `Profiles`.`ID` = `sys_friend_list`.`ID`\n WHERE `sys_friend_list`.`Profile` = {$iId} AND `Check` = 0\n ORDER BY `Profiles`.`NickName` ASC"); $aProfiles = array(); while ($aRow = $r->fetch()) { $aProfiles[] = new xmlrpcval(BxDolXMLRPCUtil::fillProfileArray($aRow, 'thumb'), 'struct'); } return new xmlrpcval($aProfiles, "array"); }
function getProfileInfoExtra() { $aRet = array(); $r = db_res("SELECT `pc`.`Caption`, `pc`.`Content` FROM `sys_profile_fields` AS `pf` INNER JOIN `sys_page_compose` AS `pc` ON (`pc`.`Func` = 'PFBlock' AND `pc`.`Content` = `pf`.`ID`) WHERE `pc`.`Page` = 'profile' AND `pf`.`Type` = 'block' AND `pc`.`Column` != 0 ORDER BY `pc`.`Column`, `pc`.`Order`"); while ($a = mysql_fetch_array($r)) { $aBlock = $this->getProfileInfoBlock($a['Caption'], $a['Content']); if (false === $aBlock) { continue; } $aRet[] = $aBlock; } return new xmlrpcval($aRet, "array"); }
/** * page code function */ function PageCompPageMainCode($iLoggedID) { $member['ID'] = (int) $iLoggedID; $p_arr = getProfileInfo($member['ID']); if ($_POST['CHANGE_STATUS']) { $sStatus = ""; switch ($_POST['CHANGE_STATUS']) { case 'SUSPEND': if ($p_arr['Status'] == 'Active') { $sStatus = "Suspended"; } break; case 'ACTIVATE': if ($p_arr['Status'] == 'Suspended') { $sStatus = "Active"; } break; } if (mb_strlen($sStatus) > 0) { db_res("UPDATE `Profiles` SET `Status` = '{$sStatus}' WHERE `ID` = {$member['ID']}"); } createUserDataFile($p_arr['ID']); reparseObjTags('profile', $member['ID']); $p_arr = getProfileInfo($member['ID']); } $aData = array('profile_status_caption' => _t("_Profile status"), 'status' => $p_arr['Status'], 'status_lang_key' => _t('__' . $p_arr['Status'])); $aForm = array('form_attrs' => array('action' => BX_DOL_URL_ROOT . 'change_status.php', 'method' => 'post', 'name' => 'form_change_status'), 'inputs' => array('status' => array('type' => 'hidden', 'name' => 'CHANGE_STATUS', 'value' => ''), 'subscribe' => array('type' => 'submit', 'name' => 'subscribe', 'value' => ''))); switch ($p_arr['Status']) { case 'Active': $aForm['inputs']['status']['value'] = 'SUSPEND'; $aForm['inputs']['subscribe']['value'] = _t('_Suspend account'); $oForm = new BxTemplFormView($aForm); $aData['form'] = $oForm->getCode(); $aData['message'] = _t("_PROFILE_CAN_SUSPEND"); break; case 'Suspended': $aForm['inputs']['status']['value'] = 'ACTIVATE'; $aForm['inputs']['subscribe']['value'] = _t('_Activate account'); $oForm = new BxTemplFormView($aForm); $aData['form'] = $oForm->getCode(); $aData['message'] = _t("_PROFILE_CAN_ACTIVATE"); break; default: $aData['message'] = _t("_PROFILE_CANT_ACTIVATE/SUSPEND"); $aData['form'] = ''; break; } return $GLOBALS['oSysTemplate']->parseHtmlByName('change_status.html', $aData); }
function getCountries($sUser, $sPwd, $sLang) { $aRet = array(); if (!($iId = BxDolXMLRPCUtil::checkLogin($sUser, $sPwd))) { return new xmlrpcresp(new xmlrpcval(array('error' => new xmlrpcval(1, "int")), "struct")); } BxDolXMLRPCUtil::setLanguage($sLang); $aCountries = array(); $r = db_res("SELECT `ISO2`, `Country` FROM `sys_countries` ORDER BY `Country` ASC"); while ($aRow = mysql_fetch_array($r)) { $a = array('Name' => new xmlrpcval(_t('__' . $aRow['Country'])), 'Code' => new xmlrpcval($aRow['ISO2'])); $aCountries[] = new xmlrpcval($a, 'struct'); } return new xmlrpcval($aCountries, "array"); }
function install($aParams) { $aResult = parent::install($aParams); $s = $this->_readFromUrl("http://ws.geonames.org/postalCodeCountryInfo?"); $a = $this->_getCountriesArray($s); if (count($a)) { db_res("TRUNCATE TABLE `bx_zip_countries_geonames`"); foreach ($a as $sCountry) { db_res("INSERT INTO `bx_zip_countries_geonames` VALUES ('{$sCountry}')"); } } else { return array('code' => BX_DOL_INSTALLER_FAILED, 'content' => 'Network error - can not get list of countries'); } return $aResult; }
function addToFavorites($iFile) { global $member; if ($iFile) { $sQuery = "SELECT * FROM `shareMusicFavorites` WHERE `medID`='{$iFile}' AND `userID`='{$member['ID']}'"; $rCheck = db_res($sQuery); if (mysql_num_rows($rCheck) > 0) { $sCode = '<div class="mediaInfo">' . _t('_File already is favorite') . '</div>'; } else { $sQuery = "INSERT INTO `shareMusicFavorites` (`medID`,`userID`,`favDate`) VALUES('{$iFile}','{$member['ID']}',NOW())"; db_res($sQuery); $sCode = '<div class="mediaInfo">' . _t("_File was added to favorite") . '</div>'; } } return $sCode; }
/** * Print news */ function MemberPrintNewsList() { global $news_limit_chars; global $short_date_format; global $tmpl; $query = "\n\t\tSELECT\n\t\t\t`ID`,\n\t\t\t`Header`,\n\t\t\t`Snippet`,\n\t\t\tDATE_FORMAT(`Date`, '{$short_date_format}' ) AS 'Date'\n\t\tFROM `News`\n\t\tORDER BY `Date` DESC\n\t\t"; $res = db_res($query); ob_start(); if (!mysql_num_rows($res)) { ?> <div class="no_news"> <?php echo _t("_No news available"); ?> </div> <?php } else { while ($news_arr = mysql_fetch_array($res)) { ?> <div class="news_cont"> <div class="clear_both"></div> <div class="news_header"> <a href="<?php echo "{$site['url']}news_view.php?ID={$news_arr['ID']}"; ?> "> <?php echo process_line_output($news_arr['Header']); ?> </a> </div> <div class="news_date"><?php echo $news_arr['Date']; ?> </div> <div class="news_snippet"> <?php echo process_text_output($news_arr['Snippet']); ?> </div> <div class="clear_both"></div> </div> <?php } } return ob_get_clean(); }
function _getMessages($sUser, $sPwd, $isInbox) { $aRet = array(); if (!($iId = BxDolXMLRPCUtil::checkLogin($sUser, $sPwd))) { return new xmlrpcresp(new xmlrpcval(array('error' => new xmlrpcval(1, "int")), "struct")); } $aMsgs = array(); $sWhere = $isInbox ? " `Recipient` = '{$iId}' " : " `Sender`= '{$iId}' "; $sJoinOn = $isInbox ? " `m`.`Sender` = `p`.`ID` " : " `m`.`Recipient` = `p`.`ID` "; $r = db_res("SELECT \r\n `m`.`ID`, `m`.`Date`, `m`.`Sender`, `m`.`Recipient`, `m`.`Subject`, `m`.`New`, \r\n `p`.`NickName` AS `Nick` \r\n FROM `sys_messages` AS `m`\r\n LEFT JOIN `Profiles` AS `p` ON ({$sJoinOn})\r\n WHERE {$sWhere} \r\n ORDER BY `Date` DESC"); while ($aRow = mysql_fetch_array($r)) { $sIcon = BxDolXMLRPCUtil::getThumbLink($isInbox ? $aRow['Sender'] : $aRow['Recipient'], 'thumb'); $aMsg = array('ID' => new xmlrpcval($aRow['ID']), 'Date' => new xmlrpcval($aRow['Date']), 'Sender' => new xmlrpcval($aRow['Sender']), 'Recipient' => new xmlrpcval($aRow['Recipient']), 'Subject' => new xmlrpcval($aRow['Subject']), 'New' => new xmlrpcval($aRow['New']), 'Nick' => new xmlrpcval($aRow['Nick']), 'Thumb' => new xmlrpcval($sIcon)); $aMsgs[] = new xmlrpcval($aMsg, 'struct'); } return new xmlrpcval($aMsgs, "array"); }
function banner_put($ID = 0, $Track = 1) { global $bann_click_url; if (!$ID) { // Get only banners that are active and for which promotion period has not expired. $bann_arr = db_arr("SELECT `ID`, `Url`, `Text` FROM `Banners` WHERE `Active` <> 0 AND `campaign_start` <= NOW() AND `campaign_end` >= NOW() ORDER BY RAND() LIMIT 1"); } else { $bann_arr = db_arr("SELECT `ID`, `Url`, `Text` FROM `Banners` WHERE `ID` = {$ID} LIMIT 1"); } if (!$bann_arr) { return ""; } if ($Track) { db_res("INSERT INTO `BannersShows` SET `ID` = {$bann_arr['ID']}, `Date` = NOW(), `IP` = '" . $_SERVER['REMOTE_ADDR'] . "'", 0); } return "<a target=\"_blank\" href=\"{$bann_click_url}?{$bann_arr['ID']}\" onmouseout=\"ce()\" onfocus=\"ss('{$bann_arr['Url']}')\" onmouseover=\"return ss('{$bann_arr['Url']}')\">{$bann_arr['Text']}</a>"; }
function getProfileInfoExtra() { $aRet = array(); $r = db_res("SELECT `pc`.`Caption`, `pc`.`Content` FROM `sys_profile_fields` AS `pf` INNER JOIN `sys_page_compose` AS `pc` ON (`pc`.`Func` = 'PFBlock' AND `pc`.`Content` = `pf`.`ID`) WHERE `pc`.`Page` = 'profile' AND `pf`.`Type` = 'block' AND `pc`.`Column` != 0 ORDER BY `pc`.`Column`, `pc`.`Order`"); while ($a = mysql_fetch_array($r)) { $aBlock = $this->getProfileInfoBlock($a['Caption'], $a['Content']); if (false === $aBlock) { continue; } $aRet[] = $aBlock; } if ($this->_iViewerId == $this->_iProfileID) { $aOwnInfo[] = new xmlrpcval(array('Caption' => new xmlrpcval(_t('_E-mail')), 'Type' => new xmlrpcval('text'), 'Value1' => new xmlrpcval($this->_aProfile['Email'])), "struct"); $aOwnInfo[] = new xmlrpcval(array('Caption' => new xmlrpcval(_t('_Membership2')), 'Type' => new xmlrpcval('text'), 'Value1' => new xmlrpcval(strip_tags(GetMembershipStatus($this->_iProfileID, false, false)))), "struct"); $aOwnInfo[] = new xmlrpcval(array('Caption' => new xmlrpcval(_t('_Status')), 'Type' => new xmlrpcval('text'), 'Value1' => new xmlrpcval(_t('__' . $this->_aProfile['Status']))), "struct"); $aRet[] = new xmlrpcval(array('Info' => new xmlrpcval($aOwnInfo, "array"), 'Title' => new xmlrpcval(_t('_Account Info'))), "struct"); } return new xmlrpcval($aRet, "array"); }
function getContacts($sUser, $sPwd) { $aRet = array(); if (!($iId = BxDolXMLRPCUtil::checkLogin($sUser, $sPwd))) { return new xmlrpcresp(new xmlrpcval(array('error' => new xmlrpcval(1, "int")), "struct")); } $aAll = array(); $aContacts = array(); // hot list $r = db_res("SELECT `p`.`ID` FROM `Profiles` AS `p`\n INNER JOIN `sys_fave_list` AS `h` ON (`h`.`Profile` = `p`.`ID`)\n WHERE `h`.`ID` = {$iId}"); while ($aRow = $r->fetch()) { $aAll[$aRow['ID']] = $aRow; } // mail contacts received $r = db_res("SELECT `p`.`ID` FROM `Profiles` AS `p`\n INNER JOIN `sys_messages` AS `m` ON (`m`.`Sender` = `p`.`ID`)\n WHERE `p`.`ID` != {$iId} AND `m`.`Recipient` = {$iId}"); while ($aRow = $r->fetch()) { $aAll[$aRow['ID']] = $aRow; } // mail contacts sent $r = db_res("SELECT `p`.`ID` FROM `Profiles` AS `p`\n INNER JOIN `sys_messages` AS `m` ON (`m`.`Recipient` = `p`.`ID`)\n WHERE `p`.`ID` != {$iId} AND `m`.`Sender` = {$iId}"); while ($aRow = $r->fetch()) { $aAll[$aRow['ID']] = $aRow; } // friends 1 $r = db_res("SELECT `p`.`ID` FROM `sys_friend_list` AS `fr`\n LEFT JOIN `Profiles` AS `p` ON (`p`.`ID` = `fr`.`Profile`)\n WHERE `fr`.`ID` = '{$iId}' AND `fr`.`Profile` != {$iId} AND `fr`.`Check` = '1'"); while ($aRow = $r->fetch()) { $aAll[$aRow['ID']] = $aRow; } // friends 2 $r = db_res("SELECT `p`.`ID` FROM `sys_friend_list` AS `fr`\n LEFT JOIN `Profiles` AS `p` ON (`p`.`ID` = `fr`.`ID`)\n WHERE `fr`.`Profile` = '{$iId}' AND `fr`.`ID` != {$iId} AND `fr`.`Check` = '1'"); while ($aRow = $r->fetch()) { $aAll[$aRow['ID']] = $aRow; } bx_import('BxDolAlerts'); $oZ = new BxDolAlerts('mobile', 'contacts', $iId, 0, array('contacts_data' => $aAll)); $oZ->alert(); foreach ($aAll as $aRow) { $a = array('ID' => new xmlrpcval($aRow['ID']), 'Nick' => new xmlrpcval(getUsername($aRow['ID'])), 'UserTitle' => new xmlrpcval(getNickName($aRow['ID']))); $aContacts[] = new xmlrpcval($a, 'struct'); } return new xmlrpcval($aContacts, "array"); }
/** * page code function */ function PageCompPageMainCode() { global $tmpl; $links_res = db_res("SELECT * FROM `Links`"); if (!mysql_num_rows($links_res)) { $out .= "<div class=\"no_links\">" . _t("_NO_LINKS") . "</div>\n"; } else { while ($link_arr = mysql_fetch_array($links_res)) { $link_url = process_line_output($link_arr['URL'], 1000); $link_title = process_line_output($link_arr['Title']); $link_desc = process_text_output($link_arr['Description']); $out .= "<div class=\"links_cont\">\n"; $out .= "<div class=\"clear_both\"></div>\n"; $out .= "<div class=\"links_header\">"; $out .= "<a href=\"{$link_url}\">{$link_title}</a></div>\n"; $out .= "<div class=\"links_snippet\">{$link_desc}</div>\n"; $out .= "<div class=\"clear_both\"></div></div>\n"; } } return $out; }
function _getMessages($sUser, $sPwd, $isInbox) { $aRet = array(); if (!($iId = BxDolXMLRPCUtil::checkLogin($sUser, $sPwd))) { return new xmlrpcresp(new xmlrpcval(array('error' => new xmlrpcval(1, "int")), "struct")); } $aMsgs = array(); if ($isInbox) { $sWhere = "`Recipient` = '{$iId}' AND NOT FIND_IN_SET('recipient', `Trash`)"; } else { $sWhere = "`Sender` = '{$iId}' AND NOT FIND_IN_SET('sender', `Trash`)"; } $sFieldsAdd = $isInbox ? ", `m`.`Sender` AS `AuthorID`" : ", `m`.`Recipient` AS `AuthorID` "; $r = db_res("SELECT\n `m`.`ID`, UNIX_TIMESTAMP(`m`.`Date`) AS `Date`, `m`.`Sender`, `m`.`Recipient`, `m`.`Subject`, `m`.`New` {$sFieldsAdd}\n FROM `sys_messages` AS `m`\n INNER JOIN `Profiles` as `p` ON (`p`.`ID` = `m`.`Sender`)\n WHERE {$sWhere}\n ORDER BY `Date` DESC"); while ($aRow = $r->fetch()) { $sIcon = BxDolXMLRPCUtil::getThumbLink($isInbox ? $aRow['Sender'] : $aRow['Recipient'], 'thumb'); $aMsg = array('ID' => new xmlrpcval($aRow['ID']), 'Date' => new xmlrpcval(defineTimeInterval($aRow['Date'])), 'Sender' => new xmlrpcval($aRow['Sender']), 'Recipient' => new xmlrpcval($aRow['Recipient']), 'Subject' => new xmlrpcval($aRow['Subject']), 'New' => new xmlrpcval($aRow['New']), 'Nick' => new xmlrpcval(getUsername($aRow['AuthorID'])), 'UserTitleInterlocutor' => new xmlrpcval(getNickName($aRow['AuthorID'])), 'Thumb' => new xmlrpcval($sIcon)); $aMsgs[] = new xmlrpcval($aMsg, 'struct'); } return new xmlrpcval($aMsgs, "array"); }
function getFriendList($id) { global $site; global $max_thumb_width; global $max_thumb_height; $id = (int) $id; $friend_list_query = "SELECT `Profiles`.* FROM `FriendList`\r\n\t\t\t\t\t\t\t\t LEFT JOIN `Profiles` ON (`Profiles`.`ID` = `FriendList`.`Profile` AND `FriendList`.`ID` = '{$id}' OR `Profiles`.`ID` = `FriendList`.`ID` AND `FriendList`.`Profile` = '{$id}')\r\n\t\t\t\t\t\t\t\t WHERE (`FriendList`.`Profile` = '{$id}' OR `FriendList`.`ID` = '{$id}') AND `FriendList`.`Check` = '1' ORDER BY `Profiles`.`Picture` DESC"; $friend_list_res = db_res("{$friend_list_query}"); $iCounter = 0; while ($friend_list_arr = mysql_fetch_assoc($friend_list_res)) { $iCounter++; $sKey = '1'; if ($iCounter == 3) { $sKey = '1'; } $ret .= '<div class="friends_thumb_' . $sKey . '">' . get_member_thumbnail($friend_list_arr['ID'], 'none') . '<div class="browse_nick"><a href="' . getProfileLink($friend_list_arr['ID']) . '">' . $friend_list_arr['NickName'] . '</a></div><div class="clear_both"></div></div>'; if ($iCounter == 3) { $iCounter = 0; } } return $ret; }
/** * page code function */ function PageCompPageMainCode() { global $site; global $short_date_format; $out = ""; $query = "SELECT `Stories`.`ID`, `Profiles`.`ID` as `MembID`, DATE_FORMAT(`Stories`.`Date`, '{$short_date_format}' ) AS 'Date', `Stories`.`Header`, `Stories`.`Text`, `Profiles`.`ID` as `prID`, `Profiles`.`NickName` FROM `Stories` INNER JOIN `Profiles` ON (`Stories`.`Sender` = `Profiles`.`ID`) WHERE `Stories`.`active` = 'on' ORDER BY `Stories`.`Date` DESC"; $res = db_res($query); if (!$res) { return 0; } $out .= "\n\t\t<br />\n\t\t<div align=left> <a href=\"" . $site['url'] . "story.php\">" . _t("_post my feedback") . "</a></div>\n\t\t<br />\n\t\t<table width=\"100%\" cellspacing=1 cellpadding=2 class=small width=100%>"; $num = mysql_num_rows($res); if (!$num) { $out .= "\n\t\t\t\t<tr>\n\t\t\t\t\t<td><center>" . _t("_NO_STORIES") . "</center></td>\n\t\t\t\t</tr>"; } else { while ($arr = mysql_fetch_array($res)) { $story_header = process_line_output($arr['Header']); $out .= "\n\t\t\t\t<tr class=panel>\n\t\t\t\t\t<td align=center width=15%>{$arr['Date']}</td>\n\t\t\t\t\t<td align=center width=15%><a href=\"" . getProfileLink($arr['prID']) . "\">{$arr['NickName']}</a></td>\n\t\t\t\t\t<td aling=left> <a href='story_view.php?ID={$arr['ID']}'>{$story_header}</a></td>\n\t\t\t\t</tr>"; } } $out .= "\n\t\t</table>\n"; return $out; }
function PageListFriend($sourceID, $targetID) { $ret = ''; $query = "SELECT * FROM `FriendList` WHERE (`ID` = '{$sourceID}' and `Profile` = '{$targetID}') or ( `ID` = '{$targetID}' and `Profile` = '{$sourceID}')"; $temp = db_assoc_arr($query); if ($sourceID == $temp['ID'] || $temp['Check'] == 1) { $ret = _t_action('_already_in_friend_list'); } elseif ($targetID == $temp['ID'] && 0 == $temp['Check']) { $query = "UPDATE `FriendList` SET `Check` = '1' WHERE `ID` = '{$targetID}' AND `Profile` = '{$sourceID}';"; if (db_res($query)) { $ret = _t_action('_User was added to friend list'); } else { $ret = _t_err('_Failed to apply changes'); } } else { $query = "INSERT INTO `FriendList` SET `ID` = '{$sourceID}', `Profile` = '{$targetID}', `Check` = '0';"; if (db_res($query)) { $ret = _t_action('_User was invited to friend list'); } else { $ret = _t_err('_Failed to apply changes'); } } return $ret; }
function getExistedBannersBlock() { $sClicksC = _t('_adm_bann_clicks'); $sImpressionsC = _t('_adm_bann_impressions'); $sPreviewC = _t('_Preview'); $sEditC = _t('_Edit'); $sDeleteC = _t('_Delete'); // Get banner info from database. $banners_res = db_res("SELECT * FROM `sys_banners` ORDER BY `ID` DESC"); $sExistedBanners = MsgBox(_t('_Empty')); if (mysql_num_rows($banners_res)) { $sExistedBanners = "<table cellspacing=1 cellpadding=2 border=0 class=small1 width=100%>"; while ($banns_arr = mysql_fetch_array($banners_res)) { $imp = db_arr("SELECT COUNT(*) FROM `sys_banners_shows` WHERE `ID` = '{$banns_arr['ID']}'"); $clicks = db_arr("SELECT COUNT(*) FROM `sys_banners_clicks` WHERE `ID` = '{$banns_arr['ID']}'"); $class = !$banns_arr['Active'] ? 'table_err' : 'panel'; $sBannerTitle = process_line_output($banns_arr['Title']); $sExistedBanners .= <<<EOF <tr class={$class}> \t<td> \t\t(<a href="banners.php?action=preview&banner_id={$banns_arr['ID']}">{$sPreviewC}</a> | \t\t\t<a href="banners.php?banner_id={$banns_arr['ID']}">{$sEditC}</a> | \t\t\t<a href="banners.php?banner_id={$banns_arr['ID']}&action=delete">{$sDeleteC}</a>) \t\t\t{$sBannerTitle} \t\t</a> \t</td> \t<td><b>{$clicks[0]}</b> {$sClicksC} </td> \t<td><b>{$imp[0]}</b> {$sImpressionsC} </td> </tr> EOF; } $sExistedBanners .= "</table>"; } $sResult = $GLOBALS['oAdmTemplate']->parseHtmlByName('design_box_content.html', array('content' => $sExistedBanners)); return DesignBoxContent(_t('_adm_mmi_banners'), $sResult, 1); }