echo "</tr>";
$result = dbquery("SELECT t.forum_id, t.thread_id, t.thread_author, t.thread_subject, a.addon_name, a.addon_submitter_name \r\n FROM " . DB_THREADS . " t \r\n LEFT JOIN " . DB_ADDONS . " a \r\n ON t.thread_author=a.addon_submitter_name\r\n WHERE t.thread_subject ='" . $d_addons['addon_name'] . "'\r\n AND (t.forum_id = '77' OR t.forum_id = '78' OR t.forum_id = '79' OR t.forum_id = '80')\r\n ORDER BY thread_id DESC LIMIT 1\r\n ");
if (dbrows($result) != 0) {
echo "<tr><td class='tbl2' width='12%' nowrap><b>" . $locale['addondb429'] . "</b></td>";
echo "<td class='tbl2' colspan='3'>";
while ($data = dbarray($result)) {
echo "<a href='" . BASEDIR . "forum/viewthread.php?thread_id=" . $data['thread_id'] . "' class='button'><span>" . $data['thread_subject'] . "</span></a>";
}
echo "</td></tr>";
}
echo "<tr>\r\n\t\t<td class='tbl2' width='12%' nowrap><b>" . $locale['addondb427'] . "</b></td>\r\n\t\t<td class='tbl1' width='*'>";
$trans = "";
$result1 = dbquery("SELECT * FROM " . DB_ADDON_TRANS . " WHERE trans_mod='" . $d_addons['addon_id'] . "' ORDER BY trans_type ASC");
if (dbrows($result1)) {
while ($data1 = dbarray($result1)) {
$trans .= "<a href='" . $trans_upload_dir . $data1['trans_file'] . "' target='_BLANK'>" . get_addon_language($data1['trans_type']) . "</a>, ";
}
} else {
$trans = $locale['addondb511'];
}
echo "{$trans}</td>\r\n\t\t<td class='tbl2' width='12%' nowrap><b>" . $locale['addondb428'] . "</b></td>\r\n\t\t<td class='tbl1' width='20%'>";
if (iMEMBER) {
echo "<img src='" . ADDON_IMG . "error.png' border='0' alt='" . $locale['addondb503'] . "' /> \r\n\t\t<a href ='" . ADDON . "error.php?error=1&addon_id=" . $d_addons['addon_id'] . "' title='" . $locale['addondb503'] . "' class='button'><span>" . $locale['addondb503'] . "</span></a><br /><br />\r\n\t\t<img src='" . ADDON_IMG . "translate.png' border='0' alt='" . $locale['addondb506'] . "' /> \r\n\t\t<a href ='" . ADDON . "error.php?error=4&addon_id=" . $d_addons['addon_id'] . "' title='" . $locale['addondb506'] . "' class='button'><span>" . $locale['addondb506'] . "</span></a>\n";
} else {
echo $locale['addondb438'];
}
echo "</td>\r\n\t\t</tr>\t\r\n\t\t";
if (checkrights("ADNX")) {
if ($d_addons['addon_status'] != 3) {
$suspended = " | <a href='admin/index.php" . $aidlink . "&action=suspend&addon_id=" . $d_addons['addon_id'] . "' class='button'><span>" . $locate['addondb425'] . "</span></a>";
} else {
$result = dbquery("UPDATE " . DB_ADDON_TRANS . " SET\r\n trans_active = '0',\r\n trans_type = '" . stripinput($_POST['lang']) . "',\r\n trans_approved_user = '******'trans_approved_user']) . "',\r\n trans_approved_comment = '" . stripinput($_POST['trans_approved_comment']) . "' \r\n WHERE trans_id = '" . $_GET['trans_id'] . "'\r\n ");
$pm_user = dbarray(dbquery("SELECT trans_user FROM " . DB_ADDON_TRANS . " WHERE trans_id='" . $_GET['trans_id'] . "'"));
$sendpm = send_pm($pm_user['trans_user'], $userdata['user_id'], $locale['addondb501'], $_POST['trans_approved_comment']);
} elseif ($_POST['trans_status'] == 2) {
@unlink($trans_upload_dir . $data1['trans_file']);
$pm_user = dbarray(dbquery("SELECT trans_user FROM " . DB_ADDON_TRANS . " WHERE trans_id='" . $_GET['trans_id'] . "'"));
$sendpm = send_pm($pm_user['trans_user'], $userdata['user_id'], $locale['addondb501'], $_POST['trans_approved_comment']);
$result = dbquery("DELETE FROM " . DB_ADDON_TRANS . " WHERE trans_id='" . $_GET['trans_id'] . "'");
}
} elseif (isset($_GET['trans_id']) && isnum($_GET['trans_id'])) {
$result = dbquery("SELECT * FROM " . DB_ADDON_TRANS . " WHERE trans_id='" . $_GET['trans_id'] . "' ");
while ($data = dbarray($result)) {
$trans_approved_user_list = builduseroptionlist("");
$lang = "";
for ($i = 1; $i <= get_addon_language(0); $i++) {
$lang .= "<option value='" . $i . "'" . ($data['trans_type'] == $i ? " selected" : "") . ">" . get_addon_language($i) . "</option>\n";
}
$trans_user = dbarray(dbquery("SELECT \r\n\t\t\t user_id, \r\n\t\t\t user_name, \r\n\t\t\t user_status \r\n\t\t\t FROM " . DB_USERS . " \r\n\t\t\t WHERE user_id='" . $data['trans_user'] . "'\r\n\t\t\t "));
$trans_status = "";
opentable($locale['addondb449']);
echo "<form name='publish' method='post' action='" . FUSION_SELF . $aidlink . "&action=2&t=t&trans_id=" . $_GET['trans_id'] . "' enctype='multipart/form-data'>\n";
echo "<table cellpadding='0' cellspacing='0' class='center'>\n<tr>\n";
echo "<td class='tbl1' nowrap>" . $locale['addondb402'] . ":</td>\r\n\t\t\t<td class='tbl1'><input type='text' class='textbox' name='addon_name' value='" . $data['trans_modname'] . "' style='width:300px;' READONLY></td>\r\n\t\t\t</tr><tr>\r\n\t\t\t<td class='tbl1' nowrap>" . $locale['addondb456'] . ":</td>\r\n\t\t\t<td class='tbl1'><select class='textbox' name='lang' style='width:300px;'>" . $lang . "</select></td>\r\n\t\t\t</tr><tr>\r\n\t\t\t<td class='tbl1' nowrap>" . $locale['addondb412'] . ":</td>\r\n\t\t\t<td class='tbl1'><a href='" . $trans_upload_dir . $data['trans_file'] . "' class='button' target='_BLANK'><span>" . $data['trans_file'] . "</span></a></td>\r\n\t\t\t</tr><tr>\r\n\t\t\t<td class='tbl1' nowrap>" . $locale['addondb458'] . ":</td>\r\n\t\t\t<td class='tbl1'><span class='small'>\r\n\t\t\t<input type='hidden' class='textbox' name='trans_name' value='" . $data['trans_user'] . "'>" . profile_link($data['trans_user'], $trans_user['user_name'], $trans_user['user_status']) . "</td>\r\n\t\t\t</tr><tr>\r\n\t\t\t<td class='tbl1' nowrap>" . $locale['addondb442'] . ":</td>\r\n\t\t\t<td class='tbl1'>";
echo "<select name='trans_status' class='textbox' style='width:300px;'>\n";
echo "<option value='0'>" . $locale['addondb806'] . "</option>\n";
echo "<option value='1'>" . $locale['addondb807'] . "</option>\n";
echo "<option value='2'>" . $locale['addondb808'] . "</option>\n";
echo "</select>\n</td>\n";
echo "</tr><tr>\r\n\t\t\t<td class='tbl1' nowrap>" . $locale['addondb417'] . ":</td>\r\n\t\t\t<td class='tbl1'><input type='hidden' class='textbox' name='trans_approved_user' value='" . $userdata['user_id'] . "' style='width:300px;'>" . $userdata['user_name'] . "</td>\r\n\t\t\t</tr><tr>\r\n\t\t\t<td class='tbl1' nowrap valign='top'>" . $locale['addondb419'] . ":</td>\r\n\t\t\t<td class='tbl1'><textarea class='textbox' name='trans_approved_comment' style='width:300px; height:48px;'></textarea></td>";
echo "</tr>\n</table>\n";
echo "<div style='text-align:center'><br />\n";
