fork download
copy 
  1.  
  2. <?php 
  3. /*******************************************
  4. * Ultimate Sphider Version 2.0.1*
  5. * This program is licensed under the GNU GPL.
  6. * By Ando Saabas           ando(a t)cs.ioc.ee<br />
  7. * By Shaquille Ray
  8. ********************************************/
  9.  
  10. error_reporting (E_ALL ^ E_NOTICE);
  11.  
  12. $include_dir = "../include";
  13. include "auth.php";
  14. include "$include_dir/commonfuncs.php";
  15. extract (getHttpVars());
  16. $settings_dir = "../settings";
  17. $template_dir = "../templates";
  18. include "$settings_dir/conf.php";
  19. set_time_limit (0);
  20.  
  21.  
  22. ?>
  23. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://w...content-available-to-author-only...3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
  24. <html xmlns="http://w...content-available-to-author-only...3.org/1999/xhtml" xml:lang="en">
  25. <head>
  26. <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
  27. <title>Ultimate Sphider CMS</title>
  28. <link rel="stylesheet" href="admin.css" type="text/css" />
  29. </head>
  30. <body>
  31. <div id="container">
  32. 	<div id="headleft">
  33. 		<a href="http://w...content-available-to-author-only...r.com/"><img src="sulogo-head.png" align="left" /></a>
  34. 	</div>
  35.  
  36. 	<div id="headright">
  37. 		<?php include_once('http://o...content-available-to-author-only...r.com/us-resources/2.0.1/2.0.1announce.php') ?>
  38.  
  39. 	</div>
  40.     </div>
  41. <?php 
  42. if (!isset($f)) {
  43. 	$f=2;
  44. }
  45. $site_funcs = Array (22=> "default",21=> "default",4=> "default", 19=> "default", 1=> "default", 2 => "default", "add_site" => "default", 20=> "default", "edit_site" => "default", 5=>"default");
  46. $stat_funcs = Array ("statistics" => "default",  "delete_log"=> "default");
  47. $settings_funcs = Array ("settings" => "default");
  48. $index_funcs = Array ("index" => "default");
  49. $index_funcs = Array ("index" => "default");
  50. $clean_funcs = Array ("clean" => "default", 15=>"default", 16=>"default", 17=>"default", 23=>"default");
  51. $cat_funcs = Array (11=> "default", 10=> "default", "categories" => "default", "edit_cat"=>"default", "delete_cat"=>"default", "add_cat" => "default", 7=> "default");
  52. $database_funcs = Array ("database" => "default");
  53. ?>
  54.  
  55. <div id="admin"> 
  56. 	<div id="tabs">
  57. 		<ul>
  58. 		<?php 	
  59. 		if ($stat_funcs[$f] ) {
  60. 			$stat_funcs[$f] = "selected";
  61. 		} else {
  62. 			$stat_funcs[$f] = "default";
  63. 		}
  64.  
  65. 		if ($site_funcs[$f] ) {
  66. 			$site_funcs[$f] = "selected";
  67. 		}else {
  68. 			$site_funcs[$f] = "default";
  69. 		}
  70.  
  71. 		if ($settings_funcs[$f] ) {
  72. 			$settings_funcs[$f] = "selected";
  73. 		} else {
  74. 			$settings_funcs[$f] = "default";
  75. 		} 
  76.  
  77. 		if ($index_funcs[$f] ) {
  78. 			$index_funcs[$f]  = "selected";
  79. 		} else {
  80. 			$index_funcs[$f] = "default";
  81. 		} 
  82.  
  83. 		if ($cat_funcs[$f] ) {
  84. 			$cat_funcs[$f]  = "selected";
  85. 		} else {
  86. 			$cat_funcs[$f] = "default";
  87. 		} 
  88.  
  89. 		if ($clean_funcs[$f] ) {
  90. 			$clean_funcs[$f]  = "selected";
  91. 		} else {
  92. 			$clean_funcs[$f] = "default";
  93. 		} 
  94.  
  95. 		if ($database_funcs[$f] ) {
  96. 			$database_funcs[$f]  = "selected";
  97. 		} else {
  98. 			$database_funcs[$f] = "default";
  99. 		} 
  100. 		?>
  101.  
  102. 		<li><a href="admin.php?f=2" id="<?php print $site_funcs[$f]?>">Sites</a>  </li>
  103. 		<li><a href="admin.php?f=categories" id="<?php print $cat_funcs[$f]?>">Categories</a></li> 
  104. 		<li><a href="admin.php?f=index" id="<?php print $index_funcs[$f]?>">Index</a></li>
  105. 		<li><a href="admin.php?f=clean" id="<?php print $clean_funcs[$f]?>">Clean tables</a> </li>
  106. 		<li><a href="admin.php?f=settings" id="<?php print $settings_funcs[$f]?>">Settings</a></li>
  107. 		<li><a href="admin.php?f=statistics" id="<?php print $stat_funcs[$f]?>">Statistics</a> </li>
  108. 		<li><a href="admin.php?f=database" id="<?php print $database_funcs[$f]?>">Database</a></li>
  109. 		<li><a href="admin.php?f=24" id="default">Log out</a></li>
  110. 		</ul>
  111. 	</div>
  112. 	<div id="main">
  113.  
  114. <?php 
  115. 	function list_cats($parent, $lev, $color, $message) {
  116. 		global $mysql_table_prefix;
  117. 		if ($lev == 0) {
  118. 			?>
  119. 			<div id="submenu">
  120. 				<ul>
  121. 				<li><a href="admin.php?f=add_cat">Add category</a> </li>
  122. 				</ul>
  123. 			</div>
  124. 			<?php 
  125. 			print $message;
  126. 			print "<br/>";
  127. 			print "<br/><div align=\"center\"><center><table cellspacing =\"0\" cellpadding=\"0\" class=\"darkgrey\" width =\"600\"><tr><td><table table cellpadding=\"3\" cellspacing=\"1\" width=\"100%\">\n";
  128. 		}
  129. 		$space = "";
  130. 		for ($x = 0; $x < $lev; $x++)
  131. 			$space .= "&nbsp;&nbsp;&nbsp;&nbsp;";
  132.  
  133. 		$query = "SELECT * FROM ".$mysql_table_prefix."categories WHERE parent_num=$parent ORDER BY category";
  134. 		$result = mysql_query($query);
  135. 		echo mysql_error();
  136.  
  137. 		if (mysql_num_rows($result) <> '')
  138. 			while ($row = mysql_fetch_array($result)) {
  139. 				if ($color =="white") 
  140. 					$color = "grey";
  141. 				else 
  142. 					$color = "white";				
  143.  
  144. 				$id = $row['category_id'];
  145. 				$cat = $row['category'];
  146. 				print "<tr class=\"$color\"><td width=90% align=left>$space<a href=\"admin.php?f=edit_cat&cat_id=$id\">".stripslashes($cat). "</a></td><td><a href=\"admin.php?f=edit_cat&cat_id=$id\" id=\"small_button\">Edit</a></td><td> <a href=\"admin.php?f=11&cat_id=$id\" onclick=\"return confirm('Are you sure you want to delete? Subcategories will be lost.')\" id=\"small_button\">Delete</a></td></tr>\n";
  147.  
  148. 				$color = list_cats($id, $lev + 1, $color, "");
  149. 			}
  150.  
  151. 		if ($lev == 0)
  152. 			print "</table></td></tr></table></center></div>\n";
  153. 		return $color;
  154. 	}
  155.  
  156. 	function walk_through_cats($parent, $lev, $site_id) {
  157. 		global $mysql_table_prefix;
  158. 		$space = "";
  159. 		for ($x = 0; $x < $lev; $x++)
  160. 			$space .= "&nbsp;&nbsp;&nbsp;&nbsp;";
  161.  
  162. 		$query = "SELECT * FROM ".$mysql_table_prefix."categories WHERE parent_num=$parent ORDER BY category";
  163. 		$result = mysql_query($query);
  164. 		echo mysql_error();
  165.  
  166. 		if (mysql_num_rows($result) <> '')
  167. 			while ($row = mysql_fetch_array($result)) {
  168. 				$id = $row['category_id'];
  169. 				$cat = $row['category'];
  170. 				$state = '';
  171. 				if ($site_id <> '') {
  172. 					$result2 = mysql_query("select * from ".$mysql_table_prefix."site_category where site_id=$site_id and category_id=$id");
  173. 					echo mysql_error();
  174. 					$rows = mysql_num_rows($result2);
  175.  
  176. 					if ($rows > 0)
  177. 						$state = "checked";
  178. 				}
  179.  
  180. 				print $space . "<input type=checkbox name=cat[$id] $state>" . $cat . "<br/>\n";
  181. 				;
  182. 				walk_through_cats($id, $lev + 1, $site_id);
  183. 			}
  184. 	}
  185.  
  186.  
  187.  
  188.  
  189.  
  190.  
  191. function addcatform($parent) {
  192. 	global $mysql_table_prefix;
  193. 	$par2 = "";
  194. 	$par2num = "";
  195. 	?>
  196. 	<div id="submenu">
  197. 	</div>
  198. 	<?php 
  199. 	if ($parent=='') 
  200. 		$par='(Top level)';
  201. 	else {
  202. 		$query = "SELECT category, parent_num FROM ".$mysql_table_prefix."categories WHERE category_id='$parent'";
  203. 		$result = mysql_query($query);
  204. 		if (!mysql_error())	{
  205. 			if ($row = mysql_fetch_row($result)) {
  206. 				$par=$row[0];
  207. 				$query = "SELECT Category_ID, Category FROM ".$mysql_table_prefix."categories WHERE Category_ID='$row[1]'";
  208. 				$result = mysql_query($query);
  209. 				echo mysql_error();
  210. 				if (mysql_num_rows($result)<>'') {
  211. 					$row = mysql_fetch_row($result);
  212. 					$par2num = $row[0];
  213. 					$par2 = $row[1];
  214. 				}
  215. 				else
  216. 					$par2 = "Top level";
  217.  
  218. 				}
  219. 			}
  220. 		else
  221. 			echo mysql_error();
  222. 		print "</td></tr></table>";
  223. 	}
  224.  
  225. ?>
  226. 	   <br/><center><table><tr><td valign=top align=center colspan=2><b>Parent: <?php print "<a href=admin.php?f=add_cat&parent=$par2num>$par2</a> >".stripslashes($par)?></b></td></tr>
  227. 		<form action=admin.php method=post>
  228.    		<input type=hidden name=f value=7>
  229.    		<input type=hidden name=parent value="<?php print $parent?>"
  230. 		<tr><td><b>Category:</b></td><td> <input type=text name=category size=40></td></tr>
  231. 		<tr><td></td><td><input type=submit id="submit" value=Add></td></tr></form>
  232.  
  233. <?php 
  234. 	print "<tr><td colspan=2>";
  235. 	$query = "SELECT category_ID, Category FROM ".$mysql_table_prefix."categories WHERE parent_num='$parent'";
  236. 	$result = mysql_query($query);
  237. 	echo mysql_error();
  238. 	if (mysql_num_rows($result)>0) {
  239. 		print "<br/><b>Create subcategory under</b><br/><br/>";
  240. 	}
  241. 	while ($row = mysql_fetch_row($result)) {
  242. 		print "<a href=\"admin.php?f=add_cat&parent=$row[0]\">".stripslashes($row[1])."</a><br/>";
  243. 	}
  244. 	print "</td></tr></table></center>";
  245. }
  246.  
  247.  
  248. 	function addcat ($category, $parent) {
  249. 			global $mysql_table_prefix;
  250. 			if ($category=="") return;
  251. 		$category = addslashes($category);
  252. 		if ($parent == "") {
  253. 			$parent = 0;
  254. 		}
  255. 		$query = "INSERT INTO ".$mysql_table_prefix."categories (category, parent_num)
  256. 				 VALUES ('$category', ".$parent.")";
  257. 		mysql_query($query);
  258. 		If (!mysql_error()) {
  259. 			return "<center><b>Category $category added.</b></center>" ;
  260. 		} else {
  261. 			return mysql_error();
  262. 		}
  263. 	}
  264.  
  265.  
  266.  
  267.  
  268. 	function addsiteform() {
  269. 		?>
  270. 		<div id="submenu"><center><b>Add a site</b></center></div>
  271. 		<br/><div align=center><center><table>
  272. 		<form action=admin.php method=post>
  273.    		<input type=hidden name=f value=1>
  274. 		<input type=hidden name=af value=2>
  275. 		<tr><td><b>URL:</b></td><td align ="right"></td><td><input type=text name=url size=60 value ="http://"></td></tr>
  276. 		<tr><td><b>Title:</b></td><td></td><td> <input type=text name=title size=60></td></tr>
  277. 		<tr><td><b>Short description:</b></td><td></td><td><textarea name=short_desc cols=45 rows=3 wrap="virtual"></textarea></td></tr>
  278. 		<tr><td>Category:</td><td></td><td>
  279. 		<?php  walk_through_cats(0, 0, '');?></td></tr>
  280. 		<tr><td></td><td></td><td><input type=submit id="submit" value=Add></td></tr></form></table></center></div>
  281. 		<?php 
  282. 	}
  283.  
  284. 	function editsiteform($site_id) {
  285. 		global $mysql_table_prefix;
  286. 		$result = mysql_query("SELECT site_id, url, title, short_desc, spider_depth, required, disallowed, can_leave_domain from ".$mysql_table_prefix."sites where site_id=$site_id");
  287. 		echo mysql_error();
  288. 		$row = mysql_fetch_array($result);
  289. 		$depth = $row['spider_depth'];
  290. 		$fullchecked = "";
  291. 		$depthchecked = "";		
  292. 		if ($depth == -1 ) {
  293. 			$fullchecked = "checked";
  294. 			$depth ="";
  295. 		} else {
  296. 			$depthchecked = "checked";
  297. 		}
  298. 		$leave_domain = $row['can_leave_domain'];
  299. 		if ($leave_domain == 1 ) {
  300. 			$domainchecked = "checked";
  301. 		} else {
  302. 			$domainchecked = "";
  303. 		}		
  304. 		?>
  305. 					<div id="submenu"><center><b>Edit site</b></center>
  306. 			</div>
  307. 			<br/><div align=center><center><table>
  308. 			<form action=admin.php method=post>
  309. 			<input type=hidden name=f value=4>
  310. 			<input type=hidden name=site_id value=<?php print $site_id;?>>
  311. 			<tr><td><b>URL:</b></td><td align ="right"></td><td><input type=text name=url value=<?php print "\"".$row['url']."\""?> size=60></td></tr>
  312. 			<tr><td><b>Title:</b></td><td></td><td> <input type=text name=title value=<?php print  "\"".stripslashes($row['title'])."\""?> size=60></td></tr>
  313. 			<tr><td><b>Short description:</b></td><td></td><td><textarea name=short_desc cols=45 rows=3 wrap><?php print stripslashes($row['short_desc'])?></textarea></td></tr>
  314. 			<tr><td><b>Spidering options:</b></td><td></td><td><input type="radio" name="soption" value="full" <?php print $fullchecked;?>> Full<br/>
  315. 			<input type="radio" name="soption" value="level" <?php print $depthchecked;?>>To depth: <input type="text" name="depth" size="2" value="<?php print $depth;?>"><br/>
  316. 			<input type="checkbox" name="domaincb" value="1" <?php print $domainchecked;?>> Spider can leave domain
  317. 			</td></tr>			
  318. 			<tr><td><b>URLs must include:</b></td><td></td><td><textarea name=in cols=45 rows=2 wrap="virtual"><?php print $row['required'];?></textarea></td></tr>
  319. 			<tr><td><b>URLs must not include:</b></td><td></td><td><textarea name=out cols=45 rows=2 wrap="virtual"><?php print $row['disallowed'];?></textarea></td></tr>
  320.  
  321. 			<tr><td>Category:</td><td></td><td>
  322. 			<?php  walk_through_cats(0, 0, $site_id);?></td></tr>
  323. 			<tr><td></td><td></td><td><input type="submit"  id="submit"  value="Update"></td></tr></form></table></center></div>
  324. 		<?php 
  325. 		}
  326.  
  327.  
  328. 		function editsite ($site_id, $url, $title, $short_desc, $depth, $required, $disallowed, $domaincb,  $cat) {
  329. 			global $mysql_table_prefix;
  330. 			$short_desc = addslashes($short_desc);
  331. 			$title = addslashes($title);
  332. 			mysql_query("delete from ".$mysql_table_prefix."site_category where site_id=$site_id");
  333. 			echo mysql_error();
  334. 			$compurl=parse_url($url);
  335. 			if ($compurl['path']=='')
  336. 				$url=$url."/";
  337. 			mysql_query("UPDATE ".$mysql_table_prefix."sites SET url='$url', title='$title', short_desc='$short_desc', spider_depth =$depth, required='$required', disallowed='$disallowed', can_leave_domain=$domaincb WHERE site_id=$site_id");
  338. 			echo mysql_error();
  339. 			$result=mysql_query("select category_id from ".$mysql_table_prefix."categories");
  340. 			echo mysql_error();
  341. 			print mysql_error();
  342. 			while ($row=mysql_fetch_row($result)) {
  343. 				$cat_id=$row[0];
  344. 				if ($cat[$cat_id]=='on') {
  345. 					mysql_query("INSERT INTO ".$mysql_table_prefix."site_category (site_id, category_id) values ('$site_id', '$cat_id')");
  346. 					echo mysql_error();
  347. 				}
  348. 			}
  349. 			If (!mysql_error()) {
  350. 				return "<br/><center><b>Site updated.</b></center>" ;
  351. 			} else {
  352. 				return mysql_error();
  353. 			}
  354. 		}
  355.  
  356. 	function editcatform($cat_id) {
  357. 		global $mysql_table_prefix;
  358. 		$result = mysql_query("SELECT category FROM ".$mysql_table_prefix."categories where category_id='$cat_id'");
  359. 		echo mysql_error();
  360. 		$row=mysql_fetch_array($result);
  361. 		$category=$row[0];
  362. 		?>
  363. 				<div id="submenu">
  364. 				<center><b>Edit category</b></center>
  365. 			</div>
  366. 			<br/>
  367. 		   <div align="center"><center><table>
  368. 			<form action="admin.php" method="post">
  369. 			<input type="hidden" name="f" value="10">
  370. 			<input type="hidden" name="cat_id" value="<?php  print $cat_id;?>"
  371. 			<tr><td><b>Category:</b></td><td> <input type="text" name="category" value="<?php print $category?>"size=40></td></tr>
  372. 			<tr><td></td><td><input type="submit"  id="submit"  value="Update"></td></tr></form></table></center></div>
  373. 		<?php 
  374. 		}
  375.  
  376.  
  377. 	function editcat ($cat_id, $category) {
  378. 		global $mysql_table_prefix;
  379. 		$qry = "UPDATE ".$mysql_table_prefix."categories SET category='".addslashes($category)."' WHERE category_id='$cat_id'";
  380. 		mysql_query($qry);
  381. 		if (!mysql_error())	{
  382. 			return "<br/><center><b>Category updated</b></center>";
  383. 		} else {
  384. 			return mysql_error();
  385. 		}
  386. 	}
  387.  
  388.  
  389.  
  390. 	function showsites($message) {
  391. 		global $mysql_table_prefix;
  392. 		$result = mysql_query("SELECT site_id, url, title, indexdate from ".$mysql_table_prefix."sites ORDER By indexdate, title");
  393. 		echo mysql_error();
  394. 		?>
  395. 		<div id='submenu'>
  396. 		 <ul>
  397. 		  <li><a href='admin.php?f=add_site'>Add site</a> </li>
  398. 		  <?php 
  399. 			if (mysql_num_rows($result) > 0) {
  400. 				?>
  401. 				<li><a href='spider.php?all=1'> Reindex all</a></li>
  402. 				<?php 
  403. 			}
  404. 			?>
  405. 		 </ul>
  406. 		</div>
  407.  
  408. 		<?php 
  409. 		print $message;
  410. 		print "<br/>";
  411. 		if (mysql_num_rows($result) > 0) {
  412. 			print "<div align=\"center\"><table cellspacing =\"0\" cellpadding=\"0\" class=\"darkgrey\"><tr><td><table cellpadding=\"3\" cellspacing=\"1\">
  413. 			<tr class=\"grey\"><td align=\"center\"><b>Site name</b></td><td align=\"center\"><b>Site url</b></td><td align=\"center\"><b>Last indexed</b></td><td colspan=4></td></tr>\n";
  414. 		} else {
  415. 			?><center><p><b>Welcom to Sphider. <br><br>Choose "Add site" from the submenu to add a new site, or "Index" to directly go to the indexing section.</b></p></center><?php 
  416. 		}
  417. 		$class = "grey";
  418. 		while ($row=mysql_fetch_array($result))	{
  419. 			if ($row['indexdate']=='') {
  420. 				$indexstatus="<font color=\"red\">Not indexed</font>";
  421. 				$indexoption="<a href=\"admin.php?f=index&url=$row[url]\">Index</a>";
  422. 			} else {
  423. 				$site_id = $row['site_id'];
  424. 				$result2 = mysql_query("SELECT site_id from ".$mysql_table_prefix."pending where site_id =$site_id");
  425. 				echo mysql_error();			
  426. 				$row2=mysql_fetch_array($result2);
  427. 				if ($row2['site_id'] == $row['site_id']) {
  428. 					$indexstatus = "Unfinished";
  429. 					$indexoption="<a href=\"admin.php?f=index&url=$row[url]\">Continue</a>";
  430.  
  431. 				} else {
  432. 					$indexstatus = $row['indexdate'];
  433. 					$indexoption="<a href=\"admin.php?f=index&url=$row[url]&reindex=1\">Re-index</a>";
  434. 				}
  435. 			}
  436. 			if ($class =="white") 
  437. 				$class = "grey";
  438. 			else 
  439. 				$class = "white";
  440. 			print "<tr class=\"$class\"><td align=\"left\">".stripslashes($row[title])."</td><td align=\"left\"><a href=\"$row[url]\">$row[url]</a></td><td>$indexstatus</td>";
  441. 			print "<td><a href=admin.php?f=20&site_id=$row[site_id] id=\"small_button\">Options</a></td></tr>\n";
  442.  
  443. 		}
  444. 		if (mysql_num_rows($result) > 0) {
  445. 			print "</table></td></tr></table></div>";
  446. 		}
  447. 	}
  448.  
  449. 	function deletecat($cat_id) {
  450. 		global $mysql_table_prefix;
  451. 		$list = implode(",", get_cats($cat_id));
  452. 		mysql_query("delete from ".$mysql_table_prefix."categories where category_id in ($list)");
  453. 		echo mysql_error();
  454. 		mysql_query("delete from ".$mysql_table_prefix."site_category where category_id=$cat_id");
  455. 		echo mysql_error();
  456. 		return "<center><b>Category deleted.</b></center>";
  457. 	}
  458. 	function deletesite($site_id) {
  459. 		global $mysql_table_prefix;
  460. 		mysql_query("delete from ".$mysql_table_prefix."sites where site_id=$site_id");
  461. 		echo mysql_error();
  462. 		mysql_query("delete from ".$mysql_table_prefix."site_category where site_id=$site_id");
  463. 		echo mysql_error();
  464. 		$query = "select link_id from ".$mysql_table_prefix."links where site_id=$site_id";
  465. 		$result = mysql_query($query);
  466. 		echo mysql_error();
  467. 		$todelete = array();
  468. 		while ($row=mysql_fetch_array($result)) {
  469. 			$todelete[]=$row['link_id'];
  470. 		}
  471.  
  472. 		if (count($todelete)>0) {
  473. 			$todelete = implode(",", $todelete);
  474. 			for ($i=0;$i<=15; $i++) {
  475. 				$char = dechex($i);
  476. 				$query = "delete from ".$mysql_table_prefix."link_keyword$char where link_id in($todelete)";
  477. 				mysql_query($query);
  478. 				echo mysql_error();
  479. 			}
  480. 		}
  481.  
  482. 		mysql_query("delete from ".$mysql_table_prefix."links where site_id=$site_id");
  483. 		echo mysql_error();
  484. 		mysql_query("delete from ".$mysql_table_prefix."pending where site_id=$site_id");
  485. 		echo mysql_error();
  486. 		return "<br/><center><b>Site deleted</b></center>";
  487. 	}
  488.  
  489. 	function deletePage($link_id) {
  490. 		global $mysql_table_prefix;
  491. 		mysql_query("delete from ".$mysql_table_prefix."links where link_id=$link_id");
  492. 		echo mysql_error();
  493. 		for ($i=0;$i<=15; $i++) {
  494. 			$char = dechex($i);
  495. 			mysql_query("delete from ".$mysql_table_prefix."link_keyword$char where link_id=$link_id");
  496. 		}
  497. 		echo mysql_error();
  498. 		return "<br/><center><b>Page deleted</b></center>";
  499. 	}
  500.  
  501.  
  502. 	function cleanTemp() {
  503. 		global $mysql_table_prefix;
  504. 		$result = mysql_query("delete from ".$mysql_table_prefix."temp where level >= 0");
  505. 		echo mysql_error();
  506. 		$del = mysql_affected_rows();
  507. 				?>
  508. 		<div id="submenu">
  509. 		</div><?php 
  510. 		print "<br/><center><b>Temp table cleared, $del items deleted.</b></center>";
  511. 	}
  512.  
  513. 	function clearLog() {
  514. 		global $mysql_table_prefix;
  515. 		$result = mysql_query("delete from ".$mysql_table_prefix."query_log where time >= 0");
  516. 		echo mysql_error();
  517. 		$del = mysql_affected_rows();
  518. 		?>
  519. 		<div id="submenu">
  520. 		</div><?php 
  521. 		print "<br/><center><b>Search log cleared, $del items deleted.</b></center>";
  522. 	}
  523.  
  524.  
  525. 	function cleanLinks() {
  526. 		global $mysql_table_prefix;
  527. 		$query = "select site_id from ".$mysql_table_prefix."sites";
  528. 		$result = mysql_query($query);
  529. 		echo mysql_error();
  530. 		$todelete = array();
  531. 		if (mysql_num_rows($result)>0) {
  532. 			while ($row=mysql_fetch_array($result)) {
  533. 				$todelete[]=$row['site_id'];
  534. 			}
  535. 			$todelete = implode(",", $todelete);
  536. 			$sql_end = " not in ($todelete)";
  537. 		}
  538.  
  539. 		$result = mysql_query("select link_id from ".$mysql_table_prefix."links where site_id".$sql_end);
  540. 		echo mysql_error();
  541. 		$del = mysql_num_rows($result);
  542. 		while ($row=mysql_fetch_array($result)) {
  543. 			$link_id=$row[link_id];
  544. 			for ($i=0;$i<=15; $i++) {
  545. 				$char = dechex($i);
  546. 				mysql_query("delete from ".$mysql_table_prefix."link_keyword$char where link_id=$link_id");
  547. 				echo mysql_error();
  548. 			}
  549. 			mysql_query("delete from ".$mysql_table_prefix."links where link_id=$link_id");
  550. 			echo mysql_error();
  551. 		}
  552.  
  553. 		$result = mysql_query("select link_id from ".$mysql_table_prefix."links where site_id is NULL");
  554. 		echo mysql_error();
  555. 		$del += mysql_num_rows($result);
  556. 		while ($row=mysql_fetch_array($result)) {
  557. 			$link_id=$row[link_id];
  558. 			for ($i=0;$i<=15; $i++) {
  559. 				$char = dechex($i);
  560. 				mysql_query("delete from ".$mysql_table_prefix."link_keyword$char where link_id=$link_id");
  561. 				echo mysql_error();
  562. 			}
  563. 			mysql_query("delete from ".$mysql_table_prefix."links where link_id=$link_id");
  564. 			echo mysql_error();
  565. 		}
  566. 		?>
  567. 		<div id="submenu">
  568. 		</div><?php 
  569. 		print "<br/><center><b>Links table cleaned, $del links deleted.</b></center>";
  570. 	}
  571.  
  572. 	function cleanKeywords() {
  573. 		global $mysql_table_prefix;
  574. 		$query = "select keyword_id, keyword from ".$mysql_table_prefix."keywords";
  575. 		$result = mysql_query($query);
  576. 		echo mysql_error();
  577. 		$del = 0;
  578. 		while ($row=mysql_fetch_array($result)) {
  579. 			$keyId=$row['keyword_id'];
  580. 			$keyword=$row['keyword'];
  581. 			$wordmd5 = substr(md5($keyword), 0, 1);
  582. 			$query = "select keyword_id from ".$mysql_table_prefix."link_keyword$wordmd5 where keyword_id = $keyId";
  583. 			$result2 = mysql_query($query);
  584. 			echo mysql_error();
  585. 			if (mysql_num_rows($result2) < 1) {
  586. 				mysql_query("delete from ".$mysql_table_prefix."keywords where keyword_id=$keyId");
  587. 				echo mysql_error();
  588. 				$del++;
  589. 			}
  590. 		}?>
  591. 		<div id="submenu">
  592. 		</div><?php 
  593. 		print "<br/><center><b>Keywords table cleaned, $del keywords deleted.</b></center>";
  594. 	}
  595.  
  596. 	function getStatistics() {
  597. 		global $mysql_table_prefix;
  598. 		$stats = array();
  599. 		$keywordQuery = "select count(keyword_id) from ".$mysql_table_prefix."keywords";
  600. 		$linksQuery = "select count(url) from ".$mysql_table_prefix."links";
  601. 		$siteQuery = "select count(site_id) from ".$mysql_table_prefix."sites";
  602. 		$categoriesQuery = "select count(category_id) from ".$mysql_table_prefix."categories";
  603.  
  604. 		$result = mysql_query($keywordQuery);
  605. 		echo mysql_error();
  606. 		if ($row=mysql_fetch_array($result)) {
  607. 			$stats['keywords']=$row[0];
  608. 		}
  609. 		$result = mysql_query($linksQuery);
  610. 		echo mysql_error();
  611. 		if ($row=mysql_fetch_array($result)) {
  612. 			$stats['links']=$row[0];
  613. 		}
  614. 		for ($i=0;$i<=15; $i++) {
  615. 			$char = dechex($i);
  616. 			$result = mysql_query("select count(link_id) from ".$mysql_table_prefix."link_keyword$char");
  617. 			echo mysql_error();
  618. 			if ($row=mysql_fetch_array($result)) {
  619. 				$stats['index']+=$row[0];
  620. 			}
  621. 		}
  622. 		$result = mysql_query($siteQuery);
  623. 		echo mysql_error();
  624. 		if ($row=mysql_fetch_array($result)) {
  625. 			$stats['sites']=$row[0];
  626. 		}
  627. 		$result = mysql_query($categoriesQuery);
  628. 		echo mysql_error();
  629. 		if ($row=mysql_fetch_array($result)) {
  630. 			$stats['categories']=$row[0];
  631. 		}
  632. 		return $stats;
  633. 	}
  634.  
  635.  
  636.  
  637. 	function addsite ($url, $title, $short_desc, $cat) {
  638. 		global $mysql_table_prefix;
  639. 		$short_desc = addslashes($short_desc);
  640. 		$title = addslashes($title);
  641. 		$compurl=parse_url("".$url);
  642. 		if ($compurl['path']=='')
  643. 			$url=$url."/";
  644. 		$result = mysql_query("select site_ID from ".$mysql_table_prefix."sites where url='$url'");
  645. 		echo mysql_error();
  646. 		$rows = mysql_numrows($result);
  647. 		if ($rows==0 ) {
  648. 			mysql_query("INSERT INTO ".$mysql_table_prefix."sites (url, title, short_desc) VALUES ('$url', '$title', '$short_desc')");
  649. 			echo mysql_error();
  650. 			$result = mysql_query("select site_ID from ".$mysql_table_prefix."sites where url='$url'");
  651. 			echo mysql_error();
  652. 			$row = mysql_fetch_row($result);
  653. 			$site_id = $row[0];
  654. 			$result=mysql_query("select category_id from ".$mysql_table_prefix."categories");
  655. 			echo mysql_error();
  656. 			while ($row=mysql_fetch_row($result)) {
  657. 				$cat_id=$row[0];
  658. 				if ($cat[$cat_id]=='on') {
  659. 					mysql_query("INSERT INTO ".$mysql_table_prefix."site_category (site_id, category_id) values ('$site_id', '$cat_id')");
  660. 					echo mysql_error();
  661. 				}
  662. 	 		}
  663.  
  664. 			If (!mysql_error())	{
  665. 				$message =  "<br/><center><b>Site added</b></center>" ;
  666. 			} else {
  667. 				$message = mysql_error();
  668. 			}
  669.  
  670. 		} else {
  671. 			$message = "<center><b>Site already in database</b></center>";
  672. 		}
  673. 		return $message;
  674. 	}
  675.  
  676.  
  677. 	function indexscreen ($url, $reindex) {
  678. 		global $mysql_table_prefix;
  679. 		$check = "";
  680. 		$levelchecked = "checked";
  681. 		$spider_depth = 2;
  682. 		if ($url=="") {
  683. 			$url = "http://";
  684. 			$advurl = "";
  685. 		} else {
  686. 			$advurl = $url;
  687. 			$result = mysql_query("select spider_depth, required, disallowed, can_leave_domain from ".$mysql_table_prefix."sites " .
  688. 					"where url='$url'");
  689. 			echo mysql_error();
  690. 			if (mysql_num_rows($result) > 0) {
  691. 				$row = mysql_fetch_row($result);
  692. 				$spider_depth = $row[0];
  693. 				if ($spider_depth == -1 ) {
  694. 					$fullchecked = "checked";
  695. 					$spider_depth ="";
  696. 					$levelchecked = "";
  697. 				}
  698. 				$must = $row[1];
  699. 				$mustnot = $row[2];
  700. 				$canleave = $row[3];
  701. 			}			
  702. 		}
  703.  
  704. 		?>
  705. 		<div id="submenu">
  706. 			<ul>
  707. 				<li>
  708. 				<?php 
  709. 				if ($must !="" || $mustnot !="" || $canleave == 1 ) {	
  710. 					$_SESSION['index_advanced']=1;
  711. 				}
  712. 				if ($_SESSION['index_advanced']==1){
  713. 					print "<a href='admin.php?f=index&adv=0&url=$advurl'>Hide advanced options</a>";
  714. 				} else {
  715. 					print "<a href='admin.php?f=index&adv=1&url=$advurl'>Advanced options</a>";
  716. 				}
  717.  
  718. 				?>
  719. 				</li>
  720. 			</ul>
  721. 		</div>
  722. 		<br/>
  723. 		<div id="indexoptions"><table>
  724. 		<form action="spider.php" method="post">
  725. 		<tr><td><b>Address:</b></td><td> <input type="text" name="url" size="48" value=<?php print "\"$url\"";?>></td></tr>
  726. 		<tr><td><b>Indexing options:</b></td><td>
  727. 		<input type="radio" name="soption" value="full" <?php print $fullchecked;?>> Full<br/>
  728. 		<input type="radio" name="soption" value="level" <?php print $levelchecked;?>>To depth: <input type="text" name="maxlevel" size="2" value="<?php print $spider_depth;?>"><br/>
  729. 		<?php if ($reindex==1) $check="checked"?>
  730. 		<input type="checkbox" name="reindex" value="1" <?php print $check;?>> Reindex<br/>
  731. 		</td></tr>
  732. 		<?php 
  733. 		if ($_SESSION['index_advanced']==1){
  734. 			?>
  735. 			<?php if ($canleave==1) {$checkcan="checked" ;} ?>
  736. 			<tr><td></td><td><input type="checkbox" name="domaincb" value="1" <?php print $checkcan;?>> Spider can leave domain <!--a href="javascript:;" onClick="window.open('hmm','newWindow','width=300,height=300,left=600,top=200,resizable');" >?</a--><br/></td></tr>
  737. 			<tr><td><b>URL must include:</b></td><td><textarea name=in cols=35 rows=2 wrap="virtual"><?php print $must;?></textarea></td></tr>
  738. 			<tr><td><b>URL must not include:</b></td><td><textarea name=out cols=35 rows=2 wrap="virtual"><?php print $mustnot;?></textarea></td></tr>
  739. 			<?php 
  740. 		}
  741. 		?>
  742.  
  743. 		<tr><td></td><td><input type="submit" id="submit" value="Start indexing"></td></tr>
  744. 		</form></table></div>
  745. 		<?php 
  746. 	}
  747.  
  748. 	function siteScreen($site_id, $message)  {
  749. 		global $mysql_table_prefix;
  750. 		$result = mysql_query("SELECT site_id, url, title, short_desc, indexdate from ".$mysql_table_prefix."sites where site_id=$site_id");
  751. 		echo mysql_error();
  752. 		$row=mysql_fetch_array($result);
  753. 		$url = replace_ampersand($row[url]);
  754. 		if ($row['indexdate']=='') {
  755. 			$indexstatus="<font color=\"red\">Not indexed</font>";
  756. 			$indexoption="<a href=\"admin.php?f=index&url=$url\">Index</a>";
  757. 		} else {
  758. 			$site_id = $row['site_id'];
  759. 			$result2 = mysql_query("SELECT site_id from ".$mysql_table_prefix."pending where site_id =$site_id");
  760. 			echo mysql_error();			
  761. 			$row2=mysql_fetch_array($result2);
  762. 			if ($row2['site_id'] == $row['site_id']) {
  763. 				$indexstatus = "Unfinished";
  764. 				$indexoption="<a href=\"admin.php?f=index&url=$url\">Continue indexing</a>";
  765.  
  766. 			} else {
  767. 				$indexstatus = $row['indexdate'];
  768. 				$indexoption="<a href=\"admin.php?f=index&url=$url&reindex=1\">Re-index</a>";
  769. 			}
  770. 		}
  771. 		?>
  772.  
  773. 		<div id="submenu">
  774. 		</div>
  775. 		<?php print $message;?>
  776. 			<br/>
  777.  
  778. 		<center>
  779. 		<div style="width:755px;">
  780. 		<div style="float:left; margin-right:0px;">
  781. 		<div class="darkgrey">
  782. 		<table cellpadding="3" cellspacing="0">
  783.  
  784. 			<table  cellpadding="5" cellspacing="1" width="640">
  785. 			  <tr >
  786. 				<td class="grey" valign="top" width="20%" align="left">URL:</td>
  787. 				<td class="white" align="left"><a href="<?php print  $row['url']; print "\">"; print $row['url'];?></a></td>
  788. 			  </tr>
  789. 			<tr>
  790. 				<td class="grey" valign="top" align="left">Title:</td>
  791. 				<td class="white" align="left"><b><?php print stripslashes($row['title']);?></b></td>
  792. 			</tr>
  793. 			  <tr>
  794. 				<td class="grey" valign="top" align="left">Description:</td>
  795. 				<td width="80%" class="white"  align="left"><?php print stripslashes($row['short_desc']);?></td>
  796. 			  </tr>
  797. 			  <tr>
  798. 				<td class="grey" valign="top" align="left">Last indexed:</td>
  799. 				<td class="white"  align="left"><?php print $indexstatus;?></td>
  800. 			  </tr>
  801. 			</table>
  802. 		</div>
  803. 		</div>
  804. 		<div id= "vertmenu">
  805. 		<ul>
  806. 		 <li><a href=admin.php?f=edit_site&site_id=<?php print  $row['site_id']?>>Edit</a></li>
  807. 		<li><?php print $indexoption?></li>
  808. 		<li><a href=admin.php?f=21&site_id=<?php print  $row['site_id']?>>Browse pages</a></li>
  809. 		<li><a href=admin.php?f=5&site_id=<?php print  $row['site_id'];?> onclick="return confirm('Are you sure you want to delete? Index will be lost.')">Delete</a></li>
  810. 		<li><a href=admin.php?f=19&site_id=<?php print  $row['site_id'];?>>Stats</a></li>
  811. 		</div>
  812. 		</ul>
  813. 		</div>
  814. 		</center>
  815. 		<div class="clear">
  816. 		</div>
  817. 		<br/>
  818. 	<?php 
  819. 	}
  820.  
  821.  
  822. 	function siteStats($site_id) {
  823. 		global $mysql_table_prefix;
  824. 		$result = mysql_query("select url from ".$mysql_table_prefix."sites where site_id=$site_id");
  825. 		echo mysql_error();
  826. 		if ($row=mysql_fetch_array($result)) {
  827. 			$url=$row[0];
  828.  
  829. 			$lastIndexQuery = "SELECT indexdate from ".$mysql_table_prefix."sites where site_id = $site_id";
  830. 			$sumSizeQuery = "select sum(length(fulltxt)) from ".$mysql_table_prefix."links where site_id = $site_id";
  831. 			$siteSizeQuery = "select sum(size) from ".$mysql_table_prefix."links where site_id = $site_id";
  832. 			$linksQuery = "select count(*) from ".$mysql_table_prefix."links where site_id = $site_id";
  833.  
  834. 			$result = mysql_query($lastIndexQuery);
  835. 			echo mysql_error();
  836. 			if ($row=mysql_fetch_array($result)) {
  837. 				$stats['lastIndex']=$row[0];
  838. 			}
  839.  
  840. 			$result = mysql_query($sumSizeQuery);
  841. 			echo mysql_error();
  842. 			if ($row=mysql_fetch_array($result)) {
  843. 				$stats['sumSize']=$row[0];
  844. 			}
  845. 			$result = mysql_query($linksQuery);
  846. 			echo mysql_error();
  847. 			if ($row=mysql_fetch_array($result)) {
  848. 				$stats['links']=$row[0];
  849. 			}
  850.  
  851. 			for ($i=0;$i<=15; $i++) {
  852. 				$char = dechex($i);
  853. 				$result = mysql_query("select count(*) from ".$mysql_table_prefix."links, ".$mysql_table_prefix."link_keyword$char where ".$mysql_table_prefix."links.link_id=".$mysql_table_prefix."link_keyword$char.link_id and ".$mysql_table_prefix."links.site_id = $site_id");
  854. 				echo mysql_error();
  855. 				if ($row=mysql_fetch_array($result)) {
  856. 					$stats['index']+=$row[0];
  857. 				}
  858. 			}
  859. 			for ($i=0;$i<=15; $i++) {
  860. 				$char = dechex($i);
  861. 				$wordQuery = "select count(distinct keyword) from ".$mysql_table_prefix."keywords, ".$mysql_table_prefix."links, ".$mysql_table_prefix."link_keyword$char where ".$mysql_table_prefix."links.link_id=".$mysql_table_prefix."link_keyword$char.link_id and ".$mysql_table_prefix."links.site_id = $site_id and ".$mysql_table_prefix."keywords.keyword_id = ".$mysql_table_prefix."link_keyword$char.keyword_id";
  862. 				$result = mysql_query($wordQuery);
  863. 				echo mysql_error();
  864. 				if ($row=mysql_fetch_array($result)) {
  865. 					$stats['words']+=$row[0];
  866. 				}
  867. 			}
  868.  
  869. 			$result = mysql_query($siteSizeQuery);
  870. 			echo mysql_error();
  871. 			if ($row=mysql_fetch_array($result)) {
  872. 				$stats['siteSize']=$row[0];
  873. 			}
  874. 			if ($stats['siteSize']=="")
  875. 				$stats['siteSize'] = 0;
  876. 			$stats['siteSize'] = number_format($stats['siteSize'], 2);
  877. 			print"<div id=\"submenu\"></div>";
  878. 			print "<br/><div align=\"center\"><center><table cellspacing =\"0\" cellpadding=\"0\" class=\"darkgrey\"><tr><td><table cellpadding=\"3\" cellspacing = \"1\"><tr  class=\"grey\"><td colspan=\"2\">";
  879. 			print "Statistics for site <a href=\"admin.php?f=20&site_id=$site_id\">$url</a>";
  880. 			print "<tr class=\"white\"><td>Last indexed:</td><td align=\"center\"> ".$stats['lastIndex']."</td></tr>";
  881. 			print "<tr class=\"grey\"><td>Pages indexed:</td><td align=\"center\"> ".$stats['links']."</td></tr>";
  882. 			print "<tr class=\"white\"><td>Total index size:</td><td align=\"center\"> ".$stats['index']."</td></tr>";
  883. 			$sum = number_format($stats['sumSize']/1024, 2);
  884. 			print "<tr class=\"grey\"><td>Cached texts:</td><td align=\"center\"> ".$sum."kb</td></tr>";
  885. 			print "<tr class=\"white\"><td>Total number of keywords:</td><td align=\"center\"> ".$stats['words']."</td></tr>";
  886. 			print "<tr class=\"grey\"><td>Site size:</td><td align=\"center\"> ".$stats['siteSize']."kb</td></tr>";
  887. 			print "</table></td></tr></table></center></div>";
  888. 		}
  889. 	}
  890.  
  891. 	function browsePages($site_id, $start, $filter, $per_page) {
  892. 		global $mysql_table_prefix;
  893. 		$result = mysql_query("select url from ".$mysql_table_prefix."sites where site_id=$site_id");
  894. 		echo mysql_error();
  895. 		$row = mysql_fetch_row($result);
  896. 		$url = $row[0];
  897.  
  898. 		$query_add = "";
  899. 		if ($filter != "") {
  900. 			$query_add = "and url like '%$filter%'";
  901. 		}
  902. 		$linksQuery = "select count(*) from ".$mysql_table_prefix."links where site_id = $site_id $query_add";
  903. 		$result = mysql_query($linksQuery);
  904. 		echo mysql_error();
  905. 		$row = mysql_fetch_row($result);
  906. 		$numOfPages = $row[0]; 
  907.  
  908. 		$result = mysql_query($linksQuery);
  909. 		echo mysql_error();
  910. 		$from = ($start-1) * 10;
  911. 		$to = min(($start)*10, $numOfPages);
  912.  
  913.  
  914. 		$linksQuery = "select link_id, url from ".$mysql_table_prefix."links where site_id = $site_id and url like '%$filter%' order by url limit $from, $per_page";
  915. 		$result = mysql_query($linksQuery);
  916. 		echo mysql_error();
  917. 		?>
  918. 		<div id="submenu"></div>
  919. 		<br/>
  920. 		<center>
  921. 		<b>Pages of site <a href="admin.php?f=20&site_id=<?php  print $site_id?>"><?php print $url;?></a></b><br/>
  922. 		<p>
  923. 		<form action="admin.php" method="post">
  924. 		Urls per page: <input type="text" name="per_page" size="3" value="<?php print $per_page;?>"> 
  925. 		Url contains: <input type="text" name="filter" size="15" value="<?php print $filter;?>"> 
  926. 		<input type="submit" id="submit" value="Filter">
  927. 		<input type="hidden" name="start" value="1">
  928. 		<input type="hidden" name="site_id" value="<?php print $site_id?>">
  929. 		<input type="hidden" name="f" value="21">
  930. 		</form>
  931. 		</p>
  932. 	<table width="600"><tr><td>
  933. 		<table cellspacing ="0" cellpadding="0" class="darkgrey" width ="100%"><tr><td>
  934. 		<table  cellpadding="3" cellspacing="1" width="100%">
  935.  
  936. 		<?php 
  937. 		$class = "white";
  938. 		while ($row = mysql_fetch_array($result)) {
  939. 			if ($class =="white") 
  940. 				$class = "grey";
  941. 			else 
  942. 				$class = "white";
  943. 			print "<tr class=\"$class\"><td><a href=\"".$row['url']."\">".$row['url']."</a></td><td width=\"8%\"> <a href=\"admin.php?link_id=".$row['link_id']."&f=22&site_id=$site_id&start=1&filter=$filter&per_page=$per_page\">Delete</a></td></tr>";
  944. 		}
  945.  
  946. 		print "</table></td></tr></table>";
  947.  
  948. 		$pages = ceil($numOfPages / $per_page);
  949. 		$prev = $start - 1;
  950. 		$next = $start + 1;
  951.  
  952. 		if ($pages > 0)
  953. 			print "<center>Pages: ";
  954.  
  955. 		$links_to_next =10;
  956. 		$firstpage = $start - $links_to_next;
  957. 		if ($firstpage < 1) $firstpage = 1;
  958. 		$lastpage = $start + $links_to_next;
  959. 		if ($lastpage > $pages) $lastpage = $pages;
  960.  
  961. 		for ($x=$firstpage; $x<=$lastpage; $x++)
  962. 			if ($x<>$start)	{
  963. 				print "<a href=admin.php?f=21&site_id=$site_id&start=$x&filter=$filter&per_page=$per_page>$x</a> ";
  964. 			} 	else
  965. 				print "<b>$x </b>";
  966. 		print"</td></tr></table></center>";
  967.  
  968. 	}
  969.  
  970.  
  971. 	function cleanForm () {
  972. 		global $mysql_table_prefix;
  973. 		$result = mysql_query("select count(*) from ".$mysql_table_prefix."query_log");
  974. 		echo mysql_error();
  975. 		if ($row=mysql_fetch_array($result)) {
  976. 			$log=$row[0];
  977. 		}
  978. 		$result = mysql_query("select count(*) from ".$mysql_table_prefix."temp");
  979. 		echo mysql_error();
  980. 		if ($row=mysql_fetch_array($result)) {
  981. 			$temp=$row[0];
  982. 		}
  983.  
  984.  
  985. 		?>
  986. 		<div id="submenu">
  987. 		</div>
  988. 		<br/><div align="center">
  989. 		<table cellspacing ="0" cellpadding="0" class="darkgrey"><tr><td align="left"><table cellpadding="3" cellspacing = "1"  width="100%"><tr class="grey"  ><td align="left"><a href="admin.php?f=15" id="small_button">Clean keywords</a> 
  990. 		 </td><td align="left"> Delete all keywords not associated with any link.</td></tr>
  991. 		<tr class="grey"  ><td align="left"><a href="admin.php?f=16" id="small_button">Clean links</a>
  992. 		</td><td align="left"> Delete all links not associated with any site.</td></tr>
  993. 		<tr class="grey"  ><td align="left"><a href="admin.php?f=17" id="small_button">Clear temp tables </a>
  994. 		</td><td align="left"> <?php print $temp;?> items in temporary table.</td></tr>
  995. 		<tr class="grey"  ><td align="left"><a href="admin.php?f=23" id="small_button">Clear search log </a> 
  996. 		</td><td align="left"><?php print $log;?> items in search log.
  997. 		</td></tr></table>		</td></tr></table></div>
  998. 		<?php 
  999. 	}
  1000.  
  1001. 	function statisticsForm ($type) {
  1002. 		global $mysql_table_prefix, $log_dir;
  1003. 		?>
  1004. 		<div id='submenu'>
  1005. 		<ul>
  1006. 		<li><a href="admin.php?f=statistics&type=keywords">Top keywords</a></li>
  1007. 		<li><a href="admin.php?f=statistics&type=pages">Largest pages</a></li>
  1008. 		<li><a href="admin.php?f=statistics&type=top_searches">Most popular searches</a></li>
  1009. 		<li><a href="admin.php?f=statistics&type=log">Search log</a></li>
  1010. 		<li><a href="admin.php?f=statistics&type=spidering_log">Spidering logs</a></li>
  1011. 		</ul>
  1012. 		</div>
  1013.  
  1014. 		<?php 
  1015. 			if ($type == "") {
  1016. 				$cachedSumQuery = "select sum(length(fulltxt)) from ".$mysql_table_prefix."links";
  1017. 				$result=mysql_query("select sum(length(fulltxt)) from ".$mysql_table_prefix."links");
  1018. 				echo mysql_error();
  1019. 				if ($row=mysql_fetch_array($result)) {
  1020. 					$cachedSumSize = $row[0];
  1021. 				}
  1022. 				$cachedSumSize = number_format($cachedSumSize / 1024, 2);
  1023.  
  1024. 				$sitesSizeQuery = "select sum(size) from ".$mysql_table_prefix."links";
  1025. 				$result=mysql_query("$sitesSizeQuery");
  1026. 				echo mysql_error();
  1027. 				if ($row=mysql_fetch_array($result)) {
  1028. 					$sitesSize = $row[0];
  1029. 				}
  1030. 				$sitesSize = number_format($sitesSize, 2);
  1031.  
  1032. 				$stats = getStatistics();
  1033. 				print "<br/><div align=\"center\"><table cellspacing =\"0\" cellpadding=\"0\" class=\"darkgrey\"><tr><td><table cellpadding=\"3\" cellspacing = \"1\"><tr  class=\"grey\"><td><b>Sites:</b></td><td align=\"center\">".$stats['sites']."</td></tr>";				
  1034. 				print "<tr class=\"white\"><td><b>Links:</b></td><td align=\"center\"> ".$stats['links']."</td></tr>";
  1035. 				print "<tr class=\"grey\"><td><b>Categories:</b></td><td align=\"center\"> ".$stats['categories']."</td></tr>";
  1036. 				print "<tr class=\"white\"><td><b>Keywords:</b></td><td align=\"center\"> ".$stats['keywords']."</td></tr>";
  1037. 				print "<tr class=\"grey\"><td><b>Keyword-link realations:</b></td><td align=\"center\"> ".$stats['index']."</td></tr>";
  1038. 				print "<tr class=\"white\"><td><b>Cached texts total:</b></td><td align=\"center\"> $cachedSumSize kb</td></tr>";
  1039. 				print "<tr class=\"grey\"><td><b>Sites size total:</b></td><td align=\"center\"> $sitesSize kb</td></tr>";
  1040. 				print "</table></td></tr></table></div>";
  1041. 			}	
  1042.  
  1043. 			if ($type=='keywords') {
  1044. 				$class = "grey";
  1045. 				print "<br/><div align=\"center\"><table cellspacing =\"0\" cellpadding=\"0\" class=\"darkgrey\"><tr><td><table cellpadding=\"3\" cellspacing = \"1\"><tr  class=\"grey\"><td><b>Keyword</b></td><td><b>Occurrences</b></td></tr>";
  1046. 				for ($i=0;$i<=15; $i++) {
  1047. 					$char = dechex($i);
  1048. 					$result=mysql_query("select keyword, count(".$mysql_table_prefix."link_keyword$char.keyword_id) as x from ".$mysql_table_prefix."keywords, ".$mysql_table_prefix."link_keyword$char where ".$mysql_table_prefix."keywords.keyword_id = ".$mysql_table_prefix."link_keyword$char.keyword_id group by keyword order by x desc limit 30");
  1049. 					echo mysql_error();
  1050. 					while (($row=mysql_fetch_row($result))) {
  1051. 						$topwords[$row[0]] = $row[1];
  1052. 					}
  1053. 				}
  1054. 				arsort($topwords);
  1055. 				$count = 0;
  1056. 				while ((list($word, $weight) = each($topwords)) && $count <= 30) {
  1057.  
  1058. 					$count++;
  1059. 					if ($class =="white") 
  1060. 						$class = "grey";
  1061. 					else 
  1062. 						$class = "white";
  1063.  
  1064. 					print "<tr class=\"$class\"><td align=\"left\">".$word."</td><td> ".$weight."</td></tr>\n";
  1065. 		 		}			
  1066. 				print "</table></td></tr></table></div>";
  1067. 			}
  1068. 			if ($type=='pages') {
  1069. 				$class = "grey";
  1070. 				?>
  1071. 				<br/><div align="center">
  1072. 				<table cellspacing ="0" cellpadding="0" class="darkgrey"><tr><td>
  1073. 				<table cellpadding="2" cellspacing="1">
  1074. 				  <tr class="grey"><td>
  1075. 				   <b>Page</b></td>
  1076. 				   <td><b>Text size</b></td></tr>
  1077. 				<?php 
  1078. 				$result=mysql_query("select ".$mysql_table_prefix."links.link_id, url, length(fulltxt)  as x from ".$mysql_table_prefix."links order by x desc limit 20");
  1079. 				echo mysql_error();
  1080. 				while ($row=mysql_fetch_row($result)) {
  1081. 					if ($class =="white") 
  1082. 						$class = "grey";
  1083. 					else 
  1084. 						$class = "white";
  1085. 					$url = $row[1];
  1086. 					$sum = number_format($row[2]/1024, 2);
  1087. 					print "<tr class=\"$class\"><td align=\"left\"><a href=\"$url\">".$url."</td><td align= \"center\"> ".$sum."kb</td></tr>";
  1088. 		 		}			
  1089. 				print "</table></td></tr></table></div>";
  1090. 			}
  1091.  
  1092. 			if ($type=='top_searches') {
  1093. 				$class = "grey";
  1094. 				print "<br/><div align=\"center\"><table cellspacing =\"0\" cellpadding=\"0\" class=\"darkgrey\"><tr><td><table cellpadding=\"3\" cellspacing = \"1\"><tr  class=\"grey\"><td><b>Query</b></td><td><b>Count</b></td><td><b> Average results</b></td><td><b>Last queried</b></td></tr>";
  1095. 				$result=mysql_query("select query, count(*) as c, date_format(max(time), '%Y-%m-%d %H:%i:%s'), avg(results)  from ".$mysql_table_prefix."query_log group by query order by c desc");
  1096. 				echo mysql_error();
  1097. 				while ($row=mysql_fetch_row($result)) {
  1098. 					if ($class =="white") 
  1099. 						$class = "grey";
  1100. 					else 
  1101. 						$class = "white";
  1102.  
  1103. 					$word = $row[0];
  1104. 					$times = $row[1];
  1105. 					$date = $row[2];
  1106. 					$avg = number_format($row[3], 1);
  1107. 					print "<tr class=\"$class\"><td align=\"left\">".htmlentities($word)."</td><td align=\"center\"> ".$times."</td><td align=\"center\"> ".$avg."</td><td align=\"center\"> ".$date."</td></tr>";
  1108. 		 		}			
  1109. 				print "</table></td></tr></table></div>";
  1110. 			}
  1111. 			if ($type=='log') {
  1112. 				$class = "grey";
  1113. 				print "<br/><div align=\"center\"><table cellspacing =\"0\" cellpadding=\"0\" class=\"darkgrey\"><tr><td><table cellpadding=\"3\" cellspacing = \"1\"><tr  class=\"grey\"><td align=\"center\"><b>Query</b></td><td align=\"center\"><b>Results</b></td><td align=\"center\"><b>Queried at</b></td><td align=\"center\"><b>Time taken</b></td></tr>";
  1114. 				$result=mysql_query("select query,  date_format(time, '%Y-%m-%d %H:%i:%s'), elapsed, results from ".$mysql_table_prefix."query_log order by time desc");
  1115. 				echo mysql_error();
  1116. 				while ($row=mysql_fetch_row($result)) {
  1117. 					if ($class =="white") 
  1118. 						$class = "grey";
  1119. 					else 
  1120. 						$class = "white";
  1121.  
  1122. 					$word = $row[0];
  1123. 					$time = $row[1];
  1124. 					$elapsed = $row[2];
  1125. 					$results = $row[3];
  1126. 					print "<tr class=\"$class\"><td align=\"left\">".htmlentities($word)."</td><td align=\"center\"> ".$results."</td><td align=\"center\"> ".$time."</td><td align=\"center\"> ".$elapsed."</td></tr>";
  1127. 		 		}			
  1128. 				print "</table></td></tr></table></div>";
  1129. 			}
  1130.  
  1131. 			if ($type=='spidering_log') {
  1132. 				$class = "grey";
  1133. 				$files = get_dir_contents($log_dir);
  1134. 				if (count($files)>0) {
  1135. 					print "<br/><div align=\"center\"><table cellspacing =\"0\" cellpadding=\"0\" class=\"darkgrey\"><tr><td><table cellpadding=\"3\" cellspacing = \"1\"><tr  class=\"grey\"><td align=\"center\"><b>File</b></td><td align=\"center\"><b>Time</b></td><td align=\"center\"><b></b></td></tr>";
  1136.  
  1137. 					for ($i=0; $i<count($files); $i++) {
  1138. 						$file=$files[$i];
  1139. 						$year = substr($file, 0,2);
  1140. 						$month = substr($file, 2,2);
  1141. 						$day = substr($file, 4,2);
  1142. 						$hour = substr($file, 6,2);
  1143. 						$minute = substr($file, 8,2);
  1144. 						if ($class =="white") 
  1145. 							$class = "grey";
  1146. 						else 
  1147. 							$class = "white";
  1148. 						print "<tr class=\"$class\"><td align=\"left\"><a href='$log_dir/$file' tareget='_blank'>$file</a></td><td align=\"center\"> 20$year-$month-$day $hour:$minute</td><td align=\"center\"> <a href='?f=delete_log&file=$file' id='small_button'>Delete</a></td></tr>";
  1149. 					}
  1150.  
  1151. 					print "</table></td></tr></table></div>";
  1152. 				} else {
  1153. 					?>
  1154. 					<br/><br/>
  1155. 					<center><b>No saved logs.</b></center>
  1156. 					<?php 
  1157. 				}
  1158. 			}
  1159.  
  1160. 	}
  1161.  
  1162. 	switch ($f)	{
  1163. 		case 1:
  1164. 			$message = addsite($url, $title, $short_desc, $cat);
  1165. 			$compurl=parse_url($url);
  1166. 			if ($compurl['path']=='')
  1167. 				$url=$url."/";
  1168.  
  1169. 			$result = mysql_query("select site_id from ".$mysql_table_prefix."sites where url='$url'");
  1170. 			echo mysql_error();
  1171. 			$row = mysql_fetch_row($result);
  1172. 			if ($site_id != "")
  1173. 				siteScreen($site_id, $message);
  1174. 			else
  1175. 				showsites($message);
  1176. 		break;
  1177. 		case 2:
  1178. 			showsites();
  1179. 		break;
  1180. 		case edit_site:
  1181. 			editsiteform($site_id);
  1182. 		break;
  1183. 		case 4:
  1184. 			if (!isset($domaincb))
  1185. 				$domaincb = 0;
  1186. 			if (!isset($cat))
  1187. 				$cat = "";
  1188. 			if ($soption =='full') {
  1189. 				$depth = -1;
  1190. 			} 
  1191. 			$message = editsite ($site_id, $url, $title, $short_desc, $depth, $in, $out,  $domaincb, $cat);
  1192. 			showsites($message);
  1193. 		break;
  1194. 		case 5:
  1195. 			deletesite ($site_id);
  1196. 			showsites();
  1197. 		break;
  1198. 		case add_cat:
  1199. 			if (!isset($parent))
  1200. 				$parent = "";
  1201. 			addcatform ($parent);
  1202. 		break;
  1203. 		case 7:
  1204. 			if (!isset($parent)) {
  1205. 				$parent = "";
  1206. 			}
  1207. 			$message = addcat ($category, $parent);
  1208. 			list_cats (0, 0, "white", $message);
  1209. 		break;
  1210. 		case categories:
  1211. 			list_cats (0, 0, "white", "");
  1212. 		break;
  1213. 		case edit_cat;
  1214. 			editcatform($cat_id);
  1215. 		break;
  1216. 		case 10;
  1217. 			$message = editcat ($cat_id, $category);
  1218. 			list_cats (0, 0, "white", $message);
  1219. 		break;
  1220. 		case 11;
  1221. 			deletecat($cat_id);
  1222. 			list_cats (0, 0, "white");
  1223. 		break;
  1224. 		case index;
  1225. 			if (!isset($url))
  1226. 				$url = "";
  1227. 			if (!isset($reindex))
  1228. 				$reindex = "";
  1229. 			if (isset($adv)) {	
  1230. 					$_SESSION['index_advanced']=$adv;
  1231. 			}
  1232. 			indexscreen($url, $reindex);
  1233. 		break;
  1234. 		case add_site;
  1235. 			addsiteform();
  1236. 		break;
  1237. 		case clean;
  1238. 			cleanForm();
  1239. 		break;
  1240.  
  1241. 		case 15;
  1242. 			cleanKeywords();
  1243. 		break;
  1244. 		case 16;
  1245. 			cleanLinks();
  1246. 		break;
  1247.  
  1248. 		case 17;
  1249. 			cleanTemp();
  1250. 		break;
  1251.  
  1252. 		case statistics;
  1253. 			if (!isset($type))
  1254. 				$type = "";
  1255. 			statisticsForm($type);
  1256. 		break;
  1257.  
  1258. 		case 19;
  1259. 			siteStats($site_id);
  1260. 		break;
  1261. 		case 20;
  1262. 			siteScreen($site_id);
  1263. 		break;
  1264. 		case 21;
  1265. 			if (!isset($start))
  1266. 				$start = 1;
  1267. 			if (!isset($filter))
  1268. 				$filter = "";
  1269. 			if (!isset($per_page))
  1270. 				$per_page = 10;
  1271.  
  1272. 			browsePages($site_id, $start, $filter, $per_page);
  1273. 		break;
  1274. 		case 22;
  1275. 			deletePage($link_id);
  1276. 			if (!isset($start))
  1277. 				$start = 1;
  1278. 			if (!isset($filter))
  1279. 				$filter = "";
  1280. 			if (!isset($per_page))
  1281. 				$per_page = 10;
  1282. 			browsePages($site_id, $start, $filter, $per_page);
  1283. 		break;
  1284. 		case 23;
  1285. 			clearLog();
  1286. 		break;
  1287. 		case 24;
  1288. 			session_destroy();
  1289. 			header("Location: admin.php");
  1290. 		break;
  1291. 		case database;
  1292. 			include "db_main.php";
  1293. 		break;
  1294. 		case settings;
  1295. 			include('configset.php');
  1296. 		break;
  1297. 		case delete_log;
  1298. 			unlink($log_dir."/".$file);
  1299. 			statisticsForm('spidering_log');
  1300. 		break;
  1301. 		case '':
  1302. 			showsites();
  1303. 		break;
  1304. 	}
  1305. 	$stats = getStatistics();
  1306. 	print "<br/><br/>	<center>Currently in database: ".$stats['sites']." sites, ".$stats['links']." links, ".$stats['categories']." categories and ".$stats['keywords']." keywords.<br/><br/></center>\n";
  1307.  
  1308. ?>
  1309. </div>
  1310. </div>
  1311. </body>
  1312. </html>
Runtime error #stdin #stdout 0.02s 13064KB
comments (?)
stdin
copy 
Standard input is empty
stdout
copy 

Warning: include(auth.php): failed to open stream: No such file or directory in /home/j3cBie/prog.php on line 13

Warning: include(): Failed opening 'auth.php' for inclusion (include_path='.:/usr/share/php5:/usr/share/php') in /home/j3cBie/prog.php on line 13

Warning: include(../include/commonfuncs.php): failed to open stream: No such file or directory in /home/j3cBie/prog.php on line 14

Warning: include(): Failed opening '../include/commonfuncs.php' for inclusion (include_path='.:/usr/share/php5:/usr/share/php') in /home/j3cBie/prog.php on line 14

Fatal error: Call to undefined function getHttpVars() in /home/j3cBie/prog.php on line 15
https://ideone.com/grapQ
language:
PHP (php 7.3.5)
created:
13 years ago
visibility:
public

Share or Embed source code

Discover > Sphere Engine API

The brand new service which powers Ideone!

Discover > IDE Widget

Widget for compiling and running the source code in a web browser!