SELECT t.entry_id, entry_date, year, month FROM exp_weblog_titles t WHERE status='' AND year != 2005


All upper case switched to mixed case:

<?php
global $DB;

$sql = "SELECT title, entry_id FROM exp_weblog_titles t WHERE status='Import Pending'";
$query = $DB->query($sql);

	if ($query->num_rows > 0)
	{
		foreach($query->result as $row)
		{

if (strtoupper($row['title']) === $row['title']) 
{ 
$new_title = ucwords(strtolower($row['title'])); 

$data = array('title' => $new_title);

$sql = $DB->update_string('exp_weblog_titles', $data, "entry_id =".$row['entry_id']);

echo $sql.'dude<br>';

//$DB->query($sql);

}  
		}
	}
?>


*************************************************************************************************************

Set to gated; remove keywords; 


<?php
global $DB;

$sql = "SELECT entry_id FROM exp_weblog_titles t WHERE status='Import Pending'";
$query = $DB->query($sql);

	if ($query->num_rows > 0)
	{
		foreach($query->result as $row)
		{

$data = array('field_id_15' => '', 'field_id_11' => 'Gated');

$sql = $DB->update_string('exp_weblog_data', $data, "entry_id =".$row['entry_id']);

//echo $sql.'<br>';

$DB->query($sql);

		}
	}
?>



field_id_15 - keywords
field_id_11 - access should be 'Gated'

 
**************************************************************************************************************

Swap from import weblog to news weblog:
weblog_id=23 - import weblog
weblog_id=10 - news

UPDATE exp_weblog_titles SET weblog_id = 10 WHERE weblog_id = 23
UPDATE exp_weblog_data SET weblog_id = 10 WHERE weblog_id = 23

*************************************************************************************************************

fix dates not in 2005; - 1176062400


<?php
global $DB, $LOC;
$b_date = '2007-04-08 00:00 AM';
$g_date = '2005-08-28 00:00 AM';
$entry_UTC_time = $LOC->convert_human_date_to_gmt($g_date);
$bentry_UTC_time = $LOC->convert_human_date_to_gmt($b_date);



$sql = "SELECT entry_id FROM exp_weblog_titles t WHERE status='Import Pending' AND entry_date = 1176062400";
$query = $DB->query($sql);

	if ($query->num_rows > 0)
	{
		foreach($query->result as $row)
		{

$data = array('entry_date' => $entry_UTC_time, 'year' => '2005', 'month' => '08', 'day' => '28');

$sql = $DB->update_string('exp_weblog_titles', $data, "entry_id =".$row['entry_id']);

echo $sql.'<br>';

//$DB->query($sql);

		}
	}
?>



{exp:query sql="SELECT entry_id, entry_date, month, day, year FROM exp_weblog_titles WHERE year=2007 AND status='Import Pending'"}
{entry_date}  --  {month} - {day} - {year}<br>
{/exp:query}

****************************************************************************
sync categories

<?php
global $DB;

$cats = array();

$query = $DB->query("SELECT cat_id FROM exp_category_field_data");

if ($query->num_rows > 0)
{
    foreach ($query->result as $row)
    {
        $cats[] = $row['cat_id'];
    }
}

$query = $DB->query("SELECT cat_id, group_id, site_id FROM exp_categories");

if ($query->num_rows > 0)
{
    foreach ($query->result as $row)
    {
        if (! in_array($row['cat_id'], $cats))
        {
            $DB->query($DB->insert_string('exp_category_field_data', array('cat_id' => $row['cat_id'], 'group_id' => $row['group_id'], 'site_id' => $row['site_id'])));
        }
    }
}

?>