Log in

View Full Version : Help with Making NEW accounts


Dwarf
12-15-2002, 01:52 PM
ok i have my eqemu account and it works fine i can login with it and everything but i want to make an new acconut with out dleating the oulf account....

so i went to MSdos to mek a new account the same way i made eqemu

i typed

F:\SERVER\EQEMU>world adduser Yolet passwordhere 1

Using database 'eq' at localhost EQEMu 0.4.0-Buon Compleanno Account Attempting to be created:Yolet passwordhere 1 Error in CreateAccount query 'INSERT INTO account SET name='Yolet', password= 'passwordhere', status=1, lsaccount_id=0;' #1062: Duplicate entry '0' for key 2
database.CreateAccount failed.

Whats wrong do i need to creat my logins in a nother manner? Em i not connecting with the data bece or soemthing? do i need to have world.exe running?

i think its trying to replase my cerent login not add a new one
" #1062: Duplicate entry '0' for key 2 " :(

Dwarf
12-15-2002, 03:59 PM
is there any other way i can make a new acount on my server:?:

Dwarf
12-16-2002, 01:49 AM
PLEASE PLEASE PLEASE PLEASE PLEASE PLEASE PLEASE

:cry: i realy realy what to get this server working properly\

Has no one here made an acount? NO! please help me

Edgar1898
12-16-2002, 02:29 AM
Looking at the syntax of the error you might need to add an account number at the end of the command.
Ie: world adduser Yolet passwordhere 1 19000
where 19000 is the account id

neotokyo
12-16-2002, 04:41 AM
if i am correct the whole thing is useless anyway, cause that account wont be able to pass authentication at public login. if you want 2 seperate users on your server (for whatever reason) make a 2nd forum acc't.

Dwarf
12-16-2002, 01:09 PM
F:\SERVER\EQEMU>world adduser Yolet passwordhere 1 20
Using database 'eq' at localhost
EQEMu 0.4.0-Buon Compleanno
Usage: world adduser username password flag
flag = 0, 1 or 2


i put 20 as the id number but it didnt work :( thanx anyway for trying to help

What do you mean it would be ussless i dont think it is ussless to have more then 8 players on my server EQ is kinda lame with only 8 players

The progeram should beable to suport it its cinda a pointless if you can only have 8 people playing on a MMORPG

How does "EQlogin.eqemu.net" have more then one account? Ill do it anyway i have to to get it working. ANYTHING. Coundt i gust add user privlges top the other accounts or computers the accounts are running on? If not i plan on geting working some time. i can cerently log on and pick a server with 1 sccount. is it the SQL sever that is stoping me from creating another account count i just make anuter account on mySQL or is that not possable im running a minylogin.exe world.exe boot5zones.exe now and its running fine but i wanta have other peole login as different users to my server (if i have to change my server list hoster i well)

Please i want it to be a good server not limmeted to 8 people. Your the grus im not smarter than yah please help me learn. Soi can get it running properly 8)

Trumpcard
12-16-2002, 02:35 PM
Well, 1st off, the reason this is happening is that you already have an account with id of 0... Hence the duplicate message.

How are you trying to connect? If you're using the public login, then the account will be created automaticlly by the loginserver on your machine when someone connects, you dont need to manually create every account on the server.

If you feel you REALLY have to create accounts, do this..
Just skip the whole thing... Open up mysql and create the account manually..

from dos, run mysql:

mysql>use eq;
mysql>select max(id) from account; (this gives you the highest account number in the database)

mysql>insert into account set name='Yolet', password='passwordhere', status='whatever status you want', lsaccount_id='1 higher than the max you got';

There, you have created a new user account. Im not sure what youre trying to accomplish, if the account doesnt exist on the forums, it wont log you in anyways via the public login server...

Dwarf
12-16-2002, 02:56 PM
Thank you vary much :D this is so neat 8)

i wanted to make it so not just anyone could creat an account :)

im sorry i was cinda uncleare but i want to make it so that people cant login unless i create the account.

Im willing to use something other then publik (wich im shere i am using) so theat i can make the accounts for people insviualy, Cinda liek the way that you can type in just anything in to the "Offishal EQemu servers" and thay well log in for you.

EDIT: Im using minny login, can i restrikt account acces using minny login or do i need to do somethin elce? (does minny login suport usermade accounts (and only accouns made my admin od sql server?))

is there a privetlogin.exe?, that i could use, i would love it if there was.

im geting in to this alot it is the neatest thing :twisted:

Dwarf
12-18-2002, 01:50 AM
i dont know if i should make a new form for this but....



How do i resrtct acces so it does not aoto creat an catount when it connects....
(like the way in eqemu normal servers ware it wont let yah in unless you use the from login (execpt i would make a login insted of a form made login))

Please hlep me out, i think this self server thing is one of the best thing i was ever involved in.