0.2.1/inc/libs/mediadata_functions.php

   1 <?php\r
   2 /************************************************************************\r
   3  * MXChange v0.2.1                                    Start: 10/08/2005 *\r
   4  * ===============                              Last change: 10/08/2005 *\r
   5  *                                                                      *\r
   6  * -------------------------------------------------------------------- *\r
   7  * File              : mediadata_functions.php                          *\r
   8  * -------------------------------------------------------------------- *\r
   9  * Short description : Functions for the mediadata extension            *\r
  10  * -------------------------------------------------------------------- *\r
  11  * Kurzbeschreibung  : Funktionen fuer die verbesserten Mediendaten     *\r
  12  * -------------------------------------------------------------------- *\r
  13  *                                                                      *\r
  14  * -------------------------------------------------------------------- *\r
  15  * Copyright (c) 2003 - 2008 by Roland Haeder                           *\r
  16  * For more information visit: http://www.mxchange.org                  *\r
  17  *                                                                      *\r
  18  * This program is free software; you can redistribute it and/or modify *\r
  19  * it under the terms of the GNU General Public License as published by *\r
  20  * the Free Software Foundation; either version 2 of the License, or    *\r
  21  * (at your option) any later version.                                  *\r
  22  *                                                                      *\r
  23  * This program is distributed in the hope that it will be useful,      *\r
  24  * but WITHOUT ANY WARRANTY; without even the implied warranty of       *\r
  25  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the        *\r
  26  * GNU General Public License for more details.                         *\r
  27  *                                                                      *\r
  28  * You should have received a copy of the GNU General Public License    *\r
  29  * along with this program; if not, write to the Free Software          *\r
  30  * Foundation, Inc., 51 Franklin St, Fifth Floor, Boston,               *\r
  31  * MA  02110-1301  USA                                                  *\r
  32  ************************************************************************/\r
  33 \r
  34 // Some security stuff...\r
  35 if (ereg(basename(__FILE__), $_SERVER['PHP_SELF']))\r
  36 {\r
  37         $INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), "/inc") + 4)."/security.php";\r
  38         require($INC);\r
  39 }\r
  40 //\r
  41 function MEDIA_UPDATE_ENTRY($keys_array, $mode, $value)\r
  42 {\r
  43         if (is_array($keys_array) && ($value > 0))\r
  44         {\r
  45                 // Is an array so we can run it through\r
  46                 foreach ($keys_array as $key)\r
  47                 {\r
  48                         // First check if it does exist\r
  49                         $result_media = SQL_QUERY_ESC("SELECT media_key FROM "._MYSQL_PREFIX."_mediadata\r
  50 WHERE media_key = '%s' LIMIT 1", array($key), __FILE__, __LINE__);\r
  51                         if (SQL_NUMROWS($result_media) == 0)\r
  52                         {\r
  53                                 // Not found so we create it (mode will be ignored here!)\r
  54                                 $result_insert = SQL_QUERY_ESC("INSERT INTO "._MYSQL_PREFIX."_mediadata (media_key, media_value)\r
  55 VALUES ('%s', '%s')", array($key, $value), __FILE__, __LINE__);\r
  56                         }\r
  57                          else\r
  58                         {\r
  59                                 // Update entry\r
  60                                 switch ($mode)\r
  61                                 {\r
  62                                         case "add": $mode = "+"; break;\r
  63                                         case "sub": $mode = "-"; break;\r
  64                                 }\r
  65                                 if ($mode == "init")\r
  66                                 {\r
  67                                         // Initialize entry\r
  68                                         $result_update = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_mediadata SET media_value=%s WHERE media_key='%s' LIMIT 1",\r
  69                                          array($value, $key), __FILE__, __LINE__);\r
  70                                 }\r
  71                                  else\r
  72                                 {\r
  73                                         // Update entry\r
  74                                         $result_update = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_mediadata SET media_value=media_value".$mode."%s WHERE media_key='%s' LIMIT 1",\r
  75                                          array($value, $key), __FILE__, __LINE__);\r
  76                                 }\r
  77                         }\r
  78                 }\r
  79         }\r
  80 }\r
  81 //\r
  82 function MEDIA_GET_ENTRY($key)\r
  83 {\r
  84         // Return nothing by default\r
  85         $value = "";\r
  86 \r
  87         // Check for entry\r
  88         $result = SQL_QUERY_ESC("SELECT media_value FROM "._MYSQL_PREFIX."_mediadata WHERE media_key='%s' LIMIT 1",\r
  89          array($key), __FILE__, __LINE__);\r
  90         if (SQL_NUMROWS($result) == 1)\r
  91         {\r
  92                 // Load data\r
  93                 list($value) = SQL_FETCHROW($result);\r
  94         }\r
  95 \r
  96         // Return data\r
  97         return $value;\r
  98 }\r
  99 //\r
 100 ?>\r