|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Quests::need work This is where quests that are outdated or still need work |
12-13-2011, 12:07 AM
|
|
Demi-God
|
|
Join Date: Nov 2007
Posts: 2,175
|
|
Task: Desert Crawl
I would bored and decided I would run through some of the task system. I took my level 22 Necro to NRO and Oasis and ran around killing snakes, spiders, etc. I finally got my last piece, in my inventory it showed as this item #13262 If you look at this screenshot it was definitely in my inventory. I checked the activities table and really did not see any issue with the entry. Tried logging, but nothing.
|
|
|
|
12-13-2011, 05:16 AM
|
|
Developer
|
|
Join Date: Aug 2006
Location: USA
Posts: 5,946
|
|
If you are playing on your own server, you can figure out that issue fairly easily. It could be a typo in the task with a wrong ID, but it could also just be that there are multiple item IDs for the item with that same name. Like in cases of Bone Chips, where there might be 10 different versions of the same item, but only 1 item id might work in a particular task. You could check your task tables and check which item ID is there. If there are multiple of the same item with different IDs, you can always set a goal list for that step and include all item IDs you would want to update the task. Otherwise, if it is just the wrong id, you can correct that easy enough.
If you do find that there is an issue and correct it, you can submit your fix in quest submissions or post about it on the PEQ forums for them to resolve it there (they would be doing it either way).
Doing a search on 13th floor where PEQ gets their items from, it only shows 1 result for that item name and it matches the item you got (13262).
http://eqitems.13th-floor.org/item.php?id=13262
So, most likely, the task just needs to have that one field updated to the correct item id.
|
|
|
|
12-13-2011, 09:05 AM
|
|
Demi-God
|
|
Join Date: Nov 2007
Posts: 2,175
|
|
This is on my agenda tonight, doing the entire thing via admin. Then I will post what the error is.
|
12-13-2011, 10:05 AM
|
Developer
|
|
Join Date: Feb 2004
Location: UK
Posts: 1,540
|
|
Did you definitely loot the Giant Scarab Egg Sack in North Ro (the activity has a constraint that it must be looted in that zone, as you can see in the Task Window in your screenshot) ?
I had a look at the database rows for that task and they look correct.
|
12-13-2011, 10:28 AM
|
|
Demi-God
|
|
Join Date: Nov 2007
Posts: 2,175
|
|
I looked at the rows too and they looked correct. I had migrated to Oasis because after an hour I had zero drops of those off of Scarabs. The drop rate was higher in Oasis. This has to be what is going on, I probably looted that one in Oasis. It totally makes sense now.
|
12-13-2011, 02:02 PM
|
Hill Giant
|
|
Join Date: Sep 2006
Posts: 112
|
|
Egg Sacks
You say that you cannot get these to drop... Well when I was testing this script out on MY server, I noticed that there are TWO North Ro's... One with a short name of nro and the other northro ... You may want to try the other one if you haven't already. It was the only way I could get them to drop for me... I think mine was nro or something... can't recall, this was MONTHS ago.
|
12-13-2011, 02:27 PM
|
|
Demi-God
|
|
Join Date: Nov 2007
Posts: 2,175
|
|
Well the zones were revamped, not sure if that has anything to do with it. I probably need to fix my zone points since I have upgraded my database.
|
12-13-2011, 05:23 PM
|
Fire Beetle
|
|
Join Date: May 2011
Posts: 8
|
|
The zones having been revamped might just factor into it since they have different zone IDs, 'nro' is the pre-revamp zone and if that's the one your server is running then you'll most likely need that id.
|
12-14-2011, 12:06 AM
|
|
Demi-God
|
|
Join Date: Nov 2007
Posts: 2,175
|
|
Still killing and trying to get it to drop, I am in NRO doing it now though The drop rate is low, so that is okay.
But just in case anyone needs to know how to do this. To get the zone point fixed for UF clients to zone into the new North Ro, and also other revamped zones.
Code:
update zone_points set client_version_mask = 4294967292 where client_version_mask = 2147483660;
update doors set client_Version_mask = 4294967292 where client_version_mask = 2147483660;
|
12-14-2011, 12:29 AM
|
Discordant
|
|
Join Date: Dec 2005
Posts: 435
|
|
Thanks for posting that provocating, the experienced people all know what their doing but those figuring it out for the first time run into small things like this.
I've been trolling the boards the last few days searching for any sql people have posted and compiling a list for myself with keywords.
I know I hate when someone asks "How do I fix 'X'." and I saw the fix previously but can't remember which post or where on the wiki it is.
|
12-14-2011, 03:17 AM
|
|
The PEQ Dude
|
|
Join Date: Apr 2003
Location: -
Posts: 1,988
|
|
If you are using the PEQ database, most of the revamped zones have not been worked with and thus are not playable (at least by PEQ's standards.) Nektulos and highpasshold are the only ones that are playable that use the client_version_mask column and it is already properly set.
I've also put Giant Scarab Egg Sack in their own lootdrop table for the nro scarabs thus increasing their drop rate. That'll be in the next SVN update for the database.
Last edited by cavedude; 12-14-2011 at 03:27 AM..
|
12-14-2011, 09:22 AM
|
|
Demi-God
|
|
Join Date: Nov 2007
Posts: 2,175
|
|
Yeah I know things like Freeport are not ready yet, may never be since a lot of peeps do not like the new Freeport. NorthRo is pretty complete though right ? The adventure camp and all of that seems pretty okay.
|
12-14-2011, 11:11 AM
|
|
The PEQ Dude
|
|
Join Date: Apr 2003
Location: -
Posts: 1,988
|
|
nro is fine, but the new northro has no factions, loot, named spawns, quests, etc other than whatever was grabbed from packet dumps.
My current project in fact is working on the overhauled zones. robregen sent me his database with a lot of work done on overhauled zones, so I am working with that to merge and tweak what's in the PEQ database.
|
12-14-2011, 11:17 AM
|
|
Demi-God
|
|
Join Date: Nov 2007
Posts: 2,175
|
|
Well Cavedude, you will never know how glad the community is that you are in fact back, working consistently. I wish I had the skills to help more than I do. I barely know c++ and know just enough Perl to be dangerous.
I was thinking since I know some C# I might be able to pump out a tool for admins, like what George did, but with a slight spin on it. I have been working with WPF, C# so maybe this could be something I could work on.
Anyway, I appreciate everything you and the team over at PEQ do for this community. Without the database and tweaking that is done, we would not be where we are today.
|
12-14-2011, 08:12 PM
|
|
Developer
|
|
Join Date: Aug 2006
Location: USA
Posts: 5,946
|
|
BTW, if the task originally posted about is zone specific like Derision mentioned, it won't work in both versions of North Ro. It will only work in the one it was created for. So, the loot drops you get from them need to be for the right zone (can't mix and match). There would need to be a separate task (exact copy other than the zone ID) for each zone if that is the case.
|
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 07:22 PM.
|
|
|
|
|
|
|
|
|
|
|
|
|