lin_UpdateSocialityEx

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

IF EXISTS(SELECT name FROM sysobjects WHERE name = N'user_sociality_ex' AND xtype='U')
	DROP TABLE [dbo].[user_sociality_ex]
GO

IF EXISTS(SELECT name FROM sysobjects WHERE name = N'user_navit' AND xtype='U')
	DROP TABLE [dbo].[user_navit]
GO

CREATE TABLE [dbo].[user_sociality_ex](
	[char_id] [int] NOT NULL,
	[suffrage] [int] NOT NULL,
	[bonus_duration] [int] NOT NULL,
	[last_bonus_time] [datetime] NOT NULL
 CONSTRAINT [PK_user_navit] PRIMARY KEY CLUSTERED
(
	[char_id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

INSERT INTO [user_sociality_ex] ( char_id, suffrage, bonus_duration, last_bonus_time )
SELECT char_id, 20, 3600, DATEADD( day, -1, GETDATE() ) FROM [user_data] WHERE [account_id] > 0
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[user_navit](
	[char_id] [int] NOT NULL,
	[navit_points] [int] NOT NULL,
	[activate_time] [int] NOT NULL,
	[duration] [int] NOT NULL,
	[bonus_duration] [int] NOT NULL,
 CONSTRAINT [PK_user_navit_1] PRIMARY KEY CLUSTERED
(
	[char_id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[lin_LoadSocialityEx]') AND type in (N'P', N'PC'))
  DROP PROCEDURE [dbo].[lin_LoadSocialityEx]
GO

CREATE PROCEDURE [dbo].[lin_LoadSocialityEx]
(
 @char_id INT
)
AS

SET NOCOUNT ON

IF EXISTS(SELECT  * FROM user_sociality_ex WHERE char_id = @char_id)
BEGIN
	SELECT  suffrage, bonus_duration,convert(nvarchar(19), last_bonus_time, 121) FROM user_sociality_ex WHERE char_id = @char_id
END
ELSE
BEGIN
	SELECT  0, 3600,'1900-00-00 00:00:00'
END
GO



IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[lin_UpdateSocialityEx]') AND type in (N'P', N'PC'))
  DROP PROCEDURE [dbo].[lin_UpdateSocialityEx]
GO

CREATE PROCEDURE [dbo].[lin_UpdateSocialityEx]
(
 @char_id INT,
 @suffrage INT,
 @bonus_duration INT,
 @last_bonus_time DATETIME
)
AS

SET NOCOUNT ON

IF EXISTS(SELECT  * FROM user_sociality_ex WHERE char_id = @char_id)
BEGIN
	UPDATE user_sociality_ex SET suffrage = @suffrage, bonus_duration = @bonus_duration, last_bonus_time = @last_bonus_time  WHERE char_id = @char_id
END
ELSE
BEGIN
	INSERT INTO user_sociality_ex (char_id,suffrage,bonus_duration,last_bonus_time) VALUES (@char_id,@suffrage,@bonus_duration,@last_bonus_time)
END
GO

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[lin_LoadNavit]') AND type in (N'P', N'PC'))
  DROP PROCEDURE [dbo].[lin_LoadNavit]
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[lin_LoadNavit]
(
 @char_id INT
)
AS

SET NOCOUNT ON

IF EXISTS(SELECT  * FROM user_navit WHERE char_id = @char_id)
BEGIN
	SELECT  navit_points, activate_time, duration, bonus_duration FROM user_navit WHERE char_id = @char_id
END
ELSE
BEGIN
	SELECT  0, 0,-1,-1
END
GO

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[lin_UpdateNavit]') AND type in (N'P', N'PC'))
  DROP PROCEDURE [dbo].[lin_UpdateNavit]
GO

CREATE PROCEDURE [dbo].[lin_UpdateNavit]
(
 @char_id INT,
 @points INT,
 @activate_time INT,
 @duration INT,
 @bonus_duration INT
)
AS

SET NOCOUNT ON

IF EXISTS(SELECT  * FROM user_navit WHERE char_id = @char_id)
BEGIN
	UPDATE user_navit SET navit_points = @points, activate_time = @activate_time, duration =  @duration, bonus_duration = @bonus_duration WHERE char_id = @char_id
END
ELSE
BEGIN
	INSERT INTO user_navit (char_id,navit_points,activate_time,duration,bonus_duration) VALUES (@char_id,@points,@activate_time,@duration,@bonus_duration)
END
GO