API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Nov 16th, 2018
77
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 39.35 KB | None | 0 0
raw download clone embed print report
  1. <?php
  2. $ledennu = mysqli_query($con, "SELECT `id` FROM `users`");
  3. $ledennu = mysqli_num_rows($ledennu);
  4. $ledenonline = mysqli_query($con, "SELECT `users`.`id` FROM `users` WHERE `lastclick` >".(time() - 900)) or die( mysqli_error($con));
  5. $ledenonline = mysqli_num_rows($ledenonline);
  6.  
  7. function is_name($i){
  8. if(!strpos("^[A-Za-z0-9-]{3,25}$", $i)){
  9. return FALSE;
  10. } else {
  11. return TRUE;
  12. }
  13. }
  14.  
  15. function is_email($em){
  16.  
  17. $ema = filter_var($em, FILTER_VALIDATE_EMAIL);
  18.  
  19. if(!$ema){
  20. return FALSE;
  21. } else {
  22. return TRUE;
  23. }
  24. }
  25.  
  26.  
  27. function countDown($i, $verschil){
  28.  
  29. $msg = "
  30.  
  31. <script type='text/javascript'>
  32. var seconds". $i."=". $verschil.";
  33. function display". $i."()
  34. {
  35. seconds". $i."=seconds". $i."-1;
  36. if(seconds". $i."<0)
  37. {
  38. countdown". $i.".innerHTML=\"0\";
  39. }
  40. else
  41. {
  42. var countdown". $i." = document.all? document.all[\"cd".$i."\"] : document.getElementById ? document.getElementById (\"cd". $i."\")
  43. : \"\";
  44. if (countdown". $i.")
  45. {
  46. countdown". $i.".innerHTML=seconds". $i.";
  47. setTimeout('display". $i."()',1000);
  48. }
  49. }
  50. }
  51. display". $i."();
  52. </script>
  53.  
  54. ";
  55.  
  56. return $msg;
  57.  
  58. }
  59.  
  60.  
  61. function bad($msg){
  62. return "<table border='0' cellspacing='0' style='margin: 0px;'>
  63. <tr>
  64. <td style='text-align: left;'>
  65. <img src='IMG/cross.png' alt='' border='0'>
  66. </td>
  67. <td>
  68. ".$msg."
  69. </td>
  70. </tr>
  71. </table>";
  72. }
  73.  
  74. function good($msg){
  75. return "<table border='0' cellspacing='0' style='margin: 0px;'>
  76. <tr>
  77. <td style='text-align: left;'>
  78. <img src='IMG/tick.png' alt='' border='0'>
  79. </td>
  80. <td>
  81. ".$msg."
  82. </td>
  83. </tr>
  84. </table>";
  85. }
  86.  
  87.  
  88. function createBalk($score){
  89.  
  90. if($score >= 100){
  91. return "<table cellspacing='1' bgcolor='#000' width='100'>
  92. <tr>
  93. <td class='balk_full'>
  94. 100%
  95. </td>
  96. </tr>
  97. </table>";
  98. } elseif($score >= 50 && $score < 100){
  99. return "<table cellspacing='1' bgcolor='#000' width='100'>
  100. <tr>
  101. <td class='balk_full' width='".$score."'>
  102. ".$score."%
  103. </td>
  104. <td class='balk_empty' style='padding: 0px;' width='".(100 - $score)."'></td>
  105. </tr>
  106. </table>";
  107. } elseif($score < 50 && $score > 0){
  108. return "<table cellspacing='1' bgcolor='#000' width='100'>
  109. <tr>
  110. <td class='balk_full' width='".$score."' style='padding: 0px;'></td>
  111. <td class='balk_empty'>
  112. ".$score."%
  113. </td>
  114. </tr>
  115. </table>";
  116. } elseif($score == 0){
  117. return "<table cellspacing='1' bgcolor='#000' width='100'>
  118. <tr>
  119.  
  120. <td class='balk_empty'>
  121. ".$score."%
  122. </td>
  123. </tr>
  124. </table>";
  125. }
  126.  
  127. }
  128.  
  129.  
  130. function getRank($rank){
  131.  
  132. if($rank < 5){
  133. $rankID = 0;
  134. } elseif($rank < 12){
  135. $rankID = 1;
  136. } elseif($rank < 22){
  137. $rankID = 2;
  138. } elseif($rank < 47){
  139. $rankID = 3;
  140. } elseif($rank < 77){
  141. $rankID = 4;
  142. } elseif($rank < 110){
  143. $rankID = 5;
  144. } elseif($rank < 160){
  145. $rankID = 6;
  146. } elseif($rank < 260){
  147. $rankID = 7;
  148. } elseif($rank < 510){
  149. $rankID = 8;
  150. } elseif($rank < 860){
  151. $rankID = 9;
  152. } elseif($rank < 1310){
  153. $rankID = 10;
  154. } else {
  155. $rankID = 11;
  156. }
  157.  
  158.  
  159. $ranken = array(
  160. array("rank" => "Scum", "rankID" => 0, "procenten" => procentRank(5, 5, $rank)),
  161. array("rank" => "Pee Wee", "rankID" => 1, "procenten" => procentRank(12, 7, $rank)),
  162. array("rank" => "Thug", "rankID" => 2, "procenten" => procentRank(22, 10, $rank)),
  163. array("rank" => "Gangster", "rankID" => 3, "procenten" => procentRank(47, 25, $rank)),
  164. array("rank" => "Hitman", "rankID" => 4, "procenten" => procentRank(77, 30, $rank)),
  165. array("rank" => "Assassin", "rankID" => 5, "procenten" => procentRank(110, 33, $rank)),
  166. array("rank" => "Boss", "rankID" => 6, "procenten" => procentRank(160, 50, $rank)),
  167. array("rank" => "Godfather", "rankID" => 7, "procenten" => procentRank(260, 100, $rank)),
  168. array("rank" => "Legendary Godfather", "rankID" => 8, "procenten" => procentRank(510, 250, $rank)),
  169. array("rank" => "Don", "rankID" => 9, "procenten" => procentRank(860, 350, $rank)),
  170. array("rank" => "Respectable Don", "rankID" => 10, "procenten" => procentRank(1310, 450, $rank)),
  171. array("rank" => "Legendary Don", "rankID" => 11, "totalpoints" => 1310, "to" => 5, "procenten" => 100),
  172. );
  173.  
  174.  
  175.  
  176. return $ranken[$rankID];
  177. }
  178.  
  179. function procentRank($total, $stap, $rankNow){
  180.  
  181. $todo = $total - $rankNow;
  182.  
  183. return round(100 -(($todo / $stap) * 100), 0);
  184. }
  185.  
  186.  
  187. function cname($id, $name, $return = false, $hard = false){
  188.  
  189. if((!file_exists("./cache/".$id."_colored_name.dat")) || ((filemtime("./cache/".$id."_colored_name.dat") < (time() - 0))) || ($hard)){
  190. // DE OUDE CODE if((!file_exists("./cache/".$id."_colored_name.dat")) || ((filemtime("./cache/".$id."_colored_name.dat") < (time() - 900))) || ($hard)){
  191.  
  192.  
  193. $sql = mysqli_query($con, "SELECT `donateur`, `status` FROM `status` WHERE `id`=".$id) or die( mysqli_error($con));
  194. $r = mysqli_fetch_assoc($sql);
  195. $Lsql = mysqli_query($con, "SELECT legend FROM speldata WHERE id=".$id) or die( mysqli_error($con));
  196. $Lr = mysqli_fetch_assoc($Lsql);
  197.  
  198. $status = $r['status'];
  199. $dona = $r['donateur'];
  200.  
  201. if($status == 0){
  202. $fc = "000";
  203. $st = "Verbannen";
  204. } elseif($status == 1){
  205. if($dona == 0){
  206. $fc = "ffffff";
  207. $st = "Lid";
  208. } elseif($dona > 0 && $dona < 5){
  209. $fc = "f7ff15";
  210. $st = "Donateur";
  211. } elseif($dona > 4 && $dona < 10){
  212. $fc = "42a6c6";
  213. $st = "VIP";
  214. } elseif($dona >= 10){
  215. $fc = "cc0099";
  216. $st = "Ultimate";
  217. }
  218.  
  219. if($Lr['legend'] == 1)
  220. {
  221. $fc = "ffe49d";
  222. }
  223.  
  224. } elseif($status == 32){
  225. if($dona == 0){
  226. $fc = "ffffff";
  227. $st = "Lid (Hidden Admin)";
  228. } elseif($dona > 0 && $dona < 5){
  229. $fc = "f7ff15";
  230. $st = "Donateur (Hidden Admin)";
  231. } elseif($dona > 4 && $dona < 10){
  232. $fc = "42a6c6";
  233. $st = "VIP (Hidden Admin)";
  234. } elseif($dona >= 10){
  235. $fc = "cc0099";
  236. $st = "Ultimate (Hidden Admin)";
  237. }
  238.  
  239. } elseif($status == 2){
  240. $fc = "39de00";
  241. $st = "Helpdesk";
  242. } elseif($status == 4){
  243. $fc = "adadad";
  244. $st = "Forum Mod";
  245. } elseif($status == 8){
  246. $fc = "ffa502";
  247. $st = "Game Mod";
  248. } elseif($status == 16){
  249. $fc = "ff0000";
  250. $st = "Admin";
  251. }
  252.  
  253. if($Lr['legend'] == 1){
  254. $s = array("status" => $st, "url" => "<a href=profile.php?x=".$name."><span style='color: #".$fc.";'>".$name." <img src='IMG/medaile.png' border='0' /></span></a>");
  255. } else {
  256. $s = array("status" => $st, "url" => "<a href=profile.php?x=".$name."><span style='color: #".$fc.";'>".$name."</span></a>");
  257. }
  258.  
  259. write("./cache/".$id."_colored_name.dat", serialize($s));
  260.  
  261.  
  262.  
  263.  
  264. } else {
  265.  
  266. $s = unserialize(file_get_contents("./cache/".$id."_colored_name.dat"));
  267.  
  268. }
  269.  
  270. if($return){
  271. return $s;
  272. }
  273.  
  274. return $s['url'];
  275.  
  276.  
  277. }
  278.  
  279. function mysql_result($in){
  280. return mysqli_real_escape_string (trim($in));}
  281.  
  282.  
  283.  
  284. function geldrank($geld){
  285.  
  286. if($geld < 100000){
  287. return "Straydog";
  288. } elseif($geld < 500000){
  289. return "Respectable Man";
  290. } elseif($geld < 1000000){
  291. return "Lower Class";
  292. } elseif($geld < 2500000){
  293. return "Middle Class";
  294. } elseif($geld < 5000000){
  295. return "Wealthy";
  296. } elseif($geld < 10000000){
  297. return "Upper Class";
  298. } elseif($geld < 25000000){
  299. return "Rich";
  300. } elseif($geld < 50000000){
  301. return "Very Rich";
  302. } elseif($geld < 100000000){
  303. return "Dangerously Rich";
  304. } else {
  305. return "Notoriously Rich";
  306. }
  307.  
  308. }
  309.  
  310. function iconStatus($sicon){
  311.  
  312. if($sicon == 0){
  313. return "<img src='IMG/status/status_online.png' alt='' width='16' height='16' border='0' />";
  314. } elseif($sicon == 1){
  315. return "<img src='IMG/status/status_online.png' alt='' width='16' height='16' border='0' />";
  316. } elseif($sicon == 2){
  317. return "<img src='IMG/status/bezet.png' alt='' width='16' height='16' border='0' />";
  318. } elseif($sicon == 3){
  319. return "<img src='IMG/status/afwezig.png' alt='' width='16' height='16' border='0' />";
  320. } elseif($sicon == 4){
  321. return "<img src='IMG/status/smokkelen.png' alt='' width='16' height='16' border='0' />";
  322. } elseif($sicon == 5){
  323. return "<img src='IMG/status/designen.png' alt='' width='16' height='16' border='0' />";
  324. } elseif($sicon == 6){
  325. return "<img src='IMG/status/druk.png' alt='' width='16' height='16' border='0' />";
  326. } elseif($sicon == 7){
  327. return "<img src='IMG/status/cake.png' alt='' width='16' height='16' border='0' />";
  328. } elseif($sicon == 99){
  329. return "<img src='IMG/status/user_grey.png' alt='' width='16' height='16' border='0' />";
  330. } elseif($sicon == 100){
  331. return "<img src='IMG/status/crown.png' alt='' width='16' height='16' border='0' />";
  332. }
  333.  
  334. }
  335.  
  336. function textStatus($stext){
  337.  
  338. if($stext == 0){
  339. return "<img src='IMG/status/status_online.png' alt='' width='16' height='16' border='0' /> <font color='#39de00'>Online</font>";
  340. } elseif($stext == 1){
  341. return "<img src='IMG/status/status_online.png' alt='' width='16' height='16' border='0' /> <font color='#39de00'>Online</font>";
  342. } elseif($stext == 2){
  343. return "<img src='IMG/status/bezet.png' alt='' width='16' height='16' border='0' /> <font color='#ba4a4a'>Bezet</font>";
  344. } elseif($stext == 3){
  345. return "<img src='IMG/status/afwezig.png' alt='' width='16' height='16' border='0' /> <font color='#f7b400'>Afwezig</font>";
  346. } elseif($stext == 4){
  347. return "<img src='IMG/status/smokkelen.png' alt='' width='16' height='16' border='0' /> <font color='#ce9b87'>Smokkelen</font>";
  348. } elseif($stext == 5){
  349. return "<img src='IMG/status/designen.png' alt='' width='16' height='16' border='0' /> <font color='#b487ce'>Designen</font>";
  350. } elseif($stext == 6){
  351. return "<img src='IMG/status/druk.png' alt='' width='16' height='16' border='0' /> <font color='#009cff'>Druk</font>";
  352. } elseif($stext == 7){
  353. return "<img src='IMG/status/cake.png' alt='' width='16' height='16' border='0' /> <font color='#f7d756'>Eten</font>";
  354. } elseif($stext == 99){
  355. return "<img src='IMG/status/user_grey.png' alt='' width='16' height='16' border='0' /> <font color='#ff0000'>Scripten</font>";
  356. } elseif($stext == 100){
  357. return "<img src='IMG/status/crown.png' alt='' width='16' height='16' border='0' /> <font color='#f7d756'>Legend</font>";
  358. }
  359.  
  360. }
  361.  
  362. function noXSS ($input)
  363. {
  364.  
  365. $inputTmp = trim(asciiDecode(strtolower($input)));
  366.  
  367.  
  368. if (substr($inputTmp, 0, 11) == 'javascript:') {
  369. $input = "";
  370. }
  371. return $input;
  372. }
  373.  
  374. function asciiDecode($input)
  375. {
  376. preg_match_all("(&#([0-9]{1,3});)", $input, $matches);
  377. $asciiCodes = array_unique($matches[1]);
  378. foreach ($asciiCodes as $asciiNr){
  379. $input = str_replace("&#$asciiNr;", chr($asciiNr), $input);
  380. }
  381. return $input;
  382. }
  383.  
  384. function deXSS_img($m){
  385. if(preg_match("/php/i", $m[1]) && preg_match("/crime-club/i", $m[1])){
  386. $r = "<img src=\"IMG/nopicture.jpg\" alt=\"\">";
  387. } else {
  388. $r = "<img src=\"".noXSS($m[1])."\" alt=\"\">";
  389. }
  390.  
  391. return $r;
  392.  
  393. }
  394.  
  395.  
  396.  
  397. function BBParser($in){
  398.  
  399. $in = htmlspecialchars($in);
  400. $in = nl2br($in);
  401.  
  402. if(!get_magic_quotes_gpc()){
  403. $in = addslashes($in);
  404. }
  405.  
  406. $in = str_replace("[color=#", "[color=", $in);
  407.  
  408. $patterns = array(
  409. "#\[b\](.*?)\[/b\]#si",
  410. "#\[u\](.*?)\[/u\]#si",
  411. "#\[ul\](.*?)\[/ul\]#si",
  412. "#\[i\](.*?)\[/i\]#si",
  413. "#\[s\](.*?)\[/s\]#si",
  414. "#\[center\](.*?)\[/center\]#si",
  415. "#\[color=(.*?)\](.*?)\[/color\]#si",
  416. "#\[size=(.*?)\](.*?)\[/size\]#si",
  417. "#\[right\](.*?)\[/right\]#si"
  418. );
  419.  
  420. $replaces = array(
  421. "<b>\\1</b>",
  422. "<u>\\1</u>",
  423. "<ul>\\1</ul>",
  424. "<i>\\1</i>",
  425. "<s>\\1</s>",
  426. "<center>\\1</center>",
  427. "<font color=\"#\\1\">\\2</font>",
  428. "<font size=\"\\1\">\\2</font>",
  429. "<div style=\"text-align: right;\" align=\"right\">\\1</div>"
  430. );
  431.  
  432.  
  433. $in = preg_replace($patterns,$replaces, $in);
  434.  
  435.  
  436. $in = preg_replace_callback("#\[img\](.*?)\[/img\]#si", "deXSS_img", $in);
  437.  
  438.  
  439. $smileys = array(
  440. ":D" => "lol",
  441. ":)" => "smile",
  442. ";)" => "wink",
  443. ":s" => "confused",
  444. ":|" => "neutral",
  445. ":P" => "razz",
  446. ":(" => "sad",
  447. ":O" => "surprised",
  448. ":twisted:" => "twisted",
  449. ":cry:" => "cry",
  450. ":mad:" => "mad",
  451. "8)" => "cool",
  452. ":x" => "silenced",
  453. ":?:" => "question",
  454. ":!:" => "exclaim",
  455. ":no:" => "naugthy",
  456. ":huh:" => "ehh",
  457. ":$" => "ashamed",
  458. ":applause:" => "applause",
  459. ":grin:" => "biggrin",
  460. ":rolleyes:" => "rolleyes",
  461. ":whistle:" => "whistle",
  462. "(A)" => "angel"
  463. );
  464.  
  465. foreach($smileys AS $key => $val){
  466. $replace = "<img src=\"IMG/smileys/".$val.".gif\" alt=\"\">";
  467. $in = str_ireplace($key, $replace, $in);
  468. }
  469.  
  470.  
  471. return $in;
  472.  
  473. }
  474.  
  475. // De goeie BB Parser voor de SHOUTBOX
  476.  
  477. function BBimages($in){
  478. $patterns = array(
  479. "#\[9\](.*?)\[/9\]#si",
  480. "#\[8\](.*?)\[/8\]#si",
  481. "#\[7\](.*?)\[/7\]#si",
  482. "#\[6\](.*?)\[/6\]#si",
  483. "#\[2=(.*?)\](.*?)\[/2\]#si",
  484. "#\[1=(.*?)\](.*?)\[/1\]#si",
  485. "#\[IMG\](.*?)\[/IMG\]#si",
  486. "#\[vid\](.*?)\[/vid\]#si",
  487. "#\[right\](.*?)\[/right\]#si"
  488. );
  489. $replaces = array(
  490. "<b>\\1</b>",
  491. "<u>\\1</u>",
  492. "<i>\\1</i>",
  493. "<s>\\1</s>",
  494. "<font color=\"#\\1\">\\2</font>",
  495. "<a href=\"\\1\">\\2</a>",
  496. "<a href=\"\\1\" TARGET=\"\\_blank\"><img src='http://clubcrime.nl/IMG/smileys/images.gif'/> <font color=#767676><b>Afbeelding</b></font></a>",
  497. "<a href=\"\\1\" TARGET=\"\\_blank\"><img src='http://clubcrime.nl/IMG/smileys/doc_film.png'/> <font color=#767676><b>Filmpje</b></font></a>",
  498. "<div style=\"text-align: right;\" align=\"right\">\\1</div>"
  499. );
  500. $in = preg_replace($patterns,$replaces, $in);
  501. $smileys = array(
  502. ":D" => "lol",
  503. ":)" => "smile",
  504. ";)" => "wink",
  505. ":s" => "confused",
  506. ":|" => "neutral",
  507. ":P" => "razz",
  508. ":(" => "sad",
  509. ":O" => "surprised",
  510. ":twisted:" => "twisted",
  511. ":cry:" => "cry",
  512. ":mad:" => "mad",
  513. "8)" => "cool",
  514. ":x" => "silenced",
  515. ":?:" => "question",
  516. ":!:" => "exclaim",
  517. ":no:" => "naugthy",
  518. ":huh:" => "ehh",
  519. ":$" => "ashamed",
  520. ":applause:" => "applause",
  521. ":grin:" => "biggrin",
  522. ":rolleyes:" => "rolleyes",
  523. ":whistle:" => "whistle",
  524. "(A)" => "angel"
  525. );
  526. foreach($smileys AS $key => $val){
  527. $replace = "<img src=\"IMG/smileys/".$val.".gif\" alt=\"\">";
  528. $in = str_ireplace($key, $replace, $in);
  529. }
  530. return $in;
  531. }
  532.  
  533. function stripper($stringvar){
  534. if (1 == get_magic_quotes_gpc()){
  535. $stringvar = stripslashes($stringvar);
  536. }
  537. return $stringvar;
  538. }
  539.  
  540.  
  541. function mkList($name, $checked = 0, $notviewed = array()){
  542.  
  543. global $famID;
  544.  
  545. $sql = mysqli_query($con, "SELECT `speldata`.`id`, `username` FROM `speldata` LEFT JOIN `users` ON `users`.`id`=`speldata`.`id` WHERE `speldata`.`familie_id`=".$famID) or die( mysqli_error($con));
  546.  
  547. $r = "<select name='".$name."'>";
  548.  
  549. while($res = mysqli_fetch_assoc($sql)){
  550.  
  551. if(!in_array($res['id'], $notviewed)){
  552.  
  553. $r .= "<option value='".$res['id']."'";
  554. if($res['id'] == $checked){
  555. $r .= " selected='selected'";
  556. }
  557. $r .= ">".$res['username']."</option>";
  558. }
  559.  
  560. }
  561.  
  562. $r .= "</select>";
  563.  
  564. return $r;
  565.  
  566. }
  567.  
  568. function fmList($name){
  569.  
  570. global $famID;
  571.  
  572. $sql = mysqli_query($con, "SELECT `speldata`.`id`, `username`, `lastclick`, `leven` FROM `speldata` LEFT JOIN `users` ON `users`.`id`=`speldata`.`id` WHERE `speldata`.`familie_id`=".$famID) or die( mysqli_error($con));
  573.  
  574. $r = "<select name='".$name."'>";
  575.  
  576. while($res = mysqli_fetch_assoc($sql)){
  577.  
  578. if($famID != 0 || ($famID == 0 && $res['id'] == ID)){
  579. $r .= "<option value='".$res['id']."'";
  580.  
  581. if($res['lastclick'] > (time() - 900)){
  582. $r .= " class='done'";
  583. }elseif($res['lastclick'] < (time() - 900)){
  584. $r .= " class='hurtList'";
  585. }
  586.  
  587. $r .= ">".$res['username']."</option>";
  588. }
  589.  
  590. }
  591.  
  592. $r .= "</select>";
  593.  
  594. return $r;
  595.  
  596. }
  597.  
  598. function mkHopsitalList(){
  599.  
  600. global $famID;
  601.  
  602. $sql = mysqli_query($con, "SELECT `speldata`.`id`, `username`, `leven` FROM `speldata` LEFT JOIN `users` ON `users`.`id`=`speldata`.`id` WHERE `speldata`.`familie_id`=".$famID) or die( mysqli_error($con));
  603.  
  604. $r = "<select name='hospital'>";
  605.  
  606. while($res = mysqli_fetch_assoc($sql)){
  607.  
  608. if($famID != 0 || ($famID == 0 && $res['id'] == ID)){
  609. $r .= "<option value='".$res['id']."'";
  610.  
  611. if($res['leven'] < 100){
  612. $r .= " class='hurtList'";
  613. }
  614.  
  615. if($res['id'] == ID){
  616. $r .= " selected='selected'";
  617. }
  618. $r .= ">".$res['username']."</option>";
  619. }
  620.  
  621. }
  622.  
  623. $r .= "</select>";
  624.  
  625. return $r;
  626.  
  627. }
  628.  
  629. function dieplayer($id){
  630. mysqli_query($con, "UPDATE `speldata` SET `leven`=0, `count_hoeren`=0 WHERE `id`=".$id) or die( mysqli_error($con));
  631. $s = mysqli_query($con, "SELECT `bankmoney`, `familie_id` FROM `speldata` WHERE `id`=".$id) or die( mysqli_error($con));
  632. $r = mysqli_fetch_assoc($s);
  633. $sql = mysqli_query($con, "SELECT `testament_type`, `testament_val` FROM `status` WHERE `id`=".$id) or die( mysqli_error($con));
  634. $res = mysqli_fetch_assoc($sql);
  635. if($res['testament_type'] == 0){
  636. if($res['testament_val'] != 0){
  637. mysqli_query($con, "UPDATE `speldata` SET `bankmoney`=`bankmoney`+".round($r['bankmoney'] / 2, 0)." WHERE `id`=".$res['testament_val']) or die( mysqli_error($con));
  638. $bericht = "Je hebt het testament van <b>".getname($id)."</b> ontvangen ter waarde van <b>\$".number_format(round($r['bankmoney'] / 2, 0))."!</b><br><br>";
  639.  
  640. mysqli_query($con, "INSERT INTO `berichten`(`verzender_id`, `ontvanger_id`, `bericht`, `date`)
  641. VALUES
  642. (-1, ".$res['testament_val'].", '".$bericht."', NOW() )") or die( mysqli_error($con));
  643. }
  644. } else {
  645. if($r['familie_id'] != 0){
  646. mysqli_query($con, "UPDATE `familie` SET `geld`=`geld`+".round($r['bankmoney'] / 2, 0)." WHERE `id`=".$r['familie_id']) or die( mysqli_error($con));
  647. }
  648. }
  649.  
  650. mysqli_query($con, "UPDATE `markt_alg` SET `bieder`=0, `high_bod`=`bied_bod` WHERE `bieder`=".$id) or die( mysqli_error($con));
  651. $sql = mysqli_query($con, "SELECT `bieder`, `high_bod`, `type`, `count` FROM `markt_alg` WHERE `user_id`=".$id) or die( mysqli_error($con));
  652. while($res = mysqli_fetch_assoc($sql)){
  653. mysqli_query($con, "UPDATE `speldata` SET `bankmoney`=`bankmoney`+".$res['high_bod']." WHERE `id`=".$res['bieder']) or die( mysqli_error($con));
  654. if($res['type'] == 2){
  655. mysqli_query($con, "UPDATE `speldata` SET `eerpunten`=`eerpunten`+".$res['count']." WHERE `id`=".$id) or die( mysqli_error($con));
  656. }
  657. }
  658. mysqli_query($con, "DELETE FROM `markt_alg` WHERE `user_id`=".$id) or die( mysqli_error($con));
  659. mysqli_query($con, "UPDATE `kf` SET `owner`=0 WHERE `owner`=".$id) or die( mysqli_error($con));
  660. mysqli_query($con, "UPDATE `rld` SET `owner`=0 WHERE `owner`=".$id) or die( mysqli_error($con));
  661. mysqli_query($con, "UPDATE `bezit` SET `owner`=0 WHERE `owner`=".$id) or die( mysqli_error($con));
  662. mysqli_query($con, "DELETE FROM `sportschool` WHERE `starter_id`=".$id);
  663. }
  664.  
  665.  
  666. function getname($id){
  667.  
  668. $sql = mysqli_query($con, "SELECT `username` FROM `users` WHERE `id`=".(int)$id) or die( mysqli_error($con));
  669. if( mysqli_num_rows($sql) == 0){
  670. return false;
  671. } else {
  672. $res = mysqli_fetch_assoc($sql);
  673. return $res['username'];
  674. }
  675. }
  676.  
  677. function getid($name){
  678.  
  679. $sql = mysqli_query($con, "SELECT `id` FROM `users` WHERE `username`='".mr($name)."' LIMIT 1") or die( mysqli_error($con));
  680. if( mysqli_num_rows($sql) == 0){
  681. return false;
  682. } else {
  683. $res = mysqli_fetch_assoc($sql);
  684. return $res['id'];
  685. }
  686. }
  687. function getidd($newfamname){
  688.  
  689. $sql = mysqli_query($con, "SELECT `id` FROM `familie` WHERE `naam`='".mr($newfamname)."' LIMIT 1") or die( mysqli_error($con));
  690. if( mysqli_num_rows($sql) == 0){
  691. return false;
  692. } else {
  693. $res = mysqli_fetch_assoc($sql);
  694. return $res['id'];
  695. }
  696. }
  697.  
  698. function getAvatar($id){
  699.  
  700. $sql = mysqli_query($con, "SELECT `avatar` FROM `profiel` WHERE `id`=".(int)$id) or die( mysqli_error($con));
  701. if( mysqli_num_rows($sql) == 0){
  702. return false;
  703. } else {
  704. $res = mysqli_fetch_assoc($sql);
  705. return $res['avatar'];
  706. }
  707. }
  708.  
  709. function write($bestand, $schrijf){
  710. $file = fopen($bestand, "w");
  711. fputs($file, $schrijf); // wegschrijven in bestand
  712. fclose($file); // sluit bestandsverbinding
  713. }
  714.  
  715.  
  716. function email($sendFrom, $sendFromName, $message, $css, $sendTo, $ow){
  717.  
  718. $headers = "From: \"".$sendFromName."\" <".$sendFrom.">\r\n";
  719. $headers .= "return-Path: Mail-Error <".$sendFrom.">\n";
  720. $headers .= "MIME-Version: 1.0\n";
  721. $headers .= "Content-Transfer-Encoding: 8bit\n";
  722. $headers .= "Content-type: text/html; charset=iso-8859-1\n";
  723.  
  724. $bericht = '<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
  725. <html>
  726. <head>'.$css.'
  727. </head>
  728.  
  729. <body>';
  730. $bericht .= $message;
  731.  
  732. $bericht .= "</body></html>";
  733.  
  734.  
  735. if(mail($sendTo, $ow, $bericht, $headers)) {
  736. return TRUE;
  737. } else {
  738. return FALSE;
  739. }
  740.  
  741. }
  742.  
  743.  
  744. function getowner($bezit, $land){
  745. $sql = mysqli_query($con, "SELECT `owner` FROM `bezit` WHERE `bezit_id`=".$bezit." AND `land_id`=".$land." LIMIT 1") or die( mysqli_error($con));
  746. $res = mysqli_fetch_assoc($sql);
  747. if($res['owner'] == 0){
  748. return false;
  749. } else {
  750. return $res['owner'];
  751. }
  752. }
  753.  
  754.  
  755. function getFamPoses($bezit, $famID){
  756.  
  757. if($famID == 0){
  758. return (int) 0;
  759. } else {
  760. if($bezit > 1){
  761. $sql = mysqli_query($con, "SELECT `bezit_id`, `familie_id` FROM `bezit`
  762. LEFT JOIN `speldata` ON (`speldata`.`id`=`bezit`.`owner`)
  763. WHERE `familie_id`=".$famID." AND `bezit_id`=".$bezit." LIMIT 2") or die( mysqli_error($con));
  764. } elseif($bezit == 0){
  765. $sql = mysqli_query($con, "SELECT `familie_id` FROM `kf`
  766. LEFT JOIN `speldata` ON (`speldata`.`id`=`kf`.`owner`)
  767. WHERE `familie_id`=".$famID." LIMIT 2") or die( mysqli_error($con));
  768. } elseif($bezit == 1){
  769. $sql = mysqli_query($con, "SELECT `familie_id` FROM `rld`
  770. LEFT JOIN `speldata` ON (`speldata`.`id`=`rld`.`owner`)
  771. WHERE `familie_id`=".$famID." LIMIT 2") or die( mysqli_error($con));
  772. }
  773.  
  774. $total = mysqli_num_rows($sql);
  775.  
  776. $sql = mysqli_query($con, "SELECT `bezit_id` , `familie_id`
  777. FROM `markt_bezit`
  778. LEFT JOIN `speldata` ON ( `speldata`.`id` = `markt_bezit`.`bieder` )
  779. WHERE `familie_id` =".$famID." AND `bezit_id`=".$bezit."
  780. LIMIT 2") or die( mysqli_error($con));
  781. $total += mysqli_num_rows($sql);
  782.  
  783. return $total;
  784.  
  785. }
  786. }
  787.  
  788.  
  789.  
  790. function hasPoses($bezit, $speler = 0){
  791. if($speler == 0){
  792. $speler = ID;
  793. }
  794.  
  795. $sql = mysqli_query($con, "SELECT `bezit_id` FROM `markt_bezit` WHERE `bieder`=".$speler." AND `bezit_id`=".$bezit." LIMIT 1") or die( mysqli_error($con));
  796. $total = mysqli_num_rows($sql);
  797. if($bezit > 1){
  798. $sql = mysqli_query($con, "SELECT `bezit_id` FROM `bezit` WHERE `owner`=".$speler." AND `bezit_id`=".$bezit." LIMIT 1") or die( mysqli_error($con));
  799. } elseif($bezit == 0){
  800. $sql = mysqli_query($con, "SELECT `land_id` FROM `kf` WHERE `owner`=".$speler." LIMIT 1") or die( mysqli_error($con));
  801. } elseif($bezit == 1){
  802. $sql = mysqli_query($con, "SELECT `land_id` FROM `rld` WHERE `owner`=".$speler." LIMIT 1") or die( mysqli_error($con));
  803. }
  804. $total += mysqli_num_rows($sql);
  805. return $total;
  806. }
  807.  
  808. function getFam($id){
  809. $sql = mysqli_query($con, "SELECT `familie_id` FROM `speldata` WHERE `id`=".(int) $id) or die( mysqli_error($con));
  810. $res = mysqli_fetch_assoc($sql);
  811. if($res['familie_id'] == 0){
  812. return false;
  813. } else {
  814. return $res['familie_id'];
  815. }
  816. }
  817.  
  818. function getFamname($id){
  819. $familie_id = $res['familie_id'];
  820. $sql = mysqli_query($con, "SELECT `familie_id` FROM `speldata` WHERE `id`=".(int) $id) or die( mysqli_error($con));
  821. $res = mysqli_fetch_assoc($sql);
  822. $query = mysqli_query($con, "SELECT `naam` FROM `familie` WHERE `id`='$familie_id'");
  823. $info = mysqli_fetch_assoc($query);
  824. return $info['naam'];
  825. }
  826.  
  827. function getFamid($id){
  828. $query = mysqli_query($con, "SELECT id FROM familie WHERE naam='$id'");
  829. $info = mysqli_fetch_object($query);
  830. return $info->id;
  831. }
  832.  
  833. function isFamForumMod($id, $fam){
  834. $sql = mysqli_query($con, "SELECT `forummod` FROM `familie` WHERE `id`=".(int) $fam) or die( mysqli_error($con));
  835. $res = mysqli_fetch_assoc($sql);
  836. if($res['forummod'] != $id){
  837. return false;
  838. } else {
  839. return $res['forummod'];
  840. }
  841. }
  842. function isExtraFamForumMod($id, $fam){
  843. $sql = mysqli_query($con, "SELECT `forummod2` FROM `familie` WHERE `id`=".(int) $fam) or die( mysqli_error($con));
  844. $res = mysqli_fetch_assoc($sql);
  845. if($res['forummod2'] != $id){
  846. return false;
  847. } else {
  848. return $res['forummod2'];
  849. }
  850. }
  851. function isFamBaas($id, $fam){
  852. $sql = mysqli_query($con, "SELECT `baas_id` FROM `familie` WHERE `id`=".(int) $fam) or die( mysqli_error($con));
  853. $res = mysqli_fetch_assoc($sql);
  854. if($res['baas_id'] != $id){
  855. return false;
  856. } else {
  857. return $res['baas_id'];
  858. }
  859. }
  860.  
  861. function hasBescherming($id = 0){
  862. if($id == 0){
  863. $id = ID;
  864. }
  865. $s = mysqli_query($con, "SELECT `bescherming` FROM `status` WHERE `id`=".$id) or die( mysqli_error($con));
  866. $r = mysqli_fetch_assoc($s);
  867. $bescherming = $r['bescherming'];
  868.  
  869. $s = mysqli_query($con, "SELECT `registerDate` FROM `users` WHERE `id`=".$id) or die( mysqli_error($con));
  870. $r = mysqli_fetch_assoc($s);
  871. $rTime = strtotime($r['registerDate']);
  872. $rDiff = time() - $rTime;
  873.  
  874. if($rDiff < (60*60*24*2) && $bescherming == 0){
  875. return true;
  876. } else {
  877. return false;
  878. }
  879. }
  880.  
  881. function getStatus($id){
  882. $sql = mysqli_query($con, "SELECT `status` FROM `status` WHERE `id`=".$id) or die( mysqli_error($con));
  883. $res = mysqli_fetch_assoc($sql);
  884. return $res['status'];
  885. }
  886.  
  887. function warn($who, $reden){
  888. $sql = mysqli_query($con, "SELECT `warns`, `status`, `donateur` FROM `status` WHERE `id`=".$who) or die( mysqli_error($con));
  889. $res = mysqli_fetch_assoc($sql);
  890. if(($res['warns'] + 1) >= 3 && $res['donateur'] == 0 && $res['status'] <= 1){
  891. setWarn($who, $reden);
  892. ban($who, 'Genoeg gewaarschuwd');
  893. } elseif(($res['warns'] + 1) >= 4 && $res['donateur'] > 0 && $res['status'] <= 1){
  894. setWarn($who, $reden);
  895. ban($who, 'Genoeg gewaarschuwd');
  896. } else {
  897. setWarn($who, $reden);
  898. }
  899. return true;
  900. }
  901.  
  902. function setWarn($who, $reden){
  903.  
  904. $bericht = "Je hebt een waarschuwing ontvangen met de volgende reden:
  905. <br><br>
  906. <b>". mysqli_real_escape_string($reden)."</b>
  907. <br><br>
  908. Premium leden, VIP\'s en donateurs worden na 4 waarschuwingen automatisch verbannen, gewone leden na 3 waarschuwingen!
  909. <br><br>
  910. Met vriendelijke groet,<br>
  911. CrimeClub Team<br><br>";
  912.  
  913.  
  914. mysqli_query($con, "INSERT INTO `berichten`(`verzender_id`, `ontvanger_id`, `bericht`, `date`)
  915. VALUES
  916. (-2, ".$who.", '".$bericht."', NOW() )") or die( mysqli_error($con));
  917.  
  918. mysqli_query($con, "UPDATE `status` SET `warns`=`warns`+1 WHERE `id`=".$who) or die( mysqli_error($con));
  919. mysqli_query($con, "INSERT INTO `warns`(`id`, `date`, `reden`, `gever`) VALUES (".$who.", NOW(), '".mr($reden)."', ".ID.")") or die( mysqli_error($con));
  920. return true;
  921. }
  922.  
  923. function ban($who, $reden){
  924. if(getStatus($who) > 1){
  925. return false;
  926. } else {
  927.  
  928. $sql = mysqli_query($con, "SELECT `ip` FROM `users` WHERE `id`=".$who) or die( mysqli_error($con));
  929. $res = mysqli_fetch_assoc($sql);
  930.  
  931. mysqli_query($con, "INSERT INTo `ip_banned` (`ip`) VALUES ('".$res['ip']."')") or die( mysqli_error($con));
  932. mysqli_query($con, "UPDATE `status` SET `status`=0 WHERE `id`=".$who) or die( mysqli_error($con));
  933. mysqli_query($con, "UPDATE `speldata` SET `eerpunten`=0, `count_hoeren`=0, `hoeren_straat`=0 WHERE `id`=".$who) or die( mysqli_error($con));
  934. mysqli_query($con, "INSERT INTO `bans`(`id`, `reden`, `date`,`gever`) VALUES (".$who.", '".mr($reden)."', NOW(), ".ID.")")
  935. or die( mysqli_error($con));
  936. dieplayer($who);
  937. cname($who, getname($who), false, true);
  938.  
  939. }
  940. }
  941.  
  942. function unban($who, $reden){
  943. if(getStatus($who) == 1){
  944. return false;
  945. } else {
  946.  
  947. $sql = mysqli_query($con, "SELECT `ip` FROM `users` WHERE `id`=".$who) or die( mysqli_error($con));
  948. $res = mysqli_fetch_assoc($sql);
  949.  
  950. mysqli_query($con, "DELETE FROM `ip_banned` WHERE `ip`='".$res['ip']."' ") or die( mysqli_error($con));
  951. mysqli_query($con, "UPDATE `status` SET `status`=1 WHERE `id`=".$who) or die( mysqli_error($con));
  952. mysqli_query($con, "UPDATE `users` SET `pass`='dac207e7c19108188646dbfb24efeb13', `email`='' WHERE `id`=".$who) or die( mysqli_error($con));
  953. mysqli_query($con, "DELETE FROM `bans` WHERE `id`=".$who) or die( mysqli_error($con));
  954. dieplayer($who);
  955. cname($who, getname($who), false, true);
  956.  
  957. }
  958. }
  959.  
  960. function Forumwarn($who, $reden){
  961. $sql = mysqli_query($con, "SELECT `forum_warns`, `status`, `donateur` FROM `status` WHERE `id`=".$who) or die( mysqli_error($con));
  962. $res = mysqli_fetch_assoc($sql);
  963. if(($res['forum_warns'] + 1) >= 3 && $res['donateur'] == 0 && $res['status'] <= 1){
  964. ForumsetWarn($who, $reden);
  965. forumban($who, 'Genoeg gewaarschuwd');
  966. } elseif(($res['forum_warns'] + 1) >= 4 && $res['donateur'] > 0 && $res['status'] <= 1){
  967. ForumsetWarn($who, $reden);
  968. forumban($who, 'Genoeg gewaarschuwd');
  969. } else {
  970. ForumsetWarn($who, $reden);
  971. }
  972. return true;
  973. }
  974.  
  975. function ForumsetWarn($who, $reden){
  976.  
  977. $bericht = "Je hebt een forum waarschuwing ontvangen met de volgende reden:
  978. <br><br>
  979. <b>". mysqli_real_escape_string($reden)."</b>
  980. <br><br>
  981. Premium leden, VIP\'s en donateurs worden na 4 waarschuwingen krijgen automatisch een forum ban, gewone leden na 3 waarschuwingen!
  982. <br><br>
  983. Met vriendelijke groet,<br>
  984. CrimeClub Team<br><br>";
  985.  
  986.  
  987. mysqli_query($con, "INSERT INTO `berichten`(`verzender_id`, `ontvanger_id`, `bericht`, `date`)
  988. VALUES
  989. (-7, ".$who.", '".$bericht."', NOW() )") or die( mysqli_error($con));
  990.  
  991. mysqli_query($con, "UPDATE `status` SET `forum_warns`=`forum_warns`+1 WHERE `id`=".$who) or die( mysqli_error($con));
  992. mysqli_query($con, "INSERT INTO `forum_warns`(`id`, `date`, `reden`, `gever`) VALUES (".$who.", NOW(), '".mr($reden)."', ".ID.")") or die( mysqli_error($con));
  993. return true;
  994. }
  995.  
  996. function meldTopic($tid, $reden){
  997. $tid = (int) $tid;
  998. $TSql = mysqli_query($con, "SELECT `starter_id`, `bericht_parsed` FROM `frm_topics` WHERE `id`=".$tid);
  999. $rSql = mysqli_fetch_assoc($TSql);
  1000. $StartID = $rSql['starter_id'];
  1001. $MsG = $rSql['bericht_parsed'];
  1002. $type2 = 2;
  1003. mysqli_query($con, "INSERT INTO `frm_meld`(`id`, `melder`, `bericht`, `reden`, `type`, `date`) VALUES (".$StartID.", ".ID.", ".$tid.", '".mr($reden)."', '".$type2."', NOW() )") or die( mysqli_error($con));
  1004. return true;
  1005. }
  1006.  
  1007. function meldMsg($rid, $reden){
  1008. $rid = (int) $rid;
  1009. $MSql = mysqli_query($con, "SELECT `reactor`, `bericht_parsed` FROM `frm_reacties` WHERE `id`=".$rid);
  1010. $rMSql = mysqli_fetch_assoc($MSql);
  1011. $ReactID = $rMSql['reactor'];
  1012. $RMsG = $rMSql['bericht_parsed'];
  1013. $type1 = 1;
  1014. mysqli_query($con, "INSERT INTO `frm_meld`(`id`, `melder`, `bericht`, `reden`, `type`, `date`) VALUES ('".$ReactID."', '".ID."', '".$rid."', '".$reden."', '".$type1."', NOW() )") or die( mysqli_error($con));
  1015. return true;
  1016. }
  1017.  
  1018. function forumban($who, $reden){
  1019. if(getStatus($who) > 1){
  1020. return false;
  1021. } else {
  1022.  
  1023. $sql = mysqli_query($con, "SELECT `ip` FROM `users` WHERE `id`=".$who) or die( mysqli_error($con));
  1024. $res = mysqli_fetch_assoc($sql);
  1025.  
  1026. mysqli_query($con, "INSERT INTO `forum_ban`(`id`, `reden`, `date`,`gever`) VALUES (".$who.", '".mr($reden)."', NOW(), ".ID.")")
  1027. or die( mysqli_error($con));
  1028. dieplayer($who);
  1029. cname($who, getname($who), false, true);
  1030.  
  1031. }
  1032. }
  1033.  
  1034. function forumdelete($who, $reden){
  1035. if(getStatus($who) > 1){
  1036. return false;
  1037. } else {
  1038.  
  1039. $sql = mysqli_query($con, "SELECT `ip` FROM `users` WHERE `id`=".$who) or die( mysqli_error($con));
  1040. $res = mysqli_fetch_assoc($sql);
  1041.  
  1042. mysqli_query($con, "INSERT INTO `forum_ban`(`id`, `reden`, `date`,`gever`) VALUES (".$who.", '".mr($reden)."', NOW(), ".ID.")")
  1043. or die( mysqli_error($con));
  1044. mysqli_query($con, "DELETE FROM `frm_reacties` WHERE `reactor`=".$who) or die( mysqli_error($con));
  1045. mysqli_query($con, "DELETE FROM `frm_topics` WHERE `starter_id`=".$who) or die( mysqli_error($con));
  1046. mysqli_query($con, "UPDATE `userstats` SET `posts`=0 WHERE `id`=".$who) or die( mysqli_error($con));
  1047. dieplayer($who);
  1048. cname($who, getname($who), false, true);
  1049.  
  1050. }
  1051. }
  1052.  
  1053.  
  1054. function hasBlocked($you, $him){
  1055. $s = mysqli_query($con, "SELECT COUNT(`id`) FROM `vrienden_blokkeren` WHERE `id`=".(int)$him." AND `type`=1 AND `who`=".(int)$you) or die( mysqli_error($con));
  1056. if( mysqli_result($s, 0) >= 1){
  1057. return true;
  1058. } else {
  1059. return false;
  1060. }
  1061. }
  1062.  
  1063.  
  1064. function getScore($id){
  1065. $sql = mysqli_query($con, "SELECT `score` FROM `speldata` WHERE `id`=".(int)$id) or die( mysqli_error($con));
  1066. $res = mysqli_fetch_assoc($sql);
  1067. $s = mysqli_query($con, "SELECT COUNT(`id`) FROM `speldata` WHERE `score`>".$res['score']) or die( mysqli_error($con));
  1068. return ( mysqli_result($s, 0) + 1);
  1069. }
  1070.  
  1071. function getLeven($id, $fam){
  1072. $sql = mysqli_query($con, "SELECT `leven` FROM `speldata` WHERE `familie_id`=".$fam." AND `id`=".$id) or die( mysqli_error($con));
  1073. $res = mysqli_fetch_assoc($sql);
  1074. return $res['leven'];
  1075. }
  1076.  
  1077.  
  1078. function ami($waarde) {
  1079. $waarde = mysqli_real_escape_string($waarde);
  1080. $waarde = addslashes($waarde);
  1081.  
  1082. return $waarde;
  1083. }
  1084.  
  1085. function mkFamOvervalList($name){
  1086. global $famID;
  1087. $sql = mysqli_query($con, "SELECT `speldata`.`id`, `username` FROM `speldata` LEFT JOIN `users` ON `users`.`id`=`speldata`.`id` WHERE `speldata`.`familie_id`=".$famID) or die( mysqli_error($con));
  1088. $r = "<select name='".$name."'>";
  1089. while($res = mysqli_fetch_assoc($sql)){
  1090. $sSql = mysqli_query($con, "SELECT COUNT(*) FROM `usertimes` WHERE `id`=".$res['id']." AND `fam_overvallen`<".time()) or die( mysqli_error($con));
  1091. $ssSql = mysqli_query($con, "
  1092. SELECT COUNT(*) FROM `fam_overvallen`
  1093. WHERE
  1094. `starter_id`=".$res['id']."
  1095. OR
  1096. (`chauffeur`=".$res['id']." AND `status1`!=2)
  1097. OR
  1098. (`bomexpert`=".$res['id']." AND `status2`!=2)
  1099. OR
  1100. (`wapenspc`=".$res['id']." AND `status3`!=2)
  1101. ") or die( mysqli_error($con));
  1102. if( mysqli_result($sSql, 0) == 1 && mysqli_result($ssSql, 0) == 0 && ID != $res['id']){
  1103. $s = mysqli_query($con, "SELECT COUNT(*) FROM `users` WHERE `lastclick`>".(time() - 300)." AND `id`=".$res['id']) or die( mysqli_error($con));
  1104. $r .= "<option value='".$res['id']."'";
  1105. if( mysqli_result($s, 0) == 1){
  1106. $r .= ' class="done"';
  1107. }
  1108. $r .= ">".$res['username']."</option>";
  1109. }
  1110. }
  1111. $r .= "</select>";
  1112. return $r;
  1113. }
  1114.  
  1115. function isValidOvervaller($overvaller){
  1116. global $famID;
  1117. if(!ctype_digit($overvaller)){
  1118. return false;
  1119. } else {
  1120. $sSql = mysqli_query($con, "SELECT COUNT(*) FROM `usertimes` WHERE `id`=".$overvaller." AND `fam_overvallen`<".time()) or die( mysqli_error($con));
  1121. $sql = mysqli_query($con, "SELECT COUNT(*) FROM `fam_overvallen`
  1122. WHERE
  1123. `starter_id`=".$overvaller."
  1124. OR
  1125. (`chauffeur`=".$overvaller." AND `status1`!=2)
  1126. OR
  1127. (`bomexpert`=".$overvaller." AND `status2`!=2)
  1128. OR
  1129. (`wapenspc`=".$overvaller." AND `status3`!=2)") or die( mysqli_error($con));
  1130. $famSql = mysqli_query($con, "SELECT COUNT(*) FROM `speldata` WHERE `familie_id`=".$famID." AND `id`=".$overvaller) or die( mysqli_error($con));
  1131. if( mysqli_result($sql, 0) >= 1){
  1132. return false;
  1133. } elseif( mysqli_result($sSql, 0) == 0){
  1134. return false;
  1135. } elseif( mysqli_result($famSql, 0) == 0){
  1136. return false;
  1137. } else {
  1138. return true;
  1139. }
  1140. }
  1141. }
  1142.  
  1143. function addBankMoney($money, $id, $min = false){
  1144. if(!ctype_digit($money) || !ctype_digit($id)){
  1145. return false;
  1146. } else {
  1147. if($min === true){
  1148. mysqli_query($con, "UPDATE `speldata` SET `bankmoney`=`bankmoney`-".mr($money)." WHERE `id`=".mr($id)) or die( mysqli_error($con));
  1149. } else {
  1150. mysqli_query($con, "UPDATE `speldata` SET `bankmoney`=`bankmoney`+".mr($money)." WHERE `id`=".mr($id)) or die( mysqli_error($con));
  1151. }
  1152. return true;
  1153. }
  1154. }
  1155.  
  1156. function addCashMoney($money, $id, $min = false){
  1157. if(!ctype_digit($money) || !ctype_digit($id)){
  1158. return false;
  1159. } else {
  1160. if($min === true){
  1161. mysqli_query($con, "UPDATE `speldata` SET `cashmoney`=`cashmoney`-".mr($money)." WHERE `id`=".mr($id)) or die( mysqli_error($con));
  1162. } else {
  1163. mysqli_query($con, "UPDATE `speldata` SET `cashmoney`=`cashmoney`+".mr($money)." WHERE `id`=".mr($id)) or die( mysqli_error($con));
  1164. }
  1165. return true;
  1166. }
  1167. }
  1168.  
  1169. function isValidRaceCar($car, $user){
  1170. if(!ctype_digit($car)){
  1171. return false;
  1172. } else {
  1173. $sSql = mysqli_query($con, "SELECT COUNT(*) FROM `racecars` WHERE `user_id`=".$user." AND `id`=".$car) or die( mysqli_error($con));
  1174. if( mysqli_result($sSql, 0) == 0){
  1175. return false;
  1176. } else {
  1177. return true;
  1178. }
  1179. }
  1180. }
  1181.  
  1182. function getRaceCars($id){
  1183. $sql = mysqli_query($con, "SELECT `car_id`,`racecars`.`id`, `naam` FROM `racecars` LEFT JOIN `cars` ON `cars`.`id`=`racecars`.`car_id` WHERE `user_id`=".$id) or die( mysqli_error($con));
  1184. $cars = array();
  1185. while($res = mysqli_fetch_assoc($sql)){
  1186. $cars[$res['id']] = array(
  1187. 'name' => $res['naam'],
  1188. 'car_id' => $res['car_id']
  1189. );
  1190. }
  1191. return $cars;
  1192. }
  1193.  
  1194. function getRaceCarName($id){
  1195. if(!ctype_digit($id)){
  1196. return false;
  1197. } else {
  1198. $sql = mysqli_query($con, "SELECT `naam` FROM `cars` LEFT JOIN `racecars` ON `racecars`.`car_id`=`cars`.`id` WHERE `racecars`.`id`=".$id) or die( mysqli_error($con));
  1199. if( mysqli_num_rows($sql) == 0){
  1200. return false;
  1201. } else {
  1202. $res = mysqli_fetch_assoc($sql);
  1203. return $res['naam'];
  1204. }
  1205. }
  1206. }
  1207.  
  1208. function getCarScores($car, $user){
  1209. $data = array(
  1210. 'snelheid' => 0,
  1211. 'acceleratie' => 0,
  1212. 'wegligging' => 0
  1213. );
  1214. if(!ctype_digit($car)){
  1215. return $data;
  1216. } else {
  1217. $sSql = mysqli_query($con, "SELECT `car_id` FROM `racecars` WHERE `user_id`=".$user." AND `id`=".$car) or die( mysqli_error($con));
  1218. if( mysqli_num_rows($sSql) == 0){
  1219. return $data;
  1220. } else {
  1221. $res = mysqli_fetch_assoc($sSql);
  1222. $sql = mysqli_query($con, "SELECT `acceleratie`,`snelheid`, `wegligging` FROM `racecars` WHERE `id`=".$res['car_id']) or die( mysqli_error($con));
  1223. return mysqli_fetch_assoc($sql);
  1224. }
  1225. }
  1226. }
  1227.  
  1228. function parseYouTube($url){
  1229. //http://www.youtube.com/watch?v=7g-nzG6ooWw
  1230. $yt = "http://www.youtube.com/v/";
  1231. $s = explode("watch?v=", $url);
  1232. if(count($s) != 2){
  1233. return false;
  1234. } else {
  1235. return $yt.$s[1].'&hl=nl&fs=1';
  1236. }
  1237. }
  1238.  
  1239. function getDonations($id){
  1240. $sql = mysqli_query($con, "SELECT `donateur` FROM `status` WHERE `id`=".$id) or die( mysqli_error($con));
  1241. $res = mysqli_fetch_assoc($sql);
  1242. return $res['donateur'];
  1243. }
  1244. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!