Showing only approved 'Latest Member'

[Xenomorph]

Do you mean is_activated?

also, I get this:

Fatal error: Call to undefined function: db_query() in /.../.../forum/Sources/Load.php on line 37

o whoops.. yeah, "is_activated"

where did you get the Load.php error at? what were you doing? what screen?

i have the mod installed on my forum (its the only package im using), and i havent come across any errors

[smacktalk]

Do you mean is_activated?

also, I get this:

Fatal error: Call to undefined function: db_query() in /.../.../forum/Sources/Load.php on line 37

o whoops.. yeah, "is_activated"

where did you get the Load.php error at? what were you doing? what screen?

i have the mod installed on my forum (its the only package im using), and i havent come across any errors

I was getting this after the installation on a blank page. I have since updated to the current release of SMF. Is this working with the newest build? If so, I will try to reinstall.

[Xenomorph]

I was getting this after the installation on a blank page. I have since updated to the current release of SMF. Is this working with the newest build? If so, I will try to reinstall.

i just installed 1.0.2, and then installed an updated version of the mod

http://xenomorph.net/files/forum/ShowOnlyAuthenticatedMembers_102.zip

[smacktalk]

I was getting this after the installation on a blank page. I have since updated to the current release of SMF. Is this working with the newest build? If so, I will try to reinstall.

i just installed 1.0.2, and then installed an updated version of the mod

http://xenomorph.net/files/forum/ShowOnlyAuthenticatedMembers_102.zip

Works fine now. Thanks!

[OAS]

i get this message when tryin to run it:
The package you are trying to download or install is either corrupt or not compatible with this version of SMF.

probably cos i'm running version 1.0.3

any possibilities of an updated version of the mod for 1.0.3 users?

cheers

[OAS]

bump

[SeaOfSin]

i get this message when tryin to run it:
The package you are trying to download or install is either corrupt or not compatible with this version of SMF.

probably cos i'm running version 1.0.3

any possibilities of an updated version of the mod for 1.0.3 users?

cheers

I had that problem myself and did a manual install that worked fine!

[OAS]

I had that problem myself and did a manual install that worked fine!

thanks SeaOfSin

all good now

[dvk01]

I get the same error message on 1.04
The package you are trying to download or install is either corrupt or not compatible with this version of SMF.

any easy way around it

how do you do a manual install

[SeaOfSin]

Follow these simple instructions

Code Select Expand


<edit file>
Sources/Subs.php
</edit file>

<search>
$result = db_query("
SELECT COUNT(ID_MEMBER), MAX(ID_MEMBER)
FROM {$db_prefix}members", __FILE__, __LINE__);
</search>

<replace>
$result = db_query("
SELECT COUNT(ID_MEMBER), MAX(ID_MEMBER)
FROM {$db_prefix}members
                                WHERE `is_activated` = '1'", __FILE__, __LINE__);
</replace>


<edit file>
Sources/Register.php
</edit file>

<search>
updateMemberData($row['ID_MEMBER'], array('is_activated' => 1, 'validation_code' => '\'\''));
</search>

<replace>
updateMemberData($row['ID_MEMBER'], array('is_activated' => 1, 'validation_code' => '\'\''));
updateStats('member');
</replace>

<edit file>
Sources/Memberlist.php
</edit file>

<search>
$request = db_query("
SELECT COUNT(ID_MEMBER)
FROM {$db_prefix}members
WHERE LOWER(SUBSTRING(realName, 1, 1)) < '" . strtolower($_REQUEST['start']) . "'", __FILE__, __LINE__);
</search>

<replace>
$request = db_query("
SELECT COUNT(ID_MEMBER)
FROM {$db_prefix}members
WHERE LOWER(SUBSTRING(realName, 1, 1)) < '" . strtolower($_REQUEST['start']) . "'
AND `is_activated` != '0'", __FILE__, __LINE__);
</replace>

<search>
$request = db_query("
SELECT
mem.memberName, mem.realName, mem.websiteTitle, mem.websiteUrl, mem.posts,
mem.ID_GROUP, mem.ICQ, mem.AIM, mem.YIM, mem.MSN, mem.emailAddress,
mem.hideEmail, mem.ID_MEMBER, IFNULL(lo.logTime, 0) AS isOnline,
IFNULL(mg.groupName, '') AS groupName, mem.showOnline, mem.dateRegistered
FROM {$db_prefix}members AS mem
LEFT JOIN {$db_prefix}log_online AS lo ON (lo.ID_MEMBER = mem.ID_MEMBER)
LEFT JOIN {$db_prefix}membergroups AS mg ON (mg.ID_GROUP = IF(mem.ID_GROUP = 0, mem.ID_POST_GROUP, mem.ID_GROUP))
ORDER BY " . $sort_methods[$_REQUEST['sort']][$context['sort_direction']] . "
LIMIT $_REQUEST[start], $modSettings[defaultMaxMembers]", __FILE__, __LINE__);
</search>

<replace>
$request = db_query("
SELECT
mem.memberName, mem.realName, mem.websiteTitle, mem.websiteUrl, mem.posts,
mem.ID_GROUP, mem.ICQ, mem.AIM, mem.YIM, mem.MSN, mem.emailAddress,
mem.hideEmail, mem.ID_MEMBER, IFNULL(lo.logTime, 0) AS isOnline,
IFNULL(mg.groupName, '') AS groupName, mem.showOnline, mem.dateRegistered
FROM {$db_prefix}members AS mem
LEFT JOIN {$db_prefix}log_online AS lo ON (lo.ID_MEMBER = mem.ID_MEMBER)
LEFT JOIN {$db_prefix}membergroups AS mg ON (mg.ID_GROUP = IF(mem.ID_GROUP = 0, mem.ID_POST_GROUP, mem.ID_GROUP))
WHERE `is_activated` != '0'
ORDER BY " . $sort_methods[$_REQUEST['sort']][$context['sort_direction']] . "
LIMIT $_REQUEST[start], $modSettings[defaultMaxMembers]", __FILE__, __LINE__);
</replace>


[dvk01]

I found the easy way is to edit the xml file to show 1.04 instead of 1.02 then it works

thanks for all the advice though

[phillyuser]

Will this fix work for SMF 1.07?