Naujokas
Reputacija:
0
Pranešimai: 5
Įstojo: 2007-01-23
|
Sveiki, turiu point system, ir j noriu integruot nario lyg, taiau kai pridedu kod :  Code$reward = dbcount(\"(points_rew)\", \"points_user\", \"user_id='$exp_user'\");
points_rew <-- Ta?k skaiius
user_id <-- nario kodas
Pagrindin lantel: points_user
gal kas ?inot, kaip tai padaryt? tarokitko noriu ?ita dalyka dt t pat, kaip yra cia nari lygis!
cia tas pagrindinis failas, kuriame yra tas kodas
Code
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\"
\".PS_012.\" |
$name_name |
\n\";
if($status9 == 1){
echo \"| \".PS_001.\" | \";
echo dbcount(\"(shout_id)\", \"shoutbox\", \"shout_name='\".$userdata['user_id'].\"'\").\"\".PS_007.\" $points_shoutbox = $shoutboxall | \";
}
if($status4 == 1){
echo \"\n| \".PS_002.\" | \n\n\";
echo dbcount(\"(article_id)\", \"articles\", \"article_name='\".$userdata['user_id'].\"'\").\"\".PS_007.\" $points_article = $articleall | \";
}
if($status5 == 1){
echo \"\n| \".PS_009.\" | \n\n\";
echo dbcount(\"(news_id)\", \"news\", \"news_name='\".$userdata['user_id'].\"'\").\"\".PS_007. \"$points_news = $newsall | \";
}
if($status10 == 1){
echo \"\n| \".PS_004.\" | \n\n\";
echo dbcount(\"(comment_id)\", \"comments\", \"comment_name='\".$userdata['user_id'].\"'\").\" \".PS_007. \"$points_kommentare = $kommentarall | \";
}
if($status1 == 1){
echo \"\n| \".PS_011.\" | \n\n\";
echo dbcount(\"(forum_id)\", \"threads\", \"thread_author='\".$userdata['user_id'].\"'\").\" \".PS_007. \"$points_thread = $threadall | \";
}
if($status2== 1){
echo \"\n| \".PS_003.\" | \n\n\";
echo dbcount(\"(post_id)\", \"posts\", \"post_author='\".$userdata['user_id'].\"'\").\" \".PS_007. \"$points_post = $postall | \";
}
if($status11== 1){
echo \"\n| \".PS_018.\" | \n\n\"; echo \"$reward | \";
}
$gesamtzahl = \"$shoutboxall \"+\" $articleall \"+\" $newsall \"+\" $kommentarall \"+\" $postall \"+\" $threadall \"+\" $reward2 \";
$guthaben = \"$shoutboxall \"+\" $articleall \"+\" $newsall \"+\" $kommentarall \"+\" $postall \"+\" $threadall \"+\" $reward2 \"+\" $extra \"-\" $ausgabe \"-\" $strafe\";
echo \"
\n | \";
echo \"\n| \n \n\".PS_008.\" | $gesamtzahl | \";
echo \"
\n | \";
echo \"\n| \n \n\".PS_013.\"$name_name: | $extra\n | \";
echo \"\n| \n \n\".PS_014.\" | $ausgabe\n | \";
echo \"\n| \n \n\".PS_015.\" | $strafe\n | \";
echo \"
\n | \";
echo \"
\n | \";
$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 \"\n| \n \n\".PS_016.\" | $guthabendb\n | \";
}
else{
echo \"\n| \n \n\".PS_016.\" | $guthabendb\n | \";
}
echo \"
\n | \";
echo \"
\n\";
closetable();
echo \"
\";
ir ia failas, kur reikia j dt
Code
if (!defined(\"IN_FUSION\")) { header(\"Location:../index.php\"); exit; }
function showexp($exp_user,$exp_posts,$exp_type) {
if (iMEMBER) {
$posts = $exp_posts;
$comment = dbcount(\"(comment_id)\", \"comments\", \"comment_name='$exp_user'\");
$rating = dbcount(\"(rating_id)\", \"ratings\", \"rating_user='$exp_user'\");
$sum = ($posts+$comment+$shoutbox+$rating+$mod+$reward);
if ($sum <= \"1\") {$rang = \"0\";$level = \"Naujokas\";}
if ($sum >= \"1\") {$rang = \"5\";$level = \"Pradinukas\";}
if ($sum >= \"5\") {$rang = \"25\";$level = \"Ap?ylantis\";}
if ($sum >= \"25\") {$rang = \"50\";$level = \"D Chemikas\";}
if ($sum >= \"50\") {$rang = \"100\";$level = \"C Chemikas\";}
if ($sum >= \"100\") {$rang = \"250\";$level = \"B Chemikas\";}
if ($sum >= \"250\") {$rang = \"500\";$level = \"A Chemikas\";}
if ($sum >= \"500\") {$rang = \"1000\";$level = \"Mokytojas\";}
if ($sum >= \"1000\") {$rang = \"2000\";$level = \"Profesorius\";}
if ($sum >= \"2000\") {$rang = \"4000\";$level = \"Vir?ininkas\";}
if ($sum >= \"4000\") {$rang = \"10000\";$level = \"Vir?ininkas kvadratu\";}
$poll_posts = $rang;
$opt_posts = ($poll_posts ? number_format(100 / $poll_posts * $sum) : 0);
if ($exp_type == \"1\") {
echo\"
Lygis: $level
Iki kito: [$opt_posts%]
Prane?im forume: $posts
Komentar: $comment
Klausimynas: $reward
\";
}
}
}
?>
$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']."'");
ia tas kodas, kuris turt sudaryt pagrind
Paranoja: Smailai i?junkti!
Redagavo Paranoja 2008-02-29 14:00 |
![]('\".IMAGES.\"line.gif' "'Procentine")