Raised This Month: $ Target: $400
 0% 

OciXCrom's Rank System [XP|Levels|Ranks]


Post New Thread Reply   
 
Thread Tools Display Modes
Author Message
totopizza
AlliedModders Donor
Join Date: Oct 2015
Location: Honduras
Old 03-17-2019 , 04:07   Re: OciXCrom's Rank System [XP|Levels|Ranks]
Reply With Quote #1

Try this, reduce the number of times a connection is created, now only create once:

Test it (I did not try it, but it should work):
Attached Files
File Type: sma Get Plugin or Get Source (crx_ranksystem_test_sql.sma - 486 views - 47.5 KB)
totopizza is offline
LithuanianJack
Senior Member
Join Date: Nov 2013
Location: Vilnius, Lithuania
Old 03-17-2019 , 04:42   Re: OciXCrom's Rank System [XP|Levels|Ranks]
Reply With Quote #2

Quote:
Originally Posted by totopizza View Post
Try this, reduce the number of times a connection is created, now only create once:

Test it (I did not try it, but it should work):
Nothing changes. When player disconnects >100 times, error happens.
LithuanianJack is offline
LithuanianJack
Senior Member
Join Date: Nov 2013
Location: Vilnius, Lithuania
Old 04-03-2019 , 11:15   Re: OciXCrom's Rank System [XP|Levels|Ranks]
Reply With Quote #3

Quote:
Originally Posted by LithuanianJack View Post
Nothing changes. When player disconnects >100 times, error happens.
I can pay for person who will fix this bug, because I want to use this plugin but plugin’s author do not know how to fix their own code fault.
LithuanianJack is offline
Koneuka
Junior Member
Join Date: Nov 2017
Old 04-05-2019 , 06:07   Re: OciXCrom's Rank System [XP|Levels|Ranks]
Reply With Quote #4

Quote:
Originally Posted by LithuanianJack View Post
I can pay for person who will fix this bug, because I want to use this plugin but plugin’s author do not know how to fix their own code fault.
If we can't close connection using AMXX, what is actually sad, we can force mysql to close connections automatically after some seconds/minutes past.

In server configuration file (the one that runs MYSQL) these globals need to be changed:

HTML Code:
global wait_timeout=28800;
global interactive_timeout=28800;
Set in seconds.

So why do we actually need 8 hours of connection?

As I understand it will make MYSQL create new connections instead of using already existing, but can solve your problem.

Last edited by Koneuka; 04-05-2019 at 06:16.
Koneuka is offline
LithuanianJack
Senior Member
Join Date: Nov 2013
Location: Vilnius, Lithuania
Old 04-19-2019 , 03:49   Re: OciXCrom's Rank System [XP|Levels|Ranks]
Reply With Quote #5

Quote:
Originally Posted by Koneuka View Post
If we can't close connection using AMXX, what is actually sad, we can force mysql to close connections automatically after some seconds/minutes past.

In server configuration file (the one that runs MYSQL) these globals need to be changed:

HTML Code:
global wait_timeout=28800;
global interactive_timeout=28800;
Set in seconds.

So why do we actually need 8 hours of connection?

As I understand it will make MYSQL create new connections instead of using already existing, but can solve your problem.
So what values would you recommend to use?
LithuanianJack is offline
Koneuka
Junior Member
Join Date: Nov 2017
Old 04-20-2019 , 15:21   Re: OciXCrom's Rank System [XP|Levels|Ranks]
Reply With Quote #6

Quote:
Originally Posted by LithuanianJack View Post
So what values would you recommend to use?
60 is totally ok for both Connection never needed longer than for a minute and should be harmless to your webserver.

Last edited by Koneuka; 04-20-2019 at 15:22.
Koneuka is offline
LithuanianJack
Senior Member
Join Date: Nov 2013
Location: Vilnius, Lithuania
Old 05-28-2019 , 02:09   Re: OciXCrom's Rank System [XP|Levels|Ranks]
Reply With Quote #7

Quote:
Originally Posted by Koneuka View Post
60 is totally ok for both Connection never needed longer than for a minute and should be harmless to your webserver.
Don’t work. When this bug will be fixed? I want to use the SQL function. And interesting, how other people use this plugin with SQL?
LithuanianJack 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 20:42.


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