The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
||||
|
||||
Retrieving lastvisit, should be easy...
Ok this is my code
PHP Code:
|
#2
|
||||
|
||||
First of all, use the query_first() method instead of query() and then fetch_array(), since you are only getting one row of data.
Anyway, what you get (that long number) is in Unix Timestamp, and needs to be converted. Use: Code:
$userlastvisit = vbdate("FORMAT", $user['lastvisit']); |
#3
|
||||
|
||||
Thanx FireFly, that was MUCH easier than what I thought it would be. :bandit:
But about the query_first, if I use that I get an error in db_mysql about a bad argument, so I had to just use query. |
#4
|
||||
|
||||
If you use query_first() you don't need fetch_array(), because it does that internally.
So instead of: Code:
$getuser=$DB_site->query("SELECT * FROM user WHERE userid=$bbuserinfo[userid]"); while ($user=$DB_site->fetch_array($getuser)) { $username=$user[username]; $userlastvisit=$user['lastvisit']; $newposts="<a href=\"search.php?s=$session[sessionhash]&action=getnew\">View New Posts</a>"; $logout="<smallfont><a href=\"member.php?s=$session[sessionhash]&action=logout\">Log Out</a>"; $markallread="<a href=\"member.php?s=$session[sessionhash]&action=markread\">Mark All Forums Read</a>"; } Code:
$user=$DB_site->query_first("SELECT * FROM user WHERE userid=$bbuserinfo[userid]"); $username=$user[username]; $userlastvisit=$user['lastvisit']; $newposts="<a href=\"search.php?s=$session[sessionhash]&action=getnew\">View New Posts</a>"; $logout="<smallfont><a href=\"member.php?s=$session[sessionhash]&action=logout\">Log Out</a>"; $markallread="<a href=\"member.php?s=$session[sessionhash]&action=markread\">Mark All Forums Read</a>"; |
#5
|
||||
|
||||
Oh ok I got it now, sorry I'm still trying to learn all this coding.
|
#6
|
||||
|
||||
Firefly - what a timely post.
Thanks for this information. While we're on the subject, I was working over the weekend trying something along the same lines. I have Photopost installed along with vbulletin and I want to pop-up a little javascript message or display a blinking "photo gallery" graphic if there have been new photos posted in the gallery since the users last visit. The problem I was running into was selecting the photopost db in index.php. It would appear to get selected properly (since servername, username & password) are the same, but then I went to select data from the photpost db, I would get a message returned a string that said something like "Resource ID 27". I'm fairly confident the select_db was working ok becuase if I did not reselect the Vbulletin db at the end of my code, vb would throw errors. any ideas???? thanks if advance Firefly! - jeff |
#7
|
||||
|
||||
Code:
$result = mysql_query_db(...); Code:
$row = mysql_fetch_array($result); |
#8
|
||||
|
||||
cool - thanks!
now where do you want me to send contributions for that condo???? - jeff |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|