IcePacks wrote:>all you have is a taser and the cold realization that you're a haphazard bandaid over a problem that may or may not exist, applied by someone who doesn't know or care enough about their job to do it properly
IcePacks wrote:>all you have is a taser and the cold realization that you're a haphazard bandaid over a problem that may or may not exist, applied by someone who doesn't know or care enough about their job to do it properly
Qbopper wrote:I think the GBP page is still busted
IcePacks wrote:>all you have is a taser and the cold realization that you're a haphazard bandaid over a problem that may or may not exist, applied by someone who doesn't know or care enough about their job to do it properly
Atlanta-Ned wrote:Qbopper wrote:I think the GBP page is still busted
it is in fact, still busted. I will fix it tomorrow.
IcePacks wrote:>all you have is a taser and the cold realization that you're a haphazard bandaid over a problem that may or may not exist, applied by someone who doesn't know or care enough about their job to do it properly
IcePacks wrote:>all you have is a taser and the cold realization that you're a haphazard bandaid over a problem that may or may not exist, applied by someone who doesn't know or care enough about their job to do it properly
1 hour of play time (time spent in living job role) in the 30 days leading up to the vote being created (by summing the role_time_log table for the time period)
SELECT
count(DISTINCT tbl_poll_vote.id) AS votes,
tbl_poll_option.text AS `option`
FROM tbl_poll_vote
LEFT JOIN tbl_poll_option ON tbl_poll_vote.optionid = tbl_poll_option.id
LEFT JOIN tbl_role_time_log ON tbl_poll_vote.ckey = tbl_role_time_log.ckey AND (tbl_role_time_log.job = 'Living')
LEFT JOIN tbl_poll_question ON tbl_poll_vote.pollid = tbl_poll_question.id
WHERE tbl_poll_vote.pollid = ?
AND tbl_role_time_log.datetime BETWEEN tbl_poll_question.starttime - INTERVAL 30 DAY AND tbl_poll_question.starttime
GROUP BY tbl_poll_vote.optionid
HAVING sum(tbl_role_time_log.delta) >= 60
ORDER BY votes DESC;
IcePacks wrote:>all you have is a taser and the cold realization that you're a haphazard bandaid over a problem that may or may not exist, applied by someone who doesn't know or care enough about their job to do it properly
IcePacks wrote:>all you have is a taser and the cold realization that you're a haphazard bandaid over a problem that may or may not exist, applied by someone who doesn't know or care enough about their job to do it properly
IcePacks wrote:>all you have is a taser and the cold realization that you're a haphazard bandaid over a problem that may or may not exist, applied by someone who doesn't know or care enough about their job to do it properly
SELECT
COUNT(o.id) AS votes,
o.text AS `option`
FROM ss13poll_vote AS v
LEFT JOIN ss13poll_option AS o ON (v.optionid = o.id)
LEFT JOIN ss13player AS p ON (v.ckey = p.ckey)
LEFT JOIN ss13poll_question AS q ON (v.pollid = q.id)
WHERE v.pollid = ?
AND
(SELECT SUM(j.delta)
FROM ss13role_time_log AS j
WHERE j.job IN ('Living')
AND j.datetime BETWEEN q.starttime - INTERVAL 30 DAY AND q.starttime
AND j.ckey = v.ckey) >= 60
GROUP BY o.text
ORDER BY votes DESC;
SELECT
COUNT(o.id) AS votes,
o.text AS `option`
FROM ss13poll_vote AS v
LEFT JOIN ss13poll_option AS o ON (v.optionid = o.id)
LEFT JOIN ss13player AS p ON (v.ckey = p.ckey)
LEFT JOIN ss13poll_question AS q ON (v.pollid = q.id)
WHERE v.pollid = ?
AND
(SELECT SUM(j.delta)
FROM ss13role_time_log AS j
WHERE j.job IN ('Living')
AND j.datetime BETWEEN q.starttime - INTERVAL 30 DAY AND q.starttime
AND j.ckey = v.ckey) >= 60
GROUP BY o.text
ORDER BY votes DESC;
IcePacks wrote:>all you have is a taser and the cold realization that you're a haphazard bandaid over a problem that may or may not exist, applied by someone who doesn't know or care enough about their job to do it properly
[10:55 AM] spookydonut: stonedmc is the work of a criminally insane mad genius
Atlanta-Ned wrote:I've got some pretty groundbreaking news to share.
As it turns out, the filter query I came up with wasn't giving the correct results. This, in spite of me going through it line-by-line, in public, after MSO went over it.
Due to some misgivings with the results, I pulled down the raw data and filtered it by hand. It didn't match up with what I was seeing on Statbus' filtered results. Or the unfiltered results. So I reached out to MSO and he sent me a query he uses for the IRV poll filtering. I adapted it to match the current cat people poll, and these results matched the manually filtered results. We're working to determine what went wrong.
The accurate poll results are now live here.
Needless to say, I am deeply sorry that my results were incorrect, and I apologize for contributing to what is already a stressful situation.
Note that this does error does NOT affect any previous polls available on Statbus.
oranges wrote:nowhere do you say why the previous filter was incorrectly returning results, why was it incorrect and what part of it was wrong?
SELECT
count(DISTINCT tbl_poll_vote.id) AS votes,
tbl_poll_option.text AS `option`
FROM tbl_poll_vote
LEFT JOIN tbl_poll_option ON tbl_poll_vote.optionid = tbl_poll_option.id
LEFT JOIN tbl_role_time_log ON tbl_poll_vote.ckey = tbl_role_time_log.ckey AND (tbl_role_time_log.job = 'Living')
LEFT JOIN tbl_poll_question ON tbl_poll_vote.pollid = tbl_poll_question.id
WHERE tbl_poll_vote.pollid = 200
AND tbl_role_time_log.datetime BETWEEN tbl_poll_question.starttime - INTERVAL 30 DAY AND tbl_poll_question.starttime
GROUP BY tbl_poll_vote.optionid
HAVING sum(tbl_role_time_log.delta) >= 60
ORDER BY votes DESC;
SELECT
sum(tbl_role_time_log.delta) AS minutes,
tbl_poll_option.text AS `option`
FROM tbl_poll_vote
LEFT JOIN tbl_poll_option ON tbl_poll_vote.optionid = tbl_poll_option.id
LEFT JOIN tbl_role_time_log ON tbl_poll_vote.ckey = tbl_role_time_log.ckey AND (tbl_role_time_log.job = 'Living')
LEFT JOIN tbl_poll_question ON tbl_poll_vote.pollid = tbl_poll_question.id
WHERE tbl_poll_vote.pollid = 200
AND tbl_role_time_log.datetime BETWEEN tbl_poll_question.starttime - INTERVAL 30 DAY AND tbl_poll_question.starttime
GROUP BY tbl_poll_vote.id
HAVING sum(tbl_role_time_log.delta) >= 60;
count(DISTINCT tbl_poll_vote.id) AS votes,
IcePacks wrote:>all you have is a taser and the cold realization that you're a haphazard bandaid over a problem that may or may not exist, applied by someone who doesn't know or care enough about their job to do it properly
oranges wrote:Atlanta-Ned wrote:I've got some pretty groundbreaking news to share.
As it turns out, the filter query I came up with wasn't giving the correct results. This, in spite of me going through it line-by-line, in public, after MSO went over it.
Due to some misgivings with the results, I pulled down the raw data and filtered it by hand. It didn't match up with what I was seeing on Statbus' filtered results. Or the unfiltered results. So I reached out to MSO and he sent me a query he uses for the IRV poll filtering. I adapted it to match the current cat people poll, and these results matched the manually filtered results. We're working to determine what went wrong.
The accurate poll results are now live here.
Needless to say, I am deeply sorry that my results were incorrect, and I apologize for contributing to what is already a stressful situation.
Note that this does error does NOT affect any previous polls available on Statbus.
nowhere do you say why the previous filter was incorrectly returning results, why was it incorrect and what part of it was wrong?
[10:55 AM] spookydonut: stonedmc is the work of a criminally insane mad genius
SELECT
count(DISTINCT ss13poll_vote.id) AS votes,
ss13poll_option.text
FROM ss13poll_vote
LEFT JOIN ss13poll_option ON (ss13poll_vote.optionid = ss13poll_option.id)
**LEFT JOIN ss13role_time_log ON ss13poll_vote.ckey = ss13role_time_log.ckey AND (ss13role_time_log.job = 'Living')**
LEFT JOIN ss13poll_question ON (ss13poll_vote.pollid = ss13poll_question.id)
WHERE ss13poll_vote.pollid = 200
AND ss13role_time_log.datetime BETWEEN ss13poll_question.starttime - INTERVAL 30 DAY AND ss13poll_question.starttime
**GROUP BY ss13poll_vote.optionid**
**HAVING sum(ss13role_time_log.delta) >= 60;**
LEFT JOIN ss13role_time_log ON ss13poll_vote.ckey = ss13role_time_log.ckey AND (ss13role_time_log.job = 'Living')
HAVING sum(ss13role_time_log.delta) >= 60;
GROUP BY ss13poll_vote.optionid
HAVING sum(ss13role_time_log.delta) >= 60;
[10:55 AM] spookydonut: stonedmc is the work of a criminally insane mad genius
MrStonedOne wrote:
So lets keep that in mind while we return to that having line:
- Code: Select all
HAVING sum(ss13role_time_log.delta) >= 60;
Remember, it's applied after the group by, so at this point there are 2 groups, the yes group, and the no group. it goes to the yes group, adds up all of their role time, and if its over 60, keeps the yes group, then it does the same to the no group.
[10:55 AM] spookydonut: stonedmc is the work of a criminally insane mad genius
GuyonBroadway wrote:MrStonedOne wrote:
So lets keep that in mind while we return to that having line:
- Code: Select all
HAVING sum(ss13role_time_log.delta) >= 60;
Remember, it's applied after the group by, so at this point there are 2 groups, the yes group, and the no group. it goes to the yes group, adds up all of their role time, and if its over 60, keeps the yes group, then it does the same to the no group.
So if I understand correctly, it was keeping all the votes of yes or no if the total playtime of all the yes or no votes was >= 60?
[10:55 AM] spookydonut: stonedmc is the work of a criminally insane mad genius
MrStonedOne wrote:The second poll will be IRV, which already has a system for custom selecting filter parameters (we base headmin election filtering on the date the headmin elections thread is posted to global announcements), so we plan to base it on the time of the first poll being started, yes.
Oldman Robustin wrote:[Long-winded feature request]
IcePacks wrote:>all you have is a taser and the cold realization that you're a haphazard bandaid over a problem that may or may not exist, applied by someone who doesn't know or care enough about their job to do it properly
IcePacks wrote:>all you have is a taser and the cold realization that you're a haphazard bandaid over a problem that may or may not exist, applied by someone who doesn't know or care enough about their job to do it properly
IcePacks wrote:>all you have is a taser and the cold realization that you're a haphazard bandaid over a problem that may or may not exist, applied by someone who doesn't know or care enough about their job to do it properly
IcePacks wrote:>all you have is a taser and the cold realization that you're a haphazard bandaid over a problem that may or may not exist, applied by someone who doesn't know or care enough about their job to do it properly
Atlanta-ned/(Sloan Cox) has shot Timothytea/(Timothy Teakettle) with [10mm bullet] (NEWHP: -21.2)
Atlanta-ned/(Sloan Cox) has fired at Timothytea/(Timothy Teakettle) with [10mm bullet] from Engineering Foyer (NEWHP: -22.1)
Atlanta-ned/(Sloan Cox) has shot Timothytea/(Timothy Teakettle) with [10mm bullet] (NEWHP: -52.1)
Atlanta-ned/(Sloan Cox) has fired at Timothytea/(Timothy Teakettle) with [10mm bullet] from Engineering Foyer (NEWHP: -52.1)
Atlanta-ned/(Sloan Cox) has shot Timothytea/(Timothy Teakettle) with [10mm bullet] (NEWHP: -82.1)
Atlanta-ned/(Sloan Cox) has fired at Timothytea/(Timothy Teakettle) with [10mm bullet] from Engineering Foyer (NEWHP: -82.1)
Atlanta-ned/(Sloan Cox) has shot Timothytea/(Timothy Teakettle) with [10mm bullet] (NEWHP: -112.1)
Atlanta-ned/(Sloan Cox) has fired at Timothytea/(Timothy Teakettle) with [10mm bullet] from Engineering Foyer (NEWHP: -112.1)
Atlanta-ned/(Sloan Cox) has shot Timothytea/(Timothy Teakettle) with [10mm bullet] (NEWHP: -142.1)
Atlanta-ned/(Sloan Cox) has fired at Timothytea/(Timothy Teakettle) with [10mm bullet] from Engineering Foyer (NEWHP: -142.1)
Atlanta-ned/(Sloan Cox) has shot Timothytea/(Timothy Teakettle) with [10mm bullet] (NEWHP: -173)
IcePacks wrote:>all you have is a taser and the cold realization that you're a haphazard bandaid over a problem that may or may not exist, applied by someone who doesn't know or care enough about their job to do it properly
IcePacks wrote:>all you have is a taser and the cold realization that you're a haphazard bandaid over a problem that may or may not exist, applied by someone who doesn't know or care enough about their job to do it properly
Atlanta-Ned wrote:At some point I'm going to move statbus to a new server, so expect some downtime. Dunno when, dunno for how long. Don't freak out if it's suddenly down for a bit.
IcePacks wrote:>all you have is a taser and the cold realization that you're a haphazard bandaid over a problem that may or may not exist, applied by someone who doesn't know or care enough about their job to do it properly
Atlanta-Ned wrote:Atlanta-Ned wrote:At some point I'm going to move statbus to a new server, so expect some downtime. Dunno when, dunno for how long. Don't freak out if it's suddenly down for a bit.
I'll probably do this this weekend, during tg's maintenance window.
IcePacks wrote:>all you have is a taser and the cold realization that you're a haphazard bandaid over a problem that may or may not exist, applied by someone who doesn't know or care enough about their job to do it properly
IcePacks wrote:>all you have is a taser and the cold realization that you're a haphazard bandaid over a problem that may or may not exist, applied by someone who doesn't know or care enough about their job to do it properly
IcePacks wrote:>all you have is a taser and the cold realization that you're a haphazard bandaid over a problem that may or may not exist, applied by someone who doesn't know or care enough about their job to do it properly
IcePacks wrote:>all you have is a taser and the cold realization that you're a haphazard bandaid over a problem that may or may not exist, applied by someone who doesn't know or care enough about their job to do it properly
IcePacks wrote:>all you have is a taser and the cold realization that you're a haphazard bandaid over a problem that may or may not exist, applied by someone who doesn't know or care enough about their job to do it properly
IcePacks wrote:>all you have is a taser and the cold realization that you're a haphazard bandaid over a problem that may or may not exist, applied by someone who doesn't know or care enough about their job to do it properly
Atlanta-Ned wrote:Even though the library is/was/will always be a mistake, I have restored it: https://sb.atlantaned.space/library
Ayy Lemoh wrote:Atlanta-Ned wrote:Even though the library is/was/will always be a mistake, I have restored it: https://sb.atlantaned.space/library
It's missing the search bar now, it seems.
IcePacks wrote:>all you have is a taser and the cold realization that you're a haphazard bandaid over a problem that may or may not exist, applied by someone who doesn't know or care enough about their job to do it properly
IcePacks wrote:>all you have is a taser and the cold realization that you're a haphazard bandaid over a problem that may or may not exist, applied by someone who doesn't know or care enough about their job to do it properly
Atlanta-Ned wrote:I made a goofy toy: https://sb.atlantaned.space/names
Please read and understand the warnings/disclaimers
Return to Site, Forums, And Wiki
Users browsing this forum: No registered users