function AdkContactWrite()
{
global $txt, $context, $scripturl, $adkportal, $sourcedir, $smcFunc;
$context['page_title'] = $txt['adkmod_modules_contacto'] . ' - ' . $context['forum_name'];
$context['sub_template'] = 'adk_contact';
$context['html_headers'] .= getCss('modules');
setLinktree('contact', 'adkmod_modules_contacto');
if (empty($adkportal['adk_enable_contact'])) {
fatal_lang_error('adkfatal_shout_now_allowed', false);
}
//get visual verification
getVisualverification();
//Select admin of the site
$sql = $smcFunc['db_query']('', '
SELECT id_member, real_name
FROM {db_prefix}members
WHERE id_group = {int:admin}
ORDER BY id_member ASC', array('admin' => 1));
$members = array();
while ($row = $smcFunc['db_fetch_assoc']($sql)) {
$members[$row['id_member']] = $row['real_name'];
}
$context['members_admin'] = $members;
$smcFunc['db_free_result']($sql);
}
function AdkSearchDownloads2()
{
global $smcFunc, $txt, $context, $scripturl, $user_info, $adkportal;
checkSession('post');
setLinktree('downloads', 'adkdown_downloads');
setLinktree('downloads;sa=search', 'adkdown_search');
$body = CleanAdkStrings($_POST['search']);
//Set the permissions
$allowed_to_manage = allowedTo('adk_downloads_manage') ? 1 : 0;
$sql = $smcFunc['db_query']('', '
SELECT
d.id_file, d.title, d.id_member, m.id_member, m.real_name, d.lastdownload, d.totaldownloads, d.date, d.views
FROM {db_prefix}adk_down_file AS d
LEFT JOIN {db_prefix}members AS m ON (m.id_member = d.id_member)
LEFT JOIN {db_prefix}adk_down_cat AS c ON (c.id_cat = d.id_cat)
WHERE (d.title LIKE "%' . $body . '%" OR d.description LIKE "%' . $body . '%")
AND ' . $adkportal['query_downloads'], array('a' => 1, 'member' => $user_info['id']));
$context['downloads'] = array();
while ($row = $smcFunc['db_fetch_assoc']($sql)) {
$context['downloads'][] = array('id' => $row['id_file'], 'title' => $row['title'], 'id_member' => $row['id_member'], 'name' => $row['real_name'], 'date' => timeformat($row['date'], '%d/%m/%Y (%I:%M:%S %p)'), 'lastd' => !empty($row['lastdownload']) ? timeformat($row['lastdownload'], '%d/%m/%Y (%I:%M:%S %p)') : $txt['adkdown_never'], 'totald' => $row['totaldownloads'], 'viewsd' => $row['views']);
}
$smcFunc['db_free_result']($sql);
if (count($context['downloads']) == 1) {
foreach ($context['downloads'] as $id2) {
$id = $id2['id'];
}
//redirect to the only download avaiable
redirectexit('action=downloads;sa=view;down=' . $id);
} elseif (count($context['downloads']) == 0) {
$context['sub_template'] = 'adk_search_not';
$context['page_title'] = $txt['adkdown_search'];
} else {
$context['sub_template'] = 'adk_search_results';
$context['page_title'] = $txt['adkdown_search'] . ': ' . $body;
}
}
function CheckCatParent($id_cat)
{
global $smcFunc, $scripturl, $context;
/***
* Load all links trees... when id_parent != 0
***/
if ($id_cat != 0) {
$sql = $smcFunc['db_query']('', '
SELECT id_parent, title FROM {db_prefix}adk_down_cat
WHERE id_cat = {int:cat}', array('cat' => $id_cat));
$row = $smcFunc['db_fetch_assoc']($sql);
$smcFunc['db_free_result']($sql);
//Again?
CheckCatParent($row['id_parent']);
setLinktree('downloads;cat=' . $id_cat, $row['title'], false, true);
}
}
