| T O P I C R E V I E W |
| Classicmotorcycling |
Posted - 29 January 2006 : 03:01:01
After a request from an e-mail from Per Serritzlev at www.assy.dk, I was able to MOD a recipe book to work with Snitz 3.4.X and it is available for download from: www.vncommodore.com/snitz_mods/recipe_book_mod_2.2.zip" target="_blank">Mod: Recipe Book 2.2
I have tried to make it as easy as possible to install with only the 1 change to the inc_header.asp file to do a link to it in your menu.
Some of the features include:
- All visitors can add a recipe
- Recipes require Admin Approval
- Only forum members can rate the recipe
- Easy to install (1 being easy, 10 being hard, the install is a 1
- Readme file to install included
)
So what are you waiting for? Enjoy.
Demo is at: www.vncommodore.com/forum/recipe.asp" target="_blank">VN Commodore Support Site
Update - Added 31 Jan 2006:
Ability to use with no other MODs installed (Added extra code to allow for the Language part with-out interfering with other Mods)< |
| 15 L A T E S T R E P L I E S (Newest First) |
| mdelcour2000 |
Posted - 12 November 2007 : 10:37:13
any fixes on the author showing up as the person logged in? Can't find a fix.< |
| simon emery |
Posted - 04 October 2007 : 11:47:20
change line 1287 in recipe.asp to
" <font face=""" & strDefaultFontFace & """ color=""" & strDefaultFontColor & """ size=""" & strDefaultFontSize & """>" & "<ul><li></li>" & replace(strRECIPEINGREDIENTS, chr(10) & chr(13), "<li>") & "</ul></font> " & vbNewLine & _
This will convert line breaks to a bulleted list in the ingredients < |
| simon emery |
Posted - 04 October 2007 : 10:58:05
I found some code errors int admin_recipe.asp that created the errors when editing a recipe. If you edited them, the ingredients dissappeared.
Here are the code changes (please be aware I am a novice)
Line 316ish
email = ChkString(Request.Form("INGREDIENTS"),"url")
This made no sense to me until I started digging in - the author must have modded something with an email field. I replaced with this
ingredients = Request.Form("ingredients")
email = ChkString(Request.Form("email"),"url")
I am not sure the second one is needed, again, I am a novice :)
Also line 334ish
I re-wrote the two lines to this:
my_Conn.Execute("UPDATE " & strTablePrefix & "RECIPE SET NAME='" & chkString(name, "SQLString") & "',POST_DATE ='" & today & "',URL ='" & URL & "',filesize ='" & chkString(filesize, "SQLString") & "',license ='" & chkString(license, "SQLString") & "',lang ='" & chkString(lang, "SQLString") & "',platform ='" & chkString(platform, "SQLString") & "',publisher ='" & chkString(publisher, "SQLString") & "',publisher_url ='" & chkString(publisher_url, "SQLString") & "',uploader ='" & chkString(uploader, "SQLString") & "',description ='" & chkString(des, "SQLString") & "',keyword ='" & chkString(key, "SQLString") & "',INGREDIENTS ='" & chkString(INGREDIENTS, "SQLString") & "', BADLINK=0 WHERE RECIPE_ID =" & webid)
else
my_Conn.Execute("UPDATE " & strTablePrefix & "RECIPE SET NAME='" & chkString(name, "SQLString") & "', URL='" & chkString(url, "SQLString") & "', filesize ='" & chkString(filesize, "SQLString") & "', license ='" & chkString(license, "SQLString") & "', lang ='" & chkString(lang, "SQLString") & "',platform ='" & chkString(platform, "SQLString") & "',publisher ='" & chkString(publisher, "SQLString") & "',publisher_url ='" & chkString(publisher_url, "SQLString") & "',uploader ='" & chkString(uploader, "SQLString") & "',description ='" & chkString(des, "SQLString") & "',keyword ='" & chkString(key, "SQLString") & "',INGREDIENTS ='" & chkString(INGREDIENTS, "SQLString") & "', BADLINK=0 WHERE RECIPE_ID =" & webid)
end if
This makes the chkstring occur on the field. I'm not sure if this one is required or not.
And finally line 1066ish I re-wrote to this:
" <textarea name=""ingredients"" cols=""30"" rows=""4"">" & ChkString(RS("INGREDIENTS"), "display") & "</textarea>" & vbNewLine & _
Again we had the email variable involved here. When doing an update, I think the system was overwriting the ingredients field with the email field, which was blank.
My next endevor is to make the ingedients display as a list, rather than a long string. Any help would be much welcomed.< |
| JJenson |
Posted - 23 June 2007 : 23:13:08
Sounds great when you are ready let me know and I will put it up on my server I can test it on whatever database you would like me to.< |
| CodeMan7 |
Posted - 23 June 2007 : 18:59:49
Ok. Will do.
BTW, I have converted the Links Manager mod over to a Recipe Manager mod. I just need to fine tune it. It actually works very good.
I've added a couple of new features but I want to add some more.< |
| JJenson |
Posted - 23 June 2007 : 18:51:42
Start a new topic on the require mod codeman. Tell me which file is missing I thought I just checked it out and its got everything. I know there are some holes I have just been in full time school and work so haven't had much of a chance to fix it like it needs to be.  < |
| cripto9t |
Posted - 23 June 2007 : 14:26:42
I'm using mySql 5
The "popular" link throws an error because the sql uses "Select Top".
MySql uses "LIMIT"
Use the TopSQL function located in "inc_func_common" to fix this.
change this
strSQL = "SELECT TOP " & intPopular & " RECIPE_ID, NAME, URL, KEYWORD, DESCRIPTION, INGREDIENTS, POST_DATE, HIT, CATEGORY, PARENT_ID, SHOWS, BADLINK FROM "& strTablePrefix & "RECIPE WHERE SHOWS = 1 ORDER BY HIT DESC"
dim rsPopular
set rsPopular = server.CreateObject("adodb.recordset")
rsPopular.Open strSQL, my_Conn
to this
strSQL = "SELECT RECIPE_ID, NAME, URL, KEYWORD, DESCRIPTION, INGREDIENTS, POST_DATE, HIT, CATEGORY, PARENT_ID, SHOWS, BADLINK FROM "& strTablePrefix & "RECIPE WHERE SHOWS = 1 ORDER BY HIT DESC"
dim rsPopular
set rsPopular = server.CreateObject("adodb.recordset")
rsPopular.Open TopSQL(strSQL,intPopular), my_Conn
You'll need to change the SHOW column to whatever you renamed it.< |
| CodeMan7 |
Posted - 22 June 2007 : 14:38:04
I made changes to the Links Manager mod before I installed it. (This was to correct the things I found wrong with the Recipe mod.)
I got the Links Manager working fine, with no problems. And the Recipe mod is based on the Links Manager mod. That is obvious by the code. Now I think I can rework the Recipe mod and get it working. I'll let you know how that turns out.
(I changed the rating system from 1 to 5 in Links Manager to 1 to 10.)
I'd like to get your Require Member Profile mod working. I tried it but the zip didn't have the admin file.
< |
| JJenson |
Posted - 22 June 2007 : 12:52:57
The one really quirky thing is that the person who uploaded the recipe changes on who viewed it last. I have not looked into it at all but you might want to take a look at that if you haven't already. < |
| CodeMan7 |
Posted - 22 June 2007 : 12:41:17
No problem. I think I know what you mean. I've seen some quirks in it myself. They shouldn't be too hard to work out.
Also, I downloaded the Links Manager mod. It's interesting that this uses the same database as the Recipe mod.
I'm going to install the Links Manager mod also. (I'm doing this on an off site testing area, so I'm not worrying about it crashing.)
I figure between the two of them I ought to be able to put something decent together.
Right now, the Recipe mod does most of what it is supposed to do. All of the major things work. Just some minor things.
I'll try to keep everybody posted here.< |
| JJenson |
Posted - 22 June 2007 : 12:00:58
Yeah I actually have the mod david did on my site in MSSQL but haven't tested that out. Also I had it up on a site with access and it had some quiry things but worked overall. I would show you but it is behind a password protected site.< |
| CodeMan7 |
Posted - 22 June 2007 : 11:32:35
Ok. Keep in mind that I'm trying to just get this working with MySQL, so I'm not taking any other implementation into account.
Others might want to check it out with Access or whatever they are using.
It would be nice if anyone who has this working could give us some input. I've seen links to a couple of sites who are using something similar. They're both in foreign languages but I can recognize the mod.
< |
| JJenson |
Posted - 22 June 2007 : 11:28:29
Hey CodeMan when you get this all rewritten and working well I would aprpeciate it if you would upload the updated version on snitzbitz? I am sure there are alot of people that would really appreciate that  < |
| CodeMan7 |
Posted - 21 June 2007 : 15:12:56
I haven't notified him.
I've got the mod working. It hasn't crashed on me yet, but everything is not working exactly like it should.
I'm cleaning up the code and adding recipes so I can give it a good test. So far, so good.
I noticed the "search" function searches the "keywords" and "Procedure" fields. It seems strange that it would search on Procedure and not on "Ingredients". I think I'll change that.
There are some quirks. Like when you have to click on "Next" for next page. That works, but when you click on "Previous" it takes you back to the menu and not the previous page.
Once I've got it working I'm going to rewrite it for a Classifieds mod.< |
| AnonJr |
Posted - 21 June 2007 : 14:39:24
No I haven't installed it yet.
Give the errors that we've been working on over the last couple days, I suspect it wasn't tested on MySQL and just needs to be updated to accommodate it. Has anybody notified Classic?< |
|
|
