The PokéCommunity Forums  

Go Back   The PokéCommunity Forums > Create & Discover > Game Development > Scripts & Tutorials
Reload this Page What I started working on (MySQL GTS)
Sign Up Rules/FAQ Daily Battle Blogs Mark Forums Read


Scripts & Tutorials This forum is for scripts and code, as well as all kinds of tutorials, software, tools and so forth. Remember to give credit!
The thread revival limit does not apply here.

Reply
 
Thread Tools
  #1    
Old October 17th, 2012 (2:48 PM). Edited October 17th, 2012 by zingzags.
zingzags's Avatar
zingzags zingzags is offline
PokemonGDX creator
 
Join Date: Jan 2009
Location: Boston
Age: 22
Nature: Adamant
Posts: 561
Hey everyone, so the other day I had a discussion with Maruno about mysql. Since we found out that Berka's script was broken I decided to work on communication between RMXP, and mysql through php. Thanks to ho-oh 12 for leaving some hints on how to do the connections (through sockets) I decided to make a GTS system from the ground up. Yesterday I managed to make communication between the game, and the database, it was able to store any information I needed. I want to make a more cleaner version of it, while leaving some examples in case someone wants to edit it in the future. Here is a picture to show the field. A pro to having the communication to php:

-If your game was decrypted, your database information wont be divulged, unless the hacker can hack the host itself. Since the information is run though the php file, all it does is send data back and forth when needed. If berka's method was being used, someone can be able to hack into your database and take anything they need.

Spoiler:



I also want to create an online ID for each user, but I might just do the same for want I did in the id field where it auto increments, so if you see people with an online id of one don't be jealous. Or as a thought I was thinking of people inserting an online username instead of an id.
__________________
Check out the Pokemon Game Engine I am working on:
https://github.com/sjosegarcia/Pokemon
Reply With Quote

Relevant Advertising!

  #2    
Old October 19th, 2012 (10:49 AM).
Umbra's Avatar
Umbra Umbra is offline
Platinum Tier
 
Join Date: Aug 2009
Location: Nearby my feet.
Age: 19
Gender: Female
Nature: Calm
Posts: 1,730
Sorry to say this, if you decrypt the game it's still easy to hack the server as of you can do queries through the decrypted game.
Reply With Quote
  #3    
Old October 19th, 2012 (11:01 AM).
zingzags's Avatar
zingzags zingzags is offline
PokemonGDX creator
 
Join Date: Jan 2009
Location: Boston
Age: 22
Nature: Adamant
Posts: 561
Quote:
Originally Posted by hansiec View Post
Sorry to say this, if you decrypt the game it's still easy to hack the server as of you can do queries through the decrypted game.
I realized it as I was coding, but at least it would not blatantly show your info.
__________________
Check out the Pokemon Game Engine I am working on:
https://github.com/sjosegarcia/Pokemon
Reply With Quote
  #4    
Old October 19th, 2012 (11:06 AM).
Umbra's Avatar
Umbra Umbra is offline
Platinum Tier
 
Join Date: Aug 2009
Location: Nearby my feet.
Age: 19
Gender: Female
Nature: Calm
Posts: 1,730
Quote:
Originally Posted by zingzags View Post
I realized it as I was coding, but at least it would not blatantly show your info.
Yeah it's better than Berka's method.
Reply With Quote
  #5    
Old October 22nd, 2012 (8:01 AM).
venom12's Avatar
venom12 venom12 is online now
Pokemon Crystal Rain Relased
 
Join Date: Sep 2006
Age: 25
Gender: Male
Nature: Adamant
Posts: 528
Send a message via Windows Live Messenger to venom12
It would be awesome if you would make that it will help much.
Reply With Quote
Reply
Quick Reply

Sponsored Links
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -8. The time now is 1:52 AM.


Style by Nymphadora, artwork by Sa-Dui.
Like our Facebook Page Follow us on Twitter © 2002 - 2016 The PokéCommunity™, pokecommunity.com.
Pokémon characters and images belong to The Pokémon Company International and Nintendo. This website is in no way affiliated with or endorsed by Nintendo, Creatures, GAMEFREAK, The Pokémon Company or The Pokémon Company International. We just love Pokémon.
All forum styles, their images (unless noted otherwise) and site designs are © 2002 - 2016 The PokéCommunity / PokéCommunity.com.
PokéCommunity™ is a trademark of The PokéCommunity. All rights reserved. Sponsor advertisements do not imply our endorsement of that product or service. User generated content remains the property of its creator.

Acknowledgements
Use of PokéCommunity Assets
vB Optimise by DragonByte Technologies Ltd © 2016.