mirror of
https://github.com/psenough/pouet.net.git
synced 2025-01-16 12:49:42 +01:00
115 lines
3.4 KiB
PHP
115 lines
3.4 KiB
PHP
<?
|
|
require("include/top.php");
|
|
|
|
unset($submitok);
|
|
// check the submitted data
|
|
if($csdbflag)
|
|
{
|
|
// check user account
|
|
if(!$_SESSION["SESSION"]||!$_SESSION["SCENEID"])
|
|
$errormessage[]="you need to be logged in first.";
|
|
// check if this prod exists
|
|
$query = "SELECT count(0) FROM groups WHERE id=".$which;
|
|
$result = mysql_query($query);
|
|
if(!mysql_result($result,0))
|
|
$errormessage[] = "This group has been lobstercized long ago (\/) -_- (\/) *clack clack clack*";
|
|
// check if csdb for this prod already exists
|
|
$query = "SELECT csdb FROM groups WHERE id=".$which;
|
|
$result = mysql_query($query);
|
|
if(mysql_result($result,0)>0)
|
|
$errormessage[] = "csdb for this group already exists (\/) O_o (\/)";
|
|
|
|
// if everything is ok
|
|
if(!$errormessage)
|
|
$submitok=true;
|
|
}
|
|
|
|
if($submitok){
|
|
$query ="update groups set csdb=".((int)$csdbflag)." where id=".$which;
|
|
mysql_query($query);
|
|
}
|
|
|
|
?>
|
|
<br>
|
|
<form action="submitgroupcsdb.php" method="post" enctype="multipart/form-data">
|
|
<INPUT TYPE="hidden" name="MAX_FILE_SIZE" value="65536">
|
|
<table bgcolor="#000000" cellspacing="1" cellpadding="0"><tr><td>
|
|
<table bgcolor="#000000" cellspacing="1" cellpadding="2">
|
|
<? if($submitok): ?>
|
|
<tr><th bgcolor="#224488">csdb id for group submited</th></tr>
|
|
<tr>
|
|
<td bgcolor="#446688" align="center">
|
|
<!--feel free to add another one<br>-->
|
|
<a href="groups.php?which=<? print($which); ?>">see what you've done</a><br>
|
|
</td>
|
|
</tr>
|
|
<? endif; ?>
|
|
<? if($errormessage): ?>
|
|
<tr><th bgcolor="#224488">errors found</th></tr>
|
|
<? for($i=0;$i<count($errormessage);$i++): ?>
|
|
<? if($i%2): ?>
|
|
<tr><td bgcolor="#557799"> <b>- <font color="#FF8888"><? print($errormessage[$i]); ?></font></b></td></tr>
|
|
<? else: ?>
|
|
<tr><td bgcolor="#446688"> <b>- <font color="#FF8888"><? print($errormessage[$i]); ?></font></b></td></tr>
|
|
<? endif; ?>
|
|
<? endfor; ?>
|
|
<? endif; ?>
|
|
<? if(!$submitok): ?>
|
|
<tr>
|
|
<th bgcolor="#224488">group information</th>
|
|
</tr>
|
|
<tr>
|
|
<td bgcolor="#446688">
|
|
<table>
|
|
<tr>
|
|
<? if($which):
|
|
$query="SELECT name FROM groups WHERE id=".$which;
|
|
$result=mysql_query($query);
|
|
$prod_name=mysql_result($result,0);
|
|
?>
|
|
<input type="hidden" name="which" value="<?=$which?>">
|
|
<td>prod:</td>
|
|
<td valign="bottom">
|
|
<a href="group.php?which=<?=$which?>"><?=$prod_name?></a>
|
|
</td>
|
|
<? else:
|
|
// build the form
|
|
$query="SELECT distinct groups.id,groups.name FROM groups,prods where groups.csdb=0 and (prods.group1=groups.id or prods.group2=groups.id) and prods.platform='Commodore 64' ORDER BY groups.name";
|
|
$result=mysql_query($query);
|
|
while($tmp=mysql_fetch_array($result)) {
|
|
$prods[]=$tmp;
|
|
}
|
|
?>
|
|
<td>select the group you want<br>to add csdb id for:</td>
|
|
<td valign="bottom">
|
|
<select name="which">
|
|
<? for($i=1;$i<count($prods);$i++): ?>
|
|
<?
|
|
if($which==$prods[$i]["id"]) {
|
|
$is_selected = " selected";
|
|
} else {
|
|
$is_selected = "";
|
|
}
|
|
?>
|
|
<option value="<? print($prods[$i]["id"]); ?>"<? print($is_selected); ?>><? print($prods[$i]["name"]); ?></option>
|
|
<? endfor; ?>
|
|
</select>
|
|
</td>
|
|
<? endif; ?>
|
|
</tr>
|
|
<tr>
|
|
<td>csdb id:</td>
|
|
<td><input type="text" name="csdbflag" value="<? print($csdbflag); ?>"><br></td>
|
|
</tr>
|
|
</table>
|
|
</td>
|
|
</tr>
|
|
<tr>
|
|
<td bgcolor="#224488" align="right"><input type="image" src="gfx/submit.gif" style="border: 0px"></td>
|
|
</tr>
|
|
<? endif; ?>
|
|
</table>
|
|
</td></tr></table>
|
|
</form>
|
|
<? require("include/bottom.php"); ?>
|