Pagina 1 van 1

im portal sql fout

Geplaatst: 05 sep 2004, 19:58
door ajcied

Code: Selecteer alles

INSERT INTO phpbb_blocks VALUES (1, 'Board Navigation', '<table width="100%" cellpadding="0" cellspacing="1" border="0">\r\n<tr>\r\n<td align="left"><span class="genmed" style="line-height: 150%">\r\n<a href="portal.php">Home</a><br />\r\n<a href="index.php">Forum</a><br />\r\n<a href="memberlist.php">Meamberlist</a><br />\r\n<a href="faq.php">FAQ</a><br />\r\n<a href="search.php">Search</a><br />\r\n</span></td>\r\n</tr>\r\n</table>', '@', 2, 1, '', 0, 0, 0, 0, '', 0, 1, 1, 1, 0, '');
INSERT INTO phpbb_blocks VALUES (2, 'Statistics', '', 'r', 3, 1, 'blocks_imp_statistics', 0, 1, 1, 43200, '', 1, 1, 1, 1, 0, '5');
INSERT INTO phpbb_blocks VALUES (3, 'Links', '<table width="100%" cellpadding="0" cellspacing="1" border="0">\r\n<tr>\r\n<td class="row1" align="center"><a href="http://phpbbintegramod.sourceforge.net" target="_blank" class="gen">IntegraMOD</a></td>\r\n</tr>\r\n</table>', 'r', 2, 1, '', 0, 1, 0, 0, '', 0, 1, 1, 1, 0, '');
INSERT INTO phpbb_blocks VALUES (4, 'Welcome to IM Portal', '<table cellspacing="0" cellpadding="0" border="0" width="100%">\r\n<tr>\r\n<td align="center"><span class="gen">\r\nWelcome to IM Portal<br /><br />For questions, comments and suggestions, please visit <a href="http://www.integramod.com">IntegraMOD</a>\r\n</span>\r\n</td>\r\n</tr>\r\n</table>', 'c', 2, 1, '', 0, 1, 0, 0, '', 0, 1, 1, 1, 0, '');
INSERT INTO phpbb_blocks VALUES (5, 'News', '', 'c', 3, 1, 'blocks_imp_forum', 0, 1, 0, 0, '', 1, 1, 1, 1, 0, '');
INSERT INTO phpbb_blocks VALUES (6, 'User Block', '', '@', 3, 1, 'blocks_imp_user_block', 0, 0, 0, 0, '', 1, 1, 1, 1, 0, '');
INSERT INTO phpbb_blocks VALUES (7, 'Who is Online', '', '@', 4, 1, 'blocks_imp_online_users', 0, 0, 1, 300, '', 1, 1, 1, 1, 0, '');
INSERT INTO phpbb_blocks VALUES (8, 'Poll', 'hkghk', 'r', 4, 1, 'blocks_imp_poll', 0, 1, 0, 0, '', 0, 1, 1, 1, 0, '');
INSERT INTO phpbb_blocks VALUES (9, 'Recent Topics', '', 'r', 1, 1, 'blocks_imp_recent_topics', 0, 1, 1, 300, '', 1, 1, 1, 1, 0, '');
INSERT INTO phpbb_blocks VALUES (10, 'Search', '', '@', 5, 1, 'blocks_imp_search', 0, 0, 1, 1000000000, '', 1, 1, 1, 1, 0, '');
INSERT INTO phpbb_blocks VALUES (11, 'sample block', '[size=12:81ef439b94][b:81ef439b94][color=red:81ef439b94]This is just a sample block[/color:81ef439b94][/b:81ef439b94] showing the capabilities of [b:81ef439b94][color=green:81ef439b94]IM Portal[/color:81ef439b94][/b:81ef439b94] with the use of BBCodes.[/size:81ef439b94] \r\n\r\n :lol:  8)  :o  :( \r\n[quote:81ef439b94]This version of IM Portal uses a multi-page feature to create more than one page for your portal.  Try visiting this address: [b:81ef439b94]http://www.myforum.com/portal.php?page=2[/b:81ef439b94]. Replace www.myforum.com with the correct location[/quote:81ef439b94]The block below (Welcome to IM Portal) is an example of a block using HTML.', 'c', 1, 1, '', 0, 1, 0, 0, '81ef439b94', 1, 1, 1, 1, 0, '');
INSERT INTO phpbb_blocks VALUES (12, 'Sample 1', 'This page shows an example of the multi-page feature of IM Portal.  This page also displays the forum-wide blocks.\r\n\r\n[code:1:82bdfbd9b5]Try to visit: http://www.myforum.com/portal.php?page=3[/code:1:82bdfbd9b5]', 'c', 1, 1, '', 0, 2, 0, 0, '82bdfbd9b5', 1, 1, 1, 1, 0, '');
INSERT INTO phpbb_blocks VALUES (13, 'Sample 6', 'This block also shows the [b:0c6a883c90][color=orange:0c6a883c90]multi-page feature of IM Portal[/color:0c6a883c90][/b:0c6a883c90].  But this time, it does not display the forum-wide blocks.\r\n\r\nYou can now proceed to the [b:0c6a883c90][color=blue:0c6a883c90]ACP[/color:0c6a883c90][/b:0c6a883c90] and delete the sample layouts/pages in the layout management page.', 'c', 1, 1, '', 0, 3, 0, 0, '0c6a883c90', 1, 1, 1, 1, 0, '');
INSERT INTO phpbb_blocks VALUES (14, 'News', '', 'c', 4, 1, 'blocks_imp_forum', 0, 3, 0, 0, '', 0, 1, 1, 1, 0, '');
INSERT INTO phpbb_blocks VALUES (15, 'Sample 2', 'This is the new feature of IM Portal which enables a block with the following options:[list:8466b58e05][*:8466b58e05]with or without titlebar\r\n[*:8466b58e05]with or without border\r\n[*:8466b58e05]with or without background[/list:u:8466b58e05]\r\nThis block is without a titlebar, border and background', 'c', 2, 1, '', 0, 2, 0, 0, '8466b58e05', 1, 0, 0, 0, 0, '');
INSERT INTO phpbb_blocks VALUES (16, 'Sample 3', 'Without titlebar only  :o', 'c', 3, 1, '', 0, 2, 0, 0, '7e13fbbacc', 1, 1, 0, 1, 0, '');
INSERT INTO phpbb_blocks VALUES (17, 'Sample 4', 'Without background only  :wink:', 'c', 4, 1, '', 0, 2, 0, 0, '5b8176554c', 1, 1, 1, 0, 0, '');
INSERT INTO phpbb_blocks VALUES (18, 'Sample 5', 'Without border  :arrow:  :idea:  :arrow:', 'c', 5, 1, '', 0, 2, 0, 0, 'ed31156971', 1, 0, 1, 1, 0, '');
INSERT INTO phpbb_blocks VALUES (19, 'Sample 7', 'Take note that pages and blocks can have different permissions.  There are 2 kinds of permissions to set, per user level and per usergroups.  It is allowed to mix permissions but it is wise to set the user level to registered when usergroups are used (e.g. making a page only accessible for a specific usergroup)  :wink:', 'c', 2, 1, '', 0, 3, 0, 0, '16703bc74c', 1, 1, 0, 0, 0, '');
INSERT INTO phpbb_blocks VALUES (20, 'Sample 8', 'To support localization for IM Portal, titlebars can also be localized so titles being displayed, instead of being retrieved from the database will be retrieved from the language files.  This only applies for those blocks which has a language file.  :shock:  8)', 'c', 3, 1, '', 0, 3, 0, 0, '48d2dd24ac', 1, 0, 1, 0, 0, '');
Als ik die in voer krijg een een foutmelding(gebruik de phpBBhack db generator)

Geplaatst: 05 sep 2004, 20:05
door Luuk
en wat is die foutmelding :roll:

Geplaatst: 06 sep 2004, 15:21
door ajcied
Parse error: parse error in /data/members/free/tripod/nl/r/o/s/rosaleszone/htdocs/phpBB2/db_update.php on line 57

http://members.lycos.nl/rosaleszone/php ... update.txt

Geplaatst: 06 sep 2004, 15:49
door mosymuis
Logisch... query #1 puilt uit van de dubbele quotes.

Zoek

Code: Selecteer alles

$sql[] = "INSERT INTO " . $table_prefix . "blocks VALUES (1, 'Board Navigation', '<table width="100%" cellpadding="0" cellspacing="1" border="0">\r\n<tr>\r\n<td align="left"><span class="genmed" style="line-height: 150%">\r\n<a href="portal.php">Home</a><br />\r\n<a href="index.php">Forum</a><br />\r\n<a href="memberlist.php">Meamberlist</a><br />\r\n<a href="faq.php">FAQ</a><br />\r\n<a href="search.php">Search</a><br />\r\n</span></td>\r\n</tr>\r\n</table>', '@', 2, 1, '', 0, 0, 0, 0, '', 0, 1, 1, 1, 0, '')";
Vervang met

Code: Selecteer alles

$sql[] = "INSERT INTO " . $table_prefix . "blocks VALUES (1, 'Board Navigation', '<table width=\"100%\" cellpadding=\"0\" cellspacing=\"1\" border=\"0\">\r\n<tr>\r\n<td align=\"left\"><span class=\"genmed\" style=\"line-height: 150%\">\r\n<a href=\"portal.php\">Home</a><br />\r\n<a href=\"index.php\">Forum</a><br />\r\n<a href=\"memberlist.php\">Meamberlist</a><br />\r\n<a href=\"faq.php\">FAQ</a><br />\r\n<a href=\"search.php\">Search</a><br />\r\n</span></td>\r\n</tr>\r\n</table>', '@', 2, 1, '', 0, 0, 0, 0, '', 0, 1, 1, 1, 0, '')";

Geplaatst: 06 sep 2004, 15:58
door ajcied
Parse error: parse error in /data/members/free/tripod/nl/r/o/s/rosaleszone/htdocs/phpBB2/db_update.php on line 59 :x :(

Geplaatst: 06 sep 2004, 16:03
door mosymuis
Kijk nu eens wat ik gedaan heb? Hetzelfde probleem heb je op regel 59; dit kan je nu dus zelf oplossen.

Geplaatst: 06 sep 2004, 17:12
door ajcied
snap niet hoe je het doen :oops:
zou jij het willen oplossen in een bestandje?

Geplaatst: 06 sep 2004, 17:53
door Luuk
als er html staat, bijvoorbeeld target="_blank" moet je dat veranderen in target=\"_blank\"
dus bij alle html de " vervangen door \"