Fraktions Kassen Bugg pRP Script

Hallo & Herzlich Willkommen
Ich besitze das pRP Script edit Planet Roleplay und mir wurde öfters gesagt das nachem Restart aufeinmal die Fkassen leer sind oder aufeinmal was anderes wie z.b vorher 500k dann 2mille oder so drine sind vielleicht haben mehrere den Fehler schon gehabt hoffe ihr könnt mir dort weiter helfen..

mfg. CranK

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;
}

Das der Code wo die Laden

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;
}