Re: [Release] Complete 120 Cap + 13D Database Running in Mssql 2005
@skerdikas i already go there, then put to download, like a p2p of iSRO, but nothing happens...
Re: [Release] Complete 120 Cap + 13D Database Running in Mssql 2005
where is Lv120 Skills :(
http://img803.imageshack.us/img803/2...0113310722.jpg
Uploaded with ImageShack.us
and all mastery like this :
Re: [Release] Complete 120 Cap + 13D Database Running in Mssql 2005
Quote:
Originally Posted by
I_Satelite_I
@skerdikas i already go there, then put to download, like a p2p of iSRO, but nothing happens...
JOYMAX.COM - Global Hub of Fun :: Silkroad Online this link is ksro p2p is rly fast rofl like 3-5mb/sec for me
Quote:
Originally Posted by
epvp2
use fenix sro client and ksro pk files and u will be fine
Re: [Release] Complete 120 Cap + 13D Database Running in Mssql 2005
grab pet can not be seen. what's wrong NPC hp mp pots received. pk2 wingsro my lvl 13 dg 101
Re: [Release] Complete 120 Cap + 13D Database Running in Mssql 2005
Full client .. It is perfect? with FenixSRO
Re: [Release] Complete 120 Cap + 13D Database Running in Mssql 2005
Quote:
Originally Posted by
PlayCreeDSRO
Full client .. It is perfect? with FenixSRO
Yep, Its Perfect... But i dont know maybe is a problem with client but, geting dc when buy things on item mall.
Re: [Release] Complete 120 Cap + 13D Database Running in Mssql 2005
yea my pk is bugged too cant find a problem so looking for expierenced pk editor who would know whats wrong with pk why items mall dc's
well kinda fixed media.pk not dcing anymore and i hope it wont dc again
Re: [Release] Complete 120 Cap + 13D Database Running in Mssql 2005
Quote:
Originally Posted by
skerdikas
well kinda fixed media.pk not dcing anymore and i hope it wont dc again
How did u fixed it LOL ? ;p
Re: [Release] Complete 120 Cap + 13D Database Running in Mssql 2005
well its kinda same fix as npc's fix or one more very easy fix is just make new char ^_^ it was b4 not sure srsly how that text file is called wich i change'd in media huh
Re: [Release] Complete 120 Cap + 13D Database Running in Mssql 2005
try to remember the file name, and explain a little bit clear... Cause i tryed everything... and always after some time the item mall bug...
Re: [Release] Complete 120 Cap + 13D Database Running in Mssql 2005
Quote:
Originally Posted by
I_Satelite_I
try to remember the file name, and explain a little bit clear... Cause i tryed everything... and always after some time the item mall bug...
well yea noticed that after like few hr's or something its bugged once again if it wont gonna get bugged ill just upload media i'v change'd abit like item names there is no more gay fenix shit they have normal names dresses 13d stuff change to Blue Dragon instead some shity fenix and its a dragon years so Blue Dragon is fine it think xD in my media all npc's fixed etc exept item lvl wich ill gonna set like that i think for 12d sox 111
normal a set 111 b set 114 and c set 118(weps acc set parts same lvl) and 13d stuff will be 120 i think its a nice idea and gonna change Jupiter gate lvl bcuz now u can enter from 111 gonna change to 105 well have some more ideas like add new pets and devil spirit with time and for tonight im out gonna go 2 sleep talk with ya 2 morow:sleep:
Re: [Release] Complete 120 Cap + 13D Database Running in Mssql 2005
@skerdikas, So if u need help send to me a private msg here, and i give to u my msn then we can make that changes...
anyway, have a nice night. i'm going away too ;p ! SeeYa;*
Re: [Release] Complete 120 Cap + 13D Database Running in Mssql 2005
i have problem with pets and summons !! no item mall pets spawn at all ! when i try to summon attack pet or grab pet i get DC , no idea why and sometimes when i buy from item mall i get DC as well !! any solution for this ? i did't find any
Re: [Release] Complete 120 Cap + 13D Database Running in Mssql 2005
You thought that i am against you Statiic and i hate u just be aware that i warned you about the bugs!
Quote:
Originally Posted by
kanift
Item mall incorrect?
Try this code
PHP Code:
USE [TEST]
GO
/****** Object: StoredProcedure [dbo].[_UPDATE_COST] Script Date: 02/02/2012 16:10:45 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
-- »óÁ¡°³Æí (ÃÖ¼±È£)
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
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¿¡ µû¶ó¼ À¯Àú ij¸¯ÅÍ ¾ÆÀ̵𰡠³Ñ¾î ¿Ã¼öµµ ÀÖ°í, cos ¾ÆÀ̵𰡠³Ñ¾î ¿Ã ¼öµµ ÀÖ´Ù.
-- ij¸¯ÅÍ ¾ÆÀ̵𸦠¾î¶´ø ¾Ë¾Æ³»¾ß ÇÏ°Ú´Ù.
----------------------------------------------------------
if (@Operation = 19)
begin
-- COS ¿ë ¹°Ç°À» ±¸ÀÔÇѰŴϱñ... ij¸¯ ã¾Æ¼ µ· »©Áà¾ßÁö...
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
-- ½ÇÅ©, ¼±¹°½ÇÅ©, ¸¶Àϸ®Áö¸¦ ±î¾ß Çϴ±¸¸¸.
-- ´Ü, ¸¶Àϸ®Áö´Â ¿É¼ÇÀÌ´Ù.
-- ij¸¯ÅÍÀÇ JID¸¦ ¾ò¾î¿À³Ê¶ó.
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. ¼öÁ¤ Àü ÄÚµå >> -- ÁÖÈ
--------------------------
-- -- °ÔÀÓ ¼¹öÂÊ¿¡¼ °»½Å ¹Þ±â À§ÇØ cost °ªÀ» °á°ú Å×ÀÌºí¿¡ ³Ö¾îµÐ´Ù.
-- 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. ¼öÁ¤ ÈÄ ÄÚµå >> --
--------------------------
-- °ÔÀÓ ¼¹öÂÊ¿¡¼ °»½Å ¹Þ±â À§ÇØ cost °ªÀ» °á°ú Å×ÀÌºí¿¡ ³Ö¾îµÐ´Ù.
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
-- ±æµå¸¦ ¾Ë¾Æ¿Í¶ó.
declare @GuildID int
select @GuildID = GuildID from _GuildMember
where CharID = @PC_ID
IF (@@ERROR <> 0 OR @@ROWCOUNT = 0)
BEGIN
RETURN -2004
END
-- ±æµå Æ÷ÀÎÆ® ±î¶ó.
update _Guild set GatheredSP = GatheredSP - @OffsetOptionalPoint
where GatheredSP >= @OffsetOptionalPoint and ID = @GuildID
IF (@@ERROR <> 0 OR @@ROWCOUNT = 0)
BEGIN
/*
-- ¾øÀ»¼öµµ Àִ°ŴÙ.
-- by novice. 2010-01-15 ¿¡·¯ÄÚµå µ¥ÀÌÅÍÇü È®Àå
-- ¿ø·¡ ÁÖ¼®µÇ¾î ÀÖ´ø ÄÚµåÀÌÁö¸¸, ÃßÈÄ °³¹ßÇÏ´Â »ç¶÷µéÀÌ
-- ¼öÁ¤µÇÁö ¾ÊÀº ³»¿ëÀ» º¸°í È¥¶õ½º·¯¿ö ÇÒ ¼ö ÀÖ¾î¼
-- ÀÌ ºÎºÐ±îÁö ¼öÁ¤Çعö¸²!
-- declare @Slot tinyint
declare @Slot int
declare @RefItemSerial64 bigint
declare @RefItemDBID bigint
declare @RefItemID int
declare @Type tinyint
-- by novice. 2010-01-15 ¿¡·¯ÄÚµå µ¥ÀÌÅÍÇü È®Àå
-- set @Slot = 0xd0 -- error_num ¼¹ö¿¡¼ »ç¿ëÇÏ´Â ¿¡·¯
-- 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 ¼¹ö¿¡¼ »ç¿ëÇÏ´Â ¿¡·¯
set @RefItemSerial64 = 0
set @RefItemDBID = 0
set @RefItemID = 0
set @Type = 2
select @Operation, @Slot, @RefItemSerial64, @RefItemDBID, @RefItemID, @Type
*/
RETURN -2005
END
--------------------------
--<< 2. ¼öÁ¤ Àü ÄÚµå >> --
--------------------------
-- °ÔÀÓ ¼¹öÂÊ¿¡¼ °»½Å ¹Þ±â À§ÇØ cost °ªÀ» °á°ú Å×ÀÌºí¿¡ ³Ö¾îµÐ´Ù.
-- insert into _ResultOfPackageItemToMappingWithServerSide
-- values (@Operation, @CharID, 252, @OffsetOptionalPoint, 8, 0, 1)
--------------------------
--<< 2. ¼öÁ¤ ÈÄ ÄÚµå >> --
--------------------------
-- °ÔÀÓ ¼¹öÂÊ¿¡¼ °»½Å ¹Þ±â À§ÇØ cost °ªÀ» °á°ú Å×ÀÌºí¿¡ ³Ö¾îµÐ´Ù.
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. ¼öÁ¤ Àü ÄÚµå >> --
--------------------------
-- °ÔÀÓ ¼¹öÂÊ¿¡¼ °»½Å ¹Þ±â À§ÇØ cost °ªÀ» °á°ú Å×ÀÌºí¿¡ ³Ö¾îµÐ´Ù.
-- insert into _ResultOfPackageItemToMappingWithServerSide
-- values (@Operation, @CharID, 252, @OffsetOptionalPoint, 32, 0, 1)
--------------------------
--<< 3. ¼öÁ¤ ÈÄ ÄÚµå >> --
--------------------------
-- °ÔÀÓ ¼¹öÂÊ¿¡¼ °»½Å ¹Þ±â À§ÇØ cost °ªÀ» °á°ú Å×ÀÌºí¿¡ ³Ö¾îµÐ´Ù.
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
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
Notice : Please change = USE[.....] and Account name of the database must be = SRO_VT_ACOOUNT
Ty! :D :ott:
Bugs but can be solved bros :D
