vBstory - an Interactive Story for vB (1.0 Final)

.

This script is pretty much dead - but if you wanted to see the concept live on, visit http://unknowntales.net/



----------------
Author
----------------

VBstory (1.0 Final)
by Daniel Hollands of Ninth Dimension.
http://ninthdimension.biz/

I do custom vB scripts as well as web design and development using PHP and MySQL.
If you would like some more information on the work I do, please visit the URL above.

----------------
About
----------------

This hack allows you to add an Interactive Story to your forum.

Once a user has chosen a story arranged into genres, they will be presented with
a chapter to read. After reading this chapter they will be presented with two
paths to follow, both of which will present a new chapter, and a further two
paths.

Eventually the user will be given the ability to add their own chapters to the
database, which will be done via a form presented on the site.

Hopefully this will encourage your users to be more active on your site, thus
giving you a higher hit rate.

----------------
Install
----------------

PLEASE MAKE A BACKUP OF ANY FILES EDITED AND YOUR DATABASE BEFORE
INSTALLING THIS HACK. If you loose all your data as a result of installing this
hack, it's your fault, not mine.

1, Upload the vbstory.php file to your forum root directory.
2, Upload the vbstory_admin.php file to your admin directory.
3, Upload the two images to your images directory.
4, Run the three SQL queries in the sql.txt file (don't just run this file, read it).
5, Add the templates listed in the templates.txt file to your site.
6, Make the file changes listed in the files.txt file. (Only one is required).
7, Using the new menu items in your admin panel (you might need to refresh it
after adding the templates) add at least one genre, and as many stories as you
want.
8, Link to vbstory.php (some examples will be provided in the final release.
9, Post a link to your vBstory in the vBstory thread on vB.org.
10, !GOLDEN RULE! Enjoy.
11, (Optional) If you want your Super Mods to have access to the admin scripts,
just upload the vbstory_admin.php file to your mod directory and complete the first
file edit instruction on the index.php file in your mod directory.

----------------
Upgrade
----------------

If you are running vBstory beta 0.5 or later you will not need to run the SQL
queries again. However if you want a fresh install, you will need to remove the
three vbs_ tables from your database.

IMPORTANT - You will need to replace ALL your vbstory templates with the new ones contained
within this archive. EVERY template has been changed.

----------------
To Do
----------------

I've not really got any more plans for this version of vBstory. I will be making a
more advanced version of vBstory for my own use, but I've not yet decided if I'm
going to release it yet.

----------------
Support
----------------

So far as I can tell, this version of vBstory is fully bug free. After a little while,
provided no errors are reported, I'll be releasing this as a final.

If you have any problems running or using this hack, please post a message in
the vBstory thread at vB.org. If you receive a serious error, I'll try to provide
support via IM (AIM, ICQ, MSN or Yahoo).

----------------
Demo
----------------

No demo at the moment, will be back soon.

[rrnolan]

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

[WarChild]

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??

[Ninth Dimension]

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]

[midnightz]

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

[Ninth Dimension]

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

[Leah]

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?

[Leah]

Nevermind, I think I got it now.

I added:

if ($bbuserinfo[userid]==0) {
show_nopermission();
}

After

require("./global.php");

in vbstory.php

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

[Ninth Dimension]

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

[Holidazed]

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

[Ninth Dimension]

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.