Ravens PHP Scripts: Forums
 

 

View next topic
View previous topic
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> General/Other Stuff
Author Message
mr-brain
New Member
New Member


Joined: Oct 07, 2005
Posts: 9
Location: The Netherlands

PostPosted: Fri Oct 07, 2005 11:57 am Reply with quote

Hello there,

I installed the Resend Email module and it works great. However whenever I look at the User RegDate it always says January 01, 1970. How to solve this (PHPNuke ver. 7.6)?

Regards
 
View user's profile Send private message
hitwalker
Sells PC To Pay For Divorce


Joined:
Posts: 5661

PostPosted: Fri Oct 07, 2005 4:40 pm Reply with quote

If this is your solution i dont know...
But this is what i found :

Open includes/usercp_viewprofile and look for

Code:


 'JOINED' => create_date($lang['DATE_FORMAT'], $profiledata['user_regdate'], $board_config['board_timezone']),



change to
Code:


        'JOINED' => $profiledata['user_regdate'],



This was by chatserv on Tue Mar 11, 2003 and was related to profile.
 
View user's profile Send private message
CurtisH
Life Cycles Becoming CPU Cycles


Joined: Mar 15, 2004
Posts: 638
Location: West Branch, MI

PostPosted: Fri Oct 07, 2005 5:24 pm Reply with quote

Thanks Hitwalker. This helped me with another issue I was dealing with. Smile

_________________
Those who dream by day are cognizant of many things which escape those who dream only by night. ~Poe 
View user's profile Send private message Visit poster's website Yahoo Messenger
hitwalker
PostPosted: Fri Oct 07, 2005 5:26 pm Reply with quote

ah curtis,thats nice to hear...
 
mr-brain
PostPosted: Sat Oct 08, 2005 3:07 am Reply with quote

No, I am afraid that that is not the solution as I already had changed it that way.
 
hitwalker
PostPosted: Sat Oct 08, 2005 5:14 am Reply with quote

Well in the module change :



Code:
strtotime($timestamp) 


to:

Code:
$timestamp 
 
mr-brain
PostPosted: Sat Oct 08, 2005 6:32 am Reply with quote

I am afraid I can't find that. Here's what I've got;

Code:
Resend, Activate, or Delete Activation Emails - V2.0.2

<?php
/***************************************************************************
 *                           usercp_viewprofile.php
 *                            -------------------
 *   begin                : Saturday, Feb 13, 2001
 *   copyright            : (C) 2001 The phpBB Group
 *   email                : Only registered users can see links on this board! Get registered or login!
 *
 *   $Id: usercp_viewprofile.php,v 1.5.2.2 2004/07/11 16:46:20 acydburn Exp $
 *
 *
 ***************************************************************************/

/***************************************************************************
 *
 *   This program is free software; you can redistribute it and/or modify
 *   it under the terms of the GNU General Public License as published by
 *   the Free Software Foundation; either version 2 of the License, or
 *   (at your option) any later version.
 *
 *
 ***************************************************************************/

if ( !defined('IN_PHPBB') )
{
        die("Hacking attempt");
        exit;
}

if ( empty($HTTP_GET_VARS[POST_USERS_URL]) || $HTTP_GET_VARS[POST_USERS_URL] == ANONYMOUS )
{
        message_die(GENERAL_MESSAGE, $lang['No_user_id_specified']);
}
$profiledata = get_userdata(intval($HTTP_GET_VARS[POST_USERS_URL]));

$sql = "SELECT *
        FROM " . RANKS_TABLE . "
        ORDER BY rank_special, rank_min";
if ( !($result = $db->sql_query($sql)) )
{
        message_die(GENERAL_ERROR, 'Could not obtain ranks information', '', __LINE__, __FILE__, $sql);
}
$ranksrow = array();
while ( $row = $db->sql_fetchrow($result) )
{
        $ranksrow[] = $row;
}
$db->sql_freeresult($result);

//
// Output page header and profile_view template
//
$template->set_filenames(array(
        'body' => 'profile_view_body.tpl')
);
if (is_active("Forums")) {
    make_jumpbox('viewforum.'.$phpEx);
}
//
// Calculate the number of days this user has been a member ($memberdays)
// Then calculate their posts per day
//
$regdate = $profiledata['user_regdate'];
$nukedate = strtotime($regdate);
$memberdays = max(1, round( ( time() - $nukedate ) / 86400 ));
$posts_per_day = $profiledata['user_posts'] / $memberdays;

// Get the users percentage of total posts
if ( $profiledata['user_posts'] != 0  )
{
        $total_posts = get_db_stat('postcount');
        $percentage = ( $total_posts ) ? min(100, ($profiledata['user_posts'] / $total_posts) * 100) : 0;
}
else
{
        $percentage = 0;
}

$avatar_img = '';
if ( $profiledata['user_avatar_type'] && $profiledata['user_allowavatar'] )
{
        switch( $profiledata['user_avatar_type'] )
        {
                case USER_AVATAR_UPLOAD:
                        $avatar_img = ( $board_config['allow_avatar_upload'] ) ? '<img src="' . $board_config['avatar_path'] . '/' . $profiledata['user_avatar'] . '" alt="" border="0" />' : '';
                        break;
                case USER_AVATAR_REMOTE:
                        $avatar_img = ( $board_config['allow_avatar_remote'] ) ? '<img src="' . $profiledata['user_avatar'] . '" alt="" border="0" />' : '';
                        break;
                case USER_AVATAR_GALLERY:
                        $avatar_img = ( $board_config['allow_avatar_local'] ) ? '<img src="' . $board_config['avatar_gallery_path'] . '/' . $profiledata['user_avatar'] . '" alt="" border="0" />' : '';
                        break;
        }
}

$poster_rank = '';
$rank_image = '';
if ( $profiledata['user_rank'] )
{
        for($i = 0; $i < count($ranksrow); $i++)
        {
                if ( $profiledata['user_rank'] == $ranksrow[$i]['rank_id'] && $ranksrow[$i]['rank_special'] )
                {
                        $poster_rank = $ranksrow[$i]['rank_title'];
                        $rank_image = ( $ranksrow[$i]['rank_image'] ) ? '<img src="' . $ranksrow[$i]['rank_image'] . '" alt="' . $poster_rank . '" title="' . $poster_rank . '" border="0" /><br />' : '';
                }
        }
}
else
{
        for($i = 0; $i < count($ranksrow); $i++)
        {
                if ( $profiledata['user_posts'] >= $ranksrow[$i]['rank_min'] && !$ranksrow[$i]['rank_special'] )
                {
                        $poster_rank = $ranksrow[$i]['rank_title'];
                        $rank_image = ( $ranksrow[$i]['rank_image'] ) ? '<img src="' . $ranksrow[$i]['rank_image'] . '" alt="' . $poster_rank . '" title="' . $poster_rank . '" border="0" /><br />' : '';
                }
        }
}

$temp_url = append_sid("privmsg.$phpEx?mode=post&amp;" . POST_USERS_URL . "=" . $profiledata['user_id']);
if (is_active("Private_Messages")) {
    $pm_img = '<a href="' . $temp_url . '"><img src="' . $images['icon_pm'] . '" alt="' . $lang['Send_private_message'] . '" title="' . $lang['Send_private_message'] . '" border="0" /></a>';
    $pm = '<a href="' . $temp_url . '">' . $lang['Send_private_message'] . '</a>';
}

if ( !empty($profiledata['user_viewemail']) || $userdata['user_level'] == ADMIN )
{
        $email_uri = ( $board_config['board_email_form'] ) ? append_sid("profile.$phpEx?mode=email&amp;" . POST_USERS_URL .'=' . $profiledata['user_id']) : 'mailto:' . $profiledata['user_email'];

        $email_img = '<a href="' . $email_uri . '"><img src="' . $images['icon_email'] . '" alt="' . $lang['Send_email'] . '" title="' . $lang['Send_email'] . '" border="0" /></a>';
        $email = '<a href="' . $email_uri . '">' . $lang['Send_email'] . '</a>';
}
else
{
        $email_img = '&nbsp;';
        $email = '&nbsp;';
}
if (( $profiledata['user-website'] == "http:///") || ( $profiledata['user_website'] == "http://")){
    $profiledata['user_website'] =  "";
}
if (($profiledata['user_website'] != "" ) && (substr($profiledata['user_website'],0, 7) != "http://")) {
    $profiledata['user_website'] = "http://".$profiledata['user_website'];
}

$www_img = ( $profiledata['user_website'] ) ? '<a href="' . $profiledata['user_website'] . '" target="_userwww"><img src="' . $images['icon_www'] . '" alt="' . $lang['Visit_website'] . '" title="' . $lang['Visit_website'] . '" border="0" /></a>' : '&nbsp;';
$www = ( $profiledata['user_website'] ) ? '<a href="' . $profiledata['user_website'] . '" target="_userwww">' . $profiledata['user_website'] . '</a>' : '&nbsp;';

if ( !empty($profiledata['user_icq']) )
{
        $icq_status_img = '<a href="http://wwp.icq.com/' . $profiledata['user_icq'] . '#pager"><img src="http://web.icq.com/whitepages/online?icq=' . $profiledata['user_icq'] . '&img=5" width="18" height="18" border="0" /></a>';
        $icq_img = '<a href="http://wwp.icq.com/scripts/search.dll?to=' . $profiledata['user_icq'] . '"><img src="' . $images['icon_icq'] . '" alt="' . $lang['ICQ'] . '" title="' . $lang['ICQ'] . '" border="0" /></a>';
        $icq =  '<a href="http://wwp.icq.com/scripts/search.dll?to=' . $profiledata['user_icq'] . '">' . $lang['ICQ'] . '</a>';
}
else
{
        $icq_status_img = '&nbsp;';
        $icq_img = '&nbsp;';
        $icq = '&nbsp;';
}

$aim_img = ( $profiledata['user_aim'] ) ? '<a href="aim:goim?screenname=' . $profiledata['user_aim'] . '&amp;message=Hello+Are+you+there?"><img src="' . $images['icon_aim'] . '" alt="' . $lang['AIM'] . '" title="' . $lang['AIM'] . '" border="0" /></a>' : '&nbsp;';
$aim = ( $profiledata['user_aim'] ) ? '<a href="aim:goim?screenname=' . $profiledata['user_aim'] . '&amp;message=Hello+Are+you+there?">' . $lang['AIM'] . '</a>' : '&nbsp;';

$msn_img = ( $profiledata['user_msnm'] ) ? $profiledata['user_msnm'] : '&nbsp;';
$msn = $msn_img;

$yim_img = ( $profiledata['user_yim'] ) ? '<a href="http://edit.yahoo.com/config/send_webmesg?.target=' . $profiledata['user_yim'] . '&amp;.src=pg"><img src="' . $images['icon_yim'] . '" alt="' . $lang['YIM'] . '" title="' . $lang['YIM'] . '" border="0" /></a>' : '';
$yim = ( $profiledata['user_yim'] ) ? '<a href="http://edit.yahoo.com/config/send_webmesg?.target=' . $profiledata['user_yim'] . '&amp;.src=pg">' . $lang['YIM'] . '</a>' : '';

$temp_url = append_sid("search.$phpEx?search_author=" . urlencode($profiledata['username']) . "&amp;showresults=posts");
$search_img = '<a href="' . $temp_url . '"><img src="' . $images['icon_search'] . '" alt="' . $lang['Search_user_posts'] . '" title="' . $lang['Search_user_posts'] . '" border="0" /></a>';
$search = '<a href="' . $temp_url . '">' . $lang['Search_user_posts'] . '</a>';
#
if ( !empty($profiledata['user_gender']))
{
           switch ($profiledata['user_gender'])
           {
                      case 1: $gender=$lang['Male'];break;
                      case 2: $gender=$lang['Female'];break;
                      default:$gender=$lang['No_gender_specify'];
           }
} else $gender=$lang['No_gender_specify'];
//
// Generate page
//
$page_title = $lang['Viewing_profile'];
include("includes/page_header.php");
$profiledata['user_from'] = str_replace(".gif", "", $profiledata['user_from']);

$template->assign_vars(array(
        'USERNAME' => $profiledata['username'],
        'JOINED' => $profiledata['user_regdate'],
        'POSTER_RANK' => $poster_rank,
        'RANK_IMAGE' => $rank_image,
        'POSTS_PER_DAY' => $posts_per_day,
        'POSTS' => $profiledata['user_posts'],
        'PERCENTAGE' => $percentage . '%',
        'POST_DAY_STATS' => sprintf($lang['User_post_day_stats'], $posts_per_day),
        'POST_PERCENT_STATS' => sprintf($lang['User_post_pct_stats'], $percentage),
        'SEARCH_IMG' => $search_img,
        'SEARCH' => $search,
        'PM_IMG' => $pm_img,
        'PM' => $pm,
        'EMAIL_IMG' => $email_img,
        'EMAIL' => $email,
        'WWW_IMG' => $www_img,
        'WWW' => $www,
        'ICQ_STATUS_IMG' => $icq_status_img,
        'ICQ_IMG' => $icq_img,
        'ICQ' => $icq,
        'AIM_IMG' => $aim_img,
        'AIM' => $aim,
        'MSN_IMG' => $msn_img,
        'MSN' => $msn,
        'YIM_IMG' => $yim_img,
        'YIM' => $yim,

        'LOCATION' => ( $profiledata['user_from'] ) ? $profiledata['user_from'] : '&nbsp;',
        'OCCUPATION' => ( $profiledata['user_occ'] ) ? $profiledata['user_occ'] : '&nbsp;',
        'INTERESTS' => ( $profiledata['user_interests'] ) ? $profiledata['user_interests'] : '&nbsp;',
'GENDER' => $gender,
        'AVATAR_IMG' => $avatar_img,

        'L_VIEWING_PROFILE' => sprintf($lang['Viewing_user_profile'], $profiledata['username']),
        'L_ABOUT_USER' => sprintf($lang['About_user'], $profiledata['username']),
        'L_AVATAR' => $lang['Avatar'],
        'L_POSTER_RANK' => $lang['Poster_rank'],
        'L_JOINED' => $lang['Joined'],
        'L_TOTAL_POSTS' => $lang['Total_posts'],
        'L_SEARCH_USER_POSTS' => sprintf($lang['Search_user_posts'], $profiledata['username']),
        'L_CONTACT' => $lang['Contact'],
        'L_EMAIL_ADDRESS' => $lang['Email_address'],
        'L_EMAIL' => $lang['Email'],
        'L_PM' => $lang['Private_Message'],
        'L_ICQ_NUMBER' => $lang['ICQ'],
        'L_YAHOO' => $lang['YIM'],
        'L_AIM' => $lang['AIM'],
        'L_MESSENGER' => $lang['MSNM'],
        'L_WEBSITE' => $lang['Website'],
        'L_LOCATION' => $lang['Location'],
        'L_OCCUPATION' => $lang['Occupation'],
        'L_INTERESTS' => $lang['Interests'],
'L_GENDER' => $lang['Gender'],

        'U_SEARCH_USER' => append_sid("search.$phpEx?search_author=" . urlencode($profiledata['username'])),

        'S_PROFILE_ACTION' => append_sid("profile.$phpEx"))
);

$template->pparse('body');

include("includes/page_tail.php");

?>


And when I change $nukedate = strtotime($regdate); to $nukedate = ($regdate); there is no difference.
 
hitwalker
PostPosted: Sat Oct 08, 2005 6:40 am Reply with quote

Well in the file you have :
Code:


//
// Calculate the number of days this user has been a member ($memberdays)
// Then calculate their posts per day
//
$nukedate = strtotime($regdate);




Isnt that the "strtotime" ?
Try fooling around with that one.
 
mr-brain
PostPosted: Sat Oct 08, 2005 6:44 am Reply with quote

As mentioned before;

Quote:
And when I change $nukedate = strtotime($regdate); to $nukedate = ($regdate); there is no difference.


I just had a look in the db but there are the correct dates so it can't be a problem in the db.
 
hitwalker
PostPosted: Sat Oct 08, 2005 7:04 am Reply with quote

but i dont see you changed any into timestamp as i posted before.
 
hitwalker
PostPosted: Sat Oct 08, 2005 7:10 am Reply with quote

and as im still reading it seems that this can be caused by numerous reasons.
however your issue might be handled here.. Only registered users can see links on this board! Get registered or login!
 
mr-brain
PostPosted: Sat Oct 08, 2005 3:28 pm Reply with quote

No, still no succes. You know what, I think I'll leave it to this. It seems to work just fine even if I can't see the correct regdate. My guess is that it has got something to do with the gender_hack I am using. I am not quite sure where it goes wrong. As said before in the db everything is correct, also in the memberlist everything shows up correct. As I am a rookie in this field I'll leave it just as it is.

Many thanks though for your kind help Hitwalker!!!

Bedankt.
 
hitwalker
PostPosted: Sat Oct 08, 2005 3:32 pm Reply with quote

well then the only thing left is server side.
ive read a few things about the date problem and your not the only one with this problem..
ive read reasons like its because of unix,because of english time and the list goes on and on...
But if its not in the database or in your site / phpbb files then only thing left is the server...
 
mr-brain
PostPosted: Sat Oct 08, 2005 5:07 pm Reply with quote

Okay, I have found the problem but I don't know enough of PHP to change the code to make it work. So if someone could please help me with this....

I altered the nuke_user_temp and added user_gender between user_regdate and check_num. The details of this field are: user_gender TINYINT 0 NOTNULL.

The PHP code for the resend e-mail module is;

Code:
<?php

/************************************************************************/
/* PHP-NUKE: Web Portal System                                          */
/* ===========================                                          */
/*                                                                      */
/* Copyright (c) 2002 by Francisco Burzi                                */
/* http://phpnuke.org                                                   */
/*                                                                      */
/* This program is free software. You can redistribute it and/or modify */
/* it under the terms of the GNU General Public License as published by */
/* the Free Software Foundation; either version 2 of the License.       */
/************************************************************************/
/************************************************************************/
/* Module by Gaylen Fraley                                              */
/* http://ravenphpscripts.com                                           */
/* http://ravenwebhosting.com                                           */
/* For use with nuke 6.5+                           .                   */
/* Change History                                                       */
/* 06/25/2005 - Version 2.0.2 Released                                  */
/*            - Fixed bug: the resend password was empty                */
/* 06/24/2005 - Version 2.0.1 Released                                  */
/*            - Fixed bug: the buttons were not language independent    */
/*            - German language translation added (Susan)               */
/*              Thanks to Susann for discovering the bug!               */
/* 06/12/2005 - Version 2.0.0 Released                                  */
/*            - Converted to new sql layer                              */
/*            - Converted & to &amp; where appropriate                  */
/*            - Efficiency modifications                                */
/*            - Added auto-refresh code to redirect where appropriate   */
/*            - Added date and timestamp added to the Waiting screen    */
/*            - Added language defines                                  */
/*            - Miscellaneous other tweaks                              */
/* 05/19/2003 - Added Modification facility to allow the Admin to make  */
/*              selected modifications to the temporary record.         */
/* 05/18/2003 - Fixed password display in email and added hyperlink     */
/*              to the display to allow the Admin to activate the user  */
/*              right from the module. The password will now be changed */
/*              when resending the email.                               */
/* 05/09/2003 - Released                                                */
/************************************************************************/

require_once("mainfile.php");
include("header.php");
$module_name = basename(dirname(__FILE__));
get_lang($module_name);
$userpage = 1;
OpenTable();
title("$sitename:<br />"._PENDINGREGISTRATIONS);

if(!defined('MODULE_FILE') AND !eregi("modules.php", $_SERVER['PHP_SELF'])) {
   echo '<center><b>'._NOACCESS._SPACE1._RDHOME._SPACE1._TWO._SPACE1._SECONDS.'</b></center><br />';
   CloseTable();
   header("Refresh: "._TWO."; URL=index.php");
   include("footer.php");
   exit();
}

if (!is_admin($admin)) {
   echo (_ACCESSDENIED);
   CloseTable();
   include("footer.php");
   exit();
}

if ($db->sql_numrows($db->sql_query("select * from ".$user_prefix."_users_temp"))==0) {
   echo '<center><b>'._NOWAITING._SPACE1._RDHOME._SPACE1._TWO._SPACE1._SECONDS.'</b></center><br />';
   CloseTable();
   header("Refresh: "._TWO."; URL=index.php");
   include("footer.php");
   exit();
}

extract($HTTP_POST_VARS);
if (isset($submit) && htmlentities($submit) == _LBLBTNRESEND) {
   for ($x=0; $x < 6; $x++) {
      mt_srand ((double) microtime() * 1000000);
      $con[$x] = substr(_CONS, mt_rand(0, strlen(_CONS)-1), 1);
      $voc[$x] = substr(_VOWELS, mt_rand(0, strlen(_VOWELS)-1), 1);
   }
   $makepass = $con[0] . $voc[0] .$con[2] . $con[1] . $voc[1] . $con[3] . $voc[3] . $con[4];
   $result = $db->sql_query("select * from ".$user_prefix."_users_temp where user_id=".$rsid);
   if(!$result) {
      echo _ERROR."<br>";
      CloseTable();
      include("footer.php");
      exit();
   }
   list($user_id, $username, $user_email, $user_password, $user_regdate, $check_num, $time) = $db->sql_fetchrow($result);
   $finishlink = "$nukeurl/modules.php?name=Your_Account&amp;op=activate&amp;username=$username&amp;check_num=$check_num";
   $message = ""._WELCOMETO." $sitename!\n\n"._YOUUSEDEMAIL." ($user_email) "._TOREGISTER." $sitename.\n\n "._TOFINISHUSER."\n\n $finishlink\n\n "._FOLLOWINGMEM."\n\n"._UNICKNAME." $username\n"._UPASSWORD." $makepass";
   $subject = ""._ACTIVATIONSUB."";
   $from = "$adminmail";
    $rc_email = mail($user_email, $subject, $message, "From: $from\nX-Mailer: PHP/" . phpversion());
    if (FALSE!==$rc_email) {
      echo _ACTMSGSENTLEFT._SPACE1.$username._SPACE1._ACTMSGSENTRIGHT;
      $result = $db->sql_query("update ".$user_prefix."_users_temp set user_password='".md5($makepass)."' where user_id=".$rsid);
      echo "<form method=\"post\" action=\"modules.php?name=".$module_name."\"><input type=\"submit\" value=\""._LBLBTNBACK."\"></form>";
   }
    else echo _SENDMAILERROR;
}
elseif (isset($delete) && htmlentities($delete) == _LBLBTNDELETE) {
   $result = $db->sql_query("delete from ".$user_prefix."_users_temp where user_id=".$rsid);
   if(!$result) {
      echo _ERROR."<br>";
      CloseTable();
      include("footer.php");
      exit();
   }
   echo '<center><b>'._TEMPRECDELRD._SPACE1._TWO._SPACE1._SECONDS.'</b></center><br />';
   CloseTable();
   header("Refresh: "._TWO."; URL=modules.php?name=".$module_name);
   include("footer.php");
   exit();
}
elseif (isset($update) && htmlentities($update) == _LBLBTNUPDATE) {
   $result = $db->sql_query("update ".$user_prefix."_users_temp set username='".$username."', user_email='".$user_email."', user_regdate='".$user_regdate."', check_num='".$check_num."', time='".$time."' where user_id=".$rsid);
   if(!$result) {
      echo _ERROR."<br>";
      CloseTable();
      include("footer.php");
      exit();
   }
   echo '<center><b>'._TEMPRECMODRD._SPACE1._TWO._SPACE1._SECONDS.'</b></center><br />';
   CloseTable();
   header("Refresh: "._TWO."; URL=modules.php?name=".$module_name);
   include("footer.php");
   exit();
}
elseif (isset($modify) && htmlentities($modify) == _LBLBTNMODIFY) {
   $result = $db->sql_query("select * from ".$user_prefix."_users_temp where user_id=".$rsid);
   if(!$result) {
      echo _ERROR."<br>";
      CloseTable();
      include("footer.php");
      exit();
   }
   list($user_id, $username, $user_email, $user_password, $user_regdate, $check_num, $time) = $db->sql_fetchrow($result);
   echo "<form method=\"post\" action=\"modules.php?name=$module_name&amp;file=index&amp;action=modify&amp;rsid=$user_id\" name=\"modifyform$rsid\">";
   echo '<table width="50%">';
   echo '<tr><td align="right">'._LBLUSERID.'</td><td>'.$user_id.'</td></tr>';
   echo '<tr><td align="right">'._LBLUSERNAME.'</td><td><input name="username" value="'.$username.'"></td></tr>';
   echo '<tr><td align="right">'._LBLUSEREMAIL.'</td><td><input name="user_email" value="'.$user_email.'"></td></tr>';
   echo '<tr><td align="right">'._LBLUSERPASSWORD.'</td><td>'.$user_password.'</td></tr>';
   echo '<tr><td align="right">'._LBLUSERREGDATE.'</td><td><input name="user_regdate" value="'.$user_regdate.'"></td></tr>';
   echo '<tr><td align="right">'._LBLUSERCHECKNUM.'</td><td><input name="check_num" value="'.$check_num.'"></td></tr>';
   echo '<tr><td align="right">'._LBLUSERTIME.'</td><td><input name="time" value="'.$time.'"></td></tr>';
   echo '<tr><td colspan="2"><input type="submit" name="update" value="'._LBLBTNUPDATE.'"></td></tr>';
   echo '</table></form>';
}
else {
   $result = $db->sql_query("select * from ".$user_prefix."_users_temp");
   if(!$result) {
      echo _ERROR."<br>";
      CloseTable();
      include("footer.php");
      exit();
   }

   while (list($user_id, $username, $user_email, $user_password, $user_regdate, $check_num, $time, $requestor) = $db->sql_fetchrow($result)) {
      $req = explode(":",$requestor);
      $requestor = "<a href=\"http://dnsstuff.com/tools/whois.ch?ip=".$req[0]."\" title=\"".$req[0]."\" target=\"_new_\">$requestor</a>";
      $finishlink = "<a href=\"$nukeurl/modules.php?name=Your_Account&amp;op=activate&amp;username=$username&amp;check_num=$check_num\" target=\"_blank\">$nukeurl/modules.php?name=Your_Account&amp;op=activate&amp;username=$username&amp;check_num=$check_num</a>";
      echo "<form method=\"post\" action=\"modules.php?name=$module_name&amp;file=index&amp;action=resend&amp;rsid=$user_id\" name=\"resendform$rsid\">";
      echo "<table width=\"100%\"><tr><td>"._LBLUSERNAME."</td><td>".$username."</td></tr><tr><td>"._LBLUSEREMAIL."</td><td>".$user_email."</td></tr><tr><td>"._LBLUSERREGDATE."</td><td>".date("F d, Y h:i:s A",$time)."</td></tr><tr><td>"._REQUESTOR."</td><td>".$requestor."</td></tr><tr><td>"._ACTLINK."</td><td>".$finishlink."</td></tr><tr><td colspan=\"3\"><input type=\"submit\" name=\"submit\" value=\""._LBLBTNRESEND."\">&nbsp;&nbsp;<input type=\"submit\" name=\"modify\" value=\""._LBLBTNMODIFY."\">&nbsp;&nbsp;<input type=\"submit\" name=\"delete\" value=\""._LBLBTNDELETE."\"></td></tr></table>";
      echo "</form>";
   }
}
CloseTable();
include("footer.php");
?>


I already tried to add user_gender into this code but that didn't work. If I delete user_gender from the nuke_users_temp everything works just fine. So my guess is that the problem exists in the code.
 
hitwalker
PostPosted: Sat Oct 08, 2005 5:20 pm Reply with quote

well im lost here....
ive send a pm to raven,he knows more about this...
 
Raven
Site Admin/Owner


Joined: Aug 27, 2002
Posts: 17086

PostPosted: Sat Oct 08, 2005 7:05 pm Reply with quote

Add the new field at the END of the table and this should work just fine.
 
View user's profile Send private message
Display posts from previous:       
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> General/Other Stuff

View next topic
View previous topic
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
You can attach files in this forum
You can download files in this forum


Powered by phpBB © 2001-2007 phpBB Group
All times are GMT - 6 Hours
 
Forums ©