error when Attaching Database (PS_GameData_Data.MDF)

Page 2 of 2 1 2
12/11/2012 22:08 nephren#16
Code:
IF NOT EXISTS (SELECT UserUID FROM PS_UserData.dbo.Users_Master WHERE UserUID=1)
BEGIN
	INSERT INTO PS_UserData.dbo.Users_Master
	(UserUID, UserID, Pw, JoinDate, Admin, AdminLevel, UseQueue, Status, Leave, LeaveDate, UserType, UserIp, ModiIp, ModiDate, Enpassword, Point)
	VALUES (1,'CHOOSENAME', 'CHOOSEPW', GETDATE(), 1, 255,'',16,'', DATEADD(year, +10, GETDATE()),'A',NULL,NULL,NULL,NULL,0);
END
Run this Query and change "CHOOSENAME" and "CHOOSEPW" to your stuff.

Be careful: Do not change the ' '.
12/11/2012 22:12 Truth1010#17
If you see no data there, it's because the table is empty and waiting for you to add accounts in.. xD

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

It's a little old, but if you just look at the User_Master table it should work the same for you in making an account. Give that a go and see if you can make an account.

EDIT: Shoo Peripher, I was typing and your post popped up! :D
12/11/2012 22:37 eclipz13#18
Yeah iv'e made a few posts about this, but this one was created by me..

I figured if i posted in the other forums that i used to get this far i'd receive more help.. or at least more promptly responses lol

I opened up the DB as it says in that tut.. but it's different in MSSQL2012
It doesn't have the same option to simply open table in the DB
I hit "design" but it doesn't have the same options to simply create the accounts :(

Can you please add me on FB so we can chat more directly and i can post screen shots and such?

FB = mikeY O Pan
12/11/2012 22:42 Truth1010#19
Right click, then SELECT x rows to view
Right click, then EDIT x rows to edit/add stuff :)

Most of us here use 2012 as well, it's mostly the same as 2005, but small changes like that. Design will actually change the layout of the table, so ignore that for now.
12/11/2012 22:42 eclipz13#20
PS.. when i ran that it said
Msg 544, Level 16, State 1, Line 3
Cannot insert explicit value for identity column in table 'Users_Master' when IDENTITY_INSERT is set to OFF.

Oh awesome.. that worked "view/edit"
BUT when i did what you said it opened it properly.. it shows the gmlight and gmlight123 ..
but when i tried to log using those it wouldn't let me as well :/

Ok. SO the account is created. but it still says it can't be found

Iv'e tried to change the game.exe ip to 192.168.0.17 as well as GamePublicIP=192.168.0.17 in PS_Game.ini

In advance i must thank you both for helping me thus far!!
12/11/2012 22:54 Truth1010#21
are you trying to connect with the right Game IP?

Sounds like your trying to connect to another server instead of your own.. xD
12/11/2012 22:55 eclipz13#22
My local ip is 192.168.0.17
12/11/2012 22:57 Truth1010#23
try make it 127.0.0.1 in the game.exe and your ini files. See if that works for you.
12/11/2012 22:59 eclipz13#24
That didn't work either :(
12/11/2012 23:09 Truth1010#25
Sent you a PM so we don't hit over 100 posts in this 1 thread trying to work out your problem. xD
Page 2 of 2 1 2