MKZ MMOFPS [Files-Database-Client [EN] Complete]

luvssti said:
@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
Click to expand...
All changed.
but same error;
 
Last edited:
DELUXX said:
change what user and pass? i did that sp and din`t work
maby can you upload a db backup?
Click to expand...

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
Click to expand...
 
Connected said:
use this
Click to expand...

problem fix , was 1 more SP _LDBI_ForceUserLogout :w00t:
now im working on a login shop
(done the login with md5 password + secure login session page)
:wink:
curtns - MKZ MMOFPS [Files-Database-Client [EN] Complete] - RaGEZONE Forums


if anyone else is working at shop just tell me ,maby in 2 will be easy
 
Last edited:
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

  1. Execute this Query
This will add the missing table
PHP: 
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
2- Execute this Query now
(this will fix youyr Stored Procedures)
it may give some error after execute but all is ok
View attachment Sp.txt

LDBI logs now
PHP: 
 ] 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

:thumbup1:
 
Last edited:
@ DELUXX
this is what papra said right

/*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)
*/
Click to expand...

if you remove that one from here

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:
ramispo said:
@ DELUXX
this is what papra said right



if you remove that one from here

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
Click to expand...


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
 
ramispo said:
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
Click to expand...

i got an account there and got like (posts = points) 20 =1 ingot ,but u can exchange points for ingots after 110 points ... and ftp password cost 1 ingot
 
all works fine now..
player with 10 to 15 users online hamachi
only 1 issue i encountered before
but its fixed now
 
[22:39:09:656][3300 ][Failed ] LGamedb [DBError] Number: 0x80040E14(-2147217900)
NativeError: 0x00000AFC(2812)
Source: Microsoft OLE DB Provider for ODBC Drivers
Description: [Microsoft][SQL Server Native Client 10.0][SQL Server]找不到存储过程 '_LDBI_RoleUpdate'。
SQLState: 37000
 
anyone know how to add new user and password? which DB and table?
 
Connected said:
anyone know how to add new user and password? which DB and table?
Click to expand...

DB - MKZ_LUserDB_30

Table - T_UserCore

Register script

index.php

PHP: 
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">

<style type="text/css">
	* { margin: 0px; padding: 0px; }
	body, html { background-color: black; margin: 0px; padding: 0px; }
	a img { border: 0px; }
	#pageWrapper { }
	
	#announcementsBox {width: 250px; }
	#announcementsBox .header { padding: 0px; background: #666666 url(NOTICE_annHeaderBack.jpg) repeat-x center top; border: solid 1px #919191; text-align: center; height: 23px; }
	#announcementsBox .header img { margin: 0px auto; height: 23px; }

	#announcementsBox .content { border: solid 1px #222222; padding-top: 0px; }
	#announcementsBox .content ul { padding: 0px 10px; list-style-type: none; height: 108px; }
	#announcementsBox .content ul li { border-bottom: solid 1px #222222; overflow: hidden; }
	#announcementsBox .content ul li.first { border-top: solid 1px #222222; }
	#announcementsBox .content ul li a, #announcementsBox .content ul li a:link, #announcementsBox .content ul li a:visited, #announcementsBox .content ul li a:active { position: relative; font: bold 10px/20px Verdana, Arial, Helvetica, sans-serif; color: white; display: block; text-decoration: none; height: 20px; padding: 0px 0px;}
	#announcementsBox .content ul li a:hover { background-color: #222222; }
	#announcementsBox .content ul li a #date { white-space: nowrap; font: normal 10px/20px Verdana, Arial, Helvetica, sans-serif; text-align: right; position: absolute; right: 0px; top: 0px; color: #666666;  }
/*	#announcementsBox .content ul li a #date.new { background: url(NOTICE_new.gif) no-repeat left top; padding-left: 47px;} */
	
	#announcementsBox .content a#more, #announcementsBox .content a#more:link, #announcementsBox .content a#more:visited, #announcementsBox .content a#more:active { display: block; float: right; background: #333333 url(../../themes/shaiya/images/notice/NOTICE_moreLinkBack.jpg) repeat-x center center; margin: 0px; font: bold 10px/14px Verdana, Arial, Helvetica, sans-serif; color: white; text-decoration: none; border: solid 1px #333333; padding: 0px 8px 4px 8px; }
	#announcementsBox .content a#more:hover { text-decoration: underline; }

	#aeriaMenu ul {width:250px; height: 32px; background: url(NOTICE_aeriaMenuBack.jpg) repeat-x right top; overflow:hidden; }
	#aeriaMenu ul li { float: left; width: 49%; display: inline;}
	
	.clear { clear: both; }
</style>



<center><img src=http://img4.mmo.mmo4arab.com/news/gaming_china/game/mkzlogo.jpg></img><br><h3><font color=yellow>MKZ Romania<br>REGISTRATION</font></h3>
<h3>Reg</h3>
<form name="form" method="post" action="1.php"> 
<p> 
<b><font color=yellow size=2>Login:</font></b><br>
<input type=text name=nikk><br>
<b><font color=yellow size=2>Password:</font></b><br>
<input type=text name=pass><br>
<b><font color=yellow size=2>Confirm the password:</font></b><br>
<input type=text name=pass2><br>
<input type="submit" name="Submit" value="Submit"> 
</p> 
</form>


1.php

PHP: 
<?php
$myServer = "127.0.0.1,1433";
$myUser = "sa";
$myPass = "123456";
$myDB = "MKZ_LUserDB_30";

$nickn = $_POST['nikk'];
$ps = $_POST['pass'];
$ps2 = $_POST['pass2'];
$passwordM5 = md5($_POST['pass']);
$email="";
$PwQuestion="who";
$PwAnswer="im";
//**********************CHECK BLOCK*************************************************************
$nickn = trim($nickn);
$ps = trim($ps);
$ps2 = trim($ps2);
if(ereg("[^0-9a-zA-Z_-]", $nickn, $str))
	{
	echo '<center>Login not in good format.';
	echo '<br><br><a href="index.php"></a></center>';
	}
elseif(ereg("[^0-9a-zA-Z_-]", $ps, $str))
	{
	echo '<center>Password not in good format.';
	echo '<br><br><a href="index.php"></a></center>';
	}
elseif (empty($nickn) || empty($ps) || empty($ps2)) 
	{
	echo '<center>Fill in the empty fields.<br><br><a href=index.php>Return to Registration</a></center>';
	}
$conn=mssql_connect($myServer,$myUser,$myPass);
if (!$conn)
  {exit("Connection Failed: " . $conn);}
$selected = mssql_select_db($myDB, $conn) or die("Couldn't open database $myDB");
//Check DB aldedy exist login
$resultx=mssql_query("SELECT F_UserName FROM  T_UserCore WHERE (F_UserName) = ('$nickn')") or die;
if (mssql_num_rows($resultx))
		{
		echo '<center>The account '.$nickn.' already exists.<br><br><a href=index.php>Return to Registration</a></center>';
exit;	
	}
	elseif ($pw != $cpw) 
		{
		echo '<center>Passwords mismatch.<br><br><a href=index.php>Return to Registration</a></center>';
exit;
		}
//*********************************************************************************************		

$sql=("SELECT MAX(F_UserName) FROM T_UserCore");
$rsA=mssql_query($sql);
if (!$rsA)
{exit("Error in SQL");}
$rrow=mssql_fetch_array($rsA);
$bb=rand(1, 1000000); 
$sql=("INSERT INTO T_UserCore (F_ID, F_UserName, F_PassWord, F_Type) VALUES ($bb,'$nickn', '$ps',1)");
$rs=mssql_query($sql);
if (!$rs)
{exit("Error in SQL");}
mssql_close($conn);
echo 'The account is created successfully.Welcome to game MKZ Romania!!!<br><br><a href=index.php>Return to Registration</a>';
?>
------------------------------------------------------

done the Clan ranking 90%

2 - MKZ MMOFPS [Files-Database-Client [EN] Complete] - RaGEZONE Forums
 
Last edited:
str8killa said:
Naty48 - MKZ MMOFPS [Files-Database-Client [EN] Complete] - RaGEZONE Forums


still need to fix this
Click to expand...

try
DB- MKZDB
Table- GameServerConfigTable


PingCfg Ping_SolongKick 500 Ping values ​​are too high time
PingCfg Ping_TestTime 10.0 Ping the value of the detection time
PingCfg Ping_ValidPer 0.6 Ping value detection rate of qualified
PingCfg PingTimeOnReady 10.0 Detection time to prepare the interface of Ping
try this
PingCfg PingTimeOnReady 22210.0 Detection time to prepare the interface of Ping

don`t know if work ,let me know if work
And this is for how many client peer IP can be open

Config OpenOneInstance 1 Allow only start the instance of a client (you can start more than one can only start one)
 
Last edited:
You must log in or register to reply here.

RaGEZONE Sponsor

    HyperFilter

About RaGEZONE

RaGEZONE® is a leading MMO and MMORPG development community offering source codes, server files, tutorials, tools, and private servers for developers and gamers.

Forum Statistics

Members online
2,791
Guests online
16,054
Total visitors
18,845
Totals may include hidden visitors.

RaGEZONE Partners

    non GamStop casinos
Back