Update: Multiskin Selection (V3.01)
Printed From: S2H.co.uk
Category: Community Forums
Forum Name: News & Annoucements
Forum Description: News and annoucements from S2H
URL: http://www.s2h.co.uk/forum/forum_posts.asp?TID=144
Printed Date: 27 Mar 2026 at 1:01am
Topic: Update: Multiskin Selection (V3.01)
Posted By: Matt
Subject: Update: Multiskin Selection (V3.01)
Date Posted: 27 Mar 2009 at 11:22am
|
The ../wwf/mods/multiskin-selection/" rel="nofollow - Multiskin Selection has been updated to be compatible with Web Wiz Forum v9.56a. you can download the latest copy from the ../wwf/mods/multiskin-selection/" rel="nofollow - Multiskin Selection page |
Replies:
Posted By: Human
Date Posted: 27 Mar 2009 at 4:08pm
|
Hi Scotty32,
what should be done to study Mysql database
|
Posted By: Matt
Date 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 ../wwf/mods/multiskin-selection/" rel="nofollow - 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:
Any feedback you or anybody else may have regarding MySQL and this modification would be greatly appreciated. |
Posted By: Human
Date Posted: 28 Mar 2009 at 8:27am
| I will return to this subject |
Posted By: Human
Date Posted: 29 Mar 2009 at 8:16am
|
I'm trying it. I could not do yet. |
Posted By: MrTWS
Date 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 http://www.crewforum.co.uk/forum/" rel="nofollow - see this in action on this forum here which uses MySQL as the backend database ------------- 
http://www.thisworldsucks.co.uk/forum/default.asp" rel="nofollow - Our Universal Forum |
Posted By: Human
Date 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 |
Posted By: Matt
Date 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. |
Posted By: Human
Date 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 ............
|
Posted By: Matt
Date 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. |
Posted By: Human
Date Posted: 15 May 2009 at 12:59pm
|
Changing places I have written above.
Give it some time, organize the way you do with the shape.
|
Posted By: Human
Date Posted: 18 May 2009 at 11:31am
|
Hi Scotty32, To download the edited form of Multiskin Selection look at private message |
Posted By: Matt
Date Posted: 20 May 2009 at 1:27pm
|
Thanks, I haven't had a chance to look into this yet but once I do I'll have check out your file. I have a break from work coming up so I'll probably work on this then. |