[Summary view] [Print] [Text view]

   1  <?php
   2  
   3  if(!function_exists('fmod')) { 
   4     function fmod($x,$y) { 
   5        $i = floor($x/$y); 
   6        return $x - $i * $y; 
   7     } 
   8  }
   9  
  10  function gt2array ($db)
  11  {
  12      // Die Werte werden mehrmals gespeichert, damit man sie sowohl über die ID als auch über den
  13      // Namen / Kurznamen ansprechen kann
  14  
  15      $array = array();
  16      
  17      // Fonts information
  18      $query = "SELECT * FROM ".DB_PREPEND."phpwcms_fonts ORDER BY font_name";
  19      $result = mysql_query($query, $db) or die ("Error in query:$query");
  20      
  21      while ($row = mysql_fetch_assoc($result))
  22      {
  23          $font_shortname = "\"".$row["font_shortname"]."\"";
  24          $array["fonts_name"][$font_shortname]["id"] = $row["font_id"];
  25          $array["fonts_name"][$font_shortname]["name"] = $row["font_name"];
  26          $array["fonts_name"][$font_shortname]["shortname"] = $row["font_shortname"];
  27          $array["fonts_name"][$font_shortname]["filename"] = $row["font_filename"];
  28          
  29          $array["fonts_id"][$row["font_id"]]["id"] = $row["font_id"];
  30          $array["fonts_id"][$row["font_id"]]["name"] = $row["font_name"];
  31          $array["fonts_id"][$row["font_id"]]["shortname"] = $row["font_shortname"];
  32          $array["fonts_id"][$row["font_id"]]["filename"] = $row["font_filename"];
  33      }
  34  
  35      // Colors information
  36      $query = "SELECT * FROM ".DB_PREPEND."phpwcms_fonts_colors ORDER BY color_name";
  37      $result = mysql_query($query, $db) or die ("Error in query:$query");
  38      
  39      while ($row = mysql_fetch_assoc($result))
  40      {
  41          $colorname = "\"".$row["color_name"]."\"";
  42          $array["colors_name"][$colorname]["id"] = $row["color_id"];
  43          $array["colors_name"][$colorname]["name"] = $row["color_name"];
  44          $array["colors_name"][$colorname]["value"] = $row["color_value"];
  45          
  46          $array["colors_id"][$row["color_id"]]["id"] = $row["color_id"];
  47          $array["colors_id"][$row["color_id"]]["name"] = $row["color_name"];
  48          $array["colors_id"][$row["color_id"]]["value"] = $row["color_value"];
  49      }
  50      
  51      // Styles information
  52      $query = "SELECT * FROM ".DB_PREPEND."phpwcms_fonts_styles ORDER BY style_name";
  53      $result = mysql_query($query, $db) or die ("Error in query:$query");
  54      
  55      while ($row = mysql_fetch_assoc($result)) {
  56      
  57          $stylename = "\"".$row["style_name"]."\"";
  58          $array["styles_name"][$stylename]["id"] = $row["style_id"];
  59          $array["styles_name"][$stylename]["name"] = $row["style_name"];
  60          
  61          $array["styles_id"][$row["style_id"]]["id"] = $row["style_id"];
  62          $array["styles_id"][$row["style_id"]]["name"] = $row["style_name"];
  63          
  64          $style_info = explode(":", $row["style_info"]);
  65          $array["styles_name"][$stylename]["font"] = $style_info[0];
  66          $array["styles_name"][$stylename]["antialiasing"] = $style_info[1];
  67          $array["styles_name"][$stylename]["size"] = $style_info[2];
  68          $array["styles_name"][$stylename]["fgcolor"] = $style_info[3];
  69          $array["styles_name"][$stylename]["fgtransparency"] = $style_info[4];
  70          $array["styles_name"][$stylename]["bgcolor"] = $style_info[5];
  71          $array["styles_name"][$stylename]["bgtransparency"] = $style_info[6];
  72          $array["styles_name"][$stylename]["line_width"] = $style_info[7];
  73          $array["styles_name"][$stylename]["format"] = $style_info[8];
  74          
  75          $array["styles_name"][$stylename]["start_x"] = empty($style_info[9]) ? 0 : $style_info[9] ;
  76          $array["styles_name"][$stylename]["start_y"] = empty($style_info[10]) ? 0 : $style_info[10] ;
  77          $array["styles_name"][$stylename]["height"] = empty($style_info[11]) ? 5 : $style_info[11] ;
  78          $array["styles_name"][$stylename]["rotation"] = empty($style_info[12]) ? 'default' : $style_info[12] ;
  79          
  80          
  81          $array["styles_id"][$row["style_id"]]["font"] = $style_info[0];
  82          $array["styles_id"][$row["style_id"]]["antialiasing"] = $style_info[1];
  83          $array["styles_id"][$row["style_id"]]["size"] = $style_info[2];
  84          $array["styles_id"][$row["style_id"]]["fgcolor"] = $style_info[3];
  85          $array["styles_id"][$row["style_id"]]["fgtransparency"] = $style_info[4];
  86          $array["styles_id"][$row["style_id"]]["bgcolor"] = $style_info[5];
  87          $array["styles_id"][$row["style_id"]]["bgtransparency"] = $style_info[6];
  88          $array["styles_id"][$row["style_id"]]["line_width"] = $style_info[7];
  89          $array["styles_id"][$row["style_id"]]["format"] = $style_info[8];
  90          
  91          $array["styles_id"][$row["style_id"]]["start_x"] = empty($style_info[9]) ? 0 : $style_info[9] ;
  92          $array["styles_id"][$row["style_id"]]["start_y"] = empty($style_info[10]) ? 0 : $style_info[10] ;
  93          $array["styles_id"][$row["style_id"]]["height"] = empty($style_info[11]) ? 5 : $style_info[11] ;
  94          $array["styles_id"][$row["style_id"]]["rotation"] = empty($style_info[12]) ? 'default' : $style_info[12] ;
  95  
  96      }
  97      
  98      return $array;
  99  }
 100  
 101  ?>