Treasure point help

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

Re: Treasure point help

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?

Re: Treasure point help

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

Re: Treasure point help

Ah, right bubbastic, thanks.

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

Re: Treasure point help

Quote:

Originally Posted by bubbastic

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

Re: Treasure point help

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.

Re: Treasure point help

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

Re: Treasure point help

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

Re: Treasure point help

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.

Re: Treasure point help

Quote:

Originally Posted by malcomtidus

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 :$:

Re: Treasure point help

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.

Re: Treasure point help

Quote:

Originally Posted by PHOENIXXXX

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

Re: Treasure point help

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

Re: Treasure point help

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

Re: Treasure point help

Thank you Mr. Awesome bubbastic :) Without you and fasa2008 and some other special guys this is simply not possible :)

1 Attachment(s)

Re: Treasure point help

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 :D:

Re: Treasure point help

You are the hero. You saved my day again. :D

Re: Treasure point help

thanks bublastic

Re: Treasure point help

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

Re: Treasure point help

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?

Re: Treasure point help

Spoiler:

Code:

ALTER PROC [dbo].[USP_TREASURE_POINT] ( @MAP_ID INT --맵아이디 , @SCORE INT --게임 SCORE , @EQUIP_DROP1 INT --드랍율 , @EQUIP_DROP2 INT , @INTVAL INT = 1 -- DEFAULT (1 HOUR) ) -- WITH ENCRYPTION AS BEGIN /******************************************************* ** 트레져 포인트 계산 ** EXEC DBO.USP_TREASURE_POINT 3, -2, 2.1, 1 *******************************************************/ SET NOCOUNT ON -- -- SELECT @MAP_ID = 3 -- , @SCORE = -2 -- , @EQUIP_DROP = 2.1 -- , @INTVAL = 1 IF OBJECT_ID('TEMPDB..#TREASURE_STAT') IS NOT NULL DROP TABLE #TREASURE_STAT CREATE TABLE #TREASURE_STAT (MAP_ID INT, CT INT, RT NUMERIC(5, 2)) INSERT INTO #TREASURE_STAT (MAP_ID, CT, RT) EXEC DBO.USP_TREASURE_GAGE 1 -- SELECT -- MAP_ID, CT, RT -- FROM -- DBO.TD_TREASURE_STAT -- WHERE -- MOD_SEQ = (SELECT MAX(MOD_SEQ) FROM DBO.TD_TREASURE_STAT WHERE USE_YN = 'Y') DECLARE @EQUIP_DROP NUMERIC(5,2) SELECT @EQUIP_DROP = CAST(CAST(@EQUIP_DROP1 AS VARCHAR(2)) + '.' + CAST(@EQUIP_DROP2 AS VARCHAR(2)) AS NUMERIC(5,2)) SELECT TREASURE_POINT = CAST(ROUND((F.BASIC_TREASURE_POINT + @EQUIP_DROP) * (E.TREASURE_RT + E.TREASURE_ADD_RT), 0) AS INT) FROM ( SELECT C.MAP_ID , C.DIFFICULT , C.TREASURE_ADD_RT , C.TREASURE_BOX , C.C_RT , D.TREASURE_RT FROM ( SELECT MAP_ID = A.MAP_NO , A.DIFFICULT , A.TREASURE_ADD_RT , A.TREASURE_BOX , C_RT = ISNULL(B.C_RT, 0) FROM ( SELECT MAP_NO , DIFFICULT , TREASURE_ADD_RT , TREASURE_BOX FROM TA_TREASURE_COURSE WHERE MAP_NO = @MAP_ID AND USE_YN = 'Y' ) A LEFT OUTER JOIN (SELECT MAP_ID , CT , RT , C_RT = CAST(ROUND(RT + .5, 2) AS INT) FROM #TREASURE_STAT WHERE MAP_ID = @MAP_ID ) B ON A.MAP_NO = B.MAP_ID ) C INNER JOIN UVW_TREASURE_RT D ON C.C_RT BETWEEN D.S_GAGE AND D.E_GAGE ) E CROSS JOIN ( SELECT * FROM TA_TREASURE_HOLE WHERE USE_YN = 'Y' AND SCORE = @SCORE) F SET NOCOUNT OFF END

There you go cody, a workaround. Does work for me though.

Re: Treasure point help

héhé that was a nice way to do it thanks mate, nice!

Re: Treasure point help

thanks, I get it to work perfectly, no errors =)