[Release Dev]Icarus Online Unpaker, server emu + sql, tools, launcher, reg script

[Tahoma2]

decision has been made yet

[Altaress]

okey ^^ have you got a icarus database for parsing data ?

<SPAWN_DATA spawn_id="0" max="1" use="true">
<DESC>!-- SpawnEditID : 257 비하인드(엘그레인), Description : --</DESC>
<ACTOR_LIST min_time_hour="0" min_time_min="0" max_time_hour="24" max_time_min="0">
<ACTOR actor_id="n_c01_0_0001_0029" faction="neutral" spawn_rate="100" spawm_limit="false" specialmotionstate="false" normalgrade="true" elitegrade="true" herograde="true" legendgrade="true"/>
</ACTOR_LIST>
<INTERACTION>
<INITIAL_STATE>in</INITIAL_STATE>
<INTERACTION_WAIT active="0" deactive="0"/>
<REQUIRED_ITEM />
</INTERACTION>
<PLACE_LIST>
<SPOT spawn_delay="0" patrol="false" avoid="false" x="2622.9644" y="2774.1587" z="78.363129" angle="220" scenario_id="" link_id="-1" patrol_range="0" space_type="ground"/>
</PLACE_LIST>
</SPAWN_DATA>

Where is a npc_id ?? 0 or 257 ?

[exe19890522]

thank you for your reply,i set login and pwd are all with "81dc9bdb52d04dc20036dbd8313ed055"
this is the sql script:
('1', '81dc9bdb52d04dc20036dbd8313ed055', '81dc9bdb52d04dc20036dbd8313ed05581dc9bdb52d04dc20036dbd8313ed055', '1234@qq.com', '1', '1', '20141225195447suKGIogguKMQEoGKEI');
--------i save it from mysql.
but the problem is still,and i find when i use the launcher.exe to login with 1234,it will give tip "account not found" ,and the loginserver.exe will show me this "mysql server has gone away".




please give me a solution，thanks very much.

[Altaress]

check files loginserver.cfg and use a reg.php for create a account in folder www.

[exe19890522]

loginserver.cfg is this: i did not set wrong,i use root-123456 in mysql.
ip = "127.0.0.1";
port = "5694";

db_host = "127.0.0.1";
db_user = "root";
db_pass = "123456";
db_name = "ica_ls";
--------------------------------
the reg.php file may usefull,but i can not use it.

i enter lilei and 1234 in reg.php like pic down:


but it did nothing,there is no new account in mysql,look down pic:


if anyone reg account success ,can you export the .sql file?
or if you are free and enthusiastic，can you share me the well done server and give the good client's down link?
i use this client http://update.multiservers.org/icarusonline.torrent
about {
ICARUS.ini 1kb
ICARUS_000.Gz 1.72gb
ICARUS_001.Gz 1.78gb
ICARUS_002.Gz 1.78gb
ICARUS_003.Gz 1.70gb
ICARUS_004.Gz 983mb
ICARUS_Setup.exe 3.91mb
total 7.96gb }

[Altaress]

Edit with navicat in ica_ls/accounts

login => lilei
password => 3752a328cf125dc589f01a1c1ff9e32281dc9bdb52d04dc20036dbd8313ed055

and test please

[exe19890522]

sorry also is account not found

============
i think the error tip is not find the account ,not pwd error.
does the login name need md5?

[Tahoma2]

reg.php:

<?php$dbhost    = "127.0.0.1";
$dbuser = "root";    
$dbpassword = "152958";
$dbname = "iemu_ls";


if (isset($_POST['login']) && isset($_POST['password']))
{
    $login = $_POST['login'];
    $password = md5($_POST['password']);
    if (strlen($login) <= 32)
        if ($msconn = @Mysql_connect($dbhost, $dbuser, $dbpassword))
            if( @Mysql_SELECT_DB($dbname))
            {
                echo 'Работа сайта временно приостановлена (Error: 101).';
                exit();
            }
    
    $mdpass = md5($login).$password;
    $query = "REPLACE INTO `accounts` SET `login`='".$login."', `password`='".$mdpass."', email= 'mail@mail.ru';";
 @Mysql_query( $query );


//    $query = "REPLACE INTO `pin_codes` SET `account_id`='".$login."', `password`='".$mdpass."', email= 'mail@mail.ru';";
// @Mysql_query( $query );
    echo 'ok';


}


?>

<form action="reg.php" method="POST">
<b>Login:</b><input type="text" name="login"><br/>
<b>Password:</b>&nbsp;<input type="password" name="password" /><br/>
<input type="submit" value="Зарегистрировать">
</form>

In accounts table:
login: lilei
password: 3752a328cf125dc589f01a1c1ff9e32281dc9bdb52d04dc20036dbd8313ed055 (1234)

[exe19890522]

sorry ,there is no new account had been reg into mysql.
the reg.php also can not usefull .
if you can login into game,youcan share me the .sql file.
=============
i need to sleep,tomorrow,i will on line.
thank you all the same.good night.

[Altaress]

for exe19890522
INSERT INTO `accounts` (`id`, `login`, `password`, `email`, `email_status`, `access`, `hash`) VALUES
(44, 'lilei', '3752a328cf125dc589f01a1c1ff9e32281dc9bdb52d04dc20036dbd8313ed055', 'mail@mail.ru', 0, 0, NULL);

I can not find the spawn_id into the client ...
actor_id="n_c01_0_0001_0029" relation ?
Can you help me please ?

[exe19890522]

sorry，i can't, i did not login into game .

- - - Updated - - -

can you share me your .sql file?

[msgdim]

Can anyone get into the game?

I have a old client (the previous one posted here) with SVN-lastest server files but no luck -- just create character screen.
If the new client can manage to get into game, please tell me, I will download it. ('cause its size is very big)

[exe19890522]

i use this client http://update.multiservers.org/icarusonline.torrent
but i can not login into game,the client give tip "account not found".
can you share me your sql?can you export your sql to .sql file?
and i use the 0.00 version server ,which you are using?
can you tell me where the SVN-lastest server files?
thank you.

[Tahoma2]

http://icarus-emu.googlecode.com/svn/trunk/

[msgdim]

After downloading the 11GB client, I can get in-game with current progress of emulator now.
I want to help with development but I don't understand packet... :(