Topic: custom php block - link error to external php page

[thellie]

for admin purposes it's good for me to know who hasn't yet activated their account (i create them via smf's admin "register new members".

so i created a little custom php block giving me a list of those who haven't activated yet, and the last 10 activations to have occurred. this works fine, and i have set a link on the names to go to an external page based on the users id_member. but when clicking on it i get:

An Error Has Occurred!
Wrong value type sent to the database. Array of integers expected. (member_list)

i added in the list of globals, but that didn't help, and i didn't want to go too far, and get myself completely lost

here's the code... anyone come across this before?

Code: [Select]

<?php
require_once('./Connections/mirrorfoundation.php'); 
require_once('admin_includes/sp_page_header_codenew.php');

mysql_select_db($database_mirrorfoundation, $mirrorfoundation);
$query_newvolstatus = "SELECT id_member, member_name, FROM_UNIXTIME(date_registered) AS date_registered, email_address FROM smf_members WHERE is_activated = 0 ORDER BY date_registered DESC";
$newvolstatus = mysql_query($query_newvolstatus, $mirrorfoundation) or die(mysql_error());
$row_newvolstatus = mysql_fetch_assoc($newvolstatus);
$totalRows_newvolstatus = mysql_num_rows($newvolstatus);

mysql_select_db($database_mirrorfoundation, $mirrorfoundation);
$query_last10registrations = "SELECT id_member, member_name, FROM_UNIXTIME(date_registered) AS date_registered, email_address FROM smf_members WHERE is_activated = 1 ORDER BY date_registered DESC LIMIT 0,10";
$last10registrations = mysql_query($query_last10registrations, $mirrorfoundation) or die(mysql_error());
$row_last10registrations = mysql_fetch_assoc($last10registrations);
$totalRows_last10registrations = mysql_num_rows($last10registrations);

echo '<table class="table">
<tr class="catbg3">
<td class="catbg3" colspan="2">
Not yet activated<hr>
</td>
</tr>';
do {

echo '<tr class="windowbg">
<td class="windowbg">

<a href="v_profile.php?id_member=', $row_newvolstatus['id_member'] ,'">',

$row_newvolstatus['member_name'] ,'</a>: </td>
<td align="right"><a href="mailto:', date('d.m.Y', strtotime($row_newvolstatus['email_address'])) ,'">email</a></td></tr>';
} while ($row_newvolstatus = mysql_fetch_assoc($newvolstatus));
echo '</table><br>';

echo '<table class="table">
<tr class="catbg3">
<td class="catbg3" colspan="2">
Last 10 activated<hr>
</td>
</tr>';
do {
echo '<tr class="windowbg">
<td class="windowbg">

<a href="v_profile.php?id_member=', $row_last10registrations['id_member'] ,'">',

$row_last10registrations['member_name'] ,'</a> 
</td>
<td align="right"><a href="mailto:', $row_last10registrations['email_address'] ,'">email</a></td></tr>';
} while ($row_last10registrations = mysql_fetch_assoc($last10registrations));
echo '</table>';

mysql_free_result($newvolstatus);
mysql_free_result($last10registrations);
?>


[thellie]

never mind, i think i've worked it out - the page it's going to is the issue... it has a join query based on the id_member, but until the user activates, those other table records aren't created...

i may have to rethink my registration method.