vb.org Archive
Page 3 of 10 12 3 45 Last »
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.6 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=194)
-   -   Major Additions - Recipe Mod Database (https://vborg.vbsupport.ru/showthread.php?t=142871)

thepub 04-10-2007 01:08 PM
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 04-10-2007 01:31 PM
Quote:
Originally Posted by whitemike (Post 1223836)
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
Quote:
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 04-10-2007 01:44 PM
Do we just import the xml file to upgrade? After I upgraded the XML, I lost my recipes.

What did I do wrong?

Fungsten 04-10-2007 05:24 PM
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 04-10-2007 07:33 PM
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 04-10-2007 10:31 PM
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 04-10-2007 11:08 PM
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 04-10-2007 11:14 PM
Worked great. Thank You!

thepub 04-11-2007 10:08 PM
I got this message today when we tried to edit a post:
Quote:
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 04-11-2007 11:06 PM
Thank you for reporting, I am working on this now

nymyth 04-12-2007 03:03 PM
will it work for 3.6.2?

Peace

ssvp 04-12-2007 04:21 PM
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 04-12-2007 08:01 PM
Quote:
Originally Posted by nymyth (Post 1225968)
will it work for 3.6.2?

Peace
Yes

Quote:
Originally Posted by ssvp (Post 1226024)
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 04-13-2007 01:26 PM
im getting a sql error when trying to edit a recipe....


Quote:
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 04-13-2007 03:42 PM
i have installed, checked, and double checked --

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

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

ericgray 04-13-2007 04:15 PM
uninstalled -- :(

nymyth 04-13-2007 04:18 PM
^^yeah, you have to go forum permissions, edit the forum u designate, scroll down and ull see the enable option...

Peace

ericgray 04-13-2007 04:30 PM
works like a charm -- thank you!

nymyth 04-13-2007 05:11 PM
n/p....glad u got it working

Peace

ericgray 04-13-2007 05:14 PM
cool beans -- :D

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

ericgray 04-13-2007 05:31 PM
also, "preparation" is mis-spelled -- :|

ericgray 04-13-2007 06:59 PM
the edit function is a big one -- if you could fix that -- or else, people will gripe, lots -- :D

ericgray 04-13-2007 11:06 PM
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 04-13-2007 11:17 PM
Yes please follow the instructiosn in the postbit(_legacy)

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

ericgray 04-13-2007 11:19 PM
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 04-13-2007 11:21 PM
Hey Eric, are you using postbit or postbit_legacy? please edit the correct template their. Also what version of VB?

Michael Biddle

ericgray 04-13-2007 11:21 PM
how do you select multiple forums, if you have sub-forums?

ericgray 04-13-2007 11:22 PM
Quote:
Originally Posted by whitemike (Post 1227088)
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 04-13-2007 11:47 PM
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 04-14-2007 01:36 AM
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 04-14-2007 01:44 AM
Has anyone come up with a way to display in the user profile how many recipes they have contributed?

Michael Biddle 04-14-2007 02:52 AM
Quote:
Originally Posted by ericgray (Post 1227153)
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

Quote:
Originally Posted by jackstraw01 (Post 1227157)
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 04-14-2007 02:57 AM
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 04-14-2007 02:58 AM
Just make it:

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

ericgray 04-14-2007 03:02 AM
sorry for the long post --

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

ericgray 04-14-2007 03:03 AM
Quote:
Originally Posted by whitemike (Post 1227184)
Just make it:

Code:
<if condition="$post[postcount] == 1 && $thread[forumid] == 1,2,3,4,5>
it shits the bed and gives me errors -- :(

ssvp 04-15-2007 03:01 AM
Quote:
Originally Posted by nymyth (Post 1226700)
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 04-15-2007 03:09 AM
Well I got my editpost thing fixed..

Here's what I did..

Edited the Plugin

recipe_editpost_update_complete

Replaced Code with
Code:

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 04-15-2007 04:39 AM
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 04-16-2007 09:50 AM
So what should I add where to get the recipe counts in user profile?


All times are GMT. The time now is 11:49 AM.
Page 3 of 10 12 3 45 Last »
Show 40 post(s) from this thread on one page

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01651 seconds
  • Memory Usage 1,910KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (3)bbcode_code_printable
  • (11)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete