CJ - Skin, Bauernhofspawn | Crashdetect

tayson87 · 26. Oktober 2015

An Spieler[playerid][pTutMissionComplete][i] haben das mal komplett rausgenommen
nur noch ein bug ist da, undzwar; Wenn man nach dem Tutorial stirbt oder gespawnt wird landet man auf'm Bauernhof. Aber sobald man reloggt ist dieser Bug für immer weg..

alva · 27. Oktober 2015

OnplayerDeath und OnPlayerSpawn posten oder einfach mal selbst durchlesen was du da überhaupt getan hast.

tayson87 · 1. November 2015

@Jeffry hättest du eventuell doch heute Zeit mal drüber zu gucken ?

Jeffry · 1. November 2015

Ich habe gestern bei deinem Kollege nachgefragt, er hat gesagt, dass alle Probleme behoben sind.
Was ist denn momentan das Problem? Vielleicht lässt es sich ja auch so über die Scripting Base lösen, ansonsten müssen wir nochmal nach einem Termin schauen, weil heute geht es bei mir nicht mehr.

Aber erkläre bitte das Problem das vorhanden ist, gegebenenfalls lässt es sich so lösen.

tayson87 · 1. November 2015

Das problem ist wenn wir bei der Tabelle etwas neues hinzufügen, dann taucht wieder das Problem auf.. Und ich wollte mal nachfragen woran es liegt ? Ist etwa die Struktur zu viel oder zu kurz ?

Code

stock CreateTables()
{
	new query[4000];
	strcat(query,"CREATE TABLE IF NOT EXISTS `"#SQLTAG"_account_main` (`id` int(11) NOT NULL AUTO_INCREMENT,`Name` varchar(24) NOT NULL,`Online` int(2) NOT NULL,`Email` varchar(128) NOT NULL,`Passwort` varchar(34) NOT NULL,`Tutorial` int(2) NOT NULL,`Admin` int(2) NOT NULL DEFAULT '0',`Verwarnungen` int(2) NOT NULL DEFAULT '0',`FLeaderRechte` int(2) NOT NULL,`Fraktion` int(2) NOT NULL,`FraktionsRang` int(2) NOT NULL,`FraktionsSperre` int(2) NOT NULL,");
 	strcat(query,"`FraktionsGehalt` int(6) NOT NULL,`Job` int(3) NOT NULL,");
	strcat(query,"`JobWarns` int(2) NOT NULL,`JobSperre` int(128) NOT NULL,`AbgefahreneJobCheckPoints` int(4) NOT NULL,`ArbeitslosenGeld` int(4) NOT NULL,`Geschlecht` int(4) NOT NULL,`SpielerAlter` int(4) NOT NULL,`Level` int(4) NOT NULL,`Geld` int(10) NOT NULL,`GWD` int(3) NOT NULL,`Zivinote` int(3) NOT NULL,`FAbteilung` int(3) NOT NULL,`Bankguthaben` int(10) NOT NULL,`BankPin` int(96) NOT NULL,");
 	strcat(query,"`WantedSterne` int(2) NOT NULL,`WantedPunkte` int(2) NOT NULL,`Suspects` int(6) NOT NULL,");
	strcat(query,"`Wanted_Grund1` varchar(128) NOT NULL,`Wanted_Grund2` varchar(128) NOT NULL,`Wanted_Grund3` varchar(128) NOT NULL,`Wanted_Grund4` varchar(128) NOT NULL,`Wanted_Grund5` varchar(128) NOT NULL,`pWantedDeaths` int(10) NOT NULL,`pBuyTickets` int(10) NOT NULL,`pJailedCount` int(10) NOT NULL,`Crimes` int(3) NOT NULL,`STVOcrimes` int(2) NOT NULL,`KampfStyle` int(2) NOT NULL,`Handy` int(2) NOT NULL,");
	strcat(query,"`MobilTelefonFlat` int(2) NOT NULL,`Handycoins` int(3) NOT NULL,`MobilVertragBiz` int(4) NOT NULL,`HandyStatus` int(2) NOT NULL,");
	strcat(query,"`HandyAkku` float(4,2) NOT NULL,`HandyNummer` int(20) NOT NULL,`Handyflat` int(3) NOT NULL,`Handyflatbuyinbiz` int(10) NOT NULL,`Letzte_X` float(10,4) NOT NULL,`Letzte_Y` float(10,4) NOT NULL,`Letzte_Z` float(10,4) NOT NULL,`Letzte_Interior` int(3) NOT NULL,`Letzte_VirtualWorld` int(11) NOT NULL,`pSelectHome` int(3) NOT NULL,`HausMieter` int(3) NOT NULL,");
	strcat(query,"`Spawn` int(2) NOT NULL,`Hotel` int(2) NOT NULL,`Tod` int(2) NOT NULL,`Tot_X` float(10,4) NOT NULL,`Tot_Y` float(10,4) NOT NULL,`Tot_Z` float(10,4) NOT NULL,`Tot_Interior` int(3) NOT NULL,`Tot_VirtualWorld` int(11) NOT NULL,`TotZeit` int(4) NOT NULL,PRIMARY KEY (`id`))");
	mysql_function_query(MySqlConnection,query,false,"","");
	strdel(query,0,sizeof(query));
    strcat(query,"ALTER TABLE "#SQLTAG"_account_main ADD COLUMN (`Friedhof` int(2) NOT NULL,`FriedhofZeit` int(4) NOT NULL,`ImKnast` int(2) NOT NULL,`KnastZeit` int(4) NOT NULL,`KnastKaution` int(2) NOT NULL,`Muted` int(2) NOT NULL,`MuteZeit` int(4) NOT NULL,`ImPrison` int(2) NOT NULL,`PrisonCPRun` int(6) NOT NULL,");
    strcat(query,"`PrisonCPGive` int(6) NOT NULL,`Morde` int(4) NOT NULL,`Tode` int(4) NOT NULL,`SkinID` int(3) NOT NULL,`FraktionSkinID` int(3) NOT NULL,`PaintBallKills` int(10) NOT NULL,`PaintBallTode` int(10) NOT NULL,`PaintBallRang` int(3) NOT NULL,`PaintBallBesuche` int(8) NOT NULL,");
	strcat(query,"`AngenommeneReports` int(6) NOT NULL,`KopfGeld` int(10) NOT NULL,`Bankkonto` int(2) NOT NULL,`pArmyPlaneOrder` int(2) NOT NULL,`pArmyHeliOrder` int(2) NOT NULL,`pArmyWaffenOrder` int(2) NOT NULL,`TimeAfterRegister` int(12) NOT NULL,`Time4Payday` int(3) NOT NULL,");
	strcat(query,"`LevelUPKosten` int(10) NOT NULL,`RespectForLevelUp` int(6) NOT NULL,`RespectFromPayday` int(6) NOT NULL,`HabGeworben` int(2) NOT NULL,`pPremiumZeit` int(128) NOT NULL,`GeworbenerSpieler` varchar(24) NOT NULL,");
	strcat(query,"`TimeoutCrashExeorKick` int(3) NOT NULL,`PropertyClearTime` int(128) NOT NULL,`pScheinSperre` int(128) NOT NULL,`PingFPS` int(2) NOT NULL,`DigiHud` int(2) NOT NULL,`pDHitsound` int(2) NOT NULL,`Bonus` int(2) NOT NULL,`Coins` int(6) NOT NULL,`pUpgradePoints` int(6) NOT NULL,`pUpgradeSkill0` int(2) NOT NULL DEFAULT '1',`pUpgradeSkill1` int(2) NOT NULL DEFAULT '1',");
	strcat(query,"`pUpgradeSkill2` int(2) NOT NULL DEFAULT '1',`pUpgradeSkill3` int(2) NOT NULL DEFAULT '1',`pUpgradeSkill4` int(2) NOT NULL DEFAULT '1',`pPickWeapons` int(2) NOT NULL,`pOrgLeader` int(4) NOT NULL,`pOrgMember` int(4) NOT NULL,`pLohn` int(12) NOT NULL,`WaitPerso` int(128) NOT NULL)");
	mysql_function_query(MySqlConnection,query,false,"","");
	strdel(query,0,sizeof(query));
	strcat(query,"ALTER TABLE "#SQLTAG"_account_main ADD COLUMN (`pMarried` varchar(24) NOT NULL DEFAULT 'Niemand',`pBuyClothes` int(6) NOT NULL,`pBrille` int(6) NOT NULL,`pTsIdent` varchar(32) NOT NULL,`pIll` int(10) NOT NULL,`pConterminatedTime` int(10) NOT NULL,`pBitchSkill` int(10) NOT NULL,`pBitchFuckCount` int(10) NOT NULL,`pMedicHealplayerSkill` int(10) NOT NULL,`pMedicHealCount` int(10) NOT NULL)");
	mysql_function_query(MySqlConnection,query,false,"","");
	strdel(query,0,sizeof(query));
	mysql_function_query(MySqlConnection,"CREATE TABLE IF NOT EXISTS `"#SQLTAG"_bans` (`IP` varchar(16) NOT NULL,`Grund` varchar(128) NOT NULL,`Name` varchar(24) NOT NULL,`Admin` varchar(24) NOT NULL,`Zeit` int(128) NOT NULL,`Uhrzeit` time NOT NULL,`Datum` date NOT NULL,PRIMARY KEY (`IP`))",false,"","");
	strcat(query,"CREATE TABLE IF NOT EXISTS `"#SQLTAG"_properties` (`id` int(4) NOT NULL,`haus_besitzer` varchar(24) NOT NULL");
	strcat(query,",`haus_Owned` int(2) NOT NULL,`haus_innenraum` int(2) NOT NULL,`haus_miete` int(11) NOT NULL,`haus_beschreibung` varchar(150) NOT NULL,`haus_locked` int(2) NOT NULL,`haus_slots` int(3) NOT NULL,`haus_eingemitetenzaehler` int(3) NOT NULL,`haus_x` float(10,4) NOT NULL,");
	strcat(query,"`haus_y` float(10,4) NOT NULL,`haus_z` float(10,4) NOT NULL,`haus_preis` int(11) NOT NULL,`haus_level` int(4) NOT NULL,`haus_geldkasse` int(11) NOT NULL");
    for(new i=0;i<MAX_HAUSSAFEINV;i++)
	{
		strcat(query,",");
	    format(query,sizeof(query),"%s`haus_inv%i` int(11) NOT NULL",query,i);
	}
	strcat(query,",`haus_heal` int(4) NOT NULL,`haus_armour` int(4) NOT NULL,`haus_hatheal` int(2) NOT NULL,`haus_hatarmour` int(2) NOT NULL,`hausgundumper` int(2) NOT NULL");
	for(new i=0;i<13;i++)
	{
		strcat(query,",");
	    format(query,sizeof(query),"%s`hausgun%i` int(3) NOT NULL,",query,i);
	    format(query,sizeof(query),"%s`hausgunammo%i` int(6) NOT NULL",query,i);
	}
	strcat(query,",`hausmull` int(3) NOT NULL,`haus_msg` varchar(64) NOT NULL,`haus_garagepos_x` float(10,4) NOT NULL,`haus_garagepos_y` float(10,4) NOT NULL,`haus_garagepos_z` float(10,4) NOT NULL,`haus_garagevehspawn_x` float(10,4) NOT NULL,`haus_garagevehspawn_y` float(10,4) NOT NULL,`haus_garagevehspawn_z` float(10,4) NOT NULL,`haus_garagevehspawn_a` float(10,4) NOT NULL,`haus_havegarage` int(2) NOT NULL,`haus_garagelocked` int(2) NOT NULL,PRIMARY KEY (`id`))");
	mysql_function_query(MySqlConnection,query,false,"","");
	strdel(query,0,sizeof(query));
	strcat(query,"CREATE TABLE IF NOT EXISTS `"#SQLTAG"_pns` (`id` int(4) NOT NULL,`pns_fraktid` int(3) NOT NULL,`pns_kasse` int(11) NOT NULL");
    for(new i=0;i<PNS_ARTIKEL_SLOTS;i++)
	{
		strcat(query,",");
	    format(query,sizeof(query),"%s`pns_a%i` int(11) NOT NULL",query,i);
	}
	strcat(query,",PRIMARY KEY (`id`))ENGINE=INNODB;");
    mysql_function_query(MySqlConnection,query,false,"","");
	strdel(query,0,sizeof(query));
	strcat(query,"CREATE TABLE IF NOT EXISTS `"#SQLTAG"_businesses` (`id` int(12) NOT NULL,`biz_Owned` int(2) NOT NULL,`biz_art` varchar(50) NOT NULL,`biz_preis` int(12) NOT NULL,`biz_level` int(12) NOT NULL,`biz_geldkasse` int(12) NOT NULL,");
	strcat(query,"`biz_locked` int(2) NOT NULL,`biz_besitzer` varchar(24) NOT NULL,`biz_teilhaber` varchar(24) NOT NULL,`biz_beschreibung` varchar(150) NOT NULL,`biz_artikel0` int(12) NOT NULL,`biz_artikel1` int(12) NOT NULL,`biz_artikel2` int(12) NOT NULL,");
	strcat(query,"`biz_artikel3` int(12) NOT NULL,`biz_artikel4` int(12) NOT NULL,`biz_artikel5` int(12) NOT NULL,`biz_artikel6` int(12) NOT NULL,`biz_artikel7` int(12) NOT NULL,`biz_artikel8` int(12) NOT NULL,`biz_artikel9` int(12) NOT NULL,`biz_artikel10` int(12) NOT NULL,");
	strcat(query,"`biz_artikel11` int(12) NOT NULL,`biz_artikel12` int(12) NOT NULL,`biz_artikel13` int(12) NOT NULL,`biz_artikel14` int(12) NOT NULL,`biz_x` float(10,4) NOT NULL,`biz_y` float(10,4) NOT NULL,`biz_z` float(10,4) NOT NULL,");
	strcat(query,"`biz_sobjp0` float(10,4) NOT NULL,`biz_sobjp1` float(10,4) NOT NULL,`biz_sobjp2` float(10,4) NOT NULL,`biz_sobjp3` float(10,4) NOT NULL,`biz_sobjp4` float(10,4) NOT NULL,`biz_sobjp5` float(10,4) NOT NULL,`biz_interior` int(4) NOT NULL,`rentbizvehiclemodelid` int(4) NOT NULL,`tPos0` float(10,4) NOT NULL,`tPos1` float(10,4) NOT NULL,`tPos2` float(10,4) NOT NULL,`tPos3` float(10,4) NOT NULL,`tPos4` float(10,4) NOT NULL,`tPos5` float(10,4) NOT NULL,PRIMARY KEY (`id`))");
	mysql_function_query(MySqlConnection,query,false,"","");
	strdel(query,0,sizeof(query));
    mysql_function_query(MySqlConnection,"CREATE TABLE IF NOT EXISTS `"#SQLTAG"_blitzer` (`id` int(10) NOT NULL,`sperreX` float(10,4) NOT NULL,`sperreY` float(10,4) NOT NULL,`sperreZ` float(10,4) NOT NULL,`BlitzerGeschwindigkeit` int(10) NOT NULL,`BlitzerOrt` varchar(128) NOT NULL,`HP` int(4) NOT NULL,PRIMARY KEY (`id`))",false,"","");
    for(new i=0;i<sizeof(LogTable);i++)
	{
	    format(query,sizeof(query),"CREATE TABLE IF NOT EXISTS `"#SQLTAG"_logs_%s` (`id` int(11) NOT NULL AUTO_INCREMENT,`Uhrzeit` time NOT NULL,`Datum` date NOT NULL",LogTable[i][Logname]);
		if(strlen(LogTable[i][Column1]) > 0) format(query,sizeof(query),"%s,`%s` varchar(128) NOT NULL",query,LogTable[i][Column1]);
		if(strlen(LogTable[i][Column2]) > 0) format(query,sizeof(query),"%s,`%s` varchar(128) NOT NULL",query,LogTable[i][Column2]);
		if(strlen(LogTable[i][Column3]) > 0) format(query,sizeof(query),"%s,`%s` varchar(128) NOT NULL",query,LogTable[i][Column3]);
		if(strlen(LogTable[i][Column4]) > 0) format(query,sizeof(query),"%s,`%s` varchar(128) NOT NULL",query,LogTable[i][Column4]);
		strcat(query,",PRIMARY KEY (`id`))ENGINE=INNODB;");
		mysql_function_query(MySqlConnection,query,false,"","");
 	}
	strdel(query,0,sizeof(query));
	mysql_function_query(MySqlConnection,"CREATE TABLE IF NOT EXISTS `"#SQLTAG"_minen` (`id` int(10) NOT NULL,`sperreX` float(10,4) NOT NULL,`sperreY` float(10,4) NOT NULL,`sperreZ` float(10,4) NOT NULL,PRIMARY KEY (`id`))",false,"","");
    mysql_function_query(MySqlConnection,"CREATE TABLE IF NOT EXISTS `"#SQLTAG"_xmasobjects` (`id` int(10) NOT NULL,`ObjectID` int(10) NOT NULL,`sperreX` float(10,4) NOT NULL,`sperreY` float(10,4) NOT NULL,`sperreZ` float(10,4) NOT NULL,PRIMARY KEY (`id`))",false,"","");
    mysql_function_query(MySqlConnection,"CREATE TABLE IF NOT EXISTS `"#SQLTAG"_eastereggs` (`id` int(4) NOT NULL,`ObjectID` int(6) NOT NULL,`sperreX` float(10,4) NOT NULL,`sperreY` float(10,4) NOT NULL,`sperreZ` float(10,4) NOT NULL,`obj_world` int(11) NOT NULL,`foundenby` varchar(24) NOT NULL,PRIMARY KEY (`id`))",false,"","");
	mysql_function_query(MySqlConnection,"CREATE TABLE IF NOT EXISTS `"#SQLTAG"_drugs` (`pflanze` int(12) NOT NULL,`drgfraktid` int(3) NOT NULL,`drgArt` int(3) NOT NULL,`drgXpos` float(10,4) NOT NULL,`drgYpos` float(10,4) NOT NULL,`drgZpos` float(10,4) NOT NULL,`drginterior` int(5) NOT NULL,`drgvirtualworld` int(5) NOT NULL,`drgProduceDrugs` int(10) NOT NULL,`drgNextDrugsIn` int(128) NOT NULL,`drgWasserzustand` int(6) NOT NULL,`drgOwner` varchar(24) NOT NULL,PRIMARY KEY (`pflanze`))",false,"","");
	strcat(query,"CREATE TABLE IF NOT EXISTS `"#SQLTAG"_fraktion_vehicles` (`id` int(12) NOT NULL,`Fraktion` int(4) NOT NULL,`Rang` int(2) NOT NULL,`modelid` int(4) NOT NULL,`Farbe1` int(5) NOT NULL,`Farbe2` int(5) NOT NULL,`Paintjob` int(5) NOT NULL,`HP` float(10,4) NOT NULL,`posx` float(10,4) NOT NULL,");
	strcat(query,"`posy` float(10,4) NOT NULL,`posz` float(10,4) NOT NULL,`posa` float(10,4) NOT NULL,`Interior` int(3) NOT NULL,`VirtualWorld` int(6) NOT NULL,`Abgeschlossen` int(2) NOT NULL,`Abgeschleppt` int(2) NOT NULL,`AbgeschlepptPreis` int(8) NOT NULL,`AbgeschlepptGrund` varchar(128) NOT NULL,`Nummernschild` varchar(64) NOT NULL,`Neon` int(5) NOT NULL,`Spoiler` int(10) NOT NULL,`Hood` int(10) NOT NULL,");
	strcat(query,"`Roof` int(10) NOT NULL,`Sideskirt` int(10) NOT NULL,`Lamps` int(10) NOT NULL,`Nitro` int(10) NOT NULL,`Exhaust` int(10) NOT NULL,`Wheels` int(10) NOT NULL,`Stereo` int(10) NOT NULL,`Hydraulics` int(10) NOT NULL,`FrontBumper` int(10) NOT NULL,`RearBumper` int(10) NOT NULL,`VentRight` int(10) NOT NULL,`VentLeft` int(10) NOT NULL,`KaufPreis` int(10) NOT NULL,`FraktionsRang` int(10) NOT NULL,`Motorschaden` int(2) NOT NULL,`FailGas` int(2) NOT NULL,");
	strcat(query,"`Tank` float(10,4) NOT NULL,`Kilometerstand` int(64) NOT NULL,`KofferraumGanja` int(10) NOT NULL,`KofferraumKokain` int(10) NOT NULL,`KofferraumMaterials` int(10) NOT NULL,`KofferraumOpium` int(10) NOT NULL,`KofferraumLunchpakete` int(10) NOT NULL,`KofferraumC4` int(10) NOT NULL,`KofferraumWerkzeugkasten` int(10) NOT NULL,`KofferraumBenzinkanister` int(10) NOT NULL,`Handbremse` int(2) NOT NULL,PRIMARY KEY (`id`))");
	mysql_function_query(MySqlConnection,query,false,"","");
	strdel(query,0,sizeof(query));
	mysql_function_query(MySqlConnection,"CREATE TABLE IF NOT EXISTS `"#SQLTAG"_gangwar2` (`GangZoneID` int(4) NOT NULL,`GangWarZoneOwner` int(3) NOT NULL,`GangWarZoneAttacker` int(3) NOT NULL,`EZ_OwnerFactionPoints` int(4) NOT NULL,`EZ_AttackFactionPoints` int(4) NOT NULL,`EZ_Started` int(2) NOT NULL,`EZ_FightTime` int(11) NOT NULL,PRIMARY KEY (`GangZoneID`))",false,"","");
    mysql_function_query(MySqlConnection,query,false,"","");
	strdel(query,0,sizeof(query));
	mysql_function_query(MySqlConnection,"CREATE TABLE IF NOT EXISTS `"#SQLTAG"_fraktion_motd` (`fID` int(12) NOT NULL,`Text` varchar(128) NOT NULL,PRIMARY KEY (`fID`))",false,"","");
	strcat(query,"CREATE TABLE IF NOT EXISTS `"#SQLTAG"_stuff` (`id` int(1) NOT NULL,`ADPreis` int(20) NOT NULL,`Lottojackpot` int(20) NOT NULL,`RentVehsPreis` int(20) NOT NULL,`TerrorSpawn` int(3) NOT NULL,`Lohnsteuer` float(10,4) NOT NULL,`Mwst` float(10,4) NOT NULL,`Grundsteuer` float(10,4) NOT NULL,`OamtStandGebuer` int(20) NOT NULL,`Solidsteuer` float(10,4) NOT NULL,`Reichensteuer` float(10,4) NOT NULL,`WLS` int(3) NOT NULL,`WSF` int(3) NOT NULL,");
    strcat(query,"`WLV` int(3) NOT NULL,`PreisLicCar` int(20) NOT NULL,`PreisLicBike` int(20) NOT NULL,`PreisLicRoller` int(20) NOT NULL,`PreisLicPlane` int(20) NOT NULL,`PreisLicHeli` int(20) NOT NULL,`PreisLicBoat` int(20) NOT NULL,`HitmanContractRang` int(2) NOT NULL,`FMeldePreis` int(20) NOT NULL,`NewspaperPreis` int(4) NOT NULL,`NewspaperText1` varchar(256) NOT NULL,`NewspaperText2` varchar(256) NOT NULL,`NewspaperText3` varchar(256) NOT NULL,`NewspaperText4` varchar(256) NOT NULL,");
    strcat(query,"`NewspaperText5` varchar(256) NOT NULL,`NewspaperText6` varchar(256) NOT NULL,`NewspaperText7` varchar(256) NOT NULL,`NewspaperText8` varchar(256) NOT NULL,`NewsPaperRealeased` int(12) NOT NULL,`NewsPaperLager1` int(12) NOT NULL,`NewsPaperLager2` int(12) NOT NULL,`EisenLagger1` int(12) NOT NULL,`EisenLagger2` int(12) NOT NULL,`Kartfahrer1` varchar(24) NOT NULL,`KartTime1` int(28) NOT NULL,`FreemanPrice` int(6) NOT NULL,");
    strcat(query,"`SAPDpay` int(6) NOT NULL,`FBIpay` int(6) NOT NULL,`SAEDpay` int(6) NOT NULL,`ARMYpay` int(6) NOT NULL,`OAMTpay` int(6) NOT NULL,`GOVpay` int(6) NOT NULL,`WorkLessMoney` int(6) NOT NULL,`BlitzerToleranz` int(6) NOT NULL,`JobSperreFree` int(20) NOT NULL,`AngelLicPrice` int(20) NOT NULL,`PersoLicPrice` int(20) NOT NULL,`WeapPrice` int(20) NOT NULL,`ParkPrice` int(20) NOT NULL,PRIMARY KEY (`id`))");
	mysql_function_query(MySqlConnection,query,false,"","");
    strdel(query,0,sizeof(query));
	strcat(query,"CREATE TABLE IF NOT EXISTS `"#SQLTAG"_fraktion_verwaltung` (`fID` int(5) NOT NULL,`Geld` int(100) NOT NULL,`Opium` int(100) NOT NULL,`Ganja` int(100) NOT NULL,`Kokain` int(100) NOT NULL,`C4` int(100) NOT NULL,`Materials` int(100) NOT NULL,`WaffenPack` int(100) NOT NULL,`WaffenSlots` int(100) NOT NULL,`Heal` int(100) NOT NULL,`HealSlots` int(100) NOT NULL,`Armour` int(100) NOT NULL,`ArmourSlots` int(100) NOT NULL,`HaveVBInvite` int(5) NOT NULL,`VBFraktion` int(5) NOT NULL,");
	strcat(query,"`F0` varchar(32) NOT NULL,`F1` varchar(32) NOT NULL,`F2` varchar(32) NOT NULL,`F3` varchar(32) NOT NULL,`F4` varchar(32) NOT NULL,`F5` varchar(32) NOT NULL,`F6` varchar(32) NOT NULL,`GFFID` int(3) NOT NULL,`GFOWNER` int(3) NOT NULL,`GFKILLS` int(5) NOT NULL,`GFDEATHS` int(5) NOT NULL,`Influence` int(11) NOT NULL,`InfluenceWinner` int(11) NOT NULL,PRIMARY KEY (`fID`))");
	mysql_function_query(MySqlConnection,query,false,"","");
    strdel(query,0,sizeof(query));
    mysql_function_query(MySqlConnection,"CREATE TABLE IF NOT EXISTS `"#SQLTAG"_multiaccounts` (`Name` varchar(24) NOT NULL,`Datum` date NOT NULL,`Uhrzeit` time NOT NULL,`Admin` varchar(24) NOT NULL,PRIMARY KEY (`Name`))",false,"","");
	strcat(query,"CREATE TABLE IF NOT EXISTS `"#SQLTAG"_account_weapons` (`Name` varchar(24) NOT NULL,`Waffen0` int(3) NOT NULL,`Waffen1` int(3) NOT NULL,`Waffen2` int(3) NOT NULL,`Waffen3` int(3) NOT NULL,`Waffen4` int(3) NOT NULL,`Waffen5` int(3) NOT NULL,`Waffen6` int(3) NOT NULL,`Waffen7` int(3) NOT NULL,`Waffen8` int(3) NOT NULL,`Waffen9` int(3) NOT NULL,`Waffen10` int(3) NOT NULL,`Waffen11` int(3) NOT NULL,`Waffen12` int(3) NOT NULL,");
	strcat(query,"`Ammo0` int(10) NOT NULL,`Ammo1` int(10) NOT NULL,`Ammo2` int(10) NOT NULL,`Ammo3` int(10) NOT NULL,`Ammo4` int(10) NOT NULL,`Ammo5` int(10) NOT NULL,`Ammo6` int(10) NOT NULL,`Ammo7` int(10) NOT NULL,`Ammo8` int(10) NOT NULL,`Ammo9` int(10) NOT NULL,`Ammo10` int(10) NOT NULL,`Ammo11` int(10) NOT NULL,`Ammo12` int(10) NOT NULL,PRIMARY KEY (`Name`))");
	mysql_function_query(MySqlConnection,query,false,"","");
	strdel(query,0,sizeof(query));
	strcat(query,"CREATE TABLE IF NOT EXISTS `"#SQLTAG"_races` (`race` varchar(32) NOT NULL,`fID` int(3) NOT NULL,`X1` float(10,4) NOT NULL,`Y1` float(10,4) NOT NULL,`Z1` float(10,4) NOT NULL,`X2` float(10,4) NOT NULL,`Y2` float(10,4) NOT NULL,`Z2` float(10,4) NOT NULL,`X3` float(10,4) NOT NULL,`Y3` float(10,4) NOT NULL,`Z3` float(10,4) NOT NULL,`X4` float(10,4) NOT NULL,`Y4` float(10,4) NOT NULL,`Z4` float(10,4) NOT NULL,`X5` float(10,4) NOT NULL,`Y5` float(10,4) NOT NULL,`Z5` float(10,4) NOT NULL,");
	strcat(query,"`X6` float(10,4) NOT NULL,`Y6` float(10,4) NOT NULL,`Z6` float(10,4) NOT NULL,`X7` float(10,4) NOT NULL,`Y7` float(10,4) NOT NULL,`Z7` float(10,4) NOT NULL,`X8` float(10,4) NOT NULL,`Y8` float(10,4) NOT NULL,`Z8` float(10,4) NOT NULL,`X9` float(10,4) NOT NULL,`Y9` float(10,4) NOT NULL,`Z9` float(10,4) NOT NULL,`X10` float(10,4) NOT NULL,`Y10` float(10,4) NOT NULL,`Z10` float(10,4) NOT NULL,`X11` float(10,4) NOT NULL,`Y11` float(10,4) NOT NULL,`Z11` float(10,4) NOT NULL,");
	strcat(query,"`X12` float(10,4) NOT NULL,`Y12` float(10,4) NOT NULL,`Z12` float(10,4) NOT NULL,`X13` float(10,4) NOT NULL,`Y13` float(10,4) NOT NULL,`Z13` float(10,4) NOT NULL,`X14` float(10,4) NOT NULL,`Y14` float(10,4) NOT NULL,`Z14` float(10,4) NOT NULL,`X15` float(10,4) NOT NULL,`Y15` float(10,4) NOT NULL,`Z15` float(10,4) NOT NULL,`X16` float(10,4) NOT NULL,`Y16` float(10,4) NOT NULL,`Z16` float(10,4) NOT NULL,`X17` float(10,4) NOT NULL,`Y17` float(10,4) NOT NULL,`Z17` float(10,4) NOT NULL,");
	strcat(query,"`X18` float(10,4) NOT NULL,`Y18` float(10,4) NOT NULL,`Z18` float(10,4) NOT NULL,`X19` float(10,4) NOT NULL,`Y19` float(10,4) NOT NULL,`Z19` float(10,4) NOT NULL,`X20` float(10,4) NOT NULL,`Y20` float(10,4) NOT NULL,`Z20` float(10,4) NOT NULL,`X21` float(10,4) NOT NULL,`Y21` float(10,4) NOT NULL,`Z21` float(10,4) NOT NULL,`X22` float(10,4) NOT NULL,`Y22` float(10,4) NOT NULL,`Z22` float(10,4) NOT NULL,`X23` float(10,4) NOT NULL,`Y23` float(10,4) NOT NULL,`Z23` float(10,4) NOT NULL,");
	strcat(query,"`X24` float(10,4) NOT NULL,`Y24` float(10,4) NOT NULL,`Z24` float(10,4) NOT NULL,`X25` float(10,4) NOT NULL,`Y25` float(10,4) NOT NULL,`Z25` float(10,4) NOT NULL,`X26` float(10,4) NOT NULL,`Y26` float(10,4) NOT NULL,`Z26` float(10,4) NOT NULL,`X27` float(10,4) NOT NULL,`Y27` float(10,4) NOT NULL,`Z27` float(10,4) NOT NULL,`X28` float(10,4) NOT NULL,`Y28` float(10,4) NOT NULL,`Z28` float(10,4) NOT NULL,`X29` float(10,4) NOT NULL,`Y29` float(10,4) NOT NULL,`Z29` float(10,4) NOT NULL,");
    strcat(query,"`X30` float(10,4) NOT NULL,`Y30` float(10,4) NOT NULL,`Z30` float(10,4) NOT NULL,`X31` float(10,4) NOT NULL,`Y31` float(10,4) NOT NULL,`Z31` float(10,4) NOT NULL,`X32` float(10,4) NOT NULL,`Y32` float(10,4) NOT NULL,`Z32` float(10,4) NOT NULL,`X33` float(10,4) NOT NULL,`Y33` float(10,4) NOT NULL,`Z33` float(10,4) NOT NULL,`X34` float(10,4) NOT NULL,`Y34` float(10,4) NOT NULL,`Z34` float(10,4) NOT NULL,`X35` float(10,4) NOT NULL,`Y35` float(10,4) NOT NULL,`Z35` float(10,4) NOT NULL,");
	strcat(query,"PRIMARY KEY (`race`))");
	mysql_function_query(MySqlConnection,query,false,"","");
	strdel(query,0,sizeof(query));
	strcat(query,"CREATE TABLE IF NOT EXISTS `"#SQLTAG"_account_vehicle` (`id` int(11) NOT NULL AUTO_INCREMENT,`name` varchar(24) NOT NULL,`slot` int(2) NOT NULL,`modelid` int(4) NOT NULL,`x` float(10,4) NOT NULL,`y` float(10,4) NOT NULL,");
  	strcat(query,"`z` float(10,4) NOT NULL,`a` float(10,4) NOT NULL,`interior` int(4) NOT NULL,`world` int(11) NOT NULL,`cc1` int(4) NOT NULL,`cc2` int(4) NOT NULL,`paintjob` int(2) NOT NULL,`vehhp` float(10,4) NOT NULL,`abgeschlossen` int(2) NOT NULL,`t1` int(4) NOT NULL,`t2` int(4) NOT NULL,`t3` int(4) NOT NULL,`t4` int(4) NOT NULL,`t5` int(4) NOT NULL,`t6` int(4) NOT NULL,`t7` int(4) NOT NULL,");
  	strcat(query,"`t8` int(4) NOT NULL,`t9` int(4) NOT NULL,`t10` int(4) NOT NULL,`t11` int(4) NOT NULL,`t12` int(4) NOT NULL,`t13` int(4) NOT NULL,`t14` int(4) NOT NULL,`Armourplating` int(2) NOT NULL,`TrackingDevice` int(2) NOT NULL,`angemeldet` int(2) NOT NULL,`atime` int(18) NOT NULL,`atanmeldung` int(2) NOT NULL,`preis` int(11) NOT NULL,`nummernschild` varchar(32) NOT NULL,`neon` int(2) NOT NULL,`motordown` int(2) NOT NULL,`failgas` int(2) NOT NULL,`tank` float(10,4) NOT NULL,");
  	strcat(query,"`km` int(11) NOT NULL,`towed` int(2) NOT NULL,`towedfreeprice` int(11) NOT NULL,`towedreason` varchar(32) NOT NULL,`kganja` int(11) NOT NULL,");
    strcat(query,"`kkokain` int(11) NOT NULL,`kopium` int(11) NOT NULL,`kmats` int(11) NOT NULL,`klunch` int(11) NOT NULL,`kc4` int(11) NOT NULL,`kwkanister` int(11) NOT NULL,`kkanister` int(11) NOT NULL,`handbrake` int(2) NOT NULL,`InGarage` int(4) NOT NULL,PRIMARY KEY (`id`))");
	mysql_function_query(MySqlConnection,query,false,"","");
	strdel(query,0,sizeof(query));
	mysql_function_query(MySqlConnection,"CREATE TABLE IF NOT EXISTS `"#SQLTAG"_account_licenses` (`Name` varchar(24) NOT NULL,`car` int(2) NOT NULL,`bike` int(2) NOT NULL,`roller` int(2) NOT NULL,`boat` int(2) NOT NULL,`plane` int(2) NOT NULL,`helicopter` int(2) NOT NULL,`weapon` int(2) NOT NULL,`fishing` int(2) NOT NULL,`personality` int(2) NOT NULL,PRIMARY KEY (`Name`))",false,"","");
    mysql_function_query(MySqlConnection,"CREATE TABLE IF NOT EXISTS `"#SQLTAG"_account_fish` (`Name` varchar(24) NOT NULL,`FishID0` int(3) NOT NULL,`FishID1` int(3) NOT NULL,`FishID2` int(3) NOT NULL,`FishID3` int(3) NOT NULL,`FishID4` int(3) NOT NULL,`FishID5` int(3) NOT NULL,`Fishweight0` int(10) NOT NULL,`Fishweight1` int(10) NOT NULL,`Fishweight2` int(10) NOT NULL,`Fishweight3` int(10) NOT NULL,`Fishweight4` int(10) NOT NULL,`Fishweight5` int(10) NOT NULL,PRIMARY KEY (`Name`))",false,"","");
    strcat(query,"ALTER TABLE `"#SQLTAG"_account_licenses` ADD COLUMN (`pArchs0` int(2) NOT NULL");
    for(new i=1;i<MAX_ARCHIVMENTS;i++)
    {
    	format(query,sizeof(query),"%s, `pArchs%i` int(2) NOT NULL",query,i);
    }
    strcat(query,")");
    mysql_function_query(MySqlConnection,query,false,"","");
    strdel(query,0,sizeof(query));
	mysql_function_query(MySqlConnection,"CREATE TABLE IF NOT EXISTS `"#SQLTAG"_account_koffer` (`Name` varchar(24) NOT NULL,`Slot0` int(10) NOT NULL,`Slot1` int(10) NOT NULL,`Slot2` int(10) NOT NULL,`Slot3` int(10) NOT NULL,`Slot4` int(10) NOT NULL,`Slot5` int(10) NOT NULL,`Slot6` int(10) NOT NULL,`Slot7` int(10) NOT NULL,`Slot8` int(10) NOT NULL,`Slot9` int(10) NOT NULL,PRIMARY KEY (`Name`))",false,"","");
	strcat(query,"CREATE TABLE IF NOT EXISTS `"#SQLTAG"_account_blacklist` (`Name` varchar(24) NOT NULL");
	for(new fID=0;fID<MAX_FRAKTIONNEN;fID++)
	{
		strcat(query,",");
	    mysql_format(MySqlConnection,query,sizeof(query),"%s`blacklist%i` varchar(32) NOT NULL",query,fID);
		strcat(query,",");
	    mysql_format(MySqlConnection,query,sizeof(query),"%s`blacklistreason%i` int(2) NOT NULL",query,fID);
	}
	strcat(query,",PRIMARY KEY (`Name`))");
	mysql_function_query(MySqlConnection,query,false,"","");
	strdel(query,0,sizeof(query));
    strcat(query,"CREATE TABLE IF NOT EXISTS `"#SQLTAG"_account_inventar` (`Name` varchar(24) NOT NULL,`c4` int(10) NOT NULL,`bomben` int(10) NOT NULL,`materials` int(10) NOT NULL,`material_packs` int(10) NOT NULL,`lunchpakets` int(10) NOT NULL,`navi` int(10) NOT NULL,`helm` int(10) NOT NULL,`angel` int(10) NOT NULL,`angelkoeder` int(10) NOT NULL,`repairboxxes` int(10) NOT NULL,`refillgalons` int(10) NOT NULL,`koffer` int(10) NOT NULL,");
    strcat(query,"`zigarrets` int(10) NOT NULL,`alcohol` int(10) NOT NULL,`pfandflaschen` int(10) NOT NULL,`ganja` int(10) NOT NULL,`kokain` int(10) NOT NULL,`opium` int(10) NOT NULL,`ganjaseats` int(10) NOT NULL,`kokainseats` int(10) NOT NULL,`opiumseats` int(10) NOT NULL,`callbook` int(10) NOT NULL,`condoms` int(10) NOT NULL,`brecheisen` int(10) NOT NULL,`duenger` int(10) NOT NULL,PRIMARY KEY (`Name`))");
	mysql_function_query(MySqlConnection,query,false,"","");
	strdel(query,0,sizeof(query));
    mysql_function_query(MySqlConnection,"CREATE TABLE IF NOT EXISTS `"#SQLTAG"_account_banksafe` (`Name` varchar(24) NOT NULL,`safetresor` int(2) NOT NULL,`ganja` int(10) NOT NULL,`kokain` int(10) NOT NULL,`opium` int(10) NOT NULL,`materials` int(10) NOT NULL,`c4` int(10) NOT NULL,PRIMARY KEY (`Name`))",false,"","");
    mysql_function_query(MySqlConnection,"CREATE TABLE IF NOT EXISTS `"#SQLTAG"_networktowers` (`id` int(12) NOT NULL,`X` float(10,4) NOT NULL,`Y` float(10,4) NOT NULL,`Z` float(10,4) NOT NULL,`HP` int(4) NOT NULL,PRIMARY KEY (`id`))",false,"","");
    mysql_function_query(MySqlConnection,"CREATE TABLE IF NOT EXISTS `"#SQLTAG"_advertismentboards` (`id` int(3) NOT NULL,`Text` varchar(64) NOT NULL,PRIMARY KEY (`id`))",false,"","");
    mysql_function_query(MySqlConnection,"CREATE TABLE IF NOT EXISTS `"#SQLTAG"_whitelist` (`Name` varchar(24) NOT NULL,PRIMARY KEY (`Name`))",false,"","");
	strcat(query,"CREATE TABLE IF NOT EXISTS `"#SQLTAG"_blackmarket` (`id` int(12) NOT NULL,`sfraktid` int(4) NOT NULL,`sbdfraktid` int(4) NOT NULL,`sx` float(10,4) NOT NULL,`sy` float(10,4) NOT NULL,`sz` float(10,4) NOT NULL,`slocked` int(2) NOT NULL,`smaterials` int(18) NOT NULL,`swerbetext` varchar(128) NOT NULL,`sprice` int(18) NOT NULL,`skasse` int(18) NOT NULL,");
	strcat(query,"`sartikel0` int(18) NOT NULL,`sartikel1` int(18) NOT NULL,`sartikel2` int(18) NOT NULL,`sartikel3` int(18) NOT NULL,`sartikel4` int(18) NOT NULL,`sartikel5` int(18) NOT NULL,`sartikel6` int(18) NOT NULL,`sartikel7` int(18) NOT NULL,`sartikel8` int(18) NOT NULL,`sartikel9` int(18) NOT NULL,`sartikel10` int(18) NOT NULL,`sartikel11` int(18) NOT NULL,`sartikel12` int(18) NOT NULL,`sartikel13` int(18) NOT NULL,");
	strcat(query,"`sattackerfraktid` int(4) NOT NULL,`swarownerpoints` int(8) NOT NULL,`swarattackerpoints` int(8) NOT NULL,`swartime` int(128) NOT NULL,`swarsleep` int(128) NOT NULL,PRIMARY KEY (`id`))");
	mysql_function_query(MySqlConnection,query,false,"","");
	strdel(query,0,sizeof(query));
    mysql_function_query(MySqlConnection,"CREATE TABLE IF NOT EXISTS `"#SQLTAG"_account_autologin` (`Name` varchar(24) NOT NULL,`IP` varchar(16) NOT NULL,PRIMARY KEY (`Name`))",false,"","");
    mysql_function_query(MySqlConnection,"CREATE TABLE IF NOT EXISTS `"#SQLTAG"_bugs` (`id` int(100) NOT NULL AUTO_INCREMENT,`Writer` varchar(30) NOT NULL,`Text` varchar(256) NOT NULL,`Priorität` varchar(64) NOT NULL,`Tick` varchar(12) NOT NULL,`Uhrzeit` time NOT NULL,`Datum` date NOT NULL,PRIMARY KEY (`id`))",false,"","");
	mysql_function_query(MySqlConnection,"CREATE TABLE IF NOT EXISTS `"#SQLTAG"_organisations` (`id` int(11) NOT NULL,`OrgName` varchar(64) NOT NULL,`OrgOwner` varchar(24) NOT NULL,`OrgMotto` varchar(128) NOT NULL,PRIMARY KEY (`id`))",false,"","");
	return 1;
}

Alles anzeigen

Jeffry · 2. November 2015

Das lässt sich so nicht sagen. Wenn du nur an den Queries etwas änderst, dann ist das einzige Problem, das möglich ist, ein Syntax Fehler im Query. Am besten du machst die Änderung mal und schaust dann im MySQL Log nach, ob dort ein Fehler ausgegeben wird (gegebenenfalls vorher den Log leeren).
Poste zusätzlich gegebenenfalls dann eine vorher und eine nachher-Version des Queries das du geändert hast.

breadfish.de 12. März 2022