PageRenderTime 51ms CodeModel.GetById 18ms RepoModel.GetById 1ms app.codeStats 0ms

/old/list.php

https://github.com/Roberto5/toolraider
PHP | 319 lines | 299 code | 9 blank | 11 comment | 55 complexity | 70cc1a847f7c3afe06a67324656e6773 MD5 | raw file
    

  1. <?php
    2. 

  2. $title = ": lista farm";
    3. 

  3. session_start();
    4. 

  4. include ("my_config.php");
    5. 

  5. include ("inc/foot.php");
    6. 

  6. include ("inc/config.php");
    7. 

  7. include ("functions.php");
    8. 

  8. $Db = new db();
    9. 

  9. online(5);
    10. 

  10. Pagina_protetta(1);
    11. 

  11. 

  12. echo '
    13. 

  13. <script language="javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.3.2/jquery.min.js"></script>
    14. 

  14. <!-- libreria locale 
    15. 

  15. <script language="javascript" src="scripts/jquerymin.js"></script>-->
    16. 

  16. <script language="Javascript" src="scripts/list.js"></script> ';
    17. 

    18. 

  18. menu();
    19. 

  19. // bivio lista farm attive e inattive
    20. 

  20. echo "<p><center><a href=\"list.php?list=activ\">lista farm attive</a> | <a href=\"list.php?list=inactiv\">lista farm inattive</a> | <a href=\"list.php?list=add\">aggiungi link</a> | <a href=\"list.php?list=cerca\">Cerca</a></center></p>";
    21. 

  21. $_GET = inputctrl($_GET);
    22. 

  22. $_POST = inputctrl($_POST);
    23. 

  23. 

  24. $list = $_GET['list'];
    25. 

  25. $sort = "idasc";
    26. 

  26. $start = 0;
    27. 

  27. 

  28. 

  29. 

  30. //passo di default
    31. 

  31. $step = 15;
    32. 

  32. 

  33. if ($list == "activ") { // stampa lista farm attive*************************************
    34. 

  34. switch ($list) {
    35. 

  35.     case "activ":
    36. 

  36.         $list = 1;
    37. 

  37.         break;
    38. 

  38.     case "inactiv":
    39. 

  39.         $list = 2;
    40. 

  40.         break;
    41. 

  41. }
    42. 

  42.     $Db->connect();
    43. 

  43.     echo "
    44. 

  44. 	<center>Seleziona pianeta<br />
    45. 

  45. 	<form name=\"list\">";
    46. 

  46.     $query = "SELECT `nome_lista` FROM `us_list` WHERE `uid` = '".$_SESSION['nome']."' AND `type`=1 GROUP BY `nome_lista` ORDER BY `nome_lista` ASC ";
    47. 

  47.     echo "<select name=listname onchange=\"richiesta(this,'".$list."','".$start."','".$sort."','".$step."',0)\"><option value=\"\" selected=\"selected\">      </option>";
    48. 

  48.     $riga = $Db->totable($query);
    49. 

  49.     for ($i = 0; $riga[$i]; $i++) {
    50. 

  50.         echo "<option value=\"".$riga[$i]['nome_lista']."\">".$riga[$i]['nome_lista']."</option>";
    51. 

  51.     }
    52. 

  52.     echo "</select></form><div id=\"visualizza\"></div></center>";
    53. 

  53.     $Db->close();
    54. 

  54. } elseif ($list == "inactiv") {
    55. 

  55.     switch ($list) {
    56. 

  56.     case "activ":
    57. 

  57.         $list = 1;
    58. 

  58.         break;
    59. 

  59.     case "inactiv":
    60. 

  60.         $list = 2;
    61. 

  61.         break;
    62. 

  62. }
    63. 

  63.     $Db->connect();
    64. 

  64.     echo "
    65. 

  65. 	<center>Seleziona pianeta<br />
    66. 

  66. 	<form name=\"list\">";
    67. 

  67.     $query = "SELECT `nome_lista` FROM `us_list` WHERE `uid` = '".$_SESSION['nome']."'  AND `type`=2 GROUP BY `nome_lista` ORDER BY `nome_lista` ASC ";
    68. 

  68.     $riga = $Db->totable($query);
    69. 

  69.     echo "<select name=listname onchange=\"richiesta(this,'".$list."','".$start."','".$sort."','".$step."',0)\"><option value=\"\" selected=\"selected\">      </option>";
    70. 

  70.     for ($i = 0; $riga[$i]; $i++) {
    71. 

  71.         echo "<option value=\"".$riga[$i]['nome_lista']."\">".$riga[$i]['nome_lista']."</option>";
    72. 

  72.     }
    73. 

  73.     echo "</select></form><div id=\"visualizza\"></div></center>";
    74. 

  74.     $Db->close();
    75. 

  75. } elseif ($list == "add") {
    76. 

  76.     if ($_SESSION['listtype'] == "") $listtype = "1";
    77. 

  77.     else  $listtype = $_SESSION['listtype'];
    78. 

  78.     if ($_SESSION['listname'] == "") $listname = "";
    79. 

  79.     else  $listname = $_SESSION['listname'];
    80. 

  80.     if ($listtype == "1") $en1 = "selected=selected";
    81. 

  81.     else  $en2 = "selected=selected";
    82. 

  82.     echo "<center><form name=\"addlink\" action=\"list.php?list=add_do\" method=\"POST\">Seleziona lista
    83. 

  83. 	<select name=\"sel\">
    84. 

  84. 	<option value=\"1\" ".$en1.">farm attive</option>
    85. 

  85. 	<option value=\"2\" ".$en2.">farm inattive</option>
    86. 

  86. 	</select> pianeta di partenza
    87. 

  87. 	<select name=\"n_list\">";
    88. 

  88.     $Db->connect();
    89. 

  89.     $query = "SELECT * FROM `us_pianeti` WHERE id='".$_SESSION['nome']."'";
    90. 

  90.     $riga = $Db->totable($query);
    91. 

  91.     $en1 = "";
    92. 

  92.     for ($i = 0; $riga[$i]; $i++) {
    93. 

  93.         if ($listname == $riga[$i]['nome_pianeta']) $en1 = "selected=selected";
    94. 

  94.         else  $en1 = "";
    95. 

  95.         echo "<option value=".$riga[$i]['nome_pianeta']." ".$en1.">".$riga[$i]['nome_pianeta']."</option>";
    96. 

  96.     }
    97. 

  97.     switch ($_SESSION['razza']) {
    98. 

  98.         case 0:
    99. 

  99.             $testo = "non hai selezionato la razza! ";
    100. 

  100.             break;
    101. 

  101.         case "Titani":
    102. 

  102.             $testo = "tipi di nave: [piccolo trasportatore] oppure [1], [grande trasportatore] oppure [2], [corsair] oppure [3] ";
    103. 

  103.             break;
    104. 

  104.         case "Terrestri":
    105. 

  105.             $testo = "tipi di nave: [piccolo trasportatore] oppure [1], [caccia] o [2], [cacciatorpediniere] o [3], [corazzata] o [4], [incrociatore] o [5]";
    106. 

  106.             break;
    107. 

  107.         case "Xen":
    108. 

  108.             $testo = "tipi di nave: [mylon] o [1], [xnair] o [2], [maxtron] o [3], [nave madre] o [4]";
    109. 

  109.             break;
    110. 

  110.     }
    111. 

  111.     echo "</select><br />
    112. 

  112. 	<input type=\"button\" value=\"aggiungi\" onClick='control()'><input type=\"reset\" value=\"reset\"><br />
    113. 

  113. 	<div><abbr title=\"l'id č il numero a 8 cifre del pianeta &#10;
    114. 

  114.     sintassi per inserire gli id: &#10;
    115. 

  115.     12345678 &quot;nome&quot; [tiponave] {numero} (commento) &#10;".$testo."
    116. 

  116.     \">istruzioni</abbr></div>
    117. 

  117. 	<textarea name=testo rows=15 cols=50></textarea><br />
    118. 

  118.     opzioni da inserire nei link<input name=text value=\"".$_SESSION['opt']."\"/><br /><select name=\"optnav\" onchange='document.addlink.text.value=document.addlink.text.value.replace(/\[[0-9]{1}\]/gi,\"\")+\"[\"+this.value+\"]\"'><option value=\"0\"></option>";
    119. 

  119.     switch ($_SESSION['razza']) {
    120. 

  120.         case "Titani":
    121. 

  121.             echo "<option value=\"1\">piccolo trasportatore</option><option value=\"2\">grande trasportatore</option><option value=\"3\">corsair</option>";
    122. 

  122.             break;
    123. 

  123.         case "Terrestri":
    124. 

  124.             echo "<option value=\"1\">piccolo trasportatore</option><option value=\"2\">caccia</option><option value=\"3\">cacciatorpediniere</option><option value=\"4\">corazzata</option><option value=\"5\">incrociatore</option>";
    125. 

  125.             break;
    126. 

  126.         case "Xen":
    127. 

  127.             echo "<option value=\"1\">mylon</option><option value=\"2\">xnair</option><option value=\"3\">maxtron</option><option value=\"4\">nave madre</option>";
    128. 

  128.             break;
    129. 

  129.     }
    130. 

  130.     echo "</select> n° <input size=\"3\" maxlength=\"9\" onchange='document.addlink.text.value=document.addlink.text.value.replace(/\{[0-9]{1,9}\}/gi,\"\")+\"{\"+this.value+\"}\"' /><br />
    131. 

  131.     <input type=button onClick='estrai()' value=elabora />
    132. 

  132. 	</center><br /><br />";
    133. 

  133. } elseif ($list == "add_do") {
    134. 

  134.     $tabel = (int)$_POST['sel'];
    135. 

  135.     $n_list = $_POST['n_list'];
    136. 

  136.     $testo = $_POST['testo'];
    137. 

  137.     $opt = $_POST['text'];
    138. 

  138. 

  139.     if (!$opt) $_SESSION['opt'] = $opt;
    140. 

  140.     if (($n_list == "") || ($testo == "")) Errore("list.php","errore","compilazione dati");
    141. 

  141.     if (!in_array($tabel,array(1,2))) Errore("list.php","errore","seleziona una lista");
    142. 

  142.     $_SESSION['listtype'] = $tabel;
    143. 

  143.     $_SESSION['listname'] = $n_list;
    144. 

  144.     //***************************estrai id
    145. 

  145.     //per imperion **************
    146. 

  146.     //sintassi  12345678 "nome" [tiponave] {numero} (commento)
    147. 

  147.     $comment = "";
    148. 

  148.     $link = "";
    149. 

  149.     $numn = "";
    150. 

  150.     $tipon = "";
    151. 

  151.     $nomel = "";
    152. 

  152.     //echo "<textarea>" . $testo . "</textarea>";
    153. 

  153.     $t = explode("\n",$testo);
    154. 

  154.     $i = 0;
    155. 

  155.     while ($t[$i]) {
    156. 

  156.         //cerca l'id
    157. 

  157.         if (eregi("^[0-9]{8,9}",$t[$i],$link2)) {
    158. 

  158.             $link[] = $link2[0];
    159. 

  159.         }
    160. 

  160.         //cerca il nome link
    161. 

  161.         if (eregi("[\"]+[a-zA-Z 0-9]+[\"]",$t[$i],$nomel2)) {
    162. 

  162.             $nomel[] = $nomel2[0];
    163. 

  163.         } else  $nomel[] = $link2[0];
    164. 

  164.         //cerca il commento
    165. 

  165.         if (eregi("[(]+[a-zA-Z 0-9]+[)]",$t[$i],$comment2)) {
    166. 

  166.             $comment[] = $comment2[0];
    167. 

  167.         } else  $comment[] = " ";
    168. 

  168.         //cerca il tipo di nave
    169. 

  169.         if (eregi("\[+[a-zA-Z0-9]+\]",$t[$i],$tipon2)) {
    170. 

  170.             $tipon[] = $tipon2[0];
    171. 

  171.         } else  $tipon[] = "0";
    172. 

  172.         //cerca il numero
    173. 

  173.         if (eregi("\{+[0-9]+\}",$t[$i],$numn2)) {
    174. 

  174.             $numn[] = $numn2[0];
    175. 

  175.         } else  $numn[] = "0";
    176. 

  176.         $i++;
    177. 

  177.     }
    178. 

  178.     
    179. 

  179.     $n = 0;
    180. 

  180.     while ($link[$n]) {
    181. 

  181.         $n++;
    182. 

  182.     }
    183. 

  183.     $Db->connect();
    184. 

  184.     $query = "SELECT count(*) AS tot FROM `us_list` WHERE uid='".$_SESSION['nome']."' AND nome_lista='".$n_list."' AND type=".$tabel."";
    185. 

  185.     $row = $Db->toarray($query);
    186. 

  186.     if ($row['tot'] == "") $row['tot'] = 1;
    187. 

  187.     else  $row['tot']++;
    188. 

  188.     for ($i = 0; $i < $n; $i++) {
    189. 

  189.         $tipon[$i] = strtolower($tipon[$i]);
    190. 

  190.         $tipon[$i] = str_replace("[","",$tipon[$i]);
    191. 

  191.         $tipon[$i] = str_replace("]","",$tipon[$i]);
    192. 

  192.         if ($_SESSION['razza'] == "Xen") {
    193. 

  193.             switch ($tipon[$i]) {
    194. 

  194.                 case "1":
    195. 

  195.                 case "mylon":
    196. 

  196.                     $type = 1;
    197. 

  197.                     break;
    198. 

  198.                 case "2":
    199. 

  199.                 case "xnair":
    200. 

  200.                     $type = 2;
    201. 

  201.                     break;
    202. 

  202.                 case "3":
    203. 

  203.                 case "maxtron":
    204. 

  204.                     $type = 3;
    205. 

  205.                     break;
    206. 

  206.                 case "4":
    207. 

  207.                 case "nave madre":
    208. 

  208.                     $type = 4;
    209. 

  209.                     break;
    210. 

  210.                 default:
    211. 

  211.                     $type = 0;
    212. 

  212.                     break;
    213. 

  213.             }
    214. 

  214.         } elseif ($_SESSION['razza'] == "Terrestri") {
    215. 

  215.             switch ($tipon[$i]) {
    216. 

  216.                 case "1":
    217. 

  217.                 case "piccolo trasportatore":
    218. 

  218.                     $type = 1;
    219. 

  219.                     break;
    220. 

  220.                 case "2":
    221. 

  221.                 case "caccia":
    222. 

  222.                     $type = 2;
    223. 

  223.                     break;
    224. 

  224.                 case "3":
    225. 

  225.                 case "cacciatorpediniere":
    226. 

  226.                     $type = 3;
    227. 

  227.                     break;
    228. 

  228.                 case "4":
    229. 

  229.                 case "corrazzata":
    230. 

  230.                     $type = 4;
    231. 

  231.                     break;
    232. 

  232.                 case "5":
    233. 

  233.                 case "incrociatore":
    234. 

  234.                     $type = 5;
    235. 

  235.                     break;
    236. 

  236.                 default:
    237. 

  237.                     $type = 0;
    238. 

  238.                     break;
    239. 

  239.             }
    240. 

  240.         } elseif ($_SESSION['razza'] == "Titani") {
    241. 

  241.             switch ($tipon[$i]) {
    242. 

  242.                 case "1":
    243. 

  243.                 case "piccolo trasportatore":
    244. 

  244.                     $type = 1;
    245. 

  245.                     break;
    246. 

  246.                 case "2":
    247. 

  247.                 case "grande trasportatore":
    248. 

  248.                     $type = 2;
    249. 

  249.                     break;
    250. 

  250.                 case "3":
    251. 

  251.                 case "corsair":
    252. 

  252.                     $type = 3;
    253. 

  253.                     break;
    254. 

  254.                 default:
    255. 

  255.                     $type = 0;
    256. 

  256.                     break;
    257. 

  257.             }
    258. 

  258.         }
    259. 

  259.         $comment[$i] = str_replace("(","",$comment[$i]);
    260. 

  260.         $comment[$i] = str_replace(")","",$comment[$i]);
    261. 

  261.         $nomel[$i] = str_replace("\"","",$nomel[$i]);
    262. 

  262.         $nomel[$i] = str_replace("\"","",$nomel[$i]);
    263. 

  263.         $num = str_replace("{","",$numn[$i]);
    264. 

  264.         $num = str_replace("}","",$num);
    265. 

  265.         if (!$Db->conta("SELECT * FROM `us_list` WHERE `link`='".$link[$i]."'")) {
    266. 

  266.             $query = "INSERT INTO `us_list` SET `type`=".$tabel." , `n`='".$row['tot']."' ,
    267. 

  267.              `uid`='".$_SESSION['nome']."' , `nome_lista`='".$n_list."' , `nome_farm`='".$nomel[$i]."' ,
    268. 

  268.               `link`='".$link[$i]."' , `comment`='".$comment[$i]."' , `tipo_nave` = '".$type."' ,
    269. 

  269.                `num_nave`='".$num."'";
    270. 

  270.             $Db->query($query);
    271. 

  271.             $row['tot']++;
    272. 

  272.         } else {
    273. 

  273.             echo "link ".$link[$i]." č giŕ esistente <br/>";
    274. 

  274.         }
    275. 

  275.     }
    276. 

  276.     $Db->close();
    277. 

  277.     ok("javascript:history.back()","ok","inserimento eseguito con successo");
    278. 

  278. } elseif ($list == "cerca") {
    279. 

  279.     echo "
    280. 

  280.     <center><form action=\"list.php?list=do\" method=\"post\">
    281. 

  281.     <select name=\"table\">
    282. 

  282.     <option value=\"1\">farm attive</option>
    283. 

  283.     <option value=\"2\" selected=\"selected\">farm passive</option>
    284. 

  284.     </select>
    285. 

  285.     inserisci l'id da cercare <input name=\"id\" size=\"8\" maxlength=\"9\" onchange=\"control(this)\" /> 
    286. 

  286.     <input type=\"submit\" value=\"cerca\" /></form>
    287. 

  287.     </center>";
    288. 

  288. } elseif ($list == "do") {
    289. 

  289.     $Db->connect();
    290. 

  290.     $id = $_POST['id'];
    291. 

  291.     $table = (int)$_POST['table'];
    292. 

  292.     if (!in_array($table,array(1,2))) Errore("index.php","ERRORE","lista errata");
    293. 

  293.     $query = "SELECT * FROM `us_list` WHERE `link`='".$id."' AND `type`=".$table;
    294. 

  294.     $num = $Db->conta($query);
    295. 

  295.     echo "<center><p>numero risultati ".$num."</p></center>";
    296. 

  296.     visualizza("",$query,"`n` ASC",0,30,$table,"",1);
    297. 

  297. } else {
    298. 

  298.     echo "<center><h2>Farm non ancora raidate oggi</h2><br /><form name=\"list\"><select name=\"table\" onchange=\"changemenuplanet(this.value);richiesta(document.list.listname,document.list.table.value,'".
    299. 

  299.         $start."','".$sort."','".$step."',1)\">
    300. 

  300.     <option value=\"1\" >farm attive</option>
    301. 

  301.     <option value=\"2\" selected=\"selected\">farm passive</option>
    302. 

  302.     </select> </center>";
    303. 

  303.     $step = 15;
    304. 

  304.     $Db->connect();
    305. 

  305.     echo "<center>Filtra pianeta<br />";
    306. 

  306.     $query = "SELECT `nome_lista` FROM `us_list` WHERE `uid` = '".$_SESSION['nome']."' AND `type`=2 GROUP BY `nome_lista` ORDER BY `nome_lista` ASC ";
    307. 

  307.     echo "<select id=\"listname\" name=\"listname\" onchange=\"richiesta(this,document.list.table.value,'".$start."','".$sort."','".$step."',1)\"><option value=\"\" selected=\"selected\">      </option>";
    308. 

  308.     $riga = $Db->totable($query);
    309. 

  309.     for ($i = 0; $riga[$i]; $i++) {
    310. 

  310.         echo "<option value=\"".$riga[$i]['nome_lista']."\">".$riga[$i]['nome_lista']."</option>";
    311. 

  311.     }
    312. 

  312.     echo "</select></form><br />numero risultati : <span id=\"ris\"></span><div id=\"visualizza\"></div></center>";
    313. 

  313.     $Db->close();
    314. 

  314.     echo "<script language=\"javascript\">
    315. 

  315. richiesta(document.list.listname,document.list.table.value,'".$start."','".$sort."','".$step."',1)
    316. 

  316. </script>";
    317. 

  317. }
    318. 

  318. foot();
    319. 

  319. ?>
    320.