View File
Simple DailyZell
Hello everyone. I came this time to bring an old daily reward system that I did. Most of the daily reward systems are so complicated for no reason.
The system draws every day (or each reload) an item from the list of rewards, which can be vip, cash or an item. Items that have already been drawn will only be drawn once the entire list has been drawn.
//SQL and insert sample
CREATE TABLE IF NOT EXISTS `daily_account` (
`aid` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `daily` (
`id` int(2) NOT NULL,
`type` int(3) NOT NULL,
`value` int(10) NOT NULL,
`take` int(2) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO `daily` (`id`, `tipo`, `valor`, `take`) VALUES
(1, 2, 1, 0),
(2, 673, 1, 0),
(3, 673, 3, 0),
//ID: Daily ID
//TYPE: 1 = Cash
// 2 = Vip
// 500+ = Item ID
//VALUE: type 1 = Cash value
// type 2 = Vip Day
// type 3 = Item Quantity
Submitter
Zell
Submitted
05/31/2018
Category
Utilities
Video
Content Author
Zell