Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > vBulletin 2.x > vBulletin 2.x Full Releases
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools
Archiv for vBulletin Details »»
Archiv for vBulletin
Version: 1.00, by Xenon Xenon is offline
Developer Last Online: Oct 2023 Show Printable Version Email this Page

Version: 2.2.x Rating:
Released: 05-26-2002 Last Update: Never Installs: 38
 
No support by the author.

Ok, i have completed my Archivhack now

Hackversion: 3.00
Known Bugs: The permissionsystem doesn't work with php4.1.x
What it does:
It compresses a thread in the database, so it would take less space, but it cannot be posted in it anymore.
Zlib-functions must be installed on your server. Without this hack won't work

You can revert Archives to threads when you want it.
A small searchengine is also included.


Install it at your own risk!!!
It should work without problems, it has been tested very long, but you know Murphys Law..

A hint how to use it with PPN's thread description Hack is in the install file.

Thanx to Foxtroter for the help on english Templates.
The conversion can take a longer timespan, read this for optimization.

look at the screenies below

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #52  
Old 08-01-2002, 12:23 PM
Xenon's Avatar
Xenon Xenon is offline
 
Join Date: Oct 2001
Location: Bavaria
Posts: 12,878
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

thanks

hmm, moving threads older than 6 month is possible i think isn't it

i don't have much free time these days, so coding and upgrading hacks isn't something what i can doo these days, but i'll put it on the to do list
Reply With Quote
  #53  
Old 08-01-2002, 02:35 PM
proxyMX's Avatar
proxyMX proxyMX is offline
 
Join Date: Jun 2002
Location: Seven of Nine is hot! :do
Posts: 294
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Yeah, ive thought it through, and ill enslave some mods to do the dirty work :P
Reply With Quote
  #54  
Old 08-01-2002, 07:50 PM
Xenon's Avatar
Xenon Xenon is offline
 
Join Date: Oct 2001
Location: Bavaria
Posts: 12,878
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

that's why they are mods
Reply With Quote
  #55  
Old 09-07-2002, 08:43 PM
Harley-1 Harley-1 is offline
 
Join Date: Apr 2002
Posts: 17
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Hallo,

sag mal gibts eine Möglichkeit alle Beiträge die man mal ins Archiv geschoben (Konvertiert) hat wieder in ein Forum zu verschieben?
Bisher gibts ja nur ne Möglichkeit einzelne Beiträge zurück zu konvertieren.
Reply With Quote
  #56  
Old 09-10-2002, 06:09 PM
cobradude cobradude is offline
 
Join Date: Nov 2001
Posts: 93
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Has anyone used this on medium sized sites in the 150,000-250,000 post range? How much did it decrease the size of your database?
Reply With Quote
  #57  
Old 09-10-2002, 09:51 PM
fastforward fastforward is offline
 
Join Date: Oct 2001
Location: NC, USA
Posts: 399
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally posted by cobradude
Has anyone used this on medium sized sites in the 150,000-250,000 post range? How much did it decrease the size of your database?
I've archived 574,902 posts in 126,980 threads at http://dbforums.com/archives/ My archiv table is 212MB.
Reply With Quote
  #58  
Old 09-10-2002, 11:06 PM
cobradude cobradude is offline
 
Join Date: Nov 2001
Posts: 93
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Thanks fastforward. What do you figure it was prior to compression?
Reply With Quote
  #59  
Old 09-11-2002, 12:09 AM
fastforward fastforward is offline
 
Join Date: Oct 2001
Location: NC, USA
Posts: 399
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally posted by cobradude
Thanks fastforward. What do you figure it was prior to compression?
Well, my post table is 1.2GB (not including indexes) and that has 820,000 posts. So I'd say the archiv hack reduces the size by roughly 2/3rds.
Reply With Quote
  #60  
Old 09-12-2002, 08:41 AM
Xenon's Avatar
Xenon Xenon is offline
 
Join Date: Oct 2001
Location: Bavaria
Posts: 12,878
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Harley: du hast die möglichkeit einfach ne whileschleife aussen rum zu bauen und damit alle archive zu reintegrieren.

ich werde sowas vielleicht auch mal selber einbaun, aber derzeit hab ich wenig zeit, muss meine zwei wochen nacharbeiten die ich nicht da war
Reply With Quote
  #61  
Old 09-18-2002, 08:15 PM
cobradude cobradude is offline
 
Join Date: Nov 2001
Posts: 93
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Got this database error when trying to arhive....

Database error in vBulletin Control Panel 2.2.7:

Invalid SQL: SELECT title, postusername, description, forumid FROM thread WHERE threadid=1
mysql error: Unknown column 'description' in 'field list'

mysql error number: 1054

Date: Wednesday 18th of September 2002 02:15:23 PM
Script: http://www.clubcobra.com/forums/forums/admin/archiv.php
Referer: http://clubcobra.com/forums/admin/ar...action=chooser

Nevermind....I thought I had the description hack installed....Got it squared away.
Reply With Quote
Reply


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 05:04 AM.


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.05183 seconds
  • Memory Usage 2,304KB
  • Queries Executed 25 (?)
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
  • (3)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (6)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (11)post_thanks_box
  • (11)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (11)post_thanks_postbit_info
  • (10)postbit
  • (11)postbit_onlinestatus
  • (11)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
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete