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

[Markz88]

How to change ip in client? I make it to play Lan with some friends

RPG Maker XP -> Script Editor -> (RMX-OS) Options and you'll find SERVERS.push(['Mew', '127.0.0.1', 54269]

[Tanuki]

Hey Markz,
could you fix the Weakness/Resistance or make a tutorial on how to fix that?

[Markz88]

I'll release soon the last version of Pokemon Essentials with online features.. I'm preparing all... Say goodbye to nox files.

Inviato dal mio GT-I9300 con Tapatalk 2

[aegisrox]

Markz welcome back!! I missed you =D
Thanks for your hard work ^_^

Aegis

[Markz88]

Changelogs:

Pokemon Essentials v11 + Online features.

DOWNLOAD

Spoiler:

Pokémon Essentials v11 2012-12-23 (Online) ENG.rar (28.1 MB)

[iLuvMyStylz]

[Err] 1005 - Can't create table 'rmxosdb.users' (errno: 150)
[Err] -- 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,
	`notrade` tinyint(1) NOT NULL default 0,
	`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;
[Msg] Finished - Unsuccessfully

Any help?

[Markz88]

[Err] 1005 - Can't create table 'rmxosdb.users' (errno: 150)
[Err] -- 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,
`notrade` tinyint(1) NOT NULL default 0,
`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;
[Msg] Finished - Unsuccessfully

Any help?

What is your database name? Call it "rmxosdb" or change USE "rmxosdb" with USE "your database name" in the sql code

Inviato dal mio GT-I9300 con Tapatalk 2

[Tanuki]

By default there is a /trade command in RMX-OS right?
It is not working? Markz couldn't you make it work? :D

[chikosvieir]

How I change the IP of the client? Please i need to know Dx

[PokeOrb]

How I change the IP of the client? Please i need to know Dx

RPG Maker XP -> Script Editor -> (RMX-OS) Options and you'll find SERVERS.push(['Mew', '127.0.0.1', 54269]

In the future, try to read through the thread first to see if an answer has already posted to your question.

[gonxfreaks]

Changelogs:

Pokemon Essentials v11 + Online features.

DOWNLOAD

Spoiler:

Pokémon Essentials v11 2012-12-23 (Online) ENG.rar (28.1 MB)

hello, does the pvp System and trade system??

[PokeOrb]

hello, does the pvp System and trade system??

Trade system does not work. I don't think there's a PvP system either.

That release is the latest version of Pokemon Essentials and RMX-OS integrated, so it's more up to date than the previous version.

[gonxfreaks]

mmm, I was thinking we could do something in the pokemon center, as in the original game, but not how to make it work ...

regards

[Cure]

Hey, I just had the honor of trying this source with the developers hosting..
Its looking extremely nice and I'd recommend keeping an eye on revisions for the source.

Good job Markz and his team.

[Joey Myerscough]

I was wondering if anyone had a better tutorial for setting up a server? I'm unsure what to do with Ruby, or MySQL. It'd be great for someone to help me with a more in-depth tutorial.