MySQL Query result is different than printed
#1

So, I have a table value Members which is 1. But when I load the row which includes the members value, it is 0.

Enums
pawn Код:
enum faction
{
    SQLID,
    Name[64],
    Type,
    Rank[32],
    Rank2[32],
    Rank3[32],
    Rank4[32],
    Rank5[32],
    Rank6[32],
    Rank7[32],
    Rank8[32],
    Rank9[32],
    Rank10[32],
    Rank11[32],
    Rank12[32],
    Rank13[32],
    Float:Intx,
    Float:Inty,
    Float:Intz,
    Float:Inta,
    Interior,
    World,
    Members[MAX_PLAYERS]

};
This is the query
pawn Код:
if(mysql_fetch_row_format(query,"|"))
        {
            sscanf(query, "p<|>e<is[64]ds[32]s[32]s[32]s[32]s[32]s[32]s[32]s[32]s[32]s[32]s[32]s[32]s[32]fffiiid>",Factions[id]);
This is what it returns from the tables
Код:
 CMySQLHandler::FetchRow() - Return: 1|Mafia||1st - Lowest Rank|2nd Rank|3rd Rank|4th Rank|5th Rank|6th Rank|7th Rank|8th Rank|9th Rank|10th Rank|11th Rank|12th Rank|13th - Highest Rank|0|0|0|0|69|23|1
This is what the
factions[id][Members], World and Interior return

While the actual values should be Int: 69 World: 23 And Members: 1

Код:
[21:14:50] > 1 factions have been loaded from the database.
[21:14:50] > 0 Members in faction ID: 1
[21:14:50] > 0 Int in faction ID: 1
[21:14:50] > 0 World in faction ID: 1
Reply
#2

Aand this can be deleted, didn't notice that I had the "Type" as an Varchar in the Database
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)