if (valid_connection($link, $connection_id)) { if ($server && $port) { db_query($link, "INSERT INTO ttirc_servers (server, port, connection_id)\n\t\t\t\t\tVALUES ('{$server}', '{$port}', '{$connection_id}')"); print_servers($link, $connection_id); } else { $error = T_sprintf("Couldn't add server (%s:%d): Invalid syntax.", $server, $port); print json_encode(array("error" => $error)); } } break; case "delete-server": $ids = db_escape_string($_REQUEST["ids"]); $connection_id = (int) db_escape_string($_REQUEST["connection_id"]); if (valid_connection($link, $connection_id)) { db_query($link, "DELETE FROM ttirc_servers WHERE\n\t\t\t\tid in ({$ids}) AND connection_id = '{$connection_id}'"); print_servers($link, $connection_id); } break; case "delete-connection": $ids = db_escape_string($_REQUEST["ids"]); db_query($link, "DELETE FROM ttirc_connections WHERE\n\t\t\tid IN ({$ids}) AND status = 0 AND owner_uid = " . $_SESSION["uid"]); print_connections($link); break; case "create-connection": $title = db_escape_string(trim($_REQUEST["title"])); if ($title) { db_query($link, "INSERT INTO ttirc_connections (enabled, title, owner_uid)\n\t\t\t\tVALUES ('false', '{$title}', '" . $_SESSION["uid"] . "')"); } print_connections($link); break; case "fetch-profiles":
function connection_editor($link, $id) { $result = db_query($link, "SELECT * FROM ttirc_connections\n\t\t\tWHERE id = '{$id}' AND owner_uid = " . $_SESSION["uid"]); $line = db_fetch_assoc($result); if (sql_bool_to_bool($line['auto_connect'])) { $auto_connect_checked = 'checked'; } else { $auto_connect_checked = ''; } if (sql_bool_to_bool($line['visible'])) { $visible_checked = 'checked'; } else { $visible_checked = ''; } if (sql_bool_to_bool($line['permanent'])) { $permanent_checked = 'checked'; } else { $permanent_checked = ''; } ?> <div id="infoBoxTitle"><?php echo __("Edit Connection"); ?> </div> <div class="infoBoxContents"> <div id="mini-notice" style='display : none'> </div> <div class="dlgSec"><?php echo __('Connection'); ?> </div> <form id="prefs_conn_form" onsubmit="return false;"> <input type="hidden" name="connection_id" value="<?php echo $id; ?> "/> <input type="hidden" name="op" value="prefs-conn-save"/> <div class="dlgSecCont"> <label class='fixed'><?php echo __('Title:'); ?> </label> <input name="title" size="30" value="<?php echo $line['title']; ?> "> <br clear='left'/> <label class="fixed"><?php echo __('Nickname:'); ?> </label> <input name="nick" size="30" value="<?php echo $line['nick']; ?> "> <br clear='left'/> <label class='fixed'><?php echo __('Favorite channels:'); ?> </label> <input name="autojoin" size="30" value="<?php echo $line['autojoin']; ?> "> <br clear='left'/> <label class='fixed'><?php echo __('Connect command:'); ?> </label> <input name="connect_cmd" size="30" value="<?php echo $line['connect_cmd']; ?> "> <br clear='left'/> <label class='fixed'><?php echo __('Character set:'); ?> </label> <?php print_select('encoding', $line['encoding'], get_iconv_encodings()); ?> <br clear='left'/> </div> <div class="dlgSec">Options</div> <div class="dlgSecCont"> <input name="visible" <?php echo $visible_checked; ?> id="pr_visible" type="checkbox" value="1"> <label for="pr_visible"><?php echo __('Enable connection'); ?> </label> <br clear='left'/> <input name="auto_connect" <?php echo $auto_connect_checked; ?> id="pr_auto_connect" type="checkbox" value="1"> <label for="pr_auto_connect"><?php echo __('Automatically connect'); ?> </label> <br clear='left'/> <input name="permanent" <?php echo $permanent_checked; ?> id="pr_permanent" type="checkbox" value="1"> <label for="pr_permanent"><?php echo __('Stay connected permanently'); ?> </label> <br clear='left'/> </div> <button type="submit" style="display : none" onclick="save_conn()"></button> </form> <div class="dlgSec"><?php echo __('Servers'); ?> </div> <ul class="container" id="servers-list"> <?php print_servers($link, $id); ?> </ul> <div class="dlgButtons"> <div style='float : left'> <button onclick="create_server()"><?php echo __('Add server'); ?> </button> <button onclick="delete_server()"><?php echo __('Delete'); ?> </button> </div> <button type="submit" onclick="save_conn()"><?php echo __('Save'); ?> </button> <button type="submit" onclick="show_prefs()"><?php echo __('Go back'); ?> </button></div> </div> </div> <?php }