Thank you so much for sharing this with everyone...

I am getting this error when trying to run the db query:
Error
SQL-query : [Edit]

CREATE TABLE `vbs_stories` (
`storyid` int(11) NOT NULL auto_increment,
`genreid` int(11) NOT NULL default \\\'0\\\',
`title` varchar(100) NOT NULL default \\\'\\\',
`name` varchar(100) NOT NULL default \\\'\\\',
`info` text NOT NULL,
`display` tinyint(4) NOT NULL default \\\'0\\\',
PRIMARY KEY (`storyid`)
) TYPE=MyISAM;

MySQL said:

You have an error in your SQL syntax near '\\\'0\\\',
`title` varchar(100) NOT NULL default \\\'\\\',
`name` varchar(' at line 3

CREATE TABLE `vbs_chapters` (
`id` bigint(20) NOT NULL auto_increment,
`chapterid` int(11) NOT NULL default \'0\',
`storyid` int(11) NOT NULL default \'0\',
`title` varchar(100) NOT NULL default \'\',
`body` text NOT NULL,
`path1` varchar(100) NOT NULL default \'\',
`path2` varchar(100) NOT NULL default \'\',
`userid` int(11) NOT NULL default \'0\',
`dateline` int(10) NOT NULL default \'0\',
`display` tinyint(4) NOT NULL default \'0\',
PRIMARY KEY (`id`)
) TYPE=MyISAM;

MySQL said:

You have an error in your SQL syntax near '\'0\',
`storyid` int(11) NOT NULL default \'0\',
`title` varchar(100) NOT ' at line 3

CREATE TABLE `vbs_genres` (
`genreid` int(11) NOT NULL auto_increment,
`title` varchar(100) NOT NULL default \'\',
`display` tinyint(4) NOT NULL default \'0\',
PRIMARY KEY (`genreid`)
) TYPE=MyISAM;

MySQL said:

You have an error in your SQL syntax near '\'\',
`display` tinyint(4) NOT NULL default \'0\',
PRIMARY KEY (`genreid`' at line 3

Im running vb 2.2.9 anyone help here??

From the looks of it you are getting problems because somehow the required SQL queries are getting messed up as you run them, what program are you using to run the queries?

I'll list the 3 queries needed below for you, my recomendation is that you run each one sepratly using phpMyAdmin.

[sql]CREATE TABLE `vbs_chapters` (
`id` bigint(20) NOT NULL auto_increment,
`chapterid` int(11) NOT NULL default '0',
`storyid` int(11) NOT NULL default '0',
`title` varchar(100) NOT NULL default '',
`body` text NOT NULL,
`path1` varchar(100) NOT NULL default '',
`path2` varchar(100) NOT NULL default '',
`userid` int(11) NOT NULL default '0',
`dateline` int(10) NOT NULL default '0',
`display` tinyint(4) NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM;[/sql]

[sql]CREATE TABLE `vbs_genres` (
`genreid` int(11) NOT NULL auto_increment,
`title` varchar(100) NOT NULL default '',
`display` tinyint(4) NOT NULL default '0',
PRIMARY KEY (`genreid`)
) TYPE=MyISAM;[/sql]

[sql]CREATE TABLE `vbs_stories` (
`storyid` int(11) NOT NULL auto_increment,
`genreid` int(11) NOT NULL default '0',
`title` varchar(100) NOT NULL default '',
`name` varchar(100) NOT NULL default '',
`info` text NOT NULL,
`display` tinyint(4) NOT NULL default '0',
PRIMARY KEY (`storyid`)
) TYPE=MyISAM;[/sql]

This is cool - I am going to create a text adventure games for VB while I try to get permission to translate zork 1 2 3 :)

hehe - nice

midnightz

that sounds like a cool hack, how much have you done so far?

Hi,
I just installed it for my forum and it looks great! :)

A question: Is it a way to change it, so that one has to be logged in to read the stories?

Nevermind, I think I got it now. :)

I added:

After

in vbstory.php

I hope that someone will tell me if I messed up.

Hi Kie, what you have done is just right to stop non-members from seeing the stories, i left it open on purpose myself so that anyone could read them, but it's your site, you do what you need to :)

I'm glad you like the hack :)

bitbender=, I followed your instructions and I get the following error:

Warning: Cannot add header information - headers already sent by (output started at /xxx/xxx/xxx/xxx/forumdisplay.php:1) in /xxx/xxx/xxx/xxx/forumdisplay.php on line 29

But that line in my forumdisplay.php looks like this.

Line 25: // ==========================
Line 26: // VBStory Hack Insert Start
Line 27: // ==========================
Line 28: if ($forumid=='4') {
Line 29: header("Location: ./vbstory.php");
Line 30: exit;
Line 31: }
Line 32: // ==========================
Line 33: // VBStory Hack Insert End
Line 34: // ==========================

And yes, I did create the forum and its ID is "4"

Help

bitg, the code bitbender posed is a simple redirect designed to bypass the forum and go directly to the interactive story. Problem is that in order for it to work it needs to be the first thing sent to the browser, at this moment in time all I can think of is that ether you need to move this code to the top of the phpinclude template, or you have some mods that it's not compatabul with (due to conflecting information being sent).

Ether way however, as i did not write that add on, i can't help you, sorry.