View Single Post
paulo_crash
AlliedModders Donor
Join Date: May 2016
Location: Brazil
Old 09-21-2021 , 22:26   Re: [CS:GO] Weapon Stickers (!stickers)
Reply With Quote #248

Quote:
Originally Posted by deko_fps View Post
works great, thank you!

*Edit:
Actually I've a problem. Everytime I reconnect from server, the stickers I've setted are gone... Before updating, everything was alright.
Can you help me solve this @paulo_crash?
Error log?

In any case it seems to be an error in your database, try deleting the database and creating a new one.

Or try running a query against your stickers 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',
            
PRIMARY KEY (`id`),
            
UNIQUE KEY (`steamid`, `weaponindex`)
            ) 
ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci

Last edited by paulo_crash; 09-21-2021 at 22:26.
paulo_crash is offline