Small Fix for people using the xp_statistics_v1.1.zip on 3.x

Read log files for errors! If this fails, come here for help

Moderator: Forum Moderator

Post Reply
fang-gaming
Peon
Posts: 2
Joined: Wed Feb 28, 2007 3:04 am

Small Fix for people using the xp_statistics_v1.1.zip on 3.x

Post by fang-gaming » Wed Feb 28, 2007 3:20 am

Some people might have noticed their xp stat pages have messed up.

like this chap viewtopic.php?t=2588

Now I know there is talk that the 3.x db structure may change completly but for now this will work.

What happens is when you connect wc3ft 3.x to your 2.3.2 database it adds an extra column into the database moving all your information one along.

to fix this modify your functions.inc.php file at lines 4 - 11 from this

Code: Select all

define("PLAYER_ID", 0);
define("PLAYER_NAME", 1);
define("XP", 2);
define("RACE", 3);
define("SKILL1", 4);
define("SKILL2", 5);
define("SKILL3", 6);
define("SKILL4", 7);
to this

Code: Select all

define("PLAYER_ID", 0);
define("PLAYER_IP", 1);
define("PLAYER_NAME", 2);
define("XP", 3);
define("RACE", 4);
define("SKILL1", 5);
define("SKILL2", 6);
define("SKILL3", 7);
define("SKILL4", 8);
and that should do it. works for ours http://www.fang-gaming.co.uk/xp/
Attachments
functions.inc.zip
Or just use this file if you are unsure about copy and pasting :P
(2.38 KiB) Downloaded 339 times
217.146.89.33:27015 WC3FT+savedXP #FaNg on quakenet.. www.fang-gaming.co.uk

217.146.89.37:27015 GUNGAME #FaNg on quakenet. www.fang-gaming.co.uk

User avatar
YamiKaitou
Forum Moderator
Forum Moderator
Posts: 1925
Joined: Wed Feb 01, 2006 4:33 pm
Contact:

Post by YamiKaitou » Wed Feb 28, 2007 7:57 am

Well, for RC6, there will be a completely new database table structure. So this will only work for RC5 and down
Image

No support via PM or Email

DesasterUK
WC3Mods Donor
WC3Mods Donor
Posts: 223
Joined: Thu Mar 09, 2006 6:05 pm
Location: Germany
Contact:

Post by DesasterUK » Wed Feb 28, 2007 8:34 am

Allready posted here:
viewtopic.php?t=2324
Image

User avatar
Geesu
<b>King of the world!</b>
Posts: 3159
Joined: Tue Jul 05, 2005 9:24 pm
Contact:

Post by Geesu » Wed Feb 28, 2007 12:17 pm

I'm working on a new version for 3.x - don't waste time on adapting to the new structure
No Support via PM

fang-gaming
Peon
Posts: 2
Joined: Wed Feb 28, 2007 3:04 am

Post by fang-gaming » Fri Mar 02, 2007 3:58 am

YamiKaitou wrote:Well, for RC6, there will be a completely new database table structure. So this will only work for RC5 and down
fang-gaming wrote: Now I know there is talk that the 3.x db structure may change completly but for now this will work.
I did mention that is was going to completly change and I just though some people (like us) who connected a 3.x server to their xp db but still use 2.3.2 might find this useful ;)
217.146.89.33:27015 WC3FT+savedXP #FaNg on quakenet.. www.fang-gaming.co.uk

217.146.89.37:27015 GUNGAME #FaNg on quakenet. www.fang-gaming.co.uk

User avatar
YamiKaitou
Forum Moderator
Forum Moderator
Posts: 1925
Joined: Wed Feb 01, 2006 4:33 pm
Contact:

Post by YamiKaitou » Fri Mar 02, 2007 7:32 am

But, like DesasterUK said, this has already been posted maybe twice now
Image

No support via PM or Email

Post Reply