Tutorial Hack

[assassingod]

// Tutorial Hack - 1.3

// 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.php?p=450259&postcount=45


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

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

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

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.

[corsacrazy]

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]

// 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. 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

[b]// 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]

Is there any moderation on user-submitted tutorials?

[cinq]

How is this different from my hack here (https://vborg.vbsupport.ru/showthread.php?t=54331) ?

[assassingod]

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]

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

[Neo]

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]

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

instead of

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

it should be


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


:nervous:

[FleaBag]

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

[Chris Gwynne]

Nice steve ;)

[MindTrix]

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]

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

[surfhog]

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]

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]

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]

I will stop with my hacking, yours seems promising.

[assassingod]

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]

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]

What are the SQL errors?:)

[MrNase]

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]

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

[SRozhon]

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

[assassingod]

Thanks for the feedback.

[surfhog]

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]

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]

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]

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]

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]

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]

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

[surfhog]

So Sorry assassingod :)

To have taken up your time with my posts. Maybe I am trying to run before I can walk here, in that I thought that I had understood how the hacks work, but it appears not to be the case :( I have just tried the "Forums Arranged in Columns Addon" with a fresh new reinstall, this has gone wrong also :( So I do not mind admitting to my personal failings and go back to the drawing board as it were.

Down but not out yet, ha ha

Mind in my defense I noticed quite few posts, stating that there are problems with hacks on version 2.3.3 - but then as a newbie, I cannot say.

Anyway, thanks for trying........

:)

[Xyphen]

That is just beautiful! Awesome work, I hope you have a vB3 version ready or in the works :)

[assassingod]

Thanks for the feedback:)
Next update:
Random Tutorials on forumhome

[SRozhon]

This is Great! I love it! Thank you

[assassingod]

Random Tutorial on Forumhome:

Follow instructions in the text file.

[corsacrazy]

installed addon nice one mate

[FleaBag]

Great work as usual mate, looking forward to moderation of user reviews. ;)

[assassingod]

Thanks:)

[Allan]

thank you to you, pretty work has :)

[IKer]

THx ! i hope the next update is : Edit Feature for user who posted tutorial
;)

[corsacrazy]

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

[assassingod]

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):

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


Replace with:

$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]

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:


Database error in vBulletin 2.3.0:

Invalid SQL:
SELECT tutid,tutname,tutposted,tutposterid,tutmodded,tutp ostername,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:

ALTER TABLE tutorials ADD tutmodded INT(10)


OR

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

tutmodded,

remove that and find and remove (line 311):

'0',

[Allan]

Whoops, I accidently had the tutorial moderation feature in there( uncomplete )
Run this query to fix:

ALTER TABLE tutorials ADD tutmodded INT(10)


OR

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

tutmodded,

remove that and find and remove (line 311):

'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?

[Aaron1]

Looking good!

Thanks for your efforts!

Did you know you can keep voting on the article if you want?

It would be even cooler if you could respond to the tutorial aswell. I have no idea if that's a hard thing to do, but could be great.

Thanks Assasin!

[assassingod]

Thanks for letting me know you could repeatedly vote, I will sort this out:)

As for a comment system, I was thinking of that and may implent it in a future version

[gmarik]

Wow

[iceman-x]

wery nice hack :D:D:D

Do this hack work on 2.3.0. havent oppgradet yet ???

[assassingod]

wery nice hack :D:D:D

Do this hack work on 2.3.0. havent oppgradet yet ???
There should be no problems with this working on 2.3.0:)

[iceman-x]

Nice, thanks again for the great hack. i will proberly install it later. :)

[FleaBag]

Got this installed and working properly - cheers.

[assassingod]

If there are any troubles or requests just post them here;):)

[corsacrazy]

request : total tutes for each section on tute_home ?

[assassingod]

request : total tutes for each section on tute_home ?
Will add to my to-do list.;)

[FleaBag]

Haha there's no stopping you!

[iceman-x]

Then the hack is installed. Thanks again :):)

[gldtn]

Haven't try this out yet, but am I able to upload pictures to my tutorials? if not, maybe this could be a feature on the next version. Maybe allow a person to upload as many picture they need to upload and than sort it out in the tutorial using the tag?

[assassingod]

gldtn, as of yet you cannot upload pictures. I'll take this into consideration in future version:)

[iceman-x]

- Is it posible to make it for only registered member.

[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]

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]

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:


require_once('./global.php');

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


Use:


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

// your code here
}

[Areku]

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


Database error in vBulletin 2.3.0:

Invalid SQL:
SELECT tutid,tutname,tutposted,tutposterid,tutmodded,tutp ostername,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.php?p=450403&postcount=53


But use this as the replacement:

$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]

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.

[GoTTi]

very cool hack here...question though...

how do i make it where i dont get the X box for image on the category...i dont want to put a image on the categor...

and also, on viewing of tutorials.php?action=home, can it be made to show how many tutorials there are in each category?

[Jannefant]

Will this hack run under 3.0.0 gamma?

Thanks in advance!

[FleaBag]

Will this hack run under 3.0.0 gamma?

Thanks in advance!

No.

[FleaBag]

very cool hack here...question though...

how do i make it where i dont get the X box for image on the category...i dont want to put a image on the categor...

and also, on viewing of tutorials.php?action=home, can it be made to show how many tutorials there are in each category?

To alter your category view as you requested, replace your tuts_catview template with the following.


{htmldoctype}
<html>
<head>
<title>$bbtitle - Tutorials > $catname[catname]</title>
$headinclude
</head>
<body>
$header

<!-- breadcrumb -->
<table cellpadding="2" cellspacing="0" border="0" width="{contenttablewidth}" {tableinvisibleextra} align="center">
<tr>
<td width="100%">
<smallfont><b><a href="index.php?s=$session[sessionhash]">$bbtitle</a> -
<a href="tutorials.php?action=home">Tutorials</a></b> > <b>$catname[catname]</b></smallfont></td>
</tr>
</table>
<!-- /breadcrumb -->
<normalfont>

<div align="right"><a href="tutorials.php?action=add">Add a tutorial!</a>
</normalfont>
<table cellpadding="0" cellspacing="0" border="0" bgcolor="{tablebordercolor}" width="98%" align="center"><tr><td>
<table cellpadding="4" cellspacing="1" border="0" width="100%">
<tr id="cat">
<td bgcolor="{categorybackcolor}" nowrap><normalfont color="{categoryfontcolor}"><b>Tutorial Name</b></normalfont></td>
<td bgcolor="{categorybackcolor}"><normalfont color="{categoryfontcolor}"><b>Posted</b></normalfont></td>
<td bgcolor="{categorybackcolor}"><normalfont color="{categoryfontcolor}"><b>By</b></normalfont></td>
<td bgcolor="{categorybackcolor}"><normalfont color="{categoryfontcolor}"><b>Views</b></normalfont></td>
<td bgcolor="{categorybackcolor}"><normalfont color="{categoryfontcolor}"><b>Votes</b></normalfont></td>
</tr>
$tutlisting
</table></td></tr></table>


The layout might be slightly different as I've changed it for my own needs.

At present you can't list the number of tutorials in each category on the main tutorial listing page.

[FleaBag]

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

I think this should work...

In tutorials.php - After;

require("./global.php");

add...

if ($bbuserinfo[userid]==0) {
show_nopermission();
}

[iceman-x]

Thanks for the permissions hack. it work like a charm. :):):)

[IKer]

Idea of addon : Make a counter of tutorial by category between "()" near de category name ;)

[FleaBag]

Thanks for the permissions hack. it work like a charm. :):):)

No problem.

[Areku]

SO cool! Thanks!

[Frozen Dreams]

Any chance that the edit option comes soon? I think this is a great idea, but before I make it public on my board I need that edit feature - otherwhise I can soooo see the staff having to do the edits - or people just reposting the tutorials :s

[assassingod]

Hello all,

When I can get my internet back, version 1.3 will be released with a ton of new features! Ive completed them all so you should get it ASAP.


Tutorial Moderation
Number of Tutorials for each catagory
Cleaner Template code (all the replacements sorted too)
Edit Feature
Admin Tutorial options
More Admin CP options
More user and usergroup permissions
A mini-rating system based on the built in vote system - see which tutorials are hot and which are not!
:)

[IKer]

Goood Assass! i'm hurry to see 1.3 release ;)

[assassingod]

I also forgot to mention a Search feature

[iceman-x]

Nice, looking forward to it. thanks in advance. :)

[chrisvonc]

Nice. Install went well on my test forum with the exception of the one DB adjustment but was fixed after the fix from post #58. I cant wait for v1.3 and all the improvements.

Thank you assassingod!

Chris

[weezer412]

anyone have any ideas on how to make a user comment system for each one?

[assassingod]

I'll release this as an addon after I released 1.3

[weezer412]

I'll release this as an addon after I released 1.3awesome i have some ideas for the next one :)

1.user comment feature
1a.once someone has posted a comment the person who made the turorial can reply in like the same box rather than making a whole new box for a comment
2.A more in depth voting system(out of 5 or maybe 10?)
3.on the main tuorials home page each should have total turoials in each section

hmmm any other cool ideas

looks like you have most of this covered awesome job

:D


maybe have like for flash tutorials the allowance of adding .swf file for previewing a tutorail and allow then rather to read the whole thing they could upload a .fla for people to freely download..also is there a way toa dd a thing like for php for actionscript that would be tizight

[SRozhon]

I love this hack! I am wondering something though. I use vbportal and I was wondering how I could change newsletter.php (see attachment) so I can add the tutorials links to my newsletter like we can add post links to the newsletter in the admin section???

[surfhog]

I manged to get this finallt working on vb2, it's real great and thanks assassingod (https://vborg.vbsupport.ru/member.php?u=17321) I like the modifications you have done :) When will you start working on a version for RC2 do you think? Be nice anyways ;)

thanks

[assassingod]

weezer412;
I'll think about these suggestions

SRozhon;
I am not familiar with vBPortal so I cannot complete that for you

Surfhog;
I am currently working on an Gamma version, however I will be updating the RC2 soon. Sadly I cannot give an exact date for the RC2 version, however, 1.3 for vB3 will be released soon.

[weezer412]

HURRY UP lol i really want this newer version im seriosuly dying for this thing lol

[kevinrstruck]

This looks like an awesome hack. I installed everything, and did my Querries, but I get this error when I try to add a test Tutorial:

Database error in vBulletin 2.3.4:

Invalid SQL:
INSERT INTO tutorials (tutid,tutname,tutpagetext,tutposted,tutmodded,tut cat,tutposterid,tutpostername)
VALUES (NULL,'Simple Monitor Calibration','A simple monitor calibration using a grayscale strip .

I know I did something wrong.

Thoughts?

[X-Sector]

I have this MySQL database error when posting a new tut

Database error in vBulletin 2.3.4:

Invalid SQL:
INSERT INTO tutorials (tutid,tutname,tutpagetext,tutposted,tutmodded,tut cat,tutposterid,tutpostername)
VALUES (NULL,'dfs','sfsf','1073949285','0','','1','Sector ')

mysql error: Unknown column 'tutmodded' in 'field list'

mysql error number: 1054

Date: Monday 12th of January 2004 05:14:45 PM
Script: http://www.xelation.net/forums/forums/tutorials.php?action=add
Referer:

[X-Sector]

Nvm.. I fixed that.

One more question.. how do you change the colour inside of the tutorials tables?

[kevinrstruck]

X-Sector since we had the same problem, and you fixed yours, mind letting me know what you did to fix it?

[X-Sector]

I ran the query :

ALTER TABLE tutorials ADD tutmodded INT(10)

This should fix your problem ;)

[X-Sector]

so anyway.. how do you change the color inside of the tutorials tables

[kevinrstruck]

Thanks X-Sector, that worked.

[MilleniumClock]

problem i get this when i try to go to a category on my site:

Database error in vBulletin 2.3.4:

Invalid SQL:
SELECT tutid,tutname,tutposted,tutposterid,tutmodded,tutp ostername,tutvotes,tutviews
FROM tutorials
WHERE tutcat = '1'
ORDER BY tutposted ASC

mysql error: Unknown column 'tutmodded' in 'field list'

mysql error number: 1054

Date: Wednesday 14th of January 2004 08:48:16 PM
Script: http://www.clockse.cx/bbs/bbs/tutorials.php?action=viewcat&catid=1
Referer: http://www.clockse.cx/bbs/tutorials.php

[weezer412]

problem i get this when i try to go to a category on my site:

Database error in vBulletin 2.3.4:

Invalid SQL:
SELECT tutid,tutname,tutposted,tutposterid,tutmodded,tutp ostername,tutvotes,tutviews
FROM tutorials
WHERE tutcat = '1'
ORDER BY tutposted ASC

mysql error: Unknown column 'tutmodded' in 'field list'

mysql error number: 1054

Date: Wednesday 14th of January 2004 08:48:16 PM
Script: http://www.clockse.cx/bbs/bbs/tutorials.php?action=viewcat&catid=1
Referer: http://www.clockse.cx/bbs/tutorials.php

well if im thinking of the right millenium clock i can easily help you because its me dung clock

[kevinrstruck]

problem i get this when i try to go to a category on my site:

Database error in vBulletin 2.3.4:

Invalid SQL:
SELECT tutid,tutname,tutposted,tutposterid,tutmodded,tutp ostername,tutvotes,tutviews
FROM tutorials
WHERE tutcat = '1'
ORDER BY tutposted ASC

mysql error: Unknown column 'tutmodded' in 'field list'

mysql error number: 1054

Date: Wednesday 14th of January 2004 08:48:16 PM
Script: http://www.clockse.cx/bbs/bbs/tutorials.php?action=viewcat&catid=1
Referer: http://www.clockse.cx/bbs/tutorials.php




Are your path correct? And did you run this query:

ALTER TABLE tutorials ADD tutmodded INT(10)

[Deska]

can't wait for version 1.3 please....

[weezer412]

can't wait for version 1.3 please....


i agree soooo much man

[Aaron1]

can't wait for version 1.3 please....

Yep, lot's of people wait for it i guess!

[weezer412]

Yep, lot's of people wait for it i guess!

for the love of god hrurry up with the hack lol

[MindTrix]

assassingod currently isnt online as much as he used to be because his internet is messed up. Im sure this hack will be updated when he gets things sorted out his end ;)

[assassingod]

MindTrix said it all.

[weezer412]

i wanted to thank you for making the tutorial hack its amazing

[assassingod]

Thanks for the feedback. I'll make sure version 1.3 makes it even more amazing;)

[Deska]

assassingod, any estimation time that you can give?
Your hack is great, that's why I really need it.

Thank's for all your hard work, :)

[assassingod]

assassingod, any estimation time that you can give?
Your hack is great, that's why I really need it.

Thank's for all your hard work, :)I'm hoping to be back online around the 22nd so 1.3 will be a few days after then:)

[weezer412]

I'm hoping to be back online around the 22nd so 1.3 will be a few days after then:)



omg yes!

you should have this thing that says add tutorials to favriotes and then they show up in post showthread right above their post as their fav tutorials

[assassingod]

I had a Favourtite feature on my mind but I would imagine it being out with version 1.4

[X-Sector]

No... make it 1.3 ;) lol

Anyway, do u know where to change the header tables colour in a tutorial page?

[assassingod]

Tha main tutorial page? Look at tuts_home, or if you mean viewing a tutorial, tuts_viewtut (I think)

Just a note, all the templates will be fixed in 1.3:)

[weezer412]

I had a Favourtite feature on my mind but I would imagine it being out with version 1.4


o man 1.4 lol the skys the limit...wow im dumb lol

[assassingod]

I would just like to tell everyone that the Tutorial Hack 1.3 is now complete!!

It will be released on the 22nd (hopefully)

All the features for 1.3 can be found here:
https://vborg.vbsupport.ru/showpost.php?p=453182&postcount=101

[weezer412]

I would just like to tell everyone that the Tutorial Hack 1.3 is now complete!!

It will be released on the 22nd (hopefully)

All the features for 1.3 can be found here:
https://vborg.vbsupport.ru/showpost.php?p=453182&postcount=101


more admin options?

[assassingod]

Tutorial Moderation, Tutotial Editing (Move, Hide, Delete and edit) among other things.

[surfhog]

It will be released on the 22nd (hopefully)
I can't wait assassingod

please feel free to work overtime on it ;) LOL

ps: I am waiting for your update on the "Forums arranged in columns on forumhome " image addition, unless I have missed it:ermm:

God bless:speechless:

[weezer412]

Tutorial Moderation, Tutotial Editing (Move, Hide, Delete and edit) among other things.


excellent

i may have missed it but are the tutorials columns going to have the total amount of tutorials in each group?

[assassingod]

Yes.

Surfhog, I cannot work on my other hacks until the 22nd (I only saved my Tutorial Hack when I formatted my HDD)

[weezer412]

Yes.

Surfhog, I cannot work on my other hacks until the 22nd (I only saved my Tutorial Hack when I formatted my HDD)


what can we expect out of 1.4?

[assassingod]

In the installation file for 1.3 I've mentioned 3 features that will appear in 1.4:


Favourite Tutorials
Page Numbers
Users tutorials in their profile (addon only)
I have thought about a comment system and decided not to release that until 1.5 (Or if further issues occur, a later version, such as 1.6)

[weezer412]

In the installation file for 1.3 I've mentioned 3 features that will appear in 1.4:


Favourite Tutorials
Page Numbers
Users tutorials in their profile (addon only)
I have thought about a comment system and decided not to release that until 1.5 (Or if further issues occur, a later version, such as 1.6)


lol dang man why not make just one big release?

[assassingod]

lol dang man why not make just one big release?
Not enough time, unfortuanetly.

[weezer412]

Not enough time, unfortuanetly.



it gets relased tommrow

[SRozhon]

I hope so, I love this hack! I can't wait to put it on RC3

[surfhog]

I hope so, I love this hack! I can't wait to put it on RC3
Me also ;)

:tired:

[Fargo]

Installed! Not working perfectly, but working never the less.

[assassingod]

it gets relased tommrow
It's getting release today yes:)

ria.enigma;
What are the problems you are getting?

[Fargo]

Other than some color changes, everything is working A-ok now. My initial problem was a couple links, but i've got that working now :)

Now im here to see if theres a comments addition to this hack. Ive seen it mentioned several times, but I wasnt worried about it at that time...

I see its been implemented on http://www.somethingleet.com


ok, looks like your consitering the comments system for a future version (enter sigh here)

On the plus side, I just caught your post about templates being fixed in 1.3, to be released on the 22nd....

....oh wait - it IS the 22nd!! lol..ok - cough it up bud! (j/k)

ok..ill shuddup now :)

[surfhog]

Well wake up and give me some (-0-0-) LOL

I am assuming that 1.3 will not work on vb3 rc3? So I have been misreading the threads :(

assassingod you are still the ace in the pack, I will wait until it can be used on vb3 ;) :tired: I love this modification, if only I could code :(

[assassingod]

Yes, this hack is for vB2 only. However, I am working on a port for vB3:)

1.3 WILL be released tonight (After 8PM+ GMT):)

[surfhog]

Yes, this hack is for vB2 only. However, I am working on a port for vB3:)

1.3 WILL be released tonight (After 8PM+ GMT):)
hehe silly me :o thanks assassingod, I really am looking forward to the vb3 version ;)

[assassingod]

1.3 Released

I just uploaded 1.3. It contains many new features, all listed in the first post.
Screenshots:
http://www.assassingod.com/screenshots

There are LOADS of screenshots to browse through.:)

[iceman-x]

Nice thanks. :)

[Fargo]

well chit..I seemed to have buggard mine :(

Will go through my work before sayin anything more...



W00t!! Ok..just a stupid mistake on my part. The tutorials.php and tutadmin.php files I replaced were not my running versions :o

Wonder which copies I initially replace then?!?! :ermm:

This is a damn fine hack Assassingod - thank you very much for your work :)

[assassingod]

Everything working then?:)

[bandersen]

Thanks for the update!

I get this tho....

Invalid SQL:
SELECT COUNT(*) as total
FROM tutorials
WHERE tutcat ='7' and tutmodded = '1'
mysql error: Unknown column 'tutmodded' in 'where clause'

[assassingod]

Run this query:

ALTER TABLE tutorials ADD tutmodded INT(6)

[bandersen]

Yes, now it works!
But I lost all the tutorials already in there.....

[assassingod]

Really? How odd. Did you do anything else?

[bandersen]

No...
They just got zero'd out sort of...

If I look in the admin panel I can still see the stats, like there should be something there, but if I click the link for most viewed tutorial.... it takes me to view a tutorial that is not there.

[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:

SELECT *
FROM tutorials


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:

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/upload/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....

[Fargo]

Everything working then?:)

Yes it does..perfectly even :D

thanks again for your contribution :)

[assassingod]

bandersen;
1. There's a fix somewhere in this thread.
2. I'll fix this tomorrow:)
3. Thats the mini-rating system. When a tutorial gets a certain amount of votes, it'll be classified as a good tutorial. I'll make a better one soon.

[bandersen]

I tried the below... but code didn't match for 1.3:
I changed the numbers in the following string with no html success (line 267 in tutorial.php):

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



[QUOTE=assassingod]iceman-x, Areku;


Areku;
1. https://vborg.vbsupport.ru/showpost.php?p=450403&postcount=53


But use this as the replacement:

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

[assassingod]

I tried the below... but code didn't match for 1.3:
I changed the numbers in the following string with no html success (line 267 in tutorial.php):

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



[QUOTE=assassingod]iceman-x, Areku;


Areku;
1. https://vborg.vbsupport.ru/showpost.php?p=450403&postcount=53


But use this as the replacement:

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

I'll redo this for you tonight:)

[Areku]

Is it me or we get just the THUMBS DOWN icon on every tutorial?

Also, where do I allow HTML posting?

Thanks!

[assassingod]

Until it gets a certain ammount of votes, it'll stay with thumbs down. 1.4 will have a better system that the current one.

[Areku]

I don't think this is a nice way to display it... I mean, there may be old well known and good tutorials ported to your system which require thumbs up ;)

What about the HTML? ;)

[Areku]

Err... something weird has happened...

I upgraded from old hack version to 1.3 and now all the tutorials miss the NEW LINE codes, ie instead of reading:

This is line1
This is line2
This is line3

I get

This is line1This is line2This is line3

Ideas?

UPDATE: Well, actually no VB code is being converted at all!

[assassingod]

Edit:
I don't understand what you did. Did you upgrade?

[Areku]

I:

1) Downloaded
"// Tutorial Hack
// Coded By: assassingod

// Version: 1.3
"

from the first thread.

2) Ran the queries missing in the version I installed earlier

3) Added the new templates, updated the old ones with the new codes

4) Made the required changes on the files

5) Moderated old tutorials to appear on the new v1.3

Now, no BB code is parsed, although is stored correctly in the DB.

Ideas?

[assassingod]

Odd. I'll have to get back to you on that. But, try inserting <br /> for a new break and see what happens.

[Areku]

Am I expected to have HTML enabled without knowing?

Also, any of the VB code works at all... nor B, nor FONT, nothing....

Thanks assassingod!

[Areku]

Hmmm... it seems it supports HTML anyway, so that may be the explanation on why it's allowing HTML but disallowing BB code?!

[Areku]

Also, it seems $tutvoteno at tuts_tutvote template is not parsed...

[assassingod]

Yes, it's possible the code for parsing the tutorial content has been messed up. I'll cook up a fix ASAP.

[assassingod]

Also, it seems $tutvoteno at tuts_tutvote template is not parsed...
$tutvoteno is called in tutorials.php so it should be. I'll look into it

[Areku]

Well, may be u can add some switches like: ALLOW BBCODE yes/no? ALLOW HTML yes/no? ;)

Thanks for the fixes.

Right now I NEED BOTH Html and BB codes, for example.

[Areku]

And for tutno....

I guess you condition it to a YES until someone votes it YES? Until then, NO does not appear?

[assassingod]

Yes, this way it prevents users from being able to give a vote a minus number.

[Areku]

They still could do it by calling the URL intentionally I guess ;)



About the search feature... which field(s) does it search the text into?

I didn't manage to get any results using keywords found on title nor in content itself...

[assassingod]

It searches using the tutorial title. I have had little troubles with it but 75% of the time I found what I needed to. 1.4 will contain a better search.

[Areku]

So will we have a fix for the bbcode parsing problem or shall we wait for 1.4? If so, when do u schedule 1.4?

Thanks!

[assassingod]

So will we have a fix for the bbcode parsing problem or shall we wait for 1.4? If so, when do u schedule 1.4?

Thanks!
Until I start on 1.4, I will provide fixes in this thread:):)

And for a release date for 1.4, I cannot say.

[IKer]

Big thx for 1.3 releaze ;)

[Areku]

IKER is it working correctly for you?

AM I the only one having installed 1.3?

Am I the only one having problems with content parsing?

Thanks!

[Exero]

is there one for vb3?

[surfhog]

assassingod, I realise that you are a very busy beaver :)

Could you give me some ideas of how I might be able to use something simular this on vb3 please.

Would it be something like adding additional web pages and linking them into the forum??

thanks for your time;)

[Areku]

a fix for the parsing problem would be AWESOME too ;)

[assassingod]

Sorry for not getting back to anyone about updates for this hack - been a bit busy. Will work on everything tonight.

[Areku]

Cool thanks!

[Areku]

It's been one week... no fix yet for the parsing problem? ;)

[weezer412]

well i updated everything works but VB code doesnt work uh oh lol

http://www.thecerealkiller.com/forums/tutorials.php?action=viewtut&tutid=4


thats some nasty stuff right there man

[weezer412]

and no1 can post new tutorials

[weezer412]

you cant make a tutorial and stop offering support man

[assassingod]

Sorry I have been busy and not been able to support any of my hacks. I'm going to sort out everyones problems A.S.A.P - Sorry for not getting back to everyone sooner.

[weezer412]

Sorry I have been busy and not been able to support any of my hacks. I'm going to sort out everyones problems A.S.A.P - Sorry for not getting back to everyone sooner.



please hurry man seriosuly its so messed up its parsing the html and doest recognize the vb code

[assassingod]

Have you tried:
https://vborg.vbsupport.ru/showpost.php?p=450403&postcount=53 ?

[Areku]

None of the code is parsed at all! Even CR's are not parsed, not just image tags...

[assassingod]

Alright, didn't know it was that serious. Let me try and sort it out

[weezer412]

Have you tried:
https://vborg.vbsupport.ru/showpost.php?p=450403&postcount=53 ?


well it didnt happen until i updated it so i dunno

[assassingod]

I really cannot see an obvious reason why this is happening. The best thing I can suggest is to reupload tutorials.php from the zip.

[weezer412]

the problem is not int utorials.php although i did reuplaod it just to be sure heres an example of the hell im facing


http://www.thecerealkiller.com/forums/tutorials.php?s=&action=viewtut&tutid=10

[assassingod]

Have you added any tutorials after the upgrade? Also, do you mind setting up a test account for me?

[weezer412]

Have you added any tutorials after the upgrade? Also, do you mind setting up a test account for me?


no all were b4 the upgrade then i added sum code u had in the last posts bc none of my tuts were showing up


test account?

[assassingod]

Try adding a tutorial now. And test account on your forums (ie, username test, password test)

[assassingod]

Also, i've checked your site and it doesn't seem to be running the latest version (Are you sure you updated the hack properly?)

[Areku]

I've reinstalled it from scratch and reuploaded latest version and still nothing...

Any other ideas?

[assassingod]

Can you install it on a testboard (Ifyou have one) and see if the problem still occurs? I have downloaded the zip in the post and installed it over and over again and cannot reproduce the problem

[Areku]

Then it must be it conflicts with another hack...

THe only one I can think of is maybe the one that saves you bandwith by removing unneeded spaces... wdy think?

[Matt D]

Is it just me, or does the search engine not work? When I click "search" without any input, I get a list of all the tutorials, but keyword specific searches based on tutorials I have already posted yield no results.

[assassingod]

Matt D, that's a bug - I may fix this. Also, the search function is very basic, however, it does work.

[Matt D]

What I've just noticed is that if you search for the last term in a tutorial header

ie:

How to upgrade to Windows XP

Searching for XP, you will find the article in the search results, but if you search for any of the other words (how, to, upgrade, windows) - you will not find the article in the results.

Give it a test at
http://www.ostutorials.com/tutorials.php?s=&action=search

With an actual article on the site, Global AWStats v5.6 on Ensim

[assassingod]

Ok I think I know what I did wrong. Give me time to update the ZIP.

[Areku]

Asssassingod,

Any chances for you to install and test the "save bandwidth" hack to see if it affects your hack's parsing?

Thanks!

[Areku]

This one i meant:
https://vborg.vbsupport.ru/showthread.php?t=56589&highlight=save+bandwith

[Parmstig]

- A vB3 port is being considered

oh, plz plz :)

[Areku]

OK it is parsing HTML correctly but it is ignoring VB CODE at all.

I've removed the "save bandwith" hack and results are THE SAME.

Has any one installed this hack onto a vb2.3.x board and have it working? online? can I have your URL?

Assassingod, any other ideas???

Thanks!

[assassingod]

I, since the beginning of this problem, am still totally confused to why it's not working. The code is exactly the same as it was in 1.2, and nothing else has changed. I really cannot think of anything to do, try editing the tutorial and saving it - that may trigger something.

[Areku]

Already tried and nothing happens... how/when/where do you parse the vb code? may be i modified any hack which is affecting yours...

[assassingod]

No that's not possible unless you modified tutorials.php - Nothing else could affect it.

[Areku]

Then I'm stunned, I reinstalled, and it's not that hard to implement! :? :? :?

[Areku]

YEEEEEEEEEEEEEEEEEEEEEEEEEHA!

Finally fixxxxed it!!

I forgot to revert tut_view template!!!

DAMNIT!



So cool hack! Thanks finally Assassingod! ;)

[assassingod]

YEEEEEEEEEEEEEEEEEEEEEEEEEHA!

Finally fixxxxed it!!

I forgot to revert tut_view template!!!

DAMNIT!



So cool hack! Thanks finally Assassingod! ;)

Well that would of never crossed my mind;) I'm glad you have sorted it though!

[GTA3_Mafia]

Any update on the next version? :)

[assassingod]

It's currently being worked on as we speak, the adminisitrative CP end is complete and the user-end is not far off it:)

[Areku]

Be sure to rename CATAGORYS to CATEGORIES ;)

Btw, is there any easy way to enable HTML output support for 1.3a?

Since tutorials are moderated, I can't see why HTML should be off...


Thanks!

[Areku]

Bah,

found myself :P

Just change

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

to

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

in tutorials.php ;)

[assassingod]

Be sure to rename CATAGORYS to CATEGORIES ;)

Btw, is there any easy way to enable HTML output support for 1.3a?

Since tutorials are moderated, I can't see why HTML should be off...


Thanks!
Yes that's been sorted;) hehe

[Areku]

Could u help me out splitting output (tutorials list) onto two colums?

I.e.

category tutorials icon category tutorials icon
category tutorials icon category tutorials icon
category tutorials icon category tutorials icon
category tutorials icon category tutorials icon

[assassingod]

I'll take a look into this if I have time:) It's a good idea too