- Silkroad Online
             

sropedia

Casper4Gold

Asfor 4Gold

 20/11/2016

 20/10/2018

Marwan

Casper4Gold

QueenSro



 





[ ] [ ]

         ::   ( :Mohamed ibrahim_)       :: ***New Filter Features*** ( :Hamza FiGo)       :: Chaos Reborn | D14 | Cap 140 | Pve | New Systems | New 140 Skills | GrandOpening 22-11-2018 ( :Hamza FiGo)       ::  Download  ( :Hamza FiGo)       ::   ( :Hamza FiGo)       ::   ( :Hamza FiGo)       ::   ( :Hamza FiGo)       ::   ( :Hamza FiGo)       ::  lv 140 ( :Hamza FiGo)       ::   ( :_ramez_)       :: Download Joysro Mbot ( :gamil12)       ::  ( Hamachi + X-Fire + Online Play ) ( :desolation)       :: www.vodka-road.com ( :goda2020)       ::   ( :нɪsσĸα)       ::   ( :Mohamed ibrahim_)       :: Hammer doesn't working on staff only ( :Zeyad1337)       :: Hammer doesn't working on staff only ( :Zeyad1337)       ::  item NPC ( :bag0ry)       :: $ $ ( :Rev-Sro)       ::   ( :нɪsσĸα)       ::  DATA BAS Rebecca-Road  ( :moatazsayed)       :: www.vodka-road.com ( : )       :: Auto Plus Notice With New Feature ( : )       :: Honor Puff Scroll #Ri3o ( : )       :: New Honor Rank Scroll ( : )      

 
30-07-2018, 07:25 AM   #1

ModySe





Jul 2018
136264
19
No Server
Male
10
ModySe

ModySe

55  



(25) :







7






- xerk
_RefTeleport

_RefTeleLink


7
HTML:
USE [SRO_VT_SHARD]
GO
/****** Object:  StoredProcedure [dbo].[_DeleteCharTemporal]    Script Date: 7/31/2018 8:46:10 AM ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO
---------------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------
ALTER PROCEDURE [dbo].[_DeleteCharTemporal]
@UserJID	as 	int,
-- @CharSlot	as 	int
@char_id_to_del as int
as
	------------------------------------
	-- step1. 일단 캐*이 존재하는지 부터 검사!
	------------------------------------
--	declare @char_id_to_del	 	int
--	set @char_id_to_del = 0
	/* -- commented by novice. for server integration.
	if (@CharSlot = 0)
		begin	select @char_id_to_del = CharID1 from _User with (nolock) where UserJID = @UserJID end
	else if (@CharSlot = 1)
		begin	select @char_id_to_del = CharID2 from _User with (nolock) where UserJID = @UserJID end
	else if (@CharSlot = 2)
		begin	select @char_id_to_del = CharID3 from _User with (nolock) where UserJID = @UserJID end
	else
		begin
			return -1
		end
	*/
	------------------------------------
	-- step2. 너 설마 dummy character를 지우* 싶은게냐? -_-+
	------------------------------------
	if (@char_id_to_del = 0)
	begin
		return -2
	end
	------------------------------------
	-- step3. 왜! 지운 거 또 지울라구?
	-- 0: *상 캐*
	-- 1: 임시 **
	------------------------------------
	declare @is_deleted	tinyint
	select @is_deleted = deleted from _char where charid = @char_id_to_del
	if (@is_deleted <> 0)
	begin
		return -3
	end
	
begin transaction
	------------------------------------
	-- step4. recycle bin 에 넣어주*...
	------------------------------------
	insert _DeletedChar values(@char_id_to_del, @UserJID, GetDate())
	if (@@error <> 0)
	begin
		rollback transaction
		return -4
	end
	
	------------------------------------
	-- step5. 임시 **됬다구 표시해두자.
	------------------------------------
	update _Char set deleted = 1 where CharID = @char_id_to_del
	if (@@error <> 0)
	begin
		rollback transaction
		return -5
	end
	------------------------------------
	-- step6. commit !!!
	------------------------------------
	commit transaction
	
	return 1
google

31-07-2018, 09:46 AM   #2

xerk





Jul 2018
136506
8
No Server
Male
10
xerk

xerk

16  



: 1
:



_RefTeleport

_RefTeleLink


7
HTML:
USE [SRO_VT_SHARD]
GO
/****** Object:  StoredProcedure [dbo].[_DeleteCharTemporal]    Script Date: 7/31/2018 8:46:10 AM ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO
---------------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------
ALTER PROCEDURE [dbo].[_DeleteCharTemporal]
@UserJID	as 	int,
-- @CharSlot	as 	int
@char_id_to_del as int
as
	------------------------------------
	-- step1. 일단 캐*이 존재하는지 부터 검사!
	------------------------------------
--	declare @char_id_to_del	 	int
--	set @char_id_to_del = 0
	/* -- commented by novice. for server integration.
	if (@CharSlot = 0)
		begin	select @char_id_to_del = CharID1 from _User with (nolock) where UserJID = @UserJID end
	else if (@CharSlot = 1)
		begin	select @char_id_to_del = CharID2 from _User with (nolock) where UserJID = @UserJID end
	else if (@CharSlot = 2)
		begin	select @char_id_to_del = CharID3 from _User with (nolock) where UserJID = @UserJID end
	else
		begin
			return -1
		end
	*/
	------------------------------------
	-- step2. 너 설마 dummy character를 지우* 싶은게냐? -_-+
	------------------------------------
	if (@char_id_to_del = 0)
	begin
		return -2
	end
	------------------------------------
	-- step3. 왜! 지운 거 또 지울라구?
	-- 0: *상 캐*
	-- 1: 임시 **
	------------------------------------
	declare @is_deleted	tinyint
	select @is_deleted = deleted from _char where charid = @char_id_to_del
	if (@is_deleted <> 0)
	begin
		return -3
	end
	
begin transaction
	------------------------------------
	-- step4. recycle bin 에 넣어주*...
	------------------------------------
	insert _DeletedChar values(@char_id_to_del, @UserJID, GetDate())
	if (@@error <> 0)
	begin
		rollback transaction
		return -4
	end
	
	------------------------------------
	-- step5. 임시 **됬다구 표시해두자.
	------------------------------------
	update _Char set deleted = 1 where CharID = @char_id_to_del
	if (@@error <> 0)
	begin
		rollback transaction
		return -5
	end
	------------------------------------
	-- step6. commit !!!
	------------------------------------
	commit transaction
	
	return 1




31-07-2018, 09:50 AM   #3

ModySe





Jul 2018
136264
19
No Server
Male
10
ModySe

ModySe

55  



:







31-07-2018, 09:56 AM   #4

ModySe





Jul 2018
136264
19
No Server
Male
10
ModySe

ModySe

55  



:







31-07-2018, 09:58 AM   #5

xerk





Jul 2018
136506
8
No Server
Male
10
xerk

xerk

16  



: 1
:



:
ModySe ,,, [ ]




31-07-2018, 10:11 AM   #6

ModySe





Jul 2018
136264
19
No Server
Male
10
ModySe

ModySe

55  



:






,,, [ ]





« | »

: 1 (0 1 )
 




09:12 PM.

@ @ @ @ @ @ SilkroadOnline @ @ @ @ @ @ @ @ (Gold) @ ( Gold) @ (Gold) @ @ ( Korean SilkRoad ) @ AgBot @ ( Accounts ) @ [ ] @ ( Item ) @ ( Gold ) @ ( Item ) @ @ Flora @ Minerva @ Feronia @ Bellona @ [ iSro ] @ @ @ @ PhBot @ -== T-BOT ==- @ Ceres @ @ @ @ @ @ @ StealthLite Bot @ Agbot @ StealthLite @ PHBOT @ T-BOT @ SroKing Bot @ [ iSro ] @ Flora @ Ceres @ Bellona @ Minerva @ Feronia @ 2017 @ @ @ @ ECSRO @ ECSRO(Fembria) @ ECSRO(VIP) @ SJSRO (OLD) @ SJSRO (new) @ sunworld @ IBot @ ( Gold ) @ @ Vsro @ Rusro @ [ Private-SRO ] @ ZSZC & Aurora @ Sbot @ Mbot @ V.I.P Zone @ VIP @ VIP @ [ PK2 Edit ] @ Mysro @ @ @ @ IBOT @ Sbot @ Mbot @ Sroking @ Elite & Eroad @ DreamWorld @ @ [ Silkroad-R ] @ Maycena @ @ [ Silkroad-R ] @ - Private SRO @ Perfection @ Ex.Silkroad R @ SroKings @ @ Other Online Games @ S4 League @ CrossFire @ Conquer Online @ LOL @ Pc Games @ @ Barons Online @ (AriesOnline (Pvp @ QueenSRO Network @ & S4 League @ & CrossFire @ World's Gate @ Sun-World @ Aion @ Continent Of The Ninth @ World Of Warcraft @ PanicSro @ @ @ IceSro-R @ Kings_Silkroad @ Justice Road @ ArabianRoadOnline Network @ Devias Online @ @ CrossFire Fantasy Game @ CrossFire @ & Aion @ & Conquer Online @ League Of Legends @ legenD road @ WantedSro Online @ @ @ Mixsro @ @ SRO-R @ LegenD Road @ Knights War Online @ Evolution Network @ FlagSRO Network @ Perfection (PvP) Network @ S4league @ @ @ @ @ Destructions Network @ FanTasYWorld @ @ Smart-Sro Online @ InFusion Online @ @ Divine Online @ Dota @ PC @ GameXen Network @ inferno online @ @ @ PK2 edit @ Velestia @ Punisher Sro Online @ Atlantis Online @ ALEXNADER SRO @ Hell World Online @ ImmortalRoad @ Centerbot @ Centerbot @ Time.Sro-Online @ Revenge (PVE) Online @ PC Other Online Games @ Online Games @ @ @ @ @ @ @ @ @ Creddy Online @ Alliance-sro @ Quick Road (PvP ) @ @ League Of Legends @ League Of Legends @ CrossFire @ League Of Legends @ [ LOL ] @ North America @ EU West @ EU Nordic & East @ League Of Legends @ @ @ @ Wolf team @ Dota 2 @ Dragon nest @ DC Universe Online @ Windows @ Quenth Online @ Wolf team Arabic @ RealDreamSro ( PvP ) @ EmpireSRO @ Amazing Sro @ Speed-sro @ . Destructions Network @ SilkRoad E 80 China @ @ @ Greats-sro Online @ @ @ Srowing @ Dakupra-Online @ @ @ @ @ @ @ @ PantuSRO @ Silkroad4arab ( vps ,server) @ Tyr Online @ RocSro @ Legend Of Silkroad @ Pioneer Gaming-Network @ Valentus - CAP 80 @ MirrorSro @ Eridanus Online Cap90 @ Fear-Sro @ Silkroad-Z Online PVE @ @ Massive-Network @ Kryptonite-Sro @ DeathRoad @ Mysro Servers @ Devils Team @ DooMSRO Network @ EROAD SRO @ Story-SRO @ Ventrue-Online @ Settlers-SRO @ Electus Online @ MarsRoad Online @ Arrow Online @ Selene @ Hermes @ OldSro Online (cap 80 ) @ Sunroad @ Eloys Online @ Sentiero-Road Online @ Steam-Sro @ Arcane Reborn Online @ Eryxonline @ Vengeance Online @ Mirage Online @ SyndiCateOnline @ Desert Sro @ NeSro Network @ Android @ @ @ MegaWar Sro @ Mirror Sro @ AdvancedSRO @ OblivionSilkroad @ Arrivals_Sro @ Amphibius Online @ Royal online @ Forbidden-Sro @ vanish-sro @ Majesty Online @ Chaos Network @ srAssist Bot @ srAssist Bot @ Damocles Sro @ Demo Sro @ KingsRoad @ Arius 9D ch & eu @ brother sro @ DreamWorld-Online @ Poseidon-Sro @ Ph-Sro @ Jupiet-Online @ Fury Sro @ JungleSro @ Xemia Games @ invctus-sro @ Revolution Gaming Network @ DemonSro @ Aeolus @ Golden Sro @ Chaos Reborn @ Chaos II Online @ Fallen Soul @ StarLife Online @ Xian @ Xian @ Revira online @ @ 2018 @ Silkroad life @ Bcsro Online @ Aliens Online @ Unix Sro @ Immortal SRO @ VehallaSro 11D @ Justice Online @ Venus Online @ [English - Arabic - Videos] @ Egypt-Sro @ (Rap) @ | WWE @ @ The Dragon Sro @ @ @ @ @ Perfection SRO @ Rev-Sro @ GoldenAge Reborn @ vodka road @


- - -