Sharing experience of confirming cShop debugging

[haha1]

Debugging steps
iis>>ASP>>"Transfer errors to browser" is set to "true"
CBA\cShop\item_checkpt.asp << edit

'PostID = "caonimabi"
'PostKEY = "53dc3b60f2d40cd4"
'PostWORLD = 1

Remove comment. Only have something to test.

PostID = "caonimabi"
PostKEY = "53dc3b60f2d40cd4"
PostWORLD = 1

Modify the IP set for you.
http://192.168.1.25:8808/cShop/item_checkpt.asp
Will tell you where the setting is wrong.
example:

'################MsSQL數據庫連接設置################

MsSqlIp = "USER1-PC\SQLEXPRESS" '數據庫連接地址如果有端口可使用IP,端口
MsSqlData = "gmg_account" '遊戲帳號數據庫名稱
MsSqlUserName = "tricksterSQL" '數據庫用戶名 << Intentionally wrong.
MsSqlPassWord = "123456" '數據庫密碼

'####################設置網站信息####################

Microsoft OLE DB Provider for ODBC Drivers 錯誤 '80040e4d'
[Microsoft][ODBC SQL Server Driver][SQL Server]使用者 'tricksterSQL' 的登入失敗。
/inc/conn.asp, 行10

 

[Timer]

I tried doing this myself and got fail102. Then I replaced caonimabi's info with some of my info from tbl_account and got this:

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]The data type of substitution parameter 4 does not match the expected type of the format specification.
/cShop/item_checkpt.asp, line 50

This is line 50:

rsConn.open rsSQL,Conn,3,2

Idk if it helps but it's something. I know fail102 means something along the lines of an invalid password.

 

[haha1]

rsConn.open rsSQL,Conn,3,2

You can see the code inside, there is a lot of information.

Keyword "Invalid game state"

 

[Timer]

You can see the code inside, there is a lot of information.

Keyword "Invalid game state"

Interesting. I looked into the procedure and found a commented out section related to login IPs.

  /*-- 중국은 IP체크를 하지 않는다.
  if  @[I][B][URL="http://forum.ragezone.com/members/116066.html"]ERROR[/URL][/B][/I] = 0 and @acc_game_latest_ip <> @[I][B][URL="http://forum.ragezone.com/members/1333401102.html"]LogiN[/URL][/B][/I]_ip) 
  begin
   set @[I][B][URL="http://forum.ragezone.com/members/116066.html"]ERROR[/URL][/B][/I] = 104
   set @[I][B][URL="http://forum.ragezone.com/members/116066.html"]ERROR[/URL][/B][/I]_msg = 'Login IP is not equal !!!'
  end
  */

It ended up showing this:



It shows my point value successfully, at least. Unfortunately, I still get cashfail.

 

[haha1]

It shows my point value successfully, at least. Unfortunately, I still get cashfail.

Bold guess that your IIS settings are wrong. I deliberately got it wrong like this. Know where the error will cause cashfail.

1.IIS

2.IIS

3.Game exe

My English is very weak. Almost all use Chinese to translate English. Then a little modification. I don’t know if the meaning can be clearly expressed ? :