Go Back   EQEmulator Home > EQEmulator Forums > General > General::General Discussion

General::General Discussion General discussion about EverQuest(tm), EQEMu, and related topics.
Do not post support topics here.

Reply
 
Thread Tools Display Modes
  #1  
Old 11-10-2008, 06:18 AM
Talio
Fire Beetle
 
Join Date: Oct 2008
Location: USA
Posts: 14
Default New To This, Any Guides?

Well I've managed to get a server up and running... toyed with some variables in the database... Etc, and find myself wondering if there are any guides out there or any FAQs regarding common questions.

I tried searching for EQemu guide but everything went to dead links, so if anyone has any good ones please let me know!

Mainly I'm curious about how to set what zone players are forced to start in, among many other minor alterations like that.

I apologize if I have simply overlooked such a guide in my searches, thanks in advance!
Reply With Quote
  #2  
Old 11-10-2008, 08:52 PM
trevius's Avatar
trevius
Developer
 
Join Date: Aug 2006
Location: USA
Posts: 5,946
Default

There is a FAQ in my sig, and an entire Wiki of information here:

http://www.eqemulator.net/wiki/wikka.php?wakka=HomePage

To set players to start in a certain zone, you just need to update your variables table and add startzone to it in the varname field. Here is an example to have them start in nexus:

Code:
varname		value		information
startzone 	nexus 		Sets the Starting Zone for all new characters
__________________
Trevazar/Trevius Owner of: Storm Haven
Everquest Emulator FAQ (Frequently Asked Questions) - Read It!
Reply With Quote
  #3  
Old 11-11-2008, 05:21 AM
Talio
Fire Beetle
 
Join Date: Oct 2008
Location: USA
Posts: 14
Default

Alright, thanks a bunch for this plethora of info =)

Much appreciated.
Reply With Quote
  #4  
Old 11-11-2008, 10:40 AM
Talio
Fire Beetle
 
Join Date: Oct 2008
Location: USA
Posts: 14
Default

Well I have been searching the net for a clear explanation on how to add rows to a present table and haven't come up with anything. Something about querying the database? None of the code I have found seems to process properly through Navicat.

Does anyone have any links to any straightforward guides on mysql? I've tried searching for some but none seem to give decent explanations on inserting rows and queries.
Reply With Quote
  #5  
Old 11-11-2008, 10:58 AM
Talio
Fire Beetle
 
Join Date: Oct 2008
Location: USA
Posts: 14
Default

Alright i spent literally 2-3 hours combing the internet for tips concerning this and then I am humbled by my own stupidity as i click "insert record" under navicat...

I feel like such a newbie. Somehow, I know an orc pawn is to blame.
Reply With Quote
  #6  
Old 11-12-2008, 07:45 AM
Talio
Fire Beetle
 
Join Date: Oct 2008
Location: USA
Posts: 14
Default

So, i've managed to add that row to my variables table and yet it doesn't make new players start in the nexus. They all still attempt to zone in to tutorialb.

I am running the most recent version of EQemu and am using the most recent version of PEQ database files. I use Navicat to alter the database, and am really stumped as to why my new players don't spawn in the nexus (i've also tried spawning them all to tutoriala as a test, to no success).

If anyone's willing to help me out I'd appreciate it!
Reply With Quote
  #7  
Old 11-12-2008, 05:21 PM
unknownhost
Sarnak
 
Join Date: Dec 2006
Posts: 89
Default

it can be very frustrating, believe me i know! but dont give up! keep at it and it all becomes more and more clear over time.

a suggestion if you havent tried it, try the
peq serverpack installer.

http://www.projecteq.net/phpBB2/viewtopic.php?t=4346

and the self-installing updates are here(just need the most recent i believe?)
http://www.projecteq.net/phpBB2/viewtopic.php?t=4612

they will make the server setup unbelievably easier.


for your edits aside from the mysql tool you are already using (which is ideal for many things but clunky for others) try using GeorgeS tools are they are nothing short of badass in every regard.

http://www.eqemulator.net/forums/forumdisplay.php?f=674
Reply With Quote
  #8  
Old 11-12-2008, 05:52 PM
trevius's Avatar
trevius
Developer
 
Join Date: Aug 2006
Location: USA
Posts: 5,946
Default

For spawning NPCs, GeorgeS has a very nice tutorial on his website here:

http://wizardportal.dyndns.org/eqemu...tut/index.html

Also, at the top of that page, there is a link to another good tutorial for making NPC pathing.

And, if you haven't tried them yet, try installing and setting up GeorgeS editing tools. His tools are pretty amazing and make database editing much easier and quicker.

Keep in mind that everyone around here gives information when possible. There is so much info out there that it would be near impossible to have it all up to date. But even though a large amount of it might have some outdated information, it is still WAY better than not having any info at all. Almost all of it is still extremely useful, and mostly only just needs a small change here and there.
__________________
Trevazar/Trevius Owner of: Storm Haven
Everquest Emulator FAQ (Frequently Asked Questions) - Read It!
Reply With Quote
  #9  
Old 11-13-2008, 07:39 AM
Talio
Fire Beetle
 
Join Date: Oct 2008
Location: USA
Posts: 14
Default

Alright well with a combination of information I managed to set a different starting point for new players (woot). I am going to delve into setting NPCs and such now... You're sure right there's a lot of information out there.

I was steamed last night when NOTHING I did was fixing the database to at least work the way it had before toying with it. I even did a fresh clean download and install with winCVS of fresh database files which caused zone.exe to error on tables that were sourced and existed in the database (npc factions).

I ended up sourcing a dump of my old database from when I transfered this lil project from a different computer over to a dedicated always-online machine. This dump seemed to have fixed the problem and the database now runs again (thank god my father taught me to always back stuff up from the time I was 3 to 21).

Now.. zone.exe seems to take longer loading the loot tables.. but eventually gets through it and I'm not going to complain.. an extra minute or so on loading up the server shouldn't be a problem especially if i end up loading a lot more into it later on =)

Thank you for all your patience folks, I appreciate it and will look through these links for any info that might help me in my endeavor to not screw up another database! lol.
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

   

All times are GMT -4. The time now is 12:03 AM.


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3