DemonGoddess

I'm going to address this one LAST time, and then I'm locking this topic. 1. The recategorization and then the follow up cleanup task is critical for the overall health of the database. We were teetering towards a severe crash, which would've meant corruption of the data that may have been salvageable, or total loss. Up until I finished this FIRST step of this (and there is more to come), I was running repair utilities on the archive database at least FOUR times a day, every day. All in an effort to keep it somewhat stable, so it would not crash. That's something I've been doing with it for months now. The first step of this overall overhaul, has actually stablilized things enough to where now I'm only having to run those repair utilities once a day. That's an improvement. 2. The code is archaic and beyond much more repairs than have already been done to it. It limits us severely in what we can do as far as levels of subcategories. There are only THREE levels I have to work with. The program itself is in the process of being rewritten. By doing what I (and others who are helping me) are doing to actually clean things up and get things moved around and such, it makes it more organized for when that software is finished and uploaded. At that point, I'll have the ability to work with unlimited levels of subcategories. That will make it so I can do more, and add more sorts of category types as sublevels. 3. We (my group of volunteers and I) are working sequentially, subdomain by subdomain. When we get to the subdomain you're referencing, it'll be cleaned up and set up according to specific subsets we have set up, such as, for pair specific categories, they have to have 10 or more stories to have their own subcategoy. So, the small ones will end up history, and there will be some further rearranging once we GET there. The ORDER we are doing this is as follows: Books Buffy the Vampire Slayer Cartoons Celebrity Comics Harry Potter Lord of the Rings Movies Non English Originals Television X-Men Anime Anime 2 (Gundam, Beyblade, etc) Bleach Final Fantasy Games InuYasha Naruto YuGiOh YuYu Hakusho 4. The tasks involved in the overall cleanup include the following (in part): a. Repairing glitches to chapter data, from 1 major and 2 minor database crashes, occurred in 2003, 2005, 2006, after they have been found and posted. b. finding and deleting troll, flame, spam, and duplicate posts to each story's review boards. c. finding and merging duplicate stories d. finding and deleting spamfics e. finding and deleting trollfics f. finding and merging duplicate users g. finding and moving fiction that is in the wrong subdomain entirely As to the "oc links", have you tried searching the summary for your character choice x OC? That'll bring up the stories.

The emails are hidden for the users in the archive because the program is old, and doesn't protect users from spam harvesters. So, by hiding them, the registered user emails aren't accessible by these things. If you need for one of us to get the email for you, use the contact form in the top menu here, explain your request, and we'll take of it.

Het 544176705 544185507 544185995 544186422 544185177 544178337 544189582 544189896 544190141 544185844 544190318 544190650 544190665 544194996 544195330 544196509 544197749 544186812 544184168 544187212 544189767 544196983 544197881 544193937 Crossovers 544197704 Threesome/Moresome 544186240 AU 544189580 544194932 544185770 544189437

Review board review # 2035155545 Review board review#2035150614 review#2035151861 Review board review#2035581537 Review board troll review#2035501731 Review board flame review#2035271157 review#2035275178 review#2035275181

its no prob....the users'll be emailed with where to post those, and then the unfics will go away......

by story ID AU 18682 544170924 544173070 544173372 Het 35050 544174997 544173689 544176776 544177814 544180651 544181076 544181078 544818398 544176489 544181900 544182126 544178728 544183088 544172657 544184648 544184647 Slash 544177863 9462

Review board review # 2035132342

this looks like some kind of format error....all the text goes across the screen to the point where you have to scroll horizontally to see the rest of it, instead of it wrapping properly. http://books.adult-fanfiction.org/story.php...&chapter=14 http://books.adult-fanfiction.org/story.php?no=544174965 Chapters 6,7,9,12,13 http://books.adult-fanfiction.org/review.ph...mp;no=544205922 It's actually the REVIEW board this time http://books.adult-fanfiction.org/story.php?no=544201705 chapter 25

http://books.adult-fanfiction.org/story.php?no=544175349 http://books.adult-fanfiction.org/story.php?no=544174209 http://books.adult-fanfiction.org/story.php?no=544174962 http://books.adult-fanfiction.org/story.php?no=544179342 http://books.adult-fanfiction.org/story.php?no=544182299 http://books.adult-fanfiction.org/story.php?no=544174965 http://books.adult-fanfiction.org/story.php?no=544185308 http://books.adult-fanfiction.org/story.php?no=544197923 http://books.adult-fanfiction.org/story.php?no=544187633 http://books.adult-fanfiction.org/story.php?no=544191480 http://books.adult-fanfiction.org/story.php?no=544190956 http://books.adult-fanfiction.org/story.php?no=544191276 http://books.adult-fanfiction.org/story.php?no=544191548 belong in Movies/M through R/Phantom of the Opera

http://books.adult-fanfiction.org/story.php?no=35050 chapter 2, no author data http://books.adult-fanfiction.org/story.php?no=544176776 chapters 2, 3; no author data http://books.adult-fanfiction.org/story.php?no=544174965 chapters 2, 6, 7, 9, 12; no author data http://books.adult-fanfiction.org/story.php?no=544183080 chapter 1; no author data http://books.adult-fanfiction.org/story.php?no=544172657 chapters 7, 11, 18, 25; no author data http://books.adult-fanfiction.org/story.php?no=544187141 chapter 24

http://books.adult-fanfiction.org/story.php?no=18682 Chapters 2 and 3

Review board, review id#2035412157 deleted

http://books.adult-fanfiction.org/story.php?no=600005444 Belongs in Gundam Wing /AC-Threesomes/Moresomes

It looks like any chapters uploaded after mid August 2003 don't have the glitch. Could you confirm?

Moved to Hellsing>Crossovers

done

Thing is, by editing, your story is no longer bumped to the top of the list. That was fixed MONTHS ago. That sort of a review would be considered a flame. Delete it from your review board. As to the original troll review referenced in this topic, I'll get the pertinent data to the right people, and delete the review. I'll also delete the blank review.

pffft. Doesn't matter how much we disagree with each other, that has no bearing on whether or not a user is kicked. Certainly isn't a REASON to. Again, as a guest poster, there are posts you've not seen which are actually relevant and pertinent to this discussion. I have asked repeatedly for patience while we go through this very large database (in those other posts I'm referencing), and correct many many things. That's not too much to ask, now is it? Would you rather that we not bust our asses AFTER we get off work, in order to stabilize this thing? So we can have a crash like what occurred in 2003? THAT is exactly where we WERE headed. I have addressed the search engine question numerous times. So here I go again. The search engine, such as it is, was by design made for a much smaller database. It is not made to handle the load of a 6GB database, which is what we have. Due to major changes in coding languages which RUN these programs, in order to make a better search engine, it has to be rewritten. When it is rewritten (which is in progress), the query language itself has also changed tremendously from the time that this original program was written, so the queries themselves within the script need completely redone in order to work in a manner which will allow more thorough search of the database, without OVERLOADING the database. If, for example, the current search engine was given more search options, it is LIKELY that it would open up too many connections to the database itself. When that happens, the SQL server resets. When the SQL server resets, ALL the programs go down for 15 minutes to an hour. For obvious reasons, there is no tweaking we can do to the current search engine. That's exactly why it's being replaced. However, it does take time to make sure that once that module is written, that it is compatible to what is already there. Not only that, it takes time to WRITE this sub routine in the first place. Realistically, it will not be ready to launch until the beta version of the new program is. That is simply due to the fact that there are incompatibilities between the version of language this was written in years ago, and the version that we have to work with now.

moved to temp subcat, to be inserted into tables in the right subdomain.

There is a very DIM reference to the location at the end of the story. Last sentence. But, good call nonetheless, were it not for that ONE sentence, yes this one would've been moved.

fixed

Once again, you people that are complaining are missing the entire POINT here. You complain without knowing just what the hell exactly we're up against, with the database itself, and old outdated software. You complain thinking that because ff.net is the way it is, that we should then be the same way as them. With software, and everything. You don't BOTHER to read the rest of what actually is going on and being done, other things posted that are and were far worse about this elsewhere in this forum (insofar as post content), nor are you willing to factor in the time involved in the task itself. You'd rather just gripe. and gripe. and gripe some more.

http://books.adult-fanfiction.org/story.php?no=544183013 Chapters 3 and 4

As you had posted to this topic, I naturally thought you were referencing the topic title, as you'd not specified the archive. However, I will bring that to her attention so it can be fixed in the archive as well.

http://books.adult-fanfiction.org/story.php?no=600005548 to go to NE/German/Books