Trade items[DC]

01/17/2015 05:04 kubed#1

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 ?

01/17/2015 06:09 Royalblade*#2

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.

01/17/2015 06:28 kubed#3

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

01/17/2015 07:15 Royalblade*#4

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

Will fix it.

01/17/2015 07:21 kubed#5

Quote:

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

Quote:

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

01/17/2015 09:08 Syloxx#6

Code:

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

01/17/2015 10:22 kubed#7

Quote:

Originally Posted by Syloxx

Code:

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

01/17/2015 10:25 Syloxx#8

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

usually it should work fine o.O

01/17/2015 10:36 kubed#9

Quote:

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)
----
:(

01/17/2015 10:40 Syloxx#10

Code:

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

try this

01/17/2015 10:41 kubed#11

Quote:

Originally Posted by Syloxx

Code:

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 ?

01/17/2015 10:45 Syloxx#12

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

01/17/2015 10:56 kubed#13

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
??

01/17/2015 11:05 Syloxx#14

_ItemQuotation
_RefObjCommon

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

01/17/2015 11:18 kubed#15

Quote:

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