vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 2.x Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=4)
-   -   Tutorial Hack (https://vborg.vbsupport.ru/showthread.php?t=58919)

assassingod 11-29-2003 10:00 PM

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 11-30-2003 08:03 PM

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

Koutaru 11-30-2003 08:08 PM

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

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

kaotic 11-30-2003 08:16 PM

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 11-30-2003 08:35 PM

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

kaotic 11-30-2003 08:41 PM

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

Quote:

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:

Quote:

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 11-30-2003 08:48 PM

thanks 4 query fix i had this problem too

kaotic 11-30-2003 08:59 PM

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

Quote:

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

Quote:

require("./global.php");
...so that tutorials.php would basically redirect to tutorials.php?action=home. That's just me, though.

TheAnt 11-30-2003 09:11 PM

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 11-30-2003 09:17 PM

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.

corsacrazy 11-30-2003 09:29 PM

another god sugestion would be to tell members how many tutorials there are in each catagory like an extra coloumn next to the image with this number...

Dan 11-30-2003 09:56 PM

Quote:

Originally Posted by assassingod
// Tutorial Hack

// Coded By: assassingod
// Credits: Slynderdale - Catagory Dropdown help
NTLDR/LeeCHeSS - LEFT JOIN help
Me - Working from 8PM til 4AM

// Description: This add-on to your vBulletin forum allows your members to post tutorials.
But thats not all, you can add/edit/delete catagories (Inc. Images & Descriptions)
You can add/edit/delete tutorials. [BB]Code can be used for special tags,
there is also a statistics page so you can check on the most/least popular
tutorials - and this is just in the admin CP!
As a user you can browse through the catagories, and post your own tutorials

// Add-ons: Coming Soon:
-Random Tutorials on forumhome
-Edit Feature for user who posted tutorial

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

// Support: Yes, I will give support for this hack

Nice hack Steve :D

FleaBag 11-30-2003 11:39 PM

Is there any moderation on user-submitted tutorials?

cinq 12-01-2003 04:22 AM

How is this different from my hack here ?

assassingod 12-01-2003 05:59 AM

kaotic, I was thinking of a comment system and will add that in the next version. Thanks for the query update & the tutorials.php edit. Will add that soon.

corsacrazy, i'll add that in a future version

FleaBag, good idea. I'll add this as an add-on rather than a feature

cinq, Sorry I didn't even realize yours good be used for tutorials (I only looked at the vBArticles, and just thought it could've been for articles only)

assassingod 12-01-2003 06:20 AM

Upgraded to 1.1
Follow the instructions in the first post and re-download the file (tutorial_install - 1.1)

Neo 12-01-2003 07:07 AM

Wee, I am now out of business...Hehe.. though the system I have is pretty advanced I might just have to cut the price =P [/shameless]

corsacrazy 12-01-2003 09:35 AM

Spellin mistake spotted causing a stat to not show on tute home

instead of

HTML Code:

<a href="tutorials.php?action=viewtut&amp;tutid=$stavote[tutid]">$statsvote[tutname]</a>
it should be


HTML Code:

<a href="tutorials.php?action=viewtut&amp;tutid=$statsvote[tutid]">$statsvote[tutname]</a>

:nervous:

FleaBag 12-01-2003 10:13 AM

Cool assasingod. You're doing well with your hacks - I'm quickly becoming a fan.

Chris Gwynne 12-01-2003 10:42 AM

Nice steve ;)

MindTrix 12-01-2003 11:13 AM

This is brilliant, Nice one mate seeing as you've seriously been working hard on this. This would be nice to have on this site so people can add their own tutorials for like using things on vB or php advice etc.

corsacrazy 12-01-2003 11:21 AM

im using it for car tutorials step by step guides etc :)

surfhog 12-01-2003 12:06 PM

hehe maybe this wasn't a good choose as a first hack to accomplish?

I have installed it and I get this message "Your account has been disabled for posting tutorials." when I attempt to post a tutorial :(

Should this installation show my current style or is it just for the vb default style?

I guess I have missed something very stupid here, could some kind sole please enlighten me.

assassingod 12-01-2003 01:40 PM

surfhog, I realized that when coding the templates that I hardcoded in the colours in so i'll change that soon

corsacrazy, cheers:)

Everyone else, thanks for the positive feedback:)

surfhog 12-01-2003 01:48 PM

ops!! OK that assassingod really nice hack though ;) Brilliant idea :)

How would I overcome this message "Your account has been disabled for posting tutorials" Please!

Have I missed something silly?

Should I have like an option in the ACP to select Allow/Disallow or something, maybe?

Thanks again :)

cinq 12-01-2003 01:59 PM

I will stop with my hacking, yours seems promising.

assassingod 12-01-2003 02:59 PM

Quote:

Originally Posted by surfhog
ops!! OK that assassingod really nice hack though ;) Brilliant idea :)

How would I overcome this message "Your account has been disabled for posting tutorials" Please!

Have I missed something silly?

Should I have like an option in the ACP to select Allow/Disallow or something, maybe?

Thanks again :)

When you edit a user, you should get an option to change whether they can post tutorials or not (It should be set to 'yes' anyway)

surfhog 12-01-2003 03:19 PM

Ok and tahnks again assassingod

You are 100% correct :) I did find that bit, I am getting sql errors now :(

rofl ;) no problems I am enjoying myself anyway, considering this is my first attempt at hacking vb haha - "newbies" - you just don't need'em do you lol

Still a great hack ;)

Thanks

assassingod 12-01-2003 03:23 PM

What are the SQL errors?:)

MrNase 12-01-2003 04:26 PM

hey, great work as usual :)

I will use that to allow my users posting articles.
Will you port that to vB3 and will you continue working on that (ab to post comments etc.) ??

assassingod 12-01-2003 04:29 PM

Thanks. I will port this to vB3 as well as all the upcoming features:)

SRozhon 12-01-2003 05:37 PM

Can't wait to try it! Thanks for sharing!!

assassingod 12-01-2003 06:26 PM

Thanks for the feedback.

surfhog 12-01-2003 09:06 PM

Thank you very much assassingod = all done and dusted - not 3 bad for a newbie :) but then again it's the brilliant coder that should take the credit for all the work and support ;)

Installed on vb2.3.3 = OK

Just one last issue if I may? - Says that the cat images should be 50x50pix

I have attached a 50x50 image which shows in the ACP "Current Catagories in the database" But the images do not appear to show in the Tutorials Catagory Listings page :( Have I missed something again please and thanks

surfhog 12-01-2003 10:35 PM

Sorry assassingod

I thought I had solved it :( silly me - When I go into ACP and hit template modify = this QSL error and I can't quite figuare this one out, maybe getting to tired now :(

Database error in vBulletin Control Panel 2.3.3:

Invalid SQL: SELECT templatesetid,title FROM templateset
mysql error: Table **** .templateset' doesn't exist

mysql error number: 1146


:disappointed:

assassingod 12-02-2003 05:36 AM

Right click on the broken image and tell me the URL of the image. As for the SQL error, i'm not too sure about that one. Have you installed anything else that may cause this problem.?

I'll wait for other people to confirm the SQL error if it's my hack.

IKer 12-02-2003 06:15 AM

Thanks for this hack, it work very good.
But what must i modify for display pics into [.img] [./img] ?
A good tutorial is a tutorial with displayed ilustrations :)

assassingod 12-02-2003 06:20 AM

Quote:

Originally Posted by IKer
Thanks for this hack, it work very good.
But when when, what i must modify for display pics into [.img] [./img] ?
A good tutorial is a tutorial with displayed ilustrations :)

I thought it did (I've just tested and it doesn't work;))
I'll fix this tonight:)

surfhog 12-02-2003 09:41 AM

thanks again assassingod ;)

Well all mysql went pear shaped last night :( So I have completely reinstalled vbb and I will try again :)

assassingod - is this or would it be, like a replacement for "Forums Arranged in Columns Addon: Forum Images"

Sorry to take up your valuable time :)

Thanks

assassingod 12-02-2003 05:27 PM

I'm not the sure about your question. Mind explaining it a bit further?


All times are GMT. The time now is 11:33 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01400 seconds
  • Memory Usage 1,824KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_html_printable
  • (7)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete