vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   Adding a user to the database manually (https://vborg.vbsupport.ru/showthread.php?t=138060)

bkbelew 01-31-2007 08:50 PM
Adding a user to the database manually
 
I have seen a few people trying to do this, but haven't seen any code to do it successfully. I built a cms, i'm trying to make it where when a user is added they are automatically added to the vbulletin database. No matter what I try I cannot get it to work. Any ideas anyone?

I tried asking on Vbulletin.com but got redirected here.

Thank you

Code:
PHP Code:
 require('inc/admins/forumconnect.php');

 $saltlength = 3;
 $salt = '';
 for ($i = 0; $i < $saltlength; $i++)
 $salt .= chr(rand(32, 126));


  $pass = md5(md5($password) . $salt);

$date = strtotime("now");
$forumquery = mysql_query("INSERT INTO user ( username, password, email, usergroupid, options, passworddate, salt )
                               VALUES('$username','$pass','$email','2','7','$date','$salt')");

// Get userid

    $clientquery = mysql_query("SELECT * FROM user WHERE username = '$username' ");
    
   while ($client = mysql_fetch_array($client_query)) {


// Insert the users userid into the userfield table

 $userfield = mysql_query("INSERT INTO userfield ( userid, field1 )
                               VALUES('$client[userid]','NULL')");


// Insert the users userid into the usertextfield table

 $usertextfield = mysql_query("INSERT INTO usertextfield ( userid, subfolders, pmfolders, buddylist, ignorelist, signature, searchprefs )
                                VALUES('$client[userid]','NULL','NULL','NULL','NULL','NULL','NULL')");


} 

dionsis 01-31-2007 10:11 PM
i have a script called jamroom doing a similar thing inserting data into vbulletin and it appears to be inserting imformation into the user table and userfield table

only thing is the postbit doesnt look right, it has no user title, no post count, in place of post count we have N/A , its not functioning properly, i have to use AdminCP -> Update Counters -> Fix broken user profiles, to get the account back right

if anyone knows what information is missing or if more tables need an insert, that would be great

bkbelew 02-02-2007 04:58 AM
Can you post what code / scripts you have?

dionsis 02-04-2007 01:11 PM
its licensed code so i cant really

Antivirus 02-04-2007 10:29 PM
I would suggest including global.php and whatever else is needed to utilize vbulletin's user datamanager class. Check this out for more info...

https://vborg.vbsupport.ru/showthread.php?t=82836


All times are GMT. The time now is 06:16 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.00994 seconds
  • Memory Usage 1,726KB
  • 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
  • (5)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