New MiniLogin Release! - Page 3

devn00b · #31 03-23-2009, 12:12 PM

Quote:

Originally Posted by Sakrateri

That was it Number6 Thanks alot, all working great now, Thank you Image and Devnoob for this, This is awesome!

Devnoob you can finally take yourself out of the I hate Devnoob club after all these years

I know right?! Amazing!

image · #32 03-23-2009, 01:50 PM

Losing numbers in the I hate devn00b club is unacceptable! I will help increase the numbers back to norm.

devn00b · #33 03-23-2009, 01:53 PM

For every one that leaves...5 more crop up!! Guess I'll always be hated.

Angelox · #34 03-23-2009, 07:46 PM

I got a problem here, sort of know what it is, but not sure what to do.
You all using MySql 5.1x? I have MySql 5.0x
here's my problem;
After the variables table is made, I get this error;

Code:

ERROR 1231 (42000): Variable 'character_set_client' can't be set to the value of 'NULL'

When attempting to run this line;

Code:

SET character_set_client = @saved_cs_client;

I'm thinking it's the version, or maybe it's because I have the old password method active?

devn00b · #35 03-23-2009, 07:52 PM

yeah stupid sql i think you can just remove that line from the sql file and it should load normally

Angelox · #36 03-23-2009, 08:01 PM

Thanks! I had an urge to do that but I wasn't sure, been researching that error for about an hour now (I found a lot of brick walls). I'll give it a run.

image · #37 03-23-2009, 08:41 PM

Yea you can ignore those, thats new MySQL stuff, don't ask me what for. You just need the default tables anyway.

Aergad · #38 03-26-2009, 02:15 AM

Just a side note you have to put the minilogin server into a seperate directory from your main eqemu server with all the files included in the zip file for it to work

warhawk · #39 03-26-2009, 04:08 PM

I'm having trouble sourcing the SQL. This bit seems to cause a 1064 error:-

Code:

DROP TABLE IF EXISTS `variables`;
CREATE TABLE `variables` (
  `varname` varchar(25) NOT NULL default '',
  `value` text NOT NULL,
  `information` text NOT NULL,
  `ts` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`varname`)
) ENGINE=MyISAM DEFAULT;

Any Ideas?

image · #40 03-26-2009, 04:26 PM

DROP TABLE IF EXISTS `variables`;
CREATE TABLE `variables` (
`varname` varchar(25) NOT NULL default '',
`value` text NOT NULL,
`information` text NOT NULL,
`ts` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
PRIMARY KEY (`varname`)
) ENGINE=MyISAM;

Remove " DEFAULT"

warhawk · #41 03-26-2009, 04:43 PM

Bah, simple when you know how

Thanks Image!

warhawk · #42 03-28-2009, 10:42 AM

Hi again

I'm still struggling to get this working.

I'm getting the following error on the minilogin shell.

Code:

Error in CheckWorldVerAuth query `SELECT approval From login_versions Where version=`0.7.0`;`
#1146: Table `peq.login_versions` does not exist
Bad Version <soft>: #1 192.168.11.53:4972

World.exe shows

Code:

[WORLD__LS] Connecting to login server...
[WORLD__LS] Setting World to MiniLogin Server type
[WORLD__LS] Connected to Loginserver: 192.168.11.53:5999
[WORLD__LS_ERR] Login server responded with FatalError. Disabling reconnect.
[WORLD__LS_ERR]      Incorrect version

I`ve ran in the loginserver.sql and configured the db.ini. Also ensuring that the its set to minilogin in the variables DB.

Any help would be great.

Thanks

War

Angelox · #43 03-28-2009, 10:59 AM

Quote:

[WORLD__LS] Setting World to MiniLogin Server type

You gotta set it to Public, not MiniLogin (it's in Variables)

image · #44 03-28-2009, 11:10 AM

The MiniLogin type will work I think, it just seems to have more checks like the world version and such

Angelox · #45 03-28-2009, 11:21 AM

Quote:

Originally Posted by image

I can set the values to whatever I want for how many users/worlds can be used, this was just a number that was suggested to me.

World accounts can only connect as one otherwise they get ghosted, it will limit to 3.

Secrets says this works for Titanium and SoF.

Anyway I'm still unsure about this, but what I'm looking for in this new mini-login, is unlimited user/player accounts. the reason for this is I already have hundreds of users for the AX_CLASSIC Server Repack (probably still have people that use my older MiniLogin package too), and they already have their characters and accounts made (the REPACK updates characters to newer versions of DB). My test server, which I don't promote and use at home, has 126 accounts - I need to protect those too, as I see people playing there.

I would even be willing to trade this feature off with only one game server able to connect LS. I would still greatly benefit because it has a true account system that doesn't require the old ip system

Three game servers hooked up to the LS would be nice, I could bring back my old ax_peq , and even some other old DB i was thinking of resurrecting.

Unlimited would be even nicer , all us "Minilogin" people could hook up with each other if we wanted.

But it's not needed - a true account system that doesn't require the old ip system is what I need, I think this wouldn't burst anybody's bubble.