[Help Thread] Please post your questions here.

[kojima2501]

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

[Questiontest]

Originally Posted by thndr

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



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

thanks.

[ThunderNikk]

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"

[Modamer9]

Originally Posted by Questiontest

No, I use MENA epic 4 client and I didn't put a password for the sql but I got this error



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

thanks.

* first must be set on authentication mode



* set a password for "sa"

* hash your pass with app pyrok and put it in *.opt

[thund22222]

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

[ThunderNikk]

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?

[thund22222]

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

[ThunderNikk]

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.

[Questiontest]

Originally Posted by Modamer9

* first must be set on authentication mode



* 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

[ThunderNikk]

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.

[Questiontest]

Originally Posted by thndr

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

[ThunderNikk]

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.

[Questiontest]

Originally Posted by thndr

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

[ThunderNikk]

[sergeu1988]

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