I honestly don't know what I should be requesting in this case. I remember briefly discussing this somewhere, but can't find the thread.
We've just received an email from our hosting company that they CHMODed authors.php to 000 because of excessive usage, which they called an exploit. We currently have 10,552 members, and it takes forever for it to load any list of authors. When we upgraded from 2.0.7 to 3.3, we had around 5000. Prior to upgrade there were no issues, but afterwards there was a huge increase in time to load the authors list.
Can anyone explain the differences between how this works in 2.0 and 3.0? The site can operate well without viewing authors.php, but I'm concerned that it might affect other areas, such as browse, if it has to do with how the info is pulled from fanfiction_authors.
To tack onto the thread ... as a temp. fix.
if(empty($countquery)) {
$pagetitle .= _MEMBERS;
$countquery = _MEMBERCOUNT.(isset($letter) ? " WHERE $letter" : "");
$authorquery = _MEMBERLIST.(isset($letter) ? " WHERE $letter" : "")." GROUP BY "._UIDFIELD;
}
I have a feeling, it'd be editing that. The $authorquery and $countquery (for the author list), but I'm not sure how the eFiction tables work so I'm afraid to attempt anything.
I was thinking of, 'where reviews-posted is higher than 20 AND where validated-stories higher than 1 AND skin is [insert all working skins]' then display? That's just an example, I guess, but I think this'd help DG. :S
eta: Joining the fanfiction_reviews.uid with fanfiction_authorprefs.userskin and (?) fanfiction_stories.uid.
No idea how to call how many reviews belong to one member, but the validated stories (if applicable) could be borrowed from the 'authors' list and the skin could be added ...
archive:
site:
Available for skin/mod commission! 🙂
Your host said it chmodded authors.php - not that they deleted the authors field in your database. One has nothing to do with the other - so your script will still work perfectly, as long as you're not calling up the authors.php page, which is the members list. So simply remove that from your menu and you should be just fine.
Jacynthe
Archives: http://fanfics.e-authors.net
Version: 3.5.3
Modified? Somewhat...
PHP: 5.3.3
MySQL: 5.0.91-community
That's exactly what I did. My issue is that I would like to be able to use it, and am trying to come up with ways to do so and not have it shut down again by the hosting company.
