|
You last visited: Today at 20:34
Advertisement
Dekaron server
Discussion on Dekaron server within the Dekaron Private Server forum part of the Dekaron category.
05/16/2017, 11:03
|
#1
|
elite*gold: 0 
Join Date: Nov 2015
Posts: 4
Received Thanks: 0
|
Dekaron server
hi
im new here my name is jochem,and live in the netherlands.... what so ever i can do allot of things with the pc.
i've done a week research now on all kinds of websites but with out succes.
how ever i found i guide to get mij own server running Private server. but unfortunate i have not that great skills in sql. i followed all the steps but when in restore the data base its asking me to get a database from "account, billing, cash, character" some how i found my way arround that to get some plane files by back upping the files first and then restore them (all links are brroken on tutorials as far i searched for it) is it like you can make them yourself or is it like you have to have them in order to get it running
mean will i did all the steps like they told me firrst i got this error from the quary 2:
Code:
Use master;
Go
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'
but it solved itself when i restarted the whole thing no errors like ??????? idk what ever right so i keep going to till this happends
Code:
Server: Msg 213, Level 16, State 5, Line 10
Insert Error: Column name or number of supplied values does not match table definition.
after i put this in
Code:
Use account;
Go
---Account Query By Warmonger---
DECLARE [MENTION=2080215]userno[/MENTION] varchar(16), @AccountID varchar(16), [MENTION=413413]password[/MENTION] varchar(32), [MENTION=950314]email[/MENTION] varchar(50), [MENTION=4111616]Secreta[/MENTION] varchar(22), [MENTION=318386]Secret[/MENTION]Q varchar(22)
SET [MENTION=2080215]userno[/MENTION]= '09101410275532'
SET @AccountID = 'Account ID'
SET [MENTION=413413]password[/MENTION] = 'Account Password'
SET [MENTION=950314]email[/MENTION] = 'E-Mail'
SET [MENTION=4111616]Secreta[/MENTION] = 'Secret Answer'
SET [MENTION=318386]Secret[/MENTION]Q = 'Secret Question'
Insert Into [USER_PROFILE] Values [MENTION=2080215]userno[/MENTION],@AccountID [MENTION=413413]password[/MENTION],'801011000000','1','0','Y','01/01/2006 00:00:00',null,null,null,'000')
remember i did this all by meself without knowledge of it... so after that all i just tryed to start the server.. but like you guys can tell allready it wont start sessionserver.exe ... so with all my hopes i just tryed to log in in dekaron and with the sa account it just says "no internet connection"
im willing to pay real people to just help me out (dont give me stuff i just tryed my best to tell my whole story maybe some is willing to do the same where to look where i can learn more etz.)
or just add me on skype: speedfight2ce
thanks
with kind regards,
pro749
|
|
|
|
05/16/2017, 17:48
|
#2
|
elite*gold: 0
Join Date: Apr 2013
Posts: 6,303
Received Thanks: 1,583
|
Hello pro749,
the Dekaron section is not meant for private Server questions/discussions. For that we (elitepvpers) have the  section.
Have a nice day!
|
|
|
|
|
05/20/2017, 21:40
|
#3
|
♥ Yuuki Asuna ♥
elite*gold: 45
Join Date: Jun 2005
Posts: 54,950
Received Thanks: 8,585
|
Dekaron -> Dekaron Private S…
#moved
|
|
|
|
|
05/20/2017, 22:02
|
#4
|
elite*gold: 0
Join Date: Jan 2012
Posts: 165
Received Thanks: 40
|
Hey, Just last month someone make a good program with all things you need inside it, download it and read everything to understand what is it exactly, good luck your pserver 
and about your Master code you need two parts.
Quote:
First query :
Use master;
Go
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=;'
Second query :
Use master;
Go
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'
|
|
|
|
|
All times are GMT +1. The time now is 20:34.
|
|
