DB Problem

[Burdenz2007]

CHARACTER_01_DBF.dbo.LoadSiegeRanking('01')

anyone has a DB Code for that? Thank you in advance.

[- DK]

FFA or Deathmatch or something like that ? Tell me exactly what you need ^^

[xRageee]

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]
@dex char(2)
as
set nocount on
set xact_abort on

select szName, idPlayer, nJob, nKills, nDeaths, nPoints
from PlayerWar_TBL
where serverindex = @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]
@dex char(2),
@ame char(32),
@idPlayer char(7),
@b int,
@nPoints int,
@lls int,
@s int
as
set nocount on
set xact_abort on

if not exists( select * from PlayerWar_TBL where idPlayer = @idPlayer and serverindex = @dex)
begin
insert PlayerWar_TBL ( serverindex, szName, idPlayer, nJob, nPoints, nKills, nDeaths )
values @dex, @ame, @idPlayer, @b, @nPoints, @lls, @s )
end
else
begin
update PlayerWar_TBL
set serverindex = @dex,
szName = @ame,
idPlayer = @idPlayer,
nJob = @b,
nPoints = @nPoints,
nKills = @lls,
nDeaths = @s
where serverindex = @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

[Burdenz2007]

Originally Posted by DK ACE

FFA or Deathmatch or something like that ? Tell me exactly what you need ^^

Actually both. ^^

Originally Posted by xRageee

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]
@dex char(2)
as
set nocount on
set xact_abort on

select szName, idPlayer, nJob, nKills, nDeaths, nPoints
from PlayerWar_TBL
where serverindex = @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]
@dex char(2),
@ame char(32),
@idPlayer char(7),
@b int,
@nPoints int,
@lls int,
@s int
as
set nocount on
set xact_abort on

if not exists( select * from PlayerWar_TBL where idPlayer = @idPlayer and serverindex = @dex)
begin
insert PlayerWar_TBL ( serverindex, szName, idPlayer, nJob, nPoints, nKills, nDeaths )
values @dex, @ame, @idPlayer, @b, @nPoints, @lls, @s )
end
else
begin
update PlayerWar_TBL
set serverindex = @dex,
szName = @ame,
idPlayer = @idPlayer,
nJob = @b,
nPoints = @nPoints,
nKills = @lls,
nDeaths = @s
where serverindex = @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

I will try this DB Code after work. Thank you in advance.