WordPress, Shopify ir PHPFusion programuotojų bendruomenė

Parašė Vaidotas-· 2008 Vas. 22 16:02:49

Sorry už flood, bet gal padės labaiu, jei damesiu



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>";

ir čia failas, kur reikia jį įdėt

<?php



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"<br>Lygis: <b>$level</b>

<br>Iki kito: [$opt_posts%]

<br>



   <table width='100%' border='1' class='line'><tr><th width='100%'> 

   <img src='".IMAGES."line.gif' title='Procentine linija' height='8' width='$opt_posts%' align='left' >

   </td></tr></table>



<br>Pranešimų forume: <b>$posts</b>

<br>Komentarų: <b>$comment</b>

<br>Klausimynas: <b>$reward</b>



";



      }



   }

}



?>

$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 turėtų sudaryt pagrindą

Redagavo Vaidotas-· 2008 Vas. 22 17:02:03