Beiträge von tayson87

Hab mal die Mieter so als textdraw gelistet das sie untereinander stehen und dass wenn keine Mieter aufgelistet werden das da 'Niemand' stehen sollte. Doch ingame wird leider nicht 'Niemand' angezeigt..
Was mach ich falsch ? Es soll so viele "Niemand" untereinander stehen wie Mieterslots es gibt

Mieterslots %i/%i",HausInfo[haus][haus_eingemitetenzaehler],HausInfo[haus][haus_slots]

public LoadHouseRentFinish(index[],sqlresultid,extraid,SconnectionHandle)
{
new lResult[128], rows, fields, string[256];
switch(sqlresultid)
{
case _SQL_HOUSEMIETER_LOAD:
{
cache_get_data(rows, fields);
new lCount;
if(rows)
{
while(lCount < rows)
{
cache_get_field_content(lCount, "SPALTE MIT DEM NAMEN", lResult), format(string, sizeof(string), "~w~%s~n~%s", string,lResult);
lCount++;
}
}
else
{
for(new i; i < 10; ++i)
{
if(i < lCount)
{
format(string, sizeof(string), "~w~%s~n~%s. Niemand", string,lResult);
}
}
}
TextDrawSetString(HausLabelTD[7], string);
}
}
return 1;
}

Welche pRP Version haste denn? Vll. kann man dir dann mehr helfen. Und zeig uns doch mal die Speicher & lade Funktion

Das Tuningsystem speichert sehr wohl nur dein pRP Script speichert dein Vehiclespeichersystem nicht

Einfach rein in den Ordner und ich kann los zocken oder wie oder muss ich ein Befehl eingeben immer wieder? DANKE

Danke, kannst du mir kurz erklären wo ich die Setting nun einfüge ?

Wie haste ein kleines Crosshair ? bzw sag mal die Settings vom Crosshair pls

Hätte sowas, ist zwar Cleo aber funkt ziemlich gut mit Tastenbelegung:

Kannst die Bewegungen schnell und langsam ect einstellen.

man kann dich nicht per pn erreichen. du musst wenn dann anschreiben

vayne
vain
vine

Ja aber im endeffekt hast du dein Knife wieder, somit hat es sich gelohnt den Support anzuschreiben meiner Meinung nach.

Bringt doch alles hier nichts oder ? Ich mein am besten den Support fragen wäre das schlauste..

Kurze Frage wie könnte man denn Abfragen bei einem Torbefehl das nur die Person das Tor öffnen kann die den namen zB Mustermann hat ?

if(IsPlayerInRangeOfPoint(playerid, 20.0, 320.91381835938, -1188.4581298828, 71.151390075684))//Villa Tor
{
if(isPlayerAnAdmin(playerid,6))
{
if(torstatus[34] == 0)
{
MoveDynamicObject(tor[34], 321.39999390, -1188.19995117, 78.19999695 + 4, 3.0);
torstatus[34] = 1;
PlayerHearMusicInRange(x,y,z,1035,5,1,500);//x,y,z,soundid,radius,timer an = 1 wenn aus = 0,zeit wann timer music/sound beendet
return 1;
}
else
{
MoveDynamicObject(tor[34], 321.39999390, -1188.19995117, 78.19999695, 3.0);
torstatus[34] = 0;
PlayerHearMusicInRange(x,y,z,1035,5,1,500);//x,y,z,soundid,radius,timer an = 1 wenn aus = 0,zeit wann timer music/sound beendet
return 1;
}
}
return SendClientMessage(playerid,GRAU,"Du bist nicht berechtigt, dieses Tor zu öffnen.");
}

Blinkersystem Funktioniert nicht wie ich es will.. Wenn Blinke dann wird der Textdraw nicht in Farbe gezeigt bzw. der textdraw soll mitblinken und den Sound solange abspielen bis man eben wieder den blinker abschaltet oder wenn es geht am besten wenn das auto abbiegt oder wendet.

if(IsPlayerInAnyVehicle(playerid))
{
new carid = GetPlayerVehicleID(playerid);
new model = (GetVehicleModel(carid)-400);
if(!IsPlayerInAnyVehicle(playerid) && !IsVehicleACar(carid)) return 1;
if(GetPlayerVehicleSeat(playerid) != 0)return 1;
if(GetVehicleModel(carid) == 509 || GetVehicleModel(carid) == 481 || GetVehicleModel(carid) == 510 || IsVehAFlugzeug(carid) || IsVehAHelicopter(carid) || IsVehABoot(carid)) return 1;
if(GetPlayerState(playerid) == 2)
{
if((newkeys == KEY_LOOK_RIGHT))//Rechter Blinker
{
DestroyObject(LightsObject[carid][0]);
DestroyObject(LightsObject[carid][1]);
LightsObject[carid][0] = -1;
LightsObject[carid][1] = -1;
if(Signal[carid] == 2)
{
SignalTick[carid][0] = 0;
SignalTick[carid][1] = -1;
PlayerSignalOFF(playerid);
Signal[carid] = 0;
}
else
{
if(Signal[carid] == 1)
{
TextDrawShowForPlayer(playerid, SignalDraw[0]);
TextDrawHideForPlayer(playerid, SignalDraw[2]);
}
LightsObject[carid][0] = CreateObject(19294, 0, 0, 0, 0, 0, 0);
LightsObject[carid][1] = CreateObject(19294, 0, 0, 0, 0, 0, 0);
AttachObjectToVehicle(LightsObject[carid][0], carid, LightsPos[model][0], LightsPos[model][1], LightsPos[model][2], 0, 0, 0);
AttachObjectToVehicle(LightsObject[carid][1], carid, LightsPos[model][3], LightsPos[model][4], LightsPos[model][5], 0, 0, 0);
PlayerSignalON(playerid, 1, true);
GetVehicleZAngle(carid, SignalAngle[carid]);
SignalTick[carid][0] = 0;
SignalTick[carid][1] = -1;
Signal[carid] = 2;
}
return 1;
}
else if((newkeys == KEY_LOOK_LEFT))//Linker Blinker
{
DestroyObject(LightsObject[carid][0]);
DestroyObject(LightsObject[carid][1]);
LightsObject[carid][0] = -1;
LightsObject[carid][1] = -1;
if(Signal[carid] == 1)
{
SignalTick[carid][0] = 0;
SignalTick[carid][1] = -1;
PlayerSignalOFF(playerid);
Signal[carid] = 0;
}
else
{
if(Signal[carid] == 2)
{
TextDrawShowForPlayer(playerid, SignalDraw[1]);
TextDrawHideForPlayer(playerid, SignalDraw[3]);
}
LightsObject[carid][0] = CreateObject(19294, 0, 0, 0, 0, 0, 0);
LightsObject[carid][1] = CreateObject(19294, 0, 0, 0, 0, 0, 0);
AttachObjectToVehicle(LightsObject[carid][0], carid, -LightsPos[model][0], LightsPos[model][1], LightsPos[model][2], 0, 0, 0);
AttachObjectToVehicle(LightsObject[carid][1], carid, -LightsPos[model][3], LightsPos[model][4], LightsPos[model][5], 0, 0, 0);
PlayerSignalON(playerid, 0, true);
GetVehicleZAngle(carid, SignalAngle[carid]);
SignalTick[carid][0] = 0;
SignalTick[carid][1] = -1;
Signal[carid] = 1;
}
return 1;
}
}
}

stock PlayerSignalON(playerid, signal, light)
{
new signal2, light2;
if(signal == 0) signal2 = 1;
else signal2 = 0;
if(light == 0) light2 = 1;
else light2 = 0;
TextDrawShowForPlayer(playerid, SignalDraw[signal2]);
TextDrawHideForPlayer(playerid, SignalDraw[signal2 + 2]);

ToggleTextDrawForPlayer(playerid, SignalDraw[signal], light2);
ToggleTextDrawForPlayer(playerid, SignalDraw[signal + 2], light);

PlayerPlaySound(playerid, 1131, 0.0, 0.0, 0.0);
return 1;
}

stock PlayerSignalOFF(playerid)
{
TextDrawShowForPlayer(playerid, SignalDraw[0]);
TextDrawShowForPlayer(playerid, SignalDraw[1]);
TextDrawHideForPlayer(playerid, SignalDraw[2]);
TextDrawHideForPlayer(playerid, SignalDraw[3]);
return 1;
}

stock UpdateSignal( playerid, status, stick, endtick )
{
new signal = ( status - 1 );
if(!endtick)
{
PlayerSignalOFF(playerid);
}
else if(stick == 17)
{
PlayerSignalON(playerid, signal, true);
}
else if(stick == 8)
{
PlayerSignalON(playerid, signal, false);
}
return 1;
}

stock ToggleTextDrawForPlayer(playerid, Text:textdraw, toggle)
{
if(toggle) TextDrawShowForPlayer(playerid, textdraw);
else TextDrawHideForPlayer(playerid, textdraw);
return 1;
}

Tut mir leid aber kann kein thread öffnen weis nicht wieso.. deswegen wollte ich hier mal fragen wo mein fehler ist

Ich kann euch sagen warum, weil einer von eurem Team das Script rumgeschickt hat. Habe selbst ab der Version 1.9.3 Aufwärts die Scripts bekommen.
Deswegen gehen nunmal Server down, weil die eigentliche Schuld vom Team selber kommt..
War eigentlich ein guter Server mit Potenzial

Wenn du die neueste pRP Version brauchst kannst dich ja pn bei mir melden
Desweiteren check deine Plugins ab

eventuell falsche oder fehlende Plugins

Habs nun verkürzt aber nun bekomm ich diese MySQL meldungen:
[20:50:10] [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 '' at line 1
[20:50:10] [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 '' at line 1
[20:50:10] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'TimeAfterRegister'
[20:50:11] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'pArchs0'
[20:50:11] [ERROR] CMySQLQuery::Execute[()] - (error #1215) Cannot add foreign key constraint
[20:50:12] [ERROR] CMySQLQuery::Execute[()] - (error #1136) Column count doesn't match value count at row 1
[20:50:12] [ERROR] CMySQLQuery::Execute[OnQueryFinish(siii)] - (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 '' at line 1

Verkürzte Version:
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,");
mysql_function_query(MySqlConnection,query,false,"","");
strdel(query,0,sizeof(query));
strcat(query,"ALTER TABLE `"#SQLTAG"_account_main` ADD COLUMN (`Tot_VirtualWorld` int(11) NOT NULL,`TotZeit` int(4) NOT NULL,");
strcat(query,"`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,`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,");
strcat(query,"`PaintBallTode` int(10) NOT NULL,`PaintBallRang` int(3) NOT NULL,`PaintBallBesuche` int(8) NOT NULL,`AngenommeneReports` int(6) NOT NULL,`KopfGeld` int(10) NOT NULL,");
strcat(query,"`Bankkonto` int(2) NOT NULL,`pArmyPlaneOrder` int(2) NOT NULL,`pArmyHeliOrder` int(2) NOT NULL,`pArmyWaffenOrder` int(2) NOT NULL,`LevelUPKosten` int(10) NOT NULL,`RespectForLevelUp` int(6) NOT NULL,`RespectFromPayday` int(6) NOT NULL,`TimeAfterRegister` int(12) NOT NULL,");
mysql_function_query(MySqlConnection,query,false,"","");
strdel(query,0,sizeof(query));
strcat(query,"ALTER TABLE `"#SQLTAG"_account_main` ADD COLUMN (`TimeAfterRegister` int(12) NOT NULL,`Time4Payday` int(3) NOT NULL,`HabGeworben` int(2) NOT NULL,`pPremiumZeit` int(11) NOT NULL,`GeworbenerSpieler` varchar(24) NOT NULL,`TimeoutCrashExeorKick` int(3) NOT NULL,`PropertyClearTime` int(128) NOT NULL,");
strcat(query,"`pScheinSperre` int(11) NOT NULL,`PingFPS` int(2) NOT NULL,`DigiHud` int(2) NOT NULL,`Bonus` int(2) NOT NULL,`pOrgLeader` int(4) NOT NULL,`pOrgMember` int(4) NOT NULL,`pLohn` int(12) NOT NULL,`WaitPerso` int(128) NOT NULL,`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,");
strcat(query,"`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));

Hab jetzt wieder ein dickes fettes Problem, komme echt mit diesen Column's nicht klar..
(86971) : error 075: input line too long (after substitutions)
(86972) : error 037: invalid string (possibly non-terminated string)
(86972) : error 029: invalid expression, assumed zero
(86972) : warning 215: expression has no effect
(86972) : error 001: expected token: ";", but found "`"
(86972) : fatal error 107: too many error messages on one line
Compilation aborted.Pawn compiler 3.2.3664 Copyright (c) 1997-2006, ITB CompuPhase
5 Errors.

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,");
mysql_function_query(MySqlConnection,query,false,"","");
strdel(query,0,sizeof(query));
strcat(query,"ALTER TABLE `"#SQLTAG"_account_main` ADD COLUMN (`Tot_VirtualWorld` int(11) NOT NULL,`TotZeit` int(4) NOT NULL,");
strcat(query,"`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,`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,");
strcat(query,"`PaintBallTode` int(10) NOT NULL,`PaintBallRang` int(3) NOT NULL,`PaintBallBesuche` int(8) NOT NULL,`AngenommeneReports` int(6) NOT NULL,`KopfGeld` int(10) NOT NULL,");
strcat(query,"`Bankkonto` int(2) NOT NULL,`pArmyPlaneOrder` int(2) NOT NULL,`pArmyHeliOrder` int(2) NOT NULL,`pArmyWaffenOrder` int(2) NOT NULL,`LevelUPKosten` int(10) NOT NULL,`RespectForLevelUp` int(6) NOT NULL,`RespectFromPayday` int(6) NOT NULL,`TimeAfterRegister` int(12) NOT NULL,");
mysql_function_query(MySqlConnection,query,false,"","");
strdel(query,0,sizeof(query));
(86971) Hier strcat(query,"ALTER TABLE `"#SQLTAG"_account_main` ADD COLUMN (`TimeAfterRegister` int(12) NOT NULL,`Time4Payday` int(3) NOT NULL,`HabGeworben` int(2) NOT NULL,");
(86972) Hier strcat(query,"`pPremiumZeit` int(11) NOT NULL,`GeworbenerSpieler` varchar(24) NOT NULL,`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,`Bonus` int(2) NOT NULL,`pOrgLeader` int(4) NOT NULL,`pOrgMember` int(4) NOT NULL,`pLohn` int(12) NOT NULL,`WaitPerso` int(128) NOT NULL,`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,");
strcat(query,"`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));

Danke

strcat(query,"ALTER TABLE `"#SQLTAG"_account_inventar` ADD COLUMN (");
for(new i=0;i<MAX_ARCHIVMENTS;i++)
{
strcat(query,",");
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));

Meinste so beim 2. Teil ?

Oder lieber so ?

strcat(query,"ALTER TABLE `"#SQLTAG"_account_inventar` ADD COLUMN (");
for(new i=0;i<MAX_ARCHIVMENTS;i++)
{
if(i > 0) strcat(query,",");
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));