Raised This Month: $110 Target: $400
 27% 

[CS:GO] Weapon Stickers (!stickers)


Post New Thread Reply   
 
Thread Tools Display Modes
paulo_crash
AlliedModders Donor
Join Date: May 2016
Location: Brazil
Old 09-23-2021 , 16:42   Re: [CS:GO] Weapon Stickers (!stickers)
Reply With Quote #251

Quote:
Originally Posted by deko_fps View Post
Thanks. I deleted and created a new one, now it's working again.
Good.

If you need the new version with the new stickers.
Attached Files
File Type: zip Weapon.Stickers.v1.0.20.zip (216.7 KB, 174 views)
paulo_crash is offline
deko_fps
Junior Member
Join Date: Sep 2021
Old 09-23-2021 , 17:57   Re: [CS:GO] Weapon Stickers (!stickers)
Reply With Quote #252

Quote:
Originally Posted by paulo_crash View Post
Good.

If you need the new version with the new stickers.
That was quick, thanks a lot!
It's working perfectly, altough I had to recreate my mysql db once again. I'm not very experienced with SQL nor plugins at all. Is there anyway to save everyone's settings? Or will I have to reset the db on every plugin update?
deko_fps is offline
paulo_crash
AlliedModders Donor
Join Date: May 2016
Location: Brazil
Old 09-23-2021 , 18:24   Re: [CS:GO] Weapon Stickers (!stickers)
Reply With Quote #253

Quote:
Originally Posted by deko_fps View Post
That was quick, thanks a lot!
It's working perfectly, altough I had to recreate my mysql db once again. I'm not very experienced with SQL nor plugins at all. Is there anyway to save everyone's settings? Or will I have to reset the db on every plugin update?
If you did everything right, I update before with the script I sent you above I wouldn't need it, so I believe.
paulo_crash is offline
mhcsgo
Junior Member
Join Date: Dec 2019
Old 10-22-2021 , 02:31   Re: [CS:GO] Weapon Stickers (!stickers)
Reply With Quote #254

Hi, does anybody update the offlined eItems.json for the Stockholm Major stickers? Thanks in advance.

BTW, is there any way to generate the json after new updates?
mhcsgo is offline
MichaelKosa
Junior Member
Join Date: Apr 2018
Location: Poland
Old 10-22-2021 , 06:39   Re: [CS:GO] Weapon Stickers (!stickers)
Reply With Quote #255

@paulo_crash Please update Stockholm Major stickers
__________________
MichaelKosa is offline
starcs
Member
Join Date: Nov 2018
Old 10-23-2021 , 18:34   Re: [CS:GO] Weapon Stickers (!stickers)
Reply With Quote #256

Quote:
Originally Posted by MichaelKosa View Post
@paulo_crash Please update Stockholm Major stickers
This is a unnofficial update, but it's working.
Credits to: WE3CS
Attached Files
File Type: zip Weapon Stickers [STOCKHOLM 2021 UPDATE].zip (334.6 KB, 72 views)
__________________
Founder of ⭐ STRTEAM
starcs is offline
paulo_crash
AlliedModders Donor
Join Date: May 2016
Location: Brazil
Old 10-23-2021 , 21:49   Re: [CS:GO] Weapon Stickers (!stickers)
Reply With Quote #257

Quote:
Originally Posted by mhcsgo View Post
Hi, does anybody update the offlined eItems.json for the Stockholm Major stickers? Thanks in advance.

BTW, is there any way to generate the json after new updates?
Quote:
Originally Posted by MichaelKosa View Post
@paulo_crash Please update Stockholm Major stickers
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.
Attached Files
File Type: zip CSGO Weapon Stickers v1.2.zip (170.2 KB, 76 views)

Last edited by paulo_crash; 10-24-2021 at 11:00.
paulo_crash is offline
SmokieCS
AlliedModders Donor
Join Date: Nov 2019
Location: Denmark
Old 10-24-2021 , 09:10   Re: [CS:GO] Weapon Stickers (!stickers)
Reply With Quote #258

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

PHP Code:
L 10/24/2021 14:09:57: [SMCall stack trace:
L 10/24/2021 14:09:57: [SM]   [0DBResultSet.FetchFloat
L 10
/24/2021 14:09:57: [SM]   [1Line 350quasemago/csgo_weaponstickers/database.inc::SQLCallback_LoadClientData 
This results in the DB not saving latest edits. I have tried to find a solution, but nothing has seamed to work yet.


SOLVED! - Had to flush my DB for it to work again.
__________________
Server Manager & Chairman of the Board - https://esportharte.dk/
Freelance Server Support
Former Co-Owner - https://tfrag.dk/

Last edited by SmokieCS; 10-24-2021 at 09:22. Reason: Solved
SmokieCS is offline
tenzix
New Member
Join Date: Oct 2021
Old 10-24-2021 , 10:17   [CS:GO] Weapon Stickers (!stickers)
Reply With Quote #259

L 10/24/2021 - 21:15:55: [csgo_weaponstickers.smx] (WeaponStickers) Connection to database failed: [2059]: Authentication plugin 'caching_sha2_password' cannot be loaded: The specified module could not be found.


I'm new to this plugin, need help! Thanks.
tenzix is offline
paulo_crash
AlliedModders Donor
Join Date: May 2016
Location: Brazil
Old 10-24-2021 , 11:01   Re: [CS:GO] Weapon Stickers (!stickers)
Reply With Quote #260

Quote:
Originally Posted by SmokieCS View Post


I get these failures after updating.

PHP Code:
L 10/24/2021 14:09:57: [SMCall stack trace:
L 10/24/2021 14:09:57: [SM]   [0DBResultSet.FetchFloat
L 10
/24/2021 14:09:57: [SM]   [1Line 350quasemago/csgo_weaponstickers/database.inc::SQLCallback_LoadClientData 
This results in the DB not saving latest edits. I have tried to find a solution, but nothing has seamed to work yet.


SOLVED! - Had to flush my DB for it to work again.
Sorry, I've updated my comment for anyone with a database error.

https://forums.alliedmods.net/showpo...&postcount=257
paulo_crash 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 17:22.


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