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)) { if ($rr->ProfileSummary > 0) {
function toggleAction($act, $newValue) { $str = "UPDATE comments SET {$act} = {$newValue} WHERE id=" . Getparam("IdComment"); sql_query($str); LogStr(" Toggling <b>hide</b> for IdComment #" . Getparam("IdComment"), "AdminComment"); }