/**
* Create user for video conference
*/
function createUser($displayName = "Participant")
{
$username = generateUsername(10);
$url = API_URL . "AddUser/?" . "account_name=" . ACCOUNT_NAME . "&api_key=" . API_KEY . "&user_name=" . $username . "&user_display_name=" . $displayName . "&user_password=" . PASS;
$result = httpRequest($url);
return array('api_result' => json_decode($result, true), 'username' => $username);
}
$rs_itemsQ = mysql_query($sql_itmesQ) or die(mysql_error());
$cartitems = array();
if (mysql_num_rows($rs_itemsQ) > 0) {
while ($itemsRow = mysql_fetch_array($rs_itemsQ)) {
$cartitems[] = $itemsRow['cart_id'];
}
$cartitemslist = implode("','", $cartitems);
// Delete Cart Items which already exists
$sql_Delitems = "DELETE FROM " . $tableprefix . "cart where cart_id IN ('" . $cartitemslist . "') ";
$rs_Delitems = mysql_query($sql_Delitems) or die(mysql_error());
}
// End Check
}
} else {
$userstring = strtolower(substr($txtBillingFirstName, 0, 3));
$get_username = generateUsername(6, 2);
if ($userstring != '') {
$username = $userstring . $get_username;
}
$guest_password = generatePassword(6, 2);
$sql = "INSERT INTO " . $tableprefix . "users (\n\t\t\t\t\t\t\tuser_name,\n\t\t\t\t\t\t\tpassword,\n\t\t\t\t\t\t\tfirst_name,\n\t\t\t\t\t\t\tlast_name,\n\t\t\t\t\t\t\taddress1,\n\t\t\t\t\t\t\taddress2,\n\t\t\t\t\t\t\tcity,\n\t\t\t\t\t\t\tstate,\n\t\t\t\t\t\t\tcountry,\n\t\t\t\t\t\t\tphone,\n\t\t\t\t\t\t\tfax,\n\t\t\t\t\t\t\tzip,\n\t\t\t\t\t\t\temail,\n\t\t\t\t\t\t\tdate_registered\n\t\t\t\t\t\t\t) VALUES (\n\t\t\t\t\t\t\t'" . mysql_real_escape_string($username) . "',\n\t\t\t\t\t\t\t'" . mysql_real_escape_string(md5($guest_password)) . "',\n\t\t\t\t\t\t\t'" . mysql_real_escape_string($txtBillingFirstName) . "',\n\t\t\t\t\t\t\t'" . mysql_real_escape_string($txtBillingLastName) . "',\n\t\t\t\t\t\t\t'" . mysql_real_escape_string($txtBillingAddress1) . "',\n\t\t\t\t\t\t\t'" . mysql_real_escape_string($txtBillingAddress2) . "',\n\t\t\t\t\t\t\t'" . mysql_real_escape_string($txtBillingCity) . "',\n\t\t\t\t\t\t\t'" . mysql_real_escape_string($txtBillingState) . "',\n\t\t\t\t\t\t\t'" . mysql_real_escape_string($ddlBillingCountry) . "',\n\t\t\t\t\t\t\t'" . mysql_real_escape_string($txtBillingPhone) . "',\n\t\t\t\t\t\t\t'" . mysql_real_escape_string($txtBillingFAX) . "',\n\t\t\t\t\t\t\t'" . mysql_real_escape_string($txtBillingZIP) . "',\n\t\t\t\t\t\t\t'" . mysql_real_escape_string($txtBillingEmail) . "',\n\t\t\t\t\t\t\tnow()\n\t\t\t\t\t\t\t)";
mysql_query($sql) or die(mysql_error());
$userid = mysql_insert_id();
$_SESSION["sess_guest_login_id"] = $userid;
$_SESSION["sess_guest_username"] = $username;
$_SESSION["sess_guest_password"] = $guest_password;
}
$_SESSION["sess_userid"] = $userid;
// Update Cart with User Id
if ($_SESSION["sess_userid"] != '') {
$sql_up = "UPDATE " . $tableprefix . "cart set user_id ='" . $_SESSION["sess_userid"] . "' ,visitor_cart_id='NULL' where visitor_cart_id ='" . session_id() . "' ";
