UnderWorld-Online :: Cap110 Database Hacked Saw1337

[kafemis]

Database

Full Clıent

Script

Start quest reward items:



We've edited all Baghdad and Jupiter mobs




New Areas
Survival area (Uniques)



Job war system





Champions system







Hacked By Saw1337

Read Me

Skype: hasan.aksoy42

Facebook: www.fb.com/OkumadaSokam

[MentaL]

[musty10]

sql 2012?

[denise456]

sql 2012?

Yeah bro SQL 2012

[cyucyu]

SMC：

connot connect to division manager (access denied)

[Coolza]

Change sec_primary, sec_content =231

[fuddreckers2]

well you released old backup of my database but there's some bugs on the old backup lemme see if you can fix it

[kafemis]

sql 2012?

Yes bro. Sql 2012

- - - Updated - - -

thank you!

np bro.

- - - Updated - - -

SMC：

connot connect to division manager (access denied)

Yes Change sec_primary, sec_content =231

- - - Updated - - -

bug o something?

No Bug

- - - Updated - - -

hasan for president !

..... :)

[radhanac]

you need make 321 in your GM account

[Wynh]

Job war system does not work
and SR_GameServer.exe does not run

[R Zone]

USE [SRO_VT_SHARD]GO
/****** Object: StoredProcedure [dbo].[_UPDATE_COST] Script Date: 26.02.2012 14:03:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO


--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
-- »???°³?? (??¼±E£)
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@


ALTER PROCEDURE [dbo].[_UPDATE_COST]
@Operation tinyint,
@CharID int,
@PaymentDevice int,
@PackageItemCodeName varchar(129),
@RemainGold bigint,
@OwnSilkToPay int,
@GiftSilkToPay int,
@OffsetOptionalPoint int,
@MileageToPay int
AS


SET NOCOUNT ON


declare @PaymentDeviceTemp int
declare @RemainOwnSilk int
declare @RemainGiftSilk int
declare @RemainMileage int
declare @Result int


set @RemainOwnSilk = 0
set @RemainGiftSilk = 0
set @RemainMileage = 0


IF (@RemainGold < 0 or @MileageToPay < 0 or @OwnSilkToPay < 0 or @GiftSilkToPay < 0 or @OffsetOptionalPoint < 0)
BEGIN
RETURN -2001
END


DECLARE @PC_ID INT
set @PC_ID = @CharID
----------------------------------------------------------
-- Operation?? µû¶?¼* A¯A? ?³¸¯?? ¾?A?µ?°? ³?¾î ??¼?µµ A?°?, cos ¾?A?µ?°? ³?¾î ?? ¼?µµ A?´U.
-- ?³¸¯?? ¾?A?µ?¸¦ ¾îA¶´? ¾E¾?³»¾? CI°?´U.
----------------------------------------------------------
if (@Operation = 19)
begin
-- COS ?ë ¹°C°A» ±¸AOC?°?´I±?... ?³¸¯ ?£¾?¼* µ· »©?à¾???...
SELECT @PC_ID = OwnerCharID FROM _CharCOS WHERE ID = @PC_ID
IF (@@ERROR <> 0 OR @@ROWCOUNT = 0)
BEGIN
RETURN -2002
END
end
/*
#define EXPAND_DEVICE_GOLDPRICE 1
#define EXPAND_DEVICE_SILKPRICE 2
#define EXPAND_DEVICE_GIFTSILKPRICE 4
#define EXPAND_DEVICE_GUILDPOINT 8
#define EXPAND_DEVICE_MILEAGE 16
*/


if ((@PaymentDevice & (2 | 4 | 16 )) > 0)
begin
-- ½C?©, ¼±¹°½C?©, ¸¶AI¸®??¸¦ ±î¾? CI´A±¸¸¸.
-- ´U, ¸¶AI¸®??´A ?E¼CA?´U.


-- ?³¸¯??AC JID¸¦ ¾?¾î?A³E¶?.
declare @JID int
select top 1 @JID = UserJID from _User
where CharID = @PC_ID
IF (@@ROWCOUNT = 0 OR @@ERROR <> 0)
BEGIN
RETURN -2006
END


DECLARE @PackageItemID int
select @PackageItemID = ID from dbo._RefPackageItem where codename128 = @PackageItemCodeName


DECLARE @rvalue int
-- EXEC @rvalue = SRO_VT_ACCOUNT.DBO._ConsumeSilkByGameServer @JID, @OwnSilkToPay OUTPUT, @GiftSilkToPay OUTPUT, @MileageToPay output, 1, @CharID
EXEC @rvalue = SRO_VT_ACCOUNT.DBO._ConsumeSilkByGameServer @JID, @OwnSilkToPay OUTPUT, @GiftSilkToPay OUTPUT, @MileageToPay output, 0, @CharID, @PackageItemID , 0


IF (@rvalue < 0 OR @@ERROR <> 0)
BEGIN
RETURN -2012
END
--------------------------
--<< 1. ¼??¤ Aü ??µ? >> -- ??E*
--------------------------
-- -- °OA? ¼*¹?AE??¼* °»½? ¹?±â A§C? cost °?A» °?°? ?×A????? ³?¾îµ?´U.
-- insert into _ResultOfPackageItemToMappingWithServerSide
-- values (@Operation, @CharID, 255, @OwnSilkToPay, 2, 0, 1)
--
-- if (@@ERROR <> 0 or @@ROWCOUNT = 0)
-- begin
-- return -2007
-- end
--
-- insert into _ResultOfPackageItemToMappingWithServerSide
-- values (@Operation, @CharID, 254,@GiftSilkToPay, 4, 0, 1)
--
-- if (@@ERROR <> 0 or @@ROWCOUNT = 0)
-- begin
-- return -2007
-- end
--
-- insert into _ResultOfPackageItemToMappingWithServerSide
-- values (@Operation, @CharID, 253,@MileageToPay, 16, 0, 1)
--------------------------
--<< 1. ¼??¤ E? ??µ? >> --
--------------------------
-- °OA? ¼*¹?AE??¼* °»½? ¹?±â A§C? cost °?A» °?°? ?×A????? ³?¾îµ?´U.
insert into _ResultOfPackageItemToMappingWithServerSide
values (@Operation, @CharID, 255, @OwnSilkToPay, 2, 0, 1, 0)


if (@@ERROR <> 0 or @@ROWCOUNT = 0)
begin
return -2007
end


insert into _ResultOfPackageItemToMappingWithServerSide
values (@Operation, @CharID, 254,@GiftSilkToPay, 4, 0, 1, 0)


if (@@ERROR <> 0 or @@ROWCOUNT = 0)
begin
return -2007
end


insert into _ResultOfPackageItemToMappingWithServerSide
values (@Operation, @CharID, 253,@MileageToPay, 16, 0, 1, 0)




----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------


if (@@ERROR <> 0 or @@ROWCOUNT = 0)
begin
return -2007
end
end


-- gold
if ((@PaymentDevice & 1) > 0)
begin
UPDATE _Char SET RemainGold = @RemainGold WHERE CharID = @PC_ID
IF (@@ERROR <> 0 OR @@ROWCOUNT = 0)
BEGIN
RETURN -2003
END
end


-- guildpoint
if ((@PaymentDevice & 8) > 0)
BEGIN
-- ±?µ?¸¦ ¾E¾???¶?.
declare @GuildID int
select @GuildID = GuildID from _GuildMember
where CharID = @PC_ID


IF (@@ERROR <> 0 OR @@ROWCOUNT = 0)
BEGIN
RETURN -2004
END


-- ±?µ? ?÷AI?® ±î¶?.
update _Guild set GatheredSP = GatheredSP - @OffsetOptionalPoint
where GatheredSP >= @OffsetOptionalPoint and ID = @GuildID


IF (@@ERROR <> 0 OR @@ROWCOUNT = 0)
BEGIN
/*
-- ¾?A»¼?µµ A?´A°?´U.


-- by novice. 2010-01-15 ??·¯??µ? µ¥A???Cü E®A?
-- ??·? ??¼®µC¾î A?´? ??µ?A???¸¸, ??E? °³¹?CI´A »ç¶÷µéA?
-- ¼??¤µC?? ¾EA? ³»?ëA» ?¸°? E¥¶?½?·¯?? C? ¼? A?¾î¼*
-- A? ?I??±î?? ¼??¤C?¹?¸²!
-- declare @Slot tinyint
declare @Slot int
declare @RefItemSerial64 bigint
declare @RefItemDBID bigint
declare @RefItemID int
declare @Type tinyint


-- by novice. 2010-01-15 ??·¯??µ? µ¥A???Cü E®A?
-- set @Slot = 0xd0 -- error_num ¼*¹???¼* »ç?ëCI´A ??·¯


-- MAKE_SRO_SP_ERR_TYPE( _UPDATE_COST, 0x0004);
-- DEFINE_SRO_SP_ERR( SRO_SP_ERR_NOT_ENOUGH_GUILD_POINT, _UPDATE_COST, 0x8001 ); // ==> 0x80010004
-- BIND_SRO_SP_ERR_TO_SRO_ERR( SRO_SP_ERR_NOT_ENOUGH_GUILD_POINT, STRGERR_NOT_ENOUGH_GUILDPOINT );
set @Slot = 0x80010004 -- error_num ¼*¹???¼* »ç?ëCI´A ??·¯
set @RefItemSerial64 = 0
set @RefItemDBID = 0
set @RefItemID = 0
set @Type = 2
select @Operation, @Slot, @RefItemSerial64, @RefItemDBID, @RefItemID, @Type
*/
RETURN -2005
END
--------------------------
--<< 2. ¼??¤ Aü ??µ? >> --
--------------------------
-- °OA? ¼*¹?AE??¼* °»½? ¹?±â A§C? cost °?A» °?°? ?×A????? ³?¾îµ?´U.
-- insert into _ResultOfPackageItemToMappingWithServerSide
-- values (@Operation, @CharID, 252, @OffsetOptionalPoint, 8, 0, 1)
--------------------------
--<< 2. ¼??¤ E? ??µ? >> --
--------------------------
-- °OA? ¼*¹?AE??¼* °»½? ¹?±â A§C? cost °?A» °?°? ?×A????? ³?¾îµ?´U.
insert into _ResultOfPackageItemToMappingWithServerSide
values (@Operation, @CharID, 252, @OffsetOptionalPoint, 8, 0, 1, 0)




----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------


if (@@ERROR <> 0 or @@ROWCOUNT = 0)
begin
return -2007
end
end


-- honorpoint
else if ((@PaymentDevice & 32) > 0)
begin
-- honorpoint ±î¶?.
update _TrainingCampMember set HonorPoint = HonorPoint - @OffsetOptionalPoint
where HonorPoint >= @OffsetOptionalPoint and CharID = @PC_ID


if (@@ERROR <> 0 or @@ROWCOUNT = 0)
begin
return -2006
end
--------------------------
--<< 3. ¼??¤ Aü ??µ? >> --
--------------------------
-- °OA? ¼*¹?AE??¼* °»½? ¹?±â A§C? cost °?A» °?°? ?×A????? ³?¾îµ?´U.
-- insert into _ResultOfPackageItemToMappingWithServerSide
-- values (@Operation, @CharID, 252, @OffsetOptionalPoint, 32, 0, 1)


--------------------------
--<< 3. ¼??¤ E? ??µ? >> --
--------------------------
-- °OA? ¼*¹?AE??¼* °»½? ¹?±â A§C? cost °?A» °?°? ?×A????? ³?¾îµ?´U.
insert into _ResultOfPackageItemToMappingWithServerSide
values (@Operation, @CharID, 252, @OffsetOptionalPoint, 32, 0, 1, 0)




----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------


if (@@ERROR <> 0 or @@ROWCOUNT = 0)
begin
return -2007
end
end


SET NOCOUNT OFF




return 1


--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@

For Fix DC

[kafemis]

Downloand 2. Link

https://docs.google.com/file/d/0B01m...QUk/edit?pli=1

[msbmohamed]

perfect database , but everything like scrolls or even premium in item mall or in npc scrolls when i click to use the item i get dc , then after i relog i found the item opened , also some scrolls give

would be Thanks if some one could help me with solution

- - - Updated - - -



that's another problem in the skill for the new scrolls in game
any one could tell me how i can start to fix the red lines and the dc which occuer from this scrolls ?

[AZM0S]

perfect database , but everything like scrolls or even premium in item mall or in npc scrolls when i click to use the item i get dc , then after i relog i found the item opened , also some scrolls give

would be Thanks if some one could help me with solution

- - - Updated - - -



that's another problem in the skill for the new scrolls in game
any one could tell me how i can start to fix the red lines and the dc which occuer from this scrolls ?

About your first problem it happens only with lottery scrolls and i didn't find a solution yet..
You can fix the red lines problem by adding effects to the scroll's skills..

[msbmohamed]

About your first problem it happens only with lottery scrolls and i didn't find a solution yet..
You can fix the red lines problem by adding effects to the scroll's skills..

not lottery scrolls only , i take dc if i use any item in game like normal premium and devil also all the new scrolls
and for the red lines can u share the skilleffect lines and database lines Pl0x ?

ThQ in Advance

[mrchymto]

Script link dead, pls reupload