Raised This Month: $218 Target: $400
 54% 

[Any][MySQL] tVip (2.2 | 05-03-19) - The simplest to use Vip Manager


Post New Thread Reply   
 
Thread Tools Display Modes
flashing
Member
Join Date: Jul 2019
Location: Delhi, India
Old 01-21-2020 , 13:56   Re: [Any][MySQL] tVip (2.2 | 05-03-19) - The simplest to use Vip Manager
Reply With Quote #231

Quote:
Originally Posted by Sincronic View Post
The funny thing is that in my logs folder i don't find anything. Where i should search ?

My database config is corect.

Code:
        "tVip"
        {
        "driver"                "mysql"
        "host"                  "xxxxxxxxxxxxxx"
        "database"              "xxxxxxxxxxxxxxx"
        "user"                  "xxxxxxxxxxxxxxxxxxx"
        "pass"                  "xxxxxxxxxxxx"
        //"timeout"             "0"
        "port"                  "3306"
Errors will be in logs folder errorlog<d/m/y>
And make sure you have done the following:

SET SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';

Make the required tables in the database:
Quote:
CREATE TABLE IF NOT EXISTS `tVip` (
`Id` bigint(20) NOT NULL AUTO_INCREMENT,
`timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`playername` varchar(36) COLLATE utf8_bin NOT NULL,
`playerid` varchar(20) COLLATE utf8_bin NOT NULL,
`enddate` timestamp NOT NULL DEFAULT '2000-01-01 20:20:20',
`admin_playername` varchar(36) COLLATE utf8_bin NOT NULL,
`admin_playerid` varchar(20) COLLATE utf8_bin NOT NULL,
PRIMARY KEY (`Id`),
UNIQUE KEY `playerid` (`playerid`)
) ENGINE = InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

Last edited by flashing; 01-21-2020 at 14:05.
flashing is offline
Sincronic
Senior Member
Join Date: Dec 2018
Old 01-21-2020 , 15:18   Re: [Any][MySQL] tVip (2.2 | 05-03-19) - The simplest to use Vip Manager
Reply With Quote #232

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 18:01.
Sincronic is offline
flashing
Member
Join Date: Jul 2019
Location: Delhi, India
Old 01-22-2020 , 00:30   Re: [Any][MySQL] tVip (2.2 | 05-03-19) - The simplest to use Vip Manager
Reply With Quote #233

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 , 14:16   Re: [Any][MySQL] tVip (2.2 | 05-03-19) - The simplest to use Vip Manager
Reply With Quote #234

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
Member
Join Date: Jul 2019
Location: Delhi, India
Old 02-07-2020 , 14:20   Re: [Any][MySQL] tVip (2.2 | 05-03-19) - The simplest to use Vip Manager
Reply With Quote #235

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 14:22.
flashing is offline
gildevanaraujo
Senior Member
Join Date: Oct 2018
Location: Brazil
Old 02-07-2020 , 14:39   Re: [Any][MySQL] tVip (2.2 | 05-03-19) - The simplest to use Vip Manager
Reply With Quote #236

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 14:44. Reason: solved
gildevanaraujo 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 15:01.


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