Treasure point help

Acardia · Feb 2, 2011

Ive got the basic info but what values go in the TREASURE_RT & MOD_SEQ when i play a game i get no points at all

malcomtidus · Feb 2, 2011

Thank you, this is the same issue I'm having. TREASURE_RT is the rate modifier of the speed of the Treasure Gauge being filled, but I'm not sure what goes in MOD_SEQ.

Do you know what goes in TREASURE_BOX?

bubbastic · Feb 2, 2011

treasure box are for items dropping out from holes
there must be an item id and a rate but this is another problem

treasure points and treasure box are 2 differents things. you should focus on one of them

then work on the other once the 1st is fixed

malcomtidus · Feb 2, 2011

Ah, right bubbastic, thanks.

I'm still trying to figure out why I'm not getting Treasure Point progression...

Acardia · Feb 3, 2011

bubbastic said:
treasure box are for items dropping out from holes
there must be an item id and a rate but this is another problem
treasure points and treasure box are 2 differents things. you should focus on one of them then work on the other once the 1st is fixed

i get what they do but even insane values dont show any treasure points in game :grr:

i just need the valumes that go in the two rows for MOD_SEQ and the treasure one

malcomtidus · Feb 3, 2011

well Arcadia, if you're talking about TREASURE_RT - That's the rate of treasure progression, (as far as I know), I'm pretty sure it changes the rate of the treasure gauge (that white-yellow bar underneath the map name) filling.

I'm not sure what MOD_SEQ is for.

X_Sarah_X · Feb 3, 2011

I will experiment with it a little when I get home and let you know what I find out.

Acardia · Feb 4, 2011

Still nothing at all :$: ive tried over 100 values today the bar hasn't moved at all

malcomtidus · Feb 4, 2011

I don't understand, there are people with working Treasure Points, and we've followed the help we were given, there must be another small step there.

Acardia · Feb 5, 2011

malcomtidus said:
I don't understand, there are people with working Treasure Points, and we've followed the help we were given, there must be another small step there.

There's Something we're missing but i cant figure out what :$:

PHOENIXXXX · Feb 13, 2011

Items are droppping but not enough as it should be.
Therefore some dropped items are missing from the inventory or stats like pangs bags, cardpacks and fragments of time.
I've tried to change the rates but something is still missing.

Acardia · Feb 15, 2011

PHOENIXXXX said:
Items are droppping but not enough as it should be.
Therefore some dropped items are missing from the inventory or stats like pangs bags, cardpacks and fragments of time.
I've tried to change the rates but something is still missing.

im still trying so far nothing

hvdaedalus · Apr 11, 2011

I found something in the logs! Could be helpful.

Code:

0x00645190 3 ei.spl->ei.srv_log log/20201_20110411_0400.1.ei.spl ]]  0x02491550 3 3 ] 2011-04-11 04:00:54	101	Cadie	2	CallProfile [Count:1792]
2011-04-11 04:01:03	107	Cadie	1	[E_ODBC] ErrCode(42000) ErrMsg([Microsoft][SQL Server Native Client 10.0][SQL Server]Procedure or function USP_TREASURE_POINT has too many arguments specified.)
2011-04-11 04:01:03	107	Cadie	1	[F_QUERY] LastSuccQuery(exec dbo.ProcGet_PCBang_Point_Item), CurrQuery({ call dbo.USP_TREASURE_POINT (7, 1, 0, 1, 0) })
0x00645190 3 ei.spl->ei.srv_log log/20201_20110411_0400.1.ei.spl ]]  0x02491550 3 3 ] 2011-04-11 04:01:03	107	Cadie	1	[E_ODBC] ErrCode(42000) ErrMsg([Microsoft][SQL Server Native Client 10.0][SQL Server]Procedure or function USP_TREASURE_POINT has too many arguments specified.)
0x00645190 3 ei.spl->ei.srv_log log/20201_20110411_0400.1.ei.spl ]]  0x02491550 3 3 ] 2011-04-11 04:01:03	107	Cadie	1	[F_QUERY] LastSuccQuery(exec dbo.ProcGet_PCBang_Point_Item), CurrQuery({ call dbo.USP_TREASURE_POINT (7, 1, 0, 1, 0) })

bubbastic · Apr 11, 2011

I thought this was already released :/
When I have some time, I'll post the infos so you can fill the tables correctly.

hvdaedalus · Apr 11, 2011

Thank you Mr. Awesome bubbastic

Without you and fasa2008 and some other special guys this is simply not possible

bubbastic · Apr 11, 2011

Too lazy to create an automated query. Here's an excel file. Just copy and paste the datas in the tables TA_TREASURE_COURSE, TA_TREASURE_RT, TA_TREASURE_HOLE.

As always, have fun

:

hvdaedalus · Apr 12, 2011

You are the hero. You saved my day again.

swdl · Apr 12, 2011

thanks bublastic

hvdaedalus · Apr 12, 2011

Here is the query. Thanks bubbastic

Code:

USE Pangya_S4_TH
GO

-- ----------------------------
-- Records of TA_TREASURE_COURSE
-- ----------------------------
INSERT INTO [dbo].[TA_TREASURE_COURSE] VALUES (N'0', N'Blue Lagoon', null, N'1', N'.25', null, N'1', N'y', N'2011-01-26 23:48:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_COURSE] VALUES (N'1', N'Blue Water', null, N'3', N'.25', null, N'1', N'y', N'2011-01-26 23:48:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_COURSE] VALUES (N'2', N'Sepia Wind', null, N'3', N'.25', null, N'1', N'y', N'2011-01-26 23:48:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_COURSE] VALUES (N'3', N'Wind Hill', null, N'5', N'.25', null, N'1', N'y', N'2011-01-26 23:48:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_COURSE] VALUES (N'4', N'Wiz Wiz', null, N'4', N'.25', null, N'1', N'y', N'2011-01-26 23:48:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_COURSE] VALUES (N'5', N'West Wiz', null, N'1', N'.25', null, N'1', N'y', N'2011-01-26 23:48:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_COURSE] VALUES (N'6', N'Blue Moon', null, N'3', N'.25', null, N'1', N'y', N'2011-01-26 23:48:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_COURSE] VALUES (N'7', N'Silvia Cannon', null, N'4', N'.25', null, N'1', N'y', N'2011-01-26 23:48:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_COURSE] VALUES (N'8', N'Ice Cannon', null, N'2', N'.25', null, N'1', N'y', N'2011-01-26 23:48:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_COURSE] VALUES (N'9', N'White_Wiz', null, N'3', N'.25', null, N'1', N'y', N'2011-01-26 23:48:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_COURSE] VALUES (N'10', N'Shining Sand', null, N'2', N'.25', null, N'1', N'y', N'2011-01-26 23:48:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_COURSE] VALUES (N'11', N'Pink Wind', null, N'1', N'.25', null, N'1', N'y', N'2011-01-26 23:48:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_COURSE] VALUES (N'12', N'Moon_Dummy', null, N'1', N'.25', null, N'1', N'y', N'2011-01-26 23:48:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_COURSE] VALUES (N'13', N'Inferno', null, N'5', N'.25', null, N'1', N'y', N'2011-01-26 23:48:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_COURSE] VALUES (N'14', N'Ice Spa', null, N'1', N'.25', null, N'1', N'y', N'2011-01-26 23:48:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_COURSE] VALUES (N'15', N'Lost Seaway', null, N'1', N'.25', null, N'1', N'y', N'2011-01-26 23:48:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_COURSE] VALUES (N'16', N'Eastern Valley', null, N'2', N'.25', null, N'1', N'y', N'2011-01-26 23:48:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_COURSE] VALUES (N'17', N'Maps', null, N'1', N'.25', null, N'1', N'y', N'2011-01-26 23:48:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_COURSE] VALUES (N'127', N'Random', null, N'1', N'.25', null, N'1', N'y', N'2011-01-26 23:48:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_COURSE] VALUES (N'138', N'TEST', null, N'1', N'.25', null, N'1', N'y', N'2011-01-26 23:48:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_COURSE] VALUES (N'253', N'TUTO', null, N'1', N'.25', null, N'1', N'y', N'2011-01-26 23:48:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_COURSE] VALUES (N'254', N'TEST', null, N'1', N'.25', null, N'1', N'y', N'2011-01-26 23:48:00.000');
GO

-- ----------------------------
-- Records of TA_TREASURE_HOLE
-- ----------------------------
INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'-54', N'1', N'1', N'Y', N'2010-12-29 17:56:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'-53', N'1', N'1', N'Y', N'2010-12-29 17:58:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'-52', N'1', N'1', N'Y', N'2010-12-29 17:58:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'-51', N'1', N'1', N'Y', N'2010-12-29 17:58:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'-50', N'1', N'1', N'Y', N'2010-12-29 17:58:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'-49', N'1', N'1', N'Y', N'2010-12-29 17:58:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'-48', N'1', N'1', N'Y', N'2010-12-29 17:58:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'-47', N'1', N'1', N'Y', N'2010-12-29 17:58:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'-46', N'1', N'1', N'Y', N'2010-12-29 17:58:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'-45', N'1', N'1', N'Y', N'2010-12-29 17:58:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'-44', N'1', N'1', N'Y', N'2010-12-29 17:58:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'-43', N'1', N'1', N'Y', N'2010-12-29 17:58:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'-42', N'1', N'1', N'Y', N'2010-12-29 17:58:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'-41', N'1', N'1', N'Y', N'2010-12-29 17:58:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'-40', N'1', N'1', N'Y', N'2010-12-29 17:58:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'-39', N'1', N'1', N'Y', N'2010-12-29 17:58:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'-38', N'1', N'1', N'Y', N'2010-12-29 17:58:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'-37', N'1', N'1', N'Y', N'2010-12-29 17:58:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'-36', N'1', N'1', N'Y', N'2010-12-29 17:59:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'-35', N'1', N'1', N'Y', N'2010-12-29 17:59:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'-34', N'1', N'1', N'Y', N'2010-12-29 17:59:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'-33', N'1', N'1', N'Y', N'2010-12-29 17:59:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'-32', N'1', N'1', N'Y', N'2010-12-29 17:59:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'-31', N'1', N'1', N'Y', N'2010-12-29 17:59:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'-30', N'1', N'1', N'Y', N'2010-12-29 17:59:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'-29', N'1', N'1', N'Y', N'2010-12-29 17:59:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'-28', N'1', N'1', N'Y', N'2010-12-29 17:59:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'-27', N'1', N'1', N'Y', N'2010-12-29 17:59:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'-26', N'1', N'1', N'Y', N'2010-12-29 17:59:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'-25', N'1', N'1', N'Y', N'2010-12-29 17:59:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'-24', N'1', N'1', N'Y', N'2010-12-29 17:59:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'-23', N'1', N'1', N'Y', N'2010-12-29 17:59:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'-22', N'1', N'1', N'Y', N'2010-12-29 17:59:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'-21', N'1', N'1', N'Y', N'2010-12-29 17:59:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'-20', N'1', N'1', N'Y', N'2010-12-29 17:59:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'-19', N'1', N'1', N'Y', N'2010-12-29 17:59:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'-18', N'1', N'1', N'Y', N'2010-12-29 17:59:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'-17', N'1', N'1', N'Y', N'2010-12-29 17:59:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'-16', N'1', N'1', N'Y', N'2010-12-29 17:59:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'-15', N'1', N'1', N'Y', N'2010-12-29 17:59:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'-14', N'1', N'1', N'Y', N'2010-12-29 17:59:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'-13', N'1', N'1', N'Y', N'2010-12-29 17:59:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'-12', N'1', N'1', N'Y', N'2010-12-29 17:59:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'-11', N'1', N'1', N'Y', N'2010-12-29 18:00:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'-10', N'1', N'1', N'Y', N'2010-12-29 18:00:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'-9', N'1', N'1', N'Y', N'2010-12-29 18:00:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'-8', N'1', N'1', N'Y', N'2010-12-29 18:00:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'-7', N'1', N'1', N'Y', N'2010-12-29 18:00:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'-6', N'1', N'1', N'Y', N'2010-12-29 18:00:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'-5', N'1', N'1', N'Y', N'2010-12-29 18:00:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'-4', N'1', N'1', N'Y', N'2010-12-29 18:00:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'-3', N'1', N'1', N'Y', N'2010-12-29 18:00:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'-2', N'1', N'1', N'Y', N'2010-12-29 18:00:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'-1', N'1', N'1', N'Y', N'2010-12-29 18:00:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'0', N'0', N'1', N'Y', N'2010-12-29 18:00:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'1', N'0', N'0', N'Y', N'2010-12-29 18:00:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'2', N'0', N'0', N'Y', N'2010-12-29 18:00:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'3', N'0', N'0', N'Y', N'2010-12-29 18:00:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'4', N'0', N'0', N'Y', N'2010-12-29 18:00:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'5', N'0', N'0', N'Y', N'2010-12-29 18:00:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'6', N'0', N'0', N'Y', N'2010-12-29 18:00:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'7', N'0', N'0', N'Y', N'2010-12-29 18:00:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'8', N'0', N'0', N'Y', N'2010-12-29 18:00:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'9', N'0', N'0', N'Y', N'2010-12-29 18:00:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'10', N'0', N'0', N'Y', N'2010-12-29 18:00:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'11', N'0', N'0', N'Y', N'2010-12-29 18:00:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'12', N'0', N'0', N'Y', N'2010-12-29 18:00:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'13', N'0', N'0', N'Y', N'2010-12-29 18:00:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'14', N'0', N'0', N'Y', N'2010-12-29 18:00:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'15', N'0', N'0', N'Y', N'2010-12-29 18:00:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'16', N'0', N'0', N'Y', N'2010-12-29 18:00:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'17', N'0', N'0', N'Y', N'2010-12-29 18:00:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'18', N'0', N'0', N'Y', N'2010-12-29 18:00:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'19', N'0', N'0', N'Y', N'2010-12-29 18:00:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'20', N'0', N'0', N'Y', N'2010-12-29 18:00:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'21', N'0', N'0', N'Y', N'2010-12-29 18:00:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'22', N'0', N'0', N'Y', N'2010-12-29 18:00:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'23', N'0', N'0', N'Y', N'2010-12-29 18:00:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'24', N'0', N'0', N'Y', N'2010-12-29 18:00:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'25', N'0', N'0', N'Y', N'2010-12-29 18:00:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'26', N'0', N'0', N'Y', N'2010-12-29 18:00:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'27', N'0', N'0', N'Y', N'2010-12-29 18:00:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'28', N'0', N'0', N'Y', N'2010-12-29 18:00:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'29', N'0', N'0', N'Y', N'2010-12-29 18:00:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'30', N'0', N'0', N'Y', N'2010-12-29 18:00:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'31', N'0', N'0', N'Y', N'2010-12-29 18:00:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'32', N'0', N'0', N'Y', N'2010-12-29 18:00:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'33', N'0', N'0', N'Y', N'2010-12-29 18:00:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'34', N'0', N'0', N'Y', N'2010-12-29 18:01:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'35', N'0', N'0', N'Y', N'2010-12-29 18:01:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'36', N'0', N'0', N'Y', N'2010-12-29 18:01:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'37', N'0', N'0', N'Y', N'2010-12-29 18:01:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'38', N'0', N'0', N'Y', N'2010-12-29 18:01:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'39', N'0', N'0', N'Y', N'2010-12-29 18:01:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'40', N'0', N'0', N'Y', N'2010-12-29 18:01:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'41', N'0', N'0', N'Y', N'2010-12-29 18:01:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'42', N'0', N'0', N'Y', N'2010-12-29 18:01:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'43', N'0', N'0', N'Y', N'2010-12-29 18:01:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'44', N'0', N'0', N'Y', N'2010-12-29 18:01:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'45', N'0', N'0', N'Y', N'2010-12-29 18:01:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'46', N'0', N'0', N'Y', N'2010-12-29 18:01:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'47', N'0', N'0', N'Y', N'2010-12-29 18:01:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'48', N'0', N'0', N'Y', N'2010-12-29 18:01:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'49', N'0', N'0', N'Y', N'2010-12-29 18:01:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'50', N'0', N'0', N'Y', N'2010-12-29 18:01:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'51', N'0', N'0', N'Y', N'2010-12-29 18:01:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'52', N'0', N'0', N'Y', N'2010-12-29 18:01:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'53', N'0', N'0', N'Y', N'2010-12-29 18:01:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'54', N'0', N'0', N'Y', N'2010-12-29 18:01:00.000');
GO

-- ----------------------------
-- Records of TA_TREASURE_RT
-- ----------------------------
INSERT INTO [dbo].[TA_TREASURE_RT] VALUES (N'0', N'25.00', N'1', N'Y', N'2010-12-29 18:20:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_RT] VALUES (N'1', N'40.00', N'1', N'y', N'2010-12-29 18:09:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_RT] VALUES (N'2', N'40.00', N'1', N'Y', N'2010-12-29 18:09:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_RT] VALUES (N'3', N'75.00', N'1', N'Y', N'2010-12-29 18:09:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_RT] VALUES (N'4', N'65.00', N'1', N'Y', N'2010-12-29 18:09:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_RT] VALUES (N'5', N'25.00', N'1', N'Y', N'2010-12-29 18:09:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_RT] VALUES (N'6', N'40.00', N'1', N'Y', N'2010-12-29 18:09:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_RT] VALUES (N'7', N'65.00', N'1', N'Y', N'2010-12-29 18:09:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_RT] VALUES (N'8', N'30.00', N'1', N'Y', N'2010-12-29 18:09:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_RT] VALUES (N'9', N'40.00', N'1', N'Y', N'2010-12-29 18:09:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_RT] VALUES (N'10', N'30.00', N'1', N'Y', N'2010-12-29 18:09:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_RT] VALUES (N'11', N'25.00', N'1', N'Y', N'2010-12-29 18:09:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_RT] VALUES (N'12', N'25.00', N'1', N'Y', N'2010-12-29 18:09:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_RT] VALUES (N'13', N'75.00', N'1', N'Y', N'2010-12-29 18:09:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_RT] VALUES (N'14', N'25.00', N'1', N'Y', N'2010-12-29 18:09:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_RT] VALUES (N'15', N'25.00', N'1', N'Y', N'2010-12-29 18:09:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_RT] VALUES (N'16', N'30.00', N'1', N'Y', N'2010-12-29 18:09:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_RT] VALUES (N'17', N'25.00', N'1', N'Y', N'2010-12-29 18:20:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_RT] VALUES (N'127', N'25.00', N'1', N'Y', N'2010-12-29 18:20:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_RT] VALUES (N'138', N'25.00', N'1', N'Y', N'2010-12-29 18:20:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_RT] VALUES (N'253', N'25.00', N'1', N'Y', N'2010-12-29 18:20:00.000');
GO
INSERT INTO [dbo].[TA_TREASURE_RT] VALUES (N'254', N'25.00', N'1', N'Y', N'2010-12-29 18:20:00.000');
GO

codyx · Apr 20, 2011

even the tables full I still got the following error :

Code:

Procedure or function USP_TREASURE_POINT has too many arguments specified.)
CurrQuery({ call dbo.USP_TREASURE_POINT (9, 0, 0, 1, 0) })

I see in the db that it needs only 4 :

Code:

[dbo].[USP_TREASURE_POINT] (   
 @MAP_ID INT     --맵아이디  
 , @SCORE INT    --게임 SCORE  
 , @EQUIP_DROP NUMERIC(5, 2) --드랍율  
 , @INTVAL INT = 1   -- DEFAULT (1 HOUR)  
)

Example :

Code:

** EXEC DBO.USP_TREASURE_POINT 3, -2, 2.1, 1

Could that be from the fact that the 3rd value is on decimal number with "2,1" insteed of "2.1" so taken as 2 vars?

Welcome!

Treasure point help

Junior Spellweaver

Newbie Spellweaver

Junior Spellweaver

Newbie Spellweaver

Junior Spellweaver

Newbie Spellweaver

All CHAOS!

Junior Spellweaver

Newbie Spellweaver

Junior Spellweaver

Newbie Spellweaver

Junior Spellweaver

Junior Spellweaver

Junior Spellweaver

Junior Spellweaver

Junior Spellweaver

Attachments

Junior Spellweaver

Newbie Spellweaver

Junior Spellweaver

Newbie Spellweaver

About Us

Online statistics

Forum statistics

RaGEZONE Sponsor