· 8 years ago · Aug 24, 2018, 02:34 AM
1//function call
2DB::loadSQLFile($MODULE_NAME, 'shop_module.sql');
3
4//error
5ERROR [Core] Invalid SQL file name: 'shop_module.sql' for module: 'SHOP_MODULE'! Only numbers, letters, and underscores permitted!
6
7
8//SQL file
9CREATE TABLE IF NOT EXISTS `sm_shops` (`ID` int(11) NOT NULL, `MAID` int(11) NOT NULL);
10CREATE TABLE IF NOT EXISTS `sm_alts` (`UID` int(11) NOT NULL, `SID` int(11) NOT NULL, `NAME` tinytext NOT NULL);
11CREATE TABLE IF NOT EXISTS `sm_items` (`ITEMREF` tinytext NOT NULL, `CATEGORY` int(11) NOT NULL);