Easier editing of the forum rules upon registration

<font size="3">
Easier editing of the forum rules upon registration</font>

Now this isn't much of a hack but what always annoyed me about the forum rules is that they were in a template. Being lazy it was just a pain navigating through the ACP to the signupadult template. So i wanted a way of editing it via the vbulletin options section of the ACP. This hack basically gives you a new option in the ACP to edit the forum rules. It is compatible with all your html and by default uses the standard forum rules set in the signupadult template. However one advantage is that you only edit the text. There is no html tables or anything to muck up if your a html newbie.

Attachment:

[Holidazed]

Well, then how am I supposed to know what it should be and how do I fix it? I am not a programmer or database guy. I just follow the instructions and cross my fingers.

I understand that some of you have fixed it. What do I do to fix this once the query is already run? How do I undo what has been done and do it again correctly?

[Areku]

Same here, i dunno why mist put 42 available to all...

DO what Zenith said, just use phpmyadmin to find out the last field number in your setting table and modify the 42 accordingly.

[Holidazed]

Well, according to my setting table, "42" is my forum rules section. In fact it reads exactly like this.
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
INSERT INTO setting VALUES (184, 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);
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Do I change this to "78" like the first query makes reference too.

Too lost to decide.

[Dean C]

Where did you get the 42 from - it says 78 in the textfile :s?

[Holidazed]

I was looking at the wrong thing. The textfile says "78". Now I know that is nothing more than the display order (not being a database guru) so I left it alone.

Here is what you do:

1. Goto phpadmin and display your database.
2. Select the "setting" table and browse it.
3. Search for "forumrules"
4. Note the number in the "settinggroupid" column
5. Browse the "settinggroup" table
6. Find the entry titled "Forum Rules"
7. Edit the entry
8. Change the "settinggroupid" to the number you saw on the "setting" table.

This should completely fix it. It did for me.

[LilDragonWings]

Thanks to Mist and Bitg...

Worked perfectly with Bitg's instructions on the database adjustment!

Now time to Chisel out my Commandments unto my community.

Word.

[Holidazed]

I may not know how to do everything, but once I figure it out, it helps that I do technical support for a living.

[Dean C]

But this makes no sense as to why you had this problem - the settinggroupid's in the textfile have no reference to 42 :s

- miSt

[Zenith]

Today at 11:09 AM Mist said this in Post #28
But this makes no sense as to why you had this problem - the settinggroupid's in the textfile have no reference to 42 :s

- miSt

You sure about that?

From your textfile....

INSERT INTO setting (settingid,settinggroupid,title,varname,value,description,optioncode,displa yorder) VALUES (NULL,42,'Rules','forumrules','....

[Dean C]

Presst Ctrl + F5 on the first page of this thread then tell me what you see?