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

Ictscripters Chat

Help testers nodig voor android app Urgent

Partner Gezocht om meerdere NFT Collecties op Open Sea te Plaatsen

Afspraken systeem met planbeperking

Developer Gezocht

Na 15 jaar terug van weggeweest: iCriminals.nl is terug (BETA)!

Op zoek naar de legends

[FREE] WeFact Hosting module

Domeinportfolio uitkuis

Heel wat sterke domeinen > 2 letters, 3 letters, premiums

367 Nieuwe Domeinnamen Februari 2026

Syntax error

Participate now!

Samsung zal miljoenen verdienen aan Apple iPhone Fold dankzij zijn 12GB RAM

Apple heeft zojuist iOS 26.4 Beta 4 vrijgegeven: hier is de verwachte lanceerdatum.

Kritieke kwetsbaarheid in Nginx UI bedreigt gevoelige data

Functioneel ontwerp

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

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

Gebruikers die dit topic bekijken