[SHARED]Server files/Guides/Gm tools

[hendrigo]

Hi Where i need trade ips???
can i use the Hamachi???
and where i need add ips?

 

[xz3r0x]

actually im not the one experiencing the problem my players are. they cant connect their always stuck at the channel part but when i play here and use lan ip it connects me really quick. so i guess i messed up on the config.

and about ran hmmm....???

actually it because, your clients cant connect to port of your worlds server, after few retry of connecting to your server from public, see the WorldSrv_24_01 log and u will notice, that it isn't writing about the public client ip connecting. So that means the router/firewall/or sotmething u use, is dropping the connect request on your world server. So forword ports from all your world servers, by default u have 1 world server and its port is 38111 if i am not mistaking, just check the WorldSvr_24_01.ini (second line).

 

[`CcyClOnE`]

wow thnx men u solved my problem too heheheh.

 

[xz3r0x]

wow thnx men u solved my problem too heheheh.

glad to hear man I was frustrated yesterday with this until i put my centos ip in DMZ area (my centos server is on separate pc). So dmz solved my problem, so i though it should be something with ports

 

[`CcyClOnE`]

yeah i was thinking of ports too but wat? i forwarded like everything except port 38111 hahah i guess i have to think more heheh. thnx again

 

[Lazy]

@darkxl
hi, yesterday i did that cmd and it worked said succesfully when i clicked no at the error frame of sql analyzer,but when i clicked ACCOUNT to make and account whit that cmd exec dbo.registeraccount...... gave error, today i click no and try that cmd again(xp_md5.dll) gives me error(screenshot) same for account
>.<
i'm so stuck

 

[xz3r0x]

you have an error in your query syntax it chould be , (comma) not . (dot) between 'xp_md5' and 'F:\.....

mistyped d00de and also change F:\xp_md5.dll to yours actual location of xp_md5.dll

 

[Lazy]

yeh but what about that connection error of sql query where i need to click yes or no somthing is wrong i feel that lol

mvg lazy

ok
exec sp_addextendedproc 'xp_md5','F:\Cabal private Server Files\Date\xp_md5.dll'
works

but when i do acc
exec dbo.cabal_tool_registerAccount 'test','123456'
says:
Server: Msg 515, Level 16, State 2, Procedure cabal_tool_registerAccount, Line 10
Cannot insert the value NULL into column 'Password', table 'ACCOUNT.dbo.cabal_auth_table'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Server: Msg 515, Level 16, State 2, Procedure cabal_tool_registerAccount, Line 16
Cannot insert the value NULL into column 'UserNum', table 'ACCOUNT.dbo.cabal_charge_auth'; column does not allow nulls. INSERT fails.
The statement has been terminated.

(1 row(s) affected)

 

[CR15T1]

Pls can someone help me ?
I've seen the items cod list . But i don't know how to add them on a charecter. Where do i need to put that code so i can recive that item on mi charecter.

 

[CR15T1]

yeh but what about that connection error of sql query where i need to click yes or no somthing is wrong i feel that lol

mvg lazy

ok
exec sp_addextendedproc 'xp_md5','F:\Cabal private Server Files\Date\xp_md5.dll'
works

but when i do acc
exec dbo.cabal_tool_registerAccount 'test','123456'
says:
Server: Msg 515, Level 16, State 2, Procedure cabal_tool_registerAccount, Line 10
Cannot insert the value NULL into column 'Password', table 'ACCOUNT.dbo.cabal_auth_table'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Server: Msg 515, Level 16, State 2, Procedure cabal_tool_registerAccount, Line 16
Cannot insert the value NULL into column 'UserNum', table 'ACCOUNT.dbo.cabal_charge_auth'; column does not allow nulls. INSERT fails.
The statement has been terminated.

(1 row(s) affected)

it's because you didn't executed right this command
exec sp_addextendedproc 'xp_md5','F:\Cabal private Server Files\Date\xp_md5.dll'
Try again.

 

[xz3r0x]

Pls can someone help me ?
I've seen the items cod list . But i don't know how to add them on a charecter. Where do i need to put that code so i can recive that item on mi charecter.

use gm tool for cash db, look at first post by darkxl on this thread

 

[slayer369]

any1 here can help me fix this error? :scratch:

 

[CR15T1]

any1 here can help me fix this error? :scratch:

in SQL Manager--> Security-->Linked Server--->GAMESERVER--> put this DRIVER={SQL Server};SERVER=localhost;UID=;PWD=; you didn't put them right.
And in the GAMESERVER-->Server Option mark all of the options.
Still in GAMSEVER--->Security mark the third option.
After that i guarantee that it will work.

 

[slayer369]

in SQL Manager--> Security-->Linked Server--->GAMESERVER--> put this DRIVER={SQL Server};SERVER=localhost;UID=;PWD=; you didn't put them right.
And in the GAMESERVER-->Server Option mark all of the options.
Still in GAMSEVER--->Security mark the third option.
After that i guarantee that it will work.

Aready did everything right under Microsoft OLE DB Provider for ODBC Drivers
Still the same error occur
What happen here :scratch:

 

[CR15T1]

Aready did everything right under Microsoft OLE DB Provider for ODBC Drivers
Still the same error occur
What happen here :scratch:

try this DRIVER={SQL Server};SERVER=localhost;UID=sa;PWD=yourdbpassword;
and make sure you've done the settings at the Security and Server Option

 

[slayer369]

try this DRIVER={SQL Server};SERVER=localhost;UID=sa;PWD=yourdbpassword;
and make sure you've done the settings at the Security and Server Option

hey guess what it finaly works! thx dude :2gunsfiring_v1:

 

[Batas]

i still dont get it darkxl posted VMware and CentOS i dl them from first post i gues everyone did same, but when i following that tutorial on instaling centOS it cant detect image that i mouted, in ss u can see that i mouted it corectly but still getting same error msg ><

 

[x1Android1x]

I have the following questions
though I walk databases and servers also
as I correctly accounts for logging players?

Tools there is any change to the English language customers?

you should put a more detailed manual on the matter because the topics tend confused posts by others but the thread that help understand the problems

 

[CR15T1]

Has someone found more Item codes ?
i mean armor codes and Board codes weapons codes etc.
Help please.

 

[zword3131]

here u have my Link for that great Project

To view the content, you need to sign in or register

Its MSSQL 2000 Enterprise full


MfG Darky

can somebody reupload Microsoft SQL Server 2000?
the file seems to be corrupted....

cheers!