Syntax error

Starlife

heey ik krijg dit

MySQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-ogameusers SET `id` = '1', `username` = 'Cmz', `email` ' at line 1

Kan iemand helpen?
dit is het script waar de fout in zit.. :

PHP

<?php


/**
 * index.php (Installeur)
 *
 * @version 1
 * @copyright 2008 By e-Zobar for XNova
 * Based on first Chlorel's code
 */


define('INSIDE'  , true);
define('INSTALL' , true);


$xnova_root_path = './../';
include($xnova_root_path . 'extension.inc');
include($xnova_root_path . 'common.'.$phpEx);
include($xnova_root_path . 'includes/databaseinfos.'.$phpEx);
include($xnova_root_path . 'includes/migrateinfo.'.$phpEx);




$Mode     = $_GET['mode'];
$Page     = $_GET['page'];
$phpself  = $_SERVER['PHP_SELF'];
$nextpage = $Page + 1;


	if (empty($Mode)) { $Mode = 'intro'; }
	if (empty($Page)) { $Page = 1;       }


	$MainTPL = gettemplate('install/ins_body');
	includeLang('install/install');
	switch ($Mode) {
		case 'intro':
				$SubTPL = gettemplate ('install/ins_intro');
				$bloc   = $lang;
				$frame  = parsetemplate ( $SubTPL, $bloc );
		 	break;
		case 'ins':
			if ($Page == 1) {
				if ($_GET['error'] == 1) {
				adminMessage ($lang['ins_error1'], $lang['ins_error']);
				}
				elseif ($_GET['error'] == 2) {
				adminMessage ($lang['ins_error2'], $lang['ins_error']);
				}


				$SubTPL = gettemplate ('install/ins_form');
				$bloc   = $lang;
				$frame  = parsetemplate ( $SubTPL, $bloc );
			}
			elseif ($Page == 2) {
				$host   = $_POST['host'];
				$user   = $_POST['user'];
				$pass   = $_POST['passwort'];
				$prefix = $_POST['prefix'];
				$db     = $_POST['db'];


				$connection = @mysql_connect($host, $user, $pass);
					if (!$connection) {
					header("Location: ?mode=ins&page=1&error=1");
					exit();
					}


				$dbselect = @mysql_select_db($db);
					if (!$dbselect) {
					header("Location: ?mode=ins&page=1&error=1");
					exit();
					}


				$numcookie = mt_rand(1000, 1234567890);
				$dz = fopen("../config.php", "w");
					if (!$dz) {
					header("Location: ?mode=ins&page=1&error=2");
					exit();
					}


				fwrite($dz, "<?php\n");
				fwrite($dz, "if(!defined(\"INSIDE\")){ die(\"attemp hacking\"); }\n");
				fwrite($dz, "\$dbsettings = Array(\n");
				fwrite($dz, "\"server\"     => \"".$host."\", // MySQL server name.\n");
				fwrite($dz, "\"user\"       => \"".$user."\", // MySQL username.\n");
				fwrite($dz, "\"pass\"       => \"".$pass."\", // MySQL password.\n");
				fwrite($dz, "\"name\"       => \"".$db."\", // MySQL database name.\n");
				fwrite($dz, "\"prefix\"     => \"".$prefix."\", // Tables prefix.\n");
				fwrite($dz, "\"secretword\" => \"XNova".$numcookie."\"); // Cookies.\n");
				fwrite($dz, "?>");
				fclose($dz);


				function doquery ($InQry, $TblName) {
					global $prefix;
					$Table  = $prefix.$TblName;
					$DoQry  = str_replace("{{table}}", $Table, $InQry);
					$return = mysql_query($DoQry) or die("MySQL Error: <b>".mysql_error()."</b>");
				return $return;
				}


				doquery ( $QryTableAks        , 'aks'        );
				$parse['aks_created'] == $lang['create_aks'];
				doquery ( $QryTableAnnonce    , 'annonce'    );
				$parse['aks_created'] == $lang['create_annonce'];				
				doquery ( $QryTableAlliance   , 'alliance'   );
				$parse['aks_created'] == $lang['create_alliance'];
				doquery ( $QryTableBanned     , 'banned'     );
				$parse['aks_created'] == $lang['create_banned'];
				doquery ( $QryTableBuddy      , 'buddy'      );
				$parse['aks_created'] == $lang['create_buddy'];
				doquery ( $QryTableChat       , 'chat'       );
				$parse['aks_created'] == $lang['create_chat'];
				doquery ( $QryTableConfig     , 'config'     );
				$parse['aks_created'] == $lang['create_config'];
				doquery ( $QryInsertConfig    , 'config'     );
				$parse['aks_created'] == $lang['populate_config'];
				doquery ( $QryTabledeclared        , 'declared'        );
				$parse['aks_created'] == $lang['create_declared'];
				doquery ( $QryTableErrors     , 'errors'     );
				$parse['aks_created'] == $lang['create_errors'];
				doquery ( $QryTableFleets     , 'fleets'     );
				$parse['aks_created'] == $lang['create_fleetss'];
				doquery ( $QryTableGalaxy     , 'galaxy'     );
				$parse['aks_created'] == $lang['create_galaxy'];
				doquery ( $QryTableIraks      , 'iraks'      );
				$parse['aks_created'] == $lang['create_iraks'];
				doquery ( $QryTableLunas      , 'lunas'      );
				$parse['aks_created'] == $lang['create_lunas'];
				doquery ( $QryTableMessages   , 'messages'   );
				$parse['aks_created'] == $lang['create_messages'];
				doquery ( $QryTableNotes      , 'notes'      );
				$parse['aks_created'] == $lang['create_notes'];
				doquery ( $QryTablePlanets    , 'planets'    );
				$parse['aks_created'] == $lang['create_planets'];
				doquery ( $QryTableRw         , 'rw'         );
				$parse['aks_created'] == $lang['create_rw'];
				doquery ( $QryTableStatPoints , 'statpoints' );
				$parse['aks_created'] == $lang['create_statpoints'];
				doquery ( $QryTableUsers      , 'users'      );
				$parse['aks_created'] == $lang['create_users'];
				doquery ( $QryTableMulti      , 'multi'      );
				$parse['aks_created'] == $lang['create_multi'];


				$SubTPL = gettemplate ('install/ins_form_done');
				$bloc   = $lang;
				$frame  = parsetemplate ( $SubTPL, $bloc );
			}
			elseif ($Page == 3) {
				if ($_GET['error'] == 3) {
				adminMessage ($lang['ins_error3'], $lang['ins_error']);
				}


				$SubTPL = gettemplate ('install/ins_acc');
				$bloc   = $lang;
				$frame  = parsetemplate ( $SubTPL, $bloc );
			}
			elseif ($Page == 4) {
				$adm_user   = $_POST['adm_user'];
				$adm_pass   = $_POST['adm_pass'];
				$adm_email  = $_POST['adm_email'];
				$adm_planet = $_POST['adm_planet'];
				$adm_sex    = $_POST['adm_sex'];
				$md5pass    = md5($adm_pass);


				if (!$_POST['adm_user']) {
					header("Location: ?mode=ins&page=3&error=3");
					exit();
				}
				if (!$_POST['adm_pass']) {
					header("Location: ?mode=ins&page=3&error=3");
					exit();
				}
				if (!$_POST['adm_email']) {
					header("Location: ?mode=ins&page=3&error=3");
					exit();
				}
				if (!$_POST['adm_planet']) {
					header("Location: ?mode=ins&page=3&error=3");
					exit();
				}


				include($xnova_root_path.'config.php');
				$db_host   = $dbsettings['server'];
				$db_user   = $dbsettings['user'];
				$db_pass   = $dbsettings['pass'];
				$db_prefix = $dbsettings['prefix'];
				$db_db     = $dbsettings['name'];


				$connection = @mysql_connect($db_host, $db_user, $db_pass);
					if (!$connection) {
					header("Location: ?mode=ins&page=1&error=1");
					exit();
					}


				$dbselect = @mysql_select_db($db_db);
					if (!$dbselect) {
					header("Location: ?mode=ins&page=1&error=1");
					exit();
					}


				function doquery ($InQry, $TblName) {
					global $db_prefix;
					$Table  = $db_prefix.$TblName;
					$DoQry  = str_replace("{{table}}", $Table, $InQry);
					$return = mysql_query($DoQry) or die("MySQL Error: <b>".mysql_error()."</b>");
				return $return;
				}


				$QryInsertAdm  = "INSERT INTO {{table}} SET ";
				$QryInsertAdm .= "`id`                = '1', ";
				$QryInsertAdm .= "`username`          = '". $adm_user ."', ";
				$QryInsertAdm .= "`email`             = '". $adm_email ."', ";
				$QryInsertAdm .= "`email_2`           = '". $adm_email ."', ";
				$QryInsertAdm .= "`authlevel`         = '3', ";
				$QryInsertAdm .= "`sex`               = '". $adm_sex ."', ";
				$QryInsertAdm .= "`id_planet`         = '1', ";
				$QryInsertAdm .= "`galaxy`            = '1', ";
				$QryInsertAdm .= "`system`            = '1', ";
				$QryInsertAdm .= "`planet`            = '1', ";
				$QryInsertAdm .= "`current_planet`    = '1', ";
				$QryInsertAdm .= "`register_time`     = '". time() ."', ";
				$QryInsertAdm .= "`password`          = '". $md5pass ."';";
				doquery($QryInsertAdm, 'users');


				$QryAddAdmPlt  = "INSERT INTO {{table}} SET ";
				$QryAddAdmPlt .= "`name`              = '". $adm_planet ."', ";
				$QryAddAdmPlt .= "`id_owner`          = '1', ";
				$QryAddAdmPlt .= "`galaxy`            = '1', ";
				$QryAddAdmPlt .= "`system`            = '1', ";
				$QryAddAdmPlt .= "`planet`            = '1', ";
				$QryAddAdmPlt .= "`last_update`       = '". time() ."', ";
				$QryAddAdmPlt .= "`planet_type`       = '1', ";
				$QryAddAdmPlt .= "`image`             = 'normaltempplanet02', ";
				$QryAddAdmPlt .= "`diameter`          = '12750', ";
				$QryAddAdmPlt .= "`field_max`         = '163', ";
				$QryAddAdmPlt .= "`temp_min`          = '47', ";
				$QryAddAdmPlt .= "`temp_max`          = '87', ";
				$QryAddAdmPlt .= "`metal`             = '500', ";
				$QryAddAdmPlt .= "`metal_perhour`     = '0', ";
				$QryAddAdmPlt .= "`metal_max`         = '1000000', ";
				$QryAddAdmPlt .= "`crystal`           = '500', ";
				$QryAddAdmPlt .= "`crystal_perhour`   = '0', ";
				$QryAddAdmPlt .= "`crystal_max`       = '1000000', ";
				$QryAddAdmPlt .= "`deuterium`         = '500', ";
				$QryAddAdmPlt .= "`deuterium_perhour` = '0', ";
				$QryAddAdmPlt .= "`deuterium_max`     = '1000000';";
				doquery($QryAddAdmPlt, 'planets');


				$QryAddAdmGlx  = "INSERT INTO {{table}} SET ";
				$QryAddAdmGlx .= "`galaxy`            = '1', ";
				$QryAddAdmGlx .= "`system`            = '1', ";
				$QryAddAdmGlx .= "`planet`            = '1', ";
				$QryAddAdmGlx .= "`id_planet`         = '1'; ";
				doquery($QryAddAdmGlx, 'galaxy');


				doquery("UPDATE {{table}} SET `config_value` = '1' WHERE `config_name` = 'LastSettedGalaxyPos';", 'config');
				doquery("UPDATE {{table}} SET `config_value` = '1' WHERE `config_name` = 'LastSettedSystemPos';", 'config');
				doquery("UPDATE {{table}} SET `config_value` = '1' WHERE `config_name` = 'LastSettedPlanetPos';", 'config');
				doquery("UPDATE {{table}} SET `config_value` = `config_value` + '1' WHERE `config_name` = 'users_amount' LIMIT 1;", 'config');


				$SubTPL = gettemplate ('install/ins_acc_done');
				$bloc   = $lang;
				$frame  = parsetemplate ( $SubTPL, $bloc );
			}
			break;
		case 'goto':
			if ($Page == 1) {
				$SubTPL = gettemplate ('install/ins_goto_intro');
				$bloc   = $lang;
				$frame  = parsetemplate ( $SubTPL, $bloc );
			}
			elseif ($Page == 2) {
				if ($_GET['error'] == 1) {
				adminMessage ($lang['ins_error1'], $lang['ins_error']);
				}
				elseif ($_GET['error'] == 2) {
				adminMessage ($lang['ins_error2'], $lang['ins_error']);
				}


				$SubTPL = gettemplate ('install/ins_goto_form');
				$bloc   = $lang;
				$frame  = parsetemplate ( $SubTPL, $bloc );
			}
			elseif ($Page == 3) {
				$host   = $_POST['host'];
				$user   = $_POST['user'];
				$pass   = $_POST['passwort'];
				$prefix = $_POST['prefix'];
				$db     = $_POST['db'];


				$connection = @mysql_connect($host, $user, $pass);
					if (!$connection) {
					header("Location: ?mode=goto&page=2&error=1");
					exit();
					}


				$dbselect = @mysql_select_db($db);
					if (!$dbselect) {
					header("Location: ?mode=goto&page=2&error=1");
					exit();
					}


				$numcookie = mt_rand(1000, 1234567890);
				$dz = fopen("../config.php", "w");
					if (!$dz) {
					header("Location: ?mode=ins&page=1&error=2");
					exit();
					}


				fwrite($dz, "<?php\n");
				fwrite($dz, "if(!defined(\"INSIDE\")){ die(\"attemp hacking\"); }\n");
				fwrite($dz, "\$dbsettings = Array(\n");
				fwrite($dz, "\"server\"     => \"".$host."\", // MySQL server name.\n");
				fwrite($dz, "\"user\"       => \"".$user."\", // MySQL username.\n");
				fwrite($dz, "\"pass\"       => \"".$pass."\", // MySQL password.\n");
				fwrite($dz, "\"name\"       => \"".$db."\", // MySQL database name.\n");
				fwrite($dz, "\"prefix\"     => \"".$prefix."\", // Tables prefix.\n");
				fwrite($dz, "\"secretword\" => \"XNova".$numcookie."\"); // Cookies.\n");
				fwrite($dz, "?>");
				fclose($dz);


				function doquery($query, $p) {
					$query = str_replace("{{prefix}}", $p, $query);
					$return = mysql_query($query) or die("MySQL Error: <b>".mysql_error()."</b>");
				return $return;
				}
				foreach ($QryMigrate as $query) {
					doquery($query, $prefix);
				}


				$SubTPL = gettemplate ('install/ins_goto_done');
				$bloc   = $lang;
				$frame  = parsetemplate ( $SubTPL, $bloc );
			}
		 	break;
		case 'upg':
		 	break;
		case 'bye':
				header("Location: ../");
		 	break;
		default:
	}


	$parse                 = $lang;
	$parse['ins_state']    = $Page;
	$parse['ins_page']     = $frame;
	$parse['dis_ins_btn']  = "?mode=$Mode&page=$nextpage";
	$Displ                 = parsetemplate ($MainTPL, $parse);


	display ($Displ, "Installeur", false, '', true);


?>

Meer tonen

meer bepaald hier :

PHP

}


                $QryInsertAdm  = "INSERT INTO {{table}} SET ";
                $QryInsertAdm .= "`id`                = '1', ";
                $QryInsertAdm .= "`username`          = '". $adm_user ."', ";
                $QryInsertAdm .= "`email`             = '". $adm_email ."', ";
                $QryInsertAdm .= "`email_2`           = '". $adm_email ."', ";
                $QryInsertAdm .= "`authlevel`         = '3', ";
                $QryInsertAdm .= "`sex`               = '". $adm_sex ."', ";
                $QryInsertAdm .= "`id_planet`         = '1', ";
                $QryInsertAdm .= "`galaxy`            = '1', ";
                $QryInsertAdm .= "`system`            = '1', ";
                $QryInsertAdm .= "`planet`            = '1', ";
                $QryInsertAdm .= "`current_planet`    = '1', ";
                $QryInsertAdm .= "`register_time`     = '". time() ."', ";
                $QryInsertAdm .= "`password`          = '". $md5pass ."';";
                doquery($QryInsertAdm, 'users');


                $QryAddAdmPlt  = "INSERT INTO {{table}} SET ";
                $QryAddAdmPlt .= "`name`              = '". $adm_planet ."', ";
                $QryAddAdmPlt .= "`id_owner`          = '1', ";
                $QryAddAdmPlt .= "`galaxy`            = '1', ";
                $QryAddAdmPlt .= "`system`            = '1', ";
                $QryAddAdmPlt .= "`planet`            = '1', ";
                $QryAddAdmPlt .= "`last_update`       = '". time() ."', ";
                $QryAddAdmPlt .= "`planet_type`       = '1', ";
                $QryAddAdmPlt .= "`image`             = 'normaltempplanet02', ";
                $QryAddAdmPlt .= "`diameter`          = '12750', ";
                $QryAddAdmPlt .= "`field_max`         = '163', ";
                $QryAddAdmPlt .= "`temp_min`          = '47', ";
                $QryAddAdmPlt .= "`temp_max`          = '87', ";
                $QryAddAdmPlt .= "`metal`             = '500', ";
                $QryAddAdmPlt .= "`metal_perhour`     = '0', ";
                $QryAddAdmPlt .= "`metal_max`         = '1000000', ";
                $QryAddAdmPlt .= "`crystal`           = '500', ";
                $QryAddAdmPlt .= "`crystal_perhour`   = '0', ";
                $QryAddAdmPlt .= "`crystal_max`       = '1000000', ";
                $QryAddAdmPlt .= "`deuterium`         = '500', ";
                $QryAddAdmPlt .= "`deuterium_perhour` = '0', ";
                $QryAddAdmPlt .= "`deuterium_max`     = '1000000';";
                doquery($QryAddAdmPlt, 'planets');


                $QryAddAdmGlx  = "INSERT INTO {{table}} SET ";
                $QryAddAdmGlx .= "`galaxy`            = '1', ";
                $QryAddAdmGlx .= "`system`            = '1', ";
                $QryAddAdmGlx .= "`planet`            = '1', ";
                $QryAddAdmGlx .= "`id_planet`         = '1'; ";
                doquery($QryAddAdmGlx, 'galaxy');


                doquery("UPDATE {{table}} SET `config_value` = '1' WHERE `config_name` = 'LastSettedGalaxyPos';", 'config');
                doquery("UPDATE {{table}} SET `config_value` = '1' WHERE `config_name` = 'LastSettedSystemPos';", 'config');
                doquery("UPDATE {{table}} SET `config_value` = '1' WHERE `config_name` = 'LastSettedPlanetPos';", 'config');
                doquery("UPDATE {{table}} SET `config_value` = `config_value` + '1' WHERE `config_name` = 'users_amount' LIMIT 1;", 'config');


                $SubTPL = gettemplate ('install/ins_acc_done');
                $bloc   = $lang;
                $frame  = parsetemplate ( $SubTPL, $bloc );
            }

Meer tonen

Stefan.J

Als je eerst even het script bekijkt zie je dat het script met een prefix variabele werkt.;)

Je prefix -ogame is niet correct. Een - in de tabelnaam binnen MySQL wordt (sterk) afgeraden (Zoals zoveel vreemde tekens). Gebruik dus een andere prefix (Bijvoorbeeld zonder -0).

Starlife

ja,maar ik vind niet waar . . ik heb ctrl+h gedaan en dan vervangen maar het blijft het zelfde

Stefan.J

Waarschijnlijk kun jij geen PHP. Ten eerste zag ik ergens iets vreemds staan:

PHP

$prefix = $_POST['prefix'];

En daarnaast zou het wel eens heel goed in een include-bestand kunnen staan.

Starlife

@killingdevil ..

waarkan ik die prefix veranderen ..

Starlife

Okj,tnx heb de fout gevonden zat in een ander bestand :p

ICTscripters

Dé plek voor IT

Dé plek voor IT

nieuwe game

Criminolz

[Beta] Ottomaan: gratis browserspel met een echte, levende stad. Feedback gezocht!

Port Father: beta van een browsergame in Antwerpen 1931, feedback welkom

Maffia Hotel: een browsergame waarin je van lobbygast naar spil van het hotel groeit

Crime Club volledig herschreven vanaf nul

Malavita (nieuwe maffia game, van 0)

Herkent deze Notion-structuurscan echte problemen?

[Aanbod] Stadskaart voor je browsergame: van menu naar klikbare stad, vanaf €200

[Verkoop] G4G (Gangsters 4 Gangsters): volledige broncode, nieuw gebouwd in PHP 8.3 | € 30 per domein

[TE KOOP] Malavita.be [Maffiaspel, gebaseerd op omicidio.nl, unieke code]

Syntax error

Registratie

PHP waarschuwt voor twee ernstige bugs die makkelijk uit te buiten lijken

Functioneel ontwerp

Access Control List implementatie in PHP/MySQL - deel 1/2

Access Control List implementatie in PHP/MySQL - deel 2/2