Global Ban Database with EXE in progress.

  • Offline Mokey
  • Fractured Wasteland
  • Elite
  • ******
  • Posts: 606
  • Https://Fractured-Gaming.com

Global Ban Database with EXE in progress.

« posted: May 24, 2015, 02:31 PM »
I am currently working on a global ban list that I feel we could all use.

I will release more information on it later,, but here is a sneak peak at the start of it.

http://grabilla.com/05518-67229a47-f57d-4a55-9df8-f623d201a861.png
Global Ban Database with EXE in progress.
Posts once, edits post 40 times in 60 seconds. STUPID FAT FINGERS!
  • Offline lodac
  • Hardened
  • ****
  • Posts: 220
  • TOP Arma Server Admin

Re: Golbal Ban Database with EXE in progress.

« Reply #1 posted: May 24, 2015, 04:27 PM »
I am currently working on a global ban list that I feel we could all use.

I will release more information on it later,, but here is a sneak peak at the start of it.

http://grabilla.com/05518-67229a47-f57d-4a55-9df8-f623d201a861.png
Global Ban Database with EXE in progress.


nice.

it'd be so awesome if someone would code something like this.

https://github.com/l0dac/beCBL

Quote
BattlEye Community Ban List (ArmA3)

Goal is to provide a central banlist solution for A3Wasteland servers, although this could be extended to all server that use BattlEye bans.txt

Administration Interface, Different access levels (Group Admin, High Admin, Low Admin)
Administration Interface, Auditing for admin actions, requiring notes. Different admin levels provide different ban options.
Provide configurable canned reasons, messages, and time frames (configure what is display'd)
Provide groups, seperating server owners from other server owners, for different ban list options.
Provide hashed link to wget bans.txt (global) or different bans.txt based off Groups or Reasons.
Ability to upload BattlEye Logs to automatically phrase and add known hack menus to ban list.
All bans are unique id'd for history and repeal process.
Sample format

ff23fb86043512134535421545435ed2 -1 TOP #1 TeamKill indefinite - bans.becbl.com dd23fb8609bsfag434t34245a3c75ed2 -1 TOP #2 Exploit indefinite - bans.becbl.com ad34fbdsaf3243534ftga44ea3c75ed2 -1 AJ #3 Exploit indefinite - bans.becbl.com cc23fb8609b9a8ed2df7f44ea3c75ed2 1415673088 TOP #4 TeamKill 1 day - bans.becbl.com

GUID TIME GROUP UID REASON TIMEFRAME - REPEAL LINK

TOPArma Mission - Share your mission on GitHub
  • Offline Mokey
  • Fractured Wasteland
  • Elite
  • ******
  • Posts: 606
  • Https://Fractured-Gaming.com

Re: Golbal Ban Database with EXE in progress.

« Reply #2 posted: May 24, 2015, 11:10 PM »
That is what I am going to slowly turn this into. Every ban would have to be approved by the highest permission set. The only people with that permission would be the top ranked a3w server owners For the soul purpose that time in game and experience is in play for approval if bans.

Admins I would like to have these permissions to approve bans would be:
AgentRev
Micovery
CreamPie
Loud
Cael
lodac
Dwarden
Trailer Park Server Owner
Mayhem Server Owner
and maybe a few others (Forgive me if I do not know your names.)

I also would like some of these owners to help Beta test this once we get a working copy in play.

Please let me know if you can beta test.

I should have a working project by Sunday night. Then I will go from there.
Posts once, edits post 40 times in 60 seconds. STUPID FAT FINGERS!

Re: Golbal Ban Database with EXE in progress.

« Reply #3 posted: May 24, 2015, 11:15 PM »
Hum seems nice but tell me is this a offline app ? Can you elaborate a bit ? You got me curious on this
  • Offline Mokey
  • Fractured Wasteland
  • Elite
  • ******
  • Posts: 606
  • Https://Fractured-Gaming.com

Re: Golbal Ban Database with EXE in progress.

« Reply #4 posted: May 25, 2015, 01:02 AM »
So this is how it would work.

Register on the A3SB (ArmA3 Server Bans) Website.with the needed information.

A3SB staff approves your admin status (proven you are a server owner)

Follow the tutorial provided in the program to get A3SB to function properly.

You get a script log of a hacker or record some one cheating. (Ban him from your server)

You go to the AS3B  program. Log into the program using your credentials when registered on the site.

You fill out the information as shown on the screenshot.

Then you submit the ban. Then the ban gets sent to my webserver waiting for approval of global ban. The staff then approves the ban.

The ban then gets uploaded to the website and it will have public access to view bans. (The hacker can appeal his ban on this site of he finds his ban)

Server Owners running A3SB will either have a manual update button that places a ban.txt in you BE folder allocated by you when you set the program up.
I Really want to set this up with an SQL data base. That just auto updates.

Then done: all bans approved by A3SB staff will be global bans to anyone running A3SB (just like open source global bans)

There will also be a "remove ban" portion to remove a ban you have applied (will be approved by A3SB staff)

Alternatively you can use the website to submit a ban. The exe is more of an "ease of access" to ban.
Posts once, edits post 40 times in 60 seconds. STUPID FAT FINGERS!
  • Offline AgentRev
  • Developer
  • Veteran
  • ******
  • Posts: 2543

Re: Golbal Ban Database with EXE in progress.

« Reply #5 posted: May 25, 2015, 01:55 AM »
Sounds just like http://arma-banlist.de/ with the addition of ban reasons and ban appeals, although I don't like their closed nature. All information contained in the banlist should be googleable.
  • Offline Mokey
  • Fractured Wasteland
  • Elite
  • ******
  • Posts: 606
  • Https://Fractured-Gaming.com

Re: Golbal Ban Database with EXE in progress.

« Reply #6 posted: May 25, 2015, 01:58 AM »
Agreed. I hope a can get as much support from the A3W community as possible.
Posts once, edits post 40 times in 60 seconds. STUPID FAT FINGERS!

Re: Golbal Ban Database with EXE in progress.

« Reply #7 posted: May 25, 2015, 04:29 AM »
I like the idea if you need on anything just say
  • Offline Mokey
  • Fractured Wasteland
  • Elite
  • ******
  • Posts: 606
  • Https://Fractured-Gaming.com

Re: Golbal Ban Database with EXE in progress.

« Reply #8 posted: May 25, 2015, 07:29 AM »
Once I get an alpha teleased, I'll have a few willing server owners test it.
Posts once, edits post 40 times in 60 seconds. STUPID FAT FINGERS!

Re: Golbal Ban Database with EXE in progress.

« Reply #9 posted: May 25, 2015, 11:01 AM »
Ok, with this topic you gave me a idea so we can organize internally our bans.

I made a quick form to populate a new table called bans in our database, that table will be then pushed to our website so people can check if its banned and why its banned to make a ban appeal, or probably have other uses in the future.

But i think to share this here with you because i dont know if maybe it can help you or give you some ideas on what your are doing so here it is:

Its in his raw stage, and im not a expert at coding, more a frankenstein  but easily upgraded / adapted with more functions from here:

HTML FORM:
Code: [Select]
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Add Ban to Database</title>
</head>
<body>
<form action="insert.php" method="post">
    <p>
        <label for="playerName">Player Name:</label>
        <input type="text" name="playername" id="playerName">
    </p>
    <p>
        <label for="playerUID">Player UID:</label>
        <input type="text" name="playeruid" id="playerUID">
    </p>
    <p>
        <label for="playerGUID">Player GUID:</label>
        <input type="text" name="playerguid" id="playerGUID">
    </p>
<p>
        <label for="banReason">Ban Reason:</label>
        <input type="text" name="banreason" id="banReason">
    </p>
<p>
        <label for="banTime">Ban Time:</label>
        <input type="text" name="bantime" id="banTime">
    </p>
    <input type="submit" value="Add Ban">
</form>
</body>
</html>

PHP CODE
Code: [Select]
<?php
$link 
mysqli_connect("HOST""USER""PASS""DATABASE");

if(
$link === false){
    die(
"Could not connect to database. " mysqli_connect_error());
}

$player_name mysqli_real_escape_string($link$_POST['playername']);
$player_UID mysqli_real_escape_string($link$_POST['playeruid']);
$player_GUID mysqli_real_escape_string($link$_POST['playerguid']);
$ban_reason mysqli_real_escape_string($link$_POST['banreason']);
$ban_time mysqli_real_escape_string($link$_POST['bantime']);
 

$sql "INSERT INTO bans (Name, UID, GUID, Reason, Time) VALUES ('$player_name', '$player_UID', '$player_GUID', '$ban_reason', '$ban_time')";
if(
mysqli_query($link$sql)){
    echo 
"Ban added successfully.";
} else{
    echo 
"Could not added the ban $sql. " mysqli_error($link);
}
 

mysqli_close($link);
?>

SQL TABLE

Code: [Select]
DROP TABLE IF EXISTS `bans`;
CREATE TABLE `bans` (
  `Name` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `UID` varchar(255) CHARACTER SET utf8 NOT NULL,
  `GUID` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `Reason` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `Time` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`UID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  • Offline Mokey
  • Fractured Wasteland
  • Elite
  • ******
  • Posts: 606
  • Https://Fractured-Gaming.com

Re: Golbal Ban Database with EXE in progress.

« Reply #10 posted: May 25, 2015, 11:07 AM »
Thanks Defused, you pretty much answered my sql questions with this lol. Awesome, much appreciated.
Posts once, edits post 40 times in 60 seconds. STUPID FAT FINGERS!

Re: Golbal Ban Database with EXE in progress.

« Reply #11 posted: May 27, 2015, 05:40 AM »
No prob, already improve a bit with some more fields and pre defined dropdown with rules and etc.

I didnt share it since its configured for our site template and our server rules and details and adaptated to our personal needs it will be useless for you.

But if you want i can adapt it to your needs no problem.
  • Offline Mokey
  • Fractured Wasteland
  • Elite
  • ******
  • Posts: 606
  • Https://Fractured-Gaming.com

Re: Golbal Ban Database with EXE in progress.

« Reply #12 posted: May 27, 2015, 06:10 AM »
Yup, I have a 5 man dev team working on this now:) gotta love comp sci majors.

Btw, this will only be available to the A3W community until full release.

Alpha Phase- only available to appointed server owners
Beta Phase- Available to all A3W server owners (with admin sub users)
Release Phase- Available to all arma 3 server owners.(with admin sub users)

The Server Owners in Alpha phase are going to be the only people outside of development that will be able to approve bans. After Release l will open "staff" applications to the public.

Community bans are the most effective way to deal with hackers. Having appointed people approve/appeal bans will help to reduce wrongful bans.

All users will also go through an authentication server. No fake users. :)

I'll keep everyone updated as we go along.

If you want to be apart of alpha testing,  please PM me with your server info so when we reach alpha stage I can verify you are the server owner.

(Newer server owners will not be in alpha, sorry guys, experience counts for this.)
Posts once, edits post 40 times in 60 seconds. STUPID FAT FINGERS!
  • Offline LouD
  • Silent but deadly ;)
  • Moderator
  • Veteran
  • ******
  • Posts: 1415

Re: Golbal Ban Database with EXE in progress.

« Reply #13 posted: May 28, 2015, 03:36 PM »
Read your PM.