Skocz do zawartości
"Idzie nowe..." - o zmianach i nie tylko ×
Przeniesienie zakupów z IPS Marketplace / Moving bought items from IPS Marketplace ×
Hosting webh.pl - 20%

Brak Polskich Znaków.

Misztella

Przez Misztella
w Ogólny support IPB

 Udostępnij
Przejdź do rozwiązania Rozwiązane przez Misztella,

Rekomendowane odpowiedzi

Misztella Współpracownik

Misztella

Opublikowano
Opublikowano

Witam ponownie.

 

Poszukuję sposobów na pozbycie się tego cholernego (błędu?), że moje forum nie posiada Polskich znaków.

 

Wykonałem sposób:

Lecz nic to nie pomogło.

 

 

Nie wiem czy jest możliwość "zmiany ręcznej" czyli zamiany tych znaków zapytania na normalne litery?

 

PS. Czy po zmianie nulleda na licencję problem zostałby rozwiązany bądź znalazł by się nowy sposób na zlikwidowanie tego (bugu?)

Misztella Współpracownik

Misztella

Opublikowano
  • Autor
Opublikowano

Spróbuj w pliku conf_global.php zmienić sql_charset na latin2 lub latin1.

Tak wygląda plis conf_global.php po otworzeniu go w notatniku.

<?php
$INFO['sql_driver']			=	'mysql';
$INFO['sql_host']			=	'localhost';
$INFO['sql_database']			=	'DATA BASE';
$INFO['sql_user']			=	'UŻYTKOWNIK';
$INFO['sql_pass']			=	'HASŁO';
$INFO['sql_tbl_prefix']			=	'forum_';
$INFO['sql_debug']			=	'0';
$INFO['sql_charset']			=	'';
$INFO['board_start']			=	'1448055834';
$INFO['installed']			=	'1';
$INFO['php_ext']			=	'php';
$INFO['safe_mode']			=	'0';
$INFO['board_url']			=	'ADRES FORUM';
$INFO['banned_group']			=	'5';
$INFO['admin_group']			=	'4';
$INFO['guest_group']			=	'2';
$INFO['member_group']			=	'3';
$INFO['auth_group']			=	'1';
$INFO['use_friendly_urls']			=	'1';
$INFO['_jsDebug']			=	'0';
$INFO['mysql_tbl_type']			=	'MyISAM';

define('IN_DEV', 0);
/* Remote archive DB - complete these details if you\'re using a remote DB for the post archive.
   If content has already been archived in the local DB, this will need transferring and will not be done automatically. */
$INFO['archive_remote_sql_host']			=	'';
$INFO['archive_remote_sql_database']			=	'';
$INFO['archive_remote_sql_user']			=	'';
$INFO['archive_remote_sql_pass']			=	'';
$INFO['archive_remote_sql_charset']			=	'';

?>

Chyba cos w nim nie tak, nie prawdaż?

Misztella Współpracownik

Misztella

Opublikowano
  • Autor
Opublikowano (edytowane)

Przeczytałeś co napisałem? :)

 

Tak i zmieniłem tę oto linijkę.

$INFO['sql_charset']			=	'latin2';

Po zmianie na Latin2 nadal to samo oraz na Latin1 także.

 

#Edit: zastanawialem się czy po zmianie tego na latin2 badz 1 nie zrobić jeszcze raz tego poradnika od cb, to mialoby wgl prawo pomóc czy zbędna robota?

 

 

A TAK WYGLADA PRZYKLADOWY PLIK Z FTP (classDbMysqlClient.php) (wydaje mi się dziwne że w nim tez są te kwadraciki etc)

pre_1448311425__xd.png

 

Plik classDbMysqlClient.php

<?php
 
/**
 * <pre>
 * Invision Power Services
 * IP.Board v3.4.8
 * MySQL Database Driver :: MySQL client
 * Last Updated: $Date: 2012-05-25 13:17:47 -0400 (Fri, 25 May 2012) $
 * </pre>
 *
 * @author  $Author: ips_terabyte $
 * @copyright (c) 2001 - 2009 Invision Power Services, Inc.
 *
 * @package IP.Board
 * @subpackage Kernel
 *
 * @since Monday 28th February 2005 16:46
 * @version $Revision: 10798 $
 */
 
class db_driver_mysql extends db_main_mysql implements interfaceDb
{
/**
* constructor
*
* @return @e void
*/
public function __construct()
{
if( !defined('MYSQLI_USED') )
{
define( 'MYSQLI_USED', 0 );
}
 
//--------------------------------------
// Set up any required connect vars here
//--------------------------------------
 
      $this->connect_vars['mysql_tbl_type'] = "";
}
 
    /**
* Connect to database server
*
* @return @e boolean
*/
public function connect()
{
//-----------------------------------------
      // Done SQL prefix yet?
      //-----------------------------------------
 
      $this->_setPrefix();
 
     //-----------------------------------------
     // Load query file
     //-----------------------------------------
 
     $this->_loadCacheFile();
 
      //-----------------------------------------
      // Connect
      //-----------------------------------------
 
     if( $this->obj['sql_socket'] )
     {
     $this->obj['sql_host'] = $this->obj['sql_host'] . ':' . $this->obj['sql_socket'];
     }
 
     if ( $this->obj['persistent'] )
     {
         $this->connection_id = @mysql_pconnect( $this->obj['sql_host'] ,
  $this->obj['sql_user'] ,
  $this->obj['sql_pass'] ,
  $this->obj['force_new_connection']
);
        }
        else
        {
$this->connection_id = @mysql_connect( $this->obj['sql_host'] ,
 $this->obj['sql_user'] ,
 $this->obj['sql_pass'] ,
 $this->obj['force_new_connection']
);
}
 
if ( ! $this->connection_id )
{
$this->throwFatalError();
return FALSE;
}
 
        if ( ! mysql_select_db($this->obj['sql_database'], $this->connection_id) )
        {
         $this->throwFatalError();
         return FALSE;
        }
 
      //-----------------------------------------
      // Remove sensitive data
      //-----------------------------------------
 
unset( $this->obj['sql_host'] );
unset( $this->obj['sql_user'] );
unset( $this->obj['sql_pass'] );
 
      //-----------------------------------------
      // If there's a charset set, run it
      //-----------------------------------------
 
      if( $this->obj['sql_charset'] )
      {
      $this->query( "SET NAMES '{$this->obj['sql_charset']}'" );
      }
 
        return TRUE;
    }
 
    /**
* Close database connection
*
* @return @e boolean
*/
public function disconnect()
{
     if ( $this->connection_id )
     {
         return @mysql_close( $this->connection_id );
        }
    }
 
    /**
* Execute a direct database query
*
* @param string Database query
* @param boolean [Optional] Do not convert table prefix
* @return @e resource
*/
public function query( $the_query, $bypass=false )
{
     //-----------------------------------------
        // Debug?
        //-----------------------------------------
 
        if ( $this->obj['debug'] OR ( $this->obj['use_debug_log'] AND $this->obj['debug_log'] ) )
        {
     IPSDebug::startTimer();
     }
 
//-----------------------------------------
// Stop sub selects? (UNION)
//-----------------------------------------
 
if ( ! IPS_DB_ALLOW_SUB_SELECTS )
{
# On the spot allowance?
if ( ! $this->allow_sub_select )
{
$_tmp = strtolower( $this->_removeAllQuotes($the_query) );
 
if ( preg_match( "#(?:/\*|\*/)#i", $_tmp ) )
{
$this->throwFatalError( "You are not allowed to use comments in your SQL query.\nAdd \ipsRegistry::DB()->allow_sub_select=1; before any query construct to allow them\n{$the_query}" );
return false;
}
 
if ( preg_match( "#[^_a-zA-Z]union[^_a-zA-Z]#s", $_tmp ) )
{
$this->throwFatalError( "UNION query joins are not allowed.\nAdd \ipsRegistry::DB()->allow_sub_select=1; before any query construct to allow them\n{$the_query}" );
return false;
}
else if ( preg_match_all( "#[^_a-zA-Z](select)[^_a-zA-Z]#s", $_tmp, $matches ) )
{
if ( count( $matches ) > 1 )
{
$this->throwFatalError( "SUB SELECT query joins are not allowed.\nAdd \ipsRegistry::DB()->allow_sub_select=1; before any query construct to allow them\n{$the_query}" );
return false;
}
}
}
}
 
     //-----------------------------------------
     // Run the query
     //-----------------------------------------
 
#I had to switch this around... The query goes first, connection id second. Otherwise it just breaks - KF
#$this->query_id = mysql_query($this->connection_id, $the_query );
$this->query_id = mysql_query( $the_query, $this->connection_id );
 
       //-----------------------------------------
       // Reset array...
       //-----------------------------------------
 
       $this->resetDataTypes();
       $this->allow_sub_select = false;
 
        if (! $this->query_id )
        {
            $this->throwFatalError("mySQL query error: $the_query");
        }
 
        //-----------------------------------------
        // Debug?
        //-----------------------------------------
 
        if ( ( $this->obj['use_debug_log'] AND $this->obj['debug_log'] ) OR ( $this->obj['use_bad_log'] AND $this->obj['bad_log'] ) OR ( $this->obj['use_slow_log'] AND $this->obj['slow_log'] ) )
{
$endtime  = IPSDebug::endTimer();
$_data    = '';
 
if ( preg_match( "/^(?:\()?select/i", $the_query ) )
         {
         $eid  = mysql_query("EXPLAIN {$the_query}", $this->connection_id);
         $_bad = false;
 
while( $array = mysql_fetch_array($eid) )
{
$array['extra'] = isset( $array['extra'] ) ? $array['extra'] : '';
 
$_data .= "\n+------------------------------------------------------------------------------+";
$_data .= "\n|Table: ". $array['table'];
$_data .= "\n|Type: ". $array['type'];
$_data .= "\n|Possible Keys: ". $array['possible_keys'];
$_data .= "\n|Key: ". $array['key'];
$_data .= "\n|Key Len: ". $array['key_len'];
$_data .= "\n|Ref: ". $array['ref'];
$_data .= "\n|Rows: ". $array['rows'];
$_data .= "\n|Extra: ". $array['Extra'];
//$_data .= "\n+------------------------------------------------------------------------------+";
 
if ( ( $this->obj['use_bad_log'] AND $this->obj['bad_log'] ) AND ( stristr( $array['Extra'], 'filesort' ) OR stristr( $array['Extra'], 'temporary' ) ) )
{
$this->writeDebugLog( $the_query, $_data, $endtime, $this->obj['bad_log'], TRUE );
}
 
if ( ( $this->obj['use_slow_log'] AND $this->obj['slow_log'] ) AND $endtime >= $this->obj['use_slow_log'] )
{
$this->writeDebugLog( $the_query, $_data, $endtime, $this->obj['slow_log'], TRUE );
}
}
 
if ( $this->obj['use_debug_log'] AND $this->obj['debug_log'] )
{
$this->writeDebugLog( $the_query, $_data, $endtime );
}
}
else
{
if ( $this->obj['use_debug_log'] AND $this->obj['debug_log'] )
{
$this->writeDebugLog( $the_query, $_data, $endtime );
}
}
}
 
        //-----------------------------------------
        // Debugging?
        //-----------------------------------------
 
        if ($this->obj['debug'])
        {
         $endtime  = IPSDebug::endTimer();
 
         $shutdown = $this->is_shutdown ? 'SHUTDOWN QUERY: ' : '';
 
         if ( preg_match( "/^(?:\()?select/i", $the_query ) )
         {
         $eid = mysql_query( "EXPLAIN {$the_query}", $this->connection_id );
 
         $this->debug_html .= "<table width='95%' border='1' cellpadding='6' cellspacing='0' bgcolor='#FFE8F3' align='center'>
  <tr>
    <td colspan='8' style='font-size:14px' bgcolor='#FFC5Cb'><b>{$shutdown}Select Query</b></td>
  </tr>
  <tr>
   <td colspan='8' style='font-family:courier, monaco, arial;font-size:14px;color:black'>$the_query</td>
  </tr>
  <tr bgcolor='#FFC5Cb'>
<td><b>table</b></td><td><b>type</b></td><td><b>possible_keys</b></td>
<td><b>key</b></td><td><b>key_len</b></td><td><b>ref</b></td>
<td><b>rows</b></td><td><b>Extra</b></td>
  </tr>\n";
while( $array = mysql_fetch_array($eid) )
{
$type_col = '#FFFFFF';
 
if ($array['type'] == 'ref' or $array['type'] == 'eq_ref' or $array['type'] == 'const')
{
$type_col = '#D8FFD4';
}
else if ($array['type'] == 'ALL')
{
$type_col = '#FFEEBA';
}
 
$this->debug_html .= "<tr bgcolor='#FFFFFF'>
<td>$array[table] </td>
<td bgcolor='$type_col'>$array[type] </td>
<td>$array[possible_keys] </td>
<td>$array[key] </td>
<td>$array[key_len] </td>
<td>$array[ref] </td>
<td>$array[rows] </td>
<td>$array[Extra] </td>
  </tr>\n";
}
 
$this->sql_time += $endtime;
 
if ($endtime > 0.1)
{
$endtime = "<span style='color:red'><b>$endtime</b></span>";
}
 
$this->debug_html .= "<tr>
 <td colspan='8' bgcolor='#FFD6DC' style='font-size:14px'><b>MySQL time</b>: $endtime</b></td>
 </tr>
 </table>\n<br />\n";
}
else
{
 $this->debug_html .= "<table width='95%' border='1' cellpadding='6' cellspacing='0' bgcolor='#FEFEFE'  align='center'>
<tr>
 <td style='font-size:14px' bgcolor='#EFEFEF'><b>{$shutdown}Non Select Query</b></td>
</tr>
<tr>
 <td style='font-family:courier, monaco, arial;font-size:14px'>$the_query</td>
</tr>
<tr>
 <td style='font-size:14px' bgcolor='#EFEFEF'><b>MySQL time</b>: $endtime</span></td>
</tr>
</table><br />\n\n";
}
}
 
$this->query_count++;
 
        $this->obj['cached_queries'][] = $the_query;
 
        return $this->query_id;
    }
 
    /**
* Retrieve number of rows affected by last query
*
* @return @e integer
*/
public function getAffectedRows()
{
return mysql_affected_rows( $this->connection_id );
}
 
    /**
* Retrieve number of rows in result set
*
* @param resource [Optional] Query id
* @return @e integer
*/
public function getTotalRows( $query_id=null )
{
if ( ! $query_id )
    {
     $query_id = $this->query_id;
     }
 
        return mysql_num_rows( $query_id );
    }
 
    /**
* Retrieve latest autoincrement insert id
*
* @return @e integer
*/
public function getInsertId()
{
return mysql_insert_id($this->connection_id);
}
 
    /**
* Retrieve the current thread id
*
* @return @e integer
*/
public function getThreadId()
{
return mysql_thread_id($this->connection_id);
}
 
    /**
* Free result set from memory
*
* @param resource [Optional] Query id
* @return @e void
*/
public function freeResult( $query_id=null )
{
    if ( ! $query_id )
    {
     $query_id = $this->query_id;
     }
 
     @mysql_free_result( $query_id );
    }
 
    /**
* Retrieve row from database
*
* @param resource [Optional] Query result id
* @return @e mixed
*/
public function fetch( $query_id=null )
{
     if ( ! $query_id )
     {
     $query_id = $this->query_id;
     }
 
        $this->record_row = mysql_fetch_array( $query_id, MYSQL_ASSOC );
 
        return $this->record_row;
    }
 
/**
* Return the number calculated rows (as if there was no limit clause)
*
* @param string  [ alias name for the count(*) ]
* @return @e integer
*/
public function fetchCalculatedRows( $alias='count' )
{
$calcRowsHandle = mysql_query( "SELECT FOUND_ROWS() as " . $alias, $this->connection_id );
 
$val = mysql_fetch_array( $calcRowsHandle, MYSQL_ASSOC );
 
return intval( $val[ $alias ] );
}
 
    /**
* Get array of fields in result set
*
* @param resource [Optional] Query id
* @return @e array
*/
public function getResultFields( $query_id=null )
{
     $fields = array();
 
    if ( !$query_id )
    {
     $query_id = $this->query_id;
     }
 
while( $field = mysql_fetch_field($query_id) )
{
            $fields[] = $field;
}
 
return $fields;
}
 
    /**
* Get array of table names in database
*
* @return @e array
*/
public function getTableNames()
{
if ( is_array( $this->cached_tables ) AND count( $this->cached_tables ) )
   {
   return $this->cached_tables;
   }
 
   $current = $this->return_die;
   $this->return_die  = true;
 
   $qid = $this->query( "SHOW TABLES FROM `{$this->obj['sql_database']}`" );
 
   $this->return_die  = $current;
 
   if( $qid AND $this->getTotalRows($qid) )
   {
   while( $result = mysql_fetch_array($qid) )
   {
$this->cached_tables[] = $result[0];
}
}
 
mysql_free_result($qid);
 
return $this->cached_tables;
    }
 
    /**
* Retrieve SQL server version
*
* @return @e string
*/
public function getSqlVersion()
{
if ( ! $this->sql_version and ! $this->true_version )
{
$this->query( "SELECT VERSION() AS version" );
 
if ( ! $row = $this->fetch() )
{
$this->query( "SHOW VARIABLES LIKE 'version' ");
$row = $this->fetch();
}
 
$this->true_version = $row['version'];
$tmp                = explode( '.', preg_replace( "#[^\d\.]#", "\\1", $row['version'] ) );
 
$this->sql_version = sprintf('%d%02d%02d', $tmp[0], $tmp[1], $tmp[2] );
    }
 
    return $this->sql_version;
}
 
    /**
* Escape strings for DB insertion
*
* @param string Text to escape
* @return @e string
*/
public function addSlashes( $t )
{
return @mysql_real_escape_string( $t, $this->connection_id );
}
 
    /**
* Get SQL error number
*
* @return @e mixed
*/
protected function _getErrorNumber()
{
   if( $this->connection_id )
   {
   return @mysql_errno( $this->connection_id );
   }
   else
   {
   return @mysql_errno();
   }
}
 
    /**
* Get SQL error message
*
* @return @e string
*/
protected function _getErrorString()
{
   if( $this->connection_id )
   {
   return @mysql_error( $this->connection_id );
   }
   else
   {
   return @mysql_error();
   }
}
 
/**
* Test to see whether a table exists
*
* @param string Table name
* @return @e boolean
*/
public function checkForTable( $table )
{
//$table_names = $this->getTableNames();
 
//$return = false;
 
//if ( in_array( strtolower( trim( $this->obj['sql_tbl_prefix'] . $table ) ), array_map( 'strtolower', $table_names ) ) )
//{
//    $return = true;
//}
 
//unset($table_names);
 
$table = trim( $this->obj['sql_tbl_prefix'] . $table );
 
$qid = $this->query( "SHOW TABLES FROM `{$this->obj['sql_database']}` LIKE '{$table}'" );
 
if( ! $qid OR ! $this->getTotalRows($qid) )
{
return false;
}
else
{
while( $result = mysql_fetch_array($qid) )
{
if( $result[0] == $table )
{
mysql_free_result($qid);
 
return true;
}
}
   }
 
   return false;
}
 
 
} // end class
 

 

Plik classDbMysqliClient.php

<?php
 
/**
 * <pre>
 * Invision Power Services
 * IP.Board v3.4.8
 * MySQL Database Driver :: MySQLi client
 * Last Updated: $Date: 2012-05-25 13:17:47 -0400 (Fri, 25 May 2012) $
 * </pre>
 *
 * @author  $Author: ips_terabyte $
 * @copyright (c) 2001 - 2009 Invision Power Services, Inc.
 *
 * @package IP.Board
 * @subpackage Kernel
 *
 * @since Monday 28th February 2005 16:46
 * @version $Revision: 10798 $
 */
 
class db_driver_mysql extends db_main_mysql implements interfaceDb
{
/**
* Connection failed flag
*
* @var  boolean
*/
protected $connect_failed = false;
 
/**
* constructor
*
* @return @e void
*/
public function __construct()
{
if( !defined('MYSQLI_USED') )
{
define( 'MYSQLI_USED', 1 );
}
 
//--------------------------------------
// Set up any required connect vars here
//--------------------------------------
 
      $this->connect_vars['mysql_tbl_type'] = "";
}
 
    /**
* Connect to database server
*
* @return @e boolean
*/
public function connect()
{
//-----------------------------------------
      // Done SQL prefix yet?
      //-----------------------------------------
 
      $this->_setPrefix();
 
     //-----------------------------------------
     // Load query file
     //-----------------------------------------
 
     $this->_loadCacheFile();
 
      //-----------------------------------------
      // Connect
      //-----------------------------------------
 
/* Did we add a port inline? */
if ( ! $this->obj['sql_port'] AND strstr( $this->obj['sql_host'], ':' ) )
{
list( $host, $port ) = explode( ':', $this->obj['sql_host'] );
 
$this->obj['sql_host'] = $host;
$this->obj['sql_port'] = intval( $port );
}
 
/* Persistent connection */
if( $this->obj['persistent'] )
{
$this->obj['sql_host'] = 'p:' . $this->obj['sql_host'];
}
 
/* Use socket if specified */
if( $this->obj['sql_socket'] )
{
if( $this->obj['sql_port'] )
{
$this->connection_id = @mysqli_connect( $this->obj['sql_host'],
 $this->obj['sql_user'],
 $this->obj['sql_pass'],
 $this->obj['sql_database'],
 $this->obj['sql_port'],
 $this->obj['sql_socket']
);
}
else
{
$this->connection_id = @mysqli_connect( $this->obj['sql_host'],
 $this->obj['sql_user'],
 $this->obj['sql_pass'],
 $this->obj['sql_database'],
 null,
 $this->obj['sql_socket']
);
}
}
else
{
if( $this->obj['sql_port'] )
{
$this->connection_id = @mysqli_connect( $this->obj['sql_host'],
 $this->obj['sql_user'],
 $this->obj['sql_pass'],
 $this->obj['sql_database'],
 $this->obj['sql_port']
);
}
else
{
$this->connection_id = @mysqli_connect( $this->obj['sql_host'],
 $this->obj['sql_user'],
 $this->obj['sql_pass'],
 $this->obj['sql_database']
);
}
 
}
 
if ( ! $this->connection_id )
{
$this->usingClass     = 'db_driver_mysql';
$this->connect_failed = true;
$this->throwFatalError();
return FALSE;
}
 
        mysqli_autocommit( $this->connection_id, TRUE );
 
      //-----------------------------------------
      // Remove sensitive data
      //-----------------------------------------
 
unset( $this->obj['sql_host'] );
unset( $this->obj['sql_user'] );
unset( $this->obj['sql_pass'] );
 
      //-----------------------------------------
      // If there's a charset set, run it
      //-----------------------------------------
 
      if( $this->obj['sql_charset'] )
      {
      $this->query( "SET NAMES '{$this->obj['sql_charset']}'" );
      }
 
parent::connect();
 
        return TRUE;
    }
 
    /**
* Close database connection
*
* @return @e boolean
*/
public function disconnect()
{
     if ( $this->connection_id )
     {
         return @mysqli_close( $this->connection_id );
        }
    }
 
    /**
* Execute a direct database query
*
* @param string Database query
* @param boolean [Optional] Do not convert table prefix
* @return @e resource
*/
public function query( $the_query, $bypass=false )
{
     //-----------------------------------------
        // Debug?
        //-----------------------------------------
 
        if ( $this->obj['debug'] OR ( $this->obj['use_debug_log'] AND $this->obj['debug_log'] ) OR ( $this->obj['use_bad_log'] AND $this->obj['bad_log'] ) )
        {
     IPSDebug::startTimer();
$_MEMORY = IPSDebug::getMemoryDebugFlag();
     }
 
//-----------------------------------------
// Stop sub selects? (UNION)
//-----------------------------------------
 
if ( ! IPS_DB_ALLOW_SUB_SELECTS )
{
# On the spot allowance?
if ( ! $this->allow_sub_select )
{
$_tmp = strtolower( $this->_removeAllQuotes($the_query) );
 
if ( preg_match( "#(?:/\*|\*/)#i", $_tmp ) )
{
$this->throwFatalError( "You are not allowed to use comments in your SQL query.\nAdd \ipsRegistry::DB()->allow_sub_select=1; before any query construct to allow them" );
return false;
}
 
if ( preg_match( "#[^_a-zA-Z]union[^_a-zA-Z]#s", $_tmp ) )
{
$this->throwFatalError( "UNION query joins are not allowed.\nAdd \ipsRegistry::DB()->allow_sub_select=1; before any query construct to allow them" );
return false;
}
else if ( preg_match_all( "#[^_a-zA-Z](select)[^_a-zA-Z]#s", $_tmp, $matches ) )
{
if ( count( $matches ) > 1 )
{
$this->throwFatalError( "SUB SELECT query joins are not allowed.\nAdd \ipsRegistry::DB()->allow_sub_select=1; before any query construct to allow them" );
return false;
}
}
}
}
 
     //-----------------------------------------
     // Run the query
     //-----------------------------------------
     $this->_tmpQ    = substr( $the_query, 0, 100 ) . '...';
        $this->query_id = mysqli_query($this->connection_id, $the_query );
 
       //-----------------------------------------
       // Reset array...
       //-----------------------------------------
 
       $this->resetDataTypes();
       $this->allow_sub_select = false;
 
        if (! $this->query_id )
        {
            $this->throwFatalError("mySQL query error: $the_query");
        }
 
        //-----------------------------------------
        // Logging?
        //-----------------------------------------
 
if ( ( $this->obj['use_debug_log'] AND $this->obj['debug_log'] ) OR ( $this->obj['use_bad_log'] AND $this->obj['bad_log'] ) OR ( $this->obj['use_slow_log'] AND $this->obj['slow_log'] ) )
{
$endtime  = IPSDebug::endTimer();
$_data    = '';
 
if ( preg_match( "/^(?:\()?select/i", $the_query ) )
         {
         $eid  = mysqli_query($this->connection_id, "EXPLAIN {$the_query}");
         $_bad = false;
 
while( $array = mysqli_fetch_array($eid) )
{
$array['extra'] = isset( $array['extra'] ) ? $array['extra'] : '';
 
$_data .= "\n+------------------------------------------------------------------------------+";
$_data .= "\n|Table: ". $array['table'];
$_data .= "\n|Type: ". $array['type'];
$_data .= "\n|Possible Keys: ". $array['possible_keys'];
$_data .= "\n|Key: ". $array['key'];
$_data .= "\n|Key Len: ". $array['key_len'];
$_data .= "\n|Ref: ". $array['ref'];
$_data .= "\n|Rows: ". $array['rows'];
$_data .= "\n|Extra: ". $array['Extra'];
//$_data .= "\n+------------------------------------------------------------------------------+";
 
if ( ( $this->obj['use_bad_log'] AND $this->obj['bad_log'] ) AND ( stristr( $array['Extra'], 'filesort' ) OR stristr( $array['Extra'], 'temporary' ) ) )
{
$this->writeDebugLog( $the_query, $_data, $endtime, $this->obj['bad_log'], TRUE );
}
 
if ( ( $this->obj['use_slow_log'] AND $this->obj['slow_log'] ) AND $endtime >= $this->obj['use_slow_log'] )
{
$this->writeDebugLog( $the_query, $_data, $endtime, $this->obj['slow_log'], TRUE );
}
}
 
if ( $this->obj['use_debug_log'] AND $this->obj['debug_log'] )
{
$this->writeDebugLog( $the_query, $_data, $endtime );
}
}
else
{
if ( $this->obj['use_debug_log'] AND $this->obj['debug_log'] )
{
$this->writeDebugLog( $the_query, $_data, $endtime );
}
}
}
 
        //-----------------------------------------
        // Debugging?
        //-----------------------------------------
 
        if ($this->obj['debug'])
        {
         $endtime    = IPSDebug::endTimer();
         $memoryUsed = IPSDebug::setMemoryDebugFlag( '', $_MEMORY );
$memory     = '';
         $shutdown   = $this->is_shutdown ? 'SHUTDOWN QUERY: ' : '';
 
         if ( preg_match( "/^(?:\()?select/i", $the_query ) )
         {
         $eid = mysqli_query( $this->connection_id, "EXPLAIN {$the_query}" );
 
         $this->debug_html .= "<table width='95%' border='1' cellpadding='6' cellspacing='0' bgcolor='#FFE8F3' align='center'>
  <tr>
    <td colspan='8' style='font-size:14px' bgcolor='#FFC5Cb'><b>{$shutdown}Select Query</b></td>
  </tr>
  <tr>
   <td colspan='8' style='font-family:courier, monaco, arial;font-size:14px;color:black'>$the_query</td>
  </tr>
  <tr bgcolor='#FFC5Cb'>
<td><b>table</b></td><td><b>type</b></td><td><b>possible_keys</b></td>
<td><b>key</b></td><td><b>key_len</b></td><td><b>ref</b></td>
<td><b>rows</b></td><td><b>Extra</b></td>
  </tr>\n";
while( $array = mysqli_fetch_array($eid) )
{
$type_col = '#FFFFFF';
 
if ($array['type'] == 'ref' or $array['type'] == 'eq_ref' or $array['type'] == 'const')
{
$type_col = '#D8FFD4';
}
else if ($array['type'] == 'ALL')
{
$type_col = '#FFEEBA';
}
 
$this->debug_html .= "<tr bgcolor='#FFFFFF'>
<td>$array[table] </td>
<td bgcolor='$type_col'>$array[type] </td>
<td>$array[possible_keys] </td>
<td>$array[key] </td>
<td>$array[key_len] </td>
<td>$array[ref] </td>
<td>$array[rows] </td>
<td>$array[Extra] </td>
  </tr>\n";
}
 
$this->sql_time += $endtime;
 
if ($endtime > 0.1)
{
$endtime = "<span style='color:red'><b>$endtime</b></span>";
}
 
if ( $memoryUsed )
{
$memory = '<br />Memory Used: ' . IPSLib::sizeFormat( $memoryUsed, TRUE );
}
 
$this->debug_html .= "<tr>
 <td colspan='8' bgcolor='#FFD6DC' style='font-size:14px'><b>MySQL time</b>: $endtime{$memory}</b></td>
 </tr>
 </table>\n<br />\n";
}
else
{
 $this->debug_html .= "<table width='95%' border='1' cellpadding='6' cellspacing='0' bgcolor='#FEFEFE'  align='center'>
<tr>
 <td style='font-size:14px' bgcolor='#EFEFEF'><b>{$shutdown}Non Select Query</b></td>
</tr>
<tr>
 <td style='font-family:courier, monaco, arial;font-size:14px'>$the_query</td>
</tr>
<tr>
 <td style='font-size:14px' bgcolor='#EFEFEF'><b>MySQL time</b>: $endtime</span></td>
</tr>
</table><br />\n\n";
}
}
 
$this->query_count++;
 
        $this->obj['cached_queries'][] = $the_query;
 
        return $this->query_id;
    }
 
    /**
* Retrieve number of rows affected by last query
*
* @return @e integer
*/
public function getAffectedRows()
{
return mysqli_affected_rows( $this->connection_id );
}
 
    /**
* Retrieve number of rows in result set
*
* @param resource [Optional] Query id
* @return @e integer
*/
public function getTotalRows( $query_id=null )
{
if ( ! $query_id )
    {
     $query_id = $this->query_id;
     }
 
        return mysqli_num_rows( $query_id );
    }
 
    /**
* Retrieve latest autoincrement insert id
*
* @return @e integer
*/
public function getInsertId()
{
return mysqli_insert_id($this->connection_id);
}
 
    /**
* Retrieve the current thread id
*
* @return @e integer
*/
public function getThreadId()
{
return mysqli_thread_id($this->connection_id);
}
 
    /**
* Free result set from memory
*
* @param resource [Optional] Query id
* @return @e void
*/
public function freeResult( $query_id=null )
{
    if ( ! $query_id )
    {
     $query_id = $this->query_id;
     }
 
     @mysqli_free_result( $query_id );
    }
 
    /**
* Retrieve row from database
*
* @param resource [Optional] Query result id
* @return @e mixed
*/
public function fetch( $query_id=null )
{
//$_MEMORY = IPSDebug::getMemoryDebugFlag();
 
     if ( ! $query_id )
     {
     $query_id = $this->query_id;
     }
 
        $this->record_row = mysqli_fetch_assoc( $query_id );
 
/*if ( is_array( $this->record_row ) )
{
$tmp = $this->record_row;
$boo = array_shift( $tmp );
}
 
$poo = IPSDebug::setMemoryDebugFlag( 'Fetch Row: ' . $boo . ' ' . $this->_tmpQ, $_MEMORY );
$this->_tmpT += $poo;*/
        return $this->record_row;
    }
 
/**
* Return the number calculated rows (as if there was no limit clause)
*
* @param string  [ alias name for the count(*) ]
* @return @e integer
*/
public function fetchCalculatedRows( $alias='count' )
{
$calcRowsHandle = mysqli_query( $this->connection_id, "SELECT FOUND_ROWS() as " . $alias );
 
$this->obj['cached_queries'][] = "SELECT FOUND_ROWS() as " . $alias;
 
$val = mysqli_fetch_assoc( $calcRowsHandle );
 
return intval( $val[ $alias ] );
}
 
    /**
* Get array of fields in result set
*
* @param resource [Optional] Query id
* @return @e array
*/
public function getResultFields( $query_id=null )
{
     $fields = array();
 
    if ( !$query_id )
    {
     $query_id = $this->query_id;
     }
 
while( $field = mysqli_fetch_field($query_id) )
{
            $fields[] = $field;
}
 
return $fields;
}
 
    /**
* Get array of table names in database
*
* @return @e array
*/
public function getTableNames()
{
   if ( is_array( $this->cached_tables ) AND count( $this->cached_tables ) )
   {
   return $this->cached_tables;
   }
 
   $current = $this->return_die;
   $this->return_die  = true;
 
   $qid = $this->query( "SHOW TABLES FROM `{$this->obj['sql_database']}`" );
 
   $this->return_die  = $current;
 
   if( $qid AND $this->getTotalRows($qid) )
   {
while( $result = mysqli_fetch_array($qid) )
{
$this->cached_tables[] = $result[0];
}
}
 
mysqli_free_result($qid);
 
return $this->cached_tables;
    }
 
    /**
* Retrieve SQL server version
*
* @return @e string
*/
public function getSqlVersion()
{
if ( ! $this->sql_version and ! $this->true_version )
{
$version = mysqli_get_server_info($this->connection_id);
 
$this->true_version = $version;
$tmp                = explode( '.', preg_replace( "#[^\d\.]#", "\\1", $version ) );
 
$this->sql_version = sprintf('%d%02d%02d', $tmp[0], $tmp[1], $tmp[2] );
    }
 
    return $this->sql_version;
}
 
    /**
* Escape strings for DB insertion
*
* @param string Text to escape
* @return @e string
*/
public function addSlashes( $t )
{
return @mysqli_real_escape_string( $this->connection_id, $t );
}
 
    /**
* Get SQL error number
*
* @return @e mixed
*/
protected function _getErrorNumber()
{
   if( $this->connect_failed )
   {
   return mysqli_connect_errno();
   }
   else
   {
     return mysqli_errno( $this->connection_id );
}
}
 
    /**
* Get SQL error message
*
* @return @e string
*/
protected function _getErrorString()
{ 
   if( $this->connect_failed )
   {
   return mysqli_connect_error( );
   }
   else
   {
     return mysqli_error( $this->connection_id );
}
}
 
/**
* Test to see whether a table exists
*
* @param string Table name
* @return @e boolean
*/
public function checkForTable( $table )
{
//$table_names = $this->getTableNames();
 
//$return = false;
 
//if ( in_array( strtolower( trim( $this->obj['sql_tbl_prefix'] . $table ) ), array_map( 'strtolower', $table_names ) ) )
//{
//    $return = true;
//}
 
//unset($table_names);
 
$table = trim( $this->obj['sql_tbl_prefix'] . $table );
 
$qid = $this->query( "SHOW TABLES FROM `{$this->obj['sql_database']}` LIKE '{$table}'" );
 
if( ! $qid OR ! $this->getTotalRows($qid) )
{
return false;
}
else
{
while( $result = mysqli_fetch_array($qid) )
{
if( $result[0] == $table )
{
mysqli_free_result($qid);
 
return true;
}
}
   }
 
   return false;
}
} // end class
 
Edytowane przez Misztella
Macsch15 Arcymistrz

Macsch15

Opublikowano
Opublikowano

Jeżeli użyjesz normalnego edytora to nie będzie dziwnych znaków i wszystkiego w jednej linii.

 

Poza tym, pytałem czy w nowych postach są polskie znaki czy nie i nie dostałem konkretnej odpowiedzi.

W spolszczeniu są polskie znaki?

Misztella Współpracownik

Misztella

Opublikowano
  • Autor
Opublikowano

Jeżeli użyjesz normalnego edytora to nie będzie dziwnych znaków i wszystkiego w jednej linii.

 

Poza tym, pytałem czy w nowych postach są polskie znaki czy nie i nie dostałem konkretnej odpowiedzi.

W spolszczeniu są polskie znaki?

 

Nie ma Polskich znaków w nowych postach.

 

W spolszczenie mam to dla wersji 3,4,8 i sam mam tą wersję. Jak tak patrzylem na komentarze to to spolszczenie od DP wszystkim śmiga jak nalezy.

Misztella Współpracownik

Misztella

Opublikowano
  • Autor
Opublikowano (edytowane)

Zrób to: http://forum.invisionize.pl/topic/47327-naprawa-wy%C5%9Bwietlania-polskich-znak%C3%B3w/a jak nie pomoże to pisz ticket do IPS - sprawdzą od środka.

A gdzie sprawdzić jaką mam bazę? I tak pozmieniam wszystko na to latin2 a potem latin1, ale chciałbym wiedzieć.

 

PS. Dodam, że miałem ten bład na wersji 3.4.6, 3.4.7 , 3.4.8 i na zadnej ten poradnik nie pomógł.

Edytowane przez Misztella
Jurij Arcymistrz

Jurij

Opublikowano
Opublikowano

PhpMyAdmin - program do zarządzania bazami danych. Twój hosting powinien to oferować w standardzie. Jeśli tego nie robi, to współczuję hostingu i zainstaluj sobie samemu :)

  • Lubię to 1
Misztella Współpracownik

Misztella

Opublikowano
  • Autor
Opublikowano

W PMA sprawdź.

 

UTF8. Mam jednak pytanie, ponieważ jak pewnie wiesz jest tam opcja zmiany bazy, czy mogę spróbować zmienić na np. latin2/1 i jeszcze raz zrobić ten poradnik?

Misztella Współpracownik

Misztella

Opublikowano
  • Autor
Opublikowano (edytowane)

Chcialem edytować ostatni post i dodać to zdj, ale nie mogę więc napisze drugi.

 

Ogólnie to dzisiaj postanowiłem za wszelką cene naprawić ten problem. Wszedłem do PMA i tam poszukałem co nieco o Polskich znakach. 

Nie wiem czy ten screen wniesie coś do tematu. Czy da sie zmienić kodowanie znakow na forum (na ten jak na screenie) ? Na PMA juz to zrobiłem aby zobaczyć czy to cos da. Jednakże moje starania były bezcelowe. 

 

Owy screen:

pre_1448706041__przechwytywanie.png

 

 

#EDIT2: Takie mam kodowanie :) Myślę, że ten screen akurat pomoże w rozwiazaniu problemu. :)

pre_1448706550__przechwytywanie.png

Edytowane przez Misztella
Gość
Ten temat został zamknięty. Brak możliwości dodania odpowiedzi.
 Udostępnij
Tematy

  • Ostatnio przeglądający   0 użytkowników

    • Brak zarejestrowanych użytkowników przeglądających tę stronę.
×
×
  • Dodaj nową pozycję...

Powiadomienie o plikach cookie

Umieściliśmy na Twoim urządzeniu pliki cookie, aby pomóc Ci usprawnić przeglądanie strony. Możesz dostosować ustawienia plików cookie, w przeciwnym wypadku zakładamy, że wyrażasz na to zgodę.