Raised This Month: $12 Target: $400
 3% 

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


Post New Thread Reply   
 
Thread Tools Display Modes
Voya
Junior Member
Join Date: Dec 2018
Old 03-03-2019 , 19:11   Re: [Any][MySQL] tVip (2.1 | 27-06-17) - The simplest to use Vip Manager
Reply With Quote #201

My console gets auto spammed with this.

03/03/2019 - 17:54:10: [SM] [1] Line 605, C:\Users\ziegl\Dropbox\SourcePawnSP\Products\ tVIP\tVip\tVip.sp::SQLListVIPsQuery
L 03/03/2019 - 17:57:06: [tVip (5).smx] Table 'lcsurf_tvip2.tVip' doesn't exist
L 03/03/2019 - 17:57:06: [SM] Exception reported: Invalid query Handle 0 (error: 4)
L 03/03/2019 - 17:57:06: [SM] Blaming: tVip (5).smx
L 03/03/2019 - 17:57:06: [SM] Call stack trace:
L 03/03/2019 - 17:57:06: [SM] [0] SQL_FetchRow
L 03/03/2019 - 17:57:06: [SM] [1] Line 483, C:\Users\ziegl\Dropbox\SourcePawnSP\Products\ tVIP\tVip\tVip.sp::SQLCheckVIPQuery
L 03/03/2019 - 17:58:02: [tVip (5).smx] Table 'lcsurf_tvip2.tVip' doesn't exist
L 03/03/2019 - 17:58:02: [tVip (5).smx] Table 'lcsurf_tvip2.tVip' doesn't exist

there is a database named tVip. im not sure why its not working. it used to before.
Voya is offline
randomusername
Junior Member
Join Date: Feb 2019
Old 03-04-2019 , 01:47   Re: [Any][MySQL] tVip (2.1 | 27-06-17) - The simplest to use Vip Manager
Reply With Quote #202

Quote:
Originally Posted by gildevanaraujo View Post
Try !addvip "STEAM_1:0:1675908" "testVip" "Trum" (in game).
sm_addvip "STEAM_1:0:1675908" "testVip" "Trum" (console).
I to get this exact issue

Last edited by randomusername; 03-04-2019 at 01:47.
randomusername is offline
Totenfluch
AlliedModders Donor
Join Date: Jan 2012
Location: Germany
Old 03-05-2019 , 10:20   Re: [Any][MySQL] tVip (2.1 | 27-06-17) - The simplest to use Vip Manager
Reply With Quote #203

Quote:
Originally Posted by randomusername View Post
I to get this exact issue
I mean the syntax is still wrong.


use

PHP Code:
sm_addvip "<SteamID>" <Duration in Month"<Name>" [0=Month,1=Minutes
run the command in your client console, then run sm_who on the given user.
If you did not receive the expected result then post your console output IN FULL here.

PHP Code:
sm_addvip "STEAM_1:0:1675908" 60 "Trum" 
^ Gives the User 60 Minutes of Vip


PHP Code:
sm_addvip "STEAM_1:0:1675908" 60 "Trum" 
^ Gives the User 60 Month of Vip


PHP Code:
sm_addvip "STEAM_1:0:1675908" 1440 "Trum" 
^ Gives the User 1440 Minutes (24h = 1 day) of Vip
__________________
Notable Projects:
Event Item Spawner | Scissors, Rock, Paper for ZephStore
tVip | Smart Link Remover
PLG & GGC - CS:GO Roleplay

and countless more...

I can make a helicopter shoot missles if you want me to...

Last edited by Totenfluch; 03-05-2019 at 10:22.
Totenfluch is offline
Totenfluch
AlliedModders Donor
Join Date: Jan 2012
Location: Germany
Old 03-05-2019 , 10:29   Re: [Any][MySQL] tVip (2.1 | 27-06-17) - The simplest to use Vip Manager
Reply With Quote #204

Quote:
Originally Posted by Voya View Post
My console gets auto spammed with this.

03/03/2019 - 17:54:10: [SM] [1] Line 605, C:\Users\ziegl\Dropbox\SourcePawnSP\Products\ tVIP\tVip\tVip.sp::SQLListVIPsQuery
L 03/03/2019 - 17:57:06: [tVip (5).smx] Table 'lcsurf_tvip2.tVip' doesn't exist
L 03/03/2019 - 17:57:06: [SM] Exception reported: Invalid query Handle 0 (error: 4)
L 03/03/2019 - 17:57:06: [SM] Blaming: tVip (5).smx
L 03/03/2019 - 17:57:06: [SM] Call stack trace:
L 03/03/2019 - 17:57:06: [SM] [0] SQL_FetchRow
L 03/03/2019 - 17:57:06: [SM] [1] Line 483, C:\Users\ziegl\Dropbox\SourcePawnSP\Products\ tVIP\tVip\tVip.sp::SQLCheckVIPQuery
L 03/03/2019 - 17:58:02: [tVip (5).smx] Table 'lcsurf_tvip2.tVip' doesn't exist
L 03/03/2019 - 17:58:02: [tVip (5).smx] Table 'lcsurf_tvip2.tVip' doesn't exist

there is a database named tVip. im not sure why its not working. it used to before.
Was fixed by running

Code:
SET SQL_MODE='ALLOW_INVALID_DATES';
in the MySQL Database
__________________
Notable Projects:
Event Item Spawner | Scissors, Rock, Paper for ZephStore
tVip | Smart Link Remover
PLG & GGC - CS:GO Roleplay

and countless more...

I can make a helicopter shoot missles if you want me to...
Totenfluch is offline
ichiballs
Member
Join Date: Oct 2016
Old 03-15-2019 , 17:07   Re: [Any][MySQL] tVip (2.2 | 05-03-19) - The simplest to use Vip Manager
Reply With Quote #205

I'm using this and MyJailbreak and people don't get player tags(myjailbreak playertags) based on flags when i give them VIP through this. Any ideas?
ichiballs is offline
Totenfluch
AlliedModders Donor
Join Date: Jan 2012
Location: Germany
Old 03-18-2019 , 20:17   Re: [Any][MySQL] tVip (2.2 | 05-03-19) - The simplest to use Vip Manager
Reply With Quote #206

Quote:
Originally Posted by ichiballs View Post
I'm using this and MyJailbreak and people don't get player tags(myjailbreak playertags) based on flags when i give them VIP through this. Any ideas?
tags are probably loaded before vip is assigned; nothing you can realy do here
__________________
Notable Projects:
Event Item Spawner | Scissors, Rock, Paper for ZephStore
tVip | Smart Link Remover
PLG & GGC - CS:GO Roleplay

and countless more...

I can make a helicopter shoot missles if you want me to...
Totenfluch is offline
Lubricant Jam
AlliedModders Donor
Join Date: Oct 2016
Location: United Kingdom
Old 03-20-2019 , 16:48   Re: [Any][MySQL] tVip (2.1 | 27-06-17) - The simplest to use Vip Manager
Reply With Quote #207

Quote:
Originally Posted by Totenfluch View Post
There is a flaw with this in regards to if you were to upgrade someone to a higher level then they'd keep the months they "paid" for the lower package in theory abusing the price for the lower package for time then paying once for the higher package.

I hope this makes some sense.

EDIT: We spoke on Steam and sorted this, cheers.
__________________

Last edited by Lubricant Jam; 03-20-2019 at 17:24.
Lubricant Jam is offline
jotaerrecs
Junior Member
Join Date: Mar 2019
Old 03-22-2019 , 12:07   Re: [Any][MySQL] tVip (2.2 | 05-03-19) - The simplest to use Vip Manager
Reply With Quote #208

Hi!

I am having some problems to use the plugin.
I've made a MySQL DB, put the address just like the main post, and nothing happened. The plugin doesn't even seems active. But i put everything where it belongs. What am i doing wrong?

"tVip"
{
"driver" "mysql"
"host" "chlorotic-shocks.000webhostapp.com"
"database" "id9039780_servidorws"
"user" "id9039780_wildfox"
"pass" "****"
//"timeout" "0"
"port" "3306"
}
jotaerrecs is offline
Niklavs
BANNED
Join Date: Nov 2018
Location: https://t.me/pump_upp
Old 04-19-2019 , 15:18   Re: [Any][MySQL] tVip (2.2 | 05-03-19) - The simplest to use Vip Manager
Reply With Quote #209

Flags doesn't work!
I don't get any error logs and command automatically saves data in db.
In cfg:
tVip_flag "0 15 16"
I have these, which should grant a o p flags, but I don't get granted any permissions. I even tried changing map.
Niklavs is offline
Send a message via ICQ to Niklavs Send a message via AIM to Niklavs Send a message via Yahoo to Niklavs
Angeelor
Member
Join Date: Jan 2017
Old 04-22-2019 , 14:16   Re: [Any][MySQL] tVip (2.2 | 05-03-19) - The simplest to use Vip Manager
Reply With Quote #210

Can you make a version where you can choose the flags of each player?


sm_addvip "<SteamID>" <Duration in Month> "<Name>" "<flags>"
Angeelor 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 14:40.


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