The Arcive of Official vBulletin Modifications Site.

RichieBoy67 · #1 04-13-2005, 11:33 PM

OK, we are trying to import new members from an existing pages membersign on page to a vb database...

Right now there is the following

PHP Code:


			
// VBulletin account creation

      $PasswordDate = date("Y-m-d");

                        $JoinDate = time();

                        OpenDB("INSERT INTO vb_user

                                                        (usergroupid, username, password, passworddate, email, usertitle, joindate, showvbcode)

                                                        VALUES

                                                        (2,'$Username',md5(md5('$Password')),'$PasswordDate','$Email','Junior Member',$JoinDate,2)");



                        // save user count and new user id to template 

                        

                        // get total members

                        $result = OpenDB("SELECT COUNT(*) AS users, MAX(userid) AS max FROM vb_user");

                        $row = mysql_fetch_assoc($result);

                        

                        $members = $row['users'];

                        $maxmembers = $row['max'];

                        

                        $result = OpenDB("SELECT userid, username FROM vb_user WHERE userid = $maxmembers");

                        $row = mysql_fetch_assoc($result);

                        

                        $newestusername = $row['username'];

                        $newuserid = $row['userid'];

                

                        // make a little array with the data

                        $values = array(

                                'numbermembers' => $members,

                                'newusername' => $newestusername,

                                'newuserid' => $newuserid

                        );



                        OpenDB("REPLACE INTO vb_datastore (title, data) VALUES ('userstats', '" . serialize($values) . "')");

                                        





                        // End VBulletin account creation        

/* ----------------------------------- */

This seems to work somehwhat but new registrants end up being only guests. My guess is that there needs to be another querrie sending user info into the usergroup table??? Am I on the right track here???

By the way--- This current script makes the new registrants guests but to fix all that needs to be done is counter updating....

I would really, really appreciate any input on this,

Thanks so much,

Rich

Zachery · #2 04-14-2005, 12:46 AM

Quote:

Originally Posted by RichieBoy67

OK, we are trying to import new members from an existing pages membersign on page to a vb database...

Right now there is the following

PHP Code:


			
// VBulletin account creation

      $PasswordDate = date("Y-m-d");

                        $JoinDate = time();

                        OpenDB("INSERT INTO vb_user

                                                        (usergroupid, username, password, passworddate, email, usertitle, joindate, showvbcode)

                                                        VALUES

                                                        (2,'$Username',md5(md5('$Password')),'$PasswordDate','$Email','Junior Member',$JoinDate,2)");



                        // save user count and new user id to template 

                        

                        // get total members

                        $result = OpenDB("SELECT COUNT(*) AS users, MAX(userid) AS max FROM vb_user");

                        $row = mysql_fetch_assoc($result);

                        

                        $members = $row['users'];

                        $maxmembers = $row['max'];

                        

                        $result = OpenDB("SELECT userid, username FROM vb_user WHERE userid = $maxmembers");

                        $row = mysql_fetch_assoc($result);

                        

                        $newestusername = $row['username'];

                        $newuserid = $row['userid'];

                

                        // make a little array with the data

                        $values = array(

                                'numbermembers' => $members,

                                'newusername' => $newestusername,

                                'newuserid' => $newuserid

                        );



                        OpenDB("REPLACE INTO vb_datastore (title, data) VALUES ('userstats', '" . serialize($values) . "')");

                                        





                        // End VBulletin account creation        

/* ----------------------------------- */

This seems to work somehwhat but new registrants end up being only guests. My guess is that there needs to be another querrie sending user info into the usergroup table??? Am I on the right track here???

By the way--- This current script makes the new registrants guests but to fix all that needs to be done is counter updating....

I would really, really appreciate any input on this,

Thanks so much,

Rich

Are you upading the other tables? there are at LEAST 3 tables you need to insert new data into.

RichieBoy67 · #3 04-14-2005, 01:17 AM

Could you please eloborate??? Members will not be registering through VBs registration page--just the sites main page... That is why I didn't think the other tables were needed......

Zachary.... Isn't there a hack somewhere that adds you to credits or something???? I am going to have to install that. You have helped me so many times!!!

Thanks!!

tnguy3n · #4 04-14-2005, 01:49 AM

I think you need to insert into passwordhistory + session table.

RichieBoy67 · #5 04-14-2005, 02:00 AM

wow- I am way off on this one I guess.....

It seemed that everything worked fine after updating counters.... I thought it was just a usergroup querrie that was needed similiar to the querrie added to the user table....

Link14716 · #6 04-14-2005, 03:25 AM

Quote:

Originally Posted by RichieBoy67

Could you please eloborate??? Members will not be registering through VBs registration page--just the sites main page... That is why I didn't think the other tables were needed......

Zachary.... Isn't there a hack somewhere that adds you to credits or something???? I am going to have to install that. You have helped me so many times!!!

Thanks!!

Those other tables are needed since vB always assumes the row will be there.

RichieBoy67 · #7 04-14-2005, 11:12 AM

That makes sense....

Could I bother you to be more specific though and tell me which querries etc are needed????? I am very confused with all of this....

So I guess I was at least on the right track. A querrie does have to be added to usergroups but what other tables???? userfields??

Thanks

Zachery · #8 04-14-2005, 03:05 PM

user
userfield
usertextfield

I think.

RichieBoy67 · #9 04-14-2005, 03:45 PM

Thanks Zachary!!

Closer than I was but still having a hard time with this.... Tough one I guess...

By any chance.... did you see my post on the other site???? Maybe you can help me there...... Should be an easy one for you.....

I'm adding you to credits tonight by the way.... you deserve it Zachary... seriously man.. I am not just kissing but... you really have helped me so many dam times...... I appreciate it man.. Thanks

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.05984 seconds Memory Usage 2,277KB Queries Executed 11 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (1)ad_showthread_firstpost (1)ad_showthread_firstpost_sig (1)ad_showthread_firstpost_start (2)bbcode_php (2)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)navbar (3)navbar_link (120)option (9)post_thanks_box (9)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (9)post_thanks_postbit_info (9)postbit (9)postbit_onlinestatus (9)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.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/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.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 showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!