Joomla SQL 2 Excel Replacement
Some months ago, almost a year I think there used to be a really ripping piece of software called SQL2Excel that was provided by Joomla R Us. It appears that this site has been down for a while, so I decided I would try to come up with a replacement that gets around some of the limitations.
So, it appears that there are some subtle variants on the site hacked in google and returning viagara or cialus, however those are spelled. But I believe the attack vector is the same and the protection is the same.
NOTE: Do not do this on a live server, backup and test mileage before deploy as components and modules might not be available. Also templates need to be updated
It’s getting pretty easy to update things these days and Joomla is no exception. There is a component that you can get for the joomla 1.5 branch and later that is called jupdate. This component works pretty good as long as your permissions are set correctly. IE if you are not running as a specific user in php that has write permissions to the root of your site, then it may be a problem during the update phase.
Having trouble with letters missing from your pdf content when you copy it to web? I noticed this issue before which I at first thought to be a corrupted PDF, but the PDF itself retained the information.
So you want to allow SuperAdmin access to joomla for demos, but you don’t want anybody to be able to do anything? Well, if thats what you want to do, then you will have to perform the following.
In case anyone is wondering where they can get the latest version of Joomla information which is now scheduled to have a major release every 6 months, the url is http://update.joomla.org/core/list.xml. There is an extension update link as well but that does not seem to be filled in currently at: http://update.joomla.org/jed/list.xml. The latest release of Joomla is 1.7 as of the time of this posting.
If you have done some scripting with MooTools and Ajax you may find the following information useful. As it is, I could not find an easy way to detect when a user was logged out of Joomla in the administration control panel for an Ajax request.
Continue reading
Looking for a way to package a module inside a component package, I came across the following technique. Re-use the JInstaller class and the com_installer install from folder code as well as the unpack methods to unzip.
Continue reading
Was having an issue viewing some content on a Joomla 1.0 site. Noticed that the server code was php5.3. There are some issues with some versions of Joomla with php5.3. For the 1.5 branch, the latest versions work but the earlier ones do not as late as 1.5.14.
At any rate, without errors showing up it is often hard to find the solution without hacking core code. One such solution is to downgrade php which may be simple in a cgi environment.
Another possible solution was found at this blog posting.
The basic idea is to change the core Joomla 1.0 file includes/Cache/Lite/Function.php. By modifying the line that looks like:
$arguments = func_get_args();
with
$arguments = func_get_args();
$numargs = func_num_args();
for($i=1; $i < $numargs; $i++){
$arguments[$i] = &$arguments[$i];
}
The content becomes visible. There are other issues that could arise due to improper database content Finish Publishing Dates, and clearing the browser cache as well as site cache.
Update:
For those of you interested in converting Templates, Modules, Components, or Plugins from 1.0 to 1.5 – please check out this page
How to change CB Subs Paid Subscriptions content
CB Subs Paid Subscription content is a little bit difficult to find at first, but once you have found it a few times, it is easier to remember and edit.