Помогите разобраться в скрипте. Поставил скрип каталога сайтов My Links Manager v1.2.1, но он отображает все сплошной ссылкой "Имя сайта", "Описание" а хотелось бы чтобы "Имя сайта" была ссылкой и отображалось жирным шрифтом а "описание" была простым текстом.
Кажется дело кроется в этом коде, но стоит что-то переставить в ней как начинают вылезать разные ошибки:
1. Bers - 23 Июня, 2014 - 23:46:32 - перейти к сообщению
Вот пример чего я хочу: http://baikalfishing[dot]ru/links , http://catalog[dot]orenru[dot]ru . А вот чего не хочу: http://jetswap[dot]biz/catalog .
Хочу заметить что ноль в Php, так что надеюсь на вашу помощь.
Вот код страницы который идет до этого:
PHP:
скопировать код в буфер обмена
скопировать код в буфер обмена
- <?PHP
- /////////////////////////////////////
- // My Links Manager v1.2.1
- // (C) 2011-2013, Alexander Yanitsky
- // Web site: janicky.com
- // Email: janickiy@mail.ru
- // skype: janickiy
- /////////////////////////////////////
- // Switch off the identifier of session
- // Check the variables received by the GET's method
- // Require necessary classes
- require_once "class/class.exception_mysql.php";
- require_once "class/class.exception_object.php";
- require_once "class/class.exception_member.php";
- require_once 'class/PEAR/PEAR.php';
- require_once 'class/Sigma.php';
- try
- {
- // Require necessary libs
- require_once "lib/function.inc";
- require_once "lib/connect.inc";
- // Shield a special characters
- $_GET['search'] = $dbh->real_escape_string($_GET['search']);
- $_GET['id_cat'] = $dbh->real_escape_string($_GET['id_cat']);
- $_GET['logic'] = $dbh->real_escape_string($_GET['logic']);
- $_GET['url'] = $dbh->real_escape_string($_GET['url']);
- $_GET['id_catalog'] = $dbh->real_escape_string($_GET['id_catalog']);
- // Get a settings of catalogue
- $query = "SELECT * FROM ".DB_SETTING."";
- $result = $dbh->query($query);
- if(!$result) { throw new ExceptionMySQL($dbh->error,$query,"Error executing SQL query!"); }
- $settings = $result->fetch_array();
- $result->close();
- // interface modules, the description of pages and meta tags
- require "templates/language/".$settings['language']."/index.inc";
- require "templates/language/".$settings['language']."/language.inc";
- $order = ($settings['view_order'] == 1 ? "time" : "count");
- $desc = ($settings['order_link'] == 1 ? "" : "DESC");
- if($_GET['id_cat'])
- {
- $arraypathway=topbarmenu($_GET['id_cat'],'');
- if($settings['static'] == 1)
- $pathway = '<a href="index.html">'.STR_HOME.'</a> ';
- else
- $pathway = '<a href="index.php">'.STR_HOME.'</a> ';
- for($i=0; $i<count($arraypathway); $i++)
- {
- if($settings['static'] == "1")
- $pathway .= '» <a href="'.root().'page_'.$arraypathway[$i][0].'_1.html">'.$arraypathway[$i][1].'</a>';
- else
- $pathway .= '» <a href="http://'.$_SERVER['SERVER_NAME'].$_SERVER['PHP_SELF'].'?id_cat='.$arraypathway[$i][0].'">'.$arraypathway[$i][1].'</a>';
- }
- }
- {
- // include template
- $tpl = new HTML_Template_Sigma('.');
- $tpl->loadTemplateFile("templates/info.html");
- $query = "SELECT * FROM ".DB_LINK." WHERE hide = 'show' AND id_link = ".$_GET['id_link'];
- $result = $dbh->query($query);
- if(!$result) { throw new ExceptionMySQL($dbh->error,$query,"Error executing SQL query!"); }
- $links = $result->fetch_array();
- $result->close();
- $query = "SELECT * FROM ".DB_CATALOG." WHERE id_cat = ".$links['id_cat'];
- $result = $dbh->query($query);
- if(!$result) { throw new ExceptionMySQL($dbh->error,$query,"Error executing SQL query!"); }
- $row = $result->fetch_array();
- $result->close();
- $description = $links['description_link'];
- $keywords = $links['kwdlink'];
- $title = "".$titlepage." ".$version." - ".$row['name']."";
- // Header
- 'description' => $description,
- 'keywords' => $keywords,
- 'version' => $version));
- $query = "SELECT COUNT(*) FROM ".DB_LINK." WHERE hide = 'show'";
- $result = $dbh->query($query);
- $total = $result->fetch_assoc();
- $result->close();
- 'name' => $row['name']));
- $links['full_description_link'] = preg_replace("/\\r\\n/s","<br />", $links['full_description_link']);
- if($settings['static'] == 1)
- {
- $link_go_back = "".root()."page_".$links['id_cat']."_1.html";
- }
- else
- {
- $link_go_back = "http://".$_SERVER['SERVER_NAME'].$_SERVER['PHP_SELF']."?id_cat=".$links['id_cat'];
- }
- $url_to_site = "".$_SERVER['PHP_SELF']."?id_link=".$links['id_link']."&url=".$links['url']."";
- 'name_url' => $links['name'],
- 'full_description_link' => $links['full_description_link'],
- 'url_to_site' => $url_to_site,
- 'GO_BACK' => STR_GO_BACK,
- 'GO_TO_WEBSITE' => GO_TO_WEBSITE));
- if($total['COUNT(*)']>3)
- {
- $tpl->parse('int');
- }
- if($_GET['url'])
- {
- // If there is a URL then count one click
- $update = "UPDATE ".DB_LINK." SET count=COUNT+1 WHERE id_link = ".$_GET['id_link'];
- if($dbh->query($update))
- {
- // Make a redirect
- $tpl->parse('redirect');
- }
- }
- // footer
- 'AUTHOR' => AUTHOR));
- // print html page
- $tpl->show();
- }
- else
- {
- // include template
- $tpl = new HTML_Template_Sigma('.');
- $tpl->loadTemplateFile("templates/index.html");
- {
- // Get the meta tags of catalogue
- $query = "SELECT description,keywords,name FROM ".DB_CATALOG." WHERE id_cat = ".$_GET['id_cat'];
- $result = $dbh->query($query);
- if(!$result) { throw new ExceptionMySQL($dbh->error,$query,"Error executing SQL query!"); }
- $row = $result->fetch_assoc();
- $description = $row['description'];
- $keywords = $row['keywords'];
- $title = "".$titlepage." ".$version." - ".$row['name'];
- $result->close();
- }
- // Elements of the pagination
- $all_number_link = 5;
- else
- $all_number_link = $settings['all_number_link'];
- $page = $_GET['page'];
- $begin = ($page - 1)*$all_number_link;
- if(!$_GET['id_cat']) $id_cat = 0;
- else $id_cat =$_GET['id_cat'];
- $query = "SELECT * FROM ".DB_CATALOG." WHERE id_parent=".$id_cat." ORDER BY name";
- $result = $dbh->query($query);
- if(!$result) { throw new ExceptionMySQL($dbh->error,$query,"Error executing SQL query!"); }
- while($row = $result->fetch_array())
- {
- }
- $result->close();
- $number = (int)($total/$settings['stl']);
- if((float)($total/$settings['stl']) - $number != 0) $number++;
- // Form an array
- for($i=0; $i<$number; $i++)
- {
- for($j=0; $j<$settings['stl']; $j++)
- {
- $arr[$i][$j] = $arraycat[$j*$number + $i];
- }
- }
- $print_cat = '<table width="100%" border="0">';
- for($i = 0; $i < $number; $i++)
- {
- $print_cat .= '<tr>';
- for($j = 0; $j < $settings['stl']; $j++)
- {
- if($arr[$i][$j][0])
- {
- if($settings['static'] == "1")
- $tlink = "".root()."page_".$arr[$i][$j][1]."_1.html";
- else
- $tlink = "http://".$_SERVER['SERVER_NAME'].$_SERVER['PHP_SELF']."?id_cat=".$arr[$i][$j][1];
- $query = "SELECT * FROM ".DB_CATALOG." WHERE image != '' and id_cat=".$arr[$i][$j][1];
- $result = $dbh->query($query);
- if(!$result) { throw new ExceptionMySQL($dbh->error,$query,"Error executing SQL query!"); }
- if($result->num_rows>0)
- $imagefolder = "img.php?id_cat=".$arr[$i][$j][1];
- else
- $imagefolder = 'images/folder.gif';
- $print_cat .= '<td width="'.(int)(100/$settings['stl']).'%"><table border="0" class="folder"><tr>
- <td><img border="0" src="'.$imagefolder.'"></td>
- <td><a href="'.$tlink.'">'.$arr[$i][$j][0].'</a> <span>('.ShowNumbersLinks($arr[$i][$j][1],0).')</span><br><div class="subcat">'.ShowSubCat($arr[$i][$j][1],$settings['static']).'</div></td></tr>';
- $result->close();
- $print_cat .= '</table></td>';
- }
- }
- $print_cat .= '</tr>';
- }
- $print_cat .= '</table>';
- // Print the list of catalogues and subcatalogues
- $query = "SELECT * FROM ".DB_CATALOG." ORDER BY name";
- $result = $dbh->query($query);
- if(!$result) { throw new ExceptionMySQL($dbh->error,$query,"Error executing SQL query!"); }
- $slct = ($_GET['id_catalog'] == 0 ? 'checked="checked"' : "");
- $searchform['print_option'] = ShowCatalogList(0,0);
- $searchform['logic0'] = 'checked="checked"';
- else
- $searchform['logic0'] = '';
- $searchform['logic1'] = ($_GET['logic'] == 1 ? 'checked="checked"' : "");
- // Header
- 'description' => $description,
- 'keywords' => $keywords,
- 'version' => $version));
- 'topbarmenu' => $pathway,
- 'slct' => $slct,
- 'CATALOG_SEARCH' => CATALOG_SEARCH,
- 'KEYWORDS' => KEYWORDS,
- 'SEARCH' => SEARCH,
- 'IT_DOESNT_MATTER' => IT_DOESNT_MATTER,
- 'MEETINGS_OF_KEYWORDS' => MEETINGS_OF_KEYWORDS,
- 'AT_LEAST_ONCE' => AT_LEAST_ONCE,
- 'ALL_WORDS_TOGETHER' => ALL_WORDS_TOGETHER,
- 'FIND' => FIND));
- 'option' => $searchform['print_option'],
- 'logic0' => $searchform['logic0'],
- 'logic1' => $searchform['logic1']));
- {
- 'ADD_URL' => ADD_URL));
- // Print a last added links
- $query = "SELECT * FROM ".DB_LINK."
- WHERE hide = 'show'
- ORDER BY time DESC
- LIMIT ".$settings['all_number_new'];
- $result = $dbh->query($query);
- if(!$result) { throw new ExceptionMySQL($dbh->error,$query,"Error executing SQL query!"); }
- if($result->num_rows > 0)
- {
- $no_links = '';
- while($links = $result->fetch_array())
- {
- if($settings['static'] == "1")
- {
- if($_GET['page'])
- $dlink = "".root()."link_".$links['id_link']."_".$_GET['page'].".html";
- else
- $dlink = "".root()."link_".$links['id_link'].".html";
- }
- else
- {
- if($_GET['page'])
- $dlink = "http://".$_SERVER['SERVER_NAME'].$_SERVER['PHP_SELF']."?id_link=".$links['id_link']."&page=".$_GET['page'];
- else
- $dlink = "http://".$_SERVER['SERVER_NAME'].$_SERVER['PHP_SELF']."?id_link=".$links['id_link'];
- }
- // Print links
- $query2 = "SELECT name FROM ".DB_CATALOG." WHERE id_cat = ".$links['id_cat'];
- $result2 = $dbh->query($query2);
- $catalog = $result2->fetch_array();
- $htmlcode_banner = $links['htmlcode_banner'];
- else
- $htmlcode_banner = '<a href=http://'.$links['url'].' target=_blank><img border="0" width="49" height="19" src="images/notimage.gif"></a>';
- $description_link = $links['description_link'];
- else
- $description_link = '<a href=http://'.$links['url'].' target=_blank>' .$links['name'].' - ' .nl2br($links['description_link']).'</a>';
- if($settings['show_pr'] == "yes")
- $show_pr = '<iframe src="show_pr.php?url='.$links['url'].'" frameborder="0" scrolling="no" width="125" height="50"></iframe> ';
- else
- $show_pr = '';
- if($settings['show_cy'] == "yes")
- $show_cy = '<iframe src="show_cy.php?url='.$links['url'].'" frameborder="0" scrolling="no" width="125" height="50"></iframe>';
- else
- $show_cy = '';