Fraktionen laden - Fehler/Bug ?!

Moin, ich probiere schon die ganze Zeit an diesem blöden stock und finde nicht die Lösung.....
Er erstellt den Table und macht die Standarteinträge.... das ist soweit perfekt, wenn jedoch die Variablen nach dem erstellen in die Kassen geladen werden sollen dann streikt er, ich habe die Namen der Ränge mal printen lassen und folgendes kam raus:
[12:46:51] RRRRRRRRRRang - 10
[12:46:51] RRRRRRRRRang - 10
[12:46:51] RRRRRRRRang - 10
[12:46:51] RRRRRRRang - 10
[12:46:51] RRRRRRang - 10
[12:46:51] RRRRRang - 10
[12:46:51] RRRRang - 10
[12:46:51] RRRang - 10
[12:46:51] RRang - 10
[12:46:51] Rang - 10

So möchte ich die Namen den Fraktionen gern zuweisen bzw. so habe ich es versucht.....
Ausschnitt der LadeFunktion:
format(string, sizeof string, "%d", i);
for(new f; f < 10; f++)
{
format(TeamInfo[i][fRank][f],30,mysql_GetString("factions",frakt, "ID", string));
}

Normalerweise müsste er das ja eiggentlich so printen:
Rang - 1
Rang -2
Rang -3
Rang - 4
Rang -5
Rang - 6
etc.....

//Edit Mehr Informationen

Selbstverständlich
Variablen:

enum FraktionDaten
{
fID,
fKasse,
fRank[9],
fGehalt[9],
fSkin[9]

}
new TeamInfo[MAX_FRAKTION][FraktionDaten];

Erstellen des tables fals nicht vorhanden:
format(string3, (sizeof string3),"CREATE TABLE IF NOT EXISTS `factions` (`ID` INT(11) NOT NULL DEFAULT '0',`Geld` INT(11) NOT NULL DEFAULT '0',");
format(string4, (sizeof string4),"`Rank1` VARCHAR(24)DEFAULT 'Rang - 1' NOT NULL,`Rank2` VARCHAR(24) DEFAULT 'Rang - 2' NOT NULL,`Rank3` VARCHAR(24) DEFAULT 'Rang - 3' NOT NULL,`Rank4` VARCHAR(24) DEFAULT 'Rang - 4' NOT NULL,`Rank5` VARCHAR(24) DEFAULT 'Rang - 5' NOT NULL,`Rank6` VARCHAR(24) DEFAULT 'Rang - 6' NOT NULL,`Rank7` VARCHAR(24) DEFAULT 'Rang - 7' NOT NULL,`Rank8` VARCHAR(24) DEFAULT 'Rang - 8' NOT NULL,");
format(string9, (sizeof string9),"`Rank9` VARCHAR(24) DEFAULT 'Rang - 9' NOT NULL,`Rank10` VARCHAR(24)DEFAULT 'Rang - 10' NOT NULL,");
format(string5, (sizeof string5),"`Skin1` INT(11) NOT NULL DEFAULT '0',`Skin2` INT(11) NOT NULL DEFAULT '0',`Skin3` INT(11) NOT NULL DEFAULT '0',`Skin4` INT(11) NOT NULL DEFAULT '0',`Skin5` INT(11) NOT NULL DEFAULT '0',`Skin6` INT(11) NOT NULL DEFAULT '0',`Skin7` INT(11) NOT NULL DEFAULT '0',`Skin8` INT(11) NOT NULL DEFAULT '0',`Skin9` INT(11) NOT NULL DEFAULT '0',`Skin10` INT(11) NOT NULL DEFAULT '0',");
format(string6, (sizeof string6),"`Gehalt1` INT(11) NOT NULL DEFAULT '0',`Gehalt2` INT(11) NOT NULL DEFAULT '0',`Gehalt3` INT(11) NOT NULL DEFAULT '0',`Gehalt4` INT(11) NOT NULL DEFAULT '0',`Gehalt5` INT(11) NOT NULL DEFAULT '0',`Gehalt6` INT(11) NOT NULL DEFAULT '0',`Gehalt7` INT(11) NOT NULL DEFAULT '0',`Gehalt8` INT(11) NOT NULL DEFAULT '0',`Gehalt9` INT(11) NOT NULL DEFAULT '0'");
format(string7, (sizeof string7),",`Gehalt10` INT(11) NOT NULL DEFAULT '0',PRIMARY KEY (`ID`)) ENGINE=MyISAM AUTO_INCREMENT=0 DEFAULT CHARSET=latin1;");
format(string8, (sizeof string8),"%s%s%s%s%s%s",string3,string4,string9,string5,string6,string7);
mysql_query(string8);
CreateKassen();
LoadKassen();

Kassen Laden:
stock LoadKassen()
{
mysql_query("SELECT NULL FROM factions");
mysql_store_result();
new rows = mysql_num_rows();
mysql_free_result();
new string[3],frakt[20];
for(new i=0; i < rows; i++)
{
format(string, sizeof string, "%d", i);
TeamInfo[i][fKasse] = mysql_GetInt("factions", "Geld", "ID", string);
TeamInfo[i][fID]= mysql_GetInt("factions", "ID", "ID", string);
for(new f; f < 10; f++)
{
switch(f)
{
case 0:frakt= "Rank1";
case 1:frakt= "Rank2";
case 2:frakt= "Rank3";
case 3:frakt= "Rank4";
case 4:frakt= "Rank5";
case 5:frakt= "Rank6";
case 6:frakt= "Rank7";
case 7:frakt= "Rank8";
case 8:frakt= "Rank9";
case 9:frakt= "Rank10";
}
format(TeamInfo[i][fRank][f],30,mysql_GetString("factions",frakt, "ID", string));
print(TeamInfo[i][fRank][f]);
}
}
return 1;
}

Ich habe mein MySQL Speicher/Load system nach dem Prinzip aufgebaut: KlIck
Ich habe deinen Stock eingebaut PermanenT
So sieht mein Table aus nach dem ich den Server starte:
KlIck
Folgendes gibt die Console aus:
[15:08:18] (null)
[15:08:18] (null)
[15:08:18] (null)
[15:08:18] (null)
[15:08:18] (null)
[15:08:18] (null)
[15:08:18] (null)
[15:08:18] (null)
[15:08:18] (null)
[15:08:18] (null)
[15:08:18] Fraktion: 0
[15:08:18] (null)
[15:08:18] (null)
[15:08:18] (null)
[15:08:18] (null)
[15:08:18] (null)
[15:08:18] (null)
[15:08:18] (null)
[15:08:18] (null)
[15:08:18] (null)
[15:08:18] (null)
[15:08:18] Fraktion: 1
[15:08:18] (null)
[15:08:18] (null)
[15:08:18] (null)
[15:08:18] (null)
[15:08:18] (null)
[15:08:18] (null)
[15:08:18] (null)
[15:08:18] (null)
[15:08:18] (null)
[15:08:18] (null)
[15:08:18] Fraktion: 2
[15:08:18] (null)
[15:08:18] (null)
[15:08:18] (null)
[15:08:18] (null)
[15:08:18] (null)
[15:08:18] (null)
[15:08:18] (null)
[15:08:18] (null)
[15:08:18] (null)
[15:08:18] (null)
[15:08:18] Fraktion: 3
[15:08:18] (null)
[15:08:18] (null)
[15:08:18] (null)
[15:08:18] (null)
[15:08:18] (null)
[15:08:18] (null)
[15:08:18] (null)
[15:08:18] (null)
[15:08:18] (null)
[15:08:18] (null)
[15:08:18] Fraktion: 4
[15:08:18] (null)
[15:08:18] (null)
[15:08:18] (null)
[15:08:18] (null)
[15:08:18] (null)
[15:08:18] (null)
[15:08:18] (null)
[15:08:18] (null)
[15:08:18] (null)
[15:08:18] (null)
[15:08:18] Fraktion: 5
[15:08:18] (null)
[15:08:18] (null)
[15:08:18] (null)
[15:08:18] (null)
[15:08:18] (null)
[15:08:18] (null)
[15:08:18] (null)
[15:08:18] (null)
[15:08:18] (null)
[15:08:18] (null)
[15:08:18] Fraktion: 6
[15:08:18] (null)
[15:08:18] (null)
[15:08:18] (null)
[15:08:18] (null)
[15:08:18] (null)
[15:08:18] (null)
[15:08:18] (null)
[15:08:18] (null)
[15:08:18] (null)
[15:08:18] (null)
[15:08:18] Fraktion: 7
[15:08:18] (null)
[15:08:18] (null)
[15:08:18] (null)
[15:08:18] (null)
[15:08:18] (null)
[15:08:18] (null)
[15:08:18] (null)
[15:08:18] (null)
[15:08:18] (null)
[15:08:18] (null)
[15:08:18] Fraktion: 8
[15:08:18] (null)
[15:08:18] (null)
[15:08:18] (null)
[15:08:18] (null)
[15:08:18] (null)
[15:08:18] (null)
[15:08:18] (null)
[15:08:18] (null)
[15:08:18] (null)
[15:08:18] (null)
[15:08:18] Fraktion: 9
[15:08:18] (null)
[15:08:18] (null)
[15:08:18] (null)
[15:08:18] (null)
[15:08:18] (null)
[15:08:18] (null)
[15:08:18] (null)
[15:08:18] (null)
[15:08:18] (null)
[15:08:18] (null)
[15:08:18] Fraktion: 10
[15:08:18] (null)
[15:08:18] (null)
[15:08:18] (null)
[15:08:18] (null)
[15:08:18] (null)
[15:08:18] (null)
[15:08:18] (null)
[15:08:18] (null)
[15:08:18] (null)
[15:08:18] (null)
[15:08:18] Fraktion: 11
[15:08:18] (null)
[15:08:18] (null)
[15:08:18] (null)
[15:08:18] (null)
[15:08:18] (null)
[15:08:18] (null)
[15:08:18] (null)
[15:08:18] (null)
[15:08:18] (null)
[15:08:18] (null)
[15:08:18] Fraktion: 12
[15:08:18]

So sieht der Table aus, wenn ich den Server stoppe:
KlIck

//Edit Rechtschreibung
//Edit2 Mehr Informationen

Bitteschööön:
[21:48:37] <-| [MYSQL] Verbindung zur Datenbank wurde erfolgreich hergestellt!
[21:48:37] (null)
[21:48:37] Rank1
[21:48:37] (null)
[21:48:37] Rank2
[21:48:37] (null)
[21:48:37] Rank3
[21:48:37] (null)
[21:48:37] Rank4
[21:48:37] (null)
[21:48:37] Rank5
[21:48:37] (null)
[21:48:37] Rank6
[21:48:37] (null)
[21:48:37] Rank7
[21:48:37] (null)
[21:48:37] Rank8
[21:48:37] (null)
[21:48:37] Rank9
[21:48:37] (null)
[21:48:37] Rank10
[21:48:37]
----------------------------------

stock LoadKassen()
{
new i,data[80],string[15];
mysql_query("SELECT NULL FROM `factions`");
mysql_store_result();
while(mysql_retrieve_row())
{
mysql_fetch_field_row(data,"Geld"); TeamInfo[i+1][fKasse] = strval(data);
mysql_fetch_field_row(data,"ID"); TeamInfo[i+1][fID] = strval(data);

for(new f=0; f < 11; f++)
{
format(string,sizeof(string),"Rank%d",f+1);
mysql_fetch_field_row(data,string);
format(TeamInfo[i+1][fRank][f],124,"%s",data);
print(TeamInfo[i+1][fRank][f]);
print(string);
}
printf("Fraktion: %i",i);
i++;
}
mysql_free_result();
return 1;
}

Hey, ich müsste jetzt nur noch die Fraktionen erstellen, damit man nicht alles Manuell eintippen muss, kan mir da jemand helfen, das fehlende Fraktionen automatisch erstellt werden?
format(query, sizeof(query),"INSERT INTO `factions` (`ID`,`Geld`,`Gehalt1`,`Gehalt2`,`Gehalt3`,`Gehalt4`,`Gehalt5`,`Gehalt6`,`Gehalt7`,`Gehalt8`,`Gehalt9`,`Gehalt10`,`Skin1`,`Skin2`,`Skin3`,`Skin4`,`Skin5`,`Skin6`,`Skin7`,`Skin8`,`Skin9`,`Skin10`,`Rank1`,`Rank2`,`Rank3`,`Rank4`,`Rank5`,`Rank6`,`Rank7`,`Rank8`,`Rank9`,`Rank10`)");
format(query1, sizeof(query1),"VALUES ('%i','8000','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','RangName1','RangName2','RangName3','RangName4','RangName5','RangName6','RangName7','RangName8','RangName9','RangName10')",i);
format(query3, sizeof(query3),"%s%s",query,query1);
mysql_query(query3);

Slash
Ich habe deine Funktion eingebaut, musste jedoch feststellen das die Schleife nicht mehr erreicht wird.....
stock LoadKassen(id)
{
new i,data[80],string[80];
format(string,80,"SELECT * FROM `factions` WHERE ID='%d'",id);
print(string);
print("LoadKassen.....");
mysql_store_result();
if(mysql_num_rows())
{
print("......mysql did num row......");
if(!mysql_retrieve_row())return print("Error.....!");
if(mysql_retrieve_row())
{
mysql_retrieve_row();
print("Data 1 & 2......");
mysql_fetch_field_row(data,"Geld");
TeamInfo[id][fKasse] = strval(data);
mysql_fetch_field_row(data,"ID");
TeamInfo[id][fID] = strval(data);
for(new f=1; f < 11; f++)
{
format(string,sizeof(string),"Rank%d",f);
mysql_fetch_field_row(data,string);
format(TeamInfo[id][fRank][f],124,"%s",data);
print(TeamInfo[id][fRank][f]);
print(string);
print("Loop......");
}
printf("Fraktion: %i",id);
i++;
}
}
print("......LoadedKassen");
mysql_free_result();
return 1;
}
[15:20:27] <-| [MYSQL] Verbindung zur Datenbank wurde erfolgreich hergestellt!
[15:20:27] SELECT * FROM `factions` WHERE ID='1'
[15:20:27] LoadKassen.....
[15:20:27] ......mysql did num row......
[15:20:27] Error.....!
[15:20:27] SELECT * FROM `factions` WHERE ID='2'
[15:20:27] LoadKassen.....
[15:20:27] ......mysql did num row......
[15:20:27] Error.....!
[15:20:27] SELECT * FROM `factions` WHERE ID='3'
[15:20:27] LoadKassen.....
[15:20:27] ......mysql did num row......
[15:20:27] Error.....!
[15:20:27] SELECT * FROM `factions` WHERE ID='4'
[15:20:27] LoadKassen.....
[15:20:27] ......mysql did num row......
[15:20:27] Error.....!
[15:20:27] SELECT * FROM `factions` WHERE ID='5'
[15:20:27] LoadKassen.....
[15:20:27] ......mysql did num row......
[15:20:27] Error.....!
[15:20:27] SELECT * FROM `factions` WHERE ID='6'
[15:20:27] LoadKassen.....
[15:20:27] ......mysql did num row......
[15:20:27] Error.....!
[15:20:27] SELECT * FROM `factions` WHERE ID='7'
[15:20:27] LoadKassen.....
[15:20:27] ......mysql did num row......
[15:20:27] Error.....!
[15:20:27] SELECT * FROM `factions` WHERE ID='8'
[15:20:27] LoadKassen.....
[15:20:27] ......mysql did num row......
[15:20:27] Error.....!
[15:20:27] SELECT * FROM `factions` WHERE ID='9'
[15:20:27] LoadKassen.....
[15:20:27] ......mysql did num row......
[15:20:27] Error.....!
[15:20:27] SELECT * FROM `factions` WHERE ID='10'
[15:20:27] LoadKassen.....
[15:20:27] ......mysql did num row......
[15:20:27] Error.....!
[15:20:27] SELECT * FROM `factions` WHERE ID='11'
[15:20:27] LoadKassen.....
[15:20:27] ......mysql did num row......
[15:20:27] Error.....!
[15:20:27] SELECT * FROM `factions` WHERE ID='12'
[15:20:27] LoadKassen.....
[15:20:27] ......mysql did num row......
[15:20:27] Error.....!
[15:20:27] SELECT * FROM `factions` WHERE ID='13'
[15:20:27] LoadKassen.....
[15:20:27] ......mysql did num row......
[15:20:27] Error.....!
[15:20:27]
----------------------------------

//Edit 1&2 Code eingefügt...
//Edit 4 Code verändert

Darf ich dich zu ner Runde TeamViewer auf nem TS einladen?

for(new f=1; f < 11; f++)
{
format(string,sizeof(string),"Rank%d",f);
mysql_fetch_field_row(data,string);
format(TeamInfo[id][fRank][f],124,"%s",data);
print(TeamInfo[id][fRank][f]);
print(string);
print(TeamInfo[1][fRank][2]);
print(TeamInfo[2][fRank][2]);
print(TeamInfo[12][fRank][2]);
}

[15:44:39] <-| [MYSQL] Verbindung zur Datenbank wurde erfolgreich hergestellt!
[15:44:39] RangName1
[15:44:39] Rank1
[15:44:39] angName1
[15:44:39] (null)
[15:44:39] (null)
[15:44:39] RangName2
[15:44:39] Rank2
[15:44:39] RangName2
[15:44:39] (null)
[15:44:39] (null)
[15:44:39] RangName3
[15:44:39] Rank3
[15:44:39] RRangName3
[15:44:39] (null)
[15:44:39] (null)
[15:44:39] RangName4
[15:44:39] Rank4
[15:44:39] RRRangName4
[15:44:39] (null)
[15:44:39] (null)
[15:44:39] RangName5
[15:44:39] Rank5
[15:44:39] RRRRangName5
[15:44:39] (null)
[15:44:39] (null)
[15:44:39] RangName6
[15:44:39] Rank6
[15:44:39] RRRRRangName6
[15:44:39] (null)
[15:44:39] (null)
[15:44:39] RangName7
[15:44:39] Rank7
[15:44:39] RRRRRRangName7
[15:44:39] (null)
[15:44:39] (null)
[15:44:39] RangName8
[15:44:39] Rank8
[15:44:39] RRRRRRRangName8
[15:44:39] (null)
[15:44:39] (null)
[15:44:39] RangName9
[15:44:39] Rank9
[15:44:39] RRRRRRRRangName9
[15:44:39] (null)
[15:44:39] (null)
[15:44:39]