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

B_R

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

Salamon75

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'

Totenfluch

Quote:

Originally Posted by B_R

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

Totenfluch

Quote:

Originally Posted by Salamon75

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?

Veckia · *Last edited by Veckia; 08-02-2018 at 10:56.*

I think this link answers him.

Tell us if it worked.

Thanks.

Groven

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

Totenfluch

Quote:

Originally Posted by Groven

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

Groven

Quote:

Originally Posted by Totenfluch

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"
	}

Totenfluch

Quote:

Originally Posted by Groven

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.

Groven · *Last edited by Groven; 08-06-2018 at 15:50.*

Quote:

Originally Posted by Totenfluch

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)