This is a required update to Kirby for upgrading from AvArcade Pro v5.3.+ to v5.4.+

This is a minor update fixing the seo issue with the Popular, Newest and Random games.


Step 1 Popular Games Fix
Step 2 Newest Games Fix
Step 3 Random Games Fix

##########################################
##########################################

Step 1 - Go to /templates/kirby/cyano_mods/popular_games.php and replace all of it's contents with:

<?php
echo '<ul>';
$sql = mysql_query("SELECT * FROM ava_games WHERE published=1 ORDER BY hits desc LIMIT 5");
while($row = mysql_fetch_array($sql)) {

	$url = GameUrl($row['id'], $row['seo_url'], $row['category_id']);
		
	$name = shortenStr($row['name'], $template['module_max_chars']);

	$description = shortenStr($row['description'], 50);

	$game['rating'] = GenerateRating($row['rating'], 'homepage');
	
	if ($setting['module_thumbs'] == 1) {
		$image_url = GameImageUrl($row['image'], $row['import'], $row['url']);
		$image = '<img alt="'.$name.'" src="'.$image_url.'" width= 60 height= 60 style="vertical-align: middle; float: left;" /> ';
	}
	else {
		$image = '';
	}
	
	echo '<li><a href="'.$url.'" title="'.$name.'">'.$image.'</a><div class="pop_games_info"><a href="'.$url.'">'.$name.'</a><br />'.$description.'<br />'.$game['rating'].' | '.$row['hits'].' '.GAME_PLAYS.'</div><div class="clear"></div></li>';
}
echo '</ul>';
?>

##########################################
##########################################

Step 2 - Go to /templates/kirby/cyano_mods/newest_games.php and replace all of it's contents with:

<?php
$sql = mysql_query("SELECT * FROM ava_games WHERE published=1 ORDER BY id desc LIMIT 10");
while($row = mysql_fetch_array($sql)) {
	
	$url = GameUrl($row['id'], $row['seo_url'], $row['category_id']);
	
	$name = shortenStr($row['name'], $template['module_max_chars']);
	
	if ($setting['module_thumbs'] == 1) {
		$image_url = GameImageUrl($row['image'], $row['import'], $row['url']);
		$image = '<img alt="'.$name.'" src="'.$image_url.'" width= 100 height= 90 class="newest_games_thumb" /> ';
	}
	else {
		$image = '';
	}
	
	echo '<a href="'.$url.'" title="'.$name.'">'.$image.'</a>';
}
?>

##########################################
##########################################

Step 3 - Go to /templates/kirby/cyano_mods/random_games.php and replace all of it's contents with:

<?php
echo '<ul>';
$sql = mysql_query("SELECT * FROM ava_games WHERE published=1 ORDER BY rand() desc LIMIT 12");
while($row = mysql_fetch_array($sql)) {
	
	$url = GameUrl($row['id'], $row['seo_url'], $row['category_id']);
		
	$name = shortenStr($row['name'], 20);

	$description = shortenStr($row['description'], 34);

	$game['rating'] = GenerateRating($row['rating'], 'homepage');
	
	if ($setting['module_thumbs'] == 1) {
		$image_url = GameImageUrl($row['image'], $row['import'], $row['url']);
		$image = '<img alt="'.$name.'" src="'.$image_url.'" width= 60 height= 60 style="vertical-align: middle; float: left;" /> ';
	}
	else {
		$image = '';
	}
	
	echo '<li><a href="'.$url.'" title="'.$name.'">'.$image.'</a><div class="random_games_info"><a href="'.$url.'">'.$name.'</a><br />'.$description.'<br />'.$game['rating'].' | '.$row['hits'].' '.GAME_PLAYS.'</div><div class="clear"></div></li>';
}
echo '</ul>';
?>

##########################################
##########################################

Step 4 - Go to /templates/kirby/cyano_mods/links.php and replace all of it's contents with:

<?php
echo '<ul>';
$sql = mysql_query("SELECT * FROM ava_links WHERE sitewide=1 AND published=1 ORDER BY id desc");

while ($row = mysql_fetch_array($sql))
	echo '<li><a href="'.$row['url'].'">'.htmlspecialchars($row['name']).'</a></li>';

if ($setting['seo_on'] == 0) {
	echo '<li><a href="'.$setting['site_url'].'/index.php?task=links">'.MORELINKS.' >></a></li>';
}
else {
	echo '<li><a href="'.$setting['site_url'].'/links'.$setting['seo_extension'].'">'.MORELINKS.' >></a></li>';

echo '</ul>';
}
?>

##########################################
##########################################


If any other issues come up, contact me at sales@cyanographics.com

-Mike
CyanoGraphics.com