ProfileBook 1.0 - notify in cb_login

[code:1] function ShowKarmaBox($name_lenght, $pass_lenght, $horizontal, $class_sfx, &$params) {
global $my,$database;
if ($my->id) {
$database->setQuery("select var_karma,total_karma,user_id from `#__karma_tb` where `user_id` = '".$my->id."' limit 1"«»);
$row = $database->loadObjectList();
$row=$row[0];
if (!$row->var_karma) {
$var_karma=0;
$total_karma=0;
} else {
$var_karma=$row->var_karma;
$total_karma=$row->total_karma;
}
$return = "<table width=\"100%\" border=\"0\">"
."<tr><td colspan=\"4\" class=sectiontableheader><a href=\""
.sefRelToAbs('index.php?option=com_karma&task=stats')
."\">Props!</a></td></tr>"
."<tr class=sectiontableentry1><td width=\'30%\">Month:</td><td width=\'20%\">".$var_karma."</td><td width=\'30%\">Total:</td><td width=\'20%\">".$total_karma."</td></tr>"
."</table>";
} else {
$return = "<div style=\"text-align: left;\"><strong>Sign in for props</strong></div>";
}
return $return;
}
[/code:1]

This notify does break the Feedback function in guestbook.

I get the following error:

pbUpdate SQL error: DB function failed with error number 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'status='' WHERE id='395'' at line 1 SQL=UPDATE jos15_comprofiler_plug_profilebook SET feedback='test', published='1' status='' WHERE id='395'
SQL =

UPDATE jos15_comprofiler_plug_profilebook SET feedback='test', published='1' status='' WHERE id='395'

I don't know, what's going wrong now

Hi, sorry, i should have been following this as i implemented this and got it working fine.

yes it did break the feedback function, but i fixed that (cant remember how now...)

I will try to attach my file here, but you should note that it has also been adjusted to allow image posts and code from allvideo plugin to work (thanx to SoM for the allvideo and another post here for the images).

If you have made the database adjustment and cb login adjustment then you would only need to add the attached file (backup your one first!)

NuMoon

yay! i got thanks

check out on my site what i did with the PU_RPS challenges, as well as the pm notification and more

i love the new cb login plugin place

SoM

Hello friends,

Any chance to have RC 1.4 Compatible Cb Login Module to notify profile entries?

Thanks:)

Hey SoM,

Did you manage to get the notifier to work as a proper plugin, or with the hacked login module code (obviously we would all prefer it as a proper plugin).



Best,

NuMoon