sropedia

Casper 4Gold

Asfor 4Gold

 20/11/2016

 3/08/2018

 26/06/2018

Casper 4Gold

QueenSro

AlieenSro    06.08.2018

 30/8/2018

 

[ ] | |





[ ] [ ]

         :: Legends Sro|PVP|D11|Coin System|AutomaticEvents|Play2Win| ( :Kivo)       :: Donate quest per day ( :.Gamer.)       :: MONTHLY PVP - SESSION THREE| FOR 20$ ( :.Gamer.)       ::  Supporters ( :.Gamer.)       ::  01096922100 + 0235699066 samsung ( :)       ::  01112124913 0235700994 Daewoo ( :)       ::  01283377353 # 0235710008 toshib ( :)       ::  01060037840 (( ))0235710008 white whale ( :)       ::  | 0235682820 01095999314 | lg ( :)       ::  (( 0235710008 01023140280 ))  ( :)       ::  || 0235699066 || || 01207619993 ||  ( :)       ::  || 01129347771|| 0235700994 || hitachi ( :)       ::  || 01129347771|| 0235700994 || hitachi ( :)       ::  0235710008 # 01096922100  ( :)       ::  01210999852 0235700997 admiral ( :)       ::  01093055835 & 0235699066  ( :)       ::  01112124913)) (( 0235682820 sharp ( :)       ::  01223179993 | | 0235700994 white westing ( :)       :: extreme sro / lvl 140 / D20 / everything is for free ( :TREND_SEEKER)       ::  01154008110 + 0235710008 frigidaire ( :)       ::  01095999314 | 0235682820 Whirlpool ( :)       ::  01096922100 _ 0235699066 kelvinator ( :)       ::  HDD Regenerator  ( :ineX13)       ::  HDD Regenerator  ( :ineX13)       :: (`. SilkRoadOnline .`) ( :aladdinali)      

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

ModySe





Jul 2018
136264
17
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
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
17
No Server
Male
10
ModySe

ModySe

55  



:







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

ModySe





Jul 2018
136264
17
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
17
No Server
Male
10
ModySe

ModySe

55  



:








« | »

: 1 (0 1 )
 




04:20 PM.

@ @ @ MultiMedia @ @ @ 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 ) @ || WWE @ Vsro @ Rusro @ [ Private-SRO ] @ ZSZC & Aurora @ Sbot @ Mbot @ V.I.P Zone @ VIP @ VIP @ [ PK2 Edit ] @ Mysro @ | WWE @ @ @ @ 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 @ WrestleMania 33 @ 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 @ silkroad classic @ 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 Road 15D @ Chaos II Online @ Fallen Soul @ StarLife Online @ Xian @ Xian @ Revira online @ Elite SRO @ @ 2018 @ Silkroad life @ Bcsro Online @ Magician Online @ Unix sro @ Immortal SRO @ VehallaSro 11D @ Justice Online @ Deco Online @ Deco Online @ Deco Online @ Deco Online @ Deco Online @ Deco Online @ TheDragonSro Online @ AlieenSro @ Venus Online @ [English - Arabic - Vedio's] @


- - -

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2018, vBulletin Solutions, Inc.