Volunteers wanted

[Kaboom]

I'm working on a sort of online Pokemon Battle Arena, where you enter, choose your Pokemon and movesets, do battle and raise your rank. I need people to help speed things up, particularly with filling in the database. Any helpers will receive credit on the finished thing.

 

[The Dash]

How about you give us a bit more of a description?

 

[Kaboom]

Yeah, sorry.

The bulk of the job is filling in the database containing all relevent details about the Pokemon. All 493 of them! That's why I need help: it's hard enough designing the system, so adding the database is just overkill! Anyone interested should sign up at https://www.adamhaskell.net/en/_php/signup.php and drop me an e-mail at adz[at]adamhaskell[dot]net.

Oh, and those that help, as well as getting credit, will be allowed to take ONE uber-legend, as opposed to those that don't help who get none.

 

[DrCoolSanta]

Umm, can you tell what type of database you are talking about. I have data of all the 493 Pokemon in Excel files, that can be made into CSV files which you can convert to SQL easilly. If you want I can convert it into a SQL command and give it to you. But you will have to tell me the format of the table.

 

[DrCoolSanta]

I attached it with this, and it is arranged by the name, you can change that though.

Didn't take much time, I can make xls file of most poke data.

 

[Kaboom]

The SQL is as follows:
Table name: arena_pokemon
Fields:
- no [National dex number of the Pokemon] INT {already set, can be used as reference}
- name [Name of the Pokemon] VARCHAR(20)
- type1 [First type of the Pokemon] ENUM {type name in lower case}
- type2 [Second type of the Pokemon] ---------------"-------------
- ability1 [ID of the first ability of the Pokemon (see table arena_abilities)] INT
- ability2 ----------second-------------------------------------------------
- hp \
- attack \
- defence \_ [Pokemon's stats at Lv100 with neutral nature] INT
- spattack /
- spdefence/
- speed /
- height \_ [Dimensions of the Pokemon, in m/kg] DOUBLE(6,2)
- weight /
- uber [1 if the Pokemon is an uber-legend, 0 if not] TINYINT

Table name: arena_abilities
Fields:
- id [ID of the ability] INT UNIQUE AUTO_INCREMENT
- name [Name of the ability] VARCHAR(20)
- description [Description of the ability] VARCHAR(200)

Table name: arena_attacks
Fields:
- id [ID of the attack] INT UNIQUE AUTO_INCREMENT
- name [name of the attack] VARCHAR(20)
- type [Type of the attack] ENUM {type name in lower case}
- power INT
- accuracy INT
- effect VARCHAR(100) {if any}

Table name: arena_items
Fields:
- id INT UNIQUE AUTO_INCREMENT
- name VARCHAR(20)
- effect VARCHAR(200)

Table name: arena_pa (assigns which pokemon can use which attacks)
Fields:
- pokemonid INT
- attackid INT

 

[DrCoolSanta]

I have attached the sql for Pokemon, but this doesn't contain the height, width or uber, sorry :(

EDIT: I have also put the abilities file up

 

[Improfane]

DrCoolSanta, are those stats, HP, Attack, Defence, Spl. Attack, Spl. Defence Speed all for a level 100 Pokemon?

How are you using it to calculate the stats of someone at level 15?

My Pokemon database only stores base stats and uses the Pokemon formulas to calculate stats.

 

[DrCoolSanta]

Seriously I have no idea how you would do that, I know of some equations on the net, just find some good battle damage calculator and it should be able to do everything for you.

These are the base stats at level 100 with neutral nature. The one in the middle on serebii's Pokedex DP's Stats part.

Considering that it is a battle tournament type of thing, these should be the ones needed. I have these prepared for another such game. And I didn't find it a problem to share these.

 

[Kaboom]

The pokemon list is perfect. Thanks a lot. 9.99/10 'cos I spotted a typo ;P.

Could you alter the abilities one because the descriptions aren't all that good - "how do they affect the battle?" is the question posed.

Are you working on the other ones?

 

[Kaboom]

Well, definitely an Uber for DrCoolSanta! But only when I've got more of the system running!

 

[DrCoolSanta]

Well thanks, I have the attacks with me as well, but will have to look for it ;)

Just looked through, improfane, those stats are the highest base stats stats possible with neutral nature, on serebii this is the middle row in the table, anything else? By damage calculator I meant that you could use some equation and use it in your programming.

It'll take some time to fix that one, but I have the attacks one which I am working on. And give me the format you want in abilities.

I have the data PE2K uses in URPG, will that do for attacks.

EDIT: There is a major glitch in abilities, description -_-;

 

[Kaboom]

I got the damage formula:

Damage = ((((2 * Level / 5 + 2) * AttackStat * AttackPower / DefenseStat) / 50) + 2) * STAB * Weakness/Resistance * RandomNumber / 100

where:
- Damage is the amount of HP lost
- Level is the attacker's level
- AttackStat is the attacker's Attack/Special Attack
- DefenseStat is the defender's Defense/Special Defense
- STAB is 1 or 1.5 if STAB applies
- Weakness/Resistance is the type correspondance factor (0.25/0.5/1/2/4)
- RandomNumber is a random value between 0.8 and 1


For the abilities' descriptions, all I need is to know what effect they have on the battle, e.g. Air Lock cancels the effect of weather, Anticipate informs the Trainer if the opponent has a Supereffective attack when the Pokemon enters the battle, that sort of thing.

 

[DrCoolSanta]

Unfortunately, you'll have to do that on your own, because I am not the right person to consult, but if you want it done, give me a site which has the info the way you want. (Abilities)

And Pokemon stats, are they the right ones? As I said they are the highest base stats with neutral nature.

Also the attacks, they are from URPG on PE2K, I just copied it from their thread, so incase they have something special to it, it could be a problem, do you want that sql list?

I also have a type effectiveness chart, lol, I'll post it as xls for you to see, just incase you have to check that. BTW don't you need the special/normal clause and who all the attack hurts(user enemy, or all enemies and users) in attacks table?

EDIT: Done