Pokémon TCG: Sword and Shield—Brilliant Stars

Searchable Pokemon TCG Database

Status
Not open for further replies.
AbsolutelyNobody, I've corrected the Bench Damage (if you find any others, please let me know).

Here's what I did. If a Pokemon is CAPABLE of doing bench damage (i.e., it does direct damage, a flip is required, a precondition must be met, etc.), I have tagged it as doing bench damage.

Two examples...

Raichu (Skyridge) - [2] Zzzap - This attack does 20 damage to each Pokémon with a Poke-Body or Poke-Power (yours and your opponent's). (Don't apply Weakness or Resistance.)

Starmie (Revelation) - [1PP] Core Stream - Choose an Energy type other than (*). This attack does 20 damage to each of your opponent's Pokemon with any Energy cards of that type attached to it. Don't apply Weakness and Resistance.

Under the right circumstances, each of these CAN do put damage on Pokemon that are on your opponent's bench. As a result, I have them tagged as Bench Damaging.
 
No prob. This is a wonderful thing that you have here, I wish I had the gift of computer programing, but I don't. Goodluck & thanks!
Nobody~

p.s. I found another small error. You list Skyridge golbat as bench damaging, when it really does more damage to ACTIVE for each golbat/zubat/crobat you have on YOUR BENCH. I'm not yelling, just pointing out why it would be inncorrect. There might be others like this, but I dunno. You probably just skipped it over by accident. Thanks for creating this!

p.s.s. what about other search modifiers under format? When the format changes you will have to change sets you search. You may want to put a few in like: Neo-on modified, or e-on modified. Just a thought, feel free to call me an idiot if you like. :)

p.s.s.s. What about cards that force shuffle? (see p.s.s. last sentence)
 
Last edited:
Carrington, in the TCG, only the type identified in the upper right corner of the card has relevance. That's really the only thing that matters when it comes to determining weaknesses and resistance.

While I understand your point, we can only go by the types assigned by WoTC and now Nintendo in assessing the cards.

As each new set gets released, I'll incorporate those into the database with the types as indicated on the cards (which will, hopefully, be more in line with the GBA versions).
 
Very impressive database. Thanks. The only thing I can think of that would be great to add is how much damage done to the active. I can see this could get hard with flips etc. but that would be cool. Again great work. This should get stickied somewhere.
 
AbsolutelyNobody, I'll check on the Skyridge Golbat. Funny that you mention that about the formats. Just today I was thinking about that same thing, adding the "classic" formats (Rocket On (from the ECSTS) and Neo Block (Worlds), for example). I'm not sure if I'll do that, but I like the idea. I'll give the forcing shuffle some thought. You may be able to find most of those through a text search already.

Pidgeotto Trainer, there is a lot of data that is already in the database that I don't expose in the search. Damage done to the active is one of those (and yes, I had problems with the flips, but I typically tried to present an average). I also have number for what I call DPE, Damage Per Energy. If it takes 3 energy to power an attack that does 40 damage, that is a DPE of 13.3. (I'm not sure why I produced those numbers, but the inner geek in me wanted out). I'll think about how to display this information (it's pretty crowded as it is already. Maybe I'll make it an optionally-displayed field for each attack.)

dc
 
Dave,

This is probably THE BEST program out there for players to search cards to make a deck. Like itoldyou this past Saturday, you need to talkto Nintendo/Pokemon. What an awesme tool!

When are you going to make it available on CD??? Just a thought.....

Anyway, you've got my vote for President!
 
Very nice work Dave!

You beat me to a complete one, darn you :p

I've been working on spoilers on my site for a long time, and I have only recently added searching functionality, but I still only have, like, 716 cards in my database :(. PHP and MySQL really do work wonders, eh? :D

If I might ask, on the technical side of things, how exactly does it search for Status Inflicters and such. Do you just have a field for each one, and then manually decide if it does that, or do you search for "Poisoned", "Paralyzed", etc in the attack effects? @_@
 
Thanks Renee! I actually have an Excel spreadsheet with all this information (and more) that I wouldn't mind sharing. If you're handy with Excel, you can probably get more detailed searches than you can through this database.

Marrilland, sorry to steal your thunder! Keep at it though, the Internet is big enough for more than one.
GREAT question on the statuses. That is pretty much brute force. I have a field in each record for Paralyzed, Poisoned, Sleep, etc. For each set I will do a search for "Paraly" (for example) and, from that set, find the cards that paralyze and put a "Y" in that field. I do the same with each of the statuses (including bench damage and forcing discard). So when I do the search on the database, I simply search for a "Y" in the fields that have been selected on the form. (That's ALSO the reason why most of the problems with my database that have been pointed out on here have been with those statuses. I made errors when manually processing them.)
BTW, I LOVE what you did with the Type, Weakness, and Resistance. Very clever!

dc
 
I kind of figured that was how it was done. All day I've been thinking of that script, lol

I was trying to think if there's some other way it could be done... Like, if it's possible to catch the exact pattern of inflicting a Status Ailment, regardless of the attack's wording. Oh the things that make programmers minds tick, eh?

And yes, I'm definitely going to keep at mine! In fact, I added 40 or so more cards today, lol. And you should definitely keep up with yours. Right now, yours is definitely the most complete TCG Database out there, and it's a valuable resource for anyone who manages to stumble on to it :)

And thanks for the compliment on the colorization options I decided to go with, hehe... I figured they needed to stand out a bit more, so I figured what the heck. :p

Keep at it, and again, great job! :D
 
Professor Renee said:
Dave,

When are you going to make it available on CD??? Just a thought.....
Click to expand...

Ok, it may not be on CD, but it *IS* available to download.

I have an Excel spreadsheet that has been zipped up and is downloadable at the bottom of the Pokedex query form. Instructions are on there.

You'll see that there's a lot of additional stuff in the spreadsheet that you don't see on a Pokedex query. Some of it is my junk, but other information you may find useful.

It's handy to have on your laptop!

(FYI, I believe that Microsoft free distributes and Excel reader for those who do not have the full-blown Excel.)

(I'm not a Palm person, but is anybody willing to create a Palm version of the Pokedex? If so, just send it to me once you're done and I'll make it accessible along with the Excel version.)

(Anybody think a PDF version of this would be useful?)
 
Last edited:
LMK in what format (or give me time to use the DB) and I would be glad to help with PDA versions.

Except babayaga is MUCH MORE versed in doing this (and her PDFs are amazing).
 
I don't know ANYTHING about PDAs and the format of data they need.

I can provide you with an Excel spreadsheet or SQL and if that can be massaged into a PDA-usable form, then super. If not, dang!
 
davechri said:
I don't know ANYTHING about PDAs and the format of data they need.

I can provide you with an Excel spreadsheet or SQL and if that can be massaged into a PDA-usable form, then super. If not, dang!
Click to expand...

I haven't worked with palm databases, but am willing to look into it. I do do MySQL. PM me if you'd like to send me a SQL dump.

regards,
:unknown-b
 
IMO card prices would be too 'fluid' and need constant updates to the db; all the other information is pretty much 'enter and forget' unless there are error corrections (until there are new cards released, of course).

'mom
 
Regarding a price guide, I have to agree with SD Pokemom. It would be easy enough to set up an interface to put and get the data, but keeping the data "fresh" would be a chore.

I love this kind of thinking though. Any kind of cross-pollenation of data between databases is great. I'm still mulling over the idea of linking to the Compendium somehow. Wouldn't it be great if, for example, you could have the names of each card be linked to the Compendium and it would pull all the ruling associated with that card when you clicked on it? Or having each attack/power linked to the Compendium and, when clicked, would retrieve all rulings associated with the attack or power?
 
Maybe whoever is the one that manages the Compendium can put in page anchors. Then, on your site, you can link to those anchors. Instead of having to guess what the anchors will be, you can simply agree on a format for them. For example, you could do the card number in set and the set number or abreviation such as for Base Set Blastoise (003-Base1).
 
davechri said:
Wouldn't it be great if, for example, you could have the names of each card be linked to the Compendium and it would pull all the ruling associated with that card when you clicked on it? Or having each attack/power linked to the Compendium and, when clicked, would retrieve all rulings associated with the attack or power?
Click to expand...
Well, that's what having it in a relational database would do for us. Otherwise, I imagine the same thing could be done with a base LaTeX or XML document. I know LaTeX better. I run a GUI for LaTeX that automagically generates a Table of Contents with links. Like when you have a PDF with a TOC (my own PDF versions of the Compendia, for example) and you click on the listing in the TOC and it takes you to the spot in the document. If LyX would output back HTML with anchors, there you'd be.

Doing it in a relational database would be better because the server would only have to serve the info for one card, and the searches could be cached to reduce server load. I'm still thinking about what would be the best way to set up the tables.

:unknown-b
 
Dave's Amazing Pokedex

Hello Dave,

Thanks for coming to & supporting our City Championship! Hope you and your family had fun. Your Poekedex is great. I don't think I have to tell you that since everyone here has already painted a very good picture of how appreciated your hard work is(^_^). Everyone has already covered all of the good ideas on how your Pokedex may be improved. Again, good job!

XS:BTW, thanx 4 letting us use ur camera 4 d event.
 
Last edited:
Status
Not open for further replies.
Back
Top