[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!) - liinor - 06.09.2014

I need working mysql plugin for ubuntu! Please give me one!

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

Quote:

Originally Posted by sheenidgs

I wanna ask about my problem. I want load some my data with function mysql_tquery, but the callback doesn't called. Here's my code:
[...]
Sorry for my bad English

It's possible that your gamemode or another filterscript has a callback with the same name ("CarPriceLoadInit") and that this callback is called instead of the one in your filterscript.
This misleading behavior is going to be fixed in R40.

Re: [REL] MySQL Plugin (Now on github!) - kurta999 - 06.09.2014

What would be, if you create another thread for connenection to the database? Because now mysql_connect() will hang up the server.

Best solution would be create thread for this and call a callback, when connection success or failed.

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

Quote:

Originally Posted by kurta999

What would be, if you create another thread for connenection to the database? Because now mysql_connect() will hang up the server.

Best solution would be create thread for this and call a callback, when connection success or failed.

That's how it works now. All connections (except the unthreaded connection ofc) are established in another thread than the main thread, so 'mysql_connect' doesn't hang up the server.

Re: [REL] MySQL Plugin (Now on github!) - sheenidgs - 07.09.2014

Quote:

Originally Posted by maddinat0r

I've changed it to another name, but it doesn't work too.

Re: [REL] MySQL Plugin (Now on github!) - devil shill - 07.09.2014

Fix the download links returns to a forbidden page.

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

Quote:

Originally Posted by devil shill

Fix the download links returns to a forbidden page.

No? https://github.com/pBlueG/SA-MP-MySQL/releases

Re: [REL] MySQL Plugin (Now on github!) - devil shill - 07.09.2014

Quote:

Originally Posted by iZN

No? https://github.com/pBlueG/SA-MP-MySQL/releases

No as i use R5 Version.

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

Quote:

Originally Posted by sheenidgs

I've changed it to another name, but it doesn't work too.

Are you sure that this callback does not exist anywhere else in any of your scripts (neither a 'public' nor a 'forward' definition)?

Re: [REL] MySQL Plugin (Now on github!) - sheenidgs - 07.09.2014

Quote:

Originally Posted by maddinat0r

Are you sure that this callback does not exist anywhere else in any of your scripts (neither a 'public' nor a 'forward' definition)?

Yes, I'm sure. I 've changed it to another and it's one and only on that script, but stiil nothing.

Re: [REL] MySQL Plugin (Now on github!) - WopsS - 07.09.2014

Quote:

Originally Posted by sheenidgs

I wanna ask about my problem. I want load some my data with function mysql_tquery, but the callback doesn't called. Here's my code:

pawn Код:

public OnFilterScriptInit()
{
    print( "> Connecting to MySQL server..." );
    sqlconn = mysql_connect( "127.0.0.1", "root", "samp", "thepassistrue" );

    ManualVehicleEngineAndLights();
    mysql_tquery( sqlconn, "SELECT * FROM `prices`;", "CarPriceLoadInit" );
    return 1;
}

forward CarPriceLoadInit();
public CarPriceLoadInit()
{
    new tmp[16];
    print("Loading Car Prices data.....");
    
    for( new i = 0; i < cache_get_row_count( sqlconn ); i++ ) {
        cache_get_field_content( i, "model", tmp, sqlconn ); VehInfo[i][Model] = strval(tmp);
        cache_get_field_content( i, "type", tmp, sqlconn ); VehInfo[i][Type] = strval(tmp);
        cache_get_field_content( i, "name", VehInfo[i][Name], sqlconn, 64 );
        cache_get_field_content( i, "price", tmp, sqlconn ); VehInfo[i][Price][0] = strval(tmp);
    }
    printf("|- %d Car Prices loaded from database. -|", cache_get_row_count( sqlconn ));
    return 1;
}

And here's the log: (from mysql_log.txt)

Код:

[23:01:24] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `prices`;", callback: "CarPriceLoadInit", format: "(null)"
[23:01:24] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[23:01:24] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[23:01:24] [DEBUG] CMySQLConnection::Connect - connection was successful
[23:01:24] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[23:01:24] [DEBUG] CMySQLConnection::Connect - connection was successful
[23:01:24] [DEBUG] CMySQLConnection::Connect - connection was successful
[23:01:24] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[23:01:24] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[23:01:24] [DEBUG] CMySQLQuery::Execute[CarPriceLoadInit] - starting query execution
[23:01:24] [DEBUG] CMySQLQuery::Execute[CarPriceLoadInit] - query was successfully executed within 0.580 milliseconds
[23:01:24] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[23:01:24] [DEBUG] Calling callback "CarPriceLoadInit"..
[23:01:24] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called

And this one from server_log.txt:

Код:

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

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

[23:02:09] 
[23:02:09] Server Plugins
[23:02:09] --------------
[23:02:09]  Loading plugin: streamer
[23:02:09]   Loaded.
[23:02:09]  Loading plugin: sscanf
[23:02:09] 

[23:02:09]  ===============================

[23:02:09]       sscanf plugin loaded.     

[23:02:09]          Version:  2.8.1        

[23:02:09]    © 2012 Alex "******" Cole  

[23:02:09]  ===============================

[23:02:09]   Loaded.
[23:02:09]  Loading plugin: mysql
[23:02:09]  >> plugin.mysql: R39-2 successfully loaded.
[23:02:09]   Loaded.
[23:02:09]  Loaded 3 plugins.

[23:02:09] 
[23:02:09] Filterscripts
[23:02:09] ---------------
[23:02:09]   Loading filterscript 'ls_mall.amx'...
[23:02:09]   Loading filterscript 'ls_elevator.amx'...
[23:02:09]   Loading filterscript 'VehSys.amx'...
[23:02:09]  
[23:02:09] > Connecting to MySQL server...
[23:02:09]   Loaded 3 filterscripts.

[23:02:09] Loaded 3 vehicles from: vehicles/trains.txt
[23:02:09] Loaded 3 vehicles from: vehicles/pilots.txt
[23:02:09] Loaded 15 vehicles from: vehicles/lv_law.txt
[23:02:09] Loaded 39 vehicles from: vehicles/lv_airport.txt
[23:02:09] Loaded 255 vehicles from: vehicles/lv_gen.txt
[23:02:09] Loaded 38 vehicles from: vehicles/sf_law.txt
[23:02:09] Loaded 35 vehicles from: vehicles/sf_airport.txt
[23:02:09] Loaded 353 vehicles from: vehicles/sf_gen.txt
[23:02:09] Loaded 24 vehicles from: vehicles/ls_law.txt
[23:02:09] Loaded 37 vehicles from: vehicles/ls_airport.txt
[23:02:09] Loaded 98 vehicles from: vehicles/ls_gen_inner.txt
[23:02:09] Loaded 389 vehicles from: vehicles/ls_gen_outer.txt
[23:02:09] Loaded 71 vehicles from: vehicles/whetstone.txt
[23:02:09] Loaded 168 vehicles from: vehicles/bone.txt
[23:02:09] Loaded 61 vehicles from: vehicles/flint.txt
[23:02:09] Loaded 96 vehicles from: vehicles/tierra.txt
[23:02:09] Loaded 96 vehicles from: vehicles/red_county.txt
[23:02:09] Total vehicles from files: 1781
[23:02:09] 
---------------------------------------
[23:02:09] Running Grand Larceny - by the SA-MP team

[23:02:09] ---------------------------------------

[23:02:09] Number of vehicle models: 173
[23:02:10]

Sorry for my bad English

I replay to your thread here. https://sampforum.blast.hk/showthread.php?tid=536003 ...

Quote:

Originally Posted by WopsS

Tip: Please put that after mysql_connect and see if it is connected to database or not.

pawn Код:

if(sqlconn && mysql_errno(sqlconn) == 0)
    print("Connection to database was established!");
else
    print("Connection to database failed!");

Edit: I try to find the problem. But I can't, on my PC it work.

Edit #2: I reproduced your problem.

This isn't a MySQL Bug, it is a function which is defined already in another FS of GM. Change name of your callback or find it in other filterscripts or gamemode and includes.

I can't reproduced it in other ways.

Re: [REL] MySQL Plugin (Now on github!) - Raefal - 08.09.2014

How to set 2 key on ORM?

Re: [REL] MySQL Plugin (Now on github!) - basicllsw - 09.09.2014

when i used mysql_function_query i got this message

Код:

D:\SAMP\gamemodes\mygamemode.pwn(265) : error 017: undefined symbol "mysql_function_query"

Код:

line 265 : 	mysql_function_query(handle,"SET NAMES TIS620",false,sendquery);

Re: [REL] MySQL Plugin (Now on github!) - iFarbod - 09.09.2014

Quote:

Originally Posted by basicllsw

when i used mysql_function_query i got this message

Код:

D:\SAMP\gamemodes\mygamemode.pwn(265) : error 017: undefined symbol "mysql_function_query"

Код:

line 265 : 	mysql_function_query(handle,"SET NAMES TIS620",false,sendquery);

You are probably using R5-R7

Re: [REL] MySQL Plugin (Now on github!) - khimera - 09.09.2014

Anyone could please update links for older versions.

Re: [REL] MySQL Plugin (Now on github!) - basicllsw - 09.09.2014

Quote:

Originally Posted by iFarbod

You are probably using R5-R7

i use R39-2 it's problem?

Re: [REL] MySQL Plugin (Now on github!) - dusk - 09.09.2014

Quote:

Originally Posted by basicllsw

i use R39-2 it's problem?

Are you sure you're using the R39-2 includes aswell? Or maybe you're compiling your gamemode with different ones?

Re: [REL] MySQL Plugin (Now on github!) - PawelQ - 09.09.2014

Links doesn't work

Re: [REL] MySQL Plugin (Now on github!) - dusk - 09.09.2014

Quote:

Originally Posted by PawelQ

Links doesn't work

The newest release can be downloaded from github, here.

Older links seem to be down... I've uploaded R6, here.

EDIT: i've got a question of my own.

Quote:

[18:40:08] [ERROR] CMySQLConnection::SetCharset - error 2019: Can't initialize character set windows-1257 (path: C:\mysql\\share\charsets\)

Plugin version: R39-2
OS: Windows
Code used to set charset:

pawn Код:

mysql_pquery(DbHandle,"SET NAMES cp1257");
mysql_set_charset("Windows-1257");

I use WAMP. But it's not even in C:. Why would it search in C drive? Or if I want to use it I have to put it in that folder?

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

1. You don't need that query, 'mysql_set_charset' is the equivalent of that query and the only correct way to do it.
2. There is no such charset as "Windows-1257", "cp1257" is the charset you want to set with 'mysql_set_charset'. Here is also a list of all valid charsets.