Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Rohan
You last visited: Today at 19:19

  • Please register to post and access all features, it's quick, easy and FREE!

 

Item Mall File

Reply
 
Old   #16
 
elite*gold: 0
Join Date: Feb 2014
Posts: 319
Received Thanks: 75
You should probably look for someone whos willing to either set it up for you and allow you to watcha dn ask questions along the way, so you can learn.
I'm also in the process of adding a IM page on my local for learning purposes.



IncognitoOne is offline  
Old   #17
 
elite*gold: 0
Join Date: Mar 2009
Posts: 260
Received Thanks: 37
Which is still i don't have any plan to share the full zrohan mall and it's database.


kennethz008 is offline  
Old   #18
 
elite*gold: 0
Join Date: Jan 2014
Posts: 184
Received Thanks: 30
for those that really want to make the shared zrohan im work, you are going to have to make your own database tables. It works with both a private mysql database and at one private mssql database as well as the standard Rohan game tables (i.e. RohanMall).

Look in the sqlmall.php file. There will be all kinds of select, update and create statements in there. Your task is to :

1. Find out which statement affects which database.
2. Look at each statement and figure out what tables it works with and create those tables.
3. Look at each statement and figure out what columns are needed in each table to satisfy that sql statement. Create them.
4. Look at the kind of data each column is expected to work with and set the column types of your tables accordingly.

If you want to make that script work, you are going to have to work at it for yourself. If you don't know sql well enough to know what an INSERT, SELECT or UPDATE statement does, study up on it.

A challenge: Nothing says you HAVE to use two different DBMS systems. There is no reason at all why a creative PHP/SQL developer can't move all the MySQL databases in the MS-SQL database. You just need to look at the code and understand what it is doing.

Reverse engineering folks. That is the name of the game if you want to develop Rohan game servers.
PenguinJoe is offline  
Old   #19
 
elite*gold: 0
Join Date: Dec 2012
Posts: 200
Received Thanks: 23
Quote:
Originally Posted by asmodeus812 View Post
This zRohan Item Mall is not full here. There are some databases missing from this zip file! So in order to run that you need the DB with items(and god knows what else is not there) which is probably a MySQL DB !
Quote:
Originally Posted by PenguinJoe View Post
for those that really want to make the shared zrohan im work, you are going to have to make your own database tables. It works with both a private mysql database and at one private mssql database as well as the standard Rohan game tables (i.e. RohanMall).

Look in the sqlmall.php file. There will be all kinds of select, update and create statements in there. Your task is to :

1. Find out which statement affects which database.
2. Look at each statement and figure out what tables it works with and create those tables.
3. Look at each statement and figure out what columns are needed in each table to satisfy that sql statement. Create them.
4. Look at the kind of data each column is expected to work with and set the column types of your tables accordingly.

If you want to make that script work, you are going to have to work at it for yourself. If you don't know sql well enough to know what an INSERT, SELECT or UPDATE statement does, study up on it.

A challenge: Nothing says you HAVE to use two different DBMS systems. There is no reason at all why a creative PHP/SQL developer can't move all the MySQL databases in the MS-SQL database. You just need to look at the code and understand what it is doing.

Reverse engineering folks. That is the name of the game if you want to develop Rohan game servers.
<---- THIS ---->

Just a Hint: If i were you I would build something from scratch . To Rebuild a new IM + Exchange Market personaly i will need somewhere between 3~5 days of normal everyday work ! Its much easier when you do it yourself and much more satisfying.
Looking for tables, columns names and etc is pain in the ass , besides you never know what else is missing from those files. It could be 1 file, and it can screw everything up !


asmodeus812 is offline  
Old   #20
 
elite*gold: 0
Join Date: Feb 2014
Posts: 319
Received Thanks: 75
I wish I had the knowledge to be able to write my own databases for a full item mall and exchange market. I give you guys much respect cause I wouldn't even know where to begin, so Im sure I'll have to hire fellas like you all to do it for me at some point :P
IncognitoOne is offline  
Old   #21
 
elite*gold: 0
Join Date: Jan 2014
Posts: 184
Received Thanks: 30
Arrow

Quote:
Originally Posted by asmodeus812 View Post
Its much easier when you do it yourself and much more satisfying.
Looking for tables, columns names and etc is pain in the *** , besides you never know what else is missing from those files. It could be 1 file, and it can screw everything up !
Absolutely!!

It is always far easier and more satisfying to create things your way than it is to try and understand what the dev of a piece of code was thinking when he created it. Often his thoughts and design priorities will not necessarily be the same as yours.

When I look at the big picture of Rohan's client/server design, I am totally flummoxed trying to understand why YNK Korea made some of the design decisions they did.
PenguinJoe is offline  
Old   #22
 
elite*gold: 0
Join Date: Jul 2016
Posts: 30
Received Thanks: 0
where's db of zrohan itemmall share please
maxsalvatore is offline  
Old   #23
 
elite*gold: 0
Join Date: Nov 2012
Posts: 131
Received Thanks: 6
this treat is 2014 ago :v
deathbrigger is offline  
Old   #24
 
elite*gold: 0
Join Date: Oct 2013
Posts: 1,045
Received Thanks: 709
That's almost a 3 year necro lol
Ishtaria is offline  
Thanks
1 User
Old   #25
 
elite*gold: 0
Join Date: May 2009
Posts: 648
Received Thanks: 205
Quote:
Originally Posted by maxsalvatore View Post
where's db of zrohan itemmall share please
Lol
itemmall broken! look my Attachment.
oziel235 is offline  
Old   #26
 
elite*gold: 0
Join Date: Mar 2009
Posts: 260
Received Thanks: 37
Oh man. 3 years already!


kennethz008 is offline  
Reply



« Previous Thread | Next Thread »

Similar Threads
[Help Request] Crash when buying a item at Item mall
Ok so I'm using ECSRO files and I have a problem with the Item mall. When i buy a item (any item) my silk gets reduced instantly but the item is not...
2 Replies - SRO PServer Ask the Experts
[Help] about item mall in ECSRO file !
Hello Guys ! *-.-**-.-**-.-* i want to know how to edit item mall price of rabbit , premium , wolf ... etc i'm using Original ECSRO FILE . ...
1 Replies - SRO PServer Ask the Experts
[Mall] Item Mall Problem
when buying items in ITEM MALL = dc but have item in inv after log in again we want fix it
0 Replies - SRO PServer Ask the Experts
[REQUEST] Item mall item for 0 silk
Hello , I am trying to make some item mall items to 0 silk but there is a problem when i put the cost to 0 silk the users can not purchase the...
11 Replies - SRO PServer - Discussions / Questions
How to buy item mall
Well i got teh coin ready to buy KLK but it won't let me log in to buy the item can some1 tell me how to buy it?
1 Replies - 9Dragons



All times are GMT +2. The time now is 19:19.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Abuse
Copyright ©2017 elitepvpers All Rights Reserved.