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.

[seridium]

Actually you are mistaken I installed the server from this method http://www.eqemulator.net/wiki/wikka...ka=ws992mysql5

I downloaded from the guide EQEmu 0.7.0.1129 Revision 222
Then I grabbed the Map Pack & New Map Pack
Then downloaded
ActivePerl-5.10.0.1004-MSWin32-x86-287188.msi
WinCvs2_0_2-4
MySQL v5.0.37

I used step by step, by the guide and then used from reference from Guide.pdf to install ---->a PEQServerPack PEQServerPack-Maps-4.0-1110a.exe

So now that the server is running as I said there are 3 things I don't know how to do I figured the rest out myself, when I installed the maps through the
PEQServerPack-Maps-4.0-1110a.exe file I un Checked allot of stuff as I did not want to mess with what I recently installed from the Guide I followed so I Did not use the PEQServerPack-Maps-4.0-1110a.exe to install for me as I knew what it did when I used it so please could you help me with my questions instead of belittling me and making me more frustrated than I already am.

[trevius]

What exactly are your questions? For GM status changes to work, the person who is using the new status needs to exit EQ completely and restart it for the changes to take effect. If you have already made the status change on his account in the accounts table, then that is all you need to do.

As for updated guides, the only guide you should really be following is the one you linked in the post above this.

For server config, the server code download should include the config files you should be using. If it doesn't then get the 1129 version download from the downloads page off of the main site here. That will include any files you may be missing from the R222 download from the SVN. You should be able to get 1129 and then copy R222 files over that directory. Also, note that there are newer revisions released than the R222 version. You can use any of them as long as the database version matches the revision of server code you are using.

If you aren't having any actual problems, then what are the questions you are needing answered?

[Angelox]

We all have to start somewhere - at one time I didn't know what MySql was, and a schema is deeper than that- You're going to have to Google a lot, and save all the good questions for the forums, I just Googled 'what is a MySql schema' and I thought this was a good one;
InformIT: Sams Teach Yourself SQL in 24 Hours > What Is a Schema?
Actually, that's AltaVista - they were pioneers in web search, I used them when it was a 'text only' Internet.

[Angelox]

Didn't see your post there trevius, is wasn't up yet while i was writing my post - I just figured this person needs to learn all the basics and that can easily be done with Google search.
I've really learned a lot about everything just by using search engines. saves a lot of wait-for-response time, and forum spam too.

Originally Posted by trevius

What exactly are your questions? For GM status changes to work, the person who is using the new status needs to exit EQ completely and restart it for the changes to take effect. If you have already made the status change on his account in the accounts table, then that is all you need to do.

As for updated guides, the only guide you should really be following is the one you linked in the post above this.

For server config, the server code download should include the config files you should be using. If it doesn't then get the 1129 version download from the downloads page off of the main site here. That will include any files you may be missing from the R222 download from the SVN. You should be able to get 1129 and then copy R222 files over that directory. Also, note that there are newer revisions released than the R222 version. You can use any of them as long as the database version matches the revision of server code you are using.

If you aren't having any actual problems, then what are the questions you are needing answered?

[seridium]

Thanks for the help much appreciated I will now learn Schema