SroPedia
Casper 4Gold

    Silkroad Online

Asfor 4Gold

 20/11/2016

 25/06/2018

 17/09/2018

 19/09/2018

 22/10/2018

 22/10/2018

 1/11/2017

 1/11/2017

 1/11/2017

Casper 4Gold

QueenSro

END11/10/2017

vps services

  [ ] | | 21/9/2017 




   Silkroad Online > >

[ ] [ ]


         :: []  ( :Neoon)       ::  vps ( :Tips007)       ::  ( :mido_1010)       ::  fun  ( :QueenSupport)       ::   ( :QueenSupport)       ::  FGW ( :F77)       ::  quere add uinq spot ( :Spicoo)       :: Destroy Windows spying and exploits ( :TheBold)       :: FGW ( :HB#)       ::  01112124913 (( )) 0235700997 +  ( :)       ::  _ 01112124913 (( )) 0235700994  ( :)       ::  01112124913 0235700994  ( :)       ::  01112124913 ( ) 0235700994 +  ( :)       ::  01092279973 ^^ ^^ 0235700994  ( :)       ::  01112124913 || || 0235700997  ( :)       ::  01112124913 & & 0235700997  ( :)       ::  01220261030 (( )) 0235700994  ( :)       ::  01092279973 @ @ 0235700994  ( :)       ::  01112124913 // // 0235700994  ( :)       ::  01112124913 (( )) 0235700994  ( :)       ::  01112124913 0235700997  ( :)       ::  01220261030 0235700997  ( :)       ::  01112124913 0235700994 sharp ( :)       ::  @ 01112124913 0235700994  ( :)       :: [ ] iBot ( :Neoon)      

 
25-09-2017, 03:30 PM   #1

HB#



  HB#


Jul 2017
133179
229
Daquhlia - Mansoura
Private Server
Male
10
HB#

HB#

316  


   Yahoo  HB#

(20) PVP Recorder Table





pvp rank table ... table pvp .. table ID kills deaths pvp ... :

: table pvp :

 
USE [SRO_VT_SHARDLOG]
GO

/****** Object:  Table [dbo].[_CharactersKillsRecord]    Script Date: 9/25/2017 2:21:52 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[_CharactersKillsRecord](
	[CharName] [varchar](max) NOT NULL,
	[CharID] [int] NOT NULL,
	[Kills] [int] NOT NULL,
	[Deaths] [int] NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO 
: SRO_VT_SHARDLOG >>> Programmability >> Stored Procedures >> _AddLogChar :

 
--Characters kills table recorder , all credits goes to #HB
	declare @LoserCharName varchar(max)
	declare @WinnerCharName varchar(max)
	declare @WinnerCharID varchar(max)
	declare @TableCheckKiller varchar(max)
		declare @TableCheckKilled varchar(max)
	set @LoserCharName = (select CharName16 from [SRO_VT_SHARD].dbo._Char where CharID = @CharID)
	
	IF (@EventID = 20) 
	begin
	Select  @Desc = REPLACE(@Desc, LEFT(@Desc, CHARINDEX('(', @Desc)),'')
	 Select  @Desc = REPLACE(@Desc, RIGHT(@Desc, CHARINDEX(')', REVERSE(@Desc))),'')
	 set @WinnerCharName = @Desc
	 set @WinnerCharID = (select CharID from [SRO_VT_SHARD].dbo._Char where CharName16 = @WinnerCharName)
	 set @TableCheckKiller = (Select CharName from _CharactersKillsRecord where CharID = @WinnerCharID)
	 set @TableCheckKilled = (select CharName from _CharactersKillsRecord where CharID = @CharID)
		IF (@TableCheckKiller is NULL) and (@TableCheckKilled is NULL)
		begin
			 	INSERT INTO _CharactersKillsRecord (CharName,CharID,Kills,Deaths) values (@WinnerCharName,@WinnerCharID,'1','0')
	INSERT INTO _CharactersKillsRecord (CharName,CharID,Kills,Deaths) values (@LoserCharName,@CharID,'0','1')
	end
	delete from _LogEventChar where CharID = @CharID
	end

		IF (@EventID = 20) 
	begin
	Select  @Desc = REPLACE(@Desc, LEFT(@Desc, CHARINDEX('(', @Desc)),'')
	 Select  @Desc = REPLACE(@Desc, RIGHT(@Desc, CHARINDEX(')', REVERSE(@Desc))),'')
	 set @WinnerCharName = @Desc
	 set @WinnerCharID = (select CharID from [SRO_VT_SHARD].dbo._Char where CharName16 = @WinnerCharName)
	 set @TableCheckKiller = (Select CharName from _CharactersKillsRecord where CharID = @WinnerCharID)
	 set @TableCheckKilled = (select CharName from _CharactersKillsRecord where CharID = @CharID)
		IF (@TableCheckKiller is not null) and (@TableCheckKilled is not NULL)
		begin
			 	UPDATE _CharactersKillsRecord set Kills = Kills + '1' where CharName = @WinnerCharName
	UPDATE _CharactersKillsRecord set Deaths = Deaths + '1' where CharName = @LoserCharName
	end
	delete from _LogEventChar where CharID = @CharID
	end

			IF (@EventID = 20) 
	begin
	Select  @Desc = REPLACE(@Desc, LEFT(@Desc, CHARINDEX('(', @Desc)),'')
	 Select  @Desc = REPLACE(@Desc, RIGHT(@Desc, CHARINDEX(')', REVERSE(@Desc))),'')
	 set @WinnerCharName = @Desc
	 set @WinnerCharID = (select CharID from [SRO_VT_SHARD].dbo._Char where CharName16 = @WinnerCharName)
	 set @TableCheckKiller = (Select CharName from _CharactersKillsRecord where CharID = @WinnerCharID)
	 set @TableCheckKilled = (select CharName from _CharactersKillsRecord where CharID = @CharID)
		IF (@TableCheckKiller is null) and (@TableCheckKilled is not NULL)
		begin
			 	INSERT INTO _CharactersKillsRecord (CharName,CharID,Kills,Deaths) values (@WinnerCharName,@WinnerCharID,'1','0')
	UPDATE _CharactersKillsRecord set Deaths = Deaths + '1' where CharName = @LoserCharName
	end
	delete from _LogEventChar where CharID = @CharID
	end

				IF (@EventID = 20) 
	begin
	Select  @Desc = REPLACE(@Desc, LEFT(@Desc, CHARINDEX('(', @Desc)),'')
	 Select  @Desc = REPLACE(@Desc, RIGHT(@Desc, CHARINDEX(')', REVERSE(@Desc))),'')
	 set @WinnerCharName = @Desc
	 set @WinnerCharID = (select CharID from [SRO_VT_SHARD].dbo._Char where CharName16 = @WinnerCharName)
	 set @TableCheckKiller = (Select CharName from _CharactersKillsRecord where CharID = @WinnerCharID)
	 set @TableCheckKilled = (select CharName from _CharactersKillsRecord where CharID = @CharID)
		IF (@TableCheckKiller is not null) and (@TableCheckKilled is NULL)
		begin
			 	UPDATE _CharactersKillsRecord set Kills = Kills + '1' where CharName = @WinnerCharName
	INSERT INTO _CharactersKillsRecord (CharName,CharID,Kills,Deaths) values (@LoserCharName,@CharID,'0','1')
	end
	delete from _LogEventChar where CharID = @CharID
	end
	--Character kills table recorder (finish) , all credits goes to #HB 
pvp table SRO_VT_SHARDLOG reset table :

 
USE [SRO_VT_SHARDLOG]
UPDATE _CharactersKillsRecord Set Kills = '0' , Deaths = '0' 


HB# :
PVPERZ-REBORN
:LOL
Server : EUNE
Solo&Duo: Gold V
Flex : Gold IV
Nickname : GearFourth

HB# ; 02-10-2017 03:17 PM

26-09-2017, 07:45 PM   #2

Hamza FiGo


ChaosRoad Owner

  Hamza FiGo


Dec 2007
6993
30,009
Cairo
Helping ppl
Private Server
Male
966
Hamza FiGo  Hamza FiGo  Hamza FiGo  Hamza FiGo  Hamza FiGo  Hamza FiGo  Hamza FiGo  Hamza FiGo

Hamza FiGo

11076  


   Yahoo  Hamza FiGo    Skype  Hamza FiGo

: PVP Recorder Table





Hamza FiGo :

|| ||


26-09-2017, 11:09 PM   #3

HB#



  HB#


Jul 2017
133179
229
Daquhlia - Mansoura
Private Server
Male
10
HB#

HB#

316  


   Yahoo  HB#

: PVP Recorder Table



Hamza FiGo


HB# :
PVPERZ-REBORN
:LOL
Server : EUNE
Solo&Duo: Gold V
Flex : Gold IV
Nickname : GearFourth


27-09-2017, 09:35 PM   #4

Destructions





Aug 2017
133321
207
No Server
Male
10
Destructions

Destructions

446  



: PVP Recorder Table



PHP




27-09-2017, 10:22 PM   #5

HB#



  HB#


Jul 2017
133179
229
Daquhlia - Mansoura
Private Server
Male
10
HB#

HB#

316  


   Yahoo  HB#

: PVP Recorder Table



Destructions
PHP
table pvp


HB# :
PVPERZ-REBORN
:LOL
Server : EUNE
Solo&Duo: Gold V
Flex : Gold IV
Nickname : GearFourth


28-09-2017, 11:29 PM   #6

EgY_KhaN


E g y Em pire

   EgY_KhaN


Aug 2012
103935
1,341
Mansoura
Love the Destruction
Private Server
Male
50
 EgY_KhaN

 EgY_KhaN

6070  


   Yahoo   EgY_KhaN    Skype   EgY_KhaN

   
: 1

: PVP Recorder Table





EgY_KhaN :

EgY_KhaN is There !



29-09-2017, 12:02 AM   #7

Neoon



  Neoon


Mar 2015
121247
3,221
~ ~
No Server
Male
97
Neoon

Neoon

2294  




   
: 1

: PVP Recorder Table



,


" " " "


Neoon :








-




[ ]



29-09-2017, 04:29 PM   #8

HB#



  HB#


Jul 2017
133179
229
Daquhlia - Mansoura
Private Server
Male
10
HB#

HB#

316  


   Yahoo  HB#

: PVP Recorder Table



EgY_KhaN


Iron.Man
,

" " " "


HB# :
PVPERZ-REBORN
:LOL
Server : EUNE
Solo&Duo: Gold V
Flex : Gold IV
Nickname : GearFourth

HB# ; 29-09-2017 04:34 PM

06-10-2017, 01:45 PM   #9

GM_Jo





Sep 2015
126132
346
Giza
Private Server
Male
13
GM_Jo

GM_Jo

438  



: PVP Recorder Table









06-10-2017, 02:19 PM   #10

HB#



  HB#


Jul 2017
133179
229
Daquhlia - Mansoura
Private Server
Male
10
HB#

HB#

316  


   Yahoo  HB#

: PVP Recorder Table



GM_Jo


...


HB# :
PVPERZ-REBORN
:LOL
Server : EUNE
Solo&Duo: Gold V
Flex : Gold IV
Nickname : GearFourth


13-10-2017, 11:25 AM   #11

Helper4You



  Helper4You


Nov 2016
131540
1,296
Lyra
Male
25
Helper4You

Helper4You

6748  


   ICQ  Helper4You    AIM  Helper4You    Yahoo  Helper4You    Skype  Helper4You

: PVP Recorder Table





Helper4You :

.
.
.
! .
.

.. .
.
.


13-10-2017, 02:56 PM   #12

HB#



  HB#


Jul 2017
133179
229
Daquhlia - Mansoura
Private Server
Male
10
HB#

HB#

316  


   Yahoo  HB#

: PVP Recorder Table





HB# :
PVPERZ-REBORN
:LOL
Server : EUNE
Solo&Duo: Gold V
Flex : Gold IV
Nickname : GearFourth


17-10-2017, 07:45 PM   #13

Erixon



  Erixon


Apr 2017
132672
201
Qena
Developermnt & Designs
Private Server
Male
10
Erixon

Erixon

241  



: PVP Recorder Table



good work


Erixon :
..


18-10-2017, 12:51 AM   #14

HB#



  HB#


Jul 2017
133179
229
Daquhlia - Mansoura
Private Server
Male
10
HB#

HB#

316  


   Yahoo  HB#

: PVP Recorder Table





HB# :
PVPERZ-REBORN
:LOL
Server : EUNE
Solo&Duo: Gold V
Flex : Gold IV
Nickname : GearFourth



« | »

: 1 (0 1 )
 






[ : | ]

@ @ @ @ @ @ 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 @ | 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 @ @ @ @ @ @ @ @ DarkWorldSro @ @ 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 @ Elamidas @ 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 @ Eternal-Online @ 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 @ Hector Network @ Vehalla-Sro D11 @ Revira online @ ClashSRO @ Metal Road @ Hogwarts - online D11 @ Aqua Sro @ Elite SRO @ @


- - -

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