Damit die Seitenleisten-Plugins auch auf den gewünschten Seiten angezeigt werden
erweitern wir nun unser Setup-Skript
http://www.oos-shop.de/doc/myoosdoc/htm ... block.html
Wir sehen zuerst nach, welche block_id unser Seitenleisten Plugin hat
<!--c1--><div class='codetop'>QUELLTEXT[/align]<div class='codemain'><!--ec1--> $blocktable = $oostable['block];
$block_sql = "SELECT block_id FROM $blocktable WHERE block_file = 'products_history'";
$nBlockID = $dbconn->GetOne($block_sql);<!--c2-->[/align]<!--ec2-->
Danach löschen wir alle Verknüpfungen mit den Seiten
<!--c1--><div class='codetop'>QUELLTEXT[/align]<div class='codemain'><!--ec1--> $block_to_page_typetable = $oostable['block_to_page_type];
$result = $dbconn->Execute("DELETE FROM " . $block_to_page_typetable . " WHERE block_id ='". intval($nBlockID) ."'");
if ($result === false) {
echo $dbconn->ErrorMsg();
exit;
}<!--c2-->[/align]<!--ec2-->
Nun tragen wir in die Datenbank ein, auf welchen Seiten wir das Plgin anzeigen möchten
<!--c1--><div class='codetop'>QUELLTEXT[/align]<div class='codemain'><!--ec1--> $dbconn->Execute("INSERT INTO " . $block_to_page_typetable . " (block_id, page_type_id) VALUES ('" . intval($nBlockID) . "', 1)");
$dbconn->Execute("INSERT INTO " . $block_to_page_typetable . " (block_id, page_type_id) VALUES ('" . intval($nBlockID) . "', 2)");
$dbconn->Execute("INSERT INTO " . $block_to_page_typetable . " (block_id, page_type_id) VALUES ('" . intval($nBlockID) . "', 3)");
$dbconn->Execute("INSERT INTO " . $block_to_page_typetable . " (block_id, page_type_id) VALUES ('" . intval($nBlockID) . "', 4)");
$dbconn->Execute("INSERT INTO " . $block_to_page_typetable . " (block_id, page_type_id) VALUES ('" . intval($nBlockID) . "', 5)");
$dbconn->Execute("INSERT INTO " . $block_to_page_typetable . " (block_id, page_type_id) VALUES ('" . intval($nBlockID) . "', 6)");
$dbconn->Execute("INSERT INTO " . $block_to_page_typetable . " (block_id, page_type_id) VALUES ('" . intval($nBlockID) . "', 7)");
$dbconn->Execute("INSERT INTO " . $block_to_page_typetable . " (block_id, page_type_id) VALUES ('" . intval($nBlockID) . "', 9)");<!--c2-->[/align]<!--ec2-->
Dies ist für products_xsell
<!--c1--><div class='codetop'>QUELLTEXT[/align]<div class='codemain'><!--ec1--> $blocktable = $oostable['block];
$query = "UPDATE $blocktable SET block_status = '1', block_side = 'right', block_sort_order = '4' WHERE block_file = 'products_xsell'";
$result =&$dbconn->Execute($query);
if ($result === false) {
echo $dbconn->ErrorMsg();
exit;
}
$blocktable = $oostable['block];
$block_sql = "SELECT block_id FROM $blocktable WHERE block_file = 'products_xsell'";
$nBlockID = $dbconn->GetOne($block_sql);
$block_to_page_typetable = $oostable['block_to_page_type];
$result = $dbconn->Execute("DELETE FROM " . $block_to_page_typetable . " WHERE block_id ='". intval($nBlockID) ."'");
if ($result === false) {
echo $dbconn->ErrorMsg();
exit;
}
$dbconn->Execute("INSERT INTO " . $block_to_page_typetable . " (block_id, page_type_id) VALUES ('" . intval($nBlockID) . "', 3)");
$dbconn->Execute("INSERT INTO " . $block_to_page_typetable . " (block_id, page_type_id) VALUES ('" . intval($nBlockID) . "', 9)");<!--c2-->[/align]<!--ec2-->
und categories
<!--c1--><div class='codetop'>QUELLTEXT[/align]<div class='codemain'><!--ec1--> $blocktable = $oostable['block];
$query = "UPDATE $blocktable SET block_status = '1', block_side = 'left', block_sort_order = '1' WHERE block_file = 'categories'";
$result =&$dbconn->Execute($query);
if ($result === false) {
echo $dbconn->ErrorMsg();
exit;
}
$blocktable = $oostable['block];
$block_sql = "SELECT block_id FROM $blocktable WHERE block_file = 'categories'";
$nBlockID = $dbconn->GetOne($block_sql);
$block_to_page_typetable = $oostable['block_to_page_type];
$result = $dbconn->Execute("DELETE FROM " . $block_to_page_typetable . " WHERE block_id ='". intval($nBlockID) ."'");
if ($result === false) {
echo $dbconn->ErrorMsg();
exit;
}
$dbconn->Execute("INSERT INTO " . $block_to_page_typetable . " (block_id, page_type_id) VALUES ('" . intval($nBlockID) . "', 1)");
$dbconn->Execute("INSERT INTO " . $block_to_page_typetable . " (block_id, page_type_id) VALUES ('" . intval($nBlockID) . "', 2)");
$dbconn->Execute("INSERT INTO " . $block_to_page_typetable . " (block_id, page_type_id) VALUES ('" . intval($nBlockID) . "', 3)");
$dbconn->Execute("INSERT INTO " . $block_to_page_typetable . " (block_id, page_type_id) VALUES ('" . intval($nBlockID) . "', 4)");
$dbconn->Execute("INSERT INTO " . $block_to_page_typetable . " (block_id, page_type_id) VALUES ('" . intval($nBlockID) . "', 5)");
$dbconn->Execute("INSERT INTO " . $block_to_page_typetable . " (block_id, page_type_id) VALUES ('" . intval($nBlockID) . "', 6)");
$dbconn->Execute("INSERT INTO " . $block_to_page_typetable . " (block_id, page_type_id) VALUES ('" . intval($nBlockID) . "', 7)");
$dbconn->Execute("INSERT INTO " . $block_to_page_typetable . " (block_id, page_type_id) VALUES ('" . intval($nBlockID) . "',
");
$dbconn->Execute("INSERT INTO " . $block_to_page_typetable . " (block_id, page_type_id) VALUES ('" . intval($nBlockID) . "', 9)");<!--c2-->[/align]<!--ec2-->
und best_sellers
<!--c1--><div class='codetop'>QUELLTEXT[/align]<div class='codemain'><!--ec1--> $blocktable = $oostable['block];
$query = "UPDATE $blocktable SET block_status = '1', block_side = 'right', block_sort_order = '6' WHERE block_file = 'best_sellers'";
$result =&$dbconn->Execute($query);
if ($result === false) {
echo $dbconn->ErrorMsg();
exit;
}
$blocktable = $oostable['block];
$block_sql = "SELECT block_id FROM $blocktable WHERE block_file = 'best_sellers'";
$nBlockID = $dbconn->GetOne($block_sql);
$block_to_page_typetable = $oostable['block_to_page_type];
$result = $dbconn->Execute("DELETE FROM " . $block_to_page_typetable . " WHERE block_id ='". intval($nBlockID) ."'");
if ($result === false) {
echo $dbconn->ErrorMsg();
exit;
}
$dbconn->Execute("INSERT INTO " . $block_to_page_typetable . " (block_id, page_type_id) VALUES ('" . intval($nBlockID) . "', 1)");
$dbconn->Execute("INSERT INTO " . $block_to_page_typetable . " (block_id, page_type_id) VALUES ('" . intval($nBlockID) . "', 2)");
$dbconn->Execute("INSERT INTO " . $block_to_page_typetable . " (block_id, page_type_id) VALUES ('" . intval($nBlockID) . "', 3)");
$dbconn->Execute("INSERT INTO " . $block_to_page_typetable . " (block_id, page_type_id) VALUES ('" . intval($nBlockID) . "', 4)");
$dbconn->Execute("INSERT INTO " . $block_to_page_typetable . " (block_id, page_type_id) VALUES ('" . intval($nBlockID) . "', 5)");
$dbconn->Execute("INSERT INTO " . $block_to_page_typetable . " (block_id, page_type_id) VALUES ('" . intval($nBlockID) . "', 6)");
$dbconn->Execute("INSERT INTO " . $block_to_page_typetable . " (block_id, page_type_id) VALUES ('" . intval($nBlockID) . "', 7)");
$dbconn->Execute("INSERT INTO " . $block_to_page_typetable . " (block_id, page_type_id) VALUES ('" . intval($nBlockID) . "', 9)");<!--c2-->[/align]<!--ec2-->
