ar you sure bcaz i did all that and same errorOriginally Posted by papra
ar you sure bcaz i did all that and same error
always failed when try to install.bat on windows server 2008, any clue?
Solve
Last edited by Connected; 01-07-12 at 03:18 PM. Reason: os problem
already change all Ips in config files?
can we do team viewer?
@ connected
run as admin
follow the path
then it will be good
i tried buying files from 175.com
but
nah its very hard lolz
Delete all ODBC setting and create again here again;
C:\Windows\SysWOW64\odbcad32.exe as run Administrator
@ModGift did you try to check this?
this was the fix I made for the LDBI: Reg Failed
1. Go to MKZ_LGameDB_30 >> GameServer >>Change the IP's under F_IP = your IP
2. Go to MKZ_LUserDB_30 >> GameServer >>Change the IP's under F_IP = your IP
3. Go to MKZ_RUserDB_30 >> GameServer >>Change the IP's under F_IP = your IP
All changed.
but same error;
Last edited by ModGift; 01-07-12 at 04:02 PM.
change your user and password, that papra said is true after editing SP no error again
change what user and pass? i did that sp and din`t work
maby can you upload a db backup?
use this
@echo on system\MetalKnightZeroClient.exe -SHELLCONNECT -LSIP 192.168.1.35 -LSPORT 4502 -P2PIP 192.168.1.35 -P2PPORT 60481 -GSIP 192.168.1.35 -GSPORT 2008 -USER lixi000002 -PWD 96e79218965eb72c92a549dd5a330112 -CHECKID test2 -CHECKTEX test -PartnerCode ??? -BIGZONEID 1 -BIGZONENAME [Test] -ZONEID 1 -ZONENAME [Test] -GSID 1 -GSNAME test pause
problem fix , was 1 more SP _LDBI_ForceUserLogout
now im working on a login shop
(done the login with md5 password + secure login session page)
if anyone else is working at shop just tell me ,maby in 2 will be easy
Last edited by DELUXX; 02-07-12 at 01:24 AM. Reason: update
this one _LDBI_ForceUserLogout
if u remove the two lines what papra said
it will enable mutli client in one PC
K guy i made the perfect fix for User logout
- Execute this Query
This will add the missing table
2- Execute this Query nowPHP Code:USE [MKZ_LGameDB_30]
GO
/****** Object: Table [dbo].[T_PlayedUser] Script Date: 07/02/2012 02:36:48 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[T_PlayedUser](
[F_ID] [int] NULL,
[F_UserID] [int] NOT NULL,
[F_UserName] [nchar](20) NOT NULL,
[F_LoginTime] [datetime] NOT NULL,
[F_LogoutTime] [varchar](20) NULL,
[F_LoginIP] [varchar](20) NOT NULL,
[F_GameIP] [varchar](20) NOT NULL,
[F_GamePort] [int] NOT NULL,
[F_GSID] [int] NOT NULL,
[F_FeeType] [tinyint] NOT NULL,
[F_Desc] [varchar](50) NOT NULL,
[F_ParentID] [int] NOT NULL,
[F_FileIndex] [tinyint] NULL,
[F_AreaID] [int] NOT NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
(this will fix youyr Stored Procedures)
it may give some error after execute but all is ok
Sp.txt
LDBI logs now
PHP Code:] DB_User_Check:nCode=1,UserName=TWMKZ000001,nUserID=2,nSeconds=999940902,nGSID=2.
[02:35:38:562][11052 ][OK ] after DB_CheckIsAdult: UserID=2, nAdult=0, Code=1
[02:35:38:562][11052 ][Info ] after DB_User_Login
[02:35:38:562][11052 ][OK ] GATE2LDBI Login(YProtectionStart): nUserID=2, LoggedID=155847, szPersionalID=000000900000000002, nConnectionId=2
[02:35:38:562][2436 ][OK ] [NMC_YP2LDBI_LOGINRETURN] GATE2LDBI Login: LoggedID=155847.
[02:35:38:593][11052 ][Info ] Check Point OK! LoggedID=155847, UserID=2, roleID=4508554, nConnectID=67629516, Point=999940902
[02:35:38:609][11052 ][Info ] recv [NMC_GATE2LDBI_LISTCHA] user:, userId:2, role:, roleId:-1, clientIndex:2, clientId:2, gateIndex:1, gateId:2, LoggedID=155847, CharacterePos=0
[02:35:38:609][11052 ][Info ] after DB_Get_RoleList
[02:35:38:609][11052 ][Info ] send [NMC_GATE2LDBI_LISTCHA] user:, userId:2, role:, roleId:54582536, clientIndex:2, clientId:2, gateIndex:1, gateId:2, LoggedID=155847, CharacterePos=0, Code=1014.
[02:36:12:640][11052 ][OK ] [YProtectionEnd] GATE2LDBI Logout: LoggedID=1, GSConnectedID=155847
[02:36:12:656][11052 ][OK ] FORCE USER LOGOUT ok,user=TWMKZ000001,GSID=2,code=1
Last edited by DELUXX; 02-07-12 at 01:56 AM.
@ DELUXX
this is what papra said right
if you remove that one from here/*fixed by kyj 2005-7-4
insert into GameLogDB..T_UserApplyLog(F_UserID,F_UserName,F_GClientID,F_UserIP,F_Type,F_Seconds,F_GSID,F_UpdateTime,F_ReturnFlag,F_RoleID,F_RoleName)
values(@UserID,@UserName,@gClientID,@UserIP,7,@FeeValue,@GSID,@now,0,@RoleID,@RoleName)
*/
this one _LDBI_ForceUserLogout ( this solve my problem but allow user to do multi client)
it will allow users to play multi client in one pc
but i dunno if theres flaw in that part
maybe yes maybe no
i hope not
i saw it in your SP txt
tnx.
edit:
can anyone know how to buy ingots?
its very hard
even if they allow paypal
i cant purchased lolz
Edit:
this is weird
i restore all my works
use the orignal DB
and all my problems gone wew
i guess it was just my PC after at all
Last edited by ramispo; 02-07-12 at 05:43 AM.
my fix make server work normal, and if you remove that one you will only make bugs sooner or later
anyway db still need some fix some table missing etc ...
post alot in forum for ingots
okey ill use ur scripts now
i want to buy that patch they said
but when i purchased using paypal
always says invalid account
and honestly
i dont understand there method of payment
tnx for the scripts
ill use it now
and test
Reply With Quote
