<? 
 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; 
 }