SA-MP Forums Archive
MySQL question (connection handle) - 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: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: MySQL question (connection handle) (/showthread.php?tid=404530)


MySQL question (connection handle) - pop.nicku - 03.01.2013

Hi,I'm using BlueG's mysql plugin and I converted my gm to the R7 version.
My problem is this:
.
PHP код:
.
.
.
[06:21:14] >> mysql_close( Connection handle: 1 )
[06:21:14] CMySQLHandler::~CMySQLHandler() - deconstructor called.
[06:21:14] CMySQLHandler::FreeResult() - The result is already empty.
[06:21:14] CMySQLHandler::Disconnect() - Connection was closed.
[06:21:59] >> mysql_ping( Connection handle: 1 )
[06:21:59] >> mysql_ping() - Invalid connection handle. (You set: 1, Highest connection handle ID is 0).
[06:21:59] >> mysql_close( Connection handle: 1 )
[06:21:59] >> mysql_close() - Invalid connection handle. (You set: 1, Highest connection handle ID is 0).
[06:21:59] >> mysql_connect(localhost, root, samp2, ******) on port 3306
[06:21:59] CMySQLHandler::CMySQLHandler() - constructor called.
[06:21:59] CMySQLHandler::CMySQLHandler() - Connecting to "localhost" | DB: "samp2" | Username: "root"
[06:21:59] CMySQLHandler::Connect() - Connection was successful.
[06:21:59] CMySQLHandler::Connect() - Auto-Reconnect has been enabled.
[06:21:59] >> mysql_ping( Connection handle: 1 )
[06:21:59] CMySQLHandler::Ping() - Connection is still alive.
[06:21:59] >> mysql_query_callback( Connection handle: 1 )
[06:21:59] >> mysql_query_callback( Connection handle: 1 )
[06:21:59] >> mysql_query_callback( Connection handle: 1 )
[06:21:59] >> mysql_query_callback( Connection handle: 1 )
[06:21:59] >> mysql_query_callback( Connection handle: 1 )
[06:21:59] >> mysql_query_callback( Connection handle: 1 )
[06:21:59] >> mysql_query_callback( Connection handle: 1 )
[06:21:59] >> mysql_query_callback( Connection handle: 1 )
[06:21:59] >> mysql_query_callback( Connection handle: 1 )
[06:21:59] >> mysql_query_callback( Connection handle: 1 )
[06:21:59] >> mysql_query_callback( Connection handle: 1 )
[06:21:59] >> mysql_query_callback( Connection handle: 1 )
[06:21:59] >> mysql_query_callback( Connection handle: 1 )
.
.
. 
Is it ok to return so much "mysql_query_callback( Connection handle: 1 )"?
If not, how can i fix it?

Thanks and srry for my bad english.

Re: MySQL question (connection handle) - [HK]Ryder[AN] - 03.01.2013

It is ok, but why are you doing it?

Re: MySQL question (connection handle) - pop.nicku - 03.01.2013

Quote:
Originally Posted by [HK]Ryder[AN]
Посмотреть сообщение
It is ok, but why are you doing it?
Doing what?

Re: MySQL question (connection handle) - [HK]Ryder[AN] - 03.01.2013

Why are you sending so many queries within one second?

Re: MySQL question (connection handle) - pop.nicku - 03.01.2013

That's how i update a player's info:

Код:
		
.
.
                format(l_string,sizeof(l_string), "UPDATE `players` SET `PlayerLevel` = '%d' WHERE `Name` = '%s'",PlayerInfo[playerid][pLevel],name);
		mysql_function_query(dbHandle, l_string, false, "", "");

		format(l_string,sizeof(l_string), "UPDATE `players` SET `AdminLevel` = '%d' WHERE `Name` = '%s'",PlayerInfo[playerid][pAdmin],name);
		mysql_function_query(dbHandle, l_string, false, "", "");

		format(l_string,sizeof(l_string), "UPDATE `players` SET `HelperLevel` = '%d' WHERE `Name` = '%s'",PlayerInfo[playerid][pHelper],name);
		mysql_function_query(dbHandle, l_string, false, "", "");

		format(l_string,sizeof(l_string), "UPDATE `players` SET `DonateRank` = '%d' WHERE `Name` = '%s'",PlayerInfo[playerid][pDonateRank],name);
		mysql_function_query(dbHandle, l_string, false, "", "");

		format(l_string,sizeof(l_string), "UPDATE `players` SET `UpgradePoints` = '%d' WHERE `Name` = '%s'",PlayerInfo[playerid][gPupgrade],name);
		mysql_function_query(dbHandle, l_string, false, "", "");
.
.


Re: MySQL question (connection handle) - Mandrakke - 03.01.2013

In the R7 version, every query will call an callback when it finish its execution... the only "problem" there is that the plugin are calling an callback that is not even set, but I think that it will not slow down your server, since every query runs in a thread.

Re: MySQL question (connection handle) - ReneG - 03.01.2013

Quote:
Originally Posted by pop.nicku
Посмотреть сообщение
That's how i update a player's info:

Код:
		
.
.
                format(l_string,sizeof(l_string), "UPDATE `players` SET `PlayerLevel` = '%d' WHERE `Name` = '%s'",PlayerInfo[playerid][pLevel],name);
		mysql_function_query(dbHandle, l_string, false, "", "");

		format(l_string,sizeof(l_string), "UPDATE `players` SET `AdminLevel` = '%d' WHERE `Name` = '%s'",PlayerInfo[playerid][pAdmin],name);
		mysql_function_query(dbHandle, l_string, false, "", "");

		format(l_string,sizeof(l_string), "UPDATE `players` SET `HelperLevel` = '%d' WHERE `Name` = '%s'",PlayerInfo[playerid][pHelper],name);
		mysql_function_query(dbHandle, l_string, false, "", "");

		format(l_string,sizeof(l_string), "UPDATE `players` SET `DonateRank` = '%d' WHERE `Name` = '%s'",PlayerInfo[playerid][pDonateRank],name);
		mysql_function_query(dbHandle, l_string, false, "", "");

		format(l_string,sizeof(l_string), "UPDATE `players` SET `UpgradePoints` = '%d' WHERE `Name` = '%s'",PlayerInfo[playerid][gPupgrade],name);
		mysql_function_query(dbHandle, l_string, false, "", "");
.
.
That honestly defeats the purpose of using mysql if you're going to update ONE field per query.
pawn Код:
format(l_string,sizeof l_string, "UPDATE `players` SET\
    `PlayerLevel` = %d,\
    `AdminLevel = %d,\
    `HelperLevel` = %d,\
    `DonateRank` = %d,\
    `UpgradePoints` = %d\
    `WHERE `Name` = '%s'",
    PlayerInfo[playerid][pLevel],
    PlayerInfo[playerid][pAdmin],
    PlayerInfo[playerid][pHelper],
    PlayerInfo[playerid][pDonateRank],
    PlayerInfo[playerid][gPupgrade],
    name
);
mysql_function_query(dbHandle, l_string, false, "", "");


Re: MySQL question (connection handle) - pop.nicku - 03.01.2013

Yeah, i know, i did it so to detect the problems, if any...