[Help Thread] Please post your questions here.

05/03/2015 15:22 kojima2501#4576
okay thndr =)
i go test ur solution =) thx for ur help
EDIT : Same with drop Cube Def R2 + Armor R2 // problem enchant
<3

Ps : i don't update arcadia with BDupdater in Revolution files
05/03/2015 15:47 Questiontest#4577
Quote:
Originally Posted by thndr View Post
That is horrible advice to give someone.

There is a 9.1 password hasher created by Pyrok there is no reason to leave your database unprotected under SAs log in.

Follow the advice in the guide and you will have a really strong server security.

Follow this advice here and you open your SQL instance to anyone who knows anything about SQL not just Rappelz Private Server browsers.

Sorry mohamad512 I don't mean any offense, I just think you should train right or don't train at all.
No, I use MENA epic 4 client and I didn't put a password for the sql but I got this error

[Only registered and activated users can see links. Click Here To Register...]

I need to clear solution or with pictures because my english is not good

thanks.
05/03/2015 15:56 ThunderNikk#4578
You need to follow the guide is what you need to do.

Log in failed for user "sa" means auth server tried to connect as user "sa" to your database but could not log in as "sa"

In SQL you need to set a password for "sa"

Then you need to hash that password with the old DES hasher, not the new one for 9.1 but the one used for the epic 5, 6, 7, and 8 server files.

This is different from the account log in and MD5 do not hash it with the MD5 key hash you password alone by itself in Pyroks old DES hasher.

Then that hashed password needs to go into the authserver.opt as the password for user "sa"
05/03/2015 16:08 Modamer9#4579
Quote:
Originally Posted by Questiontest View Post
No, I use MENA epic 4 client and I didn't put a password for the sql but I got this error

[Only registered and activated users can see links. Click Here To Register...]

I need to clear solution or with pictures because my english is not good

thanks.
* first must be set on authentication mode

[Only registered and activated users can see links. Click Here To Register...]

* set a password for "sa"

* hash your pass with app pyrok and put it in *.opt
05/03/2015 16:37 thund22222#4580
I need help creating a script so that each level has a certain exp
Tried this
local lv = get_value ("level")
if lv == 20 then
set_env("game.exp_rate",20)
end

But it failed
05/03/2015 16:42 ThunderNikk#4581
How come you don't just set the amount of experience needed to level to the next level appropriate to your changing the rate at that level?
05/03/2015 16:47 thund22222#4582
in the fact that you put just one example but this full text

local lv = get_value ("level")
if lv > 160 then
set_env("game.exp_rate",20)
else
set_env("game.exp_rate",30)
end

I put in on_player_level_up script
05/03/2015 17:40 ThunderNikk#4583
So for levels greater than 160 you could divide the experience needed per level by 20, and for levels lower than 160 you could divide the experience needed per level by 30.

Greater than 160 they level 20 times faster and lower than or = to 160 they level 30 times faster.

Much less complicated. You can write it in a nice SQL query so you can change it back whenever you want. Do the same for pet levels and it is exactly like you changed the games experience rate.
05/03/2015 19:00 Questiontest#4584
Quote:
Originally Posted by Modamer9 View Post
* first must be set on authentication mode

[Only registered and activated users can see links. Click Here To Register...]

* set a password for "sa"

* hash your pass with app pyrok and put it in *.opt
I set on the authenication mode and set a password for sa but How I can hash my pass sorry my english doesn't help I need to pictures to do that please how I can hash my pass with app pyrok and put it in opt and thanks
05/03/2015 19:27 ThunderNikk#4585
Double click on DES tool to open it.

Put un hashed password in first window.

Copy hashed password from second window.

Paste into authserver.opt and gameserver.opt files and re compress them both using the Rappelz compressor.

It really explains how to do all of this in the guides. You are using pre 9.1 files so make sure you use the guide for 8.1 or older.

If you need pictures, I apologize, but I am too lazy to post pictures showing people how to double click on an executable to open it.
05/03/2015 19:45 Questiontest#4586
Quote:
Originally Posted by thndr View Post
Double click on DES tool to open it.

Put un hashed password in first window.

Copy hashed password from second window.

Paste into authserver.opt and gameserver.opt files and re compress them both using the Rappelz compressor.

It really explains how to do all of this in the guides. You are using pre 9.1 files so make sure you use the guide for 8.1 or older.

If you need pictures, I apologize, but I am too lazy to post pictures showing people how to double click on an executable to open it.
I don't even know what is DES tool I think I don't have it so I need pictures
05/03/2015 20:29 ThunderNikk#4587
I really don't think Pyrok will mind me sharing his tool since most all of us have it already anyway and it is included with E7 repacks.

If you reply back asking for pictures on how to use it I am just going to let other people help you out from now on.
05/03/2015 22:12 Questiontest#4588
Quote:
Originally Posted by thndr View Post
I really don't think Pyrok will mind me sharing his tool since most all of us have it already anyway and it is included with E7 repacks.

If you reply back asking for pictures on how to use it I am just going to let other people help you out from now on.
I could paste it into authsever but I couldn't do that in gameserver because bloc-notes can't save that and I got this error

[Only registered and activated users can see links. Click Here To Register...]
05/03/2015 22:23 ThunderNikk#4589
[Only registered and activated users can see links. Click Here To Register...]
05/04/2015 01:26 sergeu1988#4590
where it fit to give the Hidden Village? prompt in the request. Rusty I have


USE [Auth]
GO

DECLARE @IN_ACCOUNT_ID INT
DECLARE @Counter int

SELECT @IN_ACCOUNT_ID = max([account_id]) FROM [dbo].[Accounts] where [block] = 0 --order by account_id

SET @Counter = 1
WHILE @Counter<=@IN_ACCOUNT_ID BEGIN
if (SELECT Count(account_id) FROM Auth.dbo.accounts where account_id = @Counter) = 1
begin
INSERT INTO [Auth].[dbo].[PaidItem] ([account_id] ,[item_code] ,[item_count] ,[rest_item_count] ,[taken_account_id] ,[confirmed] ,[isCancel])
VALUES (@Counter, ID ,ID , @Counter, 1, 0)
end
SET @Counter = @Counter + 1
END
GO

Epic 9.1

When adding a hidden village an error, tweak for 9.1 epic if you can. I did not know in what subject to write

I'm confused by topics