I still get the same error. It is either I understand you incorrectly. Please be specific, because I'm not a coder like you
Code:
$ticketfetch = $DB_site->query("
SELECT
rpg_lottery_tickets.*,
rpg_lottery.*,
user.username,
user.userid
FROM
`" . TABLE_PREFIX . "rpg_lottery` AS `rpg_lottery`
LEFT JOIN `" . TABLE_PREFIX . "rpg_lottery_tickets` AS `rpg_lottery_tickets` ON(rpg_lottery_tickets.lotteryid = rpg_lottery.lotteryid)
LEFT JOIN `" . TABLE_PREFIX . "user` AS `user` ON(user.userid = rpg_lottery_tickets.userid)
WHERE rpg_lottery.lotteryid = '$lottery[lotteryid]'
ORDER BY RAND() LIMIT 1
");
$lotteryinfo = $DB_site->fetch_array($ticketfetch);
$tickets = count($lotteryinfo);
if ($tickets == 0)
{
define('CP_REDIRECT', 'lotteryadmin.php?do=edit');
print_stop_message('rpg_lottery_ticket_error');
}
// #########################
$sub = 'Lottery Winner!';
$message = "Hi, $lottery[username]
You've won '$lotteryinfo[lotteryname]' lottery!
$lottery[prize] $vboptions[rpg_currency] has been added to your pocket!";
// ##########################
process_rpg_pm($lotteryinfo['userid'], $lotteryinfo['username'], $bbuserinfo['userid'], $bbuserinfo['username'], $sub, $message);
$DB_site->query("UPDATE " . TABLE_PREFIX . "user SET $vboptions[rpg_pointfield] = $vboptions[rpg_pointfield] + $lotteryinfo[prize] WHERE userid=$lotteryinfo[userid]");
$DB_site->query("DELETE FROM " . TABLE_PREFIX . "rpg_lottery WHERE lotteryid = '$lotteryinfo[lotteryid]'");
$DB_site->query("DELETE FROM " . TABLE_PREFIX . "rpg_lottery_tickets WHERE lotteryid = '$lotteryinfo[lotteryid]'");