New Posts New Posts RSS Feed - Update: Multiskin Selection (V3.01)
  FAQ FAQ  Forum Search   Register Register  Login Login

Topic ClosedUpdate: Multiskin Selection (V3.01)
 Post Reply Post Reply Page  12>
Author
  Topic Search Topic Search  Topic Options Topic Options
Matt View Drop Down
Admin Group
Admin Group


Joined: 07 Feb 2003
Location: Manchester, UK
Status: Offline
Points: 195 		Direct Link To This Post Topic: Update: Multiskin Selection (V3.01)
    Posted: 27 Mar 2009 at 11:22am
The Multiskin Selection has been updated to be compatible with Web Wiz Forum v9.56a.

you can download the latest copy from the Multiskin Selection page
Back to Top
Human View Drop Down
Newbie
Newbie


Joined: 23 Mar 2009
Status: Offline
Points: 11 		Direct Link To This Post Posted: 27 Mar 2009 at 4:08pm
Hi Scotty32,
what should be done to study Mysql database
Back to Top
Matt View Drop Down
Admin Group
Admin Group


Joined: 07 Feb 2003
Location: Manchester, UK
Status: Offline
Points: 195 		Direct Link To This Post Posted: 27 Mar 2009 at 6:30pm
At present this mod has not been tested using MySQL and therefore is not supported.

If you wish to use the Multiskin Selection mod with MySQL then I would recommend using the Cookie option rather than the database to store users skins.


If you wish to wish to use the database to store the users skin option then it should be a simple case of adding a new field to the 'tblAuthor' table called 'Mod_Skin', this should be an 'int' type, not null and the default value should be 1. You can add this using phpMyAdmin if you have that set up on your server.

You could also try this SQL statement, but I cannot garrentee it will work:

ALTER TABLE [tblAuthor] ADD [Mod_Skin] [int] NOT NULL DEFAULT (1)


Any feedback you or anybody else may have regarding MySQL and this modification would be greatly appreciated.
Back to Top
Human View Drop Down
Newbie
Newbie


Joined: 23 Mar 2009
Status: Offline
Points: 11 		Direct Link To This Post Posted: 28 Mar 2009 at 8:27am
I will return to this subject
Back to Top
Human View Drop Down
Newbie
Newbie


Joined: 23 Mar 2009
Status: Offline
Points: 11 		Direct Link To This Post Posted: 29 Mar 2009 at 8:16am
I'm trying it. I could not do yet.
Back to Top
MrTWS View Drop Down
Newbie
Newbie
Avatar

Joined: 06 Apr 2008
Location: United Kingdom
Status: Offline
Points: 25 		Direct Link To This Post Posted: 30 Mar 2009 at 7:01am
Just to add Scotty that on this subject I have successfully installed this mod on a MySQL version, but as you said, I did not run the database update files
I just manually added in your lines rather than copy over the whole files

You can see this in action on this forum here which uses MySQL as the backend database
Back to Top
Human View Drop Down
Newbie
Newbie


Joined: 23 Mar 2009
Status: Offline
Points: 11 		Direct Link To This Post Posted: 30 Mar 2009 at 8:45am
mysql is running as the cookies, the database does not record.
input from members of a try.
 
the error
 
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[MySQL][ODBC 3.51 Driver][mysqld-4.1.22-community-nt]Build WHERE -> insert_fields() failed.
/956test/functions/s2h_multiskin.asp, line 85
 
Back to Top
Matt View Drop Down
Admin Group
Admin Group


Joined: 07 Feb 2003
Location: Manchester, UK
Status: Offline
Points: 195 		Direct Link To This Post Posted: 30 Mar 2009 at 3:38pm
I'll have a look at this once I get a chance.

In the mean time you can use the Cookie method like TWS is.
Back to Top
Human View Drop Down
Newbie
Newbie


Joined: 23 Mar 2009
Status: Offline
Points: 11 		Direct Link To This Post Posted: 06 May 2009 at 2:39pm
Hi Scotty32,
 
In this way it works
 
includes/s2h_skinfile.asp  change line 39 False --> True
 
old status

blnS2HSkinUseDatabase = False  'Set to true if you wish to store the skin to database (registered members only)
 
new status 

blnS2HSkinUseDatabase = True  'Set to true if you wish to store the skin to database (registered members only)
 
 
functions/s2h_multiskin.asp
 
old status
 
............
rsCommon.Update
end if
rsCommon.Close
............
 
new status 
 
............
    'rsCommon.Update
 strSQL = "Update " & strDBTable & "Author Set Mod_Skin = '"& intS2HSkinID &"' Where Author_ID = '"& lngLoggedInUserID &"';"
 adoCon.Execute(strSQL) 
 end if
    'rsCommon.Close
............
Back to Top
Matt View Drop Down
Admin Group
Admin Group


Joined: 07 Feb 2003
Location: Manchester, UK
Status: Offline
Points: 195 		Direct Link To This Post Posted: 14 May 2009 at 2:43pm
Thanks for the feedback.

I was thinking the Update might need changing, but I havent used ASP+MySQL together much.

When I can find the time, I will work on supporting MySQL in this mod.
Back to Top
 Post Reply Post Reply Page  12>
  Share Topic   

Forum Jump Forum Permissions View Drop Down



This page was generated in 0.079 seconds.