View Single Post
zordd
New Member
Join Date: Feb 2021
Old 11-23-2021 , 11:59   Re: [CS:GO] Weapon Stickers (!stickers)
Reply With Quote #294

Quote:
Originally Posted by paulo_crash View Post
Attached is the new version, I didn't get to test it, anything a touch.

[EDIT]
For those who have errors in the database run this script in your sticker database.
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
If rpboelma continues, delete the database completely and create again from scratch.

please send me the new stickers version?
zordd is offline