[JamieS1211]

- 31 Aug 2015 05:31 #160196 I use something called h2 console. You need to open the database (you can locate it from obvious name folders) in the root of the folder you launch pixelmon from (.minecraft or .pixelmon/[profile_name]). To open it you need to use the jdbc url something like this "jdbc:h2:C:\Users\Jamie\AppData\Roaming\.minecraft - Pixelmon - 4.0\database\Pixelmon2".

Then you can type in commands to open tables for example "SELECT * FROM PIXELMONSPAWNLOCATIONS" where"*" means everything and "PIXELMONSPAWNLOCATIONS" is the table you want to look up. You can change "*" to variables so that you only display some things but you need some knowledge of database stuff.

Minecraft username - Jamies1211

Minecraft username -SpreadSheetGuy

Twitch username - Jamies1211

[ATEMVEGETA]

- 01 Sep 2015 02:08 #160238 I downloaded and installed H2 but then I have no idea what to do. What is that line exactly and where to write it? Is it the path for pixelmon.jar?
Like: jdbc:h2:C:\Users\ATEMVEGETA\AppData\Roaming\.minecraft\mods\Pixelmon-1.8-4.0.7-universal

[JamieS1211]

- 01 Sep 2015 03:00 #160239

"jdbc:h2:C:\Users\Jamie\AppData\Roaming\.minecraft - Pixelmon - 4.0\database\Pixelmon2".

for you it will be "jdbc:h2:C:\Users\ATEMVEGETA\AppData\Roaming\.minecraft\database\Pixelmon2"

I have a differently named .minecraft as I have used the normal MC launcher under different profiles with different folders to change pixelmon install via changing profile.

Minecraft username - Jamies1211

Minecraft username -SpreadSheetGuy

Twitch username - Jamies1211

[ATEMVEGETA]

- 01 Sep 2015 08:53 #160243 Ok, but where do I have to type that?

[JamieS1211]

- 01 Sep 2015 10:09 #160244 This is how I have connected to the database on the laptop I am currently using. The full JDBC Url is "jdbc:h2:C:\Users\Jamie\AppData\Roaming\.minecraft\database\Pixelmon2". You need to make sure you actually have the pixelmon database there. You can't connect to the database if you don't have the file there to connect to. If you are still having issues screenshot your database folder.

Minecraft username - Jamies1211

Minecraft username -SpreadSheetGuy

Twitch username - Jamies1211

[ATEMVEGETA]

- 01 Sep 2015 18:55 #160263 I think I'm in now, ty!

Can you please tell me all the commands to get to the page that I can change the legendaries type, since I have no idea about stuff as database, etc?

[MrMasochism]

- 01 Sep 2015 19:38 #160264 Do a basic read-up on sql and how to read/edit tables

[JamieS1211]

- 02 Sep 2015 05:06 #160270 This could help you "SELECT * FROM PIXELMONSPAWNLOCATIONS WHERE PIXELMONID LIKE 108 OR PIXELMONID LIKE 473 OR PIXELMONID LIKE 474 OR PIXELMONID LIKE 249 OR PIXELMONID LIKE 353 OR PIXELMONID LIKE 354 OR PIXELMONID LIKE 355 OR PIXELMONID LIKE 361 OR PIXELMONID LIKE 359 OR PIXELMONID LIKE 360;". It should display all legendarys that sporn normally.

Refer to this image for what pokemon is what number


At the bottom left of the table there is a button that says edit. Click that to start editing. Then on the far left of each row is a pencil, click that to edit anything about that row.

Minecraft username - Jamies1211

Minecraft username -SpreadSheetGuy

Twitch username - Jamies1211

[ATEMVEGETA]

- 02 Sep 2015 05:56 #160272

SELECT * FROM PIXELMONSPAWNLOCATIONS WHERE PIXELMONID LIKE 108 OR PIXELMONID LIKE 473 OR PIXELMONID LIKE 474 OR PIXELMONID LIKE 249 OR PIXELMONID LIKE 353 OR PIXELMONID LIKE 354 OR PIXELMONID LIKE 355 OR PIXELMONID LIKE 361 OR PIXELMONID LIKE 359 OR PIXELMONID LIKE 360;
Table "PIXELMONSPAWNLOCATIONS" not found; SQL statement:
SELECT * FROM PIXELMONSPAWNLOCATIONS WHERE PIXELMONID LIKE 108 OR PIXELMONID LIKE 473 OR PIXELMONID LIKE 474 OR PIXELMONID LIKE 249 OR PIXELMONID LIKE 353 OR PIXELMONID LIKE 354 OR PIXELMONID LIKE 355 OR PIXELMONID LIKE 361 OR PIXELMONID LIKE 359 OR PIXELMONID LIKE 360 [42102-176] 42S02/42102 (Help)

I get this error!

[JamieS1211]

- 02 Sep 2015 06:45 #160273 Can you screenshot your entire h2 console tab. You may not be in the pixelmon database correctly.

It should look like this with the same things on the far left.

Minecraft username - Jamies1211

Minecraft username -SpreadSheetGuy

Twitch username - Jamies1211