function stylebox($css_name, $css_info, $classes) { $show_name = showgoodname($css_name); $boxname = "style_{$css_name}" . "_box"; $activesection = $_SESSION["activesection"]; $activetheme = $_SESSION["activetheme"]; $debug = $_SESSION["debug"]; $allstylesrbtn = getvardata("allstylesrbtn", "no", 99); //$debug = "true"; if ($debug == "true") { echo "<!-- in showstyle with [{$css_name}]:"; print_r($css_info); echo "-->\n"; } $name_prefix = ""; $source = isset($css_info["source"]) ? $css_info["source"] : "unknown"; unset($css_info["source"]); $type = isset($css_info["type"]) ? $css_info["type"] : $name_prefix; unset($css_info["type"]); $section = isset($css_info["section"]) ? $css_info["section"] : "default"; unset($css_info["section"]); // section is section, source is theme $name_prefix = $type == "class" ? "." : $name_prefix; $name_prefix = $type == "id" ? "#" : $name_prefix; $insection = $section == $activesection && $source == $activetheme ? "insec" : "nonsec"; //echo "<!-- testing [$section] vs [$activesection] and [$source] vs [$activetheme] => [$insection] -->\n"; $insection = $section == "system" ? "isdefault" : $insection; $showstyle = $allstylesrbtn == "no" && $insection == "nonsec" ? "noshow" : ""; echo "\t\t<div name=\"{$boxname}\" id=\"{$boxname}\" class=\"{$classes} {$insection} {$showstyle}\">\n"; echo "\t\t\t<table border=0 cellspacing=0 cellpadding=0>\n"; echo "\t\t\t\t<tr><td colspan=3 width=170px>{$name_prefix}" . "{$show_name}</td></tr>\n"; if (count($css_info) > 0) { foreach ($css_info as $thisplace => $placeinfo) { $name = $placeinfo["name"]; $value = $placeinfo["value"]; echo "\t\t\t\t<tr>\n"; echo "\t\t\t\t\t<td width=20px> </td>\n"; echo "\t\t\t\t\t<td width=120px;>{$name} :</td>\n"; echo "\t\t\t\t\t<td width=120px>{$value}</td>\n"; echo "\t\t\t\t</tr>\n"; } } else { echo "\t\t\t\t<tr><td colspan=3>Click to add a new style</td></tr>"; } echo "\t\t\t</table>\n"; echo "\t\t</div>\n"; }
function updatestyles($name, $section, $type, $theme) { $show_name = showgoodname($name); $css_name = ($type == "class" or $type == "") ? ".{$show_name}" : "#{$show_name}"; $csection = ($section == "" or $section == "default") ? "" : " and section=\"{$section}\""; $usection = ($section == "" or $section == "default") ? "," : ",section=\"{$section}\","; $shandle = $_SESSION["shandle"]; $name_list = $_POST["css_parts"]; $value_list = $_POST["css_values"]; $activebrowser = $_SESSION["activebrowser"]; $theme = $theme == "" ? $_SESSION["activetheme"] : $theme; $section = $section == "" ? $_SESSION["activesection"] : $section; //echo "<!-- into update with [$css_name]:[$theme]:[$section] -->\n"; //echo "<!-- update style with [names]:";print_r($name_list);echo "-->\n"; //echo "<!-- update style with [values]:";print_r($value_list);echo "-->\n"; $css_place = 0; $statusmessage = "Update Complete"; foreach ($name_list as $index => $name) { $css_place++; $value = $value_list[$index]; //echo "<!-- processing [$index] => [$name]:[$value] -->\n"; // check for an existing css entry $sql = "select corder,css_value from activecss where conditional=\"browser\" and css_name=\"{$css_name}\" and looking_for=\"{$activebrowser}\" and theme=\"{$theme}\" {$csection} and css_selector=\"{$name}\" limit 1"; //echo "<!-- sql[$sql] -->\n"; $sresult = mysqli_query($shandle, $sql) or die("Cannot talk to active css table"); $sdata = mysqli_fetch_array($sresult); $corder = $sdata["corder"]; $result = $sdata["css_value"]; //echo "<!-- result [$corder][$result] -->\n"; // no corder means insert record otherwise update if ($corder < 1) { $sql = "insert into activecss set conditional=\"browser\", looking_for=\"{$activebrowser}\",theme=\"{$theme}\"" . $usection . "css_name=\"{$css_name}\",css_selector=\"{$name}\", css_value=\"{$value}\",css_place=\"{$css_place}\""; } else { $sql = "update activecss set css_value=\"{$value}\" where corder=\"{$corder}\""; } //echo "<!-- sql[$sql] -->\n"; $sresult = mysqli_query($shandle, $sql) or die("Cannot talk to activecss"); $statusmessage = $sresult === false ? "Update Failed" : $statusmessage; } return $statusmessage; }