Loginserver.ini setting up server variables [HELP]

[seridium]

Ok another newb question I am trying to setup my server now that it runs but with the new eqemu there is no Loginserver.ini how do i set up my server inforrlike motd ever admin satatuse Character GM statuse I ave scored the forums and checked the board and in the wiki part in Variables it states.

The best way to set a variable is to run SQL like this directly:

REPLACE INTO variables (varname,value) VALUES('VARIABLE_NAME', 'VALUE');


Which makes 0% sense to me...

Could someone elaborate for me pretty please or point me in the right direction.

[seridium]

The best way to set a variable is to run SQL like this directly:

REPLACE INTO variables (varname,value) VALUES('VARIABLE_NAME', 'VALUE');


Which makes 0% sense to me...


As in I typed in mysql
REPLACE INTO variables (varname,value) VALUES('MOTD', 'Welcome to my server');

And it tells me something about no database, which data base do I use? peq_db?

[seridium]

As in I typed in mysql
REPLACE INTO variables (varname,value) VALUES('MOTD', 'Welcome to my server');

And it tells me something about no database, which data base do I use? peq_db?


Ok I think I figured out the mysql its easier to load mysql from cmd and through directory I Was able to Source Load_players.sql with allot of duplicates and many beeps is that bad? lol sorry im totally new to this.

I also went and re did Peqdb_1129Rev291.sql in the same manner and duplicated a bunch of stuff, is this bad?

Or is it normal when updating to here many beeps?




I also have many other sql files in my directory as in "inventory.sql' "guilds.sql" "petition.sql" and so on am i to source these all in the same manner? or do they have something to do with editing my server?

[Yeormom]

You have to create a schema before you can start sourcing, unless the PEQ script includes a line to create a schema.

[seridium]

So where on this site is there reference to a "Schema"

Where is there a new guide?
Where do I find EQ admin tools that work?

Why is the Guide so outdated? it really doesn't help, you know you told me in a last post "that you could clearly see I knew nothing" but the reason for that is the Guide sucked! not updated but I figured it out after 12 hours of research on my own not being able to connect to a dead site I think I did pretty well but at least if there was a post compiled of new info for creating a server, like even the little things your supposed to figure out on your own like the Schema thing Or maybe a update on the site like removing the Admin server login pages, they are a little mis leading non the least.

Also for the ServerConfiguration page http://www.eqemulator.net/wiki/wikka...rConfiguration do I use this info for 0.7.0 server?


So far I have my server running all seems to run well I have no errors as of yet other then losing connection to login server, GM status everything seems to work fine just had a little trouble getting my friends GM status to allow him to have GM commands such as #itemsearch #gi etc, is there something I am missing to make him have full level GM status I made him level 250 in status in Accounts_ table and Caharacter_ table such as I did with my Characters

[Yeormom]

You used a installer to do all the work for you. Thus, you do not understand majority of what is going on. That installer did about 90% of the work for you when it comes to getting a base installation going. If you have everything up and running as you say, this thread is no longer necessary.