Welcome to Geeklog, Anonymous Thursday, March 28 2024 @ 04:50 pm EDT

Geeklog Forums

YAPM - Yet Another Private Messenger

Page navigation


Status: offline

Robin

Forum User
Full Member
Registered: 02/15/02
Posts: 725
caffeinated
I found this oldie but goldie Smile and thought I'd give it a try.
I modified it a little, tested on GL 1.4 and looks like it does everything you'd expect a PM plugin should do.
File is waiting for you here.
There is still a lot work to be done on it e.g. stripping all the hardcoded language, polish it, etc.
As usual waiting for your feedback Very Happy
Geeklog Polish Support Team
 Quote

Status: offline

mugen

Forum User
Chatty
Registered: 02/22/06
Posts: 53
UPDATE: Plugin cause of SQL error? See below:
cedko.com -- Cartoonin' The World :)
 Quote

Status: offline

mugen

Forum User
Chatty
Registered: 02/22/06
Posts: 53
Quote by mugen: Hi Robin, I've installed it and it works great Big Celebration Thanks! mugen

cedko.com

Question: how do you make it so that when a new user registers at the site, they get a welcome PM?

Thanks, mugen
cedko.com -- Cartoonin' The World :)
 Quote

Status: offline

mugen

Forum User
Chatty
Registered: 02/22/06
Posts: 53
caffeinated
Hi, after installing the PM plugin I keep getting a SQL error everytime I log out! I think it's something to do with the php block code, because when I disable the PM block, the logout works fine.

Help? Can someone help me

Thanks, mugen


cedko.com -- Cartoonin' The World :)
 Quote

Status: offline

Robin

Forum User
Full Member
Registered: 02/15/02
Posts: 725
Quote by mugen: Hi, after installing the PM plugin I keep getting a SQL error everytime I log out!

Quoting the error would significantly help to investigate it Wink
Geeklog Polish Support Team
 Quote

Status: offline

mugen

Forum User
Chatty
Registered: 02/22/06
Posts: 53
Quote by Robin:
Quote by mugen: Hi, after installing the PM plugin I keep getting a SQL error everytime I log out!

Quoting the error would significantly help to investigate it Wink


Hi Robin, it just displays a blank page with the sentence:

MySQL error returned. (additional text here, can't remember).

Thanks, mugen
cedko.com -- Cartoonin' The World :)
 Quote

Status: offline

Robin

Forum User
Full Member
Registered: 02/15/02
Posts: 725
Could you switch it on so I can check it myself? Also you can test it on my site.

Anyone else is having this problem? Rolling Eyes
Geeklog Polish Support Team
 Quote

Status: offline

mugen

Forum User
Chatty
Registered: 02/22/06
Posts: 53
Quote by Robin: Could you switch it on so I can check it myself? Also you can test it on my site.

Anyone else is having this problem? Rolling Eyes


Hi Robin, it's active now you can see the error message when you logout from the website:
An SQL error has occurred. Please see error.log for details.

in error.log:
Wed 08 Mar 2006 23:04:47 GMT-8 - 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 'and receiverdelete='' and rd=''' at line 1. SQL in question: SELECT * FROM gl_pm WHERE sentto= and receiverdelete='' and rd=''

This only happens when I activate the php block for this plugin, otherwise it works fine.

Thanks for your help, mugen


cedko.com -- Cartoonin' The World :)
 Quote

Status: offline

bieffe

Forum User
Junior
Registered: 11/30/02
Posts: 16
hello,

i've tried this PM plugin. it's nice & simple but only one problem for me atm.

as what mugen posted, the problem occured when activate php block.

i'm 90% sure that the line below got problem.

$result = DB_query("SELECT * FROM {$_TABLES['pm']} WHERE sentto=" . $_USER['uid'] . " and receiverdelete='' and rd=''");


below are my error log.

Wed 08 Mar 2006 20:56:02 MYT - 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 'and receiverdelete='' and rd=''' at line 1. SQL in question: SELECT * FROM gl_pm WHERE sentto= and receiverdelete='' and rd=''
 Quote

Status: offline

Robin

Forum User
Full Member
Registered: 02/15/02
Posts: 725
There is one more thing that has to be done after installation of this plugin. You have to add pm.view feature to Logged-in users group.

This can be easily achieved using handy little script by Blaine called Group Access Tool.

I'll get back to you as soon as I have some answers to your issues Smile
Glad you you like it.
Smile
Geeklog Polish Support Team
 Quote

Status: offline

mugen

Forum User
Chatty
Registered: 02/22/06
Posts: 53
Quote by bieffe: hello,

i've tried this PM plugin. it's nice & simple but only one problem for me atm.

as what mugen posted, the problem occured when activate php block.

i'm 90% sure that the line below got problem.

$result = DB_query("SELECT * FROM {$_TABLES['pm']} WHERE sentto=" . $_USER['uid'] . " and receiverdelete='' and rd=''");


below are my error log.

Wed 08 Mar 2006 20:56:02 MYT - 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 'and receiverdelete='' and rd=''' at line 1. SQL in question: SELECT * FROM gl_pm WHERE sentto= and receiverdelete='' and rd=''


I think bieffe is on the right track.
cedko.com -- Cartoonin' The World :)
 Quote

Status: offline

Robin

Forum User
Full Member
Registered: 02/15/02
Posts: 725
Quote by mugen:in error.log:
[08-Mar-2006 19:48:18] PHP Parse error: parse error, unexpected T_STRING in /home/cedko2/system/lib-custom.php on line 450


What does it actually write in this line 450?
Geeklog Polish Support Team
 Quote

Status: offline

mugen

Forum User
Chatty
Registered: 02/22/06
Posts: 53
caffeinated
Quote by Robin:
Quote by mugen:in error.log:
[08-Mar-2006 19:48:18] PHP Parse error: parse error, unexpected T_STRING in /home/cedko2/system/lib-custom.php on line 450


What does it actually write in this line 450?


I'm sorry, I was looking at the wrong error log, the real error message is similar to bieffe's error:

Wed 08 Mar 2006 23:04:47 GMT-8 - 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 'and receiverdelete='' and rd=''' at line 1. SQL in question: SELECT * FROM gl_pm WHERE sentto= and receiverdelete='' and rd=''

Thanks for your help Robin - mugen
cedko.com -- Cartoonin' The World :)
 Quote

Status: offline

kr

Forum User
Newbie
Registered: 03/02/06
Posts: 4
Location:Germany
This plugin looks nice ... BTW: Installation performed without any error or problems on my v1.4.0sr2 site.

After installation i was also possible to send and recieve messages but does anyone now if the plugin has the possibility to inform a user about his new messages? Right now the only way i see to get informed that a new message was arrived is by manually checking the "Private Messaging" Inbox.

Any Ideas?

c'ya KR
 Quote

Status: offline

mugen

Forum User
Chatty
Registered: 02/22/06
Posts: 53
caffeinated
Quote by kr: This plugin looks nice ... BTW: Installation performed without any error or problems on my v1.4.0sr2 site.

After installation i was also possible to send and recieve messages but does anyone now if the plugin has the possibility to inform a user about his new messages? Right now the only way i see to get informed that a new message was arrived is by manually checking the "Private Messaging" Inbox.

Any Ideas?

c'ya KR


Hi KR, you need to create a special geeklog php block to inform users when they have a new message. To create a php block involves pasting some code in your /system/lib-custom.php file, then activating it in your block admin. Do a search on blocks to learn more.

To display when a new message has arrived, this is what bieffe and myself are trying to do now, but there seems to be some problem with the PM block code. Robin is helping to solve this problem.

Cheers, mugen
cedko.com -- Cartoonin' The World :)
 Quote

Status: offline

Robin

Forum User
Full Member
Registered: 02/15/02
Posts: 725
Quote by bieffe:
as what mugen posted, the problem occured when activate php block.


What version of MySql are you using?

I checked it on two versions and looks like 4.0.24 returns this error and 4.1.12 doesn't.
So maybe Mysql upgrade would help Rolling Eyes
Geeklog Polish Support Team
 Quote

Status: offline

mugen

Forum User
Chatty
Registered: 02/22/06
Posts: 53
Quote by Robin:
Quote by bieffe:
as what mugen posted, the problem occured when activate php block.


What version of MySql are you using?

I checked it on two versions and looks like 4.0.24 returns this error and 4.1.12 doesn't.
So maybe Mysql upgrade would help Rolling Eyes


Hi Robin, ISP is using 4.0.25 so can't upgrade. Thanks for your help Its a deal - shaking hands guess have to leave out the block for now.

mugen
cedko.com -- Cartoonin' The World :)
 Quote

Status: offline

bieffe

Forum User
Junior
Registered: 11/30/02
Posts: 16
Quote by Robin:
Quote by bieffe:
as what mugen posted, the problem occured when activate php block.


What version of MySql are you using?

I checked it on two versions and looks like 4.0.24 returns this error and 4.1.12 doesn't.
So maybe Mysql upgrade would help Rolling Eyes


my mysql version 4.1.15 Neutral
 Quote

Status: offline

Robin

Forum User
Full Member
Registered: 02/15/02
Posts: 725
OK
Let's give it a try.
I modified this sql from the block code and so far so good Smile
Test it please and let me know about the results
Text Formatted Code
        $result = DB_query("SELECT * FROM " . $_TABLES['pm'] . " WHERE sentto=" . $_USER['uid'] . " AND receiverdelete='' AND rd=''");

 

Geeklog Polish Support Team
 Quote

Status: offline

mugen

Forum User
Chatty
Registered: 02/22/06
Posts: 53
Quote by Robin: OK
Let's give it a try.
I modified this sql from the block code and so far so good Smile
Test it please and let me know about the results
Text Formatted Code
        $result = DB_query("SELECT * FROM " . $_TABLES['pm'] . " WHERE sentto=" . $_USER['uid'] . " AND receiverdelete='' AND rd=''");


 


Hi Robin, nope not working, error message:
Fri 10 Mar 2006 12:11:16 GMT-8 - 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 'AND receiverdelete='' AND rd=''' at line 1. SQL in question: SELECT * FROM gl_pm WHERE sentto= AND receiverdelete='' AND rd=''
cedko.com -- Cartoonin' The World :)
 Quote

Page navigation

All times are EDT. The time is now 04:50 pm.

  • Normal Topic
  • Sticky Topic
  • Locked Topic
  • New Post
  • Sticky Topic W/ New Post
  • Locked Topic W/ New Post
  •  View Anonymous Posts
  •  Able to post
  •  Filtered HTML Allowed
  •  Censored Content