SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Enthusiast
    Join Date
    May 2010
    Location
    Indonesia
    Posts
    27
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Convert Other MySQL Into Wordpress Database

    Hello, anybody know how to convert other mysql database into wordpress ?

    Other database:
    Code MySQL:
    -- --------------------------------------------------------
     
    --
    -- Table structure for table `files`
    --
     
    CREATE TABLE `files` (
      `fileid` int(11) NOT NULL AUTO_INCREMENT,
      `file` text NOT NULL,
      `icon` varchar(200) NOT NULL,
      `filelocation` enum('1','2','3') NOT NULL DEFAULT '1',
      `iconlocation` enum('1','2') NOT NULL DEFAULT '1',
      `customcode` text NOT NULL,
      `title` varchar(150) NOT NULL,
      `description` varchar(255) NOT NULL,
      `keywords` varchar(255) NOT NULL,
      `width` smallint(5) NOT NULL DEFAULT '0',
      `height` smallint(5) NOT NULL DEFAULT '0',
      `category` mediumint(6) NOT NULL DEFAULT '0',
      `timesplayed` int(11) NOT NULL DEFAULT '0',
      `status` tinyint(1) NOT NULL DEFAULT '0',
      `filetype` varchar(25) NOT NULL,
      `dateadded` int(10) NOT NULL DEFAULT '0',
      `rating` decimal(3,2) NOT NULL DEFAULT '0.00',
      `totalvotes` int(11) NOT NULL DEFAULT '0',
      `totalvotepoints` int(11) NOT NULL DEFAULT '0',
      `added_by` int(11) NOT NULL DEFAULT '0',
      `adult` enum('0','1') NOT NULL DEFAULT '0',
      `scores` enum('0','1') NOT NULL DEFAULT '0',
      `score_type` enum('1','2') NOT NULL DEFAULT '1',
      `score_name` varchar(50) NOT NULL DEFAULT '',
      `plugs` tinyint(1) NOT NULL DEFAULT '0',
      `sponsor_title` varchar(150) NOT NULL DEFAULT '',
      `sponsor_url` varchar(255) NOT NULL DEFAULT '',
      PRIMARY KEY (`fileid`),
      KEY `category` (`category`),
      KEY `title` (`title`),
      FULLTEXT KEY `search` (`title`,`description`,`keywords`)
    ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
     
    --
    -- Dumping data for table `files`
    --
     
    INSERT INTO `files` VALUES(1, 'k.swf', 'ggg.gif', '1', '1', '', 'test', 'test', 't, t, te', 600, 600, 61, 0, 1, 'SWF', 1308247587, 0.00, 0, 0, 1, '0', '0', '1', '', 0, '', '');
    INSERT INTO `files` VALUES(2, 'http://www.example.com/s.swf', 'test.jpg', '2', '1', '', 'test2', 'gggggggg', 'c, g', 600, 600, 61, 0, 1, 'SWF', 1308247641, 0.00, 0, 0, 1, '0', '0', '1', '', 0, '', '');
    INSERT INTO `files` VALUES(3, '', 'my.jpg', '2', '1', '<iframe src=\\''http://games.211games.com/b/dora/diego-safari-rescue/Loader.swf\\'' width=\\''650\\'' height=\\''430\\'' scrolling=\\''no\\'' frameborder=\\''0\\'' marginwidth=\\''0\\'' marginheight=\\''0\\'' name=\\''afplay\\''></iframe>\n', 'test3', 'ifram code', '', 0, 0, 61, 0, 1, 'code', 1308247711, 0.00, 0, 0, 1, '0', '0', '1', '', 0, '', '');

    Into Wordpress database:
    Code MySQL:
    -- --------------------------------------------------------
     
    --
    -- Table structure for table `wp_myarcadegames`
    --
     
    CREATE TABLE `wp_myarcadegames` (
      `id` int(11) NOT NULL AUTO_INCREMENT,
      `postid` text COLLATE utf8_unicode_ci NOT NULL,
      `uuid` text COLLATE utf8_unicode_ci NOT NULL,
      `game_tag` text COLLATE utf8_unicode_ci NOT NULL,
      `game_type` text COLLATE utf8_unicode_ci NOT NULL,
      `name` text COLLATE utf8_unicode_ci NOT NULL,
      `slug` text COLLATE utf8_unicode_ci NOT NULL,
      `categories` text COLLATE utf8_unicode_ci NOT NULL,
      `description` text COLLATE utf8_unicode_ci NOT NULL,
      `tags` text COLLATE utf8_unicode_ci NOT NULL,
      `instructions` text COLLATE utf8_unicode_ci NOT NULL,
      `controls` text COLLATE utf8_unicode_ci NOT NULL,
      `rating` text COLLATE utf8_unicode_ci NOT NULL,
      `height` text COLLATE utf8_unicode_ci NOT NULL,
      `width` text COLLATE utf8_unicode_ci NOT NULL,
      `thumbnail_url` text COLLATE utf8_unicode_ci NOT NULL,
      `swf_url` text COLLATE utf8_unicode_ci NOT NULL,
      `screen1_url` text COLLATE utf8_unicode_ci NOT NULL,
      `screen2_url` text COLLATE utf8_unicode_ci NOT NULL,
      `screen3_url` text COLLATE utf8_unicode_ci NOT NULL,
      `screen4_url` text COLLATE utf8_unicode_ci NOT NULL,
      `video_url` text COLLATE utf8_unicode_ci NOT NULL,
      `created` text COLLATE utf8_unicode_ci NOT NULL,
      `leaderboard_enabled` text COLLATE utf8_unicode_ci NOT NULL,
      `highscore_type` text COLLATE utf8_unicode_ci NOT NULL,
      `coins_enabled` text COLLATE utf8_unicode_ci NOT NULL,
      `status` text COLLATE utf8_unicode_ci NOT NULL,
      PRIMARY KEY (`id`)
    ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=8 ;
     
    --
    -- Dumping data for table `wp_myarcadegames`
    --
     
    INSERT INTO `wp_myarcadegames` VALUES(1, '17', '47d046c096eda8c222b4ae96d77a54b2', '1012488684', 'embed', 'test1 emb', 'test1-emb', 'العاب ذكاء', 'لعبة سبونج بوب سيارات مع بسيط و شخصيات نكلوديون في اقوى سباق *لقات نكلوديون مع سبونجبوب', '', '', '', '', '', '', 'http://localhost:8888/newp/wp-content/thumbs/4sqk5e_2.58134579974E+18_logo.png', '<object id=\\''UnityObject\\'' width=\\''640\\'' height=\\''450\\'' codebase=\\''http://webplayer.unity3d.com/download_webplayer/UnityWebPlayer.cab#version=2,0,0,0\\'' classid=\\''clsid:444785F1-DE89-4295-863A-D46C3A781394\\''>\r\n<param value=\\''http://www.nick.com/games/data/nickelodeon/nick-racers-revolution/game.unity3d\\'' name=\\''src\\''>\r\n<embed id=\\''UnityEmbed\\'' width=\\''640\\'' height=\\''450\\'' pluginspage=\\''http://www.unity3d.com/unity-web-player-2.x\\'' type=\\''application/vnd.unity\\'' src=\\''http://www.nick.com/games/data/nickelodeon/nick-racers-revolution/game.unity3d\\''>\r\n</object>', '', '', '', '', '', '2011-06-16 18:26:51', '', 'high', '', 'published');
    INSERT INTO `wp_myarcadegames` VALUES(2, '18', 'ba291e4fefdae4372db6d5f874d86c1e', '-722444701', 'custom', 'firstgame', 'firstgame', 'العاب سونيك', 'العاب تلبيس للبنات جديده 2012', '', '', '', '', '444', '556', 'http://localhost:8888/newp/wp-content/thumbs/oeopu5_1.08603510484E+18_2htkjzk8dk0_2617480884904079328_first_date_outfit.jpg', 'http://localhost:8888/newp/wp-content/games/ke8jec_2.59940990056E+18_76eefmjnjhs_1567785759865391420_first_date_outfit.swf', '', '', '', '', '', '2011-06-16 18:32:09', '', 'high', '', 'published');
    INSERT INTO `wp_myarcadegames` VALUES(3, '19', 'be79b131-74b4-3093-a51f-c9e955d72844', '191dae1c69992ff4', 'mochi', 'Halloween Vampire', 'halloween-vampire', 'Customize,Dress-Up,Driving,Other,Puzzles', 'It’s Halloween again and Vanessa is getting ready for a photo-shoot to win the Halloween vampire contest. She needs a scary looking makeover as well as a weird costume to complete the vampire effect. Apply a creepy looking makeover and dress her up in an equally bizarre costume to make her look really frightening. Let her earn the title of the perfect Halloween Vampire', 'halloween,vampire,dress up,dressupgames,gothic,evil,devil,night,scary,skill,costumes,dresses,clothes,outfits,accessories,makup,girls,online,flash,fun,free games', '', 'fire = na;jump = na;movement = na;', 'Everyone', '539', '683', 'http://games.mochiads.com/c/g/halloween-vampire/_thumb_100x100.jpg', 'http://games.mochiads.com/c/g/halloween-vampire/Halloween-Vampire.swf', '', '', '', '', '', '2011-06-11T03:42:47.911144-08:00', '', '', '', 'published');
    INSERT INTO `wp_myarcadegames` VALUES(4, '20', 'd4cee943-181a-3016-b23a-55630fc545f4', 'f24d3f2350274e4e', 'mochi', 'Carbon Auto Theft', 'carbon-auto-theft', 'Driving', 'Grab some wheels of STEAL. Become world''s greatest car thief!', 'carbon,auto,theft,car,drive,park,driving,parking,carbon auto theft,en', 'Use Arrow keys to drive and walk. Space for hand Brake.', 'fire = space;jump = na;movement = arrow;', 'Everyone', '530', '650', 'http://games.mochiads.com/c/g/carbon-auto-theft/_thumb_100x100.jpg', 'http://games.mochiads.com/c/g/carbon-auto-theft/carbon_auto_theft.swf', 'http://games.mochiads.com/c/g/carbon-auto-theft/screen1.jpg', 'http://games.mochiads.com/c/g/carbon-auto-theft/screen2.jpg', 'http://games.mochiads.com/c/g/carbon-auto-theft/screen3.jpg', 'http://games.mochiads.com/c/g/carbon-auto-theft/screen4.jpg', '', '2010-06-24T01:24:20.583118-08:00', '', '', '', 'published');
    INSERT INTO `wp_myarcadegames` VALUES(5, '', '0ee45c83-8932-327c-b956-7dd6a291a11d', '1230b9dfd19c2300', 'mochi', 'Dock My Boat', 'dock-my-boat', 'Action,Driving', 'Driving a boat is so hard, they call it "piloting." The boat keeps moving after you stop the engines! So be a swell sailor and put your boat back where it belongs, huh? Or maybe you should go back to parking slot cars.', 'Dock My Boat,Boat Games,Action Games', 'Arrow keys to steer boat', 'fire = na;jump = na;movement = na;', 'Everyone', '600', '800', 'http://games.mochiads.com/c/g/dock-my-boat/_thumb_100x100.jpg', 'http://games.mochiads.com/c/g/dock-my-boat/dockmyboat.swf', '', '', '', '', '', '2011-04-21T10:17:01.899685-08:00', '', '', '', 'new');
    INSERT INTO `wp_myarcadegames` VALUES(6, '', '65c25882-dd3b-3020-99ff-d8bc25b832b5', 'ad8e0f318ba738e7', 'mochi', 'Harv-E', 'harv-e', 'Action,Driving,Shooting,Strategy', 'Dig, blast and upgrade your way to finding love and friendship, one piece at a time.', 'robot,robots,mining,mine,dig,digging,fun,casual,upgrades,achievements,trophies,timing,skill,en', 'Use arrow keys or wasd keys to move and look around.\r\n\r\nClick to start digging.\r\n\r\nHold down the mouse button to activate your magnet once you have purchased it.\r\n\r\nMake sure your magnets radius touches the claw or it will have no effect.\r\n\r\nClick to pick up and place dynamite.', 'fire = left_mouse;jump = na;movement = wasd;', 'Everyone', '480', '640', 'http://games.mochiads.com/c/g/harv-e/_thumb_100x100.png', 'http://games.mochiads.com/c/g/harv-e/Harv-E.swf', 'http://games.mochiads.com/c/g/harv-e/screen1.jpg', '', '', '', '', '2011-05-23T09:39:21.988471-08:00', '', '', '', 'new');
    INSERT INTO `wp_myarcadegames` VALUES(7, '', '1a23e777-a932-3be6-8ce9-c4a77c64b733', '7af6643095664356', 'mochi', 'Dangers of dark night', 'dangers-of-dark-night', 'Action,Adventure,Driving,Sports,Strategy', 'In a dark night, a hawk has lost from his folk. He was searching his group. Suddenly cruel tribes attacked him. Please help him to escape from: DANGERS OF DARK NIGHT', 'Hawk,Flying,Adventure,Keyboard,Swords,en', 'Use arrow keys to move.', 'fire = na;jump = na;movement = arrow;', 'Everyone', '500', '600', 'http://games.mochiads.com/c/g/dangers-of-dark-night/_thumb_100x100.jpg', 'http://games.mochiads.com/c/g/dangers-of-dark-night/darknight.swf', '', '', '', '', '', '2011-06-13T23:14:43.110870-08:00', '1', '', '', 'new');

  2. #2
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,341
    Mentioned
    63 Post(s)
    Tagged
    3 Thread(s)
    if you could please list all the target columns in the wp_myarcadegames table, and beside each one, please indicate which source column in the files table will provide the values for it
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  3. #3
    SitePoint Enthusiast
    Join Date
    May 2010
    Location
    Indonesia
    Posts
    27
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Mr moderator, please delete this thread.


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •