Public Karma log?

[finnhack]

Hi!

I'm looking for a way to make a public Karma-log, so that everyone can see who has given what kind of Karma to whom.

Can anyone kindly give me some ideas/codes how to fetch the right data from the database? I planned using the the data in log_karma-table, but due to my very poor PHP and MySQL skills I haven't managed to get all info together (for example putting the uid and real name together so that the log shows the users name instead of UID number)...

Thanks!

[Jack.R.Abbit]

OK... so you have a query that gets the Karma info from the karma log table... now if you query the members table with ID_TARGET or ID_EXECUTOR and get the memberName you will have user name of who did it to whom.  You might be able to write all of that into 1 query of all the tables but I'm not the great with the MySQL yet either.

-Jack

[David]

This mod could be tactfully evil but yet so friggen fun.

[finnhack]

This mod could be tactfully evil but yet so friggen fun.

Might be I am an evil person   But I really find this thing sort of important, and will probably try to work it out some how. So if I stay offline for the next two years, you know I'm working with the code.

edit:

Code Select Expand

$karma_result = mysql_query("SELECT * FROM {$db_prefix}log_karma ORDER BY logTime");
while($row_karmas = mysql_fetch_array($karma_result))
{
  echo "$row_karmas[ID_TARGET] $row_karmas[ID_EXECUTOR] $row_karmas[action]<br>\n";
}

Well, this simple code imports the Karmalog. My only problem is that I can't find out how to connect the ID_EXECUTOR and ID_TARGET to their respective real names in the members table...

[Jack.R.Abbit]

Code Select Expand

$karma_result = mysql_query("SELECT * FROM {$db_prefix}log_karma ORDER BY logTime");
while($row_karmas = mysql_fetch_array($karma_result))
{
 $target_result = mysql_query("SELECT memberName FROM {$db_prefix}members WHERE ID_MEMBER=$row_karmas[ID_TARGET] LIMIT 1");
 $row_target = mysql_fetch_array($target_result)

 $executor_result = mysql_query("SELECT memberName FROM {$db_prefix}members WHERE ID_MEMBER=$row_karmas[ID_EXECUTOR] LIMIT 1");
 $row_executor = mysql_fetch_array($executor_result)

 echo "$row_target[memberName] $row_executor[memberName] $row_karmas[action]<br>\n";
}
 Maybe some SQL wiz can simplify this but I think it works.

-Jack

[finnhack]

Thanks Jack! It works like a dream!

I changed the memberName to realName, and added two missing ";". The final, and for me working, code looks like this:

Code Select Expand


$karma_result = mysql_query("SELECT * FROM {$db_prefix}log_karma ORDER BY logTime DESC");
while($row_karmas = mysql_fetch_array($karma_result))
{
$target_result = mysql_query("SELECT realName FROM {$db_prefix}members WHERE ID_MEMBER=$row_karmas[ID_TARGET] LIMIT 1");
$row_target = mysql_fetch_array($target_result);

$executor_result = mysql_query("SELECT realName FROM {$db_prefix}members WHERE ID_MEMBER=$row_karmas[ID_EXECUTOR] LIMIT 1");
$row_executor = mysql_fetch_array($executor_result);
$ktime = timeformat( $row_karmas[logTime] );

print <<< EOT
 <tr onmouseover="javascript:style.backgroundColor='#eeeeee'" onmouseout="javascript:style.backgroundColor=''">
  <td style="padding : 2px; white-space : nowrap;">$ktime</td>
  <td style="padding : 2px; white-space : nowrap;">$row_executor[realName] gave $row_target[realName] a $row_karmas[action]</td>
 </tr>

EOT;

}


[Jack.R.Abbit]

Glad I could be of some use today.  

-Jack

[PioneeR]

This mod could be tactfully evil but yet so friggen fun.

Sounds like a very good idea to enable when boards get a bit dull

How do I do it? Where do I put the code?