Author Topic: [MOD] PM to owner of image when Comment ist posted  (Read 61730 times)

0 Members and 1 Guest are viewing this topic.

Offline Zyga

  • Jr. Member
  • **
  • Posts: 87
    • View Profile
Re: PM to owner of image when Comment ist posted
« Reply #30 on: April 07, 2006, 05:05:07 PM »
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   :cry:
it takes user_id field not comments_to_pm and (correct me if im wrong) it takes it from image table not users

Offline Frobman

  • Pre-Newbie
  • Posts: 7
    • View Profile
    • Bilderatlas-Deutschland
Re: PM to owner of image when Comment ist posted
« Reply #31 on: May 13, 2006, 11:55:13 AM »
Quote
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

Offline Zyga

  • Jr. Member
  • **
  • Posts: 87
    • View Profile
Re: PM to owner of image when Comment ist posted
« Reply #32 on: May 13, 2006, 04:06:03 PM »
Quote
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

Offline impss

  • Sr. Member
  • ****
  • Posts: 382
    • View Profile
    • Cusstom.net
Re: [MOD] PM to owner of image when Comment ist posted
« Reply #33 on: February 28, 2007, 04:08:39 AM »
Im getting this error as others have

Code: [Select]
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

Offline Flo2005

  • Full Member
  • ***
  • Posts: 237
  • Copy & Paste Profi :)
    • View Profile
    • snuup.de! - Bilder - Sounds - Videos - fun4FREE!
Re: [MOD] PM to owner of image when Comment ist posted
« Reply #34 on: February 28, 2007, 06:39:09 AM »
Im getting this error as others have

Code: [Select]
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

Project offline

Offline impss

  • Sr. Member
  • ****
  • Posts: 382
    • View Profile
    • Cusstom.net
Re: [MOD] PM to owner of image when Comment ist posted
« Reply #35 on: February 28, 2007, 07:05:25 AM »
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?

Offline impss

  • Sr. Member
  • ****
  • Posts: 382
    • View Profile
    • Cusstom.net
Re: [MOD] PM to owner of image when Comment ist posted
« Reply #36 on: February 28, 2007, 03:26:27 PM »
Thank you it looks to be working. And Thanks for the quick responce
 8)


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

Offline Jan-Lukas

  • Addicted member
  • ******
  • Posts: 1.289
    • View Profile
    • Discover the New World of Kindersurprise
Re: [MOD] PM to owner of image when Comment ist posted
« Reply #37 on: June 02, 2007, 01:25:31 AM »
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
Danke Harald