Home News Contact Us Forum About Us Demos Products F.A.Q.
Shopping Cart
You currently have 0 items in your cart.


Recent Events
  • 31/12/2023 New Year SALE

    We are glad to announce New Year SALE. 25% discount for all our extensions. Use NY24 coupon code. Hurry up the discount is valid till 7 January.

  • 21/11/2023 BLACK FRIDAY 23 is coming

    BIG SALE, 35% discount for all our extensions. Use BF23 coupon code. Hurry up the discount is valid till 27 November.


2Checkout.com, Inc. is an authorized retailer of goods and services provided by ARI Soft. 2CheckOut




Follow us on twitter



Welcome, Guest
Please Login or Register.    Lost Password?

Predefined variables in SQL WHERE
(1 viewing) (1) Guest
Go to bottomPage: 1
TOPIC: Predefined variables in SQL WHERE
#49604
Predefined variables in SQL WHERE 10 Years, 1 Month ago Karma: 0
Hi!

Can you point me to information what are possible predefined variables used in WHERE clause for current log in user?
I found {$UserName} and {$UserID} but not list of all possibilities.
I would like to show data to logged in user based on his Joomla User Group membership.
I tried with WHERE PartnerGroup = {$UserGroupID} but without success.
The administrator has disabled public write access.
 
#49605
Re:Predefined variables in SQL WHERE 10 Years, 1 Month ago Karma: 748
Hello,

The following predefined variables are supported:

{$UserId}
{$UserType}
{$UserName}
{$UserLogin}
{$UserBlock}
{$UserEmail}


{$UserGroupId} predefined variable can be used in J! 1.5.

Regards,
ARI Soft
The administrator has disabled public write access.
 
Go to topPage: 1