ดั้มไฟล์ SQL ของ Flash Game ยังไงครับ

asian101990 · โพสต์ 2009-10-20 23:02:54

กดส่งตามนี้เลยครับ

DROP TABLE IF EXISTS cdb_nkflash_player;
CREATE TABLE cdb_nkflash_player (
uid mediumint(8) unsigned NOT NULL default '0',
timestamp int(10) unsigned NOT NULL default '0'
) TYPE=MyISAM;
DROP TABLE IF EXISTS cdb_nkflash_log;
CREATE TABLE cdb_nkflash_log (
logid int(10) unsigned NOT NULL auto_increment,
uid mediumint(8) unsigned NOT NULL default '0',
game_id varchar(15) NOT NULL default '',
game_title varchar(20) NOT NULL default '',
fullmoney int(10) NOT NULL default '0',
score varchar(20) NOT NULL default '',
start_time int(10) unsigned NOT NULL default '0',
dateline int(10) unsigned NOT NULL default '0',
KEY logid (logid)
) TYPE=MyISAM DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `cdb_nkflash`;
CREATE TABLE cdb_nkflash (
game_id varchar(15) NOT NULL default '',
game_type char(1) NOT NULL default '1',
lastplay_time int(10) unsigned NOT NULL default '0',
flash_url varchar(30) NOT NULL default '',
flash_width smallint(5) unsigned NOT NULL default '500',
flash_height smallint(5) unsigned NOT NULL default '500',
flash_bgcolor varchar(10) NOT NULL default '#FFFFFF',
game_title varchar(20) NOT NULL default '',
play_fee smallint(6) NOT NULL default '0',
bonus_rate float unsigned NOT NULL default '1',
rate_limit float NOT NULL default '1',
score_unit varchar(10) NOT NULL default '',
game_img varchar(30) NOT NULL default '',
game_details text NOT NULL,
played_times int(9) unsigned NOT NULL default '0',
favorates char(1) NOT NULL default '0',
medal_id smallint(5) unsigned NOT NULL default '0',
uid_1 varchar(11) NOT NULL default '0',
score_1 double unsigned NOT NULL default '0',
level_1 int(9) unsigned NOT NULL default '0',
dateline_1 int(10) unsigned NOT NULL default '0',
others_1 varchar(250) NOT NULL default '',
uid_2 varchar(11) NOT NULL default '0',
score_2 double unsigned NOT NULL default '0',
level_2 int(9) unsigned NOT NULL default '0',
dateline_2 int(10) unsigned NOT NULL default '0',
others_2 varchar(250) NOT NULL default '',
uid_3 varchar(11) NOT NULL default '0',
score_3 double unsigned NOT NULL default '0',
level_3 int(9) unsigned NOT NULL default '0',
dateline_3 int(10) unsigned NOT NULL default '0',
others_3 varchar(250) NOT NULL default '',
uid_4 varchar(11) NOT NULL default '0',
score_4 double unsigned NOT NULL default '0',
level_4 int(9) unsigned NOT NULL default '0',
dateline_4 int(10) unsigned NOT NULL default '0',
others_4 varchar(250) NOT NULL default '',
uid_5 varchar(11) NOT NULL default '0',
score_5 double unsigned NOT NULL default '0',
level_5 int(9) unsigned NOT NULL default '0',
dateline_5 int(10) unsigned NOT NULL default '0',
others_5 varchar(250) NOT NULL default '',
uid_6 varchar(11) NOT NULL default '0',
score_6 double unsigned NOT NULL default '0',
level_6 int(9) unsigned NOT NULL default '0',
dateline_6 int(10) unsigned NOT NULL default '0',
others_6 varchar(250) NOT NULL default '',
uid_7 varchar(11) NOT NULL default '0',
score_7 double unsigned NOT NULL default '0',
level_7 int(9) unsigned NOT NULL default '0',
dateline_7 int(10) unsigned NOT NULL default '0',
others_7 varchar(250) NOT NULL default '',
uid_8 varchar(11) NOT NULL default '0',
score_8 double unsigned NOT NULL default '0',
level_8 int(9) unsigned NOT NULL default '0',
dateline_8 int(10) unsigned NOT NULL default '0',
others_8 varchar(250) NOT NULL default '',
uid_9 varchar(11) NOT NULL default '0',
score_9 double unsigned NOT NULL default '0',
level_9 int(9) unsigned NOT NULL default '0',
dateline_9 int(10) unsigned NOT NULL default '0',
others_9 varchar(250) NOT NULL default '',
uid_10 varchar(11) NOT NULL default '0',
score_10 double unsigned NOT NULL default '0',
level_10 int(9) unsigned NOT NULL default '0',
dateline_10 int(10) unsigned NOT NULL default '0',
others_10 varchar(250) NOT NULL default '',
PRIMARY KEY (game_id),
KEY played_times (played_times),
KEY medal_id (medal_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
INSERT INTO cdb_nkflash (game_id, game_type, flash_url, flash_width, flash_height, flash_bgcolor, game_title, play_fee, bonus_rate, rate_limit, score_unit, game_img, game_details, favorates, medal_id)
VALUES ('Rage3', '1', 'nkflash/Rage3.swf', 600, 400, '#FFFFFF', 'ไอ้มืดยอดกังฟู', 1, 500, 900, ' คะแนน', 'nkflash/Rage3.gif', 'ใช้ปุ่ม A S D Q W E บังคับ', '3', 981);
INSERT INTO cdb_nkflash (game_id, game_type, flash_url, flash_width, flash_height, flash_bgcolor, game_title, play_fee, bonus_rate, rate_limit, score_unit, game_img, game_details, favorates, medal_id)
VALUES ('DirtBike', '6', 'nkflash/DirtBike.swf', 650, 520, '#000000', 'มอไซค์ไต่ท่อ', 1, 500, 500, 'คะแนน', 'nkflash/DirtBike.gif', 'ใช้ปุ่มลูกศร ขึ้น ลง ซ้าย ขวา และ SPACE ในการควบคุม', '3', 434);
INSERT INTO cdb_nkflash (game_id, game_type, flash_url, flash_width, flash_height, flash_bgcolor, game_title, play_fee, bonus_rate, rate_limit, score_unit, game_img, game_details, favorates, medal_id)
VALUES ('Book_Ofthe_Dead', '5', 'nkflash/Book_Ofthe_Dead.swf', 700, 450, '#000000', 'จับผิดภาพ 7 อย่าง', 1, 800, 900, ' คะแนน', 'nkflash/Book_Ofthe_Dead.gif', 'ให้เราหาตำแหน่งภาพที่ผิด 7 แห่ง', '3', 972);
INSERT INTO cdb_nkflash (game_id, game_type, flash_url, flash_width, flash_height, flash_bgcolor, game_title, play_fee, bonus_rate, rate_limit, score_unit, game_img, game_details, favorates, medal_id)
VALUES ('raidenx', '1', 'nkflash/raidenx.swf', 514, 600, '#000000', 'ยานอวกาศ', 1, 9000, 9000, 'คะแนน', 'nkflash/raidenx.gif', 'วิธีเล่น ใช้ปุ่มลูกศร ขึ้น ลง ซ้าย ขวา และ Z ยิง , X ปล่อยระเบิด , P หยุด', '3', 453);

คัดลอกไปที่คลิปบอร์ด

บัญชี		จำสถานะนี้ไว้ในครั้งหน้า	ลืมรหัสผ่าน
รหัสผ่าน			สมัครสมาชิก