The deal with the thread pruning - Page 4

crono_logical · 06-27-2002, 10:49 PM

Not sure. Deleting posts/threads using the edit/delete button will reduce post counts respectively. Dunno if the same works for pruning though, especially on such a large scale - I'd expect not as it would be more accurate that way, but I guess we'll have to wait and see.

Aexoden · 06-27-2002, 11:27 PM

First of all, I'd think vBulletin would MD5 hash (or otherwise hash) passwords, so they wouldnt' be in there except as meaningless hash codes. If they don't, they need to get a clue.

But yeah, that still leaves PMs and such. I don't know how vB organizes its tables.. but it should be possible to just backup relevant tables (posts, etc.).. But even then, it would just be a huge MySQL mess (plain text...but very ugly to read) without a program to read it...

Citizen Bleys · 06-27-2002, 11:45 PM

See, I never thought of private messages being viewable. What else have I not thought of? It's a somewhat scary thought, and it would be a sod of a lot scarier if the db was available for public download.

No, I think it's a sod of a lot safer if nobody but the admins have access to the database backup.

Scottie · 06-27-2002, 11:50 PM

Hashing the passwords was actually something only recently introduced to the VB. I think 2.x or later. I can't even remember. But yeah they're hashed now.

The Man · 06-28-2002, 02:01 AM

An idea occurred to me earlier this evening, while I was away. Is there any way to write a program that will convert every thread in General Chat into an individual .mht archive (read: an html file with all the associated images embedded within)? If we could do that, then we could at least leave General Chat up, even if it would lose its searchability. Of course, that could be highly impractical as well, but if we could .mht-ize all the threads in GC and then post them as individual attachments in some new thread, that would severely decrease the number of entries in EoFF's databased.

On another note, I'm apparently not the only one to be affected by post counts drops, as Cute&Dangerous told me in chat that she noticed she lost some posts today (I myself recall her profile saying she had over 1,000 posts, and today that had dropped to 975), crono_logical had gained all of three posts between some point earlier today and 11:15 PM Eastern Time on June 22nd (which is unthinkable for him, especially since I've seen him post far more than three times between those dates), and Dee lost posts during that same time period. Musashius also apparently gained only five posts during that time, which seems unlikely to me as well. Oh, and then Bleys somehow managed to gain something like 22,500 posts during that time, but that's another story. O_o

The post count thingy didn't seem to affect everyone, and I myself only carefully checked the twelve highest posters. It seems very strange, however. It's not just the value in my profile that's off either; the search results decreased by a comparable out. Can anyone explain what's going on? I didn't think the pruning was supposed to have started yet, and I'm feeling very confuzzled. Meep.

Peace
The Man

crono_logical · 06-28-2002, 12:20 PM

When the board gets disabled, the whole thing gets disabled for everyone except admins, you can't just disable particular forums, unless you're willing to go around doing each one individually.

Why do you want all threads in Gen Chat to be archived like so anyway? If they're really that good, I guess they should be moved to the Archive - PM someone capable of moving them those threads and we'll see if it's really worth it

I believe attachments are stored as entries in the database too as well anyway

MHT archives would be biggger than the original threads stored anyway, since they'd also contain images and such within them, many of which may be repeated when you have several archives.

OOC:	As for post counts, maybe I really did only post a few times since then - I've been playing FFX a heck of a lot so hardly been posting much recently anyway

Citizen Bleys · 06-28-2002, 03:09 PM

1) attachments are stored in the database. Even if I knew how to save the whole forum as .mht files (and I don't), it would probably increase the size of the db to do it that way

2) Post counts: I have no idea what's wrong with them, and frankly, there is a reason why they don't show up in people's profiles anymore. We had a lot of senseless, post-count-raising garbage back when we had them shown. If anything, I'm tempted to make them not shown in profiles, as well.

Squally Leonharty · 06-28-2002, 04:44 PM

Originally posted by Citizen Bleys
1) attachments are stored in the database. Even if I knew how to save the whole forum as .mht files (and I don't), it would probably increase the size of the db to do it that way

MHT files aren't part of vBulletin.

They're part of IE. File -> Save As -> Select MHT -> Save.

crono_logical Administrator Hypnotising you Location: Back in Time	#25 Not sure. Deleting posts/threads using the edit/delete button will reduce post counts respectively. Dunno if the same works for pruning though, especially on such a large scale - I'd expect not as it would be more accurate that way, but I guess we'll have to wait and see.
06-27-2002, 10:49 PM

Citizen Bleys Ukrainophile Location: Chateau d'Oraguille	#27 (permalink) See, I never thought of private messages being viewable. What else have I not thought of? It's a somewhat scary thought, and it would be a sod of a lot scarier if the db was available for public download. No, I think it's a sod of a lot safer if nobody but the admins have access to the database backup.
06-27-2002, 11:45 PM

Scottie Former Staff 4/20 Location: Jersey	#28 (permalink) Hashing the passwords was actually something only recently introduced to the VB. I think 2.x or later. I can't even remember. But yeah they're hashed now.
06-27-2002, 11:50 PM

Squally Leonharty Recognized Member Your worst wet nightmare Location: Maastricht, the Netherlands	#32 (permalink) Originally posted by Citizen Bleys *1) attachments are stored in the database. Even if I knew how to save the whole forum as .mht files (and I don't), it would probably increase* the size of the db to do it that way** MHT files aren't part of vBulletin. They're part of IE. File -> Save As -> Select MHT -> Save.
06-28-2002, 04:44 PM