MYSQL loading problem
#1

Hi everyone,

I'm pretty new with loading massive MYSQL things, and am stuck on my Factions loading part...
here is the function:
pawn Код:
forward LoadFactions();
public LoadFactions()
{

    new Query[300];
    for(new i = 0; i < MAX_FACTIONS; i++)
    {
    format(Query, sizeof(Query), "SELECT * FROM `Factions` WHERE `FactionID` = '%s' ", FactionCount);
    mysql_query(Query);
    mysql_store_result();
    mysql_fetch_row_format(Query);
    sscanf(Query, "e<p<|>is[128]s[128]dfff>", FInfo[i]);
    mysql_free_result();
    FactionCount++;
    new string[128];
    format(string,sizeof(string),"Faction Name: %s \nOwned by: %s\nFaction Value: %d",FInfo[i][Name],FInfo[i][Owner],FInfo[i][Value]);
    CreateDynamicPickup(1239,1,FInfo[i][LocationX],FInfo[i][LocationY],FInfo[i][LocationZ],-1,-1,-1,100.0);
    CreateDynamic3DTextLabel(string,COLOR_RED,FInfo[i][LocationX],FInfo[i][LocationY],FInfo[i][LocationZ],100.0);
   
    }
}
I thought it was right, but apperently not..
Reply


Messages In This Thread
MYSQL loading problem - by Jstylezzz - 26.06.2012, 17:09
Re: MYSQL loading problem - by Vince - 27.06.2012, 10:49
Re: MYSQL loading problem - by Jstylezzz - 27.06.2012, 10:51
Re: MYSQL loading problem - by AndreT - 27.06.2012, 13:29
Re: MYSQL loading problem - by Jstylezzz - 27.06.2012, 13:54
Re: MYSQL loading problem - by Jstylezzz - 28.06.2012, 19:04
Re: MYSQL loading problem - by Jstylezzz - 01.07.2012, 15:30
Re: MYSQL loading problem - by MadeMan - 01.07.2012, 15:47
Re: MYSQL loading problem - by Jstylezzz - 01.07.2012, 15:57
Re: MYSQL loading problem - by Jstylezzz - 03.07.2012, 08:40

Forum Jump:


Users browsing this thread: 2 Guest(s)