irclog2html for #bzmods on 20061025

00:00.19blast007I made a set of functions that handle all my database operations
00:00.46CBG:( I don't get functions at all... :/
00:01.03blast007then you won't understand classes either  :)
00:01.12CBGyep
00:01.17blast007I have a dbinterface class that contains all those functions
00:01.33CBGbut either way, how do I see that somethng exists or not in the database?
00:01.51blast007mysql_num_rows($result) == 0
00:02.17blast007or if your mysql_fetch_assoc($result) returns false
00:03.12blast007but really, you should work on the basics before writing a bot
00:04.06CBGssh :P
00:04.14CBGthis WAS a way to work on the basics
00:04.20CBGlike, ifs, arrays, etc
00:04.30CBGI did already make a guestbook :D
00:05.02CBGwhich was pretty good imho
00:05.08CBGhttp://becounted.info/gb/gb1.php if you care
00:14.30*** join/#bzmods oobeb (n=oobeb@cpc4-stme1-0-0-cust103.cdif.cable.ntl.com)
00:14.42blast007+hate
00:14.44oobebomfg 1 hatez j00!!!!!!!!!1111111oneoneoneeleven
00:15.28CBG+dislike is <action> looks away.
00:15.34CBG+dislike
00:15.40CBGhmm
00:16.03CBG+love is good
00:16.04oobebCBG: love already exists.
00:16.08blast007:)
00:16.11blast007clower
00:16.13blast007closer*
00:16.16CBGsomething works.
00:16.35blast007make it message the channel when it detects it should create a factoid
00:17.01blast007or just make it: echo "\n\nHAHA\n\n";
00:17.09CBGYeah, I'm about to.
00:17.28blast007I use 'haha' and 'hehe' a lot in debug output  :P
00:17.50CBGlol..
00:17.55blast007and that too
00:18.27CBGIn my terminal I see "blast007!i=1000@pdpc/supporter/active/blast007" for example...
00:18.28blast007I think I even used ROFLCOPTER once
00:18.36CBG$data->nick = blast007
00:18.49CBG$data->host = pdpc/supporter/active/blast007
00:18.58CBGhow do I get that whole string? what's the var?
00:19.05blast007what whole string?
00:19.06blast007oh
00:19.31CBGfor: "blast007!i=1000@pdpc/supporter/active/blast007"
00:19.37CBGor combination of vars
00:20.53blast0071 sec
00:21.17CBGthnx, I'm too tired to go hunting for it
00:25.26blast007$data->nick."!".$data->ident."@".$data.host
00:26.10CBGthanks!
00:26.29CBGso if I am inserting that, do I put it all in single quotes?
00:26.55blast007nope
00:27.05CBG"INSERT INTO factoids (name, value, creator) VALUES ('$parts[0]', '$parts[1]', '$data->nick."!".$data->ident."@".$data.host')" or..?
00:27.15CBGdo any of the values need be in single quotes?
00:27.35blast007oh, you're doing it like that..
00:28.03CBG$add = "INSERT INTO .....";
00:28.04CBGmysql_query($add);
00:28.16CBGI'm doing it like that...
00:28.25blast007"INSERT INTO factoids (name, value, creator) VALUES ('$parts[0]', '$parts[1]', '{$data->nick}!{$data->ident}@{$data->host}')"
00:28.39CBGo.O ok thanks..
00:28.40blast007(I had a brain fart when I did $data.host  ;)
00:28.54blast007the { and } might not be necessary, but I'm not sure
00:29.11blast007the -> might throw off PHP's automatic parsing
00:31.57CBGlet's see :)
00:32.04*** join/#bzmods oobeb (n=oobeb@cpc4-stme1-0-0-cust103.cdif.cable.ntl.com)
00:32.09CBG+ping
00:32.09oobebPong, CBG.
00:32.12CBG+love
00:32.17CBG+love is bad
00:32.18oobebCBG: love already exists.
00:32.31CBG+dislike is <action> looks away.
00:32.31oobebCBG: dislike added!
00:32.37CBG+dislike
00:33.06CBGOct 25 01:32:26 SmartIRC.php(1568) received: ":CBG!n=CBG@about/essy/fan/CBG PRIVMSG #bzmods :+dislike"
00:33.06CBGOct 25 01:32:27 SmartIRC.php(1495) sent: "PRIVMSG #bzmods :"
00:33.06CBGOct 25 01:32:27 SmartIRC.php(1568) received: ":kornbluth.freenode.net 412 oobeb :No text to send"
00:33.07CBGOct 25 01:32:27 SmartIRC.php(1854) replycode UNKNOWN (412): ":kornbluth.freenode.net 412 oobeb :No text to send"
00:36.38*** join/#bzmods oobeb (n=oobeb@cpc4-stme1-0-0-cust103.cdif.cable.ntl.com)
00:36.48CBG+ping
00:36.48oobebCBG: Yo, 'sup m' homie?
00:36.52CBG+like
00:37.01CBG+likeuhoh
00:37.04CBGuhoh*
00:38.00*** join/#bzmods oobeb (n=oobeb@cpc4-stme1-0-0-cust103.cdif.cable.ntl.com)
00:38.09CBG+like
00:38.10oobebI like you too!
00:38.19CBG+like is good
00:38.20oobebCBG: like already exists.
00:38.24CBG+dislike is good
00:38.25oobebCBG: dislike already exists.
00:38.29CBG:/
00:38.34CBG+hrchj is good
00:38.34oobebCBG: hrchj added!
00:38.38CBG+dislike
00:38.43CBG:/
00:38.46CBG+hrchj
00:38.50CBG:/
00:39.04CBGOct 25 01:38:36 SmartIRC.php(1495) sent: "PRIVMSG #bzmods :"
00:39.07CBGnot sending anything
00:46.57blast007check the database
00:47.01blast007see if it inserted properly
00:47.16blast007(via the command line mysql)
00:47.20CBGthey certainly seem too
00:47.25CBGwhich is a great sign.
00:47.53CBGbut therefor, why can't it display the value?
00:47.58CBGlike it can for old factoids?
00:51.43blast007print_r can write out the contents of an array
00:51.45CBGah, might be user error
00:51.47blast007print_r($row)
00:51.48blast007oh
00:51.51CBGhold on
00:52.06*** join/#bzmods oobeb (n=oobeb@cpc4-stme1-0-0-cust103.cdif.cable.ntl.com)
00:52.10CBG+like
00:52.14oobebI like you too!
00:52.26CBG+dance is <action> dances
00:52.27oobebCBG: dance added!
00:52.31CBG+dance
00:52.36CBGyeah
00:52.39CBGi'm stupid.
00:52.52CBGyou HAVE to add <reply>
00:53.02CBGor <action>
00:53.55blast007does your bot support multiple word factoids?
00:54.09CBGnope
00:54.11blast007neither does mine  :(
00:54.28CBGthe problem was/is this:  list($ftype, $fmsg) = explode(" ", $row["value"], 2);
00:54.28blast007I'd have to do some regex trickery to get that
00:54.46blast007you could store them in seperate columns too
00:55.02CBGwell, it's all of this really:
00:55.04CBGlist($ftype, $fmsg) = explode(" ", $row["value"], 2);
00:55.06CBGif ($ftype == "<action>") { $irc->message(SMARTIRC_TYPE_ACTION, $data->channel, $fmsg); }
00:55.08CBGelse { $irc->message(SMARTIRC_TYPE_CHANNEL, $data->channel, $fmsg); }
00:55.49CBGif I do: "+this is that" then $row[value] == "that"
00:56.05CBGso when I explod, $ftype = "that" and $fmsg is empty
00:56.16CBGso <reply> is required
00:57.35blast007CREATE TABLE `factoids` (
00:57.35blast007<PROTECTED>
00:57.35blast007<PROTECTED>
00:57.35blast007<PROTECTED>
00:57.38blast007<PROTECTED>
00:57.40blast007<PROTECTED>
00:57.43blast007<PROTECTED>
00:57.45blast007<PROTECTED>
00:57.48blast007<PROTECTED>
00:57.51blast007<PROTECTED>
00:57.53blast007<PROTECTED>
00:57.56blast007)
00:58.01CBGo.O
00:58.10CBGI just got: name, value, creator and date.
00:58.11blast007name is what people call
00:58.33CBG255 char factoids, eh? ;)
00:59.06CBGhow do I say if(this == that AND (a = x OR b = z) ) ?
01:01.02blast007if ($this == $that && ($a == $x || $b == $z) )
01:01.36CBGso, exactly how I had it..? (but with correct syntax) ..
01:02.02blast007yeah
01:02.38CBG*sigh*
01:03.05CBGah, I shouldn't do that anyway
01:03.12CBGI should nest (another) if
01:03.53CBGman, I got nested ifs like 8 layers deep :/
01:03.58blast007eh
01:04.00blast007why?
01:04.11CBGI should start using spaces instead of tabs.
01:04.18blast007oh, you don't know about switch statements, do you?
01:05.23blast007http://www.tizag.com/phpT/switch.php
01:07.29CBGI do know of switch statements
01:07.37CBGbut I'm too far gone to change it all now
01:07.49blast007heh
01:07.50CBG[2:03am] <blast007> why?  -- 'cause I'm a shitty coder? ;)
01:08.03blast007nah, I didn't have to ask why
01:09.44CBG:P
01:10.10*** join/#bzmods oobeb (n=oobeb@cpc4-stme1-0-0-cust103.cdif.cable.ntl.com)
01:10.52CBG+test test
01:10.55CBG+test is test
01:10.56oobebCBG: test added!
01:10.59CBGdang
01:11.02CBG+like
01:11.03oobebI like you too!
01:11.05CBG+dislike
01:11.18CBG+dislike is <reply> bad thing to
01:11.18oobebCBG: dislike already exists.
01:11.22CBG+dislike
01:11.32CBG+like is this
01:11.32oobebCBG: like already exists.
01:11.44CBG+poopy is <reply> pooooooopy
01:11.45oobebCBG: poopy added!
01:11.51CBG+poopy
01:12.00CBGo.O
02:28.55CBG+lala is <action> sings loudly lala
02:28.56oobebCBG: lala added!
02:28.59CBG+lala
02:29.02CBG:/
13:21.23*** join/#bzmods CBG (n=CBG@about/essy/fan/CBG)
13:21.24*** mode/#bzmods [+o CBG] by ChanServ
14:59.46*** join/#bzmods oobeb (n=oobeb@cpc4-stme1-0-0-cust103.cdif.cable.ntl.com)
15:11.31CBG++abc is <reply 123 lala ok
15:11.31oobebCBG: abc added!
15:11.38CBG++abcd is <reply> 123 lala ok
15:11.39oobebCBG: abcd added!
15:11.49CBG++1234 is <action> abc lala ok
15:11.49oobebCBG: 1234 added!
15:11.53CBG++abcd
15:11.58CBG++1234
15:12.14CBGsending an action for both
15:12.20CBGand a blank action at that
15:12.36CBGbecause that is what has been added to the database :/
15:12.47CBGso the INSERT part is broke
15:12.51CBGit's SELECTING correctly
15:19.35blast007yup
15:20.11CBGI'm working on it. :|
15:20.17CBGProbably some screwed up SQL
15:20.21CBGI'm not so good at that
15:20.28CBGbut hey, I'm not so good at PHP either
15:20.31CBGso could be that.
15:20.43CBGIn summary, SOMETHING I did is broken.
15:21.46blast007>this is that
15:21.52blast007oh
15:21.59*** join/#bzmods Argooon (i=1000@24-196-92-143.dhcp.mdsn.wi.charter.com)
15:22.01blast007>this is that
15:22.04ArgooonFactoid created.
15:22.11blast007>literal this
15:22.12Argooon"this" is "<normal> that"
15:22.49blast007make it default to <normal> if they don't specify either <reply> or <action>
15:23.20blast007<normal> responds with <factoid name> is/are/was/were <factoid definition>
15:23.33blast007<reply> responds with just <factoid definition>
15:23.56blast007do you store the is/are/was/were part?
15:24.23CBGbut <normal> isn't same as <reply> ?
15:24.30blast007no
15:24.30CBGah, ok
15:24.34CBGI see
15:24.45CBGsorry, I replied after reading only half your messages
15:24.49blast007:)
15:24.55CBGright, good idea.
15:25.16blast007I also store my <normal> stuff in a seperate column in my factoids table
15:25.49blast007so that one column stores either normal, reply, or action
15:26.04CBGyeah, but I can work around that easily
15:26.12blast007and then I have a column that stores either 'is', 'are', 'was', 'were'
15:26.19blast007>we were going away
15:26.20ArgooonFactoid created.
15:26.22blast007>we
15:26.23CBGo.O
15:26.23Argooonwe were going away
15:26.28blast007>literal we
15:26.29Argooon"we" is "<normal> going away"
15:27.16CBGhumm
15:30.43blast007+------+----------------+-------------+------------+-------+-----------+------------+----------+
15:30.46blast007| name | definitiontype | messagetype | definition | karma | requested | created    | creator  |
15:30.46CBGHmm, at some point last night I added an iff
15:30.49blast007+------+----------------+-------------+------------+-------+-----------+------------+----------+
15:30.52blast007| we   | were           | <normal>    | going away |     0 |         1 | 1161789993 | blast007 |
15:30.55blast007+------+----------------+-------------+------------+-------+-----------+------------+----------+
15:31.16CBGif the user does not use <repely> or <action> it doesn't add it.
15:31.18CBGit is now
15:31.35CBGkarma..?
15:31.43blast007yeah...I don't like that in there anymore
15:31.47CBGrequested is a good idea, I didn't think of that.
15:31.48blast007I want to seperate karma
15:32.02CBGkarma would be a separate table
15:32.05blast007yeah
15:32.10blast007that's how it _should_ be  ;)
15:32.14CBG:)
15:32.32CBGhow does one add a column to a table?
15:32.39blast007phpmyadmin
15:32.41blast007;)
15:32.45CBG....
15:32.50blast007there is a way of course
15:32.55blast007with ALTER TABLE
15:32.58CBGi'll find it
15:32.59blast007read the docs on that
15:33.03CBGah, k ty
15:33.10CBGfirst, lets fix what I have so far
15:34.16CBGbollocks
15:34.31CBGI had an if(this = that OR that = this)...
15:34.36blast007lol
15:34.38CBGwith single ='s ...
15:34.40CBGFUCK
15:34.42CBGI always do that.
15:34.47blast007I've done that too
15:35.02CBGI've done it 10 times on everyone php thing I ever did...
15:35.04CBG*sigh*
15:35.06blast007I've sat for hours playing with the code trying to fix it....then I see what I did...
15:35.13CBGyeah
15:35.41blast007cuz when you have several thousand lines of code in multiple files, it can hard to pin down an issue like that
15:35.57CBGheh
15:36.11CBGI once had a vb script that was several thousand lines
15:36.29CBGit was for coursework. My teacher refused to show me how to do a loop.
15:36.31blast007wait...VB? I thought you were a mac person!
15:36.38blast007heh
15:36.52CBGSo I copied a block of code 100 times changing 2 numbers each time.
15:37.03CBGheh, it was for ICT coursework last year
15:37.09blast007someone at my college (several years before me) had written an appliction for class
15:37.15CBGexcel macro
15:37.29blast007he had like 20,000 lines of code, because he DIDN'T use a loop
15:37.34CBGheh
15:37.40CBGyeah. loops are good.
15:37.41blast007he could have done the whole thing in like 200 lines
15:37.49blast007he had to rewrite it  :)
15:37.54CBGheh
15:38.06blast007the sad part is that he wrote the long one
15:38.11CBGI bet I lost 10 marks on my coursework 'cause that teacher was a bitch
15:38.20blast007heh
15:38.28blast007anyway, gotta get ready for work
15:38.32CBGheh
15:53.11*** join/#bzmods oobeb (n=oobeb@cpc4-stme1-0-0-cust103.cdif.cable.ntl.com)
15:53.28CBG+ping
15:53.28oobebPong, CBG.
15:53.31CBG+love
15:53.50CBG+love2 is <action> makes bad love to the speaker
15:53.51oobebCBG: Please use the correct <reply> or <action> syntax.
15:53.58CBG:( I did...
16:40.35*** join/#bzmods oobeb (n=oobeb@cpc4-stme1-0-0-cust103.cdif.cable.ntl.com)
16:41.53CBG+love
16:41.55CBG+love2
16:42.06CBG+love2 is <reply> i lub u 2
16:42.06oobebCBG: Please use the correct <reply> or <action> syntax.
16:42.12CBG+love2 is <action> i lub u 2
16:42.12oobebCBG: Please use the correct <reply> or <action> syntax.
16:50.55*** join/#bzmods oobeb (n=oobeb@cpc4-stme1-0-0-cust103.cdif.cable.ntl.com)
16:51.39CBG+love
16:51.42CBG+love2
16:51.45CBG+love2 is <action> i lub u 2
16:51.46oobebCBG: love2 added!
16:51.48CBG+love2
16:51.52CBG:D
16:52.02CBG+love3 is <reply> reply love 3 lal
16:52.02oobebCBG: love3 added!
16:52.05CBG+love3
16:52.06oobebreply love 3 lal
16:53.09CBG+love4 is a mistake, broken
16:53.09oobebCBG: Please use the correct <reply> or <action> syntax.
16:53.13CBGsweet
16:53.17CBGall seems to work ;)
20:00.18*** join/#bzmods blast007_ (i=1000@pdpc/supporter/active/blast007)
22:37.43*** topic/#bzmods by CBG -> http://www.bash.org/?703054
23:22.58CBGOooh, factoid support is coming along NICELY.
23:23.05CBGLet's see what it can do now!
23:23.19*** join/#bzmods oobeb (n=oobeb@cpc4-stme1-0-0-cust103.cdif.cable.ntl.com)
23:23.24CBG+ping
23:23.24oobebPong, CBG.
23:23.27CBG+love
23:23.40CBG+love is <action> sings a love song.
23:23.40oobebCBG: love already exists.
23:23.45CBG+no, love is <action> sings a love song.
23:23.45oobebCBG: love changed!
23:23.49CBG+love
23:23.52CBGW00t!!!
23:23.54CBGomfg!!
23:23.57CBGit WORKS!!
23:24.08CBG+no, newthing is <action> sings a love song.
23:24.08oobebCBG: newthing does not exist.
23:24.12CBG:D
23:24.17CBG+newthing is <action> sings a love song.
23:24.17oobebCBG: newthing added!
23:24.28CBG+newthing
23:24.28CBG+newthing
23:24.29CBG+newthing
23:24.50CBGbah, seems not
23:25.32CBGshould do this time...
23:25.41CBGthen I just need factinfo and literal
23:25.58*** join/#bzmods oobeb (n=oobeb@cpc4-stme1-0-0-cust103.cdif.cable.ntl.com)
23:26.02CBGboth relatively easy to do, now the database is set and I'm getting to grips with sql
23:26.05CBG+newthing
23:26.06CBG+newthing
23:26.07CBG+newthing
23:26.08CBG+newthing
23:26.24CBGargh, still not working :/
23:27.23CBGwhile ($row = mysql_fetch_assoc($result))
23:27.23CBG{
23:27.23CBG$req = $row["requests"];
23:27.24CBG$nreq = $req++;
23:27.24CBG$increase = "UPDATE factoids SET requests = '$nreq' WHERE name='$factname'";
23:27.24CBG$increquests = mysql_query($increase) or die(mysql_error());
23:27.37CBGblast007: ^ why won't that work? :(
23:34.55CBG!invite piratepenguin
23:36.47CBG!invite #bzmods piratepenguin
23:36.51CBG!invite piratepenguin #bzmods
23:45.35blast007CBG: I'll show you an easier query
23:46.02CBGk..
23:46.12blast007I think this works anyway...
23:46.42blast007"UPDATE factoids SET requests = requests + 1 WHERE name='$factname'"
23:47.52CBGahhh, that's not the problem anyway
23:48.05CBGI need an ; inside the " qoutes
23:48.15CBGlike so:  $increase = "UPDATE factoids SET requests = '$nreq' WHERE name='$factname';";
23:48.24CBGbut your way is nicer anyway, if it works
23:49.40CBGactually.. :/ no, i don't need the ; :/
23:50.34blast007my DBInterface doesn't do it that way, because it's more generic
23:50.35*** join/#bzmods oobeb (n=oobeb@cpc4-stme1-0-0-cust103.cdif.cable.ntl.com)
23:50.38blast007it just let's me set it
23:50.54blast007isn't targeted at just incrementing by one
23:51.07blast007(so that I can use the same function to reset the count if necessary)
23:51.16CBG+love
23:51.18CBGuh, I broke it..
23:51.20CBGuh, I broke ping
23:51.22CBG+ping
23:51.22oobebPong, CBG.
23:51.24CBGahh, there.
23:51.26CBG+love
23:51.31CBG+love
23:51.32CBG+love
23:51.38CBGit works... yay
23:51.40CBGthnx blast007
23:51.57blast007+cheesewiz is <action> takes a wiz on some cheese
23:51.57oobebblast007: cheesewiz added!
23:52.02blast007+cheesewiz
23:53.33CBG:D
23:57.26blast007+forget cheesewiz
23:57.43CBGah, yeah, need that
23:57.49blast007+forget is <reply> I can't find my keys
23:57.50oobebblast007: forget added!
23:57.57blast007+forget
23:58.00blast007;)
23:58.06CBGcrap..
23:58.14CBG:/
23:58.33CBGit didn't add it
23:58.49CBG>:(
23:59.34blast007and I know why  ;)
23:59.47CBGoh, hmm
23:59.50CBGforget is an SQL thing?
23:59.54blast007no

Generated by irclog2html.pl by Jeff Waugh - find it at freshmeat.net! Modified by Tim Riker to work with blootbot logs, split per channel, etc.