# phpMyAdmin MySQL-Dump # version 2.2.2 # http://phpwizard.net/phpMyAdmin/ # http://phpmyadmin.sourceforge.net/ (download page) # # Host: localhost # Generation Time: Mar 25, 2002 at 10:37 AM # Server version: 3.23.49 # PHP Version: 4.1.2 # Database : `goblin_demo` # -------------------------------------------------------- # # Table structure for table `whatdafaq` # CREATE TABLE whatdafaq ( id int(11) NOT NULL auto_increment, question varchar(255) default NULL, answer text, category int(11) default NULL, section enum('yes','no') NOT NULL default 'no', publish enum('yes','no') NOT NULL default 'no', ordering int(11) default NULL, date date default NULL, PRIMARY KEY (id) ) TYPE=MyISAM COMMENT='FAQs stored here'; # # Dumping data for table `whatdafaq` # INSERT INTO whatdafaq (id, question, answer, category, section, publish, ordering, date) VALUES (1, 'Introducing WhatDaFaq', '', 1, 'yes', 'yes', 7, NULL); INSERT INTO whatdafaq (id, question, answer, category, section, publish, ordering, date) VALUES (2, 'What is WhatDaFaq ?!?', '

WhatDaFaq is a FAQ creation tool. It allows you to build up a list of FAQs for your site visitors, using this simple admin tool.', 1, 'no', 'yes', 8, NULL); INSERT INTO whatdafaq (id, question, answer, category, section, publish, ordering, date) VALUES (3, 'What is WhatDaFaq written in?', 'WhatDaFaq is written in PHP (a free, Open Source server side scripting language), talking to MySQL', 1, 'no', 'yes', 9, NULL); INSERT INTO whatdafaq (id, question, answer, category, section, publish, ordering, date) VALUES (4, 'Where can I get it?', '

Right here! Pick your download:\r\n

Zip : GZip : BZip', 1, 'no', 'yes', 10, NULL); INSERT INTO whatdafaq (id, question, answer, category, section, publish, ordering, date) VALUES (5, 'Is there a demo?', '

You\'re looking at it. You can also try the administration tool WhatDaAdmin\r\n

One thing, as a test of your ability... try to avoid posting...\r\n

testing!

\r\n

or\r\n

asdf!

\r\n

We\'re sure you have a brain. Why not use it to speed the flow of knowledge around the world?\r\n

Note: in the demo version, you can\'t edit this category, so these FAQs you\'re reading stay put.', 1, 'no', 'yes', 11, NULL); INSERT INTO whatdafaq (id, question, answer, category, section, publish, ordering, date) VALUES (6, 'Installing WhatDaFaq', '', 1, 'yes', 'yes', 12, NULL); INSERT INTO whatdafaq (id, question, answer, category, section, publish, ordering, date) VALUES (7, 'Creating FAQs', '', 1, 'yes', 'yes', 16, NULL); INSERT INTO whatdafaq (id, question, answer, category, section, publish, ordering, date) VALUES (8, 'What directory should I install it under?', '

The zips will expand into the subdirectory ./whatdafaq\r\n

It\'s recommended you seperate the index.php file, which your visitors will see, from the admin file.\r\n

In general, we recommend you replace the files included in index.php and whatdaadmin.php with those for your own site.\r\n

Of course to get it up and running for your own demo, the whatdafaq directory is fine.', 1, 'no', 'yes', 13, NULL); INSERT INTO whatdafaq (id, question, answer, category, section, publish, ordering, date) VALUES (9, 'You include a few files. What do they do?', '

For layout purposes, we include header.php and footer.php at the top and bottom respectively. These files you should replace with your own.\r\n

dbconnect.php provides the connection to MySQL.\r\n

auth.php envokes the session that controls access to whatdaadmin.php', 1, 'no', 'yes', 14, NULL); INSERT INTO whatdafaq (id, question, answer, category, section, publish, ordering, date) VALUES (10, 'How do I configure the demo version on my machine?', '

Once you\'ve unzipped the files somewhere under your web directory, update whatever MySQL database you wish to use with whatdafaq.sql\r\n

Now update dbconnect.php with your MySQL username / password etc.', 1, 'no', 'yes', 15, NULL); INSERT INTO whatdafaq (id, question, answer, category, section, publish, ordering, date) VALUES (11, 'What are headings?', '

Headings are visual grouping off FAQs. They appear on the left hand side by default, in index.php.\r\n

When you add / edit an item in the FAQ list, use the switch "Section Heading" to define a Heading.', 1, 'no', 'yes', 17, NULL); INSERT INTO whatdafaq (id, question, answer, category, section, publish, ordering, date) VALUES (12, 'What is Position?', '

Position is the order, from the top, that an item appears within a FAQ Category.\r\n

When you add / edit you can set the position of the item relative to the other items you find.', 1, 'no', 'yes', 18, NULL); INSERT INTO whatdafaq (id, question, answer, category, section, publish, ordering, date) VALUES (13, 'I added an item - why doesn\'t appear to visitors?', '

Make sure you set "Publish" to "Yes".\r\n

Publish allows you to add a series of FAQs but keep them invisible until you are ready to display them.', 1, 'no', 'yes', 19, NULL); INSERT INTO whatdafaq (id, question, answer, category, section, publish, ordering, date) VALUES (20, 'How do I move an item from one category to another?', '

Once you\'ve added the item, you can move the category it\'s in by editing it.\r\n

In general, the "FAQ Category:" select box at the top is used to set which category you want to work on.', 1, 'no', 'yes', 20, NULL); INSERT INTO whatdafaq (id, question, answer, category, section, publish, ordering, date) VALUES (21, 'Where can I edit the current categories?', '

There\'s no admin interface for editing categories. This is for a good reason.\r\n

Every new item gets assigned to a category. If you then delete the category, you\'re asking for trouble.\r\n

At the moment, you have to manually update the "whatdafaqcat" table to edit / create categories. We suggest you plan out from the start what categories you\'re going to have.', 1, 'no', 'yes', 21, NULL); INSERT INTO whatdafaq (id, question, answer, category, section, publish, ordering, date) VALUES (22, 'Chilling Out', '', 2, 'yes', 'yes', 5, NULL); INSERT INTO whatdafaq (id, question, answer, category, section, publish, ordering, date) VALUES (23, 'What\'s a good way to chill out online?', '

Try this Guided Meditation. Will space you out nicely, in the comfort of your busy office.', 2, 'no', 'yes', 6, NULL); INSERT INTO whatdafaq (id, question, answer, category, section, publish, ordering, date) VALUES (24, 'Roadkill Trivia', '', 3, 'yes', 'yes', 2, NULL); INSERT INTO whatdafaq (id, question, answer, category, section, publish, ordering, date) VALUES (25, 'The first frisbee', '

It\'s a little know fact that the origional frisbee was a cat.\r\n

At the end of the sixties, Frisbee took his last stroll on the freeway, spending the last of his nine lives under the wheel of a truck.\r\n

It was a long hot summer and Frisbee\'s owners search everywhere. For weeks they couldn\'t find him.\r\n

Until one day...\r\n

The rest we leave to the imagination', 3, 'no', 'yes', 2, NULL); INSERT INTO whatdafaq (id, question, answer, category, section, publish, ordering, date) VALUES (26, 'Roadkill Recipes', '', 3, 'yes', 'yes', 3, NULL); INSERT INTO whatdafaq (id, question, answer, category, section, publish, ordering, date) VALUES (27, 'Truck Driver Surprise', '

Broiled Venison Tenderloin\r\n

Ingredients:
\r\n(1) venison tenderloin (or backstrap)
\r\n(1) onion sliced
\r\ngarlic to taste
\r\npepper to taste
\r\nsalt to taste
\r\n(2) slices bacon\r\n

Directions:
\r\nSoak the venison in salt water to remove all blood (approximately 20 minutes). Rinse well and place on broiler rack. Add garlic, salt and pepper. Wrap the bacon slices (widthwise) around the tenderloin. Slice the onion and place the slices on top of the bacon. Broil for 20 minutes. Cover the tenderloin with foil and broil for 5-10 minutes.\r\n

Slice and serve with your favorite vegetables.', 3, 'no', 'yes', 4, NULL); # -------------------------------------------------------- # # Table structure for table `whatdafaqcat` # CREATE TABLE whatdafaqcat ( id int(11) NOT NULL auto_increment, category varchar(255) NOT NULL default '', PRIMARY KEY (id) ) TYPE=MyISAM COMMENT='Categories of FAQs'; # # Dumping data for table `whatdafaqcat` # INSERT INTO whatdafaqcat (id, category) VALUES (1, 'WhatDaFaq FAQs'); INSERT INTO whatdafaqcat (id, category) VALUES (2, 'Life, The Universe and Everything'); INSERT INTO whatdafaqcat (id, category) VALUES (3, 'About Roadkill');