Typo3 allow the functionallity that you can outsource your TypoScripts in an external File. Most developer use the File Extension .ts for these kind of Files. They store the Typo Scripts in a public folder like fileadmin/typoscripts.
In this case can all view sensitive Data including Robots of many Search Engines.
Some Examples can be found via google like this.
So secure your Typoscript with folowing htaccess Snippet:
<FilesMatch "\.ts$">
Deny from All
</FilesMatch> |
If you dont use any Url Extensions you can put this Lines in the Root .htaccess of Typo3 and now nobody can access the Typoscripts in a public Folder.
Today we had lost 1 Hour because we want implement an User Function in Typo3 over an Typoscript. Following Snippet does not work:
### add user stylesheets ###
includeLibs.usersites = fileadmin/scripts/class.usersites_css.php
page.headerData.1010 = USER
page.headerData.1010.userFunc = usersitescss->usergetcss
This example include the class where the User function. The mistake is that Typo3 has a Naming Convention that all User Functions must beginning with user_.
The correct Code Snippet is:
### add user stylesheets ###
includeLibs.usersites = fileadmin/scripts/class.usersites_css.php
page.headerData.1010 = USER
page.headerData.1010.userFunc = user_sitescss->user_getcss
Now its work perfectly. Hmpf.
Yesterday I´ve found a program which I looking for a long Time ago. We want comapre any MySQL Databases including Data its in.
The great Software calls Toad for MySQL and can be download here.
It support some nice Features:
- Compare any Databases on any MySQL Server.
- Compare Structure of an Database
- Compare Date of an Database
- Export the Data as SQL, Excel or CSV File
- It´s Freeware
- And lots more what I cant find out in this short time
You should take a look to this nice App if you need some comparing functionality.