Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 Programming Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 04-13-2005, 11:33 PM
RichieBoy67's Avatar
RichieBoy67 RichieBoy67 is offline
 
Join Date: Apr 2004
Location: CT - Down in a hole..
Posts: 3,057
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Qurrie Challenge...

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
Reply With Quote
  #2  
Old 04-14-2005, 12:46 AM
Zachery's Avatar
Zachery Zachery is offline
 
Join Date: Jul 2002
Location: Ontario, Canada
Posts: 11,440
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
Reply With Quote
  #3  
Old 04-14-2005, 01:17 AM
RichieBoy67's Avatar
RichieBoy67 RichieBoy67 is offline
 
Join Date: Apr 2004
Location: CT - Down in a hole..
Posts: 3,057
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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!!
Reply With Quote
  #4  
Old 04-14-2005, 01:49 AM
tnguy3n's Avatar
tnguy3n tnguy3n is offline
 
Join Date: May 2003
Location: U of I, Iowa
Posts: 846
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I think you need to insert into passwordhistory + session table.
Reply With Quote
  #5  
Old 04-14-2005, 02:00 AM
RichieBoy67's Avatar
RichieBoy67 RichieBoy67 is offline
 
Join Date: Apr 2004
Location: CT - Down in a hole..
Posts: 3,057
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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....
Reply With Quote
  #6  
Old 04-14-2005, 03:25 AM
Link14716's Avatar
Link14716 Link14716 is offline
 
Join Date: Jun 2002
Location: Georgia, USA
Posts: 2,519
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
Reply With Quote
  #7  
Old 04-14-2005, 11:12 AM
RichieBoy67's Avatar
RichieBoy67 RichieBoy67 is offline
 
Join Date: Apr 2004
Location: CT - Down in a hole..
Posts: 3,057
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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
Reply With Quote
  #8  
Old 04-14-2005, 03:05 PM
Zachery's Avatar
Zachery Zachery is offline
 
Join Date: Jul 2002
Location: Ontario, Canada
Posts: 11,440
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

user
userfield
usertextfield

I think.
Reply With Quote
  #9  
Old 04-14-2005, 03:45 PM
RichieBoy67's Avatar
RichieBoy67 RichieBoy67 is offline
 
Join Date: Apr 2004
Location: CT - Down in a hole..
Posts: 3,057
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 09:28 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.05266 seconds
  • Memory Usage 2,281KB
  • 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