Archiv for vBulletin

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

[snyx]

impressive!
[high]* snyx runs off to install[/high]

[Xenon]

Originally posted by Velocd
How about using PPN's recent thread description hack to be able to add descriptions to the archives? Or will this already work if you have PPN's thread description hack installed?

No, it doesn't work with the installed PPN Hack.
I'll make an option in the next version, so you can use the description hack, shouldn't be a great problem

[high]* Xenon has to take a look at PPNs Hack again[/high]

[Xenon]

yeah, will integrate this next version, but i'll also change it a bit, so you can use a description w/o PPNs Hack

for all of you, which want to use PPNs Hack with the Archive, make following changes:

[sql]
ALTER TABLE `archiv` ADD `description` VARCHAR(100) NOT NULL;
[/sql]

edit admin/archiv.php:

find:

PHP Code:

$thread=$DB_site->query_first("SELECT title, postusername, forumid FROM thread WHERE threadid=$threadid"); 


replace with:

PHP Code:

$thread=$DB_site->query_first("SELECT title, postusername, forumid, description FROM thread WHERE threadid=$threadid"); 


find:

PHP Code:

$DB_site->query("INSERT INTO archiv (archivid,ersteller,title,forum,firstpost,lastpost,posts,topposter,archivtext) VALUES (NULL,'".addslashes(htmlspecialchars($thread[postusername]))."','".addslashes(htmlspecialchars($thread[title]))."','".addslashes(htmlspecialchars($forum[title]))."','$first[dateline]','$last[dateline]','$totalposts','".addslashes(htmlspecialchars($topposter[postuser]))." (".$topposter[posts].")','".addslashes($fulltext)."')"); 


replace with:

PHP Code:

$DB_site->query("INSERT INTO archiv (archivid,description,ersteller,title,forum,firstpost,lastpost,posts,topposter,archivtext) VALUES (NULL,'".addslashes(htmlspecialchars($thread[description]))."','".addslashes(htmlspecialchars($thread[postusername]))."','".addslashes(htmlspecialchars($thread[title]))."','".addslashes(htmlspecialchars($forum[title]))."','$first[dateline]','$last[dateline]','$totalposts','".addslashes(htmlspecialchars($topposter[postuser]))." (".$topposter[posts].")','".addslashes($fulltext)."')"); 


edit
archiv_showarchiv template and add $archiv[description] wherever you want it

should work but isn't tested

[Ordovicium]

Originally posted by Xenon

but post your wishes, so i can include them all in next version

Integration into the search Engine.

[Xenon]

genau, lass mich nur leiden ^^

will see what i can do

[Nam]

Is this the hack that has already been used at www.sitepointforums.com ? The reason I ask is because when I search stuff at that site, all old thread are closed that I couldn't reply even if I want to.

If it's, it's a great hack.

[Xenon]

no, it isn't.

[Xenon]

ok, new version out now.

just a small update, but i'm sure you'll enjoy it.

You can now convert threads which have special options (like last post x days ago and so on)
Also you can make an Optional description to an Archiv. And you have to change 1 line when you use PPN's hack, every other thing is included

@Ordovicium: have had a look at search.php, this would be a real hard work to integrate it into the search engine, so i can't include it in near time.
Wie heissts, ich legs erstmal zu den Akten, vielleicht kommt mir irgendwann mal die geniale idee WIE

[Ordovicium]

ok. No Problem.

[Frank-kun]

Hey Xenon, great hack, works like a charm. But there's a tiny bug. If the forum you make an archived thread from has an apostrophe in it..like "AnimeInfo's Best Of", you get a database error when you try to view the archive since the code gets confused about the apostrophe and thinks it's a single quote. I'm not sure if you'd be able to fix the bug, but I thought I'd let you know.

I just changed the name of my forum to one that didn't have an apostrophe and it works good.

I also took the liberty of rewriting the text that shows up in the templates in English (hope you don't mind). If you folks want maybe I can repost Xenon's templates...