شـريـط الاهـداءات
قسم المواضيع المكررة و المخالفة هنا يتم وضع المواضيع المخالفة والمواضيع المكررة
01-10-2013, 11:49 PM
#1
• الانـتـسـاب » Oct 2011
• رقـم العـضـويـة » 92849
• المشـــاركـات » 289
• الـدولـة » alex
• الـهـوايـة » Edite Media.pk2
• اسـم الـسـيـرفـر » Private Server
• الـجـنـس » Male
• نقـاط التقييم » 239
مطلوب شرح بتفصيل المملللل
Procedure
_TimedJob
كود PHP:
if(@ JobID = '34038' ) -- Remover Blue Avatar
begin
SELECT @ ItemID = ItemID from _Inventory where CharID = @ CharID AND Slot = '13'
SELECT @ RefItemID = RefItemID from _Items where ID64 = @ ItemID
If (@ RefItemID >= '43620' AND @ RefItemID <= '43625' )
begin
Update _Items Set MagParamNum = 0 , MagParam1 = NULL , MagParam2 = NULL , MagParam3 = NULL , MagParam4 = NULL , MagParam5 = NULL , MagParam6 = NULL , MagParam7 = NULL , MagParam8 = NULL , MagParam9 = NULL , MagParam10 = NULL , MagParam11 = NULL , MagParam12 = NULL where ID64 = @ ItemID
end
Else
If (@ RefItemID >= '22912' AND @ RefItemID <= '22923' )
begin
Update _Items Set MagParamNum = 0 , MagParam1 = NULL , MagParam2 = NULL , MagParam3 = NULL , MagParam4 = NULL , MagParam5 = NULL , MagParam6 = NULL , MagParam7 = NULL , MagParam8 = NULL , MagParam9 = NULL , MagParam10 = NULL , MagParam11 = NULL , MagParam12 = NULL where ID64 = @ ItemID
end
Else
If (@ RefItemID >= '23272' AND @ RefItemID <= '23275' )
begin
Update _Items Set MagParamNum = 0 , MagParam1 = NULL , MagParam2 = NULL , MagParam3 = NULL , MagParam4 = NULL , MagParam5 = NULL , MagParam6 = NULL , MagParam7 = NULL , MagParam8 = NULL , MagParam9 = NULL , MagParam10 = NULL , MagParam11 = NULL , MagParam12 = NULL where ID64 = @ ItemID
end
Else
If (@ RefItemID >= '23320' AND @ RefItemID <= '23321' )
begin
Update _Items Set MagParamNum = 0 , MagParam1 = NULL , MagParam2 = NULL , MagParam3 = NULL , MagParam4 = NULL , MagParam5 = NULL , MagParam6 = NULL , MagParam7 = NULL , MagParam8 = NULL , MagParam9 = NULL , MagParam10 = NULL , MagParam11 = NULL , MagParam12 = NULL where ID64 = @ ItemID
end
Else
If (@ RefItemID >= '24262' AND @ RefItemID <= '24273' )
begin
Update _Items Set MagParamNum = 0 , MagParam1 = NULL , MagParam2 = NULL , MagParam3 = NULL , MagParam4 = NULL , MagParam5 = NULL , MagParam6 = NULL , MagParam7 = NULL , MagParam8 = NULL , MagParam9 = NULL , MagParam10 = NULL , MagParam11 = NULL , MagParam12 = NULL where ID64 = @ ItemID
end
Else
If (@ RefItemID >= '24298' AND @ RefItemID <= '24317' )
begin
Update _Items Set MagParamNum = 0 , MagParam1 = NULL , MagParam2 = NULL , MagParam3 = NULL , MagParam4 = NULL , MagParam5 = NULL , MagParam6 = NULL , MagParam7 = NULL , MagParam8 = NULL , MagParam9 = NULL , MagParam10 = NULL , MagParam11 = NULL , MagParam12 = NULL where ID64 = @ ItemID
end
Else
If (@ RefItemID >= '24351' AND @ RefItemID <= '24380' )
begin
Update _Items Set MagParamNum = 0 , MagParam1 = NULL , MagParam2 = NULL , MagParam3 = NULL , MagParam4 = NULL , MagParam5 = NULL , MagParam6 = NULL , MagParam7 = NULL , MagParam8 = NULL , MagParam9 = NULL , MagParam10 = NULL , MagParam11 = NULL , MagParam12 = NULL where ID64 = @ ItemID
end
Else
If (@ RefItemID >= '24405' AND @ RefItemID <= '24412' )
begin
Update _Items Set MagParamNum = 0 , MagParam1 = NULL , MagParam2 = NULL , MagParam3 = NULL , MagParam4 = NULL , MagParam5 = NULL , MagParam6 = NULL , MagParam7 = NULL , MagParam8 = NULL , MagParam9 = NULL , MagParam10 = NULL , MagParam11 = NULL , MagParam12 = NULL where ID64 = @ ItemID
end
Else
If (@ RefItemID >= '24644' AND @ RefItemID <= '24661' )
begin
Update _Items Set MagParamNum = 0 , MagParam1 = NULL , MagParam2 = NULL , MagParam3 = NULL , MagParam4 = NULL , MagParam5 = NULL , MagParam6 = NULL , MagParam7 = NULL , MagParam8 = NULL , MagParam9 = NULL , MagParam10 = NULL , MagParam11 = NULL , MagParam12 = NULL where ID64 = @ ItemID
end
Else
If (@ RefItemID >= '25799' AND @ RefItemID <= '25822' )
begin
Update _Items Set MagParamNum = 0 , MagParam1 = NULL , MagParam2 = NULL , MagParam3 = NULL , MagParam4 = NULL , MagParam5 = NULL , MagParam6 = NULL , MagParam7 = NULL , MagParam8 = NULL , MagParam9 = NULL , MagParam10 = NULL , MagParam11 = NULL , MagParam12 = NULL where ID64 = @ ItemID
end
Else
If (@ RefItemID >= '29403' AND @ RefItemID <= '29412' )
begin
Update _Items Set MagParamNum = 0 , MagParam1 = NULL , MagParam2 = NULL , MagParam3 = NULL , MagParam4 = NULL , MagParam5 = NULL , MagParam6 = NULL , MagParam7 = NULL , MagParam8 = NULL , MagParam9 = NULL , MagParam10 = NULL , MagParam11 = NULL , MagParam12 = NULL where ID64 = @ ItemID
end
Else
If (@ RefItemID >= '33814' AND @ RefItemID <= '33837' )
begin
Update _Items Set MagParamNum = 0 , MagParam1 = NULL , MagParam2 = NULL , MagParam3 = NULL , MagParam4 = NULL , MagParam5 = NULL , MagParam6 = NULL , MagParam7 = NULL , MagParam8 = NULL , MagParam9 = NULL , MagParam10 = NULL , MagParam11 = NULL , MagParam12 = NULL where ID64 = @ ItemID
end
Else
If (@ RefItemID >= '35578' AND @ RefItemID <= '35581' )
begin
Update _Items Set MagParamNum = 0 , MagParam1 = NULL , MagParam2 = NULL , MagParam3 = NULL , MagParam4 = NULL , MagParam5 = NULL , MagParam6 = NULL , MagParam7 = NULL , MagParam8 = NULL , MagParam9 = NULL , MagParam10 = NULL , MagParam11 = NULL , MagParam12 = NULL where ID64 = @ ItemID
end
Else
If (@ RefItemID >= '35586' AND @ RefItemID <= '35591' )
begin
Update _Items Set MagParamNum = 0 , MagParam1 = NULL , MagParam2 = NULL , MagParam3 = NULL , MagParam4 = NULL , MagParam5 = NULL , MagParam6 = NULL , MagParam7 = NULL , MagParam8 = NULL , MagParam9 = NULL , MagParam10 = NULL , MagParam11 = NULL , MagParam12 = NULL where ID64 = @ ItemID
end
Else
If (@ RefItemID >= '36750' AND @ RefItemID <= '36753' )
begin
Update _Items Set MagParamNum = 0 , MagParam1 = NULL , MagParam2 = NULL , MagParam3 = NULL , MagParam4 = NULL , MagParam5 = NULL , MagParam6 = NULL , MagParam7 = NULL , MagParam8 = NULL , MagParam9 = NULL , MagParam10 = NULL , MagParam11 = NULL , MagParam12 = NULL where ID64 = @ ItemID
end
Else
If (@ RefItemID >= '36806' AND @ RefItemID <= '36811' )
begin
Update _Items Set MagParamNum = 0 , MagParam1 = NULL , MagParam2 = NULL , MagParam3 = NULL , MagParam4 = NULL , MagParam5 = NULL , MagParam6 = NULL , MagParam7 = NULL , MagParam8 = NULL , MagParam9 = NULL , MagParam10 = NULL , MagParam11 = NULL , MagParam12 = NULL where ID64 = @ ItemID
end
Else
If (@ RefItemID >= '36915' AND @ RefItemID <= '36932' )
begin
Update _Items Set MagParamNum = 0 , MagParam1 = NULL , MagParam2 = NULL , MagParam3 = NULL , MagParam4 = NULL , MagParam5 = NULL , MagParam6 = NULL , MagParam7 = NULL , MagParam8 = NULL , MagParam9 = NULL , MagParam10 = NULL , MagParam11 = NULL , MagParam12 = NULL where ID64 = @ ItemID
end
Else
If (@ RefItemID >= '38802' AND @ RefItemID <= '38815' )
begin
Update _Items Set MagParamNum = 0 , MagParam1 = NULL , MagParam2 = NULL , MagParam3 = NULL , MagParam4 = NULL , MagParam5 = NULL , MagParam6 = NULL , MagParam7 = NULL , MagParam8 = NULL , MagParam9 = NULL , MagParam10 = NULL , MagParam11 = NULL , MagParam12 = NULL where ID64 = @ ItemID
end
Else
If (@ RefItemID >= '38838' AND @ RefItemID <= '38841' )
begin
Update _Items Set MagParamNum = 0 , MagParam1 = NULL , MagParam2 = NULL , MagParam3 = NULL , MagParam4 = NULL , MagParam5 = NULL , MagParam6 = NULL , MagParam7 = NULL , MagParam8 = NULL , MagParam9 = NULL , MagParam10 = NULL , MagParam11 = NULL , MagParam12 = NULL where ID64 = @ ItemID
end
Else
If (@ RefItemID >= '38966' AND @ RefItemID <= '38969' )
begin
Update _Items Set MagParamNum = 0 , MagParam1 = NULL , MagParam2 = NULL , MagParam3 = NULL , MagParam4 = NULL , MagParam5 = NULL , MagParam6 = NULL , MagParam7 = NULL , MagParam8 = NULL , MagParam9 = NULL , MagParam10 = NULL , MagParam11 = NULL , MagParam12 = NULL where ID64 = @ ItemID
end
Else
If (@ RefItemID >= '39286' AND @ RefItemID <= '39303' )
begin
Update _Items Set MagParamNum = 0 , MagParam1 = NULL , MagParam2 = NULL , MagParam3 = NULL , MagParam4 = NULL , MagParam5 = NULL , MagParam6 = NULL , MagParam7 = NULL , MagParam8 = NULL , MagParam9 = NULL , MagParam10 = NULL , MagParam11 = NULL , MagParam12 = NULL where ID64 = @ ItemID
end
Else
If (@ RefItemID >= '41473' AND @ RefItemID <= '41520' )
begin
Update _Items Set MagParamNum = 0 , MagParam1 = NULL , MagParam2 = NULL , MagParam3 = NULL , MagParam4 = NULL , MagParam5 = NULL , MagParam6 = NULL , MagParam7 = NULL , MagParam8 = NULL , MagParam9 = NULL , MagParam10 = NULL , MagParam11 = NULL , MagParam12 = NULL where ID64 = @ ItemID
end
Else
If (@ RefItemID >= '41798' AND @ RefItemID <= '41803' )
begin
Update _Items Set MagParamNum = 0 , MagParam1 = NULL , MagParam2 = NULL , MagParam3 = NULL , MagParam4 = NULL , MagParam5 = NULL , MagParam6 = NULL , MagParam7 = NULL , MagParam8 = NULL , MagParam9 = NULL , MagParam10 = NULL , MagParam11 = NULL , MagParam12 = NULL where ID64 = @ ItemID
end
Else
If (@ RefItemID >= '41833' AND @ RefItemID <= '41844' )
begin
Update _Items Set MagParamNum = 0 , MagParam1 = NULL , MagParam2 = NULL , MagParam3 = NULL , MagParam4 = NULL , MagParam5 = NULL , MagParam6 = NULL , MagParam7 = NULL , MagParam8 = NULL , MagParam9 = NULL , MagParam10 = NULL , MagParam11 = NULL , MagParam12 = NULL where ID64 = @ ItemID
end
Else
If (@ RefItemID >= '41946' AND @ RefItemID <= '41955' )
begin
Update _Items Set MagParamNum = 0 , MagParam1 = NULL , MagParam2 = NULL , MagParam3 = NULL , MagParam4 = NULL , MagParam5 = NULL , MagParam6 = NULL , MagParam7 = NULL , MagParam8 = NULL , MagParam9 = NULL , MagParam10 = NULL , MagParam11 = NULL , MagParam12 = NULL where ID64 = @ ItemID
end
Else
If (@ RefItemID >= '42713' AND @ RefItemID <= '42722' )
begin
Update _Items Set MagParamNum = 0 , MagParam1 = NULL , MagParam2 = NULL , MagParam3 = NULL , MagParam4 = NULL , MagParam5 = NULL , MagParam6 = NULL , MagParam7 = NULL , MagParam8 = NULL , MagParam9 = NULL , MagParam10 = NULL , MagParam11 = NULL , MagParam12 = NULL where ID64 = @ ItemID
end
Else
If (@ RefItemID >= '43009' AND @ RefItemID <= '43014' )
begin
Update _Items Set MagParamNum = 0 , MagParam1 = NULL , MagParam2 = NULL , MagParam3 = NULL , MagParam4 = NULL , MagParam5 = NULL , MagParam6 = NULL , MagParam7 = NULL , MagParam8 = NULL , MagParam9 = NULL , MagParam10 = NULL , MagParam11 = NULL , MagParam12 = NULL where ID64 = @ ItemID
end
Else
If (@ RefItemID >= '43584' AND @ RefItemID <= '43589' )
begin
Update _Items Set MagParamNum = 0 , MagParam1 = NULL , MagParam2 = NULL , MagParam3 = NULL , MagParam4 = NULL , MagParam5 = NULL , MagParam6 = NULL , MagParam7 = NULL , MagParam8 = NULL , MagParam9 = NULL , MagParam10 = NULL , MagParam11 = NULL , MagParam12 = NULL where ID64 = @ ItemID
end
return - 3
end
توقيع katsh1
:
ComingSo0o0o0o0N
إعلانات google
02-10-2013, 12:43 AM
#2
Dev Hamboka
• الانـتـسـاب » Sep 2012
• رقـم العـضـويـة » 105765
• المشـــاركـات » 3,012
• الـدولـة » تحت البحر
• الـهـوايـة » hack Site
• اسـم الـسـيـرفـر » No Server
• الـجـنـس » Male
• نقـاط التقييم » 1765
02-10-2013, 12:49 AM
#3
• الانـتـسـاب » Jun 2011
• رقـم العـضـويـة » 88572
• المشـــاركـات » 3,746
• الـدولـة » أمـــ الدنيــا ــــ
• الـهـوايـة » SRO_VT_SHARD
• اسـم الـسـيـرفـر » No Server
• الـجـنـس » Male
• نقـاط التقييم » 2477
أيــوة يعنــى عــايـز أيــه ؟! -_-
توقيع ●♥ Marwan1337 ♥●
:
█ Professional Data Base / Media Editor █
02-10-2013, 04:05 PM
#4
• الانـتـسـاب » Oct 2011
• رقـم العـضـويـة » 92849
• المشـــاركـات » 289
• الـدولـة » alex
• الـهـوايـة » Edite Media.pk2
• اسـم الـسـيـرفـر » Private Server
• الـجـنـس » Male
• نقـاط التقييم » 239
انا فى حجات باجى اعملها بتكون فى حجات بتتحت فى Procedure عايز اعرف دا ايه و فين و _TimedJob دا فين و اضيف الكويرى دا فيه ازاى
كود PHP:
if(@ JobID = '34038' ) -- Remover Blue Avatar begin SELECT @ ItemID = ItemID from _Inventory where CharID = @ CharID AND Slot = '13' SELECT @ RefItemID = RefItemID from _Items where ID64 = @ ItemID If (@ RefItemID >= '43620' AND @ RefItemID <= '43625' ) begin Update _Items Set MagParamNum = 0 , MagParam1 = NULL , MagParam2 = NULL , MagParam3 = NULL , MagParam4 = NULL , MagParam5 = NULL , MagParam6 = NULL , MagParam7 = NULL , MagParam8 = NULL , MagParam9 = NULL , MagParam10 = NULL , MagParam11 = NULL , MagParam12 = NULL where ID64 = @ ItemID end Else If (@ RefItemID >= '22912' AND @ RefItemID <= '22923' ) begin Update _Items Set MagParamNum = 0 , MagParam1 = NULL , MagParam2 = NULL , MagParam3 = NULL , MagParam4 = NULL , MagParam5 = NULL , MagParam6 = NULL , MagParam7 = NULL , MagParam8 = NULL , MagParam9 = NULL , MagParam10 = NULL , MagParam11 = NULL , MagParam12 = NULL where ID64 = @ ItemID end Else If (@ RefItemID >= '23272' AND @ RefItemID <= '23275' ) begin Update _Items Set MagParamNum = 0 , MagParam1 = NULL , MagParam2 = NULL , MagParam3 = NULL , MagParam4 = NULL , MagParam5 = NULL , MagParam6 = NULL , MagParam7 = NULL , MagParam8 = NULL , MagParam9 = NULL , MagParam10 = NULL , MagParam11 = NULL , MagParam12 = NULL where ID64 = @ ItemID end Else If (@ RefItemID >= '23320' AND @ RefItemID <= '23321' ) begin Update _Items Set MagParamNum = 0 , MagParam1 = NULL , MagParam2 = NULL , MagParam3 = NULL , MagParam4 = NULL , MagParam5 = NULL , MagParam6 = NULL , MagParam7 = NULL , MagParam8 = NULL , MagParam9 = NULL , MagParam10 = NULL , MagParam11 = NULL , MagParam12 = NULL where ID64 = @ ItemID end Else If (@ RefItemID >= '24262' AND @ RefItemID <= '24273' ) begin Update _Items Set MagParamNum = 0 , MagParam1 = NULL , MagParam2 = NULL , MagParam3 = NULL , MagParam4 = NULL , MagParam5 = NULL , MagParam6 = NULL , MagParam7 = NULL , MagParam8 = NULL , MagParam9 = NULL , MagParam10 = NULL , MagParam11 = NULL , MagParam12 = NULL where ID64 = @ ItemID end Else If (@ RefItemID >= '24298' AND @ RefItemID <= '24317' ) begin Update _Items Set MagParamNum = 0 , MagParam1 = NULL , MagParam2 = NULL , MagParam3 = NULL , MagParam4 = NULL , MagParam5 = NULL , MagParam6 = NULL , MagParam7 = NULL , MagParam8 = NULL , MagParam9 = NULL , MagParam10 = NULL , MagParam11 = NULL , MagParam12 = NULL where ID64 = @ ItemID end Else If (@ RefItemID >= '24351' AND @ RefItemID <= '24380' ) begin Update _Items Set MagParamNum = 0 , MagParam1 = NULL , MagParam2 = NULL , MagParam3 = NULL , MagParam4 = NULL , MagParam5 = NULL , MagParam6 = NULL , MagParam7 = NULL , MagParam8 = NULL , MagParam9 = NULL , MagParam10 = NULL , MagParam11 = NULL , MagParam12 = NULL where ID64 = @ ItemID end Else If (@ RefItemID >= '24405' AND @ RefItemID <= '24412' ) begin Update _Items Set MagParamNum = 0 , MagParam1 = NULL , MagParam2 = NULL , MagParam3 = NULL , MagParam4 = NULL , MagParam5 = NULL , MagParam6 = NULL , MagParam7 = NULL , MagParam8 = NULL , MagParam9 = NULL , MagParam10 = NULL , MagParam11 = NULL , MagParam12 = NULL where ID64 = @ ItemID end Else If (@ RefItemID >= '24644' AND @ RefItemID <= '24661' ) begin Update _Items Set MagParamNum = 0 , MagParam1 = NULL , MagParam2 = NULL , MagParam3 = NULL , MagParam4 = NULL , MagParam5 = NULL , MagParam6 = NULL , MagParam7 = NULL , MagParam8 = NULL , MagParam9 = NULL , MagParam10 = NULL , MagParam11 = NULL , MagParam12 = NULL where ID64 = @ ItemID end Else If (@ RefItemID >= '25799' AND @ RefItemID <= '25822' ) begin Update _Items Set MagParamNum = 0 , MagParam1 = NULL , MagParam2 = NULL , MagParam3 = NULL , MagParam4 = NULL , MagParam5 = NULL , MagParam6 = NULL , MagParam7 = NULL , MagParam8 = NULL , MagParam9 = NULL , MagParam10 = NULL , MagParam11 = NULL , MagParam12 = NULL where ID64 = @ ItemID end Else If (@ RefItemID >= '29403' AND @ RefItemID <= '29412' ) begin Update _Items Set MagParamNum = 0 , MagParam1 = NULL , MagParam2 = NULL , MagParam3 = NULL , MagParam4 = NULL , MagParam5 = NULL , MagParam6 = NULL , MagParam7 = NULL , MagParam8 = NULL , MagParam9 = NULL , MagParam10 = NULL , MagParam11 = NULL , MagParam12 = NULL where ID64 = @ ItemID end Else If (@ RefItemID >= '33814' AND @ RefItemID <= '33837' ) begin Update _Items Set MagParamNum = 0 , MagParam1 = NULL , MagParam2 = NULL , MagParam3 = NULL , MagParam4 = NULL , MagParam5 = NULL , MagParam6 = NULL , MagParam7 = NULL , MagParam8 = NULL , MagParam9 = NULL , MagParam10 = NULL , MagParam11 = NULL , MagParam12 = NULL where ID64 = @ ItemID end Else If (@ RefItemID >= '35578' AND @ RefItemID <= '35581' ) begin Update _Items Set MagParamNum = 0 , MagParam1 = NULL , MagParam2 = NULL , MagParam3 = NULL , MagParam4 = NULL , MagParam5 = NULL , MagParam6 = NULL , MagParam7 = NULL , MagParam8 = NULL , MagParam9 = NULL , MagParam10 = NULL , MagParam11 = NULL , MagParam12 = NULL where ID64 = @ ItemID end Else If (@ RefItemID >= '35586' AND @ RefItemID <= '35591' ) begin Update _Items Set MagParamNum = 0 , MagParam1 = NULL , MagParam2 = NULL , MagParam3 = NULL , MagParam4 = NULL , MagParam5 = NULL , MagParam6 = NULL , MagParam7 = NULL , MagParam8 = NULL , MagParam9 = NULL , MagParam10 = NULL , MagParam11 = NULL , MagParam12 = NULL where ID64 = @ ItemID end Else If (@ RefItemID >= '36750' AND @ RefItemID <= '36753' ) begin Update _Items Set MagParamNum = 0 , MagParam1 = NULL , MagParam2 = NULL , MagParam3 = NULL , MagParam4 = NULL , MagParam5 = NULL , MagParam6 = NULL , MagParam7 = NULL , MagParam8 = NULL , MagParam9 = NULL , MagParam10 = NULL , MagParam11 = NULL , MagParam12 = NULL where ID64 = @ ItemID end Else If (@ RefItemID >= '36806' AND @ RefItemID <= '36811' ) begin Update _Items Set MagParamNum = 0 , MagParam1 = NULL , MagParam2 = NULL , MagParam3 = NULL , MagParam4 = NULL , MagParam5 = NULL , MagParam6 = NULL , MagParam7 = NULL , MagParam8 = NULL , MagParam9 = NULL , MagParam10 = NULL , MagParam11 = NULL , MagParam12 = NULL where ID64 = @ ItemID end Else If (@ RefItemID >= '36915' AND @ RefItemID <= '36932' ) begin Update _Items Set MagParamNum = 0 , MagParam1 = NULL , MagParam2 = NULL , MagParam3 = NULL , MagParam4 = NULL , MagParam5 = NULL , MagParam6 = NULL , MagParam7 = NULL , MagParam8 = NULL , MagParam9 = NULL , MagParam10 = NULL , MagParam11 = NULL , MagParam12 = NULL where ID64 = @ ItemID end Else If (@ RefItemID >= '38802' AND @ RefItemID <= '38815' ) begin Update _Items Set MagParamNum = 0 , MagParam1 = NULL , MagParam2 = NULL , MagParam3 = NULL , MagParam4 = NULL , MagParam5 = NULL , MagParam6 = NULL , MagParam7 = NULL , MagParam8 = NULL , MagParam9 = NULL , MagParam10 = NULL , MagParam11 = NULL , MagParam12 = NULL where ID64 = @ ItemID end Else If (@ RefItemID >= '38838' AND @ RefItemID <= '38841' ) begin Update _Items Set MagParamNum = 0 , MagParam1 = NULL , MagParam2 = NULL , MagParam3 = NULL , MagParam4 = NULL , MagParam5 = NULL , MagParam6 = NULL , MagParam7 = NULL , MagParam8 = NULL , MagParam9 = NULL , MagParam10 = NULL , MagParam11 = NULL , MagParam12 = NULL where ID64 = @ ItemID end Else If (@ RefItemID >= '38966' AND @ RefItemID <= '38969' ) begin Update _Items Set MagParamNum = 0 , MagParam1 = NULL , MagParam2 = NULL , MagParam3 = NULL , MagParam4 = NULL , MagParam5 = NULL , MagParam6 = NULL , MagParam7 = NULL , MagParam8 = NULL , MagParam9 = NULL , MagParam10 = NULL , MagParam11 = NULL , MagParam12 = NULL where ID64 = @ ItemID end Else If (@ RefItemID >= '39286' AND @ RefItemID <= '39303' ) begin Update _Items Set MagParamNum = 0 , MagParam1 = NULL , MagParam2 = NULL , MagParam3 = NULL , MagParam4 = NULL , MagParam5 = NULL , MagParam6 = NULL , MagParam7 = NULL , MagParam8 = NULL , MagParam9 = NULL , MagParam10 = NULL , MagParam11 = NULL , MagParam12 = NULL where ID64 = @ ItemID end Else If (@ RefItemID >= '41473' AND @ RefItemID <= '41520' ) begin Update _Items Set MagParamNum = 0 , MagParam1 = NULL , MagParam2 = NULL , MagParam3 = NULL , MagParam4 = NULL , MagParam5 = NULL , MagParam6 = NULL , MagParam7 = NULL , MagParam8 = NULL , MagParam9 = NULL , MagParam10 = NULL , MagParam11 = NULL , MagParam12 = NULL where ID64 = @ ItemID end Else If (@ RefItemID >= '41798' AND @ RefItemID <= '41803' ) begin Update _Items Set MagParamNum = 0 , MagParam1 = NULL , MagParam2 = NULL , MagParam3 = NULL , MagParam4 = NULL , MagParam5 = NULL , MagParam6 = NULL , MagParam7 = NULL , MagParam8 = NULL , MagParam9 = NULL , MagParam10 = NULL , MagParam11 = NULL , MagParam12 = NULL where ID64 = @ ItemID end Else If (@ RefItemID >= '41833' AND @ RefItemID <= '41844' ) begin Update _Items Set MagParamNum = 0 , MagParam1 = NULL , MagParam2 = NULL , MagParam3 = NULL , MagParam4 = NULL , MagParam5 = NULL , MagParam6 = NULL , MagParam7 = NULL , MagParam8 = NULL , MagParam9 = NULL , MagParam10 = NULL , MagParam11 = NULL , MagParam12 = NULL where ID64 = @ ItemID end Else If (@ RefItemID >= '41946' AND @ RefItemID <= '41955' ) begin Update _Items Set MagParamNum = 0 , MagParam1 = NULL , MagParam2 = NULL , MagParam3 = NULL , MagParam4 = NULL , MagParam5 = NULL , MagParam6 = NULL , MagParam7 = NULL , MagParam8 = NULL , MagParam9 = NULL , MagParam10 = NULL , MagParam11 = NULL , MagParam12 = NULL where ID64 = @ ItemID end Else If (@ RefItemID >= '42713' AND @ RefItemID <= '42722' ) begin Update _Items Set MagParamNum = 0 , MagParam1 = NULL , MagParam2 = NULL , MagParam3 = NULL , MagParam4 = NULL , MagParam5 = NULL , MagParam6 = NULL , MagParam7 = NULL , MagParam8 = NULL , MagParam9 = NULL , MagParam10 = NULL , MagParam11 = NULL , MagParam12 = NULL where ID64 = @ ItemID end Else If (@ RefItemID >= '43009' AND @ RefItemID <= '43014' ) begin Update _Items Set MagParamNum = 0 , MagParam1 = NULL , MagParam2 = NULL , MagParam3 = NULL , MagParam4 = NULL , MagParam5 = NULL , MagParam6 = NULL , MagParam7 = NULL , MagParam8 = NULL , MagParam9 = NULL , MagParam10 = NULL , MagParam11 = NULL , MagParam12 = NULL where ID64 = @ ItemID end Else If (@ RefItemID >= '43584' AND @ RefItemID <= '43589' ) begin Update _Items Set MagParamNum = 0 , MagParam1 = NULL , MagParam2 = NULL , MagParam3 = NULL , MagParam4 = NULL , MagParam5 = NULL , MagParam6 = NULL , MagParam7 = NULL , MagParam8 = NULL , MagParam9 = NULL , MagParam10 = NULL , MagParam11 = NULL , MagParam12 = NULL where ID64 = @ ItemID end return - 3 end
الكود دا في ايه الى المفرود اعدلو للسيرفر بتاعى Thanks
توقيع katsh1
:
ComingSo0o0o0o0N
02-10-2013, 04:12 PM
katsh1
هذه الرسالة حذفت بواسطة
TYKE .
03-10-2013, 08:27 PM
#7
• الانـتـسـاب » Jun 2011
• رقـم العـضـويـة » 88572
• المشـــاركـات » 3,746
• الـدولـة » أمـــ الدنيــا ــــ
• الـهـوايـة » SRO_VT_SHARD
• اسـم الـسـيـرفـر » No Server
• الـجـنـس » Male
• نقـاط التقييم » 2477
الـ Query عشــانـ Remover Blue Avatar
وصعــب أنــ واحــد يشــرحلـكـ كـلـ حـاجـة فـى الـ Query
بـسـ أنـا أولـ مـرة أشــوفـ الـ Query ده ,,
توقيع ●♥ Marwan1337 ♥●
:
█ Professional Data Base / Media Editor █
05-10-2013, 12:41 AM
#8
• الانـتـسـاب » Oct 2011
• رقـم العـضـويـة » 92849
• المشـــاركـات » 289
• الـدولـة » alex
• الـهـوايـة » Edite Media.pk2
• اسـم الـسـيـرفـر » Private Server
• الـجـنـس » Male
• نقـاط التقييم » 239
انا عارف انو علشان remove blue from dress
دا بيتحت فى Procedure in _TimedJob_
انا عايز اعرف فين مكان Procedure
و _TimedJob
و اجيب ID الى هوا طلبو فى Query ازاى
يارب تكون فهمتنى
وشكرا على مرورك
توقيع katsh1
:
ComingSo0o0o0o0N
05-10-2013, 12:44 PM
#9
• الانـتـسـاب » Sep 2012
• رقـم العـضـويـة » 105332
• المشـــاركـات » 319
• الـدولـة »
• الـهـوايـة » Hex,PHP,C#,SQL
• اسـم الـسـيـرفـر » No Server
• الـجـنـس » Male
• نقـاط التقييم » 258
SRO_VT_SHARD>> Programmability >>> Stored Procedures >>> _AddTimedJob
and this not Query to remove Blue from avatar
this Procedures scroll to remove Blue from avatar
you need more skill to know how to use this procedures in your server
06-10-2013, 11:50 AM
#10
• الانـتـسـاب » Jun 2011
• رقـم العـضـويـة » 88572
• المشـــاركـات » 3,746
• الـدولـة » أمـــ الدنيــا ــــ
• الـهـوايـة » SRO_VT_SHARD
• اسـم الـسـيـرفـر » No Server
• الـجـنـس » Male
• نقـاط التقييم » 2477
توقيع ●♥ Marwan1337 ♥●
:
█ Professional Data Base / Media Editor █
يتصفح الموضوع حالياً : 1 (0 عضو و 1 زائر)
ضوابط المشاركة
تستطيع إضافة مواضيع جديدة
تستطيع الرد على المواضيع
تستطيع إرفاق ملفات
تستطيع تعديل مشاركاتك
كود HTML معطلة
الساعة الآن 07:21 AM .