<<Prev Next>> Scroll to Bottom
Stuff goes here
L1[02:11:23] ⇨
Joins: TPG24
(~ThePiGuy2@host-92-31-106-206.as13285.net)
L2[02:12:49] ⇦
Quits: ThePiGuy24 (~ThePiGuy2@host-92-31-106-206.as13285.net) (Ping
timeout: 192 seconds)
L3[11:42:46] ⇨
Joins: ThePiGuy24
(~ThePiGuy2@host-92-31-106-206.as13285.net)
L4[11:43:26] ⇦
Quits: TPG24 (~ThePiGuy2@host-92-31-106-206.as13285.net) (Ping
timeout: 195 seconds)
L5[12:36:58] ⇨
Joins: TPG24
(~ThePiGuy2@host-92-31-106-206.as13285.net)
L6[12:38:22] ⇦
Quits: ThePiGuy24 (~ThePiGuy2@host-92-31-106-206.as13285.net) (Ping
timeout: 189 seconds)
L7[13:53:24] ⇨
Joins: ThePiGuy24
(~ThePiGuy2@host-92-31-106-104.as13285.net)
L8[13:54:06] ⇦
Quits: TPG24 (~ThePiGuy2@host-92-31-106-206.as13285.net) (Ping
timeout: 189 seconds)
L9[14:50:51] ⇦
Quits: Amanda (~m-yt727s@c-73-165-62-84.hsd1.pa.comcast.net)
(Remote host closed the connection)
L10[14:51:03] ⇨
Joins: Amanda
(~m-yt727s@c-73-165-62-84.hsd1.pa.comcast.net)
L11[15:18:57] ⇨
Joins: TPG24
(~ThePiGuy2@host-92-31-110-216.as13285.net)
L12[15:20:32] ⇦
Quits: ThePiGuy24 (~ThePiGuy2@host-92-31-106-104.as13285.net) (Ping
timeout: 189 seconds)
L13[16:50:52] ⇦
Quits: Amanda (~m-yt727s@c-73-165-62-84.hsd1.pa.comcast.net)
(Remote host closed the connection)
L14[16:51:04] ⇨
Joins: Amanda
(~m-yt727s@c-73-165-62-84.hsd1.pa.comcast.net)
L15[17:18:34] ⇨
Joins: ForeBot
(~ForeBot@81-227-95-20-no600.tbcn.telia.com)
L16[17:19:29] <Forecaster> ?tonkout
0CD85
L17[17:19:29] <ForeBot> Kapow! Forecaster!
You beat your own previous record of 15 minutes and 4 seconds (By
19 hours, 23 minutes and 16 seconds)! I hope you're happy!
L18[17:19:30] <ForeBot> Forecaster has
tonked out! Tonk has been reset! They gained 0.019 tonk points!
plus 0.036 bonus points for consecutive hours! Current score:
0.055, Position #-1
L19[17:20:34] ⇦
Quits: ForeBot (~ForeBot@81-227-95-20-no600.tbcn.telia.com) (Client
Quit)
L20[17:23:15] ⇨
Joins: ForeBot
(~ForeBot@81-227-95-20-no600.tbcn.telia.com)
L21[17:23:28] <Forecaster> ?tonk
0CD85
L22[17:23:28] <ForeBot> Heckgosh!
Forecaster! You beat your own previous record of <0 (By 3
minutes and 59 seconds)! I hope you're happy!
L23[17:23:29] <ForeBot> Forecaster's new
record is 3 minutes and 59 seconds! No points gained for stealing
from yourself. (Lost out on 0.00007)
L24[17:28:25] <Forecaster>
?tonkreseteverything
L25[17:28:26] <ForeBot> Top scores:
L26[17:28:28] <ForeBot> Resetting the tonk
scoreboard forever!
L27[17:28:39] <Forecaster> hm, it should
not do that
L28[17:28:47] ⇦
Quits: ForeBot (~ForeBot@81-227-95-20-no600.tbcn.telia.com)
()
L29[17:30:26] <Forecaster> oh, there's no
ratelimit on tonk anymore... oops
L30[17:30:51] <Forecaster> I really need to
put a "if (testing)" on stuff like that...
L31[17:32:43] ⇨
Joins: ForeBot
(~ForeBot@81-227-95-20-no600.tbcn.telia.com)
L32[17:32:55] <Forecaster> ?tonk
L33[17:32:55] <ForeBot> You got the first
Tonk Forecaster, but this is only the beginning.
L34[17:33:17] <Forecaster> there, also now
it disables the dang code check when testing
L35[17:34:42] <Forecaster> ?tonkout
L37[17:34:47] <Forecaster> or not...
L38[17:34:48] <Forecaster> sigh
L39[17:35:02] ⇦
Quits: ForeBot (~ForeBot@81-227-95-20-no600.tbcn.telia.com) (Client
Quit)
L40[17:35:30] ⇨
Joins: ForeBot
(~ForeBot@81-227-95-20-no600.tbcn.telia.com)
L41[17:35:47] <Forecaster> ?tonkout
L43[17:35:54] <Forecaster> ?debug
L44[17:36:23] ⇦
Quits: ForeBot (~ForeBot@81-227-95-20-no600.tbcn.telia.com) (Client
Quit)
L45[17:39:08] ⇨
Joins: ForeBot
(~ForeBot@81-227-95-20-no600.tbcn.telia.com)
L46[17:39:15] <Forecaster> ?debug
L47[17:39:15] <ForeBot> Debug mode is
ENABLED
L48[17:39:18] <Forecaster> hm
L49[17:39:21] <Forecaster> ?tonkout
L51[17:39:33] <Forecaster> did I &&
that wrong
L52[17:40:00] <Forecaster> no...
L53[17:40:02] <Forecaster> weird
L54[17:40:23] <Forecaster> ?tonkout
0CD85
L55[17:40:24] <ForeBot> Forecaster: You
gotta tonk before you can tonk out. For this transgression the
timer has been reset.
L56[17:40:37] <Forecaster> oh right, I did
it for tonk, but not tonkout
L57[17:44:00] ⇦
Quits: ForeBot (~ForeBot@81-227-95-20-no600.tbcn.telia.com)
()
L58[17:48:37] ⇨
Joins: ForeBot
(~ForeBot@81-227-95-20-no600.tbcn.telia.com)
L59[17:48:43] <Forecaster> ?tonkout
L60[17:48:43] <ForeBot> Forecaster: You
gotta tonk before you can tonk out. For this transgression the
timer has been reset.
L61[17:49:12] <Forecaster> hm, weird
L62[17:57:55] <Forecaster> oh wait, I have
a tonk of 0
L63[17:57:57] <Forecaster> ?tonk
L64[17:57:57] <ForeBot> Woah! Forecaster!
You beat your own previous record of <0 (By 9 minutes and 14
seconds)! I hope you're happy!
L65[17:57:58] <ForeBot> Forecaster's new
record is 9 minutes and 14 seconds! No points gained for stealing
from yourself. (Lost out on 0.00015)
L66[17:58:03] <Forecaster> bah
L67[18:04:31] ⇦
Quits: Amanda (~m-yt727s@c-73-165-62-84.hsd1.pa.comcast.net)
(Remote host closed the connection)
L68[18:04:42] ⇨
Joins: Amanda
(~m-yt727s@c-73-165-62-84.hsd1.pa.comcast.net)
L69[18:09:15] <Forecaster> ?tonkout
L70[18:09:15] <ForeBot> Shoot! Forecaster!
You beat your own previous record of 9 minutes and 14 seconds (By 2
minutes and 3 seconds)! I hope you're happy!
L71[18:09:16] <ForeBot> Forecaster has
tonked out! Tonk has been reset! They gained 0 tonk points! Current
score: 0, Position #-1
L72[18:09:26] <Forecaster> uh, that's not
quite right
L73[18:13:14] ⇦
Quits: ForeBot (~ForeBot@81-227-95-20-no600.tbcn.telia.com)
()
L74[18:13:39] ⇨
Joins: ForeBot
(~ForeBot@81-227-95-20-no600.tbcn.telia.com)
L75[18:13:54] <Forecaster>
?testcommand
L76[18:14:39] <Forecaster> hm, that's a
problem it hasn't set the id column as primary key or auto
inc
L77[18:14:47] ⇦
Quits: ForeBot (~ForeBot@81-227-95-20-no600.tbcn.telia.com) (Client
Quit)
L78[18:18:08] <Forecaster> oh, probably
because I didn't make it do that when creating tables
L79[18:27:33] <Forecaster> oh huh, sqlite
doesn't need the auto increment keyword
L80[18:28:16] <Forecaster> INTEGER PRIMARY
KEY just automatically performs that function, AUTO INC just
prevents it from reusing ids
L81[18:29:40] ⇨
Joins: ForeBot
(~ForeBot@81-227-95-20-no600.tbcn.telia.com)
L82[18:30:12] <Forecaster>
?testcommand
L83[18:30:21] <Forecaster>
?testcommand
L84[18:30:43] ⇦
Quits: ForeBot (~ForeBot@81-227-95-20-no600.tbcn.telia.com) (Client
Quit)
L85[18:31:06] ⇨
Joins: ForeBot
(~ForeBot@81-227-95-20-no600.tbcn.telia.com)
L86[18:31:13] <Forecaster>
?testcommand
L87[18:31:26] <Forecaster> hm, its setting
id to 0
L88[18:31:32] <Forecaster>
?testcommand
L89[18:31:41] ⇦
Quits: ForeBot (~ForeBot@81-227-95-20-no600.tbcn.telia.com) (Client
Quit)
L90[18:39:38] ⇦
Quits: TPG24 (~ThePiGuy2@host-92-31-110-216.as13285.net) (Ping
timeout: 189 seconds)
L91[18:44:18] ⇨
Joins: ThePiGuy24
(~ThePiGuy2@host-92-31-110-216.as13285.net)
L92[18:50:59] ⇨
Joins: ForeBot
(~ForeBot@81-227-95-20-no600.tbcn.telia.com)
L93[18:51:16] <Forecaster>
?testcommand
L94[18:51:27] <Forecaster>
?testcommand
L95[18:51:32] ⇦
Quits: ForeBot (~ForeBot@81-227-95-20-no600.tbcn.telia.com) (Client
Quit)
L96[18:55:06] ⇨
Joins: ForeBot
(~ForeBot@81-227-95-20-no600.tbcn.telia.com)
L97[18:55:15] <Forecaster>
?testcommand
L98[18:55:37] <Forecaster> hrm
L99[18:55:40] <Forecaster> "(5 values
for 6 columns)"
L100[18:55:54] <Forecaster> well yeah,
that's what I thought I had to do, not include the id
L101[18:55:58] <Forecaster> but apparently
not
L102[18:56:58] ⇦
Quits: ForeBot (~ForeBot@81-227-95-20-no600.tbcn.telia.com) (Client
Quit)
L103[18:57:29]
⇨ Joins: ForeBot
(~ForeBot@81-227-95-20-no600.tbcn.telia.com)
L104[18:57:41] <Forecaster>
?testcommand
L105[18:57:51] <Forecaster>
?testcommand
L106[18:57:59] ⇦
Quits: ForeBot (~ForeBot@81-227-95-20-no600.tbcn.telia.com) (Client
Quit)
L107[18:59:00]
⇨ Joins: ForeBot
(~ForeBot@81-227-95-20-no600.tbcn.telia.com)
L108[18:59:12] <Forecaster>
?testcommand
L109[18:59:22] <Forecaster>
?testcommand
L110[18:59:38] ⇦
Quits: ForeBot (~ForeBot@81-227-95-20-no600.tbcn.telia.com) (Client
Quit)
L111[19:01:44]
⇨ Joins: ForeBot
(~ForeBot@81-227-95-20-no600.tbcn.telia.com)
L112[19:01:51] <Forecaster>
?testcommand
L113[19:07:04] <Forecaster> but this
article says that's how it should work...
L114[19:07:30] <Forecaster> I wonder if
it's the REPLACE INTO
L115[19:10:43] <Forecaster> sigh, guess I
need to make it a bit smarter and adapt to whether the entry is new
or not
L116[19:10:58] <Forecaster> I was hoping I
could leave that to the sql system
L117[19:20:59] <Michiyo> REPLACE INTO
should work... what is the issue?
L118[19:21:34] <Forecaster> I'm setting
the id field to null, but it becomes 0 in the table
L119[19:21:57] <Forecaster> if I don't
include the id field it complains about the missing column
L120[19:22:36] <Michiyo> Got the schema
handy?
L121[19:22:44] <Michiyo> I'll load it into
a database and poke it
L123[19:25:36] ⇦
Quits: ForeBot (~ForeBot@81-227-95-20-no600.tbcn.telia.com)
()
L124[19:28:42]
⇨ Joins: ForeBot
(~ForeBot@81-227-95-20-no600.tbcn.telia.com)
L125[19:28:49] ⇦
Quits: ForeBot (~ForeBot@81-227-95-20-no600.tbcn.telia.com) (Client
Quit)
L126[19:29:07] <Michiyo> Is there a reason
you don't have ID set to autoinc?
L127[19:29:27]
⇨ Joins: ForeBot
(~ForeBot@81-227-95-20-no600.tbcn.telia.com)
L128[19:29:35] <Forecaster> I read that
that wasn't needed, it should auto inc just from primary key
L129[19:29:43] <Forecaster> auto inc just
makes sure it never re-uses an id
L130[19:30:12] <Forecaster>
?testcommand
L131[19:30:13] <Michiyo> Autoinc makes
this ALMOST work, I can specify everything except the ID.. but then
it doesn't properly replace.. just makes a new insert...
L132[19:30:22] ⇦
Quits: ForeBot (~ForeBot@81-227-95-20-no600.tbcn.telia.com) (Client
Quit)
L133[19:30:33] <Michiyo> I've used REPLACE
INTO before, but it's been ages and I forget the specifics
L134[19:31:10]
⇨ Joins: ForeBot
(~ForeBot@81-227-95-20-no600.tbcn.telia.com)
L135[19:31:17] <Forecaster>
?testcommand
L136[19:31:31] ⇦
Quits: ForeBot (~ForeBot@81-227-95-20-no600.tbcn.telia.com) (Client
Quit)
L137[19:32:16] <Forecaster> yeah I have no
idea, it just uses 0 as the id all the time, this time I changed
the data between running the command, and it just replaced the same
row with id 0
L138[19:32:48] <Forecaster> I'll just
conditionally use REPLACE or INSERT depending on the object
state
L139[19:33:08] <Michiyo> "It is
important to understand that it is an insert+delete and never and
update. The consequence of this, is that you will always want to
make sure when you do a replace, you should always include data for
all the fields."
L140[19:33:09] <Forecaster> I already have
a field that tells me if it came from the database or not
anyway
L141[19:34:11] <Forecaster> that doesn't
explain how just the insert is supposed to work :|
L142[19:35:54] <Michiyo> Seems you're only
ever supposed to use replace if you KNOW the pkey value, so you
always insert your own tracked id and you always provide said id
when you call an update
L143[19:36:43] <Forecaster> I guess INSERT
OR REPLACE just doesn't work with an auto incrementing id
L144[19:36:53] <Michiyo> yep
L146[19:43:54] <Forecaster> hm, how do I
test for an unset int...
L147[19:45:40] <Forecaster> ah, an unset
int defaults to 0 apparently
L148[19:50:06]
⇨ Joins: ForeBot
(~ForeBot@81-227-95-20-no600.tbcn.telia.com)
L149[19:50:22] <Forecaster>
?testcommand
L150[19:50:45] <Forecaster> oh
L151[19:51:07] <Forecaster> 5 values for 6
columns means I provided 6 columns and 5 values
L152[19:51:13] <Forecaster> why is it
doing that...
L153[19:51:17] ⇦
Quits: ForeBot (~ForeBot@81-227-95-20-no600.tbcn.telia.com) (Client
Quit)
L154[19:52:54]
⇨ Joins: ForeBot
(~ForeBot@81-227-95-20-no600.tbcn.telia.com)
L155[19:53:07] <Forecaster>
?testcommand
L156[19:54:08] ⇦
Quits: ForeBot (~ForeBot@81-227-95-20-no600.tbcn.telia.com) (Client
Quit)
L157[19:54:28]
⇨ Joins: ForeBot
(~ForeBot@81-227-95-20-no600.tbcn.telia.com)
L158[19:54:35] <Forecaster>
?testcommand
L159[19:54:38] <Michiyo> Is this going to
be able to migrate SQLite to MySQL/MariaDB?
L160[19:54:49] ⇦
Quits: ForeBot (~ForeBot@81-227-95-20-no600.tbcn.telia.com) (Client
Quit)
L161[19:55:49] <Forecaster> what I'm doing
right now is implementing a class-based db interface, this will
replace all the statements strewn around the hooks
L162[19:56:35] <Forecaster> then I can
just add a mysql mode to the interface that generates mysql/mariadb
statements instead of sqlite statements and you can just choose
which to use without changing the usage
L163[19:59:06] <Forecaster> you know, in
theory
L165[20:02:54] <Forecaster> sssh
L166[20:03:00] <Forecaster> it's time
travel
L167[20:37:16]
⇨ Joins: ForeBot
(~ForeBot@81-227-95-20-no600.tbcn.telia.com)
L168[20:37:26] <Forecaster>
?testcommand
L169[20:37:41] ⇦
Quits: ForeBot (~ForeBot@81-227-95-20-no600.tbcn.telia.com) (Client
Quit)
L170[20:37:44] <Forecaster> INSERT INTO
UserData () VALUES ()
L171[20:38:07] <Forecaster> something's
not right here...
L172[20:43:27]
⇨ Joins: ForeBot
(~ForeBot@81-227-95-20-no600.tbcn.telia.com)
L173[20:43:44] <Forecaster>
?testcommand
L175[20:44:39] ⇦
Quits: ForeBot (~ForeBot@81-227-95-20-no600.tbcn.telia.com) (Client
Quit)
L176[20:45:47]
⇨ Joins: ForeBot
(~ForeBot@81-227-95-20-no600.tbcn.telia.com)
L177[20:45:59] <Forecaster>
?testcommand
L179[20:46:07] ⇦
Quits: ForeBot (~ForeBot@81-227-95-20-no600.tbcn.telia.com) (Client
Quit)
L180[20:48:22]
⇨ Joins: ForeBot
(~ForeBot@81-227-95-20-no600.tbcn.telia.com)
L181[20:48:32] <Forecaster>
?testcommand
L183[20:49:03]
<Forecaster> that's...
L184[20:49:05]
<Forecaster> what
L185[20:49:19]
<Forecaster> `INSERT INTO UserData
('username', 'category', 'entrykey', 'entry_data', 'count') VALUES
(?, ?, ?, ?, ?)`
L186[20:50:12]
<Forecaster> ????
L187[20:50:28] <Michiyo> Whats up?
L188[20:50:40]
<Forecaster> why did it make id
null?!
L189[20:50:42]
<Forecaster> D:
L190[20:50:50]
<Forecaster> what the heck
L191[20:51:01] <Michiyo> Because it's not
auto_inc?
L192[20:51:01]
<Forecaster> is there a different between
INT and INTEGER...
L193[20:51:09]
<Forecaster> I don't know!
L194[20:51:53] ⇦
Quits: ForeBot (~ForeBot@81-227-95-20-no600.tbcn.telia.com) (Client
Quit)
L195[20:51:55] <Michiyo> AUTO_INCREMENT
should take care of that, I've never had anything else work for
that
L196[20:52:05] <Michiyo> other than
tracking my own IDs in code, and using those
L197[20:52:11]
<Forecaster> but the internet can't lie
D:
L198[20:54:52]
⇨ Joins: ForeBot
(~ForeBot@81-227-95-20-no600.tbcn.telia.com)
L199[20:56:45] ⇦
Quits: ForeBot (~ForeBot@81-227-95-20-no600.tbcn.telia.com) (Client
Quit)
L200[20:57:16]
⇨ Joins: ForeBot
(~ForeBot@81-227-95-20-no600.tbcn.telia.com)
L201[20:58:09] <Forecaster> neither AUTO
INCREMENT or AUTO_INCREMENT is the right syntax apparnetly
L202[20:58:26] <Michiyo> ?
L203[20:58:44] <Forecaster> oh, it's just
one word
L204[20:58:55] <Michiyo> "int NOT
NULL AUTO_INCREMENT"
L205[20:59:04] <Michiyo> when you create
it, or you have to modify the table with it
L206[20:59:36] ⇦
Quits: ForeBot (~ForeBot@81-227-95-20-no600.tbcn.telia.com) (Client
Quit)
L207[21:00:02]
⇨ Joins: ForeBot
(~ForeBot@81-227-95-20-no600.tbcn.telia.com)
L208[21:00:07] <Forecaster> both
PRIMARY_KEY and PRIMARY KEY resulted in errors
L209[21:00:30] <Forecaster> (AUTOINCREMENT
is only allowed on an INTEGER PRIMARY KEY)
L210[21:00:31] <Forecaster> huh
L211[21:00:42] <Forecaster> so there is a
difference between INT and INTEGER then
L212[21:01:10] ⇦
Quits: ForeBot (~ForeBot@81-227-95-20-no600.tbcn.telia.com) (Client
Quit)
L213[21:01:47]
⇨ Joins: ForeBot
(~ForeBot@81-227-95-20-no600.tbcn.telia.com)
L214[21:02:10] <Forecaster>
?testcommand
L215[21:03:10] <Forecaster>
?testcommand
L217[21:03:29]
<Forecaster> okay...
L218[21:03:41]
<Forecaster> seems the only problem was
that I was using INT and not INTEGER...
L219[21:03:54]
<Forecaster> now it works without auto
inc
L220[21:04:04] <Michiyo> huh....
interesting
L221[21:04:05] ⇦
Quits: ForeBot (~ForeBot@81-227-95-20-no600.tbcn.telia.com) (Client
Quit)
L222[21:04:49] <Michiyo> INT is SUPPOSED
to be a synonym for INTEGER...
L223[21:04:51] <Michiyo> so
L224[21:04:52] <Michiyo> Odd.
L225[21:05:12]
<Forecaster> it was the only thing I
changed
L226[21:05:16]
<Forecaster> very weird
L228[21:05:22] <Michiyo> MySQL supports
the SQL standard integer types INTEGER (or INT
L229[21:05:33]
<Forecaster> this is sqlite
L230[21:05:44] <Michiyo> OH, thought you
were on SQL at this point
L231[21:05:44] <Michiyo> lol
L232[21:05:51] <Michiyo> Yeah, fuck that..
:P
L233[21:05:52]
⇨ Joins: ForeBot
(~ForeBot@81-227-95-20-no600.tbcn.telia.com)
L234[21:06:19]
<Forecaster> no, I'm implementing the
interface first
L235[21:06:37]
<Forecaster> it needs to work with sqlite
first, unless you want to migrate the db manually :P
L236[21:07:21] <Forecaster>
?testcommand
L237[21:07:38] <Forecaster> okay, updating
is also working, good
L238[21:08:23] <Forecaster> now the tonk
stuff should work correctly, in theory
L239[21:08:35] <Forecaster> ?tonk
L240[21:08:35] <ForeBot> Yeah!
Forecaster! You beat your own previous record of <0 (By 2
hours, 59 minutes and 19 seconds)! I hope you're happy!
L241[21:08:36] <ForeBot> Forecaster's new
record is 2 hours, 59 minutes and 19 seconds! No points gained for
stealing from yourself. (Lost out on 0.00299)
L242[21:08:54] <Forecaster>
?tonkreseteverything
L243[21:08:55] <ForeBot> Resetting the
tonk scoreboard forever!
L244[21:08:58] <Forecaster> ?tonk
L245[21:08:58] <ForeBot> You got the first
Tonk Forecaster, but this is only the beginning.
L246[21:09:09] <Forecaster> I don't feel
like waiting 3 hours...
L247[21:09:45]
⇨ Joins: Notcaster
(webchat@81-227-95-20-no600.tbcn.telia.com)
L248[21:10:06] <Notcaster> it me
L249[21:10:15] <Notcaster> I mean, who
could I be oooo
L250[21:10:25] <Notcaster> ?tonk
L251[21:10:25] <ForeBot> Woah! Notcaster!
You beat Forecaster's previous record of <0 (By 1 minute and 27
seconds)! I hope you're happy!
L252[21:10:26] <ForeBot> Notcaster's new
record is 1 minute and 27 seconds! Notcaster also gained 0.00002
tonk points for stealing the tonk. Position #-1.
L253[21:10:35] <Notcaster> hm, still doing
that -1 thing
L254[21:11:41] ⇦
Quits: ForeBot (~ForeBot@81-227-95-20-no600.tbcn.telia.com)
()
L255[21:11:58] <Forecaster> ah well,
progress has been made, that'll do for today
L256[21:12:05] ⇦
Quits: Notcaster (webchat@81-227-95-20-no600.tbcn.telia.com)
(Client Quit)