Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 General Discussions
  #1  
Old 03-13-2011, 10:57 AM
Log on Log on is offline
 
Join Date: Aug 2009
Location: KSA
Posts: 91
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default some table and its functions

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
Reply With Quote
  #2  
Old 03-13-2011, 08:09 PM
BirdOPrey5's Avatar
BirdOPrey5 BirdOPrey5 is offline
Senior Member
 
Join Date: Jun 2008
Location: New York
Posts: 10,610
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
Reply With Quote
  #3  
Old 03-14-2011, 06:16 AM
Log on Log on is offline
 
Join Date: Aug 2009
Location: KSA
Posts: 91
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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
Reply With Quote
  #4  
Old 03-14-2011, 11:18 AM
BirdOPrey5's Avatar
BirdOPrey5 BirdOPrey5 is offline
Senior Member
 
Join Date: Jun 2008
Location: New York
Posts: 10,610
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
Reply With Quote
  #5  
Old 03-15-2011, 08:47 AM
Log on Log on is offline
 
Join Date: Aug 2009
Location: KSA
Posts: 91
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Ok got it.. thank you very much

I wish to have answers for the rest of the tables


Regards
Reply With Quote
  #6  
Old 03-15-2011, 06:00 PM
richy96's Avatar
richy96 richy96 is offline
 
Join Date: Apr 2008
Location: England
Posts: 93
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 04:42 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.05047 seconds
  • Memory Usage 2,202KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (6)post_thanks_box
  • (6)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (6)post_thanks_postbit_info
  • (6)postbit
  • (6)postbit_onlinestatus
  • (6)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete