I'm not sure why it does what it does because I'm just learning mysql, but according to bitg's instructions to cross reference the group id's and such worked perfectly.

It seems like the "forum rules" box wasn;t married to the Forum rules category in my Admin CP correctly. Maybe because I had added other categories to my admin CP already?

Like I said, I'm just learning all this over the last two weeks. But that's what seems to be the problem, otherwise, I don't know why it worked, but matching up the ID numbers as bitg mentioned made everything better.

Hope that helps !

Well it's nothing on my end ;)

Basically i think the textfile hasn't been updated in people's cache :D

I see the same. A query in your text file inserts 42 into settinggroupid in the setting table.

INSERT INTO setting (settingid,settinggroupid,title,varname,value,desc ription,optioncode,displayorde r) VALUES (NULL,42,'Rules','forumrules','....

I'm sorry, this doesn't work. I'm not a sql or database expert, but I can copy and paste with the best of "em, and that's what I did.

I copy and paste the first query, which is

INSERT INTO settinggroup (settinggroupid,title,displayorder) VALUES (NULL,'Forum Rules','78');

and i get the following error

Warning: mysql_num_fields(): supplied argument is not a valid MySQL result resource in /home/bret/public_html/forums/admin/query.php on line 29

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/bret/public_html/forums/admin/query.php on line 33

then I run the second query, and get the following error:

INSERT INTO setting (settingid,settinggroupid,title,varname,value,desc ription,optioncode,displayorde r) VALUES (NULL,42,'Rules','forumrules',' <p><normalfont>Registration to this forum is free!
We do insist that you abide by the rules and policies detailed below.
If you agree to the terms, please press the Agree button at the end of the page.
Note: By pressing the button you declare that you are over the age of 13.
If you are 13 or under, please use
<a href="register.php?s=$session[sessionhash]&action=signup&who=coppa&url=$url">this registration form</a>.</normalfont></p>

<p><normalfont>Although the administrators and moderators of $bbtitle will attempt to keep all objectionable messages off this forum,
it is impossible for us to review all messages. All messages express the views of the author,
and neither the owners of $bbtitle or Jelsoft Enterprises Limited (developers of vBulletin)
will be held responsible for the content of any message.</normalfont></p>

<p><normalfont>By clicking the Agree button, you warrant that you will not post any messages that are obscene,
vulgar, sexually-orientated, hateful, threatening, or otherwise violative of any laws.</normalfont></p>

<p><normalfont>The owners of $bbtitle have the right to remove, edit, move or close any thread for any reason.</normalfont></p>','Here is what the guests on your forum will see upon registration. They have to read this page and agree to the terms before registering.','textarea','1');

ok, i downloaded another version of the query.php file, and i got the first qquery to run, but the second still gives me trouble

mysql error: You have an error in your SQL syntax near ';
' at line 1

Now I am having a wierd problem. I have already installed a Quiz system on my site and it is using the "settinggroupid" of "42". When I install this hack, it makes the section in "ACP|vBulleting Options" called "Forum Rules" but it puts the forum rules form box in the "Quiz" section. See for yourself. when I change the "settinggroupid" to something I think is not being used, the form box goes away altogether. I don't get it.

How do I fix this?

Go to setting.php in your admin directory and manually remove the settings :)

Then change all instances of 42 in the queries that are meant to be run to something like 111 :)

- miSt

What settings are in the setting.php file? When installing this hack, there was no mention of modifying that file.

When I change the "42" int he database, the forum rules dissapear altogether, but the category stats the same.

http://www.yoursite.com/forums/admin/setting.php

Remove whatever option was added to the vBulletin Options page.