Search found 501 matches

Go to advanced search

by GamePlayHeaven
Tue Jun 15, 2010 14:22
Forum: EQRoster
Topic: EQRoster v4.4.0 Released (HP/Mana/Endurance fix)
Replies: 24
Views: 11483

Re: EQRoster v4.4.0 Released (HP/Mana/Endurance fix)

I'll take a look at it tomorow
by GamePlayHeaven
Mon Jun 14, 2010 22:41
Forum: EQRoster
Topic: EQRoster v4.4.0 Released (HP/Mana/Endurance fix)
Replies: 24
Views: 11483

Re: EQRoster v4.4.0 Released (HP/Mana/Endurance fix)

A buddy told me that he avoids date fields like the plague in mySQL, since he has seen lots of problems with them over time in PHP apps he wrote. He adviced me to use a datetime field instead. The good thing about a datetime field is that it's basically just a large number (the amount of millisecond...
by GamePlayHeaven
Mon Jun 14, 2010 9:14
Forum: EQRoster
Topic: EQRoster v4.4.0 Released (HP/Mana/Endurance fix)
Replies: 24
Views: 11483

Re: EQRoster v4.4.0 Released (HP/Mana/Endurance fix)

Should work fine with the v4.4.1 release.
by GamePlayHeaven
Mon Jun 14, 2010 7:20
Forum: EQRoster
Topic: EQRoster v4.4.0 Released (HP/Mana/Endurance fix)
Replies: 24
Views: 11483

Re: EQRoster v4.4.0 Released (HP/Mana/Endurance fix)

v4.4.1 has been uploaded.
by GamePlayHeaven
Mon Jun 14, 2010 7:19
Forum: EQRoster
Topic: EQRoster v4.4.0 Released (HP/Mana/Endurance fix)
Replies: 24
Views: 11483

Re: EQRoster v4.4.0 Released (HP/Mana/Endurance fix)

Oh btw Lukeren, could you either run the database update script, or manually change the HP, MANA and Endurance fields in the Characters database table to mediumint (instead of smallint)? I just noticed that this wasn't updated correctly in the version of the database creation script for a clean rost...
by GamePlayHeaven
Mon Jun 14, 2010 7:15
Forum: EQRoster
Topic: EQRoster v4.4.1 Released (Guild Dump & Magelo import fix)
Replies: 0
Views: 18664

EQRoster v4.4.1 Released (Guild Dump & Magelo import fix)

Version 4.4.1 of the EverQuest roster is on the downloads page. The following additions/fixes have been made: Updated the Magelo import to support the current Magelo format. This includes GLPs, Endurance, TradeSkills, Keys and some flags. Note: Most flags remain non-working for now, as the magelo fo...
by GamePlayHeaven
Mon Jun 14, 2010 7:15
Forum: EQRoster
Topic: EQRoster v4.4.0 Released (HP/Mana/Endurance fix)
Replies: 24
Views: 11483

Re: EQRoster v4.4.0 Released (HP/Mana/Endurance fix)

The date format in the guild dump posted is: 12/21/05 aka MM/DD/YY, exactly what the roster expects. This date is then changed into the database date format YYYY-MM-DD. I can't see what would go wrong here, except if your database date format is different from YYYY-MM-DD. Could that be why you have ...
by GamePlayHeaven
Sat Jun 12, 2010 15:22
Forum: EQRoster
Topic: EQRoster v4.4.0 Released (HP/Mana/Endurance fix)
Replies: 24
Views: 11483

Re: EQRoster v4.4.0 Released (HP/Mana/Endurance fix)

If you mail me a current guild dump, I'll fix the roster import for you.
by GamePlayHeaven
Fri Jun 11, 2010 14:27
Forum: EQRoster
Topic: EQRoster v4.4.0 Released (HP/Mana/Endurance fix)
Replies: 24
Views: 11483

Re: EQRoster v4.4.0 Released (HP/Mana/Endurance fix)

Yeah, magelo doesn't like it when you perform data mining on their ip ;) That's why the warning is in there.

That was years and years ago, so they might be less picky about it nowadays.
by GamePlayHeaven
Fri Jun 11, 2010 0:00
Forum: EQRoster
Topic: EQRoster v4.4.0 Released (HP/Mana/Endurance fix)
Replies: 24
Views: 11483

Re: EQRoster v4.4.0 Released (HP/Mana/Endurance fix)

I believe there is a delay on purpose between each magelo import, to prevent magelo from blocking your IP.

I don't recall if this delay was configurable in the config file (it's been a while since I wrote it all), but I will take a look at that as well.

Regards,
Michaël
by GamePlayHeaven
Thu Jun 10, 2010 14:34
Forum: EQRoster
Topic: EQRoster v4.4.0 Released (HP/Mana/Endurance fix)
Replies: 24
Views: 11483

Re: EQRoster v4.4.0 Released (HP/Mana/Endurance fix)

I never really looked into this, but it should be doable. I'm guessing you can call a url you want to run each night from your server? If so, all you need is a magelo import script that runs without any user input. I can definately build the later. On a sidenote: Since I haven't played EQ in years, ...
by GamePlayHeaven
Mon Jun 07, 2010 5:40
Forum: EQRoster
Topic: EQRoster v4.4.0 Released (HP/Mana/Endurance fix)
Replies: 24
Views: 11483

EQRoster v4.4.0 Released (HP/Mana/Endurance fix)

Version 4.4.0 of the EverQuest roster is on the downloads page. The following additions/fixes have been made: Fixed a bug where HP, Mana and Endurance where cut of at 32767. The database wasn't prepared for the large values you can now achieve for these variables in Everquest. Widened the HP, Mana a...
by GamePlayHeaven
Mon Jun 07, 2010 4:31
Forum: EQRoster
Topic: Max numbers
Replies: 2
Views: 2905

Re: Max numbers

The following update should fix the problem: - Open the roster database in your MySQL maintenance tool (for example phpMyAdmin) - Select the characters database - Change the following fields from smallint(5) to mediumint(5) HP Mana Endurance That should fix it. Alternatively, an update will be relea...
by GamePlayHeaven
Sat Jun 05, 2010 23:34
Forum: EQRoster
Topic: Max numbers
Replies: 2
Views: 2905

Re: Max numbers

My first guess is the type of database field. Those are probable integers, and have to be upgraded to something higher.
I will take a look at it next week and post an upgrade.

Go to advanced search

cron