Beiträge von Domino98

  • Fubbo Retro

    Ich will euch mein Habbo Retro R63 vorstellen!

    Ich habe mir mal gedacht ich erstelle mir doch auch mal ein Habbo Retro Hotel und dann habe ich es gemacht. Es ist leider noch mit Hamachi aber bald läuft das Hotel mit einem Root Server.

    Hamachi Daten!

    Netzwerk-Name: Bebba-Hotel1, Bebba-hotel2, Bebba-hotel3

    Netzwerk-Passwort: 123 bei allen

    Link: http://5.128.21.235

    Es werden noch Xlers gesucht und ein CM!


    Ich wünsche euch noch viel spass und ich würde mich freuen wenn ihr in das Fubbo Retro kommen würdet.


    Mit freundlichen Gruss


    Domino98

  • habuedit mysql config probleme

    was muss ich da genau machen das die Habuedit cms richtig funktioniert also an diesen mysql.php?

    hier ist die Mysql.php!


    <?php

    class dbc {

    var $link;
    var $mode = false; //"MYSQL40";
    var $commit = false;

    function dbc( $config, &$pre ) {
    if( @include( $config ) ) {
    $this->link = @mysql_connect( $sql_host, $sql_user, $sql_pass );
    if (!$this->link) trigger_error( "Could not connect Database!", E_USER_ERROR );
    $db = @mysql_select_db( $sql_db, $this->link );
    if (!$db) trigger_error( "Could not select Database!", E_USER_ERROR );

    if( $this->mode ) $this->query( "SET SESSIONSQL_MODE=".$this->mode );
    $pre = $prefix;
    } else trigger_error( "Config File missing!", E_USER_ERROR );
    }

    function query( $sql ) {
    if( $res = mysql_query( $sql, $this->link ))
    return $res;
    else trigger_error( "Bei dem Query: \"".htmlspecialchars( $sql )."\" ist folgender Fehler aufgeterten:<br>".mysql_error(), E_USER_ERROR );
    }

    function get( $table, $cond = 1, $limit = -1, $order = "" ) {
    $query = "SELECT * FROM ".$table." WHERE $cond";
    if( !empty( $order )) $query .= " ORDER BY $order";
    if( $limit > 0 ) $query .= " LIMIT $limit";

    $res = $this->query( $query );
    $result = array();
    while( $row = mysql_fetch_assoc( $res )) $result[] = $row;

    mysql_free_result( $res );
    if( $limit == 1 ) return $result[0];
    else return $result;
    }

    function fetch_query( $query ) {
    $res = $this->query( $query );
    $result = array();
    while( $row = mysql_fetch_assoc( $res )) $result[] = $row;

    mysql_free_result( $res );
    return $result;
    }

    function get_assoc( $table, $cond = 1, $value, $key = "id" ) {
    $query = "SELECT * FROM ".$table." WHERE $cond ORDER BY $value";

    $res = $this->query( $query );
    $result = array();
    while( $row = mysql_fetch_assoc( $res )) $result[$row[$key]] = $row[$value];

    mysql_free_result( $res );
    return $result;
    }

    function del( $table, $cond ) {
    return $this->query( "DELETE FROM ".$table." WHERE $cond" );
    }

    function id_get( $table, $id ) {
    $query = "SELECT * FROM ".$table." WHERE id = '$id' LIMIT 1";
    $res = $this->query( $query );
    $result = mysql_fetch_assoc( $res );
    mysql_free_result( $res );
    return $result;
    }

    function id_del( $table, $id ) {
    return $this->query( "DELETE FROM ".$table." WHERE id = '$id' LIMIT 1" );
    }

    function id() {
    return @mysql_insert_id( $this->link );
    }

    function close() {
    if( $this->commit ) $db->query( "COMMIT;" );
    mysql_close( $this->link );
    }

    function flist( $table ) {
    $res = $this->query( "SHOW COLUMNS FROM ".$table );
    $fields = array();

    while( $f = mysql_fetch_row( $res )) $fields[] = $f;
    mysql_free_result( $res );
    return $fields;
    }

    function insert( $table, $values, $type = "INSERT" ) {
    global $userdata;
    if( !empty( $userdata['id'] )) $values['create_by'] = $userdata['id'];
    $values['create_date'] = time();

    $fields = array(); $vals = array();
    foreach( $this->flist( $table ) as $f )
    if( isset( $values[$f[0]] )) {
    $fields[] = "`$f[0]`";
    $vals[] = (empty( $values[$f[0]] ) && $f[2] == 'YES') ? "NULL" : "'".$values[$f[0]]."'";
    }

    $this->query( "$type INTO $table ( ".implode( ", ", $fields ).")
    VALUES ( ".implode( ", ", $vals ).");" );
    }

    function update( $table, $values, $cond = 1 ) {
    global $userdata;
    if( !empty( $userdata['id'] )) $values['update_by'] = $userdata['id'];
    $values['update_date'] = time();

    $sql = "UPDATE $table SET "; $ups = array();
    foreach( $this->flist( $table ) as $f )
    if( isset( $values[$f[0]] ))
    if( empty( $values[$f[0]] ) && $f[2] == 'YES' ) $ups[] = "`$f[0]` = NULL";
    else $ups[] = "`$f[0]` = '".$values[$f[0]]."'";
    $this->query( $sql.implode( ", ", $ups )." WHERE $cond" );
    }

    function id_update( $table, $values, $id ) {
    $this->update( $table, $values, "id = '".(int)$id."'" );
    }

    function multi_insert( $table, $rows, $type = "INSERT" ) {
    global $userdata;
    $flist = $this->flist( $table );

    foreach( $rows as $row ) {
    if( !empty( $userdata['id'] )) $row['create_by'] = $userdata['id'];
    $row['create_date'] = time();

    $fields = array(); $vals = array();
    foreach( $flist as $f )
    if( isset( $row[$f[0]] )) {
    $fields[] = "`$f[0]`";
    $vals[] = (empty( $row[$f[0]] ) && $f[2] == 'YES') ? "NULL" : "'".$row[$f[0]]."'";
    }

    $this->query( "$type INTO $table ( ".implode( ", ", $fields ).")
    VALUES ( ".implode( ", ", $vals ).");" );
    }
    }

    function multi_update( $table, $rows ) {
    trigger_error( "Function is not implemented!", E_USER_ERROR );
    }
    }

    ?>