Code: Alles auswählen
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', 8)
[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', 1109203602, 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', 1109203602, 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', 1109203602, 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', 1109203602, 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://www.keulaer-boesel.de/images/links/web_logo88a.gif')
[Added/Updated] line: 17 , INSERT INTO phpbb_link_config (config_name, config_value) VALUES ('site_url', 'http://www.keulaer-boesel.de/')
[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')
markus67 hat geschrieben:So ganz versteh ich das jetzt nicht .. das sieht doch gut aus .. wo soll den ein Code über die ganze Seite sichtbar sein ?
Hi..........,pillhuhn hat geschrieben:Ich mein den Html code von meinem Banner!
wo muss ich den jetzt mit dem code hin?Huchi hat geschrieben: habs auch hinbekommen das im IE undim FF es gleich (fast) angezeigt wird und zwar mit dem code:Nur noch eine abschließende Frage! Warum wird der HIntergrund der Textarea im IE weiß angezeigt und im FF grau. Sollte doch gehen das bei beiden weiß anzeigt, oder?Code: Alles auswählen
<table border="0" cellpadding="3" cellspacing="1" width="100%" class="forumline"> <tr> <th class="thHead" align="left" nowrap="nowrap">{L_LINK_US}</th> </tr> <tr> <td class="row1"> <br /><span class="gensmall"><center><img src="{U_SITE_LOGO}" border="0" alt="{SITENAME}" /></center><br /> <center>{L_LINK_US_EXPLAIN}</center></span><br /> <table width="100%" cellspacing="1" cellpadding="2" border="0" align="center" style="table-layout:fixed;border:none thin #FFFFFF"> <tr> <td class="gensmall" align="center">HTML Code mit unserem Logo:<br>(Code wird bei klick markiert) <br /> <textarea readonly name="Link us" style="text-align:left" cols="25" rows="4"; onClick="select()"><a href="http://www.url" target="_blank"><img src="http://www.url.....banner.gif" width="88" height="31" border="0" alt="www.url" title="www.url"></a> </textarea> </table>
Huchi
[/quote]