Jump to content


Go to solution Solved by loki951510,

Recommended Posts

Server version: 5.5.5-10.1.26-MariaDB

"INSERT INTO iplist (ip, master, count) VALUES ('$ipget', '1', '1') ON DUPLICATE KEY UPDATE master=values(master) + 1, count=values(count) + 1";
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `ip` varchar(255) NOT NULL,
  `master` varchar(255) NOT NULL DEFAULT '0',
  `vamps` varchar(255) NOT NULL DEFAULT '0',
  `curzed` varchar(255) NOT NULL DEFAULT '0',
  `count` varchar(255) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ip` (`ip`)

When posting the IP to the server if its not in the database it will get a new entry

or if the IP is already in the database it will add +1 onto the master table and add +1 to the count


but the the min if its already in the database it is putting 2 onto the master row and 2 into the count row and then if it goes a 3ed time it just stays on 2


what i would like it to do is to add +1 each extra time its added into the database

Link to post
Share on other sites

the goal is that when an IP is banned from one of my servers the IP is sent to the database if the IP has never been banned it will make a new entry to the database (as far as i can tell this part is working)  but if it is already in there it will add +1 to the IP entry what is already in there and add +1 to the count row as well (the part of the script i think is going wrong)


it's so i can see if there is any IP's what are getting banned more then others so i can permanently ban them if needed see attached pic



as you can see with IP (second on the list) MsT has been hit 2 times (but in my logs the IP has been banned 5 times but only showing 2) and VmH has been hit 1 time so the counts isnt going up over 2 where is should be 6

Link to post
Share on other sites
  • Solution

after looking though it all agen this moring  i can see where i was gong wrong

master=values(master) + 1, count=values(count) + 1
should of been just

master = master + 1, count = count + 1
its because it was pulling the values from the insert vaules and not the databse its self Edited by loki951510
Link to post
Share on other sites
This thread is more than a year old.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.