This list is a result of the SQL queries needed for the Advanced Links MOD
[Error or Already added] line: 1 , CREATE TABLE phpbb_link_categories ( cat_id mediumint(8) unsigned NOT NULL auto_increment, cat_title varchar(100) NOT NULL default '', cat_order mediumint(8) unsigned NOT NULL default '0', PRIMARY KEY (cat_id), KEY cat_order (cat_order))
[Error or Already added] line: 2 , CREATE TABLE phpbb_links ( link_id mediumint(8) unsigned NOT NULL auto_increment, link_title varchar(100) NOT NULL default '', link_desc varchar(255) default NULL, link_category mediumint(8) unsigned NOT NULL default '0', link_url varchar(100) NOT NULL default '', link_logo_src varchar(120) default NULL, link_joined int(11) NOT NULL default '0', link_active tinyint(1) NOT NULL default '0', link_hits int(10) unsigned NOT NULL default '0', user_id mediumint(8) NOT NULL default '0', user_ip varchar(8) NOT NULL default '', last_user_ip varchar(8) NOT NULL default '', PRIMARY KEY (link_id))
[Error or Already added] line: 3 , INSERT INTO phpbb_link_categories VALUES (1, 'Arts', 1)
[Error or Already added] line: 4 , INSERT INTO phpbb_link_categories VALUES (2, 'Business', 2)
[Error or Already added] line: 5 , INSERT INTO phpbb_link_categories VALUES (3, 'Children and Teens', 3)
[Error or Already added] line: 6 , INSERT INTO phpbb_link_categories VALUES (4, 'Computers', 4)
[Error or Already added] line: 7 , INSERT INTO phpbb_link_categories VALUES (5, 'Games', 5)
[Error or Already added] line: 8 , INSERT INTO phpbb_link_categories VALUES (6, 'Health', 6)
[Error or Already added] line: 9 , INSERT INTO phpbb_link_categories VALUES (7, 'Home', 7)
[Error or Already added] line: 10 , INSERT INTO phpbb_link_categories VALUES (8, 'News',
[Error or Already added] line: 11 , INSERT INTO phpbb_links VALUES (1, 'phpBB Official Website', 'Official phpBB Website', 4, '
http://www.phpbb.com/', 'images/links/phpBB_88a.gif', 1137538290, 1, 0, 2, '', '')
[Error or Already added] line: 12 , INSERT INTO phpbb_links VALUES (2, 'phpbb-tw.net', 'Unofficial phpBB Chinese Support Centre', 4, '
http://phpbb-tw.net', 'images/links/phpbb-tw_logo88a.gif', 1137538290, 1, 0, 2, '', '')
[Error or Already added] line: 13 , INSERT INTO phpbb_links VALUES (3, 'phpbb2.de', 'Your Source for phpBB2 Stuff', 4, '
http://www.phpbb2.de', 'images/links/phpbb2_de_logo.gif', 1137538290, 1, 0, 2, '', '')
[Error or Already added] line: 14 , INSERT INTO phpbb_links VALUES (4, 'Forumimages.com', 'Forumimages.com', 4, '
http://www.forumimages.com', 'images/links/forum_images_banner_88x31.gif', 1137538290, 1, 0, 2, '', '')
[Error or Already added] line: 15 , CREATE TABLE phpbb_link_config ( config_name varchar(255) NOT NULL default '', config_value varchar(255) NOT NULL default '' )
[Added/Updated] line: 16 , INSERT INTO phpbb_link_config (config_name, config_value) VALUES ('site_logo', '
http://mxbikes.de/querlenker/forum/imag ... ogo88a.gif')
[Added/Updated] line: 17 , INSERT INTO phpbb_link_config (config_name, config_value) VALUES ('site_url', '
http://mxbikes.de/querlenker/forum/')
[Added/Updated] line: 18 , INSERT INTO phpbb_link_config (config_name, config_value) VALUES ('width', '88')
[Added/Updated] line: 19 , INSERT INTO phpbb_link_config (config_name, config_value) VALUES ('height', '31')
[Added/Updated] line: 20 , INSERT INTO phpbb_link_config (config_name, config_value) VALUES ('linkspp', '10')
[Added/Updated] line: 21 , INSERT INTO phpbb_link_config (config_name, config_value) VALUES ('display_interval', '6000')
[Added/Updated] line: 22 , INSERT INTO phpbb_link_config (config_name, config_value) VALUES ('display_logo_num', '10')
[Added/Updated] line: 23 , INSERT INTO phpbb_link_config (config_name, config_value) VALUES ('display_links_logo', '1')
[Added/Updated] line: 24 , INSERT INTO phpbb_link_config (config_name, config_value) VALUES ('email_notify', '1')
[Added/Updated] line: 25 , INSERT INTO phpbb_link_config (config_name, config_value) VALUES ('pm_notify ', '0')
[Added/Updated] line: 26 , INSERT INTO phpbb_link_config (config_name, config_value) VALUES ('lock_submit_site', '0')
[Added/Updated] line: 27 , INSERT INTO phpbb_link_config (config_name, config_value) VALUES ('allow_no_logo', '0')
