[Tool Php] Real alchemy rate

[gigola123]

Hello all , this is me , Mixizi.

I want to release a little tool which took me about 10 mins to do.



There you'll be able to make your alchemy rate ,(It's really easy) I want to say thx to synx , he discover how to use the alchemy rate.

This tool convert everything to hex and convert again to decimal , checking if there is 2 bytes per "+" , if not add a Bytes "0" for make the value understable for the gs.

I've also made a blue decrypt but if you are kind I'll release it .

If you want to decrypt your actual rate I've made a tool too :



I use it on my server actually and it's working well so enjoy it.

[PortalDark]

#approved

[Kape7]

Good job

[denise456]

GOOD JOB

[Crue*]

Nice

[martynas123boxter]

********!!
Oh sry Good Job

[IceAmStiel]

CREATE FUNCTION [dbo].[ALCHEMY_convPercentage](@P1 TINYINT, @P2 TINYINT, @P3 TINYINT, @P4 TINYINT) 
RETURNS INT

AS
BEGIN
	RETURN CONVERT(INT, CONVERT(varbinary(1), @P1) + CONVERT(varbinary(1), @P2) + CONVERT(varbinary(1), @P3) + CONVERT(varbinary(1), @P4));
END

CREATE PROCEDURE [dbo].[ALCHEMY_convParameter]

	@Param	INT,
	@P1		varchar(8) OUTPUT,
	@P2		varchar(8) OUTPUT,
	@P3		varchar(8) OUTPUT,
	@P4		varchar(8) OUTPUT

as

SELECT
	@P1 = CONVERT(varchar(3), CONVERT(INT, SUBSTRING(CONVERT(varbinary(4), @Param), 1, 1))) + '%',
	@P2 = CONVERT(varchar(3), CONVERT(INT, SUBSTRING(CONVERT(varbinary(4), @Param), 2, 1))) + '%',
	@P3 = CONVERT(varchar(3), CONVERT(INT, SUBSTRING(CONVERT(varbinary(4), @Param), 3, 1))) + '%',
	@P4 = CONVERT(varchar(3), CONVERT(INT, SUBSTRING(CONVERT(varbinary(4), @Param), 4, 1))) + '%';

RETURN;

»»

_

SELECT
	r.ID, 
	r.CodeName128, 
	CASE WHEN TypeID4 = 1 THEN 'Elixir' ELSE 'Powder' END as 'ItemType', 
	CASE WHEN TypeID4 = 1 THEN CASE WHEN i.ItemClass = 1 THEN 'A' ELSE 'B' END ELSE 'D' + CONVERT(varchar(25), i.ItemClass) END as 'Type',
	CONVERT(varchar(25), CONVERT(INT, SUBSTRING(CONVERT(varbinary(4), i.Param2), 1, 1))) + '%' as '+1',
	CONVERT(varchar(25), CONVERT(INT, SUBSTRING(CONVERT(varbinary(4), i.Param2), 2, 1))) + '%' as '+2',
	CONVERT(varchar(25), CONVERT(INT, SUBSTRING(CONVERT(varbinary(4), i.Param2), 3, 1))) + '%' as '+3',
	CONVERT(varchar(25), CONVERT(INT, SUBSTRING(CONVERT(varbinary(4), i.Param2), 4, 1))) + '%' as '+4',
	CONVERT(varchar(25), CONVERT(INT, SUBSTRING(CONVERT(varbinary(4), i.Param3), 1, 1))) + '%' as '+5',
	CONVERT(varchar(25), CONVERT(INT, SUBSTRING(CONVERT(varbinary(4), i.Param3), 2, 1))) + '%' as '+6',
	CONVERT(varchar(25), CONVERT(INT, SUBSTRING(CONVERT(varbinary(4), i.Param3), 3, 1))) + '%' as '+7',
	CONVERT(varchar(25), CONVERT(INT, SUBSTRING(CONVERT(varbinary(4), i.Param3), 4, 1))) + '%' as '+8',
	CONVERT(varchar(25), CONVERT(INT, SUBSTRING(CONVERT(varbinary(4), i.Param4), 1, 1))) + '%' as '+9',
	CONVERT(varchar(25), CONVERT(INT, SUBSTRING(CONVERT(varbinary(4), i.Param4), 2, 1))) + '%' as '+10',
	CONVERT(varchar(25), CONVERT(INT, SUBSTRING(CONVERT(varbinary(4), i.Param4), 3, 1))) + '%' as '+11',
	CONVERT(varchar(25), CONVERT(INT, SUBSTRING(CONVERT(varbinary(4), i.Param4), 4, 1))) + '%' as '+12'
FROM	dbo._RefObjCommon r with(NOLOCK)
JOIN	dbo._RefObjitem i with(NOLOCK) on r.Link = i.ID
WHERE	TypeID1 = 3 AND TypeID2 = 3 AND TypeID3 = 10 AND TypeID4 in (1,2)

ORDER BY ItemType asc, i.ItemClass asc

»»



>.<

[gigola123]

<.<

Hah really nice sql , really like that sure my "tool" , I don't know if I should say "tool" was really easy to do. I know is useless front of your sql thing but I'll make a decrypt one for you fun.

There is the decryptor :

[IceAmStiel]

Originally Posted by gigola123

<.<

Hah really nice sql , really like that sure my "tool" , I don't know if I should say "tool" was really easy to do. I know is useless front of your sql thing but I'll make a decrypt one for you fun.

Aw hun! Just wanted to post the sql version as it might be handier for some people

[gigola123]

Originally Posted by IceAmStiel

Aw hun! Just wanted to post the sql version as it might be handier for some people

Thanks for your share if some people prefere to use my web site , there is also a decryptor for decrypt your actual alchemy rate I just made it.

[Snow*]

Awesome job.

[royalblade]

Originally Posted by gigola123

I've also made a blue decrypt but if you are kind I'll release it .

are u ******* kidding me?

When i showed you how to decrypt the blues and make sense of the parameters i told you 2 things! Remember them again!

[gigola123]

Originally Posted by royalblade

are u ******* kidding me?

When i showed you how to decrypt the blues and make sense of the parameters i told you 2 things! Remember them again!

You never told me how to decrypt the blue.. You joke ? You just show me how to get the "base" which wasn't the good method , your calculate was wrong ^^'

[royalblade]

Originally Posted by gigola123

You never told me how to decrypt the blue.. You joke ? You just show me how to get the "base" which wasn't the good method , your calculate was wrong ^^'

True i never TOLD you.. i showed it to you on teamviewer.
But its nice to see how people turn their backs on someone so quickly...
I posted this **** at ******** which includes the basic calculation method once u have the base parameter which i indeed showed and told how to get.

use sro_vt_shard
Declare @magimmo bigint
Declare @baseimmo bigint
declare @basealgo bigint
declare @immonum int
declare @bluenumalgo int
declare @Slot int
declare @charname varchar (64)
set @charname = 'Razgriz'
set @Slot = 17
set @immonum = 568387 -- Immortal number
set @basealgo = 51 -- dont touch
set @baseimmo=4294967347 -- dont touch
set @bluenumalgo = (@basealgo*(@immonum-1)) -- dont touch
set @magimmo = ((@baseimmo*@immonum)-@bluenumalgo) -- dont touch
Update _Items set MagParam1 = @magimmo where ID64 = 
(select itemid from _Inventory where CharID = 
(select CharID from _Char where CharName16 = @charname) 
and Slot = @Slot)

Did i not?

set @bluenumalgo = (@basealgo*(@immonum-1)) -- dont touch
set @magimmo = ((@baseimmo*@immonum)-@bluenumalgo) -- dont touch

is this not some sorta calculation for you?

[gigola123]

Nop , I've made a different system , totaly different. If you want to see come at skype.