Changeset 356 for branches

Timestamp:

03/25/06 01:12:37 (3 years ago)

Author:

anti

Message:

+ this is some seriosly old code, but there is some tagging stuff in here

Location:

branches/plogger-with-tags

Files:

• admin/plog-admin-functions.php (modified) (1 diff)
• admin/plog-manage.php (modified) (2 diffs)
• admin/plog-upload.php (modified) (2 diffs)
• gallery.php (modified) (3 diffs)
• plog-connect.php (modified) (1 diff)

branches/plogger-with-tags/admin/plog-admin-functions.php

@@ -720 +720 @@
 
 
+function parse_tags($str) {
+        // 1. compress all whitespace
+        $str = preg_replace('/\s{2,}/','',$str);
+        // 2. extract any phrases in quotes
+        preg_match_all('/"([(\w|\s)]+)"/',$str,$phrases);
+        preg_match_all('/"([^"]+)"/',$str,$phrases);
+
+        // 2. now remove the phrases
+        $str = preg_replace('/"([^"]*)"/','',$str);
+        // 3. get single words
+        $words = preg_split('/\s+/',$str);
+        $tags = array_merge($phrases[1],$words);
+
+        $usable_tags = array();
+        foreach($tags as $tag) {
+               if (empty($tag)) continue;
+               if (!preg_match('/[^\W]/',$tag)) continue;
+               $usable_tags[] = $tag;
+        }
+        return $usable_tags;
+}
+
+function update_picture_tags($picture_id,$tags) {
+        global $TABLE_PREFIX;
+        $tags = parse_tags(SmartStripSlashes($tags));
+        $picture_id = intval($picture_id);
+
+        /* process any tags for the picture */
+        $existing_tags = $existing_rels = array();
+        if (sizeof($tags) > 0) {
+                $tagsql = join('","',$tags);
+                $sql = 'SELECT * FROM '.$TABLE_PREFIX.'tags WHERE `tag` IN ("'.$tagsql.'")';
+                $result = mysql_query($sql);
+                while($tag_row = mysql_fetch_assoc($result)) {
+                        $existing_tags[$tag_row['tag']] = $tag_row['id'];
+                };
+
+                $sql = 'SELECT * FROM '.$TABLE_PREFIX.'tag2picture WHERE `picture_id` ="'.$picture_id.'"';
+                $result = mysql_query($sql);
+                while($tag_row = mysql_fetch_assoc($result)) {
+                        $existing_rels[$tag_row['tag_id']] = $tag_row['picture_id'];
+                };
+        };
+
+        foreach($tags as $tag) {
+                if (!isset($existing_tags[$tag])) {
+                        // must be a new tag, register it
+                        $formatted = mysql_real_escape_string(preg_replace("/[^\w|\.|'|\-|\[|\]]/","_",$tag));
+                        $sql = 'INSERT INTO '.$TABLE_PREFIX.'tags (`tag`,`tagdate`,`formatted`)
+                                        VALUES ("'.mysql_real_escape_string($tag).'","'.$formatted.'",NOW())';
+                        print $sql;
+                        $result = mysql_query($sql);
+                        $existing_tags[$tag] = mysql_insert_id();
+                };
+
+                if (!isset($existing_rels[$existing_tags[$tag]])) {
+                        // no connection between tag and picture? create if
+                        $sql = 'INSERT INTO '.$TABLE_PREFIX.'tag2picture (`picture_id`,`tag_id`,`tagdate`)
+                                        VALUES ("'.$picture_id.'","'.$existing_tags[$tag].'",NOW())';
+                        mysql_query($sql);
+                };
+        }
+
+        // now remove links to any tags that have been deleted
+        foreach($existing_rels as $tag_id => $pic_id) {
+                if (!in_array($tag_id,$existing_tags)) {
+                        $sql = "DELETE FROM `".$TABLE_PREFIX."tag2picture`
+                                        WHERE `picture_id` = '$picture_id' AND `tag_id` = '$tag_id'";  
+                        mysql_query($sql);
+                };
+
+        }
+}
 ?>

branches/plogger-with-tags/admin/plog-manage.php

@@ -307 +307 @@
                 
                 $output .= '<form class="edit" action="'.$_SERVER["PHP_SELF"].'" method="post">';
-                
-                
-                $output .= 'Caption:<br/><input size="80" name="caption" id="caption" value="'.$photo['caption'].'">
-                                    Allow Comments? <input type="checkbox" id="allow_comments" name="allow_comments" value="1"'." $state>";
+
+                $tagsql = "SELECT tag FROM ".$TABLE_PREFIX."tags tags,".$TABLE_PREFIX."tag2picture rel
+                WHERE tags.id = rel.tag_id AND rel.picture_id = " . $photo['id'];
+                $result = mysql_query($tagsql);
+                $tags = array();
+
+                while($tag_row = mysql_fetch_assoc($result)) {
+                        $tag_value = $tag_row["tag"];
+                        // if tag contains spaces, then surround it with quotes
+                        if (preg_match("/\s/",$tag_value)) $tag_value = '"' . $tag_value . '"';
+                        $tags[] = $tag_value;
+                };
+
+                $tagvalue = join(' ',$tags);
+
+                $output .= 'Caption:<br/><input size="80" name="caption" id="caption" value="'.$photo['caption'].'"><br/>';
+                $output .= "Tags:<br/> <input size='80' id='tags' name='tags' value='".$tagvalue."'><br/>";
+                $output .= 'Allow Comments? <input type="checkbox" id="allow_comments" name="allow_comments" value="1"'." $state>";
                                         
                 $output .= '<input type="hidden" name="level" value="'.$_REQUEST['level'].'"><input type="hidden" 
@@ -413 +427 @@
         else if ($_POST['action'] == 'update-picture') {
                 $action_result = update_picture($_POST['pid'],$_POST['caption'],$_POST['allow_comments']);
+                update_picture_tags($_POST['pid'],$_POST['tags']);
         }
         else if ($_POST['action'] == 'update-album') {

branches/plogger-with-tags/admin/plog-upload.php

@@ -80 +80 @@
                                         
                                 $result = add_picture($album_id,$_FILES["userfile"]["tmp_name"],$_FILES["userfile"]["name"],$_REQUEST["caption"]);
-                                $output .= '<p class="actions">'.$result["output"].'</p>';
+                                if (!empty($result['errors'])) {
+                                        $output .= '<p class="errors">'.$result["errors"].'</p>';
+                                } else {
+                                        $output .= '<p class="actions">'.$result["output"].'</p>';
+                                        update_picture_tags($result["picture_id"],$_POST["tags"]);
+                                };
                         
                 }
@@ -93 +98 @@
       &nbsp;<input name="userfile" type="file"/><br />
                         Picture Caption (optional): <input name="caption" size="60"/><br />
+                        Tags (optional): <input name="tags" size="60"/><br />
                         </div>';
 

branches/plogger-with-tags/gallery.php

@@ -81 +81 @@
         $output .= '
                 <div id="wrapper">
-                        <table id="header-table" width="100%"><tr><td>'.generate_header().'</td><td style="text-align: right; vertical-align: bottom;">'.generate_jump_menu().generate_search_box().'</td></tr></table>';
+                        <table id="header-table" width="100%"><tr><td>'.generate_header().'</td><td style="text-align: right; vertical-align: bottom;"> <a href="'.$SERVER["PHP_SELF"].'?level=tags">tags</a> '.generate_jump_menu().generate_search_box().'</td></tr></table>';
         
         if ($level != "picture"){
@@ -262 +262 @@
 
                         $num_items = 1;
+                }
+
+                if ($level == "tags") {
+                        $output .= '<div id="inner_wrapper"><div id="big-picture-container">';
+                        $output .= generate_tag_interface();
+                        $output .= '</div></div>';
                 }
                 
@@ -1103 +1109 @@
 }
 
+function generate_tag_interface() {
+        global $TABLE_PREFIX;
+
+        $selected_tag = $_GET["tag"];
+        $sel_id = 0;
+        $sql = "SELECT * FROM ".$TABLE_PREFIX."tags";
+        $result = run_query($sql);
+        $filter = 0;
+        $output = '';
+        while($row = mysql_fetch_assoc($result)) {
+                if ($row['id'] == $selected_tag) $filter=$row['tag'];
+                $output .= "<a href='" . $_SERVER["PHP_SELF"] . '?level=tags&tag=' . $row['id'] . "'>" . $row['tag'] . '</a> ';
+        };
+        if ($filter) {
+                $output .= "<h1>Pictures tagged with `$filter`</h1>";
+                $output .= '<ul class="slides">';
+                $sql = "SELECT p.*,path,tag FROM ".$TABLE_PREFIX."pictures p, ".$TABLE_PREFIX."tags tag, ".$TABLE_PREFIX."tag2picture t2p WHERE (p.id = t2p.picture_id AND t2p.tag_id = tag.id AND tag.id = '$selected_tag')";
+                $result = mysql_query($sql);
+                while($row = mysql_fetch_assoc($result)) {
+                       $thumbpath = generate_thumb($row['path'], $row['id'], 'small');
+                       $output .= "<li class='thumbnail'>";
+                       $imgtag = '<img class="photos" src="'.$thumbpath.'" title="'.htmlspecialchars($row["description"]).'" alt="'.htmlspecialchars($row["description"]).'" />';
+                       $output .= "<a href='" . generate_url("picture",$row['id']) . "'>";
+                       $output .= $imgtag;
+                       $output .= "</a></li>";
+                };
+                $output .= "</ul>";
+        };
+        return $output;
+}
+
 // function for generating the slideshow javascript
 function generate_slideshow_js($id, $mode) {

branches/plogger-with-tags/plog-connect.php

@@ -5 +5 @@
 
 $DB_HOST = "localhost";
-$DB_USER = "";
-$DB_PW = "";
-$DB_NAME = "";
+$DB_USER = "plogtag";
+$DB_PW = "plogtag";
+$DB_NAME = "plogtag";
 
 $dbh = mysql_connect ($DB_HOST, $DB_USER, $DB_PW) or die ("Plogger cannot connect to the database because: " . mysql_error());
 mysql_select_db ($DB_NAME);
+
 
 function run_query($query){