Go Back   The PokéCommunity Forums > Creative Discussions > Game Development > Scripts & Tutorials
Reload this Page What I started working on (MySQL GTS)

Notices
For all updates, view the main page.

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 (02:48 PM). Edited October 17th, 2012 by zingzags.
zingzags's Avatar
zingzags zingzags is offline
PokemonGDX creator
 
Join Date: Jan 2009
Location: Boston
Age: 21
Nature: Adamant
Posts: 560
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
  #2    
Old October 19th, 2012 (10:49 AM).
Umbreon's Avatar
Umbreon Umbreon is offline
Gold Tier
 
Join Date: Aug 2009
Location: Nearby my feet.
Age: 18
Gender: Male
Nature: Calm
Posts: 1,588
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: 21
Nature: Adamant
Posts: 560
Quote originally posted by hansiec:
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).
Umbreon's Avatar
Umbreon Umbreon is offline
Gold Tier
 
Join Date: Aug 2009
Location: Nearby my feet.
Age: 18
Gender: Male
Nature: Calm
Posts: 1,588
Quote originally posted by zingzags:
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 (08:01 AM).
venom12's Avatar
venom12 venom12 is offline
Pokemon Crystal Rain Relased
 
Join Date: Sep 2006
Age: 24
Gender: Male
Nature: Adamant
Posts: 524
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 UTC -8. The time now is 12:51 PM.