| 00:48.32 | CBG | blast007: did you pass out?! |
| 01:35.11 | blast007 | CBG: no, I was in a meeting at work, then I went home, and I started building my computer |
| 01:35.19 | CBG | pfffff |
| 01:35.28 | CBG | what a lousy bunch of excuses! |
| 01:35.50 | blast007 | I have the mobo, CPU, video card, and RAM in the system :D |
| 01:36.12 | blast007 | now I need to install the PSU, hard drive, DVD-RW, and....hmm, I think that's it |
| 01:36.49 | CBG | !!msg ##essy Oh yes it was!! |
| 01:37.14 | CBG | well, FINALLY got mysql and apache to RUN |
| 01:37.27 | CBG | recreating database so I can test if it works with fatso... |
| 01:39.17 | blast007 | I should play Descent II on my Core 2 Duo ;) |
| 01:39.23 | blast007 | ultimate irony |
| 01:39.27 | CBG | heh |
| 01:39.42 | blast007 | or I suppose the ultimate irony would be playing the original pong |
| 01:39.59 | CBG | yeah |
| 01:40.04 | CBG | on a Quad |
| 01:40.11 | CBG | with 16GB Ram |
| 01:40.17 | blast007 | nah, 8 way opteron |
| 01:40.28 | blast007 | each is dual core I think |
| 01:40.32 | blast007 | so 16 cores |
| 01:40.37 | CBG | heh |
| 01:40.50 | blast007 | and like 8GB of RAM per CPU (or is it per core? I forget) |
| 01:41.29 | *** join/#bzmods oobeb (n=oobeb@cpc4-stme1-0-0-cust103.cdif.cable.ntl.com) |
| 01:41.32 | CBG | ++ping |
| 01:41.32 | oobeb | Pong, CBG. |
| 01:41.32 | CBG | +hug |
| 01:41.36 | CBG | +other |
| 01:41.39 | CBG | weee |
| 01:41.58 | CBG | Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in SmartIRC-0.5.5/dbconnect.txt on line 7 |
| 01:41.59 | CBG | Client does not support authentication protocol requested by server; consider upgrading MySQL client |
| 01:42.01 | CBG | FUUUUUCK |
| 01:42.09 | blast007 | haha |
| 01:42.14 | blast007 | niiiice |
| 01:42.34 | CBG | How fucking long has it taken me to get a new mysql version to work..? :/ |
| 01:42.39 | CBG | bastard. |
| 01:42.40 | blast007 | do you have the openssl extension loaded in php.ini |
| 01:42.45 | blast007 | ? |
| 01:42.48 | CBG | the what? |
| 01:42.55 | blast007 | openssl |
| 01:43.02 | blast007 | I wonder if that was the problem |
| 01:43.10 | CBG | .. no idea |
| 01:43.21 | blast007 | actually, let me google that error |
| 01:44.00 | CBG | no "openssl" or even "ssl" in my php 5 php.ini |
| 01:46.10 | blast007 | do a phpinfo() page and tell me the MySQL client version |
| 01:47.04 | CBG | k |
| 01:47.14 | blast007 | "client API version" down in the "mysql" section |
| 01:47.57 | CBG | 5.0.19 |
| 01:48.13 | blast007 | hmm, ok |
| 01:48.42 | blast007 | what version of mysql is running? |
| 01:49.00 | CBG | ...? not 5.0.19 ? |
| 01:49.11 | blast007 | client API is the client |
| 01:49.20 | blast007 | I want the server version, in case it's different |
| 01:49.43 | CBG | where would it say? |
| 01:50.09 | CBG | phpinfo is at http://localhost:8888/info.php btw |
| 01:50.14 | CBG | uhh... my ip:8888 |
| 01:50.24 | CBG | cbg.sh.nu:8888/info.php |
| 01:51.00 | blast007 | oh, wait..before, you had 5.0.19 as well |
| 01:51.11 | blast007 | from that telnet you pasted |
| 01:51.13 | blast007 | hmm :/ |
| 01:51.26 | blast007 | the issue is the password that is being used |
| 01:51.27 | CBG | :/ |
| 01:51.38 | CBG | This is MAMP 1.3, I had 1.2 before. |
| 01:51.41 | CBG | 1.4 was fucked. |
| 01:51.49 | blast007 | but based on the version of the client, this should work |
| 01:51.53 | CBG | I even tried "MAMPstack" with no success. |
| 01:52.08 | CBG | oh, ok, I'll check my data. |
| 01:53.03 | blast007 | http://www.digitalpeer.com/id/mysql |
| 01:53.33 | CBG | the MAMP page tells me exactly how to connect to MySQL, I copied and pasted the line... restarteding bot |
| 01:53.37 | *** join/#bzmods oobeb (n=oobeb@cpc4-stme1-0-0-cust103.cdif.cable.ntl.com) |
| 01:54.01 | blast007 | they're probably liars |
| 01:54.05 | CBG | +ping |
| 01:54.05 | oobeb | Whaddaya want, CBG? |
| 01:54.08 | CBG | +other |
| 01:54.21 | CBG | Parse error: parse error in /Users/Matthew/SmartIRC-0.5.5/dbconnect.txt on line 7 |
| 01:54.22 | CBG | <PROTECTED> |
| 01:54.44 | blast007 | :/ |
| 01:54.45 | blast007 | what is on line 7? |
| 01:54.47 | blast007 | or 6 to 8, actually |
| 01:55.00 | CBG | oh, damn.. |
| 01:55.02 | CBG | a ; in middle of the line |
| 01:55.04 | CBG | It was a random ; , thats all. |
| 01:55.36 | *** join/#bzmods oobeb (n=oobeb@cpc4-stme1-0-0-cust103.cdif.cable.ntl.com) |
| 01:55.38 | CBG | +ping |
| 01:55.38 | oobeb | Pong, CBG. |
| 01:55.41 | CBG | +other |
| 01:55.58 | CBG | Warning: mysql_connect(): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in /Users/Matthew/SmartIRC-0.5.5/dbconnect.txt on line 7 |
| 01:55.58 | CBG | Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) |
| 01:56.00 | blast007 | heh, "that's all" -famouse last words |
| 01:56.04 | blast007 | famous even |
| 01:56.10 | CBG | :P |
| 01:56.36 | blast007 | go bitch at MAMP to fix their shit |
| 01:56.44 | blast007 | or do this: http://www.digitalpeer.com/id/mysql |
| 01:57.39 | *** join/#bzmods oobeb (n=oobeb@cpc4-stme1-0-0-cust103.cdif.cable.ntl.com) |
| 01:57.43 | CBG | +ping |
| 01:57.43 | oobeb | Pong, CBG. |
| 01:57.45 | CBG | +other |
| 01:57.50 | CBG | eh |
| 01:58.35 | CBG | trying that link.... |
| 01:58.37 | CBG | -bash: mysql: command not found |
| 01:58.48 | CBG | it's not really normal install... it's MAMP. |
| 01:58.51 | blast007 | you have to CD into the mysql directory for MAMP |
| 01:58.58 | blast007 | find the binaries |
| 01:59.01 | blast007 | for mysql |
| 01:59.06 | CBG | ok |
| 01:59.19 | blast007 | anyway, time to finish building my computer :P |
| 02:02.03 | CBG | :) |
| 02:03.11 | CBG | the moment of truth |
| 02:03.27 | *** join/#bzmods oobeb (n=oobeb@cpc4-stme1-0-0-cust103.cdif.cable.ntl.com) |
| 02:03.29 | CBG | +ping |
| 02:03.29 | oobeb | CBG: Yes, sir? |
| 02:03.31 | CBG | +other |
| 02:03.34 | CBG | :( |
| 02:03.47 | CBG | still: Warning: mysql_connect(): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in /Users/Matthew/SmartIRC-0.5.5/dbconnect.txt on line 7 |
| 02:03.47 | CBG | Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) |
| 02:03.51 | CBG | I did what that site said... |
| 02:04.03 | CBG | ah, wait... didn't flush... |
| 02:04.11 | CBG | no wonder it stinks of shit |
| 02:05.30 | *** join/#bzmods oobeb (n=oobeb@cpc4-stme1-0-0-cust103.cdif.cable.ntl.com) |
| 02:05.34 | CBG | +other |
| 02:05.48 | CBG | still... same... error |
| 02:05.52 | CBG | fuuuuuck |
| 02:14.12 | CBG | well, thanks a lot anyway, blast007 :( |
| 02:14.18 | CBG | maybe it'll magically work tomorrow |
| 03:24.55 | blast007 | unlikely |
| 11:15.37 | *** join/#bzmods oobeb (n=oobeb@cpc4-stme1-0-0-cust103.cdif.cable.ntl.com) |
| 11:16.31 | CBG | +hug |
| 11:17.36 | CBG | ++lala |
| 11:19.10 | CBG | ++ping |
| 11:19.10 | CBG | Warning: mysql_connect(): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in /Users/Matthew/SmartIRC-0.5.5/dbconnect.txt on line 7 |
| 11:19.10 | CBG | Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) |
| 11:19.10 | CBG | fuck.... :( |
| 11:19.10 | CBG | no miracle over night... |
| 12:07.53 | CBG | the fucking bastard |
| 12:08.07 | CBG | mysql.sock is in /tmp/mysql/mysql.sock |
| 12:08.15 | CBG | it's looking for it in /tmp/mysql.sock |
| 12:08.20 | CBG | stupid thing |
| 12:33.56 | *** join/#bzmods oobeb (n=oobeb@cpc4-stme1-0-0-cust103.cdif.cable.ntl.com) |
| 12:34.04 | CBG | +ping |
| 12:34.05 | oobeb | CBG: Yo, 'sup m' homie? |
| 12:34.07 | CBG | +oth |
| 12:34.14 | CBG | ARGH!!! |
| 12:41.48 | *** join/#bzmods oobeb (n=oobeb@cpc4-stme1-0-0-cust103.cdif.cable.ntl.com) |
| 12:42.11 | CBG | +ping |
| 12:42.11 | oobeb | CBG: Yes, sir? |
| 12:42.13 | CBG | +oth |
| 12:42.17 | CBG | FFS!! |
| 13:31.02 | *** join/#bzmods oobeb (n=oobeb@cpc4-stme1-0-0-cust103.cdif.cable.ntl.com) |
| 13:33.22 | CBG | +ping |
| 13:33.22 | oobeb | CBG: Yes, sir? |
| 13:33.24 | CBG | +oth |
| 13:33.26 | CBG | ... |
| 13:38.28 | *** join/#bzmods oobeb (n=oobeb@cpc4-stme1-0-0-cust103.cdif.cable.ntl.com) |
| 13:38.31 | CBG | +ping |
| 13:38.31 | oobeb | CBG: Yo, 'sup m' homie? |
| 13:38.34 | CBG | +oth |
| 13:38.42 | CBG | This is SO much fucking fun. |
| 14:03.03 | *** join/#bzmods oobeb (n=oobeb@cpc4-stme1-0-0-cust103.cdif.cable.ntl.com) |
| 14:04.19 | CBG | +ping |
| 14:04.19 | oobeb | CBG: Yes, sir? |
| 14:04.19 | CBG | +oth |
| 14:04.19 | CBG | ... |
| 14:04.23 | CBG | wow, didn't expect THAT ! |
| 14:13.46 | *** join/#bzmods fatso (n=fatso@about/essy/fan/CBG) |
| 14:13.46 | *** mode/#bzmods [+o fatso] by ChanServ |
| 14:19.21 | *** join/#bzmods fatso (n=fatso@about/essy/fan/CBG) |
| 14:19.21 | *** mode/#bzmods [+o fatso] by ChanServ |
| 18:41.57 | CBG | !say ##planetmofo don't ban me! I'm innocent! |
| 18:41.58 | fatso | ##planetmofo don't ban me! I'm innocent! |
| 18:42.02 | CBG | .. |
| 18:42.08 | CBG | !msg ##planetmofo don't ban me! I'm innocent! |
| 18:51.52 | *** join/#bzmods a_meteorite (n=a_meteor@unaffiliated/ameteorite/x-000000001) |
| 18:52.13 | *** join/#bzmods oobeb (n=oobeb@82.6.124.104) |
| 18:52.28 | CBG | here is a command hard coded...: |
| 18:52.31 | CBG | +ping |
| 18:52.31 | oobeb | CBG: Yo, 'sup m' homie? |
| 18:52.49 | CBG | now, when I say something that's NOT hard coded, it should connect to the database and search for it: |
| 18:52.51 | CBG | +vyguhbjnk |
| 18:52.59 | CBG | Warning: mysql_connect(): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in /Users/Matthew/SmartIRC-0.5.5/dbconnect.txt on line 7 |
| 18:52.59 | CBG | Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) |
| 18:53.11 | a_meteorite | k |
| 18:53.18 | a_meteorite | that's because your mysql socket isn't there |
| 18:53.24 | CBG | I know. |
| 18:53.37 | CBG | I bet I know more about it than you. I spent about 12 hours total on this. |
| 18:53.44 | a_meteorite | uh huh |
| 18:53.51 | CBG | I tried dozens of "solutions" - nothing fixes it. |
| 18:54.06 | CBG | 10 people in #mysql offered help but nobody there could fix it. |
| 18:54.09 | a_meteorite | I bet it's easily fixable. |
| 18:54.18 | CBG | How much? ;) |
| 18:54.26 | a_meteorite | by finding out where the mysql sock is |
| 18:55.03 | CBG | I know where it is. |
| 18:55.06 | CBG | I tried a symlink, no luck. |
| 18:55.12 | a_meteorite | ps waux | grep mysql |
| 18:55.15 | a_meteorite | is it running? |
| 18:55.20 | blast007 | CBG: are you connecting to 127.0.0.1 or localhost? |
| 18:55.26 | blast007 | (in the mysql_connect) |
| 18:55.34 | CBG | I checked my php.ini files, it has the /tmp/mysql/mysqp.sock path |
| 18:55.47 | CBG | I even created a my.cnf file in /etc which has that path |
| 18:55.53 | CBG | I have no clue why it uses the bad one |
| 18:56.01 | blast007 | CBG: read what I just said ;) |
| 18:56.04 | CBG | blast007: hmm, 127.0.0.1 |
| 18:56.07 | blast007 | hrm |
| 18:56.09 | CBG | unless I changed it back, i'll see |
| 18:56.29 | CBG | ah, it's back as 'localhost' |
| 18:56.30 | blast007 | if you use localhost, it uses the socket, but if you use 127.0.0.1, it uses TCP/IP |
| 18:56.45 | CBG | changed it, trying bot again |
| 18:57.12 | *** join/#bzmods oobeb (n=oobeb@cpc4-stme1-0-0-cust103.cdif.cable.ntl.com) |
| 18:57.14 | blast007 | +other |
| 18:57.37 | CBG | same error |
| 18:58.00 | CBG | a_meteorite: what am I looking for with this ps+grep command ? |
| 18:58.24 | a_meteorite | to see if it's actually running :) |
| 18:58.33 | CBG | ... what should it look like? |
| 18:58.38 | a_meteorite | paste the output |
| 18:58.54 | *** join/#bzmods tannerld (n=tanner@adsl-068-209-251-067.sip.asm.bellsouth.net) |
| 18:58.59 | CBG | Matthew 24381 3.0 0.2 53692 1416 ?? S 3:02PM 0:26.95 /Applications/MAMP/Library/libexec/mysqld --basedir=/Applications/MAMP/Library --datadir=/Applicat |
| 18:58.59 | CBG | Matthew 24328 0.0 0.0 18644 172 ?? S 3:02PM 0:00.08 sh /Applications/MAMP/Library/bin/mysqld_safe --port=8889 --socket=/Applications/MAMP/tmp/mysql/my |
| 18:59.05 | CBG | yo tannerld |
| 18:59.13 | a_meteorite | ok, there's the socket |
| 18:59.44 | a_meteorite | mysql_connect() can use a socket for the server |
| 18:59.46 | a_meteorite | http://www.php.net/mysql_connect |
| 18:59.56 | a_meteorite | ohhh |
| 19:00.01 | blast007 | a_meteorite: we're trying to avoid the socket |
| 19:00.02 | a_meteorite | did you specify the port right as well? |
| 19:00.09 | CBG | !voice blast007 a_meteorite tannerld ibot |
| 19:00.09 | *** mode/#bzmods [+v blast007] by fatso |
| 19:00.13 | CBG | yes, correct port. |
| 19:00.19 | CBG | !voice a_meteorite |
| 19:00.20 | *** mode/#bzmods [+v a_meteorite] by fatso |
| 19:00.24 | CBG | !voice tannerld |
| 19:00.25 | *** mode/#bzmods [+v tannerld] by fatso |
| 19:00.26 | blast007 | CBG: seperate them with ,'s |
| 19:00.27 | CBG | !voice ibot |
| 19:00.27 | *** mode/#bzmods [+v ibot] by fatso |
| 19:00.34 | blast007 | (and no space) |
| 19:00.40 | CBG | !devoice blast007,a_meteorite,tannerld,ibot |
| 19:00.45 | blast007 | or maybe that only works for joins |
| 19:00.54 | CBG | I didn't ADD support for that myself, blast007 |
| 19:01.01 | CBG | so didn't expect it to work anyway |
| 19:01.18 | blast007 | CBG: the raw join() command supports comma delimited channels |
| 19:02.14 | CBG | !join ##planetmofo,#bzstocks |
| 19:02.20 | a_meteorite | argh. lukaskalo is asking to be admin cause he's in Europe and they can't get rid of TKers at night. |
| 19:02.33 | CBG | blast007: he joined the 2nd.. |
| 19:02.34 | blast007 | eh, poll ban? |
| 19:02.43 | a_meteorite | no, not enough people at the time |
| 19:02.52 | a_meteorite | only 6-7 people early morning |
| 19:03.03 | blast007 | do you trust him? |
| 19:03.05 | a_meteorite | I could set the limit lower... |
| 19:03.12 | a_meteorite | that's the thing, I don't know if I can :) |
| 19:03.24 | CBG | wait, fatso is already in ##pm... duh |
| 19:03.25 | blast007 | make the TK kick be a 5 hour ban instead ;) |
| 19:04.09 | a_meteorite | heh, I just modded a plugin to ban if they get kicked the second time |
| 19:04.11 | a_meteorite | (based on antiLagKickRejoin) |
| 19:04.59 | a_meteorite | noob. now he's all "if you make me admin I will make you one at my server" |
| 19:05.26 | blast007 | my policy, if they ask, they don't get admin |
| 19:06.34 | CBG | so, a_meteorite got any smart ideas? ;) |
| 19:07.35 | a_meteorite | yeah, get a real mysql package |
| 19:07.58 | CBG | ... *sigh* |
| 19:08.06 | a_meteorite | from mysql themselves |
| 19:08.14 | a_meteorite | I'm installing MAMP.. |
| 19:08.20 | CBG | the point of MAMP is that you just download it, put it in your apps folder and BANG. Everyone WORKS. |
| 19:08.26 | CBG | *sigh* |
| 19:08.31 | a_meteorite | it's not working :) |
| 19:08.37 | CBG | I've had the problem with MAMP 1.2 1.3 and 1.4 |
| 19:08.41 | CBG | YOU'RE TELLING ME?!?! |
| 19:08.52 | CBG | AFTER I SPEND THIS FUCKING LONG ON IT?!?! |
| 19:08.57 | CBG | cock. |
| 19:08.59 | a_meteorite | yeah, I'm telling you |
| 19:09.06 | CBG | I'm quite pissed, can you tell? |
| 19:09.24 | a_meteorite | YOU ARE TEH PISSED CBG, AND I AM TELLING YOU MAMP DOESN'T WORK! |
| 19:09.26 | a_meteorite | :) |
| 19:09.29 | CBG | Ok, php question... |
| 19:09.39 | CBG | I have $something = "abcd"; |
| 19:09.51 | CBG | I want to then make $abcd = "blah blah"; |
| 19:10.15 | CBG | (when I don't know the value of $something) |
| 19:10.19 | a_meteorite | uh ok |
| 19:10.34 | a_meteorite | ok.. |
| 19:10.36 | blast007 | so $something would contain the variable name? |
| 19:10.45 | CBG | I guess... |
| 19:10.49 | blast007 | $$something = "blah blah" |
| 19:10.52 | blast007 | ; |
| 19:10.54 | CBG | yeah.. |
| 19:11.49 | a_meteorite | heh, I've never had to do that before |
| 19:11.50 | a_meteorite | interesting... |
| 19:11.58 | CBG | that works, blast007 ? |
| 19:12.07 | blast007 | CBG: it should, but I never use it |
| 19:12.17 | blast007 | you can do the same with function names |
| 19:13.24 | blast007 | a_meteorite: do you run Halo at full quality? |
| 19:13.39 | a_meteorite | yes |
| 19:13.48 | blast007 | sure looks a lot better |
| 19:13.49 | a_meteorite | and I only do AF if I close everything |
| 19:13.55 | blast007 | I had been running at lowest on my laptop |
| 19:14.03 | blast007 | now with my new system it's all shiny and nice |
| 19:14.24 | a_meteorite | My Radeon 9600 128MB Pro nearly chokes on it when you get a couple dozen enemies in a small room :) |
| 19:15.00 | a_meteorite | I don't know how to measure FPS, but I'd say about 20 FPS with lots of enemies and just cruising is about 40-50 FPS |
| 19:17.45 | blast007 | I haven't played much, but my system is more than capable |
| 19:17.51 | blast007 | 512MB video card |
| 19:18.09 | a_meteorite | *sighs* |
| 19:18.35 | a_meteorite | I really want to sell my Mac and get a PC with OSx86, but then I can't use Linux(or)Windows + Mac OS X at the same time :( |
| 19:18.47 | CBG | hah, if I did factoid support as part of my code, in arrays, it would be bloated as SHIT |
| 19:18.55 | a_meteorite | ... |
| 19:19.00 | a_meteorite | try sqlite |
| 19:20.49 | CBG | three factoids...: |
| 19:20.52 | CBG | $factoids = array ("something" => array("value" => "whatever", "creator" => $data->nick, "date" => date(..)), "somethingelse" => array("value" => "whatever", "creator" => $data->nick, "date" => date(..)), "another" => array("value" => "whatever", "creator" => $data->nick, "date" => date(..))); |
| 19:20.58 | CBG | nice, no? ;) |
| 19:21.08 | a_meteorite | :o |
| 19:21.31 | CBG | why sqllite and not mysql ? |
| 19:21.39 | CBG | I'd think MAMP is the real problem, not mySQL itself. |
| 19:21.44 | a_meteorite | because, then you don't have to fiddle with a server |
| 19:21.51 | blast007 | CBG: that's what I did at first, an array stored in memory ;) |
| 19:21.52 | a_meteorite | sqlite is still a good choice |
| 19:21.55 | CBG | hmm, ok |
| 19:21.59 | CBG | blast007: rofl |
| 19:22.27 | a_meteorite | sqlite is nice and fast for lower traffic things |
| 19:22.27 | blast007 | stored it into a text file after every change |
| 19:22.28 | a_meteorite | it's just a file with a library |
| 19:22.31 | CBG | I started thinking about doing it, then I thought "No Fucking Way. That's gonna be the biggest piece of crap ever coded in php!" lol |
| 19:22.38 | CBG | a_meteorite: alright |
| 19:22.49 | blast007 | CBG: hah, then you haven't seen Argooon's code |
| 19:22.57 | CBG | lol |
| 19:23.07 | blast007 | yay, upgrade done |
| 19:23.28 | blast007 | I upgraded php and mysql ;) |
| 19:23.58 | CBG | uhoh |
| 19:24.10 | CBG | a_meteorite: do I get the "sqlite-3_3_8.kit" ? |
| 19:24.13 | a_meteorite | nice resource: http://devzone.zend.com/node/view/id/760 |
| 19:24.23 | a_meteorite | the what? |
| 19:24.24 | CBG | It;s the only mention of 'mac' on the page... |
| 19:24.40 | a_meteorite | no no |
| 19:24.45 | a_meteorite | just compile it |
| 19:25.03 | CBG | "A starkit containing precompiled SQLite binaries and Tcl bindings for Linux-x86, Windows, and Mac OS-X ppc and x86." under "Cross-Platform Binaries" |
| 19:25.06 | CBG | http://www.sqlite.org/download.html |
| 19:25.08 | CBG | .. |
| 19:25.10 | CBG | k.. |
| 19:25.12 | CBG | so I just get the plain source tarball ? |
| 19:25.13 | a_meteorite | You don't need Tcl bindings |
| 19:25.15 | a_meteorite | yes |
| 19:25.19 | CBG | ok |
| 19:25.32 | CBG | I don't like compiling unless I have to. |
| 19:25.38 | a_meteorite | it's pretty easy |
| 19:25.39 | blast007 | bah, forget SQLite |
| 19:25.39 | CBG | If I did I'd be on linux already. |
| 19:25.49 | CBG | blast007: ...? |
| 19:25.50 | a_meteorite | IIRC, php only includes sqlite2 interface |
| 19:25.50 | blast007 | CBG: what is the issue with MySQL now? that authentication stuff? |
| 19:26.04 | CBG | the socket thing still |
| 19:26.06 | a_meteorite | sqlite makes a good choice for this type of job anyways |
| 19:26.07 | blast007 | :/ |
| 19:26.18 | CBG | I swear, it's unfixable. |
| 19:26.22 | blast007 | a_meteorite: do you know if MAMP has support for sqlite? |
| 19:26.31 | CBG | does it need to..? |
| 19:26.34 | blast007 | it has to be built as a PHP extension |
| 19:26.44 | blast007 | if they didn't build it, then it won't |
| 19:26.53 | blast007 | CBG: check your phpinfo() page |
| 19:26.54 | a_meteorite | blast007: um, I'm not sure |
| 19:27.09 | a_meteorite | I think if it doesn't find sqlite libs it uses it's own internal lib |
| 19:27.12 | CBG | I am, blast007 . |
| 19:27.12 | a_meteorite | which is sqlite2 |
| 19:27.17 | blast007 | hah, it already HAS sqlite |
| 19:27.25 | blast007 | CBG: which version do you have? |
| 19:27.38 | blast007 | of MAMP |
| 19:27.48 | CBG | 1.3 now |
| 19:28.05 | CBG | it has SQLite Manager .. |
| 19:28.10 | CBG | so, yeah... |
| 19:28.13 | blast007 | a_meteorite: the point I was making is that the sqlite functions in PHP are only available if the sqlite extension was compiled |
| 19:28.20 | a_meteorite | blast007: ah |
| 19:28.23 | blast007 | http://www.mamp.info/en/help/releases/ |
| 19:28.36 | a_meteorite | It's been so long since I built my php and sqlite :) |
| 19:28.42 | a_meteorite | probably time for another upgrade |
| 19:29.01 | CBG | 'SQLite Library2.8.17' |
| 19:29.19 | a_meteorite | that's fine, just make sure you make sqlite2 databases |
| 19:29.20 | CBG | I just downloaded 3.3.8. lol. You think MAMP are a little behind..? ;) |
| 19:29.30 | a_meteorite | that won't help.. |
| 19:29.35 | CBG | how could I not..? |
| 19:29.36 | a_meteorite | *cough* I was thinking of building your own php |
| 19:29.58 | a_meteorite | you need sqlite2 to make sqlite2 databases |
| 19:30.14 | CBG | I'm using MAMPs SQLite |
| 19:30.18 | CBG | so how can I go wrong..? |
| 19:30.30 | a_meteorite | cause MAMP uses sqlite2 |
| 19:30.33 | CBG | uh, wtf? I have to 'upload' a databse? |
| 19:30.36 | a_meteorite | which is incompatible with sqlite3 |
| 19:30.38 | a_meteorite | no.. |
| 19:30.42 | CBG | a_meteorite: I don't have any other sqlite |
| 19:30.57 | a_meteorite | you need sqlite2 to make sqlite2 databases so you can use that in your php |
| 19:31.12 | a_meteorite | if you get sqlite3 and make sqlite3 databases MAMP's php can't use that |
| 19:31.23 | CBG | I only have sqlite 2. |
| 19:31.26 | a_meteorite | k |
| 19:31.26 | CBG | That's all MAMP has. |
| 19:31.28 | a_meteorite | use that then |
| 19:31.35 | CBG | If I use MAMPs SQLite version... no problem. |
| 19:31.48 | blast007 | CBG: until you upgrade ;) |
| 19:31.49 | CBG | Except it seems I have to 'upload' a database. :/ |
| 19:31.54 | CBG | blast007: sshhh :P |
| 19:32.03 | a_meteorite | request for me to match... |
| 19:32.14 | a_meteorite | I'm sure blast007 can be more helpful than me :) |
| 19:32.20 | blast007 | I don't do sqlite |
| 19:32.28 | a_meteorite | *sigh* |
| 19:32.35 | a_meteorite | well, it's exactly like mysql |
| 19:32.56 | a_meteorite | except it doesn't care about data types (ints and that) |
| 19:32.57 | blast007 | not really |
| 19:33.02 | a_meteorite | close enough |
| 19:33.05 | blast007 | not really |
| 19:33.07 | CBG | why doesn't MAMP show release info for the latest version..? |
| 19:33.08 | blast007 | ;) |
| 19:33.14 | a_meteorite | it works :P |
| 19:33.37 | a_meteorite | unless you're doing some complex queries that are mysql only... I doubt it |
| 19:34.09 | blast007 | yay for INNER JOINS and LEFT JOINS |
| 19:34.27 | a_meteorite | but it implements most of SQL92 |
| 19:34.30 | a_meteorite | http://www.sqlite.org/omitted.html |
| 19:34.37 | a_meteorite | if you need that stuff, than you'll need to fix mysql :P |
| 19:34.39 | blast007 | yeah, I know, I'm just messing with ya |
| 19:34.54 | a_meteorite | oh, well, match time |
| 19:35.06 | a_meteorite | good luck, I think you'll get it with some googling and that tutorial link I gave you :) |
| 19:35.42 | CBG | haha, I wish. |
| 19:35.57 | blast007 | CBG: if you're going to play with SQLite, or MySQL for that matter, first make a script that just plays around with their features |
| 19:36.04 | blast007 | it will be MUCH easier to debug |
| 19:36.40 | CBG | http://www.apachefriends.org/en/xampp.html |
| 19:36.44 | CBG | WTF is with that picture?!? |
| 19:37.06 | blast007 | heh |
| 19:37.20 | blast007 | she's running or something |
| 19:37.57 | CBG | ........ |
| 19:38.08 | CBG | SHE?!?!? |
| 19:38.08 | blast007 | I was going to suggest the OSX version of XAMPP, but they said it's not being developed right now, so I was unsure of the functionality |
| 19:38.25 | CBG | Well, I'm gonna try it. |
| 19:38.29 | blast007 | k |
| 19:40.20 | CBG | because sqlitemanage seriously sucks dog balls |
| 19:54.20 | CBG | After downloading simply unpack the file with Stuffit Expander or simular software and doubleclick the pkg file: ..... |
| 19:54.25 | CBG | There's no such thing. |
| 21:39.54 | *** join/#bzmods ibot (i=ibot@pdpc/supporter/active/TimRiker/bot/apt) |
| 21:39.54 | *** topic/#bzmods is http://bash.org/?700639, http://bash.org/?700642, http://bash.org/?700647, http://bash.org/?700666, http://bash.org/?700670 |
| 21:45.24 | CBG | OK, lets summarise... |
| 21:45.27 | CBG | MAMP SUCKS COCK |
| 21:45.37 | CBG | SQLITE IS GAY |
| 21:45.46 | CBG | and XAMPP HAS A TINY COCK |
| 21:46.01 | CBG | All in all, quote an UNPRODUCTIVE 2 FUCKING days. |
| 21:46.05 | CBG | quite* |
| 21:46.06 | a_meteorite | All very true. |
| 21:46.11 | a_meteorite | But SQLite likes you. |
| 21:46.40 | CBG | But it's a piece of shit, so it can go fuck itself. |
| 21:46.54 | a_meteorite | What'd it do to you to ever hate it? |
| 21:47.12 | a_meteorite | And what about PHP? Does it have a tiny ass or something? |
| 21:47.25 | CBG | It's not fucking possible to create a database for it. |
| 21:47.37 | CBG | PHP is a cutie, we make out regularly. |
| 21:49.11 | CBG | So, yeah. |
| 21:49.16 | CBG | TEXT FILES FOR ME!! |
| 21:49.16 | blast007 | CBG: maybe it's your Operating System |
| 21:49.30 | tannerld | eheh |
| 21:49.31 | blast007 | or your NOS |
| 21:49.31 | CBG | If I can work out how the fuck I do it that way. |
| 21:49.31 | a_meteorite | No, he loves Mac OS X. |
| 21:49.34 | blast007 | Non-Operating System |
| 21:49.44 | CBG | blast007: whaetver, I'm not chaning my OS for a databse. |
| 21:49.49 | a_meteorite | CBG: pfft.. install some packages |
| 21:49.52 | CBG | ..? |
| 21:50.00 | blast007 | manually install MySQL, and PHP |
| 21:50.00 | a_meteorite | Like the MySQL official installer for Mac OS X. |
| 21:50.03 | blast007 | you don't need Apache |
| 21:50.10 | a_meteorite | Yeah. Just do that. |
| 21:50.19 | CBG | PHP is fine. |
| 21:50.26 | CBG | Only mySQL won't work. |
| 21:50.32 | a_meteorite | JUST FRIGGIN INSTALL MYSQL! :P |
| 21:50.40 | CBG | O FUCKING K |
| 21:50.55 | CBG | I was gonna before you said to use sqlite |
| 22:16.22 | CBG | When you say "Download mySQL", you mean "MySQL Community Server", right? |
| 22:17.38 | CBG | a_meteorite: blast007: ^ |
| 22:17.46 | a_meteorite | oh |
| 22:17.53 | a_meteorite | yes |
| 22:17.58 | CBG | ok |
| 22:18.21 | CBG | 70MB!??!!?? |
| 22:18.27 | CBG | OMFG!!!!! |
| 22:18.32 | a_meteorite | Yeah |
| 22:18.46 | CBG | !! |
| 22:18.46 | fatso | Calm down, CBG, calm down! |
| 22:18.50 | CBG | :D |
| 22:18.52 | CBG | !!! |
| 22:18.52 | fatso | Calm down, CBG, calm down! |
| 22:18.53 | a_meteorite | !! |
| 22:18.53 | fatso | Calm down, a_meteorite, calm down! |
| 22:18.55 | a_meteorite | !!! |
| 22:18.56 | fatso | Calm down, a_meteorite, calm down! |
| 22:18.58 | a_meteorite | !!!! |
| 22:19.00 | CBG | !!lart a_meteorite |
| 22:19.02 | a_meteorite | :( |
| 22:25.02 | CBG | There are 2 pkg files. |
| 22:26.03 | CBG | mysql-5.1.11-beta-osx10.3-powerpc.pkg and MySQLStartupItem.pkg |
| 22:26.08 | CBG | a_meteorite: which one? |
| 22:26.21 | a_meteorite | mysql-5.1.11... |
| 22:26.57 | a_meteorite | MySQLStartup is to make an entry in your StartupItems to start MySQL |
| 22:26.59 | CBG | lalalalaaaaaaa |
| 22:27.01 | a_meteorite | never worked for me :\ |
| 22:27.05 | CBG | aight |
| 22:27.41 | CBG | I can tell, this is gonna take all night and still not work. |
| 22:27.51 | a_meteorite | yup |
| 22:28.00 | a_meteorite | I compiled all mine from source except for MySQL |
| 22:29.35 | CBG | I installed the pkg, now what? |
| 22:29.43 | a_meteorite | Now connect to MySQL |
| 22:29.46 | CBG | Do i need to read the 1000 page long read me..? |
| 22:29.48 | a_meteorite | on the default port |
| 22:29.50 | a_meteorite | no |
| 22:30.00 | CBG | what port is that? |
| 22:30.14 | a_meteorite | 3306, IIRC, but you don't need to specify it |
| 22:30.23 | CBG | ok |
| 22:30.33 | CBG | user? pass? |
| 22:30.44 | a_meteorite | user: root, there is no pass |
| 22:30.45 | blast007 | root for username, blank for password |
| 22:30.58 | CBG | $connect = mysql_connect('127.0.0.1', 'root', '') or die (mysql_error ()); |
| 22:31.11 | CBG | right? |
| 22:31.20 | blast007 | yeah |
| 22:31.41 | CBG | Guess I need to work out how to create tables and shit with php now though. |
| 22:32.26 | blast007 | use the 'mysql' client ;) |
| 22:32.38 | CBG | hmm? |
| 22:32.46 | CBG | command line? |
| 22:32.48 | a_meteorite | yes |
| 22:32.49 | blast007 | http://dev.mysql.com/doc/refman/5.0/en/create-table.html |
| 22:32.52 | a_meteorite | mysql -u root |
| 22:33.07 | a_meteorite | oh, you need to add mysql's bin to your $PATH |
| 22:33.29 | CBG | hmm? |
| 22:33.44 | blast007 | a_meteorite: aww, it isn't like linux, and Just Works(tm)? |
| 22:34.11 | a_meteorite | blast007: it installs in /usr/local/mysql which is a symlink to /usr/local/mysql-5.1.11-blah-blah |
| 22:34.22 | a_meteorite | so you can have multiple versions |
| 22:34.45 | blast007 | /usr/bin/mysql |
| 22:34.52 | blast007 | for me |
| 22:34.53 | a_meteorite | it's not in there |
| 22:35.03 | a_meteorite | /usr/local/mysql/bin/mysql |
| 22:35.03 | blast007 | I know ;) |
| 22:35.08 | blast007 | /exec -o which mysql |
| 22:35.09 | CBG | *ahem* -bash: mysql: command not found |
| 22:35.20 | a_meteorite | add it to your $PATH |
| 22:35.36 | CBG | WTF? |
| 22:35.39 | CBG | HOW?! WHERE? |
| 22:35.40 | blast007 | or just specify the full path to it |
| 22:35.42 | a_meteorite | *cough* |
| 22:35.45 | a_meteorite | just do: |
| 22:35.52 | a_meteorite | /usr/local/mysql/bin/mysql -u root |
| 22:36.02 | CBG | I'm not doing that all the damn time... |
| 22:36.06 | CBG | Can I symlink it? |
| 22:36.14 | a_meteorite | Add it to your $PATH |
| 22:36.22 | CBG | ...?? |
| 22:36.22 | a_meteorite | ok, here's what you do.. |
| 22:36.41 | a_meteorite | nano -w ~/.profile |
| 22:36.51 | CBG | s/nano/pico/ |
| 22:37.04 | CBG | k, it's empty |
| 22:37.10 | a_meteorite | PATH=$PATH:/usr/local/mysql/bin |
| 22:37.10 | a_meteorite | export PATH |
| 22:37.16 | a_meteorite | add those lines in |
| 22:37.32 | a_meteorite | and if you want more paths... just add more of these lines: |
| 22:37.41 | a_meteorite | PATH=$PATH:/usr/local/bin (for instance) |
| 22:37.47 | a_meteorite | and make sure export PATH is the very last line |
| 22:37.51 | CBG | more paths for what? |
| 22:37.56 | a_meteorite | like, in the future |
| 22:37.59 | CBG | ok |
| 22:38.02 | a_meteorite | just do those two lines for now |
| 22:38.11 | blast007 | CBG: who knows...maybe PHP, or bzfs, or cheeseburger? |
| 22:38.18 | CBG | done |
| 22:38.20 | blast007 | cd /mcdonalds |
| 22:38.22 | CBG | blast007: porn? |
| 22:38.27 | a_meteorite | source ~/.profile |
| 22:38.30 | blast007 | you have binary porn? |
| 22:38.37 | blast007 | s/binary/executable/ |
| 22:38.49 | CBG | -bash: souce: command not found |
| 22:38.56 | a_meteorite | source |
| 22:39.03 | CBG | ahh, lol |
| 22:39.10 | CBG | nothing. |
| 22:39.13 | a_meteorite | ok |
| 22:39.16 | a_meteorite | which mysql |
| 22:39.29 | CBG | /usr/local/mysql/bin/mysql |
| 22:39.32 | a_meteorite | mysql -u root |
| 22:39.36 | CBG | yay |
| 22:39.38 | a_meteorite | no password either |
| 22:40.16 | CBG | ahahahahahahaahahahahahahahahahahahahahahahahaahahahahahahahahahahahahaahahahahahahahahahahahahahaahahahahahahahaahahahahahahahahahahahahahahahahaahahahahahahahahahahahahaahahahahahahahahahahahahahaahahahahahahahaahahahahahahahahahahahahahahahahaahahahahahahahahahahahahaahahahahahahahahahahahahahaahahahahahahahaahahahahahahahahahahahahahahahahaahahahahahahahahahahahahaahahahahahahahahahahahahahaahahahahahahahaahahahahahahahahahahahahahahahahaahahahahahahahaha |
| 22:40.19 | a_meteorite | ... |
| 22:40.20 | CBG | ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) |
| 22:40.25 | blast007 | lol |
| 22:40.26 | a_meteorite | You need to start it. |
| 22:40.32 | CBG | ...? |
| 22:40.34 | a_meteorite | install that other package |
| 22:40.44 | a_meteorite | mysqlstartupblah.pkg |
| 22:40.47 | blast007 | I just do /etc/rc.d/rc.mysql start |
| 22:40.48 | blast007 | ;) |
| 22:40.56 | blast007 | if only you had linux |
| 22:40.58 | a_meteorite | we don't even have init or rc :P |
| 22:41.08 | a_meteorite | oh, wait, yes we do got rc |
| 22:41.12 | a_meteorite | but I don't want to mess with it |
| 22:41.14 | CBG | done |
| 22:41.21 | a_meteorite | normally we use /Library/StartupItems |
| 22:41.23 | CBG | now..? |
| 22:41.28 | a_meteorite | now try |
| 22:41.35 | CBG | same error |
| 22:41.43 | a_meteorite | k |
| 22:42.04 | CBG | *SIGH* |
| 22:42.15 | a_meteorite | sudo /Library/StartupItems/MY<tab to complete> start |
| 22:42.36 | CBG | MySQLCOM ? |
| 22:42.41 | a_meteorite | yes |
| 22:42.44 | CBG | pass? |
| 22:42.51 | a_meteorite | your user password |
| 22:42.56 | a_meteorite | your mac os x account |
| 22:43.00 | CBG | sudo: /Library/StartupItems/MySQLCOM/: command not found |
| 22:43.06 | a_meteorite | argghhh |
| 22:43.07 | a_meteorite | hold on a sec |
| 22:43.11 | CBG | this is fun |
| 22:43.12 | blast007 | hehehehehehehehe |
| 22:43.20 | CBG | SO MUCH FUCKING FUN!!!! |
| 22:43.25 | a_meteorite | there's another one in |
| 22:43.32 | CBG | Hang on, I'll use filemaker |
| 22:43.38 | a_meteorite | //Library/StartupItems/MySQLCOM/MySQLCOM probablyu |
| 22:43.40 | CBG | that WORKS, at least. |
| 22:43.51 | a_meteorite | try that |
| 22:44.05 | blast007 | worst case, try: sudo /usr/local/mysql/bin/mysqld_safe --user=mysql & |
| 22:44.08 | a_meteorite | sudo /Library/StartupItems/MySQLCOM/MySQLCOM start |
| 22:44.11 | a_meteorite | :P |
| 22:44.23 | a_meteorite | it starts up with some arguments, iirc |
| 22:44.39 | blast007 | argument 1: "I refuse to start!" |
| 22:44.50 | a_meteorite | Instead, I used a LaunchDaemon |
| 22:44.59 | blast007 | Intead, I used a linux |
| 22:45.03 | blast007 | Instead even |
| 22:45.08 | a_meteorite | rofl |
| 22:45.22 | a_meteorite | I use Launchd! so there! |
| 22:45.28 | a_meteorite | http://en.wikipedia.org/wiki/Launchd |
| 22:45.31 | blast007 | time to order food |
| 22:45.40 | a_meteorite | my mom's doing take-out again |
| 22:45.46 | a_meteorite | explains why I'm overweight |
| 22:45.55 | blast007 | I haven't gone to McDonalds since my car accident...I've ordered delivery every day |
| 22:46.10 | a_meteorite | lol, McD's delivers in your area?! |
| 22:46.22 | blast007 | no |
| 22:46.27 | a_meteorite | oh, that'd be sweet |
| 22:46.29 | blast007 | Milios |
| 22:46.35 | blast007 | yeah, it would be :) |
| 22:46.45 | blast007 | I'll probably never go back to that one McDonalds |
| 22:46.47 | a_meteorite | oh, like Subway |
| 22:47.13 | blast007 | there's apparently one a lot closer inside a mall's food court |
| 22:47.14 | CBG | Starting MySQL database server |
| 22:47.14 | CBG | !!! :D yay |
| 22:47.14 | CBG | iBook:~ Matthew$ mysql -u root |
| 22:47.15 | CBG | Welcome to the MySQL monitor. Commands end with ; or \g. |
| 22:47.15 | CBG | Your MySQL connection id is 2 to server version: 5.1.11-beta |
| 22:47.15 | CBG | Type 'help;' or '\h' for help. Type '\c' to clear the buffer. |
| 22:47.17 | CBG | mysql> |
| 22:47.19 | blast007 | and they have other stuff ther as well |
| 22:47.19 | CBG | w00t w00000000t yaaaayyy!! |
| 22:47.21 | a_meteorite | there ya go |
| 22:47.23 | blast007 | CBG: yay |
| 22:47.31 | a_meteorite | now go scrap MAMP |
| 22:47.37 | a_meteorite | quick! before it blows up! |
| 22:47.59 | CBG | thnx met |
| 22:48.01 | CBG | k, now lets do some sql shit |
| 22:48.15 | fatso | squirrels!? |
| 22:48.15 | CBG | what car accident? |
| 22:48.15 | CBG | I need apache and php dude |
| 22:48.26 | a_meteorite | I was kidding |
| 22:48.31 | a_meteorite | now connect in your PHP |
| 22:48.40 | CBG | I'm making a table |
| 22:48.42 | a_meteorite | and make your tables, yo |
| 22:48.44 | a_meteorite | k |
| 22:48.49 | CBG | www.w3schools.com/sql/ |
| 22:48.57 | a_meteorite | at least with SQLite you don't have to worry about data types |
| 22:48.59 | a_meteorite | :P |
| 22:56.21 | CBG | my table looks like this: |
| 22:56.42 | a_meteorite | I suck at SQL. |
| 22:56.43 | CBG | CREATE TABLE factoids ( |
| 22:56.43 | CBG | <PROTECTED> |
| 22:56.44 | CBG | <PROTECTED> |
| 22:56.44 | CBG | <PROTECTED> |
| 22:56.44 | CBG | <PROTECTED> |
| 22:56.45 | CBG | ); |
| 22:56.50 | a_meteorite | create an id |
| 22:57.01 | CBG | So, when I INSERT data, for it to add it's own timestamp, so I leave that out? |
| 22:57.09 | CBG | I have name as unique btw. |
| 22:57.28 | a_meteorite | looks fine, but I scorn SQL |
| 22:57.51 | CBG | So, when I INSERT data, for it to add the timestamp, do I leave that out? |
| 22:58.02 | a_meteorite | I don't know |
| 22:58.05 | CBG | :( |
| 22:58.06 | a_meteorite | I think so |
| 22:58.12 | a_meteorite | I got to go anyways |
| 22:58.31 | CBG | aight, cya |
| 22:58.38 | CBG | thnx too |
| 23:03.42 | blast007 | CBG: want to see my factoids table? |
| 23:04.17 | CBG | I have a table and some test data already, I hope |
| 23:05.02 | CBG | I'd like to TRY and do it without stealing code and such, if possible. |
| 23:05.04 | CBG | though, no doubt I will fail. |
| 23:06.55 | CBG | I run "SELECT * FROM factoids;" and it says: ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELETCT * FROM factoids' at line 1 |
| 23:06.58 | CBG | :/ |
| 23:07.08 | tannerld | heheh |
| 23:07.17 | CBG | goddamnit |
| 23:07.33 | CBG | ahhhh |
| 23:07.40 | tannerld | aren't they so error specific? "Ok error....bad.....but why?!" :E |
| 23:07.47 | CBG | I can't spell SELECT |
| 23:07.49 | CBG | ffs. |
| 23:08.10 | CBG | alright, my table works, it has data |
| 23:08.11 | CBG | w00t w00t |
| 23:09.01 | CBG | WITH DATES, I might add |
| 23:09.26 | tannerld | heheh |
| 23:11.17 | CBG | here comes oobeb |
| 23:11.28 | CBG | aka fat1c.php |
| 23:11.33 | CBG | aka TEST BOT |
| 23:11.44 | *** join/#bzmods oobeb (n=oobeb@cpc4-stme1-0-0-cust103.cdif.cable.ntl.com) |
| 23:11.48 | CBG | +ping |
| 23:11.54 | oobeb | Pong, CBG. |
| 23:11.55 | CBG | still joining... |
| 23:11.58 | CBG | +love |
| 23:12.02 | CBG | argh |
| 23:12.08 | CBG | damn, wrong database name |
| 23:13.02 | blast007 | heh |
| 23:13.05 | CBG | ok, this time...!! |
| 23:13.14 | CBG | shit, I need a bigger screen two |
| 23:13.18 | blast007 | really, mysql shouldn't be an addon for your bot |
| 23:13.22 | CBG | I got like,4 different things filling my screen |
| 23:13.31 | *** join/#bzmods oobeb (n=oobeb@cpc4-stme1-0-0-cust103.cdif.cable.ntl.com) |
| 23:13.31 | blast007 | the bot should connect to MySQL right away |
| 23:13.32 | CBG | I'm conatsnlty command-tabbing between them |
| 23:13.43 | CBG | +ping |
| 23:13.43 | oobeb | CBG: Yes, sir? |
| 23:13.46 | CBG | +love |
| 23:13.46 | oobeb | Resource id #11 |
| 23:13.49 | blast007 | hehehe |
| 23:13.51 | CBG | hmm |
| 23:13.54 | CBG | well, it didn't crash |
| 23:13.57 | CBG | great. |
| 23:14.05 | blast007 | did you make it message the mysql_query() ? |
| 23:14.21 | CBG | yeah |
| 23:14.26 | CBG | since I dunno what that outputs |
| 23:14.46 | blast007 | a resource handler that you can pass to other mysql_* functions |
| 23:15.02 | CBG | dunno what the heck I do with "Resource id #11" |
| 23:15.04 | CBG | I was kinda expecting it to list the "love" row |
| 23:15.11 | blast007 | nope |
| 23:15.25 | blast007 | all you did was run the query |
| 23:15.31 | blast007 | you have to tell PHP what to do now |
| 23:15.35 | CBG | k |
| 23:15.41 | blast007 | let me get an example |
| 23:15.52 | CBG | I'm googling |
| 23:16.21 | CBG | ah, I need something like: mysql_fetch_row($result) ? |
| 23:16.48 | blast007 | yeah |
| 23:16.50 | blast007 | $row = mysql_fetch_assoc($result); |
| 23:17.03 | blast007 | assoc will create a named array |
| 23:17.03 | CBG | k, thnx |
| 23:17.56 | CBG | and I can just do $irc->message(SMARTIRC_TYPE_CHANNEL, $data->channel, the_array...); then? |
| 23:18.06 | CBG | to get the whole row of data..? |
| 23:18.54 | CBG | ahh: while ($row = mysql_fetch_assoc($result)) { |
| 23:18.54 | CBG | <PROTECTED> |
| 23:18.54 | CBG | <PROTECTED> |
| 23:18.55 | CBG | <PROTECTED> |
| 23:18.59 | CBG | } |
| 23:21.58 | blast007 | I'd also recommend escaping any user input |
| 23:22.30 | CBG | uh? wha? |
| 23:22.30 | blast007 | otherwise if someone put's a ' in their factoid, it might crash or MySQL might get b0rked |
| 23:22.38 | CBG | ah, right.. |
| 23:22.45 | CBG | you can add factoids yet |
| 23:22.52 | CBG | I'm nowhere close to that :P |
| 23:23.01 | blast007 | +test';DROP TABLE factoids;' |
| 23:23.07 | blast007 | oh |
| 23:23.08 | CBG | do I need to escpae < and > in php? |
| 23:23.12 | blast007 | hope I didn't actually drop your table |
| 23:23.18 | blast007 | forget it was actuallyhere |
| 23:23.26 | CBG | You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ';DROP'' at line 1 |
| 23:23.29 | CBG | rofl |
| 23:23.54 | CBG | the ; at the start is bad :P |
| 23:24.07 | CBG | do I need to escpae < and > in php? |
| 23:24.14 | blast007 | 1 sec, phone call |
| 23:25.04 | CBG | pffffff |
| 23:26.34 | CBG | here goes |
| 23:26.59 | *** join/#bzmods oobeb (n=oobeb@cpc4-stme1-0-0-cust103.cdif.cable.ntl.com) |
| 23:27.41 | CBG | +ping |
| 23:27.41 | oobeb | CBG: Yes, sir? |
| 23:27.44 | CBG | +love |
| 23:27.48 | tannerld | :o |
| 23:27.51 | CBG | W00000T!!! |
| 23:27.53 | CBG | OMFG!!!!! |
| 23:27.55 | CBG | +like |
| 23:27.55 | oobeb | I like you too! |
| 23:27.57 | CBG | ++hate |
| 23:27.58 | oobeb | omfg 1 hatez j00!!!!!!!!!1111111oneoneoneeleven |
| 23:27.58 | tannerld | lol |
| 23:28.04 | CBG | YES!!! |
| 23:28.07 | CBG | IT WORKS!!!! |
| 23:28.08 | tannerld | hehe |
| 23:28.17 | CBG | Wow!! |
| 23:32.20 | blast007 | +hate |
| 23:32.21 | oobeb | omfg 1 hatez j00!!!!!!!!!1111111oneoneoneeleven |
| 23:33.46 | CBG | It does actions too! |
| 23:33.47 | CBG | +love |
| 23:34.06 | CBG | With the same <reply>/<action> syntax as ibot |
| 23:35.24 | CBG | I am getting blank white space in my terminal output though, blast007 |
| 23:35.38 | CBG | each time before he responds to a factoid |
| 23:38.40 | CBG | should I use include_once for my database connect file..? blast007 |
| 23:38.45 | CBG | get off the damn phone |
| 23:39.10 | tannerld | lol |
| 23:39.16 | tannerld | sudo rm phone |
| 23:39.25 | blast007 | where did my phone go?!?! |
| 23:39.43 | CBG | W00t! |
| 23:40.15 | blast007 | wait...you're including the database connect file every time? |
| 23:40.41 | CBG | heh, guess so... |
| 23:41.00 | CBG | well, only if the command was not recgonised (hard coded) |
| 23:41.55 | blast007 | you could make MySQL connect when you start the bot |
| 23:42.02 | blast007 | then you can store settings in there as well |
| 23:42.23 | blast007 | the problem with that is that MySQL will time out eventually |
| 23:42.30 | blast007 | and you'll lose the connection |
| 23:42.42 | blast007 | but PHP won't know it automatically :P |
| 23:43.04 | CBG | yeah, I am moving the include() to the start |
| 23:43.10 | CBG | but should I use include_once ? |
| 23:43.26 | blast007 | depends on how you set it up |
| 23:43.35 | CBG | :/ |
| 23:43.36 | blast007 | but that's how it _should_ be |
| 23:43.48 | blast007 | if that doesn't work, then you need to fix your code |
| 23:43.52 | CBG | I'll look up include_once |
| 23:44.00 | blast007 | require_once is better |
| 23:44.15 | CBG | require vs include ....?? |
| 23:44.23 | blast007 | require will error if it can't include it |
| 23:44.31 | blast007 | include just issues a warning |
| 23:44.42 | blast007 | since it's an important file, you want to require it |
| 23:45.02 | CBG | but it's the same otherwise? |
| 23:45.04 | CBG | include_once('SmartIRC.php'); |
| 23:45.06 | CBG | that's a _little_ important too ;) |
| 23:47.25 | blast007 | heh |
| 23:48.03 | blast007 | I suppose "include" has a use as well for important files |
| 23:48.09 | blast007 | like if you want to handle the error yourself |
| 23:48.14 | blast007 | and make it all pretty |
| 23:48.20 | CBG | +hde |
| 23:48.25 | blast007 | +hide |
| 23:48.33 | blast007 | +cheeseburger |
| 23:48.36 | blast007 | +die |
| 23:48.37 | CBG | it only has love, hate and like |
| 23:48.43 | CBG | ya can stop now :P |
| 23:48.43 | blast007 | +hate |
| 23:48.44 | oobeb | omfg 1 hatez j00!!!!!!!!!1111111oneoneoneeleven |
| 23:48.49 | blast007 | +like |
| 23:48.50 | oobeb | I like you too! |
| 23:48.56 | CBG | +love |
| 23:49.01 | blast007 | I was avoiding that one |
| 23:49.05 | CBG | heh |
| 23:49.42 | CBG | what does mysql_fetch_assoc($result) output if what I tried to SELECT doesn't exist? |
| 23:50.35 | blast007 | I think FALSE |
| 23:50.40 | blast007 | it should be doc'ed |
| 23:51.48 | CBG | I wanna do something like: when they try to set a new factoid, check if it exists, if so, say "but it's already something else" else INSERT.. |