Private Server [HELP]

Page 2 of 3

08/03/2009 07:11 ursan99#16

idk but maybe u need to add the ports in ur firewall...

08/03/2009 15:24 Bear Walken#17

You must run these scripts on SQL Query Analyzer

Run this first

Code:

USE master
EXEC sp_addlinkedserver 'LSV_GHBILL','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'LSV_DKRACNT','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'DKRCASH','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'LSV_DKRHELION','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'LSV_DKRNUNVICE','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'LSV_DKRQUNE','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'LSV_DKRRONDOW','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'LSV_DKRSIZ','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'LSV_DKRTEST','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'LSV_DKRZUTO','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'LSV_DKRSTA','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'DKRACCOUNT01','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'

then this...

Code:

USE master
exec sp_serveroption 'LSV_GHBILL','rpc out','true' 
exec sp_serveroption 'LSV_GHBILL','rpc','true' 
exec sp_serveroption 'LSV_DKRACNT','rpc out','true' 
exec sp_serveroption 'LSV_DKRACNT','rpc','true' 
exec sp_serveroption 'DKRCASH','rpc out','true' 
exec sp_serveroption 'DKRCASH','rpc','true' 
exec sp_serveroption 'LSV_DKRHELION','rpc out','true' 
exec sp_serveroption 'LSV_DKRHELION','rpc','true' 
exec sp_serveroption 'LSV_DKRNUNVICE','rpc out','true' 
exec sp_serveroption 'LSV_DKRNUNVICE','rpc','true' 
exec sp_serveroption 'LSV_DKRQUNE','rpc out','true' 
exec sp_serveroption 'LSV_DKRQUNE','rpc','true' 
exec sp_serveroption 'LSV_DKRRONDOW','rpc out','true' 
exec sp_serveroption 'LSV_DKRRONDOW','rpc','true' 
exec sp_serveroption 'LSV_DKRSIZ','rpc out','true' 
exec sp_serveroption 'LSV_DKRSIZ','rpc','true' 
exec sp_serveroption 'LSV_DKRTEST','rpc out','true' 
exec sp_serveroption 'LSV_DKRTEST','rpc','true' 
exec sp_serveroption 'LSV_DKRZUTO','rpc out','true' 
exec sp_serveroption 'LSV_DKRZUTO','rpc','true' 
exec sp_serveroption 'LSV_DKRSTA','rpc out','true' 
exec sp_serveroption 'LSV_DKRSTA','rpc','true' 
exec sp_serveroption 'DKRACCOUNT01','rpc out','true' 
exec sp_serveroption 'DKRACCOUNT01','rpc','true'

Maybe this is your problem. Another thing try to install netframework... sry my poor english.

09/04/2009 21:25 EliteWarrior#18

Quote:

CAST_PORT = 7882
DATABASE_ADDRESS = 5.58.189.91
DATABASE_DATABASE = CHARACTER
DATABASE_ACCOUNT = sa
DATABASE_PASSWORD = 1234
CAST_SERVER_ID = 1101
LOG_PATH = ..\LogFiles\

I got a question the ''sa'' account do i have to create it with sql manager or is it a default one? Becuase authenication mode during setup i used windows authenication.

If so the password can just be random?

Because i dont think sa can just be put in the config.ini while it dont exists with pw in database .

So what do i need to do to make it work? This is the only problem atm where im stuck.

Trust me ive searched alot of topics.

Error message i get:

[Only registered and activated users can see links. Click Here To Register...]

this is how my config looks like :

[Only registered and activated users can see links. Click Here To Register...]

09/04/2009 23:56 ~Kakkarot~#19

Quote:

Originally Posted by EliteWarrior

I got a question the ''sa'' account do i have to create it with sql manager or is it a default one? Becuase authenication mode during setup i used windows authenication.

If so the password can just be random?

Because i dont think sa can just be put in the config.ini while it dont exists with pw in database .

So what do i need to do to make it work? This is the only problem atm where im stuck.

Trust me ive searched alot of topics.

Error message i get:

[Only registered and activated users can see links. Click Here To Register...]

this is how my config looks like :

[Only registered and activated users can see links. Click Here To Register...]

no the password cant be "just random" you ahve to put in the password that u used while installing SQL, if you put windows atuhentication then i think you will have to install it again

09/05/2009 00:26 EliteWarrior#20

nvm got it work for some reason i used SA and a password that used while install sp4. If i edit anything withing the server files while server is up do i have to close client or close client and server so the edited files like exp ratio/dil is active?

09/05/2009 07:56 caper#21

Any updates to server files or server share requires a restart. You must also update client if you update server share folder.

09/05/2009 10:56 abelwang#22

i NEED A WEB SERVER FILE. any1 have it? i couldnt find it.

09/05/2009 11:38 Pyrofol#23

It is not needed anymore

09/05/2009 16:21 EliteWarrior#24

Quote:

Originally Posted by caper

Any updates to server files or server share requires a restart. You must also update client if you update server share folder.

Ok thanks so i have to shutdown server if i edit replace files in share.

Ive managed to get 100% succesr rate for argating and socketing and dil for it to pay 100dil :P

Right now ive got a major problem,when i do the command /gm callmonsters 330

or w/e the client crashes immediately. Ever since i downloaded some ones edited monster.csv and itemset.csv because you could then spawn GM Rings.

AND yes i have replaced in both server side and client side folders. Any one knows what the problem is?

I also have replaced them with the old ones,still no succes.

09/05/2009 19:38 twiggy345#25

Quote:

Originally Posted by EliteWarrior

Ok thanks so i have to shutdown server if i edit replace files in share.

Ive managed to get 100% succesr rate for argating and socketing and dil for it to pay 100dil :P

Right now ive got a major problem,when i do the command /gm callmonsters 330

or w/e the client crashes immediately. Ever since i downloaded some ones edited monster.csv and itemset.csv because you could then spawn GM Rings.

AND yes i have replaced in both server side and client side folders. Any one knows what the problem is?

I also have replaced them with the old ones,still no succes.

Is it any monster or just that one?
if its just that one then you are missing files. the textures etc. but if its with other monsters as well then you have a bad monster.csv file

Just download A6 from silkbotter and start over on the editing files. that should fix it

09/05/2009 19:42 EliteWarrior#26

It is with all Monster ID's ever since i downloaded that edited monster.csv and itemset.csv . I have tried replacing with the A6 from silkbotter nothing worked.

What im doing now is extract again the A6 client and replace ALL files. Same for server . I let you know what i got.

09/07/2009 05:39 janvier123#27

does anything show up in you dbmon ?

09/07/2009 19:51 EliteWarrior#28

ehm no not really ,what i have done is reinstalled client and server. Now its working again.

But damn that edited monster.csv and itemset.csv are bugged for some reason the one that has posted them.

Do you know what values to edit ? For the gm rings? Without having again client crash.

09/07/2009 20:12 janvier123#29

try to check the logs folder in your server folder
see if anything pops up in there

02/01/2010 16:49 CROvic#30

download this
[Only registered and activated users can see links. Click Here To Register...]
[Only registered and activated users can see links. Click Here To Register...]

Page 2 of 3