Wanted someone that can convert article database

I am looking for someone that can convert an article dashboard sql to another sql
here is the structure for articledashboard

CREATE TABLE `bla bla bla` (
  `article_id` bigint(20) NOT NULL auto_increment,
  `author_id` int(11) NOT NULL default '0',
  `penname_id` int(11) NOT NULL default '0',
  `category_id` int(11) NOT NULL default '0',
  `article_title` varchar(200) NOT NULL default '',
  `article_sum` text NOT NULL,
  `article_body` text NOT NULL,
  `article_res` text NOT NULL,
  `article_key` text NOT NULL,
  `posteddate` date NOT NULL default '0000-00-00',
  `revieweddate` date NOT NULL default '0000-00-00',
  `modifieddate` date NOT NULL default '0000-00-00',
  `status` enum('F','M','A','D') NOT NULL default 'F',
  `ip` varchar(20) NOT NULL default '',
  `article_downloads` int(11) NOT NULL default '0',
  `article_wordcount` int(11) NOT NULL default '0',
  `reviewedip` varchar(20) NOT NULL default '',
  PRIMARY KEY  (`article_id`),
  KEY `IX_author` (`author_id`),
  KEY `IX_pen` (`penname_id`),
  KEY `IX_category` (`category_id`),
  KEY `IX_status` (`status`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=19140 ;

Code (markup):

and here for what I want

CREATE TABLE `blah blah blah` (
  `ID` int(11) NOT NULL auto_increment,
  `TITLE` varchar(255) NOT NULL default '',
  `DESCRIPTION` longtext,
  `ARTICLE` longtext,
  `CATEGORY_ID` int(11) NOT NULL default '0',
  `STATUS` int(11) NOT NULL default '1',
  `DATE_MODIFIED` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `DATE_ADDED` timestamp NOT NULL default '0000-00-00 00:00:00',
  `IPADDRESS` varchar(15) default NULL,
  PRIMARY KEY  (`ID`),
  KEY `PLD_ARTICLE_TITLE_IDX` (`TITLE`),
  KEY `PLD_ARTICLE_CATEGORY_ID_IDX` (`CATEGORY_ID`),
  KEY `PLD_ARTICLE_STATUS_IDX` (`STATUS`),
  FULLTEXT KEY `PLD_ARTICLE_DESCRIPTION_IDX` (`DESCRIPTION`),
  FULLTEXT KEY `PLD_ARTICLE_ARTICLE_IDX` (`ARTICLE`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

Code (markup):

 

I am still looking for someone to convert over 47000 articles to go into phpld article structure

 

Hey, I can do this job, too.
If still looking, drop me another PM and let's get started.

 

i think you can't used the articles on articledashboard since the database for AD is encrypted. so you need to decrypt the article before displaying it to your phpld .

BUT if you changed your mind and continue using your AD Directory, i can customize the design according to your need. see my sample AD. demo .

Thanks,
eli

 

on the ad all you have to do is change blob to text and the mysql is is no longer encryped as far as the articles go as i have done it with 10 of them so far