Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Shaiya > Shaiya Private Server
You last visited: Today at 12:49

  • Please register to post and access all features, it's quick, easy and FREE!

Advertisement



Unknown SQL account creation bug?

Discussion on Unknown SQL account creation bug? within the Shaiya Private Server forum part of the Shaiya category.

Reply
 
Old   #1
 
[Dev]RiseAgainst's Avatar
 
elite*gold: 0
Join Date: Jun 2011
Posts: 54
Received Thanks: 13
Unknown SQL account creation bug?

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.
Attached Images
File Type: jpg account error 1.jpg (194.2 KB, 42 views)
File Type: jpg account error 2.jpg (198.0 KB, 38 views)
[Dev]RiseAgainst is offline  
Old 10/10/2011, 22:07   #2
 
elite*gold: 0
Join Date: Jul 2009
Posts: 408
Received Thanks: 180
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.
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
viper4513 is offline  
Old 10/10/2011, 22:12   #3
 
[Dev]RiseAgainst's Avatar
 
elite*gold: 0
Join Date: Jun 2011
Posts: 54
Received Thanks: 13
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?
[Dev]RiseAgainst is offline  
Old 10/10/2011, 22:13   #4
 
elite*gold: 0
Join Date: Jul 2009
Posts: 408
Received Thanks: 180
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
viper4513 is offline  
Old 10/10/2011, 22:16   #5
 
[Dev]RiseAgainst's Avatar
 
elite*gold: 0
Join Date: Jun 2011
Posts: 54
Received Thanks: 13
Quote:
Originally Posted by viper4513 View Post
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
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.
[Dev]RiseAgainst is offline  
Old 10/10/2011, 22:19   #6
 
elite*gold: 0
Join Date: Jul 2009
Posts: 408
Received Thanks: 180
just post it plain then no problems.

for the code thing
Code:
test

["code"] message ["/code"]
["spoiler"] message ["/spoiler"]

Both with no "
viper4513 is offline  
Old 10/10/2011, 22:20   #7
 
[Dev]RiseAgainst's Avatar
 
elite*gold: 0
Join Date: Jun 2011
Posts: 54
Received Thanks: 13
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
Thats without the columns like i said ill leave it to you but im pretty sure its right.
[Dev]RiseAgainst is offline  
Old 10/10/2011, 22:23   #8
 
elite*gold: 0
Join Date: Jul 2009
Posts: 408
Received Thanks: 180
set Admin to 1
UseQueue to 0
Leave to 0

Execute query (red ! in the top left) and try that.
viper4513 is offline  
Old 10/10/2011, 22:26   #9
 
[Dev]RiseAgainst's Avatar
 
elite*gold: 0
Join Date: Jun 2011
Posts: 54
Received Thanks: 13
Quote:
Originally Posted by viper4513 View Post
set Admin to 1
UseQueue to 0
Leave to 0

Execute query (red ! in the top left) and try that.
It says when i try to set to 1 or 0 for usequeue and admin invalid entry. It will only accept true of false.
[Dev]RiseAgainst is offline  
Old 10/10/2011, 22:33   #10
 
elite*gold: 0
Join Date: Jul 2009
Posts: 408
Received Thanks: 180
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.
viper4513 is offline  
Old 10/10/2011, 22:38   #11
 
[Dev]RiseAgainst's Avatar
 
elite*gold: 0
Join Date: Jun 2011
Posts: 54
Received Thanks: 13
Quote:
Originally Posted by viper4513 View Post
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.
i added u on skype and ill open my teamviewer up. thanks for the assistance
[Dev]RiseAgainst is offline  
Old 10/10/2011, 22:46   #12
 
elite*gold: 0
Join Date: Jul 2009
Posts: 408
Received Thanks: 180
Didnt get a request from you yet.. whats yours? :S
viper4513 is offline  
Old 10/10/2011, 22:48   #13
 
[Dev]RiseAgainst's Avatar
 
elite*gold: 0
Join Date: Jun 2011
Posts: 54
Received Thanks: 13
Quote:
Originally Posted by viper4513 View Post
Didnt get a request from you yet.. whats yours? :S
tacticalnukez
[Dev]RiseAgainst is offline  
Reply


Similar Threads Similar Threads
KTS Account Creation
04/12/2011 - Rappelz Trading - 7 Replies
Ich biete hier nun meinen service an,KTS accounts zu erstellen. pro account: 5$ spart euch die billig flames. nicht jeder schafft es (komischerweise) sich nen kts acc zu machen und ich bin es leid die ganzen accounts umsonst zu machen und meine zeit damit zu verschwenden. einfach eine pm mit den Wunsch-Daten schreiben.
Creation of account?
04/09/2011 - Elsword - 14 Replies
I've heard from people that the elsword server is up. so i went to register but unlucky me there is a ip block. so how can i make an account?
Account Creation
09/03/2010 - CO2 Private Server - 1 Replies
Hey guys! At first im looking now around some hours for a working registerpage for 5165, I don't really see a sense to have appserver when everything runs over the oldcodb, only for website it should be usefull. Well If I maybe overlooked an existing RegPAge then tell me please. THe way with /newacc blahblahblah I already know but wont make accounts for people who dont get on the console right... Another Idea I got is from a system far before the ninjas got released, I mean it was...
Account Creation
08/09/2010 - Battle of the Immortals - 1 Replies
I live in Australia, is it possible to create another account for PW and be able to play? I can play right now because this PW account was created before the restrictions were laid on. edit: I think I may have been mistaken about this, I just created an account and it works perfectly fine... where in the name of the lord almighty did I get the idea that I can't play since I live in Australia hmm? Delete this thread please. However if you're here, then I might aswell ask. Has anyone...
Account creation
09/02/2005 - General Gaming Discussion - 5 Replies
If you cannot log on, give me a pm and I will create accounts for those of you who cannot, I have created four succsessfully already. ______________________________ Details needed: Your wanted ID Your wanted Pass



All times are GMT +1. The time now is 12:55.


Powered by vBulletin®
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2025 elitepvpers All Rights Reserved.