Lua Lottery System need help

[therrax]

[09/05/2014 21:28:26] Reward: crystal coin
[09/05/2014 21:28:26] Next lottery in 0.0016666666666667 minutes.".
[09/05/2014 21:28:26] mysql_real_query(): INSERT INTO `lottery_system`(`player_id`, `date`, `item_id`, `item_name`) VALUES ( 4, 1399663706, 2160, 'crystal coin'); - MYSQL ERROR: Table 'ots.lottery_system' doesn't exist (1146)


Why? :/
Where is " PHPMYADMIN/MYSQL File "?
I use it "http://otland.net/threads/mod-lottery-system-tfs-0-4.185660/#post-2057247"

 

[WibbenZ]

"'ots.lottery_system' doesn't exist"

You need to add that table.

Add this into your phpmyadmin page.

CREATE TABLE IF NOT EXISTS `lottery_system` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`player_id` int(11) NOT NULL DEFAULT '0',
`date` int(10) unsigned NOT NULL DEFAULT '0',
`item_id` int(11) NOT NULL DEFAULT '0',
`item_name` varchar(50) NOT NULL DEFAULT '',PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;

 

[therrax]

@WibbenZ
To which file i have to add this? I do not know which is phpmyadmin file:/

 

[czarnowidz]

1. http://yourhost/phpMyAdmin/
2. You have to log in with mysql user&password
3. Choose `ots` database
4. Click SQL (or SQL Query) in the top of site
5. Paste code in big textarea and click execute.
Assuming you're using mysql database.

 

[therrax]

Thanks!!