Minilogin to public server? (i'll settle for the minilogin source code)

[Angelox]

Originally Posted by John Adams

Yes, I am boxing off the same machine. What happens currently (not using this script) is if you have 2 accts with the same IP, I think the Db search stops at the first match of IP it finds (doesn't consider the account name at all, I am sure). Even without 2 boxing. Set up 2+ accts with the same IP in your database, log one in, see the toons. Then, log out - and log in the second acct from the same machine. You'll see the first guys toons again.

So even before trying to 'box', I am having an issue with same-IP. Which I am hoping this tool might help with - but I am thinking, if it doesn't change the first accts IP, it won't solve my problem.

(btw, I don't seem to have this problem with Public, but I don't have access to that atm ~cry~)

Try it! I think once logged in, ip doesn't matter anymore - might when you zone though.
This php sort of "knows" what belongs to who.

[Aerewen]

no you will not be able to 2-box with this script... the eqemu server bases account id on IP address so if you change the ip address even after logged in you will either a) change accounts, b) crash the server, or c) crash the zone you are in

i should mention that this script was written based on the modified ax_peq database i'm using, i dont know offhand if the account table has a different number of columns than the default peq databases... but that could cause login problems for some servers.

[Aerewen]

oh on a side note you definitely cannot 2-box with this script...

when a player logs in their account it automatically changes all other account rows with their ip address to use the ip of 0.0.0.0

this was done to prevent crashes on the server side from having multiple accounts active using the same IP

but this also provides for a nifty little feature... your GM's can have one login/password for their GM account and another login/password for their regular account. then they can use this tool to swap between accounts to go play as a normal player with 0 access flags to GM commands since it will erase their IP from whichever account they did not log in from.

Also for long term use, players can actually create more than just one account worth of characters on the server. So we arent limiting them to selecting just some of the classes. they can make an account, fill it up with toons, and come back to make a new account, then fill that one up as well :p

[Sakrateri]

I realize you said no support so I am just throwing this out for the general public, Mabey someone else has experienced this and knows a fix. When someone first creates an account it sets the password as 0 in the database instead of what they wanted, If I manually put a password in and tell them what it is then it is fine after that .. Any ideas? and that is a 0 not an O that its making.

[DarkMaster]

Just wanted to say thanks for the script, it is cleaver. I am running EQemu from behind a 2 firewalls using nat / port forwarding and it all works fine. Just what the doctor ordered lol!

[John Adams]

Sak, check out what Aerewen said before about invalid column counts between databases. If you are getting a zero stuffed into Password, maybe that zero was destined for the Status column instead?

Best way to do inserts (on new accounts) is to always provide the (field_names) for every (field_value) you supply.

Eg.,
INSERT INTO account (name, password, status) VALUES ('name','password','status');

Many people tend to take the shortcut, and just do a:

INSERT INTO account VALUES ('name','password','status');

...but that implies **exact** column placement and order. If accounts has 4 columns, for example, the above insert would error with "invalid column count" or something about not being able to find a column. Check that out.

I wish my linux webserver was working. I'm dying to try this out!

[Sakrateri]

well this is what I've got for the code now

$sql = "INSERT INTO `account` VALUES (". $newno. ",'". $_POST['username']. "','',0,'". $_POST['password']. "',".$admin_level. ",".  $newno. ",0,0,'". $_SERVER['REMOTE_ADDR']. "',0,0)";

and these are all the rows I've got in my database
e
id,name,charname,packencrypt,sharedplat,password,s tatus,Isaccount_id,gmspeed,revoked,miniloginip,hid eme

That first 0 is showing up as the password because i changed it to a 5 and it set the password as 5 and yes I believe that is suppose to be the status. anyone can look at this and tell me what i have to do to fix it? I have tried deleting and adding stuff and nothing worked.