add_message($usr);
//save to db
add_acct_db(array('cpid' => $acc_id, 'db' => $databasename, 'dbuser' => $databaseuser, 'dbpass' => encrypt($databasepass)));
} else {
add_message("Can not create user , no provide db user & pass");
}
}
if ($task == 'adduser' || $task == 'binduserdb') {
//add user to db
if ($databaseuser && $databasename) {
$cpanel_mysql = HW_CPanel_Mysql::init($cpanel);
$addusr = $cpanel_mysql->add_user2db($databaseuser, str_replace($cpaneluser . '_', '', $databasename));
add_message($addusr);
//save to db
$databasepass = '';
$res_db = get_acct_dbs($acc_id, " and dbuser='******' limit 1");
if ($res_db) {
$row = $res_db->FetchRow();
if (count($row)) {
$databasepass = $row['dbpass'];
}
}
add_acct_db(array('cpid' => $acc_id, 'db' => $databasename, 'dbuser' => $databaseuser, 'dbpass' => $databasepass));
} else {
add_message("can not add user to db, no provide user & db name");
}
}
}
invalid:
//delete db from manager
if (_get('do') == 'del_db_from_manager' && is_numeric(_get('id'))) {
/**
* run sql to fixed url base in wordpress that stored in wp_posts, wp_postmeta,wp_options
* @param $cp
*/
function wp_sql_fixedbaseurl($cp)
{
$db = _post('db');
$dbuser = _post('dbuser');
$where = '';
if ($db) {
$where .= " and db='{$db}' ";
}
if ($dbuser) {
$where .= " and dbuser='******' ";
}
$dbs = get_acct_dbs($cp->acc_id, $where);
if ($dbs) {
$dbs = $dbs->FetchRow();
}
if (is_array($dbs) && count($dbs)) {
$cmd = _post('cmd');
//contain command file
$find = _post('findstr');
//what to find?
$repl = _post('replacestr');
//replace with ?
$save = WHM_CPANEL_SHELL_APP . "/x_ssh/commands";
//modify cmd file, do not put -D param before dbname
//https://my.bluehost.com/cgi/help/112
$txt = "mysql -p -u {$cp->cpaneluser}_{$dbs['dbuser']} {$cp->cpaneluser}_{$dbs['db']} < wp_fixedbaseurl_mysql.sql\r\nread -n1 -r -p 'Press any key to continue...' key";
file_put_contents($save . '/' . $cmd, $txt);
//create sql file
$sql = 'update wp_options set option_value=REPLACE(option_value,"' . $find . '","' . $repl . '");' . PHP_EOL;
$sql .= 'update wp_posts set post_content=REPLACE(post_content,"' . $find . '","' . $repl . '");' . PHP_EOL;
$sql .= 'update wp_posts set guid=REPLACE(guid,"' . $find . '","' . $repl . '");' . PHP_EOL;
$sql .= 'update wp_postmeta set meta_value=REPLACE(meta_value,"' . $find . '","' . $repl . '");' . PHP_EOL;
file_put_contents($save . '/wp_fixedbaseurl_mysql.sql', $sql);
//upload .sql file to server
$cpanel_file = $cp->get_instance('fileman_no_auth');
$res = $cpanel_file->uploadfiles(array('fullpath' => "{$save}/wp_fixedbaseurl_mysql.sql", 'type' => '', 'name' => 'wp_fixedbaseurl_mysql.sql'), '/');
ajax_output($res);
//run batch file
$cp->run_command();
}
}
/**
* list saved acc dbs
* @param $data
*/
function listsaved_acc_dbs($data)
{
$list_dbs = get_acct_dbs($data->acc_id);
echo '<table border="1px" cellpadding="3px" cellspacing="1px" class="hover-table">
<tr>
<td><strong>ID</strong></td>
<td><strong>CPID</strong></td>
<td><strong>cpanel domain</strong></td>
<td><strong>cpanel user</strong></td>
<td><strong>cpanel email</strong></td>
<td><strong>DB</strong></td>
<td><strong>DB User</strong></td>
<td><strong>DB Pass</strong></td>
<td></td>
</tr>';
while ($row = $list_dbs->FetchRow()) {
echo '<tr>';
echo "<td><strong>{$row['autoID']}</strong></td>";
echo "<td>{$row['id']}</td>";
echo "<td>{$row['cpanel_domain']}</td>";
echo "<td>{$row['cpanel_user']}</td>";
echo "<td>{$row['cpanel_email']}</td>";
echo "<td>{$row['db']}</td>";
echo "<td>{$row['dbuser']}</td>";
echo "<td>" . decrypt($row['dbpass']) . "</td>";
echo '<td><a href="javascript:void(0)" onclick="hw_deldb_fromlocal(' . $row["id"] . ');">Del from db</a></td>';
echo '</tr>';
}
echo '</table>';
echo '<div>Chú ý: Nhập chỉ số ID trong tool cài đặt WP tự động để cấu hình wp-config.php</div>';
}
