/** * 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);