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

[Sakrateri]

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

[Angelox]

Originally Posted by Sakrateri

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.

[Sakrateri]

I will try this , but one thing

restore my database to you your MySql Server

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

[Aerewen]

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.

[Sakrateri]

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.

[Aerewen]

execute this query in your database:

SELECT * FROM `account` WHERE `id` = 9;

then tell me if it returned any information

[Sakrateri]

it returned

Empty set <0.00 sec>

[Aerewen]

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

		$sql = "INSERT INTO `account` (`id`,`name`,`charname`,`sharedplat`,`password`,`status`,`lsaccount_id`,`gmspeed`,`revoked`,`minilogin_ip`,`hideme`,`rulesflag`) VALUES (". $newno. ",'". $_POST['username']. "','',0,'". $_POST['password']. "',". $admin_level. ",". $newno. ",0,0,'". $_SERVER['REMOTE_ADDR']. "',0,0)";

to

		$sql = "INSERT INTO `account` (`id`,`name`,`charname`,`sharedplat`,`password`,`status`,`lsaccount_id`,`gmspeed`,`revoked`,`minilogin_ip`,`hideme`,`rulesflag`) VALUES (NULL,'". $_POST['username']. "','',0,'". $_POST['password']. "',". $admin_level. ",". $newno. ",0,0,'". $_SERVER['REMOTE_ADDR']. "',0,0)";

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