These are chat archives for arenanet/api-cdi

2nd
Jun 2017
ChieftainAlex
@ChieftainAlex
Jun 02 2017 16:25
It is absolutely ridiculous how happy I am to have cut up the gw1 map using some shitty python script. I had absolutely no idea what I was doing, ended up having to re-install python, GDAL and all the other crap plugins, followed by modifying the original files because they ended up rendering tiles with an inverted y-axis -__- ... all because I refused to use an old version of leaflet and didn't want a watermark >.>
Pat Cavit
@tivac
Jun 02 2017 16:30
hah
that sounds like programming to me!
ChieftainAlex
@ChieftainAlex
Jun 02 2017 18:06
??
like sector polys in /v2/maps instead of /v2/continents/...?
oh
that's gw1
ChieftainAlex
@ChieftainAlex
Jun 02 2017 18:07
^^
/v2/wvw/rewardtracks or just /v2/wvw/tracks
ChieftainAlex
@ChieftainAlex
Jun 02 2017 18:10
I'd go with rewardtracks
v2/wvw/tracks would be the ultimate wvw sniping tool
oh lord
smiley
@codemasher
Jun 02 2017 18:14
a job for @rhoot :D
he's got his hands full already I think
smiley
@codemasher
Jun 02 2017 18:14
i guess so
but for serious, i'd really like to have a list of all language strings in gw1
like skill descriptions other than de/en
windwarrior
@windwarrior
Jun 02 2017 18:36
/v2/wvw/💎🛤️
smiley
@codemasher
Jun 02 2017 18:44
@ChieftainAlex try this tile layer:
https://smiley.codes/maps/for/gw1/tiles/tyria/{z}/{x}/{y}.png
https://smiley.codes/maps/for/gw1/tiles/cantha/{z}/{x}/{y}.png
https://smiley.codes/maps/for/gw1/tiles/elona/{z}/{x}/{y}.png
Edgar Doiron
@Coffee4cr
Jun 02 2017 18:53
I need help
I can't stop watching StockStream
haha
ChieftainAlex
@ChieftainAlex
Jun 02 2017 18:54
@smiley hell yeah. how old is that map?
smiley
@codemasher
Jun 02 2017 18:54
uhh, i made this ages ago
i've all the data in a database in case you need
ChieftainAlex
@ChieftainAlex
Jun 02 2017 18:55
neat. spotted my horrible gw1w "interactive maps" and thought i could do better after playing with gw2's tiles
smiley
@codemasher
Jun 02 2017 18:55
that was my initial goal when gwcom.de went down because the wiki used their map widget
(guildwiki.de)
ChieftainAlex
@ChieftainAlex
Jun 02 2017 18:56
I can see the source so I think anything I'd need from that is there
smiley
@codemasher
Jun 02 2017 18:56
the database holds a bit more, though...
but this repo is outdated
i started to rewrite it at some point over here https://github.com/codemasher/gw1-database
ChieftainAlex
@ChieftainAlex
Jun 02 2017 18:59
alright, that's definitely food for thought, I'm going to aimlessly continue tagging the coordinates of all the markers and labels ^^
smiley
@codemasher
Jun 02 2017 19:22
$q = $db->prepared('SELECT * FROM gw1_bosses WHERE region_id IN(?,?,?,?) ORDER BY mapname', [9,10,11,12]); // cantha


$json = [
    'type' => 'FeatureCollection',
    'features' => []
];

foreach($q as $d){
    $elite = $db->prepared('SELECT name_en FROM gw1_skills_pve WHERE id = ?', [$d['elite']]);

    $json ['features'][] = [
        'type' => 'Feature',
        'geometry' => [
            'type' => 'Point',
            'coordinates' => [round(($d['coord_x']*1.0)+0), round(($d['coord_y']*1.0)+0)]
        ],
        'properties' => [
            'name' => $d['name_en'],
            'prof' => $d['profession'],
            'skill' => is_array($elite[0]) && isset($elite[0]['name_en']) ? $elite[0]['name_en'] : '',
            'skill_id' => $d['elite'],
        ]
    ];
}
Nabrok
@Nabrok
Jun 02 2017 19:26
One thing you could do is prepare the statement before the loop
smiley
@codemasher
Jun 02 2017 19:29
no
that would use a different method id didn't have back then :D
Nabrok
@Nabrok
Jun 02 2017 19:29
Prepare before the loop, then in the loop bind the new $d['elite'] and execute
/shrug
Quaggan BooOOoot
@QuagganBooOOoot
Jun 02 2017 19:30
¯\_(ツ)_/¯
Nabrok
@Nabrok
Jun 02 2017 19:31
Or, I think you could do all in one go with something like SELECT name_en FROM gw1_skills_pve JOIN gw1_bosses ON (gw1_skills_pve.id = gw1_bosses.elite) WHERE region_id IN (?,?,?,?)
smiley
@codemasher
Jun 02 2017 19:32
(that was just a quick & dirty script to put icons on the map - see the source of it :D)
good luck with what ever you are doing next @tivac :heart:
windwarrior
@windwarrior
Jun 02 2017 20:10
good luck on future ventures @tivac!
missing 3 days and 479 commits for nice numbers
windwarrior
@windwarrior
Jun 02 2017 20:17
commit 10.000: I am out!
Eearslya Sleiarion
@Eearslya
Jun 02 2017 20:28
Aw D:
Who's going to be lead, then? This mysterious new guy we haven't met?
Archomeda
@Archomeda
Jun 02 2017 20:34
aww @tivac :sob:
well, good luck with whatever you'll be doing next!
@Eearslya uhhhhhhh
:wave:
Pat Cavit
@tivac
Jun 02 2017 21:27
Yeah don't worry I put the "best" "possible" "person" in charge before I left
darthmaim
@darthmaim
Jun 02 2017 21:27
lol
Pat Cavit
@tivac
Jun 02 2017 21:27
ok quotes around person was unfair
darthmaim
@darthmaim
Jun 02 2017 21:27
:P
Pat Cavit
@tivac
Jun 02 2017 21:27
I'm reasonably confident @lye is a person
wow
Pat Cavit
@tivac
Jun 02 2017 21:28
XD
Eearslya Sleiarion
@Eearslya
Jun 02 2017 21:28
@lye in charge? Oh boy.
darthmaim
@darthmaim
Jun 02 2017 21:29
first thing tomorrow, @lye assigns all other devs to make local api and character rendering a reality
Eearslya Sleiarion
@Eearslya
Jun 02 2017 21:29
HIDE THE IIS SERVERS
Pat Cavit
@tivac
Jun 02 2017 21:29
lmao
darthmaim
@darthmaim
Jun 02 2017 21:29
how long until gw2 runs on FreeBSD?
Pat Cavit
@tivac
Jun 02 2017 21:31
2-3 days
windwarrior
@windwarrior
Jun 02 2017 21:33
wait @lye is not the API server itself
lol
@darthmaim most of the API stuff is outside the normal purview of the web team
I just personally commandeered a bunch of non-web stuff
Eearslya Sleiarion
@Eearslya
Jun 02 2017 21:36
you guys are taking too long, gimme
darthmaim
@darthmaim
Jun 02 2017 21:36
thats not how that leadership delegation thing works :P
windwarrior
@windwarrior
Jun 02 2017 21:36
its the webs team policy now to only deploy at 5pm friday before a long weekend :p?
just to make deploying more exciting
but gratz @lye on the promotion then I guess :>
thanks :>
Archomeda
@Archomeda
Jun 02 2017 22:00
gz! <3
Michael Dougall
@madou
Jun 02 2017 22:32
:sparkles:
man 8 yrs at arenanet @tivac, whats the outside world going to look like !?
Pat Cavit
@tivac
Jun 02 2017 22:35
well today it's bright and sunny
but beyond that, ¯\(°_o)/¯
Michael Dougall
@madou
Jun 02 2017 22:43
you staying in the games industry?
Eearslya Sleiarion
@Eearslya
Jun 02 2017 22:57
it's too sunny, it's weird
won't seattle like..melt?
...shoot, what's the name of that one really weird-shaped building?
JC123
@JC123
Jun 02 2017 23:04
space needle?
Pat Cavit
@tivac
Jun 02 2017 23:10
@madou yeah, I'm gonna still be in games
windwarrior
@windwarrior
Jun 02 2017 23:10
really weird building... hmm
Eearslya Sleiarion
@Eearslya
Jun 02 2017 23:12
No wait, found it, the EMP
seattle's already melting
Michael Dougall
@madou
Jun 02 2017 23:26
@tivac cool man, all the best with the next gig ! bigger and better things hopefully