[RELEASE] WORKING Fixed Serverfiles+English gameclient!

I cant open quiery analyzer too...:mad:

Quote:

Originally Posted by 4bidn1 also srry 4 the newbie questions but im kinda confused on wat 2 change to make argate rate 100% i dont c ne thing on the 5th column but crazy signs nvm i found it :P edit : hmm 4 some reason i cant open my query analyzer its says server access denied or dosnt exist ne ideas?

I have problem with modifying rates in data.pak i want to give 10 stats per level,so i relplaced byStatPointPerLevel ,5 with byStatPointPerLevel ,10.Its more digit,so winhex need to add 1 more byte,but if i do this client crashes.Someone know how to fix it,or its other way here how to do it?For example some china,taiwan or usa folder?
Yeah its give me 10 points if i edit on server side only,but in game it give 5 atm and rest of points after i relog,so its not very good...

Well i found a way how to do it..... open data.pak with darkinc unpacker,than delete data.pak
and in extracted folders you can edit it easily. :)

Anyone can post his SQL 2000 Settings?

Still getting this access denied error while startingh the server even with sp4 :(

but i can access with query analyser at least on localhost (on my vm)

i can open query on local now but wen i get to the part of clicking dbmon debug monitor it says not associated with a trusted sql connection zzzz ive been trying 2 fix this 4 hours it 5 am now o_O im to sleepy to finish does ne 1 have ne idea y it says that ??

Quote:

Originally Posted by silkbotter YOU should just shut up and be thankful for this thread :/ i uploaded it on rapidshare.com, don't be so lame. download one part, restart your modem/router and download the next one :/ why don't YOU (community) give me a little help and upload the stuff on another server? why do i have to do all the work?? o0 gees. this sux.. i see about 200 fucking downloads of my files... and what did i get? nothing else than flaming,begging etc.. i think it's time for you to do something for the stuff you want! nobody helped me. don't be lame. learn stuff about this whole server issue and get busy!!!

lol just said u should? don't be emo

Hello guys I have a little problem:

I made all steps..and now wanted to test it...
First I started dbmon.exe...all good... than I started CastServer[1.26.0].exe.
My cmd tell me :
Cast server started
SP_GUILD_SERVERID_SET SUCCESS
ok all good..and now...the LoginServer.exe...cmd tell me:

Japan GameChu login module loading fail...
<----------Login Server Started--------->

now MsgServer[1.3.0].exe...cmd tell me:
MsgServer Started...I think its okay..
now SessionServer[1.22.0].exe...cmd tell me:
Session Server Ready
Provider::Execute (CChar*szName)
szname: SP_LOGIN_FLAG_SET
Microsoft Ole DB PROVIDER for SQL Server:Der Server 'LSV_DKRACNT'konnte in sys servers nicht gefunden werden. Führen sie sp_addlinkedserver aus, um den Server zu sysservers hinzuzufügen. (its german) now in english... the Server 'LSV_DKRACNT' cant find in sys servers. do the command sp_addlinkedserver to add this to the sysservers.

>>CRITICAL ERROR:SP_LOGIN_FLAG_SET PROC CALL FAIL
File:.\Config\Provider.cpp, line:79


and I got a critical windows error....so what the hell is wrong Oo...I done all the things from the chinese video and got that error...

pls help me..

Quote:

Originally Posted by Genre69 lol just said u should? don't be emo

don't be lazy and noobish ;)

Quote:

Originally Posted by socressor Hello guys I have a little problem: I made all steps..and now wanted to test it... First I started dbmon.exe...all good... than I started CastServer[1.26.0].exe. My cmd tell me : Cast server started SP_GUILD_SERVERID_SET SUCCESS ok all good..and now...the LoginServer.exe...cmd tell me: Japan GameChu login module loading fail... <----------Login Server Started---------> now MsgServer[1.3.0].exe...cmd tell me: MsgServer Started...I think its okay.. now SessionServer[1.22.0].exe...cmd tell me: Session Server Ready Provider::Execute (CChar*szName) szname: SP_LOGIN_FLAG_SET Microsoft Ole DB PROVIDER for SQL Server:Der Server 'LSV_DKRACNT'konnte in sys servers nicht gefunden werden. Führen sie sp_addlinkedserver aus, um den Server zu sysservers hinzuzufügen. (its german) now in english... the Server 'LSV_DKRACNT' cant find in sys servers. do the command sp_addlinkedserver to add this to the sysservers. >>CRITICAL ERROR:SP_LOGIN_FLAG_SET PROC CALL FAIL File:.\Config\Provider.cpp, line:79 and I got a critical windows error....so what the hell is wrong Oo...I done all the things from the chinese video and got that error... pls help me..

you forgot to open you "sql query manager" and type this commands:
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={SQ L Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'LSV_DKRNUNVICE','','MSDASQL',NULL,NULL,'DRIVER={S QL 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={SQ L 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=;'

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'

and click on "execute" ;)

bah still stuck at this shit access denied since some hours. Doesnt matter what I switch in the options. Where can i see that SP4 is successfully installed?

Quote:

3048: CastServer Started 3188: Japan GameChu Login module loading Fail... 3188: <------------- Login Server Started ------------> 3088: Session Server Ready 3188: ------------------ Connect Session Server IP : [ 192.168.126.128 ] ------- ----------- 3048: Provider::initialize() Microsoft OLE DB Provider for SQL Server: [DBNETLIB][ConnectionOpen (Connect()). ]SQL Server does not exist or access denied. 3048: [CRITICAL ERROR] SP_GUILD_SERVER_ID_SET SUCCESS 3088: Provider::initialize() Microsoft OLE DB Provider for SQL Server: [DBNETLIB][ConnectionOpen (Connect()). ]SQL Server does not exist or access denied. 3088: >> CRITICAL ERROR : SP_LOGIN_FLAG_SET PROC CALL FAIL 3088: File: .\Config\Provider.cpp, Line: 79

i hope you installed sql 2000 first :D
well. in the "about" window.
there should be something like "sql-server 2000 sp4" ^^

Quote:

Originally Posted by silkbotter i hope you installed sql 2000 first :D well. in the "about" window. there should be something like "sql-server 2000 sp4" ^^

hehe yeah i did from your posted source. And after that i installed this : SQL2000.AS-KB884525-SP4-x86-ENU.exe !

In which application do u have that about window? In the entprice manager is only for that application and not for the server. I cant find it :(

Edit: WTF this seems only for analysis services ... rofl isnt the sp4 free ? o.O

Edit2: WTF² :D link is on the same page a bit below ^^ why they put it under that as file o.O

Quote:

Originally Posted by silkbotter don't be lazy and noobish ;) you forgot to open you "sql query manager" and type this commands: 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={SQ L Server};SERVER=localhost;UID=;PWD=;' EXEC sp_addlinkedserver 'LSV_DKRNUNVICE','','MSDASQL',NULL,NULL,'DRIVER={S QL 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={SQ L 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=;' 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' and click on "execute" ;)

thank you :) I done it. Now the server runs...next time I wanne run it as a webserver :). Because German guys need an own server :P.

the service pack is free... the sql server 2000 not xD

look@ your installed software ^^

i'm installing right now ;) just didnt noticed the name.

<--- noob :D

Edit: Omg next error :( :( :(

anyone saw this before?

Quote:

2324: CastServer Started 2480: Japan GameChu Login module loading Fail... 2324: SP_GUILD_SERVERID_SET SUCCESS 2480: <------------- Login Server Started ------------> 2608: MsgServer Started 2700: Session Server Ready 2480: ------------------ Connect Session Server IP : [ 192.168.126.128 ] ------- ----------- 2700: Provider::Execute( CCHAR * szName ) szName: SP_LOGIN_FLAG_SET Microsoft OLE DB Provider for SQL Server: [OLE/DB provider returned message: [Mi crosoft][ODBC SQL Server Driver][SQL Server]I/O error (bad page ID) detected dur ing read at offset 0x0000000011c0>> CRITICAL ERROR : SP_LOGIN_FLAG_SET PROC CALL FAIL 2700: File: .\Config\Provider.cpp, Line: 79

Do i need to update SP4 before adding the tables or what?

Edit2: Seems like the problem was sa account for testing before with my other one it works fine ;)

nice, cant wait till the video comes lol

Hello guys ,

I got a new Problem....I managed all server things...now wanted to connect...ran the p-server connector.exe...took my server and started...till the loading screen got 65,9% all was good...than at 65,9% it trows me out of the game ...back to the p-server connector.exe... any idea??

:confused: