Please complete your profile before you add a game. | '.
boxfoot());
include("../inc/apodfoot2.php");
exit;
}
//==========================================================
//=== DISPLAY SAVE GAME ====================================
//==========================================================
if(isset($_POST['apodgameadd']) && $_POST['apodgameadd']=="yes"){
$result=mysql_query("select data_id from ap_game_data where url='".$_POST['url']."'",$db);
if( ($rs=mysql_fetch_array($result)) ){ $data_id=$rs['data_id']; }
mysql_free_result($result);
//==========================================================
if(isset($data_id)){
print(boxhead('Game Already Exist',1,"90%").
'
'.$_POST['url'].'
already exist.
[manage your games]
|
'.
boxfoot());
}
else{
//==========================================================
$z3d=0;
$zmulti=0;
$attr=0;
$filesize=$_POST['fmfilesize'];
if(isset($_POST['fmz3d']) && $_POST['fmz3d']=="on")$z3d=1;
if(isset($_POST['fmzmulti']) && $_POST['fmzmulti']=="on")$zmulti=1;
if(isset($_POST['fmkey']) && $_POST['fmkey']=="on")$attr+=1000;
if(isset($_POST['fmmou']) && $_POST['fmmou']=="on")$attr+=100;
if(isset($_POST['fmsnd']) && $_POST['fmsnd']=="on")$attr+=10;
if(isset($_POST['fmmus']) && $_POST['fmmus']=="on")$attr+=1;
if($filesize=="")$filesize="0";
$result=mysql_query("select (max(data_id)+1) as new_id from ap_game_data",$db);
if( ($rs=mysql_fetch_array($result)) ){ $data_id=$rs['new_id']; }
mysql_free_result($result);
mysql_query("insert into ap_game_data (title,url,url_bk,des,des_ctrl,keywords,cat_id,format_id,filesize,attributes,z3d,zmulti,create_mem_id,member_id,data_id,hit_dt,created_dt,created_ip) values(".
"'".str_replace("'","'",strip_tags(trim($_POST['title'])))."'".
",'".strip_tags(trim($_POST['url']))."'".
",'".strip_tags(trim($_POST['url']))."'".
",'".str_replace("'","'",strip_tags(trim($_POST['des'])))."'".
",'".str_replace("'","'",strip_tags(trim($_POST['des_ctrl'])))."'".
",'".str_replace("'","'",strip_tags(trim($_POST['keywords'])))."'".
",".$_POST['cat_id'].
",".$_POST['format_id'].
",".$filesize.
",".$attr.
",".$z3d.
",".$zmulti.
",".$gbUserID.
",".$gbUserID.
",".$data_id.
",now()".
",now()".
",'".$_SERVER['REMOTE_ADDR']."'".
")",$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 Added',1,"90%").
'
Thank you
'.$_POST['title'].' has been added.
[edit] [manage your games]
|
'.
boxfoot());
//==========================================================
}
}
//==========================================================
//=== DISPLAY EDIT GAME ====================================
//==========================================================
else{
print(boxhead('Add New Game',2,"90%"));
?>