Ok thanks ACraig

Thats a v. good overview. You need to decide what you want. Yes, there are full Java bindings for CrystalSpace as there are for OpenGL with JOGL and LWJOGL etc etc. If having graphical character creation facilities would be desirable. Lots of work has been done PHP wise, its not worth throwing unless you envisage something considerably more advantageous.

Once you know what you want let me know.

All the best
PR

Ok Caarie

Many thanks for reply. Its a big picture, I'm sure I'll understand more presently. The DB adminstrator can restrict with logins get access to which tables/data in MYSQL Admin so that should can help stop people running riot. Whether via a webapp or directly with MySQL logins. With the space thing, I wish I was a millionaire! I would donate! By direct access you mean a login to MySQL itself I guess. Weird that changes come after a restart, I run MySQL locally and on my server which my business runs on, and both update instantly. Perhaps its been set up that way? I would help to keep an eye on whats been changed!

Many thanks
PR

A point that made me smile
"This is comparible to writing something like phpMyAdmin or a similar MySQL type of interface?"

To Clarify Steuben's point - the Webclient formulates SQL queries for you currently, and adds revision information into the SVN? The Webclient directly alters the tables or you upload the SQL queries manually into MySQL?

The webconsole then seems to be many things? A GM tool, a character editing software for NPCs, a quest configuration tool. In fact a wrapper for all that is linked to the Database game wise? Its a tall order, and would need to be cut into pieces that could be worked on, by a head developer on PS.

I'm a Newb with capital 'N' @ PHP. But it looks like a Servlet-esque server side scripting language. I can figure out whats going on I guess.

I have started writing and re-writing this response * 10. I scanned through 'Aerig' docs. Though a login @ browse only or screenshots would help.

1. Taking ACraigs earlier point - Do you want the webconcole re-written in-whole or in-part with a client-side Java GUI?  *EDIT* I notice as I scan the PHP. That PHP uses specific commands to interact with MySQL, so it may offer limited 'lifting' of queries.

2. Or do you want a re-write of the PHP code in Serverside Java. I don't know about the limitations of PHP vrs Servlets.

I need to know if you a proposing a re-write of the PHP existing console or a new Client side tool?

I worked on a help-desk solution some years ago that attempted to replicate a large Java GUI for 'emergency' work by employees when at home. The content was all Scripted in --Java Servlets and JSP server side-- and piped back in HTML, with the usual splattering of Javascript on the client side. it got really complicated and the s/house eventually gave it up for lost. But I can see the advantages that non-tech. users can just login and forget about trying to compile are install any programs to adjust in-game settings. I have experience at this. Problems were always HTML layout making the HTML experience feel like a GUI. IMO HTML=HTML dont try.
I'll carry on looking over this material as free-time permits.

Best regards
PR

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

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.

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