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

Het Grote Vibe Code Topic

PWYL source gezocht

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

370 Nieuwe Domeinnamen April 2026

Snel een website nodig?

Sicarras.com - Moderne Mafia Text-Based RPG

Syntax error

Participate now!

Google Cloud is in de problemen (en AWS weet het)

Nebius kondigt bouw aan van een van Europa's grootste datacenters

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

Functioneel ontwerp

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

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