vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 2.x Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=4)
-   -   Archiv for vBulletin (https://vborg.vbsupport.ru/showthread.php?t=39104)

Xenon 05-26-2002 10:00 PM

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

Xenon 05-27-2002 06:35 PM

screen1

Screenshot from updated version

Xenon 05-27-2002 06:35 PM

nr2

Xenon 05-27-2002 06:35 PM

3

Xenon 05-27-2002 06:36 PM

last screenie

Henry-RS 05-27-2002 06:46 PM

This looks like a great hack! :)

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

inetd 05-27-2002 07:51 PM

Good hack!
I will install later.

Ordovicium 05-27-2002 08:29 PM

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 05-27-2002 08:37 PM

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 05-27-2002 09:08 PM

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 05-28-2002 04:01 AM

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

Xenon 05-28-2002 10:16 AM

Quote:

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 05-28-2002 11:31 AM

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 05-28-2002 04:38 PM

Quote:

Originally posted by Xenon

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

Integration into the search Engine.

Xenon 05-28-2002 04:42 PM

genau, lass mich nur leiden ^^

will see what i can do :)

Nam 05-28-2002 11:10 PM

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 05-29-2002 12:00 PM

no, it isn't.

Xenon 05-29-2002 08:04 PM

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 05-29-2002 09:51 PM

ok. No Problem.

Frank-kun 05-30-2002 12:14 AM

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 05-30-2002 11:15 AM

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 05-30-2002 11:59 AM

ok, uploaded a bugfixed version

thanks for pointing your finger on it ;)

Harley-1 05-30-2002 10:10 PM

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 05-30-2002 11:19 PM

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 05-30-2002 11:44 PM

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

THX

inetd 06-05-2002 05:56 PM

[high]* inetd install hack
[/high]
[high]* inetd wait new version
[/high]
:D

Xenon 06-05-2002 07:38 PM

[high]* Xenon is happy
[/high]

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

Dean C 06-06-2002 07:58 AM

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 06-06-2002 09:08 AM

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 06-06-2002 10:51 AM

kann man einbaun, sollte nicht das problem sein :)

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

Dean C 06-06-2002 10:57 AM

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

thank in advance

Xenon 06-06-2002 11:10 AM

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 06-06-2002 12:33 PM

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

Xenon 06-06-2002 12:56 PM

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

Xenon 06-06-2002 04:09 PM

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 06-06-2002 05:18 PM

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

Xenon 06-06-2002 05:22 PM

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

Tarion 06-06-2002 07:25 PM

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 06-06-2002 07:38 PM

Quote:

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 06-06-2002 07:40 PM

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


All times are GMT. The time now is 06:09 AM.

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.01382 seconds
  • Memory Usage 1,827KB
  • 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
  • (4)bbcode_php_printable
  • (3)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)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