Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

MuWeb Market to Pokemon Market

Initiate Mage
Joined
Jan 25, 2013
Messages
13
Reaction score
0
I was thinking,
there is a MuWeb Market system,
and it is made to work with sql,
so what if someone with good php/sql knowledge,
adapt it to work with some mysql pokemon files like the essential ones (markz, nox)

People offer their pokemon (or items) and other people can buy it,
I think it's not that hard to make,
since its just delete the innecesary things and change the sql routes.
Is there anyone who thinks that could be able to make it?
It would be a really good release :)

This is the MuWeb Market System: http://forum.ragezone.com/f197/muweb-0-9-market-system-577758/
 
Initiate Mage
Joined
Jan 25, 2013
Messages
13
Reaction score
0
It would be easier to make it yourself, considering it should only require you to make it read and edit the database at very few times.

I don't know a lot of php/mysql,
could you give me a basic base to start? :laugh:
 
Joined
Jul 29, 2012
Messages
527
Reaction score
71
Well, i won't do the coding for you but you should only need 2 files (unless you want a very clean and easy to work with source, use 4 pages.)

2 file option:
config - connects to database
market - buy/sell pokemon

4 file option:
config - connects to database
list pokemon being traded
page to sell pokemon
page to buy specific pokemon

to connect to a database, we can use the following code:
Code:
<?
$Username = "DATABASE USERNAME";
$Password = "DATABASE PASSWORD";
$Database = "POKEMON DATABASE";
$Host = localhost;
mysql_connect($Host, $Username, $Password);
@mysql_select_db($Database) or die ("Server unable to connect to specified database");
?>
username, password and database will need to be changed to the required (the stuff you use to login and the database you use for pokemon)
Host will be either localhost, or the IP of the database server.
the next line connects to the database server, and the following line tells it to select the database.

That's just basic part of what you will need, you can find loads of tutorials online about it.
 
Initiate Mage
Joined
Jan 25, 2013
Messages
13
Reaction score
0
The problem is that in essentials (nox, markz)
every pokemon has like 6 different rows of info.
Something like pokemon[0]evs, pokemon[0]ivs, pokemon[0]movelist, etc.

That's why I don't know how to do it,
how to select the desire pokemon and when someone buy it,
how to make it not replace his pokemon ('cause if you just change the userid of the pokemon, then it will replace the buyer pokemon[0]).
 
Joined
Jul 29, 2012
Messages
527
Reaction score
71
pokemon nox database is terrible, there is just too much data inserted into one table that trying to get a webpage to load one specific line among the possible 100,000 (with only about 100 users registered) will eitehr:
a) crash the webservber
b) take a long time to load
c) just won't load
d) cause the game server to take longer to save and load data since the database server is tending to the web users.

it would be best to try and fix up the pokemon nox database before this.
 
Initiate Mage
Joined
Jan 25, 2013
Messages
13
Reaction score
0
pokemon nox database is terrible, there is just too much data inserted into one table that trying to get a webpage to load one specific line among the possible 100,000 (with only about 100 users registered) will eitehr:
a) crash the webservber
b) take a long time to load
c) just won't load
d) cause the game server to take longer to save and load data since the database server is tending to the web users.

it would be best to try and fix up the pokemon nox database before this.

Yeah but how,
I don't know anything about ruby,
and ruby originaly don't even support mysql,
so it is a wierd connection there.

Even if it takes long to load,
it would be a good add-on.

Better would be an in-game trade system,
but nobody seems to know how to do it,
or just don't want to do it.
 
Joined
Aug 16, 2006
Messages
1,251
Reaction score
199
:p
IvRi2 - MuWeb Market to Pokemon Market - RaGEZONE Forums


^ Pokenet based

We are already coding a web and in game version as well...

Its possible to make an item mall with any game, if you know how the database / server works.
 

Attachments

You must be registered for see attachments list
Initiate Mage
Joined
Jan 25, 2013
Messages
13
Reaction score
0
The problem is that Nox/Markz database sucks,
and the idea is that other players can sell their pokemon,
anyways, cool stuff good job :)
 
Back
Top