Discuz!官方免费开源建站系统

 找回密码
 立即注册

QQ登录

只需一步,快速开始

搜索

請問如何把含sql語句的文本導入至mysql資料庫?

[复制链接]
lukkinfun 发表于 2006-7-10 14:41:37 | 显示全部楼层 |阅读模式
如題..
我有一個sql文本..
但不知該如何導入..
拜託各位幫幫忙..

文本如下:

DROP TABLE IF EXISTS cdb_arcade;
         CREATE TABLE cdb_arcade (
           scoreid int(11) NOT NULL auto_increment,
           username varchar(50) NOT NULL default '',
           game varchar(50) NOT NULL default '',
           score int(11) NOT NULL default '0',
           comment varchar(70) NOT NULL default 'No comment',
           PRIMARY KEY  (scoreid)
         ) TYPE=MyISAM AUTO_INCREMENT=1 ;
         DROP TABLE IF EXISTS cdb_arcadeconfig;
         CREATE TABLE cdb_arcadeconfig (
           arcadeid tinyint(4) NOT NULL auto_increment,
           active tinyint(4) NOT NULL default '0',
           vpaver varchar(10) NOT NULL default '',
           path varchar(100) NOT NULL default '',
           useraccess varchar(100) NOT NULL default '',
           usescoreicons tinyint(4) NOT NULL default '0',
           scoreiconname varchar(100) NOT NULL default '',
           scoreicondata mediumblob NOT NULL,
           topscoreiconname varchar(100) NOT NULL default '',
           topscoreicondata mediumblob NOT NULL,
           usekingicon tinyint(4) NOT NULL default '0',
           kingiconname varchar(100) NOT NULL default '',
           kingicondata mediumblob NOT NULL,
           usedetailicons tinyint(4) NOT NULL default '0',
           gamedetailiconname varchar(100) NOT NULL default '',
           gamedetailicondata mediumblob NOT NULL,
           userdetailiconname varchar(100) NOT NULL default '',
           userdetailicondata mediumblob NOT NULL,
           PRIMARY KEY  (arcadeid)
         ) TYPE=MyISAM AUTO_INCREMENT=2 ;
         INSERT INTO cdb_arcadeconfig VALUES (1, 1, '100B', 'games/', ' 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 35', 1, 'icon-scoreboard.gif', 0x4749463839610e001000c41f00fffde8fffbcffffbccfffde1fffef2fff8acfffde0fffcd8fffabdfff9b5fffcdcfffcd6fffcd7fff8a0fffde7fffeeefffac0fffcd9fffeedfffbc7fffef0fffccffffde3fff8a3fffbcefff9b3fffef5fff8a6fffef3fff79900000000000021f9040100001f002c000000000e001000000556e0278e64297a68aa7aa3c7691af1000613b0270138c332258d0eeee3a158561d614ba288042085a4f204b8a99243cf0091b948b1adc3c6f3059f2a5254fa84c10a85649c47f025afede9fa89eec60e892b2826832521003b, 'icon-scoreboard2.gif', 0x4749463839610e001000c40000ffc909ff9700ff9700ffc903ffe32cff6700ffc902ffb200ff8500ff7600ffb201ffb200ffb200ff6700ffc907ffe318ff8500ffb200ffe314ff9700ffe321ffb200ffc904ff6700ff9700ff7600ffe346ff6700ffe333ff5b0000000000000021f9040100001f002c000000000e001000000556e0278e64297a68aa7aa3c7691af1000613b0270138c332258d0eeee3a158561d614ba288042085a4f204b8a99243cf0091b948b1adc3c6f3059f2a5254fa84c10a85649c47f025afede9fa89eec60e892b2826832521003b, 1, 'icon-crown.gif', 0x4749463839610d000c00e60000d3d194c6bc67d1c87dd0c887e4c610ddbe16eacd19ddc122ecd12ae4c934d9c13dddc750cdc280efc500e4bc04f3cc15e8c31af3ce1ef6d222e5c220e7c621e7c422f2cf2befce33e1c637e6cb4ae1c94fdec551e4ce61d0c072f5c500f5c600efc100f7ca0beac417fcd120efc61ef6ce21edc620f1ca25e3c024f3cc31efca31f0cd3debcc40dcbf3fddc65ef2c000e9b702ffcb07fdc609ffca12ffce12ffcf13f9c613e8be1ceec420e9bd20e7c132e3be3cd1ba6ad2bd6edac67df7bc00f8c007ffc608fac513f0bf1af7c725e2c25fb2a16bd1bc7dba9753e0d2b5c48d54ffffff00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000021f9040100004b002c000000000d000c00000763804b82838483488546854a091a831c0a0b83192906071b82281115821808041316141023303342433812052c4b2a0f0d1f31413f32350e17823b2421201e2f344036262d82453a242522273744392b2e85d18449473c1d02030c3e3d0100d2dfe08381003b, 1, 'icon-spyglass.gif', 0x4749463839610c000c00c41f00b2b9d5b9f3ffd98c4bcbd8e6f0ac5ba8d5f3a8cdea95aacdd7fcffb8eeffcefbfffdffffe4ffffc2f2fcf1ffffc9eaf5a1bad6feca80efffffb17766e3f0f7d4baa1a58685bdd9e79ba1b68ea7d3afc0dbc5cbded7e7eeccefffffc77400000021f9040100001f002c000000000c000c0000053ae0271e860189e8d80401b2a5e2c52049470130b7484af268b0c1c2a1081460a2c1a35100223f900ca6f24459085594c093fd4cb05d41a49b0a01003b, 'icon-spyglass2.gif', 0x4749463839610c000c00c40000060c420cbbff4f00002a4b7fab03000142bb012e8f00022e49edff0ba2ff31e6fff4ffff76ffff18b5edb1ffff268fc5000d46f82700a8ffff05000073abd1400d00000000114f8200000900013d0415551e2a5f4982a22ca8ffff210000000021f9040100001f002c000000000c000c00000538e0271e860189e8d80401b2a5e2c5204947c11fb7484af2e08385431128e03e8347a3a0397e20194cc529b210a82281073bb96205116c2a04003b);
         DROP TABLE IF EXISTS cdb_arcadegames;
         CREATE TABLE cdb_arcadegames (
           gameid int(11) NOT NULL auto_increment,
           name varchar(50) NOT NULL default '',
           title varchar(50) NOT NULL default '',
           description mediumtext NOT NULL,
           filename varchar(50) NOT NULL default '',
           thumbnailname varchar(100) NOT NULL default '',
           thumbnaildata mediumblob NOT NULL,
           active smallint(1) NOT NULL default '0',
           championactive tinyint(4) NOT NULL default '0',
           championid int(11) NOT NULL default '0',
           champion varchar(50) NOT NULL default '',
           championpicname varchar(100) NOT NULL default '',
           championpicdata mediumblob NOT NULL,
           championtext varchar(255) NOT NULL default '',
           championcolor varchar(50) NOT NULL default '',
           scorevar varchar(50) NOT NULL default '',
           hashoffset int(11) NOT NULL default '0',
           gamecode mediumtext NOT NULL,
           moneyperplay int(3) unsigned default NULL,
           bonusperplay float unsigned default NULL,
           PRIMARY KEY  (gameid)
         ) TYPE=MyISAM AUTO_INCREMENT=8 ;
         INSERT INTO cdb_arcadegames VALUES (2, 'breakout', '打磚塊', '※打磚塊游戲說明+秘技<br>打磚塊最新全攻略', 'breakout.swf', 'proimage1.gif', 0x4749463839611e001e00d500000075e9006edc006edb006dda0067ce0066cd0067cd0066cc0061c20060c10060c000376d003367003366003060001b36001f3d001d39001a33000f1d0101000f0c01ffc2180f0b01ffbf18f0b317f0b4170e0a01ffb516ffb816f0aa15e19d13825b0b78540affb216f4aa15f0a715f0a815e29d14e19d1480590b0f0a01080501fffffffafafaefefefd7d7d7d4d4d4c3c3c3bdbdbd7a7a7a7676767575755151514646463333332323231b1b1b1313130c0c0c08080807070700000000000021f9040100003f002c000000001e001e000006d7c09f70482c1a8fc8a4f2f829399f4e8f69e30b69a0d84f7124ea7abb1cd2c587c27ccfa3a287c36eb33ba331c8e2ae7b8a26927eaff79ca821197c8326451b1788898929143e2a158a911b453e959697989997949a98120b0da1a2a20e9c9d960b0003abacac06a6a73e0d0307b5b6b60ab0a7b3b7bdb944b1960c0104c5c6c608ba9d0d0205cecfcf09ca9a131011d7d8d80fd3c19adcdd98dfe096e2e33ed33ce695ba38312e33eab03d302bf535e6b03b2df52b32f8c09768b058f122c7bf21996ed8d0110fa03a6f0e1f865b42b1a2c58b18970401003b, 1, 0, 0, '', 'proimage2.gif', 0x4749463839610d000c00e60000c6665cca2b2bcf4041c84e50c60008c5000bd20007cf0008e2000ae3000ce2000bf00410c7474dc2000fbc000dd6000fd10010dd0010e40010d40011d7000ed80011e70011eb0011e4000df70010f60010f10517f11625d1343ec70012c70012c20012d20012d10010e70016da0014e30014da0013e20014d50011ed0015ea0016f50019f30014e60013ea1525c40014bf0016d50016d4001ade001ade0017de0017d90019d30015db0016d70019e50018e9001bd7293fd52d3ed93c4dc9001bcf001bd5001bda001bd8001ce7001def1433ae3846cf4054c4163fc88091cf135dcfcfcf00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000021f9040100004b002c000000000d000c00000763804b82838483488546854a091a831c0a0b83192906071b82281115821808041316141023303342433812052c4b2a0f0d1f31413f32350e17823b2421201e2f344036262d82453a242522273744392b2e85d18449473c1d02030c3e3d0100d2dfe08381003b, '', '#ff0000', '\$breakoutscore', 5, '<object classid="clsid27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,0,0" width="400" height="500">\r\n<param name="movie" value="\$vpa_gameurl?location=\$vpa_url&gamename=\$game&gamehash=\$gamehash&s=\$_DISCUZ[sid]">\r\n<param name=loop value=false> \r\n<param name=menu value=false> \r\n<param name=quality value=high> \r\n<param name=bgcolor value=#000000>\r\n<embed src="\$vpa_gameurl" pluginspage="http://www.macromedia.com/go/getflashplayer" type="application/x-shockwave-flash" width="400" height="500">\r\n</embed>\r\n</object>', 10, '100');
         INSERT INTO cdb_arcadegames VALUES (3, 'pacman', '食鬼', '※食鬼游戲說明', 'pacman.swf', 'thumb-pacman.gif', 0x4749463839611e001e00d50000d0758f0033ff1f4cff5f7fffdfe5ff3f66ff7f99ffbfccffdd0000cf0000b30000a500009700008400007c00007900006700006000005600004800004500003800002b00002700002200001c00001b00001700001600001500001400001100001000000f00000e00000a0000080000e95f5ff08f8ff29f9ff6bfbfffffff00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000021f9040100002a002c000000001e001e000006b4409570482c1a8fc8a472c96c3a9fd06832f4e95831d22148924078bf0908292afa9acfa2e7a87b6e27464e487b8e7838cd2614caf4cdef114d215f2529850725088486254d115f852903010508909205144c0c8f85050102959d9f0c4c0b7d850406000826a8aa0b4c0a662785275fb429b60a4c74bd804bbe74bcc16dc3c466c6c75ec6a65f0e0e660b6cc3132a6cbf602a1bcbc00d42245ebb2ab208164215bf4a1e441719441e1a441c59f4f5f6f7f8f94241003b, 1, 0, 0, '', 'icon-crown-red.gif', 0x4749463839610d000c00e60000c6665cca2b2bcf4041c84e50c60008c5000bd20007cf0008e2000ae3000ce2000bf00410c7474dc2000fbc000dd6000fd10010dd0010e40010d40011d7000ed80011e70011eb0011e4000df70010f60010f10517f11625d1343ec70012c70012c20012d20012d10010e70016da0014e30014da0013e20014d50011ed0015ea0016f50019f30014e60013ea1525c40014bf0016d50016d4001ade001ade0017de0017d90019d30015db0016d70019e50018e9001bd7293fd52d3ed93c4dc9001bcf001bd5001bda001bd8001ce7001def1433ae3846cf4054c4163fc88091cf135dcfcfcf00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000021f9040100004b002c000000000d000c00000763804b82838483488546854a091a831c0a0b83192906071b82281115821808041316141023303342433812052c4b2a0f0d1f31413f32350e17823b2421201e2f344036262d82453a242522273744392b2e85d18449473c1d02030c3e3d0100d2dfe08381003b, '', '#FF0000', '\$pacmanscore', 5, '<object classid="clsid27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,0,0" width="360" height="420">\r\n<param name="movie" value="\$vpa_gameurl?location=\$vpa_url&gamename=\$game&gamehash=\$gamehash&s=\$_DISCUZ[sid]">\r\n<ARAM NAME=quality VALUE=high>\r\n<ARAM NAME=bgcolor VALUE=#000000>\r\n<embed src="\$vpa_gameurl" pluginspage="http://www.macromedia.com/go/getflashplayer" type="application/x-shockwave-flash" width="360" height="420"></embed></object>', 10, '1');
         INSERT INTO cdb_arcadegames VALUES (4, 'spaceinvaders', '太空入侵', '※太空入侵游戲說明', 'invaders.swf', 'thumb-invaders.gif', 0x4749463839611e001e00e60000fffffffdfdfdfbfbfbfafafaf8f8f8f6f6f6f5f5f5f4f4f4f3f3f3ecececeaeaeae9e9e9e7e7e7e6e6e6e3e3e3e1e1e1dfdfdfdcdcdcdadadad8d8d8d7d7d7d6d6d6d2d2d2cbcbcbc9c9c9c3c3c3c1c1c1b6b6b6b4b4b4b1b1b1aaaaaaa9a9a9a7a7a7a6a6a6a5a5a5a4a4a4a3a3a3a2a2a2a0a0a09d9d9d9999999696969090908d8d8d8a8a8a8787878585858383838080807e7e7e7c7c7c7575757474746f6f6f6e6e6e6d6d6d6b6b6b6060605c5c5c5858585555555151514d4d4d4c4c4c4a4a4a4747474242424040403939393737373636363333332d2d2d2c2c2c2828282525252222222020201f1f1f1d1d1d1c1c1c1919191717171616161515151414141212121111111010100e0e0e0c0c0c0b0b0b09090908080805050504040403030301010100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000021f90401000063002c000000001e001e000007ff806382838485868788898a87628d8e8f90918f859295966294979a8e999b9a9d9e96a08d60555661915d4e5d91a36250181e9242003ead848e5b3d4a572c283a548e6141332345613b489cb88d4d0e348d4109478f17b2625c0532cb838e4d0b375a1f0d000d12e71200031543620130dc82de0d2f441304110200fb000f0c0036960c88116f8cb77ffb4888d9c06f401623fc00106cd4a9094200145a40e0172005888813313113c3e440c4932801b828e8c80b131329510a486285e5231e1d1028f83042844f11253200d08002922b291638a0820404c08f5bdd1ee5085163c897484f70a818e165d2c8462b2630b974c2002b9b8eb24ce96a094b94a51419bf8692e46aaed7a876e9cacd8b96efdd4580030b1e4c385120003b, 1, 1, 0, '', 'icon-crown-purple.gif', 0x4749463839610d000c00e60000c65cc3bf2bcac440cfbe4ec8b000c6ac00c5bc00d2b800cfc800e2c800e3c800e2d304f0b847c7a500c2a200bcb900d6b200d1be00ddc400e4b500d4ba00d7b800d8c600e7ca00ebc700e4d500f7d400f6cf05f1d316f1bd34d1a700c7a700c7a200c2b100d2b200d1c100e7b700dac000e3b800dabe00e2b500d5c700edc400eacb00f5ce00f3c400e6cb15eaa200c49c00bfb000d5ab00d4b500deb800deb800deb100d9b000d3b500dbaf00d7bd00e5bd00e9b629d7b82dd5bd3cd9a000c9a600cfab00d5af00daad00d8bb00e7c114ef9738aeb140cf9016c4b280c87913cfcfcfcf00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000021f9040100004b002c000000000d000c00000763804b82838483488546854a091a831c0a0b83192906071b82281115821808041316141023303342433812052c4b2a0f0d1f31413f32350e17823b2421201e2f344036262d82453a242522273744392b2e85d18449473c1d02030c3e3d0100d2dfe08381003b, '太空入侵冠軍冠軍榜', '#FF0000', '\$invadersscore', 5, '<object classid="clsid27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,0,0" width="500" height="500">\r\n<param name="movie" value="\$vpa_gameurl?location=\$vpa_url&gamename=\$game&gamehash=\$gamehash&s=\$_DISCUZ[sid]">\r\n<param name="quality" value="high">\r\n<param name="menu" value="false">\r\n<embed src="\$vpa_gameurl" pluginspage="http://www.macromedia.com/go/getflashplayer" type="application/x-shockwave-flash" width="500" height="500">\r\n</embed></object>', 10, '1');
         INSERT INTO cdb_arcadegames VALUES (5, 'starwars', '鈦戰機', '※鈦戰機游戲說明', 'starwars.swf', 'starwars.gif', 0x4749463839611e001e00f700000000010e0e0ff8f8f9c4c4c5ebeef4dfe1e5d7d8da85888dd5d9df94999fbabec3c2c4c6a4a5a6d3d4d5afb0b1919394e5e7e8555656d4d5d5cecfcfb0b1b18d8e8e898a8a040301050402543807462f0d5c4016070502ffcd85f6cc90dbb782bc9f74cac6c07e551faa762e4d3617b581398f662ff4b255302312ba8b4ac59758bb90588a6c45ad8a59927650b79a71e7c79ad1b58eeddac1e5dbcdeee6dbe3ddd51f1509352613372a1a95918c090603130e090c0906040302050403a9a5a1110d0a050302020101fffffff9f9f9f6f6f6f4f4f4f1f1f1f0f0f0efefefeeeeeeedededecececebebebe8e8e8e6e6e6e5e5e5e4e4e4e1e1e1e0e0e0dedededddddddcdcdcdbdbdbdadadad9d9d9d8d8d8d6d6d6d5d5d5d4d4d4d3d3d3cfcfcfcecececdcdcdcccccccbcbcbcacacac9c9c9c8c8c8c7c7c7c6c6c6c5c5c5c4c4c4c3c3c3c2c2c2c1c1c1c0c0c0bfbfbfbebebebdbdbdbcbcbcbbbbbbbababab9b9b9b8b8b8b7b7b7b6b6b6b5b5b5b4b4b4b3b3b3b2b2b2b1b1b1b0b0b0afafafaeaeaeadadadacacacabababaaaaaaa9a9a9a8a8a8a7a7a7a6a6a6a5a5a5a4a4a4a3a3a3a2a2a2a1a1a1a0a0a09f9f9f9e9e9e9d9d9d9c9c9c9b9b9b9a9a9a9999999898989797979696969595959494949393939292929191919090908f8f8f8e8e8e8d8d8d8c8c8c8b8b8b8a8a8a8989898888888787878686868585858484848383838282828181817f7f7f7e7e7e7c7c7c7b7b7b7979797878787777777676767575757272727070706f6f6f6e6e6e6d6d6d6c6c6c6b6b6b6a6a6a6969696868686767676666666565656363636262626060605e5e5e5d5d5d5b5b5b5858585656565252524e4e4e4c4c4c4848484646464141413f3f3f3e3e3e3939393232323030302f2f2f2d2d2d2c2c2c2a2a2a2929292828282424242020201f1f1f1e1e1e1818181515151414141111110e0e0e0b0b0b0808080505050303030202020101010000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002c000000001e001e000008ff00d90964c783878e16211cd0f236b021bb6faed22873e8709d0f111e080818120598436b9cc06ca9a365cf338a0d59d0809084c89021a5044a8bc485cda443a13cd9b152e81a4a12310a406162a4881124a6088dd464aa9220509e446d5a83465c43213754d43020c50993254d9e30a123aa14a851801e81ead4c993a631d31af230d14142832b52a0408922850a1e52a0406db2c3c993a74e8f3a9141d690c30a19602670c152a5ca952e61d46c0a254a919e519e402d82342ace2b76eb8200d00003c180325fbc74c192e5cb1b3b9842919ae32854a846843e85fac3681d861d3652cc582067cd193255946071640a54a5519ad8741a15298fe14f91de94ff6387a3c4070514eec881f3e5c89351c67ee9ca146acf9d5498e060fae4e9932634d95c80820b3f3030481f79d8b18513a2f4924b2ebc9462c613663ce28623a218165a19ce00310208093892082181e4b1c51bc0f8128b2dbc780208165674d106299fd4084a2a72e0b2c109393c5009248c24e207199804530b2e2c62f2881a5688f18728679192c91f534c92c10b0754b08925924062c81cae10434b2cbc141309246d70814620a578424819588c2145243d4460c129196a724924828cc28b30c2c8328a2392a831861c7eb881191f9b44524633ec04f08b29a894921327925452cc30bba0f2ca298ba0f1c61e81f0610929a5487889390291938c2aa69cff724a29a270524a2b95f871892175d4c107219898324a28a5244246340da573cd31b3b4c28a2aa988228a268b2c22c81f8324320928a2f8260a19a09c43d13ae4c0b249a5a49c5289239038f24824924c324ab7a5189206352809f40b24a694628a27717052a327a13c9206add296810a3af9b2c34c23b39eb20724b2127a8a276878328a2983b8514dc3ec4c73482aa93842082aa498f24625a59c328724a68452062ce980bc4d21ab74c266ac96d4710a29a82042082b80d4a10dc8ec8c5388298874326b2a813082b2299904f2ed2dea207dce249068828a29a6908207286193120a237cecd10dd2025982482b60a7328920a9f89b0a2b7f70e111dbece84382c524ada0a20a2197a8a28a2884b031c72ae0f0cd8e3ac86cd1c629a614920a2575ac21c932e138de10377b4cb1071c6ff8710b36597bee503ab070a10934e3b11d10003b, 1, 0, 0, '', 'c.gif', 0x4749463839610d000c00e60000645cc62b2dca4043cf4e52c8000bc6000ec5000bd2000bcf000de2000fe3000ee20414f0474fc70012c20010bc0012d60014d10013dd0014e40014d40012d70014d80015e70014eb0011e40014f70014f6051af11628f13440d10015c70015c70015c20015d20014d10019e70017da0017e30016da0018e20014d50019ed001aea001df50018f30016e61528ea0017c40019bf0019d5001dd4001dde001ade001ade001cd90018d3001adb001dd7001ce5001fe92941d72d41d53c50d9001ec9001ecf001ed5001fda001fd80020e71436ef3848ae4056cf1641c48092c8135fcfcfcfcf00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000021f9040100004b002c000000000d000c00000763804b82838483488546854a091a831c0a0b83192906071b82281115821808041316141023303342433812052c4b2a0f0d1f31413f32350e17823b2421201e2f344036262d82453a242522273744392b2e85d18449473c1d02030c3e3d0100d2dfe08381003b, '', '#FF0000', '\$score', 5, '<object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,0,0" width="400" height="500">\r\n<param name="movie" value="\$vpa_gameurl?location=\$vpa_url&gamename=\$game&gamehash=\$gamehash&s=\$_DISCUZ[sid]">\r\n<param name=loop value=false> \r\n<param name=menu value=false> \r\n<param name=quality value=high> \r\n<param name=bgcolor value=#000000>\r\n<embed src="\$vpa_gameurl" pluginspage="http://www.macromedia.com/go/getflashplayer" type="application/x-shockwave-flash" width="400" height="500">\r\n</embed>\r\n</object>', 10, '1');
         INSERT INTO cdb_arcadegames VALUES (6, 'kartf1', 'F1賽車', '※F1賽車游戲說明', 'kartf1.swf', 'kartf1.gif', 0x4749463839611e001e00d50000ffff66ffff33ffff00ffcc33ffcc00cccccccccc33cccc00cc9933cc99009999999999669999339966336699cc666699666666336699333333333300000000adb2bd736d63a19e9f848283e1dfe2bab9bbb0b0b46265849d9ea2717fb24f56715064a4a9acb5bdc0c8c4c6ccadb2beacb0baa2a4a9acb1bcb2b6bfa9afbbb6bbc5aab0bbaeb4bfb0b7c394947c4141401c1b15b49d367775714f4d4b5d5857a7a2a200000000000000000000000000000000000000000000000000000000000021f90400000000002c000000001e001e000006ff408865481cc6160459a1c26c3a9f1561916820c43229a8b6292dc606b18649b52d7787904055862d6fcf96989c9119b9dfc5748360c9dcf168080c0257257f5a5231096a0d184b8750896049232d242c28999a24246e42100003820a17101e200fa7201ea91c16182c8816080708030a30b92f0f1120bebe1c12b918644f10a0085623b930340f1cbf20100fc23032c54e1006b6016c142fa71c2fe3e40f200e30c4910031010d581d1d0a342033323216322f1f1c0a1d21b18c7d61c0c604290c1f22d8cba76f06040cf2a09c80c060001b1118ee6198f1c2de3d19334266b4a0e0490a08603460c9978fe3c29622890464b202259b0226641c9341e30504c71a2141cea0712c5f081548518880308186531ad63ebed818728682173232ce68f61442060812c286b5960f82c3aa3330d0c887e1058c17625f7ccd25232c5157329e7db8c7a12f06081c6608fb996bae84a7af306050a040f162c58c1dffa421a33084b765652870112244891221e49100ed59f13d089561ccc510f755e7d71b50bc2e8d018658c15f21740ca960c5e7dfc083a710cab14601082d5060aac08293f3e7d039b168c182858a0cc721fd1991a10504ed770af8f90e7ecb890c1948902f2f117d8b20003b, 1, 0, 0, '', 'proimage.gif', 0x4749463839610d000c00e60000c6665cca2b2bcf4041c84e50c60008c5000bd20007cf0008e2000ae3000ce2000bf00410c7474dc2000fbc000dd6000fd10010dd0010e40010d40011d7000ed80011e70011eb0011e4000df70010f60010f10517f11625d1343ec70012c70012c20012d20012d10010e70016da0014e30014da0013e20014d50011ed0015ea0016f50019f30014e60013ea1525c40014bf0016d50016d4001ade001ade0017de0017d90019d30015db0016d70019e50018e9001bd7293fd52d3ed93c4dc9001bcf001bd5001bda001bd8001ce7001def1433ae3846cf4054c4163fc88091cf135dcfcfcf00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000021f9040100004b002c000000000d000c00000763804b82838483488546854a091a831c0a0b83192906071b82281115821808041316141023303342433812052c4b2a0f0d1f31413f32350e17823b2421201e2f344036262d82453a242522273744392b2e85d18449473c1d02030c3e3d0100d2dfe08381003b, '', '#FF0000', '\$conta', 5, '<object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,0,0" width="400" height="500">\r\n<param name="movie" value="\$vpa_gameurl?location=\$vpa_url&gamename=\$game&gamehash=\$gamehash&s=\$_DISCUZ[sid]">\r\n<embed src="\$vpa_gameurl" pluginspage="http://www.macromedia.com/go/getflashplayer" type="application/x-shockwave-flash" width="400" height="500">\r\n</embed>\r\n</object>', 50, '1');
         DROP TABLE IF EXISTS cdb_arcadescoregroups;
         CREATE TABLE cdb_arcadescoregroups (
           groupid int(11) NOT NULL auto_increment,
           groupname varchar(100) NOT NULL default '',
           begindate int(11) NOT NULL default '0',
           enddate int(11) NOT NULL default '0',
           PRIMARY KEY  (groupid)
         ) TYPE=MyISAM AUTO_INCREMENT=2 ;
         INSERT INTO cdb_arcadescoregroups VALUES (1, 'Default Scores', 0, 0);
         DROP TABLE IF EXISTS cdb_arcadescores;
         CREATE TABLE cdb_arcadescores (
           scoreid int(11) NOT NULL auto_increment,
           scoregroup int(11) NOT NULL default '0',
           game varchar(50) NOT NULL default '',
           begintime int(11) NOT NULL default '0',
           endtime int(11) NOT NULL default '0',
           gamehash varchar(50) NOT NULL default '',
           valid tinyint(1) NOT NULL default '0',
           username varchar(50) NOT NULL default '',
           score int(11) NOT NULL default '0',
           comment varchar(70) NOT NULL default 'No comment',
           PRIMARY KEY  (scoreid)
         ) TYPE=MyISAM PACK_KEYS=0 AUTO_INCREMENT=10204 ;
         
         DROP TABLE IF EXISTS cdb_arcadetopscores;
         CREATE TABLE cdb_arcadetopscores (
           scoreid int(11) NOT NULL auto_increment,
           scoregroup int(11) NOT NULL default '0',
           game varchar(50) NOT NULL default '',
           begintime int(11) NOT NULL default '0',
           endtime int(11) NOT NULL default '0',
           username varchar(50) NOT NULL default '',
           score int(11) NOT NULL default '0',
           comment varchar(70) NOT NULL default 'No comment',
           PRIMARY KEY  (scoreid)
         ) TYPE=MyISAM PACK_KEYS=0 AUTO_INCREMENT=695 ;
ALTER TABLE cdb_arcadeconfig ADD `avg` tinyint(1) DEFAULT '0' NOT NULL;
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

手机版|小黑屋|Discuz! 官方站 ( 皖ICP备16010102号 )star

GMT+8, 2024-12-26 16:49 , Processed in 0.023983 second(s), 5 queries , Gzip On, Redis On.

Powered by Discuz! X3.4

Copyright © 2001-2023, Tencent Cloud.

快速回复 返回顶部 返回列表