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";