[MOD] PM to owner of image when Comment ist posted

[Zyga]

oh, you are right.

you should use:
if ($image_row['user_id']) {
   here whole code from first page
}

$image_row['user_id'] is the image owner's user_id

hmmmm i dont understeand   
it takes user_id field not comments_to_pm and (correct me if im wrong) it takes it from image table not users

[Frobman]

but again i have problem

i receive PM but when i click on it
site works but over i see


Quote
DB Error: Bad SQL Query: SELECT COUNT(pm_id) AS total FROM 4images_pm WHERE pm_from = AND (pm_type = 2 OR pm_type = 0)
You have an error in your SQL syntax near 'AND (pm_type = 2 OR pm_type = 0)' at line 3

please help !
code is like it was :/ i change nothing

i dont know with one code fragment should i paste here

@Zyga: how did you solve the problem? (i´ve the same Error-Message)

Thx Frobman

[Zyga]

but again i have problem

i receive PM but when i click on it
site works but over i see


Quote
DB Error: Bad SQL Query: SELECT COUNT(pm_id) AS total FROM 4images_pm WHERE pm_from = AND (pm_type = 2 OR pm_type = 0)
You have an error in your SQL syntax near 'AND (pm_type = 2 OR pm_type = 0)' at line 3

please help !
code is like it was :/ i change nothing

i dont know with one code fragment should i paste here

@Zyga: how did you solve the problem? (i´ve the same Error-Message)

Thx Frobman

sorry but I do nothing it just start works few days later
I dont know how can I help

[ivan]

hi zusammen,
wäre es möglich bei pm_from anstatt immer den admin zu nehmen
die entsprechende id des absenders zu nehmen?

und wenn es ein gast ist, auch gast im der kopfzeile erscheint....

gruss ivan

[impss]

Im getting this error as others have

Code:  [Select]  [Expand]  [Hide line numbers]

1 2	DB Error: Bad SQL Query: SELECT COUNT(pm_id) AS total FROM 4images_pm WHERE pm_from = AND (pm_type = 2 OR pm_type = 0) 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 (pm_type = 2 OR pm_type = 0)' at line 3

any help?

thanks

[Flo2005]

Im getting this error as others have

Code:  [Select]  [Expand]  [Hide line numbers]

1 2	DB Error: Bad SQL Query: SELECT COUNT(pm_id) AS total FROM 4images_pm WHERE pm_from = AND (pm_type = 2 OR pm_type = 0) 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 (pm_type = 2 OR pm_type = 0)' at line 3

any help?

thanks

Which PHP Version is running on your server?

I´ll remember  you have to change something in pm.php when you´re running PHP5

[ivan]

correct this part:

$pm_from = 0; //Hier bitte die user_id vom Absender angeben

[impss]

Yea.. im running PhP5

correct this part:

$pm_from = 0; //Hier bitte die user_id vom Absender angeben

'

do i change that to a 1?

[ivan]

your user_id

[impss]

Thank you it looks to be working. And Thanks for the quick responce
 


Is there any way to change it so the Pm is sent from the commenter?

[Jan-Lukas]

hi zusammen,
wäre es möglich bei pm_from anstatt immer den admin zu nehmen
die entsprechende id des absenders zu nehmen?

und wenn es ein gast ist, auch gast im der kopfzeile erscheint....

gruss ivan

Hbe es mir auch gerade eingebaut, und finde auch das dort die ID des Absenders reingehört.
Über eine Lösung würde ich mich freuen

Danke
Harald