[Plugin] [REL] MySQL Plugin (Now on github!) - 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: Plugin Development (https://sampforum.blast.hk/forumdisplay.php?fid=18)
+--- Thread: [Plugin] [REL] MySQL Plugin (Now on github!) (/showthread.php?tid=56564)
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Plugin Development (https://sampforum.blast.hk/forumdisplay.php?fid=18)
+--- Thread: [Plugin] [REL] MySQL Plugin (Now on github!) (/showthread.php?tid=56564)
Pages:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
Re: [REL] MySQL Plugin R5 (04/09/10) - russ0 - 02.07.2011
Been trying to use this plugin with the CWRP (the base plugin doesn't works at linux / is bugged) gamemode but the login bugs completely... This is my code, it doesn't even finishs, the server keeps running but the player just 'frozes', even though some sendclientmessage (example: you are not logged etc) will still be sent to the user after some time.
pawn Код:
stock loginPlayer(playerid, const senha[50])
{
new field[120][1024];
new query[256], pname[MAX_PLAYER_NAME];
GetPlayerName(playerid, pname, MAX_PLAYER_NAME);
format(query, sizeof(query), "SELECT * FROM players WHERE Name = '%s'", pname);
mysql_query(query);
mysql_store_result();
if(mysql_fetch_row(data))
{
splith(data, field, '|');
PlayerInfo[playerid][pLevel] = strval(field[3]);
PlayerInfo[playerid][pAdmin] = strval(field[4]);
PlayerInfo[playerid][pDonateRank] = strval(field[5]);
PlayerInfo[playerid][gPupgrade] = strval(field[6]);
PlayerInfo[playerid][pConnectTime] = strval(field[7]);
PlayerInfo[playerid][pReg] = strval(field[8]);
PlayerInfo[playerid][pSex] = strval(field[9]);
PlayerInfo[playerid][pAge] = strval(field[10]);
PlayerInfo[playerid][pOrigin] = strval(field[11]);
PlayerInfo[playerid][pCK] = strval(field[12]);
PlayerInfo[playerid][pMuted] = strval(field[13]);
PlayerInfo[playerid][pExp] = strval(field[14]);
PlayerInfo[playerid][pCash] = strval(field[15]);
PlayerInfo[playerid][pAccount] = strval(field[16]);
PlayerInfo[playerid][pCrimes] = strval(field[17]);
PlayerInfo[playerid][pKills] = strval(field[18]);
PlayerInfo[playerid][pDeaths] = strval(field[19]);
PlayerInfo[playerid][pArrested] = strval(field[20]);
PlayerInfo[playerid][pWantedDeaths] = strval(field[21]);
PlayerInfo[playerid][pPhoneBook] = strval(field[22]);
PlayerInfo[playerid][pLottoNr] = strval(field[23]);
PlayerInfo[playerid][pFishes] = strval(field[24]);
PlayerInfo[playerid][pBiggestFish] = strval(field[25]);
PlayerInfo[playerid][pJob] = strval(field[26]);
PlayerInfo[playerid][pPayCheck] = strval(field[27]);
PlayerInfo[playerid][pHeadValue] = strval(field[28]);
PlayerInfo[playerid][pJailed] = strval(field[29]);
PlayerInfo[playerid][pJailTime] = strval(field[30]);
PlayerInfo[playerid][pMats] = strval(field[31]);
PlayerInfo[playerid][pDrugs] = strval(field[32]);
PlayerInfo[playerid][pLeader] = strval(field[33]);
PlayerInfo[playerid][pMember] = strval(field[34]);
PlayerInfo[playerid][pFMember] = strval(field[35]);
PlayerInfo[playerid][pRank] = strval(field[36]);
PlayerInfo[playerid][pChar] = strval(field[37]);
PlayerInfo[playerid][pContractTime] = strval(field[38]);
PlayerInfo[playerid][pDetSkill] = strval(field[39]);
PlayerInfo[playerid][pSexSkill] = strval(field[40]);
PlayerInfo[playerid][pBoxSkill] = strval(field[41]);
PlayerInfo[playerid][pLawSkill] = strval(field[42]);
PlayerInfo[playerid][pMechSkill] = strval(field[43]);
PlayerInfo[playerid][pJackSkill] = strval(field[44]);
PlayerInfo[playerid][pCarSkill] = strval(field[45]);
PlayerInfo[playerid][pNewsSkill] = strval(field[46]);
PlayerInfo[playerid][pDrugsSkill] = strval(field[47]);
PlayerInfo[playerid][pCookSkill] = strval(field[48]);
PlayerInfo[playerid][pFishSkill] = strval(field[49]);
PlayerInfo[playerid][pSHealth] = floatstr(field[50]);
PlayerInfo[playerid][pHealth] = floatstr(field[51]);
PlayerInfo[playerid][pInt] = strval(field[52]);
PlayerInfo[playerid][pLocal] = strval(field[53]);
PlayerInfo[playerid][pTeam] = strval(field[54]);
PlayerInfo[playerid][pModel] = strval(field[55]);
PlayerInfo[playerid][pPnumber] = strval(field[56]);
PlayerInfo[playerid][pPhousekey] = strval(field[57]);
PlayerInfo[playerid][pPcarkey] = strval(field[58]);
PlayerInfo[playerid][pPapptkey] = strval(field[59]);
PlayerInfo[playerid][pPbiskey] = strval(field[60]);
PlayerInfo[playerid][pPos_x] = floatstr(field[61]);
PlayerInfo[playerid][pPos_y] = floatstr(field[62]);
PlayerInfo[playerid][pPos_z] = floatstr(field[63]);
PlayerInfo[playerid][pCarLic] = strval(field[64]);
PlayerInfo[playerid][pFlyLic] = strval(field[65]);
PlayerInfo[playerid][pBoatLic] = strval(field[66]);
PlayerInfo[playerid][pFishLic] = strval(field[67]);
PlayerInfo[playerid][pGunLic] = strval(field[68]);
PlayerInfo[playerid][pGun1] = strval(field[69]);
PlayerInfo[playerid][pGun2] = strval(field[70]);
PlayerInfo[playerid][pGun3] = strval(field[71]);
PlayerInfo[playerid][pGun4] = strval(field[72]);
PlayerInfo[playerid][pAmmo1] = strval(field[73]);
PlayerInfo[playerid][pAmmo2] = strval(field[74]);
PlayerInfo[playerid][pAmmo3] = strval(field[75]);
PlayerInfo[playerid][pAmmo4] = strval(field[76]);
PlayerInfo[playerid][pCarTime] = strval(field[77]);
PlayerInfo[playerid][pPayDay] = strval(field[78]);
PlayerInfo[playerid][pPayDayHad] = strval(field[79]);
PlayerInfo[playerid][pCDPlayer] = strval(field[80]);
PlayerInfo[playerid][pWins] = strval(field[81]);
PlayerInfo[playerid][pLoses] = strval(field[82]);
PlayerInfo[playerid][pAlcoholPerk] = strval(field[83]);
PlayerInfo[playerid][pDrugPerk] = strval(field[84]);
PlayerInfo[playerid][pMiserPerk] = strval(field[85]);
PlayerInfo[playerid][pPainPerk] = strval(field[86]);
PlayerInfo[playerid][pTraderPerk] = strval(field[87]);
PlayerInfo[playerid][pTut] = strval(field[88]);
PlayerInfo[playerid][pMissionNr] = strval(field[89]);
PlayerInfo[playerid][pWarns] = strval(field[90]);
PlayerInfo[playerid][pAdjustable] = strval(field[91]);
PlayerInfo[playerid][pFuel] = strval(field[92]);
PlayerInfo[playerid][pMarried] = strval(field[93]); // QUATRO \/
PlayerInfo[playerid][pMarriedTo] = strmid(PlayerInfo[playerid][pMarriedTo], field[94], 0, strlen(field[94])-1, 255);
PlayerInfo[playerid][pLinked] = strval(field[96]); // 96
PlayerInfo[playerid][pDeagle] = strval(field[97]);
PlayerInfo[playerid][pShotgun] = strval(field[98]);
PlayerInfo[playerid][pRifle] = strval(field[99]);
PlayerInfo[playerid][pSDPistol] = strval(field[100]);
PlayerInfo[playerid][pMP5] = strval(field[101]);
PlayerInfo[playerid][pM4] = strval(field[102]);
PlayerInfo[playerid][pAK47] = strval(field[103]);
format(PlayerInfo[playerid][pStartIP], 16, "%s", field[104]);
format(PlayerInfo[playerid][pEndIP], 16, "%s", field[105]);
PlayerInfo[playerid][pLocker] = strval(field[106]);
PlayerInfo[playerid][pRadioFrequency] = strval(field[107]);
PlayerInfo[playerid][pRadio] = strval(field[108]);
PlayerInfo[playerid][pPecArm] = strval(field[109]);
PlayerInfo[playerid][pMesa] = strval(field[110]);
PlayerInfo[playerid][pLuvas] = strval(field[111]);
drugInfo[playerid][dgCocaina] = strval(field[112]);
drugInfo[playerid][dgMaconha] = strval(field[113]);
drugInfo[playerid][dgOpio] = strval(field[114]);
drugInfo[playerid][dgCrack] = strval(field[115]);
drugInfo[playerid][dgMeth] = strval(field[116]);
drugInfo[playerid][dgHeroina] = strval(field[117]);
drugInfo[playerid][dgHaxixe] = strval(field[118]);
PlayerInfo[playerid][pPcarkey2] = strval(field[119]);
mysql_free_result();
PlayerInfo[playerid][pAdjustable] = 0;
ResetPlayerCash(playerid);
GivePlayerCash(playerid,PlayerInfo[playerid][pCash]);
if(PlayerInfo[playerid][pReg] == 0)
{
PlayerInfo[playerid][pLevel] = 1;
PlayerInfo[playerid][pSHealth] = 0.0;
PlayerInfo[playerid][pHealth] = 100.0;
PlayerInfo[playerid][pPos_x] = NOOB_X;
PlayerInfo[playerid][pPos_y] = NOOB_Y;
PlayerInfo[playerid][pPos_z] = NOOB_Z;
PlayerInfo[playerid][pInt] = 0;
PlayerInfo[playerid][pLocal] = 1;
PlayerInfo[playerid][pTeam] = 3;
PlayerInfo[playerid][pModel] = 135;
new randphone = 10000000 + random(89999999);
PlayerInfo[playerid][pNumero] = randphone;
PlayerInfo[playerid][pPhousekey] = 255;
PlayerInfo[playerid][pPcarkey] = 999;
PlayerInfo[playerid][pPcarkey2] = 999;
PlayerInfo[playerid][pPcarkey3] = 999;
PlayerInfo[playerid][pPapptkey] = 255;
PlayerInfo[playerid][pPbiskey] = 255;
PlayerInfo[playerid][pAccount] = 0;
PlayerInfo[playerid][pReg] = 1;
GivePlayerCash(playerid, 500);
}
if(PlayerInfo[playerid][pLevel] == -999) return Ban(playerid);
gPlayerLogged[playerid] = 1;
SpawnPlayer(playerid);
if(PlayerInfo[playerid][pDonateRank]==0)
{
PlayerInfo[playerid][pMascara]=0;
}
SetPlayerSpawn(playerid);
DateProp(playerid);
load_peixes(playerid);
load_celular(playerid);
LoadNewProfile(playerid);
SetPlayerSkin(playerid, PlayerInfo[playerid][pSkin1]);
SetPVarInt(playerid, "logouAgora", 1);
print("Erro? carregardados4(playerid) 02");
format(data, 3, " ");
SetTimerEx("LoadArmas", 3000, false, "i", playerid);
ClearChatbox(playerid, 10);
return 1;
}
}
Re: [REL] MySQL Plugin R5 (04/09/10) - Toni - 02.07.2011
@russ0, you should consider using sscanf as a data parser. It has a built in delimiter so you don't need split. And the Linux build is buggy iirc.
Re: [REL] MySQL Plugin R5 (04/09/10) - russ0 - 02.07.2011
Can you give me an example on how to use the sscanf on my situation? I've seen it before but I've never used it, but I'll be testing some ways to do it. I'm not using the linux build now though.
Re: [REL] MySQL Plugin R5 (04/09/10) - Ivan_Pantovic - 02.07.2011
Works perfect!
Just one question:
Can i enable logging for errors only?
Re: AW: [REL] MySQL Plugin R5 (04/09/10) - JernejL - 03.07.2011
Quote:
|
Originally Posted by Blowfish
 The first one is that this MySQL plugin does not seem to be able to fetch multiline strings.
|
Re: [REL] MySQL Plugin R6 - BlueG - 09.07.2011
The plugin has been updated after almost one year once again due to a threading bug which was discovered by xxmitsu. I have added mutexes to make sure shared variables don't get accessed twice by different threads at the same time. (which causes random crashes) Besides that I have made some code improvements and fixed some small bugs.
I advice everyone who uses the threading capabilities to update to R6, the files are as usual in the first post.
Great thanks for this release goes to xxmitsu for testing and compiling the plugin on Debian5 and CentOS.
Re: [REL] MySQL Plugin R6 - 09/07/11 - Jochemd - 09.07.2011
Can you make one for GLIBCXX_4.3.8? I don't really got how to do that...
Re: [REL] MySQL Plugin R6 - Donya - 09.07.2011
Quote:
|
Originally Posted by G-sTyLeZzZ
The plugin has been updated after almost one year once again due to a threading bug which was discovered by xxmitsu. I have added mutexes to make sure shared variables don't get accessed twice by different threads at the same time. (which causes random crashes) Besides that I have made some code improvements and fixed some small bugs.
I advice everyone who uses the threading capabilities to update to R6, the files are as usual in the first post. Great thanks for this release goes to xxmitsu for testing and compiling the plugin on Debian5 and CentOS. |
great update.
i don't think i did anything wrong but, it still says Mysql Plugin R5 successfully loaded
Re: [REL] MySQL Plugin R6 - 09/07/11 - kacper55331 - 09.07.2011
Код:
[17:50:40] > MySQL plugin R5 successfully loaded. [17:50:40] Loaded.
Re: [REL] MySQL Plugin R6 - 09/07/11 - Jochemd - 09.07.2011
Quote:
|
Originally Posted by kacper55331
Код:
[17:50:40] > MySQL plugin R5 successfully loaded. [17:50:40] Loaded. |
Yeah, I guess he forgot to change...
Re: [REL] MySQL Plugin R6 - 09/07/11 - xxmitsu - 09.07.2011
If you compiled it from source, the version string isn't updated/changed with the string "R6" (if that annoys you, you can change that yourself).
But if you compare the source code with the previous version(R5), you'll see that there's a mutex implementation.
Код:
while(true) {
Mutex::getInstance()->_lockMutex();
Re: [REL] MySQL Plugin R6 - 09/07/11 - Luis- - 09.07.2011
Hmm, it may just be me but I have downloaded the R6 version but it still loads R5, I find it very weird.
Re: [REL] MySQL Plugin R6 - 09/07/11 - Jochemd - 09.07.2011
Read what is said above, Luis.
Re: [REL] MySQL Plugin R6 - 09/07/11 - Donya - 09.07.2011
Quote:
|
Originally Posted by -Luis
Hmm, it may just be me but I have downloaded the R6 version but it still loads R5, I find it very weird.
|
Re: [REL] MySQL Plugin R6 - 09/07/11 - Laronic - 09.07.2011
R6 works fine for me.
Nice update btw!
Re: [REL] MySQL Plugin R6 - 09/07/11 - GhoulSlayeR - 09.07.2011
I appreciate the fixes, thank you.
Re: [REL] MySQL Plugin R6 - 09/07/11 - Calgon - 10.07.2011
Thanks for the update.
Re: [REL] MySQL Plugin R6 - 09/07/11 - Whitetiger - 10.07.2011
The new plugin versions crashes my server (100% CPU usage) when i try to reload an FS that uses MySQL
I am using mysql_close() in OnFilterScriptExit, and it works perfectly fine in R5 (switched back to R5, made no changes in the script)
Running Linux (ServerFFS) with the CentOS plugin versions
AW: [REL] MySQL Plugin R6 - 09/07/11 - Forbidden - 13.07.2011
If there are display succefully ,then yes.
Re: [REL] MySQL Plugin R6 - 09/07/11 - Incognation - 13.07.2011
But the current version is R6, and he shows R5..