历经骑士 4 5年共享点东西估计有人要的.

only

历经骑士 4 5年,不想在说什么。不需要解释什么不需要指桑骂槐觉得此帖不好可以不用理会

分享一些有用的东西 LINUX2.0

CREATE PROCEDURE baslangicitem
@account varchar(21)
AS
begin

declare @class smallint

select @class = cast(substring(cast(class as varchar(3)),2,2) as smallint(2)) from userdata where struserid=@account

if @class=1 or @class=5 or @class=6
update userdata set stritem=(select stritem from userdata where struserid='骑士01') where struserid=@account

if @class=2 or @class=7 or @class=8
update userdata set stritem=(select stritem from userdata where struserid='骑士02') where struserid=@account

if @class=3 or @class=9 or @class=10
update userdata set stritem=(select stritem from userdata where struserid='骑士03') where struserid=@account

if @class=4 or @class=11 or @class=12
update userdata set stritem=(select stritem from userdata where struserid='骑士04') where struserid=@account

--update userdata set  stritem = (select stritem from baslangic where class=@class), level=80 where struserid=@account

end
GO

LINUX 新手装备储存.你懂的

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[smg_CHECK_USERID_DUPLICATION]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[smg_CHECK_USERID_DUPLICATION]
GO

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

-- scripted by sungyong
-- 2005.04.11
CREATE PROCEDURE smg_CHECK_USERID_DUPLICATION
@CharID char(21),
@nRet smallint OUTPUT
AS
DECLARE @Row tinyint
SET @Row = 0
SELECT @Row = byDuplication FROM CHECK_USERID WHERE strUserId = @CharID
IF @Row > 0
BEGIN
SET @nRet =  1
RETURN
END
SET @nRet =  0

---------如果人法师>=8，更新所有人法师角色不能上线，如果人法师<8，更新所有人法师角色可以上线
DECLARE @ren int
select @ren =count(*)  from knight.dbo.userdata where struserid in (select strcharid from Knight_Account.dbo.CURRENTUSER ) and class=210
if @ren>=8
BEGIN

update knight.dbo.userdata set nServerIndex=2 where class=210 and struserid not in (select strcharid from Knight_Account.dbo.CURRENTUSER )
RETURN
END

select @ren =count(*)  from knight.dbo.userdata where struserid in (select strcharid from Knight_Account.dbo.CURRENTUSER ) and class=210
if @ren<8
BEGIN
update knight.dbo.userdata set nServerIndex=1 where class=210 and struserid not in (select strcharid from Knight_Account.dbo.CURRENTUSER )and nServerIndex<>1
RETURN

END
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

限制法师你懂的

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[UPDATE_BATTLE_HERO]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[UPDATE_BATTLE_HERO]
GO

SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS OFF
GO

-- sungyong 2003.1.21 create

CREATE PROCEDURE UPDATE_BATTLE_HERO
@strCharID char(21),
@strNation char(20),
@strClass char(30),
@strAchievement char(50),
@nIndex smallint

AS

DECLARE @nRet int,@StrAccount char(21)

select  @StrAccount=StrAccountID from ACCOUNT_CHAR where strCharID1=@StrCharID --1号角色
select  @StrAccount=StrAccountID from ACCOUNT_CHAR where strCharID2=@StrCharID --2号角色
select  @StrAccount=StrAccountID from ACCOUNT_CHAR where strCharID3=@StrCharID --3号角色
--猎杀第二、三守，自动返20购点。
IF @nindex=1001 or  @nindex=1002  or @nindex=2001 or @nindex=2002 or @nindex=1101 or  @nindex=1102  or @nindex=2101 or @nindex=2102
UPDATE Knight_Account.dbo.TB_USER SET CashPoint=CashPoint+20 WHERE strAccountID=@StrAccount
else
--猎杀第一守，自动返30购点。
if @nindex=1003 or @nindex=2003 or @nindex=1103 or @nindex=2103
UPDATE Knight_Account.dbo.TB_USER SET CashPoint=CashPoint+30 WHERE strAccountID=@StrAccount

SET @nRet = 0
SELECT @nRet = COUNT(strUserID) FROM HERO_USER WHERE shIndex = @nIndex
IF @nRet = 0
INSERT INTO HERO_USER (strUserID, strNation, strClass, strAchievement, shIndex)VALUES(@strCharID, @strNation, @strClass, @strAchievement, @nIndex)

ELSE
UPDATE HERO_USER SET strUserID = @strCharID, strNation = @strNation, strClass = @strClass, strAchievement = @strAchievement WHERE shIndex = @nIndex

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

杀守备送点你懂的

1c 5a 80 00 8b 0d f4 cb 93 00 68 登陆器端口  你懂的

LINUX  EB版本修改

00 00 80 B8 88 E1 1C 00 00 75 6D 66 C7 43

你懂的

登陆器版本修改你懂的

4C24548B74245081E1FF00000081FE

AEC76F00D8C76F0002C86F00B8

only · 2012-12-12 15:18:57

修复讨伐队你懂的]

only · 2012-12-12 15:20:31

蓝箱子换点红包换积分你懂的

-- scripted by sungyong
-- 2002.12.6
CREATE PROCEDURE UPDATE_COUPON_EVENT
@strAccountID char(21),
@strCharID char(21),
@strCouponID char(20),
@nItemID int,
@nItemCount int
AS
BEGIN TRAN
--please change ths value of this item yourself.
if @nItemID=379131000
begin
update tb_user set ipoint=ipoint+300 where straccountid=@straccountid
end

if @nItemID= 379156000
begin
update tb_user set cashpoint=cashpoint+1 where straccountid=@straccountid
end

COMMIT TRAN
GO

only · 2012-12-12 15:23:11

带团人转兽兽转人

CREATE procedure [SLLEO_ToHuman]
@Account char(30)

AS DECLARE @clannumber smallint, @length int,@row int,@i int,@dwid int,@pos int,@dur int,@dur1 int,@ext int,@StackSize1 int,@strName varchar(30),@strExtName varchar(30),@Cdwid varbinary(4),@cdur varchar(2),@cstack varchar(2), @vicechief_1 varchar(21)
begin tran
declare @char1 varchar(21)
set @char1 = (select strcharid1 from account_char where straccountid = @account)
declare @char2 varchar(21)
set @char2 = (select strcharid2 from account_char where straccountid = @account)
declare @char3 varchar(21)
set @char3 = (select strcharid3 from account_char where straccountid = @account)
declare @clannumber1 smallint
set @clannumber1 = (select idnum from knights where chief = @char1)
declare @clannumber2 smallint
set @clannumber2 = (select idnum from knights where chief = @char2)
declare @clannumber3 smallint
set @clannumber3 = (select idnum from knights where chief = @char3)
update account_char set bnation = '2' where bnation = '1' and straccountid = @Account
update userdata set nation = '2' where nation = '1' and struserid = @char1
update userdata set race = '11' where race = '1' and class in ('101','105','106') and struserid = @char1
Update userdata set race = '12' where race = '2' and class in ('107','111','102','104','112','108') and struserid = @char1
update userdata set race = '13' where race = '3' and class in ('103','109','110') and struserid = @char1
update userdata set race = '13' where race = '4' and class in ('104','111','112','110') and struserid = @char1
update userdata set class = '205' where class = '105' and struserid = @char1
update userdata set class = '207' where class = '107' and struserid = @char1
update userdata set class = '209' where class = '109' and struserid = @char1
update userdata set class = '211' where class = '111' and struserid = @char1
update userdata set class = '201' where class = '101' and struserid = @char1
update userdata set class = '202' where class = '102' and struserid = @char1
update userdata set class = '203' where class = '103' and struserid = @char1
update userdata set class = '204' where class = '104' and struserid = @char1
update userdata set class = '212' where class = '112' and struserid = @char1
update userdata set class = '206' where class = '106' and struserid = @char1
update userdata set class = '208' where class = '108' and struserid = @char1
update userdata set class = '210' where class = '110' and struserid = @char1
update userdata set zone = '21',bind = '-1',px = '31900',pz = '40100',py = '0' where struserid = @char1
update userdata set nation = '2' where nation = '1' and struserid = @char2
update userdata set race = '11' where race = '1' and class in ('101','105','106') and struserid = @char2
Update userdata set race = '12' where race = '2' and class in ('107','111','102','104','112','108') and struserid = @char2
update userdata set race = '13' where race = '3' and class in ('103','109','110') and struserid = @char2
update userdata set race = '13' where race = '4' and class in ('104','111','112','110') and struserid = @char2
update userdata set class = '205' where class = '105' and struserid = @char2
update userdata set class = '207' where class = '107' and struserid = @char2
update userdata set class = '209' where class = '109' and struserid = @char2
update userdata set class = '211' where class = '111' and struserid = @char2
update userdata set class = '201' where class = '101' and struserid = @char2
update userdata set class = '202' where class = '102' and struserid = @char2
update userdata set class = '203' where class = '103' and struserid = @char2
update userdata set class = '204' where class = '104' and struserid = @char2
update userdata set class = '212' where class = '112' and struserid = @char2
update userdata set class = '206' where class = '106' and struserid = @char2
update userdata set class = '208' where class = '108' and struserid = @char2
update userdata set class = '210' where class = '110' and struserid = @char2
update userdata set zone = '21',bind = '-1',px = '31900',pz = '40100',py = '0' where struserid = @char2
update userdata set nation = '2' where nation = '1' and struserid = @char3
update userdata set race = '11' where race = '1' and class in ('101','105','106') and struserid = @char3
Update userdata set race = '12' where race = '2' and class in ('107','111','102','104','112','108') and struserid = @char3
update userdata set race = '13' where race = '3' and class in ('103','109','110') and struserid = @char3
update userdata set race = '13' where race = '4' and class in ('104','111','112','110') and struserid = @char3
update userdata set class = '205' where class = '105' and struserid = @char3
update userdata set class = '207' where class = '107' and struserid = @char3
update userdata set class = '209' where class = '109' and struserid = @char3
update userdata set class = '211' where class = '111' and struserid = @char3
update userdata set class = '201' where class = '101' and struserid = @char3
update userdata set class = '202' where class = '102' and struserid = @char3
update userdata set class = '203' where class = '103' and struserid = @char3
update userdata set class = '204' where class = '104' and struserid = @char3
update userdata set class = '212' where class = '112' and struserid = @char3
update userdata set class = '206' where class = '106' and struserid = @char3
update userdata set class = '208' where class = '108' and struserid = @char3
update userdata set class = '210' where class = '110' and struserid = @char3
update userdata set zone = '21',bind = '-1',px = '31900',pz = '40100',py = '0' where struserid = @char3
Update knights set nation = '2' where nation = '1' and chief = @char1
Update knights set nation = '2' where nation = '1' and chief = @char2
Update knights set nation = '2' where nation = '1' and chief = @char3

commit tran
GO

only · 2012-12-12 15:23:27

你懂的

CREATE procedure [dbo].[SLLEO_ToKarus]
@Account char(30)

AS DECLARE @clannumber smallint, @length int,@row int,@i int,@dwid int,@pos int,@dur int,@dur1 int,@ext int,@StackSize1 int,@strName varchar(30),@strExtName varchar(30),@Cdwid varbinary(4),@cdur varchar(2),@cstack varchar(2)

begin tran

declare @char1 varchar(21)
set @char1 = (select strcharid1 from account_char where straccountid = @account)
declare @char2 varchar(21)
set @char2 = (select strcharid2 from account_char where straccountid = @account)
declare @char3 varchar(21)
set @char3 = (select strcharid3 from account_char where straccountid = @account)
declare @clannumber1 smallint
set @clannumber1 = (select idnum from knights where chief = @char1)
declare @clannumber2 smallint
set @clannumber2 = (select idnum from knights where chief = @char2)
declare @clannumber3 smallint
set @clannumber3 = (select idnum from knights where chief = @char3)

update account_char set bnation = '1' where bnation = '2' and straccountid = @Account

update userdata set nation = '1' where nation = '2' and struserid = @char1
Update userdata set race = '1' where race = '11' and class in ('201','205','206') and struserid = @char1
Update userdata set race = '1' where race = '12' and class in ('201','205','206') and struserid = @char1
Update userdata set race = '1' where race = '13' and class in ('201','205','206') and struserid = @char1
Update userdata set race = '2' where race = '12' and class in ('207','211','202','204','212','208') and struserid = @char1
update userdata set race = '2' where race = '13' and class in ('202','207','208') and struserid = @char1
update userdata set race = '3' where race = '12' and class in ('203','209','210') and struserid = @char1
update userdata set race = '3' where race = '13' and class in ('203','209','210') and struserid = @char1
update userdata set race = '4' where race = '13' and class in ('204','211','212') and struserid = @char1
update userdata set class = '105' where class = '205' and struserid = @char1
update userdata set class = '107' where class = '207' and struserid = @char1
update userdata set class = '109' where class = '209' and struserid = @char1
update userdata set class = '111' where class = '211' and struserid = @char1
update userdata set class = '101' where class = '201' and struserid = @char1
update userdata set class = '102' where class = '202' and struserid = @char1
update userdata set class = '103' where class = '203' and struserid = @char1
update userdata set class = '104' where class = '204' and struserid = @char1
update userdata set class = '112' where class = '212' and struserid = @char1
update userdata set class = '106' where class = '206' and struserid = @char1
update userdata set class = '108' where class = '208' and struserid = @char1
update userdata set class = '110' where class = '210' and struserid = @char1
update userdata set zone = '21',bind = '-1',px = '31900',pz = '40100',py = '0' where struserid = @char1
update userdata set nation = '1' where nation = '2' and struserid = @char2
Update userdata set race = '1' where race = '11' and class in ('201','205','206') and struserid = @char2
Update userdata set race = '1' where race = '12' and class in ('201','205','206') and struserid = @char2
Update userdata set race = '1' where race = '13' and class in ('201','205','206') and struserid = @char2
Update userdata set race = '2' where race = '12' and class in ('207','211','202','204','212','208') and struserid = @char2
update userdata set race = '2' where race = '13' and class in ('202','207','208') and struserid = @char2
update userdata set race = '3' where race = '12' and class in ('203','209','210') and struserid = @char2
update userdata set race = '3' where race = '13' and class in ('203','209','210') and struserid = @char2
update userdata set race = '4' where race = '13' and class in ('204','211','212') and struserid = @char2
update userdata set class = '105' where class = '205' and struserid = @char2
update userdata set class = '107' where class = '207' and struserid = @char2
update userdata set class = '109' where class = '209' and struserid = @char2
update userdata set class = '111' where class = '211' and struserid = @char2
update userdata set class = '101' where class = '201' and struserid = @char2
update userdata set class = '102' where class = '202' and struserid = @char2
update userdata set class = '103' where class = '203' and struserid = @char2
update userdata set class = '104' where class = '204' and struserid = @char2
update userdata set class = '112' where class = '212' and struserid = @char2
update userdata set class = '106' where class = '206' and struserid = @char2
update userdata set class = '108' where class = '208' and struserid = @char2
update userdata set class = '110' where class = '210' and struserid = @char2
update userdata set zone = '21',bind = '-1',px = '31900',pz = '40100',py = '0' where struserid = @char2
update userdata set nation = '1' where nation = '2' and struserid = @char3
Update userdata set race = '1' where race = '11' and class in ('201','205','206') and struserid = @char3
Update userdata set race = '1' where race = '12' and class in ('201','205','206') and struserid = @char3
Update userdata set race = '1' where race = '13' and class in ('201','205','206') and struserid = @char3
Update userdata set race = '2' where race = '12' and class in ('207','211','202','204','212','208') and struserid = @char3
update userdata set race = '2' where race = '13' and class in ('202','207','208') and struserid = @char3
update userdata set race = '3' where race = '12' and class in ('203','209','210') and struserid = @char3
update userdata set race = '3' where race = '13' and class in ('203','209','210') and struserid = @char3
update userdata set race = '4' where race = '13' and class in ('204','211','212') and struserid = @char3
update userdata set class = '105' where class = '205' and struserid = @char3
update userdata set class = '107' where class = '207' and struserid = @char3
update userdata set class = '109' where class = '209' and struserid = @char3
update userdata set class = '111' where class = '211' and struserid = @char3
update userdata set class = '101' where class = '201' and struserid = @char3
update userdata set class = '102' where class = '202' and struserid = @char3
update userdata set class = '103' where class = '203' and struserid = @char3
update userdata set class = '104' where class = '204' and struserid = @char3
update userdata set class = '112' where class = '212' and struserid = @char3
update userdata set class = '106' where class = '206' and struserid = @char3
update userdata set class = '108' where class = '208' and struserid = @char3
update userdata set class = '110' where class = '210' and struserid = @char3
update userdata set zone = '21',bind = '-1',px = '31900',pz = '40100',py = '0' where struserid = @char3
Update knights set nation = '1' where nation = '2' and chief = @char1
Update knights set nation = '1' where nation = '2' and chief = @char2
Update knights set nation = '1' where nation = '2' and chief = @char3

commit tran
GO

only · 2012-12-12 15:24:12

网页你懂的


<%
action=trim(request("action"))
idnum=trim(request("idnum"))
if idnum<>"" and isnumeric(idnum) then idnum=cint(idnum)

if action="do" then
acid=trim(CheckStr(request.form("acid")))
tdid=trim(CheckStr(request.form("id")))
If acid<>"" and tdid<>"" Then
set ccs=ConnAccount.execute("select straccountid from currentuser where straccountid='"&acid&"'")
if not ccs.eof then
msg="该账号在线，无法转换！"
else
Set rs=connGame.execute("select straccountid,bnation,strcharid1,strcharid2,strcharid3 from account_char where straccountid='" & acid & "'")
if not rs.eof then
if rs("bnation")=1 then
connGame.execute("EXEC SLLEO_ToHuman '"&acid&"'")
connGame.execute("update userdata set zone=21 where struserid in('"&rs("strcharid1")&"','"&rs("strcharid2")&"','"&rs("strcharid3")&"')")
msg="带团转人成功 - "&strAccountID&" - 时间："&now()&"！"
else
connGame.execute("EXEC SLLEO_ToKarus '"&acid&"'")
connGame.execute("update userdata set zone=21 where struserid in('"&rs("strcharid1")&"','"&rs("strcharid2")&"','"&rs("strcharid3")&"')")
msg="带团转兽成功 - "&acid&" - 时间："&now()&"！"
end If
else
msg="该账号不存在或未建人物！"
End If
rs.close:set rs=nothing
end if
ccs.close:set ccs=nothing
else
msg="必要的参数为空！"
End if
response.write("<script>alert('"&msg&"');</script>")
'response.write("<script>parent.document.getElementById('status_'+"&tdid&").innerHTML='"&msg&"';</script>")
response.end
end if
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title></title>
<link href="style.css" rel="Stylesheet" type="text/css" />
<script type="text/javascript">
function dochange(acid,id){
if(acid!=''&&id!=''){
document.getElementById('acid').value=acid;
document.getElementById('id').value=id;
document.getElementById('ajaxForm').action='index.clannationchange.asp?action=do';
document.getElementById('ajaxForm').submit();
}else{
alert('参数错误');
return false;
}
}
</script>
</head>
<body id="content">
<table width="100%" border="0" cellspacing="0" cellpadding="0" id="introTbl">
<tr>
<td colspan="2" class="t" height="25">整团国家转换</td>
</tr>
<tr>
<td height="25" width="50" align="right"> </td>
<td align="left">
<form id="searchFrm" name="searchFrm" method="POST" action="index.clannationchange.asp?action=view" style="margin:5px;">
<table border="0" width="100%" cellspacing="0" cellpadding="0">
<tr>
<td height="25" width="70">军团ID：</td>
<td align="left">
<select name="IDNum" id="IDNum" class="select" style="width:400px;">
<%
Set rs=conngame.execute("select idname,idnum,members,chief,nation from knights order by nation asc,idnum asc")
Do While Not rs.eof
%>
<option value="<%=rs("IDNum")%>" <%if idnum=rs("idnum") then response.write("selected")%>>[<%=rs("nation")%>][<%=rs("IDNum")%>]/[<%=rs("members")%>]   <%=rs("IDName")%>   ->  <%=rs("chief")%></option>
<%
rs.movenext
Loop
rs.close:Set rs=Nothing
%>
</select>
</td>
</tr>
<tr>
<td height="35"> </td>
<td align="left"><input type="submit" class="btns" value=" 查看团名单 " /></td>
</tr>
<tr>
<td height="25"> </td>
<td id="sendresult" align="left" style="color:green;font-weight:bold;"> </td>
</tr>
</table>
</form>
<%
if action="view" then
idnum=trim(request("idnum"))
if idnum<>"" and isnumeric(idnum) then
response.write("<br /><table border=0 width=100% cellspacing=0 cellpadding=0 style='margin-left:5px;border-top:1px #ccc solid;'>")
response.write("<tr>")
response.write("<td class='t' height='23' width='40'>操作</th>")
response.write("<td width='150' class='t'>账号</th>")
response.write("<td width='180' class='t'>人名</th>")
response.write("<td width='80' class='t'>贡献</th>")
response.write("<td class='t' width='180'>最后更新</th>")
response.write("</tr>")
set rs=conngame.execute("select straccountid,struserid,knights,loyalty,updatetime from userdata where knights="&idnum&" order by loyalty desc")
i=1
do while not rs.eof
response.write("<tr>")
response.write("<td align='center'><a href='###' style='color:#d1326a;' onclick=""dochange('"&trim(rs("straccountid"))&"',"&i&")"">转换</a></th>")
response.write("<td height='23'><a href='account.viewwarehouse.asp?straccountid="&rs("straccountid")&"' target='_blank'>"&rs("straccountid")&"</a></th>")
response.write("<td><a href='account.viewuser.asp?struserid="&rs("struserid")&"' target='_blank'>"&rs("struserid")&"</a></th>")
response.write("<td>"&rs("loyalty")&"</th>")
response.write("<td>"&rs("updatetime")&"</th>")
response.write("<td id='status_"&i&"'> </th>")
response.write("</tr>")
i=i+1
rs.movenext
loop
rs.close:set rs=nothing
response.write("<tr><td colspan='4' height='30' align='left'><input type='submit' class='btns' value=' 开始转换 ' /></td></tr>")
response.write("</table><br />")
end if
end if
%>
</td>
</tr>
</table>
<form name="ajaxForm" id="ajaxForm" action="#" method="post" target="_blank">
<input type="hidden" name="acid" id="acid" value="">
<input type="hidden" name="id" id="id" value="">
</form>
<iframe id="postFrm" name="postFrm" height="0" width="0" scrolling="no" frameborder="0" src="about:blank"></iframe>
</body>
</html>
<%closeconn()%>

only · 2012-12-12 15:28:02

翅膀补丁你懂的

only · 2012-12-12 15:29:38

商业LINUX2.0 也共享比较全可以开服比网上放的全本人东西非垃圾决定退出骑士了

喜欢研究开服的尽管拿去

250789073 QQ群

only · 2012-12-12 15:30:40

不爱加群的可以直接下载服务端虚拟机

only · 2012-12-12 15:36:06

15300 15200

15100端口已修改15300 15200 绝非人多卡号。不是垃圾东西你懂的

账号		自动登录	找回密码
密码			加入

历经骑士 4 5年 共享点东西 估计有人要的.

49 回复

only

历经骑士 4 5年共享点东西估计有人要的.