[OFFICIAL RELEASE] UberCMS Newest Vault - Based on RevCMS, Coded by JerryCool with UberCMS!

[Jerry]

Hello everyone, It's been awhile. Let's release my edited Vault for UberCMS

Screenshots:

SQLS:

DROP TABLE IF EXISTS `vault`;
CREATE TABLE IF NOT EXISTS `vault` (
  `code` int(6) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `vault` (`code`) VALUES
(22729),
(54321),
(22222);

DROP TABLE IF EXISTS `vault_entries`;
CREATE TABLE IF NOT EXISTS `vault_entries` (
  `id` int(211) NOT NULL AUTO_INCREMENT,
  `username` varchar(211) NOT NULL,
  `code` varchar(211) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

DROP TABLE IF EXISTS `vault_prizes`;
CREATE TABLE IF NOT EXISTS `vault_prizes` (
  `id` int(100) NOT NULL AUTO_INCREMENT,
  `name` varchar(211) NOT NULL,
  `amount` varchar(10) NOT NULL,
  `imagename` varchar(211) NOT NULL,
  `type` enum('furni','coins') NOT NULL DEFAULT 'furni',
  `extradata` varchar(211) NOT NULL DEFAULT '1',
  `base_item` varchar(211) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

INSERT INTO `vault_prizes` (`id`, `name`, `amount`, `imagename`, `type`, `extradata`, `base_item`) VALUES
(1, 'Throne', '10', 'throne.gif', 'furni', '1', ''),
(2, '10k Coins!', '0', 'gold_bar.gif', 'coins', '10000', ''),
(3, 'Silver Dragon', '3', 'dragon_silver.gif', 'furni', '1', 'rare_dragonlamp*3');

DROP TABLE IF EXISTS `vault_winners`;
CREATE TABLE IF NOT EXISTS `vault_winners` (
  `id` int(211) NOT NULL AUTO_INCREMENT,
  `username` varchar(211) NOT NULL,
  `code` varchar(211) NOT NULL,
  `claimed` enum('0','1') NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;

Download Links:

You must be registered for see links

You must be registered for see links

Credits:
MrCookie/HillBilly - Making Vault Page from RvCMS
JerryCool - Making the coding UberCMS changing stuff

 

[ying]

Instead of having the user wait 6 hours for their prize, have it execute an SQL that automatically inserts the furniture into the users hand, wouldnt take too long quite easy to do.