[Guide] Little Guide

[Gothic]

-Download of VM Ware 9.0

Download of openSUSE 12.2

Fit new VM with OpenSuse (Easy Install of VM Ware)

Started by yast2 command sshd, mysql, apache and openssl and installed

tManually the 3 old libs: libmysqlclient.so.12, libssl.so.6, libcrypto.so.6 insert in to the / usr / lib / folder (as root)

Server files copied via WinSCP in the vm

All adapted newStobm.bin

In su mode, the server files given admin rights (chmod 777)

By Navicat (Windows) the sqls batched

Adjuset the db some global vwariable, t_iplist

Account created ingame

Then the server files ran without problems and i was sin me in.

yet a few notes:

(Purblic)game server reguires a client-old EP2 othherwise send error

Wiza's pw hash generator is wrong

PW:

hash("sha256", username.salt.passwort)

libmysqlclient.so.12: 2

libssl.so.6: 2

libcrypto.so.6: 2

yum: 2

Navicat Lite for Linux: 2

 

 

 

Rates Eding:

 

#Rates V1.0 (On the NPC)
UPDATE t_npc SET a_exp = a_exp * 1;
UPDATE t_npc SET a_skill_point = a_skill_point * 1;
UPDATE t_npc SET a_prize = a_prize * 1;

#Rates V1.2 (On The t_exp Tabele) with command or writhe your own
UPDATE t_exp SET a_exp = a_exp / 1;
UPDATE t_npc SET a_skill_point = a_skill_point * 1;
UPDATE t_npc SET a_prize = a_prize * 1;

# Droptable
UPDATE t_npc SET a_item_percent_0 = a_item_percent_0 * 1;
UPDATE t_npc SET a_item_percent_1 = a_item_percent_1 * 1;
UPDATE t_npc SET a_item_percent_2 = a_item_percent_2 * 1;
UPDATE t_npc SET a_item_percent_3 = a_item_percent_3 * 1;
UPDATE t_npc SET a_item_percent_4 = a_item_percent_4 * 1;
UPDATE t_npc SET a_item_percent_5 = a_item_percent_5 * 1;
UPDATE t_npc SET a_item_percent_6 = a_item_percent_6 * 1;
UPDATE t_npc SET a_item_percent_7 = a_item_percent_7 * 1;
UPDATE t_npc SET a_item_percent_8 = a_item_percent_8 * 1;
UPDATE t_npc SET a_item_percent_9 = a_item_percent_9 * 1;
UPDATE t_npc SET a_item_percent_10 = a_item_percent_10 * 1;
UPDATE t_npc SET a_item_percent_11 = a_item_percent_11 * 1;
UPDATE t_npc SET a_item_percent_12 = a_item_percent_12 * 1;
UPDATE t_npc SET a_item_percent_13 = a_item_percent_13 * 1;
UPDATE t_npc SET a_item_percent_14 = a_item_percent_14 * 1;
UPDATE t_npc SET a_item_percent_15 = a_item_percent_15 * 1
UPDATE t_npc SET a_item_percent_16 = a_item_percent_16 * 1;
UPDATE t_npc SET a_item_percent_17 = a_item_percent_17 * 1;
UPDATE t_npc SET a_item_percent_18 = a_item_percent_18 * 1;
UPDATE t_npc SET a_item_percent_19 = a_item_percent_19 * 1;

# droptable for Items with +
UPDATE t_npc SET a_minplus = a_minplus +1;
UPDATE t_npc SET a_maxplus = a_maxplus +1;
UPDATE t_npc SET a_probplus = 5000;

#HS for drop on all Mobs
UPDATE t_npc SET a_item_19 = 85;

 

PW Gennerator Beta:

 

if (isset( $_GET['username']))
{
$user = $_GET['username'];
$pass = $_GET['password'];
$salt = $_GET['salt'];
echo hash("sha256",$user.$salt.$pass);
}
echo '<form method="get" action="calc.php">
Username:<br>
<input type="text" size="24" maxlength="30" name="username"><br>

Password:<br>
<input type="text" size="24" maxlength="30"
name="password"><br>

Salt:<br>
<input type="text" size="24" maxlength="30"
name="salt"><br>

<input type="submit" value="Generate">';

 

 

 

 

And your friend is googel

 

thx to Falo and Samker and me