[Release] Pokemon Markz88 MMO STARTER KIT [RPG Maker XP]

[Adam Hatmaker]

Having a problem with executing the 'rmxosdb' database. i get this. but both my connection and database is called rmxosdb just to be safe but to no avail. #Edit # can i manually input the tables... if so could someone post a screenshot of one of theirs so ill know what to put it and how... and the FOREIGN and PRIMARY KEYS.
-- SQL Database for RMX-OS
-- by Blizzard

START TRANSACTION;

-- these two are used to create the database and can be ommited in case the database already exists
CREATE DATABASE IF NOT EXISTS `rmxosdb` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
USE `rmxosdb`;

DROP TABLE IF EXISTS `save_data`;
DROP TABLE IF EXISTS `inbox`;
DROP TABLE IF EXISTS `buddy_list`;
DROP TABLE IF EXISTS `user_data`;
DROP TABLE IF EXISTS `guilds`;
DROP TABLE IF EXISTS `ips`;
DROP TABLE IF EXISTS `users`;

-- Registered Users

CREATE TABLE `users` (
`user_id` int(10) unsigned NOT NULL auto_increment,
`username` varchar(32) NOT NULL UNIQUE,
`password` varchar(11) NOT NULL,
`usergroup` int(10) NOT NULL default 0,
`banned` tinyint(1) NOT NULL default 0,
PRIMARY KEY (`user_id`)
) ENGINE = InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;

-- IPs

CREATE TABLE `ips` (
`user_id` int(10) unsigned NOT NULL,
`ip` varchar(15) NOT NULL,
PRIMARY KEY (`user_id`, `ip`),
FOREIGN KEY (`user_id`) REFERENCES users(`user_id`) ON DELETE CASCADE
) ENGINE = InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;

-- Guilds

CREATE TABLE `guilds` (
`guild_id` int(10) unsigned NOT NULL auto_increment,
`leader_id` int(10) unsigned NOT NULL UNIQUE,
`guildname` varchar(32) NOT NULL UNIQUE,
`password` varchar(11) NOT NULL,
PRIMARY KEY (`guild_id`),
FOREIGN KEY (`leader_id`) REFERENCES users(`user_id`) ON DELETE CASCADE
) ENGINE = InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;

-- Special User Data

CREATE TABLE `user_data` (
`user_id` int(10) unsigned NOT NULL,
`lastlogin` DATETIME NOT NULL,
`guild_id` int(10) unsigned default NULL,
PRIMARY KEY (`user_id`),
FOREIGN KEY (`user_id`) REFERENCES users(`user_id`) ON DELETE CASCADE,
FOREIGN KEY (`guild_id`) REFERENCES guilds(`guild_id`) ON DELETE SET NULL
) ENGINE = InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;

-- Buddy List

CREATE TABLE `buddy_list` (
`user1_id` int(10) unsigned NOT NULL,
`user2_id` int(10) unsigned NOT NULL,
PRIMARY KEY (`user1_id`, `user2_id`),
FOREIGN KEY (`user1_id`) REFERENCES users(`user_id`) ON DELETE CASCADE,
FOREIGN KEY (`user2_id`) REFERENCES users(`user_id`) ON DELETE CASCADE
) ENGINE = InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;

-- PM Inbox Data

CREATE TABLE `inbox` (
`pm_id` int(10) unsigned NOT NULL auto_increment,
`recipient_id` int(10) unsigned NOT NULL,
`sendername` varchar(32) NOT NULL,
`senddate` DATETIME NOT NULL,
`message` text NOT NULL,
`unread` tinyint(1) NOT NULL default 1,
PRIMARY KEY (`pm_id`),
FOREIGN KEY (`recipient_id`) REFERENCES users(`user_id`) ON DELETE CASCADE
) ENGINE = InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;

-- Saved Data

CREATE TABLE `save_data` (
`user_id` int(10) unsigned NOT NULL,
`data_name` varchar(255) NOT NULL,
`data_value` text NOT NULL,
PRIMARY KEY (`user_id`, `data_name`),
FOREIGN KEY (`user_id`) REFERENCES users(`user_id`) ON DELETE CASCADE
) ENGINE = InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;

COMMIT;

 

[fenixpe]

How do I translate into Portuguese?

 

[Arthur Padilha]

How do I translate into Portuguese?

Open the translate file.
Tenta abrir o arquivo de tradução, tem na pasta de recursos.

 

[Weskerino]

download don't work.

You must be registered to see links

FIX please

 

[Adam Hatmaker]

Anybody got any solid ways of getting the PVP Server to connect I'm at a loss... after making 80 percent of the original Kanto plus areas for other pokes. So if anybody have any ideas id appreciated it. I honestly don't see what im supposed to edit and change it to in the "tutorial" other then the vague PVP server tut awesome job with everything truly its all great love how the terrain is already set up.

 

[fenixpe]

Open the translate file.
Tenta abrir o arquivo de tradução, tem na pasta de recursos.

não achei a pasta :S

 

[Alex Van Molen]

Hello sir!.
I got this error, any one can fix it?
REMOVED
Thanks before

 

[Mugaru]

Your SQL version is too old. Upgrade to 6.0.0...

 

[Alex Van Molen]

Your SQL version is too old. Upgrade to 6.0.0...

i've updated my SQL version, but it can fix that..
REMOVED

 

[Velmonty]

I'm having issues with the SMTP server for PVP.

The Main.rb hangs at this message and won't continue any further.
I can get the actual server up and running, and the settings for the SMTP server are configured the way I was told to do so. (Gmail Username, password, etc.)

Is it possible to make a PVP command like the /trade command with no need for another server or SMTP?
You can't make a multiplayer game without battles, so this is a huge setback in further progression of my game, as I can't do PVP without making the SMTP work.

Any advice?

 

[andsnake]

1.I can not Run Server RMX-OS.
The image problem (

)
2.Where Script Font Game? I want to translate Thai, but Font do not.
Please help me. Thanks.

do not use rubby x64 , use the normal x86 one. at least that's how i got it to work

ups, sorry for doble post

there is a leftover in the pokecenter event where pbPokemonFollow method is called. it seems they removed the pokemon follow script and that is why it throws Method not Found. Try editing the event in the pokemon center and remove the line where that method is called.

 

[andsnake]

i'm having a prolem with the PvP battle system. i used smtp.live.com to overcome some authentication problems i had using gmail when trying to start pvp server. but when i try to battle the only thing that appears after choosing my opponents nickname, is a black screen and nothing happens. Did anyone alese confronted this error ?

 

[andsnake]

So i've managed to give the PvP a successful try. But i've noticed random crashes.
I believe the main reason to be the fact that all the battle handling seems to be done by the two clients.
For example the way i imagine the current "PvP" system works is that if a trainer named "A" and a trainer named "B" with pokemons "a" and "b" respectevly battle, what happens is that when pokemon a executes a move A's client calculates the dmg+effects, but also B's client calculates the same dmg+effect. This sometimes may lead to a difference between what A's client calculated and what B's client calculated.

I'm not sure if this is the actual way it is handled, but if it is i believe that is the reason why random crashes happen.

It would be more effective if we found a way to remove the battle logic from the client and into the PvP server itself.
Unfortunatelty i dont know ruby very well to be able to do that by myself, nor understand basic structure of how the current battle system works due to lack of documentation. I could try to help though if someone gives me a brief explanation on how RMX-OS, RPG maker and pokemon essentials work together.

It would be nice though if people already knowledgeable about the project structure, give this a try.

 

[-DefaulT]

@andsnake I haven't looked into this source but I have a rather good understanding of ruby, I'll look into this in my free time and see if I can figure out a solution for you.

 

[zeak6464]

So i've managed to give the PvP a successful try. But i've noticed random crashes.
I believe the main reason to be the fact that all the battle handling seems to be done by the two clients.
For example the way i imagine the current "PvP" system works is that if a trainer named "A" and a trainer named "B" with pokemons "a" and "b" respectevly battle, what happens is that when pokemon a executes a move A's client calculates the dmg+effects, but also B's client calculates the same dmg+effect. This sometimes may lead to a difference between what A's client calculated and what B's client calculated.

I'm not sure if this is the actual way it is handled, but if it is i believe that is the reason why random crashes happen.

It would be more effective if we found a way to remove the battle logic from the client and into the PvP server itself.
Unfortunatelty i dont know ruby very well to be able to do that by myself, nor understand basic structure of how the current battle system works due to lack of documentation. I could try to help though if someone gives me a brief explanation on how RMX-OS, RPG maker and pokemon essentials work together.

It would be nice though if people already knowledgeable about the project structure, give this a try.

Me and my friend actually re-wrote some of the server & pvp stuff so it should work better for you .. like here is an example of the server "Main.rb"

RUBY_VERSION =~ /(\d+.\d+)/
version = $1

require 'socket'
require "./mysql_api"
require './servidor.rb'
require './sql_db.rb'
require './cliente.rb'
require './clienteind.rb'
require './envio.rb'

IP = '127.0.0.1'
PORT = 5000
SQLHOST = "127.0.0.1"
SQLUSR = "root"
SQLPASS = "toor" ##edit
SQLDBASE = "erps"
VERSION = 1
MAXIMUM_CONNECTIONS = 20
TRADETIMEOUT = 30
BATTLETIMEOUT = 30



	def main
		while true
		Client.reset
		Send.reset
		$clients = ClientHandler.new
	  [USER=412249]Server[/USER] = Server.new
	  [USER=412249]Server[/USER].run
		end
	end
	print "			Online PvP & Trade System v1 \n\n"
	if IP == '127.0.0.1'
		print "Iniciando servidor en modo local\n"
	else
	print "Iniciando servidor en #{IP}:#{PORT}\n"
	end
	main

yeah still need to translate some to English but not much lol

I'll release my stuff if you guys wish to use it

 

[-DefaulT]

@zeak6464 can you wrap those in code tags please, it makes it easier to read.

ex:

[code][/code]

 

[zeak6464]

Download Link :

You must be registered to see links

If you wish to use my game resources go right ahead here is the game link :

You must be registered to see links

How to use the Servers !
1: Database
2: What to edit ?
3: How to start !

1a: Make sure you have a Database like Navicat
1b: Make 2 Databases 1 to see players 1 for pvp & trade
Login Server = rmxosdb
Trade & PVP = erps

2a. Make Sure you Edit anything that says Mysql or IP address
2b. Edit the scripts to make sure they are the same as your database & Ip address

3a: To start Login Server click on RMX-OS.rb (yes make sure you have ruby installed on the server)
3b: To start Trade & PVP server click on Main.rb
3c. Add in all the Scripts above MAIN
3d. Add in an NPC with 3 choices
$scene = RegistrarPVP.new
$scene = BattlePVP.new
$scene = TradePVP.new

Friend Code is (Value 50)
So add in a place in your Trainer Card for the value 50
If you don't see your FC then something went wrong.....

 

[-DefaulT]

oh my gawd, the sprites are so TINY lol

 

[andsnake]

andsnake I haven't looked into this source but I have a rather good understanding of ruby, I'll look into this in my free time and see if I can figure out a solution for you.

-DefaulT thanks for replying

Download Link :

You must be registered to see links

If you wish to use my game resources go right ahead here is the game link :

You must be registered to see links

How to use the Servers !
1: Database
2: What to edit ?
3: How to start !

1a: Make sure you have a Database like Navicat
1b: Make 2 Databases 1 to see players 1 for pvp & trade
Login Server = rmxosdb
Trade & PVP = erps

2a. Make Sure you Edit anything that says Mysql or IP address
2b. Edit the scripts to make sure they are the same as your database & Ip address

3a: To start Login Server click on RMX-OS.rb (yes make sure you have ruby installed on the server)
3b: To start Trade & PVP server click on Main.rb
3c. Add in all the Scripts above MAIN
3d. Add in an NPC with 3 choices
$scene = RegistrarPVP.new
$scene = BattlePVP.new
$scene = TradePVP.new

Friend Code is (Value 50)
So add in a place in your Trainer Card for the value 50
If you don't see your FC then something went wrong.....

zeak6464 thanks for your contribution
i'll give it a try later in the day

 

[Lucila]

Download Link :

You must be registered to see links

If you wish to use my game resources go right ahead here is the game link :

You must be registered to see links

How to use the Servers !
1: Database
2: What to edit ?
3: How to start !

1a: Make sure you have a Database like Navicat
1b: Make 2 Databases 1 to see players 1 for pvp & trade
Login Server = rmxosdb
Trade & PVP = erps

2a. Make Sure you Edit anything that says Mysql or IP address
2b. Edit the scripts to make sure they are the same as your database & Ip address

3a: To start Login Server click on RMX-OS.rb (yes make sure you have ruby installed on the server)
3b: To start Trade & PVP server click on Main.rb
3c. Add in all the Scripts above MAIN
3d. Add in an NPC with 3 choices
$scene = RegistrarPVP.new
$scene = BattlePVP.new
$scene = TradePVP.new

Friend Code is (Value 50)
So add in a place in your Trainer Card for the value 50
If you don't see your FC then something went wrong.....

Good job zeak!
I have a question, you speak spanish? because "registrar" is spanish word... I speak spanish, maybe we can do a job together