SA-MP Forums Archive
[Plugin] [REL] SA:MP MySQL Plugin 2.1.1 - Released (1/25/2011 - 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] SA:MP MySQL Plugin 2.1.1 - Released (1/25/2011 (/showthread.php?tid=122983)

Pages: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22

Re: [REL] SA:MP MySQL Plugin 2.1.1 - Released (1/25/2011 - tony_fitto - 22.10.2011

Anyone got the server restart bug as me?

Once some one is trying to connect to the server it restarts without any errors.
Please help me!

Re: [REL] SA:MP MySQL Plugin 2.1.1 - Released (1/25/2011 - GangsTa_ - 22.10.2011

I need the mysql_fetch_array function.

Re: [REL] SA:MP MySQL Plugin 2.1.1 - Released (1/25/2011 - RingoRus - 06.11.2011

I have a problem with the mysql_fetch_field() function:

Код:
new query[256],val[32],idx;
while(idx < MAX_INTERIORS)
{
   format(query,256,"SELECT * FROM itr WHERE id=%d",idx);
   mysql_query(query);
   mysql_store_result();
   mysql_fetch_field("ix",val);II[idx][IntX] = floatstr(val);
   mysql_fetch_field("iy",val);II[idx][IntY] = floatstr(val);
   mysql_fetch_field("iz",val);II[idx][IntZ] = floatstr(val);
   mysql_free_result();
   idx++;
}
This code is in OnGameModeInit() and first during execution mysql_fetch_field() crash the server.

Last lines in mysql.log:
Код:
[Sun Nov 06 16:18:34 2011] Function: mysql_query executed: "SELECT * FROM itr WHERE id=0" with result: "0".
[Sun Nov 06 16:18:34 2011] Function: mysql_store_result executed with result: "1"
[Sun Nov 06 16:18:34 2011] Function: mysql_fetch_field executed.
When you first start everything works well, the crash occurs when you restart (gmx).


P.S. Sorry for my bad English

Re: [REL] SA:MP MySQL Plugin 2.1.1 - Released (1/25/2011 - kr0tchy - 12.11.2011

solved

Re: [REL] SA:MP MySQL Plugin 2.1.1 - Released (1/25/2011 - Luis- - 12.11.2011

Which one is better? I am currently using BlueG's but I am thinking about using this one.

Re: [REL] SA:MP MySQL Plugin 2.1.1 - Released (1/25/2011 - HACKHERS - 19.11.2011

Can StrickenKid or someone can make charsets for this plugin when im getting a data from database some character changed to ? when im doing with PHP it doesn't.

Re: [REL] SA:MP MySQL Plugin 2.1.1 - Released (1/25/2011 - Johndaonee - 22.11.2011

Could anybody help me out here?
Failed to exeute query. Data truncated for column 'LoadPosX' at row 1.
I sometimes get this, could anybody tell me what could be the reason for this?

This is the code that returns this

pawn Код:
GetPlayerPos( playerid, PlayerInfo[playerid][PosX], PlayerInfo[playerid][PosY], PlayerInfo[playerid][PosZ] );
format( query, sizeof( query ), "UPDATE `accounts` SET `LoadPosX` = '%f' WHERE `UserID` = '%d'", PlayerInfo[playerid][PosX], PlayerInfo[playerid][pDatabaseID] );
mysql_query(query);


Re: [REL] SA:MP MySQL Plugin 2.1.1 - Released (1/25/2011 - tliamg - 25.11.2011

Having had several tables of data players can add new recordu automatically to all tables?

Quote:

new str[126];
format(str, sizeof(str), "SELECT `won` FROM `players_stats` WHERE `name` = '%s'", NickName(playerid));
mysql_query(str);
mysql_store_result();
if(mysql_num_rows())
{
mysql_free_result();
}
else
{
mysql_free_result();
format(str, sizeof(str), "UPDATE `players_stats` SET `won`=%d WHERE `name` = '%s'", NickName(playerid));
mysql_query(str);
}
A different, better way is?

AW: [REL] SA:MP MySQL Plugin 2.1.1 - Released (1/25/2011 - Mischi - 29.11.2011

Is that plugin compatible to mysql 5.5? cause i can’t find the libraries in /usr/lib/mysql

Re: [REL] SA:MP MySQL Plugin 2.1.1 - Released (1/25/2011 - Jon_De - 01.12.2011

plugin is worked on 0.3d normal?

Re: [REL] SA:MP MySQL Plugin 2.1.1 - Released (1/25/2011 - Danielo - 09.01.2012

Why mysql won't load if I upgraded the plugin?
It connects to the DB but won't load it.

AW: [REL] SA:MP MySQL Plugin 2.1.1 - Released (1/25/2011 - Klick11 - 25.01.2012

Links down i need this Plugin! I cant find it in ****** and on the germany site, please upload it again for me.

Thank you!

Sorry for my bad english

AW: [REL] SA:MP MySQL Plugin 2.1.1 - Released (1/25/2011 - C0dy09 - 25.01.2012

where is the download link..?

Re: [REL] SA:MP MySQL Plugin 2.1.1 - Released (1/25/2011 - nacimbogoss - 25.01.2012

Were is it ?
No link ?

Re: [REL] SA:MP MySQL Plugin 2.1.1 - Released (1/25/2011 - inferno211 - 25.01.2012

please new dl link

AW: [REL] SA:MP MySQL Plugin 2.1.1 - Released (1/25/2011 - C0dy09 - 25.01.2012

there must be a person which have the plugin..

Re: [REL] SA:MP MySQL Plugin 2.1.1 - Released (1/25/2011 - inferno211 - 25.01.2012

I know well and just waiting for someone

Really I need it ;/

AW: [REL] SA:MP MySQL Plugin 2.1.1 - Released (1/25/2011 - Klick11 - 25.01.2012

Yes Please Who have the plugin, please upload it

Re: [REL] SA:MP MySQL Plugin 2.1.1 - Released (1/25/2011 - StrickenKid - 25.01.2012

Sorry, my domain expired on the 23rd, it should be back up shortly.

Re: [REL] SA:MP MySQL Plugin 2.1.1 - Released (1/25/2011 - Blacklite - 25.01.2012

here are some temporary links: