I have bought a arcade site. I has php pages, games and a few other files. Instructions: Installation Instructions: 1. Upload all the files contained in the freearcade_files folder to your webroot. 2. Modify admin/config.php to match your database settings. 3. Using phpMyAdmin or any other means at your disposal create the database using the included .sql file in the docs directory. 4. Style your site as you wish using any html editor. More to come soon... ?! OK so there is a file called mysqldump I think i have to "run" this file which will create the database for me. Is this right? If so how do I do this? Hard to know what info you need to answer this query! Any any more Qs please ask. Cheers Notting
Just found a file called "db" which contains: -- -- Table structure for table `arcade_admin` -- CREATE TABLE `arcade_admin` ( `id` int(11) NOT NULL auto_increment, `user_name` varchar(255) NOT NULL default '', `password` varchar(255) NOT NULL default '', `email` varchar(255) NOT NULL default '', PRIMARY KEY (`id`) ) TYPE=MyISAM AUTO_INCREMENT=2 ; -- -- Dumping data for table `arcade_admin` -- INSERT INTO `arcade_admin` VALUES (1, 'admin', '123456', 'info@phpconstruct.com'); -- -------------------------------------------------------- -- -- Table structure for table `arcade_cats` -- CREATE TABLE `arcade_cats` ( `cat` varchar(100) NOT NULL default '' ) TYPE=MyISAM; -- -- Dumping data for table `arcade_cats` -- INSERT INTO `arcade_cats` VALUES ('puzzle'); INSERT INTO `arcade_cats` VALUES ('action'); INSERT INTO `arcade_cats` VALUES ('adventure'); INSERT INTO `arcade_cats` VALUES ('other'); -- -------------------------------------------------------- -- -- Table structure for table `arcade_games` -- CREATE TABLE `arcade_games` ( `id` int(11) NOT NULL auto_increment, `cat` varchar(100) NOT NULL default '', `game` varchar(255) NOT NULL default '', `game_desc` varchar(255) NOT NULL default '', `game_image` varchar(255) NOT NULL default '', `game_file` varchar(255) NOT NULL default '', `num_plays` int(11) NOT NULL default '0', `status` int(11) NOT NULL default '0', `featured` int(11) NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM AUTO_INCREMENT=100 ; -- -- Dumping data for table `arcade_games` -- INSERT INTO `arcade_games` VALUES (1, 'puzzle', 'Reel Gold', 'A great game.', 'reelgoldsmallicon.jpg', 'reelgold.inc.php', 0, 1, 1); INSERT INTO `arcade_games` VALUES (2, 'action', '3 Foot Ninja 2', '', 'ninja2smallicon.gif', '3footninja2.inc.php', 0, 1, 1); INSERT INTO `arcade_games` VALUES (3, 'action', 'Aqua', '', 'aquasmallicon.gif', 'aqua.inc.php', 0, 1, 1); INSERT INTO `arcade_games` VALUES (4, 'adventure', 'Beach Tennis', '', 'beachtennissmallicon.gif', 'beachtennis.inc.php', 0, 1, 1); INSERT INTO `arcade_games` VALUES (5, 'action', '3 Foot Ninja', '', '3FootNinjasmallicon.gif', '3footninja.inc.php', 0, 1, 0); INSERT INTO `arcade_games` VALUES (6, '', 'Dancing Hillary', '', 'dancinghillarysmallicon.gif', 'dancinghillary.inc.php', 0, 1, 0); INSERT INTO `arcade_games` VALUES (7, '', 'Adventure Elf', '', 'adventureelfsmallicon.gif', 'adventureelf.inc.php', 0, 1, 1); INSERT INTO `arcade_games` VALUES (8, '', 'Alien Abduction', '', 'alienabductionsmallicon.gif', 'alienabduction.inc.php', 0, 1, 1); INSERT INTO `arcade_games` VALUES (9, '', 'Alien Attack', '', 'alienattacksmallicon.gif', 'alienattack.inc.php', 0, 1, 1); INSERT INTO `arcade_games` VALUES (10, '', 'Alien Clones', '', 'alienclonessmallicon.gif', 'alienclones.inc.php', 0, 1, 1); INSERT INTO `arcade_games` VALUES (11, '', 'Badaboom', '', 'badaboomsmallicon.gif', 'badaboom.inc.php', 0, 1, 1); INSERT INTO `arcade_games` VALUES (12, '', 'Baseball', '', 'baseballsmallicon.gif', 'baseball.inc.php', 0, 1, 1); INSERT INTO `arcade_games` VALUES (13, '', 'Battle Pong', '', 'battlepongsmallicon.gif', 'battlepong.inc.php', 0, 1, 1); INSERT INTO `arcade_games` VALUES (14, '', 'Battleships', '', 'battleshipssmallicon.gif', 'battleships.inc.php', 0, 1, 1); INSERT INTO `arcade_games` VALUES (15, '', 'Black Jack Elf', '', 'blackjackelfsmallicon.gif', 'blackjackelf.inc.php', 0, 1, 1); INSERT INTO `arcade_games` VALUES (16, '', 'Bloomin Gardens', '', 'bloomingardenssmallicon.gif', 'bloomingardens.inc.php', 0, 1, 0); INSERT INTO `arcade_games` VALUES (17, '', 'Blox Forever', '', 'bloxforeversmallicon.gif', 'bloxforever.inc.php', 0, 1, 0); INSERT INTO `arcade_games` VALUES (18, '', 'Boom Boom', '', 'boomboomsmallicon.gif', 'boomboom.inc.php', 0, 1, 0); INSERT INTO `arcade_games` VALUES (19, '', 'Bubble Trouble', '', 'bubbletroublesmallicon.gif', 'bubbletrouble.inc.php', 0, 1, 0); INSERT INTO `arcade_games` VALUES (20, '', 'Bug On A Wire', '', 'bugonawiresmallicon.gif', 'bugonawire.inc.php', 0, 1, 0); INSERT INTO `arcade_games` VALUES (21, '', 'Bunch', '', 'bunchsmallicon.gif', 'bunch.inc.php', 0, 1, 0); INSERT INTO `arcade_games` VALUES (22, '', 'Bush Aerobics', '', 'bushaerobicssmallicon.gif', 'bushaerobics.inc.php', 0, 1, 0); INSERT INTO `arcade_games` VALUES (23, '', 'Bush Royal Rampage', '', 'bushroyalrampagesmallicon.gif', 'bushroyalrampage.inc.php', 0, 1, 0); INSERT INTO `arcade_games` VALUES (24, '', 'Bush Shootout', '', 'bushshootoutsmallicon.gif', 'bushshootout.inc.php', 0, 1, 0); INSERT INTO `arcade_games` VALUES (25, '', 'Cable Capers', '', 'cablecaperssmallicon.gif', 'cablecapers.inc.php', 0, 1, 0); INSERT INTO `arcade_games` VALUES (26, '', 'Canyon Glider', '', 'canyonglidersmallicon.gif', 'canyonglider.inc.php', 0, 1, 0); INSERT INTO `arcade_games` VALUES (27, '', 'Carnival Jackpot', '', 'carnivaljackpotsmallicon.gif', 'carnivaljackpot.inc.php', 0, 1, 0); INSERT INTO `arcade_games` VALUES (28, '', 'Couronne Deluxe', '', 'couronnedeluxesmallicon.gif', 'couronnedeluxe.inc.php', 0, 1, 0); INSERT INTO `arcade_games` VALUES (29, '', 'Crash Down', '', 'crashdownsmallicon.gif', 'crashdown.inc.php', 0, 1, 0); INSERT INTO `arcade_games` VALUES (30, '', 'Crimson Viper', '', 'crimsonvipersmallicon.gif', 'crimsonviper.inc.php', 0, 1, 0); INSERT INTO `arcade_games` VALUES (31, '', 'Crypt Raider', '', 'cryptraidersmallicon.gif', 'cryptraider.inc.php', 0, 1, 0); INSERT INTO `arcade_games` VALUES (32, '', 'Cube Buster', '', 'cubebustersmallicon.gif', 'cubebuster.inc.php', 0, 1, 0); INSERT INTO `arcade_games` VALUES (33, '', 'Dancing Bush', '', 'dancingbushsmallicon.gif', 'dancingbush.inc.php', 0, 1, 0); INSERT INTO `arcade_games` VALUES (34, '', 'Dancing Cherie', '', 'dancingcheriesmallicon.gif', 'dancingcherie.inc.php', 0, 1, 0); INSERT INTO `arcade_games` VALUES (35, '', 'Da Numba', '', 'danumbasmallicon.gif', 'danumba.inc.php', 0, 1, 0); INSERT INTO `arcade_games` VALUES (36, '', 'Disc Golf', '', 'discgolfsmallicon.gif', 'discgolf.inc.php', 0, 1, 0); INSERT INTO `arcade_games` VALUES (37, '', 'Dr Carter', '', 'drcartersmallicon.gif', 'drcarter.inc.php', 0, 1, 1); INSERT INTO `arcade_games` VALUES (38, '', 'Field Goal', '', 'fieldgoalsmallicon.gif', 'fieldgoal.inc.php', 0, 1, 0); INSERT INTO `arcade_games` VALUES (39, '', 'Flash Man', '', 'flashmansmallicon.gif', 'flashman.inc.php', 0, 1, 0); INSERT INTO `arcade_games` VALUES (40, '', 'Fowl Words 2', '', 'fowlwords2smallicon.gif', 'fowlwords2.inc.php', 0, 1, 0); INSERT INTO `arcade_games` VALUES (41, '', 'Frank', '', 'franksmallicon.gif', 'frank.inc.php', 0, 1, 0); INSERT INTO `arcade_games` VALUES (42, '', 'Gravity', '', 'gravitysmallicon.gif', 'gravity.inc.php', 0, 1, 1); INSERT INTO `arcade_games` VALUES (43, '', 'Gyro Ball', '', 'gyroballsmallicon.gif', 'gyroball.inc.php', 0, 1, 0); INSERT INTO `arcade_games` VALUES (44, '', 'Harvey Wallbanger', '', 'harveywallbangersmallicon.gif', 'harveywallbanger.inc.php', 0, 1, 0); INSERT INTO `arcade_games` VALUES (45, '', 'Hostile Skies', '', 'hostileskiessmallicon.gif', 'hostileskies.inc.php', 0, 1, 0); INSERT INTO `arcade_games` VALUES (46, '', 'Ice Breakout', '', 'icebreakoutsmallicon.gif', 'icebreakout.inc.php', 0, 1, 0); INSERT INTO `arcade_games` VALUES (47, '', 'Kerry Aerobics', '', 'kerryaerobicssmallicon.gif', 'kerryaerobics.inc.php', 0, 1, 0); INSERT INTO `arcade_games` VALUES (48, '', 'King Of The Hill', '', 'kingofthehillsmallicon.gif', 'kingofthehill.inc.php', 0, 1, 0); INSERT INTO `arcade_games` VALUES (49, '', 'Letter Rip', '', 'letterripsmallicon.gif', 'letterrip.inc.php', 0, 1, 0); INSERT INTO `arcade_games` VALUES (50, '', 'Lunar Command', '', 'lunarcommandsmallicon.gif', 'lunarcommand.inc.php', 0, 1, 0); INSERT INTO `arcade_games` VALUES (51, '', 'Mahjongg', '', 'mahjonggsmallicon.gif', 'mahjongg.inc.php', 0, 1, 0); INSERT INTO `arcade_games` VALUES (52, '', 'Miniclip Rally', '', 'minicliprallysmallicon.gif', 'minicliprally.inc.php', 0, 1, 0); INSERT INTO `arcade_games` VALUES (53, '', 'Mission Mars', '', 'missionmarssmallicon.gif', 'missionmars.inc.php', 0, 1, 0); INSERT INTO `arcade_games` VALUES (54, '', 'Monkey Lander', '', 'monkeylandersmallicon.gif', 'monkeylander.inc.php', 0, 1, 0); INSERT INTO `arcade_games` VALUES (55, '', 'Nordic Chill', '', 'nordicchillsmallicon.gif', 'nordicchill.inc.php', 0, 1, 0); INSERT INTO `arcade_games` VALUES (56, '', 'Paintball', '', 'paintballsmallicon.gif', 'paintball.inc.php', 0, 1, 0); INSERT INTO `arcade_games` VALUES (57, '', 'Panik', '', 'paniksmallicon.gif', 'panik.inc.php', 0, 1, 0); INSERT INTO `arcade_games` VALUES (58, '', 'Pearl Diver', '', 'pearldiversmallicon.gif', 'pearldiver.inc.php', 0, 1, 0); INSERT INTO `arcade_games` VALUES (59, '', 'Penga Pop', '', 'pengapopsmallicon.gif', 'pengapop.inc.php', 0, 1, 0); INSERT INTO `arcade_games` VALUES (60, '', 'Pharaohs Tomb', '', 'pharaohstombsmallicon.gif', 'pharaohstomb.inc.php', 0, 1, 0); INSERT INTO `arcade_games` VALUES (61, '', 'Pipe Down', '', 'pipedownsmallicon.gif', 'pipedown.inc.php', 0, 1, 0); INSERT INTO `arcade_games` VALUES (62, '', 'Presidential Knockout', '', 'presidentialknockoutsmallicon.gif', 'presidentialknockout.inc.php', 0, 1, 0); INSERT INTO `arcade_games` VALUES (63, '', 'Red Beard', '', 'redbeardsmallicon.gif', 'redbeard.inc.php', 0, 1, 0); INSERT INTO `arcade_games` VALUES (64, '', 'Rigelian Hotshots', '', 'rigelianhotshotssmallicon.gif', 'rigelianhotshots.inc.php', 0, 1, 0); INSERT INTO `arcade_games` VALUES (65, '', 'Rocket Man', '', 'rocketmansmallicon.gif', 'rocketman.inc.php', 0, 1, 0); INSERT INTO `arcade_games` VALUES (66, '', 'Roll On', '', 'rollonsmallicon.gif', 'rollon.inc.php', 0, 1, 0); INSERT INTO `arcade_games` VALUES (67, '', 'Rural Racer', '', 'ruralracersmallicon.gif', 'ruralracer.inc.php', 0, 1, 0); INSERT INTO `arcade_games` VALUES (68, '', 'Samurai', '', 'samuraismallicon.gif', 'samurai.inc.php', 0, 1, 0); INSERT INTO `arcade_games` VALUES (69, '', 'Santa Balls 2', '', 'santaballs2smallicon.gif', 'santaballs2.inc.php', 0, 1, 0); INSERT INTO `arcade_games` VALUES (70, '', 'Save The Sheriff', '', 'savethesheriffsmallicon.gif', 'savethesheriff.inc.php', 0, 1, 0); INSERT INTO `arcade_games` VALUES (71, '', 'Sheepish', '', 'sheepishsmallicon.gif', 'sheepish.inc.php', 0, 1, 0); INSERT INTO `arcade_games` VALUES (72, '', 'Shove It', '', 'shoveitsmallicon.gif', 'shoveit.inc.php', 0, 1, 0); INSERT INTO `arcade_games` VALUES (73, '', 'Skidoo TT', '', 'skidoottsmallicon.gif', 'skidoott.inc.php', 0, 1, 0); INSERT INTO `arcade_games` VALUES (74, '', 'Ski Jump', '', 'skijumpsmallicon.gif', 'skijump.inc.php', 0, 1, 0); INSERT INTO `arcade_games` VALUES (75, '', 'Slackers', '', 'slackerssmallicon.gif', 'slackers.inc.php', 0, 1, 0); INSERT INTO `arcade_games` VALUES (76, '', 'Slingshot', '', 'slingshotsmallicon.gif', 'slingshot.inc.php', 0, 1, 0); INSERT INTO `arcade_games` VALUES (77, '', 'Smashing', '', 'smashingsmallicon.gif', 'smashing.inc.php', 0, 1, 0); INSERT INTO `arcade_games` VALUES (78, '', 'Snake', '', 'snakesmallicon.gif', 'snake.inc.php', 0, 1, 0); INSERT INTO `arcade_games` VALUES (79, '', 'Snowboarding XS', '', 'snowboardingxssmallicon.gif', 'snowboardingxs.inc.php', 0, 1, 0); INSERT INTO `arcade_games` VALUES (80, '', 'Space Escape', '', 'spaceescapesmallicon.gif', 'spaceescape.inc.php', 0, 1, 0); INSERT INTO `arcade_games` VALUES (81, '', 'Space Fighter', '', 'spacefightersmallicon.gif', 'spacefighter.inc.php', 0, 1, 0); INSERT INTO `arcade_games` VALUES (82, '', 'Space Invaders', '', 'spaceinvaderssmallicon.gif', 'spaceinvaders.inc.php', 0, 1, 0); INSERT INTO `arcade_games` VALUES (83, '', 'Stan', '', 'stansmallicon.gif', 'stan.inc.php', 0, 1, 0); INSERT INTO `arcade_games` VALUES (84, '', 'Sub Commander', '', 'subcommandersmallicon.gif', 'subcommander.inc.php', 0, 1, 0); INSERT INTO `arcade_games` VALUES (85, '', 'Super Bike', '', 'superbikesmallicon.gif', 'superbike.inc.php', 0, 1, 0); INSERT INTO `arcade_games` VALUES (86, '', 'Surfs Up', '', 'surfsupsmallicon.gif', 'surfsup.inc.php', 0, 1, 0); INSERT INTO `arcade_games` VALUES (87, '', 'Twiddle Stix', '', 'twiddlestixsmallicon.gif', 'twiddlestix.inc.php', 0, 1, 0); INSERT INTO `arcade_games` VALUES (88, '', 'United We Dance', '', 'unitedwedancesmallicon.gif', 'unitedwedance.inc.php', 0, 1, 0); INSERT INTO `arcade_games` VALUES (89, '', 'VertiGolf', '', 'vertigolfsmallicon.gif', 'vertigolf.inc.php', 0, 1, 0); INSERT INTO `arcade_games` VALUES (90, '', 'VertiGolf 2', '', 'vertigolf2smallicon.gif', 'vertigolf2.inc.php', 0, 1, 0); INSERT INTO `arcade_games` VALUES (91, '', 'Wakeboarding', '', 'wakeboardingsmallicon.gif', 'wakeboarding.inc.php', 0, 1, 0); INSERT INTO `arcade_games` VALUES (92, '', 'War On Terrorism', '', 'waronterrorismsmallicon.gif', 'waronterrorism.inc.php', 0, 1, 0); INSERT INTO `arcade_games` VALUES (93, '', 'Warrior', '', 'warriorsmallicon.gif', 'warrior.inc.php', 0, 1, 0); INSERT INTO `arcade_games` VALUES (94, '', 'White House Joust', '', 'whitehousejoustsmallicon.gif', 'whitehousejoust.inc.php', 0, 1, 0); INSERT INTO `arcade_games` VALUES (95, '', 'Wordo', '', 'wordosmallicon.gif', 'wordo.inc.php', 0, 1, 0); INSERT INTO `arcade_games` VALUES (96, 'action', 'Xraye', '', 'xrayesmallicon.gif', 'xraye.inc.php', 0, 1, 0); INSERT INTO `arcade_games` VALUES (97, '', 'Zed', '', 'zedsmallicon.gif', 'zed.inc.php', 0, 1, 0); -- -------------------------------------------------------- -- -- Table structure for table `arcade_news` -- CREATE TABLE `arcade_news` ( `id` int(11) NOT NULL auto_increment, `news_header` varchar(255) NOT NULL default '', `news_body` varchar(255) NOT NULL default '', `news_image` varchar(255) NOT NULL default '', `news_date` varchar(255) NOT NULL default '', `news_submitted_by` varchar(255) NOT NULL default '', `status` int(11) NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM AUTO_INCREMENT=9 ; -- -- Dumping data for table `arcade_news` -- INSERT INTO `arcade_news` VALUES (8, 'Welcome To MikesFunGames.com', 'Over 100 games and counting.', '', '', '', 1); Code (markup):
If you have phpMyAdmin (or something similar) installed on your server you could log in to that and find the SQL query option. Paste the contents of the db-file into the form. Click on OK and the database will be created (if you have permission to create new database, that is).
and once you've done that I guess you'd have to edit the config.php file to match your mysql username and password.
mysqladmin create [name you want to call the db] mysql [name from above] < db You may need to add the -p option to the above so you are asked for a password, depends on your server. This is assuming you have command line access on your server. If you only have access via cpanel or similar, I can't help you, don't use cpanel. You will also need to set up a user that can access the db: mysql [name of db] grant all privileges on [name of db].* to [username]@"localhost" identified by '[password]'; Again you may need the -p option to enter a password HTH,