# 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

Here's the demo in admin cp.

here's a demo in post newthread:

here's a demo in tip show:

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

thanks for a great hack

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

any way to scroll the whole post?

Nice hack.

excellent hack. its great for forums that include support

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/user...&usergroupid=6

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

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

please note:
Run the following queries (for info on how to run queries go here: http://www.vbulletin.com/forum/showt...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

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.