[Plugin] [REL] MySQL Plugin (Now on github!)

[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)

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 (Now on github!) - Riddy - 10.01.2014

Just wondering, can the MySQL lag out due to that fact that it I'm loading 300 rows at a constant like almost instantly, and the server seems to lag out after they are done, can this be the mysql server itself? or is this a problem with the loop loading and then going through a second function to create objects?

Re: [REL] MySQL Plugin (Now on github!) - maddinat0r - 10.01.2014

Quote:

Originally Posted by Riddy

Just wondering, can the MySQL lag out due to that fact that it I'm loading 300 rows at a constant like almost instantly, and the server seems to lag out after they are done, can this be the mysql server itself? or is this a problem with the loop loading and then going through a second function to create objects?

Hard to say. It also depends how many columns you are loading (the number of fields fetched by the query is important, rows*columns). However, it's likely that the MySQL plugin causes this if the lag occurs before the result-callback is called. Why don't you use the profiler plugin or just disable the object creating code and find the cause?

Re: [REL] MySQL Plugin (Now on github!) - Riddy - 10.01.2014

Quote:

Originally Posted by maddinat0r

Disabled the creation of the objects, and it has a slight lag on localhost, but I've noticed on a bought server, it completely lags out, it takes time for other queries to be executed such as looking up the db for a certain player, even after the queries are complete for the objects.

EDIT: Mind, I am using cache for this.

Re: [REL] MySQL Plugin (Now on github!) - iZN - 10.01.2014

Quote:

Originally Posted by ombre

I run on debian 7 64b and R5 mysql plugin I need the plugin for debian 5 or x86 or other?

Use R6. Also, it is recommended to use R34 (latest). Don't know if it will work fine on Debian 7, it will need to be compiled again.

Re: [REL] MySQL Plugin (Now on github!) - Su37Erich - 10.01.2014

Quote:

Originally Posted by IstuntmanI

Use the static version.

Thanks, it's working now

Re: [REL] MySQL Plugin (Now on github!) - anou1 - 13.01.2014

Cause I wasnt able to recover a value with a query like

Код:

 mysql_format(mysql, query, sizeof(query), "INSERT INTO `joueurs` (`Username`, `Password`, `IP`, `Admin`, `VIP`, `Argent`, `posX` ,`posY`, `posZ`, `Interieur`, `World`, `Skin`, `Niveau`) VALUES ('%e', '%s', '%s', 0, 0, 1000, 1527.5634, -1738.9218, 13.5469, 0, 0, 26, 1)", Name[playerid], pInfo[playerid][Password], IP[playerid]);
mysql_tquery(mysql, query, "", "");

mysql_format(mysql, query, sizeof(query), "SELECT `posX`, `posY` FROM `joueurs` WHERE `posX` = '%f', `posY` = '%f'", pInfo[playerid][posX], pInfo[playerid][posY]);
printf("%f %f ", pInfo[playerid][posX], pInfo[playerid][posY]);

With my code, It always return me 0 instead of the positionX and positionY.

Do you know why ?

Re: [REL] MySQL Plugin (Now on github!) - maddinat0r - 13.01.2014

Quote:

Originally Posted by anou1

Cause I wasnt able to recover a value with a query like

Код:

 mysql_format(mysql, query, sizeof(query), "INSERT INTO `joueurs` (`Username`, `Password`, `IP`, `Admin`, `VIP`, `Argent`, `posX` ,`posY`, `posZ`, `Interieur`, `World`, `Skin`, `Niveau`) VALUES ('%e', '%s', '%s', 0, 0, 1000, 1527.5634, -1738.9218, 13.5469, 0, 0, 26, 1)", Name[playerid], pInfo[playerid][Password], IP[playerid]);
mysql_tquery(mysql, query, "", "");

mysql_format(mysql, query, sizeof(query), "SELECT `posX`, `posY` FROM `joueurs` WHERE `posX` = '%f', `posY` = '%f'", pInfo[playerid][posX], pInfo[playerid][posY]);
printf("%f %f ", pInfo[playerid][posX], pInfo[playerid][posY]);

With my code, It always return me 0 instead of the positionX and positionY.

Do you know why ?

Where exactly did it returned 0? Did you mean that the query isn't returning any result?

Re : [REL] MySQL Plugin (Now on github!) - anou1 - 13.01.2014

I tried to explain it more there:

https://sampforum.blast.hk/showthread.php?tid=487488

Thank you for your help !

Re : [REL] MySQL Plugin (Now on github!) - ombre - 14.01.2014

if my gamemode is scripted for the r6 and I install the R34 what's happen?

because i use:

mysql_fetch_int
mysql_query
OnQueryFinish

And I see it's not used for the r7

Re : [REL] MySQL Plugin (Now on github!) - ombre - 16.01.2014

libmysqlclient.so.15 ( or more ) is compulsory because I don't have but the plugin work's why?

Re: Re : [REL] MySQL Plugin (Now on github!) - iZN - 16.01.2014

Quote:

Originally Posted by ombre

libmysqlclient.so.15 ( or more ) is compulsory because I don't have but the plugin work's why?

That library is already there or while using static plugin it works fine (Not confirmed). If it is working fine, so don't worry about it.

Re: [REL] MySQL Plugin (Now on github!) - rouzbeh - 16.01.2014

hello guys ...
i have a rpg server using mysql system
my database have 8 Tables every have 20 columns + 1 Table have 200 columns
and that 9 tables update every 5 minutes(save every players and houses and more stats in server)
i want buy this VPS and run this gamemode on it:
Ram: 2GB
Cpu: 2 Core 2.0 Ghz(intel E5)
can i run this server without problems on this vps?
i think mysql queries needs best hardware! but i need your help,
plz say yes or no with reason?!

Re: [REL] MySQL Plugin (Now on github!) - Michalec - 16.01.2014

No, mysql don't need the best hardware. This config is good

Re: [REL] MySQL Plugin (Now on github!) - B-Matt - 18.01.2014

Quote:

Originally Posted by rouzbeh

hello guys ...
i have a rpg server using mysql system
my database have 8 Tables every have 20 columns + 1 Table have 200 columns
and that 9 tables update every 5 minutes(save every players and houses and more stats in server)
i want buy this VPS and run this gamemode on it:
Ram: 2GB
Cpu: 2 Core 2.0 Ghz(intel E5)
can i run this server without problems on this vps?
i think mysql queries needs best hardware! but i need your help,
plz say yes or no with reason?!

I'm running my server on 1 core CPU and it's quite fast. No need to worry.

AW: [REL] MySQL Plugin (Now on github!) - eLiTe. - 20.01.2014

Please Update R5 for 0.3z R2

Re: AW: [REL] MySQL Plugin (Now on github!) - iZN - 20.01.2014

Quote:

Originally Posted by eLiTe.

Please Update R5 for 0.3z R2

MySQL plugin doesn't even touches the new callbacks and why would they even update such old revision?

Re: [REL] MySQL Plugin (Now on github!) - Aliassassin123456 - 23.01.2014

Solved

Hi there,
I change my windows to 8.1 64bit Enterprise,
When i run sa-mp server i reached an error: MSVCP110.dll is missing blah blah ...
I download this dll file and put it to System32 and SysWOW64 and when i want to run samp-server i reach this:

Код:

----------
Loaded log file: "server_log.txt".
----------

SA-MP Dedicated Server
----------------------
v0.3z-RC3, ©2005-2014 SA-MP Team

[14:20:47] 
[14:20:47] Server Plugins
[14:20:47] --------------
[14:20:47]  Loading plugin: streamer
[14:20:47] 

*** Streamer Plugin v2.6.1 by Incognito loaded ***

[14:20:47]   Loaded.
[14:20:47]  Loading plugin: mysql
[14:20:47]   Failed.
[14:20:47]  Loading plugin: crashdetect
[14:20:47]   CrashDetect v4.13 is OK.
[14:20:47]   Loaded.
[14:20:47]  Loaded 2 plugins.

[14:20:47] 
[14:20:47] Filterscripts
[14:20:47] ---------------
[14:20:47]   Loaded 0 filterscripts.

[14:20:47] [debug] Run time error 19: "File or function is not found"
[14:20:47] [debug]  cache_get_row_count
[14:20:47] [debug]  cache_get_row
[14:20:47] [debug]  mysql_tquery
[14:20:47] [debug]  cache_get_row_int
[14:20:47] [debug]  cache_get_row_float
[14:20:47] [debug]  mysql_log
[14:20:47] [debug]  mysql_connect
[14:20:47] [debug]  cache_insert_id
[14:20:47] [debug] Run time error 19: "File or function is not found"
[14:20:47] [debug]  cache_get_row_count
[14:20:47] [debug]  cache_get_row
[14:20:47] [debug]  mysql_tquery
[14:20:47] [debug]  cache_get_row_int
[14:20:47] [debug]  cache_get_row_float
[14:20:47] [debug]  mysql_log
[14:20:47] [debug]  mysql_connect
[14:20:47] [debug]  cache_insert_id
[14:20:47] Script[gamemodes/lol.amx]: Run time error 19: "File or function is not found"
[14:20:47] Number of vehicle models: 0

i already run dll files fixer and fix msvcp110.dll but, still same ... i download all vcredist(Visual C++ Redistributable 64bit and 32bit) and install them and restart, ...., but still the same problem...
I am using R34 version

Help...

Re: [REL] MySQL Plugin (Now on github!) - iZN - 23.01.2014

The best thing is not to download those .dll's separately, just download the package instead. Just check if you have 'Visual C++ 2012', x86 and x64.

Re: [REL] MySQL Plugin (Now on github!) - Aliassassin123456 - 23.01.2014

Quote:

Originally Posted by iZN

The best thing is not to download those .dll's separately, just download the package instead. Just check if you have 'Visual C++ 2012', x86 and x64.

Quote:

Originally Posted by Aliassassin123456

i download all vcredist(Visual C++ Redistributable 64bit and 32bit) and install them and restart, ...., but still the same problem...
I am using R34 version

Help...

I already dl and install that .. update4 32bit and 64bit ... + My windows is fully up to date

Re: [REL] MySQL Plugin (Now on github!) - Misiur - 23.01.2014

Do you have both libmysql and mysql dll's?

#e: Oh, I'm Mysql plugin topic