[php-blog-cvs] jBlog db.sql,1.6,1.7 jBlog.css.php,1.1,1.2 jBlog_admin.php,1.7,1.8 jBlog_admin_installer.inc.php,1.5,1.6 jBlog_functions.inc.php,1.13,1.14

[<gsc...@us...>]

Update of /cvsroot/php-blog/jBlog
In directory sc8-pr-cvs1:/tmp/cvs-serv11025

Modified Files:
	db.sql jBlog.css.php jBlog_admin.php 
	jBlog_admin_installer.inc.php jBlog_functions.inc.php 
Log Message:
css in db


Index: db.sql
===================================================================
RCS file: /cvsroot/php-blog/jBlog/db.sql,v
retrieving revision 1.6
retrieving revision 1.7
diff -u -d -r1.6 -r1.7
--- db.sql	5 Mar 2003 15:03:27 -0000	1.6
+++ db.sql	5 Mar 2003 23:14:37 -0000	1.7
@@ -71,3 +71,16 @@
   count int(11) NOT NULL default '0',
   PRIMARY KEY  (url,day)
 ) TYPE=MyISAM;
+
+#
+# Table structure for table 'jBlog_css'
+#
+
+CREATE TABLE {PREFIX}css (
+  cssid int(11) NOT NULL auto_increment,
+  name varchar(40) default NULL,
+  data text,
+  PRIMARY KEY  (cssid)
+) TYPE=MyISAM;
+
+

Index: jBlog.css.php
===================================================================
RCS file: /cvsroot/php-blog/jBlog/jBlog.css.php,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -d -r1.1 -r1.2
--- jBlog.css.php	5 Mar 2003 21:09:39 -0000	1.1
+++ jBlog.css.php	5 Mar 2003 23:14:37 -0000	1.2
@@ -1,6 +1,8 @@
 <?php
-
-readfile("jBlog.css");
+session_start();
+include_once("jBlog_config.inc.php");
+$css = jBlog_getCSS();
+echo $css['data'];
 
 /* This could be tidied up by using the comment style rules recently added */
 

Index: jBlog_admin.php
===================================================================
RCS file: /cvsroot/php-blog/jBlog/jBlog_admin.php,v
retrieving revision 1.7
retrieving revision 1.8
diff -u -d -r1.7 -r1.8
--- jBlog_admin.php	5 Mar 2003 21:09:40 -0000	1.7
+++ jBlog_admin.php	5 Mar 2003 23:14:37 -0000	1.8
@@ -53,6 +53,7 @@
                     &bull; <a href='?jBlog[adminModule]=entries&jBlog[adminAction]=editSelect'>Edit entries</a><br>
                     &bull; <a href='?jBlog[adminModule]=entries&jBlog[adminAction]=deleteSelect'>Delete entries</a><br>
                     &bull; <a href='?jBlog[adminModule]=images'>Manage images</a><br>
+                    &bull; <a href='?jBlog[adminModule]=css'>Manage css</a><br>
 					&bull; <a href='?jBlog[adminModule]=images&jBlog[adminAction]=addSelect'>Add images</a><br>
                     &bull; <a href='?jBlog[adminModule]=images&jBlog[adminAction]=genThumbs' onClick="alert('WARNING:\nThis may take a long time if there are many images without thumbnails.');">Create Thumbs</a><br>
                     &bull; <a href='?jBlog[adminModule]=logout'>Log out</a><br>
@@ -73,6 +74,10 @@
 
 							case "images":
 								include("jBlog_admin_images.inc.php");
+                            break;
+
+							case "css":
+								include("jBlog_admin_css.inc.php");
                             break;
 
 							case "logout":

Index: jBlog_admin_installer.inc.php
===================================================================
RCS file: /cvsroot/php-blog/jBlog/jBlog_admin_installer.inc.php,v
retrieving revision 1.5
retrieving revision 1.6
diff -u -d -r1.5 -r1.6
--- jBlog_admin_installer.inc.php	5 Mar 2003 15:03:27 -0000	1.5
+++ jBlog_admin_installer.inc.php	5 Mar 2003 23:14:37 -0000	1.6
@@ -250,6 +250,11 @@
                                     '$_POST[email]',
                                     $mail_comments) ";
                     mysql_query($query);
+
+                    $text = mysql_escape_string(file_get_contents('./jBlog.css'));
+                    $query = "INSERT into $_POST[dbPrefix]css values(NULL, 'default', '$text')";
+                    mysql_query($query);
+
                     echo "<p>Welcome to jBlog!</b><p>";
                     echo "Write down your password: ".$_POST["pass"]." and <a href='".$_POST["jBlogHTTPPath"]."'>check out your blog</a>";
                     session_destroy();

Index: jBlog_functions.inc.php
===================================================================
RCS file: /cvsroot/php-blog/jBlog/jBlog_functions.inc.php,v
retrieving revision 1.13
retrieving revision 1.14
diff -u -d -r1.13 -r1.14
--- jBlog_functions.inc.php	5 Mar 2003 21:09:40 -0000	1.13
+++ jBlog_functions.inc.php	5 Mar 2003 23:14:37 -0000	1.14
@@ -761,6 +761,28 @@
     mysql_db_query($jBlog['dbName'], "DELETE FROM {$jBlog['dbPrefix']}references WHERE entry_id='$id'");
 }
 
+function jBlog_updertCSS($css) {
+	global $jBlog;
+
+    $newEntry = 0;
+    $exflag = 0;
+
+	if (!is_numeric($css["cssid"])) $css["cssid"] = "NULL";
+    $querystring = "REPLACE INTO ".$jBlog["dbPrefix"]."css
+                    (cssid, name, data)
+                    VALUES (
+                    ".$css["cssid"].",
+                    '".mysql_escape_string($css["name"])."',
+					'".mysql_escape_string($css["data"])."')";
+    $query = mysql_db_query($jBlog["dbName"], $querystring);
+    print "$querystring";
+    if ($css['cssid'] == "NULL") {
+        $newEntry = 1;
+        $css['cssid'] = mysql_insert_id();
+    }
+    return mysql_error();
+}
+
 /**
 * Get a list of images
 **/
@@ -933,6 +955,46 @@
     <?php
 }
 
+function jBlog_printCSSForm($targetURL, $hiddens = array(), $entry = array(), $errMsg = "") {
+	global $jBlog;
+
+    $css = jBlog_getCSS();
+    ?>
+    	<font color="#ff0000"><?=$errMsg?></font>
+    	<table class='jBlogEntryEdit'>
+        	<form action='<?=$targetURL?>' method="post" name="jBlogCSS">
+            <?php
+				foreach($hiddens as $key => $value) {
+					echo "<input type='hidden' name='$key' value='$value'>\n";
+                }
+		echo '<input type="hidden" name="jBlog[cssid]" value="'.$css["cssid"]."\">\n";
+            ?>
+            <tr>
+                <td align="left">template name</td>
+            </tr>
+			<tr>
+				<td align="left">
+                	<input type="text" name="jBlog[name]" value="<?=htmlentities($css["name"])?>" size=40>
+                </td>
+    		</tr>
+            <tr>
+                <td colspan="2">CSS</td>
+            </tr>   
+    		<tr>
+				<td colspan="2">
+                	<textarea name="jBlog[data]" cols=80 rows=20><?=htmlentities($css["data"])?></textarea>
+                </td>
+    		</tr>
+            <tr>
+            	<td colspan="2" align="right">
+                	<input type="submit" value="save">
+                </td>
+            </tr>
+            </form>
+    	</table>
+    <?php
+}
+
 function jBlog_authenticate_author($username, $password) {
     global $jBlog;
     global $_SESSION;
@@ -1000,6 +1062,15 @@
         }     
     }
 }
+
+function jBlog_getCSS($name = 'default' ) {
+    global $jBlog;
+    $query = "SELECT * from jBlog_css where name = '$name'";
+    $cursor = mysql_db_query($jBlog['dbName'], $query);
+    $row = mysql_fetch_assoc($cursor);
+    return $row;
+}
+
 define("JBLOG_FUNCTIONS_LOADED", true);
 ?>