Question   Do I get access to the SQL database?

A. The code below can be used to modify the paths used inside of WordPress when transferring to a new domain, or to a new path on the same domain. Only run the file once and then delete it from the server. Also, first backup the database incase you run into any issues.

<?php
include("dbconn.php");

$wpDB = "vsnwp"; //WordPress Database Name
$wpOldPath = "domain.com/blog"; //The old path to WordPress content
$wpNewPath = "new-domain.com"; //The new path to WordPress content

mysql_select_db($wpDB);
 
 
$results = $mysqli->query("SELECT * FROM wp_posts WHERE guid LIKE '%".$wpOldPath."%'");
$numrows = $results->num_rows;
while($resRow = $results->fetch_assoc())
{
	$tID = $resRow["ID"];
	$tGuid = $resRow("guid");
	$tGuid = str_replace($wpOldPath, $wpNewPath, $tGuid);
	if (!get_magic_quotes_gpc()) $tGuid = addslashes($tGuid);
	$mysqli->query("UPDATE wp_posts SET guid='".$tGuid."' WHERE ID=".$tID);
}

$results = $mysqli->query("SELECT * FROM wp_posts WHERE post_content LIKE '%".$wpOldPath."%'");
while($resRow = $results->fetch_assoc())
{
	$tID = $resRow["ID"];
	$tGuid = $resRow["post_content"];
	$tGuid = str_replace($wpOldPath, $wpNewPath, $tGuid);
	if (!get_magic_quotes_gpc()) $tGuid = addslashes($tGuid);
	$mysqli->query("UPDATE wp_posts SET post_content='".$tGuid."' WHERE ID=".$tID);
}


$results = $mysqli->query("SELECT * FROM wp_postmeta WHERE meta_value LIKE '%".$wpOldPath."%'");
while($resRow = $results->fetch_assoc())
{
	$tID = $resRow["meta_id"];
	$tGuid = $resRow["meta_value"];
	$tGuid = str_replace($wpOldPath, $wpNewPath, $tGuid);
	if (!get_magic_quotes_gpc()) $tGuid = addslashes($tGuid);
	$mysqli->query("UPDATE wp_postmeta SET meta_value='".$tGuid."' WHERE meta_id=".$tID);
}
?>


Additional Steps:
Make sure to update wp_options table where you see former domain name to using the new domain.
In WP Multisite (Our WP Replicating Blog feature) you must also update the wp_blogs table where you see the old domain in the domain field for each site.

A. Yes, to do this you would create a contact group for the page and assign the piggyback page to the contact group. After doing that you can edit the contact notification message for the contact group so that it mentions the piggyback domain name.

A. Yes, infact you will need to purchase a domain name if you don't have one. A domain name doesn't cost much...

See our Price List for more details and PRICES (Click here to view)

A. Inside the client admin there is a way to easily add email accounts for a site and you do not need this guide.

NOTE: This guide is intended for developers working on systems that have a dedicated server.

Every server has a database titled: wmtserver

Inside of this database there is a table titled: emailaccounts

You can manually create email accounts by inserting them into the emailaccounts table.

Below is an explination of each column in the emailaccounts table:
email: The email address.  Do not include @domainname.com.  So for example if you are making an email myemail@mydomain.com then you should enter myemail into this field.
password: The password (without any encoding, salt, etc) of the email account.
siteid: This is the id of the site (domain) that the email belongs to.  You can get the siteid of a site by going into webmarketingtool.com and going to the page for the site and the page URL is site.php?id=# where # is the siteid for that site.
forwarding: If you want the email to forward to another email, enter the email address that it should forward to.  Otherwise leave this field blank.

A.

Domain Ordering

To buy domain, enter domain name in ~wmtsystemurl~/admin/domains### and click check availability as follows

If this domain name is available, you will be redirected to the payment page
After performing payment the domain will be added to your domain list as shown below



Click on domain link to manage it

b- Import a domain:


Note: Imported domain DNS needs to be set to the NS for the server the system is hosted on. Server must also be refreshed for these pages to begin functioning. Contact Web Marketing Tool to have the server refreshed.

2- Manage Domains

a- Set Home Page:
click on set home page button to set your new domain home page

b- Domain management options
You can renew your domain and set name servers as follow




C- Setup email
You can setup your emails @YourNewDomain as follow also you can setup forwards