[Shakes & Fidget] FIX - Bugowanie grzybów i złota

    case $ACT_GAMBLE:
        
        // bet {silver, shrooms}
        
        $bet = explode(';', $action_extra);
        
        
        
        // get data
        
        $qry = $db->prepare("SELECT *, 

				(

					SELECT Count(*) FROM messages WHERE messages.read = 0 AND messages.reciver_id = user_id

				) AS c, (

				    SELECT Count(*) + 1 FROM user_data WHERE user_data.honor > (

				        SELECT honor FROM user_data WHERE ssid = :ssid

				    )

				) AS rank2 

				 FROM user_data WHERE ssid = :ssid2");
        
        $qry->bindParam(':ssid', $SSID);
        
        $qry->bindParam(':ssid2', $SSID);
        
        $qry->execute();
        
        
        
        $db_data = $qry->fetchAll();
        
        $db_data = $db_data[0];
        
        
        
        $qry = $db->prepare("SELECT pos

FROM (

SELECT honor, lvl, user_name, ssid, user_id, @r:[email protected]<script data-cfhash='f9e31' type="text/javascript">/*  */</script>+1 as pos

FROM user_data, (select @r:=0) r0

ORDER BY honor DESC, lvl DESC, user_id DESC)  user_data_ordered WHERE ssid = :ssid");
        
        $qry->bindParam(':ssid', $SSID);
        
        $qry->execute();
        
        
        
        $pos = $qry->fetchAll();
        
        $db_data['rank'] = $pos[0][0];
        
        
        
        if ($bet[0] > $db_data['silver']) {
            
            break;
            
        }
        
        if ($bet[1] > $db_data['mushroom']) {
            
            break;
            
        }
		
		if ($bet[0] < 0 OR $bet[1] < 0) {
			break;
		}
		
        
        
        
        $qry = $db->prepare("SELECT value FROM game_settings WHERE setting = 'GAMBLER' LIMIT 1");
        
        $qry->execute();
        
        $res = $qry->fetchAll(PDO::FETCH_ASSOC);
        
        $ccc = $res[0]['value'];
        
        
        
        $r = mt_rand(0, 100);
        
        
        
        if ($r < $ccc) {
            
            $db_data['silver'] += $bet[0];
            
            $db_data['mushroom'] += $bet[1];
            
        }
        
        else {
            
            $db_data['silver'] -= $bet[0];
            
            $db_data['mushroom'] -= $bet[1];
            
        }
        
        
        
        $qry = $db->prepare("UPDATE user_data SET 

				silver = :silver, 

				mushroom = :shroom 

				WHERE ssid = :ssid");
        
        $qry->bindParam(':silver', $db_data['silver']);
        
        $qry->bindParam(':shroom', $db_data['mushroom']);
        
        $qry->bindParam(':ssid', $SSID);
        
        $qry->execute();
        
        
        
        loadDefaultData($db_data);
        
        
        
        // 168 win || 169 lose
        
        if ($r < $ccc) {
            
            $ret[0] = "168" . $ret[0];
            
        }
        
        else {
            
            $ret[0] = "169" . $ret[0];
            
        }
        
        
        
        break;