Table User

[gengar003]

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]

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]

and how would I change it in php?

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

but can prolly figure it out.


thanx.

[Gary King]

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]

so, I'd just do

PHP Code:

$bbuserinfo[myvar] = newval 


?

[Gary King]

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]

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

[Gary King]

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]

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]

Yes.