show tip hack version:1.0

# 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

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

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