[SOLVED] name list link with space in it issue

thewebsurfer
OFFLINE
Posts: 292
Thanks: 13
Karma: 1

11 years 1 month ago - 11 years 1 month ago #238314 by thewebsurfer

[SOLVED] name list link with space in it issue was created by thewebsurfer

hi, when i copy a link of a list with a space in the name and past it in an article, the joomla url sef make the link with a space in it!
obviously is incorrect..how can i solve?

example:
index.php?option=com_comprofiler&task=usersList&listid=16

joomla url sef rewrites the url like:
index.php/comprofiler/userslist/Window%20dresser
and this dont work

Last edit: 11 years 1 month ago by krileon.

Please Log in or Create an account to join the conversation.

krileon
ONLINE
Posts: 48681
Thanks: 8313
Karma: 1446

11 years 1 month ago #238351 by krileon

Replied by krileon on topic name list link with space in it issue

Please apply the below quickfix and see if it resolves your issue.

IN: /components/com_comprofiler/router.php
ON: Line 106
FROM:

Code:

$sql					=	'SELECT id FROM #__users WHERE username = '. $database->Quote( $user );

TO:

Code:

$sql					=	'SELECT id FROM #__users WHERE username = '. $database->Quote( urldecode( $user ) );

Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.

The following user(s) said Thank You: thewebsurfer

Please Log in or Create an account to join the conversation.

thewebsurfer
OFFLINE
Posts: 292
Thanks: 13
Karma: 1

11 years 1 month ago - 11 years 1 month ago #238368 by thewebsurfer

Replied by thewebsurfer on topic name list link with space in it issue

i didnt solve sorry

in pvt i sent you the link

Last edit: 11 years 1 month ago by thewebsurfer.

Please Log in or Create an account to join the conversation.

krileon
ONLINE
Posts: 48681
Thanks: 8313
Karma: 1446

11 years 1 month ago #238372 by krileon

Replied by krileon on topic name list link with space in it issue

Whoops that was a fix for SEF usernames with spaces. Please try the below for userlist fix.

IN: /components/com_comprofiler/router.php
ON: Line 53
FROM:

Code:

$query['listid']	=	$listNames[0];

TO:

Code:

$query['listid']	=	(int) $query['listid'] . ':' . $listNames[0];

ON: Line 118 - 119
FROM:

Code:

$database				=	JFactory::getDBO();
$sql					=	'SELECT listid FROM #__comprofiler_lists WHERE title = '. $database->Quote( $listid ) . ' AND published = 1';

TO:

Code:

list( $id, $alias )		=	explode( ':', $listid, 2 );
$database				=	JFactory::getDBO();
$sql					=	'SELECT listid FROM #__comprofiler_lists WHERE listid = '. (int) $id . ' AND published = 1';

Note sure if the quickfix will entirely work on CB 1.9, but it's fixed for CB 2.0.

The following user(s) said Thank You: thewebsurfer

Please Log in or Create an account to join the conversation.

thewebsurfer
OFFLINE
Posts: 292
Thanks: 13
Karma: 1

11 years 1 month ago #238375 by thewebsurfer

Replied by thewebsurfer on topic name list link with space in it issue

solved thanks :cheer:

The following user(s) said Thank You: krileon

Please Log in or Create an account to join the conversation.

Moderators: beat, nant, krileon