ok, maybe you didnt say that, but you should..

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!

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


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.

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

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 .

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 :D

Well I still say this is an awsome script and you are awsome for doing this , I am happy to keep using it how it is if you dont feel like messing with it , as it is now everyone just has to use a 0 for the password and do it twice then its fine, its no matter if everyone knows the password cause its the IP that matters.

okie i changed the sql statement to include column names.. this should now work properly when creating a new account with any database :)

Thanks again on this, is it updated on the previous link?

Did you ever get my DB working? , if not tell me more about what you have, is it MySql4x, and did you use Cavedude's installer?

Yes its 4x and yes I used Cavedudes, that new one is not working for me at all and I just ran into one more problem. Is there anything in the old code that will not allow more then eight accounts to be created? everytime I get eight accounts created every try after that to make another one says there was an error while trying to create your account, then if I delete a couple of the accounts I can make more up till eight accounts again? I am really sorry about this and if you dont feel like messing with it I understand but I still say its an awsome job. Its my problem for not knowing how to read and make this code better myself. Thanks

You mean Cavedudes old install? If so, then your problem is, the new database, PEQ, EQ and AX_PEQ are all compatible with the latest EQEMU and you'd have to update your binaries.
If you have something that works (Cavedudes old install?) , then here's an easy way to upgrade; Don't uninstall anything, you can go to my site, download my full DB for MySql4x, Go to MySql Site, Download MySql-Administrator, Go to Eqemu site, download newest binaries -
Then restore my database to you your MySql Server, backup your current eqemu configuration, then overwrite the eqemu directory with the newer binaries from eqemu site.- the only file you should keep is your eqemu_config.xml. You'll see where you can set permissions and what-not to any database you have installed via MySql-Admin; Set permissions for newly restored DB. once you have set permissions, you need to point the eqemu to the new database; make changes in the eqemu_config.xml file to that.
Theres' links to all this posted at my website.

I will try this , but one thing

I am a little confused about that , run that over TOP of the database I am using now (cavedudes)?

check your database and see if you have a user entry with the "id" field set to 9

the script increments the id field automatically just in case the mysql database isnt set to auto increment that field.

user entry? you mean account id? no , i cant get past 8

btw , I am using MYSQL Front , so what ever I need to do in the database is pretty easy.

execute this query in your database:
then tell me if it returned any information

it returned

that's really odd... the only thing i can think of to try is changing line 161 from:
to

and hope your database is set to auto increment the id field

I wouldn't insert 'id' at all, on an auto-increment field.

setting it to null will cause it to auto increment as well. as memory serves me older versions of MySQL will spit out an error if your insert query doesnt specify at least a null value for a key

Just because I am in an argumentive mood today (grin), no value passed would also be NULL. ;)

Ok, I am done.

Just to sustain your mood :p

You are correct, however if someone were to type in an emty set of quotes or a 0 there thinking it was a mistake in my post, then the query wouldnt work :)

which is why i added the column and the NULL value to the query ;)

Oddly, my mood changed once I left work. :D

You win. Uncle!!

Okay, using this PHP fix...when i type in my username and password, internet explorer eventually comes up with the error of "cannot load page"
However, i know it connects because I can see the attempts to connect in the minilogin.exe...

Any ideas? My thoughts were that I needed to change something about the MySql access...

Below are my files, copied and pasted verbatim (aside from making the user/pass blank)

~~~~~~~~~~~~~~~~~~
Index.php
~~~~~~~~~~~~~~~~~~
Put this page on your site after setting the variables below to
the information of the MySQL database with the PEQ info in it.
*/
$DB_ADDY = "eqemu.no-ip.biz:5999"; //address:port for the MySQL server
$DB_USER = ""; //username to login to MySQL with
$DB_PASS = ""; //password to login to MySQL with
$DB_DB = "ax"; //database name to use "peq" for default installation

$server_name = "Shadows of Hatred"; //set the name of your server here
$admin_level = 250; //default level of admin to give to people who sign up
//This WILL NOT modify admin of people logging in to the server.

~~~~~~~~~~~~~~~~~~~
Loginserver.ini
~~~~~~~~~~~~~~~~~~~
[LoginServer]
loginserver=eqemu.no-ip.biz
loginport=5999
worldname=Shadows of Hatred
worldaddress=eqemu.no-ip.biz
locked=false
account=
password=

[WorldServer]
Defaultstatus=
Unavailzone=
[ChatChannelServer]

worldshortname=
chataddress=
chatport=

[LoginConfig]
ServerMode=MiniLogin
ServerPort=5999

~~~~~~~~~~~~~~~~~~~
eqemu_config.xml
~~~~~~~~~~~~~~~~~~~
<?xml version="1.0">
<server>
<world>
<shortname>Minilogin</shortname>
<longname>Shadows of Hatred</longname>

<!-- Only specify these two if you really think you need to. -->
<address>eqemu.no-ip.biz</address>
<localaddress>127.0.0.1</localaddress>

<!-- Loginserver information. -->
<loginserver>
<host>eqemu.no-ip.biz</host>
<port>5999</port>
<account></account>
<password></password>
</loginserver>
<unlocked/>
<!-- Sets the shared key used by zone/launcher to connect to world -->
<key>some long random string</key>

<!-- Enable and set the port for the HTTP service. -->
<tcp ip="eqemu.no-ip.biz" port="9000" telnet="enable"/>
<http port="9080" enabled="true" mimefile="mime.types" />
</world>

<!-- Database configuration, replaces db.ini. -->
<database>
<host>eqemu.no-ip.biz</host>
<port>3306</port>
<username></username>
<password></password>
<db>ax</db>
</database>
</server>


Can anyone shed some light...please? It would be GREATLY appreciated!!!
Thanks in advance,
-Cyro

Ok I'm getting some really horrible errors:

Any ideas?

Yeah, google this:
Tons of posts about this on the net.

does anyone still have the source of PEQ_Updater?

Can anyone post me a link or email me Aerewen's updater? I lost mine when my hard disk died

ME Too!!!!! please
 

I'd also like to get hold of a copy of that code..
So, if some kind person could link it I too would be forever grateful. :)
LOL, could email it me too, that'd be better :)

Many thanks, in advance

gecko

Did you guys ever get ahold of peq_updater.zip? If not, here's a link:

http://eq.mmoemulators.com/files/peq_updater.zip

Not sure if this was his latest work - file dated 12/15/2006 locally.

Hi John
I still need it, your link didn't work for me :(

EDIT:
NM, I found a copy in a trash folder with an slocate.

Weird. I clicked the link and it works for me. :)

Either way, glad you found what you needed.

I just tried again, but no worries, I got the file. Thanks anyways!

.
 

FYI:
I tested it for fun just to see if it works and it only updates ip address's of existing accounts it dont add them like it says.
other than that it works great.

Hmm, likewise, just the other day - my first time trying it (I don't use it, just wanted to see what it did) and it did add a record to my account table. Sure you didn't add an account that was already there? j/k

..
 

No I used a clean test server install and nothing was inserted.
maybe you have to add a GM first. <shrug>.

take it to another eq emulator site. -- matt

I have a more permenant solution

http://shardsofnorrath.no-ip.org:90/...er-1.0BETA.zip

It includes a launcher that the users login to and a server that handles the updating of ips based on their username and password giving the ilusion of a public loginserver while using minilogin

ummm that link doesn't work. Anyone have a mirror?