i need a populated database.

Welcome in the osiRose emulator Project.

Moderators: osRose dev team, ospRose dev team, osiRose dev team, Moderators

i need a populated database.

Postby -DefaulT on Wed Jul 17, 2013 8:56 pm

Looking for a pre-populated database, all but the accounts table is fine, i just need something to work with, i am making a new tool for database management for the people that dont really know how to use the database or for ease of use i guess. lol

Here are some examples of what im working on.


What i have so far:
  • Connect / Disconnect
  • Settings
  • Character Search
  • Character View
  • Ban
  • Mod Zuly
  • Clan View
  • Direct SQL Queries
  • Online Count

Previews!
Image
Image
Image
Image
Image
Image

Thoughts so far?

So if you want to help out, just do a SQL dump of all the tables except for accounts and i can get to testing. Thanks!
Last edited by -DefaulT on Thu Jul 18, 2013 9:02 pm, edited 1 time in total.
Image
User avatar
-DefaulT
Smoulie
Smoulie
 
Posts: 44
Joined: Wed Sep 12, 2007 5:16 am

Re: i need a populated database.

Postby Sewerguy on Wed Jul 17, 2013 11:00 pm

Looks sick!

Though I cannot provide an SQL file, because I have no players :/
Sewerguy
Jelly Bean
Jelly Bean
 
Posts: 12
Joined: Tue Jan 17, 2012 2:56 pm

Re: i need a populated database.

Postby Rakoon on Wed Jul 17, 2013 11:24 pm

This is cool man!!

i will give you my database its have 200 accounts ready on it for testing, give me some time to upload it for you, maybe tomorrow.

Thanks :mrgreen:
Rakoon
Rackie
Rackie
 
Posts: 204
Joined: Sat Oct 20, 2012 5:49 am

Re: i need a populated database.

Postby -DefaulT on Wed Jul 17, 2013 11:30 pm

thanks, and like i said i dont need the accounts table, for security purposes i dont need the ips and passwords etc, just the other ones lol.

also if anybody knows the way the clan_rank works in the characters database that would help out.

i.e
0 = nothing?
1 = master?
2 = deputy?

etc

thanks
Image
User avatar
-DefaulT
Smoulie
Smoulie
 
Posts: 44
Joined: Wed Sep 12, 2007 5:16 am

Re: i need a populated database.

Postby -DefaulT on Fri Jul 19, 2013 1:31 am

Double post i know but im at a stand still until i get this database, ive done all that i can so far.
Image
User avatar
-DefaulT
Smoulie
Smoulie
 
Posts: 44
Joined: Wed Sep 12, 2007 5:16 am

Re: i need a populated database.

Postby Rakoon on Sat Jul 20, 2013 3:10 am

Hello,

i found an old copy of database, i hope it will be okay to help you, this DEV 4 database and sorry for the Delay. :mrgreen:
Attachments
rose.rar
(549.74 KiB) Downloaded 767 times
Rakoon
Rackie
Rackie
 
Posts: 204
Joined: Sat Oct 20, 2012 5:49 am

Re: i need a populated database.

Postby PurpleYouko on Thu Jul 25, 2013 3:03 pm

Here is a copy of my KTRose database from my local test server on my ofice PC :D
ktrose_db.zip
(49.11 KiB) Downloaded 641 times


don't forget it is a very different design for inventory and storage.
Each player gets a single line of data rather than each item getting one as done before.
Each field is then split up into a series of numbers separated by vertical bar ' | '
These sections correspond to slot position in the inventory/storage.
Each sub-stat for the items has it's own field, also seperated out into individual values.

So as an example you might have 4 items in the first 4 slots

the first field contains the id of the owner.

ItemID
403|44|1|705
Itemtype
10|10|10|10 so they are all consumables
refine
0|0|0|0 of course they are not refined

and so on

There is also a backupstorage table that contains a whole bunch of entries for each character.
The reason for this is so that every transaction is recorded with the present state of the entire storage for that character. Really easy to roll it back that way and also to keep track of scammers or duplicators.

Turns out I don't have an osirose database. I will try to find the time to set up an osirose server at some point to get the data from it. Right now the server is refusing to run properly and I don't really have the time to track down the problem.
Need to lookup information on NARose items, skills, quests?
Now featuring a newly completed skill tree for all classes
Formatting fixed for different resolutions
Image

"A Gazelle is nothing but a giraffe plotted logarithmicaly"
User avatar
PurpleYouko
Rose Guru
Rose Guru
 
Posts: 4733
Joined: Fri Aug 10, 2007 2:05 pm

Re: i need a populated database.

Postby -DefaulT on Sun Jul 28, 2013 1:09 am

thanks purple, you're a big help.
Image
User avatar
-DefaulT
Smoulie
Smoulie
 
Posts: 44
Joined: Wed Sep 12, 2007 5:16 am


Return to Support - OsiRose Emulator

Who is online

Users browsing this forum: No registered users and 6 guests

cron