[tony_fitto]

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!

[GangsTa_]

I need the mysql_fetch_array function.

[RingoRus]

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

[kr0tchy]

solved

[Luis-]

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

[HACKHERS]

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.

[Johndaonee]

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

[tliamg]

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?

[Mischi]

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

[Jon_De]

plugin is worked on 0.3d normal?

[Danielo]

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

[Klick11]

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

[C0dy09]

where is the download link..?

[nacimbogoss]

Were is it ?
No link ?

[inferno211]

please new dl link

[C0dy09]

there must be a person which have the plugin..

[inferno211]

I know well and just waiting for someone

Really I need it ;/

[Klick11]

Yes Please Who have the plugin, please upload it

[StrickenKid]

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

[Blacklite]

here are some temporary links:

• Windows (comes with libmysql.dll, .NET Framework required)
  • XP / Vista / 7
• Linux (compiled on Debian 5)
  • Linux Distributions
  • Static Linux Distributions (Use on Hosted Servers e.g. ServerFFS)
• Source
  • Cross Compatible
• Scripts
  • Example Script
  • Example Callback Script