Craft Problem

[Acnathon]

Hi there! I have a little question
Maybe you can give me some tips why the Basic Craft LV9 is bugged?
I mean before they craft 1 SEH, PCH or PPCK everything is fine! but after they crafted 1 of above their craft starts to be bugged, they fail everything...
The high craft rate can causes this? or....?

Thanks in advance!

[MentaL]

[cypher]

Works for me. Don't use high rates.

[Acnathon]

Well... we just tried modifing the rates... even with 1x rate its still bugged :-( im gonna try now with a fully clean server install if it works

btw thanks cypher

BTW Checked the craft starts to be bugged when they are on LV9 100%
on 80% is ok... (with clean install)
maybe can be made a Scheduled job in SQL that cheks every minute the values in the cabal_craft_table (for this rows: Level0 and Exp0) and it resets back to LV9 0% when they relog?
I mean something like this should be ok?

USE Gamedb
UPDATE dbo.cabal_craft_table
SET Level0='9',
Exp0='36000'
WHERE Level0='9' and Exp0='45000'; 

[chumpywumpy]

I would use a trigger for that. I have barely touched basic craft as I know the rates are pitiful so it isn't really worth doing, most of the time you are crafting at a loss and I complained about this in official a lot. At some point I want to redo all of the rates to make it worthwhile doing again.

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TRIGGER dbo.craft_fix 
   ON  dbo.cabal_craft_table 
   AFTER UPDATE
AS 
BEGIN
	UPDATE dbo.cabal_craft_table
	SET Level0='9',Exp0='36000'
	WHERE Level0='9' and Exp0='45000';
END
GO

[Acnathon]

I would use a trigger for that. I have barely touched basic craft as I know the rates are pitiful so it isn't really worth doing, most of the time you are crafting at a loss and I complained about this in official a lot. At some point I want to redo all of the rates to make it worthwhile doing again.

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TRIGGER dbo.craft_fix 
   ON  dbo.cabal_craft_table 
   AFTER UPDATE
AS 
BEGIN
    UPDATE dbo.cabal_craft_table
    SET Level0='9',Exp0='36000'
    WHERE Level0='9' and Exp0='45000';
END
GO

Thank you very much it works :) 1 more thing i just observed that on lv9 craft PCH when you succeeded to create it creates PCHH :D
that can be changed on craft.scp?

Edit:

[RecipeCommonEvaluation]	RecipeID	Order	EXP	ItemIdx	ItemOption	Class1	Class1F	Class2F	Class3F	Class4F	Class5F	Class6F	Class7F	Class8F
601	121	2	45	632	0	100	100	100	100	100	100	100	100	80
602	121	3	90	632	0	100	100	100	100	100	100	100	100	100
603	121	4	135	632	0	100	100	100	100	100	100	100	100	100
604	121	5	180	632	0	100	100	100	100	100	100	100	100	100

Is that what needed to change to 1426 to get pch (not pchh?)

NVM i edited those and now works :)