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

[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.

[John Adams]

Column "packetencrypt" sounds like old Emu. Like I said, if the fields in the accounts table to not match what Aerewen's Insert expects, that's what's causing your problem. If he's using the current database, try that on a separate install just to verify (point your configs to a new currently sourced database - PEQ, ax_peq, something like that).

[Sakrateri]

Edit, Nm got it ...trying to get Angels database installed and I am having moments of pure stupidness !


Well , I cant get Angel's to work I tried installing it two diferent times, mabey there is a special order to install all this? I also was going to post on Angel's boards but does not seem to be a way to register so I can .

[Aerewen]

yeah im gonna rewrite the SQL statements to specify values by column name... like i said this script was written for use with my server only... i just made the SQL/server info into variables for other people to use :p

i'll have an updated version here in a few mins. once i eat some dinner that is