Hello everyone, i must say from the start i'm not good with php but i try to learn. Hope this forum can give me the answer.
I'm trying to build a site using a free script AVAarcade, like most game scripts it's using IDs to generate the pages.
example : www.website.tld/view/12345/the-game-i-play/
What i want is to get rid of the IDs and replace them with a slug.
What i have done, i created a new column for my database next to "name" and "id" called "slug" and writed the description for that game.
example :
name: The Game I Play
slug: the-game-i-play
id: 12345
Now the problem is that i can call the script to use the slug insted of the ID.
Let's take a file : /modules/popular.php
It has the following content and displays the most popular games:
<?
##
# AV ARCADE v3
# popular.php
# Loads the most popular games/media module
##
$sql = mysql_query("SELECT * FROM ava_games WHERE published=1 ORDER BY hits desc LIMIT 10");
while($row = mysql_fetch_array($sql))
{
$abcd= $row['name'];
$abcd = str_replace (" ", "-", $abcd);
if ($seo_on == 0)
{
$url = 'index.php?task=view&id='.$row['id'].'';
}
else
{
$url = 'view/'.$row['id'].'/'.$abcd.'/';
}
echo ' <a href="'.$site_url.'/'.$url.'">'.$row['name'].'</a><br>';
}
?>
I changed the code like this to use the slug not the id like this but doesn't work:
<?
##
# AV ARCADE v3
# popular.php
# Loads the most popular games/media module
##
$slug = intval($_GET['slug']);
$sql = mysql_query("SELECT * FROM ava_games WHERE slug=".$slug."");
while($row = mysql_fetch_array($sql))
{
if ($seo_on == 0)
{
$url = 'index.php?task=view&slug='.$row['slug'].'';
}
else
{
$url = 'view/'.$slug.'';
}
echo ' <a href="'.$site_url.'/'.$url.'">'.$row['name'].'</a><br>';
}
?>
Also i changed added this line in .htaccess but can make it work :queasy:
RewriteRule view/([0-9a-zA-Z?-]+) index.php?task=view&id=$1&name=$2 [L]
Can someone bring the light in this issue ? i want to make the script take the slug from my databese and create the new game page, with the url like this www.website.tld/view/the-game-i-play/.
P.S. the AVarcade version is 4.
