show tip hack version:1.0

[xware]

# version:1.0
# Date: 02.18.02
# Description: This hack allows you to add a tip to forumdisplay page, like a newsfader. Admin can edit the usergroups to set which usergroup can post new thread as a tip.
# admin or moderarors can edit thread to set or cancel a tip's show.
#Backup your database and files before install this hack

[xware]

Here's the demo in admin cp.

[xware]

here's a demo in post newthread:

[xware]

here's a demo in tip show:

[xware]

Here's a demo for admin or mods edit thread:

[maverick1236]

thanks for a great hack

its only showing the TITLE of the tip post in the fader

any way to scroll the whole post?

[Dade]

Nice hack.

[Kumaro]

excellent hack. its great for forums that include support

[Kumaro]

after installation, I tried to edit the Administrator user group and then got this error:

Database error in vBulletin Control Panel 2.2.1:

Invalid SQL: UPDATE usergroup SET title='Administrators',usertitle='Administrator',s tarlevel='5',starimg='bb',cancontrolpanel=1,canmod ifyprofile=1,canviewmembers=1,canview=1,cansearch= 1,canemail=1,canpostnew=1,canmove=1,canopenclose=1 ,candeletethread=1,canreplyown=1,canreplyothers=1, canviewothers=1,caneditpost=1,candeletepost=1,canu sepm=1,canpostpoll=1,canvote=1,canpostattachment=1 ,canposttip=1,ismoderator=1,canpublicedit=1,canpub licevent=1,canthreadrate=1,cantrackpm=1,candenypmr eceipts=1,maxbuddypm=5,maxforwardpm=5,canwhosonlin e=1,canwhosonlineip=1 WHERE usergroupid=6
mysql error: Unknown column 'canposttip' in 'field list'

mysql error number: 1054

Date: Monday 18th of February 2002 10:25:02 PM
Script: http://forums.411hype.com/admin/usergroup.php
Referer: http://forums.411hype.com/admin/usergroup.php?action=edit&usergroupid=6

[Kumaro]

actually, there are many many errors when I install this....not a good hack if it is only compatible with unhacked boards.

[sleepbirdcyp]

but it's working on Vb2.01 VB2.22

[xware]

Originally posted by Kumaro
actually, there are many many errors when I install this....not a good hack if it is only compatible with unhacked boards.

please note:
Run the following queries (for info on how to run queries go here: http://www.vbulletin.com/forum/showthread.php?threadid=18558)

ALTER TABLE usergroup ADD canposttip SMALLINT (5) not null;
UPDATE usergroup SET canposttip=1 WHERE usergroupid=5 OR usergroupid=6 OR usergroupid=7;
ALTER TABLE thread ADD showtip CHAR (3) not null;

If you haven't ALTER TABLE usergroup before you run the following queries then be a error. :greedy:

This hack is compatible with all unhacked or hacked boards

[MiF]

Does anyone else have a problem downloading this attachment? Seems the RAR file is corrupted when I download it.

Edit: I was able to extract it. don't know what the problem was initially.