[RELEASE] WORKING Fixed Serverfiles+English gameclient!

12/07/2008 16:37 silkbotter#1
update:17.09.09
a full working image of a dekaron server for vmware was posted here --> [Only registered and activated users can see links. Click Here To Register...]



update:18.03.09
my release had some errors.
the server fixes are:
- d-shop working
- tele to space working
- teleporter in maze to deatrhland fixed.
file:
[Only registered and activated users can see links. Click Here To Register...]
--------------------------------
admin panel fix:
- coins-add-system fixed.
file:
[Only registered and activated users can see links. Click Here To Register...]


there's still the bug that you won't be teleported to acquirai ruins if you run over the npc in front of the teleporter on north morte. you can fix that by yourself




This post will be updated if anything new happens!!
updated 06.03.09
-added the client download
-here's the rest of my serverfile releases: [Only registered and activated users can see links. Click Here To Register...]

updated 05.03.09
Our member "Nightwish10" stole my rapidshare account and deleted the client.
i'm uploading the new compatible client (A6 Difference client). the download-links will be updated as soon as the client is up.

updated 27.02.09
added the sn.txt
launched own dekaron private server. webpage can be found@my sig or [Only registered and activated users can see links. Click Here To Register...]
new stuff? yeah.. new summoner skills, more to come later..
here a clean database:
NOT-WORKING-DB

here's the working database with 0 accountnames entry:
[Only registered and activated users can see links. Click Here To Register...]

this db contains all the characters and stuff, but doesn't contain any accounts.
remember: you need to set-up the reg-page in order to create an account and to play on your own server ;)

hello ladys.
well, i spent my whole weekend working on the serverfiles compatibility with an english gameclient!
and guess what... i made it :)

you just need 2 things: the serverfiles and the apropriate english gameclient.



here are the fixed and modified serverfiles.(Difference A6)
[Only registered and activated users can see links. Click Here To Register...]

here's the web-registration files:
[Only registered and activated users can see links. Click Here To Register...]
web files config:
open your config.inc.php.
Quote:
<?php

//开始session
session_start();

//设置不进行本地缓存
header('Expires: '.date('D,d M Y H:i:s',mktime(0,0,0,1,1,2000)).' GMT');
header('Last-Modified:'.gmdate('D,d M Y H:i:s').' GMT');
header('Cache-control: private, no-cache,must-revalidate');
header('Pragma: no-cache');

$db_name="SHOULD BE ACCOUNT";
$db_host="DATABASE HOST";
$db_user="DB USERNAME";
$db_pwd="DB PASSWORD";
?>
then open register.php
Quote:
<?php

require_once "config.inc.php";

if(isset($_SESSION[step2]) && isset($_POST[step2])) {
//提取的最后一步
$errorStr = formStep3();
if($errorStr!=null){
require_once('register.html');
}else{
require_once('success.html');
$suc=$success;
unset($_SESSION[step2], $_SESSION[step1]);
}}
else {
//注册的第二步
require_once('register.html');
$_SESSION[step2] = 1; }


//判断用户提交的表单的数据的 准确性 和 保存提交数据 的函数
function formStep3(){
$errors = array();
$errorStr = null;
//查询用户名是否存在
$strSql="select * from Tbl_user where user_id='$_POST[username]'";
if ($_POST[ZoneGroup]=="zone1") {
$account_odbc = odbc_connect('account','DB SQL USER','DB SQL PASSWORD');
} elseif ($_POST[ZoneGroup]=="zone2") {
$account_odbc = odbc_connect('account2',DB SQL USER','DB SQL PASSWORD');
} else {
die ("<p><b>分区选择错误!</b></p>");
}
$user_result=odbc_do($account_odbc,$strSql);
$result_query=odbc_fetch_row($user_result);
if (odbc_result($user_result,1)!= "") $errors[] = "该名称已�*被占用,请重新输入";
//验证用户名是否规范
if(!preg_match("/^[0-9a-zA-Z]{6,12}$/i", $_POST[username])) $errors[]="只能用英文大小写字母数字的组合作为用户名";
//验证用户名长度
if(strlen($_POST[username])<6) $errors[] = "用户名的长度不能小于6位";
if(strlen($_POST[username])>12) $errors[]= "用户名的长度不能超过12位";
//验证密码是否规范
if(!preg_match("/^[0-9a-zA-Z]{6,12}$/i", $_POST[password1])) $errors[]="只能用英文大小写字母数字的组合作为密码";
if(preg_match("/^[0-9]{6,12}$/i",$_POST[password1])) $errors[]="不可使用纯数字作为密码";
//验证用户名和密码是否相同
if($_POST[username]==$_POST[password1]) $errors[]= "帐号和密码不能相同";
//验证密码长度
if(strlen($_POST[password1])<6) $errors[] = "密码的长度不能小于6位";
if(strlen($_POST[password1])>12) $errors[] = "密码长度不能大于12位";
//验证密码一致性
if($_POST[password2]!=$_POST[password1]) $errors[] = "输入的密码不一致";
//验证找回密码问题答案长度
if(strlen($_POST[question])>20) $errors[] = "找回密码问题大于20位,请返回重新输入";
if(strlen($_POST[question])<10) $errors[] = "找回密码问题小于10位,请返回重新输入";
if(strlen($_POST[answer])>20) $errors[] = "找回密码答案大于20位,请返回重新输入";
if(strlen($_POST[answer])<10) $errors[] = "找回密码答案小于10位,请返回重新输入";
//验证用户email正确性
if(!preg_match("/^\w+([-+.]\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*$/i",$_POST[mail])) $errors[]="Email地址不正确,请重新输入正确的Email地址";


//错误信息输出
if(sizeof($errors)>0){
$errorStr .= "<br><font>";
$errorStr .= "信息输入错误:";
foreach($errors as $error)
$errorStr .= "<li>$error</li>";
$errorStr .= "</font><br><br>";
}else{

//加密密码
$passwd_user=md5($_POST[password1]);
//获取user_no
$dk_time=strftime("%y%m%d%H%M%S");
list($usec1, $sec1) = explode(" ",microtime());
$dk_user_no=$dk_time.substr($usec1,2,2);
//用户注册语句
$dk_account_query="insert into user_profile(user_no,user_id,user_pwd,resident_no, user_type,login_flag,login_tag,ipt_time,login_time ,logout_time,user_ip_addr,server_id) values('$dk_user_no','$_POST[username]','$passwd_user','801011000000','1','0','Y','01/01/2006 00:00:00',null,null,null,'000')";
//用户资料保存
$dk_account_query2="insert into Tbl_user(user_no,user_id,user_pwd,user_mail,user_a nswer,user_question) values('$dk_user_no','$_POST[username]','$_POST[password1]','$_POST[mail]','$_POST[answer]','$_POST[question]')";
//执行用户注册和资料保存语句
$dk_account_result1=odbc_do($account_odbc,$dk_acco unt_query);
$dk_account_result2=odbc_do($account_odbc,$dk_acco unt_query2);
odbc_close($account_odbc);



}
//返回错误消息到页面
return $errorStr;
}

?>
don't forget to create a system dns odbc driver linked to "account" database ;)

here the php administration tools: [Only registered and activated users can see links. Click Here To Register...]
do the same things on the single php files as you made on the registration.

here the Difference Action 6 client:

[Only registered and activated users can see links. Click Here To Register...]
[Only registered and activated users can see links. Click Here To Register...]
[Only registered and activated users can see links. Click Here To Register...]
[Only registered and activated users can see links. Click Here To Register...]
[Only registered and activated users can see links. Click Here To Register...]
[Only registered and activated users can see links. Click Here To Register...]
[Only registered and activated users can see links. Click Here To Register...]
[Only registered and activated users can see links. Click Here To Register...]
[Only registered and activated users can see links. Click Here To Register...]
[Only registered and activated users can see links. Click Here To Register...]
[Only registered and activated users can see links. Click Here To Register...]


the things you need to do?
well.. the same as the ones in this video: [Only registered and activated users can see links. Click Here To Register...]

a video-step-by-step-clicktutorial will be added later...

give me some reputation if you enjoyed this release.
you know... reputation is everything ;)
i'm not begging. i'm just asking you to be fair ;)

Have fun with the release ^^


---EDIT1---
known bugs:
- hatching an egg from the D-Shop is not possible;
- it's not possible to insert pots in slots F4, F5 and F6
(dunno if the same problem exists on 2moons/Dekaron)
- Transparency of the map doesn't work
- Npc-Search on the map doesn't work
(but hey, you just need to put your mouse over the npc-points on the map)



changing XP/DROP/ETC ratios:
1-edit the values in the "share" folder of the server folder (for example "server/share/formula.ini").
2- make sure you edit the same stuff on the dekaron-p.server client



future plans:
-fixing bugs ;)
- adding even more stuff in the d-shop (like argates etc)


since everybody is too lame to go 5 pages foward, here's the sn.txt:

Quote:
EXEC sp_addlinkedserver 'LSV_GHBILL','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'LSV_DKRACNT','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'DKRCASH','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'LSV_DKRHELION','','MSDASQL',NULL,NULL,'DRIVER={SQ L Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'LSV_DKRNUNVICE','','MSDASQL',NULL,NULL,'DRIVER={S QL Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'LSV_DKRQUNE','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'LSV_DKRRONDOW','','MSDASQL',NULL,NULL,'DRIVER={SQ L Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'LSV_DKRSIZ','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'LSV_DKRTEST','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'LSV_DKRZUTO','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'LSV_DKRSTA','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'DKRACCOUNT01','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'

exec sp_serveroption 'LSV_GHBILL','rpc out','true'
exec sp_serveroption 'LSV_GHBILL','rpc','true'
exec sp_serveroption 'LSV_DKRACNT','rpc out','true'
exec sp_serveroption 'LSV_DKRACNT','rpc','true'
exec sp_serveroption 'DKRCASH','rpc out','true'
exec sp_serveroption 'DKRCASH','rpc','true'
exec sp_serveroption 'LSV_DKRHELION','rpc out','true'
exec sp_serveroption 'LSV_DKRHELION','rpc','true'
exec sp_serveroption 'LSV_DKRNUNVICE','rpc out','true'
exec sp_serveroption 'LSV_DKRNUNVICE','rpc','true'
exec sp_serveroption 'LSV_DKRQUNE','rpc out','true'
exec sp_serveroption 'LSV_DKRQUNE','rpc','true'
exec sp_serveroption 'LSV_DKRRONDOW','rpc out','true'
exec sp_serveroption 'LSV_DKRRONDOW','rpc','true'
exec sp_serveroption 'LSV_DKRSIZ','rpc out','true'
exec sp_serveroption 'LSV_DKRSIZ','rpc','true'
exec sp_serveroption 'LSV_DKRTEST','rpc out','true'
exec sp_serveroption 'LSV_DKRTEST','rpc','true'
exec sp_serveroption 'LSV_DKRZUTO','rpc out','true'
exec sp_serveroption 'LSV_DKRZUTO','rpc','true'
exec sp_serveroption 'LSV_DKRSTA','rpc out','true'
exec sp_serveroption 'LSV_DKRSTA','rpc','true'
exec sp_serveroption 'DKRACCOUNT01','rpc out','true'
exec sp_serveroption 'DKRACCOUNT01','rpc','true'


/GM DISTRIBUTE
/GM PLAYERCOUNT
/GM SUMMON [PC ID]
/GM RETURN [PC ID]
/GM ITEMDROPRATIO [ItemDropRatio(1.0)]
/GM MONEYDROPRATIO [MoneyDropRatio(1.0)]
/GM MOVEMAP [MAPINDEX] [X] [Y]
/GM RESET_ALLMONSTER
/GM RESETMONSTER [MONSTERINDEX]
/GM ghostmode [on/off]
/GM observermode [on/off]
/GM callmonster [MonsterIndex]
/GM callmonsters [index] [count]
/GM kick [PC ID]
/GM revive [PC ID]
/GM heal [PC ID]
/GM find [PC ID]
/GM chase [PC ID]
/GM dummycount
/GM damage [on/off]
/GM createbrick [BrickID]
/GM destroybrick [BrickID]
/GM guildheal [pc name]
/GM fieldheal [map index]
/GM guildreturn [pc name]
/GM fieldreturn [map index]
/GM siegereset
/GM siegestop
/GM siegestart [time]
/GM siegeend [time]
/GM guildwarstart [time]
/GM guildwarend [time]
/GM open_teleport
/GM close_teleport
/GM resetcooltime
/GM resetcooltime_map
/GM partywarstart [time]
/GM partywarend
/GM observermode [on/off]
/GM call [PC ID]
/GM callmonster [MonsterIndex]
/GM callmonsters [index] [count]
/GM chase [PC ID]
/GM close_teleport
/GM createbrick [BrickID]
/GM damage [on/off]
/GM destroybrick [BrickID]
/GM DISTRIBUTE
/GM dummycount
/GM EXPRATIO [比率]
/GM fieldheal [map index]
/GM fieldreturn [map index]
/GM find [PC ID]
/GM FINISH [Kick 时间] ([结束时间])
/GM ghostmode [on/off]
/GM guildheal [pc name]
/GM guildreturn [pc name]
/GM guildwarend [time]
/GM guildwarstart [time]
/GM heal [PC ID]
/GM ITEMDROPRATIO [ItemDropRatio(1.0)]
/GM kick [PC ID]
/GM MAXPC [地图上的 Max Player 数字]
/GM MAXPLAYER [Max Player 数字(包括待机)]
/GM MONEYDROPRATIO [MoneyDropRatio(1.0)]
/GM MOVEMAP [MAPINDEX] [X] [Y]
/GM NOTICE \[公告内容]\
/GM observermode [on/off]
/GM open_teleport
/GM partywarend
/GM partywarstart [time]
/GM PLAYERCOUNT
/GM REGEN [怪物复活速度 (百分率)]
/GM RESET_ALLMONSTER
/GM resetcooltime
/GM RESETMONSTER [MONSTERINDEX
/GM RETURN [PC ID]
/GM revive [PC ID]
/GM siegeend [time]
/GM siegereset
/GM siegestart [time]
/GM siegestop
/GM SUMMON [PC ID]
12/07/2008 16:48 GodsPirate#2
Bravo!
12/07/2008 19:34 DoubleDTheGreat#3
working well for me, thanks a lot
12/07/2008 19:48 JagoDragon#4
Very Very Nice will be checking this out later on, im a big fan of 2Moons/Dekaron so this will be fun :)
12/07/2008 19:51 Farmer John#5
Do i have to download those client part files? or can i just grab the Dk extreme server client? and use the server files with it? or would that be the same?
part files are ok...but if ur not a premium user, you have to download them 1 at a time.
12/08/2008 02:51 cre4tiv3#6
can some1 upload this on a mirror?
12/08/2008 04:38 -=ToMiK=-#7
Someone needs to make a tut how to create a server with these files...or better just create a video of you making a server.......WOULD GET HELLA THANKS....
12/08/2008 05:05 GrandSlam#8
its quite easy really ill make a video and post it later
12/08/2008 06:39 loonbg#9
how can i clear data base for account's and charcaters ?
12/08/2008 06:43 men944#10
nice :D
12/08/2008 07:32 silkbotter#11
use the client that i uploaded.
the official dekaron extreme client data.pak contains different values and won't be compatible with the server values. you'll get a "incorrect game version" ;)

and as i said: when i'll get some free time i'll make a noob-tutorial that everybody will understand ;)
12/08/2008 07:36 TyroneBiggums#12
where can i find gm commands for it?

like .add+9 caligo xD
12/08/2008 07:40 silkbotter#13
these are the only known gm commands:

Quote:
/GM DISTRIBUTE
/GM PLAYERCOUNT
/GM SUMMON [PC ID]
/GM RETURN [PC ID]
/GM ITEMDROPRATIO [ItemDropRatio(1.0)]
/GM MONEYDROPRATIO [MoneyDropRatio(1.0)]
/GM MOVEMAP [MAPINDEX] [X] [Y]
/GM RESET_ALLMONSTER
/GM RESETMONSTER [MONSTERINDEX]
/GM ghostmode [on/off]
/GM observermode [on/off]
/GM callmonster [MonsterIndex]
/GM callmonsters [index] [count]
/GM kick [PC ID]
/GM revive [PC ID]
/GM heal [PC ID]
/GM find [PC ID]
/GM chase [PC ID]
/GM dummycount
/GM damage [on/off]
/GM createbrick [BrickID]
/GM destroybrick [BrickID]
/GM guildheal [pc name]
/GM fieldheal [map index]
/GM guildreturn [pc name]
/GM fieldreturn [map index]
/GM siegereset
/GM siegestop
/GM siegestart [time]
/GM siegeend [time]
/GM guildwarstart [time]
/GM guildwarend [time]
/GM open_teleport
/GM close_teleport
/GM resetcooltime
/GM resetcooltime_map
/GM partywarstart [time]
/GM partywarend
/GM observermode [on/off]
/GM call [PC ID]
/GM callmonster [MonsterIndex]
/GM callmonsters [index] [count]
/GM chase [PC ID]
/GM close_teleport
/GM createbrick [BrickID]
/GM damage [on/off]
/GM destroybrick [BrickID]
/GM DISTRIBUTE
/GM dummycount
/GM EXPRATIO [比率]
/GM fieldheal [map index]
/GM fieldreturn [map index]
/GM find [PC ID]
/GM FINISH [Kick 时间] ([结束时间])
/GM ghostmode [on/off]
/GM guildheal [pc name]
/GM guildreturn [pc name]
/GM guildwarend [time]
/GM guildwarstart [time]
/GM heal [PC ID]
/GM ITEMDROPRATIO [ItemDropRatio(1.0)]
/GM kick [PC ID]
/GM MAXPC [地图上的 Max Player 数字]
/GM MAXPLAYER [Max Player 数字(包括待机)]
/GM MONEYDROPRATIO [MoneyDropRatio(1.0)]
/GM MOVEMAP [MAPINDEX] [X] [Y]
/GM NOTICE \[公告内容]\
/GM observermode [on/off]
/GM open_teleport
/GM partywarend
/GM partywarstart [time]
/GM PLAYERCOUNT
/GM REGEN [怪物复活速度 (百分率)]
/GM RESET_ALLMONSTER
/GM resetcooltime
/GM RESETMONSTER [MONSTERINDEX
/GM RETURN [PC ID]
/GM revive [PC ID]
/GM siegeend [time]
/GM siegereset
/GM siegestart [time]
/GM siegestop
/GM SUMMON [PC ID]
I'll try to crack the gm-tool. it may be easier to work with that ;)
12/08/2008 08:59 loonbg#14
can eny say hoy to clean data base for account's charcaters ?
12/08/2008 11:54 myst1337#15
Hello,
Why is that my SessionServer says error, i start it and in 5 secs it says error, and how can i add myself GM?
Also, 6 - \Dekaron gameclient\p-server connector (open it with an hex-editor, and replace the ip adresses (2) 192.168.5.7 with your server-ip)
Whats it? help me pls.