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.

If this will work on 2.3, I'll become a fan of it and will develop an add-on with your help, if you'll be interested.

Hi all, i've been out of a development mood for a while so i've not been about to answer any questions (sorry).

Anyway, I can't see why it would not work with 2.3.0, it's seperate from the rest of the forum, needs very little actual "hacking" and providing that themain system variables havent been changed, i can't see a problem.

Small Update, i'm working this weekend on an more advanced verson of vBstory for my own use, but if you show me enough love I might think about releasing it :)

Yes this works flawlessly on vB 2.3.0 as best as I can tell. I'm hoping to open the new site in June and would really love the more advanced version you spoke about anyway I can get it!

Oh and BTW, I love you. :D

-Jason

I have a wish:

Lets take I have a book, 20 000 symbols. I want it to be displayed by chapters and about 900 symbols in every page. With a dropdown panel with the generated pages.

sorry, but i'm a little confused as to what you want me to do.

Here is a demo:
http://www.oshoworld.com/onlinebooks...0breakfast.txt

It cuts the with XML, but whe doen't need it. We just take certain proportions from te DB. Now it's more clear? :o)

Oh, i think i see, you are after some type of system that you can use to display an xml book on the internet, with preformed chapters, etc...

I can't help you with that, this is an interactive story that is designed to let forum members add new chapters, it's not the type of thing you are ater, and to be honest with you, i don't think i'd be able to code what you need anyway, sorry.

Dimension, it does not has to XML, it's just the demo.
It's very close to what you have. It would be an add-on for e-librarys. You know your code far more better than I, so it would take 4 times less time than for me.

An option where admins add text and it is displayed in 900 symbols text chunks. Please say you'll think about it?!

gmarik, I'm sorry mate but i still don't fully understand what you want/need. This plus the fact that apart from an minor update to fix some minor bugs, i'm not going to be making any more changes to the script (i like the way it runs at the moment).

but please, by all means, if you, or someone else here wants to edit the hack, be my guest, i'd love to see any changes that other people make :)

Are we any closer to an update on this? :D

nope, not yet :) I've not had any time i'm sorry to say. but as soon as something happens, you will be the first to know :)

Okay good 'nuff! :) I can't wait!

LOL this is funny, here I am, the author of this hack, and i have to come back to vB.org to download a copy of the hack so I can put it on my latest forum. hehehehe.

BTW, if I make any changes to this install to improve it in anyway, i'll post them here for you all.

While i'm on the subject, has anyone out there in hack land made any changes to the script? if so please feel free to share them, i'd love to see what you have done with it.

i just added this vbstory to my site
www.clan-ice.com/vbstory.php
but i get this error when i click suggest a story
how can i fix it this plz help

Warning: Invalid argument supplied for foreach() in /home/clan-ic/public_html/vbstory.php on line 85

i fixed problems i forgot add story genre

lol :) I'm glad you got it working :)

I just love this idea and are really looking forward to letting all "my kids" write their heart out. Only problem is that I get an "One or more of the required fields is empty, please press the back button and try again." when adding a chapter. I have seen someone else had this problem but he never returned to say what he did to fix this?

Ohh... and by the way, this is a Danish site, therefor the "funny" lingo :)
I haven't started translating the templates yet, so it can't be that :)

will there be a vb3 port of this?

I would also love to hae this but is not compatable with vb3.. What would it take to get it to work on VB3... Please, my users really enjoyed this hack but I no longer can use since I upgraded...

Ive made a request for vb3 story here :
https://vborg.vbsupport.ru/showthread.php?t=63908

Yes please ! Millions of users are waiting this excelent hack !!!!!

Looking forward to this, it is much desired.

<a href="http://www.rapchoice.com/forums/vbstory.php?s=&menu=34" target="_blank">http://www.rapchoice.com/forums/vbstory.php?s=&menu=34</a>

I don't know if anyone here is interested or not, but the latest version of this project is now online at http://unknowntales.net/

Now before you all go getting excited about a vB3 release or anything like that, you should know that this is an independently scripted revamp of the entire concept. It's not available for download or use on any other sites - it's my own site for my own purpose.

So why am I telling you? Well - why not, some of you enjoyed the concept of the interactive story site, so I figured I'd let you know that it lives on.

I don't have any plans for any more public releases of the script at this point, nor do I see anything like this happening in the future, but I am thinking about offering a remotely hosted story service that webmasters might be interested in signing up for - it's just an idea right now, but more may come of it soon.

I don't mind that the version of vBstory listed on this site remains active and available for download; however I do request that no further versions of the script be made.

Anyway, if you're interested, check out http://unknowntales.net/ and let me know what you think :)

is this working in vb3.6.7? :)