[H] Mysql mit Datenbank verbinden

[Kevin]

<?php

  /* (c) 2011 diSturbia */

  function mysql_c($localhost, $user1477249, $PASSWORD, $db1477249-main) {
    mysql_connect($localhost, $user1477249, $PASSWORD) or die(mysql_error());
    mysql_select_db($db) or die(mysql_error());
  }
  
  function mysql_q($query) {
    $res = mysql_query($query);
    if(!$res) { die(mysql_error()); }
    return $res;
  }
  
  function mysql_idc($table) {
    $r = mysql_fetch_array(mysql_q('SELECT * FROM '.$table.' ORDER BY `id` DESC'));
    return $r['id'] + 1;
  }
  
  
  function crypt_ip($ip) {
    for($i = 0; $i <= 15; $i++) {
      $ip = hash('adler32', hash('ripemd160', md5($ip))); }
    return $ip;
  }
  
  
  function page_c($table) {
    $c = mysql_result(mysql_q('SELECT COUNT(*) FROM '.$table), 0);
    return ($c / 20) + 1;
  }
  
  function tool_i($tool) {
    $r = mysql_fetch_array(mysql_q('SELECT * FROM `tool-icons` WHERE `name` = \''.mysql_real_escape_string($tool).'\''));
    return htmlentities($r['pfad']);
  }
  
  function geoIP($ip) {
    $gip = geoip_open('inc/GeoIP.dat', GEOIP_STANDARD);
    $land = geoip_country_code_by_addr($gip, $ip);
    geoip_close($gip);
    return strtolower($land);
  }

?>

Danke. (YY)

[Lyra]

<?php

  /* (c) 2011 diSturbia */

  function mysql_c($host, $user, $pass, $db) {
    mysql_connect($host, $user, $pass) or die(mysql_error());
    mysql_select_db($db) or die(mysql_error());
  }
  
  function mysql_q($query) {
    $res = mysql_query($query);
    if(!$res) { die(mysql_error()); }
    return $res;
  }
  
  function mysql_idc($table) {
    $r = mysql_fetch_array(mysql_q('SELECT * FROM '.$table.' ORDER BY `id` DESC'));
    return $r['id'] + 1;
  }
  
  
  function crypt_ip($ip) {
    for($i = 0; $i <= 15; $i++) {
      $ip = hash('adler32', hash('ripemd160', md5($ip))); }
    return $ip;
  }
  
  
  function page_c($table) {
    $c = mysql_result(mysql_q('SELECT COUNT(*) FROM '.$table), 0);
    return ($c / 20) + 1;
  }
  
  function tool_i($tool) {
    $r = mysql_fetch_array(mysql_q('SELECT * FROM `tool-icons` WHERE `name` = \''.mysql_real_escape_string($tool).'\''));
    return htmlentities($r['pfad']);
  }
  
  function geoIP($ip) {
    $gip = geoip_open('inc/GeoIP.dat', GEOIP_STANDARD);
    $land = geoip_country_code_by_addr($gip, $ip);
    geoip_close($gip);
    return strtolower($land);
  }

?>