View Single Post
kratoss1812
Senior Member
Join Date: May 2018
Location: Romānia
Old 01-26-2022 , 13:39   Re: [CSGO] Case Opening(1.1.0b) DREAMS & NIGHTMARE Case Added. UPDATED 15th Jan. 2022
Reply With Quote #33

Quote:
Originally Posted by chroma1337 View Post
Quote:
Originally Posted by sojio12 View Post
HTML Code:
[SM] Exception reported: Failed to create MySQL tables. Error: "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IF NOT EXISTS `type` INT UNSIGNED NOT NULL DEFAULT 0 AFTER `skinId`' at line 1".
L 01/22/2022 - 22:06:59: [SM] Blaming: csgo_case_opening.smx
L 01/22/2022 - 22:06:59: [SM] Call stack trace:
L 01/22/2022 - 22:06:59: [SM]   [0] SetFailState
L 01/22/2022 - 22:06:59: [SM]   [1] Line 24, inc/db.inc::CreateTables_SQLCallback
i have same thing
This is due your MySQL version. IIRC "ADD AFTER" was added in newer versions. I did this because that column wasn't existing from the start and people that were already using my plugin had the table created without it. I had to find a way to add that column without putting the users through too much effort. This will be fixed in the following update(this week).

Quote:
Originally Posted by manicogaming View Post
You could also add the item found event for when someone unboxes an item, or do you think it would get too spammy?
Short answer: Yes.
Long answer: This plugin already has the open message that is printed for everyone if the skin has a higher rarity, no point in adding found event.

Quote:
Originally Posted by Golbanux View Post
Great work! Can't wait to test it! <3
Thank you! I'm waiting for feedback.

FOR SUPPORT JOIN MY DISCORD: https://discord.gg/ndhn6nH5Hn
__________________
kratoss1812 is offline