Databases
StackOverflow2013
Postsdbo
POCreating an "anti-botting" system by adding values into the database
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POCreating an "anti-botting" system by adding values into the database
    primarykey
    data
    text
    <p>I have no clue on how to make this to work, so I'm just looking for ideas currently, let me explain what I want to make; Let's say I have a button named "click". Everytime I press this button, it adds 1 to the database, so when I have pressed it 10 times, it holds the value "10" in the database column named "clicks". This is already made though. I just need something that can check how fast I was pressing the button the 10 times to make an anti botting system. So I thought that making a column in the database named "time" this "time" column resets itself every 10 seconds and adds 1 to the column everytime the "click" button is pressed. Then I can make something in my PHP script like this: If time > 200 DELETE USER etc.</p> <p>So if a someone should be able to get the "time" column on 200 before it resets itself, it must be a bot pressing since it is not human-like to press that many times in only 10 seconds.</p> <p>I have read something about TIMESTAMP and INTERVAL but I cannot get it to woth the way I thought. I simply just need a column that will delete all data inside it, after a certain time.</p> <p>Any suggestions are welcome! Thanks in advance.</p> <p>I've come this far with the code:</p> <pre><code>if (isset($_POST['djahff'])) { // The button require_once('connectvars.php'); // The DB connection $dbc = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME); $idsession = $_SESSION['id']; $result = mysqli_query($dbc, "INSERT INTO pbclickslogin SET cps=1, id='$idsession' ON DUPLICATE KEY UPDATE cps=cps+1"); // Adding 1 to the column "cps" where username=$username $data = mysql_query("SELECT TIMESTAMPDIFF(SECOND, NOW(), mark) &gt; 10 FROM pbclickslogin WHERE username='$username'") // Checking if the difference from mark and now is 10 seconds I assume? or die(mysql_error()); while($info = mysql_fetch_array( $data )) { $result = mysqli_query($dbc, "UPDATE pbclickslogin SET cps='0', mark=NOW() WHERE username='$username'"); // Updating cps and mark because the difference from mark and now was 10 seconds. } } </code></pre> <p>The site updates everytime the button is pressed, it's a button made with input type "submit". </p> <p>Uhmm I didn't really understand you fully Algomorph but I assume it was because of my code posting mistakes. Sorry I am still new on this forum. Anyway I guess I have an update statement here etc.? Are there still the same problems as you mentioned before?</p> <p>Ps. Thanks for noticing me about the forum format</p> <p>I have now added a little more code:</p> <pre><code>if ($info[0] == 1) { $result = mysqli_query($dbc, "UPDATE pbclickslogin SET cps='0', mark=NOW() WHERE username='$username'"); // Updating cps and mark because the difference from mark and now was 10 seconds. } </code></pre> <p>The code however, never Update now. I tried with ($info['0'] == 1) aswell but with no luck unfortunatly. Besides that I don't really understand this now, what is $info[0]? Is it finding something inside the database that is 0 or something? I usually only use $info when calling on columns. Thanks again man :)</p> <p>Another few changes were added, the code we've got now is as followed:</p> <pre><code>if (isset($_POST['djahff'])) { // The button require_once('connectvars.php'); // The DB connection $dbc = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME); $idsession = $_SESSION['id']; $result = mysqli_query($dbc, "INSERT INTO pbclickslogin SET cps=1, id='$idsession' ON DUPLICATE KEY UPDATE cps=cps+1"); // Adding 1 to the column "cps" where username=$username $data = mysql_query("SELECT TIMESTAMPDIFF(SECOND, mark, NOW() ) &gt; 10 FROM pbclickslogin WHERE id='$idsession';") // Checking if the difference from mark and now is 10 seconds I assume? or die(mysql_error()); while($info = mysql_fetch_array( $data )) { if ($info[0] == 1) { $result = mysqli_query($dbc, "UPDATE pbclickslogin SET cps='0', mark=NOW() WHERE id='$idsession'"); // Updating cps and mark because the difference from mark and now was 10 seconds. } } } </code></pre> <p>to Algomorph: Why did you change NOW() ) > 10 to NOW() ) > 1000 by the way? Plus: The problem I am having at the moment is that when I press the button "djahff" it updates the timestamp "mark" but not the integer "cps". </p> <p>Thanks :-) - We're getting closer!</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USPaul R
    1. USPeterrr
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POCreating an "anti-botting" system by adding values into the database
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POCreating an "anti-botting" system by adding values into the database
      1. This table or related slice is empty.
      1. VTDownMod
    1. This table or related slice is empty.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload