este es el codigo:
Código PHP:
<?php include 'header.php'; ?>
<?php
if (loggedin())
{
$title = mysql_escape_string(stripslashes($_POST['title']));
$hname = mysql_escape_string(stripslashes($_POST['hname']));
$type = mysql_escape_string(stripslashes($_POST['type']));
$code = mysql_escape_string(stripslashes($_POST['code']));
$description = mysql_escape_string(stripslashes(nl2br($_POST['description'])));
$instructions = mysql_escape_string(stripslashes(nl2br($_POST['instructions'])));
$credits = mysql_escape_string(stripslashes(nl2br($_POST['credits'])));
$width = mysql_escape_string(intval(stripslashes($_POST['width'])));
$height = mysql_escape_string(intval(stripslashes($_POST['height'])));
$codetype = mysql_escape_string(stripslashes($_POST['codetype']));
$reverse = mysql_escape_string(stripslashes($_POST['reverse']));
if ($reverse == 'on')
{
$reverse_scoring = '1';
}
else
{
$reverse_scoring = '0';
}
$err = "";
connect();
$query = "SELECT * FROM gtypes";
$result = mysql_query($query);
$okg = 0;
while ($row = mysql_fetch_array($result))
{
if ($row['type'] === $type)
{
$okg++;
}
}
if ($okg == 0)
{
$err .= "<li>Invalid game type</li>\n";
}
$query = "SELECT * FROM games";
$result = mysql_query($query);
$okt = 0;
while ($row = mysql_fetch_array($result))
{
if ($row['name'] === stripslashes($title))
{
$okt++;
}
}
if ($okt != 0)
{
$err .= "<li>Game title already used</li>\n";
}
if ($title == "")
{
$err .= "<li>Must enter a title</li>\n";
}
//if($code==""){
//$err.="<li>Must have code for the game</li>\n";
//}
if ($width == "0")
{
$err .= "<li>Must enter a width</li>\n";
}
if ($height == "0")
{
$err .= "<li>Must enter a height</li>\n";
}
if ($codetype == "")
{
$err .= "<li>Must enter a code type (flash, java, etc.)</li>\n";
}
if ($description == "")
{
$err .= "<li>Must provide a game description</li>\n";
}
if ($instructions == "")
{
$err .= "<li>Must provide game instructions</li>\n";
}
if ($credits == "")
{
$err .= "<li>Must provide game credits</li>\n";
}
if ($_FILES['small']['name'] == "")
{
$err .= "<li>Must choose a small thumbnail image</li>\n";
}
if ($_FILES['large']['name'] == "")
{
$err .= "<li>Must choose a large thumbnail image</li>\n";
}
if ($_FILES['game1']['name'] == "")
{
$err .= "<li>Must choose a Shockware, Flash, or Java file</li>\n";
}
if ($err != "")
{
message("The following must be fixed:<br>\n<ul>\n$err</ul>");
}
else
{
// Prepare to Upload Small Thumb
$sext1 = explode(".", $_FILES['small']['name']);
$s1 = count($sext1);
$sext = $sext1[$s1 - 1];
$sname = stripuser($title) . "_small.$sext";
$dir_path = getcwd() . "/games/";
$tmp_path = $_FILES['small']['tmp_name'];
$target_path = $dir_path . $sname;
if (!move_uploaded_file($tmp_path, $target_path))
{
if (!copy($tmp_path, $target_path))
{
message('Couldn\'t move the uploaded Small thumbnail. ' . E_USER_WARNING);
}
}
while (file_exists($tmp_path))
{
unlink($tmp_path);
clearstatcache();
}
// Prepare to Upload Large Thumb
$lext1 = explode(".", $_FILES['large']['name']);
$l1 = count($lext1);
$lext = $lext1[$l1 - 1];
$lname = stripuser($title) . "_large.$lext";
$tmp_path = $_FILES['large']['tmp_name'];
$target_path = $dir_path . $lname;
if (!move_uploaded_file($tmp_path, $target_path))
{
if (!copy($tmp_path, $target_path))
{
message('Couldn\'t move the uploaded Large thumbnail. ' . E_USER_WARNING);
}
}
while (file_exists($tmp_path))
{
unlink($tmp_path);
clearstatcache();
}
// Prepare to Upload Game File
$gext1 = explode(".", $_FILES['game1']['name']);
$g1 = count($gext1);
$gext = $gext1[$g1 - 1];
$gname = stripuser($title) . ".$gext";
$tmp_path = $_FILES['game1']['tmp_name'];
$target_path = $dir_path . $gname;
if (!move_uploaded_file($tmp_path, $target_path))
{
if (!copy($tmp_path, $target_path))
{
message('Couldn\'t move the uploaded file. ' . E_USER_WARNING);
}
}
while (file_exists($tmp_path))
{
unlink($tmp_path);
clearstatcache();
}
$memberID = $_COOKIE['id'];
$query = "INSERT INTO games VALUES ('','$title','0','$code','$type','$description','$instructions','$credits','games/$sname','games/$lname','games/$gname','$hname','$width','$height','$codetype', '$reverse_scoring', '0', '$memberID')";
$result = mysql_query($query);
$in_id = mysql_insert_id();
message("<a href=\"game.php?id={$in_id}\">" . stripslashes($title) . "</a> successfully added.");
}
mysql_close();
}
else
{
message("You must be logged in to use this feature.");
}
?>
<?php require_once 'footer.php'; ?>
Código:
esos son los registros que agregue tocando la linea 162-- -- Estructura de tabla para la tabla `games` -- CREATE TABLE IF NOT EXISTS `games` ( `gameid` bigint(20) unsigned NOT NULL auto_increment, `name` text NOT NULL, `plays` bigint(20) unsigned NOT NULL default '0', `code` text NOT NULL, `type` text NOT NULL, `description` text NOT NULL, `instructions` text NOT NULL, `credits` text NOT NULL, `sthumb` text NOT NULL, `lthumb` text NOT NULL, `file1` text NOT NULL, `hname` text NOT NULL, `width` int(10) unsigned NOT NULL default '550', `height` int(10) unsigned NOT NULL default '400', `codetype` text NOT NULL, `reverse_scoring` tinyint(1) NOT NULL default '0', `display` tinyint(1) NOT NULL default '1', PRIMARY KEY (`gameid`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1639 ; -- -- Volcar la base de datos para la tabla `games` -- INSERT INTO `games` (`gameid`, `name`, `plays`, `code`, `type`, `description`, `instructions`, `credits`, `sthumb`, `lthumb`, `file1`, `hname`, `width`, `height`, `codetype`, `reverse_scoring`, `display`) VALUES (1638, 'test test', 0, '', 'Puzzle', 'testtttttt', 'testtttttt', 'testtttttt', 'games/testtest_small.png', 'games/testtest_large.png', 'games/testtest.swf', '100000', 500, 400, 'Flash', 0, 0), (13, 'test 13', 12, 'Puzzle', 'bla bla bla', 'bla bla bla', 'bla bla bla', 'games/13diasenelinfierno_small.gif', 'games/13diasenelinfierno_large.gif', '', 'games/13diasenelinfierno.swf', '640', 480, 0, '0', 0, 1), (1637, 'title', 0, 'code', 'type', 'description', 'instructions', 'redits', 'games/$sname', 'games/lname', 'games/gname', 'hname', 0, 0, 'codetype', 0, 0);
Linea: 162 que creo es la que da problemas
$query = "INSERT INTO games VALUES ('','$title','0','$code','$type','$description','$ instructions','$credits','games/$sname','games/$lname','games/$gname','$hname','$width','$height','$codetype', '$reverse_scoring', '0', '$memberID')";
por favor una ayuda, gracias!
