Trade items[DC]

[kubed]

can any one help me
when i make trade from jangan to dw and try to sell my fking item trade Got DC
How i can fixed it ?

[Royalblade*]

Tell me the error that you get in the GS...

Is it something like [AQ:StorageUpdater] .... Failed blabla
If yes, copy paste the whole error log to see where it bugs. Should be pretty simple to solve.

[kubed]

thank you very much for answer me
yes i got some error at GM

-
-DB Query Error(100): EXEC _AddTrijobReward 3, 68553

-AQ_Trijob for Update Reward Failed!!

-AQ Failed! Log out!! [AQType: 13]

i hope you know how i can fixed it
thanks

[Royalblade*]

USE [SRO_VT_SHARD]
ALTER PROCEDURE [dbo].[_AddTrijobReward]
@JobType TINYINT,
@Reward INT
AS
RETURN

Will fix it.

[kubed]

Originally Posted by blablaRoyal

USE [SRO_VT_SHARD]
ALTER PROCEDURE [dbo].[_AddTrijobReward]
@JobType TINYINT,
@Reward INT
AS
RETURN

Will fix it.

Big thanks for try to help me :
but i got this error when i try to add this query
-------------
Msg 111, Level 15, State 1, Procedure _AddTrijobReward, Line 6
'CREATE/ALTER PROCEDURE' must be the first statement in a query batch.
--------------
i hope you can fixed it
*Its my _AddTrijobReward

USE [SRO_VT_SHARD]
GO
/****** Object: StoredProcedure [dbo].[_AddTrijobReward] Script Date: 1/17/2015 8:32:16 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO

ALTER PROCEDURE [dbo].[_AddTrijobReward]
@JobType TINYINT,
@Reward INT
AS
UPDATE _TrijobRewards SET Reward = (Reward + @Reward) WHERE JobType = @JobType

[Syloxx]

USE [SRO_VT_SHARD]
GO

/****** Object:  Table [dbo].[_TrijobRewards]    Script Date: 17.01.2015 09:08:12 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

DROP TABLE [dbo].[_TrijobRewards]
GO

CREATE TABLE [dbo].[_TrijobRewards](
	[JobType] [tinyint] NOT NULL,
	[Reward] [bigint] NOT NULL CONSTRAINT [DF__TrijobRewards]  DEFAULT (0),
 CONSTRAINT [PK__TrijobRewards] PRIMARY KEY CLUSTERED 
(
	[JobType] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]

GO

try this then

[kubed]

Originally Posted by Syloxx

USE [SRO_VT_SHARD]
GO

/****** Object:  Table [dbo].[_TrijobRewards]    Script Date: 17.01.2015 09:08:12 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

DROP TABLE [dbo].[_TrijobRewards]
GO

CREATE TABLE [dbo].[_TrijobRewards](
	[JobType] [tinyint] NOT NULL,
	[Reward] [bigint] NOT NULL CONSTRAINT [DF__TrijobRewards]  DEFAULT (0),
 CONSTRAINT [PK__TrijobRewards] PRIMARY KEY CLUSTERED 
(
	[JobType] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]

GO

try this then

not working error
DB Query Error(100): EXEC _AddTrijobReward 3, 68553

[Syloxx]

so run this query
EXEC _AddTrijobReward 3, 68553
and tell me whats the restult

usually it should work fine o.O

[kubed]

Originally Posted by Syloxx

so run this query
EXEC _AddTrijobReward 3, 68553
and tell me whats the restult

usually it should work fine o.O

thanks very much for try help me
but
i got 0
----

(0 row(s) affected)
----

[Syloxx]

INSERT INTO _TrijobRewards VALUES (1,0)
INSERT INTO _TrijobRewards VALUES (2,0)
INSERT INTO _TrijobRewards VALUES (3,0)

try this

[kubed]

Originally Posted by Syloxx

INSERT INTO _TrijobRewards VALUES (1,0)
INSERT INTO _TrijobRewards VALUES (2,0)
INSERT INTO _TrijobRewards VALUES (3,0)

try this

got
-------

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

----------
i must restart server to try !
it's working ?

[Syloxx]

server restart isn't required just try to sell your trader goods ^^

[kubed]

it's working so good
thanks very much
you are super hero
------
please tell me fast how i can edit rate gold
because it so high and will destroyed my system
---------
i need every trade earned 200~300 m
how i can do it
??

[Syloxx]

_ItemQuotation
_RefObjCommon

one of this both tables.
there are tons of releases search for it

[kubed]

Originally Posted by Syloxx

_ItemQuotation
_RefObjCommon

one of this both tables.
there are tons of releases search for it

thank you for help
you are the one
i will try to Google for rate gold
have nice day