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
(1 viewing) (1) Guest
Go to bottomPage: 123
TOPIC: Predefined variables
#14666
Re:Predefined variables 12 Years, 12 Months ago Karma: 0
Well the site is localhost, so no way to give you any access.

By the way, it seems to work with the $UserId, I got blank with $UserGroupId but the user is in several groups, so this may be the problem, I got "no available data" when using $UserName and $UserType which is probably due to an SQL error.

With debug activated I get this :

Fatal error: Cannot access protected property JDatabaseMySQL::$_debug in E:\wamp\www\j16\modules\mod_aridatatables\includes\kernel\DataTables\Models\class.DataTablesDataSqlModel.php on line 75

Edit :

I tested with the sql you provided :
SELECT
CONCAT(id,{$UserName})
FROM
#__content

And it works fine
Last Edit: 2011/05/10 13:48 By enricocerica.
The administrator has disabled public write access.
 
#14667
Re:Predefined variables 12 Years, 12 Months ago Karma: 0
Ok, I found the problem, I should use {$UserName} instead of '{$UserName}'

Thanks
The administrator has disabled public write access.
 
#14668
Re:Predefined variables 12 Years, 12 Months ago Karma: 748
It occurs because the module calls "JDatabase::Quote" method for predefined variables due to security reasons. It is not necessary to wrap it with quotes again.

PS: We have fixed problem with debug mode. Updated extension can be downloaded in "Member Area".

Regards,
ARI Soft
The administrator has disabled public write access.
 
#14670
Re:Predefined variables 12 Years, 12 Months ago Karma: 0
Ok thanks.
Would be nice to get more predefined fields like group name or any other field from the plugin user extended fields if used.
The administrator has disabled public write access.
 
#14672
Re:Predefined variables 12 Years, 12 Months ago Karma: 748
We will respect your suggestion and try to extend predefined variables list in a future release.

Regards,
ARI Soft
The administrator has disabled public write access.
 
#14673
Re:Predefined variables 12 Years, 12 Months ago Karma: 0
Ok, great, it will be very useful basicaly to limit the scope of the SQL result based on those fields.
The administrator has disabled public write access.
 
Go to topPage: 123