Quote:
Originally Posted by Strange2010
can anyone help me write the missing stored procedure (smp_insert_cash_card_use_info) ?
i opened captain herlock using a hex program and i found some clues but when i try adding it i get this error
(Procedure or function smp_insert_cash_card_use_info has too many arguments specified.)
any one know what this means ?
|
Yes the server tries to execute the SMP with too many Arguments.
A little example:
@IN_PARAMs are your parameter which habe to be committed.
Code:
PROCEDURE [dbo].[smp_this_is_a_stored_procedure]
@IN_PARAM1 INT,
@IN_PARAM2 INT,
@IN_PARAM3 INT
...
If you want to execute this smp you have to deliver all of the parameters otherwise the smp will print an error.
you have to do it like this:
Code:
exec smp_this_is_a_stored_procedure 1,2,3
But in your case the gameserver delivers too much parameters or too less.
like this:
Code:
exec smp_this_is_a_stored_procedure 1,2,3,4
or
Code:
exec smp_this_is_a_stored_procedure 1,2
This will cause an error too.
You can download SQL Profiler and use it to monitor all of the smps executed by the gameserver. You will find the SMP errors pretty fast if you use this tool to debug.
![[Release] Rappelz Epic 7.4 Server Files + Databases](https://www.elitepvpers.com/forum/iconimages/rappelz-private-server/release-rappelz-epic-7-4-server-files-databases_ltr.gif){kind=small}
