so mal 2 fragen oder auch 3

proflyffers · 2. August 2009, 22:04

also hallo GL!
habe das volgende problem:kann in der phpmyadmin db keine queris einbauen um den master hero changer ein zu fügen wenn er in der db mit drinn is und ich die db importiere dan macht er mir beim query ne fehler meldung :(!
meine db leuft über plesk wegen mysql zu dem habe ich heute rausgefunden wenn die db importiert wurde im plesk was 2std dauert :( und ich im nachhinein navicat installe die daten eingebe die ich für plesk nutze zeigt er mir auch die db bei navicat.
meine frage is nu habe den query (master_hero+skills) über navicat hinzugefügt aber wirkt nicht es kann trotzdem niemand nach relogg master oder hero werden.
was kann ich machen das es geht?

dan hab ich noch folgendes problem mit meinem forum da ich von einem schlechten aber denoch teuren root umgezogen binn auf eine empfehlung von Valron "danke noch mal der server is geil" (root)
bekomme ich das forum nicht zum laufen da er mir einen fehler der php datei ansagt wegen passwort aber ich von anfang bis ende der zeilen schaute aber nix fand bzw nix stand konnte ich auch nix machen da ich mich nich mit php auskenne aber langsam lerne da ich fast alles eigentlich alleine versuche aber nach genau 28std und 34 min vielen mir die augen zu und meine geduld wa am ende jetzt versuche ich mir hier hilfe zu holen da ich i einem anderen forum "nich der rede wert" kennt jeder den stall da keine hlfe bekam.

nun hoffe ich hier bei euch auf reichlicher nützliger antworten :)

Valron · 2. August 2009, 22:09

[COLOR="Cyan"]Zum 1. Problem:
Connecte mit Navicat, mach ein Rechtsklick auf characters und
geh auf Design Table (Bei englischen version) bzw Tabelle entwerfen
(deutsche Version).
Dann geh zu Trigger und lösch die Abfrage, die da Höchswahrscheinlich
steht.
Dann speichern und schließen.

Nun gehst du auf Abfragen, wählst die Abfrage / den Trigger aus
und drückst oben auf start.
Nun sollte er das ganz normal starten!

Zum 2. Problem:

Welches Forum CMS benutzt du?

mfg
Valron[/COLOR]

proflyffers · 2. August 2009, 22:12

also kurz zum forum nein nehme leider mybb da ich es selber nich konnte hab ich es mir machen lassen"nich falsch verstehen"^^

und zum trigger genau das habe ich gemacht trotz allem geht das leider nicht valron

Valron · 2. August 2009, 22:17

[COLOR="Cyan"]Da müsste eigentlich eine Config Datei sein (config.php)
die so aussieht:

PHP-Quellcode

<?php
// phpBB 3.0.x auto-generated configuration file
// Do not change anything in this file!
$dbms = 'mysql';
$dbhost = 'localhost';
$dbport = '';
$dbname = 'proflyffers';
$dbuser = 'root';
$dbpasswd = '1234';
$table_prefix = 'phpbb_';
$acm_type = 'file';
$load_extensions = '';
@define('PHPBB_INSTALLED', true);
// @define('DEBUG', true);
// @define('DEBUG_EXTRA', true);
?>

Alles anzeigen

Dies einfach anpassen und fertig.

Nochmal zum Trigger Problem:
Kommt irgendeine Fehlermeldung, wenn du den
Trigger versuchst wieder zu starten?

mfg
Valron[/COLOR]

proflyffers · 2. August 2009, 22:20

werd gleich ma den fehler posten ok.

der trigger zeigt mir leider keinen fehler das is ja das kuriose an der sache

Valron · 2. August 2009, 22:25

[COLOR="Cyan"]Hm, dann weis ich auch nicht so recht....

Und wie siehts mit dem Forum aus?
Haste eine config gefunden? :P

mfg
Valron[/COLOR]

proflyffers · 2. August 2009, 22:31

www3.pic-upload.de/02.08.09/lbsv5tnjhr34.jpg
www3.pic-upload.de/02.08.09/mzawwvzrc53p.jpg

so das is es der erste is nur zum beweiß das ich drücken erweitern auf mybb ........

und der zweite is der fehler meine config.inc wo der fehler steckt werd ich dir hier posten

mist wasn das

moment ich muss noch mal forums größe einstellen wa mein fehler

so sollte es gehen

Valron · 2. August 2009, 22:32

[COLOR="Cyan"]Die Bilder sind zu klein <.<
Mach bitte den exakten Link zum Bild,
damit man es in original Größe anschauen kann..

mfg
Valron[/COLOR]

proflyffers · 2. August 2009, 22:36

die wollen irgend wie nicht größer komisch habs nun 3 mal größer gemacht
so beide in 1024er

Valron · 2. August 2009, 22:40

[COLOR="Cyan"]Der pfad zu deiner Config steht doch in der Fehlermeldung. O.O
Geh da hin und pass sie an, und fertig ists.^^

mfg
Valron[/COLOR]

proflyffers · 2. August 2009, 22:44

das is es ja in der zeile steht ja leider nix darüber das is ja mein riesen proiblem :( das sin die einzigen 2fehler die ich atm noch aufm root habe :(

hier die sql:

Quellcode

<?php
/**
* MyBB 1.4
* Copyright © 2008 MyBB Group, All Rights Reserved
*
* Website: [url=http://www.mybboard.net]MyBB - Free PHP and MySQL Forum Software[/url]
* License: [url=http://www.mybboard.net/about/license]MyBB - License Agreement[/url]
*
* $Id: db_mysql.php 4304 2009-01-02 01:11:56Z chris $
*/
class DB_MySQL
{
/**
* The title of this layer.
*
* @var string
*/
var $title = "MySQL";
/**
* The short title of this layer.
*
* @var string
*/
var $short_title = "MySQL";
/**
* The type of db software being used.
*
* @var string
*/
var $type;
/**
* A count of the number of queries.
*
* @var int
*/
var $query_count = 0;
/**
* A list of the performed queries.
*
* @var array
*/
var $querylist = array();
/**
* 1 if error reporting enabled, 0 if disabled.
*
* @var boolean
*/
var $error_reporting = 1;
/**
* The read database connection resource.
*
* @var resource
*/
var $read_link;
/**
* The write database connection resource
*
* @var resource
*/
var $write_link;
/**
* Reference to the last database connection resource used.
*
* @var resource
*/
var $current_link;
/**
* Explanation of a query.
*
* @var string
*/
var $explain;
/**
* The current version of MySQL.
*
* @var string
*/
var $version;
/**
* The current table type in use (myisam/innodb)
*
* @var string
*/
var $table_type = "myisam";
/**
* The table prefix used for simple select, update, insert and delete queries
*
* @var string
*/
var $table_prefix;
/**
* The extension used to run the SQL database
*
* @var string
*/
var $engine = "mysql";
/**
* Weather or not this engine can use the search functionality
*
* @var boolean
*/
var $can_search = true;
/**
* The database encoding currently in use (if supported)
*
* @var string
*/
var $db_encoding = "utf8";
/**
* The time spent performing queries
*
* @var float
*/
var $query_time = 0;
/**
* Connect to the database server.
*
* @param array Array of DBMS connection details.
* @return resource The DB connection resource.
*/
function connect($config)
{
// Simple connection to one server
if(array_key_exists('hostname', $config))
{
$connections['read'][] = $config;
}
else
// Connecting to more than one server
{
// Specified multiple servers, but no specific read/write servers
if(!array_key_exists('read', $config))
{
foreach($config as $key => $settings)
{
if(is_int($key)) $connections['read'][] = $settings;
}
}
// Specified both read & write servers
else
{
$connections = $config;
}
}
$this->db_encoding = $config['encoding'];
// Actually connect to the specified servers
foreach(array('read', 'write') as $type)
{
if(!is_array($connections[$type]))
{
break;
}
if(array_key_exists('hostname', $connections[$type]))
{
$details = $connections[$type];
unset($connections);
$connections[$type][] = $details;
}
// Shuffle the connections
shuffle($connections[$type]);
// Loop-de-loop
foreach($connections[$type] as $single_connection)
{
$connect_function = "mysql_connect";
if($single_connection['pconnect'])
{
$connect_function = "mysql_pconnect";
}
$link = $type."_link";
$this->get_execution_time();
$this->$link = @$connect_function($single_connection['hostname'], $single_connection['username'], $single_connection['password'], 1);
$time_spent = $this->get_execution_time();
$this->query_time += $time_spent;
// Successful connection? break down brother!
if($this->$link)
{
$this->connections[] = "[".strtoupper($type)."] {$single_connection['username']}@{$single_connection['hostname']} (Connected in ".number_format($time_spent, 0)."s)";
break;
}
else
{
$this->connections[] = "<span style=\"color: red\">[FAILED] [".strtoupper($type)."] {$single_connection['username']}@{$single_connection['hostname']}</span>";
}
}
}
// No write server was specified (simple connection or just multiple servers) - mirror write link
if(!array_key_exists('write', $connections))
{
$this->write_link = &$this->read_link;
}
// Have no read connection?
if(!$this->read_link)
{
$this->error("[READ] Unable to connect to MySQL server");
}
// No write?
else if(!$this->write_link)
{
$this->error("[WRITE] Unable to connect to MySQL server");
}
// Select databases
if(!$this->select_db($config['database']))
{
return false;
}
$this->current_link = &$this->read_link;
return $this->read_link;
}
/**
* Selects the database to use.
*
* @param string The database name.
* @return boolean True when successfully connected, false if not.
*/
function select_db($database)
{
global $mybb;
$this->current_link = &$this->read_link;
$read_success = @mysql_select_db($database, $this->read_link) or $this->error("[READ] Unable to select database", $this->read_link);
if($this->write_link)
{
$this->current_link = &$this->write_link;
$write_success = @mysql_select_db($database, $this->write_link) or $this->error("[WRITE] Unable to select database", $this->write_link);
$success = ($read_success && $write_success ? true : false);
}
else
{
$success = $read_success;
}
if($success && $this->db_encoding)
{
$this->query("SET NAMES '{$this->db_encoding}'");
if($write_success && count($this->connections) > 1)
{
$this->write_query("SET NAMES '{$this->db_encoding}'");
}
}
return $success;
}
/**
* Query the database.
*
* @param string The query SQL.
* @param integer 1 if hide errors, 0 if not.
* @param integer 1 if executes on slave database, 0 if not.
* @return resource The query data.
*/
function query($string, $hide_errors=0, $write_query=0)
{
global $pagestarttime, $db, $mybb;
$this->get_execution_time();
// Only execute write queries on slave database
if($write_query && $this->write_link)
{
$this->current_link = &$this->write_link;
$query = @mysql_query($string, $this->write_link);
}
else
{
$this->current_link = &$this->read_link;
$query = @mysql_query($string, $this->read_link);
}
if($this->error_number() && !$hide_errors)
{
$this->error($string);
exit;
}
$query_time = $this->get_execution_time();
$this->query_time += $query_time;
$this->query_count++;
if($mybb->debug_mode)
{
$this->explain_query($string, $query_time);
}
return $query;
}
/**
* Execute a write query on the slave database
*
* @param string The query SQL.
* @param boolean 1 if hide errors, 0 if not.
* @return resource The query data.
*/
function write_query($query, $hide_errors=0)
{
return $this->query($query, $hide_errors, 1);
}
/**
* Explain a query on the database.
*
* @param string The query SQL.
* @param string The time it took to perform the query.
*/
function explain_query($string, $qtime)
{
global $plugins;
if($plugins->current_hook)
{
$debug_extra = "<div style=\"float_right\">(Plugin Hook: {$plugins->current_hook})</div>";
}
if(preg_match("#^\s*select#i", $string))
{
$query = mysql_query("EXPLAIN $string", $this->current_link);
$this->explain .= "<table style=\"background-color: #666;\" width=\"95%\" cellpadding=\"4\" cellspacing=\"1\" align=\"center\">\n".
"<tr>\n".
"<td colspan=\"8\" style=\"background-color: #ccc;\">{$debug_extra}<div><strong>#".$this->query_count." - Select Query</strong></div></td>\n".
"</tr>\n".
"<tr>\n".
"<td colspan=\"8\" style=\"background-color: #fefefe;\"><span style=\"font-family: Courier; font-size: 14px;\">".$string."</span></td>\n".
"</tr>\n".
"<tr style=\"background-color: #efefef;\">\n".
"<td><strong>table</strong></td>\n".
"<td><strong>type</strong></td>\n".
"<td><strong>possible_keys</strong></td>\n".
"<td><strong>key</strong></td>\n".
"<td><strong>key_len</strong></td>\n".
"<td><strong>ref</strong></td>\n".
"<td><strong>rows</strong></td>\n".
"<td><strong>Extra</strong></td>\n".
"</tr>\n";
while($table = mysql_fetch_array($query))
{
$this->explain .=
"<tr bgcolor=\"#ffffff\">\n".
"<td>".$table['table']."</td>\n".
"<td>".$table['type']."</td>\n".
"<td>".$table['possible_keys']."</td>\n".
"<td>".$table['key']."</td>\n".
"<td>".$table['key_len']."</td>\n".
"<td>".$table['ref']."</td>\n".
"<td>".$table['rows']."</td>\n".
"<td>".$table['Extra']."</td>\n".
"</tr>\n";
}
$this->explain .=
"<tr>\n".
"<td colspan=\"8\" style=\"background-color: #fff;\">Query Time: ".$qtime."</td>\n".
"</tr>\n".
"</table>\n".
"<br />\n";
}
else
{
$this->explain .= "<table style=\"background-color: #666;\" width=\"95%\" cellpadding=\"4\" cellspacing=\"1\" align=\"center\">\n".
"<tr>\n".
"<td style=\"background-color: #ccc;\">{$debug_extra}<div><strong>#".$this->query_count." - Write Query</strong></div></td>\n".
"</tr>\n".
"<tr style=\"background-color: #fefefe;\">\n".
"<td><span style=\"font-family: Courier; font-size: 14px;\">".htmlspecialchars_uni($string)."</span></td>\n".
"</tr>\n".
"<tr>\n".
"<td bgcolor=\"#ffffff\">Query Time: ".$qtime."</td>\n".
"</tr>\n".
"</table>\n".
"<br />\n";
}
$this->querylist[$this->query_count]['query'] = $string;
$this->querylist[$this->query_count]['time'] = $qtime;
}
/**
* Return a result array for a query.
*
* @param resource The query ID.
* @param constant The type of array to return.
* @return array The array of results.
*/
function fetch_array($query)
{
$array = mysql_fetch_assoc($query);
return $array;
}
/**
* Return a specific field from a query.
*
* @param resource The query ID.
* @param string The name of the field to return.
* @param int The number of the row to fetch it from.
*/
function fetch_field($query, $field, $row=false)
{
if($row === false)
{
$array = $this->fetch_array($query);
return $array[$field];
}
else
{
return mysql_result($query, $row, $field);
}
}
/**
* Moves internal row pointer to the next row
*
* @param resource The query ID.
* @param int The pointer to move the row to.
*/
function data_seek($query, $row)
{
return mysql_data_seek($query, $row);
}
/**
* Return the number of rows resulting from a query.
*
* @param resource The query ID.
* @return int The number of rows in the result.
*/
function num_rows($query)
{
return mysql_num_rows($query);
}
/**
* Return the last id number of inserted data.
*
* @return int The id number.
*/
function insert_id()
{
return mysql_insert_id($this->current_link);
}
/**
* Close the connection with the DBMS.
*
*/
function close()
{
@mysql_close($this->read_link);
if($this->write_link)
{
@mysql_close($this->write_link);
}
}
/**
* Return an error number.
*
* @return int The error number of the current error.
*/
function error_number()
{
if($this->current_link)
{
return @mysql_errno($this->current_link);
}
else
{
return @mysql_errno();
}
}
/**
* Return an error string.
*
* @return string The explanation for the current error.
*/
function error_string()
{
if($this->current_link)
{
return @mysql_error($this->current_link);
}
else
{
return @mysql_error();
}
}
/**
* Output a database error.
*
* @param string The string to present as an error.
*/
function error($string="")
{
if($this->error_reporting)
{
if(class_exists("errorHandler"))
{
global $error_handler;
if(!is_object($error_handler))
{
require_once MYBB_ROOT."inc/class_error.php";
$error_handler = new errorHandler();
}
$error = array(
"error_no" => $this->error_number(),
"error" => $this->error_string(),
"query" => $string
);
$error_handler->error(MYBB_SQL, $error);
}
else
{
trigger_error("<strong>[SQL] [".$this->error_number()."] ".$this->error_string()."</strong><br />{$string}", E_USER_ERROR);
}
}
else
{
return false;
}
}
/**
* Returns the number of affected rows in a query.
*
* @return int The number of affected rows.
*/
function affected_rows()
{
return mysql_affected_rows($this->current_link);
}
/**
* Return the number of fields.
*
* @param resource The query ID.
* @return int The number of fields.
*/
function num_fields($query)
{
return mysql_num_fields($query);
}
/**
* Lists all functions in the database.
*
* @param string The database name.
* @param string Prefix of the table (optional)
* @return array The table list.
*/
function list_tables($database, $prefix='')
{
if($prefix)
{
$query = $this->query("SHOW TABLES FROM `$database` LIKE '".$this->escape_string($prefix)."%'");
}
else
{
$query = $this->query("SHOW TABLES FROM `$database`");
}
while(list($table) = mysql_fetch_array($query))
{
$tables[] = $table;
}
return $tables;
}
/**
* Check if a table exists in a database.
*
* @param string The table name.
* @return boolean True when exists, false if not.
*/
function table_exists($table)
{
$err = $this->error_reporting;
$this->error_reporting = 0;
// Execute on slave server to ensure if we've just created a table that we get the correct result
$query = $this->write_query("
SHOW TABLES
LIKE '{$this->table_prefix}$table'
");
$exists = $this->num_rows($query);
$this->error_reporting = $err;
if($exists > 0)
{
return true;
}
else
{
return false;
}
}
/**
* Check if a field exists in a database.
*
* @param string The field name.
* @param string The table name.
* @return boolean True when exists, false if not.
*/
function field_exists($field, $table)
{
$err = $this->error_reporting;
$this->error_reporting = 0;
$query = $this->write_query("
SHOW COLUMNS
FROM {$this->table_prefix}$table
LIKE '$field'
");
$exists = $this->num_rows($query);
$this->error_reporting = $err;
if($exists > 0)
{
return true;
}
else
{
return false;
}
}
/**
* Add a shutdown query.
*
* @param resource The query data.
* @param string An optional name for the query.
*/
function shutdown_query($query, $name=0)
{
global $shutdown_queries;
if($name)
{
$shutdown_queries[$name] = $query;
}
else
{
$shutdown_queries[] = $query;
}
}
/**
* Performs a simple select query.
*
* @param string The table name to be queried.
* @param string Comma delimetered list of fields to be selected.
* @param string SQL formatted list of conditions to be matched.
* @param array List of options, order by, order direction, limit, limit start
*/
function simple_select($table, $fields="*", $conditions="", $options=array())
{
$query = "SELECT ".$fields." FROM {$this->table_prefix}{$table}";
if($conditions != "")
{
$query .= " WHERE ".$conditions;
}
if(isset($options['order_by']))
{
$query .= " ORDER BY ".$options['order_by'];
if(isset($options['order_dir']))
{
$query .= " ".my_strtoupper($options['order_dir']);
}
}
if(isset($options['limit_start']) && isset($options['limit']))
{
$query .= " LIMIT ".$options['limit_start'].", ".$options['limit'];
}
elseif(isset($options['limit']))
{
$query .= " LIMIT ".$options['limit'];
}
return $this->query($query);
}
/**
* Build an insert query from an array.
*
* @param string The table name to perform the query on.
* @param array An array of fields and their values.
* @return int The insert ID if available
*/
function insert_query($table, $array)
{
if(!is_array($array))
{
return false;
}
$fields = "`".implode("`,`", array_keys($array))."`";
$values = implode("','", $array);
$this->write_query("
INSERT
INTO {$this->table_prefix}{$table} (".$fields.")
VALUES ('".$values."')
");
return $this->insert_id();
}
/**
* Build one query for multiple inserts from a multidimensional array.
*
* @param string The table name to perform the query on.
* @param array An array of inserts.
* @return int The insert ID if available
*/
function insert_query_multiple($table, $array)
{
if(!is_array($array))
{
return false;
}
// Field names
$fields = array_keys($array[0]);
$fields = "`".implode("`,`", $fields)."`";
$insert_rows = array();
foreach($array as $values)
{
$insert_rows[] = "('".implode("','", $values)."')";
}
$insert_rows = implode(", ", $insert_rows);
$this->write_query("
INSERT
INTO {$this->table_prefix}{$table} ({$fields})
VALUES {$insert_rows}
");
}
/**
* Build an update query from an array.
*
* @param string The table name to perform the query on.
* @param array An array of fields and their values.
* @param string An optional where clause for the query.
* @param string An optional limit clause for the query.
* @return resource The query data.
*/
function update_query($table, $array, $where="", $limit="", $no_quote=false)
{
if(!is_array($array))
{
return false;
}
$comma = "";
$query = "";
$quote = "'";
if($no_quote == true)
{
$quote = "";
}
foreach($array as $field => $value)
{
$query .= $comma."`".$field."`={$quote}{$value}{$quote}";
$comma = ", ";
}
if(!empty($where))
{
$query .= " WHERE $where";
}
if(!empty($limit))
{
$query .= " LIMIT $limit";
}
return $this->write_query("
UPDATE {$this->table_prefix}$table
SET $query
");
}
/**
* Build a delete query.
*
* @param string The table name to perform the query on.
* @param string An optional where clause for the query.
* @param string An optional limit clause for the query.
* @return resource The query data.
*/
function delete_query($table, $where="", $limit="")
{
$query = "";
if(!empty($where))
{
$query .= " WHERE $where";
}
if(!empty($limit))
{
$query .= " LIMIT $limit";
}
return $this->write_query("
DELETE
FROM {$this->table_prefix}$table
$query
");
}
/**
* Escape a string according to the MySQL escape format.
*
* @param string The string to be escaped.
* @return string The escaped string.
*/
function escape_string($string)
{
if(function_exists("mysql_real_escape_string") && $this->read_link)
{
$string = mysql_real_escape_string($string, $this->read_link);
}
else
{
$string = addslashes($string);
}
return $string;
}
/**
* Frees the resources of a MySQLi query.
*
* @param object The query to destroy.
* @return boolean Returns true on success, false on faliure
*/
function free_result($query)
{
return mysql_free_result($query);
}
/**
* Escape a string used within a like command.
*
* @param string The string to be escaped.
* @return string The escaped string.
*/
function escape_string_like($string)
{
return $this->escape_string(str_replace(array('%', '_') , array('\\%' , '\\_') , $string));
}
/**
* Gets the current version of MySQL.
*
* @return string Version of MySQL.
*/
function get_version()
{
if($this->version)
{
return $this->version;
}
$query = $this->query("SELECT VERSION() as version");
$ver = $this->fetch_array($query);
if($ver['version'])
{
$version = explode(".", $ver['version'], 3);
$this->version = intval($version[0]).".".intval($version[1]).".".intval($version[2]);
}
return $this->version;
}
/**
* Optimizes a specific table.
*
* @param string The name of the table to be optimized.
*/
function optimize_table($table)
{
$this->write_query("OPTIMIZE TABLE {$this->table_prefix}{$table}");
}
/**
* Analyzes a specific table.
*
* @param string The name of the table to be analyzed.
*/
function analyze_table($table)
{
$this->write_query("ANALYZE TABLE {$this->table_prefix}{$table}");
}
/**
* Show the "create table" command for a specific table.
*
* @param string The name of the table.
* @return string The MySQL command to create the specified table.
*/
function show_create_table($table)
{
$query = $this->write_query("SHOW CREATE TABLE {$this->table_prefix}{$table}");
$structure = $this->fetch_array($query);
return $structure['Create Table'];
}
/**
* Show the "show fields from" command for a specific table.
*
* @param string The name of the table.
* @return string Field info for that table
*/
function show_fields_from($table)
{
$query = $this->write_query("SHOW FIELDS FROM {$this->table_prefix}{$table}");
while($field = $this->fetch_array($query))
{
$field_info[] = $field;
}
return $field_info;
}
/**
* Returns whether or not the table contains a fulltext index.
*
* @param string The name of the table.
* @param string Optionally specify the name of the index.
* @return boolean True or false if the table has a fulltext index or not.
*/
function is_fulltext($table, $index="")
{
$structure = $this->show_create_table($table);
if($index != "")
{
if(preg_match("#FULLTEXT KEY (`?)$index(`?)#i", $structure))
{
return true;
}
else
{
return false;
}
}
if(preg_match('#FULLTEXT KEY#i', $structure))
{
return true;
}
return false;
}
/**
* Returns whether or not this database engine supports fulltext indexing.
*
* @param string The table to be checked.
* @return boolean True or false if supported or not.
*/
function supports_fulltext($table)
{
$version = $this->get_version();
$query = $this->write_query("SHOW TABLE STATUS LIKE '{$this->table_prefix}$table'");
$status = $this->fetch_array($query);
if($status['Engine'])
{
$table_type = my_strtoupper($status['Engine']);
}
else
{
$table_type = my_strtoupper($status['Type']);
}
if($version >= '3.23.23' && $table_type == 'MYISAM')
{
return true;
}
return false;
}
/**
* Returns whether or not this database engine supports boolean fulltext matching.
*
* @param string The table to be checked.
* @return boolean True or false if supported or not.
*/
function supports_fulltext_boolean($table)
{
$version = $this->get_version();
$supports_fulltext = $this->supports_fulltext($table);
if($version >= '4.0.1' && $supports_fulltext == true)
{
return true;
}
return false;
}
/**
* Creates a fulltext index on the specified column in the specified table with optional index name.
*
* @param string The name of the table.
* @param string Name of the column to be indexed.
* @param string The index name, optional.
*/
function create_fulltext_index($table, $column, $name="")
{
$this->write_query("
ALTER TABLE {$this->table_prefix}$table
ADD FULLTEXT $name ($column)
");
}
/**
* Drop an index with the specified name from the specified table
*
* @param string The name of the table.
* @param string The name of the index.
*/
function drop_index($table, $name)
{
$this->write_query("
ALTER TABLE {$this->table_prefix}$table
DROP INDEX $name
");
}
/**
* Checks to see if an index exists on a specified table
*
* @param string The name of the table.
* @param string The name of the index.
*/
function index_exists($table, $index)
{
$index_exists = false;
$query = $this->write_query("SHOW INDEX FROM {$this->table_prefix}{$table}");
while($ukey = $this->fetch_array($query))
{
if($ukey['Key_name'] == $index)
{
$index_exists = true;
break;
}
}
if($index_exists)
{
return true;
}
return false;
}
/**
* Drop an table with the specified table
*
* @param boolean hard drop - no checking
* @param boolean use table prefix
*/
function drop_table($table, $hard=false, $table_prefix=true)
{
if($table_prefix == false)
{
$table_prefix = "";
}
else
{
$table_prefix = $this->table_prefix;
}
if($hard == false)
{
$this->write_query('DROP TABLE IF EXISTS '.$table_prefix.$table);
}
else
{
$this->write_query('DROP TABLE '.$table_prefix.$table);
}
}
/**
* Replace contents of table with values
*
* @param string The table
* @param array The replacements
*/
function replace_query($table, $replacements=array())
{
$values = '';
$comma = '';
foreach($replacements as $column => $value)
{
$values .= $comma."`".$column."`='".$value."'";
$comma = ',';
}
if(empty($replacements))
{
return false;
}
return $this->write_query("REPLACE INTO {$this->table_prefix}{$table} SET {$values}");
}
/**
* Sets the table prefix used by the simple select, insert, update and delete functions
*
* @param string The new table prefix
*/
function set_table_prefix($prefix)
{
$this->table_prefix = $prefix;
}
/**
* Fetched the total size of all mysql tables or a specific table
*
* @param string The table (optional)
* @return integer the total size of all mysql tables or a specific table
*/
function fetch_size($table='')
{
if($table != '')
{
$query = $this->query("SHOW TABLE STATUS LIKE '".$this->table_prefix.$table."'");
}
else
{
$query = $this->query("SHOW TABLE STATUS");
}
$total = 0;
while($table = $this->fetch_array($query))
{
$total += $table['Data_length']+$table['Index_length'];
}
return $total;
}
/**
* Fetch a list of database character sets this DBMS supports
*
* @return array Array of supported character sets with array key being the name, array value being display name. False if unsupported
*/
function fetch_db_charsets()
{
if($this->link && version_compare($this->get_version(), "4.1", "<"))
{
return false;
}
return array(
'big5' => 'Big5 Traditional Chinese',
'dec8' => 'DEC West European',
'cp850' => 'DOS West European',
'hp8' => 'HP West European',
'koi8r' => 'KOI8-R Relcom Russian',
'latin1' => 'cp1252 West European',
'latin2' => 'ISO 8859-2 Central European',
'swe7' => '7bit Swedish',
'ascii' => 'US ASCII',
'ujis' => 'EUC-JP Japanese',
'sjis' => 'Shift-JIS Japanese',
'hebrew' => 'ISO 8859-8 Hebrew',
'tis620' => 'TIS620 Thai',
'euckr' => 'EUC-KR Korean',
'koi8u' => 'KOI8-U Ukrainian',
'gb2312' => 'GB2312 Simplified Chinese',
'greek' => 'ISO 8859-7 Greek',
'cp1250' => 'Windows Central European',
'gbk' => 'GBK Simplified Chinese',
'latin5' => 'ISO 8859-9 Turkish',
'armscii8' => 'ARMSCII-8 Armenian',
'utf8' => 'UTF-8 Unicode',
'ucs2' => 'UCS-2 Unicode',
'cp866' => 'DOS Russian',
'keybcs2' => 'DOS Kamenicky Czech-Slovak',
'macce' => 'Mac Central European',
'macroman' => 'Mac West European',
'cp852' => 'DOS Central European',
'latin7' => 'ISO 8859-13 Baltic',
'cp1251' => 'Windows Cyrillic',
'cp1256' => 'Windows Arabic',
'cp1257' => 'Windows Baltic',
'binary' => 'Binary pseudo charset',
'geostd8' => 'GEOSTD8 Georgian',
'cp932' => 'SJIS for Windows Japanese',
'eucjpms' => 'UJIS for Windows Japanese',
);
}
/**
* Fetch a database collation for a particular database character set
*
* @param string The database character set
* @return string The matching database collation, false if unsupported
*/
function fetch_charset_collation($charset)
{
$collations = array(
'big5' => 'big5_chinese_ci',
'dec8' => 'dec8_swedish_ci',
'cp850' => 'cp850_general_ci',
'hp8' => 'hp8_english_ci',
'koi8r' => 'koi8r_general_ci',
'latin1' => 'latin1_swedish_ci',
'latin2' => 'latin2_general_ci',
'swe7' => 'swe7_swedish_ci',
'ascii' => 'ascii_general_ci',
'ujis' => 'ujis_japanese_ci',
'sjis' => 'sjis_japanese_ci',
'hebrew' => 'hebrew_general_ci',
'tis620' => 'tis620_thai_ci',
'euckr' => 'euckr_korean_ci',
'koi8u' => 'koi8u_general_ci',
'gb2312' => 'gb2312_chinese_ci',
'greek' => 'greek_general_ci',
'cp1250' => 'cp1250_general_ci',
'gbk' => 'gbk_chinese_ci',
'latin5' => 'latin5_turkish_ci',
'armscii8' => 'armscii8_general_ci',
'utf8' => 'utf8_general_ci',
'ucs2' => 'ucs2_general_ci',
'cp866' => 'cp866_general_ci',
'keybcs2' => 'keybcs2_general_ci',
'macce' => 'macce_general_ci',
'macroman' => 'macroman_general_ci',
'cp852' => 'cp852_general_ci',
'latin7' => 'latin7_general_ci',
'cp1251' => 'cp1251_general_ci',
'cp1256' => 'cp1256_general_ci',
'cp1257' => 'cp1257_general_ci',
'binary' => 'binary',
'geostd8' => 'geostd8_general_ci',
'cp932' => 'cp932_japanese_ci',
'eucjpms' => 'eucjpms_japanese_ci',
);
if($collations[$charset])
{
return $collations[$charset];
}
return false;
}
/**
* Fetch a character set/collation string for use with CREATE TABLE statements. Uses current DB encoding
*
* @return string The built string, empty if unsupported
*/
function build_create_table_collation()
{
if(!$this->db_encoding)
{
return '';
}
$collation = $this->fetch_charset_collation($this->db_encoding);
if(!$collation)
{
return '';
}
return " CHARACTER SET {$this->db_encoding} COLLATE {$collation}";
}
/**
* Time how long it takes for a particular piece of code to run. Place calls above & below the block of code.
*
* @return float The time taken
*/
function get_execution_time()
{
static $time_start;
$time = strtok(microtime(), ' ') + strtok('');
// Just starting timer, init and return
if(!$time_start)
{
$time_start = $time;
return;
}
// Timer has run, return execution time
else
{
$total = $time-$time_start;
$time_start = 0;
if($total < 0) $total = 0;
return $total;
}
}
}
?>

Alles anzeigen

das is nu die .php wo er agt fehler aber wo ich nix definieren kann allein mit mein paar php kenntnissen :(
komme da irgend wie nicht weiter

Valron · 2. August 2009, 22:52

[COLOR="Cyan"]Hm, das ist dann die Falsche Datei. :o

Irgendwo muss eine Datei liegen, die genau
config.php
ODER
config.inc
heist.

Diese Datei sieht bei MyBB normalerweise so aus:

PHP-Quellcode

<?php
/* Datenbankkonfiguration */
$config['database']['type'] = "mysql";
$config['database']['database'] = "database-name";
$config['database']['table_prefix'] = "mybb_";
$config['database']['hostname'] = "localhost";
$config['database']['username'] = "mysql-username";
$config['database']['password'] = "mysql-password";
/* Admin-CP URL / Ordnername des Admin-CPs */
$config['admindir'] = "admin";
/* Links zum Admin-CP zeigen? */
$config['hide_admin_links'] = 0;
/* Cache-Konfiguration */
/* files = Speichert Cache im Ordner /inc/cache/ (muss beschreibbar sein!) */
/* db = Speichert Cache in der Datenbank */
$config['cachestore'] = "db";
/* Memcache-Konfiguration */
/* Nur wichtig, wenn Memcache eingesetzt wird */
$config['memcache_host'] = 'localhost';
$config['memcache_port'] = 11211;
/* Super-Administratoren; mehere IDs durch Kommas trennen */
$config['super_admins'] = '1';
/* Datenbank-Kodierung */
$config['database']['encoding'] = 'utf8';
/* Automatische Logbereinigung */
$config['log_pruning'] = array(
'admin_logs' => 365, // Administrator logs
'mod_logs' => 0, // Moderator logs
'task_logs' => 30, // Scheduled task logs
'mail_logs' => 180, // Mail error logs
'user_mail_logs' => 180, // User mail logs
'promotion_logs' => 180 // Promotion logs
);
?>

Alles anzeigen

Die musst du finden und editieren, die muss irgendwo da liegen.

mfg
Valron[/COLOR]

proflyffers · 2. August 2009, 22:54

diese datei habe ich schon bearbeitet und alles um geändert aber geht trotz dem nicht siehst ja den fehler den er mir zeigt :( verstehe das alles nicht mehr :(

Valron · 2. August 2009, 22:55

[COLOR="Cyan"]Bist du sicher das der Username "Hammel_" ist?
Mit dem unterstrich? oO

Schau dir die Config noch einmal GENAU an, da stimmt 100%
irgendwas nicht.

mfg
Valron[/COLOR]

proflyffers · 2. August 2009, 23:00

ja hab den _ weg gemacht aber trotzdem geht es nicht:(

Valron · 2. August 2009, 23:03

[COLOR="Cyan"]Omg, Omg.
Du bist ein Problemkind :XD::XD::XD:

Sind deine Rootdaten noch die alten?
Wenn nicht schick sie mir per PM ich mach das
selber.
Wenn ich fertig bin, änderst es dann wieder bitte.^^

mfg
Valron[/COLOR]

proflyffers · 2. August 2009, 23:11

ja ich weiß und du bist der problem lösende papa^^

Valron · 2. August 2009, 23:25

[COLOR="Cyan"]So, alle Probleme gelöst. ;)

Wünsche dir noch viel Glück. :P

mfg
Valron[/COLOR]

PHP-Quellcode

Quellcode

PHP-Quellcode

Teilen