some table and its functions

[Log on]

hi everybody,

I have questions about some of the forum tables such as:

Postparsed
posthash
postedithistory
postlog
user
thread
template
reputation


what is the function of each one?
If I truncate the table, what is the affects?



Thank you

[BirdOPrey5]

user = contains all the infomation on each user you have, username, userid, email address, a bunch of preferences... You will lose users if you truncate the table and who knows what else would break.

thread = The info on each unique thread including thread title, who it was by, when it was posted (dates), and the postid of the first post. AGAIN, do not manually mess with this table.

template = All your templates that control how your vbulletin forum looks and runs. DO NOT manually edit this.

reputation = All the reputation your users have left for each other, on occasion I empty this table so everyone starts with a fresh slate but all reputation comments will be lost.

The other tables have to do with posts, I would suggest not manually editing any of them either.

[Log on]

thank you BirdOPrey5

did the number of the reputation let say my reputation is 500 point If you truncate reputations' table will be go again to ZERO ... or just the comments ?


I wish to have answers for other tables


Regards

[BirdOPrey5]

You will need to update the counters for Reputation (or it will happen eventually on its own) but yes you lose all your reputation points too, it will reset to whatever your forum default is, usually 10 points.

[Log on]

Ok got it.. thank you very much

I wish to have answers for the rest of the tables


Regards

[richy96]

You could try using PMA (PhpMyAdmin) that's what I use to look around in the vbulletin tables structure and browse the contents. It should be available on your hosts server as part of the standard hosting package, otherwise if you have a test installation of php/mysql/apache as I do on my home LAN you can create a backup of your live site and also install PMA there and mess around with the backup instead.

In fact even getting a backup of a live site to run locally is a challenge (or so I found) that will teach you a lo about vbulletin by the time you have it working!

At least you can then break things to your hearts content while you learn how it all works

AS we all as PMA, some other tools I find invaluable by the way are :

Firebug+FirePHP (php debugger) plugins for Firefox

Venkman javascript/AJAX debugger plugin for Firefox

Web developr tools (again for Firefox) I use this to view the generated html after javascriot/ajax operations

Actual Search and Replace (for finding any text references within folders full of source code file)

The first three are free - the last one is pretty cheap shareware but well worth it (to me)

I personally use Dreamweaver for my php/html/javascript editor, but also have the NetBeans IDE (which is free) but have not used it yet.

I use one PC for dreamweaver and another pc as my apache server and debugging browser

Actually I'd be quite interested to hear what other folks are using

Rich