4
votes
Accepted
Redirect if userid is not found in a database table
The first problem is that you're using joomlausers->id which doesn't look correct. It should be $joomlausers->id (with a $ at the beginning).
Secondly, loadObjectList() returns an indexed array ...
- 26.7k
3
votes
Accepted
Article id from category view
In both cases you should access the article's object id property. By the way, do note that JRequest is deprecated.
For the article, in your article template you can add next to the article's title ...
- 19.6k
3
votes
Redirect if userid is not found in a database table
I don't think it is very direct to filter the result set when sql is perfectly qualified to do such logic.
As Lodder corrected, you also need to use setQuery(), fix your missing $, adjust your result ...
- 4,671
2
votes
Where is the menu item ID?
I don't know what the documentations says, but the truth is that I haven't see the menu item id in the details page for a while, although it used to exist there ( I remember it in Joomla 2.5, below ...
- 19.6k
2
votes
Accepted
Get ID for new Article or Category
There is a relevant discussion here, but in short it just concludes that using the jdatabase insertid method is just as rubbish as mysqli_insert_id.
Joomla DB Insert, how to get last inserted id?
...
- 3,209
2
votes
How to update field defination of id from int to varchar in #_users table structure
This is actually a pure MySQL question which should be titled "How to Alter a MySQL column". There is nothing different or special if the database is used for a Joomla site.
So simply to have this ...
- 19.6k
1
vote
Append id to every link generated by joomla
You could use something like the following:
jQuery(document).ready(function($) {
var querystring = 'affiliate=12345';
$('a').each(function() {
var href = $(this).attr('href');
...
- 26.7k
1
vote
Accepted
VM3 Order Numbers
This plugin does the job, order numbers are customisable through this - http://extensions.virtuemart.net/vm-orders/order-number-plugin-detail
- 411
Only top scored, non community-wiki answers of a minimum length are eligible