[ help ] - Advanced String Manipulation

From: Charles (me_at_privacy.net)
Date: 09/25/04

  • Next message: Wes S.: "Re: image resize" 
    Date: Fri, 24 Sep 2004 21:29:27 -0300

    I have to convert a forum MySQL database (Gold Sonata Cyboard) into
    another one (vBulletin)
    I am beginner at PHP/MySQL, and I'd need some help please. I haven't been
    able to find what I needed on PHP.NET
    Here's what I have as the old forum data base structure:

    CREATE TABLE `board_data` (
       `id` int(10) unsigned NOT NULL auto_increment,
       `board` int(10) unsigned NOT NULL default '0',
       `thread` int(10) unsigned NOT NULL default '0',
       `parent` int(10) unsigned NOT NULL default '0',
       `author` varchar(64) NOT NULL default '',
       `email` varchar(64) NOT NULL default '',
       `subject` varchar(128) NOT NULL default '',
       `body` text NOT NULL,
       `datestamp` timestamp(14) NOT NULL,
       `ip` varchar(16) NOT NULL default '',
       `host` varchar(128) NOT NULL default '',
       `vipflag` varchar(255) NOT NULL default '',
       `link` varchar(128) NOT NULL default '',
       `linkname` varchar(128) NOT NULL default '',
       `image` varchar(128) NOT NULL default '',
       `locked` tinyint(4) NOT NULL default '0',
       `sticky` tinyint(4) NOT NULL default '0',
       `email_replies` tinyint(4) NOT NULL default '0',
       `hide_email` tinyint(4) NOT NULL default '0',
       PRIMARY KEY (`id`),
       KEY `board` (`board`,`thread`,`parent`)
    ) TYPE=MyISAM AUTO_INCREMENT=331 ;

    And here's the new structure that I have to deal with:

    CREATE TABLE `post` (
       `postid` int(10) unsigned NOT NULL auto_increment,
       `threadid` int(10) unsigned NOT NULL default '0',
       `parentid` int(10) unsigned NOT NULL default '0',
       `username` varchar(50) NOT NULL default '',
       `userid` int(10) unsigned NOT NULL default '0',
       `title` varchar(250) NOT NULL default '',
       `dateline` int(10) unsigned NOT NULL default '0',
       `pagetext` mediumtext NOT NULL,
       `allowsmilie` smallint(6) NOT NULL default '0',
       `showsignature` smallint(6) NOT NULL default '0',
       `ipaddress` varchar(15) NOT NULL default '',
       `iconid` smallint(5) unsigned NOT NULL default '0',
       `visible` smallint(6) NOT NULL default '0',
       `attach` smallint(5) unsigned NOT NULL default '0',
       PRIMARY KEY (`postid`),
       KEY `iconid` (`iconid`),
       KEY `userid` (`userid`),
       KEY `threadid` (`threadid`,`userid`)
    ) TYPE=MyISAM AUTO_INCREMENT=2 ;

    What I'd like to do is an update.php script to run off the server and grab
    the data from the first forum to the new one. There are some information
    on the old forum that I won't need anymore (ie: link, linkname, etc...).
    My script still will have to come up with unprovided information to fill
    in (ie: ipaddress, visible...)

    I'd like to know how to do it, and learn. Do you have good tutorials to
    learn? Or could you show me how to do this?
    Thanks,

    Charles.

  • Next message: Wes S.: "Re: image resize"

    Relevant Pages

    • Re: USB not working
      ... You give no information about the script for the script. ... In the forum post you post blind references to 2 KB articles* but you do not state the the scripts are an automated way to perform the Resolutions. ... *Windows XP or Windows Server 2003 does not detect your new USB device: ... A computer that is running Windows XP cannot detect a USB thumb drive, an Apple iPod, or an external hard disk drive: ...
      (microsoft.public.windowsxp.general)
    • RE: Forcing of Absolute Hyperlinks
      ... Thank you for posting in our Partner Online Technical Community. ... However, the script ... POTC on Forum whilst the "New" option will be removed from NNTP newsgroup. ...
      (microsoft.public.office.setup)
    • PHP Forum Script
      ... I am looking for a script that act as a Simple Forum, ... Can use MySQL. ... "registered users" feature, ... Do anyone knows about a PHP forum script that does not have user ...
      (comp.lang.php)
    • Re: USB not working
      ... You give no information about the script (e.g., what problems it's supposed to fix; how it fixes them) for the script. ... In the forum post you post blind references to 2 KB articles* but you do not state the the scripts are an automated way to perform the Resolutions. ...
      (microsoft.public.windowsxp.general)
    • Re: AARoads Forum is back
      ... banned, but you can't deny that I made that forum what it is, and now ... They also stole the script for a chatroom that I paid for. ... with the admin of AARoads in regards to the purchase of "your" script ...
      (misc.transport.road)