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

11-12-2007, 03:45 AM
|
 |
The PEQ Dude
|
|
Join Date: Apr 2003
Location: -
Posts: 1,988
|
|
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.
|
 |
|
 |
 |
|
 |

11-12-2007, 10:38 AM
|
AX Classic Developer
|
|
Join Date: May 2006
Location: filler
Posts: 2,049
|
|
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;
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..
|
 |
|
 |

11-12-2007, 11:45 AM
|
AX Classic Developer
|
|
Join Date: May 2006
Location: filler
Posts: 2,049
|
|
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');
|

11-12-2007, 01:15 PM
|
Demi-God
|
|
Join Date: Jul 2006
Posts: 1,552
|
|
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.
|

11-12-2007, 11:12 PM
|
Dragon
|
|
Join Date: Dec 2003
Location: Earth
Posts: 818
|
|
Why the day/night cycle don't work.
Quote:
Originally Posted by John Adams
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/
|
 |
|
 |
 |
|
 |

11-12-2007, 11:49 PM
|
AX Classic Developer
|
|
Join Date: May 2006
Location: filler
Posts: 2,049
|
|
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..
|
 |
|
 |

11-14-2007, 02:41 AM
|
 |
Hill Giant
|
|
Join Date: Jun 2006
Location: New York City
Posts: 180
|
|
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.
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
All times are GMT -4. The time now is 02:08 AM.
|
|
 |
|
 |
|
|
|
 |
|
 |
|
 |