Upgrade from eqDKP Errors

[Michad]

Upgrade from eqDKP to nDKP

Please wait while we upgrade...

Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in /home/michfan/public_html/ndkp/installation/upgrade_script.php on line 158

Player table has been populated ... Adding raids.
Please note: After the upgrade you will need to login to nDKP administration and edit each raid to verify that bosses and dungeons are inserted correctly. Failure to do so, may affect how nDKP displays your raid history.

Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in /home/michfan/public_html/ndkp/installation/upgrade_script.php on line 184

nDKP raids Updated.

Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in /home/michfan/public_html/ndkp/installation/upgrade_script.php on line 242

NDKP has created Administrator access...

Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in /home/michfan/public_html/ndkp/installation/upgrade_script.php on line 141

Warning: array_unique(): The argument should be an array in /home/michfan/public_html/ndkp/installation/upgrade_script.php on line 117

NDKP Attendance is recorded daily and not by boss kills therefore Attendance is recorded seperately. NDKP has updated your daily attendance

Any ideas?

Using the following:

PHP version 4.3.11
MySQL version 4.1.13-standard

[Michad]

Ok found out the error. My tables are named wowdkp_ rather than eqdkp_ so i had to go into the upgrade_script.php and modify all those lines to reflect as such.

After doing that i ran into another problem:


Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in /home/michfan/public_html/ndkp/installation/upgrade_script.php on line 158

What im seeing on this line is this:


$sql = mysql_query("select member_name, member_class from wowdkp_members");

Now member_name exists as a table in that respective table but the newest EQDKP uses a seperate wowdkp_classes table and corresponds it with member_class_id.

Any suggestions on how to modify this query to install correctly?

[Michad]

Here are the table setups if you need any additional info:


DROP TABLE IF EXISTS eqdkp_members;
CREATE TABLE `eqdkp_members` (
`member_id` smallint(5) unsigned NOT NULL auto_increment,
`member_name` varchar(30) NOT NULL UNIQUE,
`member_earned` float(11,2) NOT NULL default '0.00',
`member_spent` float(11,2) NOT NULL default '0.00',
`member_adjustment` float(11,2) NOT NULL default '0.00',
`member_status` ENUM('0','1') NOT NULL default '1',
`member_firstraid` int(11) NOT NULL default '0',
`member_lastraid` int(11) NOT NULL default '0',
`member_raidcount` int(11) NOT NULL default '0',
`member_level` tinyint(2),
`member_race_id` smallint(3) unsigned NOT NULL default '0',
`member_class_id` smallint(3) unsigned NOT NULL default '0',
`member_rank_id` smallint(3) NOT NULL default '0',
PRIMARY KEY (`member_id`)
)TYPE=InnoDB;

DROP TABLE IF EXISTS eqdkp_classes;
CREATE TABLE `eqdkp_classes` (
`c_index` smallint(3) unsigned NOT NULL auto_increment,
`class_id` smallint(3) unsigned NOT NULL,
`class_name` varchar(50) NOT NULL,
`class_min_level` smallint(3) NOT NULL DEFAULT '0',
`class_max_level` smallint(3) NOT NULL DEFAULT '999',
`class_armor_type` varchar(50) NOT NULL,
`class_hide` enum('0','1') NOT NULL DEFAULT '0',
PRIMARY KEY (`c_index`)
)TYPE=InnoDB;

[Tivoli]

it probably needs to be changed to
read below ^^.

[Asia]

I would need to rewrite a script for that eqdkp. because eqdkp is now recording class_id

In line 158 of upgrade_script.php change the current SQL query

$sql = mysql_query("select member_name, member_class from wowdkp_members");

to the following:

$sql = mysql_query("select member_name, class_name from eqdkp_members left join eqdkp_classes on class_id=member_class_id");

Change eqdkp_classes to wowdkp_classes or whaever the name is.

[Michad]

I would need to rewrite a script for that eqdkp. because eqdkp is now recording class_id



In line 158 of upgrade_script.php change the current SQL query

$sql = mysql_query("select member_name, member_class from wowdkp_members");

to the following:

$sql = mysql_query("select member_name, class_name from eqdkp_members left join eqdkp_classes on class_id=member_class_id");

Change eqdkp_classes to wowdkp_classes or whaever the name is.

Yeah used that but the classes dont seem to be populating properly.

Go to www.bbcguild.com/ndkp/ and youll see that the class structure is completely wacked out. For example shamans dont show up on the list and none of the others are populated.

[Asia]

OMG you got it working all but the classes!!!!! That's looks so sweet :D

hmmm... I will write a script for you to edit those at once but has to wait until tomorrow :( or later this evening.

[Michad]

Yes so far im very pleased with this program. Great work guys.

[Asia]

Yes so far im very pleased with this program. Great work guys.

How the heck did you get 128% attendance? lol
I wanna know this secret right now!

can i get the URL of your eqdkp too? I want to compare it.. Nurfed's eqdkp was old so I didn't have any current numbers to compare when alcaras did this code.

[Michad]

www.bbcguild.com/wowdkp/

Take note that in the transfer our Azuregos and Kazzak raids didnt populate and are blank but i dunno if that affects it.

[Asia]

www.bbcguild.com/wowdkp/

Take note that in the transfer our Azuregos and Kazzak raids didnt populate and are blank but i dunno if that affects it.

hmm...

I'll work on another update script for eqdkp by the weekend. Looks like a lot didn't move over.

[Jaguar645]

Yes so far im very pleased with this program. Great work guys.

How the heck did you get 128% attendance? lol
I wanna know this secret right now!

can i get the URL of your eqdkp too? I want to compare it.. Nurfed's eqdkp was old so I didn't have any current numbers to compare when alcaras did this code.'


Hell you think 128% is high? check it out on our test server ;)

http://oizopower.nl/~chrno/ndkp/

If you want i can supply you our EqDKP database which is built by EQdkp 1.3.0.

Drop me an e-mail/pm if you need it :)

[Asia]

yes, could you send me the info? lani@psymple.com I would appreciate that a lot :)

[Jaguar645]

You my sir should check your inbox soon for mail ^^

[Michad]

If you need my database too id be more than glad to send it your way.

[Asia]

If you need my database too id be more than glad to send it your way.

This would be great if you could email it to me lani@psymple.com
Could you deselect the following options when you dump the sql

Enclose table and field names with backquotes
This has to be unchecked!

The EqDKP upgrade is all I need right now

[Michad]

Sent

[Michad]

You still need anything for this Asia?