function viewSpamSayMember($sResult = "") { $TMess = array(); $str = "select messages.*,messages.Status as MessageStatus,mSender.Username as Username_sender,mReceiver.Username as Username_receiver from messages,members as mSender,members as mReceiver where mSender.id=IdSender and messages.SpamInfo='SpamSayMember' and mReceiver.id=IdReceiver and (mSender.Status='Active' or mSender.Status='Pending') order by messages.id desc limit 50"; if (GetStrParam("IdSender", "") != "") { $str = "select messages.*,messages.Status as MessageStatus,mSender.Username as Username_sender,mReceiver.Username as Username_receiver from messages,members as mSender,members as mReceiver where mSender.id=IdSender and mReceiver.id=IdReceiver and (mSender.Status='Active' or mSender.Status='Pending') and messages.SpamInfo='SpamSayMember' and messages.IdSender=" . IdMember(GetStrParam("IdSender", 0)) . " order by messages.id desc limit 20"; } if (GetStrParam("IdReceiver", "") != "") { $str = "select messages.*,messages.Status as MessageStatus,mSender.Username as Username_sender,mReceiver.Username as Username_receiver from messages,members as mSender,members as mReceiver where mSender.id=IdSender and mReceiver.id=IdReceiver and (mSender.Status='Active' or mSender.Status='Pending') and messages.SpamInfo='SpamSayMember' and messages.IdReceiver" . IdMember(GetStrParam("IdReceiver", 0)) . " order by messages.id desc limit 20"; } // echo "str=$str<br>" ; $qry = sql_query($str); while ($rr = mysql_fetch_object($qry)) { array_push($TMess, $rr); } DisplayMessages($TMess, $sResult, GetStrParam("IdSender", "")); // call the layout exit(0); // exit after the layout has been called }
private function LinkWithPicture($Username, $ParamPhoto = "", $Status = "") { $words = new MOD_words(); $Photo = $ParamPhoto; if ($Photo == "") { $query = $this->dao->query("\nSELECT SQL_CACHE\n *\nFROM\n members\nWHERE\n id = " . IdMember($Username)) . "\n "; $rr = $query->fetch(PDB::FETCH_OBJ); $Photo = $this->DummyPict($rr->Gender, $rr->HideGender); } $thumb = $this->getthumb($Photo, 100, 100); if ($thumb === null) { $thumb = ""; } if ($Status == 'map_style') { return "<a href=\"javascript:newWindow('{$Username}')\" title=\"" . $words->getBuffered("SeeProfileOf", $Username) . "\"><img class=\"framed\" style=\"float: left; margin: 4px\" src=\"" . $this->bwlink($thumb) . "\" height=\"50px\" width=\"50px\" alt=\"Profile\" /></a>"; } return "<a href=\"" . $this->bwlink("bw/member.php?cid={$Username}") . "\" title=\"" . $words->getBuffered("SeeProfileOf", $Username) . "\"><img class=\"framed\" src=\"" . $this->bwlink($thumb) . "\" height=\"50px\" width=\"50px\" alt=\"Profile\" /></a>"; }
write to the Free Software Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA. */ chdir(".."); require_once "lib/init.php"; require_once "layout/error.php"; require_once "layout/adminlogs.php"; $RightLevel = HasRight('Logs'); // Check the rights if ($RightLevel < 1) { echo "This Need the sufficient <b>Logs</b> rights<br />"; exit(0); } $where = ''; $username = GetParam("Username", "0"); $cid = IdMember($username); if ($cid != 0) { $where .= " AND IdMember=" . $cid; } if (HasRight('Logs', 'OwnLogsRestriction') and !HasRight('Logs', '"All"')) { $cid = $_SESSION["IdMember"]; // Member with scope OwnLogsRestriction can only see his own rights $username = fUsername($cid); } $limitcount = GetParam("limitcount", 100); // Number of records per page $start_rec = GetParam("start_rec", 0); // Number of records per page $andS1 = GetStrParam("andS1", ""); if ($andS1 != "") { $where .= " AND Str LIKE '%" . $andS1 . "%'";
$IdMember = $_SESSION['IdMember']; if (IsAdmin()) { // admin can alter other profiles $IdMember = GetParam("cid", $_SESSION['IdMember']); } $m = prepareProfileHeader($IdMember, "", 0); // This is the profile of the contact which is going to be used switch (GetParam("action")) { case "del": $str = "delete from intermembertranslations where IdTranslator=" . GetParam("IdTranslator") . " and IdMember=" . $IdMember; sql_query($str); LogStr("Removing translator <b>" . fUserName(GetParam("IdTranslator")) . "</b>", "mytranslators"); break; case "add": // todo $IdTranslator = IdMember(GetParam("Username"), 0); $IdLanguage = Getparam("IdLanguage"); $rr = LoadRow("select id from intermembertranslations where IdTranslator=" . $IdTranslator . " and IdMember=" . $IdMember . " and IdLanguage=" . $IdLanguage); if (!isset($rr->id) and $IdTranslator != 0) { // if not allready exists $str = "insert into intermembertranslations(IdTranslator,IdMember,IdLanguage) values(" . $IdTranslator . "," . $IdMember . "," . $IdLanguage . ")"; sql_query($str); LogStr("Adding translator <b>" . fUserName(GetParam("IdTranslator")) . "</b> for language", "mytranslators"); } break; } $TData = array(); $str = "select intermembertranslations.*,members.Username,members.ProfileSummary,cities.Name as cityname,regions.Name as regionname,countries.Name as countryname,membersphotos.FilePath as photo,membersphotos.Comment"; $str .= " from intermembertranslations,cities,countries,regions,recentvisits,members left join membersphotos on membersphotos.IdMember=members.id and membersphotos.SortOrder=0 where cities.IdRegion=regions.id and countries.id=cities.IdCountry and cities.id=members.IdCity and status='Active' and members.id=intermembertranslations.IdTranslator and intermembertranslations.IdMember=" . $IdMember . " and members.status='Active' GROUP BY members.id order by intermembertranslations.updated desc"; $qry = sql_query($str); while ($rr = mysql_fetch_object($qry)) {
case "AdminAbuser": $Message = "Abusive Comments"; $count = getcount("AdminAbuserMustCheck", $RestrictToIdMember); // call the layout DisplayAdminComments(loaddata("AdminAbuserMustCheck", $RestrictToIdMember, $page, $comments_per_page), $Message, $page, $comments_per_page, $count, "AdminAbuserMustCheck"); exit(0); break; case "All": $Message = "All Comments "; $count = getcount("", $RestrictToIdMember); // call the layout DisplayAdminComments(loaddata("", $RestrictToIdMember, $page, $comments_per_page), $Message, $page, $comments_per_page, $count); exit(0); break; case "ShowOneMember": $RestrictToIdMember = IdMember(GetParam("cid", 0)); break; case "HideAction": $Message = "Toggle hide for general public"; toggleAction('DisplayInPublic', 0); break; case "UnhideAction": $Message = "Toggle hide for general public"; toggleAction('DisplayInPublic', 1); break; case "DefaultEditAction": $Message = "Toggle whether creator may edit post"; toggleAction('AllowEdit', 0); break; case "AllowEditAction": $Message = "Toggle whether creator may edit post";
function IsPublic($IdMember = 0) { $rr = LoadRow("select SQL_CACHE * from memberspublicprofiles where memberspublicprofiles.IdMember=" . IdMember($IdMember)); if (isset($rr->id)) { return true; } else { return false; } }