Raised This Month: $32 Target: $400
 8% 

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, 335 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
201724
Member
Join Date: May 2011
Old 02-12-2012 , 01:55   Re: Fixed SQL_ThreadQuery Server Pause
Reply With Quote #5

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 #6

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 #7

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 #8

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 #9

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
senecas
Senior Member
Join Date: Jun 2006
Old 04-01-2012 , 20:40   Re: Fixed SQL_ThreadQuery Server Pause
Reply With Quote #10

Quote:
Originally Posted by claudiuhks View Post
Using a (virtual) machine running Linux with Makefile.
I mean "how to"...
I already have linux(ubuntu).
as I heard, I need some hl sdk, metamod source stuff like that.
Is there any tutorial about this ?
it is not, You can teach me step by step.
or you can share your (vm/vbox) virtual disk file.
senecas is offline
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 09:55.


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