|
v6 Nariu Reitingavimas
|
| RAFFAK |
parašyta 2009-06-26 10:23
|
Pradinukas
Reputacija:
0
Pranešimai: 45
Įstojo: 2008-05-07
|
Pas jus tinklapyje radau Nariu Reitingavima. Noreciau, kad vietoj nariu forumo pranesimu skaiciaus, rodytu pateiktu nuotrauku skaiciu. Reitingavimas atrodo stai taip:
http://img99.imageshack.us/img99/7263/reitingavimas.jpg
O jame esantis kodas taip:
 Code
/*---------------------------------------------------+
| PHP-Fusion 6 Content Management System
+----------------------------------------------------+
| Copyright 2002 - 2005 Nick Jones
| http://www.php-fusion.co.uk/
+----------------------------------------------------+
| By Rolisj
| www.emp3.dar.lt
|
+----------------------------------------------------*/
require_once \"maincore.php\";
require_once \"subheader.php\";
require_once \"side_left.php\";
include LOCALE.LOCALESET.\"members-profile.php\";
opentable(\"Reitingai\");
if (iMEMBER) {
if (!isset($sortby)) $sortby = \"all\";
$orderby = ($sortby == \"all\" ? \"\" : \" WHERE user_name LIKE '\".stripinput($sortby).\"%'\");
$result = dbquery(\"SELECT * FROM \".$db_prefix.\"users\".$orderby.\"\");
$rows = dbrows($result);
if (!isset($rowstart) || !isNum($rowstart)) $rowstart = 0;
if ($rows != 0) {
echo \"
\".$locale['401'].\" |
Prane?im forume: |
Prane?imai ?aukykloje: |
Komentar: |
Reitingavim: |
Data: |
\n\";
$result = dbquery(\"SELECT * FROM \".$db_prefix.\"users\".$orderby.\" ORDER BY user_posts DESC, user_posts LIMIT $rowstart,20\");
while ($data = dbarray($result)) {
echo \"\n| \n\".$data['user_name'].\" | \n\";
echo \"\n\".$data['user_posts'].\" | \";
echo \"\n\".dbcount(\"(shout_id)\", \"shoutbox\", \"shout_name='\".$data['user_id'].\"'\").\" | \n\";
echo \"\n\".dbcount(\"(comment_id)\", \"comments\", \"comment_name='\".$data['user_id'].\"'\").\" | \n\";
echo\"\n\".dbcount(\"(rating_id)\", \"ratings\", \"rating_user='\".$data['user_id'].\"'\").\" | \";
echo \"\n\".($data['user_lastvisit'] != 0 ? showdate(\"shortdate\", $data['user_lastvisit']) : $locale['u049']).\" | \";
}
echo \"\n
\n\";
} else {
echo \"
\n\".$locale['403'].\"$sortby
\n\n\";
}
$search = array(
\"A\",\"B\",\"C\",\"D\",\"E\",\"F\",\"G\",\"H\",\"I\",\"J\",\"K\",\"L\",\"M\",\"N\",\"O\",\"P\",\"Q\",\"R\",
\"S\",\"T\",\"U\",\"V\",\"W\",\"X\",\"Y\",\"Z\",\"0\",\"1\",\"2\",\"3\",\"4\",\"5\",\"6\",\"7\",\"8\",\"9\"
);
echo \"
\n\";
} else {
echo \"
\n\".$locale['002'].\"
\n\n\";
}
closetable();
echo \"\".makePageNav($rowstart,20,$rows,3,FUSION_SELF.\"?sortby=$sortby&\").\"\n \n\";
require_once \"side_right.php\";
require_once \"footer.php\";
?>
|
| |
|
|
| tabux |
parašyta 2009-06-27 11:11
|
S.Administratorius
Reputacija:
0
Pranešimai: 1009
Įstojo: 2008-10-16
|
Code
require_once \"maincore.php\";
require_once \"subheader.php\";
require_once \"side_left.php\";
include LOCALE.LOCALESET.\"members-profile.php\";
opentable(\"Reitingai\");
if (iMEMBER) {
if (!isset($sortby)) $sortby = \"all\";
$orderby = ($sortby == \"all\" ? \"\" : \" WHERE user_name LIKE '\".stripinput($sortby).\"%'\");
$result = dbquery(\"SELECT * FROM \".$db_prefix.\"users\".$orderby.\"\");
$rows = dbrows($result);
if (!isset($rowstart) || !isNum($rowstart)) $rowstart = 0;
if ($rows != 0) {
echo \"
\".$locale['401'].\" |
Nuotrauku: |
Pranessimai saukykloje: |
Komentaru: |
Reitingavimu: |
Data: |
\n\";
$result = dbquery(\"SELECT * FROM \".$db_prefix.\"users\".$orderby.\" ORDER BY user_posts DESC, user_posts LIMIT $rowstart,20\");
while ($data = dbarray($result)) {
echo \"\n| \n\".$data['user_name'].\" | \n\";
echo \"\n\".dbcount(\"(photo_id)\", \"photos\", \"photo_user='\".$data['user_id'].\"'\").\" | \n\";
echo \"\n\".dbcount(\"(shout_id)\", \"shoutbox\", \"shout_name='\".$data['user_id'].\"'\").\" | \n\";
echo \"\n\".dbcount(\"(comment_id)\", \"comments\", \"comment_name='\".$data['user_id'].\"'\").\" | \n\";
echo\"\n\".dbcount(\"(rating_id)\", \"ratings\", \"rating_user='\".$data['user_id'].\"'\").\" | \";
echo \"\n\".($data['user_lastvisit'] != 0 ? showdate(\"shortdate\", $data['user_lastvisit']) : $locale['u049']).\" | \";
}
echo \"\n
\n\";
} else {
echo \"
\n\".$locale['403'].\"$sortby
\n\n\";
}
$search = array(
\"A\",\"B\",\"C\",\"D\",\"E\",\"F\",\"G\",\"H\",\"I\",\"J\",\"K\",\"L\",\"M\",\"N\",\"O\",\"P\",\"Q\",\"R\",
\"S\",\"T\",\"U\",\"V\",\"W\",\"X\",\"Y\",\"Z\",\"0\",\"1\",\"2\",\"3\",\"4\",\"5\",\"6\",\"7\",\"8\",\"9\"
);
echo \"
\n\";
} else {
echo \"
\n\".$locale['002'].\"
\n\n\";
}
closetable();
echo \"\".makePageNav($rowstart,20,$rows,3,FUSION_SELF.\"?sortby=$sortby&\").\"\n \n\";
require_once \"side_right.php\";
require_once \"footer.php\";
?>
|
| |
|
|
| RAFFAK |
parašyta 2009-06-30 07:08
|
Pradinukas
Reputacija:
0
Pranešimai: 45
Įstojo: 2008-05-07
|
Dekui, idealiai veikia. Lock |
| |
|
