Ho-oh 112's mySQL Trade System

Ho-oh 112 · Mar 7, 2012

Updates:
Fixed up Summary Screen error....

Version 2.0 progress:
Completed

Version 2.0 Full

Bugs: The Storage screen doesn't disapear until a few seconds after you select the trade pokemon
when offline(when it can't find a match for the pokemon) you can find a "" pokemon which is has these attributes: name "", level 0, wants 0, level 0-0 and then it crashes after trying to trade
Summary screen won't load so I removed it until I fix it.
and the GTS sartup box will stick for a few steps...

DON'T REPORT THESE BUGS! ONLY BUGS NOT LISTED!

Features:
Custom species restrictions (seen/owned/all)
Custom user level restrictions (levels 1-Maxlevel)
Sends data to a .php file and sends that to the database since nobody can figure out the mySQL support by berka...

Todo:
Actually make the .php file for everyone...

Tutorial:
1. Extract the zip
2. replace the old pokebattle_Pokemon script with pokebattle_pokemon2.0 script
3. replace the old PokemonStorage script with the contents of PokemonStorage.txt
4. make a new script section and place the trade script in there.
5. test it out and report if any errors happen.

CALL WITH:

Code:

pbStartGTS()

Finally the .zip file:
View attachment 63866

Credits:
Me - Main system
Poccil - For the base pokemon stoarage script(modified by me)
Desbrina - Helping improve the PHP script

salva123 · Mar 7, 2012

good work, but how do I call the script?

Ho-oh 112 · Mar 7, 2012

salva123 said:
good work, but how do I call the script?

Searching for a pokemon: pbShowSearchList()
Uploading a pokemon: pbUploadList()
Showing Uploaded Summary: pbShowTradeSummary()
Checking to see if your trade has been taken: pbCheckGotten()

ALSO, IGNORE THE OTHER THREAD, IT WAS AN ACCIDENTAL DUPLICATE.

salva123 · Mar 7, 2012

do I have to change something in the script? because everytime that I try to connect it tells me unable to connect

Ho-oh 112 · Mar 8, 2012

salva123 said:
do I have to change something in the script? because everytime that I try to connect it tells me unable to connect

Well, have you configured the mySQL script?

venom12 · Mar 8, 2012

I put my pass host etc in and still cant connect to database.

Ho-oh 112 · Mar 8, 2012

venom12 said:
I put my pass host etc in and still cant connect to database.

does it print it out(like a regular problem report) or say it in a Kernel.pbMessage(standard messaging)

venom12 · Mar 8, 2012

Normal kernelmessage, dont know why weird ;]

Ho-oh 112 · Mar 8, 2012

venom12 said:
Normal kernelmessage, dont know why weird ;]

Ok, it's a problem with my script, worked fine yesterday though.... I'll go fix it. Or if you want to try and fix it remove these lines ONLY THOSE 3:

Code:

rescue
  Kernel.pbMessage(_INTL("There was an error, we must cancel the Trade."))
  return false

then check the error report.

venom12 · Mar 8, 2012

Ho-oh 112 said:
Ok, it's a problem with my script, worked fine yesterday though.... I'll go fix it. Or if you want to try and fix it remove these lines ONLY THOSE 3:

Code:

rescue Kernel.pbMessage(_INTL("There was an error, we must cancel the Trade.")) return false

then check the error report.

No i dont get this error i got error from mysql unable to connect.

Ho-oh 112 · Mar 8, 2012

venom12 said:
No i dont get this error i got error from mysql unable to connect.

something to do with your connection then

MaTe9usz6 · Mar 8, 2012

When i change your mysql setting to my, and i calling the script: pbSqlConnect. I have a message:

The script is taking too long.
The game will restart.

P. S.

Can you rec the yt film how this script works?

Ho-oh 112 · Mar 8, 2012

MaTe9usz6 said:
When i change your mysql setting to my, and i calling the script: pbSqlConnect. I have a message:

The script is taking too long.
The game will restart.

P. S.

Can you rec the yt film how this script works?

That's because it's trying to connect but one of the following is happening:

Your connection to the internet is slow

Your connection to the SQL database is slow

You lost connection to the internet/sql connection for even a second (happened to me before)

Your mySQL database doesn't have external connections avaible

Your mySQL doesn't have remote SSH access

OR your PC is just slow (which is the least likely to be)

the reseting of the game is built into Essentials meaning it's not my script reseting. Make sure you have ALL the following corrected.

EDIT:
I for some reason cannot edit the first post because it tells me "This website is currently offline."
After I get that problem solved I'll make a tutorial for this

pokemonmasteraaron · Mar 8, 2012

Hey, ho-oh dude.
I'm really nervous about editting the scripts.
I'm blind, so to edit, I have to select all, copy, paste in to notepad, then dldelete the old script, than paste in my modified script.
So, I've got a big favor to ask.
Could you copy all of the editted scripts in to separate text files and upload them for me?
You'd only have to do like the mysql, storiage box, and the actual script, and only about 0-2 more.
I could edit the scripts in the txts you gave me, and then paste them in.
I would feal much more secure.
Even with backups, I get so nervous.
Back when I was little and played g/s/c, I would save after every 1-5 battles, lol.
Also, one last thing.
Do all I have to do, not to do with scripts, is make a mysql account and put libmysql.dll in my game's root?
Or is there more?
Help in very appreciated, thanks!

Ho-oh 112 · Mar 8, 2012

pokemonmasteraaron said:
Hey, ho-oh dude.
I'm really nervous about editting the scripts.
I'm blind, so to edit, I have to select all, copy, paste in to notepad, then dldelete the old script, than paste in my modified script.
So, I've got a big favor to ask.
Could you copy all of the editted scripts in to separate text files and upload them for me?
You'd only have to do like the mysql, storiage box, and the actual script, and only about 0-2 more.
I could edit the scripts in the txts you gave me, and then paste them in.
I would feal much more secure.
Even with backups, I get so nervous.
Back when I was little and played g/s/c, I would save after every 1-5 battles, lol.
Also, one last thing.
Do all I have to do, not to do with scripts, is make a mysql account and put libmysql.dll in my game's root?
Or is there more?
Help in very appreciated, thanks!

I'll upload .txt files after I can finally edit the first post, I've already sent in my problem but I didn't get a reply yet, I guess it's because it's a large post.

Also, you don't make the mySQL account you make the database (but in the same respective it's still an account) so yeah that's about all you also have to configure the settings (listed at the top of the mySQL support script) so that your settings are there.

pokemonmasteraaron · Mar 8, 2012

which mysql to I need?
There's a lot.
mysql cluster, and a few others.
Right now, I'm hoping mysql is compatible with screen readers.
Probably, as it seems wrather popular.
Then again, it might not.
FLStudio, the number 1 midi sequencer, camtasia, a popular screen recorder, and Norton (a virus protecter) don't work with screen reader tecnology.
Thanks, your gonna make my game awesome!

Nevermind, I got a mysql installed (server and mysql workbench)

How do I get my sql server running though?
I suppose I need to know that before I put in the scripts anyway.
Do I have to like put it on a website?
Or can I (for now) use my pc as the server?

overstood · Mar 9, 2012

I get client crash and errors. Please give a step by step instruction or upload the scripts. Would really appreciate this.
Nice Script though.
One more question; is it possible to list ALL Pokemon which were uploaded instead just of them you have seen?

Ho-oh 112 · Mar 9, 2012

pokemonmasteraaron said:
which mysql to I need?
There's a lot.
mysql cluster, and a few others.
Right now, I'm hoping mysql is compatible with screen readers.
Probably, as it seems wrather popular.
Then again, it might not.
FLStudio, the number 1 midi sequencer, camtasia, a popular screen recorder, and Norton (a virus protecter) don't work with screen reader tecnology.
Thanks, your gonna make my game awesome!

Nevermind, I got a mysql installed (server and mysql workbench)

How do I get my sql server running though?
I suppose I need to know that before I put in the scripts anyway.
Do I have to like put it on a website?
Or can I (for now) use my pc as the server?

for localhost you can use your pc as the server but only locally, otherwise you'll need to find a web/sql host which can meet all the requirments you need.

overstood said:
I get client crash and errors. Please give a step by step instruction or upload the scripts. Would really appreciate this.
Nice Script though.
One more question; is it possible to list ALL Pokemon which were uploaded instead just of them you have seen?

1. I'll make a guide as soon as I can edit the post(I'll try after posting this)

2. Upload the scripts? I already put them up.

3. I'll make a configuration setting for it.

overstood · Mar 9, 2012

In fact i Meant the Script.rgss data. Or a project file. Coz for now it wont work for me.
Don't know what to do, tried a lot.

Installed 1:1 like your manual:

---------------------------

---------------------------
Exception: RuntimeError

Message: Script error within event 13, map 38 (Route 1):

Exception: ArgumentError

Message: (eval):1:in `pbUploadList'wrong number of arguments(0 for 1)

***Full script:

pbUploadList()

Interpreter:243:in `pbExecuteScript'

(eval):1:in `pbExecuteScript'

Interpreter:1593:in `eval'

Interpreter:243:in `pbExecuteScript'

Interpreter:1593:in `command_355'

Interpreter:494:in `execute_command'

Interpreter:193:in `update'

Interpreter:106:in `loop'

Interpreter:198:in `update'

Scene_Map:103:in `update'

Interpreter:276:in `pbExecuteScript'

Interpreter:1593:in `command_355'

Interpreter:494:in `execute_command'

Interpreter:193:in `update'

Interpreter:106:in `loop'

Interpreter:198:in `update'

Scene_Map:103:in `update'

Scene_Map:101:in `loop'

Scene_Map:114:in `update'

Scene_Map:68:in `main'

Ho-oh 112 · Mar 9, 2012

overstood said:
In fact i Meant the Script.rgss data. Or a project file. Coz for now it wont work for me.
Don't know what to do, tried a lot.

Installed 1:1 like your manual:

---------------------------

---------------------------
Exception: RuntimeError

Message: Script error within event 13, map 38 (Route 1):

Exception: ArgumentError

Message: (eval):1:in `pbUploadList'wrong number of arguments(0 for 1)

***Full script:

pbUploadList()

Interpreter:243:in `pbExecuteScript'

(eval):1:in `pbExecuteScript'

Interpreter:1593:in `eval'

Interpreter:243:in `pbExecuteScript'

Interpreter:1593:in `command_355'

Interpreter:494:in `execute_command'

Interpreter:193:in `update'

Interpreter:106:in `loop'

Interpreter:198:in `update'

Scene_Map:103:in `update'

Interpreter:276:in `pbExecuteScript'

Interpreter:1593:in `command_355'

Interpreter:494:in `execute_command'

Interpreter:193:in `update'

Interpreter:106:in `loop'

Interpreter:198:in `update'

Scene_Map:103:in `update'

Scene_Map:101:in `loop'

Scene_Map:114:in `update'

Scene_Map:68:in `main'

right: View attachment 63752

Scripts.rxdata is in the .zip

EDIT:
Oh, your problem is that you didn't define a pokemon yet for the player to upload (you were looking at the wanted/wanted level range pokemon)

You've got to define a player's pokemon, using something like pbChooseSpecies or something.

Ho-oh 112's mySQL Trade System

More options

Ho-oh 112

Advance Scripter

salva123

Ho-oh 112

Advance Scripter

salva123

Ho-oh 112

Advance Scripter

venom12

Pokemon Crystal Rain Relased

Ho-oh 112

Advance Scripter

venom12

Pokemon Crystal Rain Relased

Ho-oh 112

Advance Scripter

venom12

Pokemon Crystal Rain Relased

Ho-oh 112

Advance Scripter

MaTe9usz6

Ho-oh 112

Advance Scripter

pokemonmasteraaron

The blind Pokémon Master!

Ho-oh 112

Advance Scripter

pokemonmasteraaron

The blind Pokémon Master!

overstood

Ho-oh 112

Advance Scripter

overstood

Ho-oh 112

Advance Scripter