[vection]

pawn Код:

format(Query, sizeof(Query), "INSERT INTO `playerinfo` (`user`, `password`, `level`, `admin`, `money`, bank) VALUES ('%s', '%s', 0, 0, 2000, 12000)", Pname, inputtext);
            mysql_query(Query); //Queries

i got this line.
in MYSQL its a long line with 200 fields.
While player register its ok, because most of the fields getting "0". the problem starts when i want to load this.
i load it with sscanf:

pawn Код:

sscanf(line, "p|ssdddds", data[0], data[1], data2[0], data2[1], data2[2], data2[3], data[2]);

Well, because i got 200 fields i cant load all of them because its error me "Too long ..."
how i can load them in other way?

[Vince]

Try the sscanf plugin and use the enum function.

pawn Код:

sscanf(line, "e<p<|>ssddds>", PlayerInfo[playerid]);

That's it. Everything will be automatically assigned to the enum.
It does require every field in MySQL to be in the same order as the enum, though.

[vection]

can you show me one line with enum? i dont get it ..

[vection]

Any solution ?

[vection]

upppppppp

[vection]

pawn Код:

new line[750];
new data[3][50]; //The data strings
                   new data2[204]; //The data variables
                   sscanf(line, "p|ssddddddddddddsddddddddddddddddddddddddddddddddddddddffdddddddddddddddddddddddddddddddddddddddddsssssdffffdffffdffffddffffffffdfffffffffffffffdddsssssffffdddddddddddddddddddddddddddddddddddddddddddddddddds"); //Splits the line with sscanf
                   format(line, 32, PlayerInfo[playerid][pKey], data[1]);
                   format(line, 32, PlayerInfo[playerid][pLevel], data2[0]);
                   format(line, 32, PlayerInfo[playerid][pAdmin], data2[1]);
                   format(line, 32, PlayerInfo[playerid][pDonateRank], data2[2]);
                   format(line, 32, PlayerInfo[playerid][pConnectTime], data2[3]);
                   format(line, 32, PlayerInfo[playerid][pSex], data2[4]);
                   format(line, 32, PlayerInfo[playerid][pAge], data2[5]);
                   format(line, 32, PlayerInfo[playerid][pCK], data2[6]);
                   format(line, 32, PlayerInfo[playerid][pMuted], data2[7]);
                   format(line, 32, PlayerInfo[playerid][pExp], data2[8]);
                   format(line, 32, PlayerInfo[playerid][pCash], data2[9]);
                   format(line, 32, PlayerInfo[playerid][pBan], data2[10]);
                   format(line, 32, PlayerInfo[playerid][pReason], data2[11]);
                   format(line, 32, PlayerInfo[playerid][pAccount], data2[12]);

Tried to do somthing like that.. still doesnt work well..