Recipe Mod Database

[Michael Biddle]

Recipe Mod
By: whitemike
Demo: Here (http://www.vbulletinzone.com)
Official Requests: Here (http://www.vbulletinzone.com/f9/)

NOTE: Support will be provided here, but I will get to it sooner on my official site. vBulletin Zone (http://www.vbulletinzone.com/)

Installation:
Templates to add:3
Templates to edit:3
Plugins Added: 14
Phrases Added: 12
Quires ran: 9
Instructions:

Import the Product .xml
Edit templatesEditpost:

Find:
<!-- / subject field -->

Add Under:
<if condition="$threadinfo[firstpostid] == $postinfo[postid] AND $foruminfo[enable_recipe]">
$editrecipe
<else />Find:
$messagearea
<!-- / message area -->

$posticons

</td>
</tr>
</table>

</div>
</div>

Add After:
</if>

Showthread:

Find:
$Navbar

Add Under:
<if condition="$foruminfo[enable_recipe]">
$recipe
</if>

Find:
<a name="poststop" id="poststop"></a>

Add Under:
<if condition="$no_posts">
<else />

Find:
<div id="posts">$postbits<div id="lastpost"></div></div>

Add Above:
</if>

Newthread:

Find:
<!-- / subject field -->

Add Under:

<if condition="$foruminfo[enable_recipe]">
$newrecipe
<else />

Find:

<!-- / message area -->

$imagereg

$posticons

</td>
</tr>
</table>

</div>
</div>

Add After:
</if>

Find:

<input type="submit" class="button" name="preview" value="$vbphrase[preview_post]" accesskey="r" tabindex="1" />Replace with:

<if condition="$foruminfo[enable_recipe]"></else><input type="submit" class="button" name="preview" value="$vbphrase[preview_post]" accesskey="r" tabindex="1" /></if>
Postbit(_legacy):

Add at Top:


<if condition="$post[postcount] == 1 && in_array($thread['forumid'], array($vboptions[recipe_forums]))">
<if condition="$show['attachments']">
<!-- attachments -->
<div style="padding:$stylevar[cellpadding]px">

<if condition="$show['thumbnailattachment']">
<fieldset class="fieldset">
<legend>$vbphrase[attached_thumbnails]</legend>
<div style="padding:$stylevar[formspacer]px">
$post[thumbnailattachments]
</div>
</fieldset>
</if>

<if condition="$show['imageattachment']">
<fieldset class="fieldset">
<legend>$vbphrase[attached_images]</legend>
<div style="padding:$stylevar[formspacer]px">
$post[imageattachments]
</div>
</fieldset>
</if>

<if condition="$show['imageattachmentlink']">
<fieldset class="fieldset">
<legend>$vbphrase[attached_images]</legend>
<table cellpadding="0" cellspacing="$stylevar[formspacer]" border="0">
$post[imageattachmentlinks]
</table>
</fieldset>
</if>

<if condition="$show['otherattachment']">
<fieldset class="fieldset">
<legend>$vbphrase[attached_files]</legend>
<table cellpadding="0" cellspacing="$stylevar[formspacer]" border="0">
$post[otherattachments]
</table>
</fieldset>
</if>

<if condition="$show['moderatedattachment']">
<fieldset class="fieldset">
<legend>$vbphrase[attachments_pending_approval]</legend>
<table cellpadding="0" cellspacing="$stylevar[formspacer]" border="0">
$post[moderatedattachments]
</table>
</fieldset>
</if>

</div>
<!-- / attachments -->
</if>
<else />

Add at End:
</if>

Find:
<div>$vbphrase[posts]: $post[posts]</div>Add After:
<div>$vbphrase[recipe_stats]: $post[recipe_stats]</div>

Fixes:

1.6

Added another template edit into the newthread template to remove the preview post option
1.5

Added a vboption for the forumid's for the templates to make easier on client side 1.4

Added Template Grouping
Cached Templates
Other small minor changes 1.3

Fixed Spelling - Duh 1.2

Fixed Major Edit Post Bug - Thanks to Nick for opening my eyes 1.1
Fixed Edit Post Bug
Fixed Spelling Error
Thats it!

Configure

Go to ACP -> Forums & Moderators -> Forum Manager -> Pick a forum and at bottom it has a new yesno setting
Go to ACP -> vBulletin Options -> Recipe Mod Database -> Enter the forumid's used for your forum
Please Click Install if you use

[Michael Biddle]

Reserved for Future Use

[Lionel]

hi, 2 questions

1-Can you add a pic?

2-can you print recipe? If it's part of showthread it will not unless you add support code.

[Michael Biddle]

No and Not tested. Will think about these in future release though.

[SpanishHarlem]

In the process of trying to install. I keep getting this in the postbit legacy.

The following template conditional expression contains function calls:

<if condition="$post[postcount] == 1 && $thread[forumid] == x(22)">

Function Name Usage in Expression
x x(22)

With a few exceptions, function calls are not permitted in template conditional expressions. Please go back and re-write this expression.

The following functions are allowed in template conditional expressions:
in_array() is_array() is_numeric() isset() empty() defined() array() can_moderate() can_moderate_calendar() exec_switch_bg() is_browser() is_member_of()

We have almost 700 recipes on our forum. This would be some sweet hack. Thank's for that.

[Michael Biddle]

replace x with 22 so its

<if condition="$post[postcount] == 1 && $thread[forumid] == 22">

[SpanishHarlem]

Thanks. Must have done something wrong along the way. Guess I will check everything out and see where I went wrong. lol

hmmmm have gone through every template again and have installed the product. Try clicking on new thread and still isn't showing. yikes

[SkyCatcher]

I don't have time right now but when I get off work I will install this. It's something that I can really really use, thanks!

[jackstraw01]

Can this be made exclusive to one forum? I have a section for recipes on my forum, can I make it so that it only applies in that section and the usual post box appears elsewhere?

[Hornstar]

Not a bad mod for quite a few sites, nice work.

[Cyricx]

Great idea!! I definately agree with the being able to upload a pic and a printable version!!

I'm gonna keep my eye on this thread :)

[akulion]

great mod

i would like to make a suggestion: how about adding an image box somewhere so that a small picture of the dish can be uploaded

then it would look like a cool cook book :D

Great mod but unfortunately I wont be using it cos I already put like a 1000 recipes using GARS so it would be one heck of a job for me to transfer them over

but ill click install all the same in support :D

[jackstraw01]

Ok, I have this installed and it works great.

However, it would be nice if when viewing the profile of a member, if it would show how many recipes they have contributed much like the thank you mod.

Thanks.

[UncoderMom]

WOW! I have a recipe forum with hundreds of them!!! This is AWESOME!!!

[UncoderMom]

Ok, I have this installed and it works great.

However, it would be nice if when viewing the profile of a member, if it would show how many recipes they have contributed much like the thank you mod.

Thanks.

That sounds way cool!

Can you maybe give vbux for posting recipes too?

[Michael Biddle]

Do you mean just add the Stats to the user profile?

[hawks_mp]

Is it possible to modify this hack so it automatically wraps img or code tags around certain input fields?

[SkyCatcher]

Only think I don't like is that previously added recipies (normal threads) aren't displayed anymore because you've gotten rid of the postbit with that conditional.

Like the hack, just not sure what I'm going to do to get the old recipies into the new system.

[Michael Biddle]

The origional ones should still show up in the instructions part.

[R-n-R]

OK, I must be missing something here (which is highly possible for me at 1AM) I just add this Mod to my site (great idea!) and I modified all the templates as described in your above instructions, but I do not see where this mod is showing up?

I took a look at your Demo site and even registered. Again I do not see anything like in the screen shots, all I see was the normal Add a post box.

What am I missing here? Thanks for setting me straight! :p

[SkyCatcher]

OK, I must be missing something here (which is highly possible for me at 1AM) I just add this Mod to my site (great idea!) and I modified all the templates as described in your above instructions, but I do not see where this mod is showing up?

I took a look at your Demo site and even registered. Again I do not see anything like in the screen shots, all I see was the normal Add a post box.

What am I missing here? Thanks for setting me straight! :p

Go to your admincp > edit forums > find your recipe forum and scroll to the bottom. Enable the hack :P

[R-n-R]

Go to your admincp > edit forums > find your recipe forum and scroll to the bottom. Enable the hack :P
AH! Its amazing how sleep has an effect on the mind. I see that now, Thanks!

[R-n-R]

Well I guess a little more help is in order, I am getting a Database (MySQL) Error.

Here is the actual error(Blue letters/numbers omitted for real letters and numbers):

EDITED TO ADD: I only get this error when I enable the mod in my forum, and it effects all my templates not just the one I modified. When I DISABLE the Mod in the forum the MySQL Errors go away and forum works normally as before.

Database error in vBulletin 3.6.5:

Invalid SQL:
SELECT count(postid) AS post_count FROM post WHERE threadid='12103';

MySQL Error : Table 'livingli_vbul.post' doesn't exist
Error Number : 1146
Date : Saturday, March 24th 2007 @ 10:16:56 AM
Script : http://www.<my domain>.com/forum/showthread.php?p=145025
Referrer : http://www.<my domain>.com/forum/newthread.php?do=postthread&f=108
IP Address : xxx.xx.xx.xxx
Username : <my user name>
Classname : vb_database


I used a existing forum (that might of had a total of 6 posts, it was recently added before I found this mod.

I get this error when I try to add a new recipe and I get this error when I try to view any exisitng (pre-mod) posts in threads.

Any ideas?

[waller99]

Same here when I try and create a new recipe.

Database error in vBulletin 3.6.4:

Invalid SQL:
SELECT count(postid) AS post_count FROM post WHERE threadid='405';

MySQL Error : Table 'mofsql.post' doesn't exist
Error Number : 1146
Date : Saturday, March 24th 2007 @ 09:20:05 AM
Script : http://www.mysite.com/showthread.php?p=4798
Referrer : http://www.mysite.com/newthread.php?do=newthread&f=20
IP Address :00.00.00.00
Username : username
Classname : vb_database

[SpanishHarlem]

Only think I don't like is that previously added recipies (normal threads) aren't displayed anymore because you've gotten rid of the postbit with that conditional.

Like the hack, just not sure what I'm going to do to get the old recipies into the new system.

Thank's for letting me know. If that is the case. Will not be adding it to the big forum. I don't want to lose 700 recipes.

[R-n-R]

Thank's for letting me know. If that is the case. Will not be adding it to the big forum. I don't want to lose 700 recipes.
Yeah, glad I only have 6 in mine now, justed the forum a few days ago.

[SkyCatcher]

Thank's for letting me know. If that is the case. Will not be adding it to the big forum. I don't want to lose 700 recipes.

Dunno. The OP said that they should still show up. Fact is, if you disable the recipe mod in that forum your threads will appear as normal again. The old threads just aren't visible to me when activating it.

You can give it a try and see if it works, it won't delete your threads or posts. If it doesn't work, simply uninstall it :)

[LRadunz]

Same here when I try and create a new recipe.

Database error in vBulletin 3.6.4:

I had the same problem and you can find the fix here:
http://www.vbhackers.com/f76/recipe-mod-6442/index8.html

I don't know why the coder didn't use this info and place it here.

[ssvp]

So I got it all installed and it appears as if it work correctly. However upon filling in the fields. I get this error back:

The message you have entered is too short. Please lengthen your message to at least 1 characters.

[waller99]

I had the same problem and you can find the fix here:
http://www.vbhackers.com/f76/recipe-mod-6442/index8.html

I don't know why the coder didn't use this info and place it here.


Thanks. That worked. I appreciate it. :up:

[kfiasche81]

UPDATE THIS MOD PLEASE !!!

http://www.vbhackers.com/f76/recipe-mod-6442/index8.html#post54484

[Michael Biddle]

Sorry about that guys, thought I already applied this updated, its in now

[Michael Biddle]

Sorry for double posting but it is updated now, so it will fix the post count problem

[Michael Biddle]

Thank's for letting me know. If that is the case. Will not be adding it to the big forum. I don't want to lose 700 recipes.

this doesnt show it in postbit form, but it does show it in the instructions section.


and no your 700 recipies wont be lost, they will be in the instructions as well, might want to have users go back and edit it according

[R-n-R]

OK I downloaded the lastest update, but why is it when I click on "post preview" or "submit new thread" I get the following:

The following errors occurred when this message was submitted:

1. The message you have entered is too short. Please lengthen your message to at least 15 characters.

I have WELL over the number of characters I have the minimum set in vB, so whats the fix for this?

[SpanishHarlem]

this doesnt show it in postbit form, but it does show it in the instructions section.


and no your 700 recipies wont be lost, they will be in the instructions as well, might want to have users go back and edit it according

Thank's Whitemike. I was really worried about that. It's a wonderful hack.

[Michael Biddle]

Not a problem. I thought about this problem during coding so the instruction part i left as message in sql rather then making a recipe_instructions like the rest

[R-n-R]

OK I downloaded the lastest update, but why is it when I click on "post preview" or "submit new thread" I get the following:



The following errors occurred when this message was submitted:

1. The message you have entered is too short. Please lengthen your message to at least 15 characters.


I have WELL over the number of characters I have the minimum set in vB, so whats the fix for this?

any ideas guys?

[jackstraw01]

Do you mean just add the Stats to the user profile?

Yes, exactly what I mean.

[ashley53680]

This hack has great potential! I am subbing. :)

[LRadunz]

So I got it all installed and it appears as if it work correctly. However upon filling in the fields. I get this error back:

The message you have entered is too short. Please lengthen your message to at least 1 characters.

# YOU NEED AT LEAST 12 CHARACTERS (Letters) IN DESCRIPTION and INSTRUCTIONS.

For All fixes.. go here...there is a new one.
http://www.vbhackers.com/f76/recipe-mod-6442/index10.html

[Michael Biddle]

OK. Product is now updated with all fixes. Please continue reporting bugs.

[jackstraw01]

Is it normal for the "Instructions" to be repeated in a seperate post?

Example: http://www.faqpal.com/forum/showthread.php?p=3#post3

also, is there a way to specify next to each field name the minimum characters and for it to say its required?

[Michael Biddle]

follow the instructions and it shows you how to remove that first post

[Fungsten]

I have a Food and Dining Subforum that is perfect for this!

On Edit.

Is there a way for a user to choose if they want to post a Recipe or a regular post? That's what I need. Thanks.

[Michael Biddle]

I have a Food and Dining Subforum that is perfect for this!

On Edit.

Is there a way for a user to choose if they want to post a Recipe or a regular post? That's what I need. Thanks.


This has been requested many times at vbhackers.com. I have chosen not to implement this feature, because it is forum based. Sorry for the inconvience. Maybe i will think about it in the future

[Fungsten]

Thanks.

[milsirhc]

Can we add pictures into the recipe as well?

[woostar]

found a bug (hoping someone can help).

To re-create the bug:-

1. Post a recipe.
2. Make a post after the recipe.
3. Edit the reply post and save.

- Refresh -

The recipe has been over written by your edited post.

W.>

[raiderlax]

Cool Mod, can it be used for only a specific forum? Thanks.

[Michael Biddle]

It can be used in as many forums as you like, but must enable per forum.

Please click install for support

[milsirhc]

whitemike,

have clicked install for support ;) thanks for this mod btw.

It would really be good if you can add an image feature. This is kinda important as you know most of the recipebooks does show what's the end product looks like.. else no one will know..

Hopefully you can implement it. Thanks

[Michael Biddle]

Well Just threw the attachment code in, and how does this look?

http://white-projects.com/showthread.php?p=1

I know it looks shitty. Lol but how should I make it better?

[milsirhc]

hahaa, let's tweak this up!! =P

Ideally, the image should be in the "post" itself but.. if you want to do it like the way you do (throwing in the attachment mod), try to shift the whole attachment table just below the post table, making it look like it's together~

[Michael Biddle]

hahaa, let's tweak this up!! =P

Ideally, the image should be in the "post" itself but.. if you want to do it like the way you do (throwing in the attachment mod), try to shift the whole attachment table just below the post table, making it look like it's together~

Problem we have here, which I don't see how to fix it unless i change whole mod because how it is now, is it doesn't even show up as postbit, but a template in showthread.

Well now ive been working on it, now i think im making it in postbit. so check it out. on my progress. any suggestions would be helpful. :D

[woostar]

Have been able to re-create the bug whitemike? you kinda skiped over my post.


found a bug (hoping someone can help).

To re-create the bug:-

1. Post a recipe.
2. Make a post after the recipe.
3. Edit the reply post and save.

- Refresh -

The recipe has been over written by your edited post.


W.>

[SnowBot]

hhmm where have i gone wrong here.....
see screenshot

http://sharingbirthdays.com/uploads/testthread.jpg

[Michael Biddle]

Read the directions...

[SnowBot]

Read the directions...

I did, any other advice?

As far as i am aware i did all the edits correctly

[Michael Biddle]

<if condition="$post[postcount] == 1 && $thread[forumid] == x(replace with forumid of your recipe mod)">
<else />

change x to your recipe forumid

[SnowBot]

hhmm thats what i have done

<if condition="$post[postcount] == 1 && $thread[forumid] == 7">
<else />
<br />
<!-- top category table setup -->

[SnowBot]

got it working.

[Michael Biddle]

kk, glad you did

[Fungsten]

that is for Recipes! The members love it!!

[woostar]

Could been a great mod but UNINSTALLED because the the coder is rude and has twice completely ignored a bug that is a major problem when put on a forum where this mod is used alot.

found a bug (hoping someone can help).

To re-create the bug:-

1. Post a recipe.
2. Make a post after the recipe.
3. Edit the reply post and save.

- Refresh -

The recipe has been over written by your edited post.


W.>

[yesfans]

Huum, change out the wording for this and I coudl use it on my DIY car repair site. How to do this or that repair.

[Michael Biddle]

Could been a great mod but UNINSTALLED because the the coder is rude and has twice completely ignored a bug that is a major problem when put on a forum where this mod is used alot.

Well for 1 I make all of my modifications free to the public, and do the best in powers and time provided, and for you to come to my thread and tell me that I am rude, and have nothing to back it up with is simply childish and idiotic. I haven't had any extra time to go on, this got emailed to my phone, which I am on now. So go ahead and badmouth my free time and modifications. U are the person here that is being rude.

And about the car repair site, just change the names od the phrases

[thepub]

ok a couple questions before I decide to install. I think this sounds awesome and would be a great asset to my cooking forum! As of right now if this is enabled in a forum you can only post a recipe post not a "regular looking" post? Also, you cannot upload attachments like you can in a "regular post"?

[woostar]

Well for 1 I make all of my modifications free to the public, and do the best in powers and time provided, and for you to come to my thread and tell me that I am rude, and have nothing to back it up with is simply childish and idiotic. I haven't had any extra time to go on, this got emailed to my phone, which I am on now. So go ahead and badmouth my free time and modifications. U are the person here that is being rude.

And about the car repair site, just change the names od the phrases

oh now i get acknowledgement because i "badmouthed" you... oh did i offend you, i'm sorry!
I'm sorry that I had "nothing to back it up with" other than a way to help you recreate the error. I'm sick to death of coders hiding behind "it's free" to pawn code that has the potential to be more of a destructive nature than a help; yet you still encourage ppl to spend their time to install it!

.... and all it required was "hiya, will sort it when i get time". Yet you choose to answer posts before and after my attempts to help you out!

and FYI there are a few more important errors that you should be aware of (you can hunt for those yourself); if you were any kind of developer you'd know how important beta testers are!

[Michael Biddle]

then uninstall it and dont bother using my modifications

[thepub]

ok a couple questions before I decide to install. I think this sounds awesome and would be a great asset to my cooking forum! As of right now if this is enabled in a forum you can only post a recipe post not a "regular looking" post? Also, you cannot upload attachments like you can in a "regular post"?

just bumping this so my question might get answered and not lost in the shuffle :o

then uninstall it and dont bother using my modifications

I want to install it if my question can get answered *smiles sweetly*

[Michael Biddle]

well, for the first question, it has been request over at vbhackers.com but i chose not to do this at this time because its based off of forums, also the attachments i have a somewhat fix for that, just include the attachment code between the if in the postbit, problem is it really doesnt look to good. once i get axx to a computer again i will fix this out, sorry for any problems this may cause. sidekick 3 takes forever to load webpages...

[thepub]

jumping for joy! I got it installed! Now one thing and it will be 100% perfect! There is a typo...the word "ingredient" is spelled "ingrediant" (which is wrong). How can I fix that so it's spelled correctly??

[Michael Biddle]

Yea I realized that, go into the phrase manager and edit the i believe its recipe_ingredients. Will use friends computer tommorow and update it.

[Michael Biddle]

I managed to get online again, I think i found the problem with the edit post. Will keep updated soon

[Michael Biddle]

Well I fixed the edit post problem with overwriting the original post. Please confirm that it is functioning correctly

[sunrainme]

<div>$vbphrase[posts]: $post[posts]</div> I don't have.

But I have this <div>
$vbphrase[posts]: $post[posts]<!-- Start Post Thank You Hack -->
and it doesn't seem to work by fiddling with it. Any suggestions?

[Michael Biddle]

I don't have.

But I have this and it doesn't seem to work by fiddling with it. Any suggestions?

Go ahead and u can throw the div above what u posted and it will work

[ruger]

In postbit_legacy, what if you already have the following code further down?

<if condition="$show['attachments']">
<!-- attachments -->
<div style="padding:$stylevar[cellpadding]px">

<if condition="$show['thumbnailattachment']">
<fieldset class="fieldset">
<legend>$vbphrase[attached_thumbnails]</legend>
<div style="padding:$stylevar[formspacer]px">
$post[thumbnailattachments]
</div>
</fieldset>
</if>

<if condition="$show['imageattachment']">
<fieldset class="fieldset">
<legend>$vbphrase[attached_images]</legend>
<div style="padding:$stylevar[formspacer]px">
$post[imageattachments]
</div>
</fieldset>
</if>

<if condition="$show['imageattachmentlink']">
<fieldset class="fieldset">
<legend>$vbphrase[attached_images]</legend>
<table cellpadding="0" cellspacing="$stylevar[formspacer]" border="0">
$post[imageattachmentlinks]
</table>
</fieldset>
</if>

<if condition="$show['otherattachment']">
<fieldset class="fieldset">
<legend>$vbphrase[attached_files]</legend>
<table cellpadding="0" cellspacing="$stylevar[formspacer]" border="0">
$post[otherattachments]
</table>
</fieldset>
</if>

<if condition="$show['moderatedattachment']">
<fieldset class="fieldset">
<legend>$vbphrase[attachments_pending_approval]</legend>
<table cellpadding="0" cellspacing="$stylevar[formspacer]" border="0">
$post[moderatedattachments]
</table>
</fieldset>
</if>

</div>
<!-- / attachments -->
</if>
<else />

[Michael Biddle]

In postbit_legacy, what if you already have the following code further down?

<if condition="$show['attachments']">
<!-- attachments -->
<div style="padding:$stylevar[cellpadding]px">

<if condition="$show['thumbnailattachment']">
<fieldset class="fieldset">
<legend>$vbphrase[attached_thumbnails]</legend>
<div style="padding:$stylevar[formspacer]px">
$post[thumbnailattachments]
</div>
</fieldset>
</if>

<if condition="$show['imageattachment']">
<fieldset class="fieldset">
<legend>$vbphrase[attached_images]</legend>
<div style="padding:$stylevar[formspacer]px">
$post[imageattachments]
</div>
</fieldset>
</if>

<if condition="$show['imageattachmentlink']">
<fieldset class="fieldset">
<legend>$vbphrase[attached_images]</legend>
<table cellpadding="0" cellspacing="$stylevar[formspacer]" border="0">
$post[imageattachmentlinks]
</table>
</fieldset>
</if>

<if condition="$show['otherattachment']">
<fieldset class="fieldset">
<legend>$vbphrase[attached_files]</legend>
<table cellpadding="0" cellspacing="$stylevar[formspacer]" border="0">
$post[otherattachments]
</table>
</fieldset>
</if>

<if condition="$show['moderatedattachment']">
<fieldset class="fieldset">
<legend>$vbphrase[attachments_pending_approval]</legend>
<table cellpadding="0" cellspacing="$stylevar[formspacer]" border="0">
$post[moderatedattachments]
</table>
</fieldset>
</if>

</div>
<!-- / attachments -->
</if>
<else />

Its fine its under an if, do as the instructions say.

[thepub]

darn! Hopefully you caught the typo with the recipe count in the users post bit, it's spelled "recipies" and should be spelled "recipe"

[thepub]

Yea I realized that, go into the phrase manager and edit the i believe its recipe_ingredients. Will use friends computer tommorow and update it.

it's still not fixed. it says "ingrediants to be used" what and where is the phrase manager?

also I got this error message Invalid SQL:
ALTER TABLE forum ADD enable_recipe TINYINT( 1 ) NOT NULL;

MySQL Error : Duplicate column name 'enable_recipe'
Error Number : 1060
Date : Tuesday, April 10th 2007 @ 10:27:36 AM
Script : http://www.theneighborhoodpub.com/admincp/plugin.php?do=productimport
Referrer : http://www.theneighborhoodpub.com/admincp/plugin.php?do=productadd
Username : Jenn
Classname : vb_database

[jackstraw01]

Do we just import the xml file to upgrade? After I upgraded the XML, I lost my recipes.

What did I do wrong?

[Fungsten]

Mike,

I am upgrading to the update. Since there are two XML files, should the old one be deleted or just upgrade to the new one? Thanks.

[Michael Biddle]

I would personally uninstall then reinstall the new.one. If ur getting errors about duplicates in the database go into phpmyadmin and delete the rows.

[Michael Biddle]

I would personally uninstall then reinstall the new.one. If ur getting errors about duplicates in the database go into phpmyadmin and delete the rows.

[Michael Biddle]

I would personally uninstall then reinstall the new.one. If ur getting errors about duplicates in the database go into phpmyadmin and delete the rows.

[Dr.NoTime]

Worked great. Thank You!

[thepub]

I got this message today when we tried to edit a post:
MySQL Error : You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'LEFT JOIN post as post on (thread.threadid = post.threadid)

Error Number : 1064
Date : Wednesday, April 11th 2007 @ 06:01:19 PM
Script : http://www.theneighborhoodpub.com/editpost.php?do=updatepost&p=81571
Referrer : http://www.theneighborhoodpub.com/editpost.php?do=editpost&p=81571
IP Address :
Username :
Classname : vb_database

How do I fix this?

[Michael Biddle]

Thank you for reporting, I am working on this now

[nymyth]

will it work for 3.6.2?

Peace

[ssvp]

Interesting.. Just installed today. It seems I can't save the edit to the post. Errors our with an SQL Update postid = "P"

[Michael Biddle]

will it work for 3.6.2?

Peace

Yes

Interesting.. Just installed today. It seems I can't save the edit to the post. Errors our with an SQL Update postid = "P"

Working on error for this. Sorry

[nymyth]

im getting a sql error when trying to edit a recipe....


LEFT JOIN post as post on (thread.threadid = post.threadid)
WHERE postid = 'post.postid;

MySQL Error : You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'LEFT JOIN post as post on (thread.threadid = post.threadid)

Error Number : 1064

any ideas

[ericgray]

i have installed, checked, and double checked --

-- i can't get this to work --

-- does it need to be turned "on"?

[ericgray]

uninstalled -- :(

[nymyth]

^^yeah, you have to go forum permissions, edit the forum u designate, scroll down and ull see the enable option...

Peace

[ericgray]

works like a charm -- thank you!

[nymyth]

n/p....glad u got it working

Peace

[ericgray]

cool beans -- :D

how do i correct spelling on "ingredients" -- ??

[ericgray]

also, "preparation" is mis-spelled -- :|

[ericgray]

the edit function is a big one -- if you could fix that -- or else, people will gripe, lots -- :D

[ericgray]

there's an error with this hack --

-- the text in "instructions" copies down in to an independent duplicate post from the poster --

-- any idea how to remedy this?

[Michael Biddle]

Yes please follow the instructiosn in the postbit(_legacy)

You need to replace the X with the forumid's that you are choosing

[ericgray]

i really did that -- :(

the forum id is as follows --

<if condition="$post[postcount] == 1 && $thread[forumid] == 58">

any other hints?

thanks!

eric

[Michael Biddle]

Hey Eric, are you using postbit or postbit_legacy? please edit the correct template their. Also what version of VB?

Michael Biddle

[ericgray]

how do you select multiple forums, if you have sub-forums?

[ericgray]

Hey Eric, are you using postbit or postbit_legacy? please edit the correct template their. Also what version of VB?

Michael Biddle


hey mike -

i'm modifying "postbit_legacy" and using 3.6.0

[Michael Biddle]

All i can tell you is do ur best to edit as my instructions say. Also feel free to add my msn or aim, and i will hel p you directy

Michael Biddle

[ericgray]

thank you for this --

-- i am looking at adding multiple sub-forums -- how would i do that with that initial postbit legacy line?

thanks!

[jackstraw01]

Has anyone come up with a way to display in the user profile how many recipes they have contributed?

[Michael Biddle]

thank you for this --

-- i am looking at adding multiple sub-forums -- how would i do that with that initial postbit legacy line?

thanks!

Seperate by commas IE: 1,2,4,6,9

Has anyone come up with a way to display in the user profile how many recipes they have contributed?

Should just add the postbit line into the profile will go check

[ericgray]

i got it to work --

-- put the junk in postbit, and not posbit_legacy --

-- also, for multiple forums, just loop it --

<if condition="$post[postcount] == 1 && $thread[forumid] == 59">
<if condition="$show['attachments']">
<!-- attachments -->
<div style="padding:$stylevar[cellpadding]px">

<if condition="$show['thumbnailattachment']">
<fieldset class="fieldset">
<legend>$vbphrase[attached_thumbnails]</legend>
<div style="padding:$stylevar[formspacer]px">
$post[thumbnailattachments]
</div>
</fieldset>
</if>

<if condition="$show['imageattachment']">
<fieldset class="fieldset">
<legend>$vbphrase[attached_images]</legend>
<div style="padding:$stylevar[formspacer]px">
$post[imageattachments]
</div>
</fieldset>
</if>

<if condition="$show['imageattachmentlink']">
<fieldset class="fieldset">
<legend>$vbphrase[attached_images]</legend>
<table cellpadding="0" cellspacing="$stylevar[formspacer]" border="0">
$post[imageattachmentlinks]
</table>
</fieldset>
</if>

<if condition="$show['otherattachment']">
<fieldset class="fieldset">
<legend>$vbphrase[attached_files]</legend>
<table cellpadding="0" cellspacing="$stylevar[formspacer]" border="0">
$post[otherattachments]
</table>
</fieldset>
</if>

<if condition="$show['moderatedattachment']">
<fieldset class="fieldset">
<legend>$vbphrase[attachments_pending_approval]</legend>
<table cellpadding="0" cellspacing="$stylevar[formspacer]" border="0">
$post[moderatedattachments]
</table>
</fieldset>
</if>

</div>
<!-- / attachments -->
</if>
<else />
<if condition="$post[postcount] == 1 && $thread[forumid] == 60">
<if condition="$show['attachments']">
<!-- attachments -->
<div style="padding:$stylevar[cellpadding]px">

<if condition="$show['thumbnailattachment']">
<fieldset class="fieldset">
<legend>$vbphrase[attached_thumbnails]</legend>
<div style="padding:$stylevar[formspacer]px">
$post[thumbnailattachments]
</div>
</fieldset>
</if>

<if condition="$show['imageattachment']">
<fieldset class="fieldset">
<legend>$vbphrase[attached_images]</legend>
<div style="padding:$stylevar[formspacer]px">
$post[imageattachments]
</div>
</fieldset>
</if>

<if condition="$show['imageattachmentlink']">
<fieldset class="fieldset">
<legend>$vbphrase[attached_images]</legend>
<table cellpadding="0" cellspacing="$stylevar[formspacer]" border="0">
$post[imageattachmentlinks]
</table>
</fieldset>
</if>

<if condition="$show['otherattachment']">
<fieldset class="fieldset">
<legend>$vbphrase[attached_files]</legend>
<table cellpadding="0" cellspacing="$stylevar[formspacer]" border="0">
$post[otherattachments]
</table>
</fieldset>
</if>

<if condition="$show['moderatedattachment']">
<fieldset class="fieldset">
<legend>$vbphrase[attachments_pending_approval]</legend>
<table cellpadding="0" cellspacing="$stylevar[formspacer]" border="0">
$post[moderatedattachments]
</table>
</fieldset>
</if>

</div>
<!-- / attachments -->
</if>
<else />
<if condition="$post[postcount] == 1 && $thread[forumid] == 65">
<if condition="$show['attachments']">
<!-- attachments -->
<div style="padding:$stylevar[cellpadding]px">

<if condition="$show['thumbnailattachment']">
<fieldset class="fieldset">
<legend>$vbphrase[attached_thumbnails]</legend>
<div style="padding:$stylevar[formspacer]px">
$post[thumbnailattachments]
</div>
</fieldset>
</if>

<if condition="$show['imageattachment']">
<fieldset class="fieldset">
<legend>$vbphrase[attached_images]</legend>
<div style="padding:$stylevar[formspacer]px">
$post[imageattachments]
</div>
</fieldset>
</if>

<if condition="$show['imageattachmentlink']">
<fieldset class="fieldset">
<legend>$vbphrase[attached_images]</legend>
<table cellpadding="0" cellspacing="$stylevar[formspacer]" border="0">
$post[imageattachmentlinks]
</table>
</fieldset>
</if>

<if condition="$show['otherattachment']">
<fieldset class="fieldset">
<legend>$vbphrase[attached_files]</legend>
<table cellpadding="0" cellspacing="$stylevar[formspacer]" border="0">
$post[otherattachments]
</table>
</fieldset>
</if>

<if condition="$show['moderatedattachment']">
<fieldset class="fieldset">
<legend>$vbphrase[attachments_pending_approval]</legend>
<table cellpadding="0" cellspacing="$stylevar[formspacer]" border="0">
$post[moderatedattachments]
</table>
</fieldset>
</if>

</div>
<!-- / attachments -->
</if>
<else />
<if condition="$post[postcount] == 1 && $thread[forumid] == 62">
<if condition="$show['attachments']">
<!-- attachments -->
<div style="padding:$stylevar[cellpadding]px">

<if condition="$show['thumbnailattachment']">
<fieldset class="fieldset">
<legend>$vbphrase[attached_thumbnails]</legend>
<div style="padding:$stylevar[formspacer]px">
$post[thumbnailattachments]
</div>
</fieldset>
</if>

<if condition="$show['imageattachment']">
<fieldset class="fieldset">
<legend>$vbphrase[attached_images]</legend>
<div style="padding:$stylevar[formspacer]px">
$post[imageattachments]
</div>
</fieldset>
</if>

<if condition="$show['imageattachmentlink']">
<fieldset class="fieldset">
<legend>$vbphrase[attached_images]</legend>
<table cellpadding="0" cellspacing="$stylevar[formspacer]" border="0">
$post[imageattachmentlinks]
</table>
</fieldset>
</if>

<if condition="$show['otherattachment']">
<fieldset class="fieldset">
<legend>$vbphrase[attached_files]</legend>
<table cellpadding="0" cellspacing="$stylevar[formspacer]" border="0">
$post[otherattachments]
</table>
</fieldset>
</if>

<if condition="$show['moderatedattachment']">
<fieldset class="fieldset">
<legend>$vbphrase[attachments_pending_approval]</legend>
<table cellpadding="0" cellspacing="$stylevar[formspacer]" border="0">
$post[moderatedattachments]
</table>
</fieldset>
</if>

</div>
<!-- / attachments -->
</if>
<else />
<if condition="$post[postcount] == 1 && $thread[forumid] == 63">
<if condition="$show['attachments']">
<!-- attachments -->
<div style="padding:$stylevar[cellpadding]px">

<if condition="$show['thumbnailattachment']">
<fieldset class="fieldset">
<legend>$vbphrase[attached_thumbnails]</legend>
<div style="padding:$stylevar[formspacer]px">
$post[thumbnailattachments]
</div>
</fieldset>
</if>

<if condition="$show['imageattachment']">
<fieldset class="fieldset">
<legend>$vbphrase[attached_images]</legend>
<div style="padding:$stylevar[formspacer]px">
$post[imageattachments]
</div>
</fieldset>
</if>

<if condition="$show['imageattachmentlink']">
<fieldset class="fieldset">
<legend>$vbphrase[attached_images]</legend>
<table cellpadding="0" cellspacing="$stylevar[formspacer]" border="0">
$post[imageattachmentlinks]
</table>
</fieldset>
</if>

<if condition="$show['otherattachment']">
<fieldset class="fieldset">
<legend>$vbphrase[attached_files]</legend>
<table cellpadding="0" cellspacing="$stylevar[formspacer]" border="0">
$post[otherattachments]
</table>
</fieldset>
</if>

<if condition="$show['moderatedattachment']">
<fieldset class="fieldset">
<legend>$vbphrase[attachments_pending_approval]</legend>
<table cellpadding="0" cellspacing="$stylevar[formspacer]" border="0">
$post[moderatedattachments]
</table>
</fieldset>
</if>

</div>
<!-- / attachments -->
</if>
<else />
<if condition="$post[postcount] == 1 && $thread[forumid] == 68">
<if condition="$show['attachments']">
<!-- attachments -->
<div style="padding:$stylevar[cellpadding]px">

<if condition="$show['thumbnailattachment']">
<fieldset class="fieldset">
<legend>$vbphrase[attached_thumbnails]</legend>
<div style="padding:$stylevar[formspacer]px">
$post[thumbnailattachments]
</div>
</fieldset>
</if>

<if condition="$show['imageattachment']">
<fieldset class="fieldset">
<legend>$vbphrase[attached_images]</legend>
<div style="padding:$stylevar[formspacer]px">
$post[imageattachments]
</div>
</fieldset>
</if>

<if condition="$show['imageattachmentlink']">
<fieldset class="fieldset">
<legend>$vbphrase[attached_images]</legend>
<table cellpadding="0" cellspacing="$stylevar[formspacer]" border="0">
$post[imageattachmentlinks]
</table>
</fieldset>
</if>

<if condition="$show['otherattachment']">
<fieldset class="fieldset">
<legend>$vbphrase[attached_files]</legend>
<table cellpadding="0" cellspacing="$stylevar[formspacer]" border="0">
$post[otherattachments]
</table>
</fieldset>
</if>

<if condition="$show['moderatedattachment']">
<fieldset class="fieldset">
<legend>$vbphrase[attachments_pending_approval]</legend>
<table cellpadding="0" cellspacing="$stylevar[formspacer]" border="0">
$post[moderatedattachments]
</table>
</fieldset>
</if>

</div>
<!-- / attachments -->
</if>
<else />
<if condition="$post[postcount] == 1 && $thread[forumid] == 61">
<if condition="$show['attachments']">
<!-- attachments -->
<div style="padding:$stylevar[cellpadding]px">

<if condition="$show['thumbnailattachment']">
<fieldset class="fieldset">
<legend>$vbphrase[attached_thumbnails]</legend>
<div style="padding:$stylevar[formspacer]px">
$post[thumbnailattachments]
</div>
</fieldset>
</if>

<if condition="$show['imageattachment']">
<fieldset class="fieldset">
<legend>$vbphrase[attached_images]</legend>
<div style="padding:$stylevar[formspacer]px">
$post[imageattachments]
</div>
</fieldset>
</if>

<if condition="$show['imageattachmentlink']">
<fieldset class="fieldset">
<legend>$vbphrase[attached_images]</legend>
<table cellpadding="0" cellspacing="$stylevar[formspacer]" border="0">
$post[imageattachmentlinks]
</table>
</fieldset>
</if>

<if condition="$show['otherattachment']">
<fieldset class="fieldset">
<legend>$vbphrase[attached_files]</legend>
<table cellpadding="0" cellspacing="$stylevar[formspacer]" border="0">
$post[otherattachments]
</table>
</fieldset>
</if>

<if condition="$show['moderatedattachment']">
<fieldset class="fieldset">
<legend>$vbphrase[attachments_pending_approval]</legend>
<table cellpadding="0" cellspacing="$stylevar[formspacer]" border="0">
$post[moderatedattachments]
</table>
</fieldset>
</if>

</div>
<!-- / attachments -->
</if>
<else />
<table class="tborder" id="post$post[postid]" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
<tr>
<td class="thead" $post[scrolltothis]>
<div class="normal" style="float:$stylevar[right]">
&nbsp;
<if condition="$show['postcount']">#<a href="showpost.php?$session[sessionurl]p=$post[postid]&amp;postcount=$post[postcount]" target="new" rel="nofollow" id="postcount$post[postid]" name="$post[postcount]"><strong>$post[postcount]</strong></a> &nbsp;</if>
<if condition="$show['reputationlink']">
<span id="reput <legend>$vbphrase[attached_files]</legend>
<table cellpadding="0" cellspacing="$stylevar[formspacer]" border="0">
$post[otherattachments]
</table>
</fieldset>
</if>

<if condition="$show['moderatedattachment']">
<fieldset class="fieldset">
<legend>$vbphrase[attachments_pending_approval]</legend>
<table cellpadding="0" cellspacing="$stylevar[formspacer]" border="0">
$post[moderatedattachments]
</table>
</fieldset>
</if>

</div>
<!-- / attachments -->
</if>

<if condition="$post['signature']">
<!-- sig -->
<div>
__________________<br />
$post[signature]
</div>
<!-- / sig -->
</if>

<if condition="$show['postedited']">
<!-- edit note -->
<div class="smallfont"> <hr size="1" style="color:$stylevar[tborder_bgcolor]" />
<em>
<phrase 1="$post[edit_username]" 2="$post[edit_date]" 3="$post[edit_time]">$vbphrase[last_edited_by_x_on_y_at_z]</phrase>.
<if condition="$post['edit_reason']">$vbphrase[reason]: $post[edit_reason]</if>
</em>
....

</div>
<!-- / post $post[postid] popup menu -->
</if>
</if>
</if>
</if>
</if>
</if>
</if>

[Michael Biddle]

Just make it:

<if condition="$post[postcount] == 1 && $thread[forumid] == 1,2,3,4,5>

[ericgray]

sorry for the long post --

-- but the commas don't work, as stated --

[ericgray]

Just make it:

<if condition="$post[postcount] == 1 && $thread[forumid] == 1,2,3,4,5>

it shits the bed and gives me errors -- :(

[ssvp]

im getting a sql error when trying to edit a recipe....




any ideas

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LEFT JOIN post as post on (thread.threadid = post.threadid)
WHERE postid = 'p' at line 2
Error Number : 1064

Same error.. The funny thing the earlier version didn't have this error..:)

[ssvp]

Well I got my editpost thing fixed..

Here's what I did..

Edited the Plugin

recipe_editpost_update_complete (http://www.forums.fvnorthwestern.com/forums/admincp/plugin.php?do=edit&pluginid=200)

Replaced Code with

if($foruminfo['enable_recipe']){
$recipe_description = addslashes($_POST['recipe_description']);
$recipe_difficulty = addslashes($_POST['recipe_difficult']);
$recipe_prep = addslashes($_POST['recipe_prep']);
$recipe_ingrediants = addslashes($_POST['recipe_ingrediants']);
$recipe_time = addslashes($_POST['recipe_time']);
$recipe_size = addslashes($_POST['recipe_size']);
$recipe_steps = addslashes($_POST['message']);
$db->query_write("UPDATE " . TABLE_PREFIX . "thread SET recipe_description = '$recipe_description', recipe_difficult = '$recipe_difficulty', recipe_prep = '$recipe_prep', recipe_ingrediants = '$recipe_ingrediants', recipe_time = '$recipe_time', recipe_size = '$recipe_size', recipe_steps = '$recipe_steps' WHERE threadid = '$threadinfo[threadid]'");
}


It now doesn't SQL Error out.. But haven't done much testing further..

[Michael Biddle]

That is the first bug, that will make users overwrite the origional thread. sorry been crazy busy lately, will get back to it asap. NN all

[jackstraw01]

So what should I add where to get the recipe counts in user profile?

[ericgray]

Well I got my editpost thing fixed..

Here's what I did..

Edited the Plugin

recipe_editpost_update_complete (http://www.forums.fvnorthwestern.com/forums/admincp/plugin.php?do=edit&pluginid=200)

Replaced Code with

if($foruminfo['enable_recipe']){
$recipe_description = addslashes($_POST['recipe_description']);
$recipe_difficulty = addslashes($_POST['recipe_difficult']);
$recipe_prep = addslashes($_POST['recipe_prep']);
$recipe_ingrediants = addslashes($_POST['recipe_ingrediants']);
$recipe_time = addslashes($_POST['recipe_time']);
$recipe_size = addslashes($_POST['recipe_size']);
$recipe_steps = addslashes($_POST['message']);
$db->query_write("UPDATE " . TABLE_PREFIX . "thread SET recipe_description = '$recipe_description', recipe_difficult = '$recipe_difficulty', recipe_prep = '$recipe_prep', recipe_ingrediants = '$recipe_ingrediants', recipe_time = '$recipe_time', recipe_size = '$recipe_size', recipe_steps = '$recipe_steps' WHERE threadid = '$threadinfo[threadid]'");
}


It now doesn't SQL Error out.. But haven't done much testing further..

good fix, sir -- works for me, too --

thanks!

[LEAD_WEIGHT]

Does your Mod let you upload an image, so people may know how a dish should look like.

Your demo link is missing a url character in your thread starter post whitemike .

[thepub]

have you fixed the edit post problem?

[LEAD_WEIGHT]

have you fixed the edit post problem?

I think it is fixed as it does say in thread starter and post made by ericgray I will wait till coder mentions if fixed was applied,

[ArchangelX]

It's not fixed. :(

When I try to edit the replies...it always takes me back to the main thread. I added Eric's code, too. :(

[ArchangelX]

To clarify, the Edit Post bug doesn't show the syntax error anymore, but what I'm getting is that if you post a response directly after submitting the code, if you try to edit the #2 post in the thread, it will take you to the 1st post and you can't edit it.

Any suggestions on what's going there? Thanks.

[StarBuG]

Some information about how this hack works would be nice.

Does it uses a forum and every recipe creates its own thread?
Or does it use the database?

Please update your original hack post with some information like it is standard on vB.or ;)

[Christine]

As of the build today (downloaded about a hour from post time), this is still an issue on editing.

This fixed it:
Well I got my editpost thing fixed..

Here's what I did..

Edited the Plugin

recipe_editpost_update_complete (http://www.forums.fvnorthwestern.com/forums/admincp/plugin.php?do=edit&pluginid=200)

Replaced Code with

if($foruminfo['enable_recipe']){
$recipe_description = addslashes($_POST['recipe_description']);
$recipe_difficulty = addslashes($_POST['recipe_difficult']);
$recipe_prep = addslashes($_POST['recipe_prep']);
$recipe_ingrediants = addslashes($_POST['recipe_ingrediants']);
$recipe_time = addslashes($_POST['recipe_time']);
$recipe_size = addslashes($_POST['recipe_size']);
$recipe_steps = addslashes($_POST['message']);
$db->query_write("UPDATE " . TABLE_PREFIX . "thread SET recipe_description = '$recipe_description', recipe_difficult = '$recipe_difficulty', recipe_prep = '$recipe_prep', recipe_ingrediants = '$recipe_ingrediants', recipe_time = '$recipe_time', recipe_size = '$recipe_size', recipe_steps = '$recipe_steps' WHERE threadid = '$threadinfo[threadid]'");
}


It now doesn't SQL Error out.. But haven't done much testing further.. Thanks for the hack, Mike -- love this. :D

[Christine]

Mike,

You also need to change "ingrediants" to "ingredients" in your .xml

Thanks again!

[ArchangelX]

Have you tried editing the posts? Did you have any problems with it editing the original post, but not the replies?

[Aimee1969]

Please complete both the subject and message fields.

I get this message when someone posts....can someone help me?

[Christine]

2-can you print recipe? If it's part of showthread it will not unless you add support code.

No and Not tested. Will think about these in future release though. I added this as an add-on mod for this product:

https://vborg.vbsupport.ru/showthread.php?t=145976

[Christine]

Have you tried editing the posts? Did you have any problems with it editing the original post, but not the replies?
I am not having any trouble editing anything since I overwrote the plugin.

[ArchangelX]

I'm not sure if I was clear, what I meant...is if someone posts a reply AFTER the recipe is created, and the goes back to try and edit that reply...they end up editing the recipe and not their response?

That's the problem I was having, and I did the same thing you did...so I was wondering what's different. Thanks.

[Christine]

I'm not sure if I was clear, what I meant...is if someone posts a reply AFTER the recipe is created, and the goes back to try and edit that reply...they end up editing the recipe and not their response?

That's the problem I was having, and I did the same thing you did...so I was wondering what's different. Thanks.Yep -- you are right. If you do s quick edit, it is fine, but if you go to advanced mode, it opens up the recipe for editing.

Let me see if I can fix this.

[ssvp]

Yep -- you are right. If you do s quick edit, it is fine, but if you go to advanced mode, it opens up the recipe for editing.

Let me see if I can fix this.

That would be supersweet!

[ArchangelX]

Yes, I agree! I'm not a coder...I'm just a plugger-inner! Heh. I'd appreciate it if anyone knowledgeable could try to figure it out...I gave it a shot, but I was kinda lost, to be honest, and gave up. :)

[Christine]

Here's a quick fix (and it is working).

In the editpost template:

FIND

<if condition="$foruminfo[enable_recipe]">


REPLACE WITH

<if condition="$post[postcount] == 1 && $thread[forumid] == x">

Where x is the forum id of your recipe forum.

[Christine]

Well, that didn't work -- now the recipe can't be edited to the thread table. At least it is secure now where other people can't edit it. I will take another look...

[ArchangelX]

Thanks for your hard work Christine...my users love this new feature...so I must thank you for looking into it.

[Christine]

I know I am rusty about coding in vB, but I can't for the life of me figure this out. For now, I overrode editing in that forum -- it is entry only for right now.

It seems the last time the hack author visited this thread was about 2 weeks ago. I will try to see if I can figure this out tomorrow with fresh eyes.

*sigh*

[Aimee1969]

Please complete both the subject and message fields.

I get this message when someone posts....can someone help me?

Can someone Please help me?? I get that message and they can't post???? Thank you {{hug}}

[Christine]

All,

Due to the security holes on this modification, I will be removing it as it requires a complete rewrite due to how the data is being stored in the tables. Mike posted to me on the VBHackers thread that he will get to it in a "week or so".

Best wishes,

[Paul M]

Moved to Graveyard until the author can address the security issues.

[Paul M]

Now restored.

[Michael Biddle]

Problem is now fixed. redownload new update

[ArchangelX]

Thanks Mike! Great work!

[ArchangelX]

Ahh...I guess the new Edit Post bug is still there, though, huh? :(

[Michael Biddle]

what bug?

[Michael Biddle]

Everything should be fixed. i fixed the edit post bug

[Fungsten]

Templates or can we just import the new XML? Thanks.

On Edit:

When I tried to import it and overwrite, etc., I had a DB error. What I did was to Uninstall the old XML then install the Updated XML and everything went fine!

[Michael Biddle]

Just reimport

[Fungsten]

Just reimport

I mentioned it in case anyone else is confused.

[Michael Biddle]

Yea the overwrite function doesn't work right. It should uninstall then reinstall with the new line but doesn't do it. So yes you must first uninstall, then reinstall the new one.

[ssvp]

Templates or can we just import the new XML? Thanks.

On Edit:

When I tried to import it and overwrite, etc., I had a DB error. What I did was to Uninstall the old XML then install the Updated XML and everything went fine!


Hrm I did that.. Then it wiped out all my receipe First Posts.. They are all N/A now..Blah..

[Michael Biddle]

Hrm I did that.. Then it wiped out all my receipe First Posts.. They are all N/A now..Blah..

We'll if you are upgrading. And doont wanna lose them. Then remove the install code. And it will work.

[ericgray]

this is scary -- i don't want to upgrade -- for fear of losing junk --

:|

[thepub]

ok it worked thanks! Is there not anything you can do about the extra thread that follows directly under the posted recipe? It just seems needless and would make the mod look cleaner if it were gone.

[ssvp]

We'll if you are upgrading. And doont wanna lose them. Then remove the install code. And it will work.

Well I did the uninstall and then reinstalled as earlier is was suggest the overwrite didn't work.. So open for suggestions now..

[ssvp]

We'll if you are upgrading. And doont wanna lose them. Then remove the install code. And it will work.

Even after the fact of what I posted?

[Michael Biddle]

Well if you don't uplad new one. Then you will still have the editpost bug.

No. Won't work after the fact.

And read post. It shows how to remove the dupe post

[ArchangelX]

Alright...ignore my whining up there...as I figured out how to fix it. But something is still wrong. I re-added all the tables that were missing by manual SQL Query...then I uninstalled the product. That fixed the uninstall problem.

I then re-installed with the updated product...

Then, I went and did a post test...and then posted two responses with the NEW product that was uploaded today. I still get the Edit Post bug in which you're able to edit the original post.

Am I doing something wrong? Or is this still not fixed? Thanks! The edit post bug is still there, and this is still broken. Unless the Product wasn't updated and I'm using the old one still? I appreciate your hard work on this Mike...really I do...it's just been frustrating trying to get it to work. Thanks.

[Michael Biddle]

Alright...ignore my whining up there...as I figured out how to fix it. But something is still wrong. I re-added all the tables that were missing by manual SQL Query...then I uninstalled the product. That fixed the uninstall problem.

I then re-installed with the updated product...

Then, I went and did a post test...and then posted two responses with the NEW product that was uploaded today. I still get the Edit Post bug in which you're able to edit the original post.

Am I doing something wrong? Or is this still not fixed? Thanks!

Well this has not been tested in 3.6.3 but it *should* work. As for this edit post error, I have fixed this, it sorta seems as if your not uploading the new one. Try uninstalling and re installing. Also others let me know if anyone else can reproduce this.

[ArchangelX]

Well...holy crap. I'm an idiot. No wonder. I followed this link from another post in the 3.5 section...I had no idea that it was for 3.6...I'm still back on 3.5.4.

Crap. This is probably my fault then.

Well...I guess it sorta does work for 3.5, then...you could say. Dangit all.

Hmm...well, maybe that's the problem then...I'm using 3.5.3...does that give you a bell to ring? Gar...I'm sorry. :(

[Michael Biddle]

I have not tested it for anything other then 3.6.x and only support 3.6.x. Sorry, I wouldnt know about 3.5 as I was in hospital through most of it.

[Fungsten]

as N/A.

[thepub]

And read post. It shows how to remove the dupe post


I just went back and re-read the thread and do not see where it says.

[Michael Biddle]

Postbit(_legacy):

Add at Top:

MAKE SURE TO CHANGE TOP LINE OF THIS WHERE X = FORUMID YOU CHOOSE

[Michael Biddle]

as N/A.

Well, did you uninstall and reinstall?

If so then it will show this as it deleted all of the other data

[thepub]

Postbit(_legacy):

Add at Top:

MAKE SURE TO CHANGE TOP LINE OF THIS WHERE X = FORUMID YOU CHOOSE

I went back and looked and have the code correct. There is still a post that comes directly under the initial recipe post.

[Michael Biddle]

and u changed the top line of the modification? like x=3, also if so, then do you have multiple forums or just this one for recipes?

[thepub]

only one forum that I use this mod in and I changed X to "59" (the forumID)

[Michael Biddle]

OK well are you using postbit or postbit_legacy?

Make sure the first line reads this:

<if condition="$post[postcount] == 1 && $thread[forumid] == 59">

[thepub]

I have the same code you posted. I used postbit_legacy, here is an attachment of a screenshot.

[Michael Biddle]

Wierd. Setup an admin account for me and I will look into it.

[thepub]

I'll pm you the info...

[thepub]

did you look into it?

[nymyth]

cant get my [img tags to work inside of it....any ideas why?

Peace

[Michael Biddle]

did you look into it?

Fixed, you had

<else />
</if>

The if was supposed to be at very bottom of postbit

[Michael Biddle]

cant get my [img tags to work inside of it....any ideas why?

Peace

What section you want the bbcode in?

[xLYNZx]

ive uploaded the .xml file, followed the instructions, and nothing..dont know what i have done!

[nymyth]

inside of instructions......

Thanks.

[Fungsten]

At the bottom of the forum settings you'll see whether or not to use the Recipe feature in that forum.

ive uploaded the .xml file, followed the instructions, and nothing..dont know what i have done!

[woostar]

Thanks for the update. Sorry for giving you a hard time before whitemike but they were pretty big holes to be leaving in a mod.

Just thought I'd let you know (although you've probably noticed) the problem when you preview the recipe before posting.

Anyway, thanks for your hard work.

W.>

[Fungsten]

Well, did you uninstall and reinstall?

If so then it will show this as it deleted all of the other data

That's all I did.

[Michael Biddle]

That's all I did.

Then it removed all data. Sorry

[nymyth]

any luck with adding [img tags into the instructions box

Peace

[xLYNZx]

At the bottom of the forum settings you'll see whether or not to use the Recipe feature in that forum.

ah thanks..durr me!!:rolleyes:

[adrianne]

Maybe add a nutritional content category??

[Fungsten]

is spelt wrong. When you are posting a new thread it currently reads:

Ingrediants to be used:

:D

[talenak]

There are several spelling errors, including "recipies" in postbit. It should be spelled recipes.

Is there any chance of getting those corrected? I can't read code and I don't know how to edit the xml or if I even have to to fix them.

[Michael Biddle]

I thought I already updated this.

SOrry, redownload, let me know if i mistyped anything else

[talenak]

Yay, it looks all right now. It's entirely possible you had updated it after I downloaded it. I dawdled getting mods installed while I reorganized the forum.

[Aimee1969]

When we go to post a recipe we get this:
Please complete both the subject and message fields.

What is wrong? Please help...

[niteslave]

Ive followed your instructions and double checked them but alas this still doesnt work for me. Any suggestions?

[talenak]

Can this be used with multiple boards? My members LOVE the mod, but they want their recipes organized. When I tried to add more forumid numbers with commas between though, I got a code error.

Let me just clarify I'm talking about the postbit. I reread and realized how poorly worded this was for my question.

The postbit legacy shows how many recipies have been posted. I want it to count posts in all the forums being used for recipes.

Obviously I can and have enabled this mod for all the recipe forums.

[Michael Biddle]

Sorry reread instuctions i just updated it. Just where X was in the postbit make it

array(x,x,x,x,x)

where x being all of the forumid's. View my demo, it shows it is possiable

[Michael Biddle]

Ok product updated. :D

[talenak]

You're awesome! Thanks,

I tried to rate the mod excellent and it my mouse went crazy and picked terrible!! I feel so guilty and it won't let me rerate it! *blush* I nominated for mod of the month though.

[Shelly]

awesome mod, we have a ton of recipes submitted by all users, is there any way to add a rating system to them similar to this boards?

[Michael Biddle]

You're awesome! Thanks,

I tried to rate the mod excellent and it my mouse went crazy and picked terrible!! I feel so guilty and it won't let me rerate it! *blush* I nominated for mod of the month though.

Its cool, im not that worried about it. I dont code freely to get praise, i do it for you guys. Glad ya liked it

awesome mod, we have a ton of recipes submitted by all users, is there any way to add a rating system to them similar to this boards?

This is not enabled yet, but I am sure we could think of something in the future. Thanks for installing.

[chatzworld]

can this mod be used on one forum or dose it have to be uased on the whole board?

[Fungsten]

Go into the "Moderators and Forums" - Click on each forum - At the bottom you can choose whether or not to activate it.

can this mod be used on one forum or dose it have to be uased on the whole board?

[chatzworld]

When a new recipie is added, the instructions apear as a 1st post on the forum any ideas how i can fix this

[Panagioths]

When i updated last time, I had to unistall the product and install it again, having the result to lose all my receipes. To update this time, do I have to unistall the product again?

[Fungsten]

When i updated last time, I had to unistall the product and install it again, having the result to lose all my receipes. To update this time, do I have to unistall the product again?

I didn't lose any of the recipes either. Not this time anyways!

[Panagioths]

Did you upgrade or reinstall?

[Michael Biddle]

Did you upgrade or reinstall?


Go to edit the current product, then remove the uninstall code. then on the new file, remove the install code and it will keep ur data

[Fungsten]

Did you upgrade or reinstall?

I think the reinstall is what erases everything.

[Panagioths]

Go to edit the current product, then remove the uninstall code. then on the new file, remove the install code and it will keep ur data
After I remove the unistall code, I will unistall the 1.3 version and then I will install the 1.4 with the install code removed?
If I just upgrade, will I have problems?

[Michael Biddle]

Well now that i think about it, you could remove the install and uninstall code from the new download, then just overwrite and it shall work

[Panagioths]

Worked just fine. Thnx a lot:D

[chatzworld]

hi how can i fix the problem i am getting with the instrucions apearing as the first post under the recipie?

[Michael Biddle]

Re-read the instructions for the postbit or postbit_legacy. You need to change the X in the top line to ur forum id

[chatzworld]

their is 2 x's

<if condition="$post[postcount] == 1 && $thread[forumid] == array(X,X)">

Which part do i change?

[Michael Biddle]

Well the 2 x's are for multiple forums being used. If its just 1 forum make it

<if condition="$post[postcount] == 1 && $thread[forumid] == array(X)">

[chatzworld]

still shows instructions as a first post

[Michael Biddle]

Did u add the else and end if?

Make me an admin account pm it to me, ill fix for ya

[chatzworld]

ok will do now

[chatzworld]

pm sent

[Michael Biddle]

Done, remove account

[chatzworld]

thanks, so i know what was done?

[Michael Biddle]

well since u were only using forum the array was pointless, so remove the array and just make it forumid

now that i think of it, i only did on orange skin.

[chatzworld]

its ok i will change the other :)

[Aimee1969]

When we go to post a recipe we get this:
Please complete both the subject and message fields.

What is wrong? Please help...

Can someone help me with my problem? Please...

[Michael Biddle]

Well you are using an outdated version, and what version of vb are u on?

[mtalks]

Well you are using an outdated version, and what version of vb are u on?

Originally Posted by Aimee1969
When we go to post a recipe we get this:
Please complete both the subject and message fields.

They are running VB 3.67 PL1 and I installed 1.4 on a test forum with no problems. It did have version 1.3 on old site and I unistalled it and redid the edits. < -- it was not working before I got involved with it.

The error it gives is : When we go to post a recipe we get this:
Please complete both the subject and message fields

Any suggestions would be greatly appreciated

[Michael Biddle]

I have seen this error once before, and never could get it again. make sure the directions are over your minimum post count.

[mtalks]

I have seen this error once before, and never could get it again. make sure the directions are over your minimum post count.

Dont quite understand that. I have admin access and if the "Would you like to enable the recipe system in this forum?" is turned to no the forum allows me to post the message fine. Turn it on to yes and we get the error.

I will if necessary try and undo all previous edits to clear the them from any possible errors made prior to me looking at it. I may just restore the templates to their original state and work from there as well (clean template from a default install).

Thanks

[Michael Biddle]

I am saying that I have never been able to reproduce this error, but yes, I have seen it on one board, but I have no clue why it works with the majority, but not the rest

[macahs]

I tried going through most of this thread but gave up and hoped for a quick reason why this is happening to me... tia! :)

I loaded everything and enabled. I hit New Post and everything comes up like it should. I fill in every field and when I hit sumbit - this is the error I am getting. Any ideas what to do?

Error:

Please complete both the subject and message fields.

[macahs]

Edit - should have looked at the last page of posts - sorry.

I guess I am getting the same error. I am running 3.6.4 I believe it is.

[Michael Biddle]

Well that is a differnt error, are you entering data in each box?

[macahs]

Yes- in each box.

Thanks for the quick reply!

[Michael Biddle]

Can I get your url?

[macahs]

Sorry - I didn't see your reply. It's www.janieandjackplace.com (http://www.janieandjackplace.com). :)

[Michael Biddle]

Sorry - I didn't see your reply. It's www.janieandjackplace.com (http://www.janieandjackplace.com). :)

Well I made a user, but never got an email to confirm it, please pass mine through

[macahs]

Not sure why it's doing that but I just set you as registered. Thanks!

[Michael Biddle]

Not sure why it's doing that but I just set you as registered. Thanks!


Well just by looking at it I can tell that you have the if wrong in a template, because I am not seeing the title textbox. Set me up as an admin or recheck your template edits on newthread

[macahs]

Sorry - it has been unbelievably hectic today but I did just set you up as an admin. Thank you for trying to help me! :)

[Michael Biddle]

Sorry - it has been unbelievably hectic today but I did just set you up as an admin. Thank you for trying to help me! :)

Hey today is actually my birthday so I am not going to be on, but I will get to it in the next few days

[Aimee1969]

Well that is a differnt error, are you entering data in each box?

It is the same error I am getting that mtalks1 has told you about. Can you help me?? Please :D

[Aimee1969]

Can someone help me with my problem? Please...

Please someone help me....this is my third or fourth asking Thank you.

[Aimee1969]

When we go to post a recipe we get this:
Please complete both the subject and message fields.

What is wrong? Please help...

Here is my first asking......:(

[TheBlackPoet]

i like this for my site.... adding a pic would be nice.... but i still like it and it is installed... i have to make some adjustments or go back over where i placed the code.. the table on my narrow theme is broken.. but the fluid one works fine....
i will follow up tomorrow..!

follow-up... works great on the narrow themes..... it was something i had done that broke the tables... good job man!!!

[macahs]

Happy Birthday! :)

Hey today is actually my birthday so I am not going to be on, but I will get to it in the next few days

[mtalks]

Hey today is actually my birthday so I am not going to be on, but I will get to it in the next few days

Hope ya had a happy birthday!

I checked the site and two out of three skins work. I even backed up the templates and then copied the working skins template edits over the non working skins templates and same result. ( I also did a side by side comparison and found no differences in the templates)

Error displayed:

Please complete both the subject and message fields
Any help will be greatly appreciated Mike, I attached the templates from the skin that is not working.

[Michael Biddle]

Sorry - it has been unbelievably hectic today but I did just set you up as an admin. Thank you for trying to help me! :)

I dont have any admincp access

[macahs]

Now are you?

[Michael Biddle]

Now are you?

You have not given me any administrator permissions, I can get into the ACP, but thats it, no settings