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

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

11-14-2007, 03:02 AM
|
 |
The PEQ Dude
|
|
Join Date: Apr 2003
Location: -
Posts: 1,988
|
|
I've been lazy, I'll get to updating it today.
|

11-14-2007, 03:22 AM
|
 |
The PEQ Dude
|
|
Join Date: Apr 2003
Location: -
Posts: 1,988
|
|
Oh, I also forgot to mention the release includes the newest 13th floor item database, as well as the village of Gukta in Rathe Mountains fully working.
CVS is updating now, give it some time before grabbing it.
|
Thread Tools |
|
Display Modes |
Hybrid Mode
|
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 11:20 PM.
|
|
 |
|
 |
|
|
|
 |
|
 |
|
 |