#pentagram@irc.freenode.net logs for 24 Apr 2005 (GMT)

Archive Today Yesterday Tomorrow
Pentagram homepage

[00:47:56] <watt> Blah? MySQL 4.x doesn't have views? Ugh.
[00:48:39] <watt> That might cause a problem... here's to hoping the server will have MySQL 5.x
[01:41:40] <servus> MySQL is junk
[01:42:13] <servus> They don't even seem to care about the SQL standard.
[02:42:14] <watt> Harsh... but at this point, I don't think I disagree...
[02:42:38] <watt> not that anyone follows the standard well yet.
[03:04:02] <servus> Sure they do
[03:04:31] <servus> SQLite has great SQL92 support. So does PostgreSQL, definitely Oracle lets you do simple stuff like views and subselects. Even MS Access supports a lot more of SQL92 than MySQL.
[03:05:50] <watt> well yes... and Oracle 10, I heard is very compliant.... but I don't think anyone follows the standard completely....
[03:05:59] <servus> But MySQL doesn't even *care*
[03:06:10] <watt> although, I'm no expert on the standard.
[03:06:14] <servus> They ignore adding crucial features, while adding their own proprietary stuff that isn't very useful.
[03:06:27] <servus> Not until VERY recently could you even do subqueries (subselects) in MySQL.
[03:06:41] <servus> You still can't do views, triggers, stored procedures...
[03:06:43] <servus> Et cetera.
[03:07:07] <watt> yeah, I noticed.... which is strange because I always considered views and subselects as a crucial part of SQL
[03:07:28] <servus> MySQL is junk. They are popular for the same reasons Redhat is.
[03:07:31] <watt> 5.x can do all of though... but it's still beta.
[03:07:40] <servus> And of course Redhat... well, compared to many other Linux distributions, is junk.
[03:07:46] <watt> publicity?
[03:07:50] <servus> Yeah!
[03:08:00] <servus> Which does not always equal quality.
[03:08:11] <servus> I like PostgreSQL and SQLite.
[04:37:08] --> pinh1440 has joined #pentagram
[04:48:16] <-- pinh1440 has left #pentagram ("Leaving")
[09:35:36] <Lightkey> giant hurt ball :)
[09:35:42] <Lightkey> seen that parody too
[09:41:31] <-- Kirben has left IRC ("System Meltdown")
[09:49:05] <servus> That was random.
[09:49:13] <servus> Katamachi Desamoru?
[09:51:35] <Lightkey> don't tell me you know what that means
[09:52:18] <Lightkey> and while we are at it: http://img253.echo.cx/img253/7338/44122c8339d3f8c28e18e3988fe071.jpg
[09:59:11] <servus> Why else would I say it?
[09:59:24] <servus> Yes I already saw that, and even posted it to someone's MySpace.
[10:02:32] <Lightkey> hah, you wouldn't believe that I got it from here but forgot that it is from here already, and it's even still on the screen
[10:06:54] <sbx> Here is a related picture: http://img253.echo.cx/img253/7338/44122c8339d3f8c28e18e3988fe071.jpg
[10:07:20] <Lightkey> oooooh, haven't seen that one
[10:07:29] <Lightkey> wait..
[10:10:21] <servus> Same picture!
[10:10:55] <servus> Try http://i5.photobucket.com/albums/y175/sammatthews/pope3.jpg
[10:31:40] --> Kirben has joined #pentagram
[10:31:40] --- ChanServ gives channel operator status to Kirben
[11:13:10] <-- Lightkey has left IRC ("Have a N.I.C.E. day")
[11:13:27] --> Lightkey has joined #Pentagram
[11:15:57] --- sbx is now known as sbx|afk
[11:30:25] --> Fingolfin has joined #pentagram
[11:30:25] --- ChanServ gives channel operator status to Fingolfin
[11:35:22] --- sbx|afk is now known as sbx
[12:34:17] <wjp> ah, missing Aerial Servants is a silly bug... not checking if the item is actually SI_SOLID before checking if it's a valid position in Item::legalCreate
[12:35:00] <wjp> (in the scene where you first meet Stratos)
[12:36:31] --> Chetic has joined #pentagram
[12:41:51] <wjp> hm, I don't check for that in most of the canExistAt/isValidPosition-like functions
[13:28:24] <-- Fingolfin has left IRC ("42")
[13:53:14] <wjp> hm, Stratos is drawn behind her platform :-(
[14:21:51] <wjp> ok, changed isValidPosition and sweepTest to properly check if items can overlap
[14:22:06] <wjp> the SweepItem now also has a 'blocking' field that indicated that
[14:22:42] <wjp> just testing a bit before committing now
[14:25:04] <wjp> hmm... those fire-arrow traps behave rather interestingly now :-)
[14:25:25] <wjp> they fire an arrow and that one stops almost immediately after being fired
[14:25:37] <wjp> the next arrow then crashes into the first one and explodes, blowing up both of them
[14:25:47] <wjp> the third arrow is then fired normally
[14:25:52] <wjp> (and then the cycle repeats)
[14:34:21] --> pika has joined #pentagram
[14:38:07] <-- pika has left IRC ("(wiRC v6.0) download it @ www.warIRC.com")
[14:56:16] <wjp> fixed and committed
[14:59:50] <Colourless> wasnt long to fix
[15:01:15] <-- Kirben has left IRC ("System Meltdown")
[15:02:43] <wjp> I switched two arguments to sweepTest :-)
[15:05:03] <wjp> (or maybe 'swapped' is a better term for that)
[15:31:32] <wjp> hm, I think ShapeInfo flag 0x4000 (current unknown46) might mean 'unclickable'
[15:32:10] <wjp> it's used for the light being cast on the street through windows and by streetlights, and also for the 'fire globe' around the avatar when Endure Heat is cast
[15:32:53] <wjp> also used for some sprites and editor items
[15:54:05] <Colourless> cya later. i'm going to sleep
[15:54:12] --- Colourless is now known as Cless|Sleep
[15:54:46] <wjp> night
[15:55:58] <wjp> or maybe it should just be based on the SI_SOLID flag
[16:07:58] <wjp> interesting; toggling that UNKNOWN46 flag makes the endure heat globe appear behind the avatar instead of in front of it
[16:08:27] <wjp> (in the original, that is)
[16:08:50] <wjp> and annoyingly, toggling the UNKNOWN46 and the SOLID flags still doesn't let me click on the fire globe to 'look' at it
[20:08:26] * Lightkey casts some light with the.. light key!
[20:41:46] --> Fingolfin has joined #pentagram
[20:41:46] --- ChanServ gives channel operator status to Fingolfin
[21:25:21] <-- Chetic has left IRC (Read error: 104 (Connection reset by peer))
[21:25:35] --> Chetic has joined #pentagram
[21:28:56] --> Chet1c has joined #pentagram
[21:30:37] <-- Chetic has left IRC (Read error: 104 (Connection reset by peer))
[21:37:54] --> Chetic has joined #pentagram
[21:38:46] <-- Chet1c has left IRC (Read error: 131 (Connection reset by peer))
[22:11:35] <-- Zain has left IRC (Read error: 54 (Connection reset by peer))
[22:43:18] <-- Lightkey has left IRC (Read error: 60 (Operation timed out))
[22:51:28] --> Lightkey has joined #Pentagram
[22:51:35] <-- Fingolfin has left IRC ("42")
[23:31:17] --> Kirben has joined #pentagram
[23:31:17] --- ChanServ gives channel operator status to Kirben
[23:31:45] --> Chet1c has joined #pentagram
[23:38:48] <-- Chetic has left IRC (Read error: 145 (Connection timed out))