Raised This Month: $ Target: $400
 0% 

Fixed SQL_ThreadQuery Server Pause


Post New Thread Reply   
 
Thread Tools Display Modes
Author Message
201724
Member
Join Date: May 2011
Old 02-06-2012 , 01:43   Fixed SQL_ThreadQuery Server Pause
Reply With Quote #1

I don't compile mysql_amxx so write the module

if player connect use SQL_ThreadQuery Read Access

If the replacement map when players enter WaitForWingleObject unable to return will result in

the module fix the bug

add amxx the code
native StopThread();
public plugin_end()
{
StopThread();
}


please delete old code and add the code2 function)

static cell AMX_NATIVE_CALL StopThread(AMX *amx, cell *params)
{
if(ThreadSaves)
{
TerminateThread(ThreadSaves,0);
CloseHandle(ThreadSaves);
ThreadSaves = NULL;
return 1;
}
return 0;
}

VOID OnAmxxDetach()
{
cbThread->UnInstallApiHook();
if(ThreadSaves)
{
TerminateThread(ThreadSaves,0);
CloseHandle(ThreadSaves);
ThreadSaves = NULL;
}
}
Attached Files
File Type: zip PatchMySQL.zip (102.8 KB, 348 views)

Last edited by 201724; 02-19-2012 at 04:02.
201724 is offline
Send a message via MSN to 201724
wangningyu
Member
Join Date: Dec 2011
Location: China.GuangDong
Old 02-06-2012 , 02:14   Re: Fixed SQL_ThreadQuery Server Pause
Reply With Quote #2

Thans for share !

///////////////////////////////////////////////////////

if the result counts more than 100,000

it must be used.
__________________
One Code , One Dream !
wangningyu is offline
201724
Member
Join Date: May 2011
Old 02-06-2012 , 05:48   Re: Fixed SQL_ThreadQuery Server Pause
Reply With Quote #3

i 'm compile mysql_amxx error i used vc6 but use mysql the libmysql.lib compile success................................
201724 is offline
Send a message via MSN to 201724
dFF
sıɹɹoɥɔ ʞɔnu
Join Date: Oct 2009
Old 02-07-2012 , 10:06   Re: Fixed SQL_ThreadQuery Server Pause
Reply With Quote #4

You should report that bug.

Also, linux version ?
dFF is offline
Bleeding Warrior
Junior Member
Join Date: Jul 2012
Old 02-22-2015 , 02:14   Re: Fixed SQL_ThreadQuery Server Pause
Reply With Quote #5

Quote:
Originally Posted by 201724 View Post
i 'm compile mysql_amxx error i used vc6 but use mysql the libmysql.lib compile success................................
Can you attach the compiled form of the module ? I am suffering frm same problem.
Bleeding Warrior is offline
201724
Member
Join Date: May 2011
Old 02-12-2012 , 01:55   Re: Fixed SQL_ThreadQuery Server Pause
Reply With Quote #6

fix WaitForSingleObject dwMilliseconds not -1

public client_putinserver(id)
{
SQL_ThreadQuery(...);
}

changer maps player join server the thread be wait..... not return...use TerminateThread the API Kill the mysql_amxx threads

Last edited by 201724; 02-12-2012 at 02:00.
201724 is offline
Send a message via MSN to 201724
GordonFreeman (RU)
Veteran Member
Join Date: Jan 2010
Location: Uzbekistan
Old 02-12-2012 , 02:55   Re: Fixed SQL_ThreadQuery Server Pause
Reply With Quote #7

Can you made it for SQLite?
__________________
The functional way is the right way
GordonFreeman (RU) is offline
201724
Member
Join Date: May 2011
Old 02-12-2012 , 09:41   Re: Fixed SQL_ThreadQuery Server Pause
Reply With Quote #8

I no use SQLite,,,,sorry
201724 is offline
Send a message via MSN to 201724
senecas
Senior Member
Join Date: Jun 2006
Old 04-01-2012 , 01:46   Re: Fixed SQL_ThreadQuery Server Pause
Reply With Quote #9

Plz, Can someone compile in linux.
or Teach me how to compile module in linux.
senecas is offline
claudiuhks
Yam Inside®™℠
Join Date: Jan 2010
Location: Living Randomly
Old 04-01-2012 , 04:38   Re: Fixed SQL_ThreadQuery Server Pause
Reply With Quote #10

Quote:
Originally Posted by senecas View Post
Plz, Can someone compile in linux.
or Teach me how to compile module in linux.
Using a (virtual) machine running Linux with Makefile.
claudiuhks is offline
Send a message via MSN to claudiuhks Send a message via Yahoo to claudiuhks Send a message via Skype™ to claudiuhks
Reply



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 16:55.


Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Theme made by Freecode