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

[assassingod]

They might be unmoderated. Go to the moderation page in the AdminCP, see if they are there.

[bandersen]

No unmoderated tuts.
10 tutorials (0 unmoderated)

edit: and if I click edit tutorial in the ADminCP... I can read the actual tut

[assassingod]

Run this query:
[SQL]
SELECT *
FROM tutorials
[/SQL]

See if there is a result. Hopefully they are still in the database.

[bandersen]

That did not help...

If I enter tut manager - modify - I can see them listed. If I click a link - I do see the actual tutorial text... so I guess they are there...
Everything looks OK in the adminCP.

[assassingod]

But did you get any results from the query?

[bandersen]

in phpMyAdmin.... all the tutorials were listed.... when running SELECT *
FROM tutorials

[assassingod]

Ok, try running this:

PHP Code:

UPDATE tutorials SET tutmodded = '1' 


[bandersen]

BINGO!!!!

They all show! Thank you for the support!!

[assassingod]

No problem

[bandersen]

Ops... search doesn't work.. but it works for the word "frank" :-) a bit random...
http://www.virtusphysica.com/forums/.../tutorials.php

Does it search tutorial name and text or just text....

[assassingod]

It only searches the tutorial name. Version 1.4 will have a better search engine this is just a simple one.

[bandersen]

OK - thank you for your work!

[bandersen]

One question: I am about to enter some 30 tutorials and some of them have tables and links in them. Can I turn on html somewhere while doing these initial entries and then turn it off again and the links etc will still be there?

thanks

[bandersen]

Hi again... sorry to bother you again. I have just entered the code for getting a random tutorial on the index page. That worked, but when I click the link, I am taken to a tutorial that do not show. Much like my initial problem. Could you help me "refresh it" from the database ?

EDIT: oh OK... the random tut on index page include those not mod. yet....

[bandersen]

How come all new tutorials show with a "bad tutorial" icon? How do I change that....