Quest Development

[Squiffy]

Very nice work! Have yet to test it out, but even if it's buggy as hell, that's still a damned daunting task to undertake

Nice job

[mollymillions]

Just thought i would post a couple of snippets that may or may not be useful examples (please correct me if any are bad examples).

Random handout and say

quest::summonitem("int(rand(7))+5019");

my @items = (5303,5304,5305,5313,6303,6311,6312,7300,7301,7311,7499);
quest::summonitem("$items[int(rand($#items+1))]");

sub EVENT_TIMER {
my $random = int(rand(4));	
if($random == 0){
	quest::say("Outta my way, ya big lummox!"); }
if($random == 1){
	quest::say("Time to drain the [dragon]..  If ya know what I mean..  Bwah ha ha ha."); }
if($random == 2){
	quest::say("You know you love me."); }
if($random == 3){
	quest::say("Hey Fishboy! You dropped something! Bwah ha ha ha!"); }	
}

Sometimes its required that an NPC moves away from another one, usually to allow one of them to be killed. You can't make an NPC walk or run to a particular location, as far as i know, so as a work around you can get the NPC to follow the PC for a short period -but If the NPC is not killed there is no easy way to return it to its spawn location.

sub EVENT_SAY { 
if($text=~/come/i){ 
	quest::follow($userid);
	quest::settimer(1,30); }
}
sub EVENT_TIMER {
quest::stoptimer(1);
quest::sfollow();
}

Recently i have found this query usefull for checking tradeskills

SELECT items.name product, skillneeded, i1.name i1
, i2.name i2, i3.name i3, i4.name i4, i5.name i5
, i6.name i6, i7.name i7, i8.name i8, i9.name i9
, i10.name i10, tradeskillrecipe.*
FROM tradeskillrecipe, items
LEFT JOIN items i1 ON tradeskillrecipe.i1 = i1.id
LEFT JOIN  items i2 ON tradeskillrecipe.i2 = i2.id
LEFT JOIN  items i3 ON tradeskillrecipe.i3 = i3.id
LEFT JOIN  items i4 ON tradeskillrecipe.i4 = i4.id
LEFT JOIN  items i5 ON tradeskillrecipe.i5 = i5.id
LEFT JOIN  items i6 ON tradeskillrecipe.i6 = i6.id
LEFT JOIN  items i7 ON tradeskillrecipe.i7 = i7.id
LEFT JOIN  items i8 ON tradeskillrecipe.i8 = i8.id
LEFT JOIN  items i9 ON tradeskillrecipe.i9 = i9.id
LEFT JOIN  items i10 ON tradeskillrecipe.i10 = i10.id
WHERE tradeskillrecipe.product = items.id
ORDER BY items.name

NPC's and loot:

select npc_types.id, left(npc_types.name,32), spawn2.zone, lootdrop_entries.item_id, items.name
from npc_types, spawnentry, spawn2
left join loottable_entries on npc_types.loottable_id = loottable_entries.loottable_id
left join lootdrop_entries on loottable_entries.lootdrop_id = lootdrop_entries.lootdrop_id
left join items on lootdrop_entries.item_id = items.id
where npc_types.id = spawnentry.npcid
and spawnentry.spawngroupid = spawn2.spawngroupid
and npc_types.name like '%Slixin_Klex%'
order by npc_types.name

[diolas]

I'm still having problems connecting to the ftp server.

The site name I'm using is:
ftp://ftp.phatcontroller.org/perl_quests.zip

login name:
anonymous@phatcontroller.org

also, I'm using WS_FTP LE

Specifically, I can't connect to the site.

Error message reads as follows:
! Can't Get "ftp://ftp.phatcontroller.org/perl_quests.zip" host entry
! Connection failed ftp://ftp.phatcontroller.org/perl_quests.zip

I've tried omitting the Perl_quests.zip as part of the ftp name, same problem.

Any help would be appreciated greatly.

[masticism]

anyone having connections problems, try this link instead


ftp://anonymous%40phatcontroller.org...ontroller.org/


Just enter an empty password.

(Tested with Mozilla 1.6, Netscape 7.1) and IE (Thanks for pointing this out diolas)

[diolas]

Thanks Masty, that one worked quit easily through explorer.

[mollymillions]

Originally Posted by diolas

The site name I'm using is:
ftp://ftp.phatcontroller.org/perl_quests.zip

The FTP site name is phatcontroller.org (I should have posted the site name and file name seperately).

[MacLeod]

Is the FTP read only now? I can't upload files.

Been real busy but caught a few syntax errors in a couple files.

[mollymillions]

Thanks for picking that up McLeod. The access rights definately were screwed up.

[Rolenar]

Hmm, I can't seem to long on, (after a number of attempts), I am using the recomended user name, but it keeps giving this error:

USER anonymous@phatcontroller.org
331 Password required for anonymous@phatcontroller.org.
PASS (hidden)
530 Login incorrect.

I am unsure why, and WS_FTP will not allow blank password
Any tips/ideas would be appriciated

[ryder911]

I tried using IE and i get Page cannot be displayed any reason why? or anyone no a way i can fix this? Thanks any help is appreciated. Please no flaming i no im a noob ;P

[Rolenar]

IE won't be able to access the site, you must download an ftp client, there are a number of free (well, trial based) clients out there, including the chocie of mollymillions, WS_FTP

[mollymillions]

I cancelled the site yesterday, it wasn't required anymore. There hasnt' been any submissions from users for long time (about a month and a half or so).

[shocker1322]

Hey, I am new to EQEmu. I have spent the last 3 days reading as many forums as I can to get all the server stuff working. Now that I finally got it working, I cannot find any quests. Would it be possible to get a copy of the file perl_quests.zip? I just missed the server being pulled down, and I cannot find a mirror for it anywhere. Thanks. If you need an email address, I can give that too.

[m0oni9]

I have a perl_quests.zip, last modified 1/17/04. Send me a message with email, or find me in chat as 'bleh', and I'll be happy to send it.

[Xabob]

This unsupported i would like a copy if anyone has it i know this is a very old post