url_bk and data_id=".$data_id,$db);
if( ($result = mysql_query("select d.data_id,d.title,d.des,d.url,m.*,c.cat_name,f.format_name from ap_".$tbname."_data d,ap_members m,ap_".$tbname."_cat c,ref_format f".
" where d.member_id=m.member_id and d.cat_id=c.cat_id and d.format_id=f.format_id and d.data_id=".$data_id)) ){
if( ($row= mysql_fetch_array($result)) ){
$tstr=$row['name_last'].$row['name_middle'].$row['name_first'].$row['cp_name'].$row['cat_name'].$row['format_name'].$row['title'].$row['des'].$row['url'];
if($row['website']!=$row['cp_website'])
$tstr.=$row['website'].$row['cp_website'];
else
$tstr.=$row['website'];
$aname=$row['name_first'];
if($row['name_last']!="")$aname.=" ".$row['name_last'];
mysql_query("update ap_".$tbname."_data set author_name='".$aname."',author_url='".$row['website']."',author_cp_name='".$row['cp_name']."',author_cp_url='".$row['cp_website']."',search='".$tstr."' where data_id=".$row['data_id']);
}
mysql_free_result($result);
}
print(boxhead('Game Updated',1,"90%").
'
Thank you
This game has been saved.
[edit] [manage your games]
|
'.
boxfoot());
}
//==========================================================
//=== DISPLAY EDIT GAME ====================================
//==========================================================
else{
$data_id=$_GET['id'];
$chk_key=array(4);
$chk_key[0]="";
$chk_key[1]="";
$chk_key[2]="";
$chk_key[3]="";
$chk_z3d="";
$chk_zmulti="";
if($data_id!=""){
print(boxhead('Edit Game',2,"90%"));
$result=mysql_query("select * from ap_game_data where data_id=".$data_id,$db);
if( ($rs=mysql_fetch_array($result)) ){
if($rs['z3d']<>0)$chk_z3d=" checked";
if($rs['zmulti']<>0)$chk_zmulti=" checked";
$attr=bindec(strval($rs['attributes']));
if(($attr&0x01)!=0)$chk_key[3]=" checked";
if(($attr&0x02)!=0)$chk_key[2]=" checked";
if(($attr&0x04)!=0)$chk_key[1]=" checked";
if(($attr&0x08)!=0)$chk_key[0]=" checked";
?>
GAME ID NOT FOUND
| ");
}
print(boxfoot());
mysql_free_result($result);
}
else print('
NO ID GIVEN');
//==========================================================
//=== DISPLAY EDIT GAME END ================================
//==========================================================
}
mysql_close($db);
require("../inc/apodfoot_noad.php");
?>