muhammad arbab
Posts:310
 |
| 03/20/2009 3:59 AM |
|
Hi, i can't find any appropiate forum to ask for this question that is why i am asking here.
What version of SQLGridSelectedView is least required for this extension. The free version is 4.1 and the latest but paid version is 5.3 i guess.
So what least version is required for this change.
Thanks for such a great extension. |
|
|
|
|
Mark Hollas
Posts:335
|
| 03/20/2009 10:52 PM |
|
I am using 5.3 but i think the free version should work. I think the only big difference between the free version is the Inter Module Communicatio, which currently is not being used with the extension pack.
Please give the free version a try. If it does not work, the 5.3 module is only $10 USD
Mark |
|
|
|
|
Tony Harrison
Posts:48
|
| 03/25/2009 11:17 AM |
|
I have tried using the "friends photos" template but with Active Social instead of Smart Thinker profile.
The sql is fine but the returned field Tokens e.g. [SGSV:Value:CreatedByUser] are not being substitued.
I am using the free SGSV 4.1 module, any thoughts? |
|
|
|
|
Tony Harrison
Posts:48
|
| 03/25/2009 11:30 AM |
|
The clue was in the fact that these templates have been written for SGSV 5.3, things are slightly different in v4.1.
In 4.1 the syntax for the replaceable sql field value tokens is as follows:
5.3 = [SGSV:Value:CreatedByUser]
4.1 = [SPSV:ColumnValue:CreatedByUser]
|
|
|
|
|
Mark Hollas
Posts:335
|
| 03/25/2009 11:50 AM |
|
No, these templates are written specific for Smart-Thinker Profiles module. The SQL directly reads from the modules tables so if you are using a Profiles module which is not Smart-Thinker then the SQL can not retrieve the proper tables and thus the SQL will fail.
If you know the table schema for the module you use then you can replace the table names appropriatly.
Unfortunatly I do not use that module an have no idea of the table schema so I can not write a patch for it at this time
Cheers
Mark |
|
|
|
|
Tony Harrison
Posts:48
|
| 03/25/2009 11:51 AM |
|
Update:
The only difference between 4.1 and 5.3 is :
4.1 = [SPSV:
5.3 = [SGSV: |
|
|
|
|
Tony Harrison
Posts:48
|
| 03/25/2009 11:52 AM |
|
Hi Mark,
I have modified the sql for ActiveSocial and it is fine, the only problem I had was the tokens not being substituted.
As you can see from the other posts I have now resolved this. |
|
|
|
|
Mark Hollas
Posts:335
|
| 03/25/2009 12:04 PM |
|
Excellent.
I was not aware that the token formation was different in lower versions of the module.
Thank you for the post
BTW I have a few more modules coming up
1) a FOLLOW mode to get photo updates from users who have not allow yet accepted a friend request (Smart-thinker firends module)
2) New comments on photos from users in your friends list
and one patch you may want to add to the FriendsPhotos module before I add it.
you need to define (for Smart-Thinker) in the WHERE clause
AND InviteStatusID=1 or else you will get photos in your list from users you have not authenticated as a friend.
Cheers
Mark |
|
|
|
|
muhammad arbab
Posts:310
|
| 03/25/2009 1:41 PM |
|
I figured that out and tried those extensions with 4.3. Its a Great extension Mark. Thanks a lot for sharing these with us.
Do you have plans for UVG extension too ?
When i get sometime i'll help you out and try to create some more extensions and share it with you all.
Looking forward for your new extensions :)
Thanks |
|
|
|
|
Mark Hollas
Posts:335
|
| 03/28/2009 3:02 AM |
|
Haha, looking for support on my own extension!
I have noticed that the TOP PHOTOs extension returns some stange values. I.E the intent is to diplay photos which have been rated my tallying the sum of the rating. but for some reason every photo has two entries.
1) the value total rating
2) another mystery (to me) value like "1" or "4" or even "0"
I was wondering if someone could shed some light on Why, even though I am aggregating all the columns, is this SQL returning the same items?
SELECT photoId AS RatedPhotoId,
SUM(Rating) AS TotalRating,
Users.DisplayName,
BizModules_UPG_Photo.CreatedByUser,
BizModules_UPG_Photo.Title,
BizModules_UPG_Photo.Src,
BizModules_UPG_Photo.AlbumId
FROM BizModules_UPG_PhotoReview
JOIN BizModules_UPG_Photo
JOIN Users
ON Users.UserId=BizModules_UPG_Photo.CreatedByUser
ON BizModules_UPG_PhotoReview.PhotoId=BizModules_UPG_Photo.ItemId
WHERE BizModules_UPG_Photo.CreatedByUser=259
GROUP BY PhotoId, CreatedByUser, Src, AlbumId, DisplayName, Title, Rating
ORDER BY BizModules_UPG_PhotoReview.Rating DESC
Thank you
Mark |
|
|
|
|
Tony Harrison
Posts:48
|
| 03/30/2009 4:09 AM |
|
Hi Mark,
It could just be the way you have pasted the code here but try this instead:
SELECT photoId AS RatedPhotoId,
SUM(Rating) AS TotalRating,
Users.DisplayName,
BizModules_UPG_Photo.CreatedByUser,
BizModules_UPG_Photo.Title,
BizModules_UPG_Photo.Src,
BizModules_UPG_Photo.AlbumId
FROM BizModules_UPG_PhotoReview
JOIN BizModules_UPG_Photo
ON BizModules_UPG_PhotoReview.PhotoId=BizModules_UPG_Photo.ItemId
JOIN Users
ON Users.UserId=BizModules_UPG_Photo.CreatedByUser
WHERE BizModules_UPG_Photo.CreatedByUser=259
GROUP BY PhotoId, CreatedByUser, Src, AlbumId, DisplayName, Title, Rating
ORDER BY BizModules_UPG_PhotoReview.Rating DESC
|
|
|
|
|
Mark Hollas
Posts:335
|
| 03/30/2009 10:04 AM |
|
Thanks for the help but it still returns odd values. This is an odd table to work with and I am really interested in how UMG tallies the rank of a Photo because even if you just choose
SELECT rating from the reviews table and group it, it returns 1,2,3,4,5
Mark |
|
|
|
|
muhammad arbab
Posts:310
|
| 04/09/2009 12:40 PM |
|
Mark any updates on the future extensions you are working at specially the idea of followers ?
Can you please provide any help or guidance in making similar extension for UVG.
Mark i just got an idea, the idea of following someone can be implemented in UVG as well just like Subscribe option in youtube.
user can subscribe to anyone posting some good videos and can get all new video posted updates on there home page etc. |
|
|
|
|
Mark Hollas
Posts:335
|
| 04/16/2009 9:00 AM |
|
I haven't made any new extension recently. I kind of ran out of ideas :)
About the 'Follow' feature, I'm sure it could be done, but I have not had a look at the UVG data tables. When I have some time I will look into it.
Mark |
|
|
|
|
muhammad arbab
Posts:310
|
| 04/16/2009 9:08 AM |
|
Thanks for u post.
One thing i wana discuss is, Is it possible to display some text (like no recent photos from friends) when the query result doesn't brings any pics from friends, similarly comments on pics etc.
At this time it only shows blank container. |
|
|
|
|
Mark Hollas
Posts:335
|
| 04/16/2009 9:58 PM |
|
yes there is a setting in the SQL module settings under "Header/Footer" you can choose what you would like to display via a template when no data is retrieved from the query.
Mark |
|
|
|
|
muhammad arbab
Posts:310
|
| 04/19/2009 3:46 PM |
|
| Thanks, i got that. |
|
|
|
|