Thread: Administrative and Maintenance Tools - Log Logins Hack
View Single Post
  #31  
Old 01-26-2011, 10:03 AM
aileron79 aileron79 is offline
 
Join Date: Apr 2009
Posts: 36
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Hi!

First of all, thanks for the hack, it really does a great job! There is only one huge problem. Some users are "always", or better "automatically" logged in by their cookies. Thus, the IP addresses of those users are NOT recorded.

Admittedly, I have no clue how this could be achieved, the only idea would be to check if there is a record matching the same ip for a particular user when opening forum_home. This, however, may of course increase database load but is probably suitable for small forums.

Well, I definitely needed that... so I just wrote the required plugin by myself, you may include that in the original addon if you like... please test thoroughly before use!

PHP Code:
$cb_lastknown_ip $vbulletin->db->query_first("SELECT ipaddress FROM " TABLE_PREFIX "logins WHERE userid=" $vbulletin->userinfo['userid']. " ORDER BY phpdate DESC LIMIT 1");
if (
$cb_lastknown_ip['ipaddress'] != IPADDRESS)
{
    
$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 ", '$logintype')");
}
unset(
$cb_lastknown_ip); 
I created a new plugin for Log Logins Hack at hook forumhome_start (maybe ..._end would be better... let's see...). Don't forget to activate, use at your own risk.
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01056 seconds
  • Memory Usage 1,779KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_php
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • showpost_complete