how i can obtain the USER table from VB3 B7 ?!!

[random_X]

how i can obtain the USER table from VB3 B7 ?!!

i want only abstraction the specific VALU as :

username
password
e-mail

who this r done ?

[Faruk]

ew, font.
ew, spelling.
ew, what exactly are you trying to get? a database dump of your own db.user table or from someone elses? o_O

[rylin]

how i can obtain the USER table from VB3 B7 ?!!

i want only abstraction the specific VALU as :

username
password
e-mail

who this r done ?

You'll probably be asked to enter your license information in the members area.
I'd suggest you do it before someone asks you to do that

[Steve Machol]

The only way to do what you want is to download vB3 and either set up a test forum, or extract the queries to create the user table from the install file.

[random_X]

ew, font.
ew, spelling.
ew, what exactly are you trying to get? a database dump of your own db.user table or from someone elses? o_O

But u Got waht i want "KuraFire" ...

Now do u know how i make database dump for my own db.user table ?!!

[random_X]

You'll probably be asked to enter your license information in the members area.
I'd suggest you do it before someone asks you to do that

heh heh heh hehhee

[random_X]

The only way to do what you want is to download vB3 and either set up a test forum, or extract the queries to create the user table from the install file.

do u have any example ?!!

[Steve Machol]

You don't need an example. The actual query is in the install file as I said (mysql-schema.php). Assuming you are not using db prefixes, it is:

CREATE TABLE user (
		userid INT UNSIGNED NOT NULL AUTO_INCREMENT,
		usergroupid SMALLINT UNSIGNED NOT NULL DEFAULT '0',
		membergroupids CHAR(250) NOT NULL DEFAULT '',
		displaygroupid SMALLINT UNSIGNED NOT NULL DEFAULT '0',
		username CHAR(50) NOT NULL DEFAULT '',
		password CHAR(32) NOT NULL DEFAULT '',
		passworddate date NOT NULL DEFAULT '0000-00-00',
		email CHAR(50) NOT NULL DEFAULT '',
		styleid SMALLINT UNSIGNED NOT NULL DEFAULT '0',
		parentemail CHAR(50) NOT NULL DEFAULT '',
		homepage CHAR(100) NOT NULL DEFAULT '',
		icq CHAR(20) NOT NULL DEFAULT '',
		aim CHAR(20) NOT NULL DEFAULT '',
		yahoo CHAR(32) NOT NULL DEFAULT '',
		showvbcode SMALLINT UNSIGNED NOT NULL DEFAULT '0',
		usertitle CHAR(250) NOT NULL DEFAULT '',
		customtitle SMALLINT NOT NULL DEFAULT '0',
		joindate INT UNSIGNED NOT NULL DEFAULT '0',
		daysprune SMALLINT NOT NULL DEFAULT '0',
		lastvisit INT UNSIGNED NOT NULL DEFAULT '0',
		lastactivity INT UNSIGNED NOT NULL DEFAULT '0',
		lastpost INT UNSIGNED NOT NULL DEFAULT '0',
		posts INT UNSIGNED NOT NULL DEFAULT '0',
		reputation SMALLINT NOT NULL DEFAULT '0',
		reputationlevelid INT UNSIGNED NOT NULL DEFAULT '1',
		timezoneoffset CHAR(4) NOT NULL DEFAULT '',
		pmpopup SMALLINT NOT NULL DEFAULT '0',
		avatarid SMALLINT NOT NULL DEFAULT '0',
		avatarrevision INT UNSIGNED NOT NULL DEFAULT '0',
		options INT UNSIGNED NOT NULL DEFAULT '15',
		birthday CHAR(10) NOT NULL DEFAULT '',
		maxposts SMALLINT NOT NULL DEFAULT '-1',
		startofweek SMALLINT NOT NULL DEFAULT '1',
		ipaddress CHAR(15) NOT NULL DEFAULT '',
		referrerid INT UNSIGNED NOT NULL DEFAULT '0',
		languageid SMALLINT UNSIGNED NOT NULL DEFAULT '0',
		msn VARCHAR(100) NOT NULL DEFAULT '',
		emailstamp INT UNSIGNED NOT NULL DEFAULT '0',
		threadedmode SMALLINT UNSIGNED NOT NULL DEFAULT '0',
		autosubscribe SMALLINT UNSIGNED NOT NULL DEFAULT '-1',
		pmtotal SMALLINT UNSIGNED NOT NULL DEFAULT '0',
		pmunread SMALLINT UNSIGNED NOT NULL DEFAULT '0',
		salt CHAR(3) NOT NULL DEFAULT '',
		PRIMARY KEY (userid),
		KEY usergroupid (usergroupid),
		KEY username (username),
		KEY birthday (birthday)
);

[random_X]

THANK'S Steve

i didn't Know Where i can find it exactly ... But u make it easier ...


thank's agine