[ Index ] |
PHP Cross Reference of phpwcms V1.4.7 _r403 (01.11.10) |
[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 ?>
title
Description
Body
title
Description
Body
title
Description
Body
title
Body
Generated: Tue Nov 16 22:51:00 2010 | Cross-referenced by PHPXref 0.7 |