Forums / Cotonti / Extensions / Request old seditio plugins to be ported

DemptD
#11259 2009-04-10 00:57
Could someone convert this:

http://www.bhsdesign.com/page.php?al=alias2757

BHS:
This plugin displays the number of hits and the name of the visitors on the person's profile itself. We currently use it on our site. For a demo just hit someone's profile.

To cotonti plugin?

Readme.txt:
FOR LDU 701:
PLACE THE FILE IN plugins/extended/wrapper/autorun.users


TAGS in users.details.tpl:
USERSDETAILS_VISITORSCOUNT
USERSDETAILS_VISITORS


RUN the SQL file ldu_users_visitors.sql

user_visitors.php:
<?PHP
/* ====================
Land Down Under - Website engine
Copyright (C) 2003 Neocrome
http://ldu.neocrome.net

[BEGIN_LDU]
File=plugins/users/default_plugins.users.php
Version=603
Updated=2004-jan-09
Type=Plugin.Users
Author=Neocrome
Description=
[END_LDU]

==================== */

if ( !defined('LDU_CODE') ) { die("Hacking attempt."); }

$visitors_limit = "LIMIT 10"; //limits the users visitors CHANGE ONLY THE NR!!
$db_users_visitors = 'ldu_users_visitors';
/*==========================================================================*/
if ( $suserid==$id )
    {
	$sqltmp = ldu_mysql_query("SELECT COUNT(*) FROM $db_users_visitors WHERE usrv_userid='$id' ");
	$user_visitorscount = mysql_result($sqltmp,0,"COUNT(*)");
	}
	else
	{
	$sqltmp = ldu_mysql_query("SELECT COUNT(*) FROM $db_users_visitors WHERE usrv_userid='$id' ");
	$user_visitorscount = mysql_result($sqltmp,0,"COUNT(*)");
	if ($suserlevel>0)
		{
		$sql_vc = ldu_mysql_query("SELECT COUNT(*) FROM $db_users_visitors WHERE usrv_vid='$suserid' AND usrv_userid='$id'  ");
		$visitor_count = mysql_result($sql_vc,0,"COUNT(*)");

		if ( $visitor_count<1 )
			{	
				$sql = ldu_mysql_query("INSERT INTO $db_users_visitors (usrv_userid, usrv_vid, usrv_vname, usrv_seen, usrv_vip) VALUES ('$id', '$suserid','$susername', '$ccdate', '$online_ip')");
			}
			else
			{	
				$sql = ldu_mysql_query("DELETE FROM $db_users_visitors WHERE usrv_userid='$id'AND usrv_vid='$suserid' ");
				$sql = ldu_mysql_query("INSERT INTO $db_users_visitors (usrv_userid, usrv_vid, usrv_vname, usrv_seen, usrv_vip) VALUES ('$id', '$suserid','$susername', '$ccdate', '$online_ip')");
			}			
		}
		else
		{
			$sql = ldu_mysql_query("INSERT INTO $db_users_visitors (usrv_userid, usrv_vid, usrv_vname, usrv_seen, usrv_vip) VALUES ('$id', '0', 'guest', '$ccdate', '$online_ip')");
		}
	}

$sqltmp = ldu_mysql_query("SELECT * FROM $db_users_visitors WHERE usrv_userid='$id' AND usrv_vid NOT LIKE '0' AND usrv_vid NOT LIKE '$suserid' ORDER BY usrv_id DESC $visitors_limit ");
while ( $usrv = mysql_fetch_array($sqltmp))
	{
	$usrv_id = $usrv["usrv_id"];
	$usrv_vid = ldu_build_user($usrv["usrv_vid"],$usrv["usrv_vname"]);
	$usrv_seen = date($ldu_dateformat,$usrv["usrv_seen"]+$stimezone*3600)." ".$stimetext;

	$visitor_online = (ldu_userisonline($usrv["usrv_vid"])) ? "1" : "0";
	$visitor_on = "<img src=\"skins/$skin/img/online".$visitor_online.".gif\" border=\"0\">";
	
	$user_visitors .= "<table><tr><td style=\"width:75%;vertical-align:bottom;\">".$visitor_on." ".$usrv_vid."</td><td style=\"width:25%;text-align:right;vertical-align:bottom;\">".$usrv_seen."</td></tr></table>";

	}

$t->assign(array(
	"USERSDETAILS_VISITORSCOUNT" => $user_visitorscount,
	"USERSDETAILS_VISITORS" => $user_visitors,
		));

?>

ldu_users_visitors.sql:
# phpMyAdmin SQL Dump
# version 2.5.6
# http://www.phpmyadmin.net
#
# Host: localhost
# Generation Time: Apr 07, 2004 at 01:59 AM
# Server version: 4.0.18
# PHP Version: 4.3.4
# 
# Database : `603`
# 

# --------------------------------------------------------

#
# Table structure for table `ldu_users_visitors`
#

CREATE TABLE `ldu_users_visitors` (
  `usrv_id` int(11) unsigned NOT NULL auto_increment,
  `usrv_userid` varchar(15) NOT NULL default '',
  `usrv_vid` varchar(15) NOT NULL default '',
  `usrv_vname` varchar(24) NOT NULL default '',
  `usrv_seen` int(11) NOT NULL default '0',
  `usrv_vip` varchar(15) NOT NULL default '',
  PRIMARY KEY  (`usrv_id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

#
# Dumping data for table `ldu_users_visitors`
#