Leaderboard

View File 553/251 Old Dyes / Palettes Working All Classes (I am not the creator of this set!) Here is an updated version of the well known 553 Clothes Dyes / 251 Hair Dyes Pack. I duplicated the existing palettes from the pack to fill the missing gaps. It now works with 3rd classes, kagerou, oboro, and everything. However, I didn't fix any of the issues in this pack, you may see: - Black Areas on clothes - Ugly colors that doesn't fit ragnarok like flashy yellow - Many palettes which look the same - 3rd classes which doesn't look really good - Blacks Pecos etc.... I made a picture with all the palettes, you can check it. If you want palettes of a better quality, you may want to check My Palleting Services. Thank you! Submitter KamiShi Submitted 12/04/2012 Category Palettes Content Author  

HI everyone! I want to share my script "Personal storage". This will allow each character on the account to have his own personal storage. This script supports 15 characters on the account. Free for use Script: prontera,159,193,4 script Personal storage#prt 113,{ mes "[Personal storage]"; mes "Here, let me open"; mes "your Storage for you."; mes "Thank you for using"; mes "the Kafra Service."; .@nb = query_sql("SELECT char_num FROM `char` WHERE char_id = '"+getcharid(0)+"' AND account_id = '"+getcharid(3)+"'", .@char_num$); close2; if (.@char_num$ == "0") openstorage2 50,STOR_MODE_GET|STOR_MODE_PUT; else if (.@char_num$ == "1") openstorage2 51,STOR_MODE_GET|STOR_MODE_PUT; else if (.@char_num$ == "2") openstorage2 52,STOR_MODE_GET|STOR_MODE_PUT; else if (.@char_num$ == "3") openstorage2 53,STOR_MODE_GET|STOR_MODE_PUT; else if (.@char_num$ == "4") openstorage2 54,STOR_MODE_GET|STOR_MODE_PUT; else if (.@char_num$ == "5") openstorage2 55,STOR_MODE_GET|STOR_MODE_PUT; else if (.@char_num$ == "6") openstorage2 56,STOR_MODE_GET|STOR_MODE_PUT; else if (.@char_num$ == "7") openstorage2 57,STOR_MODE_GET|STOR_MODE_PUT; else if (.@char_num$ == "8") openstorage2 58,STOR_MODE_GET|STOR_MODE_PUT; else if (.@char_num$ == "9") openstorage2 59,STOR_MODE_GET|STOR_MODE_PUT; else if (.@char_num$ == "10") openstorage2 60,STOR_MODE_GET|STOR_MODE_PUT; else if (.@char_num$ == "11") openstorage2 61,STOR_MODE_GET|STOR_MODE_PUT; else if (.@char_num$ == "12") openstorage2 62,STOR_MODE_GET|STOR_MODE_PUT; else if (.@char_num$ == "13") openstorage2 63,STOR_MODE_GET|STOR_MODE_PUT; else if (.@char_num$ == "14") openstorage2 64,STOR_MODE_GET|STOR_MODE_PUT; else mes "Can`t open storage. Unknown char_id."; end; } Configuration: add this lines to conf/inter_server.yml # Char 1-3 - ID: 50 Name: "Storage" Table: "storage_char_0" Max: 300 - ID: 51 Name: "Storage" Table: "storage_char_1" Max: 300 - ID: 52 Name: "Storage" Table: "storage_char_2" Max: 300 # Char 4-6 - ID: 53 Name: "Storage" Table: "storage_char_3" Max: 300 - ID: 54 Name: "Storage" Table: "storage_char_4" Max: 300 - ID: 55 Name: "Storage" Table: "storage_char_5" Max: 300 # Char 7-9 - ID: 56 Name: "Storage" Table: "storage_char_6" Max: 300 - ID: 57 Name: "Storage" Table: "storage_char_7" Max: 300 - ID: 58 Name: "Storage" Table: "storage_char_8" Max: 300 # Char 10-12 - ID: 59 Name: "Storage" Table: "storage_char_9" Max: 300 - ID: 60 Name: "Storage" Table: "storage_char_10" Max: 300 - ID: 61 Name: "Storage" Table: "storage_char_11" Max: 300 # Char 13-15 - ID: 62 Name: "Storage" Table: "storage_char_12" Max: 300 - ID: 63 Name: "Storage" Table: "storage_char_13" Max: 300 - ID: 64 Name: "Storage" Table: "storage_char_14" Max: 300 Add new sql tables: CREATE TABLE IF NOT EXISTS `storage_char_0` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `account_id` int(11) unsigned NOT NULL DEFAULT '0', `nameid` smallint(5) unsigned NOT NULL DEFAULT '0', `amount` smallint(11) unsigned NOT NULL DEFAULT '0', `equip` int(11) unsigned NOT NULL DEFAULT '0', `identify` smallint(6) unsigned NOT NULL DEFAULT '0', `refine` tinyint(3) unsigned NOT NULL DEFAULT '0', `attribute` tinyint(4) unsigned NOT NULL DEFAULT '0', `card0` smallint(5) unsigned NOT NULL DEFAULT '0', `card1` smallint(5) unsigned NOT NULL DEFAULT '0', `card2` smallint(5) unsigned NOT NULL DEFAULT '0', `card3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_id0` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val0` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm0` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id1` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val1` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm1` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id2` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val2` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm2` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm3` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id4` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val4` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm4` tinyint(3) unsigned NOT NULL DEFAULT '0', `expire_time` int(11) unsigned NOT NULL DEFAULT '0', `bound` tinyint(3) unsigned NOT NULL DEFAULT '0', `unique_id` bigint(20) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `account_id` (`account_id`) ) ENGINE=MyISAM AUTO_INCREMENT=3169 DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `storage_char_1` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `account_id` int(11) unsigned NOT NULL DEFAULT '0', `nameid` smallint(5) unsigned NOT NULL DEFAULT '0', `amount` smallint(11) unsigned NOT NULL DEFAULT '0', `equip` int(11) unsigned NOT NULL DEFAULT '0', `identify` smallint(6) unsigned NOT NULL DEFAULT '0', `refine` tinyint(3) unsigned NOT NULL DEFAULT '0', `attribute` tinyint(4) unsigned NOT NULL DEFAULT '0', `card0` smallint(5) unsigned NOT NULL DEFAULT '0', `card1` smallint(5) unsigned NOT NULL DEFAULT '0', `card2` smallint(5) unsigned NOT NULL DEFAULT '0', `card3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_id0` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val0` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm0` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id1` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val1` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm1` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id2` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val2` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm2` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm3` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id4` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val4` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm4` tinyint(3) unsigned NOT NULL DEFAULT '0', `expire_time` int(11) unsigned NOT NULL DEFAULT '0', `bound` tinyint(3) unsigned NOT NULL DEFAULT '0', `unique_id` bigint(20) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `account_id` (`account_id`) ) ENGINE=MyISAM AUTO_INCREMENT=3169 DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `storage_char_2` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `account_id` int(11) unsigned NOT NULL DEFAULT '0', `nameid` smallint(5) unsigned NOT NULL DEFAULT '0', `amount` smallint(11) unsigned NOT NULL DEFAULT '0', `equip` int(11) unsigned NOT NULL DEFAULT '0', `identify` smallint(6) unsigned NOT NULL DEFAULT '0', `refine` tinyint(3) unsigned NOT NULL DEFAULT '0', `attribute` tinyint(4) unsigned NOT NULL DEFAULT '0', `card0` smallint(5) unsigned NOT NULL DEFAULT '0', `card1` smallint(5) unsigned NOT NULL DEFAULT '0', `card2` smallint(5) unsigned NOT NULL DEFAULT '0', `card3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_id0` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val0` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm0` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id1` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val1` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm1` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id2` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val2` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm2` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm3` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id4` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val4` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm4` tinyint(3) unsigned NOT NULL DEFAULT '0', `expire_time` int(11) unsigned NOT NULL DEFAULT '0', `bound` tinyint(3) unsigned NOT NULL DEFAULT '0', `unique_id` bigint(20) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `account_id` (`account_id`) ) ENGINE=MyISAM AUTO_INCREMENT=3169 DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `storage_char_3` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `account_id` int(11) unsigned NOT NULL DEFAULT '0', `nameid` smallint(5) unsigned NOT NULL DEFAULT '0', `amount` smallint(11) unsigned NOT NULL DEFAULT '0', `equip` int(11) unsigned NOT NULL DEFAULT '0', `identify` smallint(6) unsigned NOT NULL DEFAULT '0', `refine` tinyint(3) unsigned NOT NULL DEFAULT '0', `attribute` tinyint(4) unsigned NOT NULL DEFAULT '0', `card0` smallint(5) unsigned NOT NULL DEFAULT '0', `card1` smallint(5) unsigned NOT NULL DEFAULT '0', `card2` smallint(5) unsigned NOT NULL DEFAULT '0', `card3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_id0` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val0` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm0` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id1` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val1` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm1` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id2` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val2` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm2` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm3` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id4` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val4` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm4` tinyint(3) unsigned NOT NULL DEFAULT '0', `expire_time` int(11) unsigned NOT NULL DEFAULT '0', `bound` tinyint(3) unsigned NOT NULL DEFAULT '0', `unique_id` bigint(20) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `account_id` (`account_id`) ) ENGINE=MyISAM AUTO_INCREMENT=3169 DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `storage_char_4` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `account_id` int(11) unsigned NOT NULL DEFAULT '0', `nameid` smallint(5) unsigned NOT NULL DEFAULT '0', `amount` smallint(11) unsigned NOT NULL DEFAULT '0', `equip` int(11) unsigned NOT NULL DEFAULT '0', `identify` smallint(6) unsigned NOT NULL DEFAULT '0', `refine` tinyint(3) unsigned NOT NULL DEFAULT '0', `attribute` tinyint(4) unsigned NOT NULL DEFAULT '0', `card0` smallint(5) unsigned NOT NULL DEFAULT '0', `card1` smallint(5) unsigned NOT NULL DEFAULT '0', `card2` smallint(5) unsigned NOT NULL DEFAULT '0', `card3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_id0` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val0` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm0` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id1` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val1` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm1` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id2` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val2` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm2` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm3` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id4` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val4` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm4` tinyint(3) unsigned NOT NULL DEFAULT '0', `expire_time` int(11) unsigned NOT NULL DEFAULT '0', `bound` tinyint(3) unsigned NOT NULL DEFAULT '0', `unique_id` bigint(20) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `account_id` (`account_id`) ) ENGINE=MyISAM AUTO_INCREMENT=3169 DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `storage_char_5` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `account_id` int(11) unsigned NOT NULL DEFAULT '0', `nameid` smallint(5) unsigned NOT NULL DEFAULT '0', `amount` smallint(11) unsigned NOT NULL DEFAULT '0', `equip` int(11) unsigned NOT NULL DEFAULT '0', `identify` smallint(6) unsigned NOT NULL DEFAULT '0', `refine` tinyint(3) unsigned NOT NULL DEFAULT '0', `attribute` tinyint(4) unsigned NOT NULL DEFAULT '0', `card0` smallint(5) unsigned NOT NULL DEFAULT '0', `card1` smallint(5) unsigned NOT NULL DEFAULT '0', `card2` smallint(5) unsigned NOT NULL DEFAULT '0', `card3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_id0` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val0` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm0` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id1` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val1` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm1` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id2` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val2` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm2` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm3` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id4` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val4` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm4` tinyint(3) unsigned NOT NULL DEFAULT '0', `expire_time` int(11) unsigned NOT NULL DEFAULT '0', `bound` tinyint(3) unsigned NOT NULL DEFAULT '0', `unique_id` bigint(20) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `account_id` (`account_id`) ) ENGINE=MyISAM AUTO_INCREMENT=3169 DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `storage_char_6` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `account_id` int(11) unsigned NOT NULL DEFAULT '0', `nameid` smallint(5) unsigned NOT NULL DEFAULT '0', `amount` smallint(11) unsigned NOT NULL DEFAULT '0', `equip` int(11) unsigned NOT NULL DEFAULT '0', `identify` smallint(6) unsigned NOT NULL DEFAULT '0', `refine` tinyint(3) unsigned NOT NULL DEFAULT '0', `attribute` tinyint(4) unsigned NOT NULL DEFAULT '0', `card0` smallint(5) unsigned NOT NULL DEFAULT '0', `card1` smallint(5) unsigned NOT NULL DEFAULT '0', `card2` smallint(5) unsigned NOT NULL DEFAULT '0', `card3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_id0` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val0` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm0` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id1` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val1` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm1` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id2` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val2` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm2` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm3` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id4` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val4` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm4` tinyint(3) unsigned NOT NULL DEFAULT '0', `expire_time` int(11) unsigned NOT NULL DEFAULT '0', `bound` tinyint(3) unsigned NOT NULL DEFAULT '0', `unique_id` bigint(20) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `account_id` (`account_id`) ) ENGINE=MyISAM AUTO_INCREMENT=3169 DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `storage_char_7` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `account_id` int(11) unsigned NOT NULL DEFAULT '0', `nameid` smallint(5) unsigned NOT NULL DEFAULT '0', `amount` smallint(11) unsigned NOT NULL DEFAULT '0', `equip` int(11) unsigned NOT NULL DEFAULT '0', `identify` smallint(6) unsigned NOT NULL DEFAULT '0', `refine` tinyint(3) unsigned NOT NULL DEFAULT '0', `attribute` tinyint(4) unsigned NOT NULL DEFAULT '0', `card0` smallint(5) unsigned NOT NULL DEFAULT '0', `card1` smallint(5) unsigned NOT NULL DEFAULT '0', `card2` smallint(5) unsigned NOT NULL DEFAULT '0', `card3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_id0` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val0` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm0` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id1` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val1` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm1` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id2` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val2` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm2` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm3` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id4` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val4` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm4` tinyint(3) unsigned NOT NULL DEFAULT '0', `expire_time` int(11) unsigned NOT NULL DEFAULT '0', `bound` tinyint(3) unsigned NOT NULL DEFAULT '0', `unique_id` bigint(20) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `account_id` (`account_id`) ) ENGINE=MyISAM AUTO_INCREMENT=3169 DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `storage_char_8` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `account_id` int(11) unsigned NOT NULL DEFAULT '0', `nameid` smallint(5) unsigned NOT NULL DEFAULT '0', `amount` smallint(11) unsigned NOT NULL DEFAULT '0', `equip` int(11) unsigned NOT NULL DEFAULT '0', `identify` smallint(6) unsigned NOT NULL DEFAULT '0', `refine` tinyint(3) unsigned NOT NULL DEFAULT '0', `attribute` tinyint(4) unsigned NOT NULL DEFAULT '0', `card0` smallint(5) unsigned NOT NULL DEFAULT '0', `card1` smallint(5) unsigned NOT NULL DEFAULT '0', `card2` smallint(5) unsigned NOT NULL DEFAULT '0', `card3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_id0` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val0` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm0` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id1` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val1` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm1` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id2` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val2` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm2` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm3` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id4` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val4` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm4` tinyint(3) unsigned NOT NULL DEFAULT '0', `expire_time` int(11) unsigned NOT NULL DEFAULT '0', `bound` tinyint(3) unsigned NOT NULL DEFAULT '0', `unique_id` bigint(20) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `account_id` (`account_id`) ) ENGINE=MyISAM AUTO_INCREMENT=3169 DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `storage_char_9` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `account_id` int(11) unsigned NOT NULL DEFAULT '0', `nameid` smallint(5) unsigned NOT NULL DEFAULT '0', `amount` smallint(11) unsigned NOT NULL DEFAULT '0', `equip` int(11) unsigned NOT NULL DEFAULT '0', `identify` smallint(6) unsigned NOT NULL DEFAULT '0', `refine` tinyint(3) unsigned NOT NULL DEFAULT '0', `attribute` tinyint(4) unsigned NOT NULL DEFAULT '0', `card0` smallint(5) unsigned NOT NULL DEFAULT '0', `card1` smallint(5) unsigned NOT NULL DEFAULT '0', `card2` smallint(5) unsigned NOT NULL DEFAULT '0', `card3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_id0` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val0` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm0` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id1` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val1` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm1` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id2` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val2` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm2` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm3` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id4` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val4` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm4` tinyint(3) unsigned NOT NULL DEFAULT '0', `expire_time` int(11) unsigned NOT NULL DEFAULT '0', `bound` tinyint(3) unsigned NOT NULL DEFAULT '0', `unique_id` bigint(20) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `account_id` (`account_id`) ) ENGINE=MyISAM AUTO_INCREMENT=3169 DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `storage_char_10` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `account_id` int(11) unsigned NOT NULL DEFAULT '0', `nameid` smallint(5) unsigned NOT NULL DEFAULT '0', `amount` smallint(11) unsigned NOT NULL DEFAULT '0', `equip` int(11) unsigned NOT NULL DEFAULT '0', `identify` smallint(6) unsigned NOT NULL DEFAULT '0', `refine` tinyint(3) unsigned NOT NULL DEFAULT '0', `attribute` tinyint(4) unsigned NOT NULL DEFAULT '0', `card0` smallint(5) unsigned NOT NULL DEFAULT '0', `card1` smallint(5) unsigned NOT NULL DEFAULT '0', `card2` smallint(5) unsigned NOT NULL DEFAULT '0', `card3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_id0` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val0` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm0` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id1` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val1` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm1` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id2` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val2` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm2` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm3` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id4` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val4` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm4` tinyint(3) unsigned NOT NULL DEFAULT '0', `expire_time` int(11) unsigned NOT NULL DEFAULT '0', `bound` tinyint(3) unsigned NOT NULL DEFAULT '0', `unique_id` bigint(20) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `account_id` (`account_id`) ) ENGINE=MyISAM AUTO_INCREMENT=3169 DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `storage_char_11` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `account_id` int(11) unsigned NOT NULL DEFAULT '0', `nameid` smallint(5) unsigned NOT NULL DEFAULT '0', `amount` smallint(11) unsigned NOT NULL DEFAULT '0', `equip` int(11) unsigned NOT NULL DEFAULT '0', `identify` smallint(6) unsigned NOT NULL DEFAULT '0', `refine` tinyint(3) unsigned NOT NULL DEFAULT '0', `attribute` tinyint(4) unsigned NOT NULL DEFAULT '0', `card0` smallint(5) unsigned NOT NULL DEFAULT '0', `card1` smallint(5) unsigned NOT NULL DEFAULT '0', `card2` smallint(5) unsigned NOT NULL DEFAULT '0', `card3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_id0` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val0` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm0` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id1` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val1` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm1` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id2` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val2` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm2` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm3` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id4` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val4` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm4` tinyint(3) unsigned NOT NULL DEFAULT '0', `expire_time` int(11) unsigned NOT NULL DEFAULT '0', `bound` tinyint(3) unsigned NOT NULL DEFAULT '0', `unique_id` bigint(20) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `account_id` (`account_id`) ) ENGINE=MyISAM AUTO_INCREMENT=3169 DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `storage_char_12` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `account_id` int(11) unsigned NOT NULL DEFAULT '0', `nameid` smallint(5) unsigned NOT NULL DEFAULT '0', `amount` smallint(11) unsigned NOT NULL DEFAULT '0', `equip` int(11) unsigned NOT NULL DEFAULT '0', `identify` smallint(6) unsigned NOT NULL DEFAULT '0', `refine` tinyint(3) unsigned NOT NULL DEFAULT '0', `attribute` tinyint(4) unsigned NOT NULL DEFAULT '0', `card0` smallint(5) unsigned NOT NULL DEFAULT '0', `card1` smallint(5) unsigned NOT NULL DEFAULT '0', `card2` smallint(5) unsigned NOT NULL DEFAULT '0', `card3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_id0` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val0` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm0` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id1` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val1` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm1` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id2` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val2` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm2` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm3` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id4` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val4` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm4` tinyint(3) unsigned NOT NULL DEFAULT '0', `expire_time` int(11) unsigned NOT NULL DEFAULT '0', `bound` tinyint(3) unsigned NOT NULL DEFAULT '0', `unique_id` bigint(20) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `account_id` (`account_id`) ) ENGINE=MyISAM AUTO_INCREMENT=3169 DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `storage_char_13` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `account_id` int(11) unsigned NOT NULL DEFAULT '0', `nameid` smallint(5) unsigned NOT NULL DEFAULT '0', `amount` smallint(11) unsigned NOT NULL DEFAULT '0', `equip` int(11) unsigned NOT NULL DEFAULT '0', `identify` smallint(6) unsigned NOT NULL DEFAULT '0', `refine` tinyint(3) unsigned NOT NULL DEFAULT '0', `attribute` tinyint(4) unsigned NOT NULL DEFAULT '0', `card0` smallint(5) unsigned NOT NULL DEFAULT '0', `card1` smallint(5) unsigned NOT NULL DEFAULT '0', `card2` smallint(5) unsigned NOT NULL DEFAULT '0', `card3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_id0` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val0` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm0` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id1` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val1` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm1` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id2` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val2` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm2` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm3` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id4` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val4` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm4` tinyint(3) unsigned NOT NULL DEFAULT '0', `expire_time` int(11) unsigned NOT NULL DEFAULT '0', `bound` tinyint(3) unsigned NOT NULL DEFAULT '0', `unique_id` bigint(20) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `account_id` (`account_id`) ) ENGINE=MyISAM AUTO_INCREMENT=3169 DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `storage_char_14` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `account_id` int(11) unsigned NOT NULL DEFAULT '0', `nameid` smallint(5) unsigned NOT NULL DEFAULT '0', `amount` smallint(11) unsigned NOT NULL DEFAULT '0', `equip` int(11) unsigned NOT NULL DEFAULT '0', `identify` smallint(6) unsigned NOT NULL DEFAULT '0', `refine` tinyint(3) unsigned NOT NULL DEFAULT '0', `attribute` tinyint(4) unsigned NOT NULL DEFAULT '0', `card0` smallint(5) unsigned NOT NULL DEFAULT '0', `card1` smallint(5) unsigned NOT NULL DEFAULT '0', `card2` smallint(5) unsigned NOT NULL DEFAULT '0', `card3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_id0` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val0` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm0` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id1` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val1` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm1` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id2` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val2` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm2` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm3` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id4` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val4` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm4` tinyint(3) unsigned NOT NULL DEFAULT '0', `expire_time` int(11) unsigned NOT NULL DEFAULT '0', `bound` tinyint(3) unsigned NOT NULL DEFAULT '0', `unique_id` bigint(20) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `account_id` (`account_id`) ) ENGINE=MyISAM AUTO_INCREMENT=3169 DEFAULT CHARSET=utf8;

View File cp_itemdesc populed table I don't know the reason but on my Fluxcp the system "UPLOAD ITEMINFO.LUA" never worked and so I took the file "itemInfo.lua" file translated by @zackdreaver (GIT repo) with all the descriptions of the translated items formatted in HTML and I have made a SQL file that inserts the data in the `cp_itemdesc` table which should be enabled on the Fluxcp "Add Item Info" page. The option to activate the description of the items is the following in the file "/config/application.php": 'ShowItemDesc' => true, // Displays generated item descs from parsed itemInfo.lua It depends on the configuration of your "phpmyadmin" (if you use it), but it is very likely that you will need to split this SQL file into several parts to avoid timing out during the query run. if you want to thank me, you can give me a "LIKE"! ;D p.s.: the first 8 items on the list are custom of my server! Submitter CyberDevil Submitted 04/05/2018 Category Other Web/CP Scripts Video Content Author CyberDevil  

Hehe, meu inglês é podre kkk mas consigo formar textos coerentes usando o tradutor kkk, vou ver se consigo falar com alguém lá. tô trabalhando em um app android mas só irei divulga-lo quando tiver uma boa parte pronta.