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.


