[Help Thread] Please post your questions here.

Page 362 of 586 « First 262312352360361 362 363364372412462 Last »
01/08/2016 05:55 Sherock#5416
Quote:
Originally Posted by TheOnlyOneRaskim View Post
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 )
01/08/2016 06:47 CHlNAMAN#5417
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.
01/08/2016 08:21 Sherock#5418
Quote:
Originally Posted by Leqendary View Post
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 ?
01/08/2016 08:24 CHlNAMAN#5419
I do not understand your question.
01/08/2016 08:49 Sherock#5420
Quote:
Originally Posted by Leqendary View Post
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 ?
01/08/2016 12:48 ThunderNikk#5421
Try looking at the old chips or the snowballs.
01/08/2016 13:14 Sherock#5422
NULL
01/09/2016 18:11 lrd12345#5423
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:

Common:

GameServer:

RapprelzAuthServer.exe log:

CaptainHerlockServer.exe log:

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]
01/09/2016 19:54 ThunderNikk#5424
What is your bat file you are using to launch the game.

It is probably the port you put in the bat for auth.
01/09/2016 21:05 lrd12345#5425
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.
01/09/2016 21:27 ThunderNikk#5426
Quote:
Originally Posted by lrd12345 View Post
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.
01/11/2016 09:35 g_d_dragon#5427
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
01/11/2016 09:45 TheOnlyOneRaskim#5428
Quote:
Originally Posted by g_d_dragon View Post
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
Code:
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();
        }
01/11/2016 13:07 Game_0verrr#5429
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.
01/11/2016 13:14 .BlackCat.#5430
Quote:
Originally Posted by Game_0verrr View Post
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 : [Only registered and activated users can see links. Click Here To Register...]
Page 362 of 586 « First 262312352360361 362 363364372412462 Last »