missing sql headers and menu skins.

[ouch]

so where are all the current SQL headers? Seems like I'm missing 3/4 of all the game items or more.

I'm also missing some of the menu skins as some menus are missing backgrounds, icons and a bunch of other things. I downloaded the SVN art package and then copied the art directory from my planeshift install to the art directory of the compiled source. Should I not of done that?

[peeg]

There's only a very basic art-package available via SVN - if you want to use all the art the official client includes copy over the files from a installed client.
The SQLs you received contain all the public data which is needed to run a testserver - you wont find all items/rules/.. that are available on laanx in there.

EDIT: Sorry, i read too fast.
Try to copy over the art that's included in the official client and re-checkout the svn-art again. Plus: Don't use the "data" folder that comes with the official client.

[ouch]

well the compile guide says to copy everything in the data folder but the gui subfolder. Should I not of done that?

isn't the SQL headers code and not art though? according to the licensing section of the website it said all code is available but the art is not. But from what I can see it's just the opposite.

I originally wanted to help out for the experience with SQL databases. So I was going to go through and correct some bug reports dealling with items and stuff in the database (particularly that really old one about the sizes of mugs and things being larger than some swords...) as well as add a few new tranformations. (mainly allowing allready molten ores to be combined to make steel, bronze, etc..)

[Caarrie]

I originally wanted to help out for the experience with SQL databases. So I was going to go through and correct some bug reports dealling with items and stuff in the database (particularly that really old one about the sizes of mugs and things being larger than some swords...) as well as add a few new tranformations. (mainly allowing allready molten ores to be combined to make steel, bronze, etc..)

No one out side the dev team can fix or attempt to fix those, and very few people have the access to fix them, any time you put into fixing them would be useless as you dont know how the database on laanx is setup or any other info to do what you wish.

[ouch]

well yeah, that's kinda my whole problem...

Kinda makes you wonder why planeshift is labled open source when it quite clearly isn't once you get the source code up and running...

[peeg]

PlaneShift's (read: the engine's) source is completely open. Everything that's not directly code (read: the content) isn't - It's pretty simple
However, I'm quite sure that the db's overall structure on laanx is the same as the the one on a testserver.

[ouch]

well see there you go, your doing it too. SQL headers ARE code. And without them a vast majority of planeshifts "engine" will not work or at the very least, never be used.

[peeg]

The SQL itself is code, yes. But it's only used to put content (namely the items/quest/yadda) into the database ...

[acraig]

well see there you go, your doing it too. SQL headers ARE code. And without them a vast majority of planeshifts "engine" will not work or at the very least, never be used.

What do you mean by 'headers' though?  Do you mean the table structure .sql files?

[ouch]

yes I was refering to the table structure .SQL files

[acraig]

Should all be defined here:
http://planeshift.svn.sourceforge.net/viewvc/planeshift/trunk/src/server/database/mysql/

[ouch]

I wish, but no, there is tons of stuff missing. steel, isn't in there, zinc, tin, bronze isn't in there either. armor I believe is completely missing as well as shields.

This file has most of the stuff listed. (80%-90% or so)
http://planeshift.svn.sourceforge.net/viewvc/planeshift/trunk/src/server/database/mysql/item_stats.sql?revision=705&view=markup

[Caarrie]

I wish, but no, there is tons of stuff missing. steel, isn't in there, zinc, tin, bronze isn't in there either. armor I believe is completely missing as well as shields.

This file has most of the stuff listed. (80%-90% or so)
http://planeshift.svn.sourceforge.net/viewvc/planeshift/trunk/src/server/database/mysql/item_stats.sql?revision=705&view=markup

As Peeg said you dont get all that is on laanx and the devs have their reasons for this. You have just enough info to run the server and use it for testing, there is no data in order for you to make the server into a duplicate of laanx. Unless you join the dev team there is no way you can get any access to any of this and even at that most devs dont have access to all aspects of the server.

[ouch]

well if thier sole reason is to prevent others from makeing a duplicate server there are other ways of doing that than excludeing 90% of the game.

[neko kyouran]

PlaneShift's (read: the engine's) source is completely open. Everything that's not directly code (read: the content) isn't - It's pretty simple
However, I'm quite sure that the db's overall structure on laanx is the same as the the one on a testserver.

PS's license isn't up for debate.

answer given.  thus, lock.