SOLVED - Add timestamp & wordcount to submission queue

I figured out how to get them to display on the submitted page.  When I am finished figuring out how to get it to write the timestamp to the table, I will post the rest of it.

EDIT:  OK, I figured it out, so the modifications to stories.php are in the original post now.

What does one mean by "submitted page"? :S

Sorry--I meant that at first all I that figured out was how to create the columns in the table on submitted.php, but not how to make it display the correct timestamp in the column.  It took me a bit longer to do that, but it's all in the original post now.

I attempted to do this for 3.x, but gave up on it, so I'm glad to see someone else didn't!  I've successfully got it working at my archive with no trouble.

I made one small change, however.  In your very first change, right at the end, I changed ORDER by story.title to ORDER by chapter.submittime, so that it would sort by the time the chapter was submitted, since that's how the mods liked it.  It seems to be working fine with my tests.

Given the 3.4 update, how should this be modified?

This is line "187" (now 231) with the part that's different from 3.3.x bolded:

$query2 = dbquery("INSERT INTO ".TABLEPREFIX."fanfiction_chapters (title, inorder, notes, endnotes, validated, wordcount, sid, uid, storytext) VALUES('".addslashes(($chaptertitle != "" ? $chaptertitle : $title))."', '$inorder', '".addslashes(format_story($notes))."', '".addslashes(format_story($endnotes))."', '$validated', '$wordcount', '$sid', '$uid', '".addslashes($storytext)."')");

This is line "201" (now 246) with the part that's different from 3.3.x bolded:

$insertchapter = dbquery("INSERT INTO ".TABLEPREFIX."fanfiction_chapters (title, inorder, notes, endnotes, validated, wordcount, sid, uid) VALUES('".addslashes(($chaptertitle != "" ? $chaptertitle : $title))."', '$inorder', '".addslashes(format_story($notes))."', '".addslashes(format_story($endnotes))."', '".($validated ? 1 : 0)."', '$wordcount', '$sid', '$uid')");

I wasn't sure if the endings were what was preventing this mod to work for me. Thanks in advance for any modifications you come up with!

Hi,

The topic title indicates adding word count to the submission page but in looking through your instructions, i don't see anything that adds it in.  Am I just missing something? (I'm going to wait to implement this until we're sure we know how to make it work for 3.4.1.

IntheMoonlight, you do add the word count to your submissions table. Since it already exists in fanfiction_chapters, you don't have to create the new field.

I've bolded the parts of the code that is used to include word count:

submitted.php:

$result = dbquery("SELECT story.title as storytitle, chapter.uid, chapter.sid, story.catid, chapter.wordcount, chapter.chapid, chapter.inorder, chapter.title, chapter.submittime, "._PENNAMEFIELD." as penname FROM (".TABLEPREFIX."fanfiction_chapters as chapter, "._AUTHORTABLE.") LEFT JOIN ".TABLEPREFIX."fanfiction_stories as story ON story.sid = chapter.sid WHERE chapter.validated = '0' AND chapter.uid = "._UIDFIELD." ORDER BY story.title");

if(dbnumrows($result)) {
$output .= "<table class="tblborder" cellspacing="0" cellpadding="0" style="margin: 0 auto; width: 90%;"><tr class="tblborder"><th>"._TITLE."</th><th>"._WORDCOUNT."</th><th>".Submitted."</th><th>"._AUTHOR."</th> <th>"._CATEGORY."</th><th>"._OPTIONS."</th></tr>";

$output .= "<td class="tblborder">".$story['wordcount']."</td>";

stories.php already contains wordcount information so there's nothing pertaining to that that you need to modify.

I think I've got it...

For the timestamp mod for 3.4.0+

submitted.php remains the same as 3.3.1.

In Stories.php:

Find this (around line 231):

$query2 = dbquery("INSERT INTO ".TABLEPREFIX."fanfiction_chapters (title, inorder, notes, endnotes, validated, wordcount, sid, uid, storytext) VALUES('".addslashes(($chaptertitle != "" ? $chaptertitle : $title))."', '$inorder', '".addslashes(format_story($notes))."', '".addslashes(format_story($endnotes))."', '$validated', '$wordcount', '$sid', '$uid', '".addslashes($storytext)."')");

and replace with:

$query2 = dbquery("INSERT INTO ".TABLEPREFIX."fanfiction_chapters (title, inorder, notes, endnotes, validated, wordcount, sid, uid, storytext, submittime) VALUES('".addslashes(($chaptertitle != "" ? $chaptertitle : $title))."', '$inorder', '".addslashes(format_story($notes))."', '".addslashes(format_story($endnotes))."', '$validated', '$wordcount', '$sid', '$uid', '".addslashes($storytext)."', now())");

Find this (around line 246):

$insertchapter = dbquery("INSERT INTO ".TABLEPREFIX."fanfiction_chapters (title, inorder, notes, endnotes, validated, wordcount, sid, uid) VALUES('".addslashes(($chaptertitle != "" ? $chaptertitle : $title))."', '$inorder', '".addslashes(format_story($notes))."', '".addslashes(format_story($endnotes))."', '".($validated ? 1 : 0)."', '$wordcount', '$sid', '$uid')");

and replace with:

$insertchapter = dbquery("INSERT INTO ".TABLEPREFIX."fanfiction_chapters (title, inorder, notes, endnotes, validated, wordcount, sid, uid, submittime) VALUES('".addslashes(($chaptertitle != "" ? $chaptertitle : $title))."', '$inorder', '".addslashes(format_story($notes))."', '".addslashes(format_story($endnotes))."', '".($validated ? 1 : 0)."', '$wordcount', '$sid', '$uid', now())");

Works fine for me 🙂

Hey Marauder by Midnight:

I'm stuck!  I was able to create the new field and was able to update submitted but when i try to find the code in stories, (I'm using the find function in notepad) it says it can't find it.  I checked my stories.php file from 3.3.1 and got the same results (as in it can't find it).

Scratch that! I was looking at the wrong file!  I thought we were still in admin..duh! *smacks self*.  I apologize for my uber stupidness

EDIT: Ok so it works. I unvlidated myself and then submitted just to test.  I went into the admin paenl and it said i had 2 chapters waiting when I only had 1.  Does anyone know if this a bug or even related to the mod?

Just adding in that I have changed everything to what has been said here, and the mod works for me. For a new user of the mod (like I am), when you forst change the code, any stories in the Submissions queue will have a date and time set at 0, but all new submissions will show up the correct date and time 🙂

Thanks to everyone who fixed/changed/updated this mod, it will come in handy for me 🙂

I know this is a stupid question but I cannot figure out how to do the database insert, can anyone show me a jpg view of the steps? I find it much easier that way 🙂 or at least explain how to add a field into fanfic chapters

Thank you so much for this. Worked perfect right away.

I have a question on how to take this one step further.
We use the “Tracker” mod that allows you to track stories and on story info you find when you last read the story. To make this mod way more useful I would like to use the new “SUBMITTIME” field on the wiewstory.php so that each chapters submit time is displayed next to the chapter name, author and word count. How would I best achieve this? Any ideas?