SRCMS 2.0A error lines [Help]

[rhysclark1]

Hi,

I have setup my silkroad private server website helped by SRCMS 2.0.

I have tested the automatic silk update however i seem to be encountering a problem.

The web purchase is successful and the IPN works correctly however the silk does not get applied to the usernames account.

i check for IPN_Error and got this:

[19-Aug-2017 17:35:41 UTC] PHP Warning: mssql_query() [<a href='function.mssql-query'>function.mssql-query</a>]: message: Incorrect syntax near ','. (severity 15) in C:\Program Files (x86)\Zend\Apache2\htdocs\module\ipn.php on line 119
[19-Aug-2017 17:35:41 UTC] PHP Warning: mssql_query() [<a href='function.mssql-query'>function.mssql-query</a>]: Query failed in C:\Program Files (x86)\Zend\Apache2\htdocs\module\ipn.php on line 119


I checked the config lines and want to ensure these are correct?
118
$silkAmount = $usdToSilks[(int)$mc_gross];
119
mssql_query("exec CGI.CGI_WebPurchaseSilk0,'$username',0,$silkAmount ,0"); // will execute automated in game update of silks.

helped sorting this would be nice, thanks

[ZαKuRα]

add zakurapk2 skype

[B1Q]

mssql_query("exec CGI.CGI_WebPurchaseSilk0,'$username',0,$silkAmount ,0"); // will execute automated in game update of silks.

you have an extra comma after the procedure name

[rhysclark1]

would you happen to know which one?

[B1Q]

i already told you... it's after the procedure name

exec CGI.CGI_WebPurchaseSilk0, '$username',0,$silkAmount ,0

[rhysclark1]

cheers man

[B1Q]

cheers