<script type="text/javascript">
 
    function getProfile() {
        var req = opensocial.newDataRequest();
        var opt_params = {};
        var req = opensocial.newDataRequest();
        opt_params[opensocial.DataRequest.PeopleRequestFields.PROFILE_DETAILS] = [opensocial.Person.Field.CURRENT_LOCATION];
        req.add(req.newFetchPersonRequest('VIEWER', opt_params), 'myOwner');
        req.send(onLoadProfile);
    }
 
    function onLoadProfile(response) {
        var html = processProfile(response);
        document.getElementById('divProfile').innerHTML = html;
    }
 
    function processProfile(response) {
 
        var html = new Array();
        try {
 
            var person = response.get('myOwner').getData();
 
            var sId = person.getId();
            var sGivenName = person.getField(opensocial.Person.Field.NAME).getField(opensocial.Name.Field.GIVEN_NAME);
            var sFamilyName = person.getField(opensocial.Person.Field.NAME).getField(opensocial.Name.Field.FAMILY_NAME);
            var sUnstructuredName = person.getField(opensocial.Person.Field.NAME).getField(opensocial.Name.Field.UNSTRUCTURED);
            var gender = person.getField(opensocial.Person.Field.GENDER);
            var sGender = gender ? gender.getDisplayValue() : 'unknown';
            var sAddressUnstructured = person.getField(opensocial.Person.Field.CURRENT_LOCATION).getField('formatted');
 
            // Get GPS coordinates:
            var sLocation = getLocationFromAddress(sAddressUnstructured);
 
            html.push('givenName: ' + sGivenName);
            html.push('<br>');
            html.push('familyName: ' + sFamilyName);
            html.push('<br>');
            html.push('gender:' + sGender);
            html.push('<br>');
            html.push('unstructured address: ' + sAddressUnstructured);
            html.push('<br>');
        }
        catch (err) {
 
            html.push('<div class="yap-error">error! ' + err + '</div>');
        }
        return html.join('');
    }
 
    function getLocationFromAddress(location) {
 
        var BASE_URI = 'http://query.yahooapis.com/v1/public/yql?format=json&q=';
 
        function handler(rsp) {
            var latitude = rsp.data.query.results.place.centroid.latitude;
            var longitude = rsp.data.query.results.place.centroid.longitude;
 
            document.getElementById('divProfile').innerHTML = document.getElementById('divProfile').innerHTML + "<br/> latitude: " + latitude + "<br/> longitude" + longitude;
        }
 
        var params = {};
        params[gadgets.io.RequestParameters.CONTENT_TYPE] = gadgets.io.ContentType.JSON;
        params[gadgets.io.RequestParameters.METHOD] = gadgets.io.MethodType.GET;
 
        var yqlQuery = BASE_URI + escape("select centroid from geo.places where text='" + location + "'");
 
        gadgets.io.makeRequest(yqlQuery, handler, params);
 
    }
 
    gadgets.util.registerOnLoadHandler(function() {
        getProfile();
    });         
 
</script>
<div id="yap-app">
    <h1>
        YAP OpenSocial/YQL/Geo Demo</h1>
    <h3>
        Your Profile</h3>
    <div id="divProfile">
        <div>
            Loading Profile...</div>
    </div>    
</div>

<script type='text/javascript' src="/Javascript/jquery-latest.min.js"></script>
<script type='text/javascript' src="/Javascript/jquery-jtemplates.js"></script>    
 
<script type="text/javascript">
 
    $(document).ready(function () {
        GetRandomProduct();
        setInterval(GetRandomProduct, 30000);
 
    });
 
    function GetRandomProduct(day) {
        var service_URL = BASE_URL + 'books';
        $.ajax({
            url: service_URL,
            dataType: 'json',
            success: function (data) {
                // alert("response:" + data);
 
                if (data == null) {
                    // alert("No response recieved!")
                    return;
                }
                else if (data.Payload.length == 0) {
                    return;
                }
                $("#FeaturedProduct").setTemplateElement("productTemplate");
                $("#FeaturedProduct").processTemplate(data.Payload);
 
            },
            error: function (error, type, exception) {
                //alert(error); alert(type); alert(exception); 
            }
        });
    }
</script>
<div class="outerbox" id="FeaturedProduct">
</div>
<textarea id="productTemplate" style="display: none"> 
 <div class="outerbox"> 
	<div class="box featured"> 
		<h2 > 
			Featured</h2> 
		<div class="item"> 
			<div class="bord-se"> 
				<div class="bord-ne"> 
					<div class="bord-s"> 
						<a href="/store/Product.aspx?ProductId={$T.ProductId}&utm_source=Homepage&utm_medium=FeaturedProd&utm_term=Widget&utm_campaign=Featured_Widget" id="A1"> 
							<img class="FeaturedProduct" src="{$T.ThumbnailUrl}" alt="featured" style="border-width:0px;" /> 
						</a> 
					</div> 
				</div> 
			</div> 
		</div> 
		<h4> 
			<a href="/store/Product.aspx?ProductId={$T.ProductId}&amp;utm_source=Homepage&amp;utm_medium=FeaturedProd&amp;utm_term=Widget&amp;utm_campaign=Featured_Widget">{$T.Name}</a></h4> 
		<p> 
			<span>Author: </span> 
			<a href="/store/search.aspx?m={$T.AuthorId}">{$T.Author}</a><br /> 
			<span class="Price"> 
				${$T.Price}</span><br /> 
 
            {$T.Summary}				
 
			<a class="more" href="/store/New-Products-C52.aspx">view all&hellip;</a> 
		</p> 		
	</div>
</div>  
 
</textarea>

 
            string key = "1234567891123456";
            string secret = @"Sometimes I sing Shania Twain's ""I Feel Like A Woman!"" in the shower.";
 
            Console.WriteLine("basic:");
            EncryptString(key, secret);
            Console.ReadKey();
 
            Console.WriteLine("salt the secret:");
            // good when there are multiple machines but a dynamic global shared secret (for example, Profile Create Date or User ID)
            string secret2 = secret + " ###" + DateTime.Now.Millisecond;
            EncryptString(key, secret2);
 
            secret2 = secret + " ###" + DateTime.Now.Millisecond;
            EncryptString(key, secret2);
 
            Console.ReadKey();
 
            Console.WriteLine("salt the key:"); 
            // good when the same machine encrypts/decrepts
            string uniqueMachineIdentifier = MachineId.GetProcessorID();
            Console.WriteLine("MachineId: " + uniqueMachineIdentifier);
            EncryptString(key + uniqueMachineIdentifier, secret);
            Console.ReadKey();
 
            Console.WriteLine("SHA1 hash the passphrase with a salt:"); 
            // note: talk about why hashing is good
            SHA1 sha = new SHA1CryptoServiceProvider();
            // This is one implementation of the abstract class SHA1.
            string password = "this is my user password and/or userid";
            byte[] saltedKey = Encoding.Default.GetBytes(key + password);
 
            byte[] result = sha.ComputeHash(saltedKey);
            EncryptString(Convert.ToBase64String(result), secret);
            Console.ReadKey();

Graphics backgroundGraphics;
backgroundImage = (Bitmap)Image.FromFile(AppDomain.CurrentDomain.BaseDirectory + "\\images\\Header.jpg");
backgroundGraphics = Graphics.FromImage(backgroundImage);
var font = new Font("Perpetua Titling MT", 24F, FontStyle.Regular);
backgroundGraphics.DrawString(authorname.ToUpper(), font, new SolidBrush(Color.FromArgb(100, 0, 0, 0)), 10, 5);

backgroundImage.Save(context.Response.OutputStream, ImageFormat.Jpeg);

Response.Status = "301 Moved Permanently";
Response.StatusCode = 301;
Response.AddHeader("Location", url);
Response.End();

";
< ?php
// change this this to strip old slugs if needed:
//update wp_posts set post_name = '' where guid like '%.asp'
set_time_limit(20000);
 
/** Loads the WordPress Environment and Template, allowing wp functions like the_title() */
define('WP_USE_THEMES', false);
require('./wp-blog-header.php');
 
function bleach($which)
{
    $result = sanitize_title(get_the_title($which));
    return $result;
}
 
$dbhost = 'data.mises.org';
$dbuser = 'mises_blog';
$dbpass = '5u7$^kjW8V';
$dbname = 'WordPress';
 
$sql = 'SELECT ID, post_title' . ' FROM `wp_posts`' . ' WHERE post_status = "publish"' . " and post_name = '' " . ' order by ID asc';
 
$db = mysql_connect($dbhost, $dbuser, $dbpass) or die('Could not connect: ' . mysql_error());
mysql_select_db($dbname);
 
$result = mysql_query($sql) or die('<b>Query failed: ' . mysql_error());
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
    $id         = $row['ID'];
    $title      = $row['post_title'];
    $clean_slug = bleach($id);
 
    echo "ID<i>:{$row['ID']} " . "post_title : {$title} " . "sanitized : {$clean_slug} ";
    $sql_u = "UPDATE `wp_posts` SET post_name = '" . $clean_slug . "' " . 'WHERE ID = ' . $id;
    echo '<b>QUERY:</b>' . $sql_u . '';
    mysql_query($sql_u) or die('ERROR: ' . mysql_error());
    flush();
}
 
mysql_close($db);
?>
</i></b>

UPDATE wordpress.wp_posts SET post_content = REPLACE(post_content,""","'");
UPDATE wordpress.wp_posts SET post_content = REPLACE(post_content,"“",'"');
UPDATE wordpress.wp_posts SET post_content = REPLACE(post_content,"”",'"');
UPDATE wordpress.wp_posts SET post_content = REPLACE(post_content,"‘","'");
UPDATE wordpress.wp_posts SET post_content = REPLACE(post_content,"’","'");
UPDATE wordpress.wp_posts SET post_content = REPLACE(post_content,"ö","ö");
UPDATE wordpress.wp_posts SET post_content = REPLACE(post_content,"ü","ü");
UPDATE wordpress.wp_posts SET post_content = REPLACE(post_content,"é","é");
UPDATE wordpress.wp_posts SET post_content = REPLACE(post_content,"É","É");
 
UPDATE wordpress.wp_users SET display_name = REPLACE(display_name,"é","é");
UPDATE wordpress.wp_users SET display_name = REPLACE(display_name,""","'");
UPDATE wordpress.wp_users SET display_name = REPLACE(display_name,"“",'"');
UPDATE wordpress.wp_users SET display_name = REPLACE(display_name,"”",'"');
UPDATE wordpress.wp_users SET display_name = REPLACE(display_name,"‘","'");
UPDATE wordpress.wp_users SET display_name = REPLACE(display_name,"’","'");
UPDATE wordpress.wp_users SET display_name = REPLACE(display_name,"ö","ö");
UPDATE wordpress.wp_users SET display_name = REPLACE(display_name,"ü","ü");
UPDATE wordpress.wp_users SET display_name = REPLACE(display_name,"é","é");
 
 
UPDATE wordpress.wp_posts SET post_title = REPLACE(post_title,""","'");
UPDATE wordpress.wp_posts SET post_title = REPLACE(post_title,"“",'"');
UPDATE wordpress.wp_posts SET post_title = REPLACE(post_title,"”",'"');
UPDATE wordpress.wp_posts SET post_title = REPLACE(post_title,"‘","'");
UPDATE wordpress.wp_posts SET post_title = REPLACE(post_title,"’","'");
 
UPDATE wordpress.wp_posts SET post_title = REPLACE(post_title,"ö","ö");
UPDATE wordpress.wp_posts SET post_title = REPLACE(post_title,"ü","ü");
UPDATE wordpress.wp_posts SET post_title = REPLACE(post_title,"é","é");

 
USE `WordPress`;
 
/*  !!! Truncate tables to prevent primary key conflicts !!! */
TRUNCATE TABLE wp_posts;
TRUNCATE TABLE wp_comments;
TRUNCATE TABLE wp_users;
 
/* users from author */
INSERT INTO wp_users (
ID,
user_login,
user_pass,
user_nicename,
user_email,
user_url,
user_registered,
/* user_activation_key, */
user_status,
display_name
 
) (SELECT
author_id,
author_name,
author_password, /* fingers crossed */
IF (author_basename IS NOT NULL,author_basename,author_name) ,
author_email,
IF (author_url IS NOT NULL,author_url,' '),
author_created_on,
/* user_activation_key, */
author_status, 
IF (author_nickname IS NOT NULL,author_nickname,author_name) 
 FROM mtutf.mt_author); 
 
/*  post from entry */
INSERT INTO wp_posts (
ID,
post_author,
post_date,
post_date_gmt,
post_content,
post_title,
post_excerpt,
post_status,
comment_status,
ping_status,
/* post_password  */
post_name,
post_modified,
post_modified_gmt, /* --post_modified_gmt,  */
/* --post_content_filter,  */
/* --post_parent,  */
/* --guid,  */
/* --menu_order,  */
/* --post_type,  */
/* --post_mime_type,  */
comment_count,
to_ping,
pinged  
) (
SELECT
entry_id,
entry_author_id,
entry_created_on,
CONVERT_TZ(entry_created_on,'+00:00','-06:00'), /* GMT */
CONCAT(entry_text,'<!--more-->',entry_text_more) ,
entry_title,
entry_excerpt,
TRIM(CAST(entry_status AS CHAR)),
TRIM(CAST(entry_allow_comments AS CHAR)),
TRIM(CAST(entry_allow_pings AS CHAR)),
/* --post_password  */
entry_basename,
/* --to_ping  */
/* --pinged  */
entry_modified_on,
CONVERT_TZ(entry_modified_on,'+00:00','-06:00'), /* -- post_modified_gmt,  */
/* --post_content_filter,  */
/* --post_parent,  */
/* --guid,  */
/* --menu_order,  */
/* --post_type,  */
/* --post_mime_type,  */
entry_comment_count,
'',
''
 FROM mtutf.mt_entry);
 
 
INSERT INTO wp_comments (
comment_ID,
comment_post_ID,
comment_author,
comment_author_email,
comment_author_url,
comment_author_IP,
comment_date,
comment_date_gmt,
comment_content,
/* comment_karma, junk_score? */
/* comment_approved, comment_junk_status?? */
/* comment_agent, */
/* comment_type, */
comment_parent,
user_id
 ) ( SELECT
comment_id,
comment_entry_id,
comment_author,
comment_email,
comment_url,
comment_ip,
comment_created_on,
CONVERT_TZ(comment_created_on,'+00:00','-06:00'), /* comment_date_gmt, */
comment_text,
/* comment_karma, */
/* comment_approved, */
/* comment_agent, */
/* comment_type, */
comment_parent_id,
comment_created_by
 FROM mtutf.mt_comment WHERE comment_junk_status = 1);
 
 
UPDATE wp_posts SET post_status = 'publish', comment_status='open', ping_status='open';
 
/*  More... */
 
UPDATE 
wordpress.wp_posts, mises_blog.mt_entry
 
SET post_content = CONCAT(CONCAT(entry_text,'<!--more-->'), entry_text_more)
 
WHERE LENGTH(entry_text_more) > 0 
AND 
mises_blog.mt_entry.entry_id = wp_posts.id
 
 
/* Specific to our DB: */
 
UPDATE wordpress.wp_posts SET guid = CONCAT('http://blog.mises.org/archives/', RIGHT(CONCAT('000000', ID),6), ".asp");
 
 
/* Set User Contributor Levels */
 
INSERT INTO wp_usermeta
(
user_id,
meta_key,
meta_value
)
(
SELECT 
id,
'wp_user_level',
1
FROM wp_users
WHERE id  NOT  IN (2,295,3)
);
 
INSERT INTO wp_usermeta
(
user_id,
meta_key,
meta_value
)
(
SELECT 
id,
'nickname',
display_name
FROM wp_users
WHERE id  NOT  IN (3,295)
)
 
INSERT INTO wp_usermeta
(
user_id,
meta_key,
meta_value
)
(
SELECT 
id,
'wp_capabilities',
meta_value = 'a:1:{s:6:"author";b:1;}' 
FROM wp_users
WHERE id  NOT  IN (2,295,3)
)