SQLStats [Unmaintained]

Visagalis submitted a new resource:

SQLStats - Automatically logs various server events to MySQL database

Read more about this resource...

 

This is a wonderful plugin, very powerful. I've been testing it on my server and it is working extremely well.

Our stats are here:
[EU] BEST - European Rust Server

Want a list of players on your website that build the most on your server?

Connect to your SQL database -

Code:

<?php
$servername = "localhost";
$username = "sqldatabaseusername";
$password = "sqldatabasepassword";
$dbname = "sqldabasename";// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
     die("Connection failed: " . $conn->connect_error);
}
?>

Select specific sql data - create table -

Code:

<table><thead>
<tr>
<th data-column-id="name">Name</th>
<th data-column-id="kills" data-type="numeric">Building Parts Created</th>
</tr>
</thead>
<tbody>
                 
<?php
$sql = "SELECT name, SUM(count) FROM q_PlayerBuilds GROUP BY name ORDER BY SUM(count) DESC LIMIT 25";
$result = $conn->query($sql);if ($result->num_rows > 0) {
// output data of each row
while($row = $result->fetch_assoc()) {
echo "<tr><td>".$row["name"]."</td><td>".$row["SUM(count)"]."</td></tr>";
}
echo "</tbody>";
echo "</table>";
} else {
echo "0 results";
}
?>
</div>

Kill connection to sql -

Code:

<?php
$conn->close();
?>

 

Visagalis updated SQLStats with a new update entry:

1.0.2

 

This looks great!

 

I'd be happy if people who are using this plugin, could give links to their websites which displays statistics taken by this plugin, so I could show them as example of what could be achieved using this plugin.
You don't need to share website sources, just a website link.

 

Давно ждал подобного плагина, спасибо автору!

 

Added our site to the example above.

 

Thanks, added your site to Working examples.

 

You should incude a sample webpage for us!

 

That thing is WIP. Meanwhile you can check post by antisoma.

 

Ahh ok thanks!
[DOUBLEPOST=1450701613][/DOUBLEPOST]This is great, this could be the new stats plugin as the other one is outdated!

 

@Visagalis If the support for NoSQL Database is getting implemented will you think about a NoSQL Solution of this plugin ?

 

Seems AWESOME, though about the example... I ain't so good at working that out. Any tips where to get help coding own page n/or just adding those tables. I can fix somekinda crappy htlm page myself

Ps. Yeah this probably don't belong here..

 

Unfortunately Oxide itself doesn't support NoSQL
Oxide/Extensions at master · OxideMod/Oxide · GitHub

 

Is someone willing to help me setup stats on my website, i have a website but i want to add it to a page. If i uploaded the php file would you be able to help thanks!

 

That is why I requested it
Request - NoSQL database support | Oxide
That is why I said if the support of NoSQL Database is getting implemented

 

Visagalis updated SQLStats with a new update entry:

1.0.2b

 

Was the varchar length too short before ?

 

yeah, seems like some weapons have name with over 32 characters, i have no idea which

 

Maybe weapons WITH holosight and silencer