EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Development::Database/World Building (https://www.eqemulator.org/forums/forumdisplay.php?f=596)
-   -   Helm of northern worlf material - no combine (https://www.eqemulator.org/forums/showthread.php?t=21829)

Rhodan 11-06-2006 06:24 AM

Helm of northern worlf material - no combine
 
This recipe in the peq database was different than what I've read on all the quest sites as well as what the quest NPC tells you - so I decided to change it.

Orignally, it needed 1 lore bone chip, 2 small ore and a gnoll pup scalp. The bone chip was wrong so I changed it to the 13073 version and set the amount to 2. I rebooted the server (dunno if thats required, just figured it couldn't hurt) then tried the recipe, which did not work. I get the message that I cannot combine these items in that container type.

I checked the database and it seems to be correct. I tried the other materials and had no trouble making those.

So anyway, I'm stumped as to why this wouldn't work. Here's the database data

tradeskill_recipe
8598, 'northern wolf helm material', 69, 0, 0, 1, 0, 'created by ylosh'

tradeskill_recipe_entries
112142, 8598, 55095, 0, 0, 0, 1
112141, 8598, 13073, 0, 0, 2, 0
112140, 8598, 10500, 0, 0, 2, 0
112139, 8598, 13789, 0, 0, 1, 0
112138, 8598, 55104, 1, 0, 0, 0

55095 is definately the northern wolf plate assembly kit given by the NPC and its marked as the container

13073 is the bonechip type that I have (not stacked)
10500 is the ore I have (not stacked)
13789 is the gnoll pup scalp.

And ideas where I'm going wrong?

MainMan 07-11-2008 01:05 AM

Hey, this is still a problem. It's still not working.

It's both the helm and the boots. Any ideas?

cavedude 07-11-2008 01:17 AM

You need to apply this patch to your code:

http://eqemulator.net/forums/showthread.php?t=25235

Or, download and use the PEQ Installer, the 1118 upgrade version contains this fix.

MainMan 07-11-2008 01:37 AM

I apologize, I wasn't specific, and this might not be the right place to comment.

I meant that this problem appears to still be occurring on The Grand Creation.

cavedude 07-11-2008 01:50 AM

No it isn't, I just did the combine fine. I'll check to make sure the recipe in the DB matches with what is on Allah.

MainMan 07-11-2008 01:54 AM

Hmm.. Here's the original from Allah:

2 Small Pieces of Ore
1 Gnoll Pup Scalp
2 Bone Chips

I'm sorry for the inconvenience, it's just frustrating; this won't work for me and I've double checked the items dozens of times.

cavedude 07-11-2008 02:48 AM

I was able to recreate the problem on TGC, but the problem is I cannot on my internal test server and they are identical. Same code, same db, same quests, even same OS and scripts.

I'll figure out what's causing TGC to flip out with these combines tomorrow.

MainMan 07-11-2008 03:31 AM

How bizarre.

Thanks again though, I really appreciate it.

trevius 07-11-2008 04:35 AM

Couldn't be that there are multiple versions of bone chips? Or, maybe the issue where you can't create a tradeskill item that has the same name as another recipe? Maybe your test server has the fix for that and PEQ doesn't?

cavedude 07-11-2008 08:33 AM

Bone chips are fine, and we're using the tradeskill patch mentioned above. TGC's source folder is identical to the one I use here as once I test here I upload to TGC, make, and deploy. I'm sure it's just a small oversight somewhere.

joligario 07-12-2008 07:43 AM

Possible Problem
 
Ok, just checked this out in our system... Taby can't combine it either. I think it has to do with the Gnoll Pup Scalp.

Could the fact that Lucy does not have it as a tradeskill item be the problem? I would think that the containers check if they are "tradeskillable" items inside.

http://lucy.allakhazam.com/item.html?id=13789

cavedude 07-12-2008 11:25 AM

No, it doesn't have to do with items, it all goes back to that patch I posted above. None of the duplicate recipes combine on TGC, but yet they all work fine on my internal test, using identical code and DB. I'm sure it's a small oversight somewhere, but I am banging my head to find it.

cavedude 07-25-2008 09:44 PM

If still interested, I finally tracked down the cause of this problem. I have no way to test the correction since I don't have a MySQL 4.0 server up, but it'll be active on PEQ with tomorrow's reboot if anybody wants to give it a try.

It came down to a query in the patch I mentioned above working in MySQL 5.0, but not 4.0 which is what TGC is running.


All times are GMT -4. The time now is 06:10 PM.

Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.