Improved Router - Better SEF URL on front-end view

Loading a view using item id is very bad ideal. There are SQL Injections bug there. I have tried creating a component using Joomla category and SQl Injection bug has appear.

I have attached the component that I created using your site. Try creating a sample data and go to view single item. In here, I view my item at mydomain.com/joomla/component/documents/item/1 
If I add a ' at the end of that url, sql injection ll apear like this
hhit.com/joomla/component/documents/item/1'
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3 SQL=SELECT title FROM bd3qu_categories WHERE id =

Hello,

Instead of using "/component-name/view-name/item-id" for the SEF output, can I make it to: "/component-name/view-name/item-name" ?

Any help would greatly be appreciated if you can point me in the right direction.

Thanks!

Elliott

I have actually tried this before and it still don't show the URL the way I envision it.

Basically, what I try to accomplish is this:

Site flow: County-->City-->Comunity

In the County page, we have list of Cities with link to City's detail page.
In the City detail page, we have list of Communities with link to Community's detail page.

I've created menu items for the County and each of the cities. No problem with the SEF there.
I have a really good SEF link for County and Cities.
However, from the City detail page, where we have the list of Communities, the link aren't looking good because I don't have menu item created for each of those communities.
If I have to create menu item for each of the Communities, it will be too many of them. We have over 1500 communities for State of Florida.

As it is now, the community URL showing as: https://TLD/name-of-city/community-template-view/community-ID

I am trying to eliminate the "community-template-view" and "community-ID" from the URL and replace it with a simple URL like: https://TLD/name-of-city/name-of-communtiy

Where can I make the edit to make it happen?

Thank you so much in advance for your help! Been scratching my heads for 2 days for this..


Elliott

Nevermind.. I figured it out. By reading the code in router.php I was able to see that if I add the alias field then the system can call for the alias instead of the id. I've added the field and all good now.

Thanks so much!

Elliott