Temos pavadinimas: WordPress, Shopify ir PHPFusion programuotojų bendruomenė :: Naujas laukelis profilyje

Parašė Mr NBA· 2008 Rugp. 25 10:08:22
#8
Gal galit padėti profile_Include ir mysql sutvarkysiu man reikia kad padėtumėte su profiliu va mano profile.php aš noriu kad tas laukelis būtųpo warns(įspėjimų sistemos) ir platus kad galėčiau apie narį labai daug ten aprašinėti.

<?php
/*---------------------------------------------------+
| PHP-Fusion 6 Content Management System
+----------------------------------------------------+
| Copyright © 2002 - 2006 Nick Jones
| http://www.php-fusion.co.uk/
+----------------------------------------------------+
| Released under the terms & conditions of v2 of the
| GNU General Public License. For details refer to
| the included gpl.txt file or visit http://gnu.org
+----------------------------------------------------*/
require_once "maincore.php";
require_once "subheader.php";
require_once "side_left.php";
include LOCALE.LOCALESET."members-profile.php";
include LOCALE.LOCALESET."user_fields.php";

   //warns\\
if (file_exists(LOCALE.LOCALESET."warns.php")) {
   include LOCALE.LOCALESET."warns.php";
} else {
   include LOCALE."English/warns.php";
}
$result2=dbquery("SELECT tw.*, tu.user_id,user_name FROM ".$db_prefix."warnings tw
LEFT JOIN ".$db_prefix."users tu ON tw.give_user=tu.user_id WHERE tw.user_id='$lookup' ORDER BY warning_number ASC");
if (dbrows($result2)) {
$warns=dbrows($result2);
} else {$warns='0'; }
//------\\

if (!isset($lookup) || !isNum($lookup)) {
   fallback("index.php");
} else {
   $result = dbquery("SELECT * FROM ".$db_prefix."users WHERE user_id='$lookup'");
   if (dbrows($result)) { $data = dbarray($result); } else { redirect("index.php"); }
}
if (!isset($group_id) && !isset($_GET['view'])) {
   if (isset($_POST['rate'])) {
      if (isNum($_POST['rating']) && !dbcount("(*)","user_ratings","rate_user = '".$userdata['user_id']."' AND rate_subject = '$lookup'") && iMEMBER) {
         $result = dbquery("INSERT INTO ".$db_prefix."user_ratings (rate_user,rate_subject,rate_opt,rate_date,rate_ip) VALUES ('".$userdata['user_id']."','$lookup','".$_POST['rating']."','".time()."','".$_SERVER['REMOTE_ADDR']."');");
         if ($result) redirect(FUSION_SELF."?lookup=$lookup");
      } else {
         fallback("http://www.google.lt/");
      }
   }
   opentable($locale['420']);

   echo "<table align='center' cellpadding='0' cellspacing='1' width='400' class='tbl-border'>
<tr>
<td colspan='3'>
<table align='center' cellpadding='0' cellspacing='0' width='100%'>
<tr>
<td class='tbl2'><b><a href='".BASEDIR."skype.php?id=".$data['user_skype']."'><img src='http://mystatus.skype.com/smallicon/".$data['user_skype']."' alt='".$data['user_skype']."'>".$data['user_name']."</b></td>
<td align='right' class='tbl2'>".getuserlevel($data['user_level'])."</td>
</tr>
</table>
</td>
<tr>

<td align='center' width='150' rowspan='5' class='tbl2'>\n";
//show warns
      if ($data['user_level'] == 101) {
echo "<img src='".IMAGES."warns/$warns.gif' alt='".$locale['warns_04']." $warns ".$locale['warns_05']."' title='".$locale['warns_04']." $warns ".$locale['warns_05']."' border='0' style='padding-bottom:5px;'><br>";

}
//
$v = 0;
   $result = dbquery("SELECT * FROM ".$db_prefix."user_ratings WHERE rate_subject = '$lookup'");
   while ($datax = dbarray($result)) $v = $v+$datax['rate_opt'];
   $res = $v;
   $vert = (dbrows($result) != 0 ? round($res/dbrows($result),2) : "N&#235;ra");
   $rdata = dbarray(dbquery("SELECT * FROM ".$db_prefix."user_ratings WHERE rate_subject = '$lookup' ORDER BY rate_date DESC LIMIT 1"));
   echo "Vartotojø &#225;vertinimas: $vert<br>\n";
   if (iMEMBER) {
      if (!dbcount("(*)","user_ratings","rate_user = '".$userdata['user_id']."' AND rate_subject = '$lookup'")) {
         echo " <form method='post' action='".FUSION_SELF."?lookup=$lookup'>\n<select name='rating' class='textbox'>\n";
         for ($i = 1; $i < 11; $i++) echo "<option value='$i'>$i</option>\n";
         echo "</select> <input name='rate' type='submit' value='Vertinti' class='textbox'>\n</form>\n";
      }
   }

echo ($data['user_avatar'] ? "<img src='".IMAGES."avatars/".$data['user_avatar']."' alt='".$locale['u017']."'>" : $locale['u046'])."</td>
<td width='1%' class='tbl1' style='white-space:nowrap'><b>Vardas:</b></td>
<td class='tbl1'>".($data['user_vardas'] ? $data['user_vardas'] : $locale['u048'])."</td>
</tr>
<tr>
<td width='1%' class='tbl2' style='white-space:nowrap'><b>".$locale['u010']."</b></td>
<td class='tbl2'>";
   if ($data['user_birthdate'] != "0000-00-00") {
      $months = explode("|", $locale['months']);
      $user_birthdate = explode("-", $data['user_birthdate']);
      echo $months[number_format($user_birthdate['1'])]." ".number_format($user_birthdate['2'])." ".$user_birthdate['0'];
   } else {
      echo $locale['u048'];
   }
   echo "</td>
</tr>
<tr>
<td width='1%' class='tbl1' style='white-space:nowrap'><b>Skype:</b></td>
<td class='tbl1'>
".($data['user_skype'] ? "
<a href='skype.php?id=".$data['user_skype']."'>".$data['user_skype']."</a>" : $locale['u048'])."
</td>
</tr>
<tr>
<td width='1%' class='tbl2' style='white-space:nowrap'><b>Rangas:</b></td>
<td class='tbl2'>".ShowRank($data['user_posts'],$data['user_rank'])."</td>
</tr>
<tr>
<td width='1%' class='tbl2' style='white-space:nowrap'><b>&#208;alis:</b></td>
<td class='tbl2'>".($data['user_salis'] ? $data['user_salis'] : $locale['u048'])."</td>
</tr>
<tr>
<td align='center' class='tbl1'>\n";
   if ($data['user_hide_email'] != "1" || iADMIN) {
      echo "[<a href='mailto:".str_replace("@","&#64;",$data['user_email'])."' title='".str_replace("@","&#64;",$data['user_email'])."'>".$locale['u051']."</a>]\n";
   }
   if ($data['user_web']) {
      $urlprefix = !strstr($data['user_web'], "http://") ? "http://" : "";
      echo "[<a href='".$urlprefix.$data['user_web']."' title='".$urlprefix.$data['user_web']."' target='_blank'>".$locale['u052']."</a>]\n";
   }
   if (iMEMBER && $data['user_id'] != $userdata['user_id']) {
      echo "[<a href='messages.php?msg_send=".$data['user_id']."' title='".$locale['u060']."'>".$locale['u053']."</a>]\n";
   }
   echo "</td>
<td width='1%' class='tbl2' style='white-space:nowrap'><b>Miestas:</b></td>
<td class='tbl2'>".($data['user_miestas'] ? $data['user_miestas'] : $locale['u048'])."</td>
</tr>\n";

//warns\\
if (!isset($warn)) {
if (dbrows($result2)) {
echo "<tr>\n
<td colspan='3' class='tbl1'>";
while ($wdata=dbarray($result2)) {
echo "<img src='".IMAGES."warns/".$wdata['warning_number'].".gif' alt='' border='0'>| <a href='profile.php?lookup=".$wdata['user_id']."' class='side'><b>".$wdata['user_name']."</b></a>".($wdata['couse'] ? ": ".$wdata['couse'] : "")."<br>";
}
echo "</td>\n</tr>";
}
} else {
if (checkrights("M")) {
echo "<tr>\n
<td colspan='3' class='tbl1' align='center'>
<form name='submitform' method='post' action='".FUSION_SELF."?lookup=$lookup'>
".$locale['warns_11']." <input type='textbox' class='textbox' name='priezastis'>&nbsp;
<input type='submit' class='button' name='warn' value='".$locale['warns_07']."'>
</form>
</td>";
}
}
//----------\\
echo "</table>\n";

   //warns start
   if (checkrights("M")) {
   //give warn
   if ($_POST['warn']) {
   $warnnumb=$warns+1;
   $priezastis=stripinput($_POST['priezastis']);
   $result = dbquery("INSERT INTO ".$db_prefix."warnings (user_id, warning_number, give_user, couse) VALUES ('$lookup','$warnnumb','".$userdata['user_id']."','$priezastis')");
   if ($warns == "4") { $result=dbquery("UPDATE ".$db_prefix."users SET user_status='1' WHERE user_id='$lookup'"); }
   redirect(FUSION_SELF."?lookup=$lookup");
   }
   //unwarn
   if ($_POST['unwarn']) {
   $result = dbquery("DELETE FROM ".$db_prefix."warnings WHERE warning_number='$warns' AND user_id='$lookup'");
   redirect(FUSION_SELF."?lookup=$lookup");
   }
   //delete user
   if ($_POST['delete']) {
      $result = dbquery("DELETE FROM ".$db_prefix."users WHERE user_id='$lookup'");
      $result = dbquery("DELETE FROM ".$db_prefix."articles WHERE article_name='$lookup'");
      $result = dbquery("DELETE FROM ".$db_prefix."comments WHERE comment_name='$lookup'");
      $result = dbquery("DELETE FROM ".$db_prefix."messages WHERE message_to='$lookup'");
      $result = dbquery("DELETE FROM ".$db_prefix."messages WHERE message_from='$lookup'");
      $result = dbquery("DELETE FROM ".$db_prefix."news WHERE news_name='$lookup'");
      $result = dbquery("DELETE FROM ".$db_prefix."poll_votes WHERE vote_user='$lookup'");
      $result = dbquery("DELETE FROM ".$db_prefix."ratings WHERE rating_user='$lookup'");
      $result = dbquery("DELETE FROM ".$db_prefix."shoutbox WHERE shout_name='$lookup'");
      $result = dbquery("DELETE FROM ".$db_prefix."threads WHERE thread_author='$lookup'");
      $result = dbquery("DELETE FROM ".$db_prefix."posts WHERE post_author='$lookup'");
      $result = dbquery("DELETE FROM ".$db_prefix."thread_notify WHERE notify_user='$lookup'");
      $result = dbquery("DELETE FROM ".$db_prefix."warnings WHERE user_id='$lookup'");
   redirect("index.php");
   }
   //ban
      if ($_POST['ban']) {
   $result = dbquery("UPDATE ".$db_prefix."users SET user_status=1 WHERE user_id='$lookup'");
   redirect(FUSION_SELF."?lookup=$lookup");
   }
   //unban
         if ($_POST['unban']) {
   $result = dbquery("UPDATE ".$db_prefix."users SET user_status=0 WHERE user_id='$lookup'");
   redirect(FUSION_SELF."?lookup=$lookup");
   }
   //form
   if ($data['user_status'] == 1) { $act = unban; $title = $locale['warns_02']; } else { $act = ban; $title = $locale['warns_01']; }
   tablebreak();
   echo "<table cellpadding='0' cellspadding='0' align='center' width='400' style='border: 1px solid #ccc;'><tr>";

   echo "<td class='tbl1'><form method='post' action='".ADMIN."members.php".$aidlink."&step=edit&user_id=$lookup'><input class='button' value='".$locale['warns_10']."' type='submit' name='edit' title='".$locale['warns_10']."'></form></td>";
   echo "<td class='tbl1'><form method='post' action='".FUSION_SELF."?lookup=$lookup'><input class='button' value='$title' type='submit' name='$act' title='$title ".$locale['warns_09']."'  OnClick=\"if (confirm('".$locale['warns_06']."')) return true; else return false;\"></form></td>";
   echo "<td class='tbl1'><form method='post' action='".FUSION_SELF."?lookup=$lookup'><input class='button' value='".$locale['warns_03']."' type='submit' name='delete' title='".$locale['warns_03']."' OnClick=\"if (confirm('".$locale['warns_06']."')) return true; else return false;\"></form></td>";



         //for admins
      if ($data['user_level'] == 101 && $data['user_status'] != 1) {
echo "<td class='tbl1'><form method='post' action='".FUSION_SELF."?lookup=$lookup&warn'>";
echo "<input type='submit' name='warning' value='".$locale['warns_07']."' class='button'>";
echo "</form></td>";
}
   if ($warns) {
echo "<td class='tbl1'><form method='post' action='".FUSION_SELF."?lookup=$lookup'>";
echo "<input type='submit' name='unwarn' value='".$locale['warns_08']."' class='button'>";
echo "</form></td>";
}


   echo "</tr></table>";
   }

   tablebreak();
   //warnings ends


   tablebreak();
   

 echo "<table align='center' cellpadding='0' cellspacing='1' width='400' class='tbl-border'>
<tr>
<td class='tbl2' colspan='2'><b>".$locale['422']."</b></td>
</tr>
<tr>
<td width='1%' class='tbl1' style='white-space:nowrap'><b>".$locale['u040']."</b></td>
<td class='tbl1'>".showdate("longdate", $data['user_joined'])."</td>
</tr>
<tr>
<td width='1%' class='tbl2' style='white-space:nowrap'><b>".$locale['u044']."</b></td>
<td class='tbl2'>".($data['user_lastvisit'] != 0 ? showdate("longdate", $data['user_lastvisit']) : $locale['u049'])."</td>
</tr>
<tr>
<td width='1%' class='tbl1' style='white-space:nowrap'><b>".$locale['u041']."</b></td>
<td class='tbl1'>".number_format(dbcount("(shout_id)", "shoutbox", "shout_name='".$data['user_id']."'"))."</td>
</tr>
<tr>
<td width='1%' class='tbl2' style='white-space:nowrap'><b>".$locale['u042']."</b></td>
<td class='tbl2'>".number_format(dbcount("(comment_id)", "comments", "comment_name='".$data['user_id']."'"))."</td>
</tr>
<tr>
<td width='1%' class='tbl1' style='white-space:nowrap'><b>".$locale['u043']."</b></td>
<td class='tbl1'>".number_format($data['user_posts'])."</td>
</tr>
</table>\n";
     
   tablebreak();
     
         echo "<table align='center' cellpadding='0' cellspacing='1' width='400' class='tbl-border'>
<tr>
<td class='tbl2' colspan='2'><b>Kita</b></td>
</tr>
<tr>
<td width='1%' class='tbl1' style='white-space:nowrap'><b>M&#235;gstamiausia komanda:</b></td>
<td class='tbl1'>".($data['user_komanda'] ? $data['user_komanda'] : $locale['u048'])."</td>
</tr>
<tr>
<td width='1%' class='tbl2' style='white-space:nowrap'><b>M&#235;gstamiausias &#254;aid&#235;jas:</b></td>
<td class='tbl2'>".($data['user_zaidejas'] ? $data['user_zaidejas'] : $locale['u048'])."</td>
</tr>
<tr>
<td width='1%' class='tbl1' style='white-space:nowrap'><b>Patinkanti konferencija:</b></td>
<td class='tbl1'>".($data['user_konf'] ? $data['user_konf'] : $locale['u048'])."</td>
</tr>
</table>\n";
   if ($data['user_groups']) {
      tablebreak();
      echo "<table align='center' cellpadding='0' cellspacing='1' width='400' class='tbl-border'>\n";
      echo "<tr>\n<td class='tbl2'><b>".$locale['423']."</b></td>\n\n</tr>\n<tr>\n<td class='tbl1'>\n";
      $user_groups = (strpos($data['user_groups'], ".") == 0 ? explode(".", substr($data['user_groups'], 1)) : explode(".", $data['user_groups']));
      for ($i = 0;$i < count($user_groups);$i++) {
         echo "<a href='".FUSION_SELF."?group_id=".$user_groups[$i]."'>".getgroupname($user_groups[$i])."</a>";
         if ($i != (count($user_groups)-1)) { echo ",\n"; } else { echo "\n"; }
      }
      echo "</td>\n</tr>\n</table>\n";
   }
   } else {
   if (!isNum($group_id)) fallback("index.php");
   $result = dbquery("SELECT * FROM ".$db_prefix."user_groups WHERE group_id='$group_id'");
   if (dbrows($result)) {
      $data = dbarray($result);
      $result = dbquery("SELECT * FROM ".$db_prefix."users WHERE user_groups REGEXP('^\\\.{$group_id}$|\\\.{$group_id}\\\.|\\\.{$group_id}$') ORDER BY user_level DESC, user_name");
      opentable($locale['410']);
      echo "<table align='center' cellpadding='0' cellspacing='1' width='100%' class='tbl-border'>
<tr>
<td align='center' colspan='2' class='tbl1'><b>".$data['group_name']."</b> (".sprintf((dbrows($result)==1?$locale['411']:$locale['412']), dbrows($result)).")</td>
</tr>
<tr>
<td class='tbl2'><b>".$locale['401']."</b></td>
<td align='center' width='1%' class='tbl2' style='white-space:nowrap'><b>".$locale['402']."</b></td>
</tr>\n";
      while ($data = dbarray($result)) {
         $cell_color = ($i % 2 == 0 ? "tbl1" : "tbl2"); $i++;
         echo "<tr>\n<td class='$cell_color'>\n<a href='profile.php?lookup=".$data['user_id']."'>".$data['user_name']."</a></td>\n";
         echo "<td align='center' width='1%' class='$cell_color' style='white-space:nowrap'>".getuserlevel($data['user_level'])."</td>\n</tr>";
      }
      echo "</table>\n";
            } else {
   
   
   
      fallback(BASEDIR."index.php");
   }
}
closetable();
   //nario parasas
if ($data['user_sig']) {
opentable("Vartotojo Para&#240;as");
echo "<center>".parseubb(parsesmileys($data['user_sig']))."</center>";
closetable();
}

//nario komentaru rodymas
include INCLUDES."comments_include.php";
   showcomments("U","users","user_id",$lookup,BASEDIR."profile.php?lookup=$lookup");
//

// Administracijos funkcijos profilyje
if (iADMIN && isset($lookup) && $lookup != '') {
include LOCALE.LOCALESET."admin/blacklist.php";
include LOCALE.LOCALESET."admin/members.php";

//if (!isset($lookup) || !isNum($lookup)) fallback("index.php");
$result = dbquery("SELECT * FROM ".$db_prefix."users WHERE user_id='$lookup'");
if (dbrows($result)) { $data = dbarray($result); } //else { redirect("index.php"); }
opentable("".$locale['403']." - ".$data['user_name']."");
$blacklist_id = "ip";

if (iUSER >= $data['user_level'] && $data['user_id'] != 1) {
echo "<a href='".BASEDIR."administration/members.php".$aidlink."&step=edit&user_id=".$data['user_id']."'>".$locale['406']."</a>\n";
if ($data['user_status'] == "2") {
echo "- <a href='".BASEDIR."administration/members.php?step=activate&sortby=$sortby&rowstart=$rowstart&user_id=".$data['user_id']."'>".$locale['412']."</a>\n";
} elseif ($data['user_status'] == "1") {
echo "- <a href='".BASEDIR."administration/members.php".$aidlink."&step=ban&act=off&sortby=$sortby&rowstart=$rowstart&user_id=".$data['user_id']."'>".$locale['407']."</a>\n";
} else {
echo "- <a href='".BASEDIR."administration/members.php".$aidlink."&step=ban&act=on&sortby=$sortby&rowstart=$rowstart&user_id=".$data['user_id']."'>".$locale['408']."</a>\n";
}
echo "- <a href='".BASEDIR."administration/members.php".$aidlink."&step=delete&sortby=$sortby&rowstart=$rowstart&user_id=".$data['user_id']."' onclick='return DeleteMember()'>".$locale['409']."</a>\n";
echo "- <a href='#'>IP:</a>\n";
echo " <strong>".$data['user_ip']."</strong>";
}
closetable();
tablebreak();
}
//Baigiasi Administracija Profilyje

require_once "side_right.php";
require_once "footer.php";
?>