PS development questions

[Baston]

Hello,

I\'m sure that my post will be redundant but ... hey this for give some help to devs so ... ;-)

I want to help you in dev, I\'d like to do 2 main things : an easy quest editor (if it doesn\'t exist yet) and an improvement of NPC AI (this is my studies field) particularly in conversationnal agent (Harnquist, Trasock, Jirosh, etc.).
But to do that I need to run a server on my own and it seems that the PS server is unable to create a valid database so my question :
Are their any database SQL script at least to create database scheme ? I really don\'t want to reverse all the DB code to reconstruct the DB scheme... I have not the time to do that.

My second question is : is there any point to do the things I want to ?

I think (but I have not yet read the code) that the AI agent are only based on things like AIML chat bot or things like that. I\'m working on this kind of things, maybe it can be an help for you.

my own project :
http://slackget.infinityperl.org/

My current study project :
http://www-poleia.lip6.fr/~ramalho/patrolling/

Moreover, I\'m a Perl modules maintener for CPAN.

Sorry if the answer is already in the forum, I\'m in england and this is the third-world of the Internet : no open wifi (or not many) and a sooooo low bandwith (max found in london 8Mb/s !!! Damn I want my 20 Mb/s line :\'( ) so I have difficulties to connect myself to the internet and browse forums.

Good day

[peeg]

Hello Baston!
The Developers can always need some help! If you are firm with AI you should definitely apply to the team. Harmquist -the thief^^- could seriously need a brainwash
Details can be found here:
http://www.planeshift.it/helpus_recruit.html

[Cha0s]

Hello and welcome! If you\'re interested in devving, I\'d suggest reading the readmes that come with the source code. You may need to look in one of the Linux build guides. The method for creating the database is the same for all, so it doesn\'t matter which one you pick.

EDIT: I\'m not sure if Windows mysql runs different than *nix/Mac, now that I think of it. You may need to get at mysql a different way, though it can\'t hurt to try the things in the *nix guides.

[AryHann]

Originally posted by Baston
Hello,

Hi there!

I want to help you in dev, I\'d like to do 2 main things : an easy quest editor (if it doesn\'t exist yet) and an improvement of NPC AI (this is my studies field) particularly in conversationnal agent (Harnquist, Trasock, Jirosh, etc.).

The quests at the moment are made into the db with the server console.
What do you mean with easy quest editor?
What shall this do?

But to do that I need to run a server on my own and it seems that the PS server is unable to create a valid database so my question :
Are their any database SQL script at least to create database scheme ? I really don\'t want to reverse all the DB code to reconstruct the DB scheme... I have not the time to do that.

What kind of error do you get when you try to create the database?
On which platform are you on?
Which compiling guides are you reading?

My second question is : is there any point to do the things I want to ?

There is if you follow the \"guidelines\" that PS is supposed to follow as well. It doesn\'t make sense that you start to work on something that is far beyond what PS is aiming at.
It is more convenient that you explain more carefully what you are planning to do for making better the NPC AI to the engine leaders, namely acraig and Vengeance.

Good luck with your projects!

[Baston]

Ok basically I just tried to start the server with a running mysql (a fuzzy area of my brain hopes that the server will create the database scheme on his own ;-)).

Reading you answers I believe that there is a point in creating a easy quest editor. I\'m thinking about something like a web front end for the mysql database. I heard (and you confirmed) that creating quest is just adding data in a database. It\'s easier and quicker do to that from a front end. The aim is to allow non SQL syntax friendly people to create quest as well.

About the AI, I need to read the code before anything but my orginal idea is to make more \"clever\" the NPC in their dialog with human players. It\'s quite hard to talk with them for the moment so I propose my help in the hope I can help makes it better.

[AryHann]

Originally posted by Baston
Ok basically I just tried to start the server with a running mysql (a fuzzy area of my brain hopes that the server will create the database scheme on his own ;-)).

Eheh, it doesn\'t work like that. If you read any of the available compiling guides you will discover that you have to \"fix it\" yourself. Basically there is an .sql \"source file\" which let you insert all the proper data in a database.
Read the guides! You find them in /planeshift/docs if you have downloaded PS from CVS, as I supposed you do.

Reading you answers I believe that there is a point in creating a easy quest editor. I\'m thinking about something like a web front end for the mysql database. I heard (and you confirmed) that creating quest is just adding data in a database. It\'s easier and quicker do to that from a front end. The aim is to allow non SQL syntax friendly people to create quest as well.

We have already a tailored front end, it is called server console. You can find the code of it in planeshift/www if you downloaded from CVS (again, as I suppose you do ). You can look at it. It is php based as far as I know. Maybe you would like to improve it following Talad\'s guidelines? If yes, I invite you to talk with him.

About the AI, I need to read the code before anything but my orginal idea is to make more \"clever\" the NPC in their dialog with human players. It\'s quite hard to talk with them for the moment so I propose my help in the hope I can help makes it better.

That\'s great. In this case, you should talk not only with Talad, but acraig or Vengeance as well, and with Magodra who has been working on the quests lately - as far as I know - more than others.

[invaginius]

hello, i\'m a java system architect and dba, and i joined ps as a player with mb release; is \"help us\" valid also for the server side? i can\'t help with graphics or 3d, and my c++ work experience is very limited, but i could help with db schemata and patterns, if needed.

which enviroment do you use for developing beside visual studio? i\'m used to develop on linux, someone got eclipse cdt up and working?

which version of mysql is installed on laanx server? as of version 5.0.3, decimal data type is no longer stored as a string, but as byte per two digit, making a deal to convert all float (4 byte) columns, which also generate a lot of approxs

[AryHann]

Hi,

Maybe you could apply for Rules or Settings? They are really though department though.

Otherwise you might help with the db as you say in the engine department, but I would suggest for that anyway a strong C++ confidence. You should definetely talk with acraig or Talad and propose your ideas about it.

I personally use MSVC 7.1, but PS can be compiled also in MinGW and in Linux. I haven\'t heard of anybody using Eclipse for PS.

If I remember right, we switched recently to version 5 of MySQL, but I don\'t remember the subversion, unfortunately.