Western Studios - |Forums | Hack and Mods

Western Studios :: View topic - Last Visit forum mod

Forum FAQ

Usergroups Profile

Profile

Last Visit forum mod

printer friendly version

Western Studios Forum Index -> Hack and Mods

X-perienced

~PHP Nuke User~

Platinum Subscriber

Posts: 125
Next Group: 25 posts

godfirst wrote:

I stumbled on a pretty good mod for my forum, and I'm trying to convert this for phpnuke. I've gotten everything done, but 1 file is puzzling.

Code:

#
#-----[ OPEN ]------------------------------------------------
#
search.php

#
#-----[ FIND ]------------------------------------------------
#
   $sql = "SELECT session_id
      FROM " . SESSIONS_TABLE;

#
#-----[ REPLACE WITH ]----------------------------------------
#

// Start replacement - Last visit MOD
$expiry_time = $current_time - $board_config['session_length'];
   $sql = "SELECT session_id
      FROM " . SESSIONS_TABLE ." WHERE session_time>$expiry_time";
// Start replacement - Last visit MOD

The actual request line isn't there. I have found aline close and wonder if I should continue

Code:

//
   // Flood control
   //
   $where_sql = ($userdata['user_id'] == ANONYMOUS) ? "se.session_ip = '$user_ip'" : 'se.session_user_id = ' . $userdata['user_id'];
   $sql = 'SELECT MAX(sr.search_time) AS last_search_time
      FROM ' . SEARCH_TABLE . ' sr, ' . SESSIONS_TABLE . " se
      WHERE sr.session_id = se.session_id
         AND $where_sql";
   if ($result = $db->sql_query($sql))
   {
      if ($row = $db->sql_fetchrow($result))
      {

Posted: Sun Jun 04, 2006 10:22 pm

Site Admin

~PHP Nuke User~

Platinum Subscriber

Posts: 3309
Staff
Next Group: 1691 posts

admin(Mark) wrote:

I would not recommend replacing the codes but you could try this

Change the codes you posted to this:

Code:

// Flood control
//
$expiry_time = $current_time - $board_config['session_length'];
$where_sql = ($userdata['user_id'] == ANONYMOUS) ? "se.session_ip = '$user_ip'" : 'se.session_user_id = ' . $userdata['user_id'];
$sql = 'SELECT MAX(sr.search_time) AS last_search_time
FROM ' . SEARCH_TABLE . ' sr, ' . SESSIONS_TABLE . " se
WHERE sr.session_id = se.session_id AND se.session_time>$expiry_time
AND $where_sql";
if ($result = $db->sql_query($sql))
{
if ($row = $db->sql_fetchrow($result))
{

I have added the extra codes.

Posted: Wed Jun 07, 2006 2:31 am

WS Newbie

~PHP Nuke User~

Posts: 10
Next Group: 40 posts

abojehad wrote:

sorry
but it does not work with me
any one try it?

Posted: Fri Jun 09, 2006 6:06 am

	Western Studios Forum Index -> PHP Nuke -> Hack and Mods	All times are GMT - 5 Hours
Page 1 of 1

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Topics		Replies	Author	Views	Last Post
Related topics
	PHP paste bin added	0	admin	768	Wed Mar 23, 2005 6:47 pm admin
	PHP Nuke klips	0	admin	608	Fri Mar 18, 2005 6:52 pm admin
	Paypal success.php	1	Jabba	783	Fri Mar 04, 2005 7:00 pm admin
	Testing PHP tags	2	admin	764	Thu Mar 03, 2005 6:06 pm admin
	PHP Nuke Icons	0	admin	813	Mon Aug 23, 2004 4:05 pm admin

Our Sponsors

Last Visit forum mod