Started by Guest, Dec 26, 2011, 09:41 pm

previous topic - next topic

0 Members and 1 Guest are viewing this topic.


   //Let's prep the account to get some info...
      SELECT cx.id_member, cx.uname, cx.requestd, cx.nextbd, cx.cxreasons,
         cx.intnotes, ls.start_time, a.payment_provider, a.ccFirst6, a.ccLast4
      FROM ADMIN_cxrequests AS cx
      LEFT JOIN z_log_subscribed AS ls ON (ls.id_member = cx.id_member)
      INNER JOIN account AS a ON (ls.id_member = a.id_member)
      WHERE cx.cxid='$cxid'
      AND ls.id_member = cx.id_member
      AND ls.id_subscribe = '1'
   "); echo mysql_error();

Browser ID: smf ()
Templates: 4: index (default), Display (default), GenericControls (default), GenericControls (default).
Sub templates: 6: init, html_above, body_above, main, body_below, html_below.
Language files: 3: index+Modifications.english (default), Post.english (default), Editor.english (default).
Style sheets: 3: index.css, jquery.sceditor.css, responsive.css.
Hooks called: 39 (show)
Files included: 27 - 991KB. (show)
Memory used: 976KB.
Tokens: post-login.
Cache hits: 17: 0.00190s for 26,707 bytes (show)
Cache misses: 3: (show)
Queries used: 12.

[Show Queries]