Jump to content
php.lv forumi

Kapēc phpBB bremzē datubāzi no php kodējuma?

Settlers

By Settlers
in PHP un datubāzes

 Share

Recommended Posts

bubu Newbie

bubu

Posted
Posted

Kā var datubāze uzkārt citas datubāzes, tu man pasaki! Reāli MySQL datubāze ir failu čupiņa vienā direktorijā. Ko tad tie faili dara? Dzēš citus failus? Drīzāk tu kautko tur ar konekcijas parametriem esi nepareizi sadarījis/nokonfigurējis.

Link to comment
Share on other sites
Settlers Newbie

Settlers

Posted
  • Author
Posted
Kā var datubāze uzkārt citas datubāzes, tu man pasaki! Reāli MySQL datubāze ir failu čupiņa vienā direktorijā. Ko tad tie faili dara? Dzēš citus failus? Drīzāk tu kautko tur ar konekcijas parametriem esi nepareizi sadarījis/nokonfigurējis.

15645[/snapback]

 

 

nee kad maneejo saitam atrubii to mysql tad paareejie iet oki doki un nekas nekaraas

Link to comment
Share on other sites
Kavacky Newbie

Kavacky

Posted
Posted
esp iemeeram  mysql_pconnect paarveidoju par mysql_connect  vizmaz teica galvenais bet taapat bremzee paareejos :( kaads zin labi php un MySQL ?
Kā "Da Boss" teica, tā ir.

 

PS: Te ir savākusies saujiņa dīvainu ļaužu, kuri brīvajā laikā cep kūkas no mālainām smiltīm, kas apslacītas ar 76. benzīnu, taču pamatā darbojas ar caurumu gatavošanu sierā. php.lv nosaukumā ir iekļauts maskēšanās nolūkos, lai šo komūnu neatrastu ļaunie citplanētu iebrucēji qwertyfaksi.

Link to comment
Share on other sites
Settlers Newbie

Settlers

Posted
  • Author
Posted
Kā "Da Boss" teica, tā ir.

 

PS: Te ir savākusies saujiņa dīvainu ļaužu, kuri brīvajā laikā cep kūkas no mālainām smiltīm, kas apslacītas ar 76. benzīnu, taču pamatā darbojas ar caurumu gatavošanu sierā. php.lv nosaukumā ir iekļauts maskēšanās nolūkos, lai šo komūnu neatrastu ļaunie citplanētu iebrucēji qwertyfaksi.

15649[/snapback]

 

jaa bet kur tad vareetu buut kljuuda ?

 

<?php
/***************************************************************************
*                                 mysql4.php
*                            -------------------
*   begin                : Saturday, Feb 13, 2001
*   copyright            : (C) 2001 The phpBB Group
*   email                : supportphpbb.com
*
*   $Id: mysql4.php,v 1.5 2002/04/02 21:13:47 the_systech Exp $
*
***************************************************************************/

/***************************************************************************
*
*   This program is free software; you can redistribute it and/or modify
*   it under the terms of the GNU General Public License as published by
*   the Free Software Foundation; either version 2 of the License, or
*   (at your option) any later version.
*
***************************************************************************/

if(!defined("SQL_LAYER"))
{

define("SQL_LAYER","mysql4");

class sql_db
{

var $db_connect_id;
var $query_result;
var $row = array();
var $rowset = array();
var $num_queries = 0;
var $in_transaction = 0;

//
// Constructor
//
function sql_db($sqlserver, $sqluser, $sqlpassword, $database, $persistency = true)
{
 $this->persistency = $persistency;
 $this->user = $sqluser;
 $this->password = $sqlpassword;
 $this->server = $sqlserver;
 $this->dbname = $database;

 $this->db_connect_id = ($this->persistency) ? mysql_connect($this->server, $this->user, $this->password) : mysql_connect($this->server, $this->user, $this->password);

 if( $this->db_connect_id )
 {
	 if( $database != "" )
	 {
   $this->dbname = $database;
   $dbselect = mysql_select_db($this->dbname);

   if( !$dbselect )
   {
  	 mysql_close($this->db_connect_id);
  	 $this->db_connect_id = $dbselect;
   }
	 }

	 return $this->db_connect_id;
 }
 else
 {
	 return false;
 }
}

//
// Other base methods
//
function sql_close()
{
 if( $this->db_connect_id )
 {
	 //
	 // Commit any remaining transactions
	 //
	 if( $this->in_transaction )
	 {
   mysql_query("COMMIT", $this->db_connect_id);
	 }

	 return mysql_close($this->db_connect_id);
 }
 else
 {
	 return false;
 }
}

//
// Base query method
//
function sql_query($query = "", $transaction = FALSE)
{
 //
 // Remove any pre-existing queries
 //
 unset($this->query_result);

 if( $query != "" )
 {
	 $this->num_queries++;
	 if( $transaction == BEGIN_TRANSACTION && !$this->in_transaction )
	 {
   $result = mysql_query("BEGIN", $this->db_connect_id);
   if(!$result)
   {
  	 return false;
   }
   $this->in_transaction = TRUE;
	 }

	 $this->query_result = mysql_query($query, $this->db_connect_id);
 }
 else
 {
	 if( $transaction == END_TRANSACTION && $this->in_transaction )
	 {
   $result = mysql_query("COMMIT", $this->db_connect_id);
	 }
 }

 if( $this->query_result )
 {
	 unset($this->row[$this->query_result]);
	 unset($this->rowset[$this->query_result]);

	 if( $transaction == END_TRANSACTION && $this->in_transaction )
	 {
   $this->in_transaction = FALSE;

   if ( !mysql_query("COMMIT", $this->db_connect_id) )
   {
  	 mysql_query("ROLLBACK", $this->db_connect_id);
  	 return false;
   }
	 }
	 
	 return $this->query_result;
 }
 else
 {
	 if( $this->in_transaction )
	 {
   mysql_query("ROLLBACK", $this->db_connect_id);
   $this->in_transaction = FALSE;
	 }
	 return false;
 }
}

//
// Other query methods
//
function sql_numrows($query_id = 0)
{
 if( !$query_id )
 {
	 $query_id = $this->query_result;
 }

 return ( $query_id ) ? mysql_num_rows($query_id) : false;
}

function sql_affectedrows()
{
 return ( $this->db_connect_id ) ? mysql_affected_rows($this->db_connect_id) : false;
}

function sql_numfields($query_id = 0)
{
 if( !$query_id )
 {
	 $query_id = $this->query_result;
 }

 return ( $query_id ) ? mysql_num_fields($query_id) : false;
}

function sql_fieldname($offset, $query_id = 0)
{
 if( !$query_id )
 {
	 $query_id = $this->query_result;
 }

 return ( $query_id ) ? mysql_field_name($query_id, $offset) : false;
}

function sql_fieldtype($offset, $query_id = 0)
{
 if( !$query_id )
 {
	 $query_id = $this->query_result;
 }

 return ( $query_id ) ? mysql_field_type($query_id, $offset) : false;
}

function sql_fetchrow($query_id = 0)
{
 if( !$query_id )
 {
	 $query_id = $this->query_result;
 }

 if( $query_id )
 {
	 $this->row[$query_id] = mysql_fetch_array($query_id, MYSQL_ASSOC);
	 return $this->row[$query_id];
 }
 else
 {
	 return false;
 }
}

function sql_fetchrowset($query_id = 0)
{
 if( !$query_id )
 {
	 $query_id = $this->query_result;
 }

 if( $query_id )
 {
	 unset($this->rowset[$query_id]);
	 unset($this->row[$query_id]);

	 while($this->rowset[$query_id] = mysql_fetch_array($query_id, MYSQL_ASSOC))
	 {
   $result[] = $this->rowset[$query_id];
	 }

	 return $result;
 }
 else
 {
	 return false;
 }
}

function sql_fetchfield($field, $rownum = -1, $query_id = 0)
{
 if( !$query_id )
 {
	 $query_id = $this->query_result;
 }

 if( $query_id )
 {
	 if( $rownum > -1 )
	 {
   $result = mysql_result($query_id, $rownum, $field);
	 }
	 else
	 {
   if( empty($this->row[$query_id]) && empty($this->rowset[$query_id]) )
   {
  	 if( $this->sql_fetchrow() )
  	 {
     $result = $this->row[$query_id][$field];
  	 }
   }
   else
   {
  	 if( $this->rowset[$query_id] )
  	 {
     $result = $this->rowset[$query_id][$field];
  	 }
  	 else if( $this->row[$query_id] )
  	 {
     $result = $this->row[$query_id][$field];
  	 }
   }
	 }

	 return $result;
 }
 else
 {
	 return false;
 }
}

function sql_rowseek($rownum, $query_id = 0)
{
 if( !$query_id )
 {
	 $query_id = $this->query_result;
 }

 return ( $query_id ) ? mysql_data_seek($query_id, $rownum) : false;
}

function sql_nextid()
{
 return ( $this->db_connect_id ) ? mysql_insert_id($this->db_connect_id) : false;
}

function sql_freeresult($query_id = 0)
{
 if( !$query_id )
 {
	 $query_id = $this->query_result;
 }

 if ( $query_id )
 {
	 unset($this->row[$query_id]);
	 unset($this->rowset[$query_id]);

	 mysql_free_result($query_id);

	 return true;
 }
 else
 {
	 return false;
 }
}

function sql_error()
{
 $result['message'] = mysql_error($this->db_connect_id);
 $result['code'] = mysql_errno($this->db_connect_id);

 return $result;
}

} // class sql_db

} // if ... define

?>

Link to comment
Share on other sites
Kristabs Newbie

Kristabs

Posted
Posted

eeem...

1)http://www.google.lv/search?hl=lv&q=phpBB+forum&btnG=Google+mekl%C4%93%C5%A1ana&meta=

2)esmu dzirdeejis par shaadaam probleemaam tikai nezinu vai taa ir query vaina vai php. hack.nite.lv/f arii probleema, ka nospiezhot add post gaidi kameer izpildaas tas viss kaadu minuuti

kopsavilkums - palasi phpBB forumus par sho savu sasaapeejushos jautaajumu, mejbii tas kaads bags un ir patchi prieksh fix`a

P.S. esmu nekompetents shajaa jautaajumaa, tikai meegjinu paliidzeet ar noraadeem

Link to comment
Share on other sites
hmnc Newbie

hmnc

Posted
Posted

nu bāc.

neba phpBB izstrādātāji taisīja to forumu speciāli, lai tas bremzētu.

Cik esmu licis - strādā visnotaļ ātri. nekad nav bijušas problēmas ar datubāzes noslodzi.

 

paņem un lejuplādē jaunāko phpBB versiju un dzīvo laimīgs.

 

vai varbūt tavs hosteris hostējas uz p1-133/32mbRAM kastes ar 666 klientiem? B)

Link to comment
Share on other sites
Settlers Newbie

Settlers

Posted
  • Author
Posted
eeem...

1)http://www.google.lv/search?hl=lv&q=phpBB+forum&btnG=Google+mekl%C4%93%C5%A1ana&meta=

2)esmu dzirdeejis par shaadaam probleemaam tikai nezinu vai taa ir query vaina vai php. hack.nite.lv/f arii probleema, ka nospiezhot add post gaidi kameer izpildaas tas viss kaadu minuuti

kopsavilkums - palasi phpBB forumus par sho savu sasaapeejushos jautaajumu, mejbii tas kaads bags un ir patchi prieksh fix`a

P.S. esmu nekompetents shajaa jautaajumaa, tikai meegjinu paliidzeet ar noraadeem

15653[/snapback]

 

tieshi taa bet es nez kur tals laags

Link to comment
Share on other sites
 Share
Go to topic listing
×
×
  • Create New...