Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Snitz Forums 2000 MOD-Group
 MOD Add-On Forum (W/Code)
 MOD: Rate my xxxxxxxxxx
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

endomorph
Junior Member

United Kingdom
128 Posts

Posted - 09 December 2007 :  07:54:10  Show Profile  Reply with Quote
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.



<

Need help with your Snitz ? Most Snitz & ASP custom coding undertaken. Email for info | Search Engine Optimisation

MarcelG
Retired Support Moderator

Netherlands
2625 Posts

Posted - 09 December 2007 :  14:27:41  Show Profile  Visit MarcelG's Homepage  Reply with Quote
Nice idea! But...I think a change is required, as I have just voted 10 times in a row on the same teacher. <

portfolio - linkshrinker - oxle - twitter
Go to Top of Page

weeweeslap
Senior Member

USA
1077 Posts

Posted - 09 December 2007 :  14:53:50  Show Profile  Visit weeweeslap's Homepage  Send weeweeslap an AOL message  Send weeweeslap a Yahoo! Message  Reply with Quote
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'.

<

coaster crazy
Go to Top of Page

weeweeslap
Senior Member

USA
1077 Posts

Posted - 09 December 2007 :  19:00:03  Show Profile  Visit weeweeslap's Homepage  Send weeweeslap an AOL message  Send weeweeslap a Yahoo! Message  Reply with Quote
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<

coaster crazy
Go to Top of Page

endomorph
Junior Member

United Kingdom
128 Posts

Posted - 10 December 2007 :  12:44:43  Show Profile  Reply with Quote
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.<

Need help with your Snitz ? Most Snitz & ASP custom coding undertaken. Email for info | Search Engine Optimisation
Go to Top of Page

endomorph
Junior Member

United Kingdom
128 Posts

Posted - 10 December 2007 :  12:51:45  Show Profile  Reply with Quote
Fixed second error in dbs file but I am lost on the first !<

Need help with your Snitz ? Most Snitz & ASP custom coding undertaken. Email for info | Search Engine Optimisation
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.12 seconds. Powered By: Snitz Forums 2000 Version 3.4.07