auto pm

[merazz012]

عملت كل حاجه تمام عندي بس الpm بتيجي في tables بس انما في الجيم مفيش حاجه بتيجي للplayers

http://i.epvpimg.com/S15Be.jpg

المشكله دي من البرنامج ولا من ايه ودا الكويري اللي اشتغلت بيه

IF (@Operation = 41 AND @ItemRefID = 67138) ------ 100 Silk Scroll
BEGIN
DECLARE @JID int,
@Silk int;

SET @Silk = 100
SELECT @JID = UserJID from SRO_VT_SHARD.._User where CharID = @CharID

IF EXISTS (Select * from SRO_VT_ACCOUNT..SK_Silk where JID = @JID)
UPDATE SRO_VT_ACCOUNT..SK_Silk set silk_own = silk_own + @Silk where JID = @JID
ELSE
INSERT INTO SRO_VT_ACCOUNT..SK_Silk
SELECT @JID, @Silk, 0, 0
insert into iLegend_Tool.._SendPrivateChat ([Service],[Target],[Chat],[Date])
values (0,@lkcharname,'Congratulations You Got 100 Silk',getdate())
END

و دا الموضوع اللي استخدمت منه البرنامج
http://www.silkroad4arab.com/vb/showthread.php?t=588584
ياربت لو حد يعرف المشكله من ايه يقولي !!

[merazz012]

up

[Dev. iLegend]

Use this query
IF (@Operation = 41 AND @ItemRefID = 67138) ------ 100 Silk Scroll
Begin
Declare @JID Int, @Silk Int , @CharName Varchar(60)
Set @Silk = 100
Set @CharName = (Select CharName16 From [SRO_VT_SHARD].[dbo].[_Char] Where CharID = @CharID)
Set @JID = (Select UserJID From [SRO_VT_SHARD].[dbo].[_User] Where CharID = @CharID)

IF Exists (Select * From [SRO_VT_ACCOUNT].[dbo].[SK_Silk] Where JID = @JID)
Begin
Update [SRO_VT_ACCOUNT].[dbo].[SK_Silk] Set silk_own = silk_own + @Silk Where JID = @JID
End Else Begin
Insert Into [SRO_VT_ACCOUNT].[dbo].[SK_Silk] Values (@JID, @Silk, 0, 0)
Insert Into [iLegend_Tool].[dbo].[_SendPrivateChat] Values (1,@CharName,'Congratulations You Got 100 Silk',Getdate())
End End

[Dev. iLegend]

وتقدر تقرا حضرتك الكيوري دي وتشوف ازاي بتضيف فى الجدول ،، لازم Service = 1 مش 0
http://www5.0zz0.com/2015/04/03/03/107101660.png
Send Private Chat
http://www5.0zz0.com/2015/04/03/03/107101660.png
بعد ما تعلم عليها بتعمل insert فى الجدول ده dbo._SendPrivateChat بالكيوري دي عشان يبعت برايفت شات لحد فى الجيم ،،

Use [iLegend_Tool]
Insert Into _SendPrivateChat Values (1,'target character name','write here your chat',Getdate())

[merazz012]

دا معاك لو مش هتعبك :D

if(@Operation = 90 )

begin
---- Plus Global
if(CAST(@strDesc_separado AS NVARCHAR) > 7 )
begin
declare @iname varchar(129)
declare @iid int
declare @cnameQ varchar(64)
Declare @RealName Varchar(Max)
select @iid = RefItemID from SRO_VT_SHARD.dbo._Items where Serial64 = @ItemSerial
select @iname = CodeName128 from SRO_VT_SHARD.dbo._RefObjCommon where id = @iid
Select @RealName = RealName From SRO_VT_SHARDLOG.dbo._itemsName Where CodeName = @iname
select @cnameQ = CharName16 from SRO_VT_SHARD.dbo._Char where CharID = @CharID
insert into iLegend_Tool.._SendGlobalChat(Service,Chat)values( 0,@cnameQ + ' has increased ' + @RealName + ' plus To + ' + CAST(@strDesc_separado AS NVARCHAR) )
end
end

[Dev. iLegend]

Replace inserting line in your query with this line
insert into iLegend_Tool.._SendGlobalChat values (1,@cnameQ + ' has increased ' + @RealName + ' plus To + ' + CAST(@strDesc_separado AS NVARCHAR),Getdate())

[Dev. iLegend]

بس من الأفضل انك عشان تعمل الموضوع دا لازم تزود Max stack الجلوبال لـ 10000 عشان لما بيستخدم جلوبال بالبرنامج لازم تحددله Slot

[merazz012]

تمام و عملت الmax-stack 20000 شكرا يا رامي :*