CHARACTER_01_DBF.dbo.LoadSiegeRanking('01')
anyone has a DB Code for that? Thank you in advance.
anyone has a DB Code for that? Thank you in advance.
DB Problem
09/28/2017 18:48
Burdenz2007#1
09/28/2017 20:11
- DK#2
FFA or Deathmatch or something like that ? Tell me exactly what you need ^^
09/28/2017 23:13
xRageee#3
USE [CHARACTER_01_DBF]
GO
/****** Object: StoredProcedure [dbo].[LoadSiegeRanking] Script Date: 06/01/2014 22:02:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE proc [dbo].[LoadSiegeRanking]
@[Only registered and activated users can see links. Click Here To Register...]dex char(2)
as
set nocount on
set xact_abort on
select szName, idPlayer, nJob, nKills, nDeaths, nPoints
from PlayerWar_TBL
where serverindex = @[Only registered and activated users can see links. Click Here To Register...]dex
return
GO
/****** Object: StoredProcedure [dbo].[uspSaveSiegeUser] Script Date: 06/01/2014 22:02:17 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
create proc [dbo].[uspSaveSiegeUser]
@[Only registered and activated users can see links. Click Here To Register...]dex char(2),
@[Only registered and activated users can see links. Click Here To Register...]ame char(32),
@idPlayer char(7),
@[Only registered and activated users can see links. Click Here To Register...]b int,
@nPoints int,
@[Only registered and activated users can see links. Click Here To Register...]lls int,
@[Only registered and activated users can see links. Click Here To Register...]s int
as
set nocount on
set xact_abort on
if not exists( select * from PlayerWar_TBL where idPlayer = @idPlayer and serverindex = @[Only registered and activated users can see links. Click Here To Register...]dex)
begin
insert PlayerWar_TBL ( serverindex, szName, idPlayer, nJob, nPoints, nKills, nDeaths )
values @[Only registered and activated users can see links. Click Here To Register...]dex, @[Only registered and activated users can see links. Click Here To Register...]ame, @idPlayer, @[Only registered and activated users can see links. Click Here To Register...]b, @nPoints, @[Only registered and activated users can see links. Click Here To Register...]lls, @[Only registered and activated users can see links. Click Here To Register...]s )
end
else
begin
update PlayerWar_TBL
set serverindex = @[Only registered and activated users can see links. Click Here To Register...]dex,
szName = @[Only registered and activated users can see links. Click Here To Register...]ame,
idPlayer = @idPlayer,
nJob = @[Only registered and activated users can see links. Click Here To Register...]b,
nPoints = @nPoints,
nKills = @[Only registered and activated users can see links. Click Here To Register...]lls,
nDeaths = @[Only registered and activated users can see links. Click Here To Register...]s
where serverindex = @[Only registered and activated users can see links. Click Here To Register...]dex
and idPlayer = @idPlayer
end
GO
/****** Object: Table [dbo].[PlayerWar_TBL] Script Date: 06/01/2014 22:02:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[PlayerWar_TBL](
[serverindex] [char](2) COLLATE Latin1_General_CI_AS NULL,
[szName] [varchar](32) COLLATE Latin1_General_CI_AS NULL,
[idPlayer] [char](7) COLLATE Latin1_General_CI_AS NULL,
[nJob] [int] NULL,
[nKills] [int] NULL,
[nDeaths] [int] NULL,
[nPoints] [int] NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: StoredProcedure [dbo].[LoadSiegeRanking] Script Date: 06/01/2014 22:02:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE proc [dbo].[LoadSiegeRanking]
@[Only registered and activated users can see links. Click Here To Register...]dex char(2)
as
set nocount on
set xact_abort on
select szName, idPlayer, nJob, nKills, nDeaths, nPoints
from PlayerWar_TBL
where serverindex = @[Only registered and activated users can see links. Click Here To Register...]dex
return
GO
/****** Object: StoredProcedure [dbo].[uspSaveSiegeUser] Script Date: 06/01/2014 22:02:17 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
create proc [dbo].[uspSaveSiegeUser]
@[Only registered and activated users can see links. Click Here To Register...]dex char(2),
@[Only registered and activated users can see links. Click Here To Register...]ame char(32),
@idPlayer char(7),
@[Only registered and activated users can see links. Click Here To Register...]b int,
@nPoints int,
@[Only registered and activated users can see links. Click Here To Register...]lls int,
@[Only registered and activated users can see links. Click Here To Register...]s int
as
set nocount on
set xact_abort on
if not exists( select * from PlayerWar_TBL where idPlayer = @idPlayer and serverindex = @[Only registered and activated users can see links. Click Here To Register...]dex)
begin
insert PlayerWar_TBL ( serverindex, szName, idPlayer, nJob, nPoints, nKills, nDeaths )
values @[Only registered and activated users can see links. Click Here To Register...]dex, @[Only registered and activated users can see links. Click Here To Register...]ame, @idPlayer, @[Only registered and activated users can see links. Click Here To Register...]b, @nPoints, @[Only registered and activated users can see links. Click Here To Register...]lls, @[Only registered and activated users can see links. Click Here To Register...]s )
end
else
begin
update PlayerWar_TBL
set serverindex = @[Only registered and activated users can see links. Click Here To Register...]dex,
szName = @[Only registered and activated users can see links. Click Here To Register...]ame,
idPlayer = @idPlayer,
nJob = @[Only registered and activated users can see links. Click Here To Register...]b,
nPoints = @nPoints,
nKills = @[Only registered and activated users can see links. Click Here To Register...]lls,
nDeaths = @[Only registered and activated users can see links. Click Here To Register...]s
where serverindex = @[Only registered and activated users can see links. Click Here To Register...]dex
and idPlayer = @idPlayer
end
GO
/****** Object: Table [dbo].[PlayerWar_TBL] Script Date: 06/01/2014 22:02:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[PlayerWar_TBL](
[serverindex] [char](2) COLLATE Latin1_General_CI_AS NULL,
[szName] [varchar](32) COLLATE Latin1_General_CI_AS NULL,
[idPlayer] [char](7) COLLATE Latin1_General_CI_AS NULL,
[nJob] [int] NULL,
[nKills] [int] NULL,
[nDeaths] [int] NULL,
[nPoints] [int] NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
09/29/2017 04:08
Burdenz2007#4
Actually both. ^^Quote:
FFA or Deathmatch or something like that ? Tell me exactly what you need ^^
I will try this DB Code after work. Thank you in advance. :)Quote:
GO
/****** Object: StoredProcedure [dbo].[LoadSiegeRanking] Script Date: 06/01/2014 22:02:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE proc [dbo].[LoadSiegeRanking]
@[Only registered and activated users can see links. Click Here To Register...]dex char(2)
as
set nocount on
set xact_abort on
select szName, idPlayer, nJob, nKills, nDeaths, nPoints
from PlayerWar_TBL
where serverindex = @[Only registered and activated users can see links. Click Here To Register...]dex
return
GO
/****** Object: StoredProcedure [dbo].[uspSaveSiegeUser] Script Date: 06/01/2014 22:02:17 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
create proc [dbo].[uspSaveSiegeUser]
@[Only registered and activated users can see links. Click Here To Register...]dex char(2),
@[Only registered and activated users can see links. Click Here To Register...]ame char(32),
@idPlayer char(7),
@[Only registered and activated users can see links. Click Here To Register...]b int,
@nPoints int,
@[Only registered and activated users can see links. Click Here To Register...]lls int,
@[Only registered and activated users can see links. Click Here To Register...]s int
as
set nocount on
set xact_abort on
if not exists( select * from PlayerWar_TBL where idPlayer = @idPlayer and serverindex = @[Only registered and activated users can see links. Click Here To Register...]dex)
begin
insert PlayerWar_TBL ( serverindex, szName, idPlayer, nJob, nPoints, nKills, nDeaths )
values @[Only registered and activated users can see links. Click Here To Register...]dex, @[Only registered and activated users can see links. Click Here To Register...]ame, @idPlayer, @[Only registered and activated users can see links. Click Here To Register...]b, @nPoints, @[Only registered and activated users can see links. Click Here To Register...]lls, @[Only registered and activated users can see links. Click Here To Register...]s )
end
else
begin
update PlayerWar_TBL
set serverindex = @[Only registered and activated users can see links. Click Here To Register...]dex,
szName = @[Only registered and activated users can see links. Click Here To Register...]ame,
idPlayer = @idPlayer,
nJob = @[Only registered and activated users can see links. Click Here To Register...]b,
nPoints = @nPoints,
nKills = @[Only registered and activated users can see links. Click Here To Register...]lls,
nDeaths = @[Only registered and activated users can see links. Click Here To Register...]s
where serverindex = @[Only registered and activated users can see links. Click Here To Register...]dex
and idPlayer = @idPlayer
end
GO
/****** Object: Table [dbo].[PlayerWar_TBL] Script Date: 06/01/2014 22:02:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[PlayerWar_TBL](
[serverindex] [char](2) COLLATE Latin1_General_CI_AS NULL,
[szName] [varchar](32) COLLATE Latin1_General_CI_AS NULL,
[idPlayer] [char](7) COLLATE Latin1_General_CI_AS NULL,
[nJob] [int] NULL,
[nKills] [int] NULL,
[nDeaths] [int] NULL,
[nPoints] [int] NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF