• Just a reminder that providing specifics on, sharing links to, or naming websites where ROMs can be accessed is against the rules. If your post has any of this information it will be removed.
  • Ever thought it'd be cool to have your art, writing, or challenge runs featured on PokéCommunity? Click here for info - we'd love to spotlight your work!
  • PokéCommunity's Easter Egg Hunt is now on! If you're interested in looking for some eggs and earning badges, click here!
  • Our weekly protagonist poll is now up! Vote for your favorite Conquest protagonist in the poll by clicking here.
  • Welcome to PokéCommunity! Register now and join one of the best fan communities on the 'net to talk Pokémon and more! We are not affiliated with The Pokémon Company or Nintendo.
    Register

Ho-oh 112's mySQL Trade System

Ho-oh 112

Advance Scripter
    • 311
    Posts
    14
    Years
    • Seen Mar 8, 2014
    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:
    "image removed"

    Credits:
    Me - Main system
    Poccil - For the base pokemon stoarage script(modified by me)
    Desbrina - Helping improve the PHP script
     
    Last edited:
    salva123 said:
    good work, but how do I call the script?
    Click to expand...


    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.
     
    do I have to change something in the script? because everytime that I try to connect it tells me unable to connect
     
    salva123 said:
    do I have to change something in the script? because everytime that I try to connect it tells me unable to connect
    Click to expand...




    Well, have you configured the mySQL script?
     
    I put my pass host etc in and still cant connect to database.
     
    venom12 said:
    I put my pass host etc in and still cant connect to database.
    Click to expand...



    does it print it out(like a regular problem report) or say it in a Kernel.pbMessage(standard messaging)
     
    Normal kernelmessage, dont know why weird ;]
     
    venom12 said:
    Normal kernelmessage, dont know why weird ;]
    Click to expand...


    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.
     
    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.
    Click to expand...


    No i dont get this error i got error from mysql unable to connect.
     
    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?
     
    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?
    Click to expand...

    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
     
    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!
     
    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!
    Click to expand...

    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.
     
    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?
     
    Last edited:
    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?
     
    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?
    Click to expand...

    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?
    Click to expand...

    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.
     
    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'
     
    Last edited:
    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'
    Click to expand...




    right: "image removed"


    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.
     
    Last edited:
    You must log in or register to reply here.
    Back
    Top