历经骑士 4 5年 共享点东西 估计有人要的.
历经骑士 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 setstritem = (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'.') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure .
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'.') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure .
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=1002or @nindex=2001 or @nindex=2002 or @nindex=1101 or@nindex=1102or @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 登陆器端口你懂的
LINUXEB版本修改
00 00 80 B8 88 E1 1C 00 00 75 6D 66 C7 43
你懂的
登陆器版本修改 你懂的
4C24548B74245081E1FF00000081FE
AEC76F00D8C76F0002C86F00B8
修复讨伐队你懂的] 蓝箱子换点红包换积分你懂的
-- 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+300where straccountid=@straccountid
end
if @nItemID= 379156000
begin
update tb_user set cashpoint=cashpoint+1 where straccountid=@straccountid
end
COMMIT TRAN
GO
带团人转兽兽转人
CREATE procedure
@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
你懂的
CREATE procedure .
@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
网页你懂的
<!--#include file="config.asp"-->
<%
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()%>
翅膀补丁你懂的 商业LINUX2.0 也共享 比较全 可以开服比网上放的全本人东西非垃圾 决定退出骑士了
喜欢研究 开服的 尽管拿去
250789073 QQ群
不爱加群的 可以直接下载服务端 虚拟机 15300 15200
15100端口已修改1530015200 绝非人多卡号。不是垃圾东西 你懂的