adding a new table to vb_user

[rin]

Hello,

as you can see on my forum, i am adding a new "rules box" which needs to applied to in order to remove it from the screen.
to get a better idea visit this link:
http://www.kawaiination.com/communi....php?styleid=11
when "apply to these rules" is clicked i want to start a script which searches the userid who clicked the link and then adds a "1" into a table called something like "read_rules". 0 should be the default value.
so, what i am asking you is:
can you tell me a script which adds a table "read_rules" into "vb_users" with a default value of "0"?

[sabret00the]

you can add the table in phpmyadmin :)

though you should check the forums theirs a couple rules hacks :)

[rin]

hehe thanks for your answer.
i would like to make my own one though.
in mysqladmin i click "vb_user" in the left frame and now, where exactly can i add such a table as described above? do i click "operations" on top and then...? :)
thanks for any help. :)

[rin]

please, can you help me?

[Marco van Herwaarden]

First of all you would be much better of if you just added a new column to the user table, instead of creating your own new table. That would be 1 query less on every page load.

I am sorry to say, but if you can not figure out how you can work with phpMyAdmin, you must really ask yourself if you should try coding.

In phpMyAdmin, just select the database you want to work on, then when you have the list of all tables, there must be a link somewhere to create a new table, or a page where you can enter a SQL statement to manually create a table.

[rin]

thanks.
the reason i ask is that i don't have a test database and i dont want to test on my live-database.

[Marco van Herwaarden]

If you have a license you are always allowed to have 1 (not public reachable, so use a .htaccess) test board.