<?php // // try{  $BaseConnect = new PDO("mysql:host=localhost;dbname=какие-то",'непонятные','символы'); }  catch(PDOException $e){  die('Нет соединения с базой данных!');    }  $BaseConnect->exec("set names utf8");  //  //фильтрация текста  function checking($text) {  $text = trim(htmlspecialchars($text));  return $text;  }  //фильтрация цифр  function number($num) {  $num = abs(intval($num));  return $num;  }  //  //Для обычного запроса  function cnt($sql, $params = array()) {      global $BaseConnect;  $stmt = $BaseConnect -> prepare($sql);      $stmt -> execute($params);      $stmt = $stmt->rowCount();      return $stmt;  }  //  //Работаем с базой данных  function qry($sql, $params = array()) {  global $BaseConnect;  $stmt = $BaseConnect -> prepare($sql);      $stmt -> execute($params);      return $stmt;  }   //  //Для вывода ассоциотивного массива   function fch($sql, $params = array()) {      global $BaseConnect;      $stmt = $BaseConnect -> prepare($sql);      $stmt -> execute($params);      $stmt = $stmt->fetch();      return $stmt;  }   // // qry("UPDATE `users` SET `key2` = ?, `sun2` = ?", array(0,0));  //обновляем ключи и редкий сундук  // // $m1 = fch("SELECT * FROM `users` WHERE `tour` >= ? ORDER BY `tour` DESC LIMIT 1", array(1));  // // if($m1['tour'] >= 1){ // // $coll1 = intval($m1['tour']*30/300); // // if($m1){ qry("UPDATE `users` SET `gold` = `gold` + ?, `premium` = ?, `premium_time` = `premium_time` + ? WHERE `id` = ? LIMIT 1", array($coll1-50,2,86400*5-10800,$m1['id']));  } // // $m2 = fch("SELECT * FROM `users` WHERE `tour` <= ? AND `id` != ? ORDER BY `tour` DESC LIMIT 1", array($m1['tour'],$m1['id']));  // // $coll2 = intval($m2['tour']*30/300); // // if($m2){ qry("UPDATE `users` SET `gold` = `gold` + ?, `premium` = ?, `premium_time` = `premium_time` + ? WHERE `id` = ? LIMIT 1", array($coll2-50,2,86400*3-10800,$m2['id']));  } // // $m3 = fch("SELECT * FROM `users` WHERE `tour` <= ? AND `id` != ? AND `id` != ? ORDER BY `tour` DESC LIMIT 1", array($m2['tour'],$m1['id'],$m2['id'])); // // $coll3 = intval($m3['tour']*30/300); // // if($m3){ qry("UPDATE `users` SET `gold` = `gold` + ?, `premium` = ?, `premium_time` = `premium_time` + ? WHERE `id` = ? LIMIT 1", array($coll3-50,2,86400*1-10800,$m3['id']));  }  // // $m4 = fch("SELECT * FROM `users` WHERE `tour` <= ? AND `id` != ? AND `id` != ? AND `id` != ? ORDER BY `tour` DESC LIMIT 1", array($m3['tour'],$m1['id'],$m2['id'],$m3['id']));  // // $coll4 = intval($m4['tour']*30/300); // // if($m4){ qry("UPDATE `users` SET `gold` = `gold` + ? WHERE `id` = ? LIMIT 1", array($coll4-50,$m4['id']));  } // // $m5 = fch("SELECT * FROM `users` WHERE `tour` <= ? AND `id` != ? AND `id` != ? AND `id` != ? AND `id` != ? ORDER BY `tour` DESC LIMIT 1", array($m4['tour'],$m1['id'],$m2['id'],$m3['id'],$m4['id']));  // // $coll5 = intval($m5['tour']*30/300); // // if($m5){ qry("UPDATE `users` SET `gold` = `gold` + ? WHERE `id` = ? LIMIT 1", array($coll5-50,$m5['id']));  } // // $m6 = fch("SELECT * FROM `users` WHERE `tour` <= ? AND `id` != ? AND `id` != ? AND `id` != ? AND `id` != ?  AND `id` != ? ORDER BY `tour` DESC LIMIT 1", array($m5['tour'],$m1['id'],$m2['id'],$m3['id'],$m4['id'],$m5['id']));  // // $coll6 = intval($m6['tour']*30/300); // // if($m6){ qry("UPDATE `users` SET `gold` = `gold` + ? WHERE `id` = ? LIMIT 1", array($coll6-50,$m6['id']));  } // // $m7 = fch("SELECT * FROM `users` WHERE `tour` <= ? AND `id` != ? AND `id` != ? AND `id` != ? AND `id` != ? AND `id` != ?  AND `id` != ? ORDER BY `tour` DESC LIMIT 1", array($m6['tour'],$m1['id'],$m2['id'],$m3['id'],$m4['id'],$m5['id'],$m6['id']));  // // $coll7 = intval($m7['tour']*30/300); // // if($m7){ qry("UPDATE `users` SET `gold` = `gold` + ? WHERE `id` = ? LIMIT 1", array($coll7-50,$m7['id']));  } // // $m8 = fch("SELECT * FROM `users` WHERE `tour` <= ? AND `id` != ? AND `id` != ? AND `id` != ? AND `id` != ? AND `id` != ?  AND `id` != ? AND `id` != ? ORDER BY `tour` DESC LIMIT 1", array($m7['tour'],$m1['id'],$m2['id'],$m3['id'],$m4['id'],$m5['id'],$m6['id'],$m7['id']));  // // $coll8 = intval($m8['tour']*30/300); // // if($m8){ qry("UPDATE `users` SET `gold` = `gold` + ? WHERE `id` = ? LIMIT 1", array($coll8-50,$m8['id']));  } // // $m9 = fch("SELECT * FROM `users` WHERE `tour` <= ? AND `id` != ? AND `id` != ? AND `id` != ? AND `id` != ? AND `id` != ?  AND `id` != ? AND `id` != ?  AND `id` != ? ORDER BY `tour` DESC LIMIT 1", array($m8['tour'],$m1['id'],$m2['id'],$m3['id'],$m4['id'],$m5['id'],$m6['id'],$m7['id'],$m8['id']));  // // $coll9 = intval($m8['tour']*30/300); // // if($m9){ qry("UPDATE `users` SET `gold` = `gold` + ? WHERE `id` = ? LIMIT 1", array($coll9-50,$m9['id']));  } // // $m10 = fch("SELECT * FROM `users` WHERE `tour` <= ? AND `id` != ? AND `id` != ? AND `id` != ? AND `id` != ? AND `id` != ?  AND `id` != ? AND `id` != ? AND `id` != ? AND `id` != ? ORDER BY `tour` DESC LIMIT 1", array($m9['tour'],$m1['id'],$m2['id'],$m3['id'],$m4['id'],$m5['id'],$m6['id'],$m7['id'],$m8['id'],$m9['id']));  // // $coll10 = intval($m10['tour']*30/300); // // if($m10){ qry("UPDATE `users` SET `gold` = `gold` + ? WHERE `id` = ? LIMIT 1", array($coll10-50,$m10['id']));  } // // $text = "Подведены итоги турнира: