<? function haveChests($user_id) { $db = Elfi::getInstanse(); $count = $db->count("SELECT `id` FROM `chests_user` WHERE `user_id`=%d",[$user_id]); return $count; } function getChests($user_id) { $db = Elfi::getInstanse(); $data = $db->query("SELECT * FROM `chests_user` WHERE `user_id`=%d",[$user_id]); $data =  mysql_fetch_assoc($data); return $data; } function getChestInfo($chest_id) { $db = Elfi::getInstanse(); $data = $db->fetch("SELECT * FROM `chests` WHERE `id`=%d",[$chest_id]); return $data; } function giveChest($user_id,$chest_id) { $db = Elfi::getInstanse(); if ($db->query("INSERT INTO `chests_user` SET `user_id`=%d,`chest_id`=%d,`time`=%d",[$user_id,$chest_id,time()])) { return true; } return false; } function canOpenThis($id,$user_id) { $db = Elfi::getInstanse(); if ($db->count("SELECT `id` FROM `chests_user` WHERE `id`=%d and `user_id`=%d",[$id,$user_id]) == 1) { return true; } return false; } function openThis($id,$user_id) { $myChest = mysql_fetch_assoc(mysql_query("SELECT * FROM `chests_user` WHERE `id`='".$id."' and `user_id`='".$user_id."'")); $chest = mysql_fetch_assoc(mysql_query("SELECT * FROM `chests` WHERE `id`='".$myChest['chest_id']."'")); if($chest) { switch ($chest['type']) { case 'legendary': $rewards = ['sapfyr','izumrud','gold','topaz','rubyn','almaz']; $rand =  $rewards[mt_rand(0,count($rewards)-1)]; if ($rand == 'sapfyr') { $reward = 'sapfyr'; $pc = mt_rand(1000,3000); }   else if ($rand == 'izumrud') { $reward = 'izumrud'; $pc = mt_rand(1000,3000); } else if ($rand == 'gold') { $reward = 'gold'; $pc = mt_rand(1000,3000); } else if ($rand == 'topaz') { reward = 'topaz'; $pc = mt_rand(1000,3000); } else if ($rand == 'rubyn') { $reward = 'rubyn'; $pc = mt_rand(1000,3000); } else if ($rand == 'almaz') { $reward = 'almaz'; $pc = mt_rand(1000,3000); } mysql_query("UPDATE `user` SET ".$reward."=".$reward."+'$pc' WHERE `id`='".$user_id."'"); $r = ['reward'=>'<img src ="/images/icon/res/'.$reward.'.png">','pc'=>$pc]; eleteChest($id); return $r; break; } } } function deleteChest($id) { mysql_query("DELETE FROM `chests_user` WHERE `id`='".$id."'"); return true; }