| T O P I C R E V I E W |
| endomorph |
Posted - 09 December 2007 : 07:54:10
Version 1.0 - 9 December 2007
Snitz forum version: 3.4.05
Tested On Database: Access
Ease of setup: Very Easy
Download: Snitzbitz
Demo: http://www.schoolsuncovered.co.uk/forum/rate_my_teacher.asp (sorry no admin demo)
This MOD allows you to create a "Rate My xxxxxxx" page on your website with a photograph and 3 configurable data fields for each profile. Creation and deletion of the profiles is only permitted by admin.
Setup
-----
1. Unzip all files and upload to your forum directory
2. In your forum directory, create a new directory called ""rmt" (without the quotes). This is where you store the profile images (400 x 400 is ideal size)
3. In admin_home.asp, find the following -
" <LI><span class=""spnMessageText""><a href=""admin_info.asp"">Server Information</a></span></LI>" & vbNewLine & _
and directly underneath this, insert -
" <LI><span class=""spnMessageText""><a href=""admin_rmt.asp"">Rate My xxxxxxx Config</a></span></LI>" & vbNewLine & _
4. Log on to your forum admin control panel and select "Mod Set Up". Select "Rate My Thing v1.0" from the drop down box and click update !
5. Go to your admin control panel and select "Rate My xxxxxxx Config". You can now set new details for the title and the 3 user configurable fields.
6. Go to your admin control panel and select "Rate My xxxxxxx Config". You can now create a new profile. Ensure that you have uploaded your pictures into the 'rmt' directory you created earlier.
7. Navigate to http://www.yourwebsite.com/yourforumdirectory/rate_my_thing.asp to view/rate or delete profiles
Any support queries, post below.
< |
| 5 L A T E S T R E P L I E S (Newest First) |
| endomorph |
Posted - 10 December 2007 : 12:51:45
Fixed second error in dbs file but I am lost on the first !< |
| endomorph |
Posted - 10 December 2007 : 12:44:43
Weeslap,
No it should not be a problem. I will work on it for a v2 along with integrating photo upload from the CP. Nice implementation on your site BTW.< |
| weeweeslap |
Posted - 09 December 2007 : 19:00:03
I tweaked around the db and got it to work and I agree with Marcel. Would it hard to change it so that instead of random picture showing, it just starts from the start and goes in sequence of order in the db, with an optional button that says, skip this rate, so people don't have to rate the one they are on and go right on to the next one? I think that would be a neat change. Nice work!
http://www.weeweeslap.com/forum/rate_my_members.asp< |
| weeweeslap |
Posted - 09 December 2007 : 14:53:50
there's 2 errors running the dbs file on sql server
quote:
Rate My Thing v1.0
Creating table(s)...
CREATE TABLE FORUM_RMT_LOGS( LOGID int IDENTITY (1, 1) PRIMARY KEY NOT NULL , PROFILE_ID int NOT NULL , SCORE int NOT NULL )
CREATE TABLE FORUM_RMT_LOGS( LOGID int IDENTITY (1, 1) PRIMARY KEY NOT NULL , PROFILE_ID int NOT NULL , SCORE int NOT NULL )
9 | Subscript out of range
--------------------------------------------------------------------------------
Creating table(s)...
CREATE TABLE FORUM_RMT_PROFILES( PROFILE_ID int IDENTITY (1, 1) PRIMARY KEY NOT NULL , URL nvarchar(50) NOT NULL , FIELD1 nvarchar(50) NOT NULL , FIELD2 nvarchar(50) NOT NULL , FIELD3 nvarchar(50) NOT NULL )
Table created succesfully
--------------------------------------------------------------------------------
Creating table(s)...
CREATE TABLE FORUM_RMT_CONFIG( RID int IDENTITY (1, 1) PRIMARY KEY NOT NULL , RNAME1 nvarchar(50) NOT NULL , RNAME2 nvarchar(50) NOT NULL , RNAME3 nvarchar(50) NOT NULL , RTITLE nvarchar(50) NOT NULL )
Table created succesfully
--------------------------------------------------------------------------------
Adding new records..
INSERT INTO FORUM_RMT_CONFIG (RNAME1, RNAME, RNAME3, RTITLE) VALUES ('Name', 'Age', 'Location', 'Woman')
INSERT INTO FORUM_RMT_CONFIG (RNAME1, RNAME, RNAME3, RTITLE) VALUES ('Name', 'Age', 'Location', 'Woman')
-2147217900 | [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'RNAME'.
< |
| MarcelG |
Posted - 09 December 2007 : 14:27:41
Nice idea! But...I think a change is required, as I have just voted 10 times in a row on the same teacher.  < |
|
|
