Clansphere :: FREE Clan Content Management System

|

|

ALTER TABLE {pre}_access ADD access_bets int(2) NOT NULL default '0';
UPDATE {pre}_access SET access_bets = '0' WHERE access_id = '1';
UPDATE {pre}_access SET access_bets = '2' WHERE access_id = '2';
UPDATE {pre}_access SET access_bets = '3' WHERE access_id = '3';
UPDATE {pre}_access SET access_bets = '4' WHERE access_id = '4';
UPDATE {pre}_access SET access_bets = '5' WHERE access_id = '5';

INSERT INTO {pre}_options (options_mod, options_name, options_value) VALUES ('bets', 'startpoints', '50');
INSERT INTO {pre}_options (options_mod, options_name, options_value) VALUES ('bets', 'pointsname', 'Points');
INSERT INTO {pre}_options (options_mod, options_name, options_value) VALUES ('bets', 'max_navlist', '4');
INSERT INTO {pre}_options (options_mod, options_name, options_value) VALUES ('bets', 'remove_quote', '10');
INSERT INTO {pre}_options (options_mod, options_name, options_value) VALUES ('bets', 'min_quote', '1,2');
INSERT INTO {pre}_options (options_mod, options_name, options_value) VALUES ('bets', 'max_quote', '100');
INSERT INTO {pre}_options (options_mod, options_name, options_value) VALUES ('bets', 'win_quote', '0.03');

ALTER TABLE {pre}_users ADD users_betpoints varchar(80) NOT NULL default '60';

CREATE TABLE {pre}_bets (
bets_id int(8) NOT NULL auto_increment,
categories_id int(8) default '0',
bets_status tinyint(1) default '0' COMMENT 'Status 0: Open, 1: on calc, 2: closed',
bets_title varchar(100) default NULL COMMENT 'Title of the bet.',
bets_starts_at int(11) default NULL COMMENT 'Date/Time the bet shows up.',
bets_closed_at int(11) default NULL COMMENT 'Date/Time the bet ends.',
bets_description text COMMENT 'Description for the bet to motivate users to place their bet.',
bets_quote varchar(10) NOT NULL default 'off',
bets_com_close int(2) NOT NULL default '0',
PRIMARY KEY (bets_id)
) TYPE=MyISAM AUTO_INCREMENT=21 COMMENT='Table for the betcenter.' AUTO_INCREMENT=21 ;

CREATE TABLE {pre}_bets_contestants (
contestants_id int(8) NOT NULL auto_increment,
bets_id int(8) NOT NULL default '0',
clans_id int(8) default '0',
bets_name varchar(100) NOT NULL default '',
bets_quote float NOT NULL default '150',
bets_draw int(1) NOT NULL default '0',
bets_winner int(4) NOT NULL default '0',
PRIMARY KEY (contestants_id)
) TYPE=MyISAM AUTO_INCREMENT=242 AUTO_INCREMENT=242 ;

CREATE TABLE {pre}_bets_users (
bets_users_id int(8) NOT NULL auto_increment,
bets_id int(9) NOT NULL default '0',
contestants_id int(8) NOT NULL default '0',
users_id int(8) NOT NULL default '0',
bets_amount float NOT NULL default '0',
bets_users_time int(11) NOT NULL default '0',
PRIMARY KEY (bets_users_id)
) TYPE=MyISAM AUTO_INCREMENT=117 AUTO_INCREMENT=117 ;

|

|