SA-MP Forums Archive
Mysql Conversion - 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 Conversion (/showthread.php?tid=484531)


Mysql Conversion - Walkie - 31.12.2013

I don't know very good mysql ... and i don't know how to convert this mysql

pawn Код:
PlayerInfo[playerid][pMeleeWep] = cache_get_row_int(0, 43);
    PlayerInfo[playerid][pPerm1] = cache_get_row_int(0, 44);
    PlayerInfo[playerid][pPerm2] = cache_get_row_int(0, 45);
    PlayerInfo[playerid][pAmmo1] = cache_get_row_int(0, 46);
    PlayerInfo[playerid][pAmmo2] = cache_get_row_int(0, 47);

to SA-MP MySQL plugin R5 G-Stylezzz plugin..

an example
pawn Код:
mysql_fetch_field_row(bb,"forumname");
            format(CharacterInfo[playerid][ii][cFname],64,"%s",bb);


Re: Mysql Conversion - Walkie - 31.12.2013

pawn Код:
mysql_fetch_field_row(bb,"melee");
            format(CharacterInfo[playerid][ii][cMeleeWep],64,"%d",bb);
            mysql_fetch_field_row(bb,"wep1");
            format(CharacterInfo[playerid][ii][cPerm1],64,"%d",bb);
            mysql_fetch_field_row(bb,"wep2");
            format(CharacterInfo[playerid][ii][cPerm2],64,"%d",bb);
            mysql_fetch_field_row(bb,"ammo1");
            format(CharacterInfo[playerid][ii][cAmmo1],64,"%d",bb);
            mysql_fetch_field_row(bb,"ammo2");
            format(CharacterInfo[playerid][ii][cAmmo2],64,"%d",bb);

i tried this.. it's ok ? how i maked?

Re: Mysql Conversion - kN1GhT - 31.12.2013

can u tell me what exactly are you trying to do?

Re: Mysql Conversion - Walkie - 31.12.2013

It's 2 different mysql plugins , and i want to covert from MySQL plugin R23 to SA-MP MySQL plugin R5 G-Stylezzz