pRP Fraktions Kassen Bugg

CranK[491] · 13. Januar 2014

Hallo & Herzlich Willkommen von dem Script Pure Roleplay / Planet Roleplay Edit habe ich den Bugg das wenn man Den Server Neustartet aufeinmal einen anderen Kontostand in der Fkasse hat
ich weis nicht woran es liegen könnte

hier laden Sie

case _SQL_FVERWALTUNG_LOAD:
{
cache_get_data(rows,fields);
new fvr = 0;
if(rows)
{
while(fvr<rows)
{
cache_get_field_content(fvr,"Geld",result);
fverwaltungen[fvr][Geld] = strval(result);
strdel(result,0,sizeof(result));
cache_get_field_content(fvr,"Opium",result);
fverwaltungen[fvr][Opium] = strval(result);
strdel(result,0,sizeof(result));
cache_get_field_content(fvr,"Ganja",result);
fverwaltungen[fvr][Ganja] = strval(result);
strdel(result,0,sizeof(result));
cache_get_field_content(fvr,"Kokain",result);
fverwaltungen[fvr][Kokain] = strval(result);
strdel(result,0,sizeof(result));
cache_get_field_content(fvr,"C4",result);
fverwaltungen[fvr][C4] = strval(result);
strdel(result,0,sizeof(result));
cache_get_field_content(fvr,"Materials",result);
fverwaltungen[fvr][Materials] = strval(result);
strdel(result,0,sizeof(result));
cache_get_field_content(fvr,"WaffenPack",result);
fverwaltungen[fvr][WaffenPack] = strval(result);
strdel(result,0,sizeof(result));
cache_get_field_content(fvr,"WaffenSlots",result);
fverwaltungen[fvr][WaffenSlots] = strval(result);
strdel(result,0,sizeof(result));
cache_get_field_content(fvr,"Heal",result);
fverwaltungen[fvr][Heal] = strval(result);
strdel(result,0,sizeof(result));
cache_get_field_content(fvr,"HealSlots",result);
fverwaltungen[fvr][HealSlots] = strval(result);
strdel(result,0,sizeof(result));
cache_get_field_content(fvr,"Armour",result);
fverwaltungen[fvr][Armour] = strval(result);
strdel(result,0,sizeof(result));
cache_get_field_content(fvr,"ArmourSlots",result);
fverwaltungen[fvr][ArmourSlots] = strval(result);
strdel(result,0,sizeof(result));
cache_get_field_content(fvr,"HaveVBInvite",result);
fverwaltungen[fvr][HaveVBInvite] = strval(result);
strdel(result,0,sizeof(result));
cache_get_field_content(fvr,"VBFraktion",result);
fverwaltungen[fvr][VBFraktion] = strval(result);
strdel(result,0,sizeof(result));
cache_get_field_content(fvr,"F0",result);
format(frank0[fvr],32,"%s",result);
strdel(result,0,sizeof(result));
cache_get_field_content(fvr,"F1",result);
format(frank1[fvr],32,"%s",result);
strdel(result,0,sizeof(result));
cache_get_field_content(fvr,"F2",result);
format(frank2[fvr],32,"%s",result);
strdel(result,0,sizeof(result));
cache_get_field_content(fvr,"F3",result);
format(frank3[fvr],32,"%s",result);
strdel(result,0,sizeof(result));
cache_get_field_content(fvr,"F4",result);
format(frank4[fvr],32,"%s",result);
strdel(result,0,sizeof(result));
cache_get_field_content(fvr,"F5",result);
format(frank5[fvr],32,"%s",result);
strdel(result,0,sizeof(result));
cache_get_field_content(fvr,"F6",result);
format(frank6[fvr],32,"%s",result);
strdel(result,0,sizeof(result));
cache_get_field_content(fvr,"GFFID",result);
fverwaltungen[fvr][GangFightfID] = strval(result);
strdel(result,0,sizeof(result));
cache_get_field_content(fvr,"GFOWNER",result);
fverwaltungen[fvr][GangFightOwner] = strval(result);
strdel(result,0,sizeof(result));
cache_get_field_content(fvr,"GSKILLS",result);
fverwaltungen[fvr][GangFightKills] = strval(result);
strdel(result,0,sizeof(result));
cache_get_field_content(fvr,"GFDEATHS",result);
fverwaltungen[fvr][GangFightDeaths] = strval(result);
strdel(result,0,sizeof(result));
cache_get_field_content(fvr,"Spice",result);
fverwaltungen[fvr][Spice] = strval(result);
strdel(result,0,sizeof(result));
cache_get_field_content(fvr,"FrakMembers",result);
fverwaltungen[fvr][FrakMembers] = strval(result);
strdel(result,0,sizeof(result));
cache_get_field_content(fvr,"FrakLimit",result);
fverwaltungen[fvr][FrakLimit] = strval(result);
strdel(result,0,sizeof(result));
fvr++;
}
}
printf("- Fraktionsvewaltungen geladen %i/%i -",rows,MAX_FRAKTIONNEN-1);
return 1;
}

case _SQL_FVERWALTUNG_INSERT:
{
cache_get_data(rows,fields);
if(!rows)
{
format(query,sizeof(query),"INSERT INTO "#DATENBANKTAG"_fraktion_verwaltung (fID,Geld,Opium,Spice,Ganja,Kokain,C4,Materials,WaffenPack,WaffenSlots,Heal,HealSlots,Armour,ArmourSlots,HaveVBInvite,VBFraktion,F0,F1,F2,F3,F4,F5,F6) VALUES ('%d','500000','0','0','0','0','0','200000','1','50','1','50','1','50','0','0','R0','R1','R2','R3','R4','R5','R6')",extraid);
mysql_function_query(MySqlConnection,query,false,"","");
printf("- Fraktionsvewaltung für die Fraktion %i erstellt -",extraid);
}
return 1;
}

Kevin1 · 13. Januar 2014

MySQL-Debug aktivieren ...
Dann schaust du:
1. Was wird beim Erstellen der Fraktionsverwaltung in die Logdatei geschrieben?
2. Was wird beim Laden der Fraktionsverwaltung in die Logdatei geschrieben?
3. Was wird beim Neustarten in die Logdatei geschrieben?
Den Log suchst du nach "_fraktion_verwaltung" ab.

Zusätzlich:
4. Existiert die Tabelle?
5. #DATENBANKTAG -> Wie in der Datenbank?
6. Was heißt "auf einmal einen anderen Kontostand"? Immer nach dem Neustarten der Gleiche oder immer irgendwelche anderen Zahlen?
7. Zeig mal bei "FVERWALTUNG_LOAD" die Query.

MfG Kevin

CranK[491] · 13. Januar 2014

andere Zahlen also auch Materialien etc.

case _SQL_FVERWALTUNG_LOAD:
{
cache_get_data(rows,fields);
new fvr = 0;
if(rows)
{
while(fvr<rows)
{
cache_get_field_content(fvr,"Geld",result);
fverwaltungen[fvr][Geld] = strval(result);
strdel(result,0,sizeof(result));
cache_get_field_content(fvr,"Opium",result);
fverwaltungen[fvr][Opium] = strval(result);
strdel(result,0,sizeof(result));
cache_get_field_content(fvr,"Ganja",result);
fverwaltungen[fvr][Ganja] = strval(result);
strdel(result,0,sizeof(result));
cache_get_field_content(fvr,"Kokain",result);
fverwaltungen[fvr][Kokain] = strval(result);
strdel(result,0,sizeof(result));
cache_get_field_content(fvr,"C4",result);
fverwaltungen[fvr][C4] = strval(result);
strdel(result,0,sizeof(result));
cache_get_field_content(fvr,"Materials",result);
fverwaltungen[fvr][Materials] = strval(result);
strdel(result,0,sizeof(result));
cache_get_field_content(fvr,"WaffenPack",result);
fverwaltungen[fvr][WaffenPack] = strval(result);
strdel(result,0,sizeof(result));
cache_get_field_content(fvr,"WaffenSlots",result);
fverwaltungen[fvr][WaffenSlots] = strval(result);
strdel(result,0,sizeof(result));
cache_get_field_content(fvr,"Heal",result);
fverwaltungen[fvr][Heal] = strval(result);
strdel(result,0,sizeof(result));
cache_get_field_content(fvr,"HealSlots",result);
fverwaltungen[fvr][HealSlots] = strval(result);
strdel(result,0,sizeof(result));
cache_get_field_content(fvr,"Armour",result);
fverwaltungen[fvr][Armour] = strval(result);
strdel(result,0,sizeof(result));
cache_get_field_content(fvr,"ArmourSlots",result);
fverwaltungen[fvr][ArmourSlots] = strval(result);
strdel(result,0,sizeof(result));
cache_get_field_content(fvr,"HaveVBInvite",result);
fverwaltungen[fvr][HaveVBInvite] = strval(result);
strdel(result,0,sizeof(result));
cache_get_field_content(fvr,"VBFraktion",result);
fverwaltungen[fvr][VBFraktion] = strval(result);
strdel(result,0,sizeof(result));
cache_get_field_content(fvr,"F0",result);
format(frank0[fvr],32,"%s",result);
strdel(result,0,sizeof(result));
cache_get_field_content(fvr,"F1",result);
format(frank1[fvr],32,"%s",result);
strdel(result,0,sizeof(result));
cache_get_field_content(fvr,"F2",result);
format(frank2[fvr],32,"%s",result);
strdel(result,0,sizeof(result));
cache_get_field_content(fvr,"F3",result);
format(frank3[fvr],32,"%s",result);
strdel(result,0,sizeof(result));
cache_get_field_content(fvr,"F4",result);
format(frank4[fvr],32,"%s",result);
strdel(result,0,sizeof(result));
cache_get_field_content(fvr,"F5",result);
format(frank5[fvr],32,"%s",result);
strdel(result,0,sizeof(result));
cache_get_field_content(fvr,"F6",result);
format(frank6[fvr],32,"%s",result);
strdel(result,0,sizeof(result));
cache_get_field_content(fvr,"GFFID",result);
fverwaltungen[fvr][GangFightfID] = strval(result);
strdel(result,0,sizeof(result));
cache_get_field_content(fvr,"GFOWNER",result);
fverwaltungen[fvr][GangFightOwner] = strval(result);
strdel(result,0,sizeof(result));
cache_get_field_content(fvr,"GSKILLS",result);
fverwaltungen[fvr][GangFightKills] = strval(result);
strdel(result,0,sizeof(result));
cache_get_field_content(fvr,"GFDEATHS",result);
fverwaltungen[fvr][GangFightDeaths] = strval(result);
strdel(result,0,sizeof(result));
cache_get_field_content(fvr,"Spice",result);
fverwaltungen[fvr][Spice] = strval(result);
strdel(result,0,sizeof(result));
cache_get_field_content(fvr,"FrakMembers",result);
fverwaltungen[fvr][FrakMembers] = strval(result);
strdel(result,0,sizeof(result));
cache_get_field_content(fvr,"FrakLimit",result);
fverwaltungen[fvr][FrakLimit] = strval(result);
strdel(result,0,sizeof(result));
fvr++;
}
}
printf("- Fraktionsvewaltungen geladen %i/%i -",rows,MAX_FRAKTIONNEN-1);
return 1;
}

Kevin1 · 13. Januar 2014

Muss ich das jetzt verstehen warum du das nochmal 1zu1 postest?
Und was wolltest du uns mit dem Einzeiler sagen?

CranK[491] · 13. Januar 2014

Mehr kann ich dir leider nicht zeigen hoffe du kannst es schaffen

Kevin1 · 13. Januar 2014

Zitat von [ScR]CranK

Mehr kann ich dir leider nicht zeigen hoffe du kannst es schaffen

Nö.
Wo ist das Problem bei den Punkten die ich geschrieben habe?
Debug aktivieren? Keine Lust? Kein Plan wie man sich die Tabellen anschaut?
...
Wenn du willst dass man dir hilft, dann musst du auch mitspielen und paar mehr Informationen preisgeben.
Wenn nicht dann lass es einfach komplett bleiben!

breadfish.de 12. März 2022