cs-gejmerzy / vip-plugin Goto Github PK

After today CS update version 1.40.0.4, plugin v1.0.25 doesn't work.
Older versions crashed server when VIP user join to team.

Unable to initialize databases

Players is created fine and populated as intended. Services is throwing an error:

22:11:52 [EROR] (plugin:VIP Plugin) Error while initializing database: System.Exception: Encountered exception while creating tables
 ---> System.Exception: Error executing SQL command: 
            CREATE TABLE IF NOT EXISTS Services (
            id INT PRIMARY KEY AUTO_INCREMENT,
            availability INT DEFAULT 2,
            player_id INT NOT NULL,
            start_date TIMESTAMP,
            end_date TIMESTAMP,
            flags VARCHAR(255),
            group_id VARCHAR(64),
            notes TEXT,
            FOREIGN KEY (player_id) REFERENCES Players(id)
            );
 ---> MySqlConnector.MySqlException (0x80004005): Invalid default value for 'end_date'
   at MySqlConnector.Core.ServerSession.ReceiveReplyAsync(IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/ServerSession.cs:line 885

Don't have VS up and running but I'm guessing setting TIMESTAMP DEFAULT CURRENT_TIMESTAMP as you do with Players lastconnect would fix it. Probably some issue with the hosting provider's SQL settings regarding the default values? Not sure tbh.

Hello, a few more tips for you, it'd be awesome if you'd add these:

-viptest (!viptest) instead of -randomvip, so if someone enters the command, e.g. You will receive a vip for 20 minutes (a group that we set up), and this command, e.g. allows a player to use it max 2x a week
-if a vip player enters the !vip command, an html menu will appear in which you can see which group you are in / so it shows the name of the group (eg smallvip, plusvip, whatever you set) and you can see what functions your vip group has (eg. bhop) and you can even select these in the menu so you can disable one by one if you don't want one function (so you can disable bhop for yourself)
-16000$ for the vip in every rounds

Share your plugin in cssharp discord and more players will see your excellent plugin: https://discord.com/invite/eAZU3guKWU

Hi, is that possible to add these functions?:

• Bhop
• HP regen
• Armor regen
• Instant plant + defuse

Describe the bug
Upon using the css commands for service disable/delete, the changes are not reflected until the server is restarted, athough the changes are correctly done in the database.

To Reproduce
Delete or disable a service from the ingame console.

Expected behavior
The given player's VIP service is disabled or deleted and the changes are reflected on the spot or at least upon reconnect.

Software:

• OS: Linux
• plugin version: Latest
• metamod version: Latest
• CSS version: Latest

Hello,

"Spawn": {
"HP": 220,

This doesn't work.

Hello, we have a jailbreak server and every round weapons, zeus, health etc. is removed by plugin. If you add delay option to give hp, taser etc. we can fix this problem.

"DefuseKit": true, setting dosn't work.
VIP-Plugin v1.0.21, CSS v202

Is it possible to add ogarniczenie for two functions in the pistol round "HP": 105, "ArmorValue": 100, so that does not add them

Describe the bug

ExtraJumps as it did not work before, it still does not work at all.
No matter what value you put in there it's still not working.
IF you compile it manually it's not working as well.

If you change the whole extra jump code, to double jump it's working fine.

Tested on multiple server hosts, still same thing

Software:

• OS: Linux
• plugin version : Latest
• metamod version : Latest
• CSS version : Latest

Additional context
Add any other context about the problem here.

 Error while loading player data on join: System.InvalidCastException: Unable to convert MySQL date/time to System.DateTime, set AllowZeroDateTime=True or ConvertZeroDateTime=True in the connection string. See https://mysqlconnector.net/connection-options/
   at MySqlConnector.ColumnReaders.TextDateTimeColumnReader.ParseDateTime(ReadOnlySpan`1 data, Boolean convertZeroDateTime, Boolean allowZeroDateTime, DateTimeKind dateTimeKind) in /_/src/MySqlConnector/ColumnReaders/TextDateTimeColumnReader.cs:line 40
   at MySqlConnector.Core.Row.GetValue(Int32 ordinal) in /_/src/MySqlConnector/Core/Row.cs:line 94
   at MySqlConnector.Core.Row.GetDateTime(Int32 ordinal) in /_/src/MySqlConnector/Core/Row.cs:line 329
   at Core.Managers.DatabaseManager.GetPlayerServices(Int32 playerId, ServiceAvailability availability) in /home/runner/work/VIP-Plugin/VIP-Plugin/src/Managers/DatabaseManager.cs:line 136
   at Core.Models.PlayerData.LoadData(CCSPlayerController player, GroupManager groupManager, DatabaseManager databaseManager) in /home/runner/work/VIP-Plugin/VIP-Plugin/src/Models/PlayerData.cs:line 72
   at Core.Plugin.<>c__DisplayClass9_1.<<EventPlayerConnectFull>b__1>d.MoveNext() in /home/runner/work/VIP-Plugin/VIP-Plugin/src/Events.cs:line 38 

i tried everything 2 days ago vip was working very well After update everything is down...

Hello, is there a way to make the VIP's get their bonuses in later rounds like get armor health in 2-3 round?

Hello where i can contact you ?

Do you intend on implementing slot reservations for the VIP players?

1. If "ExtraJumps": 0, is set to more than 0
   Players models are bugged (floating) in the AIR.
   And it does not work :D

2. Grenade system sucks, as it drops grenades if player arleady have them on the spawn. So unlimited grenades for other players.

3. Even thought RandomVIP is disabled. It's still assigning random VIP ( didin't test nigh vip tho)
   "RandomVIP": {
   "Enabled ": false,
   "AfterRound ": 3,
   "MinimumPlayers ": 2,
   "RepeatPicking ": 3,
   "PermissionsGranted ": [],
   "PermissionExclude": []
   },

4. Organize config file, it's quite a mess, make it more readable and easier to work with. Make sections for player spawn bonuses, events, weapons, messages, and other like misc.

• Double jump
• Healthshot on spawn
• Show damage given
• Reset score
• Reserved slot

Main problem now of plugin is for Retakes or DM server is when you spawned VIP plugin switch gun from primary, to secondary or from secondary to knife. This is very annoying :(

Money are not stacking correctly. After round ends at the next round start you have to buy and sell a gun to take all money.

Also I think i'm getting segmentation fault sometimes.

Adding feature for colored smoke will be nice as an option :]
M1Kac have separated plugin, but still doesn't work for flag permission.
https://github.com/M1Kac/Simple-ColoredSmoke/blob/main/Simple%20ColoredSmoke/ColoredSmoke.cs

Can you add a team option to this plugin so that VIP system can only be used by the T or CT team?

When you set in config "Zeus": false, you still get Zeus on spawn.
VIP Plugin v1.0.4
CSSharp v195
Linux