Per the details of the SquidgeWorld Monthly Contest, here are the winners for July 2021:
Random story chosen:
On July 25th, user merelyafigment posted a fic called Captured
Random commenter chosen:
On July 3rd, an anonymous user going by "Laurence" left a comment on Cas's fic called In The Arms Of An Angel
Congratulations to merelyafigment, Laurence, and Cas! I will be in touch asap with details about your win and gift offering.
There has been some discussion over on Dreamwidth (at this link) about possibly adding works in the public domain as a secondary exception to the "No links to Patreon, Ko-Fi, etc" rule. Looking through the "Books and Literature" section of fandoms, there are several that caught my eye, such as The Bible, The Picture of Dorian Grey, Moby Dick, Paradise Lost, among others. Before I make a decision on this, I would like to hear from SquidgeWorld users.
If this goes through, then public domain fandoms would be updated to have "[Public Domain]" as part of the fandom name (or something similar).
Please give me your thoughts on this. Thanks!
I've updated the Terms of Service for SquidgeWorld.org archive. You can find the details here, but in a nutshell, it's explicitly stated that users may not link to any money-making properties such as KoFi or Patreon with very, very limited exceptions.
Per the details of the SquidgeWorld Monthly Contest, here are the winners for June 2021:
Random story chosen:
On June 13th, user mbozzo posted a fic called A Mystery Killing In The Police Station
Random commenter chosen:
On June 7th, an anonymous user going by "Kim Lindsay" left a wonderful comment on Karen_Sumners's fic from 2008 (!!!!!) called Airs from Heaven or Blasts from Hell.
Congratulations to mbozzo, Kim Lindsay, and Karen_Sumners! I will be in touch asap with details about your win and gift offering.
Many thanks to Dreamwidth user jesse-the-k for putting together this primer on "Making AO3 Easier to Read", and then allowing me to post a link to it here on SquidgeWorld. If you're interested, jessie-the-k put it together in their Dreamwidth entry. You can find it here: https://jesse-the-k.dreamwidth.org/377083.html
Per the details of the SquidgeWorld Monthly Contest, here are the winners for April 2021:
Random story detail:
On May 5th, SqWA user diaryofageekgirl posted a fic called That Now And Always You'll Stay In My Heart
Random commenter detail:
On May 21st, user Netchka3posted a comment to wereleopard's story Fallen Under His Protection
Congratulations to diaryofageekgirl, Netchka3, and wereleopard! I will be in touch soon with your gift!
NOTE: Apparently my query was wrong and the random story was backdated. I let it stand for this month, but I will fix the query before next. I'll also draw a second winner asap.
Second Note: Congrats to SquidgeWorld user Beverly as the official winner of the random story since there was a technical error with the first winner's entry. The story that Beverly won for is No Ordinary Love in the Harry Potter fandom.
Per the details of the SquidgeWorld Monthly Contest, here are the winners for April 2021:
Random story detail:
On April 5th, SqWA user hyarrowen posted a fic called Corrie of the Horse
Random commenter detail:
On April 30th, an anonymous user with the nickname Kurare posted a comment to Moonloon's story Critical Mass
Congratulations to hyarrowen, Kurare, and Moonloon! I will be in touch soon with your gift!
Just so there's a level playing field for the monthly SquidgeWorld contest, here's the post that holds all of the details.
* Once a month on the first day of the month, the system will run an automatic job that queries the system for the previous month. (Queries are at the bottom of this post)
* The queries will pull three winners - One registered user that posted a story in the previous month, one commenter (registered or anonymous) that posted a comment on any story, and the person who wrote the story that was commented on.
* If the person drawn won the previous month's contest, they are not eligible. So if user 'GENSLASHFEM' won on February 1st for a comment they left on January 20th, when the contest is drawn on March 1st for February, user 'GENSLASHFEM' isn't eligible. Basically, you're only eligible every other month. Questions?
* Users must have a valid email address in order to get their prize.
* Prizes are a (US) $10 gift certificate to Amazon, Apple, or Google Play. Please note: If you are in the United States, the gift certificates are not an issue. However, if you are outside of the United States, sometimes I cannot purchase a gift card; for example, a gift card purchased on Amazon.com will notwork on Amazon.com.au for some reason. In this case, you can ask for the $10 be donated to the charity of your choice.
* When it comes to winners of the comments contest, users can be registered or unregistered (leave an anonymous comment); the system queries for both at the same time and randomizes the results.
* Winners have until the last day of the month they won to respond and claim their win!
* Fics must be added during the previous month and not be backdated beyond the first of that month in order to qualify. For example, a fic added on March 27th, 2021 and backdated to March 2nd, 2021 would qualify, as would a fic added on March 27th, 2021 and not backdated. But a fic added on March 27th, 2021 and backdated to January 20th, 2021 would not be eligible if drawn. Additionally, the work is only eligible for the first month that it qualified. If a user added a work on March 27th and not backdated, it would be eligible for the April drawing. If that same user added an additional chapter in May, making the original story multi-chapter, the additional chapter is not eligible. Date of first publication of the original chapter is the qualifier for a single work.
Geeky details
Query to get the random story:
Query to get the comment winner:select w.id, ch.published_at, w.title, p.name, u.email
from works w, pseuds p, users u, creatorships cr, chapters ch
where ch.published_at between date_format(now() - INTERVAL 1 MONTH, '%Y-%m-01 00:00:00')
and date_format(LAST_DAY(now() - INTERVAL 1 MONTH), '%Y-%m-%d 23:59:59')
and w.id = cr.creation_id
and w.id = ch.work_id
and cr.creation_type = 'Work'
and cr.pseud_id = p.id
and p.user_id = u.id
order by rand()
limit 6;
select cm.created_at, cm.pseud_id, psc.name, usc.email, cm.comment_content, cha.work_id, w.title, pwa.name, usa.email
from comments cm, pseuds psc, users usc, chapters cha, works w, creatorships cr,
pseuds pwa, users usa
where cm.created_at between date_format(now() - INTERVAL 1 MONTH, '%Y-%m-01 00:00:00')
and date_format(LAST_DAY(now() - INTERVAL 1 MONTH), '%Y-%m-%d 23:59:59')
and cm.pseud_id is not NULL
and cm.pseud_id = psc.id
and psc.user_id = usc.id
and cm.parent_type = 'Chapter'
and cm.parent_id = cha.id
and cha.work_id = w.id
and w.id = cr.creation_id
and cr.creation_type = 'Work'
and cr.pseud_id = pwa.id
and pwa.user_id = usa.id
union
select cm.created_at, 0, cm.name, cm.email, cm.comment_content, cha.work_id, w.title, pwa.name, usa.email
from comments cm, chapters cha, works w, creatorships cr,
pseuds pwa, users usa
where cm.created_at between date_format(now() - INTERVAL 1 MONTH, '%Y-%m-01 00:00:00')
and date_format(LAST_DAY(now() - INTERVAL 1 MONTH), '%Y-%m-%d 23:59:59')
and cm.pseud_id is NULL
and cm.parent_type = 'Chapter'
and cm.parent_id = cha.id
and cha.work_id = w.id
and w.id = cr.creation_id
and cr.creation_type = 'Work'
and cr.pseud_id = pwa.id
and pwa.user_id = usa.id
order by rand()
limit 6;
