#test | Logs for 2015-10-14
« return
[04:28:59] -!- crutchy_ [crutchy_!~crutchy@135-10-9-848.cust.aussiebb.net] has joined #test
[04:28:59] -!- mode/#test [+v crutchy_] by wheatley
[04:31:16] -!- crutchy has quit [Ping timeout: 264 seconds]
[06:02:28] -!- crutchy_ has quit [Ping timeout: 264 seconds]
[06:02:28] -!- exec has quit [Ping timeout: 264 seconds]
[06:18:58] -!- crutchy_ [crutchy_!~crutchy@709-27-2-01.cust.aussiebb.net] has joined #test
[06:18:58] -!- mode/#test [+v crutchy_] by wheatley
[06:45:02] -!- crutchy_ has quit [Quit: Leaving]
[06:45:26] -!- crutchy [crutchy!~crutchy@709-27-2-01.cust.aussiebb.net] has joined #test
[06:45:26] -!- mode/#test [+v crutchy] by wheatley
[06:48:26] -!- exec [exec!~exec@utioner/T-800/BeVeryAfraid] has joined #test
[06:48:26] -!- mode/#test [+v exec] by wheatley
[07:33:18] BotRoss is now known as VaginaBot
[07:34:02] VaginaBot is now known as BotRoss
[07:36:35] BotRoss is now known as Barrabot
[10:18:04] <crutchy> ~restart
[10:18:06] <exec> successfully saved buckets file (90.6 kb)
[10:18:14] -!- exec has quit [Quit: dafuq]
[10:21:09] -!- exec [exec!~exec@utioner/T-800/BeVeryAfraid] has joined #test
[10:21:09] -!- mode/#test [+v exec] by wheatley
[10:21:13] <crutchy> ~list
[10:21:14] <exec> ~list ~list-auth ~lock ~unlock
[10:21:15] <exec> systemctl ~ ~! ~activity ~addr ~api ~aur ~bitbucket-feed ~cat ~cd ~cid ~civ ~comments ~confucius ~convert ~count ~cowsay ~deb ~define ~define-add ~define-count ~define-delete ~define-sources ~devs ~eds ~exec-issue ~execfs ~feed-list ~filter ~filth ~first ~fortune ~funding ~g ~g'day ~g'night ~gday ~get ~github-feed ~github-list ~gnight ~google ~header ~header-login ~help ~isup ~jisho ~join ~karma ~last ~link ~links ~location ~log ~ls ~md ~mkdir ~moo
[10:21:16] <exec> ~nyse ~openthepodbaydoors ~part ~php ~queue ~quickpoll ~rainbow ~random ~rd ~rehash-issue ~remind ~rmdir ~scramble ~sed ~seen ~set ~shorten ~sizeof ~slashcode-find ~slashcode-issue ~sn-internal ~staff ~submit ~suggest ~suggest-api ~suggest-exec ~suggest-rss ~tell ~time ~time-add ~time-del ~title ~translate ~translate-sl ~uid ~unset ~up ~verifier-nick ~vote ~weather ~weather-add ~weather-del ~weather-old ~weather-prefs ~welcome ~wiki ~yukiku
[10:21:29] <crutchy> systemctl
[10:21:30] <exec> 02trying to ...
[10:21:33] <exec> ...04failed! - use epoch instead: http://universe2.us
[10:21:37] <crutchy> lol
[10:22:17] <crutchy> systemctl fart
[10:22:18] <exec> 02trying to fart ...
[10:22:21] <exec> ...04failed! - use epoch instead: http://universe2.us
[10:23:12] <crutchy> ~sizeof google.com
[10:23:26] <crutchy> ~sizeof
[10:23:47] <crutchy> ~!
[10:23:49] <exec> syntax to search: ~! %search%, set: ~! %id% %content%, delete: ~! %id% -
[10:23:49] <exec> can't use pipe (|) char, %id% can't contain spaces, but %content% can, %search% is a regexp pattern
[10:23:49] <exec> will return a list of one or more %id% => %content% if %search% matches either %id% or %content%
[10:24:04] <crutchy> ~! trains
[10:24:06] <exec> └─ "trains" not found
[10:24:16] <crutchy> ~! .*
[10:24:17] <exec> ├─ NCommander/Youtube/Nethack0 => https://www.youtube.com
[10:24:17] <exec> ├─ NCommander/Youtube/Nethack1 => https://www.youtube.com
[10:24:18] <exec> ├─ alberto_mysql => SELECT * FROM dcp_packages AS p1 LEFT JOIN (SELECT DISTINCT pid,GROUP_CONCAT(DISTINCT description ORDER BY description) as feature_list FROM dcp_packages_features GROUP BY pid ORDER BY pid) AS p2 ON p1.id = p2.pid;
[10:24:19] <exec> ├─ asdf/piano => https://www.youtube.com
[10:24:20] <exec> ├─ asdf/rainbows => https://www.youtube.com
[10:24:21] <exec> ├─ asdf/skateboards => https://www.youtube.com
[10:24:22] <exec> ├─ asdf/turtle => https://www.youtube.com
[10:24:22] <exec> ├─ cartman_stuck_in_cow's_ass => https://www.youtube.com
[10:24:23] <exec> ├─ chromas/SoylentNews/themes/greyscale => http://chromas.0x.no
[10:24:24] <exec> ├─ dev => https://dev.soylentnews.org
[10:24:25] <exec> ├─ epoch => http://universe2.us
[10:24:26] <exec> ├─ erb/bill-gates-steve-jobs => https://www.youtube.com
[10:24:27] <exec> ├─ erb/ghost-mythbusters => https://www.youtube.com
[10:24:28] <exec> ├─ exec/source => https://github.com
[10:25:29] <crutchy> ~ps
[10:25:31] <exec> [17115] php scripts/wiki.php '~ps' '#test' 'crutchy' '~wiki-privmsg'
[10:25:31] <exec> [17120] php scripts/title.php 'event-privmsg crutchy #test ~ps' '~title-internal' '#test' 'crutchy'
[10:25:31] <exec> [17124] php scripts/karma.php 'PRIVMSG ~ps' '#test' 'crutchy' '~karma-internal' 'irc.sylnt.us'
[10:25:31] <exec> [17128] php scripts/privmsg.php '~ps' 'crutchy' '#test'
[10:25:31] <exec> [17132] php scripts/tell.php '~ps' '#test' 'crutchy' '~tell-internal' 'irc.sylnt.us'
[10:25:32] <exec> [17139] php scripts/scripting.php 'event-privmsg crutchy #test ~ps' '' 'exec' '1444817894.1867' '~x' 'INTERNAL' ':exec INTERNAL :~x event-privmsg crutchy #test ~ps' '' '1444818330.6271'
[10:25:33] <exec> [17145] php scripts/forward.php 'event-privmsg crutchy #test ~ps' '' 'exec' '~forward' 'INTERNAL'
[10:25:34] <exec> [17152] php scripts/activity.php 'exec' 'event-privmsg crutchy #test ~ps' '' '1444817894.1867' '~activity' 'INTERNAL'
[10:28:14] <crutchy> ~list-auth
[10:28:15] <exec> ~q ~rehash ~ps ~kill ~killall ~dest-override ~dest-clear ~buckets-dump ~buckets-save ~buckets-load ~buckets-flush ~buckets-list ~restart ~ignore ~unignore
[10:28:15] <exec> ~bucket ~copyright ~define-list ~define-source-edit ~define-source-param ~deop ~devoice ~eval ~event-test ~exec-add ~exec-del ~exec-irc-raw ~exec-save ~feeds ~forward ~freenode ~invite ~ircd ~journals ~kick ~minion ~mysql ~op ~reader ~relay ~say ~slash-test ~soon ~startup ~tests ~topic ~users ~voice ~wiki-privmsg ~x
[10:28:40] <crutchy> ~exec-irc-raw WHOIS exec
[10:28:59] <TheMightyBuzzard> you still bothering poor exec?
[10:29:19] <crutchy> just tidying up some code
[10:29:35] <crutchy> and trying to figure out wtf all these commands might be :/
[10:29:46] <TheMightyBuzzard> heh
[10:30:14] <crutchy> ~mysql
[10:30:26] <TheMightyBuzzard> i was slacking. playing Overlord instead of doing something useful.
[10:30:48] <crutchy> haha
[10:30:52] <crutchy> yeah i should play a game
[10:30:57] <crutchy> ~mysql count
[10:31:14] <TheMightyBuzzard> ~mysql drop table users;
[10:32:07] <crutchy> ~mysql last
[10:32:30] <crutchy> oh bugger. that's why it no worka. damn dest list
[10:32:43] <crutchy> ~rehash
[10:32:55] <exec> successfully reloaded exec file (154 aliases)
[10:33:03] <crutchy> ~mysql count
[10:33:07] <exec> 481515
[10:33:14] <crutchy> ~mysql last
[10:33:17] <exec> :crutchy!~crutchy@709-27-2-01.cust.aussiebb.net PRIVMSG #test :~mysql last
[10:33:36] <TheMightyBuzzard> storing raw messages?
[10:33:46] <crutchy> not sure
[10:33:48] <TheMightyBuzzard> #seen crutchy
[10:33:48] <MrPlow> Wed Oct 14 10:33:46 2015 on #test: not sure
[10:33:58] <crutchy> might be serialized arrays
[10:34:28] <crutchy> yeah i think arrays, cos its outputting the 'raw' element
[10:34:36] <crutchy> s/raw/data/
[10:34:36] <sedctl> <crutchy> yeah i think arrays, cos its outputting the 'data' element
[10:35:36] <TheMightyBuzzard> looks like a raw line of received channel message to me
[10:36:18] <TheMightyBuzzard> smoke break
[10:41:01] <crutchy> ~sql query SELECT * FROM exec_irc_bot.sn_comments WHERE (user="crutchy")
[10:41:48] <crutchy> ~sql query SELECT COUNT(*) FROM exec_irc_bot.sn_comments
[10:42:24] <crutchy> ~sql query SELECT COUNT(*) FROM exec_irc_bot.sn_comments
[10:46:04] <crutchy> ~mysql query SELECT COUNT(*) FROM exec_irc_bot.sn_comments
[10:46:11] <chromas> ~sql query select * from exec_irc_bot.sn_comments limit 1 order by random
[10:47:33] <crutchy> ~mysql query SELECT COUNT(*) FROM exec_irc_bot.sn_comments
[10:47:35] <exec> 31055
[10:47:41] <crutchy> thas betterer
[10:47:54] <crutchy> ~mysql query SELECT * FROM exec_irc_bot.sn_comments WHERE (user="crutchy")
[10:48:19] <crutchy> ~mysql query SELECT * FROM exec_irc_bot.sn_comments WHERE (user="crutchy")
[10:48:23] <crutchy> stupid typos
[10:48:29] <chromas> might be faster if you just select one column
[10:48:40] <chromas> at least, it was for me
[10:48:48] <crutchy> i'm not even sure if it works at all :/
[10:49:07] <crutchy> ~mysql query SELECT * FROM exec_irc_bot.sn_comments WHERE
[10:49:12] <crutchy> derp
[10:49:16] <crutchy> ~mysql query SELECT * FROM exec_irc_bot.sn_comments
[10:49:20] <exec> 1|2015-03-21 12:09:41|Anonymous Coward|0|(Score:0)|0|Uh huh?|cURL turns Seventeen Today|Now it's grown up will it come with a no-nonsense cli program like it's older sibling wget? wget http://example.org Is all I want to know. ---- Something badly wrong with ecode parsing and URL's in plain-text and html modes!|160627|6634|http://soylentnews.org/comments.pl?sid=6634&cid=160627|||https://soylentnews.org/article.pl?sid=15/03/20/1221252&threshold
[10:49:21] <exec> 2|2015-03-21 12:09:42|wonkey_monkey|279|(Score:2)|2|Re:Uh huh?|cURL turns Seventeen Today|Now it's grown up will it come with a no-nonsense cli program like it's older sibling wget?|160632|6634|http://soylentnews.org/comments.pl?sid=6634&cid=160632|160627|http://soylentnews.org/comments.pl?sid=6634&cid=160627|https://soylentnews.org/article.pl?sid=15/03/20/1221252&threshold=-1&highlightthresh=-1&mode=flat&commentsort=0
[10:49:22] <exec> 3|2015-03-21 12:09:43|hemocyanin|186|(Score:2)|2|Re:Uh huh?|cURL turns Seventeen Today|also -o or -O Name the file whatever you want: curl http://example.org [example.org] -o file.ext Use the remote file name: curl http://example.org [example.org] -O|160635|6634|http://soylentnews.org/comments.pl?sid=6634&cid=160635|160632|http://soylentnews.org/comments.pl?sid=6634&cid=160632|https://soylentnews.org/article.pl?sid=15/
[10:49:37] <crutchy> heh. lucky i limited it to 3 records :p
[10:49:47] <chromas> ~sql query select average(score) from exec_irc_bot.sn_comments
[10:49:54] <chromas> uh...huhuhuhuh
[10:49:55] <chromas> score
[10:50:11] * chromas wonders if netflix has beavis and butthead
[10:50:17] <crutchy> hurhurhur... chromas is gunna thcore.. in vegas
[10:50:25] <chromas> they do have the movie
[10:51:01] <chromas> ~sql query select average('Score') from exec_irc_bot.sn_comments
[10:51:18] <chromas> I probably don't even haz permission to sql :0
[10:51:20] <chromas> :)
[10:51:24] <chromas> but I can still spam it :D
[10:51:53] <crutchy> nah you do
[10:52:09] <crutchy> it was ~mysql (i fuked up thing it was ~sql for a while)
[10:52:19] <crutchy> i just added ~sql to do the same :)
[10:52:21] <chromas> I think mysql and postgres have slightly different syntax, especially with quotes
[10:52:25] <crutchy> should work now
[10:52:26] <chromas> ah
[10:52:44] <chromas> ~sql query select average('Score') from exec_irc_bot.sn_comments
[10:53:16] <crutchy> might be lowercase
[10:53:19] <crutchy> score
[10:53:34] <chromas> ~sql query select average('score') from exec_irc_bot.sn_comments
[10:53:48] <crutchy> https://github.com
[10:53:50] <Barrabot> ^ 03exec-irc-bot/schema_comments.sql at master · crutchy-/exec-irc-bot · GitHub
[10:53:50] <chromas> ~sql query select average(`score`) from exec_irc_bot.sn_comments
[10:53:53] <exec> └─ 13exec-irc-bot/schema_comments.sql at master · crutchy-/exec-irc-bot · GitHub
[10:54:04] <chromas> I'm not even sure if it's a valid query
[10:54:06] <crutchy> ~title off
[10:54:07] <exec> titles disabled for 10#test
[10:54:19] <crutchy> hmm. i might be able to output error info
[10:54:44] <chromas> ~sql query select `score` from exec_irc_bot.sn_comments limit 1
[10:54:46] <exec> (Score:-1, Disagree)
[10:54:50] <chromas> ooh
[10:54:55] <chromas> oh!!
[10:54:57] <chromas> it's a string
[10:55:00] <chromas> can't average that
[10:57:04] <chromas> well the next field's a number, even if it's still a string
[10:57:11] <chromas> ~sql query select `Score` from exec_irc_bot.sn_comments limit 1
[10:57:13] <exec> (Score:-1, Disagree)
[10:57:23] <crutchy> ~sql query select `score_num` from exec_irc_bot.sn_comments limit 1
[10:57:27] <exec> -1
[10:57:28] <chromas> ~sql query select 5 from exec_irc_bot.sn_comments limit 1
[10:57:30] <chromas> ah
[10:57:33] <exec> 5
[10:57:53] <crutchy> ~sql query select average(`score_num`) from exec_irc_bot.sn_comments limit 1
[10:58:13] <crutchy> ~sql query select average(`score_num`) from exec_irc_bot.sn_comments
[10:58:33] <chromas> ~sql query select sum(`score_num`) from exec_irc_bot.sn_comments
[10:58:34] <exec> 43292
[10:58:40] <chromas> ~sql query select avg(`score_num`) from exec_irc_bot.sn_comments
[10:58:41] <crutchy> ~g mysql average
[10:58:44] <exec> [google] https://dev.mysql.com
[10:58:44] <exec> 1.39404282724199
[10:58:48] <crutchy> lol
[10:58:55] <chromas> needs moar precision
[10:58:56] <crutchy> wholly shat :)
[10:59:36] <chromas> does your db store the entire comments?
[10:59:46] <chromas> could be a nifty chatterbot source
[11:00:09] <crutchy> yeah in comment_body
[11:00:17] <crutchy> its only truncated in #comments
[11:00:54] <chromas> ~sql query select `Comment` from exec_irc_bot.sn_comments limit 1
[11:01:04] <crutchy> ~sql query select count(id) from exec_irc_bot.sn_comments where (score_num=5)
[11:01:06] <exec> 355
[11:01:12] <chromas> ~sql query select `Comment_body` from exec_irc_bot.sn_comments limit 1
[11:01:16] <exec> Now it's grown up will it come with a no-nonsense cli program like it's older sibling wget? wget http://example.org Is all I want to know. ---- Something badly wrong with ecode parsing and URL's in plain-text and html modes!
[11:01:31] <crutchy> oh yeah ciri would eat that up :p
[11:02:23] <chromas> ~sql query select concat('ciri: ', select `Comment_body` from exec_irc_bot.sn_comments limit 1)
[11:02:29] <chromas> aw
[11:02:50] <chromas> of course, if it's built in then you wouldn't need the extra query cruft
[11:03:00] <crutchy> ~sql query select comment_body from exec_irc_bot.sn_comments where (comment_body='*ciri*') limit 1
[11:03:26] <chromas> ~sql query select concat('ciri: ', (select `Comment_body` from exec_irc_bot.sn_comments limit 1))
[11:03:28] <exec> ciri: Now it's grown up will it come with a no-nonsense cli program like it's older sibling wget? wget http://example.org Is all I want to know. ---- Something badly wrong with ecode parsing and URL's in plain-text and html modes!
[11:03:42] <chromas> ~sql query select concat('ciri: ', (select `Comment_body` from exec_irc_bot.sn_comments order by random limit 1))
[11:03:58] <chromas> dun brokeit
[11:04:12] <chromas> ~sql query select concat('ciri: ', (select `Comment_body` from exec_irc_bot.sn_comments limit 1 order by random))
[11:04:13] <crutchy> ~sql query select comment_body from exec_irc_bot.sn_comments where (comment_body like '%ciri%') limit 1
[11:04:15] <exec> ciri: tama lama ding dong ping pong
[11:04:25] <crutchy> ~sql query select comment_body from exec_irc_bot.sn_comments where (comment_body like '%fart%') limit 1
[11:04:27] <exec> So I take it Iceland is such a great place they have solved all other pressing problems and a quarter of the country can make copyrights their most pressing issue? Not sure if that makes me want to move there, after all it must be a utopia, or if it would be so boring that it would be a bad idea. Oh crap, Google to the rescue. Seems Iceland really does have some serious problems but I guess they would prefer to ignore all that and fart around with the
[11:04:27] <chromas> maybe can't order by random
[11:05:22] <chromas> ~sql query select concat('ciri: ', (select `Comment_body` from exec_irc_bot.sn_comments limit 1 order by random()))
[11:05:23] <crutchy> ~sql query select comment_body from exec_irc_bot.sn_comments where (comment_body like '%fart%') limit 1 order by rand()
[11:05:41] <crutchy> ~sql query select comment_body from exec_irc_bot.sn_comments where (comment_body like '%fart%') order by rand() limit 1
[11:05:43] <exec> So if I fart and my neighbor can smell it can I be fined?
[11:05:48] <crutchy> ~sql query select comment_body from exec_irc_bot.sn_comments where (comment_body like '%fart%') order by rand() limit 1
[11:05:50] <exec> My fart could asphyxiate your ass. SN is getting worse and worse.
[11:05:55] <crutchy> ~sql query select comment_body from exec_irc_bot.sn_comments where (comment_body like '%fart%') order by rand() limit 1
[11:05:58] <exec> 2014 MU69 is a rather insignificant space rock of perhaps 40 km in diameter, completing a full orbit in 300 years. Once visited, it will have the distinction of being the farthest object ever visited by a spacecraft for at least 30 more years, unless a chance discovery reveals another object in New Horizon's path.
[11:06:03] <crutchy> hehe
[11:06:03] <chromas> :D
[11:06:18] <chromas> exec++
[11:06:20] <chromas> ++exec
[11:06:21] <Barrabot> Karma - exec: 71
[11:06:30] <crutchy> .macro .soylentfart * privmsg ~sql query select comment_body from exec_irc_bot.sn_comments where (comment_body like '%fart%') order by rand() limit 1
[11:06:31] <exec> 02 *** macro with trigger ".soylentfart" and PRIVMSG command template "~sql query select comment_body from exec_irc_bot.sn_comments where (comment_body like '%fart%') order by rand() limit 1" saved
[11:06:35] <crutchy> .soylentfart
[11:06:37] <exec> ~sql query select comment_body from exec_irc_bot.sn_comments where (comment_body like '%fart%') order by rand() limit 1
[11:06:40] <exec> The math says it is feasible. It seems a bit cantankerous old fart do want something to be abandoned and never worked on a gain just because you don't understand it.
[11:06:59] <crutchy> .macro .soylentfart * internal ~sql query select comment_body from exec_irc_bot.sn_comments where (comment_body like '%fart%') order by rand() limit 1
[11:07:00] <exec> 02 *** macro with trigger ".soylentfart" and INTERNAL command template "~sql query select comment_body from exec_irc_bot.sn_comments where (comment_body like '%fart%') order by rand() limit 1" saved
[11:07:04] <crutchy> .soylentfart
[11:07:06] <exec> My cat is a dog in that respect. It starts crying like a baby when you leave the house, and I don't mean sobbing or anything like that but really screaming like a little kid. When I come home she's usually lying on the doormat. When my wife walks to work (only a block away) she walks along to the farthest corner in her territory and starts screaming there. It nuts, really, and also a little funny. She's also a naughty cat. Yes you are, yes you are a na
[11:07:13] <crutchy> .soylentfart
[11:07:18] <exec> Beans, yeah. If it's all the same methane, why let cows have all the fun when we can fart to our stomach's content?
[11:07:26] <crutchy> lol
[11:08:05] <chromas> .soylentfart
[11:08:18] <crutchy> ...
[11:08:20] <chromas> .soylentfart
[11:08:22] <exec> So I take it Iceland is such a great place they have solved all other pressing problems and a quarter of the country can make copyrights their most pressing issue? Not sure if that makes me want to move there, after all it must be a utopia, or if it would be so boring that it would be a bad idea. Oh crap, Google to the rescue. Seems Iceland really does have some serious problems but I guess they would prefer to ignore all that and fart around with the
[11:08:42] <crutchy> dunno why first one no worka :/
[11:08:48] <crutchy> .soylentfart
[11:08:50] <exec> I believe in renewables, and feel that it's important --- I'm just curious as to what the state of currently available technology. Hydro, as I noted farther down provides ~4% of Kentucky's power, and they generate more than half of the hydro power in the U.S. What are the renewable solutions for Kentucky (and its industry)?
[11:09:17] <crutchy> where's the fart in that?
[11:09:22] <crutchy> oh
[11:09:25] <crutchy> 'farther'
[11:10:14] <chromas> also Kentucky
[11:10:18] <crutchy> lol
[11:10:40] <crutchy> Kentucky Fart Chicken
[21:43:52] -!- exec has quit [Ping timeout: 264 seconds]
[21:44:28] -!- crutchy has quit [Ping timeout: 264 seconds]
[21:52:36] -!- crutchy [crutchy!~crutchy@135-10-9-848.cust.aussiebb.net] has joined #test
[21:52:36] -!- mode/#test [+v crutchy] by wheatley
[21:55:47] -!- exec [exec!~exec@utioner/T-800/BeVeryAfraid] has joined #test
[21:55:47] -!- mode/#test [+v exec] by wheatley