36 lines
2.0 KiB
Markdown
36 lines
2.0 KiB
Markdown
url: https://github.com/nuclearsilo583/zephyrus-store-preview-new-syntax
|
|
what is changed?
|
|
|
|
store/sql.sp and store/db.sp
|
|
char m_szQuery[1024]; buffer size 512 is not enough. this is related to the query
|
|
Format(STRING(m_szQuery), "CREATE TABLE IF NOT EXISTS `%s` (\
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,\
|
|
`parent_id` int(11) NOT NULL DEFAULT '-1',\
|
|
`item_price` int(32) NOT NULL,\
|
|
`item_type` varchar(64) NOT NULL,\
|
|
`item_flag` varchar(64) NOT NULL,\
|
|
`item_name` varchar(64) NOT NULL,\
|
|
`additional_info` text NOT NULL,\
|
|
`item_status` tinyint(1) NOT NULL,\
|
|
`supported_game` varchar(64) NOT NULL,\
|
|
PRIMARY KEY (`id`)\
|
|
) ENGINE=InnoDB AUTO_INCREMENT=0 CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci", g_eCvars[g_cvarItemsTable].sCache);
|
|
|
|
|
|
|
|
not executing the query
|
|
|
|
DELETE store_items, store_equipment "
|
|
... "FROM store_items, store_equipment "
|
|
... "WHERE store_items.unique_id = store_equipment.unique_id "
|
|
... "AND store_items.player_id = store_equipment.player_id "
|
|
... "AND store_items.date_of_expiration != 0 "
|
|
... "AND store_items.date_of_expiration < %d", GetTime());
|
|
|
|
DELETE FROM store_items WHERE date_of_expiration != 0 AND date_of_expiration < %d
|
|
because its performing bad, also all our stuff is permanent.
|
|
|
|
fuck these jewish niggers edit to the include/zephstocks file, they added tabbing inside quotes that fuck up compiling when retabbing the indentation of the whole file.
|
|
|
|
|