Java web programmer any use?

[lemongrove]

Hi,

I have some skills at Java programming & web development. If this is any use?
I did think about offering to help with the coding, but my C++ is really poor, and I don't know much about OpenGL.

thanks
Paul

[acraig]

Yes. I am sure we would have a use for some Java application programmer.  Right now we are missing a fair number of tools and was considering Java as a platform to develop those tools on.

[lemongrove]

Fine, tools are no problem. Let me know the requirements spec. And I can get right onto it.

Best regards Paul

[lemongrove]

Thought I better add, I terms of interacting with C code. In the past I've done this by connecting to ports etc, I'm good network wise, and file wise for getting data into Java tools. But I'm not too good with JNI native interfaces into C. You'll have to take care of this bit, should you need it.

[acraig]

Do you know if Java ( or applets ) have any capability to connect to a mysql database?

[steuben]

http://dev.mysql.com/usingmysql/java/ <--- looks it maybe...

[lemongrove]

Yes sure, I can connect to any database that you have a JDBC driver for. I have much experience doing this. Its easy to do, MySQL comes with a JDBC driver.

*edit*

Though as for Java applets, let me know what you have in mind. I have some Swing (GUI) experience which is okay for running desktop tool stuff (its stable). I have a lot of experience running up browser interfaces using DHTML run up by Servlets. Its easy to install on your server as well. But if you want to run a Swing GUI inside a browser, this used to be a bit buggy about 5 years ago last time I tried anything complicated with it. About the time of Java 4.0 I think it was. I don't have any experience of the new native Widget GUI stuff, but I'm not sure if thats properly portable yet.

Best regards Paul

[acraig]

It seems to me that a client application will be better suited at least initially.  Right now we have many database tables and trying to enter data in them is not always easy and can be prone to mistakes because of all the keys into different tables.   Initially I'd like to be able to present a nice interface to these tables. I will have to take a look and see what Crystal Space supports in terms of Java as well.  But I could see this application expanding out to where we can load character models for NPC's and customize them. 

Right now, just having a nice tool to be able to update tables with new items easily would be a great help

[lemongrove]

Do you have a schema I can see?  Are you aware of 'Navicat' its a great interface into MySQL? I use this in my business work. I does all kind of useful things. Upload spreadsheets and do all kinds of things that PHP MyAdmin sometimes had problems with.

1. You want this interface to be used on local PCs only by approved folks with security clearance for remote MySQL access onto the server to edit characters on the server?
2. Or to access characters on a local client machine stored on locally on a PC with MySQL running locally?

3. How is character data currently stored schema wise?
4. Will this be a text only interface for editing and type checking character attributes?

Best regards
PR

[Caarrie]

you might want to take a look here http://planeshift.svn.sourceforge.net/viewvc/planeshift/trunk/src/server/database/mysql/

[steuben]

1. yes

3. the svn data can answer that simply. http://xrl.us/pssvnguide
4. managing the database and all that that entails... if you can figure out how manage sc_pathpoint generally you win bonus point

the svn has copy of the exsisting wc there as well.

[lemongrove]

I had a scan

http://planeshift.svn.sourceforge.net/viewvc/*checkout*/planeshift/stable/data/races/quickpaths.xml?revision=23&content-type=text%2Fplain

SVN is some kind of repository? I only ever used Sourcesafe. In reality I've never used SVN?

Do I read you want me to try to compile the a server locally to get access to the tables locally? I'm confused how you are writing the SQL queries? By hand?

Best regs
PR

[acraig]

Your best bet to start is to take a look at:
http://planeshift.svn.sourceforge.net/viewvc/planeshift/www/webconsole/

This is our 'web console' written in PHP that attempts to provide some tools to access the database in a meaningful way.   Basically it's hiding the schema of the database so that the rest of the team can add the content to the game.  Right now its very poorly done and the settings team is always having issues with it. 

It is a bit of a mess but it's something to start on.  I can take some screen shots and give you an idea of what it is.

[steuben]

the initial inserts for the most part, yes. after the the webclient, or wc, builds them. /www is the current webclient. it is a php based site. that builds up the queries.

no you don't have to build the server. mostly you just have to pay attention to the sql directory in server. you will be able to setup the sql portion easily... skip the compile portions of the walkthrough and just pay attention on how to setup the sql portion.  it will give you an idea of what you will have to hook into.

yes it is a code reposioty. pretty simple to use. i can an i crash compilers on hello world code, as the joke goes.

[Tuxide]

lemongrove:  You'll also want to check out this thread to give you a better idea of what is needed in this "web console" project, and maybe even the PlaneShift build channel on irc://irc.freenode.net/#planeshift-build as well.  I have both psserver and webconsole up and running on localhost and have somewhat interest in what acraig needs as well.

SVN is some kind of repository? I only ever used Sourcesafe. In reality I've never used SVN?

SVN is a repository; SourceForge did away with CVS.