Code: Selecteer alles
CREATE TABLE phpbb_chapter (
fldAuto int(11) NOT NULL auto_increment,
faq_fldAuto int(11) DEFAULT '0' NOT NULL,
name varchar(50) NOT NULL,
orderingfield varchar(10) NOT NULL,
PRIMARY KEY (fldAuto),
UNIQUE fldAuto (fldAuto),
KEY fldAuto_2 (fldAuto, faq_fldAuto)
);
#
# Dumping data for table 'phpbb_chapter'
#
INSERT INTO phpbb_chapter VALUES ( '1', '1', 'General', 'ZZZZZZ');
INSERT INTO phpbb_chapter VALUES ( '2', '1', 'Download', 'ZZZZZZ');
INSERT INTO phpbb_chapter VALUES ( '3', '1', 'Help', 'ZZZZZZ');
# --------------------------------------------------------
#
# Table structure for table 'phpbb_faq'
#
CREATE TABLE phpbb_faq (
fldAuto int(11) NOT NULL auto_increment,
name varchar(50) NOT NULL,
descr text NOT NULL,
PRIMARY KEY (fldAuto),
UNIQUE fldAuto (fldAuto),
KEY fldAuto_2 (fldAuto)
);
#
# Dumping data for table 'phpbb_faq'
#
INSERT INTO phpbb_faq VALUES ( '1', 'ArticleMentor', 'A year ago or so I developed quite a few free scripts written in ASP ( <a href=\\\"http://www.aspcode.net/articlementor/index.php\\\">Listing here</a> ). Amongst other AdMentor ( a very popular banner rotation script ), a Postcard script, Poll script etc. I also developed ArticleMentor - which was a simple/lightweight content management system.
Now I have started porting ( and enhancing ) the scripts to PHP, and the first I release is ArticleMentor.
');
# --------------------------------------------------------
#
# Table structure for table 'phpbb_question'
#
CREATE TABLE phpbb_question (
fldAuto int(11) NOT NULL auto_increment,
chapter_fldAuto int(11) DEFAULT '0' NOT NULL,
question varchar(255) NOT NULL,
answer longtext NOT NULL,
orderingfield varchar(10) NOT NULL,
PRIMARY KEY (fldAuto),
UNIQUE fldAuto (fldAuto),
KEY fldAuto_2 (fldAuto, chapter_fldAuto)
);
#
# Dumping data for table 'phpbb_question'
#
INSERT INTO phpbb_question VALUES ( '1', '1', 'Presentation and features', 'ArticleMentor is a content management system with these features.
1. Lightweight. Few tables and few scripts.
2. MySQL database access
3. Three layered content structure - Categories, subcategories and the actual articles. For example I have a category \\\'ArticleMentor\\\', with subcategories \\\'Features\\\', \\\'Download\\\' etc and all subcategories contains articles
4. Show multipage articles ( with automatic next/prev buttons ). See example by looking at the Admin GUI screenshots
5. Articles can also be co called \\\'external links\\\' - when you just specify an url as articletext then when user clicks on the article he/she will be redirected to that url
6. Article should be able to contain HTML tags
', 'ZZZZZZ');
INSERT INTO phpbb_question VALUES ( '2', '2', 'Version log', '<b>1.0 2000-09-04</b>
First ASP version released.
<b>2.0 2001-08-23</b>
First PHP version released. Enhancements include:
- Better CSS support
', 'ZZZZZZ');
INSERT INTO phpbb_question VALUES ( '3', '1', 'Online DEMO - well you are looking at ArticleMentor right now...', 'http://www.aspcode.net/php/article/index.php', 'ZZZZZZ');
INSERT INTO phpbb_question VALUES ( '4', '1', 'Admin GUI screenshots', '<b>The system is administered with a webbased GUI, here are some screenshots:</b>
<img src=\\\"screenshots/image1.gif\\\">
<NEWPAGE>
<img src=\\\"screenshots/image2.gif\\\">
<NEWPAGE>
<img src=\\\"screenshots/image3.gif\\\">
', 'ZZZZZZ');
INSERT INTO phpbb_question VALUES ( '5', '3', 'Config issues', 'Create a database in MySQL ( lets say you call it artment ) and then run the script artmentor.sql.
Open up incconfig.php.
Change the rows
<EM>
$incdbhost = \\\"localhost\\\";
$incdbuser = \\\"youruser\\\";
$incdbpwd = \\\"yourpwd\\\";
$databasename = \\\"artment\\\";
</EM>
to reflect your installation.
Thats it. Now you should be able to run it.
Read on for more advanced configuration
<NEWPAGE>
<b>GUI configuration</b>
- style.css can be changed to get some other look
- also the file inctemplate.php. Change that file to reflect your own GUI - however be sure to look for the PHP variables so you don\\\'t delete them.
', 'ZZZZZZ');
en wat houd
Code: Selecteer alles
Change the prefix
within the file if you changed the default prefix(phpbb_) to something else.Alvast bedankt
