[Help Thread] Please post your questions here.

Page 298 of 590

298

04/14/2015 16:24 Questiontest#4456

What is the easiest way to remove gameguard from sframe?

04/14/2015 18:04 ThunderNikk#4457

You could try this in your .bat launcher from the 9.1 file release and maybe you don't have to remove game guard from the sframe...

/use_nprotect:0

04/14/2015 19:13 Saltaya#4458

Quote:

Originally Posted by bertie2008

I also noticed another error in Auth, not sure if it is related to this problem or not, it has always appeared but I have been able to play and use all the facilities, hv etc

ERROR ODBC: SQLExecute: error:
ERROR ODBC: 42S02:1:208:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'account'.
ERROR ODBC: 42000:2:8180:[Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s) could not be prepared.
Debug DbQueryBinding1: DB query failed: UPDATE account SET last_login_server_idx = ? WHERE account_id = ?;

If I change the Auth table from accounts to account I cannot log into the server

Help please :handsdown:

I guess you use glandu's great Auth Emu.

Simply DONT change the Database Name, edit the Auth.opt of glandu's auth Emu.

There is something like

Code:

sql.db_account.query:SELECT * FROM Accounts WITH(NOLOCK) WHERE login_name = ? AND password = ?;

Edit this line properly

Edit: Sorry i didn't read right. Forget the above

04/14/2015 19:38 TheOnlyOneRaskim#4459

Hi Guy's,

incredible that im asking E*pvp but im Stuck and maybe someone got the Fix for me.

Well im currently writing an application, wich gives me all user related infos.

But for some Reason i have an minor bug (maybe application itself but cant find any error code). Im using an SQL Query to get the inventory/Warehouse etc pp.

Now when it loads the Main Weapon and the Offhand, it loads my pet's armory (if equipped)

Example below:

Without Creature has Equip :
[Only registered and activated users can see links. Click Here To Register...]

If my Creature has Equip:
[Only registered and activated users can see links. Click Here To Register...]

If someone has the Right gcode for character equip, i would like to know it.

Thanks in Advance ^^

04/14/2015 19:38 glandu2#4460

Quote:

Originally Posted by bertie2008

I have noticed that when I get a char to mc and log out the next time I log in I get this error appearing in herlock:

DB COM ERROR (Thread:2, HRESULT:80040E57, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) DB_GetCommercialStorageInfo(dbo.smp_check_purchase d_item):
Arithmetic overflow error converting expression to data type int.

Skills disappear from bar and hv pass is no longer valid on all chars on that account, if I delete the mc char everything works perfectly again.

I also noticed another error in Auth, not sure if it is related to this problem or not, it has always appeared but I have been able to play and use all the facilities, hv etc

ERROR ODBC: SQLExecute: error:
ERROR ODBC: 42S02:1:208:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'account'.
ERROR ODBC: 42000:2:8180:[Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s) could not be prepared.
Debug DbQueryBinding1: DB query failed: UPDATE account SET last_login_server_idx = ? WHERE account_id = ?;

If I change the Auth table from accounts to account I cannot log into the server

Help please :handsdown:

About the auth:
if your table is named "accounts" and you have the column "last_login_server_idx" in it, this use this config in your opt :

Code:

sql.db_updatelastserveridx.query:UPDATE accounts SET last_login_server_idx = ? WHERE account_id = ?;

else put that:

Code:

sql.db_updatelastserveridx.enable:false

This query is used so the client can pre-select the last gameserver the player used and it only have to press enter to use the same gameserver.

04/14/2015 20:10 bertie2008#4461

I have noticed that when I get a char to mc and log out the next time I log in I get this error appearing in herlock:

DB COM ERROR (Thread:2, HRESULT:80040E57, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) DB_GetCommercialStorageInfo(dbo.smp_check_purchase d_item):
Arithmetic overflow error converting expression to data type int.

Skills disappear from bar and hv pass is no longer valid on all chars on that account, if I delete the mc char everything works perfectly again

Forgot to mention I am using the 9.1 server files with ismoke's Auth, telecaster and premium fix and US client

When I log into the game I get a message: Cannot connect to server. Please try again later (1)

Help please :handsdown:

04/14/2015 20:13 glandu2#4462

Quote:

Originally Posted by TheOnlyOneRaskim

Hi Guy's,

incredible that im asking E*pvp but im Stuck and maybe someone got the Fix for me.

Well im currently writing an application, wich gives me all user related infos.

But for some Reason i have an minor bug (maybe application itself but cant find any error code). Im using an SQL Query to get the inventory/Warehouse etc pp.

Now when it loads the Main Weapon and the Offhand, it loads my pet's armory (if equipped)
[...]

The SQL query return several rows, one for your player and one for it's pet maybe ? (and the pet appear to be the first row)
I don't know well telecaster, but what about adding a condition sommon_id = 0 ?

04/14/2015 20:24 TheOnlyOneRaskim#4463

Quote:

Originally Posted by glandu2

The SQL query return several rows, one for your player and one for it's pet maybe ? (and the pet appear to be the first row)
I don't know well telecaster, but what about adding a condition sommon_id = 0 ?

Got it now.

The Telecaster stores different Informations with the gcode column.

If anybody else ran into this:

Spoiler

For example you want to get the mainhand

Code:

use telecaster
select * from item where wear_type = 0 and gcode = 3
go

04/14/2015 21:17 mohamad512#4464

Quote:

Originally Posted by mohamad512

hey guys , i have an Accounts Manager .php script ..

i don't now how to configuring it ...

there is Database name " Login Data" , i don't now where it must be @@ in sql or some php admin.

and is a connection in the script's for the data i think "Login Data"

1- $DB_connect_this ->connect("127.0.0.1","root","adskasu1564-","shop");

i think it some php data connection cos the (root)

I hop if any one now something about " how to configuring the Loging Data " tell me@@

regards

04/15/2015 05:42 werrior#4465

Any1 know how to level-up Pet ?

I tried to change multiplier exp via S game.exp_rate:10 (CaptainHerlockServer.exe) but only My character that level-up fast while Pet didn't affected

*edit
found it, nvm

04/17/2015 14:47 Domesday Brock#4466

Quote:

Originally Posted by bertie2008

I have noticed that when I get a char to mc and log out the next time I log in I get this error appearing in herlock:

DB COM ERROR (Thread:2, HRESULT:80040E57, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) DB_GetCommercialStorageInfo(dbo.smp_check_purchase d_item):
Arithmetic overflow error converting expression to data type int.

Skills disappear from bar and hv pass is no longer valid on all chars on that account, if I delete the mc char everything works perfectly again

Forgot to mention I am using the 9.1 server files with ismoke's Auth, telecaster and premium fix and US client

When I log into the game I get a message: Cannot connect to server. Please try again later (1)

Help please :handsdown:

Having exactly the same problem, hope someone helps, the one guy that I know would sort this out in no time is bogged down updating his own server at the moment

04/17/2015 15:00 ismokedrow#4467

If you all would provide an SQL Trace from SQL Profiler when this issue happens, it would be a LOT easier to figure out what parameters are causing the bad conversion.

04/17/2015 17:39 mohamad512#4468

hey ...

I'm trying to run cash shop on my PC ..

*i'm using IIS8

but this error came out : Call to undefined function mssql_connect()

04/17/2015 18:17 Lawcry#4469

Hi guys,

i just tried to setup 9.1 server on my laptop following [Only registered and activated users can see links. Click Here To Register...] guide (thanks for this).

My problem is, that when i try to launch GameServer it crashes without error.

GameLog.txt is empty.

My System

Spoiler

gameserver.opt

Spoiler