Tutorial Hack

// Tutorial Hack - [high]1.3[/high]

// Coded By: assassingod

// Credits:

• Slynderdale - Catagory Dropdown help
• NTLDR/LeeCHeSS - LEFT JOIN help
• Me - Working from 8PM til 4AM
• a-drive - Original Hack idea

// Description:
The Tutorial hack 1.3 has much more features that you can possibly imagine!
User permissions, allow or disallow users (and usergroups!) to use the tutorial
section. Tutorial Moderation, want to give approval to tutorials before they appear live on the site? With this feature you can, you can either allow or delete tutorials!
Search feature, now you and your users can search for tutorials easily without the hassle of looking for them!
Add, Delete, Modify catagories to your liking! You have an easy-to-use catagory manager so you dont have to go through any trouble adding catagories.
Allow your users to vote on their favourite tutorials. Good tutorials will be regconized by others! Move, Hide, Edit and Delete - these are some of the tutorial features you as an administrator can do for tutorials. Move a tutorial to another catagory, Hide it temporarily, Edit it and even Delete!
Quick Stats! See which tutorials are hot, and which are not.
Add a whole new level to your site with the Tutorial Hack!

// Upcoming features:
- Favourite Tutorials, users can add tutorials to their favourites page and find
the tutorial quickly!
- Page Numbers
- Users tutorials in profile (Add-on only)

// Notices:
- Sorry for the delay of 1.3
- A vB3 port is being considered, work will only be done on RC2 though, no earlier version will be tested on
- 1.4 will contain the formentioned upcoming features
- As I mention in the instructions, there are 27 templates to add.


// Add-ons:
Random Tutorials on forumhome - https://vborg.vbsupport.ru/showpost....9&postcount=45


// Screenshots:
http://www.assassingod.com/screenshots
(Screenshots also included in the ZIP)

-----------------------------------

• Updates: 1/12/2003 8.20AM (GMT): [high]Updated query and tutorials.php - thanks kaotic[/high]
• Updates: 3/12/2003 7.39PM (GMT): [high]Random Tutorial on forumhome add-on[/high]
• Updates: 4/12/2003 6.12PM (GMT): [high]Fixed [IMG] tag problem[/high]
• Updates: 23/1/2004 9.03PM (GMT): [high]Updated to 1.3[/high]

How to Upgrade: Re-upload tutorials.php and tutadmin.php. Follow the instructions. Re-do ALL templates

[sabret00the]

very nice looking, this hack will look excellent given the right style set, great work

[Koutaru]

Nice work! I'll be looking into it a bit later

Suggestion: maybe making the tutorial content box a bit bigger?

[kaotic]

Excellent hack. This has the potential to accomplish many great things. Good work.

Edit:
Is there some form of comments system? Or would it be possible to have a topic automatically opened upon the installtion of a new tutorial?

[corsacrazy]

OMG mate been lookin 4 sumthin the same nice werk my friend

[kaotic]

I've got it installed now, but I did find one problem. In your instructions, it says to run this query:

CREATE TABLE tutorials (
tutid tinyint(11) unsigned NOT NULL auto_increment,
tutname varchar(100) NOT NULL default '',
tutpagetext longtext NOT NULL,
tutposted int(10) unsigned default NULL,
tutcat tinyint(5) NOT NULL default '0',
tutposterid tinyint(2) NOT NULL default '0',
tutpostername varchar(50) NOT NULL default '',
tutvotes int(11) NOT NULL default '0',
tutviews int(11) NOT NULL default '0',
catid` varchar(50) NOT NULL default '0',
PRIMARY KEY (`tutid`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

Instead, it should be:

CREATE TABLE tutorials (
tutid tinyint(11) unsigned NOT NULL auto_increment,
tutname varchar(100) NOT NULL default '',
tutpagetext longtext NOT NULL,
tutposted int(10) unsigned default NULL,
tutcat tinyint(5) NOT NULL default '0',
tutposterid tinyint(2) NOT NULL default '0',
tutpostername varchar(50) NOT NULL default '',
tutvotes int(11) NOT NULL default '0',
tutviews int(11) NOT NULL default '0',
catid varchar(50) NOT NULL default '0',
PRIMARY KEY (`tutid`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

With exception of that minor flaw, good hack, good instructions, good job!

[corsacrazy]

thanks 4 query fix i had this problem too

[kaotic]

One more thing that I updated to suit my needs. I added...

if ((!isset($action) or $action=="")) {
$action="home";
}

...after...

require("./global.php");

...so that tutorials.php would basically redirect to tutorials.php?action=home. That's just me, though.

[TheAnt]

ok, I installed it, but when i goto test it out on localhost, it comes as a white page, but I've imported the templates using the Template Backup System

[kaotic]

I think I can help.

Unless you took my advice from my previous post, you must go to tutorials.php?action=home to open the page, instead of tutorials.php.