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

[JulianD]

Can I ask why do you always set $templatesused after require global.php? I think it's pointless because the templates are not being cached, and there will be one query for every template the script reads.

[assassingod]

iceman-x, Only registered users should be able to post tutorials

JuliadD, i've always used $templatesused in my scripts wether it's needed or not. But when I re-code tutorials.php, I'll be sure to see what's not needed

[iceman-x]

Originally Posted by assassingod

iceman-x, Only registered users should be able to post tutorials

JuliadD, i've always used $templatesused in my scripts wether it's needed or not. But when I re-code tutorials.php, I'll be sure to see what's not needed

Thanks. But i was woundering if only registerd people can view the tutorials.

[Areku]

Can we make it so only REGISTERED users can view/access the tutorials zone?

[Brad]

Originally Posted by assassingod

iceman-x, Only registered users should be able to post tutorials

JuliadD, i've always used $templatesused in my scripts wether it's needed or not. But when I re-code tutorials.php, I'll be sure to see what's not needed

That is not the issue here, the error is calling global.php before you define $templatesused. This means everytime you call get_template(); in the script it runs a query.

So instead of:

PHP Code:

require_once('./global.php');

if ($do =  'moo')
{
$templatesused = 'blah,blah3,blah999';
} 


Use:

PHP Code:

if ($do = 'bahh')
{
$templatesused = 'sheep,sheepy';
require_once('./global.php');

// your code here
} 


[Areku]

Originally Posted by Socrate

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 


As of today I'm still getting the "tutmoded unknown" sql error. Just thought you'd like to know. SQL query adding the table fixed it.

I also had to edit some colors as you seem to pick only the default blues hardcoded instead of being picked from the style config...

Congrats on the hack anyway, up 'n running on 2.3.0

Btw,

1) how can I allow HTML on the tutorials? It's disabled by default.

2) how can i prevent UNREGISTERED users to read ANY tutorial?

3) What's the result of voting NO on a tutorial?

4) Would it be possible to sort the categories list alphabetically?

5) Is it possible to add the time the tutorial was posted? This is because I use the "Today at, Yesterday at," hack stamp and it shows weird as no time is displayed.


Thanks!

[assassingod]

iceman-x, Areku;
I will add this next version

Anime-Loo, thank you.

Areku;
1. https://vborg.vbsupport.ru/showpost....3&postcount=53


But use this as the replacement:

PHP Code:

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


2. As mentioned above, i'll add this next version
3. The ammount of votes go down and indicates if the tutorial is properly written, or if it works etc. Basically and indication of a good tutorial
4. Yes, i'll post this soon
5. I'll consider this in a future version

[Areku]

Thanks for #1.

I'll wait for the other 3

KUTGW!

[dacrownjewlz]

Great hack

I could not get the tutorials.php script to work until I removed "tutmodded," from one of the queries.

[assassingod]

Originally Posted by dacrownjewlz

Great hack

I could not get the tutorials.php script to work until I removed "tutmodded," from one of the queries.

The file should be updated. I'll check it out soon

[assassingod]

Just a note:

I cannot update this hack until I can get my internet connection back from my ISP

[FleaBag]

Why did they take it?

[assassingod]

Check my thread in the lounge.

[Areku]

Can any1 else at least help me out with the no permissions to read to unregistered/not logged in users?

[gmarik]

The add-on could have a small thumb as well, the random one.