Put this into the database
PHP Code:
CREATE TABLE `blackjack` ( `userid` int(11) NOT NULL default '0', `points` int(11) NOT NULL default '0', `status` enum('playing','waiting') collate latin1_german1_ci NOT NULL default 'playing', `cards` text collate latin1_german1_ci NOT NULL, `date` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`userid`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_german1_ci;
PHP Code:
CREATE TABLE `cards` ( `id` int(11) NOT NULL auto_increment, `points` int(11) NOT NULL default '0', `pic` text collate latin1_german1_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=53 DEFAULT CHARSET=latin1 COLLATE=latin1_german1_ci AUTO_INCREMENT=53 ;
And finally
PHP Code:
INSERT INTO `cards` VALUES (1, 2, '2p.bmp'); INSERT INTO `cards` VALUES (2, 3, '3p.bmp'); INSERT INTO `cards` VALUES (3, 4, '4p.bmp'); INSERT INTO `cards` VALUES (4, 5, '5p.bmp'); INSERT INTO `cards` VALUES (5, 6, '6p.bmp'); INSERT INTO `cards` VALUES (6, 7, '7p.bmp'); INSERT INTO `cards` VALUES (7, 8, '8p.bmp'); INSERT INTO `cards` VALUES (8, 9, '9p.bmp'); INSERT INTO `cards` VALUES (9, 10, '10p.bmp'); INSERT INTO `cards` VALUES (10, 10, 'vp.bmp'); INSERT INTO `cards` VALUES (11, 10, 'dp.bmp'); INSERT INTO `cards` VALUES (12, 10, 'kp.bmp'); INSERT INTO `cards` VALUES (13, 1, 'tp.bmp'); INSERT INTO `cards` VALUES (14, 2, '2b.bmp'); INSERT INTO `cards` VALUES (15, 3, '3b.bmp'); INSERT INTO `cards` VALUES (16, 4, '4b.bmp'); INSERT INTO `cards` VALUES (17, 5, '5b.bmp'); INSERT INTO `cards` VALUES (18, 6, '6b.bmp'); INSERT INTO `cards` VALUES (19, 7, '7b.bmp'); INSERT INTO `cards` VALUES (20, 8, '8b.bmp'); INSERT INTO `cards` VALUES (21, 9, '9b.bmp'); INSERT INTO `cards` VALUES (22, 10, '10b.bmp'); INSERT INTO `cards` VALUES (23, 10, 'vb.bmp'); INSERT INTO `cards` VALUES (24, 10, 'db.bmp'); INSERT INTO `cards` VALUES (25, 10, 'kb.bmp'); INSERT INTO `cards` VALUES (26, 1, 'tb.bmp'); INSERT INTO `cards` VALUES (27, 2, '2k.bmp'); INSERT INTO `cards` VALUES (28, 3, '3k.bmp'); INSERT INTO `cards` VALUES (29, 4, '4k.bmp'); INSERT INTO `cards` VALUES (30, 5, '5k.bmp'); INSERT INTO `cards` VALUES (31, 6, '6k.bmp'); INSERT INTO `cards` VALUES (32, 7, '7k.bmp'); INSERT INTO `cards` VALUES (33, 8, '8k.bmp'); INSERT INTO `cards` VALUES (34, 9, '9k.bmp'); INSERT INTO `cards` VALUES (35, 10, '10k.bmp'); INSERT INTO `cards` VALUES (36, 10, 'vk.bmp'); INSERT INTO `cards` VALUES (37, 10, 'dk.bmp'); INSERT INTO `cards` VALUES (38, 10, 'kk.bmp'); INSERT INTO `cards` VALUES (39, 1, 'tk.bmp'); INSERT INTO `cards` VALUES (40, 2, '2c.bmp'); INSERT INTO `cards` VALUES (41, 3, '3c.bmp'); INSERT INTO `cards` VALUES (42, 4, '4c.bmp'); INSERT INTO `cards` VALUES (43, 5, '5c.bmp'); INSERT INTO `cards` VALUES (44, 6, '6c.bmp'); INSERT INTO `cards` VALUES (45, 7, '7c.bmp'); INSERT INTO `cards` VALUES (46, 8, '8c.bmp'); INSERT INTO `cards` VALUES (47, 9, '9c.bmp'); INSERT INTO `cards` VALUES (48, 10, '10c.bmp'); INSERT INTO `cards` VALUES (49, 10, 'vc.bmp'); INSERT INTO `cards` VALUES (50, 10, 'dc.bmp'); INSERT INTO `cards` VALUES (51, 10, 'kc.bmp'); INSERT INTO `cards` VALUES (52, 1, 'tc.bmp');
|