DemonGoddess

Belong in Movies>M through R>Phantom of the Opera http://books.adult-fanfiction.org/story.php?no=544201705

Before I ever got to the HP section for the initial first step of all this, it was noted in the Site News block. That's where anything like this would've been and was announced. When the site news was updated, I was still working in the left hand menu for this part of the cleanup. All parties involved in this cleanup, and reprogramming (which is being done OFF site) are well aware of why it is this is being done. I dunno, I think I'd rather have a program that's actually working, than one where the database had a severe crash (again), and any all story data was scrambled. You might want to have a look at the work forums, and see just what exactly we're up against, particularly when it comes to the repair end. Bearing in mind we've only just started the hardest part of all this. Maybe THEN that could inspire some patience and forbearance. All of what is now ongoing, SHOULD have been done immediately following the subdivide of the database across the different subdomains. That is wasn't, means that there is that much more of a mess to deal with now.

It's not possible to generate a broadcast email for the archive. The software does NOT support the function. If you look, the categories you mentioned weren't deleted, they were MOVED. They became subcategories of their parent type category. Should you actually bother to take the time to read the MULTIPLE posts on this topic, and what exactly is going on, you might not be so damn impatient, and as you said, selfish.

http://books.adult-fanfiction.org/story.php?no=544203963 has both the missing author data and endless horizontal scroll; chapter 1 http://books.adult-fanfiction.org/story.php?no=544181043 no author data, chapter 10 horizontal scroll, chapter 20 http://books.adult-fanfiction.org/story.php?no=544180033 no author data, chapter 9 http://books.adult-fanfiction.org/story.php?no=544184837 horizontal scroll, chapter 7 http://books.adult-fanfiction.org/story.php?no=600005491 Glitched chapter titles, chapters 19, 20 http://books.adult-fanfiction.org/story.php?no=544185142 no author data chapter 9

http://books.adult-fanfiction.org/story.php?no=544179014 no author data Chapters 1, 3 horizontal endless scroll Chapters 1, 3 http://books.adult-fanfiction.org/story.php?no=544191474 no author data, Chapter 5 http://books.adult-fanfiction.org/story.php?no=544201199 no author data, chapters 2, 5 http://books.adult-fanfiction.org/story.php?no=544175134 no author data, chapters 5, 6

Belong in Movies>M through R>Phantom of the Opera http://books.adult-fanfiction.org/story.php?no=544172641 http://books.adult-fanfiction.org/story.php?no=544182117 http://books.adult-fanfiction.org/story.php?no=544179014 http://books.adult-fanfiction.org/story.php?no=544197442 http://books.adult-fanfiction.org/story.php?no=544201697 http://books.adult-fanfiction.org/story.php?no=544203128 http://books.adult-fanfiction.org/story.php?no=544202074 http://books.adult-fanfiction.org/story.php?no=544205006 http://books.adult-fanfiction.org/story.php?no=544195989 http://books.adult-fanfiction.org/story.php?no=544181043 http://books.adult-fanfiction.org/story.php?no=544215730 http://books.adult-fanfiction.org/story.php?no=544215793 http://books.adult-fanfiction.org/story.php?no=600000183 http://books.adult-fanfiction.org/story.php?no=600000182 http://books.adult-fanfiction.org/story.php?no=544192468 http://books.adult-fanfiction.org/story.php?no=544203290 http://books.adult-fanfiction.org/story.php?no=600005480 http://books.adult-fanfiction.org/story.php?no=544215352 Belongs in Non English>German>Books http://books.adult-fanfiction.org/story.php?no=544175506

There are four of us going through this whole thing. Only ONE of us is actually doing the db fixes for what is found. We're working as fast as we can, however. It's a good thing we're all speed readers. As to time frame, that gets a little tricky, because that will depend on what is found in each and every subdomain. We're only, what, four days into it so far, and have almost completed the first subdomain. So, a good approximation would be 1 to 3 weeks per subdomain, depending upon how many stories that particular subdomain has. There is much more to what we are doing, than simply recategorizing you know. My post to this topic actually outlines a bit more what it is we're doing, exactly. Of course, I've already outlined that elsewhere as well. As I've said before, you all have to realize that not only is this a time consuming task, all four of us work full time plus jobs. I'll give you an example of just what exactly it is that I personally do, on a daily basis, just to get this done as quick as possible. On my work days, both before and after I come home, I tend to work on this for anywhere from 6 to 10 hours in a day. Mind you, I'm usually scheduled 10 hour shifts where I work. Somewhere in between this and work, I sleep, get some household chores done, and other normal day to day life activities. The next couple of days, I'm off work. I expect (as this has been my habit on my off days) that I'll put in an average of 12 hours each day to this task. In the meantime, the ladies helping me, are going through their selected subcategories and whatnot, generally after work. I can tell you from observation, not ONE of them has spent less than four hours a day on this task, every day, since we started this part. Of the four of us, I'm the only one without small children at home. Mine are all grown. So, you have to factor in as well that they must take care of their families and familial responsiblities, ASIDE from so graciously donating their time to assisting me, and getting this done for the archive. You can believe that no one will be happier than I to have this finished and done. It'll be NICE to be able to actually read for once, get back to my art which I've neglected, and a host of other things I'm ignoring in favor of getting this whole thing done as quickly as is possible.

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.