★★★★★★★★数据库几个比较明显的错误，及一些适合新手的东西★★★★★★★
1：人物连接中断warehose表 在设计表中要加入一个字段strWarehousePW char 10
2：人物无法进入
以下3个表删除Account_char TB_USERUserData
，然后在查询器里复制运行下就好了，运行按F5
===================
Account_char
CREATE TABLE (
(21) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
NOT NULL ,
NOT NULL CONSTRAINT DEFAULT (0),
(21) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
(21) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
(21) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
(21) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
(21) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
CONSTRAINT PRIMARY KEY CLUSTERED
(
) WITH FILLFACTOR = 90 ON
) ON
GO
==========================
TB_USER
CREATE TABLE (
(21) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
(13) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
(20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
NOT NULL ,
(50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
NULL ,
(15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON
GO
=============================
UserData
CREATE TABLE (
(21) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
NOT NULL CONSTRAINT DEFAULT (0),
NOT NULL CONSTRAINT DEFAULT (1),
NOT NULL CONSTRAINT DEFAULT (0),
NOT NULL CONSTRAINT DEFAULT (0),
NOT NULL CONSTRAINT DEFAULT (0),
NOT NULL CONSTRAINT DEFAULT (0),
NOT NULL CONSTRAINT DEFAULT (1),
NOT NULL CONSTRAINT DEFAULT (0),
NOT NULL CONSTRAINT DEFAULT (100),
NOT NULL CONSTRAINT DEFAULT (0),
NOT NULL CONSTRAINT DEFAULT (0),
NOT NULL CONSTRAINT DEFAULT (0),
NOT NULL CONSTRAINT DEFAULT (0),
NOT NULL CONSTRAINT DEFAULT (100),
NOT NULL CONSTRAINT DEFAULT (100),
NOT NULL CONSTRAINT DEFAULT (100),
NOT NULL CONSTRAINT DEFAULT (0),
NOT NULL CONSTRAINT DEFAULT (0),
NOT NULL CONSTRAINT DEFAULT (0),
NOT NULL CONSTRAINT DEFAULT (0),
NOT NULL CONSTRAINT DEFAULT (0),
NOT NULL CONSTRAINT DEFAULT (1),
NOT NULL CONSTRAINT DEFAULT (0),
NOT NULL CONSTRAINT DEFAULT (0),
NOT NULL CONSTRAINT DEFAULT (1),
NULL ,
NOT NULL CONSTRAINT DEFAULT (268100),
NOT NULL CONSTRAINT DEFAULT (131000),
NOT NULL CONSTRAINT DEFAULT (0),
NOT NULL CONSTRAINT DEFAULT (0),
(10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT DEFAULT (0x00),
(400) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
(400) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
NOT NULL CONSTRAINT DEFAULT (0),
(400) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
NOT NULL CONSTRAINT DEFAULT (0),
NOT NULL CONSTRAINT DEFAULT (0),
NOT NULL CONSTRAINT DEFAULT (getdate()),
NULL ,
CONSTRAINT PRIMARY KEY CLUSTERED
(
) WITH FILLFACTOR = 90 ON
) ON
GO
3：人箭塔修复
修箭塔，以下4个分别查询器里执行（F5执行）
1
DELETE FROM K_NPC
WHERE (sSid = 5300) OR
(sSid = 5400)
2
DELETE FROM K_NPCPOS
WHERE (NpcID = 5300) OR
(NpcID = 5400)
3
INSERT INTO K_NPC ( , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ) VALUES ( 5400, 'Guard tower', 5401, 100, 0, 0, 1, 0, 62, 1, 1, 1, 0, 90, 0, 0, 100000, 0, 0, 15000, 497, 497, 0, 1500, 0, 0, 1000, 300139, 0, 0, 255, 255, 255, 255, 255, 255, 255, 200, 30, 35, 35, 0, 0, 1, 1, 0 );
INSERT INTO K_NPC ( , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ) VALUES ( 5300, 'Guard tower', 5301, 100, 0, 0, 2, 0, 62, 1, 1, 1, 0, 90, 0, 0, 100000, 0, 0, 15000, 497, 497, 0, 1500, 0, 0, 1000, 300139, 0, 0, 255, 255, 255, 255, 255, 255, 255, 200, 30, 35, 35, 0, 0, 1, 1, 0 );
4
INSERT INTO K_NPCPOS ( , , , , , , , , , , , , , , , , , , , ) VALUES ( 201, 5300, 104, 0, 0, 0, 0, 597, 914, 599, 912, 588, 924, 610, 902, 1, 60, 0, 0, '' );
INSERT INTO K_NPCPOS ( , , , , , , , , , , , , , , , , , , , ) VALUES ( 201, 5300, 104, 0, 0, 0, 0, 665, 930, 666, 928, 659, 939, 677, 919, 1, 60, 0, 0, '' );
INSERT INTO K_NPCPOS ( , , , , , , , , , , , , , , , , , , , ) VALUES ( 201, 5400, 104, 0, 0, 0, 0, 1328, 1110, 1329, 1108, 1321, 1117, 1339, 1100, 1, 60, 0, 0, '' );
INSERT INTO K_NPCPOS ( , , , , , , , , , , , , , , , , , , , ) VALUES ( 201, 5300, 104, 0, 0, 0, 0, 601, 897, 603, 895, 591, 906, 614, 885, 1, 60, 0, 0, '' );
INSERT INTO K_NPCPOS ( , , , , , , , , , , , , , , , , , , , ) VALUES ( 201, 5300, 104, 0, 0, 0, 0, 646, 924, 648, 922, 638, 932, 658, 915, 1, 60, 0, 0, '' );
INSERT INTO K_NPCPOS ( , , , , , , , , , , , , , , , , , , , ) VALUES ( 201, 5300, 104, 0, 0, 0, 0, 649, 910, 651, 908, 643, 916, 662, 897, 1, 60, 0, 0, '' );
INSERT INTO K_NPCPOS ( , , , , , , , , , , , , , , , , , , , ) VALUES ( 201, 5300, 104, 0, 0, 0, 0, 593, 949, 595, 947, 585, 955, 603, 942, 1, 60, 0, 0, '' );
INSERT INTO K_NPCPOS ( , , , , , , , , , , , , , , , , , , , ) VALUES ( 201, 5300, 104, 0, 0, 0, 0, 634, 954, 636, 952, 627, 959, 646, 945, 1, 60, 0, 0, '' );
INSERT INTO K_NPCPOS ( , , , , , , , , , , , , , , , , , , , ) VALUES ( 201, 5300, 104, 0, 0, 0, 0, 651, 873, 653, 872, 646, 881, 662, 863, 1, 60, 0, 0, '' );
INSERT INTO K_NPCPOS ( , , , , , , , , , , , , , , , , , , , ) VALUES ( 201, 5300, 104, 0, 0, 0, 0, 613, 864, 615, 862, 603, 872, 629, 850, 1, 60, 0, 0, '' );
INSERT INTO K_NPCPOS ( , , , , , , , , , , , , , , , , , , , ) VALUES ( 201, 5300, 104, 0, 0, 0, 0, 633, 865, 635, 863, 628, 873, 649, 853, 1, 60, 0, 0, '' );
INSERT INTO K_NPCPOS ( , , , , , , , , , , , , , , , , , , , ) VALUES ( 201, 5300, 104, 0, 0, 0, 0, 666, 886, 668, 884, 660, 893, 681, 873, 1, 60, 0, 0, '' );
INSERT INTO K_NPCPOS ( , , , , , , , , , , , , , , , , , , , ) VALUES ( 201, 5300, 104, 0, 0, 0, 0, 594, 870, 596, 868, 587, 876, 608, 860, 1, 60, 0, 0, '' );
INSERT INTO K_NPCPOS ( , , , , , , , , , , , , , , , , , , , ) VALUES ( 201, 5300, 104, 0, 0, 0, 0, 655, 949, 657, 947, 648, 956, 671, 935, 1, 60, 0, 0, '' );
INSERT INTO K_NPCPOS ( , , , , , , , , , , , , , , , , , , , ) VALUES ( 201, 5300, 104, 0, 0, 0, 0, 669, 907, 671, 905, 658, 917, 680, 893, 1, 60, 0, 0, '' );
INSERT INTO K_NPCPOS ( , , , , , , , , , , , , , , , , , , , ) VALUES ( 201, 5300, 104, 0, 0, 0, 0, 574, 911, 576, 908, 567, 918, 582, 901, 1, 60, 0, 0, '' );
INSERT INTO K_NPCPOS ( , , , , , , , , , , , , , , , , , , , ) VALUES ( 201, 5400, 104, 0, 0, 0, 0, 1361, 1134, 1363, 1133, 1354, 1139, 1373, 1124, 1, 60, 0, 0, '' );
INSERT INTO K_NPCPOS ( , , , , , , , , , , , , , , , , , , , ) VALUES ( 201, 5400, 104, 0, 0, 0, 0, 1334, 1062, 1336, 1060, 1330, 1068, 1346, 1053, 1, 60, 0, 0, '' );
INSERT INTO K_NPCPOS ( , , , , , , , , , , , , , , , , , , , ) VALUES ( 201, 5400, 104, 0, 0, 0, 0, 1349, 1087, 1351, 1085, 1342, 1094, 1360, 1078, 1, 60, 0, 0, '' );
INSERT INTO K_NPCPOS ( , , , , , , , , , , , , , , , , , , , ) VALUES ( 201, 5400, 104, 0, 0, 0, 0, 1354, 1072, 1356, 1071, 1348, 1079, 1363, 1062, 1, 60, 0, 0, '' );
INSERT INTO K_NPCPOS ( , , , , , , , , , , , , , , , , , , , ) VALUES ( 201, 5400, 104, 0, 0, 0, 0, 1398, 1101, 1400, 1099, 1394, 1108, 1410, 1089, 1, 60, 0, 0, '' );
INSERT INTO K_NPCPOS ( , , , , , , , , , , , , , , , , , , , ) VALUES ( 201, 5400, 104, 0, 0, 0, 0, 1403, 1086, 1404, 1085, 1396, 1092, 1418, 1075, 1, 60, 0, 0, '' );
INSERT INTO K_NPCPOS ( , , , , , , , , , , , , , , , , , , , ) VALUES ( 201, 5400, 104, 0, 0, 0, 0, 1343, 1125, 1345, 1124, 1338, 1130, 1353, 1117, 1, 60, 0, 0, '' );
INSERT INTO K_NPCPOS ( , , , , , , , , , , , , , , , , , , , ) VALUES ( 201, 5400, 104, 0, 0, 0, 0, 1383, 1136, 1385, 1134, 1379, 1141, 1392, 1128, 1, 60, 0, 0, '' );
INSERT INTO K_NPCPOS ( , , , , , , , , , , , , , , , , , , , ) VALUES ( 201, 5400, 104, 0, 0, 0, 0, 1409, 1050, 1411, 1049, 1406, 1056, 1419, 1043, 1, 60, 0, 0, '' );
INSERT INTO K_NPCPOS ( , , , , , , , , , , , , , , , , , , , ) VALUES ( 201, 5400, 104, 0, 0, 0, 0, 1366, 1038, 1368, 1037, 1358, 1047, 1374, 1030, 1, 60, 0, 0, '' );
INSERT INTO K_NPCPOS ( , , , , , , , , , , , , , , , , , , , ) VALUES ( 201, 5400, 104, 0, 0, 0, 0, 1389, 1039, 1390, 1037, 1382, 1045, 1398, 1029, 1, 60, 0, 0, '' );
INSERT INTO K_NPCPOS ( , , , , , , , , , , , , , , , , , , , ) VALUES ( 201, 5400, 104, 0, 0, 0, 0, 1423, 1066, 1424, 1065, 1418, 1072, 1436, 1055, 1, 60, 0, 0, '' );
INSERT INTO K_NPCPOS ( , , , , , , , , , , , , , , , , , , , ) VALUES ( 201, 5400, 104, 0, 0, 0, 0, 1345, 1044, 1347, 1042, 1340, 1049, 1356, 1035, 1, 60, 0, 0, '' );
INSERT INTO K_NPCPOS ( , , , , , , , , , , , , , , , , , , , ) VALUES ( 201, 5400, 104, 0, 0, 0, 0, 1405, 1130, 1407, 1128, 1397, 1135, 1419, 1117, 1, 60, 0, 0, '' );
INSERT INTO K_NPCPOS ( , , , , , , , , , , , , , , , , , , , ) VALUES ( 201, 5400, 104, 0, 0, 0, 0, 1422, 1088, 1423, 1086, 1413, 1095, 1431, 1077, 1, 60, 0, 0, '' );
INSERT INTO K_NPCPOS ( , , , , , , , , , , , , , , , , , , , ) VALUES ( 201, 5400, 104, 0, 0, 0, 0, 1414, 1111, 1416, 1109, 1407, 1117, 1423, 1101, 1, 60, 0, 0, '' );
INSERT INTO K_NPCPOS ( , , , , , , , , , , , , , , , , , , , ) VALUES ( 201, 5300, 104, 0, 0, 0, 0, 577, 936, 579, 934, 570, 944, 589, 927, 1, 60, 0, 0, '' );
INSERT INTO K_NPCPOS ( , , , , , , , , , , , , , , , , , , , ) VALUES ( 201, 5300, 104, 0, 0, 0, 0, 580, 887, 582, 886, 573, 894, 589, 879, 1, 60, 0, 0, '' );
INSERT INTO K_NPCPOS ( , , , , , , , , , , , , , , , , , , , ) VALUES ( 201, 5400, 104, 0, 0, 0, 0, 1328, 1085, 1330, 1083, 1320, 1092, 1338, 1076, 1, 60, 0, 0, '' );
INSERT INTO K_NPCPOS ( , , , , , , , , , , , , , , , , , , , ) VALUES ( 201, 5300, 104, 0, 0, 0, 0, 613, 956, 616, 954, 606, 963, 625, 946, 1, 60, 0, 0, '' );
4：出生携带金钱等设置方法
改这个存储过程 CREATE_NEW_CHAR 的下列地方即可
INSERT INTO USERDATA (strUserId, Nation, Race, Class, HairColor, Face, Strong, Sta, Dex, Intel, Cha, Zone, PX, PZ )
VALUES (@CharID, @Nation, @Race, @Class, @Hair, @Face, @Str, @Sta, @Dex, @Intel, @Cha, @Zone, @PosX, @PosZ )
改为：
INSERT INTO USERDATA (strUserId, Nation, Race, Class, HairColor, Face, Strong, Sta, Dex, Intel, Cha, Zone, PX, PZ ,,exp,loyalty,authority,gold)
VALUES (@CharID, @Nation, @Race, @Class, @Hair, @Face, @Str, @Sta, @Dex, @Intel, @Cha, @Zone, @PosX, @PosZ ,69,311540998,8000000,0,2100000000)
说明：人物出生直接69级，打个怪就升70级，带800万贡献，有21亿在身上，直接GM号
5：弓浪3万伤害修复
把MAGIC_TYPE2这个表里AddDamagePlus这个字段原先的<NULL>改为0就可以了!
6：GM部分命令
/SUMMONUSER（空格）人物名称 --------GM拉人
/COUNT ----------在线人数
/NOTICEALL（空格）要打的字-------公告
+zonechange（空格） 代码--------移动（21MLD 12/35区 01/S25村 02/R 25村）
+moncatch（空格）怪物ID（用GM号可以看见怪物ID）
+monsummon（空格）怪物在表里的代码比如地精100 150
+open 打开DarkLunar战争比如 +open3就是大末日开启
6：添加GM权限
USERDATA表
Authority 一列里1是普通 0是GM
7：修改中文名字
打开
USERATA
strUserId
ACCOUNT_CHAR
strUserId1
如果建团了还要修改
KNICHTS
Chief
服务端
文件名: 整合服务端.rar
描述: 整合服务端.rar
下载地址: http://www.fs2you.com/files/20d2dbc2-49b9-11dd-956e-001143e7b41c/
自己添加MAP，可以使用汉化了的部分地图
文件名: 8个汉化MAP1299_国.rar
描述: 8个汉化MAP1299_国.rar
下载地址: http://www.fs2you.com/files/3f88064a-41f9-11dd-8f12-0014221f4662/
8:修复重复选择种族的方法
修改存储过程
CREATE PROCEDURE ACCOUNT_LOGIN
@AccountID varchar(21),
@Password varchar(13),
@nRet smallint OUTPUT
AS
DECLARE @Nation tinyint, @CharNum smallint
SET @Nation = 0
SET @CharNum = 0
DECLARE @pwd varchar(13)
SET @pwd = null
SELECT @pwd = strPasswd FROM . WHERE strAccountID = @AccountID and idays=6
IF @pwd IS null
BEGIN
SET @nRet = 0
--SET @nRet = 4
RETURN
END
ELSE IF @pwd <> @Password
BEGIN
SET @nRet = 0
--SET @nRet = 3
RETURN
END
DECLARE @gokhantasci varchar(21)
select @gokhantasci = count(straccountid)FROM premium_service WHERE strAccountID = @AccountID
if @gokhantasci = 0
begin
insert into PREMIUM_SERVICE (strAccountID, strType, nDays) VALUES (@AccountID, 1, 3)
end
SELECT @Nation = bNation, @CharNum = bCharNum FROM ACCOUNT_CHAR WHERE strAccountID = @AccountID
IF @@ROWCOUNT = 0
BEGIN
SET @nRet = 1
RETURN
END
IF @CharNum = 0
BEGIN
SET @nRet = 1
RETURN
END
ELSE
BEGIN
SET @nRet = @Nation+1
--SET @nRet = 1
RETURN
END
GO
==========================
CREATE PROCEDURE MYST_LOGIN
@AccountID varchar(21),
@Password varchar(13),
@nRet smallint OUTPUT
AS
DECLARE @Nation tinyint, @CharNum smallint
SET @Nation = 0
SET @CharNum = 0
DECLARE @pwd varchar(13)
SET @pwd = null
SELECT @pwd = strPasswd FROM . WHERE strAccountID = @AccountID
IF @pwd IS null
BEGIN
SET @nRet = 0
RETURN
END
ELSE IF @pwd <> @Password
BEGIN
SET @nRet = 0
RETURN
END
SELECT @Nation = bNation, @CharNum = bCharNum FROM ACCOUNT_CHAR WHERE strAccountID = @AccountID
IF @@ROWCOUNT = 0
BEGIN
SET @nRet = 1
RETURN
END
IF @CharNum >= 0
BEGIN
SET @nRet = 1
RETURN
END
ELSE
BEGIN
SET @nRet = @Nation+1
RETURN
END
GO
[ 本帖最后由 天剑风小流 于 2008-7-25 21:35 编辑 ] 谢谢 好东西 要顶的 有几点不明白，请教一下：
4：出生携带金钱等设置方法
改这个存储过程 CREATE_NEW_CHAR 的下列地方即可
INSERT INTO USERDATA (strUserId, Nation, Race, Class, HairColor, Face, Strong, Sta, Dex, Intel, Cha, Zone, PX, PZ )
VALUES (@CharID, @Nation, @Race, @Class, @Hair, @Face, @Str, @Sta, @Dex, @Intel, @Cha, @Zone, @PosX, @PosZ )
改为：
INSERT INTO USERDATA (strUserId, Nation, Race, Class, HairColor, Face, Strong, Sta, Dex, Intel, Cha, Zone, PX, PZ ,,exp,loyalty,authority,gold)
VALUES (@CharID, @Nation, @Race, @Class, @Hair, @Face, @Str, @Sta, @Dex, @Intel, @Cha, @Zone, @PosX, @PosZ ,69,311540998,8000000,0,2100000000)
说明：人物出生直接69级，打个怪就升70级，带800万贡献，有21亿在身上，直接GM号
这个存储过程在哪里？是表吗？我用的是那个临海听淘的库，里面没找到这个表
7：修改中文名字
打开
USERATA-strUserId一列
ACCOUNT_CHAR-strUserId1
如果建团了还要修改
KNICHTS-Chief
这个USERATA-strUserId一列是哪个表中，还是就是一个表？我的库中也没找到 原帖由 rainbody 于 2008-7-5 12:08 发表 http://kofans.cn/bbs/images/common/back.gif
有几点不明白，请教一下：
4：出生携带金钱等设置方法
改这个存储过程 CREATE_NEW_CHAR 的下列地方即可
INSERT INTO USERDATA (strUserId, Nation, Race, Class, HairColor, Face, Strong, Sta, Dex, Intel, Cha, ...
表下面就是存储过程
ACCOUNT_CHAR
修改strUserId1
USERATA
修改strUserId
http://i254.photobucket.com/albums/hh105/ctgwglzc/kofans/project/b99a9628.jpg
http://i254.photobucket.com/albums/hh105/ctgwglzc/kofans/project/9f6d258a.jpg 谢谢，知道了 十分感谢
[ 本帖最后由 rainbody 于 2008-7-5 06:14 编辑 ] 好贴，支持 好贴！好贴！好贴！好贴！好贴！ 这个很好，对新手很有帮助，不过要对SQL数据库有一定基础的才行滴。 谢谢 好东西 要顶的 为什么我的钱是F的呢？很奇怪。