Need help for auction:)

Page 1 of 2

06/07/2012 14:33 zorroxxxx#1

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

06/07/2012 17:28 bwr_62#2

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 ;)

06/07/2012 17:43 c1ph3r#3

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

06/07/2012 18:22 Xijezu#4

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.

06/07/2012 18:35 gavsta#5

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"

06/07/2012 19:48 ptifou78#6

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

06/07/2012 20:09 zorroxxxx#7

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

06/07/2012 20:12 TheOnlyOneRaskim#8

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

06/07/2012 22:54 PSmerch#9

use gameserver.opt

game.mem_usage_info_save_interval

06/07/2012 23:13 ptifou78#10

But more the number is low more captain herlock use cpu ;)

06/08/2012 08:53 zorroxxxx#11

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

:D

06/08/2012 09:10 rastamannns#12

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

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

06/08/2012 09:23 zorroxxxx#13

Quote:

Originally Posted by rastamannns

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

ut what do you fucking 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?:mofo:

06/08/2012 09:29 rastamannns#14

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!

06/08/2012 09:33 zorroxxxx#15

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.

Page 1 of 2