Exemple #1
0
 /**
  * Gets the tracking status of a table, is it active or deactive ?
  *
  * @param string $dbname    name of database
  * @param string $tablename name of table
  *
  * @static
  *
  * @return boolean true or false
  */
 public static function isTracked($dbname, $tablename)
 {
     if (!self::$enabled) {
         return false;
     }
     /* We need to avoid attempt to track any queries
      * from PMA_getRelationsParam
      */
     self::$enabled = false;
     $cfgRelation = PMA_getRelationsParam();
     /* Restore original state */
     self::$enabled = true;
     if (!$cfgRelation['trackingwork']) {
         return false;
     }
     $sql_query = " SELECT tracking_active FROM " . self::_getTrackingTable() . " WHERE db_name = '" . PMA_Util::sqlAddSlashes($dbname) . "' " . " AND table_name = '" . PMA_Util::sqlAddSlashes($tablename) . "' " . " ORDER BY version DESC";
     $row = $GLOBALS['dbi']->fetchArray(PMA_queryAsControlUser($sql_query));
     if (isset($row['tracking_active']) && $row['tracking_active'] == 1) {
         return true;
     } else {
         return false;
     }
 }
Exemple #2
0
    /**
     * Gets the tracking status of a table, is it active or deactive ?
     *
     * @param string $dbname    name of database
     * @param string $tablename name of table
     *
     * @static
     *
     * @return boolean true or false
     */
    static public function isTracked($dbname, $tablename)
    {
        if (! self::$enabled) {
            return false;
        }
        /* We need to avoid attempt to track any queries from PMA_getRelationsParam */
        self::$enabled = false;
        $cfgRelation = PMA_getRelationsParam();
        /* Restore original state */
        self::$enabled = true;
        if (! $cfgRelation['trackingwork']) {
            return false;
        }

        $sql_query = " SELECT tracking_active FROM " . self::$pma_table .
        " WHERE db_name = '" . PMA_sqlAddSlashes($dbname) . "' " .
        " AND table_name = '" . PMA_sqlAddSlashes($tablename) . "' " .
        " ORDER BY version DESC";

        $row = PMA_DBI_fetch_array(PMA_query_as_controluser($sql_query));

        if (isset($row['tracking_active']) && $row['tracking_active'] == 1) {
            return true;
        } else {
            return false;
        }
    }