| Author |
 Topic  |
|
CodeMan7
New Member
USA
88 Posts |
 Posted - 21 June 2007 : 10:13:44
|
Thanks, Anon. It does work. Actually, it works the same as the one I suggested.
I don't think this mod was ready for primetime. It has a link (after the search) beside each recipe which says:
" Report a bug (or error)"
When you click on that link, you get an error which says that "table snitz.recipe" does not exist.
The search on 10 recipes works fine. Everything is formatted as it should be. The searches on 20 and 30 recipes are all off and have lots of errors, code snippets showing, etc.
Did you install this mod, Anon? Just curious what you got, if you did install it.
< |
 |
|
|
AnonJr
Moderator
United States
5768 Posts |
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?< |
|
|
|
CodeMan7
New Member
USA
88 Posts |
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.< |
|
|
|
JJenson
Advanced Member
USA
2121 Posts |
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
New Member
USA
88 Posts |
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
Advanced Member
USA
2121 Posts |
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
New Member
USA
88 Posts |
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
Advanced Member
USA
2121 Posts |
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
New Member
USA
88 Posts |
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.
< |
|
|
|
cripto9t
Average Member
USA
881 Posts |
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.< |
_-/Cripto9t\-_ |
Edited by - cripto9t on 23 June 2007 14:32:07 |
|
|
|
JJenson
Advanced Member
USA
2121 Posts |
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. < |
|
|
|
CodeMan7
New Member
USA
88 Posts |
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
Advanced Member
USA
2121 Posts |
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.< |
|
|
|
simon emery
Starting Member
19 Posts |
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.< |
|
|
|
simon emery
Starting Member
19 Posts |
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 < |
|
|
|
Topic |
|
|
|
Mod: Recipe Book 2.1
