~~WARNING STILL LEARNING MYSELF I MAYBE WRONG!~~
Quote:
|
Originally Posted by Kode Black
Could someone please clarify the different parts of a server for me, it sounds really dumb but I have yet to completely understand them.
Source:
Database:
Configuration:
|
The source is the code for the server executibles. These executibles read the info in the database and send that info to the client. It also does most of the calculations for mana, hitpoints, damage, exp, AA, runspeed ect ect.
The database is where all the filling for eq is stored. Its job is to simply hold all the info for the game. This covers almost everything from the names of NPCs' to the player's characters to the items, to the factions to the loot tables and quite a few other things.
Configuration is how your server is set up. Pretty simple.
Quote:
MySQL: This basically manages the database, allowing you to edit the mobs, spawn times, zonepoints, drop rates, regen rates and more along those lines, mostly anything pertaining to the database. MySQL also runs quest scripts made with Perl.
Am I right on that?
Perl: Enables you to write scripts which will be run in mysql. Can these scripts be edited by sql? Is perl run hand in hand with sql, or is it seperate and sql just uses the scripts made in perl?
Compiler/Compiling: WTF? Something to do with creating/editing a source I think.
|
MySQL is a database server program. Its job is to give out the info in the database to programs that ask for it. You can edit your database with mysql in the command prompt but there are other window programs out there that make the task much easier.
Perl is a programming language. What is meant when people ask if you have installed perl is if you have installed the perl compiler. Perl is one of the few languages that is platform independant, meaning that the perl script you write can run on any OS as long as they have the compiler installed. SQL does not run any perl scripts. As I understand it here is how the perl system works.
- Player zones into a zone with quest npc's
The server executibles load the quest file with the help of the perl compiler.
The server executibles then tell the client what to display to the client.
If the conditions of the quest are met the server executibles then add/remove/edit some info in the database and tells the client what to display to the player.
Perl scripts can be written in almost any text editor including textpad for those who are bold.
A compiler is a program that takes the source code and turns it into executibles. Visual Studio.net is the only compiler supported with EQemu (afaik) As for editing the source, well you can do that in notepad if you feel bold enough. Programs like Visual Studio.Net color code everything and make it nice and pretty.
As for the AA question, I think some of the info is hard coded into the server and other info is in the database.
**EDIT**
Closing tags and removing extra close tags
