Parašė Vaidotas-· 2008 Vas. 19 15:02:51
#1
Sveiki, turiu tokią bėdą. man reikia padaryt tokį nedidelį dalyką: aš savo puslapyje naudoju Point_system modifikaciją, ir noriu, kad narių profile faile rodytų kiek narys turi surinkęs
taškų pabrrėžiu tik taškų, todėl norėjau paklaust, kokį kodą ir į kur reikia įdėt į profile.php failą, kad būtų matomi taškai nario profily! Štai kodai:
<?
/*--------------------------------------------+
| PHP-Fusion 5 - Content Management System |
|---------------------------------------------|
| author: Nick Jones (Digitanium) © 2002-2005 |
| web: http://www.php-fusion.co.uk |
| email: nick@php-fusion.co.uk |
|---------------------------------------------|
| Released under the terms and conditions of |
| the GNU General Public License (Version 2) |
+--------------------------------------------*/
@require_once "../../config.php";
require_once "../../maincore.php";
require_once "../../subheader.php";
require_once "../../side_left.php";
@include "locale/".$settings['locale'].".php";
@include "locale/German.php";
if (iMEMBER) {
$row = dbquery("SELECT * FROM ".$db_prefix."points WHERE id='1'");
$points=dbarray($row);
$points_thread = $points['points'];
$row2 = dbquery("SELECT * FROM ".$db_prefix."points WHERE id='2'");
$points2=dbarray($row2);
$points_post = $points2['points'];
$row3 = dbquery("SELECT * FROM ".$db_prefix."points WHERE id='3'");
$points3=dbarray($row3);
$points_link = $points3['points'];
$row4 = dbquery("SELECT * FROM ".$db_prefix."points WHERE id='4'");
$points4=dbarray($row4);
$points_article = $points4['points'];
$row5 = dbquery("SELECT * FROM ".$db_prefix."points WHERE id='5'");
$points5=dbarray($row5);
$points_news = $points5['points'];
$row9 = dbquery("SELECT * FROM ".$db_prefix."points WHERE id='9'");
$points9=dbarray($row9);
$points_shoutbox = $points9['points'];
$row10 = dbquery("SELECT * FROM ".$db_prefix."points WHERE id='10'");
$points10=dbarray($row10);
$points_kommentare = $points10['points'];
$row12 = dbquery("SELECT * FROM ".$db_prefix."points WHERE id='12'");
$name12=dbarray($row12);
$name_name = $name12['name'];
$row1 = dbquery("SELECT * FROM ".$db_prefix."points WHERE id='1'");
$status1=dbarray($row1);
$status1 = $status1['status'];
$row2 = dbquery("SELECT * FROM ".$db_prefix."points WHERE id='2'");
$status2=dbarray($row2);
$status2 = $status2['status'];
$row3 = dbquery("SELECT * FROM ".$db_prefix."points WHERE id='3'");
$status3=dbarray($row3);
$status3 = $status9['status'];
$row4 = dbquery("SELECT * FROM ".$db_prefix."points WHERE id='4'");
$status4=dbarray($row4);
$status4 = $status4['status'];
$row5 = dbquery("SELECT * FROM ".$db_prefix."points WHERE id='5'");
$status5=dbarray($row5);
$status5 = $status5['status'];
$row9 = dbquery("SELECT * FROM ".$db_prefix."points WHERE id='9'");
$status9=dbarray($row9);
$status9 = $status9['status'];
$row10 = dbquery("SELECT * FROM ".$db_prefix."points WHERE id='10'");
$status10 =dbarray($row10);
$status10 = $status10['status'];
$row11 = dbquery("SELECT * FROM ".$db_prefix."points WHERE id='11'");
$status11 =dbarray($row11);
$status11 = $status11['status'];
$row= dbquery("SELECT * FROM ".$db_prefix."points_user WHERE user_id='".$userdata['user_id']."'");
$reward=dbarray($row);
$reward = $reward['points_rew'];
$row= dbquery("SELECT * FROM ".$db_prefix."points_user WHERE user_id='".$userdata['user_id']."'");
$strafe =dbarray($row);
$strafe = $strafe ['points_str'];
$row= dbquery("SELECT * FROM ".$db_prefix."points_user WHERE user_id='".$userdata['user_id']."'");
$extra=dbarray($row);
$extra= $extra['points_ext'];
$row= dbquery("SELECT * FROM ".$db_prefix."points_user WHERE user_id='".$userdata['user_id']."'");
$ausgabe=dbarray($row);
$ausgabe= $ausgabe['points_aus'];
$shoutboxzahl =dbcount("(shout_id)", "shoutbox", "shout_name='".$userdata['user_id']."'");
$articlezahl =dbcount("(article_id)", "articles", "article_name='".$userdata['user_id']."'");
$newszahl =dbcount("(news_id)", "news", "news_name='".$userdata['user_id']."'");
$kommentarezahl =dbcount("(comment_id)", "comments", "comment_name='".$userdata['user_id']."'");
$threadzahl =dbcount("(forum_id)", "threads", "thread_author='".$userdata['user_id']."'");
$postzahl = dbcount("(post_id)", "posts", "post_author='".$userdata['user_id']."'");
if($status5== 1){
$newsall="$newszahl "*" $points_news ";
}
if($status9== 1){
$shoutboxall="$shoutboxzahl "*" $points_shoutbox ";
}
if($status4== 1){
$articleall="$articlezahl "*" $points_article";
}
if($status10== 1){
$kommentarall="$kommentarezahl "*" $points_kommentare ";
}
if($status1== 1){
$threadall=" $threadzahl "*" $points_thread ";
}
if($status2== 1){
$postall="$postzahl "*" $points_post ";
}
if($status11== 1){
$reward2="$reward";
}
opentable("".PS_000."");
echo"<table align='center' width='408' cellspacing='0' cellpadding='0' class='tbl'>
<tr>
<td width='50%' align='left' class='tbl2'><b>".PS_012."</b></td>
<td width='50%' align='lefr' class='tbl2'><b>$name_name</b></td>
</tr>\n";
if($status9 == 1){
echo "<tr><td class='tbl'>".PS_001."</td><td class='tbl' colspan='2'>";
echo dbcount("(shout_id)", "shoutbox", "shout_name='".$userdata['user_id']."'")."".PS_007." $points_shoutbox = $shoutboxall </td></tr> ";
}
if($status4 == 1){
echo "<tr>\n<td class='tbl'>".PS_002."</td>\n<td class='tbl' colspan='2'>\n";
echo dbcount("(article_id)", "articles", "article_name='".$userdata['user_id']."'")."".PS_007." $points_article = $articleall </td></tr> ";
}
if($status5 == 1){
echo "<tr>\n<td class='tbl'>".PS_009."</td>\n<td class='tbl' colspan='2'>\n";
echo dbcount("(news_id)", "news", "news_name='".$userdata['user_id']."'")."".PS_007. "$points_news = $newsall </td></tr> ";
}
if($status10 == 1){
echo "<tr>\n<td class='tbl'>".PS_004."</td>\n<td class='tbl' colspan='2'>\n";
echo dbcount("(comment_id)", "comments", "comment_name='".$userdata['user_id']."'")." ".PS_007. "$points_kommentare = $kommentarall</td></tr> ";
}
if($status1 == 1){
echo "<tr>\n<td class='tbl'>".PS_011."</td>\n<td class='tbl' colspan='2'>\n";
echo dbcount("(forum_id)", "threads", "thread_author='".$userdata['user_id']."'")." ".PS_007. "$points_thread = $threadall </td></tr> ";
}
if($status2== 1){
echo "<tr>\n<td class='tbl'>".PS_003."</td>\n<td class='tbl' colspan='2'>\n";
echo dbcount("(post_id)", "posts", "post_author='".$userdata['user_id']."'")." ".PS_007. "$points_post = $postall </td></tr> ";
}
if($status11== 1){
echo "<tr>\n<td class='tbl'>".PS_018."</td>\n<td class='tbl' colspan='2'>\n"; echo "$reward </td></tr> ";
}
$gesamtzahl = "$shoutboxall "+" $articleall "+" $newsall "+" $kommentarall "+" $postall "+" $threadall "+" $reward2 ";
$guthaben = "$shoutboxall "+" $articleall "+" $newsall "+" $kommentarall "+" $postall "+" $threadall "+" $reward2 "+" $extra "-" $ausgabe "-" $strafe";
echo "<tr><td class='tbl' colspan='2'><hr>\n</td></tr> ";
echo "<tr>\n<td class='tbl'>\n \n".PS_008." </td><td class='tbl' colspan='2'>$gesamtzahl</td></tr> ";
echo "<tr><td class='tbl' colspan='2'><hr>\n</td></tr> ";
echo "<tr>\n<td class='tbl'>\n \n".PS_013."$name_name:</td> <td class='tbl' colspan='2'>$extra\n</td></tr> ";
echo "<tr>\n<td class='tbl'>\n \n".PS_014." </td><td class='tbl' style='color: #FF0000' colspan='2'>$ausgabe\n</td></tr> ";
echo "<tr>\n<td class='tbl'>\n \n".PS_015." </td><td class='tbl' style='color: #FF0000' colspan='2'>$strafe\n</td></tr> ";
echo "<tr><td class='tbl' colspan='2'><hr>\n</td></tr> ";
echo "<tr><td class='tbl' colspan='2'><hr>\n</td></tr> ";
$row= dbquery("SELECT * FROM ".$db_prefix."points_user WHERE user_id='".$userdata['user_id']."'");
$guthabendb=dbarray($row);
$guthabendb = $guthabendb['points_ges'];
if( $guthaben <= -1)
{
echo "<tr>\n<td class='tbl'>\n \n".PS_016." </td><td class='tbl' style='color: #FF0000' colspan='2'>$guthabendb\n</td></tr> ";
}
else{
echo "<tr>\n<td class='tbl'>\n \n".PS_016." </td><td class='tbl' colspan='2'>$guthabendb\n</td></tr> ";
}
echo "<tr><td class='tbl' colspan='2'><hr>\n</td></tr> ";
echo "</table>\n";
closetable();
echo "<br>";
opentable("".PS_020."");
echo "<form name='strpoints' method='post' action='".$PHP_SELF."'>
<table align='center' width='100%' cellspacing='0' cellpadding='0' class='tbl'>
";
$row= dbquery("SELECT * FROM ".$db_prefix."points_user WHERE user_id='".$userdata['user_id']."'");
$user_id=dbarray($row);
$user_id = $user_id['user_id'];
$row= dbquery("SELECT * FROM ".$db_prefix."points_user WHERE user_id='".$userdata['user_id']."'");
$user_name=dbarray($row);
$user_name = $user_name['user_name'];
if( $user_id == $userdata['user_id']){
if (isset($_POST['update'])) {
dbquery("SELECT * FROM ".$db_prefix."points_user WHERE user_id='".$userdata['user_id']."'");
$result = dbquery("UPDATE ".$db_prefix."points_user SET points_ges='$guthaben', user_name='".$userdata['user_name']."' WHERE user_id='".$userdata['user_id']."'");
echo"<p><font color='#FF0000'><b>".PS_021."</b></font></p>";
}
echo"
<tr><br>
<td align='center' colspan='2'>".PS_024."</td></tr><tr>
<td align='center' colspan='2'><input type='submit' name='update' value='".PS_020."' class='button'></td>
</tr>
</table>
</form>
";}
else{
if (isset($_POST['update'])) {
dbquery("SELECT * FROM ".$db_prefix."points_user ");
$result = dbquery("INSERT INTO ".$db_prefix."points_user (user_id,user_name) VALUES ('".$userdata['user_id']."','".$userdata['user_name']."') ");
echo"<p><font color='#FF0000'><b>".PS_022."</b></font></p>";
}
echo"
<tr><br>
<td align='center' colspan='2'>".PS_025."</td></tr><tr>
<td align='center' colspan='2'><input type='submit' name='update' value='".PS_023."' class='button'></td>
</tr>
</table>
</form>";
}
echo"<br>";
closetable();
}
else{
require_once "member.php";
}
require_once "../../side_right.php";
require_once "../../footer.php";
?>
Profile.php
<?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";
if (!isset($group_id)) {
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['420']);
echo "<center><a href='".FUSION_SELF."?lookup=$lookup&view=last_comments'>|Paskutiniai komentarai</a> | <a href='".FUSION_SELF."?lookup=$lookup&view=last_posts'>Paskutinės žinutės forume</a>|\n";
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>".$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";
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>".$locale['u009']."</b></td>
<td class='tbl1'>".($data['user_location'] ? $data['user_location'] : $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>".$locale['u021']."</b></td>
<td class='tbl1'>".($data['user_aim'] ? $data['user_aim'] : $locale['u048'])."</td>
</tr>
<tr>
<td width='1%' class='tbl2' style='white-space:nowrap'><b>".$locale['u011']."</b></td>
<td class='tbl2'>".($data['user_icq'] ? $data['user_icq'] : $locale['u048'])."</td>
</tr>
<tr>
<td width='1%' class='tbl1' style='white-space:nowrap'><b>".$locale['u012']."</b></td>
<td class='tbl1'>".($data['user_msn'] ? $data['user_msn'] : $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>".$locale['u013']."</b></td>
<td class='tbl2'>".($data['user_yahoo'] ? $data['user_yahoo'] : $locale['u048'])."</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>".$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>
<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>\n";
$c = dbcount("(comment_id)","comments","comment_name = '".$data['user_id']."'");
$pvid = $data['user_posts'] != 0 ? round($data['user_posts']/((time()-$data['user_joined'])/86400),2) : 0;
$cvid = $c != 0 ? round($c/((time()-$data['user_joined'])/86400),2) : 0;
echo "<tr>
<td width='1%' class='tbl1' style='white-space:nowrap'><b>Žinučių per parą forume:</b></td>
<td class='tbl1'>".($pvid > $data['user_posts'] ? $data['user_posts'] : $pvid)."</td>
</tr>
<tr>
<td width='1%' class='tbl1' style='white-space:nowrap'><b>Komentarų per parą:</b></td>
<td class='tbl1'>".($cvid > $c ? $c : $cvid)."</td>
</tr>
<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";
}
closetable();
} else {
if (isset($group_id)) {
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");
}
}
}
if (isset($_GET['view'])) {
$view = $_GET['view'];
if ($view == "last_comments") {
opentable("Paskutiniai komentarai");
$result = dbquery("SELECT * FROM ".$db_prefix."comments WHERE comment_name = '".$data['user_id']."' ORDER BY comment_datestamp DESC LIMIT 0,10");
if (dbrows($result)) {
while ($datac = dbarray($result)) {
if ($datac['comment_type'] == "U") {
$place = BASEDIR."profile.php?lookup=".$datac['comment_item_id'];
} elseif ($datac['comment_type'] == "N") {
$place = BASEDIR."news.php?readmore=".$datac['comment_item_id'];
} elseif ($datac['comment_type'] == "A") {
$place = BASEDIR."readarticle.php?article_id=".$datac['comment_item_id'];
} elseif ($datac['comment_type'] == "P") {
$place = BASEDIR."photogallery.php?photo_id=".$datac['comment_item_id'];
}
echo "<table width='100%' style='border:1px solid #000;'>
<tr>
<td><img src='".THEME."images/bullet.gif'> ".ucfirst(showdate("longdate",$datac['comment_datestamp']))." - <a href='$place'>Eiti į komentaro vietą</a>".(iADMIN ? " - <b>IP:</b> ".$datac['comment_ip']."\n" : "")."
</tr>
<tr>
<td>".($datac['comment_smileys'] == 1 ? parseubb(parsesmileys($datac['comment_message'])) : parseubb($datac['comment_message']))."</td>
</tr>
".(iADMIN ? "<tr>
<td><a href='".ADMIN."comments.php$aidlink&step=edit&comment_id=".$datac['comment_id']."&ctype=".$datac['comment_type']."&cid=".$datac['comment_item_id']."'>Taisyti</a> - <a href='".ADMIN."comments.php$aidlink&step=delete&comment_id=".$datac['comment_id']."&ctype=".$datac['comment_type']."&cid=".$datac['comment_item_id']."'>Trinti</a></td>
</tr>" : "")."
</table><br>\n";
}
} else {
echo "<center>Šis vartotojas komentarų dar neparašė</center>\n";
}
closetable();
} elseif ($view == "last_posts") {
$result = dbquery("SELECT * FROM ".$db_prefix."posts WHERE post_author = '".$data['user_id']."' ORDER BY post_datestamp DESC LIMIT 0,5");
opentable("Paskutiniai forumo pranešimai");
if (dbrows($result)) {
while ($pdata = dbarray($result)) {
echo "<table width='100%' style='border:1px solid #000;'>
<tr>
<td><img src='".THEME."images/bullet.gif'> ".ucfirst(showdate("longdate",$pdata['post_datestamp']))." - <a href='".FORUM."viewthread.php?forum_id=".$pdata['forum_id']."&thread_id=".$pdata['thread_id']."&pid=".$pdata['post_id']."#post_".$dpata['post_id']."'>Eiti į žinutės vietą</a>".(iADMIN ? " - <b>IP:</b> ".$pdata['post_ip']."\n" : "")."</td>
</tr>
<tr>
<td>".($pdata['post_smileys'] == 1 ? nl2br(parsesmileys(parseubb($pdata['post_message']))) : nl2br(parseubb($pdata['post_message'])))."</td>
</tr>".(iADMIN ? "<tr>
<td><a href='".FORUM."post.php?action=edit&forum=".$pdata['forum_id']."&thread_id=".$pdata['thread_id']."&post_id=".$pdata['post_id']."'>Taisyti</a></td>
</tr>\n" : "")."</table><br>\n";
}
} else {
echo "<center>Šis vartotojas pranešimų forume dar neparašė</center>\n";
}
closetable();
} elseif ($view == "last_shouts") {
$result = dbquery("SELECT * FROM ".$db_prefix."shoutbox WHERE shout_name = '".$data['user_id']."' ORDER BY shout_datestamp DESC LIMIT 0,10");
}
}
if (isset($_GET['lookup']) && !isset($_GET['view'])) {
include INCLUDES."comments_include.php";
showcomments("U","users","user_id",$_GET['lookup'],FUSION_SELF."?lookup=".$_GET['lookup']);
}
require_once "side_right.php";
require_once "footer.php";
?>
:?