The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
ok i added a custom user profile field with vb, and basically i'd like to know what the mysql query code is to show all users who have actually filled in the user profile field, as opposed to those who haven't. something like "SELECT (*) from user WHERE userinfo[field9] != NULL", although i know that's not right.. but hopefully you get the gist of it, heh.
|
#2
|
||||
|
||||
I'm not sure how you would do this for vB, but the syntax for the SQL query your looking for is this:
SELECT * FROM user WHERE field9 IS NOT NULL |
#3
|
||||
|
||||
Code:
SELECT * FROM user LEFT JOIN userfield USING (userid) WHERE field9<>"" |
#4
|
|||
|
|||
Quote:
Code:
// ############################## start showphotos ############################ if ($action=="showphotos") { include("./global.php"); eval("dooutput(\"".gettemplate("getinfo_showphotos")."\");"); while ($showpics=$DB_site->fetch_array($allphotos)) { eval("dooutput(\"".gettemplate("getinfo_showphoto_bit")."\");"); } // end while } |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|