[ArnyVee]

Originally Posted by imported_silkroad

FWIW, Added new field winnumber to MySQL table credits_lottery to record winning number after each lottery. Code mod below:

# diff credits_daily.php credits_daily.php.back2
183c183
<                       $vbulletin->db->query_write("UPDATE " . TABLE_PREFIX . "credits_lottery SET active = 0, winner = '" . $vbulletin->db->escape_string(serialize($winners)) . "', winnumber = $winnumber WHERE lotteryid = " . $lottery['lotteryid']);
---
>                       $vbulletin->db->query_write("UPDATE " . TABLE_PREFIX . "credits_lottery SET active = 0, winner = '" . $vbulletin->db->escape_string(serialize($winners)) . "' WHERE lotteryid = " . $lottery['lotteryid']);

If it works (hope so!), will mod template to show winning number in last lottery, which is missing now.

Originally Posted by Darkwaltz4

that looks like it should work, and easy to pull out when listing finished drawings

Wow, if this works, please share!