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)

mistyl 01-04-2003 10:19 PM

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 01-04-2003 10:22 PM

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 01-04-2003 10:27 PM

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 01-04-2003 10:31 PM

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

NuclioN 01-04-2003 11:07 PM

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

Xenon 01-05-2003 10:08 AM

@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 01-05-2003 10:14 AM

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

Xenon 01-05-2003 11:09 AM

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 01-05-2003 11:10 AM

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 01-05-2003 11:14 AM

no, sorry haven't had time to write one

NuclioN 01-05-2003 11:18 AM

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 01-05-2003 08:25 PM

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 01-05-2003 08:36 PM

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

Xenon 01-06-2003 07:21 AM

@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 01-06-2003 08:12 PM

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 01-07-2003 03:24 AM

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:
PHP Code:

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

should be:
PHP Code:

$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 01-07-2003 04:08 PM

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

also it should be that:
PHP Code:

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

[high]* Xenon updates file :)
[/high]


Quote:

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

Quote:

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 01-07-2003 04:30 PM

Quote:

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 01-07-2003 04:38 PM

hmm, i can give you the code :)

open archiv.php and replace this:
PHP Code:

  makeforumchoosercode("and forum is<br><smallfont>Subforums are not included!</smallfont>","useforumid",-1,"Any"); 

with this:
PHP Code:

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

this should work..

AWS 01-07-2003 06:22 PM

Quote:

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

open archiv.php and replace this:
PHP Code:

  makeforumchoosercode("and forum is<br><smallfont>Subforums are not included!</smallfont>","useforumid",-1,"Any"); 

with this:
PHP Code:

  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 01-07-2003 06:27 PM

np

you're welcome :)

alexi 01-09-2003 06:17 AM

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 01-09-2003 11:24 AM

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:
PHP Code:

  $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 01-10-2003 11:05 AM

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

Xenon 01-10-2003 10:19 PM

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 01-12-2003 07:19 AM

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

Dean C 01-12-2003 11:31 AM

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

- miSt

Xenon 01-12-2003 11:56 AM

@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 01-12-2003 02:03 PM

Oh i see - well it still looks nice :p

NuclioN 01-12-2003 03:08 PM

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 01-12-2003 03:31 PM

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 01-12-2003 11:07 PM

Got it figured out! Thank you!

Xenon 01-13-2003 02:42 PM

:)
[high]* Xenon enjoys to hear that[/high]

alexi 01-19-2003 11:07 PM

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 01-20-2003 03:38 AM

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 01-20-2003 02:38 PM

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

alexi 01-23-2003 05:00 AM

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 02-09-2003 03:00 PM

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 02-09-2003 03:12 PM

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 02-09-2003 03:18 PM

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

Quote:

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!

Quote:

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...


All times are GMT. The time now is 09:15 PM.

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.01465 seconds
  • Memory Usage 1,838KB
  • 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_php_printable
  • (6)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
  • (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