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

[John Adams]

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

Ok, I am done.

[Aerewen]

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

[John Adams]

Oddly, my mood changed once I left work.

You win. Uncle!!

[Cyro]

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

[LordHogFred]

Ok I'm getting some really horrible errors:

Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in C:\Inetpub\wwwroot\eqlogin\index.php on line 119

Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in C:\Inetpub\wwwroot\eqlogin\index.php on line 120

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in C:\Inetpub\wwwroot\eqlogin\index.php on line 122

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\Inetpub\wwwroot\eqlogin\index.php on line 123

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in C:\Inetpub\wwwroot\eqlogin\index.php on line 158

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in C:\Inetpub\wwwroot\eqlogin\index.php on line 159

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in C:\Inetpub\wwwroot\eqlogin\index.php on line 163

Any ideas?

[John Adams]

Yeah, google this:

Client does not support authentication protocol requested by server; consider upgrading MySQL client

Tons of posts about this on the net.

[PenPen01]

does anyone still have the source of PEQ_Updater?

[Angelox]

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

[GeckoGal]

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

[John Adams]

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.

[Angelox]

Originally Posted by John Adams

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.

[John Adams]

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

Either way, glad you found what you needed.

[Angelox]

Server not found
Firefox can't find the server at eq.mmoemulators.com.

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

[sdabbs65]

Originally Posted by Aerewen

Here's the solution to this problem temporarily.

Dowload the zip file with peq_updater.php and eqhost.txt file, install them on a webserver.
Modify the variables in the php file to your MySQL server information.
Read the info in the header of the php document to learn how this works.

I will not be providing support for this utility, but feel free to post bugs and whatnot here for as long as the moderators wish to allow it. You should already have PHP/MySQL installed if you are using the PEQ Editor on your system.

Download Zip File
Download RAR File

edit: added rar file for people who prefer it.

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.

[John Adams]

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