[WTB] Articles CMS that works with this DB structure

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • ProRankTracker
    PRT
    • May 2006
    • 263

    #1

    [WTB] Articles CMS that works with this DB structure

    Hi,

    I have a DB with this structure:

    Code:
    DROP TABLE IF EXISTS articles;
    CREATE TABLE articles (
      id int(10) unsigned NOT NULL auto_increment,
      categ int(3) unsigned NOT NULL default '0',
      title varchar(250) default NULL,
      author varchar(250) default NULL,
      date_pub int(20) unsigned default NULL,
      site varchar(200) default NULL,
      PRIMARY KEY (id),
      UNIQUE KEY id(id),
      KEY categ(categ)
    ) TYPE=INNODB;
    
    #
    
    INSERT INTO articles VALUES("1", "1", "Sell More Books With an E-mail Newsletter", "Alexandria K. Brown", "1126962450", "ezinearticles.com");
    
    #
    
    DROP TABLE IF EXISTS articles_text;
    CREATE TABLE articles_text (
      id int(10) unsigned NOT NULL default '0',
      content text,
      KEY id(id)
    ) TYPE=INNODB;
    
    
    INSERT INTO articles_text VALUES("1", "<p><i>NOTE: Because many words in this article are likely to trigger sp^m filters, we\'ve disguised them with symbols (e.g. sp^m). This will ensure a higher delivery rate if you use this article in your e-zine.</i></p>\r\n\r\n<p>If you\'re selling your... at the END of my sig file, after my contact information: \"BOOST BUSINESS by publishing your own e-mail newsletter! Learn how now ? sign up for fr*ee how-to tips at http://www.ezinequeen.com.\"</li>\r\n</ol>\r\n\r\n<p>(c) 2000-2003 Alexandria K. Brown. All rights reserved.</p><p>ABOUT THE AUTHOR</p>");
    I need an Articles CMS that can work with it (SE friendly, Mod_Rewrite, Good admin panel)..

    Please post/pm if you have anything to offer.

    Thanks,
    E-A.
  • fetishblog
    Confirmed User
    • Sep 2005
    • 5995

    #2
    Try out http://www.articletrader.com/articlems/.

    It's free.

    Fling.com doesn't steal your traffic and sales unlike some other dating companies. I promote them, and so should you!

    Comment

    Working...