sphandler.h

来自「国外网游源码....除工具源码缺少之外,其余程序都全...至于,什么游戏,因为国」· C头文件 代码 · 共 690 行 · 第 1/2 页

#ifndef __SPHANDLER_H
#define __SPHANDLER_H

#define SPLOG			"./sp_log.txt"

/********************************************************************

		肺拿辑滚 牢刘虐 掘扁(付胶磐辑滚 啊悼矫, 肺拿辑滚 立加矫)

CREATE PROCEDURE [DBO].[SAGetServerAuthor]
	@IDX			bigint,
	@PORT			smallint,
	@IP				varchar(15)
AS
SET NOCOUNT ON

update SAServer set sas_remote_ip=@IP, sas_port=@PORT where sas_idx=@IDX

select sas_idx, sas_auth_size, sas_auth_index, sas_auth_code
from SAServer
where sas_idx=@IDX

GO

/********************************************************************/

/********************************************************************

			肺拿辑滚 府胶飘沥焊 掘扁(付胶磐辑滚 啊悼矫)

CREATE PROCEDURE [DBO].[SAGetServerInfo]
	@ID as varchar(32),
	@GROUP as varchar(32)
AS
SET NOCOUNT ON

select sas_idx, sas_type, sas_name, sas_mode
from SAServer
where sas_id=@ID and sas_group=@GROUP

GO

/********************************************************************/

/********************************************************************

		肺拿辑滚 牢郸胶沥焊 掘扁(付胶磐辑滚 啊悼矫:可历滚DB)

CREATE PROCEDURE [DBO].[MCGetServerIndex]
	@IP				varchar(15),
	@ID				varchar(32),
	@GROUP			varchar(32)
AS
SET NOCOUNT ON

update MCServer set mcs_remote_ip=@IP, mcs_update_time=getdate() where mcs_type='MASTERSERVER'
select mcs_idx from MCServer where mcs_id=@ID and mcs_group=@GROUP

GO

/********************************************************************/

/********************************************************************

		肺拿辑滚 立加困摹 盎脚(肺拿辑滚 立加矫:可历滚DB)

CREATE PROCEDURE [DBO].[MCSetServerLogin]
	@IDX			bigint,
	@IP				varchar(15)
AS
SET NOCOUNT ON

update MCServer set mcs_remote_ip=@IP, mcs_update_time=getdate() where mcs_idx=@IDX

GO

/********************************************************************/

/********************************************************************

			蜡历 扁夯沥焊(蜡历 立加且锭 佬绢辑 酒捞叼厚背)

CREATE PROCEDURE [DBO].[SAGetUserInfo]
	@ID		varchar(16)
AS
SET NOCOUNT ON

select sau_idx, sau_id, sau_pwd, sau_nick, sau_gender
from SAUser
where sau_id=@ID

GO

/********************************************************************/

/********************************************************************

			蜡历 霸烙沥焊(蜡历 立加矫 蜡历 扁夯沥焊 罐篮 饶)

CREATE PROCEDURE [DBO].[SAGetGameInfo]
	@IDX	bigint
AS
SET NOCOUNT ON

if not exists(select * from SAGame where sag_idx=@IDX)
begin
	insert into SAGame(sag_idx) values(@IDX)
end

select sag_idx, sag_clan, sag_pilot, sag_level, sag_exp, sag_mechanic1, sag_mechanic2, sag_mechanic3,
sag_cash, sag_point, sag_best_point, sag_best_straight, sag_win_straight, sag_win, sag_lose,
sag_kill, sag_death, sag_rank, sag_quit, sag_black, sag_server
from SAGame
where sag_idx=@IDX

GO

/********************************************************************/

/********************************************************************

			蜡历 酒捞袍沥焊(蜡历 立加矫 蜡历 霸烙沥焊 罐篮 饶)

CREATE PROCEDURE [DBO].[SAGetItemInfo]
	@IDX	bigint
AS
SET NOCOUNT ON

if not exists(select * from SAItem where sai_idx=@IDX)
begin
	insert into SAItem(sai_idx) values(@IDX)
end

select sai_idx, sai_slot1, sai_slot2, sai_slot3, sai_slot4, sai_slot5, sai_slot6, sai_slot7, sai_slot8, sai_slot9, sai_slot10,
sai_slot11, sai_slot12, sai_slot13, sai_slot14, sai_slot15, sai_slot16, sai_slot17, sai_slot18, sai_slot19, sai_slot20,
sai_slot21, sai_slot22, sai_slot23, sai_slot24, sai_slot25, sai_slot26, sai_slot27, sai_slot28, sai_slot29, sai_slot30,
sai_slot31, sai_slot32, sai_slot33, sai_slot34, sai_slot35, sai_slot36, sai_slot37, sai_slot38, sai_slot39, sai_slot40,
sai_slot41, sai_slot42, sai_slot43, sai_slot44, sai_slot45, sai_slot46, sai_slot47, sai_slot48, sai_slot49, sai_slot50,
sai_slot51, sai_slot52, sai_slot53, sai_slot54, sai_slot55, sai_slot56, sai_slot57, sai_slot58, sai_slot59, sai_slot60
from SAItem
where sai_idx=@IDX

GO

/********************************************************************/

/********************************************************************

		蜡历 皋墨葱沥焊(蜡历 立加矫 蜡历 酒捞袍沥焊 罐篮 饶)

CREATE PROCEDURE [DBO].[SAGetMechanicInfo]
	@IDX	bigint
AS
SET NOCOUNT ON

if not exists(select * from SAMechanic where sam_useridx=@IDX)
begin
	insert into SAMechanic(sam_useridx)	values(@IDX)

	update SAGame set sag_mechanic1 = b.sam_idx
	from SAGame a, SAMechanic b
	where a.sag_idx = @IDX and b.sam_useridx = @IDX
end

select sam_idx, sam_id, sam_fight, sam_dur, sam_skin, sam_color,
sam_main_slot, sam_sub_slot, sam_back_slot1, sam_back_slot2, sam_back_slot3
from SAMechanic
where sam_useridx=@IDX

GO

/********************************************************************/

/********************************************************************

			蜡历 肺弊牢沥焊 眠啊(橇府哩抛捞记 侩)

CREATE PROCEDURE [DBO].[SAAddUserInfo]
	@ID			varchar(16),
	@PWD		varchar(16),
	@NICK		varchar(16),
	@GENDER		tinyint
AS
SET NOCOUNT ON

insert into SAUser(sau_id, sau_pwd, sau_nick, sau_gender)
values(@ID, @PWD, @NICK, @GENDER)

select sau_idx, sau_id, sau_pwd, sau_nick, sau_gender
from SAUser
where sau_id=@ID

GO

/********************************************************************/

/********************************************************************

			蜡历 立加困摹 盎脚(付胶磐辑滚俊 蜡历 立加矫)

CREATE PROCEDURE [DBO].[SASetGameLogin]
	@IDX			bigint,
	@IP1			varchar(15),
	@IP2			varchar(15)
AS
SET NOCOUNT ON

update SAGame set sag_remote_ip=@IP1, sag_private_ip=@IP2, sag_server=0 where sag_idx=@IDX

GO

/********************************************************************/

/********************************************************************

			蜡历 霸烙困摹 盎脚(肺厚辑滚俊 蜡历 立加矫)

CREATE PROCEDURE [DBO].[SASetGamePosition]
	@IDX			bigint,
	@SERVER			bigint
AS
SET NOCOUNT ON

update SAGame set sag_server=@SERVER where sag_idx=@IDX

GO

/********************************************************************/

/********************************************************************

					蜡历 肺弊酒眶盎脚

CREATE PROCEDURE [DBO].[SASetGameLogout]
	@IDX			bigint
AS
SET NOCOUNT ON

update SAGame set sag_server=0, sag_update_time=getdate() where sag_idx=@IDX

GO

/********************************************************************/

/********************************************************************

				蜡历 霸烙搬苞 历厘

CREATE PROCEDURE [DBO].[SASetGameResult]
	@IDX			bigint,
	@MECHANIC		bigint,
	@LEVEL			tinyint,
	@EXP			bigint,
	@POINT			smallint,
	@KILL			tinyint,
	@DEATH			tinyint,
	@WIN			tinyint,
	@QUIT			tinyint,
	@INCREASE		tinyint,
	@MAIN_SLOT		varchar(2),
	@MAIN_ITEM		varchar(15),
	@SUB_SLOT		varchar(2),
	@SUB_ITEM		varchar(15),
	@BACK1_SLOT		varchar(2),
	@BACK1_ITEM		varchar(15),
	@BACK2_SLOT		varchar(2),
	@BACK2_ITEM		varchar(15),
	@BACK3_SLOT		varchar(2),
	@BACK3_ITEM		varchar(15)
AS
SET NOCOUNT ON

declare @param		nvarchar(256)
set @param='@outIdx bigint output'
declare @sql 		nvarchar(512)
set @sql='update SAItem set ' +
case when @MAIN_SLOT='0' then '' else 'sai_slot' + @MAIN_SLOT + '=''' + @MAIN_ITEM + ''', ' end +
case when @SUB_SLOT='0' then '' else 'sai_slot' + @SUB_SLOT + '=''' + @SUB_ITEM + ''', ' end +
case when @BACK1_SLOT='0' then '' else 'sai_slot' + @BACK1_SLOT + '=''' + @BACK1_ITEM + ''', ' end +
case when @BACK2_SLOT='0' then '' else 'sai_slot' + @BACK2_SLOT + '=''' + @BACK2_ITEM + ''', ' end +
case when @BACK3_SLOT='0' then '' else 'sai_slot' + @BACK3_SLOT + '=''' + @BACK3_ITEM + ''', ' end +
'sai_update_time=getdate() where sai_idx=@outIdx'

exec sp_executesql @sql, @param, @outIdx=@IDX output

if(@WIN=1)
begin
	update SAGame
	set sag_level=@LEVEL, sag_exp=@EXP, sag_kill=sag_kill+(@KILL), sag_death=sag_death+(@DEATH),
	sag_point = case when @INCREASE=1 then sag_point+(@POINT) else sag_point-(@POINT) end,
	sag_best_point = case when @INCREASE=1 then
					case when sag_best_point>@POINT then sag_best_point else @POINT end
					else sag_best_point end,
	sag_best_straight = case when sag_best_straight>sag_win_straight+(1) then sag_best_straight else sag_win_straight+(1) end,
	sag_win_straight=sag_win_straight+(1), sag_win=sag_win+(1), sag_update_time=getdate()
	where sag_idx=@IDX
end
else
begin
	update SAGame
	set sag_level=@LEVEL, sag_exp=@EXP, sag_kill=sag_kill+(@KILL), sag_death=sag_death+(@DEATH),
	sag_point = case when @INCREASE=1 then sag_point+(@POINT) else sag_point-(@POINT) end,
	sag_best_point = case when @INCREASE=1 then
					case when sag_best_point>@POINT then sag_best_point else @POINT end
					else sag_best_point end,
	sag_quit = case when @QUIT=1 then sag_quit+(1) else sag_quit end,
	sag_win_straight=0, sag_lose=sag_lose+(1), sag_update_time=getdate()
	where sag_idx=@IDX
end

update SAMechanic
set sam_dur=case when sam_dur>@DEATH then sam_dur-(@DEATH) else 0 end,
sam_main_slot = case when @MAIN_SLOT='0' or @MAIN_ITEM='' then 0 else sam_main_slot end,
sam_sub_slot = case when @SUB_SLOT='0' or @SUB_ITEM='' then 0 else sam_sub_slot end,
sam_back_slot1 = case when @BACK1_SLOT='0' or @BACK1_ITEM='' then 0 else sam_back_slot1 end,
sam_back_slot2 = case when @BACK2_SLOT='0' or @BACK2_ITEM='' then 0 else sam_back_slot2 end,
sam_back_slot3 = case when @BACK3_SLOT='0' or @BACK3_ITEM='' then 0 else sam_back_slot3 end,
sam_fight=sam_fight+(1), sam_update_time=getdate()
where sam_idx=@MECHANIC

GO

/********************************************************************/

/********************************************************************

				酒捞袍 备涝

CREATE PROCEDURE [DBO].[SASetItemBuy]
	@IDX			bigint,
	@INVENSLOT		varchar(2),
	@ITEM			varchar(15),
	@CASH			bigint,
	@POINT			bigint
AS
SET NOCOUNT ON

declare @param		nvarchar(256)
set @param='@outIdx bigint output'
declare @sql 		nvarchar(256)
set @sql='update SAItem set sai_slot' + @INVENSLOT + '=''' + @ITEM + ''' where sai_idx=@outIdx'

exec sp_executesql @sql, @param, @outIdx=@IDX output

update SAGame set sag_buy=sag_buy+(1), sag_cash=@CASH, sag_point=@POINT WHERE sag_idx=@IDX