| 00:07.28 | *** join/#wowuidev Trela (~Alexia@c-71-207-245-20.hsd1.al.comcast.net) |
| 00:18.28 | *** join/#wowuidev MentalPower (~textual@WoWUIDev/Norganna/Administrator/MentalPower) |
| 00:18.28 | *** mode/#wowuidev [+v MentalPower] by ChanServ |
| 00:21.56 | *** join/#wowuidev User632 (~U632@173.51.205.208) |
| 00:22.02 | *** join/#wowuidev Kodiack (~Colton@96-42-240-206.dhcp.roch.mn.charter.com) |
| 00:30.07 | *** join/#wowuidev kd3 (~Kaydeethr@wowwiki/Kaydeethree) |
| 00:31.43 | kd3 | ugh. if I never see another shipping pallet again it will be too soon |
| 00:34.19 | Kraps | http://us.battle.net/wow/en/forum/topic/7005435990?page=8#143 |
| 00:34.30 | Kraps | just end it |
| 00:34.39 | Kraps | kill everyone |
| 00:34.48 | Kraps | salt the earth |
| 00:43.24 | Primer | For what blizz is doing or for that quoted dude? |
| 00:49.08 | kd3 | emails out |
| 00:50.08 | kd3 | nevcairiel, your email bounced |
| 00:54.27 | pompy1 | http://clientsupport.curse.com/ticket.aspx?id=33067 heh, disclaimer: brain may assplode. |
| 00:54.49 | kd3 | eesh |
| 01:00.06 | kd3 | no~ the worldserver crashed just as I was about to open up on a rare |
| 01:00.07 | kd3 | damn it all |
| 01:02.11 | Shirik | server went "wait a sec kd3's not allowed to have this ASSERTIONFAILURE" |
| 01:03.54 | Shirik | pompy1: awesome |
| 01:06.55 | pompy1 | haha. |
| 01:09.54 | Shirik | loooooooooool |
| 01:09.56 | Shirik | https://petitions.whitehouse.gov/petition/deport-everyone-signed-petition-withdraw-their-state-united-states-america/dmQl1bXL |
| 01:23.43 | *** join/#wowuidev Sum_Wun (~sum_wun@65.36.101.251) |
| 01:25.44 | TC-work | Shirik: Where is petition to deport people that signed a petition to deport people. |
| 01:26.00 | TC-work | Sad part is i know there are people that would sign it in all honesty. |
| 01:34.24 | Shirik | http://www.cbsnews.com/8301-201_162-57548600/cops-ariz-woman-runs-over-husband-for-not-voting/ |
| 01:35.40 | *** join/#wowuidev Funkeh` (~funk@5ad4d5c3.bb.sky.com) |
| 01:35.41 | *** join/#wowuidev Funkeh` (~funk@WoWUIDev/WoWAce/Ace3/BigWigs/funkeh) |
| 01:49.49 | *** join/#wowuidev vhaarr (~folk@ti0013a380-dhcp2261.bb.online.no) |
| 01:49.49 | *** join/#wowuidev vhaarr (~folk@WoWUIDev/WoWAce/Rabbit/vhaarr) |
| 01:54.03 | Semlar | http://i.imgur.com/wpQ5d.jpg aw yeah, i finally got transformed zones working with the terrain textures |
| 02:06.02 | Semlar | i may be alone in my passion for cartography |
| 02:06.23 | kd3 | http://www.cleveland.com/metro/index.ssf/2012/11/cleveland_woman_holds_idiot_si.html |
| 02:13.06 | kd3 | does grid support the role icons? I can't seem to find it anywhere |
| 02:14.13 | Semlar | http://www.youtube.com/watch?v=ZPkE2hHneP4 |
| 02:18.48 | *** join/#wowuidev Kaylin (~Kaylin@c-67-201-226-158.reshall.wwu.edu) |
| 02:19.53 | Semlar | i should get a dash cam |
| 02:23.12 | Wobin | anyone know the signature of SetTradeSkillCategoryFilter ? |
| 02:24.27 | Semlar | it takes category and optional subcategory |
| 02:28.35 | pompy1 | Shirik: http://kutv.com/news/top-stories/stories/utah-country-thousands-sign-petition-utah-secede-2764.shtml?wap=0 |
| 02:30.55 | *** join/#wowuidev tardmrr (~tardmrr@WoWUIDev/WoWI/Dongle/Tem) |
| 02:30.55 | *** mode/#wowuidev [+v tardmrr] by ChanServ |
| 02:32.01 | *** join/#wowuidev Kodiack1 (~Colton@96-42-240-206.dhcp.roch.mn.charter.com) |
| 02:32.22 | pompy1 | kd3: http://www.wowace.com/addons/gridstatusrole/ |
| 02:32.31 | *** join/#wowuidev Therzok (~Therzok@p16.eregie.pub.ro) |
| 02:33.05 | *** join/#wowuidev jnwhiteh (~jnwhiteh@WoWUIDev/WoWI/Featured/Dongle/cladhaire) |
| 02:33.05 | *** mode/#wowuidev [+o jnwhiteh] by ChanServ |
| 02:34.47 | Shirik | pompy1: I think if Utah became a country it would be the first ever country surrounded by another country |
| 02:34.53 | Shirik | That being said UTAH HAS NOTHING IN IT |
| 02:36.57 | Kaylin | vatican city |
| 02:42.09 | Ressy | Meanwhile, Austin Texas wants no part of being its own country: https://petitions.whitehouse.gov/petition/peacefully-grant-city-austin-texas-withdraw-state-texas-remain-part-united-states/TDD212hQ |
| 02:42.22 | Ressy | seriously, these petitions on the WH site are nonsense |
| 02:42.54 | Ressy | well, I wouldn't say all of them are. Just a large number of them are. |
| 02:44.01 | Shirik | omg |
| 02:44.05 | Shirik | that would be so amazing |
| 02:44.20 | Shirik | the first ever donut country |
| 02:44.31 | Semlar | can i just secede from north florida |
| 02:45.19 | Shirik | Peacefully grant the remaining United States of America a Pizza Party furnished by Pizza Hut and Papa Johns (unless he keeps laying off his workers) should the State of Missouri succeed with one or both of their petitions to the White House to Secede from the Union. |
| 02:45.22 | Shirik | this is getting stupid |
| 02:46.38 | Semlar | it's the only place where the more north you go the more south it gets |
| 02:52.41 | *** join/#wowuidev Caleb| (~Caleb|@1F2E9F4A.dsl.pool.telekom.hu) |
| 02:55.10 | Wobin | Semlar: so only two arguments? |
| 02:55.47 | Semlar | as far as i can tell |
| 02:56.27 | Semlar | if you call like SetTradeSkillCategoryFilter(1) it only shows the first collapsible category in the tradeskill window |
| 02:58.07 | Semlar | SetTradeSkillCategoryFilter(0) resets it |
| 03:00.33 | Semlar | i think the index corresponds to whatever's under the SubClass menu in the filter dropdown |
| 03:02.11 | Wobin | Semlar: ta muchly |
| 03:12.47 | *** join/#wowuidev Droolio (~drool@host86-179-173-193.range86-179.btcentralplus.com) |
| 03:21.16 | *** join/#wowuidev iShirik (~shirik@WoWUIDev/WoWIStaff/Norganna/StatisticalEngineer/Shirik) |
| 03:21.16 | *** mode/#wowuidev [+o iShirik] by ChanServ |
| 03:41.25 | Arrowmaster | kd3: they are going to show the madoka movie in ohio! |
| 03:41.29 | kd3 | ! |
| 03:41.47 | Arrowmaster | but on the opposite fucking side of the state from me |
| 03:41.57 | kd3 | still worth a drive |
| 03:42.03 | Arrowmaster | its a 4 hour drive |
| 03:43.52 | Arrowmaster | oh its on the 4th, i have tickets for TSO on the 6th so i guess theres enough time that i could make it back |
| 04:00.29 | *** join/#wowuidev Esamynn (~chatzilla@WoWUIDev/WoWI/Featured/Esamynn) |
| 04:00.29 | *** mode/#wowuidev [+v Esamynn] by ChanServ |
| 04:05.37 | *** join/#wowuidev vhaarr (~folk@WoWUIDev/WoWAce/Rabbit/vhaarr) |
| 04:12.22 | *** join/#wowuidev Trela (~Alexia@c-71-207-245-20.hsd1.al.comcast.net) |
| 04:12.45 | *** join/#wowuidev Trela (~Alexia@c-71-207-245-20.hsd1.al.comcast.net) |
| 04:13.09 | *** join/#wowuidev Trela (~Alexia@c-71-207-245-20.hsd1.al.comcast.net) |
| 04:37.24 | *** join/#wowuidev Antiarc (~Instantbi@ip98-165-104-202.ph.ph.cox.net) |
| 04:39.26 | Fisker | thanks a lot kd3 |
| 04:45.23 | *** join/#wowuidev Antiarc (~Instantbi@98.165.104.202) |
| 04:46.50 | *** join/#wowuidev MentalPower (~textual@WoWUIDev/Norganna/Administrator/MentalPower) |
| 04:46.50 | *** mode/#wowuidev [+v MentalPower] by ChanServ |
| 04:47.50 | *** join/#wowuidev Iriel (~Iriel@173-8-135-209-SFBA.hfc.comcastbusiness.net) |
| 04:47.50 | *** mode/#wowuidev [+o Iriel] by ChanServ |
| 04:48.51 | *** join/#wowuidev Trela (~Alexia@71.207.245.20) |
| 04:54.44 | *** join/#wowuidev ShaunDreclin (~ShaunDrec@184.145.91.168) |
| 04:58.53 | *** join/#wowuidev iShirik (~shirik@WoWUIDev/WoWIStaff/Norganna/StatisticalEngineer/Shirik) |
| 04:58.53 | *** mode/#wowuidev [+o iShirik] by ChanServ |
| 05:05.53 | *** join/#wowuidev Kraps (~chatzilla@69.114.203.17) |
| 05:06.17 | Arrowmaster | Fisker: got any tips on setting up a guest account on 4.2 |
| 05:06.26 | Fisker | just create a new account |
| 05:06.35 | Fisker | i just called it guest for shit and giggles |
| 05:06.39 | Arrowmaster | i did but it doesnt see any of my apps |
| 05:06.50 | Fisker | i do not believe it is supposed to? |
| 05:07.19 | Arrowmaster | right but how the hell can i give it access to apps without adding an account to it and installing from the play store |
| 05:09.37 | Fisker | guess you need to |
| 05:09.51 | Fisker | maybe if you got root |
| 05:09.55 | *** join/#wowuidev nilyaK (~Kaylin@c-67-201-227-50.reshall.wwu.edu) |
| 05:10.14 | Fisker | you may be able to get the apk installed simply from the other user |
| 05:10.43 | *** join/#wowuidev Seerah (~RyanNL@adsl-98-66-63-250.mem.bellsouth.net) |
| 05:10.43 | *** mode/#wowuidev [+o Seerah] by ChanServ |
| 05:14.47 | Fisker | yeah you need some kind of account for now |
| 05:15.50 | Arrowmaster | well i just threw a different pin lock on the user and ill figure it out then later or let somebody else figure it out first |
| 05:21.13 | Fisker | aha |
| 05:21.15 | Fisker | i might've found shit |
| 05:21.47 | TC-Away | we do not want to know where your ass has been |
| 05:22.33 | Fisker | baw |
| 05:22.35 | Fisker | didn't work |
| 05:25.06 | Fisker | got it |
| 05:26.22 | Fisker | not sure if it works with paid stuff though |
| 05:26.40 | Fisker | but basically you need to use an adb shell and the package manager |
| 05:26.59 | Fisker | pm -r /path/to/apk.apk |
| 05:27.03 | Fisker | while logged in as the other user |
| 05:32.54 | Fisker | yeah don't think paid apps is happening |
| 05:35.51 | kd3 | oh wow. good thing I didn't lfr the instant the servers came up |
| 05:35.56 | kd3 | getting saved on a wipe? |
| 05:40.07 | Ressy | fixed it pretty quickly |
| 05:40.15 | Ressy | considering... |
| 06:08.46 | *** join/#wowuidev karl_w_w (~karl@61.116.96.58.static.exetel.com.au) |
| 06:14.04 | *** part/#wowuidev Seerah (~RyanNL@adsl-98-66-63-250.mem.bellsouth.net) |
| 06:17.08 | *** join/#wowuidev Kurapica (~chatzilla@58.247.109.243) |
| 06:26.47 | *** join/#wowuidev tem (~tardmrr@WoWUIDev/WoWI/Dongle/Tem) |
| 06:26.47 | *** mode/#wowuidev [+v tem] by ChanServ |
| 06:39.33 | *** join/#wowuidev kd3 (~Kaydeethr@wowwiki/Kaydeethree) |
| 06:48.25 | *** join/#wowuidev rtharper (~tomh@c83-250-218-181.bredband.comhem.se) |
| 06:48.26 | *** join/#wowuidev rtharper (~tomh@unaffiliated/sioraiocht) |
| 06:52.17 | *** join/#wowuidev iShirik (~shirik@WoWUIDev/WoWIStaff/Norganna/StatisticalEngineer/Shirik) |
| 06:52.19 | *** mode/#wowuidev [+o iShirik] by ChanServ |
| 06:55.35 | Fisker | Stanzilla |
| 06:56.44 | *** join/#wowuidev tardmrr (~tardmrr@WoWUIDev/WoWI/Dongle/Tem) |
| 06:56.44 | *** mode/#wowuidev [+v tardmrr] by ChanServ |
| 06:59.05 | *** join/#wowuidev Aurorus (~Aurorus@unaffiliated/aurorus) |
| 07:08.17 | *** join/#wowuidev nilyaK (~Kaylin@c-67-201-227-50.reshall.wwu.edu) |
| 07:13.39 | *** join/#wowuidev cbreak-work (~cbreak@drz-wizzer.drz.ethz.ch) |
| 07:17.53 | *** join/#wowuidev Neffi (~Neffi@pool-98-116-218-107.nycmny.fios.verizon.net) |
| 07:24.37 | *** join/#wowuidev |Paradox| (~iamparado@c-71-57-196-26.hsd1.va.comcast.net) |
| 07:26.39 | *** join/#wowuidev Hazal (~Mikkel@94.145.13.67) |
| 07:27.50 | nevcairiel | kd3: oh, right, i stoped using that domain, can you send it to h.leppkes@gmail.com in the future? |
| 07:28.52 | *** join/#wowuidev iShirik (~shirik@WoWUIDev/WoWIStaff/Norganna/StatisticalEngineer/Shirik) |
| 07:28.52 | *** mode/#wowuidev [+o iShirik] by ChanServ |
| 07:38.07 | *** join/#wowuidev Elkano (~elkano@pool016.vpn.uni-saarland.de) |
| 07:38.07 | *** join/#wowuidev Elkano (~elkano@WoWUIDev/WoWAce/Elkano) |
| 07:39.50 | *** join/#wowuidev User632 (~U632@71.110.116.202) |
| 08:07.29 | *** join/#wowuidev TC-Away (~TC@99.50.80.110) |
| 08:07.29 | *** join/#wowuidev TC-Away (~TC@WoWUIDev/PITA/TC) |
| 08:19.19 | *** join/#wowuidev Kalroth (~md@77.68.162.16) |
| 08:19.50 | *** join/#wowuidev Antze (~Antze@77.238.236.80) |
| 08:25.01 | *** join/#wowuidev Monolit (~Strigoy@89.112.4.92.pppoe.eltel.net) |
| 08:57.51 | *** join/#wowuidev F16Gaming (F16Gaming@p6-691d-5e0c.10m.i.exo.me.uk) |
| 08:59.26 | Stanzilla | Fisker |
| 09:02.04 | *** join/#wowuidev wereHamster (~tomc@azeroth.caurea.org) |
| 09:02.11 | *** join/#wowuidev flyth (~flyth@78.46.52.72) |
| 09:04.24 | *** join/#wowuidev Fisker (~ballmer@2a01:4f8:d12:1104:d1e:d1e:d1e:d1e) |
| 09:07.54 | *** join/#wowuidev F16Gaming (F16Gaming@p6-691d-5e0c.10m.i.exo.me.uk) |
| 09:23.29 | *** join/#wowuidev Darkchaos (~darkchaos@i59F79C9A.versanet.de) |
| 09:35.26 | *** join/#wowuidev wereHamster (~tomc@unaffiliated/werehamster) |
| 09:39.30 | *** join/#wowuidev brykrys (~chatzilla@cpc4-craw2-0-0-cust16.16-3.cable.virginmedia.com) |
| 09:39.30 | *** join/#wowuidev brykrys (~chatzilla@WoWUIDev/Norganna/Dev/Brykrys) |
| 09:43.28 | *** join/#wowuidev Caribou| (~Caribou@81.240.114.53) |
| 09:51.18 | AcidWeb | Somebody here want GW2 15-18 november trial? |
| 09:53.08 | *** join/#wowuidev brykrys (~chatzilla@cpc4-craw2-0-0-cust16.16-3.cable.virginmedia.com) |
| 09:53.10 | *** join/#wowuidev brykrys (~chatzilla@WoWUIDev/Norganna/Dev/Brykrys) |
| 09:57.17 | Fisker | Stanzilla |
| 09:57.38 | Stanzilla | Fisker: shipping tomorrow |
| 09:57.43 | Stanzilla | according to play store |
| 09:58.12 | Fisker | :( |
| 09:58.16 | Fisker | d i c k s |
| 10:02.50 | Fisker | what is this fucking shit? |
| 10:02.56 | Fisker | Already been sent in the UK |
| 10:03.43 | Fisker | nothing like a tracking number yet right? |
| 10:04.27 | *** join/#wowuidev galaris__ (~galaris@91.82.242.69) |
| 10:06.22 | Neffi | p |
| 10:09.20 | *** join/#wowuidev brykrys (~chatzilla@WoWUIDev/Norganna/Dev/Brykrys) |
| 10:13.47 | Fisker | starts rustling Stanzilla |
| 10:14.08 | Stanzilla | no |
| 10:14.17 | Fisker | :( |
| 10:14.27 | Fisker | racist google |
| 10:19.12 | *** join/#wowuidev Kodiack (~Colton@96-42-240-206.dhcp.roch.mn.charter.com) |
| 11:01.41 | *** join/#wowuidev Dewin (~Daniel@c-76-28-131-143.hsd1.wa.comcast.net) |
| 11:43.01 | karl_w_w | oh look |
| 11:43.07 | karl_w_w | ipv6 fixes for win 7 |
| 11:45.54 | Fisker | i won't look karl_w_w |
| 11:50.00 | karl_w_w | fine then, see if i care! |
| 11:52.06 | *** join/#wowuidev SPt_Apollo (uid3263@gateway/web/irccloud.com/x-rpmikgrjnyxowsob) |
| 12:22.05 | *** join/#wowuidev klip (klip@gollum.klapka.cz) |
| 12:44.17 | *** join/#wowuidev Darkchaos (~darkchaos@i59F4A205.versanet.de) |
| 13:01.04 | *** join/#wowuidev Therzok (~Therzok@p16.eregie.pub.ro) |
| 13:25.15 | *** join/#wowuidev Jitta (Jitta@91-65-44-29-dynip.superkabel.de) |
| 13:34.07 | *** join/#wowuidev alestane (~alestane@174.63.97.69) |
| 13:34.08 | *** mode/#wowuidev [+v alestane] by ChanServ |
| 13:50.40 | *** join/#wowuidev Ingela (~Ingela@213.66.222.210) |
| 14:06.03 | *** join/#wowuidev Lopeppeppy (~Lopeppepp@141.222.29.125) |
| 14:06.04 | *** mode/#wowuidev [+v Lopeppeppy] by ChanServ |
| 14:10.43 | *** join/#wowuidev Liath (~Liath@adsl-99-21-137-64.dsl.hstntx.sbcglobal.net) |
| 14:10.43 | *** join/#wowuidev Liath (~Liath@unaffiliated/liath) |
| 14:14.04 | *** join/#wowuidev CM_Derel1ct (~CM_Derel1@108-202-218-180.lightspeed.rcsntx.sbcglobal.net) |
| 14:14.39 | *** part/#wowuidev CM_Derel1ct (~CM_Derel1@108-202-218-180.lightspeed.rcsntx.sbcglobal.net) |
| 14:14.43 | *** join/#wowuidev Ressy (~resa1983@unaffiliated/ressy) |
| 14:14.50 | *** join/#wowuidev CM_Derel1ct (~CM_Derel1@108-202-218-180.lightspeed.rcsntx.sbcglobal.net) |
| 14:36.52 | *** join/#wowuidev Telshin (~textual@76.164.170.2) |
| 14:36.55 | *** part/#wowuidev Paul1 (~Paul1@212.224.70.58) |
| 14:38.59 | *** join/#wowuidev Liath (~Liath@adsl-99-21-137-64.dsl.hstntx.sbcglobal.net) |
| 14:38.59 | *** join/#wowuidev Liath (~Liath@unaffiliated/liath) |
| 14:41.40 | *** join/#wowuidev Baraius (~brianhudd@173.227.74.50) |
| 14:48.07 | *** join/#wowuidev Baraius_ (~brianhudd@23.21.72.1) |
| 14:54.16 | *** join/#wowuidev shifuimam (~shifuimam@72.205.51.228) |
| 14:59.25 | *** join/#wowuidev Vlad| (~Vlad|@128.121.45.31.customer.cdi.no) |
| 15:00.37 | Vlad| | being internet-less since Monday, with most of the day it being down, feels kind of nice |
| 15:00.49 | *** part/#wowuidev CM_Derel1ct (~CM_Derel1@108-202-218-180.lightspeed.rcsntx.sbcglobal.net) |
| 15:01.22 | nevcairiel | for us too |
| 15:02.26 | Vlad| | job interview went nice I think, filling out 10 pages form to get security clearance :P |
| 15:02.39 | Vlad| | bet in comparison to the US one it's really short |
| 15:05.11 | mitch0 | I didn't have to fill out any security clearance form... (not in the US though) |
| 15:08.29 | *** join/#wowuidev Hazal (~Mikkel@94.145.13.67) |
| 15:09.50 | *** join/#wowuidev adtywhyz (~iamparado@c-71-57-196-26.hsd1.va.comcast.net) |
| 15:17.32 | *** join/#wowuidev Baraius_ (~brianhudd@173.227.74.50) |
| 15:27.23 | *** join/#wowuidev mgopaikmul (~iamparado@c-71-57-196-26.hsd1.va.comcast.net) |
| 15:31.21 | *** join/#wowuidev MentalPower (~textual@WoWUIDev/Norganna/Administrator/MentalPower) |
| 15:31.21 | *** mode/#wowuidev [+v MentalPower] by ChanServ |
| 15:31.25 | *** join/#wowuidev Mihau (~Mihau@76.164.170.2) |
| 15:32.27 | *** join/#wowuidev |Paradox| (~iamparado@c-71-57-196-26.hsd1.va.comcast.net) |
| 15:37.19 | *** join/#wowuidev egeksp (~iamparado@c-71-57-196-26.hsd1.va.comcast.net) |
| 15:47.53 | *** join/#wowuidev Unkle (~Unkle@50-0-113-124.dedicated.static.sonic.net) |
| 15:48.58 | *** join/#wowuidev Ooglogput (~Ooglogput@h77-53-157-182.dynamic.se.alltele.net) |
| 15:51.55 | *** join/#wowuidev Unkle_ (~Unkle@50-0-113-123.dedicated.static.sonic.net) |
| 15:59.44 | Vlad| | Xuerian :D |
| 16:00.02 | Vlad| | Semlar :D |
| 16:02.13 | pompy1 | Vlad| :D |
| 16:02.20 | Vlad| | hi to you too pompy1 |
| 16:02.25 | Vlad| | why the 1? :D |
| 16:02.39 | pompy1 | internet probs |
| 16:02.46 | Vlad| | :D |
| 16:02.50 | Vlad| | yeah had that too |
| 16:10.23 | Vlad| | what's new on the addon front? |
| 16:17.41 | *** join/#wowuidev cawaker (~cawaker@66.27.163.187) |
| 16:20.14 | *** join/#wowuidev nilyaK (~Kaylin@c-67-201-227-50.reshall.wwu.edu) |
| 16:23.22 | Semlar | hey vlad |
| 16:25.26 | Semlar | http://i.imgur.com/wpQ5d.jpg i got terrain maps working for the transformed zones |
| 16:29.40 | Neffi | transformed zones? |
| 16:30.20 | Semlar | zones that are technically part of another map |
| 16:30.37 | Semlar | the blood elf zones, the space cow zones |
| 16:30.39 | Neffi | how did you get them working seemlessly? |
| 16:30.41 | Neffi | db? |
| 16:30.50 | Semlar | still just the api |
| 16:31.14 | Semlar | just had to figure out how the math worked for them |
| 16:31.15 | Neffi | heh |
| 16:31.26 | Neffi | i didnt think it did |
| 16:31.35 | Neffi | figured the game stitched them with a db |
| 16:32.03 | Semlar | it does actually |
| 16:32.22 | Neffi | but you stitched them with math |
| 16:32.22 | Semlar | i believe i saw a table in the dbc files specifically for the minimap tiles |
| 16:32.51 | Semlar | yeah i just used some math based on the yards sizes and offsets of the maps |
| 16:33.04 | Semlar | since every minimap tile is the same size |
| 16:33.08 | Neffi | oh i c |
| 16:33.26 | Semlar | i mean it's not perfect, if you go over an area without tiles you get green boxes |
| 16:33.33 | Semlar | but i can get around that |
| 16:33.45 | Neffi | you can filter those to black, no? |
| 16:33.49 | Semlar | plus that's usually only if you go into the ocean |
| 16:34.11 | Neffi | wel blue in that case |
| 16:34.18 | Neffi | afaik that's what the game does |
| 16:34.57 | Semlar | i actually was going to take the nearest tile to the edge that existed, crop it to an edge pixel and then expand it over the whole background and hide the missing tiles |
| 16:35.15 | Semlar | which should basically give me the right color of the background |
| 16:35.31 | Neffi | makes sense unless it's not a pretty edge |
| 16:35.47 | Neffi | I wish you could read the bitmap of textures |
| 16:36.17 | Semlar | i wish you could check if a texture existed while you were setting it |
| 16:36.38 | Semlar | as it stands it's not that easy to detect |
| 16:37.02 | nevcairiel | why would you try to set a texture which doesnt exist |
| 16:37.08 | Semlar | :( |
| 16:37.15 | Neffi | nax, he's working with minimap tiles |
| 16:37.24 | Neffi | you dont necessarily know if one exists |
| 16:37.34 | Semlar | you should still be able to get feedback as to whether the texture you're setting succeeded or not |
| 16:37.43 | nevcairiel | you used to before 5.0 |
| 16:37.48 | Semlar | yeah.. |
| 16:37.58 | *** join/#wowuidev g0urra (~g0urra@unaffiliated/gourra) |
| 16:38.03 | Neffi | Didnt you come up with a way Semlar? |
| 16:38.11 | Semlar | i did but it sucks |
| 16:38.15 | Neffi | By checking if the resulting texture has the size of the green texture? |
| 16:38.29 | Semlar | i have to wait for the texture to load so there's a little delay |
| 16:38.58 | Semlar | so i have to use this queue-like system |
| 16:39.20 | Semlar | i guess it could build a cache for itself |
| 16:40.02 | Neffi | you could have it work to build a cache in the background over time |
| 16:40.11 | Neffi | so in the timespan of maybe an hour, it knows all the tiles in existence |
| 16:40.17 | Neffi | then clear it when a new patch is detected |
| 16:40.31 | Semlar | yeah |
| 16:41.56 | Semlar | oh there is one thing, if i want to support more minimap tiles than just for the continents i do have to keep a table of internal map names |
| 16:42.08 | Semlar | at least ones that don't match what you get from GetMapInfo |
| 16:42.17 | Neffi | you should do that |
| 16:42.44 | Semlar | if i'm going to store those i might as well store a little more about them that you can't get in game |
| 16:42.49 | Neffi | it'd be strange if your map just didnt work for Vash;jr |
| 16:43.02 | Semlar | >_> |
| 16:43.16 | Semlar | depends on whether you want the surface terrain or not |
| 16:43.32 | Neffi | which works by default? |
| 16:43.35 | Neffi | underwater or surface? |
| 16:44.29 | Semlar | http://i.imgur.com/LzfRJ.jpg |
| 16:45.11 | Neffi | looks funny |
| 16:46.34 | Semlar | i don't know for sure what it takes to access the underwater tiles but i THINK they just have something like "noliquid" in the file path |
| 16:48.23 | Vlad| | Semlar: isn't the issue like caves or houses... |
| 16:48.31 | Vlad| | when you enter a house the outside world is unloaded |
| 16:48.39 | Vlad| | same with submerging into water isn't it? |
| 16:48.48 | Semlar | no |
| 16:49.53 | Semlar | http://i.imgur.com/KJGPt.jpg |
| 16:50.47 | Vlad| | I mean |
| 16:50.58 | Vlad| | when you enter vashjir and submerge in the water the minimap will change and show the bottom |
| 16:51.03 | Vlad| | and not the surface minimap textures |
| 16:51.04 | Semlar | when you go indoors they start using objects to build the minimap |
| 16:51.15 | Neffi | objects? |
| 16:51.22 | Neffi | like tree and bench objects? |
| 16:51.45 | Semlar | i think they're just called wmo or world map objects |
| 16:51.56 | Vlad| | when you fly above the water (not submerged) the minimap shows the upper layer, above the water and islands, like your picture Semlar |
| 16:52.02 | Vlad| | when you submerge it changes to show the lower level ;) |
| 16:52.06 | Vlad| | that's what I was talking about |
| 16:52.19 | Semlar | i'm pretty sure underwater vashjir still uses terrain tiles |
| 16:52.32 | Semlar | probably |
| 16:52.57 | Semlar | if it doesn't i don't really have to worry about it because there is no way i'm going to support indoor minimap stuff |
| 16:52.58 | Vlad| | I am just saying, I don't know if you can view vashjir water minimap while not being under water youself :P |
| 16:53.14 | Vlad| | could leave a hole for a plugin to step in and add this feature no? |
| 16:53.33 | Semlar | oh i suppose |
| 16:53.50 | Semlar | the code's a mess right now from all my testing, i need to clean it all up |
| 16:54.00 | Vlad| | no worries |
| 16:56.12 | Semlar | ironforge must be indoors |
| 16:56.12 | Neffi | dont worry, nobody cares about If |
| 16:56.12 | Semlar | because my map is just going to show the outside of the mountain |
| 16:56.26 | Semlar | well, it probably doesn't matter too much anyway because you would have to zoom in a LOT to a map as small as ironforge for it to fade the terrain in |
| 16:56.37 | *** join/#wowuidev Dewin (~Daniel@c-76-28-131-143.hsd1.wa.comcast.net) |
| 16:56.49 | Semlar | i based the alpha on the scale of the map to make sure it didn't start fading out before you could read it |
| 16:57.04 | *** join/#wowuidev brykrys (~chatzilla@cpc4-craw2-0-0-cust16.16-3.cable.virginmedia.com) |
| 16:57.05 | *** join/#wowuidev brykrys (~chatzilla@WoWUIDev/Norganna/Dev/Brykrys) |
| 16:57.18 | Semlar | so with smaller maps you have to be zoomed in closer for them to disappear |
| 16:57.51 | Vlad| | david petraeus resignes |
| 16:57.52 | Vlad| | ? |
| 16:57.59 | Semlar | yeah he's a slut |
| 16:58.02 | nevcairiel | you're so last week |
| 16:58.17 | Vlad| | lol |
| 16:58.25 | Vlad| | because he was in an affair? |
| 16:58.34 | Vlad| | don't sound that bad :P |
| 17:01.33 | *** join/#wowuidev stolenlegacy (~stolenleg@unaffiliated/stolenlegacy) |
| 17:01.57 | Semlar | i had to stop using GetContinentMapInfo because it was mixing up kalimdor and ek |
| 17:03.29 | Semlar | their map ids are 0 and 1 and the function gets the wrong one for both |
| 17:06.11 | Semlar | actually if you want to play with an extremely buggy preview with really messy code i could upload this somewhere |
| 17:06.51 | Neffi | i might like to |
| 17:07.00 | Semlar | it's practically unnavigable without using the in-game map to switch continents |
| 17:07.21 | Semlar | i'll fix that later |
| 17:07.54 | Neffi | that's what i said about DK runes on my UFs |
| 17:08.02 | Neffi | still not fixed 6 months later |
| 17:08.05 | Semlar | >_> |
| 17:08.11 | Neffi | damn DKs |
| 17:09.22 | Vlad| | Papa John's bit on the daily show was funny :p |
| 17:11.56 | Vlad| | http://www.thedailyshow.com/watch/tue-november-13-2012/post-democalyptic-world---whine-country---employee-benefits :P |
| 17:14.06 | Semlar | http://semlar.com/BitMap.zip map demo if you want to play with it |
| 17:16.05 | Semlar | just keep in mind you'll probably have to use the normal game map to help it navigate around |
| 17:16.56 | Semlar | especially since i didn't add buttons for the maelstrom or the cosmos map |
| 17:20.07 | Semlar | and half the stuff in the ui file is going to get moved over to the core |
| 17:29.28 | *** join/#wowuidev foxlit (~foxlit@188.177.103.242) |
| 17:40.15 | Semlar | it's super inefficient right now because of how i'm doing the terrain map |
| 17:40.36 | Lopeppeppy | I'm locked in. All alone. Spoooooooky office is spooky. |
| 17:40.46 | Semlar | who's behind you |
| 17:41.01 | Lopeppeppy | A huge picture window for the velociraptors to use as an entryway. |
| 17:41.20 | Semlar | excellent |
| 17:42.03 | Arrowmaster | lol http://www.salon.com/2012/11/13/gallup_is_very_upset_at_nate_silver/ |
| 17:42.12 | Lopeppeppy | I try to provide for the raptor and zombie takeovers. |
| 17:42.40 | Semlar | that's very thoughtful |
| 17:43.25 | Semlar | i'm sure they'll appreciate it as they're eating your brains |
| 17:43.34 | Vlad| | <3 Semlar |
| 17:43.48 | Vlad| | now I get to bash your coding! |
| 17:44.00 | Semlar | that doesn't count because that is a horrible example of my coding |
| 17:44.02 | Vlad| | as we all know that is the purpose of showing code on irc :P |
| 17:44.26 | Vlad| | I am joking, I wouldn't ,maybe nevcairiel or adys would bash :P |
| 17:44.38 | Adys | who's talking shit on php? |
| 17:44.51 | Semlar | this is like looking at an artist's work before it's even halfway complete |
| 17:45.27 | Vlad| | don't worry Semlar ;) |
| 17:46.10 | Lopeppeppy | We're not unreasonable, no one's gonna eat your eyes. |
| 17:46.26 | Vlad| | not all of us here are unresonable no :P |
| 17:46.54 | Vlad| | Adys I wanted to code a PHP file to compile an EXE for me customized for the person that is downloading. |
| 17:47.50 | Vlad| | 's spell has been resisted by Adys. |
| 17:48.15 | *** join/#wowuidev Kalroth (~Kalroth@d40aa5af.rev.stofanet.dk) |
| 17:49.15 | Semlar | does everyone need a different exe |
| 17:49.41 | Vlad| | it's cool to bake in some variables instead of having a zip with an exe and a config file for example ^^ |
| 17:50.22 | Semlar | a config file would probably make more sense and would be a lot easier to do |
| 17:50.42 | Vlad| | the purpose isn't to be able to edit these variables |
| 17:50.49 | Arrowmaster | hahaha awesome http://imgur.com/u4kn4 |
| 17:53.54 | Lopeppeppy | Taxidermy makes for some very-funny. |
| 17:56.25 | *** join/#wowuidev Elkano (~elkano@pool021.vpn.uni-saarland.de) |
| 17:56.26 | *** join/#wowuidev Elkano (~elkano@WoWUIDev/WoWAce/Elkano) |
| 18:01.12 | Neffi | Adys: A fractal of... blah, fuck it |
| 18:03.24 | Lopeppeppy | A fractal fuck. *giggle snort* |
| 18:03.30 | Neffi | lol |
| 18:03.41 | Neffi | Manglebrot is giggling in his grave |
| 18:03.42 | nilyaK | oh god I can see forever? |
| 18:04.14 | Neffi | I was referring to my standard troll when people refer to PHP being good: http://me.veekun.com/blog/2012/04/09/php-a-fractal-of-bad-design/ |
| 18:06.05 | pompy | Vlad|: yeah, they digged through his emails and found out about his affair. |
| 18:06.32 | Vlad| | is it legal to dig around private mails like that? |
| 18:06.44 | Vlad| | was it the police or news organizations? :P |
| 18:09.32 | pompy | FBI |
| 18:09.36 | pompy | "“As a general matter, the government cant get into your email unless they are conducting an investigation of a crime,” he told ABCNews.com." |
| 18:10.00 | Semlar | on the other hand i'm pretty sure they can get information about you from your isp without a warrant |
| 18:10.00 | nilyaK | s/can't/isn't supposed to |
| 18:10.41 | pompy | http://abcnews.go.com/blogs/technology/2012/11/online-anonymity-nearly-impossible-broadwells-emails-show/ |
| 18:11.36 | *** join/#wowuidev Liath (~Liath@adsl-99-21-137-64.dsl.hstntx.sbcglobal.net) |
| 18:11.36 | *** join/#wowuidev Liath (~Liath@unaffiliated/liath) |
| 18:12.31 | Vlad| | define the scenery http://imgur.com/r/WTF/OIjzZ |
| 18:13.30 | pompy | overly disgusting. |
| 18:16.46 | Lopeppeppy | Crusty. |
| 18:17.03 | Lopeppeppy | Looks like sewage backup after a natural disaster. I hope. |
| 18:17.13 | Lopeppeppy | But the beer bottles tell me it's a squatted house or something. |
| 18:22.09 | karl_w_w | <Vlad|> define the scenery http://imgur.com/r/WTF/OIjzZ <- puzzling |
| 18:25.11 | *** join/#wowuidev Arrow|phone (~arrow@WoWUIDev/WoWAce/ResponsibleForEverythingAndNothing/Arrowmaster) |
| 18:34.07 | Cairenn | oh ugh ... Vlad|, give a person some warning |
| 18:34.09 | Cairenn | ewwwwww |
| 18:34.15 | Vlad| | :P |
| 18:34.27 | Vlad| | you're a mom, you've probably seen that in a babys diaper already |
| 18:35.26 | *** join/#wowuidev Arrow|tablet (~arrow@WoWUIDev/WoWAce/ResponsibleForEverythingAndNothing/Arrowmaster) |
| 18:39.37 | TC-work | IN the diaper, not all over the table surrounding it |
| 18:40.24 | Ressy | lawlz. You haven't seen a blow out then. |
| 18:40.38 | Vlad| | back in school, I once did see something similar, not so much, bit there was poo on the walls and on the seat and on the floor, I wonder how they did it ... |
| 18:40.39 | TC-work | Only in a tire |
| 18:40.39 | Vlad| | :P |
| 18:41.51 | Semlar | stahp |
| 18:46.19 | *** join/#wowuidev MidnightAge (~midnight@50-90-9-206.res.bhn.net) |
| 18:56.18 | alestane | Really, is there a reason for this discussion? |
| 18:56.51 | Semlar | anyway |
| 18:56.54 | Semlar | http://i.imgur.com/D6MRi.jpg |
| 18:57.05 | *** join/#wowuidev Unkle (~Unkle@50-0-113-124.dedicated.static.sonic.net) |
| 18:58.23 | Semlar | this is probably one of my favorite screenshots |
| 18:59.10 | cawaker | thats a rad shot, like it was made with a fisheye lens |
| 18:59.20 | Semlar | i was drunk |
| 19:00.05 | cawaker | lol i love the drunk effects |
| 19:00.06 | Semlar | if you disable the drunk haze you still get the crazy fisheye effect |
| 19:00.35 | Neffi | Devs: We want to keep the rogue fixes in 5.1 conservative. 5.1: Wound Poison does 33% more damage! |
| 19:00.56 | Neffi | Why do they think it's ok for a class to simply suck for half an expansion? |
| 19:01.42 | Vlad| | there is a problem with rogues? |
| 19:02.18 | Neffi | In PvP I feel like I'm made of paper |
| 19:02.25 | Neffi | Except paper might have some mobility thanks to wind |
| 19:02.26 | Semlar | http://raidbots.com/dpsbot/Overall_DPS/10N/100/14/60/default/ dps seems alright |
| 19:02.42 | Neffi | Semlar: Yeah in PvP it's a very different story |
| 19:02.56 | Neffi | We can't sustain any damage thanks to: gimp survivability and no mobilit |
| 19:03.12 | Semlar | so you're saying you're like a warrior now |
| 19:03.24 | Vlad| | lol... no wonder my MM hunter sucks at dps :P |
| 19:03.26 | Lopeppeppy | Regex - what Shakespeare tortured us with! |
| 19:03.50 | Neffi | Semlar: I'm saying warriors and sub rogues switched places between Cata and MOP |
| 19:03.54 | Vlad| | lol arcane mage sucks too, like already two of the four classes I love to play (with those specs) are low on dps :3 |
| 19:04.06 | Neffi | Why is it that most classes either have to be OP or totally gimp? |
| 19:04.14 | foxlit | Lopeppeppy: but it's one of the easiest and most beautiful things, CS-wise? |
| 19:04.36 | alestane | Simplest, maybe. I don't know if "easy" is the right word. |
| 19:05.29 | Neffi | or beautiful |
| 19:07.23 | Vlad| | anyone else thought the first minutes of "Up", the introduction movie, was much better than the movie itself? :P |
| 19:08.32 | Semlar | haven't seen it |
| 19:09.19 | Semlar | it's not really the kind of movie i would watch |
| 19:09.35 | TC-work | It's a good movie |
| 19:09.42 | Semlar | yeah i only watch bad movies |
| 19:09.45 | alestane | Vlad|, I wouldn't watch it without the rest of the movie there for it to set up. |
| 19:09.59 | Vlad| | the opening bit is like 3 minutes but when I think of Up I always think of the intro :P |
| 19:10.11 | TC-work | Semlar: really? So you have seen Iron Sky? |
| 19:10.15 | Vlad| | ofc it makes you wanna watch the rest of the movie, alestane;) |
| 19:10.20 | Semlar | no i haven't seen all bad movies |
| 19:10.25 | TC-work | ... |
| 19:11.06 | Semlar | i haven't actually heard of it |
| 19:11.25 | Vlad| | it's a sad and happy intro :< |
| 19:11.41 | Semlar | i've seen frankenfish |
| 19:12.05 | Vlad| | talking about bad movies? |
| 19:12.38 | Vlad| | I raise you http://twitchfilm.com/assets_c/2012/11/Sharknado-thumb-300xauto-34828.jpg |
| 19:12.54 | Semlar | how does it compare to sharktopus |
| 19:13.04 | Lopeppeppy | Two headed shark is the bestest bad movie I've seen recently. |
| 19:13.07 | TC-work | and nothing beats bad movies for Mega shark VS. Giant Octopus. Right Lopeppeppy? |
| 19:13.37 | Lopeppeppy | Compares equivalently with MegaShark vs. Giant Octoups and MegaShark versus Megacroc |
| 19:13.39 | Vlad| | still, a tornado out of sharks must be less likely than a sharkoctopus right? |
| 19:13.39 | Vlad| | :P |
| 19:13.51 | Vlad| | at least those animals could exist, a shark tornado, not so much |
| 19:13.58 | Semlar | what about dinocroc vs supergator |
| 19:14.07 | Lopeppeppy | Haven't seen, sounds a hoot. |
| 19:14.10 | Semlar | okay i think we've covered enough scifi originals |
| 19:14.10 | TC-work | tornado no. But hurricane yes |
| 19:14.12 | Lopeppeppy | Piranha 3D is classy. |
| 19:14.23 | TC-work | imdb.com |
| 19:14.28 | TC-work | ... |
| 19:14.32 | TC-work | #@*($&#@^$*(& |
| 19:14.35 | Semlar | prianhaconda |
| 19:14.48 | Semlar | these have to be automatically generated |
| 19:14.58 | Vlad| | snakeosaurus |
| 19:16.08 | Lopeppeppy | Love the trashy SciFi movies! |
| 19:17.08 | pompy | how about a fire tornado? |
| 19:17.10 | pompy | http://www.wptv.com/dpp/news/world/fire-tornado-australian-outback-video-fiery-phenomenon-caught-on-video-by-chris-tangey-goes-viral |
| 19:17.28 | Vlad| | I became teary in under 5 minutes lol |
| 19:17.42 | Vlad| | damn I'm such a pussy |
| 19:17.49 | Semlar | we were worried about a firecane when katrina swept through the gulf after the oil spill |
| 19:19.43 | Vlad| | I like the comment on the Up: Love Story bit "Pixar made a better love story in 8 minutes then twilight did in 3 movies." :P |
| 19:20.07 | Semlar | but it lacked vampires |
| 19:20.22 | Semlar | strike 1, pixar |
| 19:20.24 | Vlad| | because as twilight prooves, vampires makes the love story so much better :P |
| 19:20.27 | Vlad| | lol |
| 19:20.44 | Semlar | literally any situation could be improved by adding vampires |
| 19:20.58 | Semlar | that's just rule 1 of cinematography |
| 19:21.11 | Vlad| | f(n) = 2^n |
| 19:21.20 | Semlar | better with vampires |
| 19:21.22 | *** join/#wowuidev ShadniX (shadow1st@b045.apm.etc.tu-bs.de) |
| 19:21.28 | Vlad| | f(n) predicts the "how better things are" the n vampires you have |
| 19:21.45 | Semlar | i'm not sure if it's an exponential growth rate |
| 19:22.04 | Neffi | <PROTECTED> |
| 19:22.05 | Semlar | there's probably an ideal number of vampires that it peaks at |
| 19:22.34 | Vlad| | :P |
| 19:22.36 | Semlar | let's call it the golden count |
| 19:23.25 | Lopeppeppy | 0. |
| 19:23.31 | Lopeppeppy | 25 werewolves though. And one ghoul. |
| 19:23.55 | Vlad| | windows update actually has updates for me :P |
| 19:23.56 | Semlar | so f(v) = 0v + 25w + 1g |
| 19:24.04 | Vlad| | haven't had any for months now |
| 19:24.32 | Semlar | i suppose that should take more arguments |
| 19:24.33 | Vlad| | Semlar: typo? |
| 19:24.36 | Vlad| | 0v? |
| 19:24.43 | alestane | http://www.crispygamer.com/sites/default/files/comics/backward/backward-2010-01-13_Publish.jpg |
| 19:24.44 | Vlad| | you mean 2^v ? |
| 19:24.45 | Semlar | he said no vampires |
| 19:24.48 | Vlad| | aah |
| 19:25.01 | Semlar | which is clearly wrong |
| 19:25.03 | Semlar | the math doesn't work |
| 19:25.04 | Vlad| | f(v,w,g)=0v+25w+1g |
| 19:25.15 | Semlar | numbers don't lie |
| 19:25.22 | Vlad| | oh |
| 19:25.25 | Vlad| | google has a fancy feature |
| 19:25.28 | Vlad| | plots graphs now |
| 19:25.28 | Vlad| | :P |
| 19:25.46 | Vlad| | https://www.google.com/search?source=ig&rlz=&q=25x%2B1y&oq=25x%2B1y&gs_l=igoogle.3...80807.83666.0.83874.8.7.0.1.0.0.50.320.7.7.0...0.0...1ac.2j1.99_zFGVyQPI |
| 19:26.14 | Semlar | 3D charts require a web browser and system that support WebGL. |
| 19:26.28 | Vlad| | isn't it a browser side feature? |
| 19:26.29 | Semlar | yeah you wish |
| 19:26.39 | Vlad| | meaning it works for your opera, chrome, firefox, e.g.? |
| 19:26.40 | Semlar | i don't have video card drivers installed |
| 19:26.42 | Vlad| | ah |
| 19:27.07 | Vlad| | oh haven't gotten any responses on my html5 "time" tag suggestion :( |
| 19:27.08 | Semlar | they apparently aren't necessary to do much |
| 19:28.35 | Semlar | have you had a chance to play with the map yet |
| 19:40.16 | alestane | Some way in SQL to select the most recent instance of every combination of two columns, along with a third column from the same row? |
| 19:40.58 | *** join/#wowuidev Thunder_Child (~TC@99-50-80-110.lightspeed.lsanca.sbcglobal.net) |
| 19:40.59 | *** join/#wowuidev Thunder_Child (~TC@WoWUIDev/PITA/TC) |
| 19:48.04 | TC-work | what the hell is up with my computer |
| 19:49.59 | Neffi | I think its graphs have a computational limit |
| 19:50.08 | Neffi | because I fed it a very large polynomial and got a straight line |
| 19:51.32 | *** join/#wowuidev Esamynn|Away (~chatzilla@WoWUIDev/WoWI/Featured/Esamynn) |
| 19:51.33 | *** mode/#wowuidev [+v Esamynn|Away] by ChanServ |
| 19:52.08 | TC-work | <PROTECTED> |
| 19:52.31 | alestane | TC-work: I have a table with three columns (that I care about). |
| 19:53.46 | TC-work | but i mean, recent as in updated, created, access? |
| 19:53.55 | alestane | I need each unique combination of values for columns a and b, along with the value of column c that accompanies the newest record in the table containing that combination. |
| 19:54.12 | alestane | recent in this case can be determined by the value of a fourth column. |
| 19:56.16 | TC-work | what am i missing? because it me it would be SELECT `column_c` WHERE `column_a` = 'x' AND `column_b` = 'x' |
| 19:57.58 | TC-work | well, SELECT `column_a`, `column_b`, `column_c` FROM `table_name` WHERE |
| 19:58.05 | TC-work | i should have done that properly |
| 19:58.23 | alestane | I want every combination in which a and b appear, though. |
| 20:00.18 | TC-work | like WHERE (`column_a` = '1' AND `column_b` = '2') OR (`column_a` = '2' AND `column_b` = '1') OR etc. |
| 20:00.58 | TC-work | s/like/like,/ |
| 20:01.25 | TC-work | i really need to '' everything since 'like' is also a valid term |
| 20:02.09 | *** join/#wowuidev Paul1 (~Paul1@212.224.70.58) |
| 20:03.56 | Vlad| | since we are talking sql |
| 20:04.01 | Vlad| | I have a particual problem |
| 20:04.06 | Lopeppeppy | You don't want much, do ya alestane? |
| 20:04.20 | alestane | A stiff drink would be nice. |
| 20:04.29 | Lopeppeppy | *giggle snark* |
| 20:04.39 | Vlad| | firstname and lastname are two colls in my database, thing is firstname can contain middlename too, and I want to query and match parts of the query in both firstname and lastname, how would you code the query? |
| 20:05.02 | TC-work | us use LIKE and % that is your wildcard |
| 20:05.09 | TC-work | you use* |
| 20:05.20 | Vlad| | I mean |
| 20:05.38 | Vlad| | ("kim long", "thong") if I query "long th" because I don't remember kim |
| 20:05.44 | Vlad| | it won't work :P need to concat |
| 20:06.42 | TC-work | or you use the wildcard in both. WHERE `first` IS LIKE %long% AND `second` IS LIKE %th% |
| 20:06.46 | TC-work | or something similar |
| 20:07.55 | TC-work | - the IS |
| 20:07.58 | *** join/#wowuidev Semlar (~chatzilla@72.188.127.100) |
| 20:08.25 | nevcairiel | doing name-based searches that are also intuitive and dont return too many results is rather complex, i've been working on our phonebook application at work the last few weeks |
| 20:08.50 | TC-work | thats why i do all sql stuff in python and use variables |
| 20:08.50 | nevcairiel | (also performance considerations, wildcard at the start doesnt play well with huge databases) |
| 20:09.38 | TC-work | well, when i can. Right now it's in PHP and i seem to be breaking it by adding a LEFT JOIN |
| 20:09.42 | TC-work | which is rather anoying |
| 20:09.48 | nevcairiel | i hardly ever write manual sql |
| 20:09.51 | nevcairiel | its all ORM these days |
| 20:09.56 | *** join/#wowuidev Seerah (~RyanNL@adsl-98-66-63-250.mem.bellsouth.net) |
| 20:09.56 | *** mode/#wowuidev [+o Seerah] by ChanServ |
| 20:10.11 | nevcairiel | at the worst, some abstraction of SQL like JPQL |
| 20:11.59 | Vlad| | sql can't concat strings? :D |
| 20:12.18 | nevcairiel | sure can |
| 20:12.31 | nevcairiel | depending on flavor, in mysql its CONCAT('A', 'B') |
| 20:12.31 | Vlad| | if I concat first then do the like part problem solved |
| 20:12.44 | nevcairiel | in pgsql its 'A' || 'B' |
| 20:13.09 | Vlad| | :D |
| 20:13.12 | nevcairiel | oracle is the same as pgsql |
| 20:13.18 | nevcairiel | any other flavors? :p |
| 20:14.09 | nevcairiel | mssql apparently uses 'A'+'B' |
| 20:14.17 | nevcairiel | gotta hate this :p |
| 20:14.39 | Vlad| | so 'A'||'B' is fine but 'A'+'B' you hate? |
| 20:14.40 | Vlad| | :P |
| 20:14.53 | Semlar | 'A'|||'B' |
| 20:14.56 | nevcairiel | i hate the differences betwen sql syntax |
| 20:15.07 | nevcairiel | although it seems oracle also understands concat(...) |
| 20:15.32 | nevcairiel | considering i really only work with oracle and pgsql these days, i'm happy either way |
| 20:15.38 | nevcairiel | they usually are pretty similar |
| 20:18.19 | Neffi | you know you're bored when you're plotting ever more complicated functions to see how strange the graph can look |
| 20:19.36 | *** join/#wowuidev rtharper (~tomh@unaffiliated/sioraiocht) |
| 20:31.50 | Ackis | Arrowmaster, Fisker: is there a way to enter shift codes for borderlands 2 online and have them link to your xbox/ps3 version? |
| 20:31.57 | TC-work | nevcairiel: is JPQL just a java front end for interacting with any DB? |
| 20:32.27 | TC-work | or is it it's own DB |
| 20:33.09 | nevcairiel | its a sql-like query language, just an abstraction of all the different sql flavors |
| 20:33.26 | nevcairiel | so no own db |
| 20:33.28 | Fisker | do i loke like a console n00b Ackis ? |
| 20:33.45 | TC-work | so it connects to any existing DB structure then? |
| 20:33.53 | nevcairiel | yea |
| 20:34.17 | TC-work | nifty, though the value seems to be limited |
| 20:34.29 | nevcairiel | better then writing vendor specific sql |
| 20:37.09 | TC-work | I dunno, i write all of my stuff for CLI or simple web pages, seems silly to do it in java |
| 20:37.55 | Fisker | it's hot in here nevcairiel |
| 20:38.13 | TC-work | rubs up against Fisker |
| 20:39.39 | *** join/#wowuidev galaris (~galaris@91.82.242.69.pool.invitel.hu) |
| 20:56.21 | *** join/#wowuidev kd3 (~Kaydeethr@wowwiki/Kaydeethree) |
| 21:09.39 | TC-work | http://www.engadget.com/2012/11/13/microsoft-warns-gamers-directx-11-1-is-windows-8-only/ |
| 21:09.59 | Fisker | old |
| 21:10.13 | TC-work | doesn't mean everyone knows it |
| 21:10.21 | Fisker | didn't say it did |
| 21:10.49 | TC-work | you just like to point out the obvious then? |
| 21:11.17 | TC-work | I'm sure your special ed teacher will give you a gold star |
| 21:11.28 | Fisker | i'm sure |
| 21:15.59 | *** join/#wowuidev punk (~cawaker@cpe-66-27-163-187.socal.res.rr.com) |
| 21:25.11 | *** join/#wowuidev bjelleklang (~chris@wikipedia/Bjelleklang) |
| 21:32.30 | *** join/#wowuidev durcyn (~durcyn@WoWUIDev/Durcyn) |
| 21:36.47 | *** join/#wowuidev |Jelly|_ (~|Jelly|@c-98-234-60-111.hsd1.ca.comcast.net) |
| 21:45.34 | *** join/#wowuidev haste (haste@zelda.ixo.no) |
| 22:36.43 | *** join/#wowuidev A-KO (as@2601:a:f00:1f:6490:5c80:1fd1:d88b) |
| 22:36.44 | *** join/#wowuidev A-KO (as@unaffiliated/a-ko) |
| 22:57.33 | *** join/#wowuidev Primer (~daniel@www.ceregatti.org) |
| 23:05.50 | Arrowmaster | Primer: are there color codes in your rDNS? |
| 23:06.51 | Arrowmaster | nvm its just this client seeing the www and colorizing it for some reason |
| 23:07.18 | *** join/#wowuidev Primer (~daniel@www.ceregatti.org) |
| 23:08.51 | *** join/#wowuidev Dark_Elf (~Dark_Elf@h75-100-159-238.wdrnin.broadband.dynamic.tds.net) |
| 23:08.59 | *** join/#wowuidev Seerah1 (~RyanNL@adsl-98-66-63-250.mem.bellsouth.net) |
| 23:08.59 | *** mode/#wowuidev [+o Seerah1] by ChanServ |
| 23:09.23 | Arrowmaster | fucking tea partiers http://thinkprogress.org/health/2012/11/14/1187181/wisconsin-lawmakers-arrest-obamacare/ |
| 23:12.52 | A-KO | lol |
| 23:13.40 | A-KO | They REALLY don't understand how the law in this country works, do they? |
| 23:13.57 | A-KO | "The Constitution" = What's on Paper + Supreme Court rulings |
| 23:14.01 | *** join/#wowuidev Wa (~wa@50.45.208.4) |
| 23:14.21 | A-KO | That's the job of the Supreme Court--to interpret the Constitution. Not to mention, the majority of the Supreme Court Justices are Conservatives |
| 23:14.27 | A-KO | and they make some really whacky decisions sometimes |
| 23:14.40 | A-KO | (SuperPACs, Arbitration, etc.) |
| 23:16.29 | *** join/#wowuidev Ressy (~Ressy@unaffiliated/ressy) |
| 23:21.20 | *** join/#wowuidev wereHamster (~tomc@azeroth.caurea.org) |
| 23:28.50 | Vlad| | I got tired of lash players, so I made my userscript to replace some of the players with a custom slick and lightweight one :3 |
| 23:34.56 | Vlad| | going to bed soon |
| 23:35.05 | Vlad| | any suggestions what dream I should watch tonight? |
| 23:44.22 | Vlad| | hilarious |
| 23:44.42 | Vlad| | "UFO caught on video in Denver CO?" |
| 23:44.56 | Vlad| | well, if you don't know what it is then yes, you saw a unidentified flying object... |
| 23:45.34 | Vlad| | I like how UFO is basically used like alien vehicle these days, jeez. |
| 23:45.46 | Vlad| | educate yourselves people :P |
| 23:46.50 | Vlad| | gn then, channel is dead atm :P |
| 23:46.56 | *** join/#wowuidev MysticalOS (~Myst@h146.15.91.75.dynamic.ip.windstream.net) |
| 23:51.50 | *** join/#wowuidev Torhal (~torhal@c-71-207-224-241.hsd1.al.comcast.net) |
| 23:55.23 | pompy | http://sphotos-b.xx.fbcdn.net/hphotos-ash3/579205_10152275019460370_215866329_n.jpg |
| 23:55.36 | Wobin | "“Just because Obama was re-elected does not mean he’s above the constitution,” Kapenga said." |
| 23:56.09 | Wobin | Is this another "It's unconstitutional because I SAY IT IS, NYAAH!"? |
| 23:56.18 | ZorbaTHut | which is technically true, but they seem to have conveniently forgotten that we just *had* a Supreme Court case to determine whether Obamacare is constitutional or not |
| 23:57.03 | Wobin | I just get a mental image of them going "It's UNCONSTITUTIONAL... TIMES INFINITY... PLUS ONE. HAHAAH" |
| 23:57.12 | ZorbaTHut | http://www.theonion.com/articles/area-man-passionate-defender-of-what-he-imagines-c,2849/ as usual, the onion is prophetic |
| 23:57.46 | Wobin | Your country is truly in trouble when the satire is indistinguishable from the reality |
| 23:57.56 | Wobin | and when the reality is too unbelieveable to satirise. |
| 23:58.30 | TC-work | That's not making me feel better |
| 23:58.45 | Dark_Elf | its gonna be in even more trouble if they dont pass the bush tax cuts by dec 31 |
