vb.org Archive - Table User

Page 1 of 3

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)

- - Table User (https://vborg.vbsupport.ru/showthread.php?t=53428)

gengar003

05-27-2003 12:33 AM

Table User

Okay, i'm not very good at mySQL, which Is why I'm asking this:

First off, what do all the Tinyint, null, etc things mean?

Second, Let's say I wanted to add a field to the table User, containing an on or off value, how would I do that?

And, once that was done, how would I use php to check if it's "on" or "off", and to change it to "on" or "off"?

... :cross-eyed:

filburt1

05-27-2003 12:46 AM

TINYINT is a datatype like long, int, String, etc.
NULL means literally "nothing."

[sql]
ALTER TABLE user ADD yourfield TINYINT(1) NOT NULL DEFAULT 0;
[/sql]

PHP Code:


		
			
if ($bbuserinfo['yourfield'])

{

    echo "on!";

}

else

{

    echo "off!";

}

gengar003

05-28-2003 12:56 AM

and how would I change it in php?

$DB_site => query (... *clueless...*

but can prolly figure it out. :)

thanx.

Gary King

05-28-2003 02:16 AM

Quote:

Today at 09:56 PM gengar003 said this in Post #3
and how would I change it in php?

$DB_site => query (... *clueless...*

but can prolly figure it out. :)

thanx.

You don't need to, vBulletin already grabs all the columns from the user table.

gengar003

05-28-2003 08:37 PM

so, I'd just do

PHP Code:


		
			
$bbuserinfo[myvar] = newval

Gary King

05-28-2003 08:52 PM

Quote:

Today at 05:37 PM gengar003 said this in Post #5
so, I'd just do

PHP Code:

$bbuserinfo[myvar] = newval

?

What exactly are you trying to do again?

PHP Code:


		
			
$bbuserinfo['myvar']

will already be set to whatever there is in the user table.

gengar003

05-30-2003 04:33 PM

I'm trying to change $bbuserinfo['myvar']

Gary King

05-30-2003 07:10 PM

Permanently in the database, or only when the script is processed?

Doing:

PHP Code:


		
			
$bbuserinfo['myvar'] = "newval";

will only set the variable for that moment. You can use phpMyAdmin to change the value(s) in the database, or use something like the following:

PHP Code:


		
			
$bbuserinfo['myvar'] = "newval";



$DB_site->query("UPDATE user SET 'col_name' = '".$bbuserinfo['myval']."' WHERE userid='".$bbuserinfo['userid']."' LIMIT 1");

gengar003

05-30-2003 10:15 PM

Quote:

Yesterday at 09:10 PM Gary W said this in Post #8

PHP Code:


		
			
$bbuserinfo['myvar'] = "newval";



$DB_site->query("UPDATE user SET 'col_name' = '".$bbuserinfo['myval']."' WHERE userid='".$bbuserinfo['userid']."' LIMIT 1");

Yes, permanently, like that, and I assume that 'col_name' is/would be well, um... so, to change $bbuserinfo['myvar'] to "newval", I'd do...

PHP Code:


		
			
$bbuserinfo['myvar'] = "newval";



$DB_site->query("UPDATE user SET 'myvar' = '".$bbuserinfo['myvar']."' WHERE userid='".$bbuserinfo['userid']."' LIMIT 1");

right?

Gary King

05-30-2003 10:57 PM

Yes.

All times are GMT. The time now is 07:02 AM.

Page 1 of 3

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01109 seconds Memory Usage 1,747KB 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 (8)bbcode_php_printable (3)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (2)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (10)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 pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: