[Phplib-trackers] [ phplib-Bugs-473196 ] ac_get_lock() and MySQL

[<no...@so...>]

Bugs item #473196, was opened at 2001-10-20 10:25
You can respond by visiting: 
http://sourceforge.net/tracker/?func=detail&atid=403611&aid=473196&group_id=31885

Category: None
Group: None
Status: Open
Resolution: None
Priority: 5
Submitted By: Andreas Stein (steinas)
Assigned to: Nobody/Anonymous (nobody)
Summary: ac_get_lock() and MySQL

Initial Comment:
file: ct_sql.inc
object: ct_sql
method: ac_get_lock()

  function ac_get_lock() {
    if ( "" != $this->database_lock_semaphore ) {
      $query = sprintf("SELECT get_lock('%s')", $this-
>database_lock_semaphore);
      while ( ! $this->db->query($query)) {
        $t = 1 + time(); while ( $t > time() ) { ; }
      }
    }
  }

for MySQL the SQL statement should be:

"SELECT GET_LOCK(str, time_out)" or
"SELECT GET_LOCK(str, 0)"

$db->query($query) is always true even if lock state 
is false

----------------------------------------------------------------------

You can respond by visiting: 
http://sourceforge.net/tracker/?func=detail&atid=403611&aid=473196&group_id=31885