vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   Welcome to our newest member (https://vborg.vbsupport.ru/showthread.php?t=113684)

suzkaw 04-21-2006 05:37 PM

Welcome to our newest member
 
I have created a login share where if they register at our main site they will automatically be registered to our forums. This works fine but on the forums at the bottom where it has "Welcome to our newest member, xxxx" never seems to update unless I go to admincp and update the users through the reset counters.

So I was wondering if I am missing a field with my insert?

Here is the code I have:
PHP Code:

$sSQL='INSERT INTO '.$tableprefix.'user SET
                       username = "'
.$username.'",
                       usergroupid = "'
.$user['usergroupid'].'",
                       email = "'
.$email.'",
                       joindate = "'
.time().'",
                       password = "'
.$password.'",
                       lastvisit = "'
.time().'",
                       lastactivity = "'
.time().'",
                       passworddate = NOW(),
                       showvbcode = 1,
                       daysprune = "-1",
                       timezoneoffset = 0,
                       options = "3159",
                       salt = "'
.$salt.'"';
    
$result=$database_vb->query($sSQL);
    
$userid=$result->insertID();

    
$sSQL='INSERT INTO '.$tableprefix.'usertextfield SET userid = '.$userid;
    
$database_vb->query($sSQL);
    
$sSQL='INSERT INTO '.$tableprefix.'userfield SET userid = '.$userid;
    
$database_vb->query($sSQL);
    
$sSQL='INSERT INTO '.$tableprefix.'passwordhistory SET userid = '.$userid.', password = "'.$password.'", passworddate = NOW()';
    
$database_vb->query($sSQL); 


suzkaw 04-24-2006 11:46 AM

I found it. You have to update the datastore table with the new details.


All times are GMT. The time now is 01:14 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.00954 seconds
  • Memory Usage 1,723KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_php_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (2)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete