vb.org Archive
Page 3 of 4 12 3 4
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.6 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=194)
-   -   Administrative and Maintenance Tools - Log Logins Hack (https://vborg.vbsupport.ru/showthread.php?t=124907)

khris7199 04-18-2007 09:47 AM
Quote:
Originally Posted by Abe1 (Post 1230056)
Can you uninstall then re-install?

Doest show installed. That is the problem.

Had a DB crash. Was able to get a partial restore. And just have building on that.

Abe1 04-18-2007 11:09 AM
Quote:
Originally Posted by khris7199 (Post 1230310)
Doest show installed. That is the problem.

Had a DB crash. Was able to get a partial restore. And just have building on that.
Can you uninstall it?

khris7199 04-18-2007 10:33 PM
Quote:
Originally Posted by Abe1 (Post 1230347)
Can you uninstall it?
It does not show installed.

It was previously installed.

Had a DB crash.(this is where it was installed)

Restored most of the Database.

Ending up having to complete start a new forum. Use Impex to get my users and forums. (lost all post,pm,plugins.)

Rebuilt from there.

Now when I attempt to install I get the error above.

Abe1 04-18-2007 11:07 PM
Quote:
Originally Posted by khris7199 (Post 1230853)
It does not show installed.

It was previously installed.

Had a DB crash.(this is where it was installed)

Restored most of the Database.

Ending up having to complete start a new forum. Use Impex to get my users and forums. (lost all post,pm,plugins.)

Rebuilt from there.

Now when I attempt to install I get the error above.
Remove the code in the install part from the XML and then upload again.

khris7199 04-19-2007 12:10 AM
Worked You all are the greatest.

miki21 05-20-2007 05:00 PM
Bonjour

Merci beaucoup pour ce hack

@++

mpasternak 07-05-2007 12:12 PM
Works great!

however I'm having security issues with users trying to log in to other peoples accounts. Failing, But trying. I've had several email complaints from the users who had emails sent to them stating someone tried logging into their account.

Actually, I just wrote it myself. using your code as a base. Here are the mods I did.


My hack for Logging Failed attempts


Two files now need to be modified to enable it. (Backup everything first)

First
./includes/function_login.php

Now look for the section for "Exec_strike_User". there will be a query inserting a strike into the system. Right before or after the code "$strikes++;" add the following code.
Code:
$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "logins (userid, username, ipaddress, phpdate, logintype) VALUES (" . $vbulletin->userinfo['userid'] . ", '" . $vbulletin->db->escape_string($vbulletin->userinfo['username']) . "', '" . $vbulletin->db->escape_string(IPADDRESS) . "', " . TIMENOW . ", 'FAILED ATTEMPT')");
Save and update the file.


Now modify the following file
./adminCP/loginlog.php

Find the while loop
Code:
while ($log = $db->fetch_array($logs))
and add
Code:
else if ($log['logintype'] == 'FAILED ATTEMPT')
{
$log['logintype'] = "FAILED LOGIN";
}
now when you view the page, all failed logins will appear.

cmwg 07-20-2007 06:06 AM
Is it possible to modify the options of this hack to create a log file of all failed logins?
Would be good to be able to see the amount of attempts (reoccuring) on a single account.

SuperTaz 07-20-2007 08:00 AM
Great hack. Installed. :D

Abe1 07-20-2007 11:21 AM
Quote:
Originally Posted by cmwg (Post 1296296)
Is it possible to modify the options of this hack to create a log file of all failed logins?
Would be good to be able to see the amount of attempts (reoccuring) on a single account.
Would be a seperate hack. I'll see if I can creat something. I don't know if I would use a file though.

agilent 07-22-2007 05:23 PM
Thanks for this mod. I have a question. Can this mod back track logins prior to installation of the mod, or can it only see logins after it was installed?

eclectica 07-23-2007 07:18 AM
Quote:
Originally Posted by agilent (Post 1298385)
Can this mod back track logins prior to installation of the mod, or can it only see logins after it was installed?
It only works for those logins which occur after the installation of the mod. And it doesn't record automatic cookie logins.

mastertek2000 11-30-2007 09:12 PM
i tried everything can not see it in admin panel
thanks but did not work

redlabour 01-29-2008 05:02 PM
Does it still work in 3.7?

eclectica 01-30-2008 01:14 AM
It's working fine for me on vBulletin 3.7.

jpbryan 02-24-2008 04:15 PM
You done good... Thanks

pantec 02-25-2008 05:00 PM
GO TO STATISTICS & LOGS!

Quote:
Originally Posted by mastertek2000 (Post 1392596)
i tried everything can not see it in admin panel
thanks but did not work

kenc 03-01-2008 03:29 PM
looks good ... like an earlier poster said it wont show up automatically after installing, just hit F5/refresh after installing and now it'll show up as "Log Logins Hack" under "Statistics and Logs" section of the admin cp ...

Thanks for the hack - nice work!

-kenc

BigDog56 03-01-2008 11:41 PM
Looks like it's working fine on 3.6.8 Thank you very much!

rnixon 03-05-2008 09:26 AM
Essential info, many thanks.

AdrianH 03-28-2008 06:29 PM
Uninstalled today as it does not record all the log ins . Half those members logging in are missing from the log.

zween 03-30-2008 02:19 PM
Excellent. Big thanks. :up:

Abe1 04-06-2008 09:24 AM
Quote:
Originally Posted by CareyCrew (Post 1477013)
Uninstalled today as it does not record all the log ins . Half those members logging in are missing from the log.
Does not record if they do not log-in. eg. If they are logged in already.

jazde86 05-08-2008 11:10 AM
I get a error at the user profile of a new user, that registered after upgrading the forum to vB 3.7.0

Quote:
Datenbankfehler in vBulletin 3.7.0:
Invalid SQL:
INSERT INTO prefix_logins (userid, username, ipaddress, phpdate, logintype) VALUES (, 'eNrib', '??.75.??.220', 1210??8??2, '');
MySQL-Fehler : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' 'eNrib', '??.75.??.220', 1210??8??2, '')' at line 1
Fehler-Nr. : 1064
Fehler-Zeit : Thursday, 08.05.2008 @ 11:22:12
Datum : Thursday, 08.05.2008 @ 11:22:14
Skript : register.php?do=addmember
Referrer : register.php?do=register
IP-Adresse : ??.75.??.220
Benutzername : eNrib
Klassenname : vB_Database
MySQL-Version :
I'vo to do Maintenance at PhotoPost vBGallery to get it working. But everytime, after a new user has added.

AdrianH 05-08-2008 02:02 PM
Quote:
Originally Posted by Abe1 (Post 1484219)
Does not record if they do not log-in. eg. If they are logged in already.

Your quote from the description of this hack :

Quote:
About this hack:
This hack will log the userid, username, ipaddress, where the login is, and time all your users log onto your forum.
It simply did not do this,people log in to the forum and at least 50% were NOT recorded , I could see members log in,check the times etc in member list but they were not recorded in this hack.

Abe1 05-11-2008 03:00 AM
Quote:
Originally Posted by CareyCrew (Post 1512697)
Your quote from the description of this hack :



It simply did not do this,people log in to the forum and at least 50% were NOT recorded , I could see members log in,check the times etc in member list but they were not recorded in this hack.
You are thinking as log in, to go to your site.

Log is is used here strictly to use the log-in form.

deLi_kurT 05-23-2008 09:33 AM
Thanks - installed

MattLuria 06-26-2008 10:22 PM
Got it installed and it works wonderfully!

vithorius 07-21-2008 03:59 PM
Very nice hack, but its time to upgrade my board... :p :rolleyes: :eek:

Nyone know if this hack works with vB 3.7.x? :confused:


Thank you so very much! :up: :up: :up:

Ingress 07-22-2008 02:16 PM
If you browse a bit through this thread, you will find https://vborg.vbsupport.ru/showthread.php?p=1432160.

And of course mine does work, too ;-)

Ingress

eclectica 07-28-2008 01:08 PM
It works on 3.7.2

AWS3 08-20-2008 09:26 PM
I've just installed it - works great on vb 3.7.2 PL2
but I don't want to log all of my users. How to log users who belong to individual groups, for example I want to log user belong to groups: 5,6,7?

IrPr 10-25-2008 12:42 PM
Such a usefull mo, Thanks Abe

Suggestion/Request:
Every time im lookin for specified IP address i've to query logins table using ssh/phpmyadmin/admincp queries
it would be great if you add some more searching tips in admincp interface such as ipaddress

ewelin 05-06-2009 01:34 PM
Hello,

I really like this MOD but I felt as though it left a lot of room for improvement. I've added some features to it and I'd be happy to share them with you if you plan on releasing an update. Main changes are that I've allowed for the tracking of the user agent, searching by username or userid. Also I updated the code so that if a user decides to do core edits for cookie tracking they can and it'll display them.

IrPr, I really like your suggestion and may implement that if I've got time as I could find the helpful as well.

Stifmeister2 05-06-2009 04:19 PM
Quote:
Originally Posted by ewelin (Post 1805731)
Hello,

I really like this MOD but I felt as though it left a lot of room for improvement. I've added some features to it and I'd be happy to share them with you if you plan on releasing an update. Main changes are that I've allowed for the tracking of the user agent, searching by username or userid. Also I updated the code so that if a user decides to do core edits for cookie tracking they can and it'll display them.

IrPr, I really like your suggestion and may implement that if I've got time as I could find the helpful as well.
Sounds good, I'm interested... :)

photofox 12-23-2009 10:32 PM
Any chance this will be converted for VB4.0?

iceman-x 01-21-2010 11:17 AM
Would love if you can convert this to VB4.X

Thanks for werry good mod.

quantquant 02-08-2010 10:58 AM
Thank you, seems to work fine also under VB3.8.4. Would love to have it for 4.0.

Dr House 02-15-2010 06:18 AM
Does it works on 4.0?

Abe1 05-03-2010 11:42 AM
New version here: https://vborg.vbsupport.ru/showthread.php?t=241780


All times are GMT. The time now is 01:02 PM.
Page 3 of 4 12 3 4
Show 40 post(s) from this thread on one page

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01233 seconds
  • Memory Usage 1,819KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (3)bbcode_code_printable
  • (13)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (3)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete