:::Today Coming With :::Remove PREMIUM Scroll::: [الأرشيف] - الموقع العربي الاول للعبة Silkroad Online

Dangers SrO

19-02-2015, 03:13 PM

http://www2.0zz0.com/2012/10/22/15/311256858.gif

http://www2.0zz0.com/2012/10/22/16/593531309.png

http://im45.gulfup.com/wsCcCQ.png

الموضوع باين من عنوانة ... اسكرول بتشيل البرميم

**************************
::::DataBease::::

RefObCommon
..............
1 70006 ITEM_MALL_PREMIUM_REMOVE ???? ???? ??? (???) xxx SN_ITEM_MALL_PREMIUM_REMOVE SN_ITEM_MALL_PREMIUM_REMOVE_TT_DESC 1 0 3 3 13 14 180000 3 0 1 1 1 255 0 1 0 0 129 0 0 0 0 0 0 0 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_mall_scroll.bsr item\etc\event_ghost_bottle.ddj xxx xxx 60003

RefObjItem
...............
60003 1 2 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1000 ????(?) 1 [USU1:SKILL_MALL_PREMIUM_REMOVE] -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 0 0 0

Refskill
...........
1 55378 1013 SKILL_MALL_PREMIUM_REMOVE ???? ???? SKILL_MALL_PREMIUM_REMOVE 0 1 1 0 0 0 0 0 1000 0 0 0 3599 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 3 0 0 255 255 0 0 0 0 0 255 255 255 255 item\etc\mall_dungeon_free_ticket_forgotten_world. ddj SN_SKILL_MALL_PKREMOVER xxx SN_SKILL_MALL_PKREMOVER_TT_DESC xxx 0 0 3 1667396966 1851946342 1685418593 3600 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

*****
addtimedjob

اولا دي بتشيل كل اللي جنب اسمك من برميم او جود بليز ا اي سكرول

if
(@JobID= '55378')
BEGIN
DECLARE @CharName16 Varchar (MAX)
Select @CharName16=CharName16 from _Char where CharID = @CharID
Begin
DELETE FROM _TimedJob WHERE Data2 between 1 AND 31104 AND CharID = @CharID
return -3
end
end

ثانيا البروسيدر دي بتشيل البرميم فقط عن طريق اضافة ID الاسكيل مقدمة من Xan (http://www.silkroad4arab.com/vb/member.php?u=122406)

IF (@Operation = 41) and (@ItemRefID = 50235)
Begin
DELETE FROM SRO_VT_SHARD.dbo._TimedJob
WHERE CharID = @CharID
--Made By #Xan
AND JobID in (9278,43653,33855)
End

او البروسيدر دي مقدمه من Hamza FiGo (http://www.silkroad4arab.com/vb/member.php?u=6993)

if(@JobID= '59704') --Remove Premium--
begin
DECLARE @CharName16 Varchar (MAX)
declare @RemovePrem1 int
declare @RemovePrem2 int
declare @RemovePrem3 int
declare @RemovePrem4 int
declare @RemovePrem5 int
declare @RemovePrem6 int
declare @RemovePrem7 int
declare @RemovePrem8 int
DECLARE @REMOVEPREM9 INT
SET @RemovePrem1 = (Select ID From _TimedJob Where CharID=@CharID and Data2=3847)
SET @RemovePrem2 = (Select ID From _TimedJob Where CharID=@CharID and Data2=3783)
SET @RemovePrem3 = (Select ID From _TimedJob Where CharID=@CharID and Data2=3769)
SET @RemovePrem4 = (Select ID From _TimedJob Where CharID=@CharID and Data2=3795)
SET @RemovePrem5 = (Select ID From _TimedJob Where CharID=@CharID and Data2=10800)
SET @RemovePrem6 = (Select ID From _TimedJob Where CharID=@CharID and Data2=224)
SET @RemovePrem7 = (Select ID From _TimedJob Where CharID=@CharID and Data2=1)
SET @RemovePrem8 = (Select ID From _TimedJob Where CharID=@CharID and Data2=2)
SET @REMOVEPREM9 = (SELECT ID FROM _TIMEDJOB WHERE CharID=@CharID AND Data2=707799600)
delete from _TimedJob WHERE ID=@RemovePrem1
delete from _TimedJob WHERE ID=@RemovePrem2
delete from _TimedJob WHERE ID=@RemovePrem3
delete from _TimedJob WHERE ID=@RemovePrem4
delete from _TimedJob WHERE ID=@RemovePrem5
delete from _TimedJob WHERE ID=@RemovePrem6
delete from _TimedJob WHERE ID=@RemovePrem7
delete from _TimedJob WHERE ID=@RemovePrem8
delete from _TimedJob WHERE ID=@REMOVEPREM9
delete from _TimedJob where CharID = @CharID and JobID = 5412
delete from _TimedJob where CharID = @CharID and JobID = 31104
end

This in
SRO_VT_SHARD
/////////////////

Client Media
********
itemdata_xxxx
....................
1 70006 ITEM_MALL_PREMIUM_REMOVE ???? ???? ??? (???) xxx SN_ITEM_MALL_PREMIUM_REMOVE SN_ITEM_MALL_PREMIUM_REMOVE_TT_DESC 1 0 3 3 13 14 180000 3 0 1 1 1 255 0 1 0 0 129 0 0 0 0 0 0 0 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_mall_scroll.bsr item\etc\event_ghost_bottle.ddj xxx xxx 1 2 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1000 ????(?) 1 [USU1:SKILL_MALL_PREMIUM_REMOVE] -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 0 0

skilldata_enc
................
1 55378 1013 SKILL_MALL_PREMIUM_REMOVE ???? ???? SKILL_MALL_PREMIUM_REMOVE 0 1 1 0 0 0 0 0 1000 0 0 0 3599 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 3 0 0 255 255 0 0 0 0 0 255 255 255 255 item\etc\mall_dungeon_free_ticket_forgotten_world. ddj SN_SKILL_MALL_PKREMOVER xxx SN_SKILL_MALL_PKREMOVER_TT_DESC xxx 0 0 3 1667396966 1851946342 1685418593 3600 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

skilleffect
...............
1 ??? ??? SKILL_MALL_PREMIUM_REMOVE 0 FALSE 0 DEFAULT none none none none none none none none 0 0,0,0,0 ONE none none none none none none none 0 1

??? ??? SKILL_MALL_PREMIUM_REMOVE ACT_S 0 FALSE none none 0 0 0 0 1 0,0 AT_LOOP MOV_NONE,0,0,0 0,0,0 false,0,0,0,0,false system\ item_returnscroll.efp none 0,0,0 none 0,0,0 none 0 none none none

9taU-wC3RR4

™Dev Microsoft™

19-02-2015, 05:19 PM

Approved#

Dev. iLegend

19-02-2015, 05:33 PM

Already Exists
(http://www.silkroad4arab.com/vb/showthread.php?p=5048652)

Hamza FiGo

19-02-2015, 05:46 PM

:111 (27):

موجودة بس ناقصة الاسكرول كاملة

Dangers SrO

19-02-2015, 05:56 PM

تسلم :jumpy:

Genius Eslam Esoo

19-02-2015, 06:11 PM

موضوع اكتر من رائع تسلم :red_bandana:

Dangers SrO

19-02-2015, 06:13 PM

شكرا علي مرورك

™♥Dev Silkroad♥™

19-02-2015, 06:16 PM

Work

الله ينور تسلم ايدك
:biggrinthumb:

Dangers SrO

19-02-2015, 06:17 PM

Your Welcome :winner_third_h4h:

Mr Z!dane

19-02-2015, 06:53 PM

تمام بس ياريت اسهلك و اسهل للناس وتفاديا للمشاكل اشتغل علي
Addlogitem
مش لازم الزيادات اللي ملهاش لازمة دي

Dangers SrO

19-02-2015, 07:02 PM

انا عمل كدا علشان تشيل ال PREMIUM only

:sweatdrop:

NewGM

20-02-2015, 12:21 AM

بجد برنس
وان شاء الله تفيد الناس وتكون مشرف متميز
فى تقدم ان شاء الله

™MaR™

20-02-2015, 01:53 AM

تمام تسلم لابجد الموضوع مفيد

Hamza FiGo

20-02-2015, 03:21 AM

انا عمل كدا علشان تشيل ال PREMIUM only

:sweatdrop:

زيدان قصدة بدل ما تشتغل علي addtimedjob اشتغل علي Addlogitem

peter.victor

20-02-2015, 12:00 PM

تسلم على الشغل الرائع

Dangers SrO

20-02-2015, 02:25 PM

احنا تحت امرك

.a7la-smile.

20-02-2015, 02:27 PM

الله عليك .

Jaffa

05-03-2015, 04:55 AM

refobjitem بايظظظظظظظظظظظظظظظظظظ

Hamza FiGo

05-03-2015, 11:34 AM

refobjitem بايظظظظظظظظظظظظظظظظظظ

تم التعديل

mando78

17-04-2015, 01:01 AM

انا عملتها وحطتها في السيرفر بس اجبها بقة ازاي عشان اجربها اكتب ايه في الكونسول

Frankobek

27-06-2015, 02:54 AM

جميل تسلم ايديك بس عندي مشكلة مش عارف احطها فين في skill effect
:blowup::blowup:

Xan

17-12-2015, 07:30 PM

IF (@Operation = 41) and (@ItemRefID = 50235)
Begin
DELETE FROM SRO_VT_SHARD.dbo._TimedJob
WHERE CharID = @CharID
--Made By #Xan
AND JobID in (9278,43653,33855)
End

البروسدر ده بيخصص أكتر

أي خدعه اعم :wave:

eslamsaied

30-12-2017, 10:27 AM

لو سمحت اضيف اسطر الSkill effect فين بالضبط في الملفSkillEffect.txt