[Plugin] [REL] SA:MP MySQL Plugin 2.1.1 - Released (1/25/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!
Reply

I need the mysql_fetch_array function.
Reply

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
Reply

solved
Reply

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

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.
Reply

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);
Reply

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?
Reply

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

plugin is worked on 0.3d normal?
Reply

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

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
Reply

where is the download link..?
Reply

Were is it ?
No link ?
Reply

please new dl link
Reply

there must be a person which have the plugin..
Reply

I know well and just waiting for someone

Really I need it ;/
Reply

Yes Please Who have the plugin, please upload it
Reply

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

here are some temporary links:
Reply


Forum Jump:


Users browsing this thread: 2 Guest(s)