| *** tpb has joined #tp | 00:00 | |
| *** ChanServ sets mode: +o tpb | 00:00 | |
| tpb | aloril has joined on worldforge | 00:24 |
|---|---|---|
| bddebian | mithro: dh_make will do that for you. Just run it from the source root dir | 00:33 |
| mithro | okay | 00:33 |
| bddebian | Or I can make you one :) | 00:33 |
| bddebian | But it's easy. I just usually use "single binary" and then hack it up from there | 00:33 |
| mithro | bddebian: well i've gotten quite fart | 00:40 |
| mithro | s/fart/far/ | 00:40 |
| mithro | this is what I have so far | 00:40 |
| mithro | Update gccxml deb based on latest CVS code. | 00:40 |
| mithro | * Update bjam deb based on latest bjam release (you seem to need 3.1.16, Ubuntu Hardy only has 3.1.14). | 00:40 |
| mithro | * Create a deb package for pygccxml. | 00:40 |
| mithro | * Create a deb package for pyplusplus. | 00:40 |
| mithro | * Create a deb package for the extra boost-indexing stuff python-ogre uses. | 00:40 |
| mithro | Of course these are very very horrible hacky debs | 00:41 |
| mithro | so I would love your input on them in a bit | 00:41 |
| bddebian | Sure I'm heading for bed shortly but anytime | 00:42 |
| mithro | bddebian: doesn't have to be today | 00:48 |
| bddebian | OK | 00:50 |
| *** bddebian has quit IRC | 00:58 | |
| * llnz wanders home | 01:05 | |
| *** llnz has quit IRC | 01:05 | |
| *** andrei has quit IRC | 01:34 | |
| *** andrei has joined #tp | 01:39 | |
| *** vi1985 has joined #tp | 01:42 | |
| *** JLP has quit IRC | 01:42 | |
| mithro | hello vi1985 | 01:43 |
| vi1985 | hey mithro! | 01:43 |
| * vi1985 just got back from a surrealistic symphony orchestra | 01:45 | |
| mithro | vi1985: cool | 01:55 |
| vi1985 | mithro, hehe I should've had my beer before, not after :) that way, might have enjoyed the music (if you can call it that) | 01:57 |
| *** AquaFox has joined #tp | 02:16 | |
| *** vi1985 has quit IRC | 02:23 | |
| *** JLafont has quit IRC | 03:23 | |
| *** Demitar has joined #tp | 03:55 | |
| *** mithro has quit IRC | 04:43 | |
| *** BZA has joined #tp | 04:49 | |
| *** BZA has left #tp | 04:50 | |
| *** mithro has joined #tp | 04:57 | |
| *** llnz has joined #tp | 05:16 | |
| *** mithro has quit IRC | 06:01 | |
| *** accAgon has joined #tp | 06:19 | |
| llnz | hi all | 06:37 |
| llnz | hi accAgon | 06:37 |
| accAgon | hi llnz | 06:38 |
| Ohm | mithro: for when you ~seen next time, the last few times you've done so it has been in the middle of the night over here. | 06:39 |
| llnz | Ohm: mithro isn't here currently | 06:39 |
| Ohm | I know. | 06:39 |
| llnz | probably on his way home from work | 06:39 |
| Ohm | hm | 06:39 |
| Ohm | he has done ~seen Ohm a few times while I've been away | 06:39 |
| *** karol has joined #tp | 07:05 | |
| llnz | hi karol | 07:08 |
| *** mithro has joined #tp | 07:09 | |
| llnz | wb mithro | 07:09 |
| llnz | figured cause of visible child that doesn't exist | 07:10 |
| mithro | llnz: oh? | 07:10 |
| llnz | the sql for retrieving objects now doesn't take into account the history support | 07:11 |
| llnz | sees all objects that have *ever* been contained in the object | 07:11 |
| mithro | oh | 07:12 |
| llnz | i can't seem to create an sql statement that will give me the right result in one statement | 07:12 |
| llnz | looks like i'll need a loop of them :-( | 07:12 |
| mithro | hrm | 07:12 |
| mithro | tell me what you need | 07:13 |
| llnz | or actually store the child object ids | 07:13 |
| Ohm | hey mithro | 07:13 |
| mithro | hey Ohm | 07:13 |
| Ohm | I've seen you ~seen me a few times, but they've all been in the middle of the night | 07:14 |
| mithro | Ohm: yay timezones | 07:14 |
| Ohm | indeed | 07:14 |
| karol | hi all | 07:14 |
| llnz | mithro: it currently does "SELECT objectid FROM object WHERE parentid = 1" | 07:14 |
| mithro | llnz: and how do you tell the difference between current and older objects? | 07:15 |
| llnz | but have to check each unique result has the highest turnnum for that objectid | 07:15 |
| Ohm | anyways, since studies are raging on again and won't die down for another 6 weeks, I won't be able to put in a lot of work | 07:16 |
| Ohm | but after that I've got summer vacation | 07:16 |
| Ohm | and nothing to do, probably | 07:17 |
| mithro | llnz: oh that is easy to solve | 07:18 |
| mithro | SELECT objectid FROM object WHERE parentid = 1 ORDER BY turnnum GROUP ON objectid | 07:18 |
| mithro | SELECT objectid FROM object WHERE parentid = 1 ORDER BY turnnum GROUP ON objectid HAVING max(turnnum) == turnid | 07:18 |
| mithro | or something like that? | 07:18 |
| llnz | the main issue is that an past child object now has a different parentid and a higher (than previous) turnnum, but the turnnum could be lower than the current turnnum | 07:20 |
| *** Demitar has quit IRC | 07:21 | |
| mithro | llnz: hrm? | 07:22 |
| llnz | the turnnum for each object could be different | 07:22 |
| llnz | hummm.... | 07:22 |
| mithro | what is wrong with the grouping I proposed above? | 07:23 |
| mithro | SELECT objectid, max(turnnum) FROM object WHERE parentid = 1 ORDER BY turnnum GROUP ON objectid | 07:23 |
| mithro | is you had - 10, 1 and 10, 5 your finally result would be 10, 5 | 07:24 |
| llnz | mysql is failing on syntax around "Order by" | 07:24 |
| llnz | eeeeeerrrrrr | 07:24 |
| llnz | no order by, group on | 07:24 |
| mithro | hrm | 07:24 |
| *** Demitar has joined #tp | 07:25 | |
| llnz | for each object on an object-by-object basis, the correct parentid is found by "SELECT parentid FROM object WHERE objectid=xxx order by turnnum limit 1; | 07:27 |
| llnz | " | 07:27 |
| mithro | okay | 07:28 |
| llnz | oh, order by turnnum desc... | 07:28 |
| mithro | llnz: can you dump me some data? | 07:30 |
| llnz | sure | 07:30 |
| * llnz 's sql-foo is weak | 07:30 | |
| mithro | mysqldump | 07:31 |
| llnz | i know that | 07:31 |
| llnz | triming data now | 07:31 |
| llnz | 12MB | 07:32 |
| mithro | llnz: try - SELECT objectid, parentid, max(turnnum) FROM object GROUP BY objectid; | 07:33 |
| llnz | that indeed appears to give the objectid, parentid and the max turnnum for each object | 07:36 |
| mithro | hrm.. that is not right | 07:37 |
| llnz | hummm.... odd | 07:38 |
| llnz | very odd | 07:43 |
| mithro | I know there is a way to do this | 07:43 |
| llnz | is 3.5MB small enough? | 07:48 |
| mithro | yeah | 07:49 |
| mithro | 12 was | 07:49 |
| mithro | SELECT object.objectid, object.parentid FROM object JOIN (SELECT objectid, max(turnnum) as maxturnnum FROM object GROUP BY objectid) AS maxx ON object.objectid = maxx.objectid AND object.turnnum = maxx.maxturnnum; | 07:50 |
| mithro | that is a crappy query | 07:50 |
| mithro | (with my 5 line dataset) | 07:51 |
| llnz | on it's way | 07:51 |
| llnz | try looking at object 1, ie what objects have 1 as parent currently | 07:53 |
| llnz | objects 1012, 1013 and 1014 should *not* appear | 07:54 |
| mithro | SELECT object.objectid, object.parentid FROM object JOIN (SELECT objectid, max(turnnum) as maxturnnum FROM object GROUP BY objectid HAVING maxturnum = ?) AS maxx ON object.objectid = maxx.objectid AND object.turnnum = maxx.maxturnnum | 07:54 |
| mithro | replace ? with the current turn? | 07:55 |
| llnz | doesn't work if the object's turnnum is less that the current turn | 07:58 |
| llnz | ie, run "delete FROM object WHERE objectid=1000 and turnnum = 75;" then try again, 1000 doesn't appear in the objectid column any more | 07:59 |
| llnz | with current turn == 75 | 07:59 |
| llnz | i don't know why they keep being saved | 08:01 |
| llnz | got it! | 08:06 |
| llnz | SELECT object.objectid FROM object JOIN (SELECT objectid, max(turnnum) as maxturnnum FROM object GROUP BY objectid) as maxx ON (object.objectid=maxx.objectid AND object.turnnum = maxx.maxturnnum) where parentid = xxx; | 08:06 |
| llnz | actually, that inner query could be useful in other places... | 08:09 |
| llnz | as well | 08:09 |
| * llnz plays rfts for a bit to see some problems | 08:23 | |
| *** accAgon has quit IRC | 08:25 | |
| mithro | llnz: what was different about your query? | 08:33 |
| mithro | oh? you where trying to find all objects that are a child for a given one? | 08:35 |
| mithro | I didn't realise that :P | 08:35 |
| llnz | yeah | 08:35 |
| mithro | bblr | 08:36 |
| llnz | by tpclient-pywx doesn't seem to want to exit anymore :-( | 08:41 |
| mithro | llnz: oh - yeah I may have introduced that bug | 08:42 |
| mithro | I'll have another look into it a bit later | 08:42 |
| llnz | yay.... NetworkFailureEvent | 08:53 |
| CIA-28 | llnz tpserver-cpp * r5716fd46427d /tpserver/ordermanager.cpp: | 08:59 |
| CIA-28 | Fixed bug with nextOrderQueueId not being set correct using persistence. | 08:59 |
| CIA-28 | OrderManager::init() now asks for the max, and adds one to it. | 08:59 |
| CIA-28 | llnz tpserver-cpp * rafa7d40ac468 /modules/persistence/mysql/mysqlpersistence.cpp: | 09:00 |
| CIA-28 | Fixed query for child object in tpmysql. | 09:00 |
| CIA-28 | Now correct gives only current children, not all children in history. | 09:00 |
| CIA-28 | llnz tpserver-cpp * r08d49a500926 /modules/persistence/mysql/mysqlpersistence.cpp: | 09:17 |
| CIA-28 | Small change so that query will work when generalised to get historic values. | 09:17 |
| CIA-28 | This is in retrieveObject in tpmysql. | 09:17 |
| CIA-28 | llnz tpserver-cpp * rb2cb61a03484 /modules/persistence/mysql/mysqlpersistence.cpp: | 09:43 |
| CIA-28 | Use new found sql-foo to save doing an extra query for each of the two objectparams. | 09:43 |
| CIA-28 | The params are ResourceList and RefQuantityList. Should be easier and less | 09:43 |
| CIA-28 | issues. | 09:43 |
| * llnz wanders off | 09:50 | |
| llnz | later all | 09:50 |
| *** llnz has quit IRC | 09:51 | |
| *** llnz has joined #tp | 09:53 | |
| llnz | i thought of something | 09:53 |
| llnz | this time | 10:03 |
| *** llnz has quit IRC | 10:04 | |
| *** zzorn has quit IRC | 10:25 | |
| *** accAgon has joined #tp | 10:29 | |
| *** Iwanowitch has joined #tp | 10:47 | |
| *** JLafont has joined #tp | 11:06 | |
| *** mithro is now known as [tp]mithro | 11:19 | |
| *** [tp]mithro is now known as tp_mithro | 11:36 | |
| *** tp_mithro is now known as mithro | 11:36 | |
| *** inkscape_ACSpike has joined #tp | 11:36 | |
| *** inkscape_ACSpike has left #tp | 11:36 | |
| *** mithro has quit IRC | 11:36 | |
| *** mithro has joined #tp | 11:37 | |
| *** mithro is now known as tp_mithro | 11:38 | |
| *** tp_mithro is now known as mithro | 11:39 | |
| *** mithro has quit IRC | 11:39 | |
| *** mithro has joined #tp | 11:40 | |
| *** mithro is now known as tp_mithro | 11:41 | |
| *** tp_mithro is now known as mithro | 11:41 | |
| *** mithro is now known as tp_mithro | 11:41 | |
| tp_mithro | napi: ping? | 12:10 |
| *** karol has quit IRC | 12:20 | |
| *** Erroneous has joined #tp | 12:23 | |
| *** JLafont has quit IRC | 12:25 | |
| *** JLafont_ has joined #tp | 12:25 | |
| *** andrei has quit IRC | 12:31 | |
| *** Demitar has quit IRC | 12:32 | |
| *** JLafont_ has quit IRC | 12:35 | |
| napi | tp_mithro; pong | 13:46 |
| tp_mithro | napi: you put in an application to openmrs too? | 13:46 |
| napi | yes | 13:47 |
| tp_mithro | have you had a positive response from them? | 13:47 |
| napi | define "positive" ? :x | 13:47 |
| napi | They havn't said "you've got it" but they seemed happy with the application as far as I can tell | 13:48 |
| *** tp_mithro has quit IRC | 13:51 | |
| napi | hmm | 13:51 |
| napi | not the response I was going for ... lol | 13:51 |
| *** Iwanowitch has quit IRC | 13:53 | |
| *** accAgon has quit IRC | 13:54 | |
| *** tp_mithro has joined #tp | 13:54 | |
| napi | tp_mithro, did you get my response? You DC'd very quick after I typed it | 13:55 |
| tp_mithro | reading logs | 13:56 |
| *** tp_mithro is now known as mithro | 13:56 | |
| *** mithro has quit IRC | 13:56 | |
| *** mithro has joined #tp | 13:56 | |
| *** mithro is now known as tp_mithro | 13:57 | |
| *** zzorn has joined #tp | 13:57 | |
| *** Epyon_ has joined #tp | 14:23 | |
| *** Lukstr has quit IRC | 14:24 | |
| *** Erroneous is now known as bzflag_Erroneous | 14:29 | |
| *** Epyon_ is now known as bzflag_epyon | 14:33 | |
| *** bzflag_epyon is now known as Epyon_ | 14:38 | |
| tpb | aloril_ has joined on worldforge | 14:54 |
| *** AquaFox has quit IRC | 14:54 | |
| tpb | aloril has quit worldforge (Ping timeout: 378 seconds) | 14:59 |
| *** JLafont has joined #tp | 14:59 | |
| tp_mithro | hello JLafont | 15:00 |
| JLafont | hallo | 15:00 |
| JLafont | how is the duplicate resolution thing going? | 15:00 |
| tp_mithro | slowly | 15:07 |
| tp_mithro | JLafont: did you see my comments on your patch? | 15:09 |
| JLafont | yeah, It should be deterministic, at least the generator function takes in a seed. But I think I should probably modify it so the seed is set when the generator is initialized | 15:10 |
| tp_mithro | JLafont: yeah your current thing is borked in that it will generate the same name for everything :P | 15:10 |
| JLafont | I also modified both my local and global gitconfig files but the patches still end up with my laptop name | 15:11 |
| JLafont | tp_mithro, haha yeah, I'll modify it and resubmit | 15:11 |
| tp_mithro | JLafont: you changed your ~/.gitconfig ? | 15:11 |
| JLafont | yeah | 15:11 |
| JLafont | I had to make it | 15:11 |
| tp_mithro | so you need to amend that patch then | 15:12 |
| JLafont | yeah, I'll go do that right now actually | 15:13 |
| JLafont | shouldn't take very long | 15:13 |
| *** zzorn_laptop has joined #tp | 15:29 | |
| *** tp_mithro has quit IRC | 15:43 | |
| JLafont | there we go | 15:44 |
| *** bzflag_Erroneous is now known as Erroneous | 16:20 | |
| *** accAgon has joined #tp | 17:09 | |
| *** accAgon has quit IRC | 17:55 | |
| *** greywhind has quit IRC | 19:16 | |
| *** Lukstr has joined #tp | 20:12 | |
| *** llnz has joined #tp | 20:55 | |
| *** llnz is now known as tp-llnz | 20:56 | |
| *** tp-llnz has quit IRC | 21:05 | |
| *** llnz has joined #tp | 21:05 | |
| llnz | hi all | 21:05 |
| *** bddebian has joined #tp | 21:31 | |
| bddebian | Heya | 21:33 |
| *** Erroneous has quit IRC | 21:42 | |
| *** mithro has joined #tp | 21:49 | |
| *** zzorn_laptop has quit IRC | 22:00 | |
| llnz | hi bddebian, mithro | 22:00 |
| mithro | hey | 22:01 |
| mithro | have to run | 22:01 |
| mithro | seeya! | 22:01 |
| bddebian | Hi llnz, mithro | 22:02 |
| bddebian | Bye mithro | 22:02 |
| Epyon_ | mithro, I understand I've been forfeited? | 22:03 |
| llnz | forfeited? | 22:09 |
| Epyon_ | well elitesec had a mentor, now it hasn't | 22:14 |
| Epyon_ | And there was no attempt on discussing conflicts, so I guess that's it for my apps :/ | 22:14 |
| llnz | duplicates were resolved today | 22:14 |
| llnz | that might be an indication to look at your other applications | 22:15 |
| Epyon_ | So I know, yet I have no info at all :| | 22:15 |
| llnz | that said, i hope you keep working on elitesec, it sounds very interesting | 22:15 |
| llnz | even if it's just a bit of documentation | 22:16 |
| Epyon_ | well, this is something I'm going to work on in my life, one way or the other. I don't believe in Elite IV :P | 22:16 |
| llnz | expect news in three days | 22:17 |
| Epyon_ | Seriously I do :P | 22:17 |
| llnz | bbs | 22:18 |
| *** mithro has quit IRC | 22:19 | |
| *** Epyon_ is now known as Epyon | 22:56 | |
| tpb | aloril__ has joined on worldforge | 23:31 |
| tpb | aloril_ has quit worldforge (Ping timeout: 378 seconds) | 23:33 |
Generated by irclog2html.py 2.17.2 by Marius Gedminas - find it at https://mg.pov.lt/irclog2html/!