[HowTo] ibProArcade - Make 'Newest Champions' clickable

cRs!MP — Sun, 05 Sep 2010 22:02:18 GMT

ibProArcade -
Make 'Newest Champions' clickable

Original.:

with Game Link.:

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.!

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.:

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.:

PHP Code:


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

..finished.!

+++++++++++++++++

greetings, cRs!MP :running:

[HowTo] ibProArcade - More than one Random Game

cRs!MP — Sun, 05 Sep 2010 21:45:20 GMT

For ibProArcade 2.6.X....

expand it to Random Games from 1 to x.!

in the file "arcade" - "functions" - "randomgame.php"..

Find.:

Code:

$DB->query("SELECT g.gid, g.gtitle, g.gname, g.gcat, cat.password, cat.active FROM ibf_games_list AS g, ibf_games_cats AS cat WHERE g.active=1 AND cat.active=1 AND g.gcat=cat.c_id AND trim(password)='' ORDER BY RAND() LIMIT 1");

The Red "1" is the Number of Random Games, this number you have
to change, change for five Random Games on five.!

Example, for five Random Games.:

Code:

$DB->query("SELECT g.gid, g.gtitle, g.gname, g.gcat, cat.password, cat.active FROM ibf_games_list AS g, ibf_games_cats AS cat WHERE g.active=1 AND cat.active=1 AND g.gcat=cat.c_id AND trim(password)='' ORDER BY RAND() LIMIT 5");

---------------------

greeting, cRs!MP :rolleyes:

vBulletin Modifications - vBulletin Modification Tutorials

[HowTo] ibProArcade - Make 'Newest Champions' clickable

[HowTo] ibProArcade - More than one Random Game