Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 Programming Discussions
  #1  
Old 04-06-2002, 02:01 AM
duntuk duntuk is offline
 
Join Date: Mar 2002
Posts: 1
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Help with auto members usergroupid

I'm just beginning with PHP/mysql... so i don't know what i'm really doing...

I'm working on this script where paying members (which would also be registered vbulletin users) would go into a password protected area on the site and be able to enter their user name and password (which would be validated) and their usergroupid would be updated to "members" (which allows them to access certain parts of the forum where plain registered users won't be able to)..... in other words.... like the vbulletin.com paying members section validation...

This is what I've come up with so far:

The form page which would go into a normal php/html page:

Code:
 
<form name="updateid" method="post" action="useridupdate.php">
                          <input type="hidden" name="action" value="memberupdate">
						  <input type="text" name="username">
                          <input type="text" name="password">
                          <input type="submit" name="Submit" value="Update">
                        </form>
and the here is the php/mysql code I'm using:


PHP Code:

<?PHP

if (action=="memberupdate") {
  include(
"./global.php");
  if (isset(
$username)) {
    
// get userid for given username
    
if ($user=$DB_site->query_first("SELECT userid,username,password,cookieuser FROM user WHERE username='".addslashes(htmlspecialchars($username))."'")) {
     if (
$user['password']!=md5($password)) {  // check password
    //    eval("standarderror(\"".gettemplate("error_wrongpassword")."\");");
    
$msg="Wrong Password";
       exit;
     }
      
$userid=$user[userid];
    } 
    
    else { 
// invalid username entered
 //     eval("standarderror(\"".gettemplate("error_wrongusername")."\");");
     
$msg"Invalid Username Entered";
      exit;
    }

    if (
$user['cookieuser']==1) {
      
vbsetcookie("bbuserid",$user['userid']);
      
vbsetcookie("bbpassword",$user['password']);
    }

$DB_site->query("UPDATE user SET usergroupid='8' WHERE userid=$userid");

 
$msg"<p>User Updated!</p>";
      
 } 
}
?>

<html>
<head>
<title>Test</title>
</head>
<body>
<? echo "$msg"; ?>
</body>
</html>
The actual problem I'm having is NOT getting the usergroupid successfully updated when the correct user/pass combination is used..... because it DOES properly update the usergroupid...

However, the problem is.... I can't get the script to display a confirmation or error message.... actually when it's runed it displays *nothing*, i.e. no 'echo' text...
(note: I'm running this from the /admin directory simply for testing purposes, and i will definitely move it out of their after i get it working)

Thank you in advance to anyone who's able to debug this script....
Reply With Quote
  #2  
Old 04-06-2002, 02:08 AM
Steve Machol's Avatar
Steve Machol Steve Machol is offline
 
Join Date: Nov 2001
Posts: 1,896
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

duntuk, could you please go to this page and enter your username, to show you are licensed. (you will need to use your customer number and password to access that page)
Thank you.
Reply With Quote
Reply

Thread Tools
Display Modes

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 12:24 PM.


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.12101 seconds
  • Memory Usage 2,172KB
  • 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
  • (1)bbcode_code
  • (1)bbcode_php
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (2)post_thanks_box
  • (2)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (2)post_thanks_postbit_info
  • (2)postbit
  • (2)postbit_onlinestatus
  • (2)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