| Author |
 Topic  |
|
dayve
Forum Moderator
USA
5820 Posts |
|
|
bcooper
Starting Member
34 Posts |
|
|
big9erfan
Average Member
540 Posts |
 Posted - 21 June 2001 : 16:01:16
|
Ok guys heres the ideas I got going.
I don't think this mod should be too difficult. There will be 3 places where code will be added, inc_functions for returning the proper image ( as necessary ), topic.asp ( for displaying the rating and link ), and pop_profile.asp for actually rating someone.
Later an admin function could be added to turn on/off the showing of ratings.
There would need to be 2 added fields to the Members table, Total_Votes and Rating.
Total_Votes would store the number of votes that have been made for a given member ( this would default to 0 ), while rating would store a number from 0 - 5. 0 being the default value and meaning NO votes cast yet. I am storing this in the member table ( same with the Rating ) and not updating it all the time to reduce the hit on the DB and server.
Another Table would have to be created such as Member_Ratings which would have the following entries
- Member_ID_Rated ( ID of the member being rated ) - Number Value
- Member_ID_Rating ( ID of the member doing the vote ) - Number Value
- Member_Rating ( the number 1 - 5 ) - Number Value
On the submit of the rating ( from profile ) a check is done.
if Request.Cookies(strTempCookieType & "User")("Name") <> "" then
iRatingID = getMemberID( Request.Cookies(strTempCookieType & "User")("Name"))
strSQL = "Select Member_Rating From " & strTablePrefix & "Member_Ratings Where Member_ID_Rating =" & iRatingID & " and Member_ID_Rated = " & Request.QuertyString("id")
The Query string will be part of the url that gets pushed along ( from the pop_profile Query String ) on the press of the Rate This Member button.
set rsRating = Server.CreateObject("ADODB.Recordset")
rsRating.Open strSQL, strConnString
if rsRating.EOF or rsRating.BOF then 'This means it there is no entry so go ahead and add it
else
Display that they have already voted.
end if
This is just REALLY rough code and I probably won't be able to work on this till Monday ( darn life  ) so if any of you want to try and begin to take this on, feel free. I've fleshed out a good portion of it here already 
If you have questions/comments e-mail me or IM me and let me know.
http://www.ugfl.net/forums |
 |
|
|
bcooper
Starting Member
34 Posts |
Posted - 21 June 2001 : 16:12:44
|
This sounds really good man. Unfortunately, I am no good with designing MOD's and have a tough time installing them too  , it sounds like itll work out real well! Someone finally listened to me and my ideas, now I feel SUPER special :).
Brandon
quote:
Ok guys heres the ideas I got going.
I don't think this mod should be too difficult...
|
|
|
|
dayve
Forum Moderator
USA
5820 Posts |
Posted - 21 June 2001 : 16:34:07
|
sounds good. doesn't look like it will be too difficult to add with exception of the existing stars for post levels. it would be nice to snitzify this idea and maybe consider a meter (bar graph) instead of stars?? at least I know that's what I will do with the end product. I am not much of a stars fan.
so what is your idea on admin option? if a member uses ranking stars will the rate member be turned off and vice versa or are we going to try and show both (if wanted).
just curious...
Dayve |
|
|
|
big9erfan
Average Member
540 Posts |
Posted - 21 June 2001 : 16:48:18
|
If admin turned it off, the stars ( or whatever ) and the rating ability would not be shown.
http://www.ugfl.net/forums |
|
|
|
big9erfan
Average Member
540 Posts |
Posted - 21 June 2001 : 16:58:04
|
Ooopps..
The real meaning of your question just hit me, so here goes.
I think that the rating stars and and RANKING stars should be completely independent.
Rankings ( based on post number ) should show of the admin chooses as should the Ratings if the admin chooses. Just b/c someone has 1000 posts doesn't make them a better member than another ( which is where the ratings come in )
http://www.ugfl.net/forums |
|
|
|
work mule
Senior Member
USA
1358 Posts |
Posted - 21 June 2001 : 18:30:05
|
I think you should be able to download the portal code and look at how the ratings were done in there. From that you should be able to develop something.
For anyone with a sub to ASPToday, here's something that's also interesting. You might get some ideas from this too.
A short-and-sweet implementation of the Likert-Scale based survey
http://www.asptoday.com/content/articles/19990827.asp
Edited by - work mule on 21 June 2001 18:32:14 |
|
|
|
big9erfan
Average Member
540 Posts |
Posted - 26 June 2001 : 13:12:13
|
Sorry guys, I thought I was gonna be able to work on this but life has taken a turn for the busier. Looks like it will be a while (months at least) for me to get any work done on this.
Sorry
http://www.ugfl.net/forums |
|
|
|
bcooper
Starting Member
34 Posts |
Posted - 26 June 2001 : 22:32:18
|
Well, since it is going to take him so long. Could anyone else here do this MOD? Someone like AZNKnight or Richard? That'd be great if one of them could!
Thanks
Brandon
quote:
Sorry guys, I thought I was gonna be able to work on this but life has taken a turn for the busier. Looks like it will be a while (months at least) for me to get any work done on this.
Sorry
http://www.ugfl.net/forums
|
|
|
|
Space_Cowboy
Starting Member
34 Posts |
Posted - 26 June 2001 : 22:47:46
|
quote:
Is this ranking an average of all submissions? Can a member rate another member more than once? Can a guest rate a memeber? All things that need to be answered before a mod can be created.
http://www.ugfl.net/forums
Yes, this should be an average of the votes. Yes and no, there should be a limit to the number of times you can vote for a member a month. Absolutely not! Just my opinion...
|
|
|
|
Space_Cowboy
Starting Member
34 Posts |
Posted - 26 June 2001 : 22:52:11
|
quote:
Well, since it is going to take him so long. Could anyone else here do this MOD? Someone like AZNKnight or Richard? That'd be great if one of them could!
Thanks
Brandon
quote:
Sorry guys, I thought I was gonna be able to work on this but life has taken a turn for the busier. Looks like it will be a while (months at least) for me to get any work done on this.
Sorry
http://www.ugfl.net/forums
If I knew more about modding, I'd give it a try, but I don't know squat about ASP! If somebody could give me a crash course in modding, I could try and do this...
|
|
|
|
bcooper
Starting Member
34 Posts |
Posted - 26 June 2001 : 23:14:35
|
Same here. If I knew more, I would have it done and posted for everyone, but I dont so I'm here hoping for SOME help. lol
quote:
quote:
Well, since it is going to take him so long. Could anyone else here do this MOD? Someone like AZNKnight or Richard? That'd be great if one of them could!
Thanks
Brandon
quote:
Sorry guys, I thought I was gonna be able to work on this but life has taken a turn for the busier. Looks like it will be a while (months at least) for me to get any work done on this.
Sorry
http://www.ugfl.net/forums
If I knew more about modding, I'd give it a try, but I don't know squat about ASP! If somebody could give me a crash course in modding, I could try and do this...
|
|
|
|
Topic |
|
Topic Locked
, thanks man you saved me alot of work :).