is_valid($ecard_id)) { $query = 'SELECT * FROM '.ECARD_TABLE.' WHERE numero = "'.$ecard_id.'";'; $result = pwg_query($query); $result_array = pwg_db_fetch_assoc($result); if (isset($result_array['numero'])) { //Recover img infos. $query = 'SELECT DISTINCT * FROM '.IMAGES_TABLE.' AS img WHERE img.id = '.$result_array['image'].';'; $result = pwg_query($query); $row = pwg_db_fetch_assoc($result); set_make_full_url(); $url = duplicate_picture_url( array( 'image_id' => $row['id'], 'image_file' => $row['file'] ), array('start') ); unset_make_full_url(); //Assign variables to template $template->assign('ecard', array( 'subject' => $result_array['sujet'], 'image' => $result_array['image'], 'message' => $result_array['message'], 'url' => $url, 'name' => $row['name'], 'image' => DerivativeImage::url(IMG_LARGE, $row), 'sender_email' => $result_array['adrexp'], 'sender_name' => $result_array['nomexp'], 'image_title' => $ecard->my_config['ecard_showinfos'] ? $row['name'] : null, 'image_author' => $ecard->my_config['ecard_showinfos'] ? $row['author'] : null )); } } $template->set_filenames(array('ecard_result' => ECARD_ROOT.'/template/publish.tpl')); $template->concat('PLUGIN_INDEX_CONTENT_BEGIN', $template->parse('ecard_result', true)); $template->clear_assign(array('U_MODE_POSTED', 'U_MODE_CREATED')); ?>