| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| QdbS - Quote database System :: Forums :: QdbS Support | |||
|
|||
 Are ip's of submitters logged anywhere? |
| Author | Post |
| csc2ya |
| ||
 Joined: Mon Aug 03 2009, 19:14:21 Posts: 10 | This will be partially solved when version 2.0 is released, since the captcha should stop most spam bots, but is there any way to find the ip of poeple that submit quotes in the current version? The reason for this is that I have had spam bots submitting quotes containing links to my database. I'm removing them when I notice them in the 'pending quotes' list, but it's pain to have to do this, and ideally i'd like to ban their ip's from even viewing the site. I can get the ip's from cpanel, but it would make it a lot easier to have it listed somewhere...even with the pending quotes in the admin section....then I wouldn't have to search through weeks worth of logs to find it. If it is not currently possible, is this something that could be considered for version 2? | ||
| Back to top |
| Jobe |
| ||
   Joined: Mon Oct 08 2007, 16:54:30 Posts: 35 | This is already a feature of version 2 as it stands. As for current versions with a few minor modifications you can have it log IP's at quote submission. If I remember correctly Eck has already done this so i'll see if I can get him to pass on the details for you. | ||
| Back to top |
| Eck |
| ||
 Posts: 10 | I've put something together for you. Download this, Extract it. With your bash-2.0 theme, replace "admin_block.tpl" with the one in that zip file. Also replace the QdbS' index.php file with the one in that zip file. admin-index.php needs to go in the /admin directory (replace /admin/index.php) ip.sql is updated SQL for qdbs_queue to allow IP's to be kept in there and then deleted after approval, so mysql -uuser -ppassword qdbs_database < ip.sql If you need further assistance, feel free to say. [ Edited Fri Oct 02 2009, 03:07:17 ] | ||
| Back to top |
| csc2ya |
| ||
Joined: Mon Aug 03 2009, 19:14:21 Posts: 10 | Thanks....i've made the changes and it works perfectly. I forgot the sql password, so I had to drop the existing qdbs_queue table, then import the sql file to recreate it with all the data, but I didn't have any pending quotes so that wasn't a problem. I submitted a test quote and it showed my ip next to it. Thanks again for the help. You've saved me a lot time searching through logs if poeple decide to spam my database. | ||
| Back to top |
| Eck |
| ||
Posts: 10 | You're welcome, Glad I could help. One last thing, even though it's not related to this topic. but it's related to your quote database. your front page is either corrupted or you've written it in some other encoding. Just a heads up. Screenshot [ Edited Sat Oct 03 2009, 07:10:39 ] | ||
| Back to top |
| csc2ya |
| ||
Joined: Mon Aug 03 2009, 19:14:21 Posts: 10 | yes...i'm aware of that problem, but can't find how to fix it. I originally edited the front page in notepad, and since then, it displays like that in firefox for some reason. I've been wondering how to fix that for ages, and it never occurred to me that it could be the encoding. I'll try and fix it later. | ||
| Back to top |
| csc2ya |
| ||
Joined: Mon Aug 03 2009, 19:14:21 Posts: 10 | Fixed....I originally edited it in wordpad and forgot to change the encoding to plain text when I saved it. I've now opened it, resaved it as plain text, then uploaded it again, and it now displays properly in firefox. | ||
| Back to top |
| Moderators: Jobe, Eck |
Welcome Online Latest Forum Posts
Re: It's been two years... Re: Restarting Qdbs - anybody interested? Re: Restarting Qdbs - anybody interested? Re: Restarting Qdbs - anybody interested? Restarting Qdbs - anybody interested?
