function update_post_content()
{
$query = "SELECT * FROM posts WHERE posts_permalink='" . $this->permalink . "' LIMIT 1;";
$result = mysql_query($query);
// This URL doesn't exist, so we'll make a new row.
if (!mysql_num_rows($result)) {
debug("[update_post_content] Could not find this row in the posts table.");
$escaped_content = str_replace("'", "\\'", $this->content);
$this->site_id = find_parent_site($this->permalink);
$r_time = new RousseauDate(time());
$this->timestamp = $r_time->print_sql_time();
$create_query = "INSERT INTO posts (posts_content,posts_site_id," . "posts_timestamp,posts_permalink,posts_xid," . "posts_blog_xid, posts_fb_id) " . "VALUES (" . "'" . $escaped_content . "'," . $this->site_id . "," . "'" . $this->timestamp . "'," . "'" . $this->permalink . "'," . "'" . $this->xid . "'," . "'" . $this->blog_xid . "'," . "'" . $this->fb_id . "'" . ");";
debug("[update_post_content] Insert query is {$create_query}");
$result = mysql_query($create_query);
} else {
$this->id = mysql_result($result, 0, "posts_id");
$this->site_id = mysql_result($result, 0, "posts_site_id");
$this->fb_id = mysql_result($result, 0, "posts_fb_id");
$content = mysql_result($result, 0, "posts_content");
// if the text has changed, update the db.
if (strlen($content) != strlen($this->content)) {
$escaped_content = str_replace("'", "\\'", $this->content);
$query = "UPDATE posts SET posts_content ='" . $escaped_content . "' WHERE posts_id=" . $this->id . ";";
$result = mysql_query($query);
}
}
}
<?php require_once 'rousseau-includes/rousseau-utilities.php'; $right_now = time(); $r_date = new RousseauDate($right_now); echo "Now is: " . $r_date->print_readable_time(); echo "SQL-readable now is: " . $r_date->print_sql_time();
