SCRIPT EVIDENTA LIVE v2.0 [FREE]

[RGK]*Kent · 29 Oct 2022, 12:46

Salutare, ma poate ajuta cineva cu o evidenta live web, asta nu vad ca ar merge, update un link ceva tutorial?

29 Oct 2022, 14:45

[RGK]*Kent wrote: ↑
29 Oct 2022, 12:46
Salutare, ma poate ajuta cineva cu o evidenta live web, asta nu vad ca ar merge, update un link ceva tutorial?

Sunt bune, le-am folosit si eu .

[RGK]*Kent · 30 Oct 2022, 01:34

alynut wrote: ↑
29 Oct 2022, 14:45

[RGK]*Kent wrote: ↑
29 Oct 2022, 12:46
Salutare, ma poate ajuta cineva cu o evidenta live web, asta nu vad ca ar merge, update un link ceva tutorial?
Sunt bune, le-am folosit si eu .

ma poti ajuta? add steam https://steamcommunity.com/profiles/76561198116761861

SHINEROYAL · 16 Nov 2022, 02:44

Merge evidenta.
Iti creaza o pagina alba, pe centru afiseaza username | IP | si nu mai stiu ce.
Daca te descurci putin iti faci ceva dragut din ceea ce este postat mai sus.
Edit;
Exemplu inainte/dupa
https://imgz.cloud/ib/kplNvVdllBeqIAv_1709309809.jpg
https://imgz.cloud/ib/kplNvVdllBeqIAv_1709309809.jpg

[RGK]*Kent · 01 Mar 2024, 00:08

Salut, revenit la acest script.
Da merge dar dropeaza doar la serverul in care e instalat.
pe mine ma intereseaza un script ca toti clientii mei din ms sa vad pe ce servere se duc.
Stie cineva?

Xeno985 · 01 Mar 2024, 22:01

Salut, am modificat putin codul PHP si ti-am facut putin "design"

si editat codul

index.php | Afiseaza codul

<!DOCTYPE html>
<html>
	<head>
		<meta charset="utf-8" />
		<meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1" />
		<meta name="viewport" content="width=device-width, initial-scale=1.0, maximum-scale=1.0">

		<title>Live Evidence</title>

		<script src="https://code.jquery.com/jquery-2.2.2.min.js" integrity="sha256-36cp2Co+/62rEAAYHLmRCPIych47CvdM+uTBJwSzWjI=" crossorigin="anonymous"></script>

		<style type="text/css">
			* {
				background-color: #212121;
				color: #f5f5f5;
			}
			#evidenta {
				margin-top: 50px;
			}
			table thead tr th {
				font-weight: bold;
				color: #cf5951;
			}
			table thead tr th,
			table tbody tr td {
				width: 200px;
				height: 50px;
				text-align: center;
			}
			table {
				border-top: 1px solid #f5f5f5;
				border-left: 1px solid #f5f5f5;
				border-right: 1px solid #f5f5f5;
				border-spacing: 0;
			}
			th, td {
				border-bottom: 1px solid #f5f5f5;
				border-spacing: 0;
			}
		</style>
	</head>
	<body>
		<center>
			<div id="evidenta"></div>
		</center>
	</body>
	<script type="text/javascript">
		$(document).ready(function() {
			$.ajaxSetup ({
				cache: false
			});
			var refreshId = setInterval(function() {
				$('#evidenta').load('stats.php');
			},1000);
		});
	</script>
</html>

stats.php | Afiseaza codul

<?php

// Set database
$DB_HOST = "localhost"; //Database hostname
$DB_USER = "root";      //Database username
$DB_PASS = "";          //Database password
$DB_NAME = "m2";        //Database name

// Create connection
$pdo = new PDO("mysql:host=".$DB_HOST."; dbname=".$DB_NAME.";charset=utf8", $DB_USER, $DB_PASS);

// Check connection
if (!$pdo->getAttribute(PDO::ATTR_CONNECTION_STATUS)) {
    die("MySQL connection failed");
}

// Create query to extract data
$result = $pdo->prepare("SELECT * FROM `drops` ORDER BY `id` DESC LIMIT 150");
$result->execute();

// Check if exist something in database
if ($result->rowCount() > 0) {
    // Output the results (create table head)
    print "<table><thead><tr><th>REDIRECT</th><th>PORT</th><th>PLAYER</th><th>IP</th><th>COUNTRY</th></tr></thead><tbody>";
    foreach($result->fetchAll(PDO::FETCH_ASSOC) as $row) {
        // Create table body
        $r = "<tr>";
        $r .= "<td>".$row['Redirect']."</td>";
        $r .= "<td>".$row['Port']."</td>";
        $r .= "<td>".$row['Name']."</td>";
        $r .= "<td>".$row['IP']."</td>";
        $r .= "<td>".$row['Country']."</td>";
        $r .= "</tr>";
        print $r;
    }
    print "</tbody></table>";
} else {
    print "0 results";
}

?>

Ti-am creat conectiune PDO sa fie mai sigur si inca o chestie importanta, cand lucrezi cu baze de date, creaza pentru fiecare tabel in parte o coloana ID ca si cheie primara cu auto increment (folosita pentru a ordona datele crescator/descrescator si pentru ca fiecare rand sa aibe un id unic prin care sa il poti gasi in baza de date).
Important de asemenea cand creezi un query sa indici specific cu ghilimele tip apostrof tablele, iar string-urile cu ghilimele simple sau duble!

Code: Select all

CREATE TABLE `drops` (
  `id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
  `Redirect` varchar(255) DEFAULT NULL,
  `Port` varchar(255) DEFAULT NULL,
  `Name` varchar(255) DEFAULT NULL,
  `IP` varchar(255) DEFAULT NULL,
  `Country` varchar(255) DEFAULT NULL
);

INSERT INTO `drops` (`id`, `Redirect`, `Port`, `Name`, `IP`, `Country`) VALUES
(1, '94.153.237.28', '27015', 'TesT PlayeR', '181.203.240.133', 'Chile'),
(2, '127.0.0.1', '27016', 'Kiloko', 'localhost', 'Romania');

Succes si sper sa nu te superi ca ti-am editat putin munca

SCRIPT EVIDENTA LIVE v2.0 [FREE]

Who is online