+- LCKB (https://lckb.dev/forum)
+-- Forum: ** OLD LCKB DATABASE ** (https://lckb.dev/forum/forumdisplay.php?fid=109)
+--- Forum: Guides & Help Section (https://lckb.dev/forum/forumdisplay.php?fid=193)
+---- Forum: Tutorials & Guides (https://lckb.dev/forum/forumdisplay.php?fid=124)
+----- Forum: General Guides (https://lckb.dev/forum/forumdisplay.php?fid=194)
+----- Thread: Missing tables in Data (/showthread.php?tid=3671)
- CDWriter - 01-30-2015
Went thru all the tools Source and found many missing tables .........Working on Server tables next .... We all know about the missing columns need to be added ....but how many Tables are missing ????
ALTER TABLE t_npc ADD a_lifetime int(11) NOT NULL DEFAULT '0' AFTER a_bound;
CREATE TABLE `t_db_list` (
`a_index` int(11) unsigned NOT NULL AUTO_INCREMENT,
`a_name` int(11) NOT NULL DEFAULT '0',
`a_lang` int(11) NOT NULL DEFAULT '0',
`a_ip` int(11) NOT NULL DEFAULT '0',
`a_db` int(11) NOT NULL DEFAULT '0',
`a_uid` int(11) NOT NULL DEFAULT '0',
`a_upw` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`a_index`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `t_lang_list` (
`a_index` int(11) unsigned NOT NULL AUTO_INCREMENT,
`a_lang` int(11) NOT NULL DEFAULT '0',
`a_str_suffix` int(11) NOT NULL DEFAULT '0',
`a_lod_suffix` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`a_index`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `t_item_exchange` (
`a_index` int(11) unsigned NOT NULL AUTO_INCREMENT,
`a_enable` int(11) NOT NULL DEFAULT '0',
`a_npc_index` int(11) NOT NULL DEFAULT '0',
`a_result_itemIndex` int(11) NOT NULL DEFAULT '0',
`a_result_itemCount` int(11) NOT NULL DEFAULT '0',
`source_itemIndex0` int(11) NOT NULL DEFAULT '0',
`source_itemIndex1` int(11) NOT NULL DEFAULT '0',
`source_itemIndex2` int(11) NOT NULL DEFAULT '0',
`source_itemIndex3` int(11) NOT NULL DEFAULT '0',
`source_itemIndex4` int(11) NOT NULL DEFAULT '0',
`source_itemCount0` int(11) NOT NULL DEFAULT '0',
`source_itemCount1` int(11) NOT NULL DEFAULT '0',
`source_itemCount2` int(11) NOT NULL DEFAULT '0',
`source_itemCount3` int(11) NOT NULL DEFAULT '0',
`source_itemCount4` int(11) NOT NULL DEFAULT '0',
`a_name` int(11) NOT NULL DEFAULT '0',
`a_desc` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`a_index`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `t_product` (
`a_index` int(11) unsigned NOT NULL AUTO_INCREMENT,
`a_name` int(11) NOT NULL DEFAULT '0',
`a_delay_msec` int(11) NOT NULL DEFAULT '0',
`a_product_item_idx` int(11) NOT NULL DEFAULT '0',
`a_product_item_mini` int(11) NOT NULL DEFAULT '0',
`a_product_item_maxi` int(11) NOT NULL DEFAULT '0',
`a_product_item_prob` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`a_index`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `t_new_promoitem` (
`a_index` int(11) unsigned NOT NULL AUTO_INCREMENT,
`a_section_type` int(11) NOT NULL DEFAULT '0',
`a_item_idx` int(11) NOT NULL DEFAULT '0',
`a_item_count` int(11) NOT NULL DEFAULT '0',
`a_item_plus` int(11) NOT NULL DEFAULT '0',
`a_item_flag` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`a_index`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `t_raid_zone_data` (
`a_index` int(11) unsigned NOT NULL AUTO_INCREMENT,
`a_district_name` int(11) NOT NULL DEFAULT '0',
`a_raid_no` int(11) NOT NULL DEFAULT '0',
`a_district_sub_no` int(11) NOT NULL DEFAULT '0',
`a_left` int(11) NOT NULL DEFAULT '0',
`a_top` int(11) NOT NULL DEFAULT '0',
`a_right` int(11) NOT NULL DEFAULT '0',
`a_bottom` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`a_index`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `t_requital_setup` (
`a_index` int(11) unsigned NOT NULL AUTO_INCREMENT,
`a_event_name` int(11) NOT NULL DEFAULT '0',
`a_event_log_ColumnNum` int(11) NOT NULL DEFAULT '0',
`a_start_time` int(11) NOT NULL DEFAULT '0',
`a_end_time` int(11) NOT NULL DEFAULT '0',
`a_item_idx` int(11) NOT NULL DEFAULT '0',
`a_item_count` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`a_index`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `t_speed_zone` (
`a_zone_index` int(11) NOT NULL DEFAULT '0',
`a_exp` int(11) NOT NULL DEFAULT '0',
`a_sp` int(11) NOT NULL DEFAULT '0',
`a_drop` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`a_zone_index`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `t_crafting` (
`a_index` int(11) unsigned NOT NULL AUTO_INCREMENT,
`a_name` int(11) NOT NULL DEFAULT '0',
`a_category` int(11) NOT NULL DEFAULT '0',
`a_type` int(11) NOT NULL DEFAULT '0',
`a_subtype` int(11) NOT NULL DEFAULT '0',
`a_need_job` int(11) NOT NULL DEFAULT '0',
`a_need_cp` int(11) NOT NULL DEFAULT '0',
`a_need_money` int(11) NOT NULL DEFAULT '0',
`a_delay_msec` int(11) NOT NULL DEFAULT '0',
`a_need_item_idx` int(11) NOT NULL DEFAULT '0',
`a_need_item_count` int(11) NOT NULL DEFAULT '0',
`a_result_item_idx` int(11) NOT NULL DEFAULT '0',
`a_result_item_count` int(11) NOT NULL DEFAULT '0',
`a_result_item_prob` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`a_index`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `t_decompose` (
`a_item_idx` int(11) unsigned NOT NULL DEFAULT '0',
`a_need_money` tinyint(3) unsigned DEFAULT '0',
`a_need_cp` int(11) unsigned DEFAULT '0',
`a_delay_msec` int(11) unsigned DEFAULT '0',
`a_result_item_idx` int(11) unsigned DEFAULT '0',
`a_result_item_plus` int(11) unsigned DEFAULT '0',
`a_result_item_flag` int(11) unsigned DEFAULT '0',
`a_result_item_mini` int(11) unsigned DEFAULT '0',
`a_result_item_maxi` int(11) unsigned DEFAULT '0',
PRIMARY KEY (`a_item_idx`),
UNIQUE KEY `a_item_idx` (`a_item_idx`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `t_lacaRette` (
`a_index` int(11) unsigned NOT NULL DEFAULT '0',
`a_name` varchar(50) NOT NULL DEFAULT '',
`a_enable` int(11) unsigned NOT NULL DEFAULT '0',
`a_useCoinCount` int(11) unsigned NOT NULL DEFAULT '0',
`a_coinIndex` int(11) NOT NULL DEFAULT '0',
`a_coinDefCount` int(11) NOT NULL DEFAULT '0',
`a_coinAddCount` int(11) NOT NULL DEFAULT '0',
`a_giveItem_1` int(11) NOT NULL DEFAULT '0',
`a_giveItem_2` int(11) NOT NULL DEFAULT '0',
`a_giveItem_3` int(11) NOT NULL DEFAULT '0',
`a_giveItem_4` int(11) NOT NULL DEFAULT '0',
`a_giveItem_5` int(11) NOT NULL DEFAULT '0',
`a_giveItem_6` int(11) NOT NULL DEFAULT '0',
`a_giveItem_7` int(11) NOT NULL DEFAULT '0',
`a_giveItem_8` int(11) NOT NULL DEFAULT '0',
`a_giveItem_9` int(11) NOT NULL DEFAULT '0',
`a_giveItem_10` int(11) NOT NULL DEFAULT '0',
`a_name_ger` varchar(50) NOT NULL DEFAULT '',
`a_name_mex` varchar(50) NOT NULL DEFAULT '',
`a_name_brz` varchar(50) NOT NULL DEFAULT '',
`a_name_jpn` varchar(50) NOT NULL DEFAULT '',
`a_name_usa` varchar(50) NOT NULL DEFAULT '',
`a_name_hk` varchar(50) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
See any problems please tell me ..... Oh and these are DATA tables ....so some of them should have something in them ....create the new tools to match and fix any bugs needed for these tables ......
If you can reply with the correct table filled GREAT ..........2
These tables are not really missing they are just no longer used or for other nations, Thai for example, which is also no longer used.
2with this said Use them our not up too you .....Iam going to leave them .....
- ZaTii - 01-30-2015
Coll thing but keep in mind that sometables are only for Korea or other Nations, So for USA they are not needed
- DamonA - 01-30-2015
I dont know why in some post arent an Button for "Thanks" for hidden content ... Just in some posts is this feature avaible
because hide not work in this section & some guy's don't can read or understand that ^^
This is limited to only release an guide sections across LCKB
-ToXiC L33T
- Wizatek - 01-30-2015
Not thanking, just replying to look. please remove this stupid feature...
These tables are not really missing they are just no longer used or for other nations, Thai for example, which is also no longer used.
- CDWriter - 01-31-2015
Not thanking, just replying to look. please remove this stupid feature...
These tables are not really missing they are just no longer used or for other nations, Thai for example, which is also no longer used.
Well good to know, guess it would not hurt leaving them ill check server source see if there called any where .....
- Wizatek - 01-31-2015
doing the opposite would be better though, clean out all tables that are not used anymore at all. there are some old event databases
- CDWriter - 01-31-2015
yep iam on it .....
- pwesty - 01-31-2015
yea mostly what i seen missing from what i released was just some events that aren't needed, so i removed them when i released the database along with the server files
PS: I had spent a couple days rebulding the database from the source, so it's nearly matching the current source we have
- Sutz - 02-06-2015
Cleaned. (Moved to guides)
- Sutz - 02-06-2015
Not thanking, just replying to look. please remove this stupid feature...
These tables are not really missing they are just no longer used or for other nations, Thai for example, which is also no longer used.
This was fixed by stopping reply rights to release & guide sections to FORCE people to use the thanks button.
When I made the new sections for the 2014 DEC release I forgot to update the hook settings an seems ppl abused it
All fixed now.