Major Additions - Recipe Mod Database

Recipe Mod
By: whitemike
Demo: Here
Official Requests: Here

NOTE: Support will be provided here, but I will get to it sooner on my official site. vBulletin Zone

Installation:

1. Templates to add:3
2. Templates to edit:3
3. Plugins Added: 14
4. Phrases Added: 12
5. Quires ran: 9

Instructions:

1. Import the Product .xml
2. Edit templates

Editpost:

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

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

1.5

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

1.4

1. Added Template Grouping
2. Cached Templates
3. Other small minor changes

1.3

1. Fixed Spelling - Duh

1.2

1. Fixed Major Edit Post Bug - Thanks to Nick for opening my eyes

1.1

1. Fixed Edit Post Bug
2. Fixed Spelling Error

Thats it!

Configure

1. Go to ACP -> Forums & Moderators -> Forum Manager -> Pick a forum and at bottom it has a new yesno setting
2. Go to ACP -> vBulletin Options -> Recipe Mod Database -> Enter the forumid's used for your forum

Please Click Install if you use

[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]

Originally Posted by whitemike

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/ad...=productimport
Referrer : http://www.theneighborhoodpub.com/ad...?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/ed...tepost&p=81571
Referrer : http://www.theneighborhoodpub.com/ed...itpost&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