AS BEGIN Declare @UserID int = (select UserJID from SRO_VT_SHARD.dbo._User where CharID = (SELECT CharID FROM SRO_VT_SHARD.dbo._Char where CharName16 = @CharName16))
IF EXISTS ( Select * From SRO_VT_ACCOUNT.dbo.SK_Silk Where JID = @UserID ) BEGIN UPDATE SRO_VT_ACCOUNT.dbo.SK_Silk set silk_own = silk_own + @silk where JID = @UserID END ELSE BEGIN INSERT SRO_VT_ACCOUNT.dbo.SK_Silk (JID,silk_own,silk_gift,silk_point) Values (@UserID,@Silk,0,0) END
END
PlusNotice Table
كود PHP:
USE [SRO_VT_SHARDLOG]GO
/****** Object: Table [dbo].[PlusNotice] Script Date: 14.06.2013 18:09:33 ******/ SET ANSI_NULLS ON GO
SET QUOTED_IDENTIFIER ON GO
SET ANSI_PADDING ON GO
CREATE TABLE [dbo].[PlusNotice]( [Sent] [int] NOT NULL, [Message] [varchar](300) NOT NULL, [Date] [datetime] NOT NULL ) ON [PRIMARY]
GO
SET ANSI_PADDING OFF GO
ALTER TABLE [dbo].[PlusNotice] ADD CONSTRAINT [DF_PlusNotice_Sent] DEFAULT ((0)) FOR [Sent] GO
ALTER TABLE [dbo].[PlusNotice] ADD CONSTRAINT [DF_PlusNotice_Date] DEFAULT (getdate()) FOR [Date]
GO
بالنسبة للي عاوز يطور في البرنامج او يتعلم منه عندك الباكت المسؤلة عن الايفنت واليوزيدج بتاعتها ودول ك اوبشن زيادة للي عاوز البرنامج يقرأ اكتر في ال Party matching
كود PHP:
byte unk1 (probably current page) byte pagesCount byte partiesCount in current page for (byte x = 0; x <= partiesCount; x++) uint matchNumber uint CharObjectID string charname byte race byte membersCount byte setting byte type byte minLevel byte maxLevel string title
Have fun
التعديل الأخير تم بواسطة ™ EgY_KhaN ™ ; 03-11-2017 الساعة 09:54 PM