LCKB › ** OLD LCKB DATABASE ** › Guides & Help Section › Tutorials & Guides › General Guides v
Missing tables in Data

Threaded Mode
Missing tables in Data
CDWriter Offline
Senior Member
****
Posts: 620
Threads: 77
Thanks Received: 0 in 0 posts
Thanks Given: 0
Joined: May 2013
Reputation: 0
#1
01-30-2015, 02:30 PM

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 ????   Smile

 

 

 

 

 
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 ...... Smile 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 .....

Find
ZaTii Offline
Senior Member
****
Posts: 336
Threads: 14
Thanks Received: 0 in 0 posts
Thanks Given: 0
Joined: May 2013
Reputation: 0
#2
01-30-2015, 03:09 PM
Coll thing but keep in mind that sometables are only for Korea or other Nations, So for USA they are not needed Wink

Find
DamonA Offline
Member
***
Posts: 208
Threads: 13
Thanks Received: 0 in 0 posts
Thanks Given: 0
Joined: Nov 2014
Reputation: 0
#3
01-30-2015, 06:05 PM

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

Find
Wizatek Offline
Posting Freak
*****
Posts: 768
Threads: 40
Thanks Received: 0 in 0 posts
Thanks Given: 0
Joined: May 2011
Reputation: 0
#4
01-30-2015, 06:39 PM

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.

Find
CDWriter Offline
Senior Member
****
Posts: 620
Threads: 77
Thanks Received: 0 in 0 posts
Thanks Given: 0
Joined: May 2013
Reputation: 0
#5
01-31-2015, 12:02 AM


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 .....

Find
Wizatek Offline
Posting Freak
*****
Posts: 768
Threads: 40
Thanks Received: 0 in 0 posts
Thanks Given: 0
Joined: May 2011
Reputation: 0
#6
01-31-2015, 12:06 AM
doing the opposite would be better though, clean out all tables that are not used anymore at all. there are some old event databases 

Find
CDWriter Offline
Senior Member
****
Posts: 620
Threads: 77
Thanks Received: 0 in 0 posts
Thanks Given: 0
Joined: May 2013
Reputation: 0
#7
01-31-2015, 03:38 AM
yep iam on it ..... Smile 

Find
pwesty Offline
Senior Member
****
Posts: 395
Threads: 43
Thanks Received: 0 in 0 posts
Thanks Given: 0
Joined: Aug 2011
Reputation: 0
#8
01-31-2015, 11:31 AM

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

Find
Sutz Offline
Administrator
*******
Posts: 1,163
Threads: 160
Thanks Received: 0 in 0 posts
Thanks Given: 0
Joined: Jun 2011
Reputation: 0
#9
02-06-2015, 10:08 AM
Cleaned. (Moved to guides)

Find
Sutz Offline
Administrator
*******
Posts: 1,163
Threads: 160
Thanks Received: 0 in 0 posts
Thanks Given: 0
Joined: Jun 2011
Reputation: 0
#10
02-06-2015, 10:18 AM


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 Undecided

 

All fixed now.

Find


Forum Jump:


Users browsing this thread: