Wish List

[Darkorical]

she is still nagging me about the user names in the click log
I found this mod
View username @ forum ACCESS log

I changed it to get it to install on 1.5.1 .... but evidently I didnt do something right becasue it doesnt appear to work.... can you offer any help?

[Amacythe]

nagging?  NAGGING?!?  What are you talking about?  Just get over there and fix it already.  Geeez... sometimes I think you like hanging out here with your new friends more than with me... you don't love me anymore... **runs off crying**

[Iridium]

Forum DRAMA!!!! OMG OMG

[David]

Forum DRAMA!!!! OMG OMG

* David runs and screams like a school girl  

[Amacythe]

LOL

I sorta am still asking him all the time... When I used YaBB Gold the access list showed the people that had logged on by nick and YaBB SE is listing only IP numbers.  Is there a mod for showing nicks if possible?  If not, can someone write one for me?

[Darkorical]

so is someone working on this for me or not?

[[Unknown]]

Admin.php... find:

   $request = mysql_query("SELECT ip, agent, toUrl, fromUrl FROM {$db_prefix}log_clicks WHERE 1;") or database_error(__FILE__, __LINE__);

Replace:

   $request = mysql_query("SELECT mem.memberName AS ip, agent, toUrl, fromUrl FROM {$db_prefix}log_clicks LEFT JOIN P{$db_prefix}members AS mem ON (ip=memberIP);") or database_error(__FILE__, __LINE__);

-[Unknown]

[Darkorical]

Table 'yabbse.Pmembers' doesn't exist
File: /home/mysafeha/www/www/yabbse/Sources/Admin.php
Line: 1887

did I do something wrong?


well I took a shot in the dark

$request = mysql_query("SELECT mem.memberName AS ip, agent, toUrl, fromUrl FROM {$db_prefix}log_clicks LEFT JOIN P{$db_prefix}members AS mem ON (ip=memberIP);") or database_error(__FILE__, __LINE__);

I removed the P and it works thanks

[Amacythe]

and another thank you from me.

[[Unknown]]

.  Sorry, I made a typo.

Glad I could be of help.

-[Unknown]