I will make a new shop with cash items.

and how can i change a shop (NPC SHOP) ?

 

Sry for Bad english

I come from germany.

 

i mean the npc(shop NPC) sell items heal pots but i will the Npc sells cash items.

 

omg i hate my english ._.

So ich hab ein Problem Ich habe ca. 200 Reged Accs auf meinen Server aber ich hab son Playerlimit.. Dann können nur 10 oder 11 Leute drauf.. Wie kann ich das Fixen? Wer Cool wenn mir wer Helfen kann.. Danke

Hi i make my first ep1 server with hamachi, it run perfect in my pc, but when i try to log in, in other pc, login is correct but when i click start appear gameserverconnection failed

 

Any idea of what i have to do?

Hey Guys i was create a Ranking Script !

 

User-Rank:

 

<?php

//currently an example, change to your desired infomation
$dbuser = "root";
$dbpass = "root";
$dbhost = "localhost";
$dbname = "newproject_db";

//connect to database
$msconn = mysql_connect($dbhost, $dbuser, $dbpass);
$db = mysql_select_db($dbname, $msconn);
mysql_query("set names UTF8");

$q = mysql_query("SELECT a_level, a_job, a_nick, a_job2 FROM t_characters WHERE a_job2>0 AND a_level>30 ORDER BY a_level DESC");
echo "</pre>
<table width="400" border="0" cellpadding="2" cellspacing="2">LevelNameClass</table>
<font color="#FF0000">Highlander</font>";} <br> elseif ($row["a_job"] == 0 && $row["a_job2"] == 2 ) {$class = "<font color="#FF0000">Warmaster</font>";} <br><br> //knight<br> elseif ($row["a_job"] == 1 && $row["a_job2"] == 1 ) {$class = "<font color="#0000FF">Royal Knight</font>";} <br> elseif ($row["a_job"] == 1 && $row["a_job2"] == 2 ) {$class = "<font color="#0000FF">Templar Knight</font>";} <br><br> //Healer<br> elseif ($row["a_job"] == 2 && $row["a_job2"] == 1 ) {$class = "<font color="#008000">Archer</font>";} <br> elseif ($row["a_job"] == 2 && $row["a_job2"] == 2 ) {$class = "<font color="#008000">Cleric</font>";} <br><br> //Mage<br> elseif ($row["a_job"] == 3 && $row["a_job2"] == 1 ) {$class = "<font color="#800080">Wizard</font>";} <br> elseif ($row["a_job"] == 3 && $row["a_job2"] == 2 ) {$class = "<font color="#800080">Witch</font>";} <br><br> //Rogue<br> elseif ($row["a_job"] == 4 && $row["a_job2"] == 1 ) {$class = "<font color="#FFA500">Assassin</font>";} <br> elseif ($row["a_job"] == 4 && $row["a_job2"] == 2 ) {$class = "<font color="#FFA500">Ranger</font>";}<br><br> //Sorcerer<br> elseif ($row["a_job"] == 5 && $row["a_job2"] == 1 ) {$class = "<font color="#9B30FF">Elementalist</font>";} <br> elseif ($row["a_job"] == 5 && $row["a_job2"] == 2 ) {$class = "<font color="#9B30FF">Specialist</font>";} <br><br> //Nightshadow<br> elseif ($row["a_job"] == 6 && $row["a_job2"] == 0 ) {$class = "NightShadow";}<br><br><br><br><br> echo "";<br> echo "<font size="3">".$row["a_level"]."</font>";<br> echo "<font size="3">".$row["a_nick"]."</font>";<br> echo "<font size="3">".$class."</font>";<br> }<br> echo "<br>";<br

 

Guild-Rank:

<?php

//currently an example, change to your desired infomation
$dbuser = "root";
$dbpass = "root";
$dbhost = "localhost";
$dbname = "newproject_db";

//connect to database
$msconn = mysql_connect($dbhost, $dbuser, $dbpass);
$db = mysql_select_db($dbname, $msconn);
mysql_query("set names UTF8");

$q = mysql_query("SELECT a_level, a_name FROM t_guild WHERE a_level>0 AND a_level>4 ORDER BY a_level DESC");
echo "</pre>
<table width="400" border="0" cellpadding="2" cellspacing="2">LevelName".$row["a_level"]."".$row["a_name"]."</table>
<br>";<br

 

Banlist:

<?php

//currently an example, change to your desired infomation
$dbuser = "root";
$dbpass = "root";
$dbhost = "localhost";
$dbname = "newproject_db";

//connect to database
$msconn = mysql_connect($dbhost, $dbuser, $dbpass);
$db = mysql_select_db($dbname, $msconn);
mysql_query("set names UTF8");

$q = mysql_query("SELECT a_idname, a_detail, a_modify_date FROM t_users_block");
echo "</pre>
<table width="450" border="0" cellpadding="2" cellspacing="2">AccountnameReasonBandate".$row["a_idname"]."".$row["a_detail"]."".$row["a_modify_date"]."</table>
<br>";<br

 

 

You only change the MySQL Connection Fields. Warning for Banlist: In your Database you must enter in "a_detail" your Reason and in "a_modify_date" the Bantime..

 

Only Works for EP1 Files !!

 

Howto:

 

You need a Webserver (eg. Xampp) on your PC, Root etc. Then you create a .php file (eg. ranking.php) . Open it and copy one of my Codes in it. Then edit the MySQL-Connection in the .php file. Then youre done!

 

(SORRY FOR BAD ENGLISH IM GERMAN)

Hey Guys this is a Simple PHP Script for your Homepage to see the Castle-Owners. It shows Zone-Name (Merak and Dratan) , Owner-Guildname and the Owner-Charname (Guildleader)

 

This is the Code:

 

<?php

//currently an example, change to your desired infomation
$dbuser = "root";
$dbpass = "root";
$dbhost = "localhost";
$dbname = "newproject_db";

//connect to database
$msconn = mysql_connect($dbhost, $dbuser, $dbpass);
$db = mysql_select_db($dbname, $msconn);
mysql_query("set names UTF8");

$q = mysql_query("SELECT a_owner_guild_name, a_owner_char_name, a_zone_index FROM t_castle");
echo "</pre>
<table width="250" border="0" cellpadding="2" cellspacing="2">Zone GuildnameOwner</table>
<font color="#FFFF00">Dratan</font>";} <br> elseif ($row["a_zone_index"] == 7 && $row["a_zone_index"] == 7 ) {$class = "<font color="#FF0000">Merak</font>";} <br><br><br><br> echo "";<br> echo "<font size="3">".$class."</font>";<br> echo "<font size="3">".$row["a_owner_guild_name"]."</font>";<br> echo "<font size="3">".$row["a_owner_char_name"]."</font>";<br><br> }<br> echo "<br>";<br

 

You only need to edit the MySQL Data. Standart is

User: root
Passwort: root
IP: localhost or 127.0.0.1

 

Warning: Only works for EP1 Files!

Hi

 

I had to make a bloodseal editor because i wanted to change some things in Option.lod.

I made it so simple that even my grandmother can use it!

 

Just click File -> Open and select the Option_xxx.lod file

Make the changes

Click File -> Save and u are done!

 

hi everyone i just want to know how to make my server online for people with my static ip? i try it but people cant log in?

how i can add new mobs lvl 165+ in my server?

 

=)

hello all , i try the program developer studio but does not work (the file skills_usa.bin yes read but not save)

 

I would like to know how to edit these 2 client files

 

skills_usa.bin and sskills_usa.lod

 

 

 

thank you very much to people who take the time to read my post

and thx wizatek for this forum

can someone tell me what is the pyra teleport scroll id?