Question   Is it possible to copy our current database of members from one software to another?

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. There is upload/download via csv features.  The database itself you do not have access to (unless you are doing a cloud/dedicated server), however we can provide you with backups or make changes to it for you as needed.

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.