solved
Bump:
Quote:
CREATE TABLE `blackjack` (
`userid` int(11) NOT NULL default '0',
`points` int(11) NOT NULL default '0',
`status` enum('playing','waiting') NOT NULL default 'playing',
`cards` text NOT NULL,
`date` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`userid`)
) ENGINE=MyISAM;
CREATE TABLE `cards` (
`id` int(11) NOT NULL auto_increment,
`points` int(11) NOT NULL default '0',
`pic` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM;
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');
ALTER TABLE `users` ADD `bjwins` int(10) NOT NULL default '0';
ALTER TABLE `users` ADD `bjlosses` int(10) NOT NULL default '0';
|
sloved fir signup
but sql blacljack i think some thing wrong
Bump: it came blank page
tell me its play By ratio or seed bouns?
|