9 years ago
6
Topic

Hi people, i am thinking in one metadescription generator, for my articles and user profiles.

Looking in the internet i saw that idea from Uriel, to use SD concat to get value from a field, that is very nice idea. 

But i would like to be able to limit the number of words on the metadescription to 155, than if the field have 500 words, for example it would take the first 155!

Do you people know if is possible to do that with SD concat?

Do anyone have any sugestions!

Thanks

Get a VIP membership
693 Posts
rpoy
9 years ago
1
Level 1

Hi diogowernik,

As much as I like the SD Concat, Im not sure it would be the best tool in this case.  It would depend on how you were building the Content Type.  Have a look at this post for another idea...

regards,

Randy

9 years ago
0
Level 2

Thanks, i will see how it work, look like a good idea use sd databaser.

9 years ago
0
Level 1

Hi again, I need a little help, i don't know how to make sql queries, I tried that and was a query that did not work!

----- 

SQL Query: SELECT name,introtext,phone_number FROM #__user WHERE id = *value*; 

Column(s) As Value: name||introtext||phone_number 

Column(s) Separator: , 

Multiple Row Separator: <br/> 

----- 

I would like to have in this field the result some thing like:

user name, phone number, Intro text content 

I read the tutorial, saw the video, but didn't understand much :( 

How could i do this querry? Sorry im new to sql world

9 years ago
0
Level 1

i did a little better, but i get info from all users, not from the owner of profile:

----------------

SQL Query: SELECT `name`, `introtext`,`phone_number` FROM `#_cck_store_item_users` WHERE id

Column(s) As Value: name||introtext||phone_number

Column(s) Separator: ,

Multiple Row Separator: <br/>

-----------------

I think that the place that i have to change is something in this -> WHERE id ... any help :)

9 years ago
1
Level 1

also i get, ::name::user name::/name , ::introtext:: etc..

reading the link, that you recomended...

they solved the issue of numbers of caracters with php string field, 

but look like diferent case... i want to get other fields value + number of characters restriction

also i dont know how make php string!

 any help? thanks

4229 Posts
Kadministrator
9 years ago
0
Level 2

For your query you need to add  = *value*; to the end and make sure this field already has user id value, inside User profile you would just need to add text or hidden field with storage set to Standard-User-Id

Get a VIP membership