vb.org Archive
Page 2 of 4 1 2 34
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.5 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=113)
-   -   Clean vB Database (https://vborg.vbsupport.ru/showthread.php?t=107134)

PennylessZ28 02-04-2006 06:31 PM
I don't want to be a butthole, but I'd be werry too of someone with 29 posts releashing their first hack that evades and empties your database.

Marco van Herwaarden 02-04-2006 06:34 PM
Quote:
Originally Posted by GTAce
Right...I dont understand...why would we want to empty out "unneeded tables"?
Like i said, vB don't have any unneeded tables, they all have their purpose. Unless you know very good what you are doing and don't need a table in your situation, i would advise against using this.
Quote:
Originally Posted by Gizmo5h1t3
so are you deffo warning against using this marco??
See above.
Quote:
Originally Posted by XtremeOffroad
Also would uninstalling this fix or restore any possible breaks in the permissions.
I didn't have a look in the hack itself. But i guess no permissions will be broken, just that some stuff that is controlled by an admin permission in standard vB, will probably be open for use without the permission (assumption).
Quote:
Originally Posted by Symen_4ab
If this hack empties the "word" table, and you're not using mysql full-text search, you'll end up with a broken search function unless you rebuild your word index.
(using this as a cron job is a very bad idea).
That is exactly my point. There are some situation (full-text for example) in which it could be good to empty the word table, but in all other cases it could for example break your search. Without warnings like that, i advise not to use this, unless you are capable of checking what it exactly does, and know 100% that it wil be the best to do in your situation.
Quote:
Originally Posted by Symen_4ab
But if you want to move to another host, "cleaning" your database is a good idea, so the database dump will be the smallest possible. (I don't know what it cleans, though)
That could be a reason to do it, but you would need to be aware that you would loose info or have to rebuild info after the move.

Symen_4ab 02-04-2006 07:00 PM
Quote:
Originally Posted by MarcoH64
Like i said, vB don't have any unneeded tables, they all have their purpose. Unless you know very good what you are doing and don't need a table in your situation, i would advise against using this.
See above.
I didn't have a look in the hack itself. But i guess no permissions will be broken, just that some stuff that is controlled by an admin permission in standard vB, will probably be open for use without the permission (assumption).
That is exactly my point. There are some situation (full-text for example) in which it could be good to empty the word table, but in all other cases it could for example break your search. Without warnings like that, i advise not to use this, unless you are capable of checking what it exactly does, and know 100% that it wil be the best to do in your situation.
That could be a reason to do it, but you would need to be aware that you would loose info or have to rebuild info after the move.
Congrats on 7000th post Marco ;)

Hum.. Back on topic, to say that I have nothing more to say..

Tidy 02-04-2006 11:14 PM
Just What I Need Thank You Very Much!

Tidy 02-04-2006 11:33 PM
Just What I Need Thank You Very Much!

Zia 02-05-2006 04:53 AM
Should I Use It ??

XtremeOffroad 02-05-2006 06:41 AM
Quote:
Originally Posted by Zia
Should I Use It ??
I thaught by now the creater would have had some updates on details or comments on their hack.
After all the warnings most if not all coders would have at least come by to explain a bit more details or try to back up their hack.
Coders I have alot of trust in have commented on this and I'll take their warnings till the author comes here and shows otherwise.

Gizmo5h1t3 02-05-2006 11:23 AM
mebbe it would be wise to remove this, until the author supplys a reasonable argument as to how this could serve any useful purpose,while having it remain safe for users.
dont forget....most ppl on here..(including me)...ARENT l33t coders etc.....and might just install this, and find things going wrong...

props to marco for the warning tho....

Tulsa 02-05-2006 11:31 AM
Well since we're all admins of sites here, I would hope that anything that says it's going to be altering your database would scream "red flag" to you and you'd hold off installing this until it's value and safety is proven.

HaMaDa4eVeR 02-05-2006 12:06 PM
Quote:
Originally Posted by MarcoH64
Let me warn future users of this hack that there are no 'uneeded tables' in vBulletin. All tables have their function, and emptying some tables should not be done without very good understanding what they are used for.

Personally i would advice strongly against a hack that not even give the full list of tables that are emptied, but just 'adminlog,session,word...etc.'.

Tables like adminlog, have already a standard vB function to clean, controlled by Admin permissions. Installing this seems to break those permission setting (or at least not use them).
dear marco :
I knew all vB tables have functions and jop , but the function of (word,adminlog,session) is not important , by anther meaning , if you empty these tables your vB database will not damage ,
the full list of tables you will find screen shot that i attached it here , and when you install it I named the link with table name , if you click (Clean Word Tables) you will empty the word tables and so on...
https://vborg.vbsupport.ru/attachmen...chmentid=42112
Symen_4ab: yes that's my aims ,, if you want transfer your site from host to anther and your database size 700 MB , sure my hack will help you , coz. word tables took more than 20% from post tables .
I advice you to test 1st in your test forum ,
thanks all and sorry for delay replay


All times are GMT. The time now is 09:53 PM.
Page 2 of 4 1 2 34
Show 40 post(s) from this thread on one page

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01579 seconds
  • Memory Usage 1,747KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (8)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (3)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.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/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.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
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete