The Arcive of Official vBulletin Modifications Site.

[BETA/DEV] MutliUser Detection · **Released**: 03-01-2006

!!!!!!!!!!!!!!!!!!!!!!!! WARNING WARNING THIS IS IN BETA / DEVELOPMENT STAGE STILL WARNING WARNING!!!!!!!!!!!!!!!!!!!!!!!!!!!

You ask what does this do?

well it checks the user against a list of usergroups / userids to see if we need to check to see if there is a possible chance of multiple people from different IP's are using the same user login information.

You also Ask how is this different from AE Multiple Login Detection Plugin?

Well the AE Multiple Login Detection Plugin only detects if one person on the same computer has logged in by setting a cookie and every time someone logs in on the computer it checks that cookie for a list of usernames and basis its report off that.

This Plugin is more for detecting password sharing.

Current Feature List

Only check specified users set in vbulletin options
Only check users of specified usergroups set in vbulletin options
after x ammount of events change password to either a set password set in vbulletin options or a random password generated by the system
Prune events after x ammount of seconds set in vbulletin options
Cron job to prune user events & change user passwords that have forgone the event threshold
Admin Interface to do add/edit/list Ips that are being ignored
Admin interface to list events
Send Notification PM of an event to a list of admins set in vbulletin options
Send an Notification email of an alert/event to a list of admins set in vbulletin options
Post a Notificaiton thread upon an alert/event trigger to a specified forum set in vbulletin options
Possibly more that i cant think of off the top of my head

Known bugs that dont effect operation of this hack or performance of your board.

Cant edit Ignore IP's in AdminCP
Cant Prune Events in AdminCP
unable to edit ignore ips in the AdminCP interface

How do i install this?
Download & unpack the zip file
import /includes/xml/product_multiuser.xml from admincp
edit your settings to reflect your installation

Version Informaiton
1.0 - Initial Release
1.0.1 - Install XML Fix - Removed ENGINE from sql query calls in produc xml file

PHPGeek2k3 · #12 03-03-2006, 05:01 AM

The XML Product File should have added that table to the database.

Could you check via phpMyAdmin to see if the table is there?

As in the tests i have done it has worked for me.

Thanks
- James

Quote:

Originally Posted by luroca

I think a table in database is missing.
When I see Display Events in ACP:

Database error in vBulletin 3.5.3:

Invalid SQL:
SELECT * FROM mu_alert_core ORDER BY alertid DESC;

MySQL Error : Table 'mydatabase.mu_alert_core' doesn't exist
Error Number : 1146
Date : Friday, March 3rd 2006 @ 12:09:51 AM
Script : http://www.myboardcom/foro/admin_cp/...?do=showevents
Referrer : http://www.myboard.com/foro/admin_cp/index.php?do=nav
IP Address : 83.33.xxx.xxx
Username : Admin
Classname : vb_database

luroca · #13 03-03-2006, 07:56 AM

Sorry, there is not such table.
When uninstall:

Code:

Invalid SQL:
DROP TABLE mu_alert_core;

MySQL Error  : Unknown table 'mu_alert_core'
Error Number : 1051

luroca · #14 03-03-2006, 08:10 AM

I see your code to create the table, but the table is not create :surprised:
I don´t use any table prefix.

luroca · #15 03-03-2006, 09:00 PM

Hello, some feedback:

Code:

$vbulletin->db->query_write("DROP TABLE " . TABLE_PREFIX . "mu_ignored_ips"); 
should be:
$vbulletin->db->query_write("DROP TABLE " . TABLE_PREFIX . "mu_alert_ignored_ips");

And
$vbulletin->db->query_write("ATLER TABLE " . TABLE_PREFIX . "user DROP `main_ip`");
should be:
$vbulletin->db->query_write("ALTER TABLE " . TABLE_PREFIX . "user DROP `main_ip`");

And
$vbulletin->db->query_wrtie("ALTER TABLE " . TABLE_PREFIX . "user DROP `num_alerts`");]]>
should be:
$vbulletin->db->query_write("ALTER TABLE " . TABLE_PREFIX . "user DROP `num_alerts`");]]>

Code:

) ENGINE=MyISAM DEFAULT CHARSET=latin1");

does not work for me, my server does not use MySam, it uses MySQL.
If I delete "ENGINE=MyISAM DEFAULT" in the product the tables are created but I get errors in Display Events:

Notice: Undefined index: charset in /home/mydominion/public_html/foro/includes/init.php on line 144

Notice: Undefined index: url in /home/mydominion/public_html/foro/includes/class_core.php on line 1991

Notice: Only variables should be assigned by reference in /home/mydominion/public_html/foro/includes/init.php on line 213

I hope this info helps.

Regards

luroca · #16 03-03-2006, 09:08 PM

By the way, am I the only one with problems? There are 16 installs yet.

PHPGeek2k3 · #17 03-03-2006, 09:15 PM

the

Code:

" . TABLE_PREFIX . "_table_name

Should not effect you installation as it is taken care of by vbulletin.

go ahead and try changing

Code:

		<uninstallcode><![CDATA[
			$vbulletin->db->query_write("DROP TABLE " . TABLE_PREFIX . "mu_alert_core");
			$vbulletin->db->query_write("DROP TABLE " . TABLE_PREFIX . "mu_alert_events");
			$vbulletin->db->query_write("DROP TABLE " . TABLE_PREFIX . "mu_ignored_ips");
			$vbulletin->db->query_write("ALTER TABLE " . TABLE_PREFIX . "user DROP `has_alerts`");
			$vbulletin->db->query_write("ALTER TABLE " . TABLE_PREFIX . "user DROP `alert_id`");
			$vbulletin->db->query_write("ATLER TABLE " . TABLE_PREFIX . "user DROP `main_ip`");
			$vbulletin->db->query_wrtie("ALTER TABLE " . TABLE_PREFIX . "user DROP `num_alerts`");]]>
		</uninstallcode>

to

Code:

		<uninstallcode><![CDATA[
			$vbulletin->db->query_write("DROP TABLE mu_alert_core");
			$vbulletin->db->query_write("DROP TABLE mu_alert_events");
			$vbulletin->db->query_write("DROP TABLE mu_ignored_ips");
			$vbulletin->db->query_write("ALTER TABLE user DROP `has_alerts`");
			$vbulletin->db->query_write("ALTER TABLE user DROP `alert_id`");
			$vbulletin->db->query_write("ATLER TABLE user DROP `main_ip`");
			$vbulletin->db->query_wrtie("ALTER TABLE user DROP `num_alerts`");]]>
		</uninstallcode>

and try replacing

Code:

<installcode><![CDATA[$db->hide_errors();
$db->query_write("CREATE TABLE `" . TABLE_PREFIX . "mu_alert_core` (
  `alertid` int(11) NOT NULL auto_increment,
  `alert_userid` int(11) NOT NULL default '0',
  `alert_threadid` int(11) default NULL,
  PRIMARY KEY  (`alertid`),
  KEY `alert_userid` (`alert_userid`)
));

$db->query_write("CREATE TABLE `" . TABLE_PREFIX . "mu_alert_events` (
  `event_id` int(10) NOT NULL default '0',
  `alert_id` int(10) NOT NULL default '0',
  `event_dateline` int(10) default NULL,
  `event_userip` varchar(15) default NULL,
  PRIMARY KEY  (`event_id`),
  KEY `alert_id` (`alert_id`),
  KEY `event_userip` (`event_userip`)
));

$db->query_write("CREATE TABLE `" . TABLE_PREFIX . "mu_alert_ignored_ips` (
  `id` int(11) NOT NULL auto_increment,
  `ip` varchar(32) NOT NULL default '',
  PRIMARY KEY  (`id`)
));

$db->query_write("ALTER TABLE " .TABLE_PREFIX . "user ADD `has_alerts` INT(1) NOT NULL DEFAULT '0',
ADD `alert_id` INT(11) NOT NULL DEFAULT '0',
ADD `main_ip` VARCHAR(32) NOT NULL DEFAULT '0',
ADD `num_alerts` INT(10) NOT NULL DEFAULT '0'");
$db->show_errors();]]>
		</installcode>

with

Code:

<installcode><![CDATA[$db->hide_errors();
$db->query_write("CREATE TABLE `mu_alert_core` (
  `alertid` int(11) NOT NULL auto_increment,
  `alert_userid` int(11) NOT NULL default '0',
  `alert_threadid` int(11) default NULL,
  PRIMARY KEY  (`alertid`),
  KEY `alert_userid` (`alert_userid`)
));

$db->query_write("CREATE TABLE `mu_alert_events` (
  `event_id` int(10) NOT NULL default '0',
  `alert_id` int(10) NOT NULL default '0',
  `event_dateline` int(10) default NULL,
  `event_userip` varchar(15) default NULL,
  PRIMARY KEY  (`event_id`),
  KEY `alert_id` (`alert_id`),
  KEY `event_userip` (`event_userip`)
));

$db->query_write("CREATE TABLE `mu_alert_ignored_ips` (
  `id` int(11) NOT NULL auto_increment,
  `ip` varchar(32) NOT NULL default '',
  PRIMARY KEY  (`id`)
));

$db->query_write("ALTER TABLE user ADD `has_alerts` INT(1) NOT NULL DEFAULT '0',
ADD `alert_id` INT(11) NOT NULL DEFAULT '0',
ADD `main_ip` VARCHAR(32) NOT NULL DEFAULT '0',
ADD `num_alerts` INT(10) NOT NULL DEFAULT '0'");
$db->show_errors();]]>
		</installcode>

thanks
- james

luroca · #18 03-03-2006, 09:38 PM

Hello James, you are right, the TABLE_PREFIX is not the problem.

The tables are now created (without the ENGINE=MyISAM DEFAULT CHARSET=latin1 and the ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1) but the error is still in Display Events:

Code:

Notice: Undefined index: charset in /home/mydominion/public_html/foro/includes/init.php on line 144
Notice: Undefined index: url in /home/mydominion/public_html/foro/includes/class_core.php on line 1991
Notice: Only variables should be assigned by reference in /home/mydominion/public_html/foro/includes/init.php on line 213

All other hacks are disabled to test this one.

Thanks to you.

P.D. I see in database that created tables are of type "MySAM", yes, as the other tables of database.

PHPGeek2k3 · #19 03-04-2006, 04:11 AM

just to let every one know i have updated the download to fix the problem with the tables not getting added to the database.

Thanks
- James

VBUsers · #20 03-04-2006, 04:44 AM

will this work with the ae detector installed? can i have both?

luroca · #21 03-04-2006, 02:12 PM

Upgrade to vb3.5.4, all original files without modifications, all products and plugins disabled, the same problems

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.06204 seconds Memory Usage 2,313KB Queries Executed 26 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (9)bbcode_code (1)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (6)navbar_link (120)option (1)pagenav (1)pagenav_curpage (2)pagenav_pagelink (11)post_thanks_box (11)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (11)post_thanks_postbit_info (10)postbit (11)postbit_onlinestatus (11)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.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_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory 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 pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!