These are chat archives for arenanet/api-cdi

27th
Sep 2016
@darthmaim so, re: pvp_rank_points
:fire:
<eof>
darthmaim
@darthmaim
Sep 27 2016 04:36
wow
who thought that would be a good idea
smiley
@codemasher
Sep 27 2016 04:38
wow, you're up early :D
darthmaim
@darthmaim
Sep 27 2016 04:39
not by choice qq
have to work early today...
smiley
@codemasher
Sep 27 2016 04:40
ugh
Archomeda
@Archomeda
Sep 27 2016 04:42
re: re: pvp rank points, i remember that the tiers in the rank point achievements are equal to the pvp ranks:
  • tier 1: rank x0 reached (except the first rank)
  • tier 2: rank x1 reached
  • tier 3: rank x2 reached
  • ...
  • tier 9: rank x8 reached
  • tier 10: rank x9 reached
smiley
@codemasher
Sep 27 2016 04:43
you're all up early D:
Archomeda
@Archomeda
Sep 27 2016 04:43
yeah, i woke up with this
codemasher @codemasher whistles innocenlty
Archomeda
@Archomeda
Sep 27 2016 04:43
(not really)
smiley
@codemasher
Sep 27 2016 04:44
well, let's just say i didn't wake up that early... :D
pulled an all-nighter to get buildwars.net updated with cool stuff
Archomeda
@Archomeda
Sep 27 2016 04:45
:O
(both just a test)
Archomeda
@Archomeda
Sep 27 2016 05:05

but yeah, with the gladiator achievement and cross referencing it with the wiki table:
| Rank | Wiki required points | Achievement required points |
| --- | --- | --- |
| 1 | 0 | 0 |
| 2 | 500 | 1500 |
| 3 | 1000 | 2000 |
| 4 | 1500 | 2500 |
| 5 | 2000 | 4000 |
| 6 | 3500 | 5500 |
| 7 | 5000 | 7000 |
| 8 | 6500 | 8500 |
| 9 | 10500 | 12500 |
| 10 | 14500 | 16500 |
| 11 | 18500 | 20500 |
| 12 | 22500 | 24500 |
| 13 | 26500 | 28500 |
| 14 | 30500 | 32500 |
| 15 | 34500 | 36500 |
| 16 | 38500 | 40500 |
| 17 | 42500 | 44500 |
| 18 | 46500 | 48500 |
| 19 | 54000 | 56000 |

something is weird with the gladiator achievement since the objectives don't really line up with the rank points... but it does for the rank 10+ ones

ehm... did i do table formatting wrong?
i swear i did a table some time ago
smiley
@codemasher
Sep 27 2016 05:09
oh hey, if you find out, feel free to contribute! :D https://github.com/chillerlan/bbcode/tree/master/src/Modules/Markdown
(table module still missing because... ugh :D)
Archomeda
@Archomeda
Sep 27 2016 05:12
oh well ¯\_(ツ)_/¯
tables are not in the original markdown spec, but lots of parsers support it anyway
smiley
@codemasher
Sep 27 2016 05:13
yea, my markdown module is basically github markdown
(or more: should be...)
Archomeda
@Archomeda
Sep 27 2016 05:16
@darthmaim what's your main account total acquired rank points (both api and achievement)? since you're rank 8, i really want to know how messed up that gladiator achievement is compared to what the actual ranking is
Archomeda
@Archomeda
Sep 27 2016 05:23
header 1 header 2 header 3
1 2 3
this should work
>_>
darthmaim
@darthmaim
Sep 27 2016 05:23
:P
total in the API is 7318
Archomeda
@Archomeda
Sep 27 2016 05:23
i probably forgot a new line
so you should have reached tier 9 in the gladiator achievement? 7318/8500?
darthmaim
@darthmaim
Sep 27 2016 05:25
yep
41 / 46 AP
9 / 10 tiers
7,318 / 8,500 objectives (86.09%)
Archomeda
@Archomeda
Sep 27 2016 05:25
and you were rank 8 atm... hm
Rank Wiki required points Achievement required points
1 0 0
2 500 1000
3 1000 1500
4 1500 2000
5 2000 2500
6 3500 4000
7 5000 5500
8 6500 7000
9 10500 8500
10 14500 12500
the 8500 is correct then, in order to reach rank 9
i'm not following this anymore
darthmaim
@darthmaim
Sep 27 2016 05:29
¯\_(ツ)_/¯
Archomeda
@Archomeda
Sep 27 2016 05:31
well good luck figuring this out @queicherius @lye, i'm out
xD
darthmaim
@darthmaim
Sep 27 2016 05:31
:D
Archomeda
@Archomeda
Sep 27 2016 05:32
maybe that's where the hidden 500 rank points comes from, maybe you need 500 to get to rank 1? and before that you're rank 0? :fire:
and you get that 500 points for free or something
doesn't make any sense compared to the gladiator achievement though
darthmaim
@darthmaim
Sep 27 2016 05:34
The account has less exp than the rank requires, so it's run through the migration process from when we changed the rank points (2013? 2014?). The code says "you are level 1, so here's 500 points to make that true".
Archomeda
@Archomeda
Sep 27 2016 05:35
wait, where did you get that?
Archomeda
@Archomeda
Sep 27 2016 05:36
omg
why did i not see that
darthmaim
@darthmaim
Sep 27 2016 05:36
haha
Archomeda
@Archomeda
Sep 27 2016 05:37
i blame sleepiness
sorry @lye :D
Archomeda
@Archomeda
Sep 27 2016 05:42
before people ask, did i just try to formulate my own explanation that somehow matched the actual one without actually knowing it? yes
darthmaim
@darthmaim
Sep 27 2016 05:42
:P
@queicherius you have a table for reference now
Archomeda
@Archomeda
Sep 27 2016 09:32
hmm... @Nabrok, an idea from someone for a bot command: !pact for a list of today's pact supply network agents
but i'm unsure if someone exposed that data as an api
you can even extend that command by adding a !daily command or something :D
Aralicia
@Aralicia
Sep 27 2016 09:40
If it's only the location of the agent, they follow a 7-day routine afaik. No API needed.
Archomeda
@Archomeda
Sep 27 2016 09:41
is it? :O
Aralicia
@Aralicia
Sep 27 2016 09:44
Many "random" things in this game are in fact not random at all, and follow a pattern. Map rewards, for example. It has a 8 weeks cycle.
Archomeda
@Archomeda
Sep 27 2016 09:45
yes, i know that; i just didn't expect it to be on a 7-day cycle though
some things are on a 100-day cycle :|
Aralicia
@Aralicia
Sep 27 2016 09:49
People were pretty surprised about it, as far as I remember. Still it was a pretty minor note at that time.
Archomeda
@Archomeda
Sep 27 2016 10:29
@Coffee4cr ehm... you know you pushed your api key and bot token to your github repo?
Aralicia
@Aralicia
Sep 27 2016 10:42
I must not look for it, I must not look for it, I must not look for it...
David Reeß
@queicherius
Sep 27 2016 10:47
@Archomeda @darthmaim @lye Thanks for the explaination and the table. That is some weird stuff. :D
David Reeß
@queicherius
Sep 27 2016 11:03
@Archomeda This actually makes a lot more sense, thanks for that. I was always wondering why the points / rank changed on e.g. 38 of all things for the wiki.
David Reeß
@queicherius
Sep 27 2016 11:11
I am sad to say that something is still off there. :( I can't do math. Move along.
David Reeß
@queicherius
Sep 27 2016 11:22
darthmaim
@darthmaim
Sep 27 2016 11:59
both my regular and my f2p account now work on gw2e @queicherius :+1:
David Reeß
@queicherius
Sep 27 2016 12:03
:+1: :)
Archomeda
@Archomeda
Sep 27 2016 12:59
:+1:
mine is correct too :D
Archomeda
@Archomeda
Sep 27 2016 13:43
that leaves the question, who wants to update the wiki? :D
Edgar Doiron
@Coffee4cr
Sep 27 2016 13:44
@Archomeda Thanks
Also, I tried merging your !wiki in my branch, but I get an error
Error: Cannot find module 'mwbot'
    at Function.Module._resolveFilename (module.js:325:15)
    at Function.Module._load (module.js:276:25)
    at Module.require (module.js:353:17)
    at require (internal/module.js:12:17)
    at Object.<anonymous> (/home/ubuntu/workspace/features/wiki.js:4:10)
    at Module._compile (module.js:409:26)
    at Object.Module._extensions..js (module.js:416:10)
    at Module.load (module.js:343:32)
    at Function.Module._load (module.js:300:12)
    at Module.require (module.js:353:17)
Archomeda
@Archomeda
Sep 27 2016 13:44
ehm, run npm install?
Edgar Doiron
@Coffee4cr
Sep 27 2016 13:44
oh
Archomeda
@Archomeda
Sep 27 2016 13:45
i've added 2 modules
Edgar Doiron
@Coffee4cr
Sep 27 2016 13:45
that fixes it
thanks
Archomeda
@Archomeda
Sep 27 2016 13:45
:D
Edgar Doiron
@Coffee4cr
Sep 27 2016 13:45
didn't notice package.json was changed
Archomeda
@Archomeda
Sep 27 2016 13:46
honestly, now that i think about it, using a mediawiki api module for this might even be overkill
Edgar Doiron
@Coffee4cr
Sep 27 2016 13:46
lol
so what are you grabbing
cause I did a search for superior sigil of energy
Archomeda
@Archomeda
Sep 27 2016 13:47
ah yes
Edgar Doiron
@Coffee4cr
Sep 27 2016 13:47
and it told me I could get it from salvaging or MF
:P
Archomeda
@Archomeda
Sep 27 2016 13:47
in my testing, it did exactly that i wanted it to do; and it grabs the first paragraph basically
if it exists
but parsing every page is annoying
since not every page is similar
if no paragraph exists, it just returns the url only :|
but here, it got acquisition
Archomeda
@Archomeda
Sep 27 2016 13:49
oh
hehe
Edgar Doiron
@Coffee4cr
Sep 27 2016 13:50
no this is the reason I think getting all that stuff from the api instead, where everything is properly defined, would work better
Archomeda
@Archomeda
Sep 27 2016 13:50
for items definitely
i made the wiki command with things like !wiki agony in mind etc
not for items
Edgar Doiron
@Coffee4cr
Sep 27 2016 13:51
makes sense
lol
Archomeda
@Archomeda
Sep 27 2016 13:52

!wiki living story for example gives:

The Living World in Guild Wars 2 is ArenaNet's official term for changes to the game intended to bring the world of Guild Wars 2 to life. Each major game update includes NPCs, events, and sometimes new instances that tell the story of Tyria's ongoing evolution. Although most of the Living World content has been temporary, these updates also have included permanent changes to the in-game world.

Edgar Doiron
@Coffee4cr
Sep 27 2016 13:52
what about if I type something close, could it give the page title from the result?
Archomeda
@Archomeda
Sep 27 2016 13:53
sadly no
only if there's an existing redirect on the wiki
Edgar Doiron
@Coffee4cr
Sep 27 2016 13:53

!wiki profit

Page title matches
Map bonus reward/profit
This page summarises the potential profit from acquiring and selling all 40 [[map bonus reward]]s for each map on a g {{Map bonus reward profit}}
1 KB (175 words) - 20:33, 20 September 2016

Archomeda
@Archomeda
Sep 27 2016 13:53
mediawiki api is a mess
Edgar Doiron
@Coffee4cr
Sep 27 2016 13:53
kk
Archomeda
@Archomeda
Sep 27 2016 13:54
i haven't found something yet that will give the first search result if an article hasn't been found
but, i think we can all agree that mediawiki's search is terrible anyway
Edgar Doiron
@Coffee4cr
Sep 27 2016 13:54
yep
Archomeda
@Archomeda
Sep 27 2016 14:03
hmm... i wonder, would it be beneficial to include a dockerfile for the bot?
in case you want discordjs 9 and therefore nodejs 6 is required?
Archomeda
@Archomeda
Sep 27 2016 15:01
ah thanks
why is Gift from Mawdrey II the first result >_>
Aralicia
@Aralicia
Sep 27 2016 15:03
Default options are meh.
Archomeda
@Archomeda
Sep 27 2016 15:08
it does, but this seems like it's only doing case insensitive search on the title
which isn't bad, since it's also needed
Archomeda
@Archomeda
Sep 27 2016 15:22
well, i now got case insensitive searching working
through 2 api calls...
Aralicia
@Aralicia
Sep 27 2016 15:23
so... let's have 3 api calls :smile:
Archomeda
@Archomeda
Sep 27 2016 15:24
that's possible
then i'll have 3
because i also call action=parse to get the html text
Aralicia
@Aralicia
Sep 27 2016 15:24
Ha yes.
Archomeda
@Archomeda
Sep 27 2016 15:24
xD
i'll add that too, since it's not a bad idea i guess XD
but first, dinner
Aralicia
@Aralicia
Sep 27 2016 15:25
On that point, you could probably use action=parse directly for some other commands.
Calling directly a template.
Eat well :)
Edgar Doiron
@Coffee4cr
Sep 27 2016 15:26
never code on an empty stomach
Aralicia
@Aralicia
Sep 27 2016 15:29
neither on a full stomach. stomach aren't comfortable. Prefer a armchair.
smiley
@codemasher
Sep 27 2016 15:37
lmao
Edgar Doiron
@Coffee4cr
Sep 27 2016 15:37
lol
Archomeda
@Archomeda
Sep 27 2016 16:06
sadly as far as i can see, i can't combine query/search with parse :(
Aralicia
@Aralicia
Sep 27 2016 16:27
I don't think that's possible. It looks like they are strongly disconnected from each-other.
Archomeda
@Archomeda
Sep 27 2016 16:29
oh well
Much better tile loading algorithm with less flickering.
get updating, map owners
smiley
@codemasher
Sep 27 2016 16:56
oh, thanks for the info, could come in handy :D https://buildwars.net/map.php
btw. anyone here installed apache >2.4.17 /w h2 on debian 8.5 yet?
Aralicia
@Aralicia
Sep 27 2016 16:59
nah. I'm on ubuntu, here. Which makes me think that I haven't looked at package updates recently.
Archomeda
@Archomeda
Sep 27 2016 17:58
Nah i have nginx
David Reeß
@queicherius
Sep 27 2016 18:15
@tivac Hope the update to the account overview makes your Tech Director happy lol. The binding needs #374 to work propperly tho.
#374 depends on me rewriting the entire frontend from callbacks to promises because sadness
async.waterfall doesn't do enough
David Reeß
@queicherius
Sep 27 2016 18:16
Oh boy
and/or I'm just being pedantic
David Reeß
@queicherius
Sep 27 2016 18:17
Well, it semi works for now. No real rush.
The equipment is the only one where it is actually interesting anyway
That one was a super easy fix
Pulling all the item flags to set the flag-based bindings is a bit more annoying is all
(but I really wish this codebase was promise-based, composition is so much easier)
Archomeda
@Archomeda
Sep 27 2016 18:30
Waterfall of tears? :)
Pat Cavit
@tivac
Sep 27 2016 18:39
@queicherius Awesome, thanks!
What does Binding: Character do to the "Bank" section?
windwarrior
@windwarrior
Sep 27 2016 20:43
my computer was complaining about my keyboard, so I replugged it in different USB ports and its fine now... some day I am gonna understand computers, 6 years of CS hasnt done the trick yet
David Reeß
@queicherius
Sep 27 2016 20:49
@tivac If you select "binding: character" you can see all "soulbound" items, then you can select which character they are bound to too next to it
windwarrior
@windwarrior
Sep 27 2016 20:51
exotic scrub :>
David Reeß
@queicherius
Sep 27 2016 20:51
Warrior only needs to press 3 buttons, he can do that in exotic. :P
(and i pretty much only use that character to solo arah)
windwarrior
@windwarrior
Sep 27 2016 20:53
tssk
what, you need to press like 5 buttons
hundo blades, banner, banner, f1, uhh
windwarrior
@windwarrior
Sep 27 2016 20:58
sword 5/4/2, f2, sword primal burst, longbow 2/4, longbow primal burst
and at 50% health sword 3 as well
sword/sword instead of mace/sword for condi war?
windwarrior
@windwarrior
Sep 27 2016 20:59
oh its torch
s/t and lb
havent played power tbh, no clue if the rota is more difficult
mace F1 is super good with condi builds
but you don't get the leap for the fire aura
windwarrior
@windwarrior
Sep 27 2016 21:03
the uhh primal burst, or the normal one?
primal burst
normal is just a stun
windwarrior
@windwarrior
Sep 27 2016 21:03
oh primal I guess, probably useful in PvP/WvW
useless in raids tho :P
oh fair
PvE meh
this is the build I'm thinking of: http://metabattle.com/wiki/Build:Berserker_-_Ragezerker
windwarrior
@windwarrior
Sep 27 2016 21:04
199 Li here ^^
ohh that stun potential
windwarrior
@windwarrior
Sep 27 2016 21:36
lol
we killed gorse while being dead
it literally died while we got killed by his world eater
#eznoupdraftalmostinstaCC
smiley
@codemasher
Sep 27 2016 23:14
// get skills
$sql = 'SELECT skilldata.`id`,
        skilldesc.`pve_name`,
        skilldesc.`pve_desc`,
        skilldesc.`pve_desc_short`,
        skilldesc.`pvp_name`,
        skilldesc.`pvp_desc`,
        skilldesc.`pvp_desc_short`,
        skilldata.`campaign` AS `campaign_id`,
        skilldata.`elite`,
        skilldata.`pve`,
        skilldata.`pvp_split`,
        skilldata.`attribute` AS `attribute_id`,
        skilldata.`'.$mode.'_activation` AS `activation`,
        skilldata.`'.$mode.'_recharge` AS `recharge`,
        skilldata.`'.$mode.'_energy` AS `energy`,
        skilldata.`'.$mode.'_upkeep` AS `upkeep`,
        skilldata.`'.$mode.'_adrenaline` AS `adrenaline`,
        skilldata.`'.$mode.'_sacrifice` AS `sacrifice`,
        skilldata.`'.$mode.'_overcast` AS `overcast`,
        skilldata.`'.$mode.'_type` AS `type_id`,
        profs.`name_'.$lang.'` AS `prof`,
        profs.`id` AS `prof_id`,
        profs.`abbr_'.$lang.'` AS `prof_abbr`,
        attribs.`name_'.$lang.'` AS `attribute`,
        attribs.`primary`,
        attribs.`max` AS `attribute_max`,
        types.`name_'.$lang.'` AS `type`,
        campaigns.`name_'.$lang.'` AS `campaign`
    FROM `gw1_skilldesc_'.$lang.'` AS skilldesc,
        `gw1_skilldata` AS skilldata,
        `gw1_professions` AS profs,
        `gw1_attributes` AS attribs,
        `gw1_skilltypes` AS types,
        `gw1_campaigns` AS campaigns
    WHERE skilldata.`profession` = profs.`id`
        AND skilldata.`attribute` = attribs.`id`
        AND skilldata.`'.$mode.'_type` = types.`id`
        AND skilldesc.`id` = skilldata.`id`
        AND campaigns.`id` = skilldata.`campaign`
        AND skilldata.`id` IN(?,?,?,?,?,?,?,?)';
ahh, good times when it was THAT easy... :D
ha ha ha
smiley
@codemasher
Sep 27 2016 23:15
teheheh
though to be fair, in the future you might consider a structured type (or just something like an hstore) instead of using computed column names
smiley
@codemasher
Sep 27 2016 23:17
yea, that's still the lazy script i still need to dissect :D
gonna rewrite redeemers code, so that my skill database finally finds a use :D
windwarrior
@windwarrior
Sep 27 2016 23:27
isnt there an * in sql, when you want like... everything?
windwarrior @windwarrior uses ORM's all the time
smiley
@codemasher
Sep 27 2016 23:28
everything from... 6 tables.
for 8 skills out of 1500
windwarrior
@windwarrior
Sep 27 2016 23:28
ehh
nevermind
smiley
@codemasher
Sep 27 2016 23:31
btw. @lye the query runs prepared, doubt it matters how the sql string is being computed (as long as there's no user input in there)
eh i'm pedantically a purist
smiley
@codemasher
Sep 27 2016 23:50
heh
(tbh, i'm paranoid, too. but probably in a different way :D)