Some sql tables are not in my DB

[Bug]

Hi im getting these error consoles

[6:50:13.503] mysql_real_query(): INSERT INTO `lottery` (`name`, `item`, `world_id`) VALUES ('Elite White', 'magic plate armor', '0'); - MYSQL ERROR: Unknown column 'world_id' in 'field list' (1054)





[6:50:26.291] mysql_real_query(): INSERT INTO `z_shop_history` VALUES (NULL, 8445609, 'Roco', 11118, 'Health Boots', 15, 1297223426, 1); - MYSQL ERROR: Column 'id' cannot be null (1048)

I dont have these tables how do i create them?

 

[Ceejzor]

For the z shop offer one you need to add this in your database sql

CREATE TABLE `z_shop_history_pacc` (
  `id` int(11) NOT NULL auto_increment,
  `to_name` varchar(255) NOT NULL default '0',
  `to_account` int(11) NOT NULL default '0',
  `from_nick` varchar(255) NOT NULL,
  `from_account` int(11) NOT NULL default '0',
  `price` int(11) NOT NULL default '0',
  `pacc_days` int(11) NOT NULL default '0',
  `trans_state` varchar(255) NOT NULL,
  `trans_start` int(11) NOT NULL default '0',
  `trans_real` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

As for the other one search for it on otland I'm sure you will find it in 2-10 seconds depending on your browser speed.

 

[Bug]

I need table z_shop_history and lottery!