AAPDRDS Help

[sirspyro]

hey there, i'm trying to get the Donation panel on my site workings and i just can't seem to figure it out...

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in *******\index.php on line 35

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in ********\index.php on line 42

any ideas? i've gone through my database over and over again. everything is where it is supposed to be. the config file is pointing to the correct direction...

with this error, i can't select the realm or anything...

[sirspyro]

ok now i have no sql errors and it goes through all the motions. still a problem though. it doesn't mail the items properly...

	foreach($Items as $key => $value)
	{
		$ccon = mysql_connect($Realms[(int)$value['realm']]['sqlhost'],$Realms[(int)$value['realm']]['sqluser'],$Realms[(int)$value['realm']]['sqlpass'],true);
		mysql_select_db($Realms[(int)$value['realm']]['chardb'],$ccon);
		$REWARDNAME = mysql_real_escape_string($Rewards[$value['id']]['name'],$ccon);
		if((int)$Rewards[$value['id']]['item1'] > 0)
		{
			mysql_query("INSERT INTO mailbox_insert_queue VALUES ('{$value['character']}','{$value['character']}','".MAIL_SUBJECT."','".MAIL_BODY."','61','0','".$Rewards[(int)$value['id']]['item1']."','1')");
		}
		if((int)$Rewards[$value['id']]['item2'] > 0)
		{
			mysql_query("INSERT INTO mailbox_insert_queue VALUES ('{$value['character']}','{$value['character']}','".MAIL_SUBJECT."','".MAIL_BODY."','61','0','".$Rewards[(int)$value['id']]['item2']."','1')");
		}
		if((int)$Rewards[$value['id']]['item3'] > 0)
		{
			mysql_query("INSERT INTO mailbox_insert_queue VALUES ('{$value['character']}','{$value['character']}','".MAIL_SUBJECT."','".MAIL_BODY."','61','0','".$Rewards[(int)$value['id']]['item3']."','1')");
		}
		if((int)$Rewards[$value['id']]['gold'] > 0)
		{
			mysql_query("INSERT INTO mailbox_insert_queue VALUES ('{$value['character']}','{$value['character']}','".MAIL_SUBJECT."','".MAIL_BODY."','61','".$Rewards[$value['id']]['gold']."','0','0')");
		}
		mysql_close($ccon);
	}

i don't have a mailbox_insert_queue table. i do have two different tables, mail and mail_items.

neither of which follow the format that the code suggests. it seems to seperate the mail from the items in the mail, and it also doesn't use the character's name, but uses the character's id. i'm so very confused. any ideas on how to resolve this?

im using Reaper-X Trinity Core 595

[B14d3r11]

That Donation page was meant for Ascent or Ascent based Emulators. Idk what you use but yea...

[sirspyro]

yeah im using trinity core, was hoping i could alter it someway...

[Lytle69]

I have this same Issue and I'm Using Arcemu.
I'd like to bump this so maybe ppl will look into this and update it.

[Algorithm]

AAPDRDS fix