Announcement

Collapse
No announcement yet.

What am I doing wrong in this script?

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • What am I doing wrong in this script?

    I get a Parse error: parse error, unexpected '{' in
    PHP Code:
    if (($bbuserinfo['profilefield23']='' ) OR ($bbuserinfo['profilefield23']= 'All')

    $dates$DB_site->query("
    SELECT "
    .TABLE_PREFIX."user.*, ".TABLE_PREFIX."avatar.avatarpath, NOT ISNULL(".TABLE_PREFIX."customavatar.avatardata) AS hascustomavatar, ".TABLE_PREFIX."customavatar.dateline, ".TABLE_PREFIX."customprofilepic.userid AS ".TABLE_PREFIX."profilepic, ".TABLE_PREFIX."customprofilepic.dateline AS ".TABLE_PREFIX."profilepicdateline 
    FROM "
    .TABLE_PREFIX."user AS ".TABLE_PREFIX."user
    LEFT JOIN " 
    TABLE_PREFIX "usertextfield AS ".TABLE_PREFIX."usertextfield ON(".TABLE_PREFIX."usertextfield.userid = ".TABLE_PREFIX."user.userid)
    LEFT JOIN " 
    TABLE_PREFIX "userfield AS ".TABLE_PREFIX."userfield ON(".TABLE_PREFIX."userfield.userid = ".TABLE_PREFIX."user.userid)
    LEFT JOIN " 
    TABLE_PREFIX "avatar AS ".TABLE_PREFIX."avatar ON(".TABLE_PREFIX."avatar.avatarid = ".TABLE_PREFIX."user.avatarid) 
    LEFT JOIN " 
    TABLE_PREFIX "customprofilepic AS ".TABLE_PREFIX."customprofilepic ON(".TABLE_PREFIX."user.userid = ".TABLE_PREFIX."customprofilepic.userid) 
    LEFT JOIN " 
    TABLE_PREFIX "customavatar AS ".TABLE_PREFIX."customavatar ON(".TABLE_PREFIX."customavatar.userid = ".TABLE_PREFIX."user.userid)
    WHERE "
    .TABLE_PREFIX."user.userid = ".TABLE_PREFIX."usertextfield.userid AND ".TABLE_PREFIX."user.usergroupid NOT IN (8) AND ".TABLE_PREFIX."userfield.field8 = 'female' AND ".TABLE_PREFIX."customprofilepic.visible = 1
    ORDER BY RAND()
    LIMIT 
    $perpage
    "
    );

    HELP... tring to do this on my own... its hard.

  • #2
    You should post it in one of the other forums
    http://www.vbulletin.com/forum/forumdisplay.php?f=24

    Another place would be www.vbulletin.org/forum

    Comment


    • #3
      Thank you and happy new year!

      Comment

      widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
      Working...
      X