Lucky Charm-Extract Hammer/EpCoin Error

02/09/2012 15:11 Foxyz#1
Ok Do u Know If it is Possible To Make a Extract Hammer Be Working With lucky Charm so the lapis dont break?
and also it cost 85 ep coin to enchant??? when ep coins dont work???
02/09/2012 16:01 [Dev]Ansem#2
Quote:
Originally Posted by Foxyz View Post
and also it cost 85 ep coin to enchant??? when ep coins dont work???
please, please rewrite your questions, "it cost 85 ep coin to enchant when ep coins dont work"
Can someone translate / explain me that one?

//That is topic number #42 for asking a little question. Seriously, use the search function and the [Only registered and activated users can see links. Click Here To Register...] << click

And I recommend you to read
this one also: [Only registered and activated users can see links. Click Here To Register...]
02/10/2012 01:35 _-Phoenix-_#3
Possible To Make a Extract Hammer Be Working With lucky Charm so the lapis dont break?

--Yes take and use Castors shstudio and edit each lapis and tell it to not break the item.

and also it cost 85 ep coin to enchant ???

ep coin???? can you explain this a little more?

and to make the ap tokens work try this as your Stored Procedure dbo.usp_Insert_Action_Log_E





/****** Object: Stored Procedure dbo.usp_Insert_Action_Log_E Script Date: 2008-6-7 18:32:40 ******/

/****** Object: Stored Procedure dbo.usp_Insert_Action_Log_E Script Date: 2008/3/15 下午 05:16:53 ******/



CREATE Proc [dbo].[usp_Insert_Action_Log_E]

/*
Created by [Only registered and activated users can see links. Click Here To Register...], 2004-08-17
Modified by [Only registered and activated users can see links. Click Here To Register...], 2004-08-19

게임내 행동 로그 남기기 */


/*

*/

@UserID varchar(18),
@UserUID int,
@CharID int,
@CharName varchar(50),
@CharLevel tinyint,
@CharExp int,
@MapID smallint,
@PosX real,
@PosY real,
@PosZ real,
@ActionTime datetime,
@ActionType tinyint,
@Value1 bigint = null,
@Value2 int = null,
@Value3 int = null,
@Value4 bigint = null,
@Value5 int = null,
@Value6 int = null,
@Value7 int = null,
@Value8 int = null,
@Value9 int = null,
@Value10 int = null,
@Text1 varchar(100) = '',
@Text2 varchar(100) = '',
@Text3 varchar(100) = '',
@Text4 varchar(100) = '',
@Sql nvarchar(4000) = '',
@yyyy varchar(4) = '',
@mm varchar(2) = '',
@dd varchar(2) = '',
@Bucket smallint = -1

AS

DECLARE @CharLeave int
SET @yyyy = datepart(yyyy, @ActionTime)


IF(LEN(@mm) = 1)
BEGIN
SET @mm = '0' + @mm
END

IF(LEN(@dd) = 1)
BEGIN
SET @dd = '0' + @dd
END

IF( @ActionType = 114 )
BEGIN
IF( @Value2 = 100216 )
BEGIN
UPDATE PS_UserData.dbo.Users_Master
SET Point = Point + ( 500 * @Value4 )
WHERE UserUID = @UserUID
END

IF( @Value2 = 44129 )
BEGIN
UPDATE ps_userdata.dbo.users_master
SET point = point + ( 1250 * @Value4 )
WHERE useruid = @UserUID
END
IF( @Value2 = 44130 )
BEGIN
UPDATE ps_userdata.dbo.users_master
SET point = point + ( 2000 * @Value4 )
WHERE useruid = @UserUID
END
IF( @Value2 = 44131 )
BEGIN
UPDATE ps_userdata.dbo.users_master
SET point = point + ( 3000 * @Value4 )
WHERE useruid = @UserUID
END
END


IF @ActionType = '116'--Trade Item-remove item from originator
BEGIN
WAITFOR DELAY '00:00:05'--Time delay to give the duper time to log out fully

SELECT @CharLeave=Leave
FROM PS_userdata.dbo.Users_Master
WHERE UserUID=@UserUID

IF @CharLeave=0
BEGIN
EXEC PS_GameData.dbo.usp_Save_Char_Item_Del_E @CharID=@CharID, @IDList=@Value1
END
END

IF @ActionType = '164'--Trade Gold-remove gold from originator
BEGIN

WAITFOR DELAY '00:00:05'--Time delay to give the duper time to log out fully

SELECT @CharLeave=Leave
FROM PS_userdata.dbo.Users_Master
WHERE UserUID=@UserUID

IF @CharLeave=0
BEGIN
UPDATE PS_GameData.dbo.Chars
SET [Money]=@Value2
WHERE PS_GameData.dbo.Chars.CharID=@CharID
END
END

SET @Sql = N'
INSERT INTO PS_GameLog.dbo.ActionLog
(UserID, UserUID, CharID, CharName, CharLevel, CharExp, MapID, PosX, PosY, PosZ, ActionTime, ActionType,
Value1, Value2, Value3, Value4, Value5, Value6, Value7, Value8, Value9, Value10, Text1, Text2, Text3, Text4)
VALUES(@UserID, @UserUID, @CharID, @CharName, @CharLevel, @CharExp, @MapID, @PosX, @PosY, @PosZ, @ActionTime, @ActionType,
@Value1, @Value2, @Value3, @Value4, @Value5, @Value6, @Value7, @Value8, @Value9, @Value10, @Text1, @Text2, @Text3, @Text4)'

EXEC sp_executesql @Sql,
N'@UserID varchar(18), @UserUID int, @CharID int, @CharName varchar(50),
@CharLevel tinyint, @CharExp int, @MapID smallint, @PosX real, @PosY real, @PosZ real, @ActionTime datetime, @ActionType tinyint,
@Value1 bigint, @Value2 int, @Value3 int, @Value4 bigint, @Value5 int, @Value6 int, @Value7 int, @Value8 int,
@Value9 int, @Value10 int, @Text1 varchar(100), @Text2 varchar(100), @Text3 varchar(100), @Text4 varchar(100)',
@UserID, @UserUID, @CharID, @CharName, @CharLevel, @CharExp, @MapID, @PosX, @PosY, @PosZ, @ActionTime, @ActionType,
@Value1, @Value2, @Value3, @Value4, @Value5, @Value6, @Value7, @Value8, @Value9, @Value10, @Text1, @Text2, @Text3, @Text4
02/10/2012 22:44 Foxyz#4
and i sell the ap coins?
02/11/2012 00:38 _-Phoenix-_#5
to make this work right for you you will have to change these in that ; 100216 ,44129 ,44130 ,44131. what your coins are and then sell them to a npc then they will have to go to their char select screen and it will work.
02/11/2012 01:42 Foxyz#6
100216 ,44129 ,44130 ,44131 i dont udnerstand...

what are those numbers for? lol
02/11/2012 02:40 RebeccaBlack#7
..They are ItemIDs. 100216 = Type 100, TypeID 216
02/11/2012 03:21 Foxyz#8
oh wow im stupid xD ty rebecca