[Help Thread] Please post your questions here.

[Sherock]

Originally Posted by TheOnlyOneRaskim

The Character wich want to learn this skill by command, have to got the amount of needed JP aswell.

no the skill it self can't be learned ( 10010 )
but when i duplicate it whit other id i can learn it

( this skill should be only for using items )

[CHlNAMAN]

There are skills that you can learn by that method, and there are skills that you can't learn by that method. As simple as that.

[Sherock]

Originally Posted by Leqendary

There are skills that you can learn by that method, and there are skills that you can't learn by that method. As simple as that.

yes and how to make any skill can't leaned by that code ?

[CHlNAMAN]

I do not understand your question.

[Sherock]

Originally Posted by Leqendary

I do not understand your question.

what i mean is
there are an items that has a skill to use it and throw the effect on the enemy ( like chips in 7.3 - 7.2 - 7.3 - ... )
those skills you can't learn it ,
how to make some other skills like those skill ?


-----

edited :

in other way ...

how to make the skill used by item but no need to learn that skill ?

[ThunderNikk]

Try looking at the old chips or the snowballs.

[Sherock]

NULL

[lrd12345]

First i want to say big thx to all of whom are helping for the great guide and reply's. I hope this topic is still active. Spend the entire night last night reading trough all the reply's and they have helped alot. Sadly to say as of now i still can not with serveral 9.1 clients(meaning I've tryed multiply clients to connect) to my server. The server itself has no apperent issues. I do not wish to go public, i only want it to be on my lan. Both client and server are running from disk0partition0 (c:\).

Here is my info, and the way iv'e set it up.

pc info : win10 x64, mysql 2014 evaluation 180 days (full)[meaning I've selected all boxes at install]

Hardware: 3.4ghz i3, 8gb ram.

Setup info:

Ports:
Auth port same as mysql port (in my case 1433)
Auth client port : 58422

Passwords:
I left all pws blank (both in mysql and in opt. sa is blank too)
I have commented out auth.db.salt (in common.opt)

Accounts:
I made all the accounts on mysql as instructed in the guide.

Network:
i have disabled my firewall, i have configurated mysql to have port 1433.

Opt files:

Auth:

 Spoiler

#Database configuration
auth.db.server:127.0.0.1
auth.db.port:1433
auth.db.name:Auth
auth.db.account:sa
auth.clients.maxpublicserveridx:10

#Server Index Offset Column Name
sql.db_account.column.serveridxoffset:server_list_mask

#include config in common.opt
%include:common.opt

Common:

 Spoiler

#Write trace log messages to file and show only info log messages on console
core.log.level:trace
core.log.consolelevel:info

#Enable traffic dump, will be in traffic_log folder (default off)
#trafficdump.enable:true

#The password is in plain text if you have one
auth.db.password:
#auth.db.salt:5dd23
#You can make auth.dbo.Accounts.[password] by visiting: 
# http://www.miraclesalad.com/webtools/md5.php (KEY+PASSWORD = hashed password)[No spaces between KEY and PASSWORD]
# Copy the resulting md5 into the password field of your account entry


#Where clients will connect (this is default values)
auth.clients.ip:127.0.0.1
auth.clients.port:58422
auth.clients.des_key:MERONG

#Where the gameserver will connect (this is default values)
auth.gameserver.ip:127.0.0.1
auth.gameserver.port:4502

#Upload configuration, use "upload" directory for guild icons
upload.dir=upload
upload.clients.ip=127.0.0.1
upload.clients.port=32214
#Use port 5000 for the guild icon mini webserver (the listen ip is also upload.clients.ip)
upload.clients.webport:5000

#Where the gameserver will connect (this is default values)
upload.gameserver.ip:127.0.0.1
upload.gameserver.port:4616

#Only for SQL Server: speed up selects with NOLOCK
sql.db_account.query:SELECT * FROM Accounts WITH(NOLOCK) WHERE login_name = ? AND password = ?;

GameServer:

 Spoiler

S:app.name:GameServer
T:auth.server_idx:1
S:auth.server_name:MyVeryOwn91Server
S:db.c.server:127.0.0.1
S:db.c.name:arcadia
S:db.c.account:sa
S:db.c._password:
S:db.user.server:127.0.0.1
S:db.user.name:telecaster
S:db.user.account:sa
S:db.user._password:
N:io.port:15574
S:io.auth.ip:127.0.0.1
S:io.ip_address:127.0.0.1
S:log.chat.ip:127.0.0.1
S:log.ip:127.0.0.1
T:log.chat.working:0
T:log.working:0
T:log.disable:1
S:game.mem_usage_info_save_interval:9999999
F:game.base_ethereal_durability_consumption_on_damage:.30
F:game.base_ethereal_durability_consumption_on_skill_attack:.40
F:game.base_ethereal_durability_consumption_on_normal_attack:.10
F:game.pvp_damage_rate_for_summon:.12
F:game.pvp_damage_rate_for_player:.08
S game.exp_rate:5
S game.item_drop_rate:1000000
S game.gold_drop_rate:2000000
S game.chaos_drop_rate:2000000
T game.apply_stamina_bonus_in_premium_pcb:0
F game.premium_pcbang_bonus_rate:.30
F game.premium_pcbang_chaos_bonus_rate:.30
F game.premium_pcbang_gold_bonus_drop_rate:.30
F game.premium_pcbang_item_bonus_drop_rate:.30
F game.premium_pcbang_chaos_bonus_drop_rate:.30
F game.ally_pcbang_bonus_rate:.30
S game.ally_pcbang_chaos_bonus_rate:.30
T:game.update.version:24
T:game.max_level:999
T:game.PKServer:0
T:game.AdultServer:0
T:game.cash_usable_server:1
S:game.local_flag:4
T:game.min_global_chat_usable_level:10
T:game.use_auto_trap:0
T:game.use_auto_jail:0
T:game.ServiceServer:0
N:console.port:44554
S:console.allow_ip:127.0.0.1
S:console._password:
S:io.upload.ip:127.0.0.1
S:io.upload.port:4616
S:game.guild_icon_base_url:http://127.0.0.1/guild/
S:game.url_list:guild.url|http://127.0.0.1/login.aspx|guild_test_download.url|guild/|web_download|5.196.124.242|web_download_port|0|shop.url|http://shop.rappelz.co|ghelp_url|http://help.gamepower7.com/help/help-page/help-page.html|guild_icon_upload.ip|5.196.124.242|guild_icon_upload.port|4617

S:game.server_screenshot_url:http://rappelz.co/launcher/server.html
S:game.helpdesk_url:http://help.gamepower7.com/help/help-page/help-page.html
S:game.newbiehelp_asura_url:http://help.gamepower7.com/help/info_asura.html
S:game.newbiehelp_deva_url:http://help.gamepower7.com/help/info_deva.html
S:game.newbiehelp_gaia_url:http://help.gamepower7.com/help/info_gaia.html
S:game.local_setting_list:log.ip|log.chat.ip|io.auth.ip|io.ip_address|db.c.server|db.user.server|N game.periodical_npc_adjustment
T:game.disable_trade:0
T:game.disable_booth:0
S:game.enhance_fail_type:2
T:game.monster_pathfinding:1
T:game.monster_wandering:1
T:game.no_collision_check:0
T:game.no_skill_cooltime:0
N:game.item_hold_time:2500
T:db.user.thread:4

RapprelzAuthServer.exe log:

 Spoiler

2016-01-09 16:24:42 Info  ConfigInfo0: N stats.connections:0
2016-01-09 16:24:42 Info  ConfigInfo0: N stats.disconnections:0
2016-01-09 16:24:42 Info  ConfigInfo0: S*trafficdump.consolelevel:fatal
2016-01-09 16:24:42 Info  ConfigInfo0: S*trafficdump.dir:E:\server_bin\Auth_bin/traffic_log
2016-01-09 16:24:42 Info  ConfigInfo0: B*trafficdump.enable:false
2016-01-09 16:24:42 Info  ConfigInfo0: S*trafficdump.file:auth.log
2016-01-09 16:24:42 Info  ConfigInfo0: S*trafficdump.level:debug
2016-01-09 16:24:42 Info  ConfigInfo0: B*upload.clients.autostart:true
2016-01-09 16:24:42 Info  ConfigInfo0: N*upload.clients.idletimeout:61
2016-01-09 16:24:42 Info  ConfigInfo0: S upload.clients.ip:127.0.0.1
2016-01-09 16:24:42 Info  ConfigInfo0: N upload.clients.port:32214
2016-01-09 16:24:42 Info  ConfigInfo0: S upload.dir:E:\server_bin\Auth_bin/upload
2016-01-09 16:24:42 Info  ConfigInfo0: B*upload.gameserver.autostart:true
2016-01-09 16:24:42 Info  ConfigInfo0: N*upload.gameserver.idletimeout:0
2016-01-09 16:24:42 Info  ConfigInfo0: S upload.gameserver.ip:127.0.0.1
2016-01-09 16:24:42 Info  ConfigInfo0: N upload.gameserver.port:4616
2016-01-09 16:24:42 Info  ConfigInfo0: B*upload.iconserver.autostart:true
2016-01-09 16:24:42 Info  ConfigInfo0: N*upload.iconserver.idletimeout:31
2016-01-09 16:24:42 Info  ConfigInfo0: S*upload.iconserver.ip:0.0.0.0
2016-01-09 16:24:42 Info  ConfigInfo0: N*upload.iconserver.port:80
2016-01-09 16:24:42 Info  DbConnectionPool0: Checking connection to "driver=SQL Server;Server=127.0.0.1,1433;Database=Auth;UID=sa;PWD=;"
2016-01-09 16:24:42 Info  ODBC: SQLDriverConnect: additional info:
2016-01-09 16:24:42 Info  ODBC: 01000:1:5701:[Microsoft][ODBC SQL Server Driver][SQL Server]Changed database context to 'Auth'.
2016-01-09 16:24:42 Info  ODBC: 01000:2:5703:[Microsoft][ODBC SQL Server Driver][SQL Server]Changed language setting to us_english.
2016-01-09 16:24:42 Info  DbConnectionPool0: Connection ok
2016-01-09 16:24:42 Info  ServersManager0: Starting server auth.clients on 127.0.0.1:58422
2016-01-09 16:24:42 Info  ServersManager0: Starting server auth.billing on 127.0.0.1:4503
2016-01-09 16:24:42 Info  ServersManager0: Starting server auth.gameserver on 127.0.0.1:4502
2016-01-09 16:24:42 Info  ServersManager0: Starting server upload.gameserver on 127.0.0.1:4616
2016-01-09 16:24:42 Info  ServersManager0: Starting server upload.clients on 127.0.0.1:32214
2016-01-09 16:24:42 Info  ServersManager0: Starting server upload.iconserver on 0.0.0.0:80
2016-01-09 16:24:42 Info  ServersManager0: Starting server admin.telnet on 127.0.0.1:4501
2016-01-09 16:28:49 Info  ServerInfo[]: Server Login: MyVeryOwn91Server[1] at 127.0.0.1:15574
2016-01-09 16:28:51 Info  GameServerSession[]: Server Login: GameServer from 127.0.0.1:53015

CaptainHerlockServer.exe log:

 Spoiler

Summary:
The client works, the launcher works, but when I try to log in with my auth.db.account, there is no error and I can not log in. Regardless of what password type I use (e.g. md5 hash, plain text, blank)

[Edit]if this post is not active, please remove[/Edit]
[Edit]FIXED THX TO SAPPHIRE TEAM[/EDIT]

[ThunderNikk]

What is your bat file you are using to launch the game.

It is probably the port you put in the bat for auth.

[lrd12345]

its been fixed but thx for the reply , it was indeed the launcher (start.bat) port who was wrong. Fixed with help form sapphire team, check their awsome server out.

[ThunderNikk]

Originally Posted by lrd12345

its been fixed but thx for the reply , it was indeed the launcher (start.bat) port who was wrong. Fixed with help form sapphire team, check their awsome server out.

No thanks I am just a lurker here. Not interested in actually playing Rappelz anymore except on my own server.

[g_d_dragon]

Hey all,

Does anyone maybe have an good guide how i can add into c# in windowsform, an insert for sql with an md5 hash and the salt pwd?

And how i can check if an account exist if i click on register_button on the windowsform in c#.

The connection work fine, the only thing is to check if the account exist and to add a new account with md5 + salt.

Thanks

[TheOnlyOneRaskim]

Originally Posted by g_d_dragon

Hey all,

Does anyone maybe have an good guide how i can add into c# in windowsform, an insert for sql with an md5 hash and the salt pwd?

And how i can check if an account exist if i click on register_button on the windowsform in c#.

The connection work fine, the only thing is to check if the account exist and to add a new account with md5 + salt.

Thanks

From my First Interface.

A better solution would be to work with Parameter instead, but you should be able to figure that out


NOTE: This code Block is NOT safe against SQL Injections

public SqlConnection CONN()
        {
            string[] values = Properties.Settings.Default.SQL_CONN_INFO.Split('|');
            return new SqlConnection(string.Format("Data Source={0},{1};Initial Catalog={4};User Id={2};Password={3};", values[0], values[1], values[2], values[3], DB("Auth")));
        }

        public string DB(string input)
        {
            string[] values = Properties.Settings.Default.SQL_DATABASE_NAMES.Split('|');
            if (input == "Arcadia") { return values[0]; }
            else if (input == "Telecaster") { return values[1]; }
            else { return values[2]; }
        }

public string login_to_launcher(string user, string password, string mac)
        {
            string answer = ""; 
            try
            {
                int account_count = 0; SqlDataReader rdr;
                SqlConnection sqlConnection = CONN();
                String sHashedPW = CreateMD5Hash(string.Format("{0}{1}", "2011", password));
                SqlCommand sqlCommand = new SqlCommand();
                sqlCommand.Connection = sqlConnection;
                sqlCommand.CommandText = "Select * from " + DB("Auth") + ".dbo.Accounts where login_name = '" + user + "'";
                sqlConnection.Open();
                rdr = sqlCommand.ExecuteReader();
                while (rdr.Read())
                {
                    account_count++;
                }
                rdr.Close();
                if (account_count == 1)
                {
                    account_count = 0;
                    sqlCommand.CommandText = "Select * from " + DB("Auth") + ".dbo.Accounts where login_name = '" + user + "' and password = '" + sHashedPW + "'";
                    rdr = sqlCommand.ExecuteReader();
                    while (rdr.Read())
                    {
                        account_count++;
                    }
                    rdr.Close();
                    if (account_count == 1)
                    {
                        bool allowed = true;
                        sqlCommand.CommandText = "Select * from " + DB("Auth") + ".dbo.banned_mac where mac_adress = '" + mac + "'";
                        rdr = sqlCommand.ExecuteReader(); while (rdr.Read()) { allowed = false; } rdr.Close();
                        if (allowed) 
                        { 
                            answer = "ENABLE_LAUNCHER";
                        }
                        else { answer = "MAC_BANNED"; }
                    }
                    else 
                    {
                        answer = "LOGIN_WRONG";  
                    }
                }
                else
                { answer = "LOGIN_NOEXIST"; }
                sqlConnection.Close();
            }
            catch { answer = "There was an internal Server Error. Please Try again later."; }
            return answer;
        }

public string CreateMD5Hash(string input)
        {
            System.Security.Cryptography.MD5 md5 = System.Security.Cryptography.MD5.Create();
            byte[] inputBytes = System.Text.Encoding.ASCII.GetBytes(input);
            byte[] hashBytes = md5.ComputeHash(inputBytes);
            StringBuilder sb = new StringBuilder();
            for (int i = 0; i < hashBytes.Length; i++)
            {
                sb.Append(hashBytes[i].ToString("X2"));
            }
            return sb.ToString().ToLower();
        }

[Game_0verrr]

I have a question about the usage of the database. I see that there are several tables including items, pets and other stuff. I try to figure out what exactly is connected to what table etc. Is there a datamodel on this database? And could someone point out where items and pets are stored? Is there an overview of commands for the TEAM-REVOLUTION 9.1 Rappelz server (the ones for CaptainHerlockServer.exe). I already tried some commands starting of with an # but they where not really succesfull in terms of actually giving me the item. (#insert_item command).

Thanks for reading and answering in advance.

[.BlackCat.]

Originally Posted by Game_0verrr

I have a question about the usage of the database. I see that there are several tables including items, pets and other stuff. I try to figure out what exactly is connected to what table etc. Is there a datamodel on this database? And could someone point out where items and pets are stored? Is there an overview of commands for the TEAM-REVOLUTION 9.1 Rappelz server (the ones for CaptainHerlockServer.exe). I already tried some commands starting of with an # but they where not really succesfull in terms of actually giving me the item. (#insert_item command).

Thanks for reading and answering in advance.

Pets are stored in SummonResource (and linked to other databases for skills , stats , soultaming etc ... )
Items are stored in ItemRseource and linked (sometimes) to other databases such ItemEffectResource , StateResource etc ...

I honestly don't use commands using the gameserver but I don't think anything changed , maybe the syntax is wrong . See here for more info :