uddeIM 0.7b released

16 years 7 months ago #47707 by frodon
Replied by frodon on topic Re:uddeIM 0.7b released
There's something i don't understand with uddeIM 0.7b.

I'm using it with fireboard and use a modifed fireboard report.php file to send "report to moderator" messages via PM and uddeIM rather than email.
However the code which is reported to work with uddeIM 0.6 don't work perfectly with uddeIM 0.7b.

The problem is that with uddeIM 0.7b the messages sent don't appear as "new" in the mail box depites the value "1" is passed to the toread variable.

Here is the uddeIM fonction :
[code:1]function SendUddeIM($reporter, $subject, $message, $msglink, $mods, $admins) {
global $database;
$time = mosFormatDate(FBTools::fbGetCurrentTime(), '%Y-%m-%d %H:%M:%S');

foreach ($admins as $admin) {
$database->setQuery("INSERT INTO #__uddeim (fromid, toid, message, datum, toread, disablereply) VALUES ('".$reporter."', '".$admin->id."', '".$message."', '".$time."', 1, 1)"«»);
$database->query();
}

foreach ($mods as $mod) {
$database->setQuery("INSERT INTO #__uddeim (fromid, toid, message, datum, toread, disablereply) VALUES ('".$reporter."', '".$mod->id."', '".$message."', '".$time."', 1, 1)"«»);
$database->query();
}
mosErrorAlert('' . _FB_REPORT_SUCCESS . '', 'window.history.go(-2);');
}[/code:1]

Could someone tell me how to modify this to make the messages sent to be seen as new.

Thanks a lot.

Please Log in to join the conversation.

16 years 7 months ago #47708 by slabbi
Replied by slabbi on topic Re:uddeIM 0.7b released
toread=1 means that the message has been read, so it is not a bug in uddeIM (and you should have the same problem with uddeIM 0.5 and 0.6) ;)

uddeIM & uddePF Development
CB Language Workgroup
CB 3rd Party Developer

Please Log in to join the conversation.

16 years 7 months ago #47710 by frodon
Replied by frodon on topic Re:uddeIM 0.7b released
arg, my bad, thanks for answering my silly question, i'll try that but i'm sure it will solve this problem.

Thank you.

Please Log in to join the conversation.

16 years 7 months ago #47895 by Scotsgait
Replied by Scotsgait on topic Re:uddeIM 0.7b released
My apologies, but I'm not that great on SQL. CAn you clarify this for me, please ?

Where you say that we need to

Update the database (go to myphpadmin and enter following SQL statement in the SQL box,
this will create the missing fields).

ALTER TABLE `jos_uddeim` ADD `cryptmode` INT( 1 ) DEFAULT '0' NOT NULL ;
ALTER TABLE `jos_uddeim` ADD INDEX `toid_toread` ( `toid` , `toread` ) ;
ALTER TABLE `jos_uddeim_emn` ADD INDEX ( `userid` ) ;
UPDATE `jos_uddeim` SET totrashoutbox=1, totrashdateoutbox=1 WHERE (systemmessage IS NOT NULL) AND (totrashoutbox=0) ;


Is this the same as running an SQL query ?

Thanks

Post edited by: Scotsgait, at: 2007/10/14 23:03

Please Log in to join the conversation.

16 years 7 months ago #47897 by slabbi
Replied by slabbi on topic Re:uddeIM 0.7b released
Scotsgait wrote:

Is this the same as running an SQL query ?


Yes, it is.

uddeIM & uddePF Development
CB Language Workgroup
CB 3rd Party Developer

Please Log in to join the conversation.

16 years 7 months ago #47905 by Scotsgait
Replied by Scotsgait on topic Re:uddeIM 0.7b released
slabbi wrote:

Scotsgait wrote:

Is this the same as running an SQL query ?


Yes, it is.


Thanks

Please Log in to join the conversation.

Moderators: beatnantslabbikrileon
Time to create page: 0.241 seconds

Facebook Twitter LinkedIn