Author |
Topic |
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 10 June 2001 : 11:27:45
|
Taos,
I accidently sent you an older file.
What you need to change is this:
if strDBType = "mysql" then strSql = strSql & ",KEY " & TablePrefix & strTableName & "_" & idFieldName & "(" & idFieldName & "))" else strSql = strSql & ")" end if
to this:
if strDBType = "mysql" and idFieldName <> "" then strSql = strSql & ",KEY " & TablePrefix & strTableName & "_" & idFieldName & "(" & idFieldName & "))" else strSql = strSql & ")" end if |
|
|
Taos
Starting Member
16 Posts |
Posted - 10 June 2001 : 12:46:56
|
Thank you Richard, I have now made the changes for the next mod.
|
|
|
faiz
Starting Member
India
13 Posts |
Posted - 10 June 2001 : 13:26:46
|
This was exactly what I had thought of but was unable to complete. If you complete it mail me the code so that I can add it to the mod.
quote:
I'll be working on an addition to this that will allow an admin to easily ( I hope ) add color schemes and not have to change code. It will store the relevant variables in a table and users will select it from there rather than it being entirely hard coded.
http://www.ugfl.net/forums
|
|
|
Morten
Junior Member
Denmark
251 Posts |
Posted - 10 June 2001 : 14:53:08
|
Did I miss something, or did somebody get the the themes to take effect ? - thats my only problem. Sorry if somebody already answeered this but the long thread is confusing for me as I don´t have english as my mainlanguage. BTW. The MOD is a great way to get rid of some of the, growing list of links in the upper right corner by just linking to the my.asp
|
|
|
stuF
Average Member
United Kingdom
561 Posts |
Posted - 10 June 2001 : 15:47:31
|
quote: by richard kinser: The files in that .zip file, I was messing with to try and get them to work with Tim's forum.
If you open my_theme.asp and change (on line #9 and #11):
Request.Cookies(strCookieURL & "User")("Name")
to
Request.Cookies(strUniqueID & "User")("Name")
if you d-loaded the same zip as i did then thats all you need to do!
|
|
|
XavierSlater
Junior Member
United Kingdom
137 Posts |
Posted - 10 June 2001 : 16:25:41
|
Hi, I got probs with the Mod_dbsetup.asp loading this MOD. Same as Taos.
Help?
Cheers.
This is a totally spanky MOD btw
Regards
Stuart
|
|
|
MDGamezz
Junior Member
USA
100 Posts |
Posted - 10 June 2001 : 16:43:55
|
Great Mod! I only have one problem. under members options you can select "My topics". It requires my_topics.asp. I dont have this file. Anyone know where I can get this? It wasnt in the zip file I downloaded here.
Thanks.
MDGamezz |
|
|
stuF
Average Member
United Kingdom
561 Posts |
Posted - 10 June 2001 : 18:38:20
|
just noticed i have an eror on the my topics link, i dont think i even have the file but, still its giving this error
Active Server Pages error 'ASP 0126'
Include file not found
/cgi-bin/forum/my_topics.asp, line 197
The include file '../forums/inc_jump_to.asp' was not found.
seen that one b4!!!
|
|
|
pure-rock
Starting Member
10 Posts |
Posted - 10 June 2001 : 22:17:47
|
I get when trying to setup the database
quote: Creating table(s)... CREATE TABLE FORUM_MY_CONFIG( MEMBER_ID#int## NOT NULL , THEME_ID#int##0 NOT NULL , MAX_MY_TOPICS#int##5 NOT NULL , SHOW_RECENT_TOPICS#int##1 NOT NULL , SHOW_MY_TOPICS#int##1 NOT NULL , SHOW_PM#int##1 NOT NULL ) -2147217900 | Syntax error in field definition.
anyone know what is happening? the same thing happens when i try and setup the Buddy list mod aswell.
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 10 June 2001 : 22:27:00
|
stuF,
You need to remove the ../forums/ part in the INCLUDE statment for that file. |
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 10 June 2001 : 22:31:09
|
pure-rock,
The reason you are getting that error is because you are using an older version of mod_dbsetup.asp. If you download one of HuwR's MODS, it will include an updated version of mod_dbsetup.asp. |
|
|
faiz
Starting Member
India
13 Posts |
Posted - 11 June 2001 : 08:42:34
|
Actually the I changed the my_topics.asp file to work as a module in the my.asp page. Delete that link without any problem. If you still want the my_topics.asp file mail me.
Faiz/.
quote:
Great Mod! I only have one problem. under members options you can select "My topics". It requires my_topics.asp. I dont have this file. Anyone know where I can get this? It wasnt in the zip file I downloaded here.
Thanks.
MDGamezz
Edited by - faiz on 11 June 2001 08:45:35 |
|
|
SalmanKhana
Average Member
USA
961 Posts |
Posted - 14 June 2001 : 06:00:02
|
This mod has one problem !!
I moved my forum to a different host. But after moving, the topics in My Page were picked up from the OLD Host's site !!
why is that ? and how do we fix it ?
|
|
|
ahimanikya
Starting Member
22 Posts |
Posted - 14 June 2001 : 13:07:55
|
I am unable to download the file, can you send it to me.
Thanks Ahimanikya
quote:
Ok,
download this file, one more time: http://www1.domaindlx.com/dssdbs/my1.zip
the only file you should need to extract is my_theme.asp
|
|
|
Space_Cowboy
Starting Member
34 Posts |
|
Topic |
|