|
You last visited: Today at 11:54
Advertisement
Need help for auction:)
Discussion on Need help for auction:) within the Rappelz Private Server forum part of the Rappelz category.
06/07/2012, 14:33
|
#1
|
elite*gold: 0
Join Date: Jul 2011
Posts: 8
Received Thanks: 0
|
Need help for auction:)
Thanks a lot, it works, you're the best!
|
|
|
06/07/2012, 17:28
|
#2
|
elite*gold: 0
Join Date: Jan 2011
Posts: 137
Received Thanks: 64
|
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
|
#3
|
elite*gold: 0
Join Date: Sep 2008
Posts: 1,606
Received Thanks: 1,210
|
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
|
#4
|
elite*gold: 0
Join Date: May 2011
Posts: 5,084
Received Thanks: 3,458
|
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
|
#5
|
elite*gold: 0
Join Date: Jul 2010
Posts: 1,141
Received Thanks: 634
|
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
|
#6
|
elite*gold: 0
Join Date: Jan 2010
Posts: 390
Received Thanks: 396
|
If you looking a bit into smp_insert_auction_info they have maybe an IF not present...
|
|
|
06/07/2012, 20:09
|
#7
|
elite*gold: 0
Join Date: Jul 2011
Posts: 8
Received Thanks: 0
|
Please guys, I have not tried that just does not go.
|
|
|
06/07/2012, 20:12
|
#8
|
elite*gold: 0
Join Date: Nov 2011
Posts: 978
Received Thanks: 1,011
|
use this
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
|
#9
|
elite*gold: 0
Join Date: Sep 2011
Posts: 43
Received Thanks: 3
|
use gameserver.opt
game.mem_usage_info_save_interval
|
|
|
06/07/2012, 23:13
|
#10
|
elite*gold: 0
Join Date: Jan 2010
Posts: 390
Received Thanks: 396
|
But more the number is low more captain herlock use cpu
|
|
|
06/08/2012, 08:53
|
#11
|
elite*gold: 0
Join Date: Jul 2011
Posts: 8
Received Thanks: 0
|
Quote:
Originally Posted by TheOnlyOneRaskim
use this
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
|
|
|
06/08/2012, 09:10
|
#12
|
elite*gold: 0
Join Date: Mar 2011
Posts: 102
Received Thanks: 51
|
Да вы пиздец какие молодцы! Плодим школьные сервера! В убыток себе! Они же сами 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!
|
|
|
06/08/2012, 09:23
|
#13
|
elite*gold: 0
Join Date: Jul 2011
Posts: 8
Received Thanks: 0
|
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?
|
|
|
06/08/2012, 09:29
|
#14
|
elite*gold: 0
Join Date: Mar 2011
Posts: 102
Received Thanks: 51
|
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
|
#15
|
elite*gold: 0
Join Date: Jul 2011
Posts: 8
Received Thanks: 0
|
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.
|
|
|
|
|
Similar Threads
|
Bug Auction !! ;)
06/03/2012 - Rappelz Private Server - 11 Replies
Hey guys
How can i fix the Duplication bug from AUCTION please :o (like Infinite server)
|
auction bot?
08/05/2009 - WoW Bots - 3 Replies
gibt es einen bot, bei dem man einfach einen gegenstand eingibt und der bot versucht dann im ah einfach die ganze zeit diesen gegenstand zu kaufen, sobald er im angebot ist?
ist an sich ja nicht sehr kompliziert... und es wäre eine ziemlich fiese und raffinierte weise geld zu machen (monopolstellung)
|
WOW Auction Bot
06/09/2007 - WoW Bots - 14 Replies
Hey,
I found this really nice Auction bot on the internet and I can only tell u "great work" !
This is a very nice bot which shows you all the items in the auction which are under the usual price so it tell you the specific item. You just buy it and get more money :)
It has a lot of other futures ... hav a look at it :)
Your OnlyPrinzP and please write a comment :) thx
DOWNLOAD ---> WOW Auction Bot Rapidshare ( size : 2,52 MB )
|
All times are GMT +2. The time now is 11:54.
|
|