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ëra");
$rdata = dbarray(dbquery("SELECT * FROM ".$db_prefix."user_ratings WHERE rate_subject = '$lookup' ORDER BY rate_date DESC LIMIT 1"));
echo "Vartotojø á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>Ð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("@","@",$data['user_email'])."' title='".str_replace("@","@",$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'>
<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ë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ëgstamiausias þaidë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ð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";
?>
kasis valdo
MJ the Best |
Šimtas metų, matau Šaukykloje nuostalgija. Smagu panaršyt po forumą ir pažiūrėt senas temas 
