<% OURL = "index.html"; OID = "7928"; TEXT_TITLE = "Admin"; HOTTITLES_TITLES = ""; %> <% if (OID.equals("22261")) {%> <%} else {%> <% } %> Terra Lannoo
<% ArrayList MENU_ITEMS = new ArrayList(); %> <% MENU_ITEMS.add(new String[] {"actua & geschiedenis", "http://www.racine.be/content/terralannoo/fondsen/actuageschiedenis/1/index.jsp", "actuageschiedenis", "", "7748", "0"}); %><% MENU_ITEMS.add(new String[] {"cadeauboeken", "http://www.racine.be/content/terralannoo/fondsen/cadeauboeken/1/index.jsp", "cadeauboeken", "", "482", "0"}); %><% MENU_ITEMS.add(new String[] {"culinair", "http://www.racine.be/content/terralannoo/fondsen/culinair/1/index.jsp", "culinair", "16x20", "476", "0"}); %><% MENU_ITEMS.add(new String[] {"gezin & opvoeden", "http://www.racine.be/content/terralannoo/fondsen/gezinopvoeden/1/index.jsp", "gezinopvoeden", "16x20", "480", "0"}); %><% MENU_ITEMS.add(new String[] {"gezond leven", "http://www.racine.be/content/terralannoo/fondsen/gezondleven/1/index.jsp", "gezondleven", "", "7757", "0"}); %><% MENU_ITEMS.add(new String[] {"interieur", "http://www.racine.be/content/terralannoo/fondsen/interieur/1/index.jsp", "interieur", "", "478", "0"}); %><% MENU_ITEMS.add(new String[] {"kind & jeugd", "http://www.racine.be/content/terralannoo/fondsen/kindjeugd/1/index.jsp", "kindjeugd", "", "7763", "0"}); %><% MENU_ITEMS.add(new String[] {"kunst & cultuur", "http://www.racine.be/content/terralannoo/fondsen/kunstcultuur/1/index.jsp", "kunstcultuur", "", "481", "0"}); %><% MENU_ITEMS.add(new String[] {"multimedia", "http://www.racine.be/content/terralannoo/fondsen/multimedia/1/index.jsp", "multimedia", "", "7780", "0"}); %><% MENU_ITEMS.add(new String[] {"poëzie", "http://www.racine.be/content/terralannoo/fondsen/pozie/1/index.jsp", "pozie", "", "7781", "0"}); %><% MENU_ITEMS.add(new String[] {"reizen", "http://www.racine.be/content/terralannoo/fondsen/reizen/1/index.jsp", "reizen", "", "479", "0"}); %><% MENU_ITEMS.add(new String[] {"spiritualiteit", "http://www.racine.be/content/terralannoo/fondsen/spiritualiteit/1/index.jsp", "spiritualiteit", "", "7889", "0"}); %><% MENU_ITEMS.add(new String[] {"studie en beroep", "http://www.racine.be/content/lannoo/fondsen/studieberoep/1/index.jsp", "studieenberoep", "", "22245", "0"}); %><% MENU_ITEMS.add(new String[] {"tuin & natuur", "http://www.racine.be/content/terralannoo/fondsen/tuinnatuur/1/index.jsp", "tuinnatuur", "", "477", "0"}); %>
uitgebreid zoeken | zoektips
 
Schrijf u in voor de GRATIS nieuwsbrief
<% int MAX_MENULINE_LENGTH = 85; StringBuffer topMenu = new StringBuffer(""); int menuLineLength = 0; int totalMenuItems = MENU_ITEMS.size(); for (int i=0; i MAX_MENULINE_LENGTH) {//--start new line topMenu.append("
\n"); topMenu.append(""); topMenu.append(""); topMenu.append(""); if (pageActive==1) {//--next menu-item is active topMenu.append("\n"); } else { topMenu.append("\n"); } menuLineLength = 0; } boolean isEndOfLine = true; if ( (i+1)"); } topMenu.append(""); //--this is the active button: right image active if (isEndOfLine) {//--end of menu-line topMenu.append("\n"); } else { topMenu.append("\n"); } } else {//--in-active menu-item if (i==0) {//--begin of menu-line topMenu.append(""); } topMenu.append(""); //--this is the in-active button: right image in-active if (isEndOfLine) {//--end of menu-line topMenu.append("\n"); } else if (myNextMenuItemPageActive==1) {//--next menu-item is active topMenu.append("\n"); } else { topMenu.append("\n"); } } } %>
 " + menuTitle + " " + menuTitle + "
<%=""+topMenu%>
 
 
  
<% TEXT_TITLE = "Admin"; %> <%=TEXT_TITLE%>
 
<%if (MERK_ID.equals("11")){%> <%}else{%> <%}%> <% Connection conBest = null; String strSQLBest = null; int k = 1; int first = 0; try { registerSqlDriver(); conBest = DriverManager.getConnection(DB_CONN, DB_USR, DB_PSW); Statement stmtTop = conBest.createStatement (); strSQLBest = "SELECT dbo.Boek.Titel, dbo.HotTitles.Ranking, dbo.HotTitles.TitelCode, dbo.HotTitles.MerkId, dbo.HotTitles.FondsId, dbo.HotTitles.TypeId FROM dbo.Boek INNER JOIN dbo.HotTitles ON dbo.Boek.TitelCode = dbo.HotTitles.TitelCode WHERE (dbo.HotTitles.MerkId = '" + MERK_ID + "') AND (dbo.HotTitles.FondsId = '" + FONTS_ID + "') "; if (MERK_ID.equals("11")){//TROTTER HEEFT ENKEL EEN TOP 5 strSQLBest = strSQLBest + "AND (dbo.HotTitles.TypeId = 1) ORDER BY dbo.HotTitles.Ranking";//TOP 5 }else{ if (FONTS_ID.equals("0")){//HOMEPAGE EN DAN TONEN WE TOP 10 / BIJ FONDSEN TONEN WE TOP 5 strSQLBest = strSQLBest + "AND (dbo.HotTitles.TypeId = 2) ORDER BY dbo.HotTitles.Ranking";//TOP 10 }else{ strSQLBest = strSQLBest + "AND (dbo.HotTitles.TypeId = 1) ORDER BY dbo.HotTitles.Ranking";//TOP 5 } } //out.print(strSQLBest); ResultSet rsTop = stmtTop.executeQuery(strSQLBest); %> <%while (rsTop.next()){%> <%switch (Integer.parseInt(MERK_ID)){ case 1://LANNOO%> <%if (first != 0){%> <%}else{first = 1; }%> <%break; case 2://TERRA%> <%if (first != 0){%> <%}else {first = 1; }%> <%break; case 3://RACINE%> <%if (first != 0){%> <%}else{first = 1; }%> <%break; case 11://TROTTER%> <%if (first != 0){%> <%}else{first = 1; }%> <%break; } k = k + 1; }%>
TOP BESTEMMINGEN
BESTSELLERS
&fondsid=<%=FONTS_ID%>"><%=rsTop.getString("Titel")%>
&fondsid=<%=FONTS_ID%>"><%=rsTop.getString("Titel")%>
&fondsid=<%=FONTS_ID%>"><%=rsTop.getString("Titel")%>
&fondsid=<%=FONTS_ID%>"><%=rsTop.getString("Titel")%>
<% rsTop.close(); stmtTop.close(); } catch (Exception e) { out.println("
SQL:" + strSQLBest + "\n\terror: \n\t\t" + StringFunctions.exceptionToString(e) + "
"); } finally { try { if (conBest != null) { conBest.close(); } } catch (SQLException sqle) { out.println("°"); } }%>
 
<% //Wegschrijven via javascript van de linkse banners%> <%//Wegschrijven van de rechtse banners%> <%switch (Integer.parseInt(MERK_ID)){ case 1://LANNOO%> <%if(FONTS_ID.equals("9")){ //kind en jeugd%>
<%}%> <%if(FONTS_ID.equals("12")){ //reizen%>

<%}%> <%if (OID.equals("22447")){ //reisboeken%>

<%}%> <%if(FONTS_ID.equals("14")){ //multimedia%>

<%}%> <%break; case 2://TERRA%> <%if(FONTS_ID.equals("12")){ //reizen%>

<%}%> <%if(FONTS_ID.equals("9")){ //kind en jeugd%>

<%}%> <%if(FONTS_ID.equals("2")){ //culinair%>

<%}%> <%break; case 11://TROTTER%>
<%break; }%> <%//Wegschrijven van de logo's%> 		   
 
 
<%switch (Integer.parseInt(MERK_ID)){ case 1:%> Pers | Disclaimer | Verkoopvoorwaarden | Server hosting door Dedicated server hosting door COMBELL <%if (OID.equals("13403") || OID.equals("13414") || OID.equals("13415")) {//LANNOO GROUP%> | Drukkerij Lannoo nv <%}%> <%break; case 2:%> © Terra Lannoo BV | Algemene Voorwaarden | Disclaimer <%break; case 3:%> Pers | Disclaimer <%break; case 11:%> Overzicht trotters | Overzicht bestemmingen | Over Trotter | Contact | Credits | Links <%break; }%>
   
<%switch (Integer.parseInt(MERK_ID)){ case 1://LANNOO%> <%if (OID.equals("216")){//HOME%> <%} else if (OID.equals("13419")){//EXPORT%> <%} else if (OID.equals("13420")){//FOREIGN RIGHTS%> <%} else if (OID.equals("22246")){//GESCHENKENSITE%> <%} else if (OID.equals("22437")){//EINDEJAAR%> <%} else if (OID.equals("22565")){//PROMO 2007%> <%} else if (FONTS_ID.equals("11")){//gezin & opvoeden%> <%} else if (OID.equals("488")){//pagina's met spandoek, zonder skyscraper%> <%}%> <%if(FONTS_ID.equals("4") || FONTS_ID.equals("6") || FONTS_ID.equals("7") || FONTS_ID.equals("10") || FONTS_ID.equals("13") || FONTS_ID.equals("17") ){ %> <% } else if (FONTS_ID.equals("5")) {//actua %> <% } else if (FONTS_ID.equals("12")) {//reizen %> <% } else if (FONTS_ID.equals("14")) {//Multimedia%> <% } else if (FONTS_ID.equals("2")) {//culinair %> <% } else if (FONTS_ID.equals("15")) {//poezie %> <%}%> <% break; case 2://TERRA%> <%if (OID.equals("219")){//HOMEPAGE%> <%} else if (FONTS_ID.equals("11")){//gezin & opvoeden%> <%}%> <% break; case 3://RACINE%> <%if (OID.equals("220")){//HOMEPAGE%> <%}%> <% break; case 11://TROTTER%> <% break; } %>