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


Recent Events
  • 23/11/2024 Black Friday 2024

    BIG SALE, 30% discount for all our extensions. Use BF24 coupon code. Hurry up the discount is valid till 3 December.

  • 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.


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
(0 viewing) 
Go to bottomPage: 123
TOPIC: Predefined variables
#14666
Re:Predefined variables 13 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 13 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 13 Years, 12 Months ago Karma: 763
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 13 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 13 Years, 12 Months ago Karma: 763
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 13 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