I see.  So if I understand correctly, I should add an additional check in the "Unhide" function that checks if the author is "trus...

See and that's why I said be specific.  No the two don't share the same code, but you didn't specify what "contact" you ...

Okay, not to discourage you guys, but I'm going to stop helping on this.  The reason being that on something this complicated, my feeling is...

I'm not sure I'm following that.  I guess I don't understand the difference.  In the SQL tables, validation is either "0...

First of all there's plenty of places in the script that send "messages."  Contact the author, reviews, etc.  You didn't...

Just a warning.  If you validate  a story to "story" instead of "chapter" when an author hides the story then unhides it...

Please be more specific.  What kind of "message"? 

Take this section out of the query.UNIX_TIMESTAMP(stories.updated) as updated Recommendations has no updated field.

As an example, if i renumber author with uid 4 to uid 2 in the _authors table will that cause me any problems, and is that the only place in which i w...

You can't go back in the update.  It's giving you that error because it's already deleted that index.  You can try continuing...

Oh! I know.  You need to change it in includes/queries.php.  Most of the places that list stories use the queries in there.

Unfortunately there are multiple places where you'd have to change things.  You'll need to look for something like:preg_match("!^[...

There's a missing single quote on line 241 of install/upgrade20.phpReplace it with this:dbquery("UPDATE ".$tableprefix."fanfiction...

Why don't you make it into a module so people don't have to modify their files?