$sql[] = "CREATE TABLE " . $table_prefix  . "blackjack_cards (
  number int(2) NOT NULL default '0',
  value text NOT NULL
) TYPE=MyISAM";

$sql[] = "INSERT INTO " . $table_prefix . "blackjack_cards (number, value) VALUES ('1', 'Two Of Clubs')";
$sql[] = "INSERT INTO " . $table_prefix . "blackjack_cards (number, value) VALUES ('2', 'Three Of Clubs')";
$sql[] = "INSERT INTO " . $table_prefix . "blackjack_cards (number, value) VALUES ('3', 'Four Of Clubs')";
$sql[] = "INSERT INTO " . $table_prefix . "blackjack_cards (number, value) VALUES ('4', 'Five Of Clubs')";
$sql[] = "INSERT INTO " . $table_prefix . "blackjack_cards (number, value) VALUES ('5', 'Six Of Clubs')";
$sql[] = "INSERT INTO " . $table_prefix . "blackjack_cards (number, value) VALUES ('6', 'Seven Of Clubs')";
$sql[] = "INSERT INTO " . $table_prefix . "blackjack_cards (number, value) VALUES ('7', 'Eight Of Clubs')";
$sql[] = "INSERT INTO " . $table_prefix . "blackjack_cards (number, value) VALUES ('8', 'Nine Of Clubs')";
$sql[] = "INSERT INTO " . $table_prefix . "blackjack_cards (number, value) VALUES ('9', 'Ten Of Clubs')";
$sql[] = "INSERT INTO " . $table_prefix . "blackjack_cards (number, value) VALUES ('10', 'Jack Of Clubs')";
$sql[] = "INSERT INTO " . $table_prefix . "blackjack_cards (number, value) VALUES ('11', 'Queen Of Clubs')";
$sql[] = "INSERT INTO " . $table_prefix . "blackjack_cards (number, value) VALUES ('12', 'King Of Clubs')";
$sql[] = "INSERT INTO " . $table_prefix . "blackjack_cards (number, value) VALUES ('13', 'Ace Of Clubs')";
$sql[] = "INSERT INTO " . $table_prefix . "blackjack_cards (number, value) VALUES ('14', 'Two Of Diamonds')";
$sql[] = "INSERT INTO " . $table_prefix . "blackjack_cards (number, value) VALUES ('15', 'Three Of Diamonds')";
$sql[] = "INSERT INTO " . $table_prefix . "blackjack_cards (number, value) VALUES ('16', 'Four Of Diamonds')";
$sql[] = "INSERT INTO " . $table_prefix . "blackjack_cards (number, value) VALUES ('17', 'Five Of Diamonds')";
$sql[] = "INSERT INTO " . $table_prefix . "blackjack_cards (number, value) VALUES ('18', 'Six Of Diamonds')";
$sql[] = "INSERT INTO " . $table_prefix . "blackjack_cards (number, value) VALUES ('19', 'Seven Of Diamonds')";
$sql[] = "INSERT INTO " . $table_prefix . "blackjack_cards (number, value) VALUES ('20', 'Eight Of Diamonds')";
$sql[] = "INSERT INTO " . $table_prefix . "blackjack_cards (number, value) VALUES ('21', 'Nine Of Diamonds')";
$sql[] = "INSERT INTO " . $table_prefix . "blackjack_cards (number, value) VALUES ('22', 'Ten Of Diamonds')";
$sql[] = "INSERT INTO " . $table_prefix . "blackjack_cards (number, value) VALUES ('23', 'Jack Of Diamonds')";
$sql[] = "INSERT INTO " . $table_prefix . "blackjack_cards (number, value) VALUES ('24', 'Queen Of Diamonds')";
$sql[] = "INSERT INTO " . $table_prefix . "blackjack_cards (number, value) VALUES ('25', 'King Of Diamonds')";
$sql[] = "INSERT INTO " . $table_prefix . "blackjack_cards (number, value) VALUES ('26', 'Ace Of Diamonds')";
$sql[] = "INSERT INTO " . $table_prefix . "blackjack_cards (number, value) VALUES ('27', 'Two Of Hearts')";
$sql[] = "INSERT INTO " . $table_prefix . "blackjack_cards (number, value) VALUES ('28', 'Three Of Hearts')";
$sql[] = "INSERT INTO " . $table_prefix . "blackjack_cards (number, value) VALUES ('29', 'Four Of Hearts')";
$sql[] = "INSERT INTO " . $table_prefix . "blackjack_cards (number, value) VALUES ('30', 'Five Of Hearts')";
$sql[] = "INSERT INTO " . $table_prefix . "blackjack_cards (number, value) VALUES ('31', 'Six Of Hearts')";
$sql[] = "INSERT INTO " . $table_prefix . "blackjack_cards (number, value) VALUES ('32', 'Seven Of Hearts')";
$sql[] = "INSERT INTO " . $table_prefix . "blackjack_cards (number, value) VALUES ('33', 'Eight Of Hearts')";
$sql[] = "INSERT INTO " . $table_prefix . "blackjack_cards (number, value) VALUES ('34', 'Nine Of Hearts')";
$sql[] = "INSERT INTO " . $table_prefix . "blackjack_cards (number, value) VALUES ('35', 'Ten Of Hearts')";
$sql[] = "INSERT INTO " . $table_prefix . "blackjack_cards (number, value) VALUES ('36', 'Jack Of Hearts')";
$sql[] = "INSERT INTO " . $table_prefix . "blackjack_cards (number, value) VALUES ('37', 'Queen Of Hearts')";
$sql[] = "INSERT INTO " . $table_prefix . "blackjack_cards (number, value) VALUES ('38', 'King Of Hearts')";
$sql[] = "INSERT INTO " . $table_prefix . "blackjack_cards (number, value) VALUES ('39', 'Ace Of Hearts')";
$sql[] = "INSERT INTO " . $table_prefix . "blackjack_cards (number, value) VALUES ('40', 'Two Of Spades')";
$sql[] = "INSERT INTO " . $table_prefix . "blackjack_cards (number, value) VALUES ('41', 'Three Of Spades')";
$sql[] = "INSERT INTO " . $table_prefix . "blackjack_cards (number, value) VALUES ('42', 'Four Of Spades')";
$sql[] = "INSERT INTO " . $table_prefix . "blackjack_cards (number, value) VALUES ('43', 'Five Of Spades')";
$sql[] = "INSERT INTO " . $table_prefix . "blackjack_cards (number, value) VALUES ('44', 'Six Of Spades')";
$sql[] = "INSERT INTO " . $table_prefix . "blackjack_cards (number, value) VALUES ('45', 'Seven Of Spades')";
$sql[] = "INSERT INTO " . $table_prefix . "blackjack_cards (number, value) VALUES ('46', 'Eight Of Spades')";
$sql[] = "INSERT INTO " . $table_prefix . "blackjack_cards (number, value) VALUES ('47', 'Nine Of Spades')";
$sql[] = "INSERT INTO " . $table_prefix . "blackjack_cards (number, value) VALUES ('48', 'Ten Of Spades')";
$sql[] = "INSERT INTO " . $table_prefix . "blackjack_cards (number, value) VALUES ('49', 'Jack Of Spades')";
$sql[] = "INSERT INTO " . $table_prefix . "blackjack_cards (number, value) VALUES ('50', 'Queen Of Spades')";
$sql[] = "INSERT INTO " . $table_prefix . "blackjack_cards (number, value) VALUES ('51', 'King Of Spades')";
$sql[] = "INSERT INTO " . $table_prefix . "blackjack_cards (number, value) VALUES ('52', 'Ace Of Spades')";

$sql[] = "CREATE TABLE " . $table_prefix  . "blackjack_info (
  given int(20) NOT NULL default '0',
  taken int(20) NOT NULL default '0',
  wins int(20) NOT NULL default '0',
  losses int(20) NOT NULL default '0',
  ties int(20) NOT NULL default '0',
  re_dealt int(20) NOT NULL default '0'
) TYPE=MyISAM";

$sql[] = "INSERT INTO " . $table_prefix . "blackjack_info (given, taken, wins, losses, ties, re_dealt) VALUES ('0', '0', '0', '0', '0', '0')";

INSERT INTO phpbb_config (config_name, config_value) VALUES ('chance_playprice', '2');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('chance_aceofclubs', '15');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('chance_aceofdiamonds', '20');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('chance_aceofhearts', '25');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('chance_aceofspades', '30');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('chance_onoff', 'on');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('chance_minorprize', '5');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('chance_given', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('chance_taken', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('chance_played', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('slot_playprice', '2');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('slot_apple', '15');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('slot_banana', '20');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('slot_orange', '25');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('slot_starfruit', '30');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('slot_onoff', 'on');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('slot_minorprize', '5');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('slot_given', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('slot_taken', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('slot_played', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('luckydice_enable', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('luckydice_maxbet', '');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('luckydice_windouble', '');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('luckydice_wintriple', '');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('luckydice_winperfect', '');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('luckydice_bonussmall', '');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('luckydice_bonusbig', '');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('luckydice_played', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('luckydice_taken', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('luckydice_given', '0');

CREATE TABLE phpbb_blackjack_refresh (
  player int(10) NOT NULL default '0',
  card1 int(3) NOT NULL default '0',
  card2 text NOT NULL,
  card3 int(3) NOT NULL default '0',
  card4 text NOT NULL
) TYPE=MyISAM;

CREATE TABLE phpbb_keno_game (
  played int(20) NOT NULL default '0',
  points_given int(20) NOT NULL default '0',
  points_taken int(20) NOT NULL default '0'
) TYPE=MyISAM;

INSERT INTO phpbb_keno_game (played, points_given, points_taken) VALUES ('0', '0', '0');

CREATE TABLE phpbb_blackjack_cards (
  number int(2) NOT NULL default '0',
  value text NOT NULL
) TYPE=MyISAM;

INSERT INTO phpbb_blackjack_cards (number, value) VALUES ('1', 'Two Of Clubs');
INSERT INTO phpbb_blackjack_cards (number, value) VALUES ('2', 'Three Of Clubs');
INSERT INTO phpbb_blackjack_cards (number, value) VALUES ('3', 'Four Of Clubs');
INSERT INTO phpbb_blackjack_cards (number, value) VALUES ('4', 'Five Of Clubs');
INSERT INTO phpbb_blackjack_cards (number, value) VALUES ('5', 'Six Of Clubs');
INSERT INTO phpbb_blackjack_cards (number, value) VALUES ('6', 'Seven Of Clubs');
INSERT INTO phpbb_blackjack_cards (number, value) VALUES ('7', 'Eight Of Clubs');
INSERT INTO phpbb_blackjack_cards (number, value) VALUES ('8', 'Nine Of Clubs');
INSERT INTO phpbb_blackjack_cards (number, value) VALUES ('9', 'Ten Of Clubs');
INSERT INTO phpbb_blackjack_cards (number, value) VALUES ('10', 'Jack Of Clubs');
INSERT INTO phpbb_blackjack_cards (number, value) VALUES ('11', 'Queen Of Clubs');
INSERT INTO phpbb_blackjack_cards (number, value) VALUES ('12', 'King Of Clubs');
INSERT INTO phpbb_blackjack_cards (number, value) VALUES ('13', 'Ace Of Clubs');
INSERT INTO phpbb_blackjack_cards (number, value) VALUES ('14', 'Two Of Diamonds');
INSERT INTO phpbb_blackjack_cards (number, value) VALUES ('15', 'Three Of Diamonds');
INSERT INTO phpbb_blackjack_cards (number, value) VALUES ('16', 'Four Of Diamonds');
INSERT INTO phpbb_blackjack_cards (number, value) VALUES ('17', 'Five Of Diamonds');
INSERT INTO phpbb_blackjack_cards (number, value) VALUES ('18', 'Six Of Diamonds');
INSERT INTO phpbb_blackjack_cards (number, value) VALUES ('19', 'Seven Of Diamonds');
INSERT INTO phpbb_blackjack_cards (number, value) VALUES ('20', 'Eight Of Diamonds');
INSERT INTO phpbb_blackjack_cards (number, value) VALUES ('21', 'Nine Of Diamonds');
INSERT INTO phpbb_blackjack_cards (number, value) VALUES ('22', 'Ten Of Diamonds');
INSERT INTO phpbb_blackjack_cards (number, value) VALUES ('23', 'Jack Of Diamonds');
INSERT INTO phpbb_blackjack_cards (number, value) VALUES ('24', 'Queen Of Diamonds');
INSERT INTO phpbb_blackjack_cards (number, value) VALUES ('25', 'King Of Diamonds');
INSERT INTO phpbb_blackjack_cards (number, value) VALUES ('26', 'Ace Of Diamonds');
INSERT INTO phpbb_blackjack_cards (number, value) VALUES ('27', 'Two Of Hearts');
INSERT INTO phpbb_blackjack_cards (number, value) VALUES ('28', 'Three Of Hearts');
INSERT INTO phpbb_blackjack_cards (number, value) VALUES ('29', 'Four Of Hearts');
INSERT INTO phpbb_blackjack_cards (number, value) VALUES ('30', 'Five Of Hearts');
INSERT INTO phpbb_blackjack_cards (number, value) VALUES ('31', 'Six Of Hearts');
INSERT INTO phpbb_blackjack_cards (number, value) VALUES ('32', 'Seven Of Hearts');
INSERT INTO phpbb_blackjack_cards (number, value) VALUES ('33', 'Eight Of Hearts');
INSERT INTO phpbb_blackjack_cards (number, value) VALUES ('34', 'Nine Of Hearts');
INSERT INTO phpbb_blackjack_cards (number, value) VALUES ('35', 'Ten Of Hearts');
INSERT INTO phpbb_blackjack_cards (number, value) VALUES ('36', 'Jack Of Hearts');
INSERT INTO phpbb_blackjack_cards (number, value) VALUES ('37', 'Queen Of Hearts');
INSERT INTO phpbb_blackjack_cards (number, value) VALUES ('38', 'King Of Hearts');
INSERT INTO phpbb_blackjack_cards (number, value) VALUES ('39', 'Ace Of Hearts');
INSERT INTO phpbb_blackjack_cards (number, value) VALUES ('40', 'Two Of Spades');
INSERT INTO phpbb_blackjack_cards (number, value) VALUES ('41', 'Three Of Spades');
INSERT INTO phpbb_blackjack_cards (number, value) VALUES ('42', 'Four Of Spades');
INSERT INTO phpbb_blackjack_cards (number, value) VALUES ('43', 'Five Of Spades');
INSERT INTO phpbb_blackjack_cards (number, value) VALUES ('44', 'Six Of Spades');
INSERT INTO phpbb_blackjack_cards (number, value) VALUES ('45', 'Seven Of Spades');
INSERT INTO phpbb_blackjack_cards (number, value) VALUES ('46', 'Eight Of Spades');
INSERT INTO phpbb_blackjack_cards (number, value) VALUES ('47', 'Nine Of Spades');
INSERT INTO phpbb_blackjack_cards (number, value) VALUES ('48', 'Ten Of Spades');
INSERT INTO phpbb_blackjack_cards (number, value) VALUES ('49', 'Jack Of Spades');
INSERT INTO phpbb_blackjack_cards (number, value) VALUES ('50', 'Queen Of Spades');
INSERT INTO phpbb_blackjack_cards (number, value) VALUES ('51', 'King Of Spades');
INSERT INTO phpbb_blackjack_cards (number, value) VALUES ('52', 'Ace Of Spades');

CREATE TABLE phpbb_blackjack_info (
  given int(20) NOT NULL default '0',
  taken int(20) NOT NULL default '0',
  wins int(20) NOT NULL default '0',
  losses int(20) NOT NULL default '0',
  ties int(20) NOT NULL default '0',
  re_dealt int(20) NOT NULL default '0'
) TYPE=MyISAM;

INSERT INTO  phpbb_blackjack_info (given, taken, wins, losses, ties, re_dealt) VALUES ('0', '0', '0', '0', '0', '0');