Beiträge von RedDragon28080

RedDragon28080 · 8. März 2017

Zitat von Kaliber

Dann lass dir mal das ganze Query ausgeben und poste es mal hier (da wo du diesen Fehler bekommst)

hier bitte

CSS: Server_log

[12:14:00] params: 560 1
[12:14:00] faction0: 1
[12:14:00] Setze 1 auf -255
[12:14:00] Setze 2 auf -255
[12:14:00] Setze 3 auf -255
[12:14:00] Setze 4 auf -255
[12:14:00] f0 = 1
[12:14:00] f0 set 1
[12:14:00] f1 = -255
[12:14:00] f1 set -255
[12:14:00] f2 = -255
[12:14:00] f2 set -255
[12:14:00] f3 = -255
[12:14:00] f3 set -255
[12:14:00] f4 = -255
[12:14:00] f4 set -255
[12:14:00] Carid: 192
[12:14:00] pstring: LyL-PD- 1
[12:14:00] Fertig.
[12:14:03]  WHERE `ID` = '0'
[12:14:40] Admin RedDragon28080 hat den Spieler RedDragon28080 sein Level auf 5 gesetzt
[12:14:57] `fSperrpreis`='0'  WHERE ID = '0'
[12:15:04] Admin RedDragon28080 hat sich zu diese Koordinaten (X 1743.626464 ,Y -1903.989868 ,Z 33.556762) geportet
[12:15:59] `fSperrpreis`='0'  WHERE ID = '0'

Alles anzeigen

CSS: msql_log

[12:20:54 03/08/17] [DEBUG] mysql_pquery - connection: 1, query: "ALTER TABLE `FracVehicles` ADD `fCarid` varchar(11) NOT NULL DEF", callback: "(null)", format: "(null)"
[12:20:54 03/08/17] [DEBUG] mysql_pquery - connection: 1, query: "ALTER TABLE `FracVehicles` ADD `fVehid` varchar(11) NOT NULL DEF", callback: "(null)", format: "(null)"
[12:20:54 03/08/17] [DEBUG] mysql_pquery - connection: 1, query: "ALTER TABLE `FracVehicles` ADD `fPosX` float NOT NULL DEFAULT '0", callback: "(null)", format: "(null)"
[12:20:54 03/08/17] [DEBUG] mysql_pquery - connection: 1, query: "ALTER TABLE `FracVehicles` ADD `fPosY` float NOT NULL DEFAULT '0", callback: "(null)", format: "(null)"
[12:20:54 03/08/17] [DEBUG] mysql_pquery - connection: 1, query: "ALTER TABLE `FracVehicles` ADD `fPosZ` float NOT NULL DEFAULT '0", callback: "(null)", format: "(null)"
[12:20:54 03/08/17] [DEBUG] mysql_pquery - connection: 1, query: "ALTER TABLE `FracVehicles` ADD `fPosA` float NOT NULL DEFAULT '0", callback: "(null)", format: "(null)"
[12:20:54 03/08/17] [DEBUG] mysql_pquery - connection: 1, query: "ALTER TABLE `FracVehicles` ADD `fCol1` varchar(11) NOT NULL DEFA", callback: "(null)", format: "(null)"
[12:20:54 03/08/17] [DEBUG] mysql_pquery - connection: 1, query: "ALTER TABLE `FracVehicles` ADD `fCol2` varchar(11) NOT NULL DEFA", callback: "(null)", format: "(null)"
[12:20:54 03/08/17] [DEBUG] mysql_pquery - connection: 1, query: "ALTER TABLE `FracVehicles` ADD `fFaction1` varchar(11) NOT NULL ", callback: "(null)", format: "(null)"
[12:20:54 03/08/17] [DEBUG] mysql_pquery - connection: 1, query: "ALTER TABLE `FracVehicles` ADD `fFaction2` varchar(11) NOT NULL ", callback: "(null)", format: "(null)"
[12:20:54 03/08/17] [DEBUG] mysql_pquery - connection: 1, query: "ALTER TABLE `FracVehicles` ADD `fFaction3` varchar(11) NOT NULL ", callback: "(null)", format: "(null)"
[12:20:54 03/08/17] [DEBUG] mysql_pquery - connection: 1, query: "ALTER TABLE `FracVehicles` ADD `fFaction4` varchar(11) NOT NULL ", callback: "(null)", format: "(null)"
[12:20:54 03/08/17] [DEBUG] mysql_pquery - connection: 1, query: "ALTER TABLE `FracVehicles` ADD `fFaction5` varchar(11) NOT NULL ", callback: "(null)", format: "(null)"
[12:20:54 03/08/17] [DEBUG] mysql_pquery - connection: 1, query: "ALTER TABLE `FracVehicles` ADD `fSpoiler` varchar(11) NOT NULL D", callback: "(null)", format: "(null)"
[12:20:54 03/08/17] [DEBUG] mysql_pquery - connection: 1, query: "ALTER TABLE `FracVehicles` ADD `fHood` varchar(11) NOT NULL DEFA", callback: "(null)", format: "(null)"
[12:20:54 03/08/17] [DEBUG] mysql_pquery - connection: 1, query: "ALTER TABLE `FracVehicles` ADD `fRoof` varchar(11) NOT NULL DEFA", callback: "(null)", format: "(null)"
[12:20:54 03/08/17] [DEBUG] mysql_pquery - connection: 1, query: "ALTER TABLE `FracVehicles` ADD `fSideskirt` varchar(11) NOT NULL", callback: "(null)", format: "(null)"
[12:20:54 03/08/17] [DEBUG] mysql_pquery - connection: 1, query: "ALTER TABLE `FracVehicles` ADD `fLamps` varchar(11) NOT NULL DEF", callback: "(null)", format: "(null)"
[12:20:54 03/08/17] [DEBUG] mysql_pquery - connection: 1, query: "ALTER TABLE `FracVehicles` ADD `fNitro` varchar(11) NOT NULL DEF", callback: "(null)", format: "(null)"
[12:20:54 03/08/17] [DEBUG] mysql_pquery - connection: 1, query: "ALTER TABLE `FracVehicles` ADD `fExhaust` varchar(11) NOT NULL D", callback: "(null)", format: "(null)"
[12:20:54 03/08/17] [DEBUG] mysql_pquery - connection: 1, query: "ALTER TABLE `FracVehicles` ADD `fWheel` varchar(11) NOT NULL DEF", callback: "(null)", format: "(null)"
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[12:20:54 03/08/17] [DEBUG] mysql_pquery - connection: 1, query: "ALTER TABLE `FracVehicles` ADD `fStereo` varchar(11) NOT NULL DE", callback: "(null)", format: "(null)"
[12:20:54 03/08/17] [DEBUG] mysql_pquery - connection: 1, query: "ALTER TABLE `FracVehicles` ADD `fHydraulics` varchar(11) NOT NUL", callback: "(null)", format: "(null)"
[12:20:54 03/08/17] [DEBUG] mysql_pquery - connection: 1, query: "ALTER TABLE `FracVehicles` ADD `fFrontBumper` varchar(11) NOT NU", callback: "(null)", format: "(null)"
[12:20:54 03/08/17] [DEBUG] mysql_pquery - connection: 1, query: "ALTER TABLE `FracVehicles` ADD `fVent1` varchar(11) NOT NULL DEF", callback: "(null)", format: "(null)"
[12:20:54 03/08/17] [DEBUG] mysql_pquery - connection: 1, query: "ALTER TABLE `FracVehicles` ADD `fRearBumper` varchar(11) NOT NUL", callback: "(null)", format: "(null)"
[12:20:54 03/08/17] [DEBUG] mysql_pquery - connection: 1, query: "ALTER TABLE `FracVehicles` ADD `fVent2` varchar(11) NOT NULL DEF", callback: "(null)", format: "(null)"
[12:20:54 03/08/17] [DEBUG] mysql_pquery - connection: 1, query: "ALTER TABLE `FracVehicles` ADD `fPaintjob` varchar(11) NOT NULL ", callback: "(null)", format: "(null)"
[12:20:54 03/08/17] [DEBUG] mysql_pquery - connection: 1, query: "ALTER TABLE `FracVehicles` ADD `fPrice` varchar(11) NOT NULL DEF", callback: "(null)", format: "(null)"
[12:20:54 03/08/17] [DEBUG] mysql_pquery - connection: 1, query: "ALTER TABLE `FracVehicles` ADD `fTankart` varchar(11) NOT NULL D", callback: "(null)", format: "(null)"
[12:20:54 03/08/17] [ERROR] CMySQLQuery::Execute[] - (error #1060) Duplicate column name 'fCarid' (Query: "ALTER TABLE `FracVehicles` ADD `fCarid` varchar(11) NOT NULL DEFAULT '0'")
[12:20:54 03/08/17] [DEBUG] mysql_pquery - connection: 1, query: "ALTER TABLE `FracVehicles` ADD `fGesperrt` varchar(11) NOT NULL ", callback: "(null)", format: "(null)"
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[12:20:54 03/08/17] [DEBUG] mysql_pquery - connection: 1, query: "ALTER TABLE `FracVehicles` ADD `fMotorschaden` varchar(11) NOT N", callback: "(null)", format: "(null)"
[12:20:54 03/08/17] [DEBUG] mysql_pquery - connection: 1, query: "ALTER TABLE `FracVehicles` ADD `fSperrpreis` varchar(11) NOT NUL", callback: "(null)", format: "(null)"
[12:20:54 03/08/17] [ERROR] CMySQLQuery::Execute[] - (error #1060) Duplicate column name 'fPosX' (Query: "ALTER TABLE `FracVehicles` ADD `fPosX` float NOT NULL DEFAULT '0.0'")
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[12:20:54 03/08/17] [ERROR] CMySQLQuery::Execute[] - (error #1060) Duplicate column name 'fPosZ' (Query: "ALTER TABLE `FracVehicles` ADD `fPosZ` float NOT NULL DEFAULT '0.0'")
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[12:20:54 03/08/17] [ERROR] CMySQLQuery::Execute[] - (error #1060) Duplicate column name 'fCol1' (Query: "ALTER TABLE `FracVehicles` ADD `fCol1` varchar(11) NOT NULL DEFAULT '0'")
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[12:20:54 03/08/17] [ERROR] CMySQLQuery::Execute[] - (error #1060) Duplicate column name 'fFaction1' (Query: "ALTER TABLE `FracVehicles` ADD `fFaction1` varchar(11) NOT NULL DEFAULT '0'")
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[12:20:54 03/08/17] [ERROR] CMySQLQuery::Execute[] - (error #1060) Duplicate column name 'fFaction3' (Query: "ALTER TABLE `FracVehicles` ADD `fFaction3` varchar(11) NOT NULL DEFAULT '0'")
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[12:20:54 03/08/17] [ERROR] CMySQLQuery::Execute[] - (error #1060) Duplicate column name 'fFaction5' (Query: "ALTER TABLE `FracVehicles` ADD `fFaction5` varchar(11) NOT NULL DEFAULT '0'")
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[12:20:54 03/08/17] [ERROR] CMySQLQuery::Execute[] - (error #1060) Duplicate column name 'fHood' (Query: "ALTER TABLE `FracVehicles` ADD `fHood` varchar(11) NOT NULL DEFAULT '0'")
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[12:20:54 03/08/17] [ERROR] CMySQLQuery::Execute[] - (error #1060) Duplicate column name 'fSideskirt' (Query: "ALTER TABLE `FracVehicles` ADD `fSideskirt` varchar(11) NOT NULL DEFAULT '0'")
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[12:20:54 03/08/17] [ERROR] CMySQLQuery::Execute[] - (error #1060) Duplicate column name 'fNitro' (Query: "ALTER TABLE `FracVehicles` ADD `fNitro` varchar(11) NOT NULL DEFAULT '0'")
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[12:20:54 03/08/17] [ERROR] CMySQLQuery::Execute[] - (error #1060) Duplicate column name 'fWheel' (Query: "ALTER TABLE `FracVehicles` ADD `fWheel` varchar(11) NOT NULL DEFAULT '0'")
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[12:20:54 03/08/17] [ERROR] CMySQLQuery::Execute[] - (error #1060) Duplicate column name 'fHydraulics' (Query: "ALTER TABLE `FracVehicles` ADD `fHydraulics` varchar(11) NOT NULL DEFAULT '0'")
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[12:20:54 03/08/17] [ERROR] CMySQLQuery::Execute[] - (error #1060) Duplicate column name 'fVent1' (Query: "ALTER TABLE `FracVehicles` ADD `fVent1` varchar(11) NOT NULL DEFAULT '0'")
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[12:20:54 03/08/17] [ERROR] CMySQLQuery::Execute[] - (error #1060) Duplicate column name 'fVent2' (Query: "ALTER TABLE `FracVehicles` ADD `fVent2` varchar(11) NOT NULL DEFAULT '0'")
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[12:20:54 03/08/17] [ERROR] CMySQLQuery::Execute[] - (error #1060) Duplicate column name 'fPrice' (Query: "ALTER TABLE `FracVehicles` ADD `fPrice` varchar(11) NOT NULL DEFAULT '0'")
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[12:20:54 03/08/17] [ERROR] CMySQLQuery::Execute[] - (error #1060) Duplicate column name 'fVehid' (Query: "ALTER TABLE `FracVehicles` ADD `fVehid` varchar(11) NOT NULL DEFAULT '0'")
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[12:20:54 03/08/17] [ERROR] CMySQLQuery::Execute[] - (error #1060) Duplicate column name 'fGesperrt' (Query: "ALTER TABLE `FracVehicles` ADD `fGesperrt` varchar(11) NOT NULL DEFAULT '0'")
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[12:20:54 03/08/17] [ERROR] CMySQLQuery::Execute[] - (error #1060) Duplicate column name 'fPosY' (Query: "ALTER TABLE `FracVehicles` ADD `fPosY` float NOT NULL DEFAULT '0.0'")
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[12:20:54 03/08/17] [ERROR] CMySQLQuery::Execute[] - (error #1060) Duplicate column name 'fPosA' (Query: "ALTER TABLE `FracVehicles` ADD `fPosA` float NOT NULL DEFAULT '0.0'")
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[12:20:54 03/08/17] [ERROR] CMySQLQuery::Execute[] - (error #1060) Duplicate column name 'fSperrpreis' (Query: "ALTER TABLE `FracVehicles` ADD `fSperrpreis` varchar(11) NOT NULL DEFAULT '0'")
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[12:20:54 03/08/17] [ERROR] CMySQLQuery::Execute[] - (error #1060) Duplicate column name 'fCol2' (Query: "ALTER TABLE `FracVehicles` ADD `fCol2` varchar(11) NOT NULL DEFAULT '0'")
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[12:20:54 03/08/17] [ERROR] CMySQLQuery::Execute[] - (error #1060) Duplicate column name 'fFaction2' (Query: "ALTER TABLE `FracVehicles` ADD `fFaction2` varchar(11) NOT NULL DEFAULT '0'")
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[12:20:54 03/08/17] [ERROR] CMySQLQuery::Execute[] - (error #1060) Duplicate column name 'fFaction4' (Query: "ALTER TABLE `FracVehicles` ADD `fFaction4` varchar(11) NOT NULL DEFAULT '0'")
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[12:20:54 03/08/17] [ERROR] CMySQLQuery::Execute[] - (error #1060) Duplicate column name 'fSpoiler' (Query: "ALTER TABLE `FracVehicles` ADD `fSpoiler` varchar(11) NOT NULL DEFAULT '0'")
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[12:20:54 03/08/17] [ERROR] CMySQLQuery::Execute[] - (error #1060) Duplicate column name 'fRoof' (Query: "ALTER TABLE `FracVehicles` ADD `fRoof` varchar(11) NOT NULL DEFAULT '0'")
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[12:20:54 03/08/17] [ERROR] CMySQLQuery::Execute[] - (error #1060) Duplicate column name 'fLamps' (Query: "ALTER TABLE `FracVehicles` ADD `fLamps` varchar(11) NOT NULL DEFAULT '0'")
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[12:20:54 03/08/17] [ERROR] CMySQLQuery::Execute[] - (error #1060) Duplicate column name 'fExhaust' (Query: "ALTER TABLE `FracVehicles` ADD `fExhaust` varchar(11) NOT NULL DEFAULT '0'")
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[12:20:54 03/08/17] [ERROR] CMySQLQuery::Execute[] - (error #1060) Duplicate column name 'fStereo' (Query: "ALTER TABLE `FracVehicles` ADD `fStereo` varchar(11) NOT NULL DEFAULT '0'")
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[12:20:54 03/08/17] [ERROR] CMySQLQuery::Execute[] - (error #1060) Duplicate column name 'fFrontBumper' (Query: "ALTER TABLE `FracVehicles` ADD `fFrontBumper` varchar(11) NOT NULL DEFAULT '0'")
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[12:20:54 03/08/17] [ERROR] CMySQLQuery::Execute[] - (error #1060) Duplicate column name 'fRearBumper' (Query: "ALTER TABLE `FracVehicles` ADD `fRearBumper` varchar(11) NOT NULL DEFAULT '0'")
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[12:20:54 03/08/17] [ERROR] CMySQLQuery::Execute[] - (error #1060) Duplicate column name 'fPaintjob' (Query: "ALTER TABLE `FracVehicles` ADD `fPaintjob` varchar(11) NOT NULL DEFAULT '0'")
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[12:20:54 03/08/17] [ERROR] CMySQLQuery::Execute[] - (error #1060) Duplicate column name 'fTankart' (Query: "ALTER TABLE `FracVehicles` ADD `fTankart` varchar(11) NOT NULL DEFAULT '0'")
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[12:20:54 03/08/17] [ERROR] CMySQLQuery::Execute[] - (error #1060) Duplicate column name 'fMotorschaden' (Query: "ALTER TABLE `FracVehicles` ADD `fMotorschaden` varchar(11) NOT NULL DEFAULT '0'")
[12:20:54 03/08/17] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError

Alles anzeigen

RedDragon28080 · 8. März 2017

das hat mir aber auch nicht geholfen habe immer noch das gleiche problem

RedDragon28080 · 8. März 2017

Zitat von Slider

Kannst Du mal bitte erlaeutern, wieso das ein Fehler gewesen ist?

das hat mir aber nicht geholfen ich habe immer noch das problem

RedDragon28080 · 8. März 2017

Zitat von robbi2304

Wann soll das Fahrzeug gespeichert werden ? Vielleicht gibst du mir dafür den Code mal. Derzeit kriegst du keine Errors wodurch das eigentlich klappen sollte

Bitte sehr dann bist du genau da wo ich auch bin finde auch nichts

Code: SaveFracVehCheck

Function OnPlayerExitVehicle(playerid, vehicleid)
{
	SaveFracVehCheck(vehicleid);
  	return 1;
}


stock SaveFracVehCheck(vehicleid)
{
	//Deklaration neuer temporärer Variablen:
	new query[3048],string[3048];


	//Schleife durch alle Fraktions-Fahrzeuge
	for(new i=0; i<MAX_FRAC_VEHICLES; i++)
	{
		//Wenn die vehicleid die gleiche ist, wie die des Fraktions-Fahrzeugs
		if(FactionCars[i][fCarid] == vehicleid)
		{
			//Wir fragen die Position des Fahrzeugs ab:
			GetVehiclePos(FactionCars[i][fCarid], FactionCars[i][fPos][0], FactionCars[i][fPos][1], FactionCars[i][fPos][2]);
			GetVehicleZAngle(FactionCars[i][fCarid], FactionCars[i][fPos][3]);


			//Und wir erstellen das Query:
			format(query, sizeof(query), "UPDATE FracVehicles SET");
			format(query, sizeof(query), "%s`fVehid`='%s', ", string, FactionCars[i][fVehid]);
			format(query, sizeof(query), "%s`fPosX`='%f', ",  string, FactionCars[i][fPos][0]);
			format(query, sizeof(query), "%s`fPosY`='%f', ",  string, FactionCars[i][fPos][1]);
			format(query, sizeof(query), "%s`fPosZ`='%f', ",  string, FactionCars[i][fPos][2]);
			format(query, sizeof(query), "%s`fPosA`='%f', ",  string, FactionCars[i][fPos][3]);
			format(query, sizeof(query), "%s`fCol1`='%d' ",  string, FactionCars[i][fCol][0]);
			format(query, sizeof(query), "%s`fCol2`='%d' ",  string, FactionCars[i][fCol][1]);
			format(query, sizeof(query), "%s`fFaction1`='%d' ",  string, FactionCars[i][fFaction][0]);
			format(query, sizeof(query), "%s`fFaction2`='%d' ",  string, FactionCars[i][fFaction][1]);
			format(query, sizeof(query), "%s`fFaction3`='%d' ",  string, FactionCars[i][fFaction][2]);
			format(query, sizeof(query), "%s`fFaction4`='%d' ",  string, FactionCars[i][fFaction][3]);
			format(query, sizeof(query), "%s`fFaction5`='%d' ",  string, FactionCars[i][fFaction][4]);
			format(query, sizeof(query), "%s`fSpoiler`='%d' ",  string, FactionCars[i][fTuning][0]);
			format(query, sizeof(query), "%s`fHood`='%d' ",  string, FactionCars[i][fTuning][1]);
			format(query, sizeof(query), "%s`fRoof`='%d' ",  string, FactionCars[i][fTuning][2]);
			format(query, sizeof(query), "%s`fSideskirt`='%d' ",  string, FactionCars[i][fTuning][3]);
			format(query, sizeof(query), "%s`fLamps`='%d' ",  string, FactionCars[i][fTuning][4]);
			format(query, sizeof(query), "%s`fNitro`='%d' ",  string, FactionCars[i][fTuning][5]);
			format(query, sizeof(query), "%s`fExhaust`='%d' ",  string, FactionCars[i][fTuning][6]);
			format(query, sizeof(query), "%s`fWheel`='%d' ",  string, FactionCars[i][fTuning][7]);
			format(query, sizeof(query), "%s`fStereo`='%d' ",  string, FactionCars[i][fTuning][8]);
			format(query, sizeof(query), "%s`fHydraulics`='%d' ",  string, FactionCars[i][fTuning][9]);
			format(query, sizeof(query), "%s`fFrontBumper`='%d' ",  string, FactionCars[i][fTuning][10]);
			format(query, sizeof(query), "%s`fVent1`='%d' ",  string, FactionCars[i][fTuning][11]);
			format(query, sizeof(query), "%s`fRearBumper`='%d' ",  string, FactionCars[i][fTuning][12]);
			format(query, sizeof(query), "%s`fVent2`='%d' ",  string, FactionCars[i][fTuning][13]);
			format(query, sizeof(query), "%s`fPaintjob`='%d' ",  string, FactionCars[i][fTuning][14]);
			format(query, sizeof(query), "%s`fPrice`='%d' ",  string, FactionCars[i][fPrice]);
			format(query, sizeof(query), "%s`fTankart`='%d' ",  string, FactionCars[i][fTankart]);
			format(query, sizeof(query), "%s`fGesperrt`='%d' ",  string, FactionCars[i][fGesperrt]);
			format(query, sizeof(query), "%s`fMotorschaden`='%d' ",  string, FactionCars[i][fMotorschaden]);
			format(query, sizeof(query), "%s`fSperrpreis`='%d' ",  string, FactionCars[i][fSperrpreis]);
			format(query, sizeof(query), "%s WHERE id = '%d'", string, i);
			//handle = die Connection Handle ID die vor mysql_connect steht.
			mysql_pquery(handle, query);
			return 1; //Es gibt ja keine zwei gleichen Fahrzeuge
		}
	}
	return 0; //Fahrzeug ist kein Fraktions-Fahrzeug
}

Alles anzeigen

_________________________________________________________________________________________________________________________________________________________________________________________________________________________

Code

public OnGameModeInit()
{
	SetTimer("SaveAllFracVehs", 60000, true); //Timer wird alle 60 Sekunden ausgeführt
	return 1;
}


Function OnGameModeExit()
{
	SaveAllFracVehs();
	return 1;
}


forward SaveAllFracVehs();
public SaveAllFracVehs()
{
	//Deklaration neuer temporärer Variablen:
	new query[3048],string[250];


	//Schleife durch alle Fraktions-Fahrzeuge
	for(new i=0; i<MAX_FRAC_VEHICLES; i++)
	{
		//Wenn das Fahrzeug existiert
		if(FactionCars[i][fVehid] >= 400 && FactionCars[i][fVehid] <= 611)
		{
			//Wir fragen die Position des Fahrzeugs ab:
			GetVehiclePos(FactionCars[i][fCarid], FactionCars[i][fPos][0], FactionCars[i][fPos][1], FactionCars[i][fPos][2]);
			GetVehicleZAngle(FactionCars[i][fCarid], FactionCars[i][fPos][3]);


			//Und wir erstellen das Query:
			format(query, sizeof(query), "UPDATE `FracVehicles` SET ");
			format(query, sizeof(query), "%s`fVehid`='%s', ", string, FactionCars[i][fVehid]);
			format(query, sizeof(query), "%s`fPosX`='%f', ",  string, FactionCars[i][fPos][0]);
			format(query, sizeof(query), "%s`fPosY`='%f', ",  string, FactionCars[i][fPos][1]);
			format(query, sizeof(query), "%s`fPosZ`='%f', ",  string, FactionCars[i][fPos][2]);
			format(query, sizeof(query), "%s`fPosA`='%f', ",  string, FactionCars[i][fPos][3]);
			format(query, sizeof(query), "%s`fCol1`='%d' ",  string, FactionCars[i][fCol][0]);
			format(query, sizeof(query), "%s`fCol2`='%d' ",  string, FactionCars[i][fCol][1]);
			format(query, sizeof(query), "%s`fFaction1`='%d' ",  string, FactionCars[i][fFaction][0]);
			format(query, sizeof(query), "%s`fFaction2`='%d' ",  string, FactionCars[i][fFaction][1]);
			format(query, sizeof(query), "%s`fFaction3`='%d' ",  string, FactionCars[i][fFaction][2]);
			format(query, sizeof(query), "%s`fFaction4`='%d' ",  string, FactionCars[i][fFaction][3]);
			format(query, sizeof(query), "%s`fFaction5`='%d' ",  string, FactionCars[i][fFaction][4]);
			format(query, sizeof(query), "%s`fSpoiler`='%d' ",  string, FactionCars[i][fTuning][0]);
			format(query, sizeof(query), "%s`fHood`='%d' ",  string, FactionCars[i][fTuning][1]);
			format(query, sizeof(query), "%s`fRoof`='%d' ",  string, FactionCars[i][fTuning][2]);
			format(query, sizeof(query), "%s`fSideskirt`='%d' ",  string, FactionCars[i][fTuning][3]);
			format(query, sizeof(query), "%s`fLamps`='%d' ",  string, FactionCars[i][fTuning][4]);
			format(query, sizeof(query), "%s`fNitro`='%d' ",  string, FactionCars[i][fTuning][5]);
			format(query, sizeof(query), "%s`fExhaust`='%d' ",  string, FactionCars[i][fTuning][6]);
			format(query, sizeof(query), "%s`fWheel`='%d' ",  string, FactionCars[i][fTuning][7]);
			format(query, sizeof(query), "%s`fStereo`='%d' ",  string, FactionCars[i][fTuning][8]);
			format(query, sizeof(query), "%s`fHydraulics`='%d' ",  string, FactionCars[i][fTuning][9]);
			format(query, sizeof(query), "%s`fFrontBumper`='%d' ",  string, FactionCars[i][fTuning][10]);
			format(query, sizeof(query), "%s`fVent1`='%d' ",  string, FactionCars[i][fTuning][11]);
			format(query, sizeof(query), "%s`fRearBumper`='%d' ",  string, FactionCars[i][fTuning][12]);
			format(query, sizeof(query), "%s`fVent2`='%d' ",  string, FactionCars[i][fTuning][13]);
			format(query, sizeof(query), "%s`fPaintjob`='%d' ",  string, FactionCars[i][fTuning][14]);
			format(query, sizeof(query), "%s`fPrice`='%d' ",  string, FactionCars[i][fPrice]);
			format(query, sizeof(query), "%s`fTankart`='%d' ",  string, FactionCars[i][fTankart]);
			format(query, sizeof(query), "%s`fGesperrt`='%d' ",  string, FactionCars[i][fGesperrt]);
			format(query, sizeof(query), "%s`fMotorschaden`='%d' ",  string, FactionCars[i][fMotorschaden]);
			format(query, sizeof(query), "%s`fSperrpreis`='%d' ",  string, FactionCars[i][fSperrpreis]);
			format(query, sizeof(query), "%s WHERE id = '%d'", string, i);
			//handle = die Connection Handle ID die vor mysql_connect steht.
			mysql_pquery(handle, query);
		}
	}
	return 1;
}

Alles anzeigen

RedDragon28080 · 7. März 2017

hier das sagt er jetzt aus

Code

[23:48:28 03/07/17] [DEBUG] mysql_connect - host: "localhost", user: "samp6231", database: "samp6231_samp", password: "****", port: 3306, autoreconnect: true, pool_size: 2
[23:48:28 03/07/17] [DEBUG] CMySQLHandle::Create - creating new connection..
[23:48:28 03/07/17] [DEBUG] CMySQLHandle::CMySQLHandle - constructor called
[23:48:28 03/07/17] [DEBUG] CMySQLHandle::Create - connection created (id: 1)
[23:48:28 03/07/17] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[23:48:28 03/07/17] [DEBUG] CMySQLConnection::Connect - connection was successful
[23:48:28 03/07/17] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[23:48:28 03/07/17] [DEBUG] mysql_errno - connection: 1
[23:48:28 03/07/17] [DEBUG] mysql_pquery - connection: 1, query: "SELECT * FROM FracVehicles ORDER BY ID ASC", callback: "LoadFracVehicles_Data", format: "(null)"
[23:48:28 03/07/17] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[23:48:28 03/07/17] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[23:48:28 03/07/17] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[23:48:28 03/07/17] [DEBUG] CMySQLConnection::Connect - connection was successful
[23:48:28 03/07/17] [DEBUG] CMySQLConnection::Connect - connection was successful
[23:48:28 03/07/17] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[23:48:28 03/07/17] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[23:48:28 03/07/17] [DEBUG] CMySQLConnection::Connect - connection was successful
[23:48:28 03/07/17] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[23:48:28 03/07/17] [DEBUG] CMySQLQuery::Execute[LoadFracVehicles_Data] - starting query execution
[23:48:28 03/07/17] [DEBUG] CMySQLQuery::Execute[LoadFracVehicles_Data] - query was successfully executed within 0.61 milliseconds
[23:48:28 03/07/17] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[23:48:28 03/07/17] [DEBUG] Calling callback "LoadFracVehicles_Data"..
[23:48:28 03/07/17] [DEBUG] cache_get_row_count - connection: 1
[23:48:28 03/07/17] [DEBUG] cache_get_field_content_int - row: 0, field_name: "ID", connection: 1
[23:48:28 03/07/17] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "ID", data: "1"
[23:48:28 03/07/17] [DEBUG] cache_get_field_content_int - row: 0, field_name: "fCarid", connection: 1
[23:48:28 03/07/17] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "fCarid", data: "0"
[23:48:28 03/07/17] [DEBUG] cache_get_field_content_int - row: 0, field_name: "fVehid", connection: 1
[23:48:28 03/07/17] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "fVehid", data: "560"
[23:48:28 03/07/17] [DEBUG] cache_get_field_content_float - row: 0, field_name: "fPosX", connection: 1
[23:48:28 03/07/17] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "fPosX", data: "1553.79"
[23:48:28 03/07/17] [DEBUG] cache_get_field_content_float - row: 0, field_name: "fPosY", connection: 1
[23:48:28 03/07/17] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "fPosY", data: "-1739.51"
[23:48:28 03/07/17] [DEBUG] cache_get_field_content_float - row: 0, field_name: "fPosZ", connection: 1
[23:48:28 03/07/17] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "fPosZ", data: "13.5469"
[23:48:28 03/07/17] [DEBUG] cache_get_field_content_float - row: 0, field_name: "fPosA", connection: 1
[23:48:28 03/07/17] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "fPosA", data: "73.2695"
[23:48:28 03/07/17] [DEBUG] cache_get_field_content_int - row: 0, field_name: "fCol1", connection: 1
[23:48:28 03/07/17] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "fCol1", data: "-1"
[23:48:28 03/07/17] [DEBUG] cache_get_field_content_int - row: 0, field_name: "fCol2", connection: 1
[23:48:28 03/07/17] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "fCol2", data: "-1"
[23:48:28 03/07/17] [DEBUG] cache_get_field_content_int - row: 0, field_name: "fFaction1", connection: 1
[23:48:28 03/07/17] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "fFaction1", data: "1"
[23:48:28 03/07/17] [DEBUG] cache_get_field_content_int - row: 0, field_name: "fFaction2", connection: 1
[23:48:28 03/07/17] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "fFaction2", data: "0"
[23:48:28 03/07/17] [DEBUG] cache_get_field_content_int - row: 0, field_name: "fFaction3", connection: 1
[23:48:28 03/07/17] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "fFaction3", data: "0"
[23:48:28 03/07/17] [DEBUG] cache_get_field_content_int - row: 0, field_name: "fFaction4", connection: 1
[23:48:28 03/07/17] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "fFaction4", data: "0"
[23:48:28 03/07/17] [DEBUG] cache_get_field_content_int - row: 0, field_name: "fFaction5", connection: 1
[23:48:28 03/07/17] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "fFaction5", data: "0"
[23:48:28 03/07/17] [DEBUG] cache_get_field_content_int - row: 0, field_name: "fSpoiler", connection: 1
[23:48:28 03/07/17] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "fSpoiler", data: "0"
[23:48:28 03/07/17] [DEBUG] cache_get_field_content_int - row: 0, field_name: "fHood", connection: 1
[23:48:28 03/07/17] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "fHood", data: "0"
[23:48:28 03/07/17] [DEBUG] cache_get_field_content_int - row: 0, field_name: "fRoof", connection: 1
[23:48:28 03/07/17] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "fRoof", data: "0"
[23:48:28 03/07/17] [DEBUG] cache_get_field_content_int - row: 0, field_name: "fSideskirt", connection: 1
[23:48:28 03/07/17] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "fSideskirt", data: "0"
[23:48:28 03/07/17] [DEBUG] cache_get_field_content_int - row: 0, field_name: "fLamps", connection: 1
[23:48:28 03/07/17] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "fLamps", data: "0"
[23:48:28 03/07/17] [DEBUG] cache_get_field_content_int - row: 0, field_name: "fNitro", connection: 1
[23:48:28 03/07/17] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "fNitro", data: "0"
[23:48:28 03/07/17] [DEBUG] cache_get_field_content_int - row: 0, field_name: "fExhaust", connection: 1
[23:48:28 03/07/17] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "fExhaust", data: "0"
[23:48:28 03/07/17] [DEBUG] cache_get_field_content_int - row: 0, field_name: "fWheel", connection: 1
[23:48:28 03/07/17] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "fWheel", data: "0"
[23:48:28 03/07/17] [DEBUG] cache_get_field_content_int - row: 0, field_name: "fStereo", connection: 1
[23:48:28 03/07/17] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "fStereo", data: "0"
[23:48:28 03/07/17] [DEBUG] cache_get_field_content_int - row: 0, field_name: "fHydraulics", connection: 1
[23:48:28 03/07/17] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "fHydraulics", data: "0"
[23:48:28 03/07/17] [DEBUG] cache_get_field_content_int - row: 0, field_name: "fFrontBumper", connection: 1
[23:48:28 03/07/17] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "fFrontBumper", data: "0"
[23:48:28 03/07/17] [DEBUG] cache_get_field_content_int - row: 0, field_name: "fVent1", connection: 1
[23:48:28 03/07/17] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "fVent1", data: "0"
[23:48:28 03/07/17] [DEBUG] cache_get_field_content_int - row: 0, field_name: "fRearBumper", connection: 1
[23:48:28 03/07/17] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "fRearBumper", data: "0"
[23:48:28 03/07/17] [DEBUG] cache_get_field_content_int - row: 0, field_name: "fVent2", connection: 1
[23:48:28 03/07/17] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "fVent2", data: "0"
[23:48:28 03/07/17] [DEBUG] cache_get_field_content_int - row: 0, field_name: "fPaintjob", connection: 1
[23:48:28 03/07/17] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "fPaintjob", data: "0"
[23:48:28 03/07/17] [DEBUG] cache_get_field_content_int - row: 0, field_name: "fPrice", connection: 1
[23:48:28 03/07/17] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "fPrice", data: "300000"
[23:48:28 03/07/17] [DEBUG] cache_get_field_content_int - row: 0, field_name: "fTankart", connection: 1
[23:48:28 03/07/17] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "fTankart", data: "1"
[23:48:28 03/07/17] [DEBUG] cache_get_field_content_int - row: 0, field_name: "fGesperrt", connection: 1
[23:48:28 03/07/17] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "fGesperrt", data: "0"
[23:48:28 03/07/17] [DEBUG] cache_get_field_content_int - row: 0, field_name: "fMotorschaden", connection: 1
[23:48:28 03/07/17] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "fMotorschaden", data: "0"
[23:48:28 03/07/17] [DEBUG] cache_get_field_content_int - row: 0, field_name: "fSperrpreis", connection: 1
[23:48:28 03/07/17] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "fSperrpreis", data: "0"
[23:48:28 03/07/17] [DEBUG] cache_get_field_content_int - row: 1, field_name: "ID", connection: 1
[23:48:28 03/07/17] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "ID", data: "2"
[23:48:28 03/07/17] [DEBUG] cache_get_field_content_int - row: 1, field_name: "fCarid", connection: 1
[23:48:28 03/07/17] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "fCarid", data: "0"
[23:48:28 03/07/17] [DEBUG] cache_get_field_content_int - row: 1, field_name: "fVehid", connection: 1
[23:48:28 03/07/17] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "fVehid", data: "560"
[23:48:28 03/07/17] [DEBUG] cache_get_field_content_float - row: 1, field_name: "fPosX", connection: 1
[23:48:28 03/07/17] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "fPosX", data: "1525.19"
[23:48:28 03/07/17] [DEBUG] cache_get_field_content_float - row: 1, field_name: "fPosY", connection: 1
[23:48:28 03/07/17] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "fPosY", data: "-1736.94"
[23:48:28 03/07/17] [DEBUG] cache_get_field_content_float - row: 1, field_name: "fPosZ", connection: 1
[23:48:28 03/07/17] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "fPosZ", data: "13.3828"
[23:48:28 03/07/17] [DEBUG] cache_get_field_content_float - row: 1, field_name: "fPosA", connection: 1
[23:48:28 03/07/17] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "fPosA", data: "356.051"
[23:48:28 03/07/17] [DEBUG] cache_get_field_content_int - row: 1, field_name: "fCol1", connection: 1
[23:48:28 03/07/17] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "fCol1", data: "-1"
[23:48:28 03/07/17] [DEBUG] cache_get_field_content_int - row: 1, field_name: "fCol2", connection: 1
[23:48:28 03/07/17] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "fCol2", data: "-1"
[23:48:28 03/07/17] [DEBUG] cache_get_field_content_int - row: 1, field_name: "fFaction1", connection: 1
[23:48:28 03/07/17] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "fFaction1", data: "1"
[23:48:28 03/07/17] [DEBUG] cache_get_field_content_int - row: 1, field_name: "fFaction2", connection: 1
[23:48:28 03/07/17] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "fFaction2", data: "0"
[23:48:28 03/07/17] [DEBUG] cache_get_field_content_int - row: 1, field_name: "fFaction3", connection: 1
[23:48:28 03/07/17] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "fFaction3", data: "0"
[23:48:28 03/07/17] [DEBUG] cache_get_field_content_int - row: 1, field_name: "fFaction4", connection: 1
[23:48:28 03/07/17] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "fFaction4", data: "0"
[23:48:28 03/07/17] [DEBUG] cache_get_field_content_int - row: 1, field_name: "fFaction5", connection: 1
[23:48:28 03/07/17] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "fFaction5", data: "0"
[23:48:28 03/07/17] [DEBUG] cache_get_field_content_int - row: 1, field_name: "fSpoiler", connection: 1
[23:48:28 03/07/17] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "fSpoiler", data: "0"
[23:48:28 03/07/17] [DEBUG] cache_get_field_content_int - row: 1, field_name: "fHood", connection: 1
[23:48:28 03/07/17] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "fHood", data: "0"
[23:48:28 03/07/17] [DEBUG] cache_get_field_content_int - row: 1, field_name: "fRoof", connection: 1
[23:48:28 03/07/17] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "fRoof", data: "0"
[23:48:28 03/07/17] [DEBUG] cache_get_field_content_int - row: 1, field_name: "fSideskirt", connection: 1
[23:48:28 03/07/17] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "fSideskirt", data: "0"
[23:48:28 03/07/17] [DEBUG] cache_get_field_content_int - row: 1, field_name: "fLamps", connection: 1
[23:48:28 03/07/17] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "fLamps", data: "0"
[23:48:28 03/07/17] [DEBUG] cache_get_field_content_int - row: 1, field_name: "fNitro", connection: 1
[23:48:28 03/07/17] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "fNitro", data: "0"
[23:48:28 03/07/17] [DEBUG] cache_get_field_content_int - row: 1, field_name: "fExhaust", connection: 1
[23:48:28 03/07/17] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "fExhaust", data: "0"
[23:48:28 03/07/17] [DEBUG] cache_get_field_content_int - row: 1, field_name: "fWheel", connection: 1
[23:48:28 03/07/17] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "fWheel", data: "0"
[23:48:28 03/07/17] [DEBUG] cache_get_field_content_int - row: 1, field_name: "fStereo", connection: 1
[23:48:28 03/07/17] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "fStereo", data: "0"
[23:48:28 03/07/17] [DEBUG] cache_get_field_content_int - row: 1, field_name: "fHydraulics", connection: 1
[23:48:28 03/07/17] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "fHydraulics", data: "0"
[23:48:28 03/07/17] [DEBUG] cache_get_field_content_int - row: 1, field_name: "fFrontBumper", connection: 1
[23:48:28 03/07/17] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "fFrontBumper", data: "0"
[23:48:28 03/07/17] [DEBUG] cache_get_field_content_int - row: 1, field_name: "fVent1", connection: 1
[23:48:28 03/07/17] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "fVent1", data: "0"
[23:48:28 03/07/17] [DEBUG] cache_get_field_content_int - row: 1, field_name: "fRearBumper", connection: 1
[23:48:28 03/07/17] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "fRearBumper", data: "0"
[23:48:28 03/07/17] [DEBUG] cache_get_field_content_int - row: 1, field_name: "fVent2", connection: 1
[23:48:28 03/07/17] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "fVent2", data: "0"
[23:48:28 03/07/17] [DEBUG] cache_get_field_content_int - row: 1, field_name: "fPaintjob", connection: 1
[23:48:28 03/07/17] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "fPaintjob", data: "0"
[23:48:28 03/07/17] [DEBUG] cache_get_field_content_int - row: 1, field_name: "fPrice", connection: 1
[23:48:28 03/07/17] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "fPrice", data: "300000"
[23:48:28 03/07/17] [DEBUG] cache_get_field_content_int - row: 1, field_name: "fTankart", connection: 1
[23:48:28 03/07/17] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "fTankart", data: "2"
[23:48:28 03/07/17] [DEBUG] cache_get_field_content_int - row: 1, field_name: "fGesperrt", connection: 1
[23:48:28 03/07/17] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "fGesperrt", data: "0"
[23:48:28 03/07/17] [DEBUG] cache_get_field_content_int - row: 1, field_name: "fMotorschaden", connection: 1
[23:48:28 03/07/17] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "fMotorschaden", data: "0"
[23:48:28 03/07/17] [DEBUG] cache_get_field_content_int - row: 1, field_name: "fSperrpreis", connection: 1
[23:48:28 03/07/17] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "fSperrpreis", data: "0"
[23:48:28 03/07/17] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called

Alles anzeigen

RedDragon28080 · 7. März 2017

Zitat von robbi2304

format(query, sizeof(query), "%s WHERE `id` = '%d'", string, i); in beiden Teilen

zu

format(query, sizeof(query), "%s WHERE id = '%d'", string, i);

hat nicht geholfen speichern immer noch nocht ab

RedDragon28080 · 7. März 2017

danke Jeffry

habe das letzte problem und zwar wir das Fahrzeug erstellt und geladen aber es wird nicht gespeichert

CSS: msql_log

[22:30:45 03/07/17] [DEBUG] mysql_connect - host: "localhost", user: "samp6231", database: "samp6231_samp", password: "****", port: 3306, autoreconnect: true, pool_size: 2
[22:30:45 03/07/17] [DEBUG] CMySQLHandle::Create - creating new connection..
[22:30:45 03/07/17] [DEBUG] CMySQLHandle::CMySQLHandle - constructor called
[22:30:45 03/07/17] [DEBUG] CMySQLHandle::Create - connection created (id: 1)
[22:30:45 03/07/17] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[22:30:45 03/07/17] [DEBUG] CMySQLConnection::Connect - connection was successful
[22:30:45 03/07/17] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[22:30:45 03/07/17] [DEBUG] mysql_errno - connection: 1
[22:30:45 03/07/17] [DEBUG] mysql_pquery - connection: 1, query: "SELECT * FROM FracVehicles ORDER BY ID ASC", callback: "LoadFracVehicles_Data", format: "(null)"
[22:30:45 03/07/17] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[22:30:45 03/07/17] [DEBUG] CMySQLConnection::Connect - connection was successful
[22:30:45 03/07/17] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[22:30:45 03/07/17] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[22:30:45 03/07/17] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[22:30:45 03/07/17] [DEBUG] CMySQLConnection::Connect - connection was successful
[22:30:45 03/07/17] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[22:30:45 03/07/17] [DEBUG] CMySQLQuery::Execute[LoadFracVehicles_Data] - starting query execution
[22:30:45 03/07/17] [DEBUG] CMySQLQuery::Execute[LoadFracVehicles_Data] - query was successfully executed within 0.69 milliseconds
[22:30:45 03/07/17] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[22:30:45 03/07/17] [DEBUG] CMySQLConnection::Connect - connection was successful
[22:30:45 03/07/17] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[22:30:45 03/07/17] [DEBUG] Calling callback "LoadFracVehicles_Data"..
[22:30:45 03/07/17] [DEBUG] cache_get_row_count - connection: 1
[22:30:45 03/07/17] [DEBUG] cache_get_field_content_int - row: 0, field_name: "ID", connection: 1
[22:30:45 03/07/17] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "ID", data: "1"
[22:30:45 03/07/17] [DEBUG] cache_get_field_content_int - row: 0, field_name: "fCarid", connection: 1
[22:30:45 03/07/17] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "fCarid", data: "0"
[22:30:45 03/07/17] [DEBUG] cache_get_field_content_int - row: 0, field_name: "fVehid", connection: 1
[22:30:45 03/07/17] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "fVehid", data: "560"
[22:30:45 03/07/17] [DEBUG] cache_get_field_content_float - row: 0, field_name: "fPosX", connection: 1
[22:30:45 03/07/17] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "fPosX", data: "1553.79"
[22:30:45 03/07/17] [DEBUG] cache_get_field_content_float - row: 0, field_name: "fPosY", connection: 1
[22:30:45 03/07/17] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "fPosY", data: "-1739.51"
[22:30:45 03/07/17] [DEBUG] cache_get_field_content_float - row: 0, field_name: "fPosZ", connection: 1
[22:30:45 03/07/17] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "fPosZ", data: "13.5469"
[22:30:45 03/07/17] [DEBUG] cache_get_field_content_float - row: 0, field_name: "fPosA", connection: 1
[22:30:45 03/07/17] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "fPosA", data: "73.2695"
[22:30:45 03/07/17] [DEBUG] cache_get_field_content_int - row: 0, field_name: "fCol1", connection: 1
[22:30:45 03/07/17] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "fCol1", data: "-1"
[22:30:45 03/07/17] [DEBUG] cache_get_field_content_int - row: 0, field_name: "fCol2", connection: 1
[22:30:45 03/07/17] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "fCol2", data: "-1"
[22:30:45 03/07/17] [DEBUG] cache_get_field_content_int - row: 0, field_name: "fFaction1", connection: 1
[22:30:45 03/07/17] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "fFaction1", data: "1"
[22:30:45 03/07/17] [DEBUG] cache_get_field_content_int - row: 0, field_name: "fFaction2", connection: 1
[22:30:45 03/07/17] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "fFaction2", data: "0"
[22:30:45 03/07/17] [DEBUG] cache_get_field_content_int - row: 0, field_name: "fFaction3", connection: 1
[22:30:45 03/07/17] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "fFaction3", data: "0"
[22:30:45 03/07/17] [DEBUG] cache_get_field_content_int - row: 0, field_name: "fFaction4", connection: 1
[22:30:45 03/07/17] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "fFaction4", data: "0"
[22:30:45 03/07/17] [DEBUG] cache_get_field_content_int - row: 0, field_name: "fFaction5", connection: 1
[22:30:45 03/07/17] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "fFaction5", data: "0"
[22:30:45 03/07/17] [DEBUG] cache_get_field_content_int - row: 0, field_name: "fSpoiler", connection: 1
[22:30:45 03/07/17] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "fSpoiler", data: "0"
[22:30:45 03/07/17] [DEBUG] cache_get_field_content_int - row: 0, field_name: "fHood", connection: 1
[22:30:45 03/07/17] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "fHood", data: "0"
[22:30:45 03/07/17] [DEBUG] cache_get_field_content_int - row: 0, field_name: "fRoof", connection: 1
[22:30:45 03/07/17] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "fRoof", data: "0"
[22:30:45 03/07/17] [DEBUG] cache_get_field_content_int - row: 0, field_name: "fSideskirt", connection: 1
[22:30:45 03/07/17] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "fSideskirt", data: "0"
[22:30:45 03/07/17] [DEBUG] cache_get_field_content_int - row: 0, field_name: "fLamps", connection: 1
[22:30:45 03/07/17] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "fLamps", data: "0"
[22:30:45 03/07/17] [DEBUG] cache_get_field_content_int - row: 0, field_name: "fNitro", connection: 1
[22:30:45 03/07/17] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "fNitro", data: "0"
[22:30:45 03/07/17] [DEBUG] cache_get_field_content_int - row: 0, field_name: "fExhaust", connection: 1
[22:30:45 03/07/17] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "fExhaust", data: "0"
[22:30:45 03/07/17] [DEBUG] cache_get_field_content_int - row: 0, field_name: "fWheel", connection: 1
[22:30:45 03/07/17] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "fWheel", data: "0"
[22:30:45 03/07/17] [DEBUG] cache_get_field_content_int - row: 0, field_name: "fStereo", connection: 1
[22:30:45 03/07/17] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "fStereo", data: "0"
[22:30:45 03/07/17] [DEBUG] cache_get_field_content_int - row: 0, field_name: "fHydraulics", connection: 1
[22:30:45 03/07/17] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "fHydraulics", data: "0"
[22:30:45 03/07/17] [DEBUG] cache_get_field_content_int - row: 0, field_name: "fFrontBumper", connection: 1
[22:30:45 03/07/17] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "fFrontBumper", data: "0"
[22:30:45 03/07/17] [DEBUG] cache_get_field_content_int - row: 0, field_name: "fVent1", connection: 1
[22:30:45 03/07/17] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "fVent1", data: "0"
[22:30:45 03/07/17] [DEBUG] cache_get_field_content_int - row: 0, field_name: "fRearBumper", connection: 1
[22:30:45 03/07/17] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "fRearBumper", data: "0"
[22:30:45 03/07/17] [DEBUG] cache_get_field_content_int - row: 0, field_name: "fVent2", connection: 1
[22:30:45 03/07/17] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "fVent2", data: "0"
[22:30:45 03/07/17] [DEBUG] cache_get_field_content_int - row: 0, field_name: "fPaintjob", connection: 1
[22:30:45 03/07/17] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "fPaintjob", data: "0"
[22:30:45 03/07/17] [DEBUG] cache_get_field_content_int - row: 0, field_name: "fPrice", connection: 1
[22:30:45 03/07/17] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "fPrice", data: "300000"
[22:30:45 03/07/17] [DEBUG] cache_get_field_content_int - row: 0, field_name: "fTankart", connection: 1
[22:30:45 03/07/17] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "fTankart", data: "1"
[22:30:45 03/07/17] [DEBUG] cache_get_field_content_int - row: 0, field_name: "fGesperrt", connection: 1
[22:30:45 03/07/17] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "fGesperrt", data: "0"
[22:30:45 03/07/17] [DEBUG] cache_get_field_content_int - row: 0, field_name: "fMotorschaden", connection: 1
[22:30:45 03/07/17] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "fMotorschaden", data: "0"
[22:30:45 03/07/17] [DEBUG] cache_get_field_content_int - row: 0, field_name: "fSperrpreis", connection: 1
[22:30:45 03/07/17] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "fSperrpreis", data: "0"
[22:30:45 03/07/17] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[22:31:47 03/07/17] [DEBUG] mysql_pquery - connection: 1, query: " WHERE `id` = '1'", callback: "(null)", format: "(null)"
[22:31:47 03/07/17] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[22:31:47 03/07/17] [ERROR] CMySQLQuery::Execute[] - (error #1064) 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 'WHERE `id` = '1'' at line 1 (Query: " WHERE `id` = '1'")
[22:31:47 03/07/17] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError

Alles anzeigen

und hier die Speicher Codes

Code: SaveFracVehCheck

stock SaveFracVehCheck(vehicleid)
{
	//Deklaration neuer temporärer Variablen:
	new query[3048],string[3048];


	//Schleife durch alle Fraktions-Fahrzeuge
	for(new i=0; i<MAX_FRAC_VEHICLES; i++)
	{
		//Wenn die vehicleid die gleiche ist, wie die des Fraktions-Fahrzeugs
		if(FactionCars[i][fCarid] == vehicleid)
		{
			//Wir fragen die Position des Fahrzeugs ab:
			GetVehiclePos(FactionCars[i][fCarid], FactionCars[i][fPos][0], FactionCars[i][fPos][1], FactionCars[i][fPos][2]);
			GetVehicleZAngle(FactionCars[i][fCarid], FactionCars[i][fPos][3]);


			//Und wir erstellen das Query:
			format(query, sizeof(query), "UPDATE FracVehicles SET");
			format(query, sizeof(query), "%s`fVehid`='%s', ", string, FactionCars[i][fVehid]);
			format(query, sizeof(query), "%s`fPosX`='%f', ",  string, FactionCars[i][fPos][0]);
			format(query, sizeof(query), "%s`fPosY`='%f', ",  string, FactionCars[i][fPos][1]);
			format(query, sizeof(query), "%s`fPosZ`='%f', ",  string, FactionCars[i][fPos][2]);
			format(query, sizeof(query), "%s`fPosA`='%f', ",  string, FactionCars[i][fPos][3]);
			format(query, sizeof(query), "%s`fCol1`='%d' ",  string, FactionCars[i][fCol][0]);
			format(query, sizeof(query), "%s`fCol2`='%d' ",  string, FactionCars[i][fCol][1]);
			format(query, sizeof(query), "%s`fFaction1`='%d' ",  string, FactionCars[i][fFaction][0]);
			format(query, sizeof(query), "%s`fFaction2`='%d' ",  string, FactionCars[i][fFaction][1]);
			format(query, sizeof(query), "%s`fFaction3`='%d' ",  string, FactionCars[i][fFaction][2]);
			format(query, sizeof(query), "%s`fFaction4`='%d' ",  string, FactionCars[i][fFaction][3]);
			format(query, sizeof(query), "%s`fFaction5`='%d' ",  string, FactionCars[i][fFaction][4]);
			format(query, sizeof(query), "%s`fSpoiler`='%d' ",  string, FactionCars[i][fTuning][0]);
			format(query, sizeof(query), "%s`fHood`='%d' ",  string, FactionCars[i][fTuning][1]);
			format(query, sizeof(query), "%s`fRoof`='%d' ",  string, FactionCars[i][fTuning][2]);
			format(query, sizeof(query), "%s`fSideskirt`='%d' ",  string, FactionCars[i][fTuning][3]);
			format(query, sizeof(query), "%s`fLamps`='%d' ",  string, FactionCars[i][fTuning][4]);
			format(query, sizeof(query), "%s`fNitro`='%d' ",  string, FactionCars[i][fTuning][5]);
			format(query, sizeof(query), "%s`fExhaust`='%d' ",  string, FactionCars[i][fTuning][6]);
			format(query, sizeof(query), "%s`fWheel`='%d' ",  string, FactionCars[i][fTuning][7]);
			format(query, sizeof(query), "%s`fStereo`='%d' ",  string, FactionCars[i][fTuning][8]);
			format(query, sizeof(query), "%s`fHydraulics`='%d' ",  string, FactionCars[i][fTuning][9]);
			format(query, sizeof(query), "%s`fFrontBumper`='%d' ",  string, FactionCars[i][fTuning][10]);
			format(query, sizeof(query), "%s`fVent1`='%d' ",  string, FactionCars[i][fTuning][11]);
			format(query, sizeof(query), "%s`fRearBumper`='%d' ",  string, FactionCars[i][fTuning][12]);
			format(query, sizeof(query), "%s`fVent2`='%d' ",  string, FactionCars[i][fTuning][13]);
			format(query, sizeof(query), "%s`fPaintjob`='%d' ",  string, FactionCars[i][fTuning][14]);
			format(query, sizeof(query), "%s`fPrice`='%d' ",  string, FactionCars[i][fPrice]);
			format(query, sizeof(query), "%s`fTankart`='%d' ",  string, FactionCars[i][fTankart]);
			format(query, sizeof(query), "%s`fGesperrt`='%d' ",  string, FactionCars[i][fGesperrt]);
			format(query, sizeof(query), "%s`fMotorschaden`='%d' ",  string, FactionCars[i][fMotorschaden]);
			format(query, sizeof(query), "%s`fSperrpreis`='%d' ",  string, FactionCars[i][fSperrpreis]);
			format(query, sizeof(query), "%s WHERE `id` = '%d'", string, i);
			//handle = die Connection Handle ID die vor mysql_connect steht.
			mysql_pquery(handle, query);
			return 1; //Es gibt ja keine zwei gleichen Fahrzeuge
		}
	}
	return 0; //Fahrzeug ist kein Fraktions-Fahrzeug
}

Alles anzeigen

Code: SaveAllFracVehs

forward SaveAllFracVehs();
public SaveAllFracVehs()
{
	//Deklaration neuer temporärer Variablen:
	new query[3048],string[250];


	//Schleife durch alle Fraktions-Fahrzeuge
	for(new i=0; i<MAX_FRAC_VEHICLES; i++)
	{
		//Wenn das Fahrzeug existiert
		if(FactionCars[i][fVehid] >= 400 && FactionCars[i][fVehid] <= 611)
		{
			//Wir fragen die Position des Fahrzeugs ab:
			GetVehiclePos(FactionCars[i][fCarid], FactionCars[i][fPos][0], FactionCars[i][fPos][1], FactionCars[i][fPos][2]);
			GetVehicleZAngle(FactionCars[i][fCarid], FactionCars[i][fPos][3]);


			//Und wir erstellen das Query:
			format(query, sizeof(query), "UPDATE `FracVehicles` SET ");
			format(query, sizeof(query), "%s`fVehid`='%s', ", string, FactionCars[i][fVehid]);
			format(query, sizeof(query), "%s`fPosX`='%f', ",  string, FactionCars[i][fPos][0]);
			format(query, sizeof(query), "%s`fPosY`='%f', ",  string, FactionCars[i][fPos][1]);
			format(query, sizeof(query), "%s`fPosZ`='%f', ",  string, FactionCars[i][fPos][2]);
			format(query, sizeof(query), "%s`fPosA`='%f', ",  string, FactionCars[i][fPos][3]);
			format(query, sizeof(query), "%s`fCol1`='%d' ",  string, FactionCars[i][fCol][0]);
			format(query, sizeof(query), "%s`fCol2`='%d' ",  string, FactionCars[i][fCol][1]);
			format(query, sizeof(query), "%s`fFaction1`='%d' ",  string, FactionCars[i][fFaction][0]);
			format(query, sizeof(query), "%s`fFaction2`='%d' ",  string, FactionCars[i][fFaction][1]);
			format(query, sizeof(query), "%s`fFaction3`='%d' ",  string, FactionCars[i][fFaction][2]);
			format(query, sizeof(query), "%s`fFaction4`='%d' ",  string, FactionCars[i][fFaction][3]);
			format(query, sizeof(query), "%s`fFaction5`='%d' ",  string, FactionCars[i][fFaction][4]);
			format(query, sizeof(query), "%s`fSpoiler`='%d' ",  string, FactionCars[i][fTuning][0]);
			format(query, sizeof(query), "%s`fHood`='%d' ",  string, FactionCars[i][fTuning][1]);
			format(query, sizeof(query), "%s`fRoof`='%d' ",  string, FactionCars[i][fTuning][2]);
			format(query, sizeof(query), "%s`fSideskirt`='%d' ",  string, FactionCars[i][fTuning][3]);
			format(query, sizeof(query), "%s`fLamps`='%d' ",  string, FactionCars[i][fTuning][4]);
			format(query, sizeof(query), "%s`fNitro`='%d' ",  string, FactionCars[i][fTuning][5]);
			format(query, sizeof(query), "%s`fExhaust`='%d' ",  string, FactionCars[i][fTuning][6]);
			format(query, sizeof(query), "%s`fWheel`='%d' ",  string, FactionCars[i][fTuning][7]);
			format(query, sizeof(query), "%s`fStereo`='%d' ",  string, FactionCars[i][fTuning][8]);
			format(query, sizeof(query), "%s`fHydraulics`='%d' ",  string, FactionCars[i][fTuning][9]);
			format(query, sizeof(query), "%s`fFrontBumper`='%d' ",  string, FactionCars[i][fTuning][10]);
			format(query, sizeof(query), "%s`fVent1`='%d' ",  string, FactionCars[i][fTuning][11]);
			format(query, sizeof(query), "%s`fRearBumper`='%d' ",  string, FactionCars[i][fTuning][12]);
			format(query, sizeof(query), "%s`fVent2`='%d' ",  string, FactionCars[i][fTuning][13]);
			format(query, sizeof(query), "%s`fPaintjob`='%d' ",  string, FactionCars[i][fTuning][14]);
			format(query, sizeof(query), "%s`fPrice`='%d' ",  string, FactionCars[i][fPrice]);
			format(query, sizeof(query), "%s`fTankart`='%d' ",  string, FactionCars[i][fTankart]);
			format(query, sizeof(query), "%s`fGesperrt`='%d' ",  string, FactionCars[i][fGesperrt]);
			format(query, sizeof(query), "%s`fMotorschaden`='%d' ",  string, FactionCars[i][fMotorschaden]);
			format(query, sizeof(query), "%s`fSperrpreis`='%d' ",  string, FactionCars[i][fSperrpreis]);
			format(query, sizeof(query), "%s WHERE `id` = '%d'", string, i);
			//handle = die Connection Handle ID die vor mysql_connect steht.
			mysql_pquery(handle, query);
		}
	}
	return 1;
}

Alles anzeigen

RedDragon28080 · 7. März 2017

Zitat von Jeffry

Lösche den Log, führe dann das aus was nicht funktioniert, und poste dann den Log nochmal.

Das wahr schon der neuste von einen restart habe jetzt aber was ausgeklammert

Code

[09:54:43 03/07/17] [ERROR] mysql_pquery - invalid connection handle (id: 0)
[09:54:43 03/07/17] [ERROR] mysql_pquery - invalid connection handle (id: 0)
[09:54:43 03/07/17] [DEBUG] mysql_connect - host: "localhost", user: "samp6231", database: "samp6231_samp", password: "****", port: 3306, autoreconnect: true, pool_size: 2
[09:54:43 03/07/17] [DEBUG] CMySQLHandle::Create - creating new connection..
[09:54:43 03/07/17] [DEBUG] CMySQLHandle::CMySQLHandle - constructor called
[09:54:43 03/07/17] [DEBUG] CMySQLHandle::Create - connection created (id: 1)
[09:54:43 03/07/17] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[09:54:43 03/07/17] [DEBUG] CMySQLConnection::Connect - connection was successful
[09:54:43 03/07/17] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[09:54:43 03/07/17] [DEBUG] mysql_errno - connection: 1
[09:54:43 03/07/17] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[09:54:43 03/07/17] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[09:54:43 03/07/17] [DEBUG] CMySQLConnection::Connect - connection was successful
[09:54:43 03/07/17] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[09:54:43 03/07/17] [DEBUG] CMySQLConnection::Connect - connection was successful
[09:54:43 03/07/17] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[09:54:43 03/07/17] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[09:54:43 03/07/17] [DEBUG] CMySQLConnection::Connect - connection was successful
[09:54:43 03/07/17] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled

Alles anzeigen

ich versuche gerade es so zu machen das meine Fraktionscars über MSQl speichern un d nicht über dini

RedDragon28080 · 6. März 2017

Zitat von Jeffry

Gibt dir denn der MySQL Log etwas aus?

weis ich nicht, ich sehe da sowieso nicht durch

--> msql_log <-- das wahr zu grpß

Zitat von Jeffry

Was wird nicht erstellt?

sowas nur von mir erstelltes

RedDragon28080 · 6. März 2017

vielendank Jeffry

habe aber zu dieses Fraktionscar noch ein Problem und zwar wird nichts im MSQL ertsellt

hier der code kannst du noich mal rübeschauen und mir sagen wo ich den fehler habe

Code

public OnGameModeInit()
{
   	LoadFracVehicles();
        SetTimer("SaveAllFracVehs", 60000, true); 
	return 1;
}
LoadFracVehicles()
{
	print("LoadFracVehicles 1");
	CreateFVTable();
	print("LoadFracVehicles 2");
	//handle = die Connection Handle ID die vor mysql_connect steht.
	//Es wird ein SELECT Query an die Datenbank gesendet, diese gibt über das Callback LoadFracVehicles_Data
	//die Daten im Cache zurück.
	mysql_tquery(handle, "SELECT * FROM FracVehicles ORDER BY ID ASC", "LoadFracVehicles_Data");
	return 1;
}


CreateFVTable()
{
	new query[512];
	print("Tabelle für FracVehicles erstellt 1");
	format(query, sizeof(query), "CREATE TABLE IF NOT EXISTS `FracVehicles` (");
	format(query, sizeof(query), "%s`ID` int(11) NOT NULL PRIMARY KEY,", query);
	format(query, sizeof(query), "%s  `fCarid` int(11) NOT NULL DEFAULT '0',", query);
	format(query, sizeof(query), "%s  `fVehid` int(11) NOT NULL DEFAULT '0',", query);
	format(query, sizeof(query), "%s  `fPosX` float NOT NULL DEFAULT '0',", query);
	format(query, sizeof(query), "%s  `fPosY` float NOT NULL DEFAULT '0',", query);
	format(query, sizeof(query), "%s  `fPosZ` float NOT NULL DEFAULT '0',", query);
	format(query, sizeof(query), "%s  `fPosA` float NOT NULL DEFAULT '0',", query);
	format(query, sizeof(query), "%s  `fCol1` int(11) NOT NULL DEFAULT '0',", query);
	format(query, sizeof(query), "%s  `fCol2` int(11) NOT NULL DEFAULT '0',", query);
	format(query, sizeof(query), "%s  `fFaction1` int(11) NOT NULL DEFAULT '-1'", query);
	format(query, sizeof(query), "%s  `fFaction2` int(11) NOT NULL DEFAULT '-1'", query);
	format(query, sizeof(query), "%s  `fFaction3` int(11) NOT NULL DEFAULT '-1'", query);
	format(query, sizeof(query), "%s  `fFaction4` int(11) NOT NULL DEFAULT '-1'", query);
	format(query, sizeof(query), "%s  `fFaction5` int(11) NOT NULL DEFAULT '-1'", query);
	format(query, sizeof(query), "%s  `fSpoiler` int(11) NOT NULL DEFAULT '0'", query);
	format(query, sizeof(query), "%s  `fHood` int(11) NOT NULL DEFAULT '0'", query);
	format(query, sizeof(query), "%s  `fRoof` int(11) NOT NULL DEFAULT '0'", query);
	format(query, sizeof(query), "%s  `fSideskirt` int(11) NOT NULL DEFAULT '0'", query);
	format(query, sizeof(query), "%s  `fLamps` int(11) NOT NULL DEFAULT '0'", query);
	format(query, sizeof(query), "%s  `fNitro` int(11) NOT NULL DEFAULT '0'", query);
	format(query, sizeof(query), "%s  `fExhaust` int(11) NOT NULL DEFAULT '0'", query);
	format(query, sizeof(query), "%s  `fWheel` int(11) NOT NULL DEFAULT '0'", query);
	format(query, sizeof(query), "%s  `fStereo` int(11) NOT NULL DEFAULT '0'", query);
	format(query, sizeof(query), "%s  `fHydraulics` int(11) NOT NULL DEFAULT '0'", query);
	format(query, sizeof(query), "%s  `fFrontBumper` int(11) NOT NULL DEFAULT '0'", query);
	format(query, sizeof(query), "%s  `fVent1` int(11) NOT NULL DEFAULT '0'", query);
	format(query, sizeof(query), "%s  `fRearBumper` int(11) NOT NULL DEFAULT '0'", query);
	format(query, sizeof(query), "%s  `fVent2` int(11) NOT NULL DEFAULT '0'", query);
	format(query, sizeof(query), "%s  `fPaintjob` int(11) NOT NULL DEFAULT '0'", query);
	format(query, sizeof(query), "%s  `fPrice` int(11) NOT NULL DEFAULT '0'", query);
	format(query, sizeof(query), "%s  `fTankart` int(11) NOT NULL DEFAULT '0'", query);
	format(query, sizeof(query), "%s  `fGesperrt` int(11) NOT NULL DEFAULT '0'", query);
	format(query, sizeof(query), "%s  `fMotorschaden` int(11) NOT NULL DEFAULT '0'", query);
	format(query, sizeof(query), "%s  `fSperrpreis` int(11) NOT NULL DEFAULT '0'", query);
	format(query, sizeof(query), "%s) ENGINE=InnoDB DEFAULT CHARSET=latin1;", query);
	//handle = die Connection Handle ID die vor mysql_connect steht.
	mysql_tquery(handle, query);
	print("Tabelle für FracVehicles erstellt 2");
	return 1;
}
dcmd_efa(playerid,params[])
{
	new query[256];
	if(Spielerinfo[playerid][pAdmin] >= 3)
	{
		if(AdminDuty[playerid] == 1)
		{
			new vehid,faction[5];
			if(!sscanf(params,"dd",vehid,faction[0]))
			{
				sscanf(params,"dddddd",vehid,faction[0],faction[1],faction[2],faction[3],faction[4]);
				if(vehid < 400 || vehid > 611) return SendClientMessage(playerid,FACTION_COL_GREY,"Vehicle-ID nur von 400 bis 611.");
				if(faction[0] && faction[0] <= MAX_FACTIONS)
				{
					printf("params: %s", params);
					printf("faction0: %d", faction[0]);
					for(new f=1;f<5;f++)
					{
						if(faction[f] <= 1 || faction[f] > MAX_FACTIONS)
						{
							printf("Setze %d auf -255", f);
							faction[f] = -255;
						}
					}
					for(new fc;fc<sizeof(FactionCars);fc++)
					{
						if(FactionCars[fc][fVehid] < 400 || FactionCars[fc][fVehid] > 611)
						{
							FactionCars[fc][fVehid] = vehid;
							new Float:fX,Float:fY,Float:fZ,Float:fA;
							GetPlayerPos(playerid,fX,fY,fZ),GetPlayerFacingAngle(playerid,fA);
							FactionCars[fc][fPos][0] = fX;
							FactionCars[fc][fPos][1] = fY;
							FactionCars[fc][fPos][2] = fZ;
							FactionCars[fc][fPos][3] = fA;
							new Color[2];
							GetDefaultCarColorOfFaction(GetPlayerLeader(playerid),Color[0],Color[1]);
							FactionCars[fc][fCol][0] = Color[0];
							FactionCars[fc][fCol][1] = Color[1];
							for(new f;f<5;f++)
							{
								printf("f%d = %d", f, faction[f]);
								FactionCars[fc][fFaction][f] = faction[f];
								printf("f%d set %d", f, FactionCars[fc][fFaction][f]);
							}
							new fTankartig = 1+ random(3);
							FactionCars[fc][fTankart] = fTankartig;
					       	for(new i = 0; i < sizeof(FactionBuylist); i++)
							{
								if(FactionCars[fc][fVehid] == FactionBuylist[i][fbVehid])
								{
									FactionCars[fc][fPrice] = FactionBuylist[i][fbPrice];
									break;
								}
							}
							format(query, sizeof(query), "INSERT INTO `FracVehicles` (`ID`, `fVehid`, `fPosX`, `fPosY`, `fPosZ`, `fPosA`, `fCol1`, `fCol2`, `fFaction1`, `fPrice`, `fTankart`) VALUES ('%d', '%d', '%f', '%f', '%f', '%f', '%d', '%d', '%d', '%d', '%d')",
							fc, FactionCars[fc][fVehid], FactionCars[fc][fPos][0], FactionCars[fc][fPos][1], FactionCars[fc][fPos][2], FactionCars[fc][fPos][3], FactionCars[fc][fCol][0], FactionCars[fc][fCol][1], FactionCars[fc][fFaction][0],
						 	FactionCars[fc][fPrice], FactionCars[fc][fTankart]);
							mysql_tquery(handle, query);
							FactionCars[fc][fCarid] = CreateVehicle(FactionCars[fc][fVehid],FactionCars[fc][fPos][0],FactionCars[fc][fPos][1],FactionCars[fc][fPos][2],FactionCars[fc][fPos][3],FactionCars[fc][fCol][0],FactionCars[fc][fCol][1],-1);
							printf("Carid: %d", FactionCars[fc][fCarid]);
							new pstring[128];
							new randomplate = 1 + random(20);
							format(pstring,sizeof(pstring),"%s %d",Factions[FactionCars[fc][fFaction][0]],randomplate);
							printf("pstring: %s", pstring);
							SetVehicleNumberPlate(FactionCars[fc][fCarid], pstring);
							SendClientMessage(playerid,FACTION_COL_YELLOW,"Du hast das Fraktionsfahrzeug erfolgreich erstellt.");
							PutPlayerInVehicle(playerid,FactionCars[fc][fCarid],0);
							printf("Fertig.");
							return true;
						}
					}
					SendClientMessage(playerid,FACTION_COL_GREY,"Die Maximale Anzahl von Fraktionsfahrzeugen wurde bereits erreicht.");
				}
				else SendClientMessage(playerid,FACTION_COL_GREY,"Falsche Fraktion!");
			}
			else SendClientMessage(playerid,FACTION_COL_GREY,"Benutze: '/efa [Model] [Hauptfraktion]'.");
		}
		else SendClientMessage(playerid,FACTION_COL_GREY,"Du bist nicht im Admindienst");
	}
	return 1;
}

Alles anzeigen

danke schön nochmal

RedDragon28080 · 6. März 2017

Closed

Hallo Liebes Breadfish

so wie es in den Titel steht habe ich 5 Error und bekomme die nicht weg.

Hier die Error

CSS: 5 error

C:\Users\Paddy\Desktop\Live you Life\gamemodes\LyL.pwn(79868) : error 075: input line too long (after substitutions)
C:\Users\Paddy\Desktop\Live you Life\gamemodes\LyL.pwn(79869) : error 037: invalid string (possibly non-terminated string)
C:\Users\Paddy\Desktop\Live you Life\gamemodes\LyL.pwn(79869) : error 017: undefined symbol "UPDATE"
C:\Users\Paddy\Desktop\Live you Life\gamemodes\LyL.pwn(79869) : error 029: invalid expression, assumed zero
C:\Users\Paddy\Desktop\Live you Life\gamemodes\LyL.pwn(79869) : fatal error 107: too many error messages on one line

und hier die zeile

Code

, `fFaction2`='%d', `fFaction3`='%d', `fFaction4`='%d', `fFaction5`='%d', `fSpoiler`='%d', `fHood`='%d', `fRoof`='%d', `fSideskirt`='%s', `fLamps`='%d', `fNitro`='%d' \
, `fExhaust`='%d', `fWheel`='%d', `fStereo`='%d', `fHydraulics`='%d', `fFrontBumper`='%d', `fVent1`='%d', `fRearBumper`='%d', `fVent2`='%s', `fPaintjob`='%d', `fPrice`='%d' \

und hier der ganze code

CSS

forward SaveAllFracVehs();
public SaveAllFracVehs()
{
	//Deklaration neuer temporärer Variablen:
	new query[2048];


	//Schleife durch alle Fraktions-Fahrzeuge
	for(new i=0; i<MAX_FRAC_VEHICLES; i++)
	{
		//Wenn das Fahrzeug existiert
		if(FactionCars[i][fVehid] >= 400 && FactionCars[i][fVehid] <= 611)
		{
			//Wir fragen die Position des Fahrzeugs ab:
			GetVehiclePos(FactionCars[i][fCarid], FactionCars[i][fPos][0], FactionCars[i][fPos][1], FactionCars[i][fPos][2]);
			GetVehicleZAngle(FactionCars[i][fCarid], FactionCars[i][fPos][3]);


			//Und wir erstellen das Query:
			format(query, sizeof(query), "UPDATE `FracVehicles` SET `fVehid`='%s', `fPosX`='%f', `fPosY`='%f', `fPosZ`='%f', `fPosA`='%f', `fCol1`='%d', `fCol2`='%d', `fFaction1`='%d' \
			, `fFaction2`='%d', `fFaction3`='%d', `fFaction4`='%d', `fFaction5`='%d', `fSpoiler`='%d', `fHood`='%d', `fRoof`='%d', `fSideskirt`='%s', `fLamps`='%d', `fNitro`='%d' \
			, `fExhaust`='%d', `fWheel`='%d', `fStereo`='%d', `fHydraulics`='%d', `fFrontBumper`='%d', `fVent1`='%d', `fRearBumper`='%d', `fVent2`='%s', `fPaintjob`='%d', `fPrice`='%d' \
			, `fTankart`='%d', `fGesperrt`='%d', `fMotorschaden`='%d', `fSperrpreis`='%d', `fFrontBumper`='%d', `fVent1`='%d', `fRearBumper`='%d', `fVent2`='%s', `fPaintjob`='%d', `fPrice`='%d' \
				WHERE `id` = '%d'",
			FactionCars[i][fVehid], FactionCars[i][fPos][0], FactionCars[i][fPos][1], FactionCars[i][fPos][2], FactionCars[i][fPos][3], FactionCars[i][fCol][0], FactionCars[i][fCol][1],
			FactionCars[i][fFaction][0], FactionCars[i][fFaction][1], FactionCars[i][fFaction][2], FactionCars[i][fFaction][3], FactionCars[i][fFaction][4], FactionCars[i][fTuning][0],
			FactionCars[i][fTuning][1], FactionCars[i][fTuning][2], FactionCars[i][fTuning][3], FactionCars[i][fTuning][4], FactionCars[i][fTuning][5], FactionCars[i][fTuning][6],
			FactionCars[i][fTuning][7], FactionCars[i][fTuning][8], FactionCars[i][fTuning][9], FactionCars[i][fTuning][10], FactionCars[i][fTuning][11], FactionCars[i][fTuning][12],
			FactionCars[i][fTuning][13], FactionCars[i][fTuning][14], FactionCars[i][fPrice], FactionCars[i][fTankart], FactionCars[i][fGesperrt], FactionCars[i][fMotorschaden],
			FactionCars[i][fSperrpreis], i);
			//handle = die Connection Handle ID die vor mysql_connect steht.
			mysql_tquery(handle, query);
		}
	}
	return 1;
}

Alles anzeigen

danke für das helfen

euer
RedDragon28080

RedDragon28080 · 5. März 2017

ne das wahr ein ".ini" habe es so raus bekommen ich habe bei OnGameModeInit jede zeile "print" gesetzt somit habe ich es raus gefunden und habe einfach den ".ini geleert

RedDragon28080 · 5. März 2017

public Itter_OnGameModeInit habe ich nicht drine nur public OnGameModeInit

braust du alles was im "Function OnGameModeInit" drine ist, ist ganz schön viel und wird zu groß werden

Es sind genau 10998 zeilen nur Function OnGameModeInit

Ich habe immer noch das Problem das bei "Mode: Unknown" steht, und das die meldung immer noch im server_log steht

Code

[16:11:27] [debug] Run time error 10: "Native function failed"
[16:11:27] [debug] AMX backtrace:
[16:11:27] [debug] #0 002c3bc8 in ?? () from German-of-Life.amx
[16:11:27] [debug] #1 000fd3fc in ?? () from German-of-Life.amx
[16:11:27] [debug] #2 00115640 in public Itter_OnGameModeInit () from German-of-Life.amx
[16:11:27] [debug] #3 native CallLocalFunction () [080dfac0] from samp28080_6231
[16:11:27] [debug] #4 0000955c in public OnGameModeInit () from German-of-Life.amx
[16:11:27] [debug] Run time error 10: "Native function failed"
[16:11:27] [debug] AMX backtrace:
[16:11:27] [debug] #0 002c3bc8 in public OnGameModeInit () from German-of-Life.amx

RedDragon28080 · 5. März 2017

ich habe sowas drine hier "#pragma dynamic 8192"

RedDragon28080 · 5. März 2017

Zitat von LeonMrBonnie

Weil der Gamemode nicht geladen wird.
Du benutzt das falsche MySQL Include deswegen startet der Server nicht.

Vielen dank LeonMrBonnie hat geklappt

jetzt zu die nächste frage was heißt das hier kann man das beheben?

C

[16:11:27] [debug] Run time error 10: "Native function failed"
[16:11:27] [debug] AMX backtrace:
[16:11:27] [debug] #0 002c3bc8 in ?? () from German-of-Life.amx
[16:11:27] [debug] #1 000fd3fc in ?? () from German-of-Life.amx
[16:11:27] [debug] #2 00115640 in public Itter_OnGameModeInit () from German-of-Life.amx
[16:11:27] [debug] #3 native CallLocalFunction () [080dfac0] from samp28080_6231
[16:11:27] [debug] #4 0000955c in public OnGameModeInit () from German-of-Life.amx
[16:11:27] [debug] Run time error 10: "Native function failed"
[16:11:27] [debug] AMX backtrace:
[16:11:27] [debug] #0 002c3bc8 in public OnGameModeInit () from German-of-Life.amx

mfg
RedDragon28080

RedDragon28080 · 5. März 2017

Hallo Liebes Breadfish Community

Mein Problem liegt daran das bei mein Server "Mode: Unknown" steht und bekomme es einfach nicht weg vielleicht könnt ihr mir sagen woran es liegt

C

----------
Loaded log file: "server_log.txt".
----------


SA-MP Dedicated Server
----------------------
v0.3.7-R2, (C)2005-2015 SA-MP Team


[15:45:29] 
[15:45:29] Server Plugins
[15:45:29] --------------
[15:45:29]  Loading plugin: crashdetect.so
[15:45:29]   crashdetect v4.8.4 is OK.
[15:45:29]   Loaded.
[15:45:29]  Loading plugin: sscanf.so
[15:45:29] 


[15:45:29]  ===============================


[15:45:29]       sscanf plugin loaded.     


[15:45:29]    (c) 2009 Alex "Y_Less" Cole


[15:45:29]  ===============================


[15:45:29]   Loaded.
[15:45:29]  Loading plugin: streamer.so
[15:45:29] 


*** Streamer Plugin v2.7.7 by Incognito loaded ***


[15:45:29]   Loaded.
[15:45:29]  Loading plugin: mysql.so
[15:45:29] 


  > MySQL plugin R5 successfully loaded.


[15:45:29]   Loaded.
[15:45:29]  Loaded 4 plugins.


[15:45:29] 
[15:45:29] Ban list
[15:45:29] --------
[15:45:29]  Loaded: samp.ban
[15:45:29] 
[15:45:29] 
[15:45:29] Filterscripts
[15:45:29] ---------------
[15:45:29]   Loaded 0 filterscripts.


[15:45:30] [debug] Run time error 19: "File or function is not found"
[15:45:30] [debug]  mysql_log
[15:45:30] [debug]  mysql_format
[15:45:30] [debug]  mysql_pquery
[15:45:30] [debug]  cache_get_data
[15:45:30] [debug]  cache_get_field_content
[15:45:30] [debug]  cache_get_row_count
[15:45:30] [debug]  cache_get_field_content_int
[15:45:30] [debug]  cache_get_field_content_float
[15:45:30] Script[gamemodes/German-of-Life.amx]: Run time error 19: "File or function is not found"
[15:45:30] Number of vehicle models: 0

Alles anzeigen

mfg
RedDragon28080

RedDragon28080 · 5. März 2017

achso oky

RedDragon28080 · 4. März 2017

so habe es fast geschaft ich habe es jetzt so gemacht es wird auch erstellt aber bei nicht abgespeichert

hier der msql_log

C

[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'FishID'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'FishID'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'FishID'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'FishID'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'Fishweight'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'Fishweight'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'Fishweight'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'Fishweight'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'CookID'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'CookID'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'CookID'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'CookID'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'CookHP'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'CookHP'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'CookHP'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'CookHP'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'Name'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'Passwort'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'Level'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'Admin'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'SpawnHealth'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'PayDay'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'Exp'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'Fraktion'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'Tutorial'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'Skin'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'FrakSkin'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'Geschlecht'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'Perso'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'CarLicense'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'CarLicensePoints'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'FlyLicense'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'BoatLicense'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'FishLicense'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'GunLicense'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'Zollpass'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'Job'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'Wanteds'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'Money'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'QuitJob'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'JobMoney'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'JobCount'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'BusSkill'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'BusSkillEXP'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'DetektivSkill'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'DetektivSkillEXP'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'Tot'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'TotUnix'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'TotX'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'TotY'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'TotZ'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'Kills'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'Deaths'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'Jailed'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'JailTime'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'Rank'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'Verbrechen'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'JailType'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'Banned'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'BanReason'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'BanAdmin'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'HouseKey'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'Erstehilfe'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'Number'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'Bank'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'Handy'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'HandyStatus'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'HandyGuthaben'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'Akku'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'PlayTime'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'Warns'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'Crimes'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'JailVisits'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'Eisen'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'EisenSafe'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'Marihuana'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'MarihuanaSafe'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'Kanister'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'Verheiratet'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'VerheiratetName'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'Premium'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'MuteTime'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'MuteReason'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'SkillPoints'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'TruckSkill'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'TruckSkillEXP'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'Muted'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'SpawnChange'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'TotWorld'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'Hitsound'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'Messages'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'FishID'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'FishID'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'FishID'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'FishID'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'FishID'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'Fishweight'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'Fishweight'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'Fishweight'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'Fishweight'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'Fishweight'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'Fished'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'FishTime'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'CookID'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'CookID'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'CookID'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'CookID'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'CookID'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'CookHP'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'CookHP'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'CookHP'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'CookHP'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'CookHP'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'FishSperre'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'SkillDrug'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'PremiumZeit'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'FishSkill'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'FishSkillEXP'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'OrgMember'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'Contract'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'ContractCount'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'LastLogin'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'IsEhrenhaft'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'Online'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'Lotto'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'PilotSkill'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'PilotSkillEXP'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'playerOnline'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'Email'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'PBPoints'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'NewPasswort'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'GotMD'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'Zigaretten'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'Bierflaschen'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'Ipod'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'Boombox'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'HaveBoombox'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'Festgeld'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'HatFestgeld'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'BisFestgeld'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'Geschenk'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'GeschenkCount'

Alles anzeigen

Ich sehe da nicht de Fehler aber vieleicht sieht ihr den Fehler

Ich brauche dringend Hilfe

RedDragon28080 · 4. März 2017

das ist aber nicht was ich wollte ich wollte mein Bruder hat für ein adnderes script von mir mal eine CreateTabelle erstellt wo immer die neue zeile erstellt worden ist und sowas wollte ich haben wie mache ich das?

hier was mein Bruder für die Version "R39-6"

meine ich genau das nur für die Version "R34"

CSS

//OnGameModeInit
    mysql_pquery(handle, "CREATE TABLE IF NOT EXISTS `users` (`id` int(11)  AUTO_INCREMENT, PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=latin1;");




Function CreateTabellen() {
	mysql_pquery(handle, "ALTER TABLE `users` ADD `IPAdresse` varchar(16) NOT NULL DEFAULT '0'");
    mysql_pquery(handle, "ALTER TABLE `users` ADD `Name` varchar(64) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Password` varchar(64) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Level` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `AdminLevel` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `DonateRank` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `UpgradePoints` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `ConnectedTime` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Registered` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Sex` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Age` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Origin` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `CK` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Muted` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Respect` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Money` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Bank` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Kredit` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `KreditDauer` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Kills` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Deaths` int(11) NOT NULL DEFAULT '0'");
    mysql_pquery(handle, "ALTER TABLE `users` ADD `Arrested` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `WantedDeaths` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Phonebook` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Fishes` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `BiggestFish` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Job` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `iJob` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Paycheck` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `HeadValue` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Jailed` int(11) NOT NULL DEFAULT '0'");
    mysql_pquery(handle, "ALTER TABLE `users` ADD `GWD` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `GangJailed` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Mauled` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `JailTime` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Materials` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Drugs` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `FightingStyle` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Leader` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Member` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Rank` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `pChar` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `FlugSkill` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `TruckSkill` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `MullSkill` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `WaffenSkill` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `pSHealth` float NOT NULL DEFAULT '0.0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `pHealth` float NOT NULL DEFAULT '0.0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `pInt` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Local` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Team` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Model` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `PhoneNr` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `House` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Bizz` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `HandyGeld` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `HandyVer` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Pos_x` float NOT NULL DEFAULT '0.0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Pos_y` float NOT NULL DEFAULT '0.0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Pos_z` float NOT NULL DEFAULT '0.0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Pos_a` float NOT NULL DEFAULT '0.0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `CarLic` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `NewLic` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `FlyLic` int(11) NOT NULL DEFAULT '0'");
    mysql_pquery(handle, "ALTER TABLE `users` ADD `BoatLic` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `GunLic` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `LKWLic` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `RollerLic` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Taxischein` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `MotoLic` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Abschlepperschein` int(11) NOT NULL DEFAULT '0'");
    mysql_pquery(handle, "ALTER TABLE `users` ADD `Zig` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Kekse` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `ZigSucht` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Gun1` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Gun2` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Gun3` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Gun4` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Ammo1` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Ammo2` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Ammo3` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Ammo4` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `CarTime` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Mulltime` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `PayDay` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `PayDayHad` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `CDPlayer` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Wins` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Loses` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `AlcoholPerk` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `HandyGeld` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `MiserPerk` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `PainPerk` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `TraderPerk` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Tutorial` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Warnings` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Adjustable` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Fuel` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Married` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `MarriedTo` VARCHAR(64) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `SpawnChange` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `WantedLevel` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `PlayMinutes` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `GesamtMinutes` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `MinutesSinceAn` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `SFPASS` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `LVPASS` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Offflucht` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Knast` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Uhr` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Handy` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `KnastTime` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Perso` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `FrakSperre` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Gehalt` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `InvWeapon` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `InvAmmo` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `InvWeapon2` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `InvAmmo2` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `InvMats` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `InvDrugs` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `FlugTime` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `FarmTime` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `GDeaths` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `GKills` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Meldung` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `HatIrgenteinHome` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Pin` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `SpawnChange` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Hotel` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `CarPunkt` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `BikePunkt` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Kanister` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `KreditRechnung` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `jobkuendigen` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Tot` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Neulingsvip` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Maske` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `DrugPerk` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Feuerzeug` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `C4` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Drugsamen` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Hotelzimmer` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `lohn` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `KrankenVersicherung` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `pHeal` float NOT NULL DEFAULT '51.0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `pArmor` float NOT NULL DEFAULT '0.0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Reparaturkit` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Pakete` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `PaketRute` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `FahrschulTime` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Fraktionlosengeld` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `WaffenMaterialID` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `BusTime` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Busskill` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `JobTime` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Autogeschenkt` int(11) NOT NULL DEFAULT '0'");
	return 1;
}

Alles anzeigen

RedDragon28080 · 3. März 2017

ich habe es so übernommen wie im Tutorial
Da stand das auch am erster Stelle
Irgendwie sehe ich hier gerade nicht durch

Frage: wenn es bald gehen sollte und ich irgendwann eine Zeile dazu schreibe wird sie dann auch übernommen oder muss ich dann die msql Daten Bank leeren?

Beiträge von RedDragon28080

5 Errors die ich nicht weg bekomme

5 Errors die ich nicht weg bekomme

5 Errors die ich nicht weg bekomme

5 Errors die ich nicht weg bekomme

5 Errors die ich nicht weg bekomme

5 Errors die ich nicht weg bekomme

5 Errors die ich nicht weg bekomme

5 Errors die ich nicht weg bekomme

5 Errors die ich nicht weg bekomme

5 Errors die ich nicht weg bekomme

5 Errors die ich nicht weg bekomme

Mode zeigt Unknown an

Mode zeigt Unknown an

Mode zeigt Unknown an

Mode zeigt Unknown an

Mode zeigt Unknown an

MySQL Tabelle im Script erstellen

MySQL Tabelle im Script erstellen

MySQL Tabelle im Script erstellen

MySQL Tabelle im Script erstellen