So heres the deal i made 2 gm accounts and a normal account in SQL. Yes i did all the info right and 1 is in OMG_Gameweb and users_master. Problem is when i go into game it says account doesnt exist. My game.exe IS hooked up to hamachi for testing purposes and the hamachi ip is correct in the exe. Any solutions i will post 2 pictures below that proves i have it in there right. And btw before you trolls come on here i HAVE searched the issue there seems to be no such thing as the account being right in database but not being in the game.
Unknown SQL account creation bug?
10/10/2011 21:34
[Dev]RiseAgainst#1
10/10/2011 22:07
viper4513#2
The reason "there seems to be no such thing as the account being right in database but not being in the game" isnt in the search, is cuz it doesnt exist. Simple enough, you got it wrong in the database.
Also you erased the Server name, but left it in the "tab" for both open tables.. :S and the passwords clearly on show.
You only need to add user info to the users.master table, OMG GameWeb can be ignored.
Were you able to log in with only 1 account there, before you tried to add your new ones? or never been able to log in?
from what i see, your UseQueue is set to False, instead of 0
but that shouldnt affect anything.
post the entire line of your users in tags.
Also you erased the Server name, but left it in the "tab" for both open tables.. :S and the passwords clearly on show.
You only need to add user info to the users.master table, OMG GameWeb can be ignored.
Were you able to log in with only 1 account there, before you tried to add your new ones? or never been able to log in?
from what i see, your UseQueue is set to False, instead of 0
but that shouldnt affect anything.
post the entire line of your users in tags.
Code:
RowID UserUID UserID Pw JoinDate Admin AdminLevel UseQueue Status Leave LeaveDate UserType UserIp ModiIp ModiDate Point Enpassword Birth 11 1 *** *** 2011-00-00 00:00:00 1 255 0 16 0 2021-00-00 00:00:00 A NULL NULL NULL 0 NULL NULL
10/10/2011 22:12
[Dev]RiseAgainst#3
i never tried i change the admin admin123 immediatly on creation. so ive never been able to log in. and my bad haha doesnt matter anyway this isnt the legit server. its a test. So any solutions come to mind viper?
10/10/2011 22:13
viper4513#4
Well i changed my admin right away and it worked fine.. liek i said, post 1 line of that users.master so i can see if you actually did write something wrong in there.
And just to check.. you did actually "execute" the query when you changed the accounts, right?? :S
And just to check.. you did actually "execute" the query when you changed the accounts, right?? :S
10/10/2011 22:16
[Dev]RiseAgainst#5
when i try to copy the rows it doesnt include the columns and i dont know how to post it in the Code: box thing haha. im newb at forums.Quote:
Well i changed my admin right away and it worked fine.. liek i said, post 1 line of that users.master so i can see if you actually did write something wrong in there.
And just to check.. you did actually "execute" the query when you changed the accounts, right?? :S
10/10/2011 22:19
viper4513#6
just post it plain then ;) no problems.
for the code thing
["code"] message ["/code"]
["spoiler"] message ["/spoiler"]
Both with no "
for the code thing
Code:
test
["code"] message ["/code"]
["spoiler"] message ["/spoiler"]
Both with no "
10/10/2011 22:20
[Dev]RiseAgainst#7
Code:
11 1 RiseAgainst Caszatt1 10/6/2011 6:42:00 PM True 255 True 16 1 10/6/2021 6:42:00 PM A NULL NULL NULL 9999999 NULL NULL
10/10/2011 22:23
viper4513#8
set Admin to 1
UseQueue to 0
Leave to 0
Execute query (red ! in the top left) and try that.
UseQueue to 0
Leave to 0
Execute query (red ! in the top left) and try that.
10/10/2011 22:26
[Dev]RiseAgainst#9
It says when i try to set to 1 or 0 for usequeue and admin invalid entry. It will only accept true of false.Quote:
UseQueue to 0
Leave to 0
Execute query (red ! in the top left) and try that.
10/10/2011 22:33
viper4513#10
1 = true
0 = false
so Admin - True
UseQueue - False
Leave - False
This shudnt actually affect the account from working tho :S
Wanna add me on skype and i'll see if i can help?
My skype is on my account here.
0 = false
so Admin - True
UseQueue - False
Leave - False
This shudnt actually affect the account from working tho :S
Wanna add me on skype and i'll see if i can help?
My skype is on my account here.
10/10/2011 22:38
[Dev]RiseAgainst#11
i added u on skype and ill open my teamviewer up. thanks for the assistanceQuote:
0 = false
so Admin - True
UseQueue - False
Leave - False
This shudnt actually affect the account from working tho :S
Wanna add me on skype and i'll see if i can help?
My skype is on my account here.
10/10/2011 22:46
viper4513#12
Didnt get a request from you yet.. whats yours? :S
10/10/2011 22:48
[Dev]RiseAgainst#13
tacticalnukezQuote: