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

[corsacrazy]

what about most popular tutorial and how total tutorials on forum home ?

[assassingod]

Originally Posted by corsacrazy

what about most popular tutorial and how total tutorials on forum home ?

I'll add those after tutorial moderation and edit feature

[assassingod]

Update:
[IMG] tags and [BB]Code working:

Find (194):

PHP Code:

    $tut[tutpagetext] = bbcodeparse($tut[tutpagetext],0,0,0,0); 


Replace with:

PHP Code:

    $tut[tutpagetext] = bbcodeparse2($tut[tutpagetext],0,1,1,1); 


Updating ZIP in a minute

[bandersen]

Thank you - I have installed and its working! Looking forward to the rest... Thanks again!

[corsacrazy]

bb and img code was working alread wots the fix for mate ?

[assassingod]

Originally Posted by corsacrazy

bb and img code was working alread wots the fix for mate ?

Hm, I was told they didn't. Anyway, this code defintly works now

[Allan]

hello
I have to replace the file "tutorials.php", and following that, I have this like error:

PHP Code:

Database error in vBulletin 2.3.0:

Invalid SQL: 
        SELECT tutid,tutname,tutposted,tutposterid,tutmodded,tutpostername,tutvotes,tutviews
        FROM tutorials
        WHERE tutcat = '1'
        ORDER BY tutposted ASC
    
mysql error: Champ 'tutmodded' inconnu dans field list 


[assassingod]

Whoops, I accidently had the tutorial moderation feature in there( uncomplete )
Run this query to fix:
[SQL]
ALTER TABLE tutorials ADD tutmodded INT(10)
[/sql]

OR

You can open tutorials.php and find (Line 310):

PHP Code:

tutmodded, 


remove that and find and remove (line 311):

PHP Code:

'0', 


[Allan]

Originally Posted by assassingod

Whoops, I accidently had the tutorial moderation feature in there( uncomplete )
Run this query to fix:
[SQL]
ALTER TABLE tutorials ADD tutmodded INT(10)
[/sql]

OR

You can open tutorials.php and find (Line 310):

PHP Code:

tutmodded, 


remove that and find and remove (line 311):

PHP Code:

'0', 


thanks

[FleaBag]

Very happy to see that you've been working on moderation mate - made my day hehe!

About to install in replacement of vBArticles - are the fixes mentioned in this thread included in the first zip?