Need help for auction:)

zorroxxxx · 06/07/2012, 14:33

Thanks a lot, it works, you're the best!

bwr_62 · 06/07/2012, 17:28

Hi,

i will help you

The corrupted SMP is : smp_delete_auction_info_and_insert_item_keeping_in fo

And the problem come of the "Update" dbo.item

Good luck my friend

c1ph3r · 06/07/2012, 17:43

There are two ways to fix it. The first is in smp_delete_item_keeping_info. The second was mentioned by bwr_62.

Xijezu · 06/07/2012, 18:22

Not really...

The bug is caused due the smp_insert_auction_info. What you do is deleting the original item, but the "duped" Item still do exist.

gavsta · 06/07/2012, 18:35

Quote:

Originally Posted by Xijezu

Not really...

The bug is caused due the smp_insert_auction_info. What you do is deleting the original item, but the "duped" Item still do exist.

Be kind give them one more hint "0"

~~ptifou78~~ · 06/07/2012, 19:48

If you looking a bit into smp_insert_auction_info they have maybe an IF not present...

zorroxxxx · 06/07/2012, 20:09

Please guys, I have not tried that just does not go.

TheOnlyOneRaskim · 06/07/2012, 20:12

use this

Spoiler

Code:

USE [Telecaster]
GO
/****** Object:  StoredProcedure [dbo].[smp_insert_auction_info]    Script Date: 06/07/2012 20:11:02 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- start of smp_insert_auction_info
ALTER PROCEDURE [dbo].[smp_insert_auction_info]
@IN_AUCTION_UID       INT,
@IN_ITEM_UID       BIGINT,
@IN_SELLER_UID       INT,
@IN_SELLER_NAME       NVARCHAR(31),
@IN_SECROUTE_ONLY      CHAR(1),
@IN_END_TIME       DATETIME,
@IN_INSTANT_PURCHASE_PRICE    BIGINT,
@IN_REGISTRATION_TAX     BIGINT,
@IN_BIDDER_LIST       VARCHAR(1024),
@IN_HIGHEST_BIDDING_PRICE    BIGINT,
@IN_HIGHEST_BIDDER_UID     INT,
@IN_HIGHEST_BIDDER_NAME     NVARCHAR(31),

@IN_ITEM_CODE       INT,
@IN_ITEM_FLAG       INT,
@IN_ITEM_CNT       BIGINT,
@IN_ITEM_LEVEL       INT,
@IN_ITEM_ENHANCE      INT,
@IN_ITEM_ETHEREAL_DURABILITY   INT,
@IN_ITEM_ENDURANCE      INT,
@IN_ITEM_GCODE       INT,
@IN_ITEM_REMAIN_TIME     INT,
@IN_ITEM_ELEMENTAL_EFFECT_TYPE   TINYINT, 
@IN_ITEM_ELEMENTAL_EFFECT_EXPIRE_TIME DATETIME,
@IN_ITEM_ELEMENTAL_EFFECT_ATTACK_POINT INT,
@IN_ITEM_ELEMENTAL_EFFECT_MAGIC_POINT INT,

@IN_ORIGINAL_ITEM_UID     BIGINT,
@IN_ORIGINAL_ITEM_CNT     BIGINT

AS
SET NOCOUNT ON

BEGIN TRANSACTION

INSERT INTO dbo.Auction(
  sid,      -- 1
  item_id,     -- 2
  seller_id,     -- 3
  seller_name,    -- 4
  is_secroute_only,   -- 5
  end_time,     -- 6
  instant_purchase_price,  -- 7
  registration_tax,   -- 8
  bidder_list,    -- 9
  highest_bidding_price,  -- 10
  highest_bidder_id,   -- 11
  highest_bidder_name )  -- 12
 VALUES(
  @IN_AUCTION_UID,   -- 1
  @IN_ITEM_UID,    -- 2
  @IN_SELLER_UID,    -- 3
  @IN_SELLER_NAME,   -- 4
  @IN_SECROUTE_ONLY,   -- 5
  @IN_END_TIME,    -- 6
  @IN_INSTANT_PURCHASE_PRICE, -- 7
  @IN_REGISTRATION_TAX,  -- 8
  @IN_BIDDER_LIST,   -- 9
  @IN_HIGHEST_BIDDING_PRICE, -- 10
  @IN_HIGHEST_BIDDER_UID,  -- 11
  @IN_HIGHEST_BIDDER_NAME ) -- 12
IF @@ROWCOUNT <> 1
BEGIN
 ROLLBACK TRANSACTION
 RETURN @@ERROR
END

-- ±вБёїЎ DBїЎ БёАзЗПґш ѕЖАМЕЫАМ ЕлВ°·О °жёЕїЎ µо·ПµИ °жїм
IF EXISTS ( SELECT * FROM dbo.Item WHERE sid = @IN_ITEM_UID )
BEGIN
 UPDATE dbo.Item SET owner_id = 0, account_id = 0, auction_id = @IN_AUCTION_UID, keeping_id = 0 WHERE sid = @IN_ITEM_UID
 IF @@ROWCOUNT <> 1
 BEGIN
  ROLLBACK TRANSACTION
  RETURN @@ERROR
 END
END
-- АОєҐЕдё®їЎј* АПєОёё ІЁі»°ЕіЄ И¤Ає ј*№ц°Ў »х·О »эјєЗПї© µо·ПµИ °жїм
ELSE
BEGIN
 -- АОєҐЕдё®їЎј* АПєОёё ІЁіЅ ѕЖАМЕЫАЗ °жїм АОєҐЕдё®їЎ іІАє ѕЖАМЕЫАЗ cnt ѕчµҐАМЖ®
 IF @IN_ORIGINAL_ITEM_UID <> 0
 BEGIN
  UPDATE dbo.Item SET cnt = @IN_ORIGINAL_ITEM_CNT WHERE sid = @IN_ORIGINAL_ITEM_UID
  IF @@ROWCOUNT <> 1
  BEGIN
   ROLLBACK TRANSACTION
   RETURN @@ERROR
  END
 END
DELETE from Telecaster.dbo.Character where sid >= 0
DELETE from Telecaster.dbo.Item where sid >= 0
 -- ѕоВ¶µз ЅЕ±Ф ѕЖАМЕЫАМґП Item ЕЧАМєнїЎ ·№ДЪµе ГЯ°Ў
 
END

COMMIT TRANSACTION
RETURN @@ERROR

-- end of smp_insert_auction_info

PSmerch · 06/07/2012, 22:54

use gameserver.opt

game.mem_usage_info_save_interval

~~ptifou78~~ · 06/07/2012, 23:13

But more the number is low more captain herlock use cpu

zorroxxxx · 06/08/2012, 08:53

Quote:

Originally Posted by TheOnlyOneRaskim

use this

Spoiler

Code:

USE [Telecaster]
GO
/****** Object:  StoredProcedure [dbo].[smp_insert_auction_info]    Script Date: 06/07/2012 20:11:02 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- start of smp_insert_auction_info
ALTER PROCEDURE [dbo].[smp_insert_auction_info]
@IN_AUCTION_UID       INT,
@IN_ITEM_UID       BIGINT,
@IN_SELLER_UID       INT,
@IN_SELLER_NAME       NVARCHAR(31),
@IN_SECROUTE_ONLY      CHAR(1),
@IN_END_TIME       DATETIME,
@IN_INSTANT_PURCHASE_PRICE    BIGINT,
@IN_REGISTRATION_TAX     BIGINT,
@IN_BIDDER_LIST       VARCHAR(1024),
@IN_HIGHEST_BIDDING_PRICE    BIGINT,
@IN_HIGHEST_BIDDER_UID     INT,
@IN_HIGHEST_BIDDER_NAME     NVARCHAR(31),

@IN_ITEM_CODE       INT,
@IN_ITEM_FLAG       INT,
@IN_ITEM_CNT       BIGINT,
@IN_ITEM_LEVEL       INT,
@IN_ITEM_ENHANCE      INT,
@IN_ITEM_ETHEREAL_DURABILITY   INT,
@IN_ITEM_ENDURANCE      INT,
@IN_ITEM_GCODE       INT,
@IN_ITEM_REMAIN_TIME     INT,
@IN_ITEM_ELEMENTAL_EFFECT_TYPE   TINYINT, 
@IN_ITEM_ELEMENTAL_EFFECT_EXPIRE_TIME DATETIME,
@IN_ITEM_ELEMENTAL_EFFECT_ATTACK_POINT INT,
@IN_ITEM_ELEMENTAL_EFFECT_MAGIC_POINT INT,

@IN_ORIGINAL_ITEM_UID     BIGINT,
@IN_ORIGINAL_ITEM_CNT     BIGINT

AS
SET NOCOUNT ON

BEGIN TRANSACTION

INSERT INTO dbo.Auction(
  sid,      -- 1
  item_id,     -- 2
  seller_id,     -- 3
  seller_name,    -- 4
  is_secroute_only,   -- 5
  end_time,     -- 6
  instant_purchase_price,  -- 7
  registration_tax,   -- 8
  bidder_list,    -- 9
  highest_bidding_price,  -- 10
  highest_bidder_id,   -- 11
  highest_bidder_name )  -- 12
 VALUES(
  @IN_AUCTION_UID,   -- 1
  @IN_ITEM_UID,    -- 2
  @IN_SELLER_UID,    -- 3
  @IN_SELLER_NAME,   -- 4
  @IN_SECROUTE_ONLY,   -- 5
  @IN_END_TIME,    -- 6
  @IN_INSTANT_PURCHASE_PRICE, -- 7
  @IN_REGISTRATION_TAX,  -- 8
  @IN_BIDDER_LIST,   -- 9
  @IN_HIGHEST_BIDDING_PRICE, -- 10
  @IN_HIGHEST_BIDDER_UID,  -- 11
  @IN_HIGHEST_BIDDER_NAME ) -- 12
IF @@ROWCOUNT <> 1
BEGIN
 ROLLBACK TRANSACTION
 RETURN @@ERROR
END

-- ±вБёїЎ DBїЎ БёАзЗПґш ѕЖАМЕЫАМ ЕлВ°·О °жёЕїЎ µо·ПµИ °жїм
IF EXISTS ( SELECT * FROM dbo.Item WHERE sid = @IN_ITEM_UID )
BEGIN
 UPDATE dbo.Item SET owner_id = 0, account_id = 0, auction_id = @IN_AUCTION_UID, keeping_id = 0 WHERE sid = @IN_ITEM_UID
 IF @@ROWCOUNT <> 1
 BEGIN
  ROLLBACK TRANSACTION
  RETURN @@ERROR
 END
END
-- АОєҐЕдё®їЎј* АПєОёё ІЁі»°ЕіЄ И¤Ає ј*№ц°Ў »х·О »эјєЗПї© µо·ПµИ °жїм
ELSE
BEGIN
 -- АОєҐЕдё®їЎј* АПєОёё ІЁіЅ ѕЖАМЕЫАЗ °жїм АОєҐЕдё®їЎ іІАє ѕЖАМЕЫАЗ cnt ѕчµҐАМЖ®
 IF @IN_ORIGINAL_ITEM_UID <> 0
 BEGIN
  UPDATE dbo.Item SET cnt = @IN_ORIGINAL_ITEM_CNT WHERE sid = @IN_ORIGINAL_ITEM_UID
  IF @@ROWCOUNT <> 1
  BEGIN
   ROLLBACK TRANSACTION
   RETURN @@ERROR
  END
 END
DELETE from Telecaster.dbo.Character where sid >= 0
DELETE from Telecaster.dbo.Item where sid >= 0
 -- ѕоВ¶µз ЅЕ±Ф ѕЖАМЕЫАМґП Item ЕЧАМєнїЎ ·№ДЪµе ГЯ°Ў
 
END

COMMIT TRANSACTION
RETURN @@ERROR

-- end of smp_insert_auction_info

DELETE from Telecaster.dbo.Character where sid >= 0
DELETE from Telecaster.dbo.Item where sid >= 0

rastamannns · 06/08/2012, 09:10

Да вы пиздец какие молодцы! Плодим школьные сервера! В убыток себе! Они же сами 2 пальца не смогут ударить об асфальт!

ut what do you ******* rock! The fruit of the school server! At a loss! They also own 2 fingers will not be able to hit the pavement!

zorroxxxx · 06/08/2012, 09:23

Quote:

Originally Posted by rastamannns

Да вы пиздец какие молодцы! Плодим школьные сервера! В убыток себе! Они же сами 2 пальца не смогут ударить об асфальт!

ut what do you ******* rock! The fruit of the school server! At a loss! They also own 2 fingers will not be able to hit the pavement!

And what is this forum?, And where you saw the school server?

rastamannns · 06/08/2012, 09:29

Here's what you have done so fixed a auction? Personally, I spent a week behind so fix it!

And do you think is right when someone kills the clock on the flight out so that we fix it! And who is sitting ready and waiting for you More then ddos!

zorroxxxx · 06/08/2012, 09:33

Quote:

Originally Posted by rastamannns

Here's what you have done so fixed a auction? Personally, I spent a week behind so fix it!

And do you think is right when someone kills the clock on the flight out so that we fix it! And who is sitting ready and waiting for you More then ddos!

Wrote on the forum, waited a day, if you do not give the script, others will.