Archiv for vBulletin

[Xenon]

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 (https://vborg.vbsupport.ru/member.php?s=&action=getinfo&userid=13885) for the help on english Templates.
The conversion can take a longer timespan, read this (https://vborg.vbsupport.ru/showthread.php?postid=345018#post345018) for optimization.

look at the screenies below

[Xenon]

screen1

Screenshot from updated version (https://vborg.vbsupport.ru/attachment.php?s=&postid=255718)

[Xenon]

nr2

[Xenon]

3

[Xenon]

last screenie

[Henry-RS]

This looks like a great hack! :)

I may use it when I'm in need of some more space.

[inetd]

Good hack!
I will install later.

[Ordovicium]

Thank you very much, now it works.

I love this hack :)

A little wish for the next Version:
Archive Threads by Date. Convert all Threads which are older than xxxxx.

[Xenon]

ok, will do what i can :)

but i think this wouldn't be next week, because i'm happy now that i've released it, and now i want to make another hack, before i'll optimize it ;)

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

[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?

[snyx]

impressive! :D
* snyx runs off to install

[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

* Xenon has to take a look at PPNs Hack again

[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:


ALTER TABLE `archiv` ADD `description` VARCHAR(100) NOT NULL;


edit admin/archiv.php:

find:

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

replace with:

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


find:

$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:

$DB_site->query("INSERT INTO archiv (archivid,description,ersteller,title,forum,firstp ost,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...

[Xenon]

ok thanks, will have a look at the bug :)

damn, i thought i have translated the templates before posting it here.
i have no problem when you upload translated templates here, feel free to do so :)

[Xenon]

ok, uploaded a bugfixed version

thanks for pointing your finger on it ;)

[Harley-1]

Great hack :) many THX

Hi,
my english isn?t very well so i write in german:D

2 kleine bugs habe ich noch gefunden:

1. Wenn man ein dump von der DB macht und es dann wieder restoren m?chte, dann geht das nich, da immer diese fehlermeldung zu sehen ist:

create table archiv(archivid int(10) unsigned not null default NULL auto_increment,ersteller varchar(50) not null default '

Error: 1101 - BLOB column 'archivtext' can't have a default value

---------------------------

2. Die Usernamen sind bei manchen Postings im Archiv falsch oder besser gesagt durcheinander, also der Originale Poster eines Beitrages ist auf einmal ein anderer und manchmal auch mit anderem Status (anstelle Registered steht dann Gast). Kann mich da auch T?uschen, aber so habe ich das beobachtet.
---------------------------

Sonst wirklich top und wenn dann noch eine Suche wenigstens nach Themen m?glich ist, dann ist er wirklich sehr gut.

[Xenon]

zu 1: hmm, das ist eigentlich kein bug in meinem hack, irgendwie funzt der dump wohl nocht ganz richtig.
hast du die neueste mysql und phpmyadmin version?

notfalls erstelle beim restoren die tabelle einfach selbst. :)

2: komisch, rein codem?sig sollte das eigentlich nicht vorkommen, kann h?chstens sein, dass die DB nach ner Zeit nicht mehr mitkommt und die daten nicht mehr richtig schickt, mal sehn ob ich den fehler zumindest mal nachstellen kann

hmm, ich denke ne suchfkt zumindest f?r themen sollte ich selber noch schreiben k?nnen :)

[Harley-1]

Ja ist ok, mit der SQL kann schon sein weil auf dem server eine 3.23.21-beta-log läuft.

THX

[inetd]

* inetd install hack
* inetd wait new version
:D

[Xenon]

* Xenon is happy

sorry, have much to do this time, so next version will take some time, but'll do what i can :)

[Dean C]

this is such a great hack...im suprised it hasn't got hundreds of replies...

/me goes off to install and will report back soon..

[Harley-1]

Idee: Anzeige der Archive in Seiten aufteilen.
Kann man sowas noch einbauen oder ist das zu aufwendig?

Idea: Display the Archive forums in pages. Can one still insert this or is it too complex?

[Xenon]

kann man einbaun, sollte nicht das problem sein :)

yes, i think i can do it without too much work :)

[Dean C]

ahhh its in german... ! the showarchiv.php is in german... is the whole hack in german d00d ...? :D

thank in advance

[Xenon]

hmm, most of the hack should be in english. but i have created it in german, so it seems i have forgotten some lines to translate :)

[Dean C]

its in the templates somewhere (i presum - unless u have the templates written into the php files)...

[Xenon]

I'll have a look on it, but i thought Frank-kun wanted to post full english templates..

[Xenon]

ok mates, now i have uploaded a new version 1.20

changes:
file showarchiv.php
template archiv_showthreads

there is now a little searchengine include which searches throug archivtitles, and the archiv list has now a pagenav :)

enjoy

[Harley-1]

Du kannst aber nicht zuf?llig hexen oder? :)
Vielen dank, ist ja Traumhaft so wie der jetzt geworden ist.

[Xenon]

hmm, glaub nicht, dass ich hexen kann *ggg*
freu mich aber wenn jemand meine geheimen künste verwenden kann ^^

[Tarion]

hallo Xenon super Hack, nur eines, bei den Benutzertiteln ist mir aufgefallen, das htmlspecialchars gesetzt wurde, was aber zu problemen führt wenn in den Titeln HTML Code verwendet wird.

Desweiteren, eine frage, ich habe festgestellt, das Attachment Links nicht angezeigt werden in den Archiven, kann man das nachträglich wieder implementieren???

Danke für deine Hilfe

[Ordovicium]

Originally posted by Xenon

there is now a little searchengine include which searches throug archivtitles, and the archiv list has now a pagenav :)

enjoy

You are my favorite hacker :)
thanx alot.

[inetd]

Xenon, don't show forum jump in archives. don't show some buttons in postbit, don't show icq buttons (i make need changes to show this buttons).
Please help me :)

[Xenon]

@Tarian: k, werd mir das mit den htmlspecials mal ansehn
Hmm, da soweit ich weis die attachments beim threadl?schen auch gel?scht werden, nehm ich an dass man sie auch nicht mehr nachtr?glich einbaun kann....

@Ord: thanks a lot

@inetd: *gg* it's no problem at your board.
i'll try to include the forumjump in the next version.

it's already in the templates, because i'm a bit lazy in template writing and just copied a code from showthread and changed it to show what it should, but i'll optimate it :)

for icq, there must be a query about the icq codes and the other buttons, perhaps i'll change it :)

[Xenon]

hmm, if you need it really, try to copy this code from functions.php

if ($post[icq]!="") {
eval("\$post[icqicon] = \"".gettemplate("icq")."\";");
} else {
$post[icq]="";
}
after this lines in showarchiv.php:

$userinfo=$post;

[Tarion]

danke für die Antwort, da muß ich dir recht geben, beim Lösachen werden Attachments auch gelöscht, was ja auch sinnvoll ist zwegs Datenbank kapazität, nochmals Danke.

[Link14716]

I installed it, and when I try to convert a forum to an archive, I get this error:

Fatal error: Call to undefined function: gzdeflate() in /home/sites/site68/web/forums/admin/archiv.php on line 122

Any ideas on how to fix this?

[Xenon]

The gzip functions must be installed on your server (i think the module for apache calls zlib..).
if this isn't installed, you can't use the hack

[Foxtroter]

Just thought some of you might want them in english.

@Xenon if you have a prob with me posting them just let me know and I'll remove.

enjoy

also for your admin panel (/admin/index.php)

replace:

makenavoption("Make Archiv(es)","archiv.php?action=chooser","<br>");
makenavoption("Revert Archiv","archiv.php?action=revert");


with:

makenavoption("Make Archive(s)","archiv.php?action=chooser","<br>");
makenavoption("Revert Archive","archiv.php?action=revert");


and for online.php

replace:

case 'showarchiv':
$userinfo[where] = "Viewing <a href='showarchiv.php?s=$session[sessionhash]'>Archiv</a>";
break;


with

case 'showarchiv':
$userinfo[where] = "Viewing <a href='showarchiv.php?s=$session[sessionhash]'>Archive</a>";
break;

[Xenon]

thanx mate :)

[Foxtroter]

Sure man np

[proxyMX]

Xenon, i have always wondered why this wasnt a pred made function with vbulletin, maybe now youve made it, they will ad it to Vb3. It is standard in many forums, and just wat ive been looking for, *huggles* thanks

[proxyMX]

i was wanting to create a specific archive forum and then move all older posts {like 6 months old+} to this forum automatically, like a prune feature that moves old threads into the archives forum, how would i go about this? I dont want to have to do ti manually

if you are thinking about this feature add it to your wishlist

Plus>> Id also like to see.

Archive Highlighting
Perhaps a small area on the mainpage that highlights a "golden oldie" post by random from the archives :)

[Xenon]

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 :)

[proxyMX]

Yeah, ive thought it through, and ill enslave some mods to do the dirty work :P

[Xenon]

that's why they are mods ;)

[Harley-1]

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.

[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?

[fastforward]

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.

[cobradude]

Thanks fastforward. What do you figure it was prior to compression?

[fastforward]

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.

[Xenon]

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

[cobradude]

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/archiv.php?action=chooser


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

[Xenon]

I've released a new Version today: 2.00

It reduces the query ammount, is more customizable because it has more templates now, corrects a small bug and: Has a small build in searchengine.

For upgrades: run admin/install_archiv.php and klick on upgrade ;)

a Note: The Searchengine just works with Archives converted by v2.00.
I'm thinking of a reindex Search Index function, but it's not finished(not started ;)) yet.

I think i'll work on this hack more again as i've done in the past ;)

[Harley-1]

Hallo,

hab mal da update gemacht, nun werden keine Beiträge im Archiv mehr angezeigt. Ich bin so verfahren wie es im ersten Posting steht. Fehler gibts keine nur werden eben die Threads nicht angezeigt.

Nebenbei hatte ich ja gefragt ob es möglich sei alle Archive wieder mal komplett zurück zu konvertieren, da meintest Du ich sollte eine schleife einbauen. Nun bin ich ned gerade so der wissende in sachen phpcoding, kannst mir da mal einen Tip geben?

[Xenon]

grr, hab vergessen was dazuzusagen ^^

For all: If you have upgrade to the newest version you have to revert your templates, because another code is used in the original ones.

Harley-1: das sollte dann wohl auch dein problem sein, einfach alle templates reverten und es sollte wieder gehn

zur schleife:
admin/archiv.php
findeif ($action=="dorevert") {

archivtothread($useid, $useforumid, $archivkill);
echo "<p>Archiv reverted!</p>";


cpredirect("archiv.php?s=$session[sessionhash]&action=revert",1);


}

ersetze es mit:
if ($action=="dorevert") {

$archives=$DB_site->query("SELECT archivid FROM archiv");
while($archiv=$DB_site->fetch_array($archives)) {
archivtothread($archiv[archivid], $useforumid, $archivkill);
echo "<p>Archiv $archiv[archivid] reverted!</p>";
}


cpredirect("archiv.php?s=$session[sessionhash]&action=revert",1);


}

das sollte alle archive zur?ckumwandeln

wie schon gesagt ich schreibe so ein script noch ausf?hrlicher, aber die suchmaschine ging beim letzten upgrade vor..

[Harley-1]

Hi,

habe das nun mal eingebaut wie du es oben beschrieben hast, aber er verlangt immer ein ID die ich eingeben soll.
Wenn ich dann irgendeine ID eingebe, dann macht der tausende threads mit dem gleichen Topic und selbigem Inhalt. Also egal wie ich es versuche, ich bekomme das Archiv nicht wieder zurück konvertiert. hast du noch eine andere Idee?

[Xenon]

sorry, hatte nen kleinen fehler drine
probiers jetzt nochmal, du musst zwar wieder ne id eingeben, aber es ist wurscht welche, er sollte nun alle machen

[Harley-1]

Jo etz macht ers, aber nun bekomme ich wieder neue probs beim reverten.
Invalid SQL: INSERT INTO post (postid,threadid,username,userid,dateline,pagetext ,allowsmilie,visible) VALUES (NULL,'8658','Jaguar','1','989245500
4','Hi

HIER DER GANZE TEXT

[ 07. Mai 2001: Beitrag editiert von: Jaguar ]','1','1')
mysql error: You have an error in your SQL syntax near 'Mülleimer' oder 'Nörgelecke', 'geschlossene Anstalt' oder wie man das sinnigerwe' at line 1

mysql error number: 1064

All zu viel hat sich eigentlich nimmer am board verändert, kann es sein, daß er sonderzeichen oder sowas ned richtig umsetzt?

[Xenon]

hmm, versuch mal in der archiv.php

das $archiv[firstpost] durch addslashes($archiv[firstpost]) zu ersetzten in der queryline

[Harley-1]

Immer noch das selbe:
Er konvertiert ein paar Threads und dann kommt immer dieser fehler. Wenn ich die threads lösche geht er weiter, aber ich kann ja schlecht von 5000 threads immer einige löschen da dies ja ned wenige sein werden.

Invalid SQL: INSERT INTO post (postid,threadid,username,userid,dateline,pagetext ,allowsmilie,visible) VALUES (NULL,'8670','Jaguar','1','989245500
4','Hi,

TEXT VOM POST

[ 07. Mai 2001: Beitrag editiert von: Jaguar ]','1','1')
mysql error: You have an error in your SQL syntax near 'Mülleimer' oder 'Nörgelecke', 'geschlossene Anstalt' oder wie man das sinnigerwe' at line 1

mysql error number: 1064

[Xenon]

hmm, versteh ich nicht, vorallem weil mülleimer oder so garnicht vorkommt im query.....

[Harley-1]

Tja das weis ich natürlich auch ned warum der das ned machen will. Es ist auch bei einigen anderen Threads so, daß er mit dieser Meldung stopt. Andere macht der ohne probleme.

[Xenon]

hmm, also bei mir gabs mit sonderzeichen tests keine probleme, aber z.Zt. hab ich auch nicht genug zeit f?r umfassende arbeiten an Hacks, die Semesterferien sind vorbei :(:(

Mal sehn, wenn ich mal etwas mehr Zeit hab werde ich mal die Fkt auf Herz und nieren testen, vielleicht kann ich den Fehler irgendwie reproduzieren und dann beheben

[spaceb]

hmm i wanted to know if i archiv messages from private forums all the users can see the messages, or only the people that have access to thoose private forums?

[Xenon]

spaceb: all messages from privat forums will be viewable for all users.

I'm already thinking of a permission system for the next greater upgrade of the hack, but i don't have an idea how to do it exactly now...

[Xenon]

Ok, i've uploade version 3.00 RC

normally everything should work, but who knows ;)

now included is an permission system

enjoy

you have to enable all permissions before anyone can see the archives.

also run the upgradescript or you'll get problems

[Harley-1]

So noch ein kleiner wunsch *g*

Wenn man Themen im archiv hat und im Forum dann mal die Counter updated dann sind alle Postings die im archiv sind bei den userposts weg. Also fehlem dem user dann Beiträge in der Anzeige der Postings. Kann man das noch einbauen, daß er die Beiträge der user im archiv mitzählt?

[Xenon]

Sorry, das geht nicht, dazu müsste die Struktur des archivs stark geändert werden....

[DrkFusion]

Hey Xenon is this the modified one, and does it work like the SearchEngs script?

-nOX

[Harley-1]

Nagut wenn das ned geht dann kann mans ned ändern. Ich werde dann mal versuchen die Postings wieder zu reverten, vielleicht schaffe ich es ja irgendwie das dieser dumme sql fehler nimmer auftaucht.

[Xenon]

Arunan: It's the newest version with the integrtion of a personal searchengine.
i've copied some parts out of the searchenginescript they use for posts and modified em...
i think it works good, it also shows the pages of an archive where the text has been found

[Harley-1]

Sag mal würde es Dir eventuell helfen wenn ich dir mal die archiv.sql zukommen lasse, damit du das so siehst wie ich?. Ich habe jetzt hin und her verscuht, aber es sind zwischendurch einfach zuviele threads die nimmer zurück revertet werden können.

[Xenon]

yo, w?re ne idee, kommt drauf an wie gro? the is ;)

aber wie gesagt zweit ist knapp derzeit also erwarte nichts zu schnelles ;)

[Harley-1]

Ne Du ich kann das schon verstehen und will Dich ja auch ned drängen. Ok dann packe ich einfach mal die ersten 50 im archiv zusammen, da dazwischen schon genug ned geht. Wie soll ichs Dir schicken?

[Xenon]

wie gro? isses?
wenns klein genug ist hier ?ber pm, ansonsten per mail ;)

[geniuscrew]

Will this archive Sticky threads, because I wouldn't like it to...

[Xenon]

yes it'll also archive sticky threads...
easiest way: move em to another forum, than convert the threads to archives and then move the stickies back ;)

[geniuscrew]

Where's 3.00? The one I downloaded says "Hack Version: 2.00".

Also do we need to archive a thread before the forum is shown?

Danke schon

[Xenon]

it is version 3.00 i just forgot to change the version number of the installfile too ;)

and yes, you need to convert a thread before the forum the thread was in will be shown on the archiv pages :)

[geniuscrew]

lol Thanks!

I'll play around with it =)

[L-Mane]

The install_archiv.php isn't working at all when I install it. Just gives me a blank page.

[Xenon]

sure you've uploaded it correct into the right directory?

it belongs into the admin folder.

because of you're the only one with ths error, you must have made something wrong, the file is ok.

[geniuscrew]

Hi Xenon

I'm getting this error when i try to convert a thread

Invalid SQL: SELECT forumid FROM archive_forums WHERE title='Introductions'
mysql error: Table '********_forum.archive_forums' doesn't exist

Please help me!

Thanks

[Xenon]

have you run the installscript correctly while upgrading?

[geniuscrew]

While upgrading?

I'm installing it for the first time - I think I might have gone wrong somewhere.

[Xenon]

oh, have had a look at it and you're right.

that's why it's 3.00 RC, there was a bug in install_script.

ulpoaded a new one...

geniuscrew: run the old install_script again and choose upgrade from version 2.00 that should solve the problems

[geniuscrew]

OMG! Das Klappt wunderbar!

Danke!

[Xenon]

:)

glad to hear that :)

[geniuscrew]

Just a teeny weeny problem :)

I archived one thread to test it - that worked fine. It showed the forum it was in and the thread.

But then I mass-archived threads which hadn't been replied to for over 50 days.

They all went to the same forum as the thread archived first - so do you have to archive forums separately?

And a little request :) - I'd like to know when each thread was archived if it that's possible

Thanks for your help Xenon!

[Xenon]

hmm, normally if those threads were in different forums, then they should also appear in different forums in your archive.

i've just rechecked the code and it is correct....

If the threads were in different forums, the names of these forums must be unique, the hack groups archives by forumnames.


but i'll redo a greater test run today evening, perhaps i'll find a bug ;)

[Xenon]

geniuscrew you help me very good with finding bugs ;)

the archives are created correctly i their specific forums, but, the showarchiv.php was a bit buggy.

upload the new one then it should work :)

[geniuscrew]

No problem Xenon!

Anyhow I prefer to archive the forums separately, just so I don't archive the Admin forum too ;)

Unless you can change it so we can manually pick what forums to archive and what to exclude [perhaps check boxes?] - just a suggestion :)

Thanks for your help m8!

[Xenon]

well would take a while to code...

but as long as you can archive forums seperatly by the choose it musn't be too fast ;)

but, you can also convert your adminforums, that's why i included a permission system ;)

[geniuscrew]

Es ist ein bisschen verwirrend :p

What exactly are the permissions for/how do u use them? I think I misinterpreted their use lol

I feel dumb ;)

[Xenon]

the permissions are there, so you can disallow users to view special archiv forums.

so you can easily convert adminforums, too, if you have set up the right permissions to just be viewable to admins ;)

[geniuscrew]

Ahh i thought so

Thanks a lot Xenon for your help - and a wonderful hack!

[Xenon]

Thanks :)

You're welcome

[MonSta]

Okay, this may seem like a dumb question, but I'm installing a hack for the first time...

What does step 4 mean?? (Make a link to showarchiv.php where you want to have it)

I just don't want to mess up my board totally...any help is appreciated!

[Xenon]

you have to edit a template and add a link to showarchiv somewhere.

i had put it into the header template, but it's up to you where in the templates you put a link

[MonSta]

Oh, okay... is this for the public to see the "show archiv" feature or for me?

[Xenon]

well, if you want the public to view the archives then you should add this link to show it to them ;)

[Alpine_Z]

Good hack!
Thank

[M.C.]

hi.
great hack, but i have one problem - when i give permissions for more than 1 gruop, all category dissapeared from the main archiv page, and only "All Archivs" left (with "0" topics).
If you have fix for that in this topic, please give me link

thanx and sorry for my english

Good Luck

[Xenon]

Once you've set up at least one permission, you have to set up the permissions for all groups in this forum, so recheck if you have enabled acces for administratorgroup also ;)

[M.C.]

Ok... when i UNcheck all boxes in permission i CAN see all categories BUT can`t go in... then when i CHECK all boxes i can see ONLY "All Archives" category... all other dissapeared BUT i CAN go in... :surprised: and why you made that options if it works like "if for one - so HAVE TO for all"??? I want show archiv ONLY for regesterd users (users, mods, admins, etc.), NOT for UNregestered & Awaiting Email Confirmation or Users Awaiting Moderation...

thanx

[M.C.]

and also, how can i add link for archive in $forumjump under:
...Search
Main
>>> Archiv <<<

???

thanx

[Xenon]

you have to edit your forumjump-template
and after that you have to edit forumdisplay.php the first part of the file where the forumjump redirects are..

the permissionsystem, was just an addon to the original hack, to allow Admins to also Archive private forums and don't let the wrong users inside. that's why it uses that behaviour.

but normally it should work, as i've tested it.
Nevertheless it's a RC, so i'll look into the code again :)

[M.C.]

okay, thanx a lot! i test it on local host before publish in the Net...

[AZone]

Good hack! But one minus - it is impossible to remove forum from archive after removing all threads in it... I have to use phpMyAdmin for it.
Or it is my mistake?

[Xenon]

Thx, seems i've forgotten this :)

Upload the new Archiv.php and showarchiv.php and this shouldn't happen anymore

[mistyl]

Quick question do I create a forum and move the threads there first then covert them into the archived threads?

How to I convert them into archived posts?

[Xenon]

no, you don't have to create a new forum and move threads there first, you can just archive them frome wherever they are (use the mask or the direkt threadid)

[mistyl]

Okay I have it up. It is there and running. When I go to move a thread over to the archive (testing it out lol) there isn't an option to move the thread over there.

I am a newbie to VB can't you tell :P

[Xenon]

when?
well you should move it when it's closed and never needed anymore :)

the option is within your AdminCP when you have installed everything right.

[mistyl]

It is there yah!!! But I am getting a page cannot be displayed when I click on the links?

I am amazed I got it there only being doing php for a week hehehe!

[mistyl]

Now I am getting a Page Not Found. I think I am missing something hmmm...

[NuclioN]

Installed and seams to work but i can't edit the permissions. Their names are showing up but there ar no radiobuttons etc.

[Xenon]

@mistyl: have you uploaded the files correctly?

@NuclioN: hmm, i think it's the same bug, as in my faster change of forumpermissions hack.
Your php-version is too old i think, ask your host to upgrade to the newest one this should solve the problem

[NuclioN]

PHP/4.1.2 Xenon. Maybe we must upgrade. Tnx.

[Xenon]

yes, it seems to happen with all php 4.1.x versions...
i knew it from my other hack...

you can use the archiv also, just the permission system does not work with php 4.1

[NuclioN]

Hm..it seems the host/provider has a balanced package that he will not upgrade for now. :(

Is there a workaround to let the permissions work?

[Xenon]

no, sorry haven't had time to write one

[NuclioN]

That's to bad. It looks if moderators can archieve postings and they show up in the showarchiv.php, but the admin can't see this submission nor can alter it. I don't know if there are members who can see and archieve but it would be great if this could be controled somewhere.

[mistyl]

It is working now! I coverted my first thread! But when I click on the link that say Show All Archives it doesn't show the threads contain in there.

http://www.divamoms.com/forums/showarchiv.php

[mistyl]

Also is there anyway to get the Archive on the forum home?

[Xenon]

@mistyl: whenever you provide an url to your board to show something be sure it's opened to guest, or give a test account or we can't help :)

question2: just add a link tho showarchiv.php on the forumhome template.

@Nuclion: hmm, you must have made an mistake, normally just admiins can create archives, that's why archiv.php is in admin-cp...

[AWS]

Excellent hack. Just what I was looking for.

Clicks install.

One question where is this located in the Archive templates?

Extreme .NET Forums > Archiv > All Archives

I want to change Archiv to Archive.

[AWS]

Uninstalled it for now. I archive a forum and all is ok. The per-page links are ok. As soon as I archive a second forum and head into that archive the first page shows the correct per-page links for that archive, but, if you click on the link to page 2 it takes you to page 2 of the whole archive. It doesn't seem to build multi-page links per forum archive but instead makes them for the whole archive and sets them in each. To see what I mean go to:

http://visualbasicforum.com/showarchiv.php

click on ADO.net archive. Then click at bottom of page click one of the per-page links. It will show posts from ASP.net the other forum I archived. If you want to view the rest of the ADO.net archived threads you have to click through all the links until you get back to them.

This is still a great hack and does just what I want, but, I can't use it as it is now. Once I archive all my forums it would be insane for a user to be able to navigate each archived forum since the perpage links seem to link randomly by date rather than by forum.

I fixed this.

This line:

$pagenav=getpagenav($totalarchives,"showarchiv.php?s=$session[sessionhash]&action=showarchives&forum=".htmlspecialchars($forum));

should be:

$pagenav=getpagenav($totalarchives,"showarchiv.php?s=$session[sessionhash]&action=showarchives&forumid=".htmlspecialchars($forumid));

Now to start archiving all my old threads and removing forums that I have closed after I archive them.

One more question. Could you add the feature to archive a forum by using the forum ID?
I want to archive all threads in a few of my forums and doing by date doesn't get all the posts. I would like to be able to just put a forum id in and have it do it that way then I know I get everything. This will also archive orphaned threads left behind that are tied to an ID of a removed forum.

[Xenon]

@AWS: Thanks, that bug comes with version3, i've forgotten to change the pagenavlink here thanks :)

also it should be that: $pagenav = getpagenav($totalarchives,"showarchiv.php?s=$session[sessionhash]&action=showarchives&forumid=".intval($forumid));

* Xenon updates file :)


One question where is this located in the Archive templates?

Extreme .NET Forums > Archiv > All Archives
you have to edit showarchiv.php the function makearchivnav($archivid=0, $forumid=-1, $title="") :)

One more question. Could you add the feature to archive a forum by using the forum ID?
it's already there, there is a forumchooser code when converting threads, no need for an id here :)

[AWS]

it's already there, there is a forumchooser code when converting threads, no need for an id here
I see that. The ability to put in a forum id would be good also.
If you remove a large forum like I did, 50,000+ posts, more than likely vbulletins script will time out and all posts won't be removed. They are still in the db tied to an id, but, since the forum is no longer there it won't show in the dropdown box.
If we are able to input an id to the missing forum we could archive those old posts and remove then from the db.
This would be very helpful to not only archive these posts, but also remove them altogether.

[Xenon]

hmm, i can give you the code :)

open archiv.php and replace this:
makeforumchoosercode("and forum is<br><smallfont>Subforums are not included!</smallfont>","useforumid",-1,"Any");

with this: makeinputcode("and forumid is<br><smallfont>Subforums are not included!</smallfont>","useforumid","-1");

this should work..

[AWS]

Originally posted by Xenon
hmm, i can give you the code :)

open archiv.php and replace this:
makeforumchoosercode("and forum is<br><smallfont>Subforums are not included!</smallfont>","useforumid",-1,"Any");

with this: makeinputcode("and forumid is<br><smallfont>Subforums are not included!</smallfont>","useforumid","-1");

this should work..
Works great. I'm archiving the orphaned threads that vbulletin didn't remove when I removed the forums. Great work.

[Xenon]

np

you're welcome :)

[alexi]

I am able to archive one or two threads then I recieve this error:

Database error in vBulletin Control Panel 2.2.9:

Invalid SQL: INSERT INTO archive (archivid,ersteller,title,forumid,firstpost,lastpo st,posts,topposter,description,archivtext) VALUES (13,'buzznwoody','Discount for 2nd day?',8,'984525232','984526514','3','Striske (1)','','
-np-

---Newsite---
uU?n?0??+6A?$@,Dz?:?
zh
(?A?@?+??D
$eE??????n{?c[??ٙY:??v??_?l?ͳ$?߮n??/,Bi?.?h?*c=x?ZP?t???ЇJ/6????o?D ?hT=L&? dW{???W??5???Jl4n???;o??r?.?*帙?Rye?Cnq??<?zƈq??]ú??pр6\\G??J??%?*? q ?=Ƃ??I

~7@?ټi?H1Lg?
?O?a?P??\\IH?_??h?X]!?׵?Y??Lh
~N?z\0?\\n:?YU?m_ʑg?? #cˏ????E?Jf?l?>I??
ȸ?f?uK?t`*H???x?ilB?Y??V?Z?kz??ܞ?*`0?A?+?t??\0&?d0s?ۥi????>?C\"????gB?PI}U?a?ym?r?ehk?c????2????8B?@r;V5Q=h???0?&?df?E??2V?(@e?g??1?????Oԕ@X?_Dt???*+??| \'ޮe????׫?&ɶq?w?`\'?9?c0?_Uú,????y?/
ϵ;?T????(???!\'?E??F?#??uTq3s3zBiv?????H????
?Ok\'|gc?$?lx??J??n]?*
??&?E]?
i?q?Y???c??\0fF???λ??D(?w?֘&?=?!?])
ZFZ?@
E^??t\\??7???W?%{?u<???l??U????? Q)P#?n??ݰ???6?]?p?1??u?D!%?l9?p??m?q???|?н?K%caF???t??}| ?? ,5gAR6ӛ?????n]??????-??a]??gI????G?}?a:??~?.o,]??fړ?4?e??J????x???
')
mysql error: Duplicate entry '13' for key 1

mysql error number: 1062

Date: Thursday 09th of January 2003 03:07:14 AM
Script: http://www.disboards.com/admin/archiv.php
Referer: http://disboards.com/admin/archiv.php?action=chooser&s=

Any clues?

[Xenon]

hmm, seems like a problem with your DB.

which MySSQL version is running?
the problem is, id 13 is tried to be inserted twice, which is impossible, because the code has this:
$tmp=$DB_site->query_first("SELECT MAX(archivid) as maxid FROM archive");
$archivid=$tmp[maxid]+1;
which makes shure, that the inserting id does not exist before inserting..

try to delete the table archiv, and recreate it, maybe it could help

[NuclioN]

It seems to work now. :) How can i let moderators archive threads into it, by putting a link in the page nav?

[Xenon]

hmm, it's not tested, but if you copy archiv.php from your admin directory into the mod dir and add the links to the pagenav it should work.....

[L-Mane]

What will happen when VB3 is released? Will this hack cause problems or anything?

[Dean C]

I would have thought it won't be compatible but vb3 already has it's own archive system :p

- miSt

[Xenon]

@Mist: you can't compare, vb3's archivesystem is just for Searchengines, it doesn't Compress anything as far as i know.

@L-Mane: Nobody could tell, because i havn't tested vb3 yet....
But it's an Addon, so it should work withouth problems, at least the old Archives should stay ok.
The action to convert new Threads into archives could perhaps make problems, i don't know how the db structure has changed.
I will surely make it vb3 compatible when i have enough time for it..

[Dean C]

Oh i see - well it still looks nice :p

[NuclioN]

Great addition. The only thing that's strange is the connection time out message when i make an archive of a thread with a certain amount of pages.

[Xenon]

hmm, i think this is a specific issue...
perhaps your timelimit is set to low....

have you tried to copy this thread into another forum?
i'd bet it would also bring up an error then....

[mistyl]

Got it figured out! Thank you!

[Xenon]

:)
* Xenon enjoys to hear that

[alexi]

I have this working finally...
The only problem I have now is speed, it takes several minutes to archive each thread even when the board load is low.. it will take weeks to archive everything I need too!

[alexi]

Ok I got that one figured out! I increased the script time out in php.ini and optimized the database, it's flying now!
This is awesome xenon

[Xenon]

:)
good to hear everything works at your board :)

[alexi]

A tip for anyone using xenon's great hack. Several times now while trying to archive a large board I started to recieve errors. The control panel would just go to a "page could not be displayed error. Each time I did a repair and optimize on the database and it worked much better after.

[scotty]

just one quick question:
- when i use the hack to archive threads - will the posts (that will be archived) be deleted from the searchindex?

i have the problem, that my searchindex is too big, and causes errors sometimes, because it's a high traffic board...

[Xenon]

if you delete the original threads after archiving (it's an option while archiving ;)) then it will delete them from the searchindex.

hint:
also, if you get problems with the searchengine more often, increase the minimum word length and reindex it, that can help you :)

[scotty]

wow - thanks for the quick answer! https://vborg.vbsupport.ru/external/2003/02/4.gif

Originally posted by Xenon
[B]if you delete the original threads after archiving (it's an option while archiving ;)) then it will delete them from the searchindex.
:) that's good!

hint:
also, if you get problems with the searchengine more often, increase the minimum word length and reindex it, that can help you :)
i've done this two times - but 12,4M rows are still too much...

[Xenon]

you're welcome :)

well the searchindex is always one of the greatest tables, from your site i think you're german are you?
have you downloaded the german badwords.php from vbulletin-germany.com
it will also reduce the searchindex after reindexing

[scotty]

Originally posted by Xenon
have you downloaded the german badwords.php from vbulletin-germany.com
yes - the german badwords.php is in place...

...aber selbst das n?tz nicht viel.

danke dennoch!

greets,
scotty

[yxboom]

I have installed the hack but have a question. Is there a way I can create a Forum category just for the archived threads and have them show up there on the Main index page?

[Xenon]

hmm, you can set up a new category as a link, but not dynamical as you want it.

[yxboom]

Could you explain please. The forum category is locked so there would be no additional posting. I just want them to show up on the Main Index page. Is that not possible?

[yxboom]

To clarify, if my only option is to setup a category as a link. How would I do that? Thanks.

[Xenon]

create a new category and as title use:
</a><a href="showarchive.php">The Archive

[yxboom]

ok thanks...but if I can bug you some more. When I set the permissions for all to see it only has a "All Archives" and the threads Archived is at 0. But when I uncheck all the permissions it shows the forums for the archived threads and the number is accurate in the threads archived but then you get permission denied when you try to read it.

[alexi]

running into a rather strange problem. It seems to be switching usernames! Not all the time but a lot of threads have the wrong users on some of the posts.

[Xenon]

hmm, never had that before...

[alexi]

any ideas what might be causing it?

[Xenon]

nope sorry, no idea...

[M.C.]

is it work on 2.3.0?

[Xenon]

i haven't tested it, but as it uses it's own files and the tables thread/posts were not changed it should :)

[M.C.]

xm... but it`s look like u not fix that thing with permissions yet... :(

[Xenon]

no i didn't get time to work on this hack anymore...

i hope i can fix the problem itself while porting the hack over to vb3

[M.C.]

will u porting it on vb3?!

[Xenon]

i will, that's 99% sure, but i don't know when i'll find the time.
i think it wouldn't be that easy because of the renamed functionnames aso..

i think i have to recode it nearly from zero

[Mike Bucy]

I have installed your Archive hack.
I'm using 2.2.7 VB & PHP 4.3.4 with Apache
Here is the error:
Parse error: parse error, unexpected '=' in C:\Network\Apache2\htdocs\forum\showarchiv.php on line 260

What did I do wrong??

[Xenon]

it seems the zip file contained one buggy file.

download it again and replace the showarchive.php with the one including in the zip now :)

[Mike Bucy]

Works Great!!! Thanks

[Okiewan]

Wish this wasn't dead :(
Works fine except marks all author's join date at 1969 ... and leaves the autor name and title out. :(

[Frozen Dreams]

Somehow I cant delete archives I created. So I had to do it through phpmyadmin for the test one I did. Running it on a 2.3.0. Anyone's got an idea?

SOrry if this has been answered before - if it has, anyone mind directing me to the link? thanks