|
This thread is locked. Additional post Likes can not be added to locked threads.
|
|
|
Gizmo (Jan 15th 2020) |
Total Likes: 1 |
|
Re: Subscriptions Question
#263419
Jan 15th a 05:54 PM
|
by isaac |
isaac |
Take a look at the exact query from within the view_subscriptions.php script. Unless there are items missing from your ubbt_SUBSCRIPTIONS database, there really isnt much going on here except requesting "align and show me everything." which just passes along those requested values to the strings for the html template. the SQL
SELECT
t1.SUBSCRIPTION_ID, t2.USER_DISPLAY_NAME, t4.USER_REAL_EMAIL, t3.SUBSCRIPTION_NAME, t1.SUBSCRIPTION_START_DATE,
t1.SUBSCRIPTION_END_DATE, t1.SUBSCRIPTION_STATUS, t1.SUBSCRIPTION_IS_ACTIVE, t1.SUBSCRIPTION_PAYMENT, t1.USER_ID,
t3.GROUP_ID
FROM
ubbt_SUBSCRIPTION_DATA AS t1,
ubbt_USERS AS t2,
ubbt_SUBSCRIPTIONS AS t3,
ubbt_USER_PROFILE AS t4
WHERE
t1.USER_ID = t2.USER_ID AND
t1.GROUP_ID = t3.GROUP_ID AND
t1.USER_ID = t4.USER_ID
ORDER BY t1.SUBSCRIPTION_ID DESC
the naming of the SELECT output items: list($invoice_no, $userdisplay, $email, $name, $start, $end, $status, $active, $payment, $uid, $group_id)
the smarty template stuff, based on those strings:
$subs[] = array(
"invoice_no" => $invoice_no,
"display_name" => $userdisplay,
"email" => $email,
"name" => $name,
"start" => $start,
"end" => $end,
"status" => $status,
"active" => $active,
"payment" => $payment,
"uid" => $uid,
"group_id" => $group_id,
);
end of script.
|
|
Bots
by Outdoorking - 04/13/2024 5:08 PM
|
|
|
|
|
|
0 members (),
502
guests, and
178
robots. |
Key:
Admin,
Global Mod,
Mod
|
|
|
|
|