ط§ظ„ط¨ظ‚ط§ط، ظ…ط³ط¬ظ„ ط¯ط§ط¦ظ…ط¢
ط§ظ„ط¥ط¹ظ„ط§ظ†ط§طھ
قديم 15-03-2019, 11:08 PM   #16

Mazika Yasser
عضو فعال



الصورة الرمزية Mazika Yasser


• الانـتـسـاب » Mar 2016
• رقـم العـضـويـة » 129351
• المشـــاركـات » 393
• الـدولـة » الجيزة
• الـهـوايـة » Designer and editor
• اسـم الـسـيـرفـر » Private Server
• الـجـنـس » Male
• نقـاط التقييم » 10
Mazika Yasser صـاعـد

Mazika Yasser غير متواجد حالياً



افتراضي رد: عندي مشكلة في التايتل ؟؟



اقتباس:
المشاركة الأصلية كتبت بواسطة BeboSilkroad عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]
ضيف دا بدل اللي عندك

كود:
USE [SRO_VT_SHARDLOG_AMK]
GO
/****** Object:  StoredProcedure [dbo].[_AddLogChar]    Script Date: 3/13/2019 10:27:52 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO


ALTER   procedure [dbo].[_AddLogChar] 
@CharID		int,
@EventID		tinyint,
@Data1		int,
@Data2		int,
@strPos		varchar(64),
@Desc		varchar(128)
as 

if( @EventID=4 or @EventID=6  or @EventID=9 )
BEGIN
	declare @len_pos 	int
	declare @len_desc	int
	set @len_pos = len(@strPos)
	set @len_desc = len(@Desc)
	if (@len_pos > 0 and @len_desc > 0)
	begin	
		insert _LogEventChar values(@CharID, GetDate(), @EventID, @Data1, @Data2, @strPos, @Desc)	
	end
	else if (@len_pos > 0 and @len_desc = 0)
	begin 	
		insert _LogEventChar (CharID, EventTime, EventID, Data1, Data2, EventPos) values(@CharID, GetDate(), @EventID, @Data1, @Data2, @strPos)
	end
	else if (@len_pos = 0 and @len_desc > 0)
	begin 	
		insert _LogEventChar (CharID, EventTime, EventID, Data1, Data2, strDesc) values(@CharID, GetDate(), @EventID, @Data1, @Data2, @Desc)
	end
	else
	begin
		insert _LogEventChar (CharID, EventTime, EventID, Data1, Data2) values(@CharID, GetDate(), @EventID, @Data1, @Data2)
	end
--DELETE  TOP (3) FROM _LogEventChar WHERE EventTime < DATEADD(week, -2, GETDATE())
END
/*
--Auto Uniques Titles System
Declare @Mobname Varchar(128)
Declare @Charname varchar (30)
Declare @Amount tinyint -- 255 kills max
IF (@EventID between 9 and 11) -- lol 
Begin
Update SRO_VT_SHARD_AMK.dbo._Char Set HwanLevel = '4' where (HwanLevel between '106' AND '112') AND (HwanLevel not between '115' and '120')

Set @Charname = (select top 1 CharName from SRO_VT_ACCOUNT_AMK.dbo.srZor_uniques Where mobname like 'MOB_CH_TIGERWOMAN' order by time desc)

Update SRO_VT_SHARD_AMK.dbo._Char Set HwanLevel='106' where (CharName16 = @Charname AND HwanLevel <= '113') OR (NickName16 = @Charname AND HwanLevel <= '113')   --AND MaxLevel between 1 AND 130

Set @Charname =(Select top 1 CharName from SRO_VT_ACCOUNT_AMK.dbo.srZor_uniques Where mobname like 'MOB_OA_URUCHI' order by time desc) 

Update SRO_VT_SHARD_AMK.dbo._Char Set HwanLevel='109' where (CharName16 = @Charname AND HwanLevel <= '114') OR (NickName16 = @Charname AND HwanLevel <= '114')   --AND MaxLevel between 1 AND 130

Set @Charname =(Select top 1 CharName from SRO_VT_ACCOUNT_AMK.dbo.srZor_uniques Where mobname like 'MOB_KK_ISYUTARU' order by time desc) 

Update SRO_VT_SHARD_AMK.dbo._Char Set HwanLevel='110' where (CharName16 = @Charname AND HwanLevel <= '115') OR (NickName16 = @Charname AND HwanLevel <= '115')   --AND MaxLevel between 1 AND 130

Set @Charname =(Select top 1 CharName from SRO_VT_ACCOUNT_AMK.dbo.srZor_uniques Where mobname like 'MOB_TK_BONELORD' order by time desc) 

Update SRO_VT_SHARD_AMK.dbo._Char Set HwanLevel='111' where (CharName16 = @Charname AND HwanLevel <= '116') OR (NickName16 = @Charname AND HwanLevel <= '116')  

Set @Charname =(Select top 1 CharName from SRO_VT_ACCOUNT_AMK.dbo.srZor_uniques Where mobname like 'MOB_RM_TAHOMET' order by time desc) 
 
Update SRO_VT_SHARD_AMK.dbo._Char Set HwanLevel='112' where (CharName16 = @Charname AND HwanLevel <= '117') OR (NickName16 = @Charname AND HwanLevel <= '117')  
 
Set @Charname =(Select top 1 CharName from SRO_VT_ACCOUNT_AMK.dbo.srZor_uniques Where mobname like 'MOB_EU_KERBEROS' order by time desc) 
 
Update SRO_VT_SHARD_AMK.dbo._Char Set HwanLevel='107' where (CharName16 = @Charname AND HwanLevel <= '118') OR (NickName16 = @Charname AND HwanLevel <= '118')  --AND MaxLevel between 1 AND 130
 
Set @Charname =(Select top 1 CharName from SRO_VT_ACCOUNT_AMK.dbo.srZor_uniques Where mobname like 'MOB_AM_IVY' order by time desc)

Update SRO_VT_SHARD_AMK.dbo._Char Set HwanLevel='108' where CharName16 = @Charname AND HwanLevel <= '119' OR (NickName16 = @Charname AND HwanLevel <= '119')

Set @Charname =(Select top 1 CharName from SRO_VT_ACCOUNT_AMK.dbo.srZor_uniques Where mobname like 'MOB_RM_ROC' order by time desc)

Update SRO_VT_SHARD_AMK.dbo._Char Set HwanLevel='129' where CharName16 = @Charname AND HwanLevel <= '115' OR (NickName16 = @Charname AND HwanLevel <= '115')

Update SRO_VT_SHARD_AMK.dbo._Char Set HwanLevel='113' where (CharName16 = @Charname AND HwanLevel <= '113') OR (NickName16 = @Charname AND HwanLevel <= '113')   --AND MaxLevel between 1 AND 130

Set @Charname = (select top 1 CharName from SRO_VT_ACCOUNT_AMK.dbo.srZor_uniques Where mobname like 'MOB_FW_BIGSPIDER_105' order by time desc)

Update SRO_VT_SHARD_AMK.dbo._Char Set HwanLevel='117' where (CharName16 = @Charname AND HwanLevel <= '113') OR (NickName16 = @Charname AND HwanLevel <= '113')   --AND MaxLevel between 1 AND 130

Set @Charname = (select top 1 CharName from SRO_VT_ACCOUNT_AMK.dbo.srZor_uniques Where mobname like 'MOB_FW_DARKEAGLE_105' order by time desc)

Update SRO_VT_SHARD_AMK.dbo._Char Set HwanLevel='115' where (CharName16 = @Charname AND HwanLevel <= '113') OR (NickName16 = @Charname AND HwanLevel <= '113')   --AND MaxLevel between 1 AND 130

Set @Charname = (select top 1 CharName from SRO_VT_ACCOUNT_AMK.dbo.srZor_uniques Where mobname like 'MOB_FW_WHITETIGER_105' order by time desc)

Update SRO_VT_SHARD_AMK.dbo._Char Set HwanLevel='116' where (CharName16 = @Charname AND HwanLevel <= '113') OR (NickName16 = @Charname AND HwanLevel <= '113')   --AND MaxLevel between 1 AND 130

Set @Charname = (select top 1 CharName from SRO_VT_ACCOUNT_AMK.dbo.srZor_uniques Where mobname like 'MOB_FW_MUJIGI_105' order by time desc)

Update SRO_VT_SHARD_AMK.dbo._Char Set HwanLevel='118' where (CharName16 = @Charname AND HwanLevel <= '113') OR (NickName16 = @Charname AND HwanLevel <= '113')   --AND MaxLevel between 1 AND 130

Set @Charname = (select top 1 CharName from SRO_VT_ACCOUNT_AMK.dbo.srZor_uniques Where mobname like 'MOB_FW_KYKLOPES_105' order by time desc)

Update SRO_VT_SHARD_AMK.dbo._Char Set HwanLevel='122' where (CharName16 = @Charname AND HwanLevel <= '113') OR (NickName16 = @Charname AND HwanLevel <= '113')   --AND MaxLevel between 1 AND 130

End*//*
IF (@EventID = '20') -- Record GM Death
BEGIN 
			
	IF (@Desc LIKE '%My: no job, Neutral%') 
	BEGIN
		Declare @Killer1 Varchar(64),
				@Killer2 Varchar(64),
				@UserID int
		Set @Killer1 =  SUBSTRING(@Desc, CHARINDEX('His(', @Desc), 
						CHARINDEX('): no job,', @Desc) - CHARINDEX('His(', @Desc) + LEN('): no job,'))

		Set @killer2 = REPLACE(@Killer1,'His(','');
		Set @killer2 = REPLACE(@Killer2,'): no job,','');
		
		SET @UserID = (select UserJID from SRO_VT_SHARD_AMK.dbo._User where CharID = (SELECT CharID FROM SRO_VT_SHARD_AMK.dbo._Char where CharID = @CharID))
		Declare @CharNa Varchar(64) = ( Select CharName16 From SRO_VT_SHARD_AMK.dbo._Char Where CharID = @CharID )
		Declare @ifGMDie int = ( Select sec_content From SRO_VT_ACCOUNT_AMK.dbo.TB_User where JID = @UserID )
		if (@ifGMDie = 156 AND @CharNa ='Big')
		BEGIN

			INSERT into [G_Events].[dbo].[_NoticeQueue] (Service,Message,Date)
			Values (0,@killer2 + ' Win The Gm Killer Event',GETDATE())
			exec G_Events.dbo._GiveSilk @killer2,10,'GMKiller'
		END
		ELSE IF EXISTS (Select CharName From [G_Events].[dbo].[_LMS_Players] Where CharName Like @CharNa  )
		BEGIN
						IF EXISTS (Select CharName From [G_Events].[dbo].[_LMS_Players] Where CharName Like @killer2  )
						BEGIN
						EXEC G_Events..LMSCheck_PDead @killer2,@CharNa
						END
		END
		ELSE
		BEGIN
		EXEC [G_Events].[dbo].[KillFetch] @CharID,@Desc,@strPos
		END
   END
   	IF (@Desc LIKE '%My: no job, Murderer%') 
	BEGIN
			Declare @Killer1Q Varchar(64),
					@Killer2Q Varchar(64),
					@UserIDQ int,
					@MurName Varchar(64)
		Set @MurName = (Select CharName16 From SRO_VT_SHARD_AMK.._Char Where CharID = @CharID )
		Set @Killer1Q =  SUBSTRING(@Desc, CHARINDEX('His(', @Desc), 
						CHARINDEX('): no job,', @Desc) - CHARINDEX('His(', @Desc) + LEN('): no job,'))

		Set @killer2Q = REPLACE(@Killer1Q,'His(','');
		Set @killer2Q = REPLACE(@Killer2Q,'): no job,','');

		if (@Killer2Q = '[My: no j' AND @MurName IN ( Select PlayerName From G_Events.._MW_PlayerName ))
		BEGIN
			INSERT into [G_Events].[dbo].[_NoticeQueue] (Service,Message,Date)
			Values (0,'[Most Wanted Event] ' + @MurName + ' Dead From Murder Status Lol, Event Finished',GETDATE())*/
تم الحل بفضلك شكرا جزيلا #يغلق


توقيع Mazika Yasser :

عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]


رد مع اقتباس
إعلانات google

إضافة رد


يتصفح الموضوع حالياً : 1 (0 عضو و 1 زائر)
 

ضوابط المشاركة
لا تستطيع إضافة مواضيع جديدة
لا تستطيع الرد على المواضيع
لا تستطيع إرفاق ملفات
لا تستطيع تعديل مشاركاتك

BB code متاحة
كود [IMG] متاحة
كود HTML معطلة

الانتقال السريع

المواضيع المتشابهه
الموضوع كاتب الموضوع المنتدى الردود آخر مشاركة
بعد اذنكم عاوز حل لمشكلة اسم الشخصية موباين الى باين التايتل نيم بس a.bogy قسم الاسئلة و الاستفسارات لعمل السيرفرات الخاصة 2 25-06-2022 07:18 AM
استفساؤ بخصوص لون التايتل ولون اسم الشخصية ™_ramez_™ الأسئلة و الاستفسارات الخاصة بالـ PK2 edit 7 27-12-2017 12:27 PM
استفساؤ بخصوص لون التايتل ولون اسم الشخصية ™_ramez_™ قسم المواضيع المكررة و المخالفة 1 22-12-2017 06:54 PM
استفساؤ بخصوص لون التايتل ولون اسم الشخصية ™_ramez_™ قسم الاسئلة و الاستفسارات لعمل السيرفرات الخاصة 2 21-12-2017 10:56 AM
استفسار بخصوص لون التايتل ولون اسم الشخصية ™_ramez_™ قسم الاسئلة و الاستفسارات لعمل السيرفرات الخاصة 3 20-12-2017 02:09 AM


الساعة الآن 10:04 PM.