Donations

[jeanz11]

I need some help i have a donation system up the money goes to my paypal but the items arent delivered to the players ingame am i missing a mailbox table in the donations database?
I followed a guide for AAPDRDS and everything works but it wont send the player the item in the mailbox please help!!!!

[jeanz11]

anyone able to help?

[gravestalker]

Do you have the correct tables and did you insert the code into the sql database?

[volitle]

have you got the right item ids in there?

[jeanz11]

yes and yes I inserted the code

CREATE TABLE `log` (
`entry` int(10) unsigned NOT NULL auto_increment,
`email` varchar(32) default NULL,
`txn_id` varchar(32) default NULL,
`date` datetime default NULL,
`status` varchar(16) default NULL,
`amount` float unsigned default NULL,
`info` blob,
PRIMARY KEY (`entry`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;
CREATE TABLE `realms` (
`entry` int(10) unsigned NOT NULL auto_increment,
`name` varchar(32) default NULL,
`sqlhost` varchar(32) default NULL,
`sqluser` varchar(32) default NULL,
`sqlpass` varchar(32) default NULL,
`chardb` varchar(32) default NULL,
PRIMARY KEY (`entry`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
CREATE TABLE `rewards` (
`entry` int(10) unsigned NOT NULL auto_increment,
`name` varchar(32) default NULL,
`realm` int(10) unsigned default NULL,
`description` text,
`item1` int(10) unsigned default NULL,
`quantity1` tinyint(3) unsigned default NULL,
`item2` int(10) unsigned default NULL,
`quantity2` tinyint(3) unsigned default NULL,
`item3` int(10) unsigned default NULL,
`quantity3` tinyint(3) unsigned default NULL,
`gold` int(10) unsigned default NULL,
`price` float unsigned default NULL,
PRIMARY KEY (`entry`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;

[jeanz11]

stil ldoesnt work

[jeanz11]

need help!