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

AlliedModders (https://forums.alliedmods.net/index.php)

- Plugins (https://forums.alliedmods.net/forumdisplay.php?f=108)

- - [Any][MySQL] tVip (2.3 | 04-04-21) - The simplest to use Vip Manager (https://forums.alliedmods.net/showthread.php?t=292183)

Re: [Any][MySQL] tVip (2.1 | 27-06-17) - The simplest to use Vip Manager

Hi, could be any possible way to add vips with different flags in the mysql table ?

Re: [Any][MySQL] tVip (2.1 | 27-06-17) - The simplest to use Vip Manager

For me it doesn't create the sql table automatically.
I tried to run the script from the source but getting this:
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 '0000-00-00 00:00:00',
`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

MySQL said: Documentation
#1067 - Invalid default value for 'enddate'

Re: [Any][MySQL] tVip (2.1 | 27-06-17) - The simplest to use Vip Manager

Quote:

Originally Posted by B_R (Post 2579779)

Hi, could be any possible way to add vips with different flags in the mysql table ?

Someone requested that in private and it was doable. But I didn't want it for this plugin to keep things simple. So no

Re: [Any][MySQL] tVip (2.1 | 27-06-17) - The simplest to use Vip Manager

Quote:

Originally Posted by Salamon75 (Post 2579872)

MySQL said: Documentation
#1067 - Invalid default value for 'enddate'

I tested it for both linux and windows on MariaDB and MySQL. What are you using?

Re: [Any][MySQL] tVip (2.1 | 27-06-17) - The simplest to use Vip Manager

I think this link answers him.

Tell us if it worked.

Thanks.

Re: [Any][MySQL] tVip (2.1 | 27-06-17) - The simplest to use Vip Manager

Is there a way to add so only Vips can use https://forums.alliedmods.net/showthread.php?t=276677 ?

Re: [Any][MySQL] tVip (2.1 | 27-06-17) - The simplest to use Vip Manager

Quote:

Originally Posted by Groven (Post 2608661)

Is there a way to add so only Vips can use https://forums.alliedmods.net/showthread.php?t=276677 ?

Use the Flag parameter within your items.txt in zephstore. Nothing to change in tVip

Re: [Any][MySQL] tVip (2.1 | 27-06-17) - The simplest to use Vip Manager

Quote:

Originally Posted by Totenfluch (Post 2608671)

Use the Flag parameter within your items.txt in zephstore. Nothing to change in tVip

Thanks,

I tried to start tVip but it dosen't let me.

Code:

        "tVip"

        {

                "driver"                        "mysql"

                "host"                                "localhost"

                "database"                        "db49"

                "user"                                "removed"

                "pass"                                "removed"

                //"timeout"                        "0"

                "port"                        "3306"

        }

Re: [Any][MySQL] tVip (2.1 | 27-06-17) - The simplest to use Vip Manager

Quote:

Originally Posted by Groven (Post 2608675)

Thanks,

I tried to start tVip but it dosen't let me.

Code:

        "tVip"

        {

                "driver"                        "mysql"

                "host"                                "localhost"

                "database"                        "db49"

                "user"                                "removed"

                "pass"                                "removed"

                //"timeout"                        "0"

                "port"                        "3306"

        }

Please post the relevant errors. You can find them in the generic error logs.

Re: [Any][MySQL] tVip (2.1 | 27-06-17) - The simplest to use Vip Manager

Quote:

Originally Posted by Totenfluch (Post 2608677)

Please post the relevant errors. You can find them in the generic error logs.

Here you go

I think I found another problem. I use KZTimer and added these to the

Code:

exception_list

But when I click on Add Vip I recieve this

Code:

No matching clients found (Noone there or everyone is already VIP/Admin)

Or is that because I am Admin and alone on the server?

Code:

sm_tvip

sm_vips

sm_vip

sm_addvip

sm_removevip

Edit: I fixed it. I switched back to localhost instead of IP.

Code:

L 08/06/2018 - 20:39:33: [SM] Exception reported: Invalid database Handle 0 (error: 4)

L 08/06/2018 - 20:39:33: [SM] Blaming: tvip.smx

L 08/06/2018 - 20:39:33: [SM] Call stack trace:

L 08/06/2018 - 20:39:33: [SM]   [0] SQL_SetCharset

L 08/06/2018 - 20:39:33: [SM]   [1] Line 55, C:\Users\ziegl\Downloads\tVip-master\tVip.sp::OnPluginStart

L 08/06/2018 - 20:39:33: [SM] Unable to load plugin "tvip.smx": Error detected in plugin startup (see error logs)