19-02-2015, 03:13 PM
|
#1
|
|
|
• الانـتـسـاب » Jan 2014
|
|
• رقـم العـضـويـة » 116041
|
|
• المشـــاركـات » 2,589
|
|
• الـدولـة » Gizaaa
|
|
• الـهـوايـة » SilkRoad4Arab Only One <3
|
|
• اسـم الـسـيـرفـر » Private Server
|
|
• الـجـنـس » Male
|
|
• نقـاط التقييم » 26
|
|
|
|
.gif)
:::Today Coming With :::Remove PREMIUM Scroll:::
الموضوع باين من عنوانة ... اسكرول بتشيل البرميم
**************************
::::DataBease::::
RefObCommon
..............
كود PHP:
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
...............
كود PHP:
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
...........
كود PHP:
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
اولا دي بتشيل كل اللي جنب اسمك من برميم او جود بليز ا اي سكرول
كود PHP:
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 الاسكيل مقدمة من عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]
كود:
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
او البروسيدر دي مقدمه من عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]
كود:
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
....................
كود PHP:
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
................
كود PHP:
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
...............
كود PHP:
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
[YOUTUBE]9taU-wC3RR4[/YOUTUBE]
|
|
|
التعديل الأخير تم بواسطة Hamza FiGo ; 17-12-2015 الساعة 01:36 PM
السبب: اضافت video
|