1 files changed, 0 insertions, 183 deletions
diff --git a/old/dbal/structure/mysql_data.sql b/old/dbal/structure/mysql_data.sql
deleted file mode 100644
index 38fc861..0000000
--- a/old/dbal/structure/mysql_data.sql
+++ /dev/null
@@ -1,183 +0,0 @@
-### Configuration values
-INSERT INTO eqdkp_config (config_name, config_value) VALUES ('default_lang', 'english');
-INSERT INTO eqdkp_config (config_name, config_value) VALUES ('default_game', 'Everquest');
-INSERT INTO eqdkp_config (config_name, config_value) VALUES ('default_style', '6');
-INSERT INTO eqdkp_config (config_name, config_value) VALUES ('default_alimit', '100');
-INSERT INTO eqdkp_config (config_name, config_value) VALUES ('default_elimit', '100');
-INSERT INTO eqdkp_config (config_name, config_value) VALUES ('default_ilimit', '100');
-INSERT INTO eqdkp_config (config_name, config_value) VALUES ('default_nlimit', '10');
-INSERT INTO eqdkp_config (config_name, config_value) VALUES ('default_rlimit', '100');
-INSERT INTO eqdkp_config (config_name, config_value) VALUES ('guildtag', '');
-INSERT INTO eqdkp_config (config_name, config_value) VALUES ('parsetags', '');
-INSERT INTO eqdkp_config (config_name, config_value) VALUES ('dkp_name', 'DKP');
-INSERT INTO eqdkp_config (config_name, config_value) VALUES ('hide_inactive', '1');
-INSERT INTO eqdkp_config (config_name, config_value) VALUES ('inactive_period', '14');
-INSERT INTO eqdkp_config (config_name, config_value) VALUES ('active_point_adj', '0.00');
-INSERT INTO eqdkp_config (config_name, config_value) VALUES ('inactive_point_adj', '0.00');
-INSERT INTO eqdkp_config (config_name, config_value) VALUES ('main_title', '');
-INSERT INTO eqdkp_config (config_name, config_value) VALUES ('sub_title', '');
-INSERT INTO eqdkp_config (config_name, config_value) VALUES ('start_page', 'viewnews.php');
-INSERT INTO eqdkp_config (config_name, config_value) VALUES ('cookie_domain', '');
-INSERT INTO eqdkp_config (config_name, config_value) VALUES ('cookie_name', 'eqdkp');
-INSERT INTO eqdkp_config (config_name, config_value) VALUES ('cookie_path', '/');
-INSERT INTO eqdkp_config (config_name, config_value) VALUES ('session_length', '3600');
-INSERT INTO eqdkp_config (config_name, config_value) VALUES ('session_cleanup', '0');
-INSERT INTO eqdkp_config (config_name, config_value) VALUES ('session_last_cleanup', '0');
-INSERT INTO eqdkp_config (config_name, config_value) VALUES ('server_name', '');
-INSERT INTO eqdkp_config (config_name, config_value) VALUES ('server_path', '/eqdkp/');
-INSERT INTO eqdkp_config (config_name, config_value) VALUES ('server_port', '80');
-INSERT INTO eqdkp_config (config_name, config_value) VALUES ('enable_gzip', '0');
-INSERT INTO eqdkp_config (config_name, config_value) VALUES ('admin_email', '');
-INSERT INTO eqdkp_config (config_name, config_value) VALUES ('account_activation', '1');
-INSERT INTO eqdkp_config (config_name, config_value) VALUES ('eqdkp_start', UNIX_TIMESTAMP());
-INSERT INTO eqdkp_config (config_name, config_value) VALUES ('default_locale', 'en_US');
-
-### Permission Options
-### A = Admin / U = User
-INSERT INTO eqdkp_auth_options (auth_id, auth_value, auth_default) VALUES ('1','a_event_add','N');
-INSERT INTO eqdkp_auth_options (auth_id, auth_value, auth_default) VALUES ('2','a_event_upd','N');
-INSERT INTO eqdkp_auth_options (auth_id, auth_value, auth_default) VALUES ('3','a_event_del','N');
-INSERT INTO eqdkp_auth_options (auth_id, auth_value, auth_default) VALUES ('4','a_groupadj_add','N');
-INSERT INTO eqdkp_auth_options (auth_id, auth_value, auth_default) VALUES ('5','a_groupadj_upd','N');
-INSERT INTO eqdkp_auth_options (auth_id, auth_value, auth_default) VALUES ('6','a_groupadj_del','N');
-INSERT INTO eqdkp_auth_options (auth_id, auth_value, auth_default) VALUES ('7','a_indivadj_add','N');
-INSERT INTO eqdkp_auth_options (auth_id, auth_value, auth_default) VALUES ('8','a_indivadj_upd','N');
-INSERT INTO eqdkp_auth_options (auth_id, auth_value, auth_default) VALUES ('9','a_indivadj_del','N');
-INSERT INTO eqdkp_auth_options (auth_id, auth_value, auth_default) VALUES ('10','a_item_add','N');
-INSERT INTO eqdkp_auth_options (auth_id, auth_value, auth_default) VALUES ('11','a_item_upd','N');
-INSERT INTO eqdkp_auth_options (auth_id, auth_value, auth_default) VALUES ('12','a_item_del','N');
-INSERT INTO eqdkp_auth_options (auth_id, auth_value, auth_default) VALUES ('13','a_news_add','N');
-INSERT INTO eqdkp_auth_options (auth_id, auth_value, auth_default) VALUES ('14','a_news_upd','N');
-INSERT INTO eqdkp_auth_options (auth_id, auth_value, auth_default) VALUES ('15','a_news_del','N');
-INSERT INTO eqdkp_auth_options (auth_id, auth_value, auth_default) VALUES ('16','a_raid_add','N');
-INSERT INTO eqdkp_auth_options (auth_id, auth_value, auth_default) VALUES ('17','a_raid_upd','N');
-INSERT INTO eqdkp_auth_options (auth_id, auth_value, auth_default) VALUES ('18','a_raid_del','N');
-INSERT INTO eqdkp_auth_options (auth_id, auth_value, auth_default) VALUES ('19','a_turnin_add','N');
-INSERT INTO eqdkp_auth_options (auth_id, auth_value, auth_default) VALUES ('20','a_config_man','N');
-INSERT INTO eqdkp_auth_options (auth_id, auth_value, auth_default) VALUES ('21','a_members_man','N');
-INSERT INTO eqdkp_auth_options (auth_id, auth_value, auth_default) VALUES ('22','a_users_man','N');
-INSERT INTO eqdkp_auth_options (auth_id, auth_value, auth_default) VALUES ('23','a_logs_view','N');
-INSERT INTO eqdkp_auth_options (auth_id, auth_value, auth_default) VALUES ('24','u_event_list','Y');
-INSERT INTO eqdkp_auth_options (auth_id, auth_value, auth_default) VALUES ('25','u_event_view','Y');
-INSERT INTO eqdkp_auth_options (auth_id, auth_value, auth_default) VALUES ('26','u_item_list','Y');
-INSERT INTO eqdkp_auth_options (auth_id, auth_value, auth_default) VALUES ('27','u_item_view','Y');
-INSERT INTO eqdkp_auth_options (auth_id, auth_value, auth_default) VALUES ('28','u_member_list','Y');
-INSERT INTO eqdkp_auth_options (auth_id, auth_value, auth_default) VALUES ('29','u_member_view','Y');
-INSERT INTO eqdkp_auth_options (auth_id, auth_value, auth_default) VALUES ('30','u_raid_list','Y');
-INSERT INTO eqdkp_auth_options (auth_id, auth_value, auth_default) VALUES ('31','u_raid_view','Y');
-INSERT INTO eqdkp_auth_options (auth_id, auth_value, auth_default) VALUES ('32','a_plugins_man','N');
-INSERT INTO eqdkp_auth_options (auth_id, auth_value, auth_default) VALUES ('33','a_styles_man','N');
-INSERT INTO eqdkp_auth_options (auth_id, auth_value, auth_default) VALUES ('34','a_soap_read','N');
-INSERT INTO eqdkp_auth_options (auth_id, auth_value, auth_default) VALUES ('35','a_soap_write','N');
-INSERT INTO eqdkp_auth_options (auth_id, auth_value, auth_default) VALUES ('36','a_backup','N');
-
-### Style presets
-INSERT INTO eqdkp_styles (style_id, style_name, template_path, body_background, body_link, body_link_style, body_hlink, body_hlink_style, header_link, header_link_style, header_hlink, header_hlink_style, tr_color1, tr_color2, th_color1, fontface1, fontface2, fontface3, fontsize1, fontsize2, fontsize3, fontcolor1, fontcolor2, fontcolor3, fontcolor_neg, fontcolor_pos, table_border_width, table_border_color, table_border_style, input_color, input_border_width, input_border_color, input_border_style) VALUES (1, 'Default', 'default', '212042', '31308C', 'underline', '000084', 'underline', 'CECFEF', 'underline', 'E6E6F5', 'underline', 'EFEFEF', 'FFFFFF', '424563', 'Verdana, Tahoma, Arial', 'Verdana, Tahoma, Arial', 'Verdana, Tahoma, Arial', 10, 11, 12, '000000', 'CECFEF', '000000', 'F80000', '008800', 1, '7B819A', 'solid', 'FFFFFF', 1, '000000', 'solid');
-INSERT INTO eqdkp_styles (style_id, style_name, template_path, body_background, body_link, body_link_style, body_hlink, body_hlink_style, header_link, header_link_style, header_hlink, header_hlink_style, tr_color1, tr_color2, th_color1, fontface1, fontface2, fontface3, fontsize1, fontsize2, fontsize3, fontcolor1, fontcolor2, fontcolor3, fontcolor_neg, fontcolor_pos, table_border_width, table_border_color, table_border_style, input_color, input_border_width, input_border_color, input_border_style) VALUES (2, 'Old School', 'default', 'FFFFFF', '000000', 'underline', '000000', 'underline', '000000', 'underline', '000000', 'underline', 'BCBFCB', 'D3D7DE', '7B819A', 'Verdana, Tahoma, Arial', 'Verdana, Tahoma, Arial', 'Verdana, Tahoma, Arial', 10, 11, 12, '000000', '000000', '000000', 'F80000', '008800', 0, '000000', 'solid', 'FFFFFF', 1, '000000', 'solid');
-INSERT INTO eqdkp_styles (style_id, style_name, template_path, body_background, body_link, body_link_style, body_hlink, body_hlink_style, header_link, header_link_style, header_hlink, header_hlink_style, tr_color1, tr_color2, th_color1, fontface1, fontface2, fontface3, fontsize1, fontsize2, fontsize3, fontcolor1, fontcolor2, fontcolor3, fontcolor_neg, fontcolor_pos, table_border_width, table_border_color, table_border_style, input_color, input_border_width, input_border_color, input_border_style) VALUES (3, 'EQdkp VB', 'default', '8080A6', '000000', 'underline', 'FB4400', 'underline', 'FFF788', 'none', 'FFF788', 'underline', 'F1F1F1', 'DFDFDF', '606096', 'Verdana, Tahoma, Arial', 'Verdana, Tahoma, Arial', 'Verdana, Tahoma, Arial', 10, 11, 12, '000000', '000000', '000000', 'F80000', '008800', 0, '000000', 'none', 'FFFFFF', 1, '000000', 'solid');
-INSERT INTO eqdkp_styles (style_id, style_name, template_path, body_background, body_link, body_link_style, body_hlink, body_hlink_style, header_link, header_link_style, header_hlink, header_hlink_style, tr_color1, tr_color2, th_color1, fontface1, fontface2, fontface3, fontsize1, fontsize2, fontsize3, fontcolor1, fontcolor2, fontcolor3, fontcolor_neg, fontcolor_pos, table_border_width, table_border_color, table_border_style, input_color, input_border_width, input_border_color, input_border_style) VALUES (4, 'Blueish', 'default', '939EAF', '586273', 'underline', 'FFF9F3', 'underline', 'FFFFFF', 'none', 'FFFFFF', 'none', 'D6DAE6', 'BFC5D3', '828FA2', 'Verdana, Tahoma, Arial', 'Verdana, Tahoma, Arial', 'Verdana, Tahoma, Arial', 10, 11, 12, '000000', 'FFFFFF', 'FFFFFF', 'F80000', '008800', 1, '455164', 'solid', '727E93', 1, 'FFFFFF', 'solid');
-INSERT INTO eqdkp_styles (style_id, style_name, template_path, body_background, body_link, body_link_style, body_hlink, body_hlink_style, header_link, header_link_style, header_hlink, header_hlink_style, tr_color1, tr_color2, th_color1, fontface1, fontface2, fontface3, fontsize1, fontsize2, fontsize3, fontcolor1, fontcolor2, fontcolor3, fontcolor_neg, fontcolor_pos, table_border_width, table_border_color, table_border_style, input_color, input_border_width, input_border_color, input_border_style) VALUES (5, 'EQdkp Items', 'default', 'FFFFFF', '2F415D', 'underline', 'E98219', 'underline', 'FFFFFF', 'underline', 'E98219', 'underline', 'F1F1F3', 'E3E4E8', '263B58', 'Verdana, Tahoma, Arial', 'Verdana, Tahoma, Arial', 'Verdana, Tahoma, Arial', 10, 11, 12, '000000', '000000', '000000', 'F80000', '008800', 1, '1D2846', 'solid', 'FFFFFF', 1, '000000', 'solid');
-INSERT INTO eqdkp_styles (style_id, style_name, template_path, body_background, body_link, body_link_style, body_hlink, body_hlink_style, header_link, header_link_style, header_hlink, header_hlink_style, tr_color1, tr_color2, th_color1, fontface1, fontface2, fontface3, fontsize1, fontsize2, fontsize3, fontcolor1, fontcolor2, fontcolor3, fontcolor_neg, fontcolor_pos, table_border_width, table_border_color, table_border_style, input_color, input_border_width, input_border_color, input_border_style) VALUES (6, 'aallix Silver', 'default', 'FFFFFF', '555555', 'none', 'EC8500', 'underline', '555555', 'none', 'EC8500', 'underline', 'F2F2F2', 'FAFAFA', 'E0E0E0', 'Verdana, Tahoma, Arial', 'Verdana, Tahoma, Arial', 'Verdana, Tahoma, Arial', 10, 11, 12, '000000', '000000', '000000', 'F80000', '008800', 1, '999999', 'solid', 'D1D1D1', 1, '000000', 'solid');
-INSERT INTO eqdkp_styles (style_id, style_name, template_path, body_background, body_link, body_link_style, body_hlink, body_hlink_style, header_link, header_link_style, header_hlink, header_hlink_style, tr_color1, tr_color2, th_color1, fontface1, fontface2, fontface3, fontsize1, fontsize2, fontsize3, fontcolor1, fontcolor2, fontcolor3, fontcolor_neg, fontcolor_pos, table_border_width, table_border_color, table_border_style, input_color, input_border_width, input_border_color, input_border_style) VALUES (7, 'Penguin', 'default', 'FFFFFF', '000000', 'underline', '000000', 'underline', '000000', 'underline', '000000', 'underline', 'EEEEEE', 'FFFFFF', 'FFCC00', 'Verdana, Tahoma, Arial', 'Verdana, Tahoma, Arial', 'Verdana, Tahoma, Arial', 10, 11, 12, '000000', '000000', '000000', 'F80000', '008800', 1, 'FFCC00', 'solid', 'FFFFFF', 1, '000000', 'solid');
-INSERT INTO eqdkp_styles (style_id, style_name, template_path, body_background, body_link, body_link_style, body_hlink, body_hlink_style, header_link, header_link_style, header_hlink, header_hlink_style, tr_color1, tr_color2, th_color1, fontface1, fontface2, fontface3, fontsize1, fontsize2, fontsize3, fontcolor1, fontcolor2, fontcolor3, fontcolor_neg, fontcolor_pos, table_border_width, table_border_color, table_border_style, input_color, input_border_width, input_border_color, input_border_style) VALUES (8, 'Collab', 'default', 'FFFFFF', '354A55', 'underline', '5B7F93', 'underline', '5B7F93', 'underline', '354A55', 'underline', 'F5F5F5', 'DEE7EB', 'C4D3DB', 'Verdana, Tahoma, Arial', 'Verdana, Tahoma, Arial', 'Verdana, Tahoma, Arial', 10, 11, 12, '000000', '000000', '000000', 'F80000', '008800', 1, '999999', 'solid', 'FFFFFF', 1, '000000', 'solid');
-INSERT INTO eqdkp_styles (style_id, style_name, template_path, body_background, body_link, body_link_style, body_hlink, body_hlink_style, header_link, header_link_style, header_hlink, header_hlink_style, tr_color1, tr_color2, th_color1, fontface1, fontface2, fontface3, fontsize1, fontsize2, fontsize3, fontcolor1, fontcolor2, fontcolor3, fontcolor_neg, fontcolor_pos, table_border_width, table_border_color, table_border_style, input_color, input_border_width, input_border_color, input_border_style) VALUES (9, 'EQdkp Invision', 'default', 'FFFFFF', '000000', 'underline', '465584', 'underline', '3A4F6C', 'none', '3A4F6C', 'underline', 'E4EAF2', 'DFE6EF', 'BCD0ED', 'Verdana, Tahoma, Arial', 'Verdana, Tahoma, Arial', 'Verdana, Tahoma, Arial', 10, 11, 12, '000000', '000000', '000000', 'F80000', '008800', 1, '345487', 'solid', 'FFFFFF', 1, '000000', 'solid');
-INSERT INTO eqdkp_styles (style_id, style_name, template_path, body_background, body_link, body_link_style, body_hlink, body_hlink_style, header_link, header_link_style, header_hlink, header_hlink_style, tr_color1, tr_color2, th_color1, fontface1, fontface2, fontface3, fontsize1, fontsize2, fontsize3, fontcolor1, fontcolor2, fontcolor3, fontcolor_neg, fontcolor_pos, table_border_width, table_border_color, table_border_style, input_color, input_border_width, input_border_color, input_border_style) VALUES (10, 'dkpUA', 'default', '253546', 'C6C6C6', 'underline', '576695', 'underline', 'C6C6C6', 'none', 'C6C6C6', 'underline', '39495A', '283846', '1F2F3D', 'Verdana', 'Verdana', 'Verdana', 10, 11, 12, 'C6C6C6', 'C6C6C6', '000000', 'FF0000', '00C000', 1, '60707E', 'solid', 'FFFFFF', 1, '60707E', 'solid');
-INSERT INTO eqdkp_styles (style_id, style_name, template_path, body_background, body_link, body_link_style, body_hlink, body_hlink_style, header_link, header_link_style, header_hlink, header_hlink_style, tr_color1, tr_color2, th_color1, fontface1, fontface2, fontface3, fontsize1, fontsize2, fontsize3, fontcolor1, fontcolor2, fontcolor3, fontcolor_neg, fontcolor_pos, table_border_width, table_border_color, table_border_style, input_color, input_border_width, input_border_color, input_border_style) VALUES (11, 'subSilver', 'default', 'FFFFFF', '006699', 'underline', 'DD6900', 'underline', 'FFA34F', 'none', 'FFA34F', 'underline', 'DEE3E7', 'EFEFEF', '1073A5', 'Verdana, Arial', 'Verdana, Arial', 'Verdana, Arial', 10, 11, 12, '000000', '000000', '000000', 'F80000', '008800', 1, '006699', 'solid', 'FFFFFF', 1, '000000', 'solid');
-INSERT INTO eqdkp_styles (style_id, style_name, template_path, body_background, body_link, body_link_style, body_hlink, body_hlink_style, header_link, header_link_style, header_hlink, header_hlink_style, tr_color1, tr_color2, th_color1, fontface1, fontface2, fontface3, fontsize1, fontsize2, fontsize3, fontcolor1, fontcolor2, fontcolor3, fontcolor_neg, fontcolor_pos, table_border_width, table_border_color, table_border_style, input_color, input_border_width, input_border_color, input_border_style) VALUES (12, 'EQdkp VB2', 'default', 'FFFFFF', '000000', 'underline', 'FF4400', 'underline', 'FFF788', 'none', 'FFF788', 'underline', 'F1F1F1', 'DFDFDF', '8080A6', 'Verdana, Arial', 'Verdana, Arial', 'Verdana, Arial', 10, 11, 12, '000000', '000000', '000000', 'F80000', '008800', 1, '555576', 'solid', 'FFFFFF', 1, '000000', 'solid');
-INSERT INTO eqdkp_styles (style_id, style_name, template_path, body_background, body_link, body_link_style, body_hlink, body_hlink_style, header_link, header_link_style, header_hlink, header_hlink_style, tr_color1, tr_color2, th_color1, fontface1, fontface2, fontface3, fontsize1, fontsize2, fontsize3, fontcolor1, fontcolor2, fontcolor3, fontcolor_neg, fontcolor_pos, table_border_width, table_border_color, table_border_style, input_color, input_border_width, input_border_color, input_border_style) VALUES (13, 'EQCPS', 'default', '7B7984', '151F41', 'underline', '800000', 'underline', 'FFFFFF', 'none', 'FFFFFF', 'none', 'CECBCE', 'BDBABD', '424952', 'Verdana, Arial', 'Verdana, Arial', 'Verdana, Arial', 10, 11, 12, '000000', '000000', '000000', '800000', '008000', 1, '000000', 'solid', 'C0C0C0', 1, '000000', 'solid');
-
-### Style configurations
-INSERT INTO eqdkp_style_config (style_id, attendees_columns, logo_path) VALUES (1, '6', 'logo.gif');
-INSERT INTO eqdkp_style_config (style_id, attendees_columns, logo_path) VALUES (2, '4', 'old_school_logo.gif');
-INSERT INTO eqdkp_style_config (style_id, attendees_columns, logo_path) VALUES (3, '6', 'vb_logo.gif');
-INSERT INTO eqdkp_style_config (style_id, attendees_columns, logo_path) VALUES (4, '6', 'blueish_logo.gif');
-INSERT INTO eqdkp_style_config (style_id, attendees_columns, logo_path) VALUES (5, '6', 'items_logo.gif');
-INSERT INTO eqdkp_style_config (style_id, attendees_columns, logo_path) VALUES (6, '6', 'aallix_logo.gif');
-INSERT INTO eqdkp_style_config (style_id, attendees_columns, logo_path) VALUES (7, '6', 'penguin_logo.gif');
-INSERT INTO eqdkp_style_config (style_id, attendees_columns, logo_path) VALUES (8, '6', 'collab_logo.gif');
-INSERT INTO eqdkp_style_config (style_id, attendees_columns, logo_path) VALUES (9, '6', 'invision_logo.gif');
-INSERT INTO eqdkp_style_config (style_id, attendees_columns, logo_path) VALUES (10, '8', 'dkpua_logo.gif');
-INSERT INTO eqdkp_style_config (style_id, attendees_columns, logo_path) VALUES (11, '8', 'subsilver_logo.gif');
-INSERT INTO eqdkp_style_config (style_id, attendees_columns, logo_path) VALUES (12, '8', 'logo.gif');
-INSERT INTO eqdkp_style_config (style_id, attendees_columns, logo_path) VALUES (13, '8', 'logo.gif');
-
-### Default user
-INSERT INTO eqdkp_users (user_id, username, user_password, user_style, user_lang, user_active) VALUES ('1','admin',md5('admin'),'6','english','0');
-INSERT INTO eqdkp_auth_users (auth_id, user_id, auth_setting) VALUES ('1','1','Y');
-INSERT INTO eqdkp_auth_users (auth_id, user_id, auth_setting) VALUES ('2','1','Y');
-INSERT INTO eqdkp_auth_users (auth_id, user_id, auth_setting) VALUES ('3','1','Y');
-INSERT INTO eqdkp_auth_users (auth_id, user_id, auth_setting) VALUES ('4','1','Y');
-INSERT INTO eqdkp_auth_users (auth_id, user_id, auth_setting) VALUES ('5','1','Y');
-INSERT INTO eqdkp_auth_users (auth_id, user_id, auth_setting) VALUES ('6','1','Y');
-INSERT INTO eqdkp_auth_users (auth_id, user_id, auth_setting) VALUES ('7','1','Y');
-INSERT INTO eqdkp_auth_users (auth_id, user_id, auth_setting) VALUES ('8','1','Y');
-INSERT INTO eqdkp_auth_users (auth_id, user_id, auth_setting) VALUES ('9','1','Y');
-INSERT INTO eqdkp_auth_users (auth_id, user_id, auth_setting) VALUES ('10','1','Y');
-INSERT INTO eqdkp_auth_users (auth_id, user_id, auth_setting) VALUES ('11','1','Y');
-INSERT INTO eqdkp_auth_users (auth_id, user_id, auth_setting) VALUES ('12','1','Y');
-INSERT INTO eqdkp_auth_users (auth_id, user_id, auth_setting) VALUES ('13','1','Y');
-INSERT INTO eqdkp_auth_users (auth_id, user_id, auth_setting) VALUES ('14','1','Y');
-INSERT INTO eqdkp_auth_users (auth_id, user_id, auth_setting) VALUES ('15','1','Y');
-INSERT INTO eqdkp_auth_users (auth_id, user_id, auth_setting) VALUES ('16','1','Y');
-INSERT INTO eqdkp_auth_users (auth_id, user_id, auth_setting) VALUES ('17','1','Y');
-INSERT INTO eqdkp_auth_users (auth_id, user_id, auth_setting) VALUES ('18','1','Y');
-INSERT INTO eqdkp_auth_users (auth_id, user_id, auth_setting) VALUES ('19','1','Y');
-INSERT INTO eqdkp_auth_users (auth_id, user_id, auth_setting) VALUES ('20','1','Y');
-INSERT INTO eqdkp_auth_users (auth_id, user_id, auth_setting) VALUES ('21','1','Y');
-INSERT INTO eqdkp_auth_users (auth_id, user_id, auth_setting) VALUES ('22','1','Y');
-INSERT INTO eqdkp_auth_users (auth_id, user_id, auth_setting) VALUES ('23','1','Y');
-INSERT INTO eqdkp_auth_users (auth_id, user_id, auth_setting) VALUES ('24','1','Y');
-INSERT INTO eqdkp_auth_users (auth_id, user_id, auth_setting) VALUES ('25','1','Y');
-INSERT INTO eqdkp_auth_users (auth_id, user_id, auth_setting) VALUES ('26','1','Y');
-INSERT INTO eqdkp_auth_users (auth_id, user_id, auth_setting) VALUES ('27','1','Y');
-INSERT INTO eqdkp_auth_users (auth_id, user_id, auth_setting) VALUES ('28','1','Y');
-INSERT INTO eqdkp_auth_users (auth_id, user_id, auth_setting) VALUES ('29','1','Y');
-INSERT INTO eqdkp_auth_users (auth_id, user_id, auth_setting) VALUES ('30','1','Y');
-INSERT INTO eqdkp_auth_users (auth_id, user_id, auth_setting) VALUES ('31','1','Y');
-INSERT INTO eqdkp_auth_users (auth_id, user_id, auth_setting) VALUES ('32','1','Y');
-INSERT INTO eqdkp_auth_users (auth_id, user_id, auth_setting) VALUES ('33','1','Y');
-INSERT INTO eqdkp_auth_users (auth_id, user_id, auth_setting) VALUES ('34','1','Y');
-INSERT INTO eqdkp_auth_users (auth_id, user_id, auth_setting) VALUES ('35','1','Y');
-INSERT INTO eqdkp_auth_users (auth_id, user_id, auth_setting) VALUES ('36','1','Y');
-
-### Member ranks
-INSERT INTO eqdkp_member_ranks (rank_id, rank_name) VALUES ('0', '');
-INSERT INTO eqdkp_member_ranks (rank_id, rank_name) VALUES ('1', 'Member');
-
-INSERT INTO eqdkp_classes (class_id, class_name, class_armor_type) VALUES (0, 'Unknown', 'Plate');
-INSERT INTO eqdkp_classes (class_id, class_name, class_armor_type) VALUES (1, 'Warrior', 'Plate');
-INSERT INTO eqdkp_classes (class_id, class_name, class_armor_type) VALUES (2, 'Rogue', 'Chain');
-INSERT INTO eqdkp_classes (class_id, class_name, class_armor_type) VALUES (3, 'Monk', 'Leather');
-INSERT INTO eqdkp_classes (class_id, class_name, class_armor_type) VALUES (4, 'Ranger', 'Chain');
-INSERT INTO eqdkp_classes (class_id, class_name, class_armor_type) VALUES (5, 'Paladin', 'Plate');
-INSERT INTO eqdkp_classes (class_id, class_name, class_armor_type) VALUES (6, 'Shadow Knight', 'Plate');
-INSERT INTO eqdkp_classes (class_id, class_name, class_armor_type) VALUES (7, 'Bard', 'Plate');
-INSERT INTO eqdkp_classes (class_id, class_name, class_armor_type) VALUES (8, 'Beastlord', 'Leather');
-INSERT INTO eqdkp_classes (class_id, class_name, class_armor_type) VALUES (9, 'Cleric', 'Plate');
-INSERT INTO eqdkp_classes (class_id, class_name, class_armor_type) VALUES (10, 'Druid', 'Leather');
-INSERT INTO eqdkp_classes (class_id, class_name, class_armor_type) VALUES (11, 'Shaman', 'Chain');
-INSERT INTO eqdkp_classes (class_id, class_name, class_armor_type) VALUES (12, 'Enchanter', 'Silk');
-INSERT INTO eqdkp_classes (class_id, class_name, class_armor_type) VALUES (13, 'Wizard', 'Silk');
-INSERT INTO eqdkp_classes (class_id, class_name, class_armor_type) VALUES (14, 'Necromancer', 'Silk');
-INSERT INTO eqdkp_classes (class_id, class_name, class_armor_type) VALUES (15, 'Magician', 'Silk');
-INSERT INTO eqdkp_classes (class_id, class_name, class_armor_type) VALUES (16, 'Berserker', 'Leather');
-
-INSERT INTO eqdkp_races (race_id, race_name) VALUES (0, 'Unknown');
-INSERT INTO eqdkp_races (race_id, race_name) VALUES (1, 'Gnome');
-INSERT INTO eqdkp_races (race_id, race_name) VALUES (2, 'Human');
-INSERT INTO eqdkp_races (race_id, race_name) VALUES (3, 'Barbarian');
-INSERT INTO eqdkp_races (race_id, race_name) VALUES (4, 'Dwarf');
-INSERT INTO eqdkp_races (race_id, race_name) VALUES (5, 'High Elf');
-INSERT INTO eqdkp_races (race_id, race_name) VALUES (6, 'Dark Elf');
-INSERT INTO eqdkp_races (race_id, race_name) VALUES (7, 'Wood Elf');
-INSERT INTO eqdkp_races (race_id, race_name) VALUES (8, 'Half Elf');
-INSERT INTO eqdkp_races (race_id, race_name) VALUES (9, 'Vah Shir');
-INSERT INTO eqdkp_races (race_id, race_name) VALUES (10, 'Troll');
-INSERT INTO eqdkp_races (race_id, race_name) VALUES (11, 'Ogre');
-INSERT INTO eqdkp_races (race_id, race_name) VALUES (12, 'Frog');
-INSERT INTO eqdkp_races (race_id, race_name) VALUES (13, 'Iksar');
-INSERT INTO eqdkp_races (race_id, race_name) VALUES (14, 'Erudite');
-INSERT INTO eqdkp_races (race_id, race_name) VALUES (15, 'Halfling');
-
-INSERT INTO eqdkp_factions (faction_id, faction_name) VALUES (1, 'Good');
-INSERT INTO eqdkp_factions (faction_id, faction_name) VALUES (2, 'Evil');