Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Rappelz > Rappelz Private Server
You last visited: Today at 18:40

  • Please register to post and access all features, it's quick, easy and FREE!

 

[Help Thread] Please post your questions here.

Reply
 
Old   #5416
 
elite*gold: 0
Join Date: Nov 2011
Posts: 980
Received Thanks: 1,007
Quote:
Originally Posted by Sherock View Post
for the skill that have ( 10010 ) id
i can't use

/run learn_skill(10010 )

but when i duplicate it with another id ( ex. 10101 )

i can use this

/run learn_skill(10101 )

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



TheOnlyOneRaskim is offline  
Thanks
1 User
Old   #5417
 
elite*gold: 0
Join Date: Oct 2013
Posts: 404
Received Thanks: 31
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 )


Sherock is offline  
Old   #5418
 
elite*gold: 0
Join Date: Jun 2015
Posts: 100
Received Thanks: 45
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.
Leqendary is offline  
Thanks
1 User
Old   #5419
 
elite*gold: 0
Join Date: Oct 2013
Posts: 404
Received Thanks: 31
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 ?


Sherock is offline  
Old   #5420
 
elite*gold: 0
Join Date: Jun 2015
Posts: 100
Received Thanks: 45
I do not understand your question.
Leqendary is offline  
Thanks
1 User
Old   #5421
 
elite*gold: 0
Join Date: Oct 2013
Posts: 404
Received Thanks: 31
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 ?
Sherock is offline  
Old   #5422
Moderator
 
elite*gold: 1
Join Date: Dec 2012
Posts: 3,148
Received Thanks: 1,032
Try looking at the old chips or the snowballs.
ThunderNikk is offline  
Old   #5423
 
elite*gold: 0
Join Date: Oct 2013
Posts: 404
Received Thanks: 31
NULL
Sherock is offline  
Old   #5424
 
elite*gold: 0
Join Date: Nov 2009
Posts: 4
Received Thanks: 0
Red face Help needed!!! Much Thanks, Keep up the good work!!!

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]
lrd12345 is offline  
Old   #5425
Moderator
 
elite*gold: 1
Join Date: Dec 2012
Posts: 3,148
Received Thanks: 1,032
What is your bat file you are using to launch the game.

It is probably the port you put in the bat for auth.
ThunderNikk is offline  
Old   #5426
 
elite*gold: 0
Join Date: Nov 2009
Posts: 4
Received Thanks: 0
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.
lrd12345 is offline  
Old   #5427
Moderator
 
elite*gold: 1
Join Date: Dec 2012
Posts: 3,148
Received Thanks: 1,032
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.
ThunderNikk is offline  
Old   #5428
 
elite*gold: 0
Join Date: Jan 2014
Posts: 182
Received Thanks: 45
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
g_d_dragon is offline  
Old   #5429
 
elite*gold: 0
Join Date: Nov 2011
Posts: 980
Received Thanks: 1,007
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();
        }
TheOnlyOneRaskim is offline  
Thanks
1 User
Old   #5430
 
elite*gold: 0
Join Date: May 2014
Posts: 46
Received Thanks: 0
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.


Game_0verrr is offline  
Reply

Tags
7.4, client, rappelz



« Previous Thread | Next Thread »

Similar Threads
[Helping Topic] 24/7 Helping Services!
stucked on anything while setuping your server? post your problem here and you will get answer as fast as possible better than spamming with posts...
31 Replies - EO PServer Hosting



All times are GMT +1. The time now is 18:40.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Abuse
Copyright ©2017 elitepvpers All Rights Reserved.