0) { $result_row = mysql_fetch_assoc($get_result_dbh); $search_params = unserialize($result_row['parameters']); } } else { foreach($_REQUEST as $key => $value) { // Reels if($key == "slot_reels" && $value > 0) { $search_params['slot_reels'] = $value; } // Tags if(substr($key, 0, 3) == "tag" && $value > 0) { $search_params['tags'][] = $value; } // Features if(substr($key, 0, 4) == "feat" && $value == "on") { list($j, $feat) = explode("_", $key); $search_params['feat'][] = $feat; } } } // compile a query.. $get_slot_sql = "SELECT SQL_CALC_FOUND_ROWS s.*, COALESCE((SELECT value FROM feature_values WHERE feature_id = 22 AND entity_id = s.id), 3) as rating FROM slot as s WHERE s.status = 'active' "; if(isset($search_params['slot_reels'])) { $get_slot_sql .= "AND reels = " . addslashes($search_params['slot_reels']) . " "; $searchcrumb[] = $search_params['slot_reels'] . " reels"; } if(isset($search_params['tags']) && count($search_params['tags']) > 0) { foreach($search_params['tags'] as $tag) { $get_slot_sql .= "AND s.id IN (SELECT entity_id FROM entity_tags WHERE tag_id = " . addslashes($tag) . ") "; // Get tag name for the bread crumb $get_tagname_sql = "SELECT t.name, tc.name FROM tags as t INNER JOIN tag_cloud as tc ON t.cloud_id = tc.id WHERE t.id = " . addslashes($tag); $get_tagname_dbh = mysql_query($get_tagname_sql); list($tagname, $cloudname) = mysql_fetch_row($get_tagname_dbh); $searchcrumb[] = "the " . $tagname . " " . $cloudname; } } if(isset($search_params['feat']) && count($search_params['feat']) > 0) { foreach($search_params['feat'] as $feat) { switch($feat) { case "freespins": $feature = "Free Spins"; break; case "bonus": $feature = "Bonus Game(s)"; break; case "playmoney": $feature = "Fun Money"; break; case "autospin": $feature = "Auto Spin"; break; case "nodl": $feature = "No Download"; break; } $searchcrumb[] = "the " . $feature . " feature"; $get_slot_sql .= "AND s.id IN ( SELECT fv.entity_id FROM feature_keys as fk INNER JOIN feature_values as fv ON fv.feature_id = fk.id WHERE fk.entity_type = 'slot' AND fk.name = '" . $feature . "' AND fv.value = 1) "; } } $get_slot_sql .= "ORDER BY rating DESC LIMIT " . ($pg * $limit) . ", " . $limit; $get_slot_dbh = mysql_query($get_slot_sql); $number_of_results = mysql_num_rows($get_slot_dbh); $num_results_sql = "SELECT FOUND_ROWS()"; $num_results_dbh = mysql_query($num_results_sql); list($number_of_results) = mysql_fetch_row($num_results_dbh); $search_description = ""; if(count($searchcrumb) > 0) { $search_description = "with "; $end = array_pop($searchcrumb); if(count($searchcrumb) > 0) { $search_description .= join(", ", $searchcrumb) . " and "; } $search_description .= $end; } // Add query $add_search_sql = "INSERT INTO search_results(description, parameters, number_found, created, checksum) "; $add_search_sql .= "VALUES ('" . addslashes($search_description) . "', '" . serialize($search_params) . "', " . $number_of_results . ", now(), '" . md5(serialize($search_params)) . "') "; $add_search_sql .= "ON DUPLICATE KEY update created = now(), number_found = " . $number_of_results; $add_search_dbh = mysql_query($add_search_sql); $search_id = mysql_insert_id(); ?> Online Slots List - Online Slots with <?=$search_description?> - SlotsOnline.com

Found slots

= 4) { for($i = 0; $i < 3; $i++) { $currentResult['default'] = new Slot(mysql_fetch_assoc($get_slot_dbh)); ?>

> Slot

Review coming soon


0) { ?>
Slot Preview Slot Name Reels Free Spins Bonus Game Review Play Now
">
Read Review
);" class="search-play">Play!

Refine Search