Go Back   EQEmulator Home > EQEmulator Forums > Development > Development::Database/World Building

Development::Database/World Building World Building forum, dedicated to the EQEmu MySQL Database. Post partial/complete databases for spawns, items, etc.

Reply
 
Thread Tools Display Modes
  #1  
Old 11-12-2007, 03:45 AM
cavedude's Avatar
cavedude
The PEQ Dude
 
Join Date: Apr 2003
Location: -
Posts: 1,988
Default

The PEQ Ykesha final release is now available for download from here:
http://downloads.sourceforge.net/peq...se_mirror=osdn

Quests can be had here:
http://downloads.sourceforge.net/eqe...se_mirror=osdn

A brief overview of this release includes:

-A more complete Ykesha including a finished Torgiran Mines and Hate's Fury
-Angelox's Gloomingdeep, Hallowshade wars, and Kithicor/Lake Rathe day/night cycles
-Addition of the Berserker epic
-Several overhauled tradeskills
-A fully working Shadowrest
-Many new quests
-Hundreds of the normal bug fixes for all expansions
-And last but certainly not least tiers 1 - 3 of PoP fully playable with the flagging/progession system in place and events/trials.

Additional files will be needed for Lake Rathe and Kithicor to work properly. Once I get those sorted out, I will link them as well.

Our next release will carry the PoP-Ykesha name, expect that after Elemental/Time are in and tested by the players on Grand Creation.
Reply With Quote
  #2  
Old 11-12-2007, 10:38 AM
Angelox
AX Classic Developer
 
Join Date: May 2006
Location: filler
Posts: 2,049
Default

Here's an explanation on how to get the day and night to shift - I'll post a Linux and a Windows script/example.
First, what happens;
I made a variable in quest_globals table called "shifter" - shifter will have 24 values and will change every EQ hour, starting with "8" (8:00 am).
How to make this variable change by the EQ hour?
With a script, that runs outside the emulator I called "shifts". Call shifts from your startup script, example;
Code:
#!/bin/sh

wine MiniLogin.exe > logs/MiniLogin.log &
P=`pwd` 
export LD_LIBRARY_PATH="$LD_LIBRARY_PATH:$P"
#make sure we have a place to log
mkdir -p logs 2>&1 > /dev/null 

#boot up world
if [ ! -e .lock-world ] ; then 
	    touch .lock-world 
	    ./world & 
	    # wait for shared memory to load
	    sleep 20 
fi 
#start up the official launcher
if [ ! -e .lock-launcher ]; then
	    touch .lock-launcher
	    ./shifts &
	    ./eqlaunch zones &
fi
Attached to this post is a package; time.tar.gz
install the time directory in your /server directory (/eqemu/server/time), with the sql files. shifts goes in /eqemu/server.
If you downloaded the latest PEQ, then it will all work.
the "shifts" script is for Linux - my next post here will be a windows/version script.
This will work fine, I've used it with no problems on my server, and now its running flawless with PEQ.

EDIT:
Actually no need to make a windows batch, just add this line to your startup.bat file;
Quote:
start perl.exe shifts.pl
rename shifts to shifts.pl and you will have to edit shifts and change the time/*.sql to time\*.sql (or maybe perl will know )

Last edited by Angelox; 11-12-2007 at 06:45 PM..
Reply With Quote
  #3  
Old 11-12-2007, 11:45 AM
Angelox
AX Classic Developer
 
Join Date: May 2006
Location: filler
Posts: 2,049
Default

You will need to run this into your database also:
Code:
INSERT INTO quest_globals
   (`charid`, `npcid`, `zoneid`, `name`, `value`)
VALUES
   (0, 0, 0, 'shifter', '1');

INSERT INTO quest_globals
   (`charid`, `npcid`, `zoneid`, `name`, `value`)
VALUES
   (0, 0, 20, 'kith', '1');

INSERT INTO quest_globals
   (`charid`, `npcid`, `zoneid`, `name`, `value`)
VALUES
   (0, 0, 51, 'lrathe', '1');
Reply With Quote
  #4  
Old 11-12-2007, 01:15 PM
John Adams
Demi-God
 
Join Date: Jul 2006
Posts: 1,552
Default

Nice work on the DB and quests, guys. PEQ is my favorite DB.

That night/day shift thing looks awfully complex. There really is no provision in the emulator to handle it internally? I know I could never get it to work, but I thought it was my lack of understanding.
Reply With Quote
  #5  
Old 11-12-2007, 11:12 PM
sdabbs65
Dragon
 
Join Date: Dec 2003
Location: Earth
Posts: 818
Default Why the day/night cycle don't work.

Quote:
Originally Posted by John Adams View Post
Nice work on the DB and quests, guys. PEQ is my favorite DB.

That night/day shift thing looks awfully complex. There really is no provision in the emulator to handle it internally? I know I could never get it to work, but I thought it was my lack of understanding.
I been watching this thing for a while now but nobody ever mentions it's for a
*nix Build I guess they just think everyone runs *nix these days.
the Day Night cycle is designed as a *unix script but you can easy use it for windows also.
theres a program called crontab that lets it work for windows.
CRONw is a small collection of Perlie things providing the main functions of a *nix-style CRON to the Perl-enabled Windows world.
It runs as a system service without any additional tools, using the functionality provided by Win32:aemon
http://cronw.sourceforge.net/
__________________
hosting Eqemu/Runuo/wow Emulators.

www.cheaterz.info
Reply With Quote
  #6  
Old 11-12-2007, 11:49 PM
Angelox
AX Classic Developer
 
Join Date: May 2006
Location: filler
Posts: 2,049
Default

Actually, I first made it as a .bat file for windows-when it was just two lines intended for the day/night mobs in Rathe a Kithicor.
Maybe someone will make a script in C and we'll have it in the source. the SQLs I made for npc_types and spawn conditions, will always be needed regardless what is done. Something like a new variable called $time would be nice. (if $time >=800 and <=1900, then it would be day time, or you could say , if $time==1936 , you could spawn some mob and start something )- $time would just return the current EqEmu time.
I just like to make things work "now", and will do anyway I know how to. It's all working nicely with no problems, so why not?
Seems to me Perl is underestimated in EqEmu. Just thought of as a "quest" tool , when you can do so much more. When I want to do something different, first thing I start thinking of is "Perl" solutions, probably because I haven't learned much in C yet.

Last edited by Angelox; 11-13-2007 at 07:56 AM..
Reply With Quote
  #7  
Old 11-14-2007, 02:41 AM
Zandig's Avatar
Zandig
Hill Giant
 
Join Date: Jun 2006
Location: New York City
Posts: 180
Default

I don't believe this version is on the CVS?

It seems the last time the CVS was updated was 24 October.

Is the CVS not being updated?

Anyhow, thanks for the database! Much appreciated.
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 02:08 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