PEQ Ykesha Beta DB and Quests Released

[cavedude]

I've decided to package up the database and quests to provide a proper release for those asking for it. It occured to me to name it Ykesha because that is more or less complete, including most of the expansion's quests. *Please note that PoP was skipped and is by no means complete or even playable in this release!* The next release branch will carry the PoP name and then on to LDoN and so forth.

Tons of great things in this release including hundreds of new quests and bug fixes, a pretty complete Vex Thal, all Epic 1.0 quests except Berserker, Beastlord, and a partially complete Paladin, PoK fully working including a good amount of its quests, several overhauled or newly popped zones, and countless tweaks, additions, etc. You will also find most of the zones the 0.6.2 client supports are popped, some with basic loot and faction. However, aside from Luclin and below, Ykesha, and PoK, none of those zones have even been looked at, so they are probably unplayable.

Here is the link for the database: http://downloads.sourceforge.net/peq...se_mirror=osdn
And the quests: http://downloads.sourceforge.net/eqe...se_mirror=osdn

I'll be updating the main ProjectEQ page with the links as I find time.

Installation is the same as the previous releases. Please report any unreported bugs on the ProjectEQ forums at: http://www.projecteq.net/phpBB2/ If you need your forum account activated until we get our anti-spam system up you may PM me on these forums.

Have fun!

[cavedude]

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.

[Angelox]

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;

#!/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;

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 )

[Angelox]

You will need to run this into your database also:

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');

[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.

[sdabbs65]

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/

[demen302]

Is this file still around anywhere? link is not working. time.tar.gz Would to try the day night shifts. Thanks!

[Angelox]

Originally Posted by demen302

Is this file still around anywhere? link is not working. time.tar.gz Would to try the day night shifts. Thanks!

The link works, just a little slow to start sometimes - try a few times and you'll get it

[Knightly]

I'm not sure if this should go in this thread or not, but I've made some changes to Angelox's time script on my own server and thought I'd share in case anyone else is as lazy as I am.

I really like the time sync, but I tend to change my database password from time to time and the shifts.pl was a problem for me to edit every time (again - laziness). I also don't like keeping track of extra directories, so I took out the need for the hourX.sql files.

Finally, I run a Windows Server most of the time and seeing a blank window makes me feel like it's not doing anything. Obviously, I can look in the database and see that it is, but I added output anyway (take out the green line below if you don't want this).

My shifts.pl is as follows (you'll need to change the variables at the top of the script to match your database login information):

#!/usr/bin/perl -w
$dbhost = "localhost";
$dbuser = "user";
$dbpass = "pass";
$database = "db";
$timenow = 8;

while (1) {
	print "Setting time shifter value to $timenow.\n"
	`mysql --host=$dbhost --user=$dbuser --password=$dbpass --database=$database --execute="UPDATE quest_globals set value='$timenow' where name ='shifter';"`;
	sleep 180;
	$timenow++;
	if ($timenow > 24) {
		$timenow = 1;
	}
}

This eliminates the need for the time.tar.gz file, but you'll still need to follow Angelox's instructions above for starting the script as well as complete the insert steps in Angelox's post above:

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');

Also, I wasn't clear when I first set this up about adding the quest lines but Angelox helped me out on that one. From his quests, he has this spawn event for NPCs in zones he wants the time to be updated on (mostly it's on the Nexus Scion and Priest of Discord templates since they're in so many zones):

# Night and Day checker
#Angelox's 
#This script will re-sync zone time 
sub EVENT_SPAWN { 
if ($shifter==20) {quest::settime(20,0);}
elsif ($shifter==21){quest::settime(21,0);}
elsif ($shifter==22){quest::settime(22,0);}
elsif ($shifter==23){quest::settime(23,0);}
elsif ($shifter==24){quest::settime(24,0);}
elsif ($shifter==1){quest::settime(1,0);}
elsif ($shifter==2){quest::settime(2,0);}
elsif ($shifter==3){quest::settime(3,0);}
elsif ($shifter==4){quest::settime(4,0);}
elsif ($shifter==5){quest::settime(5,0);}
elsif ($shifter==6){quest::settime(6,0);}
elsif ($shifter==7){quest::settime(7,0);}
elsif ($shifter==8){quest::settime(8,0);}
elsif ($shifter==9){quest::settime(9,0);}
elsif ($shifter==10){quest::settime(10,0);}
elsif ($shifter==11){quest::settime(11,0);}
elsif ($shifter==12){quest::settime(12,0);}
elsif ($shifter==13){quest::settime(13,0);}
elsif ($shifter==14){quest::settime(14,0);}
elsif ($shifter==15){quest::settime(15,0);}
elsif ($shifter==16){quest::settime(16,0);}
elsif ($shifter==17){quest::settime(17,0);}
elsif ($shifter==18){quest::settime(18,0);}
elsif ($shifter==19){quest::settime(19,0);}
}

I had a problem comparing the diffs between quests because such a huge block was different when adding this code in, so I shortened it to the following:

sub EVENT_SPAWN { 
	if ($shifter > 0 && $shifter < 25) {quest::settime($shifter,0);}
}

Day & Night shifts add such nostalgia for me that this is one of my favorite addons for the emulator. Mahalo Angelox!