/**
* Function handles the response from the popup windows search request, the
* function name italm_ajax_it is a little misleading as there is no longer
* any ajax stuff going on.
*
* @global $wpdb
*/
function italm_ajax_it()
{
global $wpdb;
$tableName = $wpdb->prefix . 'italm';
$linkname = ita_sanitize_title(isset($_POST['linkname']) ? $_POST['linkname'] : '');
$linkUrl = isset($_POST['linkurl']) ? $_POST['linkurl'] : '';
$linkImage = isset($_POST['linkimage']) ? $_POST['linkimage'] : '';
$linkResult = $wpdb->get_row('SELECT * FROM ' . $tableName . ' WHERE linkUrl = \'' . $linkUrl . '\';', ARRAY_A);
$maskedUrl = get_option('siteurl') . '/' . ita::setting('ita-maskurl') . '/%s';
if (sizeof($linkResult) < 1) {
$wpdb->insert($tableName, array('linkName' => $linkname, 'linkUrl' => $linkUrl, 'updateTime' => time()), array('%s', '%s', '%d'));
$linkResult = $wpdb->get_row('SELECT * FROM ' . $tableName . ' WHERE linkUrl = \'' . $linkUrl . '\';', ARRAY_A);
} else {
$wpdb->update($tableName, array('updateTime' => time()), array('linkUrl' => $linkUrl), array('%d'), array('%s'));
}
if (ita::setting('ita-maskenable') == '1') {
$maskedUrl = sprintf($maskedUrl, str_replace(array(' ', '.'), array('_', ''), $linkResult['linkName']));
} else {
$maskedUrl = $linkUrl;
}
die('top.itaToEditor(\'' . $linkname . '\',\'' . $linkUrl . '\',\'' . $linkImage . '\');top.itaOk( );');
}
$newlink = urldecode(trim(str_replace($options['partnerUrl'], '', $link['linkUrl'])));
$newlink = str_replace('&partnerId=' . $options['partnerId'], '', $newlink);
$updates[$linkid]['url'] = $newlink;
$updates[$linkid]['name'] = $link['linkName'];
}
}
}
// If proceed has been submitted
if (isset($_GET['proceed'])) {
// Check for the proceed token, allow through if it's correct
$token = get_option('italm-upgrade-token', '');
if (trim($token) != "" && $_GET['proceed'] == $token) {
foreach ($updates as $id => $link) {
print "[" . $id . "] Updating " . $link['name'] . " to " . $link['url'] . "<br/>";
$url = $link["url"];
$newLinkName = ita_sanitize_title($link["name"]);
if (!$wpdb->update($tableName, array('linkUrl' => $url, 'linkName' => $newLinkName), array('linkid' => $id), array('%s'), array('%d'))) {
}
}
update_option('ita-partner', $options['partnerId']);
update_option('ita-partnerurl', $options['partnerUrl']);
update_option('ita-version', '0.1');
$wpdb->query($wpdb->prepare("DELETE FROM wp_options WHERE option_name = %s;", 'italm-upgrade-token'));
} else {
$err = '<div class="wrap"><h2>Error Upgrading iTALM</h2><div class="error" ><p><strong>Error Upgrading</strong> - Please return to <a href="' . admin_url("options-general.php?page=itunes-affiliate-link-maker/ita.class.admin.php&italm=upgrade") . '">upgrade page</a></p></div></div>';
print $err;
}
print "All done.";
} else {
$tokenval = md5(time() . get_option('siteurl'));
update_option('italm-upgrade-token', $tokenval);
