抛捞喉抛胶飘.sql

Soul的源代码,类似于劲舞团之类的游戏

@OChar as varchar(16) -- _OwnChar
--@ITCT as int, -- _ItemCount ,
--@ITLV as tinyint, -- _ItemLevel
--@ITCS as int, -- _ItemCurSp 
--@CD as int, -- _CurDurability
--@SpFtO as tinyint, -- _SpFtOption
--@SpScO as tinyint, -- _SpScOption 
--@SpTrO as tinyint, -- _SpTrOption 
--@SpFrO as tinyint, -- _SpFrOption 
--@NmFtO as tinyint, -- _NmFtOption 
--@NmScO as tinyint, -- _NmScOption 
--@NMTrO as tinyint -- _NmTrOption 
As
begin tran
insert Item2 values (0,0,0,@OChar,0,0,0,0,0,0,0,0,0,0,0)
if @@Error <> 0
	begin
		rollback tran
	end
else
	begin
		commit tran
	end
go
--drop proc sp_item2In
--exec sp_item2In 'hoon4'
--select * from item2

/*---------------------------------------------------------------------------------------------------------------------------------*/
/*index甫 器窃*/
create table char1
(
_name varchar(16) primary key,
_index1 int, _index2 int, _index3 int, _index4 int, _index5 int, _index6 int, _index7 int,
_index8 int, _index9 int, _index10 int, _index11 int, _index12 int, _index13 int, _index14 int,
_index15 int, _index16 int, _index17 int, _index18 int, _index19 int, _index20 int, _index21 int,
_index22 int, _index23 int, _index24 int, _index25 int, _index26 int, _index27 int, _index28 int,
_index29 int, _index30 int, _index31 int, _index32 int, _index33 int, _index34 int, _index35 int,
_index36 int, _index37 int, _index38 int, _index39 int, _index40 int, _index41 int, _index42 int,
_index43 int, _index44 int, _index45 int, _index46 int, _index47 int, _index48 int, _index49 int,
_index50 int, _index51 int, _index52 int, _index53 int, _index54 int, _index55 int, _index56 int,
_index57 int, _index58 int, _index59 int, _index60 int, _index61 int, _index62 int, _index63 int,
_index64 int, _index65 int, _index66 int, _index67 int, _index68 int, _index69 int, _index70 int,
_index71 int, _index72 int, _index73 int, _index74 int, _index75 int, _index76 int, _index77 int,
_index78 int, _index79 int, _index80 int, _index81 int, _index82 int, _index83 int, _index84 int,
_index85 int, _index86 int, _index87 int, _index88 int, _index89 int, _index90 int, _index91 int,
_index92 int, _index93 int, _index94 int, _index95 int, _index96 int, _index97 int, _index98 int,
_index99 int, _index100 int, _index101 int, _index102 int, _index103 int, _index104 int, _index105 int,
_index106 int, _index107 int, _index108 int, _index109 int, _index110 int, _index111 int, _index112 int,
_index113 int, _index114 int, _index115 int, _index116 int, _index117 int, _index118 int, _index119 int,
_index120 int, _index121 int, _index122 int, _index123 int, _index124 int, _index125 int, _index126 int,
_index127 int, _index128 int, _index129 int, _index130 int, _index131 int, _index132 int, _index133 int,
_index134 int, _index135 int, _index136 int, _index137 int, _index138 int, _index139 int, _index140 int,
_index141 int, _index142 int, _index143 int, _index144 int, _index145 int, _index146 int, _index147 int,
_index148 int, _index149 int, _index150 int
)
select * from char1 where _name = 'hoon29999'
/*sp 积己 */
--select
create proc sp_charSe
@AID AS varchar(16)
AS
select _index1, _index2, _index3, _index4, _index5, _index6, _index7,
_index8, _index9, _index10, _index11, _index12 , _index13 , _index14 ,
_index15 , _index16 , _index17 , _index18 , _index19 , _index20 , _index21 ,
_index22 , _index23 , _index24 , _index25 , _index26 , _index27 , _index28 ,
_index29 , _index30 , _index31 , _index32 , _index33 , _index34 , _index35 ,
_index36 , _index37 , _index38 , _index39 , _index40 , _index41 , _index42 ,
_index43 , _index44 , _index45 , _index46 , _index47 , _index48 , _index49 ,
_index50 , _index51 , _index52 , _index53 , _index54 , _index55 , _index56 ,
_index57 , _index58 , _index59 , _index60 , _index61 , _index62 , _index63 ,
_index64 , _index65 , _index66 , _index67 , _index68 , _index69 , _index70 ,
_index71 , _index72 , _index73 , _index74 , _index75 , _index76 , _index77 ,
_index78 , _index79 , _index80 , _index81 , _index82 , _index83 , _index84 ,
_index85 , _index86 , _index87 , _index88 , _index89 , _index90 , _index91 ,
_index92 , _index93 , _index94 , _index95 , _index96 , _index97 , _index98 ,
_index99 , _index100 , _index101 , _index102 , _index103 , _index104 , _index105 ,
_index106 , _index107 , _index108 , _index109 , _index110 , _index111 , _index112 ,
_index113 , _index114 , _index115 , _index116 , _index117 , _index118 , _index119 ,
_index120 , _index121 , _index122 , _index123 , _index124 , _index125 , _index126 ,
_index127 , _index128 , _index129 , _index130 , _index131 , _index132 , _index133 ,
_index134 , _index135 , _index136 , _index137 , _index138 , _index139 , _index140 ,
_index141 , _index142 , _index143 , _index144 , _index145 , _index146 , _index147 ,
_index148 , _index149 , _index150 from char1 where _name = @AID
go
--update
create proc sp_charUp
@AID AS varchar(16),
@index1 AS int,@index2 AS int,@index3 AS int,@index4 AS int,@index5 AS int,@index6 AS int,@index7 AS int,@index8 AS int,
@index9 AS int,@index10 AS int,@index11 AS int,@index12 AS int,@index13 AS int,@index14 AS int,@index15 AS int,@index16 AS int,
@index17 AS int,@index18 AS int,@index19 AS int,@index20 AS int,@index21 AS int,@index22 AS int,@index23 AS int,@index24 AS int,
@index25 AS int,@index26 AS int,@index27 AS int,@index28 AS int,@index29 AS int,@index30 AS int,@index31 AS int,@index32 AS int,
@index33 AS int,@index34 AS int,@index35 AS int,@index36 AS int,@index37 AS int,@index38 AS int,@index39 AS int,@index40 AS int,
@index41 AS int,@index42 AS int,@index43 AS int,@index44 AS int,@index45 AS int,@index46 AS int,@index47 AS int,@index48 AS int,
@index49 AS int,@index50 AS int,@index51 AS int,@index52 AS int,@index53 AS int,@index54 AS int,@index55 AS int,@index56 AS int,
@index57 AS int,@index58 AS int,@index59 AS int,@index60 AS int,@index61 AS int,@index62 AS int,@index63 AS int,@index64 AS int,
@index65 AS int,@index66 AS int,@index67 AS int,@index68 AS int,@index69 AS int,@index70 AS int,@index71 AS int,@index72 AS int,
@index73 AS int,@index74 AS int,@index75 AS int,@index76 AS int,@index77 AS int,@index78 AS int,@index79 AS int,@index80 AS int,
@index81 AS int,@index82 AS int,@index83 AS int,@index84 AS int,@index85 AS int,@index86 AS int,@index87 AS int,@index88 AS int,
@index89 AS int,@index90 AS int,@index91 AS int,@index92 AS int,@index93 AS int,@index94 AS int,@index95 AS int,@index96 AS int,
@index97 AS int,@index98 AS int,@index99 AS int,@index100 AS int,@index101 AS int,@index102 AS int,@index103 AS int,@index104 AS int,
@index105 AS int,@index106 AS int,@index107 AS int,@index108 AS int,@index109 AS int,@index110 AS int,@index111 AS int,@index112 AS int,
@index113 AS int,@index114 AS int,@index115 AS int,@index116 AS int,@index117 AS int,@index118 AS int,@index119 AS int,@index120 AS int,
@index121 AS int,@index122 AS int,@index123 AS int,@index124 AS int,@index125 AS int,@index126 AS int,@index127 AS int,@index128 AS int,
@index129 AS int,@index130 AS int,@index131 AS int,@index132 AS int,@index133 AS int,@index134 AS int,@index135 AS int,@index136 AS int,
@index137 AS int,@index138 AS int,@index139 AS int,@index140 AS int,@index141 AS int,@index142 AS int,@index143 AS int,@index144 AS int,
@index145 AS int,@index146 AS int,@index147 AS int,@index148 AS int,@index149 AS int,@index150 AS int
As
begin tran
update char1 set  
_index1 = @index1, _index2 = @index2, _index3 = @index3, _index4 = @index4, _index5 = @index5, _index6 = @index6, _index7 = @index7,
_index8 = @index8, _index9 = @index9, _index10 = @index10, _index11 = @index11, _index12 = @index12, _index13 = @index13, _index14 = @index14,
_index15 = @index15, _index16 = @index16, _index17 = @index17, _index18 = @index18, _index19 = @index19, _index20 = @index20, _index21 = @index21,
_index22 = @index22, _index23 = @index23, _index24 = @index24, _index25 = @index25, _index26 = @index26, _index27 = @index27, _index28 = @index28,
_index29 = @index29, _index30 = @index30, _index31 = @index31, _index32 = @index32, _index33 = @index33, _index34 = @index34, _index35 = @index35,
_index36 = @index36, _index37 = @index37, _index38 = @index38, _index39 = @index39, _index40 = @index40, _index41 = @index41, _index42 = @index42,
_index43 = @index43, _index44 = @index44, _index45 = @index45, _index46 = @index46, _index47 = @index47, _index48 = @index48, _index49 = @index49,
_index50 = @index50, _index51 = @index51, _index52 = @index52, _index53 = @index53, _index54 = @index54, _index55 = @index55, _index56 = @index56,
_index57 = @index57, _index58 = @index58, _index59 = @index59, _index60 = @index60, _index61 = @index61, _index62 = @index62, _index63 = @index63,
_index64 = @index64, _index65 = @index65, _index66 = @index66, _index67 = @index67, _index68 = @index68, _index69 = @index69, _index70 = @index70,
_index71 = @index71, _index72 = @index72, _index73 = @index73, _index74 = @index74, _index75 = @index75, _index76 = @index76, _index77 = @index77,
_index78 = @index78, _index79 = @index79, _index80 = @index80, _index81 = @index81, _index82 = @index82, _index83 = @index83, _index84 = @index84,
_index85 = @index85, _index86 = @index86, _index87 = @index87, _index88 = @index88, _index89 = @index89, _index90 = @index90, _index91 = @index91,
_index92 = @index92, _index93 = @index93, _index94 = @index94, _index95 = @index95, _index96 = @index96, _index97 = @index97, _index98 = @index98,
_index99 = @index99, _index100 = @index100, _index101 = @index101, _index102 = @index102, _index103 = @index103, _index104 = @index104, 
_index105  = @index105,_index106 = @index106, _index107 = @index107, _index108 = @index108, _index109 = @index109, _index110 = @index110, 
_index111 = @index111, _index112 = @index112, _index113 = @index113, _index114 = @index114, _index115 = @index115,
 _index116 = @index116, _index117 = @index117, _index118 = @index118, _index119 = @index119,
_index120 = @index120, _index121 = @index121, _index122 = @index122, _index123 = @index123, _index124 = @index124,
_index125 = @index125, _index126 = @index126, _index127 = @index127, _index128 = @index128, _index129 = @index129, 
_index130 = @index130, _index131 = @index131, _index132 = @index132, _index133 = @index133, _index134 = @index134, 
_index135 = @index135, _index136 = @index136 , _index137 = @index137, _index138 = @index138, _index139 = @index139, 
_index140 = @index140, _index141 = @index141, _index142 = @index142, _index143 = @index143, _index144 = @index144, 
_index145 = @index145, _index146 = @index146, _index147 = @index147, _index148 = @index148, _index149 = @index149, 
_index150 = @index150
where _name = @AID
if @@Error <> 0
	begin
		rollback tran
	end
else
	begin
		commit tran
	end
go
--insert
create proc sp_charIn
@AID AS varchar(16)
As
begin tran
insert char1 values (@AID,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
if @@Error <> 0
	begin
		rollback tran
	end
else
	begin
		commit tran
	end
go
/*---------------------------------------------------------------------------------------------------------------------------------*/
/*binary Inven 器窃*/
create table char2
(
_name varchar(16) primary key,
_Inven binary(6450)
)
/*sp 积己 */
--select
create proc sp_char2Se
@AID AS varchar(16)
AS
select _name,_Inven from char2 where _name = @AID
go
--update
create proc sp_char2Up
@AID AS varchar(16),
@Item AS binary(6450)
As
begin tran
update char2 set  _Inven = @Item where _name = @AID
if @@Error <> 0
	begin
		rollback tran
	end
else
	begin
		commit tran
	end
go
--insert
create proc sp_char2In
@AID AS varchar(16),
@Item AS binary(6450)
As
begin tran
insert char2 values (@AID,@Item)
if @@Error <> 0
	begin
		rollback tran
	end
else
	begin
		commit tran
	end
go
/*---------------------------------------------------------------------------------------------------------------------------------*/

select * from testData where _name = 'hoon0'
select * from AccountData where CAccountID = '1234567890123456'