View Single Post
paulo_crash
AlliedModders Donor
Join Date: May 2016
Location: Brazil
Old 01-27-2022 , 10:13   Re: [CS:GO] Weapon Stickers (!stickers)
Reply With Quote #309

Here is the latest version, everything updated, just upload it to the server.

Remember to remove previous eItems from the server so there is no error, delete the plugin and resubmit.

CSGO Weapon Stickers.zip

If you need the fix for the database, just run this script:
PHP Code:
CREATE TABLE IF NOT EXISTS `weaponstickers1` (
            `
idINT NOT NULL AUTO_INCREMENT,
            `
steamidvarchar(64COLLATE utf8mb4_unicode_ci NOT NULL,
            `
weaponindexint(11NOT NULL DEFAULT '0',
            `
slot0int(11NOT NULL DEFAULT '0',
            `
slot1int(11NOT NULL DEFAULT '0',
            `
slot2int(11NOT NULL DEFAULT '0',
            `
slot3int(11NOT NULL DEFAULT '0',
            `
slot4int(11NOT NULL DEFAULT '0',
            `
slot5int(11NOT NULL DEFAULT '0',
            `
wear0float4 NOT NULL DEFAULT '0.000000',
            `
wear1float4 NOT NULL DEFAULT '0.000000',
            `
wear2float4 NOT NULL DEFAULT '0.000000',
            `
wear3float4 NOT NULL DEFAULT '0.000000',
            `
wear4float4 NOT NULL DEFAULT '0.000000',
            `
wear5float4 NOT NULL DEFAULT '0.000000',
            `
rotation0float4 NOT NULL DEFAULT '0.000',
            `
rotation1float4 NOT NULL DEFAULT '0.000',
            `
rotation2float4 NOT NULL DEFAULT '0.000',
            `
rotation3float4 NOT NULL DEFAULT '0.000',
            `
rotation4float4 NOT NULL DEFAULT '0.000',
            `
rotation5float4 NOT NULL DEFAULT '0.000',
            `
last_seenint(11NOT NULL DEFAULT '0'
            
PRIMARY KEY (`id`),
            
UNIQUE KEY (`steamid`, `weaponindex`)
            ) 
ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
paulo_crash is offline