Re: [Guide]Server setup guide!
Whoo, another problem, heh. Someone earlier on this page (11) had the same problem but no one has given an answer >.< Okay, I have everything running smooth...until I try to create my account with KOAM.
It comes up with this error after I connect, enter an ID and PWD and click 'Add': Access violation at address 1F453E7E in module "msado15.dll". Write of address 00C69014
Also, is there a way I can just manually add this? I already have an admin character created, but no account for him =/
EDIT:
After hours of searching .__. I created it manually. Geeze, things are difficult to find here. We need more awesome guides like this one. Maybe I should work on one ^^
Re: [Guide]Server setup guide!
How can i create an account? Because Admin Panel.exe gives me an error.
EDIT: Btw Kiona,how did you create your account manually? I can't find Accounts Table or something similar.
Re: [Guide]Server setup guide!
I used the Query Analyzer and put in this:
SET IDENTITY_INSERT Login On
INSERT INTO Login
(UID, ID, PWD, Birth, Type, ExpTime)
VALUES ('2', 'admin', 0x(converted pw...without brackets), 'yyyy-mm-dd', '0', '4000')
SET IDENTITY_INSERT Login Off
then right click -> excute
Example of converted password (before conversion: test123): 0x791FFE793A4A91
So it would be:
SET IDENTITY_INSERT Login On
INSERT INTO Login
(UID, ID, PWD, Birth, Type, ExpTime)
VALUES ('2', 'admin', 0x791FFE793A4A91, '2007-04-06', '0', '4000')
SET IDENTITY_INSERT Login Off
I just used the conversion table in an acc_reg.php to figure out how to convert my password :P
and for 'yyyy-mm-dd', just put in the current date =P
'admin' can be changed to whatever username you want
This information is actually stored in the kal_auth -> Tables -> Login
If you manually make a character without an account, I think you just have to make sure that the UID on them are the same. So if the char's UID is 1, the account's UID should also be 1. I'm not exactly sure on this though, I'm a newb :P
Re: [Guide]Server setup guide!
Quote:
Originally Posted by
Skray
I have a problem making the server: I don't understand this part
~Now copy and paste the address of the file "C:\Documents and Settings\Jared\Desktop\Kal.Server.Working.2006.09. 01\KALdb" that would be mine
~Still in options under "Move to physical file name" put that address so for me I would have "C:\Documents and Settings\Jared\Desktop\Kal.Server.Working.2006.09. 01\KALdb\KAL_AUTH.mdf"
Do the same thing for the log file as well.
I understand i need copy the file adress, but where i paste it?
Please, answer fast, Ty
Skray, you just go to the tab "Options" and then click under "Move to physical file name" beside the kal_auth_Data and kal_auth_Log and paste the address there.
So, using the example given, it would look something like this:
kal_auth_Data | C:\Documents and Settings\Jared\Desktop\Kal.Server.Working.2006.09. 01\KALdb\KAL_AUTH.mdf
kal_auth_Log | C:\Documents and Settings\Jared\Desktop\Kal.Server.Working.2006.09. 01\KALdb\KAL_AUTH.ldf
(note: the only difference between the _Data and _Log is the .mdf and .ldf Sometimes when people paste the address into the box, they erase the \kal_auth.mdf and .ldf and forget which extensions to use :P)
Re: [Guide]Server setup guide!
Quote:
Originally Posted by
LsE
~Now copy and paste the address of the file "C:\Documents and Settings\Jared\Desktop\Kal.Server.Working.2006.09. 01\KALdb" that would be mine
~Still in options under "Move to physical file name" put that address so for me I would have "C:\Documents and Settings\Jared\Desktop\Kal.Server.Working.2006.09. 01\KALdb\KAL_AUTH.mdf"
Do the same thing for the log file as well.
I dont really understand what to do here^^
And what to do here:
now go back to your enterprise manager and select the kal_db and got the tables and then item right click on it and select design table make sure it looks like this
with the allow null and int as Info
Please explain more noob friendly :)
I basically just explained the first party to Skray :) See my last post on this topic ^^
For the second thing, it's basically just make your table look like the picture :P You only need to change the 'int' column and the 'allow null' column, the middle one will adjust the values automatically :)
Re: [Guide]Server setup guide!
Where can i find the Database Server Username..??
(I can Login to Login Server with my Username but not in Database server)
Re: [Guide]Server setup guide!
Oh... i need put idm and idf, ok i tried and it runs good :) , i ask you more questions later ^^ thanks at all.
I have a new question:
''Now you should be done with all that and onto the ODBC
Go into start -- control panel -- administrative tools -- Data Sources (ODBC)''
Where is it? someone can do a photo or pass it to paint? i don't find this command/ folder.
Help me please, Thanks.
Re: [Guide]Server setup guide!
OK i got the Problem Above Fixed but know when i started all the servers i got a new error at KalXtreme Server: CANT GET ITEM ID what to do?
Re: [Guide]Server setup guide!
Quote:
Originally Posted by
Skray
Oh... i need put idm and idf, ok i tried and it runs good :) , i ask you more questions later ^^ thanks at all.
I have a new question:
''Now you should be done with all that and onto the ODBC
Go into start -- control panel -- administrative tools -- Data Sources (ODBC)''
Where is it? someone can do a photo or pass it to paint? i don't find this command/ folder.
Help me please, Thanks.
Click Start > Settings > Control Panel
It'll bring up a folder, now look for Administrative Tools (It'll probably be on the first row)
Double click that and look for the "Data Sources (ODBC)"
If you can't find your Control Panel, click Start > Run and type in 'control panel'
-----------------
Tommie, I'm not quite sure what's wrong....but are you sure you got your 'Item' table to look like the screenshot Dopestar posted? Also...if that doesn't fix it, I'm pretty sure someone posted a question like this earlier and it was answered.
Re: [Guide]Server setup guide!
[quote=Kiona;2130070]Click Start > Settings > Control Panel
It'll bring up a folder, now look for Administrative Tools (It'll probably be on the first row)
Double click that and look for the "Data Sources (ODBC)"
If you can't find your Control Panel, click Start > Run and type in 'control panel'
Explain me with and image please, i can't fins ''Start'' i don't understand what start is.
Thank you VM
Re: [Guide]Server setup guide!
Where can I find the auth file thats needed for the auth database?
Like in KalOnline?
:sweatdrop
Re: [Guide]Server setup guide!
Quote:
Originally Posted by
HopesCorrupted
Where can I find the auth file thats needed for the auth database?
Like in KalOnline?
:sweatdrop
... In the first post say: for private server is needed:
Kalonlineeng clean
Repack
Mssql
The auth file is inside the repack, in the database folder.
Please, can someone answer my question? Fast plz
Re: [Guide]Server setup guide!
Re: [Guide]Server setup guide!
Quote:
Originally Posted by
Skray
Explain me with and image please, i can't fins ''Start'' i don't understand what start is.
Thank you VM
At the bottom left of your screen there should be the "Start" button :)
http://i50.photobucket.com/albums/f3...art_button.jpg
