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);


?>

Toon Meer

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 );
            }

Toon Meer

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

OS Vendetta gezocht

Fallen Kingdom Game

Crimora.nl

RPG game gebouwd met AI

(Verkoop) Criminals

Het Grote Vibe Code Topic

Ictscripters Chat

Het oorspronkelijke Criminals Script

Straatbaas.eu – complete Nederlandstalige en Engelstalige online maffia-RPG

306 Nieuwe Domeinnamen Juni 2026

4-letter domein: Togi.nl

Syntax error

Participate now!

Quanscient ontvangt €10M om AI- en kwantum-native hardware engineering te bevorderen - Tech.eu

Datalek bij leverancier Canvas - Universiteit van Amsterdam

Data privacy in 2026: Hoe de naleving van GDPR verandert

Functioneel ontwerp

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

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