Profile Viewed

[djsammy]

can some one help me with this please
Profile viewed: times this coding i got

<div class='codetop'>CODE</div><div class='codemain' style='height:200px;white-space:pre;overflow:auto'>$nopl = mysql_fetch_array(mysql_query("SELECT signature FROM ibwf_users WHERE id=".$who.""));
$sign = parsepm($nopl[0], $sid);
echo "Info: $sign
";
$noi = mysql_fetch_array(mysql_query("SELECT lastact FROM ibwf_users WHERE id=".$who.""));
$var1 = date("His",$noi[0]);
$var2 = time();
$var21 = date("His",$var2);
$var3 = $var21 - $var1;
$var4 = date("s",$var3);
echo "Idle For: ";
$remain = time() - $noi[0];
$idle = gettimemsg($remain);
echo "$idle
";
$nout = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_uploads WHERE uid=".$who.""));
echo "[b]Files Uploaded: $nout[0]
";
echo "Profile viewed: $sql2[0] times";</div>


or has some one got some thing like this please

[Guest]

echo "[b]Profile viewed:[/b] $sql2[0] times";

Where is the SQL query for $sql??

[rukiya]

I posted my profile code several months ago here.

[djsammy]

<div class='quotetop'>QUOTE (REY619 @ Mar 7 2009, 02:37 AM) <{POST_SNAPBACK}></div>

echo "[b]Profile viewed:[/b] $sql2[0] times";

Where is the SQL query for $sql??[/b]

i dont have one any one got sql for it please

[thunderwap]

<div class='quotetop'>QUOTE (djsammy @ Mar 8 2009, 12:42 AM) <{POST_SNAPBACK}></div>

i dont have one any one got sql for it please[/b]

sql query is

`profileview` int(100) NOT NULL default '0',

add this new row in ibwf_users

[jsyguy23]

<div class='codetop'>CODE</div><div class='codemain' style='height:200px;white-space:pre;overflow:auto'>
$vws=mysql_fetch_array(mysql_query("SELECT proviews FROM ibwf_users WHERE id=&#39;".$who."&#39;"));
$views=$vws[0]+1;
echo "Profile Views: $views
";
if(mypro(getuid_sid($sid), $who)){
echo "";}else{
mysql_query("UPDATE ibwf_users SET proviews=&#39;".$views."&#39; WHERE id=&#39;".$who."&#39;");}

and in core

////////////////////////////////////////profile views
function mypro($uid, $tid){
if($uid==$tid){return true;}
}
</div>

just if you not got rest

[djsammy]

<div class='quotetop'>QUOTE (jsyguy23 @ Mar 8 2009, 03:10 PM) <{POST_SNAPBACK}></div>

<div class='codetop'>CODE

<div class='codemain' style='height:200px;white-space:pre;overflow:auto'>
$vws=mysql_fetch_array(mysql_query("SELECT proviews FROM ibwf_users WHERE id=&#39;".$who."&#39;"));
$views=$vws[0]+1;
echo "Profile Views: $views
";
if(mypro(getuid_sid($sid), $who)){
echo "";}else{
mysql_query("UPDATE ibwf_users SET proviews=&#39;".$views."&#39; WHERE id=&#39;".$who."&#39;");}

and in core

////////////////////////////////////////profile views
function mypro($uid, $tid){
if($uid==$tid){return true;}
}
</div>

just if you not got rest[/b][/quote]
<div class='codetop'>CODE</div><div class='codemain' style='height:200px;white-space:pre;overflow:auto'>$vws=mysql_fetch_array(my sql_query("SELECT proviews FROM ibwf_users WHERE id=&#39;".$who."&#39;"));
$views=$vws[0]+1;
echo "Profile Views: $views
";
if(mypro(getuid_sid($sid), $who)){
echo "";}else{
mysql_query("UPDATE ibwf_users SET proviews=&#39;".$views."&#39; WHERE id=&#39;".$who."&#39;");}
</div> where in core does it go

[crazybrumi]

it doesnt start like a function so no lol. it goes in your profile action lmfao.

[jsyguy23]

<div class='codetop'>CODE</div><div class='codemain' style='height:200px;white-space:pre;overflow:auto'>
////////////////////////////////////////profile views
function mypro($uid, $tid){
if($uid==$tid){return true;}
}
</div>

only this bit goes in core pmsl

[djsammy]

<div class='quotetop'>QUOTE (jsyguy23 @ Mar 10 2009, 11:18 PM) <{POST_SNAPBACK}></div>

<div class='codetop'>CODE

<div class='codemain' style='height:200px;white-space:pre;overflow:auto'>
////////////////////////////////////////profile views
function mypro($uid, $tid){
if($uid==$tid){return true;}
}
</div>

only this bit goes in core pmsl[/b][/quote]
ok thanks mate

[djsammy]

<div class='quotetop'>QUOTE (djsammy @ Mar 11 2009, 04:31 AM) <{POST_SNAPBACK}></div>

ok thanks mate[/b]

i got this error when i done it

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/hardray/public_html/web/index.php on line 2963