Question   Does your software have a centralized database that is upload/downloadable data?

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, the autoresponder can contain the details for the Members/Contacts using ~~ fields (exa: ~firstname~).

A. Yes, to copy over Members you would need to export the Members to a csv file from one software and then import them into the other software.

A.

Dedicated Server

Yes, phpMyAdmin. With a dedicated server ($100+ a month) through us you have phpMyAdmin access. 

Shared Hosting

With a shared hosting account you can use our database view page found on the site page to view the database (but not able to edit like phpMyAdmin).  For editing you have to do it via php code.

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.