[Tool Php] Real alchemy rate

Page 1 of 2

03/15/2013 18:15 gigola123#1

Hello all , this is me , Mixizi.

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

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

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 :

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

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

03/16/2013 16:09 PortalDark#2

#approved

03/16/2013 16:30 Kape7#3

Good job :)

03/16/2013 16:39 denise456#4

GOOD JOB

03/16/2013 17:44 Crue*#5

Nice

03/16/2013 17:57 martynas123boxter#6

Blow job!!
Oh sry Good Job :)

03/16/2013 19:43 IceAmStiel#7

Code:

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

Code:

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;

��

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

Code:

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

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

>.<

03/16/2013 20:12 gigola123#8

<.<

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 : [Only registered and activated users can see links. Click Here To Register...]

03/16/2013 20:34 IceAmStiel#9

Quote:

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 [Only registered and activated users can see links. Click Here To Register...]

03/16/2013 21:10 gigola123#10

Quote:

Originally Posted by IceAmStiel

Aw hun! Just wanted to post the sql version as it might be handier for some people [Only registered and activated users can see links. Click Here To Register...]

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.
[Only registered and activated users can see links. Click Here To Register...]

03/16/2013 21:49 Snow*#11

Awesome job.

03/16/2013 22:50 royalblade#12

Quote:

Originally Posted by gigola123

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

are u fucking 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!

03/16/2013 22:52 gigola123#13

Quote:

Originally Posted by royalblade

are u fucking 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 ^^'

03/16/2013 22:57 royalblade#14

Quote:

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 crap at ******** which includes the basic calculation method once u have the base parameter which i indeed showed and told how to get.

Code:

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?

03/16/2013 22:59 gigola123#15

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

Page 1 of 2