1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:
42:
43:
44:
45:
46:
47:
48:
49:
50:
51:
52:
53:
54:
55:
56:
57:
58:
59:
60:
61:
62:
63:
64:
65:
66:
67:
68:
69:
70:
71:
72:
73:
74:
75:
76:
77:
78:
79:
80:
81:
82:
83:
84:
85:
86:
87:
88:
89:
90:
91:
92:
93:
94:
95:
96:
97:
98:
99:
100:
101:
102:
103:
104:
105:
106:
107:
108:
109:
110:
111:
112:
113:
114:
115:
116:
117:
118:
119:
120:
121:
122:
123:
124:
125:
126:
127:
128:
129:
130:
131:
132:
133:
134:
135:
136:
137:
138:
139:
140:
141:
142:
143:
144:
145:
146:
147:
148:
149:
150:
151:
152:
153:
154:
155:
156:
157:
158:
159:
160:
161:
162:
163:
164:
165:
166:
167:
168:
169:
170:
171:
172:
173:
174:
175:
176:
177:
178:
179:
180:
181:
182:
183:
184:
185:
186:
187:
188:
189:
190:
191:
192:
193:
194:
195:
196:
197:
198:
199:
200:
201:
202:
203:
204:
205:
206:
207:
208:
209:
210:
211:
212:
213:
214:
215:
216:
217:
218:
219:
220:
221:
222:
223:
224:
|
<?php
require ("./global.php");
isAdmin();
if(isset($_REQUEST['action'])) $action=$_REQUEST['action'];
else $action="view";
if($action=="add") {
if(isset($_POST['send'])) {
reset($_POST);
while(list($key,$val)=each($_POST)) $$key=trim($val);
$db->query("INSERT INTO bb".$n."_subvariablepacks (subvariablepackid,parent_subvariablepackid,subvariablepackname) VALUES (NULL,'".intval($parent_subvariablepackid)."','".addslashes($subvariablepackname)."')");
$subvariablepackid=$db->insert_id();
$body="<body bgcolor="$bgcolor" text="$textcolor"".ifelse($bodytags," $bodytags");
$db->unbuffered_query("INSERT INTO bb".$n."_subvariables (subvariableid,subvariablepackid,variable,substitute) VALUES (NULL,'$subvariablepackid','<body','".addslashes($body)."')",1);
if($imagelogo) $imagelogo="<img src="$imagelogo" border=0>";
$db->unbuffered_query("INSERT INTO bb".$n."_subvariables (subvariableid,subvariablepackid,variable,substitute) VALUES (NULL,'$subvariablepackid','{imagelogo}','".addslashes($imagelogo)."')",1);
if($imageback) $imageback="background="$imageback"";
$db->unbuffered_query("INSERT INTO bb".$n."_subvariables (subvariableid,subvariablepackid,variable,substitute) VALUES (NULL,'$subvariablepackid','{imageback}','".addslashes($imageback)."')",1);
if($cssfile) $cssfile="<link rel="stylesheet" href="$cssfile">";
$db->unbuffered_query("INSERT INTO bb".$n."_subvariables (subvariableid,subvariablepackid,variable,substitute) VALUES (NULL,'$subvariablepackid','{cssfile}','".addslashes($cssfile)."')",1);
$normalfont="<font face="$normalfont" size="$normalfontsize"".ifelse($normalfonttags," $normalfonttags");
$db->unbuffered_query("INSERT INTO bb".$n."_subvariables (subvariableid,subvariablepackid,variable,substitute) VALUES (NULL,'$subvariablepackid','<normalfont','".addslashes($normalfont)."')",1);
$smallfont="<font face="$smallfont" size="$smallfontsize"".ifelse($smallfonttags," $smallfonttags");
$db->unbuffered_query("INSERT INTO bb".$n."_subvariables (subvariableid,subvariablepackid,variable,substitute) VALUES (NULL,'$subvariablepackid','<smallfont','".addslashes($smallfont)."')",1);
$db->unbuffered_query("INSERT INTO bb".$n."_subvariables (subvariableid,subvariablepackid,variable,substitute) VALUES (NULL,'$subvariablepackid','{imagefolder}','".addslashes($imagefolder)."')",1);
$db->unbuffered_query("INSERT INTO bb".$n."_subvariables (subvariableid,subvariablepackid,variable,substitute) VALUES (NULL,'$subvariablepackid','{tableoutbordercolor}','".addslashes($tableoutbordercolor)."')",1);
$db->unbuffered_query("INSERT INTO bb".$n."_subvariables (subvariableid,subvariablepackid,variable,substitute) VALUES (NULL,'$subvariablepackid','{tableinbordercolor}','".addslashes($tableinbordercolor)."')",1);
$db->unbuffered_query("INSERT INTO bb".$n."_subvariables (subvariableid,subvariablepackid,variable,substitute) VALUES (NULL,'$subvariablepackid','{tabletitlecolor}','".addslashes($tabletitlecolor)."')",1);
$db->unbuffered_query("INSERT INTO bb".$n."_subvariables (subvariableid,subvariablepackid,variable,substitute) VALUES (NULL,'$subvariablepackid','{tablecolora}','".addslashes($tablecolora)."')",1);
$db->unbuffered_query("INSERT INTO bb".$n."_subvariables (subvariableid,subvariablepackid,variable,substitute) VALUES (NULL,'$subvariablepackid','{tablecolorb}','".addslashes($tablecolorb)."')",1);
$db->unbuffered_query("INSERT INTO bb".$n."_subvariables (subvariableid,subvariablepackid,variable,substitute) VALUES (NULL,'$subvariablepackid','{fontcolorsecond}','".addslashes($fontcolorsecond)."')",1);
$db->unbuffered_query("INSERT INTO bb".$n."_subvariables (subvariableid,subvariablepackid,variable,substitute) VALUES (NULL,'$subvariablepackid','{fontcolorthird}','".addslashes($fontcolorthird)."')",1);
$db->unbuffered_query("INSERT INTO bb".$n."_subvariables (subvariableid,subvariablepackid,variable,substitute) VALUES (NULL,'$subvariablepackid','{tablecatcolor}','".addslashes($tablecatcolor)."')",1);
$db->unbuffered_query("INSERT INTO bb".$n."_subvariables (subvariableid,subvariablepackid,variable,substitute) VALUES (NULL,'$subvariablepackid','{tableinwidth}','".addslashes($tableinwidth)."')",1);
$db->unbuffered_query("INSERT INTO bb".$n."_subvariables (subvariableid,subvariablepackid,variable,substitute) VALUES (NULL,'$subvariablepackid','{tableoutwidth}','".addslashes($tableoutwidth)."')",1);
$db->unbuffered_query("INSERT INTO bb".$n."_subvariables (subvariableid,subvariablepackid,variable,substitute) VALUES (NULL,'$subvariablepackid','{timecolor}','".addslashes($timecolor)."')",1);
$db->unbuffered_query("INSERT INTO bb".$n."_subvariables (subvariableid,subvariablepackid,variable,substitute) VALUES (NULL,'$subvariablepackid','{imagefolder}','".addslashes($imagefolder)."')",1);
$db->unbuffered_query("INSERT INTO bb".$n."_subvariables (subvariableid,subvariablepackid,variable,substitute) VALUES (NULL,'$subvariablepackid','{inposttablecolor}','".addslashes($inposttablecolor)."')",1);
$db->unbuffered_query("INSERT INTO bb".$n."_subvariables (subvariableid,subvariablepackid,variable,substitute) VALUES (NULL,'$subvariablepackid','{prefixcolor}','".addslashes($prefixcolor)."')",1);
$db->unbuffered_query("INSERT INTO bb".$n."_subvariables (subvariableid,subvariablepackid,variable,substitute) VALUES (NULL,'$subvariablepackid','{mainbgcolor}','".addslashes($mainbgcolor)."')",1);
$db->unbuffered_query("INSERT INTO bb".$n."_subvariables (subvariableid,subvariablepackid,variable,substitute) VALUES (NULL,'$subvariablepackid','{css}','".addslashes($css)."')",1);
$db->unbuffered_query("INSERT INTO bb".$n."_subvariables (subvariableid,subvariablepackid,variable,substitute) VALUES (NULL,'$subvariablepackid','{!DOCTYPE}','".addslashes($doctype)."')",1);
header("Location: designpack.php?action=view&sid=$session[hash]");
exit();
}
$subp_options="";
$result=$db->query("SELECT * FROM bb".$n."_subvariablepacks ORDER BY subvariablepackname ASC");
while($row=$db->fetch_array($result)) $subp_options.=makeoption($row['subvariablepackid'],$row['subvariablepackname'],"",0);
eval("print("".gettemplate("designpack_add")."");");
}
if($action=="view") {
$count=0;
$designpack_viewbit="";
$result=$db->query("SELECT * FROM bb".$n."_subvariablepacks ORDER BY subvariablepackname");
while($row=$db->fetch_array($result)) {
$rowclass = getone($count++,"firstrow","secondrow");
eval ("\$designpack_viewbit .= "".gettemplate("designpack_viewbit")."";");
}
eval("print("".gettemplate("designpack_view")."");");
}
if($action=="edit") {
if(isset($_POST['send'])) {
reset($_POST);
while(list($key,$val)=each($_POST)) $$key=trim($val);
$subvariablepackid=intval($subvariablepackid);
$db->unbuffered_query("UPDATE bb".$n."_subvariablepacks SET parent_subvariablepackid='".intval($parent_subvariablepackid)."', subvariablepackname='".addslashes($subvariablepackname)."' WHERE subvariablepackid='$subvariablepackid'",1);
$body="<body bgcolor="$bgcolor" text="$textcolor"".ifelse($bodytags," $bodytags");
$db->unbuffered_query("UPDATE bb".$n."_subvariables SET substitute='".addslashes($body)."' WHERE variable='<body' AND subvariablepackid='$subvariablepackid'",1);
if($imagelogo) $imagelogo="<img src="$imagelogo" border=0>";
$db->unbuffered_query("UPDATE bb".$n."_subvariables SET substitute='".addslashes($imagelogo)."' WHERE variable='{imagelogo}' AND subvariablepackid='$subvariablepackid'",1);
if($imageback) $imageback="background="$imageback"";
$db->unbuffered_query("UPDATE bb".$n."_subvariables SET substitute='".addslashes($imageback)."' WHERE variable='{imageback}' AND subvariablepackid='$subvariablepackid'",1);
if($cssfile) $cssfile="<link rel="stylesheet" href="$cssfile">";
$db->unbuffered_query("UPDATE bb".$n."_subvariables SET substitute='".addslashes($cssfile)."' WHERE variable='{cssfile}' AND subvariablepackid='$subvariablepackid'",1);
$normalfont="<font face="$normalfont" size="$normalfontsize"".ifelse($normalfonttags," $normalfonttags");
$db->unbuffered_query("UPDATE bb".$n."_subvariables SET substitute='".addslashes($normalfont)."' WHERE variable='<normalfont' AND subvariablepackid='$subvariablepackid'",1);
$smallfont="<font face="$smallfont" size="$smallfontsize"".ifelse($smallfonttags," $smallfonttags");
$db->unbuffered_query("UPDATE bb".$n."_subvariables SET substitute='".addslashes($smallfont)."' WHERE variable='<smallfont' AND subvariablepackid='$subvariablepackid'",1);
$db->unbuffered_query("UPDATE bb".$n."_subvariables SET substitute='".addslashes($imagefolder)."' WHERE variable='{imagefolder}' AND subvariablepackid='$subvariablepackid'",1);
$db->unbuffered_query("UPDATE bb".$n."_subvariables SET substitute='".addslashes($tableoutbordercolor)."' WHERE variable='{tableoutbordercolor}' AND subvariablepackid='$subvariablepackid'",1);
$db->unbuffered_query("UPDATE bb".$n."_subvariables SET substitute='".addslashes($tableinbordercolor)."' WHERE variable='{tableinbordercolor}' AND subvariablepackid='$subvariablepackid'",1);
$db->unbuffered_query("UPDATE bb".$n."_subvariables SET substitute='".addslashes($tabletitlecolor)."' WHERE variable='{tabletitlecolor}' AND subvariablepackid='$subvariablepackid'",1);
$db->unbuffered_query("UPDATE bb".$n."_subvariables SET substitute='".addslashes($tablecolora)."' WHERE variable='{tablecolora}' AND subvariablepackid='$subvariablepackid'",1);
$db->unbuffered_query("UPDATE bb".$n."_subvariables SET substitute='".addslashes($tablecolorb)."' WHERE variable='{tablecolorb}' AND subvariablepackid='$subvariablepackid'",1);
$db->unbuffered_query("UPDATE bb".$n."_subvariables SET substitute='".addslashes($fontcolorsecond)."' WHERE variable='{fontcolorsecond}' AND subvariablepackid='$subvariablepackid'",1);
$db->unbuffered_query("UPDATE bb".$n."_subvariables SET substitute='".addslashes($fontcolorthird)."' WHERE variable='{fontcolorthird}' AND subvariablepackid='$subvariablepackid'",1);
$db->unbuffered_query("UPDATE bb".$n."_subvariables SET substitute='".addslashes($tablecatcolor)."' WHERE variable='{tablecatcolor}' AND subvariablepackid='$subvariablepackid'",1);
$db->unbuffered_query("UPDATE bb".$n."_subvariables SET substitute='".addslashes($tableinwidth)."' WHERE variable='{tableinwidth}' AND subvariablepackid='$subvariablepackid'",1);
$db->unbuffered_query("UPDATE bb".$n."_subvariables SET substitute='".addslashes($tableoutwidth)."' WHERE variable='{tableoutwidth}' AND subvariablepackid='$subvariablepackid'",1);
$db->unbuffered_query("UPDATE bb".$n."_subvariables SET substitute='".addslashes($timecolor)."' WHERE variable='{timecolor}' AND subvariablepackid='$subvariablepackid'",1);
$db->unbuffered_query("UPDATE bb".$n."_subvariables SET substitute='".addslashes($imagefolder)."' WHERE variable='{imagefolder}' AND subvariablepackid='$subvariablepackid'",1);
$db->unbuffered_query("UPDATE bb".$n."_subvariables SET substitute='".addslashes($inposttablecolor)."' WHERE variable='{inposttablecolor}' AND subvariablepackid='$subvariablepackid'",1);
$db->unbuffered_query("UPDATE bb".$n."_subvariables SET substitute='".addslashes($prefixcolor)."' WHERE variable='{prefixcolor}' AND subvariablepackid='$subvariablepackid'",1);
$db->unbuffered_query("UPDATE bb".$n."_subvariables SET substitute='".addslashes($mainbgcolor)."' WHERE variable='{mainbgcolor}' AND subvariablepackid='$subvariablepackid'",1);
$db->unbuffered_query("UPDATE bb".$n."_subvariables SET substitute='".addslashes($css)."' WHERE variable='{css}' AND subvariablepackid='$subvariablepackid'",1);
$db->unbuffered_query("UPDATE bb".$n."_subvariables SET substitute='".addslashes($doctype)."' WHERE variable='{!DOCTYPE}' AND subvariablepackid='$subvariablepackid'",1);
header("Location: designpack.php?action=view&sid=$session[hash]");
exit();
}
$subvariablepackid=intval($_REQUEST['subvariablepackid']);
$dp = $db->query_first("SELECT * FROM bb".$n."_subvariablepacks WHERE subvariablepackid='$subvariablepackid'");
$result=$db->query("SELECT * FROM bb".$n."_subvariables WHERE subvariablepackid='$subvariablepackid'");
while($row=$db->fetch_array($result)) {
switch($row['variable']) {
case "<body":
preg_match("/<body bgcolor="([^"]*)" text="([^"]*)"(.*)/i",$row['substitute'],$match);
$bgcolor=htmlspecialchars($match[1]);
$textcolor=htmlspecialchars($match[2]);
$bodytags=htmlspecialchars(trim($match[3]));
break;
case "<smallfont":
preg_match("/<font face="([^"]*)" size="([^"]*)"(.*)/i",$row['substitute'],$match);
$smallfont=htmlspecialchars($match[1]);
$smallfontsize=htmlspecialchars($match[2]);
$smallfonttags=htmlspecialchars(trim($match[3]));
break;
case "<normalfont":
preg_match("/<font face="([^"]*)" size="([^"]*)"(.*)/i",$row['substitute'],$match);
$normalfont=htmlspecialchars($match[1]);
$normalfontsize=htmlspecialchars($match[2]);
$normalfonttags=htmlspecialchars(trim($match[3]));
break;
case "{imageback}":
preg_match("/background="([^"]*)"/i",$row['substitute'],$match);
$imageback=htmlspecialchars($match[1]);
break;
case "{imagelogo}":
preg_match("/<img src="([^"]*)"/i",$row['substitute'],$match);
$imagelogo=htmlspecialchars($match[1]);
break;
case "{cssfile}":
preg_match("/href="([^"]*)">/i",$row['substitute'],$match);
$cssfile=htmlspecialchars($match[1]);
break;
case "{tableoutbordercolor}":
$tableoutbordercolor=htmlspecialchars($row['substitute']);
break;
case "{tableinbordercolor}":
$tableinbordercolor=htmlspecialchars($row['substitute']);
break;
case "{tabletitlecolor}":
$tabletitlecolor=htmlspecialchars($row['substitute']);
break;
case "{tablecolora}":
$tablecolora=htmlspecialchars($row['substitute']);
break;
case "{tablecolorb}":
$tablecolorb=htmlspecialchars($row['substitute']);
break;
case "{fontcolorsecond}":
$fontcolorsecond=htmlspecialchars($row['substitute']);
break;
case "{fontcolorthird}":
$fontcolorthird=htmlspecialchars($row['substitute']);
break;
case "{tablecatcolor}":
$tablecatcolor=htmlspecialchars($row['substitute']);
break;
case "{tableinwidth}":
$tableinwidth=htmlspecialchars($row['substitute']);
break;
case "{tableoutwidth}":
$tableoutwidth=htmlspecialchars($row['substitute']);
break;
case "{timecolor}":
$timecolor=htmlspecialchars($row['substitute']);
break;
case "{imagefolder}":
$imagefolder=htmlspecialchars($row['substitute']);
break;
case "{inposttablecolor}":
$inposttablecolor=htmlspecialchars($row['substitute']);
break;
case "{prefixcolor}":
$prefixcolor=htmlspecialchars($row['substitute']);
break;
case "{mainbgcolor}":
$mainbgcolor=htmlspecialchars($row['substitute']);
break;
case "{css}":
$css=htmlspecialchars($row['substitute']);
break;
case "{!DOCTYPE}":
$doctype=htmlspecialchars($row['substitute']);
break;
}
}
$subp_options="";
$result=$db->query("SELECT * FROM bb".$n."_subvariablepacks WHERE subvariablepackid <> '$subvariablepackid' ORDER BY subvariablepackname ASC");
while($row=$db->fetch_array($result)) $subp_options.=makeoption($row['subvariablepackid'],$row['subvariablepackname'],$dp['parent_subvariablepackid'],1);
eval("print("".gettemplate("designpack_edit")."");");
}
if($action=="del") {
$subvariablepackid=intval($_REQUEST['subvariablepackid']);
if(isset($_POST['send'])) {
$db->unbuffered_query("DELETE FROM bb".$n."_subvariablepacks WHERE subvariablepackid='$subvariablepackid'",1);
$db->unbuffered_query("DELETE FROM bb".$n."_subvariables WHERE subvariablepackid='$subvariablepackid'",1);
$db->unbuffered_query("UPDATE bb".$n."_styles SET subvariablepackid=0 WHERE subvariablepackid='$subvariablepackid'",1);
$db->unbuffered_query("UPDATE bb".$n."_subvariablepacks SET parent_subvariablepackid=0 WHERE parent_subvariablepackid='$subvariablepackid'",1);
header("Location: designpack.php?action=view&sid=$session[hash]");
exit();
}
$dp = $db->query_first("SELECT subvariablepackname FROM bb".$n."_subvariablepacks WHERE subvariablepackid='$subvariablepackid'");
eval("print("".gettemplate("designpack_del")."");");
}
?>
|