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

Sakrateri · #1 12-16-2006, 01:51 AM

yes I did, I believe it is trying to use the MYSQL database that was installed with apache automatically when I installed easyphp, Any easy way for me to direct apache to my MYSQL that I use for eqemu? I Put For: DB_ADDY = "localhost"; . Mabey I should put the actual IP and a port number?

Sakrateri · #2 12-16-2006, 02:07 AM

Ok, I put the address and port number and now Im getting this

Code:

Warning: mysql_connect(): Host 'gameserver.launchmodem.com' is not allowed to connect to this MySQL server in e:\program files\easyphp1-8\www\updater\index.php on line 119

Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in e:\program files\easyphp1-8\www\updater\index.php on line 120

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in e:\program files\easyphp1-8\www\updater\index.php on line 122

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in e:\program files\easyphp1-8\www\updater\index.php on line 123

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in e:\program files\easyphp1-8\www\updater\index.php on line 158

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in e:\program files\easyphp1-8\www\updater\index.php on line 159

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in e:\program files\easyphp1-8\www\updater\index.php on line 163

think im getting somewhere, lol not sure where

Angelox · #3 12-16-2006, 02:18 AM

Here's all my files tested and working -
Note: blackwater.dynip.com is the dynamic dns I used for resolving my ip address.
Also, I have a dedicated MySql server on another machine in my LAN, so I specify the IP where needed.

eqhost.txt on client;

Code:

LoginServer]
Host=blackwater.dynip.com:5999

Code:

<?xml version="1.0">
<server>
        <world>
                <shortname>minilogin</shortname>
                <longname>BlackwaterMiniLogin</longname>
                
                <!-- Only specify these two if you really think you need to. -->
		<address>blackwater.dynip.com</address>
		<localaddress>127.0.0.1</localaddress>
		
		<!-- Loginserver information.  -->
        <loginserver>
		<host>blackwater.dynip.com</host>
		<port>5999</port>
		<account></account>
		<password></password>
        </loginserver>

                <!-- Sets the shared key used by zone/launcher to connect to world -->
                <key>************/key>

                <!-- Enable and set the port for the HTTP service. -->
                <http port="9080" enabled="true" mimefile="mime.types" />
        </world>

                <!-- Database configuration, replaces db.ini. -->
        <database>
                <host>192.168.2.108</host>
                <port>3306</port>
                <username>***</username>
                <password>***</password>
                <db>ax_peq</db>
        </database>
</server>

Login server.ini;

Code:

[LoginServer]
loginserver=blackwater.dynip.com
#loginserver2=newlogin1.eqemulator.net
loginport=5999
#loginport2=5999
worldname=BlackwaterMiniLogin
worldaddress=blackwater.dynip.com
locked=false
#account=
#password=

[WorldServer]
Defaultstatus=
Unavailzone=

[ChatChannelServer]
worldshortname=
chataddress=
chatport=

[LoginConfig]
ServerMode=MiniLogin
ServerPort=5999

Stuff I changed on my peq_updater.php;

Code:

*/
$DB_ADDY = "192.168.2.108"; //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_peq"; //database name to use "peq" for default installation

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

My Linux server uses DMZ with its own Firewall, I have these ports for EqEmu;

Code:

3306/udp 5999/udp 9000/udp 7000:7010/udp 3306/tcp 5999/tcp 7000:7010/tcp

I was just on with a friend , and it's all working fine -
It looks like your MySql Server is not permiting your PhP setup to access it, maybe your webserver is somewhere else and you need to add the host in the Mysql user list?

Sakrateri · #4 12-16-2006, 04:06 AM

Ok Aerewen , I just gotta say you are AWSOME, its working and now I can enjoy a little bit more of that flavor known as freedom

This is just way to cool !! I think this may be even better then the real login as now it checks your Account name, Password AND IP !! Damnit man did I say your AWSOME? well thank you so much for this ....its rocks !!

P.S And thanks for your Help Angel , Your Awsome too !

Sakrateri · #5 12-16-2006, 05:09 AM

Somethng funny here. When a person first makes an account it wants to put the first number of the IP in the revoked column and then nothing in the IP column but when they do it a second time it puts the entire IP in the IP column correctly but the number that was put in the revoked column is still there.... I dont even know what the revoked column is for lol...

John Adams · #6 12-16-2006, 05:10 AM

I'm attempting to get this to work on my systems now (and I'll try not to ask for support, hehe), but here's a functionality question that I'll toss out while I work...

With this script, can I 2-box on Minilogin (obviously, 2 accts with the same IP)? Because currently, no matter how clever I think I am, Minilogin doesn't seem to give a rats ass about account name at all - only IP - which I believe is the base issue most have with Minilogin. Everyone touts that it only uses account name and IP - but if that were true, I could have 12 accounts with the same IP, and see my chars.

I do see Minilogin handing off the right Acct # from IP (blah) to World.exe, but when I get inside, all I see is 1 guys toons. Any idea if this script will help us lonely boxers?

Angelox · #7 12-16-2006, 05:18 AM

Quote:

Originally Posted by John Adams

I'm attempting to get this to work on my systems now (and I'll try not to ask for support, hehe), but here's a functionality question that I'll toss out while I work...

With this script, can I 2-box on Minilogin (obviously, 2 accts with the same IP)? Because currently, no matter how clever I think I am, Minilogin doesn't seem to give a rats ass about account name at all - only IP - which I believe is the base issue most have with Minilogin. Everyone touts that it only uses account name and IP - but if that were true, I could have 12 accounts with the same IP, and see my chars.

I do see Minilogin handing off the right Acct # from IP (blah) to World.exe, but when I get inside, all I see is 1 guys toons. Any idea if this script will help us lonely boxers?

I think it will, as it actually uses the username/password and IP feature in the database - you might try setting one account, logging in, then set the other account (always go to the Updater first) - login again ( I take you're boxing off the same machine?)

John Adams · #8 12-16-2006, 05:24 AM

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

Angelox · #9 12-16-2006, 05:27 AM

Quote:

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.

Angelox · #10 12-16-2006, 05:25 AM

I would only use it with friends for now, as I can already see a few issues. For example, Maybe it could be fixed to where one IP can only have three accounts made in a session. You could end up with your accounts getting spammed with accountnames.
Also, you should make a "blank" account with a specific password, in case someone just presses the "enter" key- I already did this, and made a blank account with a blank PW. If it has a password, they will get an error.