- Forums and subforums. Subforums are placed into a new category.
- Topics
- Posts
- Users
- Groups
- Ranks
- Private messages
- Topics watch
- Polls
- Banned list
- Censored words
Download
D¡cky wrote: Are you looking at the vb3_pmtext table?
Are both the sender and receiver members of your vB board?
justinkim wrote: That link redirects me to http://portal.tds.net/. You may have to zip it.
Code: Select all
else
if ($users_left == 0)
{
$users_left = $user_default;
}
{
$sql = "SELECT m.*, mf.*, mtf.* FROM " . VB3_MEMBERS_TABLE . " m, ".VB3_MEMBERS_FIELD_TABLE." mf, ".VB3_MEMBERS_TEXTFIELD_TABLE." mtf WHERE m.userid = mf.userid AND m.userid = mtf.userid LIMIT $user_loc,$users_left "; // on the last pass only what is left
}
Code: Select all
else
{
if ($users_left == 0)
{
$users_left = $user_default;
}
$sql = "SELECT m.*, mf.*, mtf.* FROM " . VB3_MEMBERS_TABLE . " m, ".VB3_MEMBERS_FIELD_TABLE." mf, ".VB3_MEMBERS_TEXTFIELD_TABLE." mtf WHERE m.userid = mf.userid AND m.userid = mtf.userid LIMIT $user_loc,$users_left "; // on the last pass only what is left
}
Code: Select all
$sql = "SELECT joindate FROM " . VB3_MEMBERS_TABLE . " where userid = 1";
Code: Select all
$sql = "SELECT MIN(joindate) as joindate FROM " . VB3_MEMBERS_TABLE ;