[1299] my files u can login the game

yl941 · 2008-4-13 12:12:19

原始数据库根本启动不了，修改了也不行，每次开启Ebenzer一会应该是加载完地图后就会显示AI出错，查了半天找不到原因，郁闷ing。。。

[ 本帖最后由 yl941 于 2008-4-13 23:13 编辑 ]

泪怜芳草 · 2008-4-13 13:50:19

别放弃,至少别人能启动,自己找找原因吧!!!

709394 · 2008-4-13 15:28:38

数据源开个KN_Data可以解决问题,但Eb启动不久后就来个AI Server Connect Fail

yl941 · 2008-4-13 22:31:14

原帖由 709394 于 2008-4-13 15:28 发表
数据源开个KN_Data可以解决问题,但Eb启动不久后就来个AI Server Connect Fail

的确是这样，这个问题可能是EB里面版本信息和服务器里面的版本信息不一致引起的，EB里面显示的1298的数据，和1299的不对应

瞎子 · 2008-4-14 10:06:30

可怜不是国人知道搞出来的.

crazyfish6 · 2008-4-14 13:23:45

只有一个莫拉登地图。。别的没有缺少DATA，没NPC

[ 本帖最后由 crazyfish6 于 2008-4-14 13:37 编辑 ]

ctgwglzc · 2008-4-14 16:02:26

(insert User in TB_user)

复制代码

Procedure ACCOUNT_LOGIN

-- Procedure update by [email protected]
-- Ex Comunidad Apocalipsis - MicroGames
Alter PROCEDURE ACCOUNT_LOGIN
@AccountID varchar(21),
@Password varchar(13),
@nRet smallint OUTPUT
AS
select @nRet=count(*) from tb_user where straccountid=@AccountID
if @nRet=0
begin
insert into tb_user values (@AccountID , @Password , 1 , 6 , 1 ,1)
set @nRet=1
RETURN
end
DECLARE @Nero tinyint, @PlayerTurk smallint, @Lethe int, @Vipspawn int , @matrix1536 int
SET @Nero = 0
SET @PlayerTurk = 0
DECLARE @pwd varchar(13)
SET @pwd = null
IF @pwd <> @Password
BEGIN
SET @nRet = 3
RETURN
END
IF @Vipspawn=0
begin
set @nRet=11
RETURN
end
IF @Lethe = 0
begin
set @nRet=12
RETURN
end
IF @matrix1536=0
begin
set @nRet=4
RETURN
end
select @nRet=count(*) from currentuser where straccountid=@AccountID
IF @nRet>0
begin
set @nRet=5
RETURN
end
SELECT @Nero = bNation, @PlayerTurk = bCharNum FROM ACCOUNT_CHAR WHERE strAccountID = @AccountID
IF @@ROWCOUNT = 0
BEGIN
SET @nRet = 1
RETURN
END
IF @PlayerTurk = 0
BEGIN
SET @nRet = 1
RETURN
END
ELSE
BEGIN
SET @nRet = 1
RETURN
END
GO

复制代码

ctgwglzc · 2008-4-14 16:05:29

first
Server Files : ServeR Filesler.zip ... at uploaded.to - Free File Hosting, Free Image Hosting, Free Music Hosting, Free Video Hosting, ...
Database : RapidShare Webhosting + Webspace

download it files and
ebenezer file in create

Notice.txt
BlockWord.txt
HackToolList.txt

if aujard server.ini port 127.0.0.1 change to 80
(some guys possible 15001)

files okey.
now DB add procedure

/****** Object: Stored Procedure dbo.PROC_INSERT_CURRENTUSER Script Date: 09/04/2008 6:03:32 PM ******/
-- 2008.04.09. ESTHECAT
CREATE PROCEDURE PROC_INSERT_CURRENTUSER
@ServerNo int,
@ServerIP varchar(50),
@AccountID varchar(50),
@CharID varchar(50),
@ClientIP varchar(50),
@nret smallint output
AS
INSERT INTO CURRENTUSER ( nServerNo, strCharID, strAccountID, strServerIP, strClientIP ) Values (@ServerNo, @ServerIP, @AccountID, @CharID, @ClientIP )
set @nret=1
GO

复制代码

how do i add?
you can add from Query analyzer

and add table

复制代码

table name is

复制代码

server files arange

复制代码

瞎子 · 2008-4-14 17:16:29

我决定要重新学英文.怒

ctgwglzc · 2008-4-18 14:37:50

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

Fix error Login