yeah thanks TECK for the support i will rewrite a better set of instructions as well as a better installer later when i get the free time... regards...

g-force2k2

Perhaps you could use vBhackmaker:)

Satan

yep is a great idea... however i still believe the old school way is better... no fancy stuff and u'll be ok always... like i did with wooolf's board.
imo, manual way is the best way. you are always in control and if you make a query code error then you know wich one is it and check the syntax rightaway...

i use chen's query hack, and i never had a prob... it does the job great...

]it's wooolF , not wooolf :p

Well, you don't have to. That table has columns that auto-increment, so you don't have to even specify a number - just put NULL and the next number will be automatically used. And I've been adding settingid's in all sorts of places manually for a long time with no problem now. :)

awesome hack! Got it installed in just couple minutes. I used everything from the first post that G Force did and it worked. I ran the install_warning.php as last and then went to vbulletin options and made the changes to the usergroups for the warning stuff. When I submitted that it started working at once :)

One question though, where do you change the color of the view warning list. I am getting a black font and can't find where to change that. Thanks

http://www.dtmpower.net/forum/warn.php?s=

thats great to hear Dado :) as for you request in the warn_list & warn_listing templates you can just change the:

to:

see if that helps ;) regards...

g-force2k2

thank you. I didn't even notice the templates were all the way at the bottom :) Sorry :D

Best hack i've seen in quite some time, *Clicks Install*

Well... I've read through this whole thread and i am still stumped. I had v1.0 installed and running with no problems, Went through the upgrade for v2.1 and ran the installer which set everything up but couldn't see the links in the threads and kept getting a DB error when trying to view the logs from the CP. I hadn't seen the bit about running the setup from the Vb Settings.

Decided to uninstall it and ran the uninstaller and removed all the add ons in the files and templates and then proceeded to do a complete install from scratch.

Now when I run the installer it hangs in step 2 at: Inserting Warning System Settings Into VBulletin Options


and I get this sql error:

Database error in vBulletin Control Panel 2.2.7:

Invalid SQL: INSERT INTO settinggroup VALUES (40, 'Warnings System', 40)
mysql error: Duplicate entry '40' for key 1

mysql error number: 1062

Date: Sunday 08th of September 2002 09:10:08 PM
Script: http://www.pprune.org/forums
Referer:

As I am not so au fait with sql I am stumped.

Anyone care to advise what to do next?