MYSQL, so oder so?

Hallo Community,

ich habe mich gerade beschäftigt meine MYSQL Speicherart etwas umzubauen, undzwar zurzeit habe ich es so:

mysql_SetInt("accounts", "Knastzeit", SInfo[playerid][pKnastzeit], "Name", SInfo[playerid][pName]);
mysql_SetInt("accounts", "Wanted", SInfo[playerid][pWanted], "Name", SInfo[playerid][pName]);
mysql_SetInt("accounts", "Knast", SInfo[playerid][pKnast], "Name", SInfo[playerid][pName]);

etc.

und nun will ich es aber so:

format(query,sizeof query,"UPDATE accounts id='%d' Level='%d' Geld='%.f2' Kills='%d'", etc...

Macht das einen großen unterschied?

Habe es nun so:

new query[1900];
format(query,sizeof query,"UPDATE `accounts` id='%d' Level='%d' Geld='%.f2' Kills='%d' Tode='%d' Health='%.f0' HatRegi='%d' Alter='%d' Geschlecht='%d' Land='%d' Mission='%d' Noobmietet='%d' HatGeld='%d' Handy='%d' HandyVer='%d' SMSFrei='%d' FreiMin='%d' Guthaben='%.f2' Nummer='%d' Autover='%d' Perso='%d Lebenver='%d' Akku='%d' Payday='%d Handyart='%d' Admin='%d' Leader='%d Member='%d' Skin='%d' Knastzeit='%d Wanted='%d' Knast='%d' pBootschein='%d pHelischein='%d' pMotorradschein='%d pLKWschein='%d' pRollerschein='%d' pAutoschein='%d Bankkonto='%.f2' Kreditpayday='%d' Kredit='%.f2 Job='%d'",
SInfo[playerid][pid],SInfo[playerid][pLevel],SInfo[playerid][pGeld],SInfo[playerid][pKills],SInfo[playerid][pTode],SInfo[playerid][pHealth],SInfo[playerid][pHatRegi], SInfo[playerid][pAlter],SInfo[playerid][pGeschlecht],SInfo[playerid][pLand],SInfo[playerid][pMission],SInfo[playerid][pNoobmietet],SInfo[playerid][pHatGeld],SInfo[playerid][pHandy],
SInfo[playerid][pHandyVer],SInfo[playerid][pSMSFrei],SInfo[playerid][pFreiMin],SInfo[playerid][pGuthaben],SInfo[playerid][pNummer],SInfo[playerid][pAutover],
SInfo[playerid][pPerso],SInfo[playerid][pLebenver],SInfo[playerid][pAkku],SInfo[playerid][pPayday],SInfo[playerid][pHandyart],SInfo[playerid][pAdmin],SInfo[playerid][pLeader], SInfo[playerid][pMember],SInfo[playerid][pSkin],SInfo[playerid][pKnastzeit],SInfo[playerid][pWanted],SInfo[playerid][pKnast], SInfo[playerid][pBootschein], SInfo[playerid][pHelischein],
SInfo[playerid][pMotorradschein],SInfo[playerid][pLKWschein],SInfo[playerid][pRollerschein],SInfo[playerid][pAutoschein],SInfo[playerid][pBankkonto],SInfo[playerid][pKreditpayday],SInfo[playerid][pKredit],SInfo[playerid][pJob];
mysql_query(query);
mysql_free_result();

Aber ich kriege immer ErrorS:

C:\Users\Moritz McGarrett\Desktop\Selfmade\gamemodes\Selfmade.pwn(5584) : error 075: input line too long (after substitutions)
C:\Users\Moritz McGarrett\Desktop\Selfmade\gamemodes\Selfmade.pwn(5585) : error 037: invalid string (possibly non-terminated string)
C:\Users\Moritz McGarrett\Desktop\Selfmade\gamemodes\Selfmade.pwn(5585) : error 017: undefined symbol "UPDATE"
C:\Users\Moritz McGarrett\Desktop\Selfmade\gamemodes\Selfmade.pwn(5585) : error 029: invalid expression, assumed zero
C:\Users\Moritz McGarrett\Desktop\Selfmade\gamemodes\Selfmade.pwn(5585) : 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.

Immer noch nicht.. wie kann ich "ehfwsfu" in zwei reihen machen? und wie beheben ich das mit dem UPDATE?

//edit

Muss ich das "Update" irgendwie definieren damit ich keine Errors mehr bekomme? und wie teile ich eine Zeile in zwei?

Also "Wasgeht=D

Wasgeht=D"

So?

Wie mach ich das nun am besten mit diesem strcat?

Was ist ein strcat? kannst du mir das vllt erklären ;)?

Also so:

new query1[900], query2[900], stringzusammen[1024];
format(query1,sizeof query1,"UPDATE accounts id='%d' Level='%d' Geld='%.f2' Kills='%d' Tode='%d' Health='%.f0' HatRegi='%d' Alter='%d' Geschlecht='%d' Land='%d' Mission='%d' Noobmietet='%d' HatGeld='%d' Handy='%d' HandyVer='%d' SMSFrei='%d' FreiMin='%d' Guthaben='%.f2' Nummer='%d' Autover='%d' Perso='%d Lebenver='%d' Akku='%d' Payday='%d Handyart='%d'",
SInfo[playerid][pid],SInfo[playerid][pLevel],SInfo[playerid][pGeld],SInfo[playerid][pKills],SInfo[playerid][pTode],SInfo[playerid][pHealth],SInfo[playerid][pHatRegi], SInfo[playerid][pAlter],SInfo[playerid][pGeschlecht],SInfo[playerid][pLand],SInfo[playerid][pMission],SInfo[playerid][pNoobmietet],SInfo[playerid][pHatGeld],SInfo[playerid][pHandy],
SInfo[playerid][pHandyVer],SInfo[playerid][pSMSFrei],SInfo[playerid][pFreiMin],SInfo[playerid][pGuthaben],SInfo[playerid][pNummer],SInfo[playerid][pAutover], SInfo[playerid][pPerso],SInfo[playerid][pLebenver],SInfo[playerid][pAkku],SInfo[playerid][pPayday],SInfo[playerid][pHandyart]);
format(query2,sizeof query2,"UPDATE accounts Admin='%d' Leader='%d Member='%d' Skin='%d' Knastzeit='%d Wanted='%d' Knast='%d' pBootschein='%d pHelischein='%d' pMotorradschein='%d pLKWschein='%d' pRollerschein='%d' pAutoschein='%d Bankkonto='%.f2' Kreditpayday='%d' Kredit='%.f2 Job='%d'",
SInfo[playerid][pAdmin],SInfo[playerid][pLeader], SInfo[playerid][pMember],SInfo[playerid][pSkin],SInfo[playerid][pKnastzeit],SInfo[playerid][pWanted],SInfo[playerid][pKnast], SInfo[playerid][pBootschein], SInfo[playerid][pHelischein],
SInfo[playerid][pMotorradschein],SInfo[playerid][pLKWschein],SInfo[playerid][pRollerschein],SInfo[playerid][pAutoschein],SInfo[playerid][pBankkonto],SInfo[playerid][pKreditpayday],SInfo[playerid][pKredit],SInfo[playerid][pJob]);
strcat(query1,stringzusammen);
strcat(query2,stringzusammen);
mysql_query(stringzusammen);
mysql_free_result();

Zitat von LeijaT

format(query, sizeof(query), "UPDATE table SET \
asdf = #, \
qwer = #, \
yxcv = #, \
etc etc")

Sollte eigentlich problemlos funktionieren.

Sorry aber da komm ich nicht mit

new query[900] = "UPDATE accounts id='%d' Level='%d' Geld='%.f2' Kills='%d' Tode='%d' Health='%.f0' HatRegi='%d' Alter='%d' Geschlecht='%d' Land='%d' Mission='%d' Noobmietet='%d' HatGeld='%d' Handy='%d' HandyVer='%d' SMSFrei='%d' FreiMin='%d' Guthaben='%.f2' Nummer='%d' Autover='%d' Perso='%d Lebenver='%d' Akku='%d' Payday='%d Handyart='%d'";
strcat(query,"Admin='%d' Leader='%d Member='%d' Skin='%d' Knastzeit='%d Wanted='%d' Knast='%d' pBootschein='%d pHelischein='%d' pMotorradschein='%d pLKWschein='%d' pRollerschein='%d' pAutoschein='%d Bankkonto='%.f2' Kreditpayday='%d' Kredit='%.f2 Job='%d'",
SInfo[playerid][pid],SInfo[playerid][pLevel],SInfo[playerid][pGeld],SInfo[playerid][pKills],SInfo[playerid][pTode],SInfo[playerid][pHealth],SInfo[playerid][pHatRegi], SInfo[playerid][pAlter],SInfo[playerid][pGeschlecht],SInfo[playerid][pLand],SInfo[playerid][pMission],SInfo[playerid][pNoobmietet],SInfo[playerid][pHatGeld],SInfo[playerid][pHandy],
SInfo[playerid][pHandyVer],SInfo[playerid][pSMSFrei],SInfo[playerid][pFreiMin],SInfo[playerid][pGuthaben],SInfo[playerid][pNummer],SInfo[playerid][pAutover], SInfo[playerid][pPerso],SInfo[playerid][pLebenver],SInfo[playerid][pAkku],SInfo[playerid][pPayday],SInfo[playerid][pHandyart]
SInfo[playerid][pAdmin],SInfo[playerid][pLeader], SInfo[playerid][pMember],SInfo[playerid][pSkin],SInfo[playerid][pKnastzeit],SInfo[playerid][pWanted],SInfo[playerid][pKnast], SInfo[playerid][pBootschein], SInfo[playerid][pHelischein],
SInfo[playerid][pMotorradschein],SInfo[playerid][pLKWschein],SInfo[playerid][pRollerschein],SInfo[playerid][pAutoschein],SInfo[playerid][pBankkonto],SInfo[playerid][pKreditpayday],SInfo[playerid][pKredit],SInfo[playerid][pJob]);
mysql_query(query);
mysql_free_result();

So hab ich es nun, kriege aber millionen warnings...

C:\Users\Moritz McGarrett\Desktop\Selfmade\gamemodes\Selfmade.pwn(5586 -- 5587) : warning 202: number of arguments does not match definition
C:\Users\Moritz McGarrett\Desktop\Selfmade\gamemodes\Selfmade.pwn(5586 -- 5587) : warning 202: number of arguments does not match definition
C:\Users\Moritz McGarrett\Desktop\Selfmade\gamemodes\Selfmade.pwn(5586 -- 5587) : warning 202: number of arguments does not match definition
C:\Users\Moritz McGarrett\Desktop\Selfmade\gamemodes\Selfmade.pwn(5586 -- 5587) : warning 202: number of arguments does not match definition
C:\Users\Moritz McGarrett\Desktop\Selfmade\gamemodes\Selfmade.pwn(5586 -- 5587) : warning 202: number of arguments does not match definition
C:\Users\Moritz McGarrett\Desktop\Selfmade\gamemodes\Selfmade.pwn(5586 -- 5587) : warning 202: number of arguments does not match definition
C:\Users\Moritz McGarrett\Desktop\Selfmade\gamemodes\Selfmade.pwn(5586 -- 5587) : warning 202: number of arguments does not match definition
C:\Users\Moritz McGarrett\Desktop\Selfmade\gamemodes\Selfmade.pwn(5586 -- 5587) : warning 202: number of arguments does not match definition
C:\Users\Moritz McGarrett\Desktop\Selfmade\gamemodes\Selfmade.pwn(5586 -- 5587) : warning 202: number of arguments does not match definition
C:\Users\Moritz McGarrett\Desktop\Selfmade\gamemodes\Selfmade.pwn(5586 -- 5587) : warning 202: number of arguments does not match definition
C:\Users\Moritz McGarrett\Desktop\Selfmade\gamemodes\Selfmade.pwn(5586 -- 5587) : warning 202: number of arguments does not match definition
C:\Users\Moritz McGarrett\Desktop\Selfmade\gamemodes\Selfmade.pwn(5586 -- 5587) : warning 202: number of arguments does not match definition
C:\Users\Moritz McGarrett\Desktop\Selfmade\gamemodes\Selfmade.pwn(5586 -- 5587) : warning 202: number of arguments does not match definition
C:\Users\Moritz McGarrett\Desktop\Selfmade\gamemodes\Selfmade.pwn(5586 -- 5588) : warning 202: number of arguments does not match definition
C:\Users\Moritz McGarrett\Desktop\Selfmade\gamemodes\Selfmade.pwn(5586 -- 5588) : warning 202: number of arguments does not match definition
C:\Users\Moritz McGarrett\Desktop\Selfmade\gamemodes\Selfmade.pwn(5586 -- 5588) : warning 202: number of arguments does not match definition
C:\Users\Moritz McGarrett\Desktop\Selfmade\gamemodes\Selfmade.pwn(5586 -- 5588) : warning 202: number of arguments does not match definition
C:\Users\Moritz McGarrett\Desktop\Selfmade\gamemodes\Selfmade.pwn(5586 -- 5588) : warning 202: number of arguments does not match definition
C:\Users\Moritz McGarrett\Desktop\Selfmade\gamemodes\Selfmade.pwn(5586 -- 5588) : warning 202: number of arguments does not match definition
C:\Users\Moritz McGarrett\Desktop\Selfmade\gamemodes\Selfmade.pwn(5586 -- 5588) : warning 202: number of arguments does not match definition
C:\Users\Moritz McGarrett\Desktop\Selfmade\gamemodes\Selfmade.pwn(5586 -- 5588) : warning 202: number of arguments does not match definition
C:\Users\Moritz McGarrett\Desktop\Selfmade\gamemodes\Selfmade.pwn(5586 -- 5588) : warning 202: number of arguments does not match definition
C:\Users\Moritz McGarrett\Desktop\Selfmade\gamemodes\Selfmade.pwn(5586 -- 5588) : warning 202: number of arguments does not match definition
C:\Users\Moritz McGarrett\Desktop\Selfmade\gamemodes\Selfmade.pwn(5586 -- 5589) : warning 202: number of arguments does not match definition
C:\Users\Moritz McGarrett\Desktop\Selfmade\gamemodes\Selfmade.pwn(5586 -- 5589) : error 001: expected token: ",", but found "-identifier-"
C:\Users\Moritz McGarrett\Desktop\Selfmade\gamemodes\Selfmade.pwn(5589) : warning 215: expression has no effect
C:\Users\Moritz McGarrett\Desktop\Selfmade\gamemodes\Selfmade.pwn(5589) : warning 215: expression has no effect
C:\Users\Moritz McGarrett\Desktop\Selfmade\gamemodes\Selfmade.pwn(5589) : warning 215: expression has no effect
C:\Users\Moritz McGarrett\Desktop\Selfmade\gamemodes\Selfmade.pwn(5589) : warning 215: expression has no effect
C:\Users\Moritz McGarrett\Desktop\Selfmade\gamemodes\Selfmade.pwn(5589) : warning 215: expression has no effect
C:\Users\Moritz McGarrett\Desktop\Selfmade\gamemodes\Selfmade.pwn(5589) : warning 215: expression has no effect
C:\Users\Moritz McGarrett\Desktop\Selfmade\gamemodes\Selfmade.pwn(5589) : warning 215: expression has no effect
C:\Users\Moritz McGarrett\Desktop\Selfmade\gamemodes\Selfmade.pwn(5589) : warning 215: expression has no effect
C:\Users\Moritz McGarrett\Desktop\Selfmade\gamemodes\Selfmade.pwn(5589) : warning 215: expression has no effect
C:\Users\Moritz McGarrett\Desktop\Selfmade\gamemodes\Selfmade.pwn(5589 -- 5590) : warning 215: expression has no effect
C:\Users\Moritz McGarrett\Desktop\Selfmade\gamemodes\Selfmade.pwn(5589 -- 5590) : warning 215: expression has no effect
C:\Users\Moritz McGarrett\Desktop\Selfmade\gamemodes\Selfmade.pwn(5589 -- 5590) : warning 215: expression has no effect
C:\Users\Moritz McGarrett\Desktop\Selfmade\gamemodes\Selfmade.pwn(5589 -- 5590) : warning 215: expression has no effect
C:\Users\Moritz McGarrett\Desktop\Selfmade\gamemodes\Selfmade.pwn(5589 -- 5590) : warning 215: expression has no effect
C:\Users\Moritz McGarrett\Desktop\Selfmade\gamemodes\Selfmade.pwn(5589 -- 5590) : warning 215: expression has no effect
C:\Users\Moritz McGarrett\Desktop\Selfmade\gamemodes\Selfmade.pwn(5589 -- 5590) : warning 215: expression has no effect
C:\Users\Moritz McGarrett\Desktop\Selfmade\gamemodes\Selfmade.pwn(5589 -- 5590) : warning 215: expression has no effect
C:\Users\Moritz McGarrett\Desktop\Selfmade\gamemodes\Selfmade.pwn(5590) : error 001: expected token: ";", but found ")"
C:\Users\Moritz McGarrett\Desktop\Selfmade\gamemodes\Selfmade.pwn(5590) : error 029: invalid expression, assumed zero
C:\Users\Moritz McGarrett\Desktop\Selfmade\gamemodes\Selfmade.pwn(5590) : fatal error 107: too many error messages on one line

Compilation aborted.Pawn compiler 3.2.3664 Copyright (c) 1997-2006, ITB CompuPhase

4 Errors.