Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 Programming Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 11-25-2009, 01:28 PM
pentium pentium is offline
 
Join Date: Mar 2002
Posts: 26
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default MySQL query please

Hi all!
i need to attach a paragraph above the text already is in pagetext (table "post"):
e.g. :
text to add: "some text to add"
pagetext: "some text already in pagetext"
result in pagetext: "some text to add some text already in pagetext"
I already created a table "addings" with 3 fields (postid, threadid, addtext).
Could someone show to me wich query I need to execute pls?
Thanks.
Reply With Quote
  #2  
Old 11-25-2009, 01:41 PM
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Location: California/Idaho
Posts: 41,180
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Do you need to actually change what is in the database (which means the user can edit it) or can you just put the text in the postbit template?
Reply With Quote
  #3  
Old 11-25-2009, 01:49 PM
pentium pentium is offline
 
Join Date: Mar 2002
Posts: 26
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I need to change what is in the database
Reply With Quote
  #4  
Old 11-26-2009, 11:09 PM
pentium pentium is offline
 
Join Date: Mar 2002
Posts: 26
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

noone can help?
Reply With Quote
  #5  
Old 11-27-2009, 12:02 PM
kh99 kh99 is offline
 
Join Date: Aug 2009
Location: Maine
Posts: 13,185
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

So just to make sure I understand, do you want a query so that the database starts out as:

Code:
table 'posts':
1, 2, "This is a post"
2, 5, "This is another post"
3, 3, "This is a third post"

table 'addings':
1, 2, "Add text-"
3, 3, "More added text-"
then you run the query once and the database is

Code:
table 'posts':
1, 2, "Add text-This is a post"
2, 5, "This is another post"
3, 3, "More added text-This is a third post"

table 'addings':
1, 2, "Add text-"
3, 3, "More added text-"
?
Reply With Quote
  #6  
Old 11-27-2009, 12:24 PM
pentium pentium is offline
 
Join Date: Mar 2002
Posts: 26
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Yes kh99 that's exactly what I whant to do
could you help?
Thanks
Reply With Quote
  #7  
Old 11-27-2009, 12:43 PM
kh99 kh99 is offline
 
Join Date: Aug 2009
Location: Maine
Posts: 13,185
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Well, I'm not a SQL expert (just learning actually), but I ran a little test and this seems to work (use at your own risk!):

Code:
UPDATE vb_post AS post 
  LEFT JOIN vb_addings as addings 
  ON (post.postid=addings.postid AND post.threadid=addings.threadid) 
  SET post.pagetext=CONCAT(addings.addtext,  post.pagetext)   
  WHERE addings.addtext IS NOT NULL

Notes:
1. This seems very dangerous! Are you sure you want to try this? Back up your database first.
2. The 'vb_' in red should be changed to be your own prefix.
3. Did you add a prefix to your 'addings' table? Change or remove the 'vb_' in blue accordingly
4. I test both postid and thread id, although I believe postid is unique
5. If you want to put something between the addtext and pagetext, you can add it to the CONCAT function (in green), such as CONCAT(addings.addtext, ' ', post.pagetext) to add a space.
6. Are you sure? Maybe run a test with an addings table that has only one or two rows.
Reply With Quote
  #8  
Old 11-27-2009, 02:26 PM
pentium pentium is offline
 
Join Date: Mar 2002
Posts: 26
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Really a great Thank you kh99
Yessss it worked very fine, 409 lines sucessfully updated!
Thanks again for yor time, you are a very kind person.
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 09:26 AM.


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.06051 seconds
  • Memory Usage 2,223KB
  • Queries Executed 13 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (3)bbcode_code
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (8)post_thanks_box
  • (8)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (8)post_thanks_postbit_info
  • (8)postbit
  • (8)postbit_onlinestatus
  • (8)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete