Code: Select all
<?php
<?
include "include_fns.php";
if(!$userdata['session_logged_in']) { // checks if user is logged in
header("Location: forum/login.php?redirect=../submit.php");
exit;
}
include "header.php";
if (!isset($submit)) {
?>
<script type="text/javascript" language="JavaScript" src="sub_popup.js"></script>
<!--Content Top-->
<table bgcolor="#FFFFFF" border=0 cellspacing=0 cellpadding=5 width=100%>
<form enctype="multipart/form-data" action="submit.php" method="post">
<tr>
<td bgcolor=#000000 colspan=2><font size=2 color=#FFFFFF><b>Game Entry</b></font></td>
</tr>
<tr>
<td bgcolor=#FFFFFF colspan=2>To add a new rpg to the database please enter information in the fields below. Use commas for multiple information in a field. Please note required fields are noted with a * .</td>
</tr>
<tr>
<td> <b>Game Name:</b></td>
<td><input type=text name=game_name maxlength=100 size=30>*<br></td>
</tr>
<tr>
<td> <b>Box Art Front:</b></td>
<td><input type="file" name="box_front" size="30"> <font size=-2><a href="javascript:popUp('refs/uploads.html')"><b>Uploading Guidelines</b></a></font></td>
</tr>
<tr>
<td> <b>Box Art Back:</b></td>
<td><input type="file" name="box_back" size="30"></td>
</tr>
<tr>
<td> <b>Platform (s):</b></td>
<td><input type=text name=platform maxlength=100 size=30>* <font size=-2><a href="javascript:popUp('refs/platforms.html')"><b>See List</b></a></font></td>
</tr>
<tr>
<td> <b>Publisher:</b></td>
<td><input type=text name=publisher maxlength=100 size=30><br></td>
</tr>
<tr>
<td> <b>Developer:</b></td>
<td><input type=text name=developer maxlength=100 size=30><br></td>
</tr>
<tr>
<td> <b>Country(s):</b></td>
<td><input type=text name=country maxlength=100 size=30> <font size=-2><a href="javascript:popUp('refs/countries.html')"><b>See List</b></a></font></td>
</tr>
<tr>
<td> <b>Release Year:</b></td>
<td><input type=text name=release_date maxlength=100 size=10></td>
</tr>
<tr>
<td> <b>Availability:</b></td>
<td><select name="availability">
<option value="">--Select Availability--</option>
<option value="Yes">Yes</option>
<option value="No">No</option>
</select>
</td>
</tr>
<tr>
<td> <b>Director:</b></td>
<td><input type=text name=director maxlength=100 size=30><br></td>
</tr>
<tr>
<td> <b>Lead Artist:</b></td>
<td><input type=text name=lead_artist maxlength=100 size=30><br></td>
</tr>
<tr>
<td> <b>Concept Designer:</b></td>
<td><input type=text name=concept_des maxlength=100 size=30><br></td>
</tr>
<tr>
<td> <b>Music Composer:</b></td>
<td><input type=text name=music_comp maxlength=100 size=30><br></td>
</tr>
<tr>
<td> <b>Genre:</b></td>
<td><input type=text name=music_comp maxlength=100 size=30> <font size=-2><a href="javascript:popUp('refs/genres.html')"><b> See List</b></a></font>
</td>
</tr>
<tr>
<td> <b>Theme:</b></td>
<td><select name="theme">
<option value="">--Select Theme--</option>
<option value="Fantasy">Fantasy</option>
<option value="Medieval">Medieval</option>
<option value="Sci-Fi">Sci-Fi</option>
<option value="Cyberpunk">Cyberpunk</option>
<option value="Post Apocalyptic">Post Apocalyptic</option>
<option value="Mech">Mech</option>
<option value="Horror">Horror</option>
<option value="Western">Western</option>
<option value="Japanese">Japanese</option>
<option value="Anime">Anime</option>
<option value="Thriller">Thriller</option>
<option value="Mystery">Mystery</option>
<option value="Dating Sim">Dating Sim</option>
<option value="Unique">Unique</option>
</select>
</td>
</tr>
<tr>
<td> <b>Number of Players:</b></td>
<td><select name="num_players">
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="0">Unlimited</option>
</select>
<br></td>
</tr>
<tr>
<td> <b>Graphics:</b></td>
<td><select name="graphics">
<option value="">--Select Graphics--</option>
<option value="3D">3D</option>
<option value="2D">2D</option>
<option value="text">Text</option>
</select>
<font size=-2><a href="javascript:popUp('refs/graphics.html')"><b> Description</b></a></font>
<br></td>
</tr>
<tr>
<td> <b>View:</b></td>
<td><select name="view">
<option value="">--Select View--</option>
<option value="Isometic">Isometric</option>
<option value="Overhead">Overhead</option>
<option value="Platform">Platform</option>
<option value="Side-Scroler">Side Scroller</option>
<option value="First-Person">First Person</option>
<option value="3rd-Person">Third Person</option>
</select>
<font size=-2><a href="javascript:popUp('refs/view.html')"><b> Description</b></a></font>
</td>
</tr>
<tr>
<td> <b>Game Description:</b></td>
<td><TEXTAREA NAME="game_desc" ROWS=10 COLS=30></TEXTAREA>*<br></td>
</tr>
<tr>
<td> <b>Screenshot 1:</b></td>
<td><input type="file" name="screen01" size="30"> <font size=-2><a href="javascript:popUp('refs/uploads.html')"><b>Uploading Guidelines</b></a></font></td>
</tr>
<tr>
<td> <b>Screenshot 2:</b></td>
<td><input type="file" name="screen02" size="30"></td>
</tr>
<tr>
<td> <b>Screenshot 3:</b></td>
<td><input type="file" name="screen03" size="30"></td>
</tr>
<tr>
<td> <b>Link 1:</b></td>
<td><input type="text" name="link01" size="30"></td>
</tr>
<tr>
<td> <b>Link 2:</b></td>
<td><input type="text" name="link02" size="30"></td>
</tr>
<tr>
<td> <b>Link 3:</b></td>
<td><input type="text" name="link03" size="30"></td>
</tr>
<tr>
<td colspan=2 align="center">
<input type=hidden name="MAX_FILE_SIZE" value="25000">
<input type=hidden name="game_id" value="<? print $game_id ?>">
<input type=submit name="submit" value="Submit"></td>
</tr>
</table>
</td>
</tr>
</table>
</form>
</div>
</td>
</tr>
</table>
<?
} else {
if (!db_connect()) {
print "Error: could not connet to the database. Please try again later.";
exit;
}
switch (false) {
case $game_name:
print "<br>Please go <a href="submit.php">back</a> and enter a game name";
exit;
case $platform:
print "<br>Please go <a href="submit.php">back</a> and enter a platform";
exit;
case $game_desc:
print "<br>Please go <a href="submit.php">back</a> and enter a short description of the game";
exit;
}
if ($_FILES['box_front']['tmp_name'] != "") {
copy($_FILES['box_front']['tmp_name'], "ul_imgs/".$_FILES['box_front']['name'])
or die("Couldn't copy the file!");
}
if ($_FILES['box_back']['tmp_name'] != "") {
copy($_FILES['box_back']['tmp_name'], "ul_imgs/".$_FILES['box_back']['name'])
or die("Couldn't copy the file!");
}
if ($_FILES['screen01']['tmp_name'] != "") {
copy($_FILES['screen01']['tmp_name'], "ul_imgs/".$_FILES['screen01']['name'])
or die("Couldn't copy the file!");
}
if ($_FILES['screen02']['tmp_name'] != "") {
copy($_FILES['screen02']['tmp_name'], "ul_imgs/".$_FILES['screen02']['name'])
or die("Couldn't copy the file!");
}
if ($_FILES['screen03']['tmp_name'] != "") {
copy($_FILES['screen03']['tmp_name'], "ul_imgs/".$_FILES['screen03']['name'])
or die("Couldn't copy the file!");
}
$game_name = addslashes($game_name);
$box_front = "ul_imgs/".$_FILES['box_front']['name'];
$box_back = "ul_imgs/".$_FILES['box_back']['name'];
$platform = addslashes($platform);
$publisher = addslashes($publisher);
$developer = addslashes($developer);
$country = addslashes($country );
$release_date = addslashes($release_date);
$availability = addslashes($availability);
$director = addslashes($director);
$lead_artist = addslashes($lead_artist);
$concept_des = addslashes($concept_des);
$music_comp = addslashes($music_comp);
$genre = addslashes($genre);
$theme = addslashes($theme);
$num_player = addslashes($num_players);
$graphics = addslashes($graphics);
$view = addslashes($view);
$game_desc = addslashes($game_desc);
$screen01 = "ul_imgs/".$_FILES['screen01']['name'];
$screen02 = "ul_imgs/".$_FILES['screen02']['name'];
$screen03 = "ul_imgs/".$_FILES['screen03']['name'];
$query = "insert into game_info (game_name, box_front, box_back, platform, publisher, developer, country, release_date, availability, director, lead_artist, concept_des, music_comp, genre, theme, num_players, graphics, view, game_desc, screen01, screen02, screen03, last_update_by) values ('".$game_name."', '".$box_front."', '".$box_back."', '".$platform."', '".$publisher."', '".$developer."', '".$country."', '".$release_date."', '".$availability."', '".$director."', '".$lead_artist."', '".$concept_des."', '".$music_comp."', '".$genre."', '".$theme."', '".$num_players."', '".$graphics."', '".$view."', '".$game_desc."','".$screen01."','".$screen02."','".$screen03."','".$auth_user."')";
$result = mysql_query($query);
if ($result) {
echo mysql_affected_rows()." game added to the queue.";
} else {
echo $query;
}
$query = "select game_id from game_info order by last_update desc limit 1";
$result = mysql_query($query);
$row = mysql_fetch_array($result);
$num_links=0;
if ($link01) {
$query = "insert into links (game_id, link_url, link_name) values ('".$row[0]."','".$link01."','".$link01."')";
$result = mysql_query($query);
if ($result) {
$num_links += 1;
}
}
if ($link02) {
$query = "insert into links (game_id, link_url, link_name) values ('".$row[0]."','".$link02."','".$link02."')";
$result = mysql_query($query);
if ($result) {
$num_links += 1;
}
}
if ($link03) {
$query = "insert into links (game_id, link_url, link_name) values ('".$row[0]."','".$link03."','".$link03."')";
$result = mysql_query($query);
if ($result) {
$num_links += 1;
}
}
if ($num_links) {
print "<br>". $num_links ." link(s) added.";
}
print "<BR><BR><BR><BR> -> <a href="index.php"><b>View Games</b></a>";
}
?>
</body>
</html>
?>