[Done] New instant messages

[Chris Cromer]

Sorry about that, the alert one accidentally had an extra ! in it... I hit the ! key an extra time by accident. I will upload it again without the stupid ! in it.

[Chris Cromer]

Alright, I removed the ! and uploaded it. So uninstall the mod download it again and install this one(make sure to clear your cache before downloading it so you don't get the cached version).

[iamdamnsam]

where is the extra ! at?  I install by hand since I have changed alot of things in my files.

[Chris Cromer]

iamdamnsam this is what it looks like:

In subs.php look for:

Code Select Expand

      $request3 = mysql_query("SELECT COUNT(*) FROM {$db_prefix}instant_messages WHERE (toName='$username' && alerted!=1 && !deletedBy!=1)");

and replace it with:

Code Select Expand

      $request3 = mysql_query("SELECT COUNT(*) FROM {$db_prefix}instant_messages WHERE (toName='$username' && alerted!=1 && deletedBy!=1)");


[Hypocrite]

Didn't work for me.

[Chris Cromer]

Are you talking about the download?... I accidentally had my ftp program set in ASCII because I was uploading some .text files. Which means I uploaded it in ASCII.

I just now reuploaded it in binary form so download it again.

If your not talking about the download, are you talking about the error message still coming up?

[iamdamnsam]

me either

[Hypocrite]

The error message is still coming up

[iamdamnsam]

Parse error: parse error in /home/virtual/site1/fst/var/www/html/boards/Sources/Subs.php on line 192

Fatal error: Call to undefined function: clicklog() in /home/virtual/site1/fst/var/www/html/boards/index.php on line 55


this is the line that it shows erroring

$requestalerter mysql_query("SELECT im_alert FROM {$db_prefix}members WHERE memberName='$username'");

[Hypocrite]

this is the line that it shows erroring

$requestalerter mysql_query("SELECT im_alert FROM {$db_prefix}members WHERE memberName='$username'");

Yeap, that's it.

[Chris Cromer]

That is quite odd... the query is correct...

Check in the members table and see if im_alert is in the table, it should be right after im_email_notify.

[Hypocrite]

Checked that already. It's there.

[Chris Cromer]

Try changing that line to this and tell me if it fixes it:

Code Select Expand

      $requestalerter mysql_query("SELECT im_alert FROM {$db_prefix}members WHERE (memberName='$username')");

[Hypocrite]

No.

I have to go now. Please try to fix this because at the moment my forum is down completely.

[Chris Cromer]

Well until I figure out what is wrong with the alert version, try using the regular version.