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

[Any][MySQL] tVip (2.3 | 04-04-21) - The simplest to use Vip Manager


Post New Thread Reply   
 
Thread Tools Display Modes
Sincronic
Senior Member
Join Date: Dec 2018
Old 01-21-2020 , 14:18   Re: [Any][MySQL] tVip (2.2 | 05-03-19) - The simplest to use Vip Manager
Reply With Quote #231

This one ?

Code:
L 01/21/2020 - 04:37:29: [SM]   [0] SQL_SetCharset
L 01/21/2020 - 04:37:29: [SM]   [1] Line 44, tVip(1).sp::OnPluginStart
L 01/21/2020 - 04:37:29: [SM] Unable to load plugin "tVip.smx": Error detected in plugin startup (see error logs)

Here is my database structure https://ibb.co/QfCYS1L .

How to insert this ?

Quote:
SET SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';
Edit:

I managed to get it to work. Thanks.
And i have a question..
is there an option to add permenant vip?

Last edited by Sincronic; 01-21-2020 at 17:01.
Sincronic is offline
flashing
Senior Member
Join Date: Jul 2019
Location: India
Old 01-21-2020 , 23:30   Re: [Any][MySQL] tVip (2.2 | 05-03-19) - The simplest to use Vip Manager
Reply With Quote #232

Quote:
Originally Posted by Sincronic View Post
This one ?

Code:
L 01/21/2020 - 04:37:29: [SM]   [0] SQL_SetCharset
L 01/21/2020 - 04:37:29: [SM]   [1] Line 44, tVip(1).sp::OnPluginStart
L 01/21/2020 - 04:37:29: [SM] Unable to load plugin "tVip.smx": Error detected in plugin startup (see error logs)

Here is my database structure https://ibb.co/QfCYS1L .

How to insert this ?



Edit:

I managed to get it to work. Thanks.
And i have a question..
is there an option to add permenant vip?
If you want to give vip permanently you can give flags directly through admins config
flashing is offline
gildevanaraujo
Senior Member
Join Date: Oct 2018
Location: Brazil
Old 02-07-2020 , 13:16   Re: [Any][MySQL] tVip (2.2 | 05-03-19) - The simplest to use Vip Manager
Reply With Quote #233

Can someone help me?

PHP Code:
L 02/07/2020 15:05:16: [SMException reportedInvalid database Handle 0 (error4)
L 02/07/2020 15:05:16: [SMBlamingtVip.smx
L 02
/07/2020 15:05:16: [SMCall stack trace:
L 02/07/2020 15:05:16: [SM]   [0SQL_SetCharset
L 02
/07/2020 15:05:16: [SM]   [1Line 56D:\CSGOServer1\csgo\addons\sourcemod\scripting\tVip.sp::OnPluginStart
L 02
/07/2020 15:05:16: [SMUnable to load plugin "tVip.smx"Error detected in plugin startup (see error logs
gildevanaraujo is offline
flashing
Senior Member
Join Date: Jul 2019
Location: India
Old 02-07-2020 , 13:20   Re: [Any][MySQL] tVip (2.2 | 05-03-19) - The simplest to use Vip Manager
Reply With Quote #234

Quote:
Originally Posted by gildevanaraujo View Post
Can someone help me?

PHP Code:
L 02/07/2020 15:05:16: [SMException reportedInvalid database Handle 0 (error4)
L 02/07/2020 15:05:16: [SMBlamingtVip.smx
L 02
/07/2020 15:05:16: [SMCall stack trace:
L 02/07/2020 15:05:16: [SM]   [0SQL_SetCharset
L 02
/07/2020 15:05:16: [SM]   [1Line 56D:\CSGOServer1\csgo\addons\sourcemod\scripting\tVip.sp::OnPluginStart
L 02
/07/2020 15:05:16: [SMUnable to load plugin "tVip.smx"Error detected in plugin startup (see error logs
Check the database connection and do this
https://forums.alliedmods.net/showpo...&postcount=231

Last edited by flashing; 02-07-2020 at 13:22.
flashing is offline
gildevanaraujo
Senior Member
Join Date: Oct 2018
Location: Brazil
Old 02-07-2020 , 13:39   Re: [Any][MySQL] tVip (2.2 | 05-03-19) - The simplest to use Vip Manager
Reply With Quote #235

Quote:
Originally Posted by flashing View Post
Check the database connection and do this
https://forums.alliedmods.net/showpo...&postcount=231
I redid the database but the problem still continues.

I checked line [56] and found it here.

PHP Code:
53) public void OnPluginStart() {
    
54 )char error[255];
    
55g_DB SQL_Connect(dbconfigtrueerrorsizeof(error));
    
56SQL_SetCharset(g_DB"utf8"); 
EDIT: Solved! Thank you bro!

Last edited by gildevanaraujo; 02-07-2020 at 13:44. Reason: solved
gildevanaraujo is offline
s0xx
New Member
Join Date: Mar 2020
Old 03-15-2020 , 14:00   Re: [Any][MySQL] tVip (2.2 | 05-03-19) - The simplest to use Vip Manager
Reply With Quote #236

[CODE]L 03/15/2020 - 17:47:13: [SM] Exception reported: Invalid database Handle 0 (error: 4)
L 03/15/2020 - 17:47:13: [SM] Blaming: tVip.smx
L 03/15/2020 - 17:47:13: [SM] Call stack trace:
L 03/15/2020 - 17:47:13: [SM] [0] SQL_SetCharset
L 03/15/2020 - 17:47:13: [SM] [1] Line 56, C:\Users\ziegl\Dropbox\SourcePawnSP\Products\ tVIP\tVip\tVip.sp::OnPluginStart
L 03/15/2020 - 17:47:13: [SM] Unable to load plugin "tVip.smx": Error detected in plugin startup (see error logs)
L 03/15/2020 - 17:47:15: [SM] Exception reported: Cannot connect to datbase error: [2003]: Can't connect to MySQL server on 'localhost' (10061)

anyone know how to fix?

Last edited by s0xx; 03-15-2020 at 14:00.
s0xx is offline
flashing
Senior Member
Join Date: Jul 2019
Location: India
Old 03-16-2020 , 01:08   Re: [Any][MySQL] tVip (2.2 | 05-03-19) - The simplest to use Vip Manager
Reply With Quote #237

Quote:
Originally Posted by s0xx View Post
[CODE]L 03/15/2020 - 17:47:13: [SM] Exception reported: Invalid database Handle 0 (error: 4)
L 03/15/2020 - 17:47:13: [SM] Blaming: tVip.smx
L 03/15/2020 - 17:47:13: [SM] Call stack trace:
L 03/15/2020 - 17:47:13: [SM] [0] SQL_SetCharset
L 03/15/2020 - 17:47:13: [SM] [1] Line 56, C:\Users\ziegl\Dropbox\SourcePawnSP\Products\ tVIP\tVip\tVip.sp::OnPluginStart
L 03/15/2020 - 17:47:13: [SM] Unable to load plugin "tVip.smx": Error detected in plugin startup (see error logs)
L 03/15/2020 - 17:47:15: [SM] Exception reported: Cannot connect to datbase error: [2003]: Can't connect to MySQL server on 'localhost' (10061)

anyone know how to fix?
make sure you have configured the database connection properly in the database.cfg file
also it seems your mysql server is on the same machine with your game server if its true try using "127.0.0.1" instead of "localhost" in the host field.
__________________

        Discord: FLASHING#8548
              Steam

Last edited by flashing; 03-16-2020 at 01:10.
flashing is offline
bloodmodii
Member
Join Date: Jun 2016
Old 04-16-2020 , 23:46   Re: [Any][MySQL] tVip (2.2 | 05-03-19) - The simplest to use Vip Manager
Reply With Quote #238

Hello everyone,
I'm having an issue with the V.I.P on my server, they're trying to join my server but each time they connect when it is full it says "dropped due to slot reservations" I checked in the console using !who and they definetely have the reserved slot flag. I don't understand
sm_reserve_type 1


sm_reserved_slots 1


sm_hide_slots 0.
Also I am using TVIP plugins to add vip on the server more easily, I thought it would be the issue but the vip do have their reserved flag so it shouldn't be a problem of compatibility between tvip and the reservedslot plugins from sourcemod, right?

Last edited by bloodmodii; 04-16-2020 at 23:46.
bloodmodii is offline
flashing
Senior Member
Join Date: Jul 2019
Location: India
Old 04-17-2020 , 11:45   Re: [Any][MySQL] tVip (2.2 | 05-03-19) - The simplest to use Vip Manager
Reply With Quote #239

Quote:
Originally Posted by bloodmodii View Post
Hello everyone,
I'm having an issue with the V.I.P on my server, they're trying to join my server but each time they connect when it is full it says "dropped due to slot reservations" I checked in the console using !who and they definetely have the reserved slot flag. I don't understand
sm_reserve_type 1


sm_reserved_slots 1


sm_hide_slots 0.
Also I am using TVIP plugins to add vip on the server more easily, I thought it would be the issue but the vip do have their reserved flag so it shouldn't be a problem of compatibility between tvip and the reservedslot plugins from sourcemod, right?
you can this plugin for better support for reserved slots
https://forums.alliedmods.net/showthread.php?t=306760
__________________

        Discord: FLASHING#8548
              Steam
flashing is offline
bloodmodii
Member
Join Date: Jun 2016
Old 04-17-2020 , 19:50   Re: [Any][MySQL] tVip (2.2 | 05-03-19) - The simplest to use Vip Manager
Reply With Quote #240

Do we have to remove the reservedslot.smx included in the default sourcemod install? Or can we keep it in the plugins folder?
bloodmodii is offline
Reply


Thread Tools
Display Modes

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 18:27.


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