SA-MP Forums Archive
MySQL Help - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: MySQL Help (/showthread.php?tid=381324)


MySQL Help - ScriptWriter - 29.09.2012

Hello, people.

I have one problem with BlueG R7 mysql plugin, don't load player data.

Код:
new Query[250];
mysql_format(SQLConnect, Query, "SELECT * FROM `players` WHERE `Vardas` = '%s' AND `Slaptazodis` = '%s'", PlayerName(playerid), inputtext);
mysql_function_query(SQLConnect, Query, true, "TikrinamPass", "d", playerid);
Callback

Код:
new pField[100];
PlayerInfo[playerid][pStatus] = 1;

cache_get_row(0, 4, pField); PlayerInfo[playerid][pIP] = strval(pField);
cache_get_row(0, 5, pField); PlayerInfo[playerid][pPinigai] = strval(pField);
cache_get_row(0, 6, pField); PlayerInfo[playerid][pEXP] = strval(pField);
cache_get_row(0, 7, pField); PlayerInfo[playerid][pLevel] = strval(pField);
cache_get_row(0, 8, pField); PlayerInfo[playerid][pSkin] = strval(pField);
cache_get_row(0, 9, pField); PlayerInfo[playerid][pLytis] = strval(pField);
cache_get_row(0, 10, pField); PlayerInfo[playerid][pAmzius] = strval(pField);
cache_get_row(0, 11, pField); PlayerInfo[playerid][pPos][0] = floatstr(pField);
cache_get_row(0, 12, pField); PlayerInfo[playerid][pPos][1] = floatstr(pField);
cache_get_row(0, 13, pField); PlayerInfo[playerid][pPos][2] = floatstr(pField);
cache_get_row(0, 14, pField); PlayerInfo[playerid][pPos][3] = floatstr(pField);
cache_get_row(0, 15, pField); PlayerInfo[playerid][pInterjeras] = strval(pField);
cache_get_row(0, 16, pField); PlayerInfo[playerid][pLastLogin] = strval(pField);
Please tell me what wrong with this codes?
Thanks.

P.S. If need more codes just write post in this topic.

Re: MySQL Help - ScriptWriter - 29.09.2012

Bump