dear sergey please try to find another solution to find and display the related games because on my server due to an specific query at line 26 in block_related.php the game page is taking about 1 minute to show. that query is:
$query = 'SELECT g.*, r.*, COUNT(*) AS cnt FROM ' . $cMain['dbPrefix'] . 'games AS g, ' . $cMain['dbPrefix'] .
'related AS r WHERE r.ip IN (SELECT DISTINCT ip FROM ' . $cMain['dbPrefix'] . 'related WHERE g.active=1 AND game_id=' . $gameID .
') AND g.id=r.game_id AND g.id<>' . $gameID . ' GROUP BY r.game_id ORDER BY cnt DESC LIMIT ' . $cB["RELATED"]["max"];
i like the related block but it cannot be used in this way ... logs from mysql started with --log-slow-queries:
# Time: 090225 0:47:26
# Query_time: 14 Lock_time: 0 Rows_sent: 5 Rows_examined: 29562
SELECT g.*, r.*, COUNT(*) AS cnt FROM pas_games AS g, pas_related AS r WHERE r.ip IN (SELECT DISTINCT ip FROM pas_related WHERE g.active=1 AND game_id=299) AND g.id=r.game_id AND g.id<>299 GROUP BY r.game_id ORDER BY cnt DESC LIMIT 5;
