From f68903ec234fe7d76cddbbaa99fb0096d329582c Mon Sep 17 00:00:00 2001 From: vdigital Date: Mon, 8 Jan 2007 20:52:58 +0000 Subject: Minor corrections in admin advices (French is still on going). git-svn-id: http://piwigo.org/svn/trunk@1702 68402e56-0260-453c-a942-63ccdbb3a9ee --- plugins/admin_advices/main.inc.php | 22 ++++++++++++++++++++++ 1 file changed, 22 insertions(+) (limited to 'plugins/admin_advices/main.inc.php') diff --git a/plugins/admin_advices/main.inc.php b/plugins/admin_advices/main.inc.php index 5af0b8f9a..a17f5a658 100644 --- a/plugins/admin_advices/main.inc.php +++ b/plugins/admin_advices/main.inc.php @@ -1,5 +1,6 @@ PHPWG_ROOT_PATH.'/plugins/admin_advices/admin_advices.tpl') ); + +// Random Thumbnail + $query = ' +SELECT * + FROM '.IMAGES_TABLE.' + ORDER BY RAND(NOW()) + LIMIT 0, 1 +;'; + $result = pwg_query($query); + $row = mysql_fetch_assoc($result); + if ( is_array($row) ) + { + $template->assign_block_vars( + 'thumbnail', + array( + 'IMAGE' => get_thumbnail_url($row), + 'IMAGE_ALT' => $row['file'], + 'IMAGE_TITLE' => $row['name'], + ) + ); + } $advice_text = array_shift($adv); $template->assign_vars( array( -- cgit v1.2.3