vb.org Archive
Page 1 of 4 1 23 Last »
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.5 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=113)
-   -   Log Logins Hack (https://vborg.vbsupport.ru/showthread.php?t=92266)

Abe1 07-14-2005 10:00 PM
Log Logins Hack
 
Log Logins Hack 1.1


About this hack:
This hack will log the userid, username, ipaddress, where the login is, and time all your users log onto your forum.
  • Files edited: 0
  • Templates edited: 0
  • Files to upload: 2
  • Time to install: 1 minutes max
Updates:

Version 1.0 (11/05/05):
  • GOLD Release of this hack for vBulletin version 3.5
Version 1.1 (11/06/05):
  • Added logging of were the log was made. (Standard, Mod CP, or Admin CP)
Please post your comments or suggestions for this hack. I read ALL posts.

MAKE SURE YOU CLICK INSTALL!
You will get an email when a new version is released.

Pictures:
  1. Admin Control Panel View of Stats

Chris M 07-15-2005 04:24 PM
Nice idea :)

[high]* Chris M considers for installation :)
[/high]

Satan

Allan 07-15-2005 05:24 PM
little screen of result please :)

Chris M 07-15-2005 05:33 PM
Quote:
Originally Posted by Allan
little screen of result please :)
There is no data displayed - You have to view it through PhpMyAdmin, therefore just imagine a PhpMyAdmin screen with data:p

Satan

cipciop 07-15-2005 06:13 PM
after lunch the puglin i have the problem with database:

Database error in vBulletin 3.5.0 Beta 4:

Invalid SQL:
CREATE TABLE IF NOT EXISTS`logins` (
`logid` int(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
`userid` int(10) NOT NULL,
`username` char(100) NOT NULL,
`ipaddress` char(15) NOT NULL,
`date` timestamp NOT NULL default CURRENT_TIMESTAMP,
`phpdate` int(10) NOT NULL);

MySQL Error : 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
'CURRENT_TIMESTAMP,
`phpdate` int(10) NOT NULL)' at line 6
Error Number : 1064

What can resolved this problem ?

Tks.

Sorry for my bad english

Abe1 07-15-2005 08:30 PM
Quote:
Originally Posted by cipciop
after lunch the puglin i have the problem with database:

Database error in vBulletin 3.5.0 Beta 4:

Invalid SQL:
CREATE TABLE IF NOT EXISTS`logins` (
`logid` int(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
`userid` int(10) NOT NULL,
`username` char(100) NOT NULL,
`ipaddress` char(15) NOT NULL,
`date` timestamp NOT NULL default CURRENT_TIMESTAMP,
`phpdate` int(10) NOT NULL);

MySQL Error : 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
'CURRENT_TIMESTAMP,
`phpdate` int(10) NOT NULL)' at line 6
Error Number : 1064

What can resolved this problem ?

Tks.

Sorry for my bad english
OK. I updated the zip file. Please try to install again now. Also, you sould first manualy delete any hooks that got installed before. After you delete them, you can import this new file.

Christine 07-15-2005 10:17 PM
Hi Abe,

This is interesting! Thanks for sharing it -- I will check with my board teams and see if there is anything they would like to do with this information.

derekivey 07-17-2005 03:33 AM
I installed it, It does the job well! :)

Jenta 07-19-2005 06:48 PM
Installed.

Is it possible you can create a session log one?

I need to see how often certain members are visiting the forums. I don't care how large the table grows and I have had no luck figuring out the new session code.

Thanks

jesus likes pie 07-20-2005 12:08 AM
Are you working on making it show in some place in the admincp rather than phpmyadmin?

Abe1 07-20-2005 01:32 AM
Quote:
Originally Posted by jesus likes pie
Are you working on making it show in some place in the admincp rather than phpmyadmin?
Eventually.

Reimer 07-22-2005 11:55 AM
It would be nice to add logging for the logout function as well because I have some problems with multiple accounts.

ExpertDomino 08-04-2005 01:01 AM
I can Confirm this in not compiatbile with 3.5.0 RC1 GRRRRRRRRRRRR, now I have some issues to fix.

derekivey 08-04-2005 01:38 AM
Yup, it doesn't work for me also on vBulletin 3.5 RC1.

Derek

Abe1 08-04-2005 11:47 AM
Updated for vb3.5rc1.

Is anyone upgrading this hack? I suggest uninstall then re-install.

Metro Man 08-04-2005 11:49 AM
great work

derekivey 08-04-2005 04:25 PM
Ok, This one works now :) Good job!

Abe1 08-04-2005 09:16 PM
Works on RC2 also.

derekivey 08-05-2005 12:11 AM
Ok, Great! :)

Abe1 08-07-2005 01:04 PM
Hack updated.

There is now a viewer for the AdminCP.

derekivey 08-07-2005 02:49 PM
Awesome,

Thanks! :)

MP3 08-08-2005 01:41 PM
if i want to see the real ip in each post, is't possible with this hack ??

Abe1 08-08-2005 01:46 PM
Quote:
Originally Posted by MP3
if i want to see the real ip in each post, is't possible with this hack ??
You can edit the plugin if you want. I'm just not sure what to replace.

Boots 08-10-2005 12:08 PM
It craps the bed with non-standard characters in usernames..

Code:
Database error in vBulletin 3.5.0 Release Candidate 2:

Invalid SQL:
INSERT INTO vb3_logins (userid, username, ipaddress, phpdate) VALUES (2677, 'i'mgirlie', '24.215.xx.xx', 1123677895);

MySQL Error  : 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 'mgirlie', '24.215.88.47', 1123677895)' at line 1 Error Number : 1064
Date        : Wednesday, August 10th 2005 @ 09:44:55 AM
Script      : http://forums.reality-check.ca/login.php
Referrer    : http://forums.reality-check.ca/memberlist.php
IP Address  : 24.215.xx.xx
Username    : i'mgirlie
Classname    : vb_database

MP3 08-10-2005 01:10 PM
Quote:
Originally Posted by Abe1
You can edit the plugin if you want. I'm just not sure what to replace.
any hint plz ?

Abe1 08-10-2005 01:30 PM
Quote:
Originally Posted by Boots
It craps the bed with non-standard characters in usernames..

Code:
Database error in vBulletin 3.5.0 Release Candidate 2:

Invalid SQL:
INSERT INTO vb3_logins (userid, username, ipaddress, phpdate) VALUES (2677, 'i'mgirlie', '24.215.xx.xx', 1123677895);

MySQL Error  : 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 'mgirlie', '24.215.88.47', 1123677895)' at line 1 Error Number : 1064
Date        : Wednesday, August 10th 2005 @ 09:44:55 AM
Script      : http://forums.reality-check.ca/login.php
Referrer    : http://forums.reality-check.ca/memberlist.php
IP Address  : 24.215.xx.xx
Username    : i'mgirlie
Classname    : vb_database
I see. I'll fix that later today.

Abe1 08-11-2005 03:52 AM
v0.4 released. Fixed for user with irregular charecters.

Boofo 08-11-2005 04:02 AM
Does this use the IP they registered with or the actual IP they are logging in from?

Abe1 08-11-2005 04:06 AM
Quote:
Originally Posted by Boofo
Does this use the IP they registered with or the actual IP they are logging in from?
The IP they are bowsing with when they login.

Boofo 08-11-2005 04:13 AM
One last question ... any way to prune this form the Admin CP if it starts to get large? ;)

Abe1 08-11-2005 04:17 AM
Quote:
Originally Posted by Boofo
One last question ... any way to prune this form the Admin CP if it starts to get large? ;)
Yes. On the same page as you can view the logings, there is an option to prune.

Boofo 08-11-2005 05:51 AM
Thank you, sir, installing now. ;)

Mu5icMan 08-11-2005 07:30 AM
very nice indeed, 'clicks install'

seangworld 08-14-2005 09:25 PM
ok, i took your suggestion on my request thread, abe, and im looking at this. as i see it, it appears that it will only keep track of those that have registered, but what i was looking for is something to track ips of those that ARE registered AND those that are NOT registered.

can this do that too?

Abe1 08-14-2005 09:54 PM
Quote:
Originally Posted by seangworld
ok, i took your suggestion on my request thread, abe, and im looking at this. as i see it, it appears that it will only keep track of those that have registered, but what i was looking for is something to track ips of those that ARE registered AND those that are NOT registered.

can this do that too?
So you dont want just a log-in logger. You want something that logs all IP's that ever come to the forum. What would you do with it?

derekivey 08-15-2005 01:14 AM
Quote:
Originally Posted by seangworld
ok, i took your suggestion on my request thread, abe, and im looking at this. as i see it, it appears that it will only keep track of those that have registered, but what i was looking for is something to track ips of those that ARE registered AND those that are NOT registered.

can this do that too?
Can't you just look at the raw apache log to determine who comes to the forum?

Bro_Joey_Gowdy 08-15-2005 02:31 AM
*Rowdy clicks install*

jesus likes pie 08-15-2005 04:27 PM
ooh i like this.

*installs and clicks on install*

jesus likes pie 08-15-2005 04:31 PM
Oh and now I see an sql error when entering a userid (Show Only Entries Generated By UserID: (leave blank to show all))

Code:
Database error in vBulletin 3.5.0 Release Candidate 2:

Invalid SQL:

                SELECT COUNT(*) AS total
                FROM logins AS logins
                userid = 1;

MySQL Error  : 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 'userid = 1' at line 3
Error Number : 1064
Date        : Monday, August 15th 2005 @ 01:30:36 PM
Script      : http://www.ugforums.org/ugforums/admincp/loginlog.php
Referrer    : http://www.ugforums.org/ugforums/admincp/loginlog.php
IP Address  : 71.241.238.138
Username    : ATI4EVER!
Classname    : vb_database

Abe1 08-15-2005 04:44 PM
Quote:
Originally Posted by jesus likes pie
Oh and now I see an sql error when entering a userid (Show Only Entries Generated By UserID: (leave blank to show all))

Code:
Database error in vBulletin 3.5.0 Release Candidate 2:

Invalid SQL:

                SELECT COUNT(*) AS total
                FROM logins AS logins
                userid = 1;

MySQL Error  : 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 'userid = 1' at line 3
Error Number : 1064
Date        : Monday, August 15th 2005 @ 01:30:36 PM
Script      : http://www.ugforums.org/ugforums/admincp/loginlog.php
Referrer    : http://www.ugforums.org/ugforums/admincp/loginlog.php
IP Address  : 71.241.238.138
Username    : ATI4EVER!
Classname    : vb_database
I see were the error is. I'll go fix it tonight if I have a min.


All times are GMT. The time now is 06:54 PM.
Page 1 of 4 1 23 Last »
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.01513 seconds
  • Memory Usage 1,820KB
  • 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
  • (4)bbcode_code_printable
  • (11)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)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