[HOW-TO] Make 'Newest Champions' clickable

If you want to get the game name in the 'Newest Champions' field clickable (as a link), than you have to modify only two lines in the arcade.php

Demo

Find:

PHP Code:

$DB->query("SELECT c.*, g.gcat, cat.password FROM ibf_games_champs AS c, ibf_games_list AS g, ibf_games_cats AS cat WHERE c.champ_gid=g.gid AND g.gcat=cat.c_id AND g.active=1 AND trim(password)='' ORDER BY champ_date DESC LIMIT 0,5"); 

Replace with:

PHP Code:

$DB->query("SELECT DISTINCT c.*, g.gcat, g.gid, cat.password FROM ibf_games_champs AS c, ibf_games_list AS g, ibf_games_cats AS cat WHERE c.champ_gid=g.gid AND g.gcat=cat.c_id AND g.active=1 AND trim(password)='' ORDER BY champ_date DESC LIMIT 0,5"); 

Find:

PHP Code:

$row['text'] = preg_replace("/<% GAMENAME %>/i", $row['champ_gtitle'] , $row['text'] ); 

Replace with:

PHP Code:

$row['text'] = preg_replace("/<% GAMENAME %>/i", '<a href="arcade.php?do=play&gameid=' . $row['gid'] . '" title="' . $row['champ_gtitle'] . '">' . $row['champ_gtitle'] . '</a>' , $row['text'] ); 

Enjoy

[Sharp Intellect]

this is a cool mod, but isn't working for me. All games are linking to /arcade.php?do=play&gameid=

Please help. Thanks!

[GreasySpoon]

Sorry, my fault. I've missed the second line in our arcade.php

It was to early in the morning

See the first post, i have added the second line.

[Sharp Intellect]

beautiful. Thank you.

[stangger5]

Hey GreasySpoon ,,,check out my arcade ..

I added the game images to the Newest Champions and Latest Arcade Score..

[GreasySpoon]

Hi stangger5,

really not bad. Good job.

Greets

[erjavid]

Thank you