Chyba v ddw_interpret_code (error type:2) na radku c.85
error:mysqli::query(): (HY000/1194): Tabulka 'PRT' je ozna-Bèena jako porušená a mìla by být opravena
#MENU_SC_PAGES5 (vyrobeno MENU_SC_PAGES4) # Zobrazuje menu sekce, ukáže jen stránky které mají vyplnìn titulek do menu # 4.11.2015 global $cSection, $cAct_page_alias, $ctable_prefix, $ddw_debug_connecteddb, $connecteddb, $path_prefix; $ddw_cV='<div class="menu_bottom">'; $debug = false; $cTmp_table = "tmpindex"; ddw_create_temp_table($cTmp_table, 'id VARCHAR(20) NOT NULL, type VARCHAR(20) NOT NULL, order_nb VARCHAR(20)'); # sekce # ------ $oT = new ddw_table_prt_handle; $cS= 'SELECT bysec.part ' .'FROM ' .'PRT bysec ' .'WHERE ' .'bysec.type="SC" ' .'AND bysec.part LIKE "%" ' .'AND bysec.subpart="PARENT_LEVEL" ' .'AND bysec.content="'.$cSection.'" '; $oT->query($cS); $nCount = $oT->NumRows(); if (!($nCount==0)): for($i=0;$i<$nCount;$i++) { $section = $oT->get_field_universal($i,'part'); $order_nb = ddw_get_part_content(ddw_typ_SECTION,$section,'MENU_ORDER'); $cS = 'INSERT INTO '.$cTmp_table.' ' .'(id, type, order_nb) VALUES ' .'(' ."'".$section."'," ."'".ddw_typ_SECTION."'," ."'".$order_nb."'" .')'; $cV=ddw_mysql_query_err($cS ); } endif; $oT=""; # stranky # ------- $oT = new ddw_table_prt_handle; $oT->query( 'SELECT bysec.part ' .'FROM ' .' '.$ctable_prefix.'PRT bysec ' .'WHERE ' .' bysec.type="PG" AND ' .' bysec.part LIKE "%" AND ' .' bysec.subpart="SECTION" AND ' .' bysec.content="'.$cSection.'" AND ' .' bysec.status=" " ' ); $nCount = $oT->NumRows(); if ($debug) $ddw_cV .= '<p>#DEGUG# $nCount(stranky) = '.$nCount; $root_page = ddw_get_part_content('SC',$cSection,'ROOT_PAGE'); if (!($nCount==0)): for($i=0;$i<$nCount;$i++) { $page = $oT->get_field_universal($i,'part'); if ($debug) $ddw_cV .= '#DEGUG# $page = '.$page; if ($page <> $root_page) { $order_nb = ddw_get_part_content('PG',$page,'MENU_ORDER'); $cS = 'INSERT INTO '.$cTmp_table.' ' .'(id, type, order_nb) VALUES ' .'(' ."'".$page."'," ."'".ddw_typ_PAGE."'," ."'".$order_nb."'" .')'; $cV=ddw_mysql_query_err($cS ); } } endif; $oT=""; $TmpHandle=-1; #$prvni = true; if (ddw_select('SELECT * FROM '.$cTmp_table.' ORDER BY order_nb', $TmpHandle)) { $nCount=$TmpHandle->num_rows; for($r=0;$r<$nCount;$r++) { $cPart = ddw_mysql_result($TmpHandle,$r,'id'); if ($debug) $ddw_cV .= '<p>#DEGUG# $part = '.$cPart; $cType = ddw_mysql_result($TmpHandle,$r,'type'); $order_nb = ddw_mysql_result($TmpHandle,$r,'order_nb'); $title = ddw_get_part_content($cType,$cPart,'TITLE'); $menu_title = ddw_get_part_content($cType,$cPart,'MENU_TITLE'); if (!empty($menu_title)) { $url = $cPart; if ($cType == ddw_typ_SECTION) $url = ddw_get_part_content(ddw_typ_SECTION,$cPart,'ROOT_PAGE'); if (empty($url)) $url = $cPart; $iOrder = (ddw_is_edit()) ? '<span class="debug_info">' .'<a href="'.$path_prefix.'php/ddw_select_all.php?type='.$cType.'&part='.$cPart.'&subpart=MENU_ORDER&editor=pspad&action=OK+edit" target="_blank">['.$order_nb.']</a>' .'</span>' : ''; # if (!$prvni) $ddw_cV .= ' | '; # $ddw_cV .= # '<a href="index.php?show='.$url.'" title="'.$title.'"> # '.$menu_title.' # </a>'.$iOrder.' # '." #"; #$prvni = false; $ddw_cV .= '<span class="page_reference"> <a href="index.php?show='.$url.'" title="'.$title.'"> '.$menu_title.' </a></span>'.$iOrder.' '." "; } } } $cS = 'DROP TABLE '.$cTmp_table.' '; $cV = ddw_mysql_query_err($cS); if ( $cSection=='ROOT' ) { $ddw_cV .= ' | <a href="index.php?show=URLS" title="adresáø webových adres (URL)"> Adresáø </a> | <a href="index.php?show=urls_tema_modely" title="adresáø modely"> Adresáø modely </a> '; $ddw_cV .= ' | <a href="index.php?show=pojmy"> Slovníèek pojmù </a> '; } $ddw_cV .= '</div>';