Loading Factions MySQL, Assistance please.
#1

Quote:

stock LoadFactions()
{
new QueryString[ 128 ];
mysql_query( "SELECT `FactionName`, `FactionRank1`,`FactionRank2`, `FactionRank3`, `FactionRank4`, `FactionRank5`, `FactionRank6`, `FactionSkin1`, `FactionSkin2`, `FactionSkin3`, `FactionSkin4`, `FactionSkin5`, `FactionSkin6`, `FactionSkin7`, `FactionSkin8`, `FactionSkin9`, `FactionSkin10`, `FactionEntX`, `FactionEntY`, `FactionEntZ`, `FactionIntX`, `FactionIntY`, `FactionIntZ`, `FactionInt`, `FactionID`, `FactionBank` FROM `Factions`");
mysql_store_result();

if( mysql_num_rows() >= 1 )
{
{
mysql_fetch_field( "FactionName", QueryString );
FactionName[FactionSQLID] = strval( QueryString );

mysql_fetch_field( "FactionRank1", QueryString );
FactionRank1[FactionSQLID] = strval( QueryString );

mysql_fetch_field( "FactionRank2", QueryString );
FactionRank2[FactionSQLID] = strval( QueryString );

mysql_fetch_field( "FactionRank3", QueryString );
FactionRank3[FactionSQLID] = strval( QueryString );

mysql_fetch_field( "FactionRank4", QueryString );
FactionRank4[FactionSQLID] = strval( QueryString );

mysql_fetch_field( "FactionRank5", QueryString );
FactionRank5[FactionSQLID] = strval( QueryString );

mysql_fetch_field( "FactionRank6", QueryString );
FactionRank6[FactionSQLID] = strval( QueryString );

mysql_fetch_field( "FactionRank7", QueryString );
FactionRank7[FactionSQLID] = strval( QueryString );

mysql_fetch_field( "FactionSkin1", QueryString );
FactionSkin1[FactionSQLID] = strval( QueryString );

mysql_fetch_field( "FactionSkin2", QueryString );
FactionSkin2[FactionSQLID] = strval( QueryString );

mysql_fetch_field( "FactionSkin3", QueryString );
FactionSkin3[FactionSQLID] = strval( QueryString );

mysql_fetch_field( "FactionSkin4", QueryString );
FactionSkin4[FactionSQLID] = strval( QueryString );

mysql_fetch_field( "FactionSkin5", QueryString );
FactionSkin5[FactionSQLID] = strval( QueryString );

mysql_fetch_field( "FactionSkin6", QueryString );
FactionSkin6[FactionSQLID] = strval( QueryString );

mysql_fetch_field( "FactionSkin7", QueryString );
FactionSkin7[FactionSQLID] = strval( QueryString );

mysql_fetch_field( "FactionSkin8", QueryString );
FactionSkin8[FactionSQLID] = strval( QueryString );

mysql_fetch_field( "FactionSkin9", QueryString );
FactionSkin9[FactionSQLID] = strval( QueryString );

mysql_fetch_field( "FactionSkin10", QueryString );
FactionSkin10[FactionSQLID] = strval( QueryString );

mysql_fetch_field( "FactionEntX", QueryString );
FactionEntX[FactionSQLID] = floatstr( QueryString );

mysql_fetch_field( "FactionEntY", QueryString );
FactionEntY[FactionSQLID] = floatstr( QueryString );

mysql_fetch_field( "FactionEntZ", QueryString );
FactionEntZ[FactionSQLID] = floatstr( QueryString );

mysql_fetch_field( "FactionIntX", QueryString );
FactionIntX[FactionSQLID] = floatstr( QueryString );

mysql_fetch_field( "FactionIntY", QueryString );
FactionIntY[FactionSQLID] = floatstr( QueryString );

mysql_fetch_field( "FactionIntZ", QueryString );
FactionIntZ[FactionSQLID] = floatstr( QueryString );

mysql_fetch_field( "SpawnX", QueryString );
SpawnX[FactionSQLID] = floatstr( QueryString );

mysql_fetch_field( "SpawnY", QueryString );
SpawnY[FactionSQLID] = floatstr( QueryString );

mysql_fetch_field( "SpawnZ", QueryString );
SpawnZ[FactionSQLID] = floatstr( QueryString );

mysql_fetch_field( "FactionInt", QueryString );
FactionInt[FactionSQLID] = strval( QueryString );

mysql_fetch_field( "FactionID", QueryString );
FactionID[FactionSQLID] = strval( QueryString );

mysql_fetch_field( "FactionBank", QueryString );
FactionBank[FactionSQLID] = strval( QueryString );
mysql_query( QueryString );
}
}
mysql_free_result();

return 1;
}

This is the part of the code where I actually load it.

Quote:

new FactionSQLID[MAX_FACTIONS];
new FactionName[MAX_FACTIONS];
new FactionRank1[MAX_FACTIONS];
new FactionRank2[MAX_FACTIONS];
new FactionRank3[MAX_FACTIONS];
new FactionRank4[MAX_FACTIONS];
new FactionRank5[MAX_FACTIONS];
new FactionRank6[MAX_FACTIONS];
new FactionRank7[MAX_FACTIONS];
new FactionSkin1[MAX_FACTIONS];
new FactionSkin2[MAX_FACTIONS];
new FactionSkin3[MAX_FACTIONS];
new FactionSkin4[MAX_FACTIONS];
new FactionSkin5[MAX_FACTIONS];
new FactionSkin6[MAX_FACTIONS];
new FactionSkin7[MAX_FACTIONS];
new FactionSkin8[MAX_FACTIONS];
new FactionSkin9[MAX_FACTIONS];
new FactionSkin10[MAX_FACTIONS];
new Float:FactionIntX[MAX_FACTIONS];
new Float:FactionIntY[MAX_FACTIONS];
new Float:FactionIntZ[MAX_FACTIONS];
new Float:FactionEntX[MAX_FACTIONS];
new Float:FactionEntY[MAX_FACTIONS];
new Float:FactionEntZ[MAX_FACTIONS];

Dont ask why I dont use Enum, It makes this MUCH easier to understand.

Quote:

error 033: array must be indexed (variable "FactionSQLID")
C:\Users\berni\Desktop\Zombie Mode\gamemodes\rp.pwn(887) : error 035: argument type mismatch (argument 1)
C:\Users\berni\Desktop\Zombie Mode\gamemodes\rp.pwn(88 : error 033: array must be indexed (variable "FactionSQLID")
C:\Users\berni\Desktop\Zombie Mode\gamemodes\rp.pwn(890) : error 035: argument type mismatch (argument 1)
C:\Users\berni\Desktop\Zombie Mode\gamemodes\rp.pwn(891) : error 033: array must be indexed (variable "FactionSQLID")
C:\Users\berni\Desktop\Zombie Mode\gamemodes\rp.pwn(893) : error 035: argument type mismatch (argument 1)
C:\Users\berni\Desktop\Zombie Mode\gamemodes\rp.pwn(894) : error 033: array must be indexed (variable "FactionSQLID")
C:\Users\berni\Desktop\Zombie Mode\gamemodes\rp.pwn(896) : error 035: argument type mismatch (argument 1)
C:\Users\berni\Desktop\Zombie Mode\gamemodes\rp.pwn(897) : error 033: array must be indexed (variable "FactionSQLID")
C:\Users\berni\Desktop\Zombie Mode\gamemodes\rp.pwn(899) : error 035: argument type mismatch (argument 1)
C:\Users\berni\Desktop\Zombie Mode\gamemodes\rp.pwn(900) : error 033: array must be indexed (variable "FactionSQLID")
C:\Users\berni\Desktop\Zombie Mode\gamemodes\rp.pwn(902) : error 035: argument type mismatch (argument 1)
C:\Users\berni\Desktop\Zombie Mode\gamemodes\rp.pwn(903) : error 033: array must be indexed (variable "FactionSQLID")
C:\Users\berni\Desktop\Zombie Mode\gamemodes\rp.pwn(905) : error 035: argument type mismatch (argument 1)
C:\Users\berni\Desktop\Zombie Mode\gamemodes\rp.pwn(906) : error 033: array must be indexed (variable "FactionSQLID")
C:\Users\berni\Desktop\Zombie Mode\gamemodes\rp.pwn(90 : error 035: argument type mismatch (argument 1)
C:\Users\berni\Desktop\Zombie Mode\gamemodes\rp.pwn(909) : error 033: array must be indexed (variable "FactionSQLID")
C:\Users\berni\Desktop\Zombie Mode\gamemodes\rp.pwn(911) : error 035: argument type mismatch (argument 1)
C:\Users\berni\Desktop\Zombie Mode\gamemodes\rp.pwn(912) : error 033: array must be indexed (variable "FactionSQLID")
C:\Users\berni\Desktop\Zombie Mode\gamemodes\rp.pwn(914) : error 035: argument type mismatch (argument 1)
C:\Users\berni\Desktop\Zombie Mode\gamemodes\rp.pwn(915) : error 033: array must be indexed (variable "FactionSQLID")
C:\Users\berni\Desktop\Zombie Mode\gamemodes\rp.pwn(917) : error 035: argument type mismatch (argument 1)
C:\Users\berni\Desktop\Zombie Mode\gamemodes\rp.pwn(91 : error 033: array must be indexed (variable "FactionSQLID")
C:\Users\berni\Desktop\Zombie Mode\gamemodes\rp.pwn(920) : error 035: argument type mismatch (argument 1)
C:\Users\berni\Desktop\Zombie Mode\gamemodes\rp.pwn(921) : error 033: array must be indexed (variable "FactionSQLID")

I cannot figure out what this means, if someone could explain it clearly, I would be much obliged, and yes, I'm scripting from scratch.
Reply


Messages In This Thread
Loading Factions MySQL, Assistance please. - by Dokins - 03.09.2011, 19:39
Re: Loading Factions MySQL, Assistance please. - by JaTochNietDan - 03.09.2011, 19:55
Re: Loading Factions MySQL, Assistance please. - by Dokins - 03.09.2011, 19:58
Re: Loading Factions MySQL, Assistance please. - by JaTochNietDan - 03.09.2011, 20:08
[No subject] - by Dokins - 09.09.2011, 16:04
Re: Loading Factions MySQL, Assistance please. - by Voldemort - 09.09.2011, 20:57

Forum Jump:


Users browsing this thread: 1 Guest(s)