Card queries [season 3 queries available]

[The Northern Light]

---

Card Queries

---

Produced by The North Pacific Cards Guild

---

TL;DR: Easily search through all 350 thousand cards using the card queries and advanced card queries pages!

What is this?

Have you ever wondered how many cards there are in The North Pacific? How many of them are legendary, epic, or ultra-rare? Or how many of them have golden badges?

Have you ever wanted to embark on collecting these sorts of cards, only to realize you do not even know which cards you need to collect? And how could you know - there are, after all, more than 350 thousand cards in both seasons, making it practically impossible to go through them one by one.

Card queries are here to help!

To help you answer these questions, be it to satisfy your curiosity, plan your collections, or for any other reason, we created the card queries and advanced card queries pages.

These pages make it easy to parse the official XML list of cards. For example, to get all the cards of The North Pacific, with the WA badge but without the delegate badge, and of uncommon rarity, you can open the card queries page, and enter the query:

+region:the_north_pacific, +badge:wa, -badge:delegate, +rarity:uncommon

Upon clicking "submit", you will be provided with a list (IDs, names, and links) of the cards satisfying the above criteria. And that's it!

How do I use the card queries pages?

Both the card queries and advanced card queries pages include detailed use instructions. The pages also list all of the options you can use to search for cards. These include, among other things, badges, rarities, regions, trophies, and many more!

You can combine these options to form more complicated queries. Additionally, you can search for cards of either season. Finally, you can select from among a few different formatting options for the results, depending on what is the most convenient for you.

How is the advanced card queries page different?

Compared to the original version, the advanced card queries page allows making more complicated queries. In particular, whereas the original version allows only doing conjunctions (logical AND) between different (potentially negated, i.e., logical NOT) options, the advanced version allows using arbitrary combinations of disjunctions (logical OR) and conjunctions.

For example, using the advanced version, you can do a query of the form: "cards that have The North Pacific as region, and have either badge 'Admin' or badge 'Moderator'." Using the original version, this requires doing two queries, one for "cards that have The North Pacific as region, and have badge 'Admin'", another for "cards that have The North Pacific as region, and have badge 'Moderator'", and then manually merging the results from the two queries.

You can also use the advanced version to combine the decks of multiple puppets (use an OR to combine deck options), implement exclusive OR (XOR) operations (e.g., "cards that have either badge 'Admin' or badge 'WA', but not both), and so on. See this page for inspiration.

Please note that the card queries and advanced card queries pages use different syntax.

Which version should I use?

That is up to you to decide. The card queries uses (arguably) simpler syntax, very similar to the one used by NationStates for telegramming multiple nations. The advanced card queries page can do everything the simpler version can, and a lot more; but it uses (arguably) more complicated syntax.

You are welcome to use whichever version you prefer. You also do not have to commit to just one or the other version: both will remain available and you are welcome to switch back and forth as you like.

Can I call the card queries from my scripts?

Yes, you can! You can directly send GET requests to the daemon serving the advanced card queries page. Here is an example GET request using cURL:

Code: Select all

curl -G 'https://azure.nsr3n.info/card_queries/get_daemon_advanced.sh' -d 'format=json&season=2' --data-urlencode 'query=region:the_north_pacific'

As with the regular page, you can specify your preferred output format, e.g., you can download the results directly in JSON output. Note that you need to use url-encoding for the "query" field of the GET request, because of the special characters it contains.

There are currently no hard-enforced rate limits for using the advanced card queries through scripts. However, please be reasonable and do not submit very large numbers of requests in short time intervals.

What if I still have questions?

For any questions or comments, including requests for additional features or bug reports, please post in this thread (preferable) or send a telegram to The Northern Light.

P.S. Many thanks to Ballotonia for making the official XML list of cards available!

[Dispatch version]

[9003]

Thanks for this super helpful

[SherpDaWerp]

Quick issue: querying

Code: Select all

+badge:Issues Author

retrieves only nations with "Issues Author", and not "Issues Author (x2)", and so on. And then you can't actually query

Code: Select all

+badge:Issues Author (x2)

which might be something to do with the brackets? Point being, there's no way to search for people who have authored more than one issue.

[The Northern Light]

Thanks. It should be fixed now. Searching for "Issues author" should get you everyone with that badge, regardless of number of issues they've authored.

The same problem used to affect the various WA authorship categories, those should be fixed as well.

[Philomathia]

What are categories? Is that going to be something like all car cards or anime cards etc?

[Ter Voland]

What are categories? Is that going to be something like all car cards or anime cards etc?

Category is what kind of nation it is, like left wing utopia, inoffensive centrist democracy, etc. You have to use underscores instead of spaces for the query. An example would be +category:capitalist_paradise. Don't include the period. I doubt car or anime cards would be a category because they're not a built in option like left wing utopia.

[The Northern Light]

You have to use underscores instead of spaces for the query.

Just a note that this is not necessary. The page should give correct results regardless of capitalization and spaces vs underscores (in fact, you can also mix spaces and underscores if you want).

[Ter Voland]

You have to use underscores instead of spaces for the query.

Just a note that this is not necessary. The page should give correct results regardless of capitalization and spaces vs underscores (in fact, you can also mix spaces and underscores if you want).

Ah ok. I just assumed that spaces wouldn't work.

[The Northern Light]

The card queries page has been updated to allow searching cards by trophies, either their type, or rank, or both. See the page for instructions.

I've also made queries faster, so some that used to require around 10 seconds should now be done in less than a second.

[The Northern Light]

The card queries page has been updated to include both card IDs and names in the results.

The results are still sorted by card ID.

As always, all comments are welcome.

[The Northern Light]

The card queries page has been updated to allow searching cards based on whether their name includes or does not include a query string.

[Nopspri]

What would I put in to find a specific exnation card?

[The Northern Light]

It depends. What information do you have about the nation?

For example, if you remember that the nation's name contains the string NAMESTRING, you can do:

Code: Select all

+exnation, +name:NAMESTRING

[Nopspri]

Thanks!

[Aclion]

Thanks. This will be very useful when season two comes out and I have to collect 300 nation's cards >.<

[The Northern Light]

The card queries page has been updated to allow searching by motto and flag.

For example, here are all the cards with .gif flags:

http://azure.nsr3n.info/card_queries/ge ... mit=submit

---

We also wanted to mention that the page will be updated to allow searching for season 2 cards as soon as the new cardlist XML file is made available (admins mentioned that this will be a few days after Season 2 begins). Until then, we will make a list that allows searching Season 2 cards by rarity only, likely after tonight's major update.

UPDATE: Unfortunately, tonight's nation dump contains rarity information only for season 1. Therefore, the season 2 update to the card queries page will need to wait till season 2 officially begins.

[N7eternia]

Thank you for this.

Who designed the template for these cards?

[The Northern Light]

The game administrators can answer this question (I assume it's one or more of them).

The card queries page will be updated as soon as the Season 2 cardlist.xml file is made available by the administrators. This will likely happen this weekend.

In the meantime, the following link has some preliminary lists of cards by rarity. Note that these are not 100% accurate, for reasons explained in the page. I am posting them here in case they are of use to people planning their S2 collections:

Preliminary list of Season 2 cards by rarity
This is now deprecated. Please use the updated card queries page.

[Assyrania]

This page is really nice. I can't open .xml files, so a big thanks for making this available.
I hope the S2 .xml files come out sooner.

[The Northern Light]

The card queries page has been updated to support queries of season 2 cards.

Currently, you can search the season 1 or season 2 list, but not both at the same time --- you will need to do two separate queries, one for each season.

If for whatever reason you think having mixed-season queries would be useful, please post here.

The preliminary lists in our previous post have now been disabled, to make sure nations do not continue to use incorrect information.

[Recuecn]

If for whatever reason you think having mixed-season queries, please post here.[/size]

Did you mean 'if you think having mixed-season queries would be nice, please say so?" Because I do think so.

[Toerana]

Yay S2, I can finally place lots of bits on cards of different regions without having to track down all the nations that may have left the region! xD

[The Northern Light]

Did you mean 'if you think having mixed-season queries would be nice, please say so?" Because I do think so.

Is it simply a matter of not having to do two queries, one for each season? Or is there a more compelling reason for it?

I can try and enable it, but it's somewhat more complicated than other features. So, I am trying to understand why people need it, in order to prioritize my TODO list.

---

Also, the spoiler in the OP mentions that the queries page supports GET requests. Admittedly, the response formatting right now is awful. I am considering updating the page to support JSON or XML formatting (analogous to the NS API).

But before I commit the time to doing so, I wanted to check first: Is anyone actually using this option?

[Recuecn]

Did you mean 'if you think having mixed-season queries would be nice, please say so?" Because I do think so.

Is it simply a matter of not having to do two queries, one for each season? Or is there a more compelling reason for it?

I can try and enable it, but it's somewhat more complicated than other features. So, I am trying to understand why people need it, in order to prioritize my TODO list.

---

Also, the spoiler in the OP mentions that the queries page supports GET requests. Admittedly, the response formatting right now is awful. I am considering updating the page to support JSON or XML formatting (analogous to the NS API).

But before I commit the time to doing so, I wanted to check first: Is anyone actually using this option?

Yeah I don't really have a very compelling reason besides "it would be easier". Super easy to see all legendary cards next to each other, for example. But yeah, it is as simple as doing a second query, so if it's more work, by all means leave it at the bottom of your to-do list.

As to the second point, I don't use the GET request function but I'm probably not the target user for that, given I don't even know what that means.

[Warzone Codger]

If for whatever reason you think having mixed-season queries would be useful, please post here.

Would this allow searching for cards which has been promoted or demoted between seasons? Or those who have lost or gained a badge or trophy?