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>'; }