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
Printable View
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
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?
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 :)
Ah, right bubbastic, thanks.
I'm still trying to figure out why I'm not getting Treasure Point progression...
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.
I will experiment with it a little when I get home and let you know what I find out. :)
Still nothing at all :$: ive tried over 100 values today the bar hasn't moved at all
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.
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.
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) })
I thought this was already released :/
When I have some time, I'll post the infos so you can fill the tables correctly.
Thank you Mr. Awesome bubbastic :) Without you and fasa2008 and some other special guys this is simply not possible :)
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:
You are the hero. You saved my day again. :D
thanks bublastic
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
even the tables full I still got the following error :
I see in the db that it needs only 4 :Code:Procedure or function USP_TREASURE_POINT has too many arguments specified.)
CurrQuery({ call dbo.USP_TREASURE_POINT (9, 0, 0, 1, 0) })
Example :Code:[dbo].[USP_TREASURE_POINT] (
@MAP_ID INT --맵아이디
, @SCORE INT --게임 SCORE
, @EQUIP_DROP NUMERIC(5, 2) --드랍율
, @INTVAL INT = 1 -- DEFAULT (1 HOUR)
)
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?Code:** EXEC DBO.USP_TREASURE_POINT 3, -2, 2.1, 1
Spoiler:
There you go cody, a workaround. Does work for me though.
héhé that was a nice way to do it thanks mate, nice!
thanks, I get it to work perfectly, no errors =)