function addCheckboxes($name, $desc, $table, $linking_table = false, $table_col = false, $link_col = false, $id = false, $admin = false) { global $rows; $rows .= '<tr'; if ($admin) { $rows .= ' class="admin"'; } //special exceptions (this is terrible) if ($table == "modules") { $description = "name"; } elseif ($table == 'skills') { $description = 'title'; } else { $description = "description"; } $rows .= '> <td class="left">' . $desc . '</td> <td>'; if ($id) { $result = db_query("SELECT \n\t\t\t\t\t\t\tt.id, \n\t\t\t\t\t\t\tt.{$description} description, \n\t\t\t\t\t\t\t(SELECT COUNT(*) FROM {$linking_table} l WHERE l.{$table_col} = {$id} AND l.{$link_col} = t.id) checked\n\t\t\t\t\t\tFROM {$table} t\n\t\t\t\t\t\tWHERE t.isActive = 1\n\t\t\t\t\t\tORDER BY t.{$description}"); } else { $result = db_query("SELECT id, {$description} description, 0 checked FROM {$table} WHERE isActive = 1 ORDER BY {$description}"); } if ($total = db_found($result)) { $counter = 0; $max = ceil($total / 3); $rows .= '<table class="nospacing" width="100%"><tr>'; while ($r = db_fetch($result)) { if ($counter == 0) { $rows .= '<td width="33%" style="vertical-align:top;"><table class="nospacing">'; } $chkname = "chk_" . $name . "_" . $r["id"]; $rows .= ' <tr> <td>' . draw_form_checkbox($chkname, $r["checked"]) . '</td> <td>' . drawCheckboxText($chkname, $r["description"]) . '</td> </tr>'; if ($counter == $max - 1) { $rows .= '</table></td>'; $counter = 0; } else { $counter++; } } if ($counter != 0) { $rows .= '</table></td>'; } $rows .= '</tr></table>'; } $rows .= ' </td> </tr>'; }
function drawThreadCommentForm($showAdmin = false) { global $page, $_josh, $_SESSION; $name = $_josh['request']['folder'] == 'bb' ? 'description' : 'message'; $return = '<a name="bottom"></a><form '; if ($_josh['db']['language'] == 'mysql') { $return .= 'accept-charset="utf-8" '; } $return .= 'method="post" action="' . $_josh['request']['path_query'] . '" onsubmit="javascript:return validate(this);"><tr valign="top"> <td class="left">' . drawName($_SESSION['user_id'], $_SESSION['full_name'], false, true, false) . '</td> <td>' . draw_form_textarea($name . langExt(), '', 'mceEditor thread'); if ($showAdmin && $page['is_admin']) { $return .= ' <table class="nospacing"> <tr> <td width="16">' . draw_form_checkbox('is_admin') . '</td> <td>' . drawCheckboxText('is_admin', 'This followup is admin-only (invisible to most users)') . '</td> </tr> </table>'; } $return .= ' </td> </tr> <tr> <td class="bottom" colspan="2">' . draw_form_submit(getString('add_followup')) . '</td> </tr> </form>'; return $return; }
function addCheckboxes($name, $desc, $table, $linking_table = false, $table_col = false, $link_col = false, $id = false, $admin = false) { global $rows; $rows .= '<tr'; if ($admin) { $rows .= ' class="admin"'; } $title = "title"; $checked = 0; //special addition for permissions $where = $name == "permissions" ? " AND l.is_admin = 1" : ""; //special exception for channels table if ($table == "channels") { $title = "title" . langExt(); $checked = 1; } $rows .= '> <td class="left">' . $desc . '</td> <td>'; if ($id) { $result = db_query("SELECT \n\t\t\t\t\t\tt.id, \n\t\t\t\t\t\tt.{$title},\n\t\t\t\t\t\t(SELECT COUNT(*) FROM {$linking_table} l WHERE l.{$table_col} = {$id} AND l.{$link_col} = t.id {$where}) checked\n\t\t\t\t\tFROM {$table} t\n\t\t\t\t\tWHERE t.is_active = 1\n\t\t\t\t\tORDER BY t.{$title}"); } else { $result = db_query("SELECT id, {$title}, {$checked} checked FROM {$table} WHERE is_active = 1 ORDER BY {$title}"); } if ($total = db_found($result)) { $counter = 0; $max = ceil($total / 3); $rows .= '<table class="nospacing" width="100%"><tr>'; while ($r = db_fetch($result)) { if ($counter == 0) { $rows .= '<td width="33%" style="vertical-align:top;"><table class="nospacing">'; } $chkname = "chk-" . $name . "-" . $r["id"]; $rows .= ' <tr> <td>' . draw_form_checkbox($chkname, $r["checked"]) . '</td> <td>' . drawCheckboxText($chkname, $r[$title]) . '</td> </tr>'; if ($counter == $max - 1) { $rows .= '</table></td>'; $counter = 0; } else { $counter++; } } if ($counter != 0) { $rows .= '</table></td>'; } $rows .= '</tr></table>'; } $rows .= ' </td> </tr>'; }