define('IN_PHPBB', true); $phpbb_root_path = '../forums/'; include($phpbb_root_path . 'extension.inc'); include($phpbb_root_path . 'common.'.$phpEx); $userdata = session_pagestart($user_ip, PAGE_INDEX); init_userprefs($userdata); $currenteditor=($userdata['username']); $id = $_GET['id']; mb_http_input("windows-1252"); mb_http_output("windows-1252"); include 'config.php'; mysql_connect($dbhost,$dbuser,$dbpasswd); mysql_select_db($dbname) or die( " :Unable to select database"); $i=0; $query="SELECT * FROM games WHERE dunique = $id"; $result=mysql_query($query); $title=mysql_result($result,0,"dtitle1"); $number=mysql_result($result,0,"dnumber"); $manu=mysql_result($result,0,"dmanuafcturer"); $cost=mysql_result($result,0,"dcost"); $collecting=mysql_result($result,0,"dcollecting"); $playing=mysql_result($result,0,"ddescription"); $frontimage=mysql_result($result,0,"dfrontimage"); $cartpath=mysql_result($result,0,"dlabelimage"); $backpath=mysql_result($result,0,"dbackpath"); $seed=mysql_result($result,0,"dvariants"); $author=mysql_result($result,0,"dauthor"); $cheats=mysql_result($result,0,"dcheats"); $boxtype=mysql_result($result,0,"dboxtype"); $released=mysql_result($result,0,"dreleased"); $carttype=mysql_result($result,0,"dcarttype"); $frequency=mysql_result($result,0,"dfrequency"); $romsize=mysql_result($result,0,"dromsize"); $region=mysql_result($result,0,"dregion"); $instructions=mysql_result($result,0,"dinstructions"); $catagory=mysql_result($result,0,"dcatagory"); $imagespan=mysql_result($result,0,"imagespan"); $query=" SELECT * FROM games WHERE dvariants = $seed"; $result=mysql_query($query); $num=mysql_numrows($result); //START OF HTML LAYOUT ?>
Front |
Cart |
Other |
|||||
Unique database ID : | Number Of Variants: | ||||||
Release Date: | Product Number: | ||||||
Author: | Value £ | ||||||
Box Type : | Binary Rom Size : | ||||||
Label Type : | Release Region : | ||||||
Catagory : | Rarity : | ||||||
Edit This Record |
Variations |
//START OF VARIANTS TABLES $query=" SELECT * FROM games WHERE dvariants = $seed"; $result=mysql_query($query); $num=mysql_numrows($result); while ($i < $num){ $unique=mysql_result($result,$i,"dunique"); $title=mysql_result($result,$i,"dtitle1"); $number=mysql_result($result,$i,"dnumber"); $manu=mysql_result($result,$i,"dmanuafcturer"); $cost=mysql_result($result,$i,"dcost"); $collecting=mysql_result($result,$i,"dcollecting"); $playing=mysql_result($result,$i,"ddescription"); $frontimage=mysql_result($result,$i,"dfrontimage"); $cartpath=mysql_result($result,$i,"dlabelimage"); $backpath=mysql_result($result,$i,"dbackpath"); $region=mysql_result($result,$i,"dregion"); $author=mysql_result($result,$i,"dauthor"); $cheats=mysql_result($result,$i,"dcheats"); $boxtype=mysql_result($result,$i,"dboxtype"); $released=mysql_result($result,$i,"dreleased"); $carttype=mysql_result($result,$i,"dcarttype"); $cheats=mysql_result($result,$i,"dcheats"); $frequency=mysql_result($result,$i,"dfrequency"); $romsize=mysql_result($result,$i,"dromsize"); ?>
|