Guest User

Untitled

a guest
Mar 1st, 2017
651
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.20 KB | None | 0 0
  1. --- data-pick.php 2017-03-01 12:23:28.632092866 +0000
  2. +++ data-pick.php-PRE-PHP7 2015-08-07 13:36:51.668196377 +0100
  3. @@ -30,9 +30,9 @@
  4. $observium_found = FALSE;
  5. }
  6.  
  7. -$link = mysqli_connect($config['db_host'],$config['db_user'],$config['db_pass'])
  8. - or die('Could not connect: ' . mysqli_error($link));
  9. - mysqli_select_db($link,$config['db_name']) or die('Could not select database: '.mysqli_error($link));
  10. +$link = mysql_connect($config['db_host'],$config['db_user'],$config['db_pass'])
  11. + or die('Could not connect: ' . mysql_error());
  12. + mysql_selectdb($config['db_name'],$link) or die('Could not select database: '.mysql_error());
  13.  
  14.  
  15. // ******************************************
  16. @@ -263,7 +263,7 @@
  17. //$SQL_picklist .= " order by name_cache;";
  18.  
  19. // Link query
  20. - $result = mysqli_query($link,"SELECT device_id,hostname FROM devices ORDER BY hostname");
  21. + $result = mysql_query("SELECT device_id,hostname FROM devices ORDER BY hostname");
  22. //$hosts = mysql_fetch_assoc($result);
  23. //$result = mysql_query($SQL_picklist);
  24. $hosts = 1;
  25. @@ -278,7 +278,7 @@
  26.  
  27. print '<option '.($host_id==-1 ? 'SELECTED' : '' ).' value="-1">Any</option>';
  28. print '<option '.($host_id==0 ? 'SELECTED' : '' ).' value="0">None</option>';
  29. - while ($host = mysqli_fetch_assoc($result))
  30. + while ($host = mysql_fetch_assoc($result))
  31. {
  32. print '<option ';
  33. if($host_id==$host['device_id']) print " SELECTED ";
  34. @@ -301,14 +301,14 @@
  35. }
  36.  
  37. $query .= " ORDER BY hostname,ports.ifAlias";
  38. - $result = mysqli_query($link,$query);
  39. + $result = mysql_query($query);
  40.  
  41. // print $SQL_picklist;
  42.  
  43. $i=0;
  44. - if( mysqli_num_rows($result) > 0 )
  45. + if( mysql_num_rows($result) > 0 )
  46. {
  47. - while ($queryrows = mysqli_fetch_assoc($result)) {
  48. + while ($queryrows = mysql_fetch_assoc($result)) {
  49. echo "<li class=\"row".($i%2)."\">";
  50. $key = $queryrows['device_id']."','".$queryrows['hostname']."','".$queryrows['port_id']."','".$queryrows['ifAlias']."','".addslashes($queryrows['ifDescr'])."','".$queryrows['ifIndex'];
  51. echo "<a href=\"#\" onclick=\"update_source_step1('$key')\">". $queryrows['hostname'] . "/" . $queryrows['ifDescr'] . " Desc:" . $queryrows['ifAlias'] . ":</a>";
  52. @@ -356,8 +356,8 @@
  53. }
  54. //$SQL_picklist .= " order by title_cache";
  55.  
  56. - $query = mysqli_query($link,"SELECT id,hostname AS name FROM `devices` ORDER BY hostname");
  57. - $hosts = mysqli_fetch_assoc($query);
  58. + $query = mysql_query("SELECT id,hostname AS name FROM `devices` ORDER BY hostname");
  59. + $hosts = mysql_fetch_assoc($query);
  60.  
  61. ?>
  62. <html>
  63. @@ -475,11 +475,11 @@
  64. print '<input id="overlib" name="overlib" type="checkbox" value="yes" '.($overlib ? 'CHECKED' : '' ).'> <label for="overlib">Set both OVERLIBGRAPH and INFOURL.</label><br />';
  65.  
  66. print '</form><div class="listcontainer"><ul id="dslist">';
  67. - $result = mysqli_query($SQL_picklist);
  68. - if( mysqli_num_rows($result) > 0)
  69. + $result = mysql_query($SQL_picklist);
  70. + if( mysql_num_rows($result) > 0)
  71. {
  72. $i=0;
  73. - while($queryrows = mysqli_fetch_assoc($result)) {
  74. + while($queryrows = mysql_fetch_assoc($result)) {
  75. echo "<li class=\"row".($i%2)."\">";
  76. $key = $queryrows['id'];
  77. $name = $queryrows['name'];
Advertisement
Add Comment
Please, Sign In to add comment