Advertisement
linccce

Quick Item select dropdown

Oct 7th, 2014
198
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.33 KB | None | 0 0
  1. <?php
  2.  
  3. if (!isset($db)) { exit; }
  4.  
  5. ### Funkcija "Persokti i skyriu..."
  6. function medis_jumper ($tevas, $lygis, $lygiai, $lang) {
  7.     global $db;
  8.     global $jungimasis;
  9.     $skirtukas ='';
  10.  
  11.     if (($lygis <= $lygiai)||($lygiai < 0)) {
  12.         $sql = ("SELECT * FROM ".$db['prefix']."skiltys WHERE level = '".$tevas."' && (lang = '".$lang."' OR lang = '0') ORDER BY position ASC");
  13.         $result = mysqli_query($jungimasis, $sql);
  14.         $kiekis = mysqli_num_rows($result);
  15.         $tarpas = $lygis;
  16.         $lygis++;
  17.  
  18.         foreach ($result as $key => $res) {
  19.             $trp = $tarpas;
  20.             $skirtukas = ("");
  21.             while ($trp>0) :
  22.                 $skirtukas = ($skirtukas."&nbsp;&nbsp;&nbsp;");
  23.                 $trp--;
  24.             endwhile;
  25.             $name = $res['name'];
  26.             $id = $res['id'];
  27.  
  28.             $query_irasai = ("SELECT * FROM ".$db['prefix']."text WHERE sid = '".$id."'");
  29.             $result_irasai = mysqli_query($jungimasis, $query_irasai);
  30.             $total_irasai = mysqli_num_rows ($result_irasai);
  31.             Print ("<option value=\"index.php?lang=".$lang."&mod=skyriai&task=list&skyrius=".$id."\">".$skirtukas." ▪&nbsp;".$name." (".$total_irasai.")</option>\n");
  32.             $sql_1 = ("SELECT * FROM ".$db['prefix']."skiltys WHERE level = '".$id."' ORDER BY position ASC");
  33.             $result_1 = mysqli_query($jungimasis, $sql_1);
  34.             if (mysqli_num_rows($result_1) != 0) {
  35.                 medis_jumper($id, $lygis, $lygiai, $lang);
  36.             }
  37.         }
  38.     }
  39. }
  40.  
  41. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement