Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 Programming Discussions
Reload this Page command help
FAQ Members List Calendar Search Today's Posts Mark Forums Read

Reply
Page 1 of 2 1 2
 
Thread Tools Display Modes
  #1  
Old 04-24-2002, 12:37 AM
Orlandu's Avatar
Orlandu Orlandu is offline
 
Join Date: Apr 2002
Posts: 40
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default command help
I know there must be some sort of command that only selects a certain number of characters from a mySQL table. I see it in action on the search page for the forums. It only gets the first bit of the post, and then puts ...

How can I do this for something else?
Reply With Quote
  #2  
Old 04-24-2002, 03:31 AM
Steve Machol's Avatar
Steve Machol Steve Machol is offline
 
Join Date: Nov 2001
Posts: 1,896
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Orlandu, please go to this page and enter your username, to show you are licensed. (you will need to use your customer number and password to access that page)
Thank you.
Reply With Quote
  #3  
Old 04-24-2002, 05:55 AM
Orlandu's Avatar
Orlandu Orlandu is offline
 
Join Date: Apr 2002
Posts: 40
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
But I'm not liscensed yet. This is a PHP forum anyway, what does it have to do with registering? I plan on buying one, just haven't gotten the money yet.

This question doesn't really relate to vB anyway, just PHP. I only noticed that vB used it and it was a great example of what I wanted.
Reply With Quote
  #4  
Old 04-24-2002, 06:06 AM
Steve Machol's Avatar
Steve Machol Steve Machol is offline
 
Join Date: Nov 2001
Posts: 1,896
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
This is a PHP forum for vB owners. Plus I noted in another thread that you already admit to having an illegal copy of vB, albeit you say you're not running it on any sites just yet and you plan to buy it soon.

https://vborg.vbsupport.ru/showthrea...911#post243911
Reply With Quote
  #5  
Old 04-24-2002, 12:25 PM
Orlandu's Avatar
Orlandu Orlandu is offline
 
Join Date: Apr 2002
Posts: 40
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Well, atleast I didn't use it anywhere. I wanted to do the right thing, so I told everything straight forward. In a few weeks, I will have a legal vB license. I just wanted a little help with PHP. Sorry I even asked.
Reply With Quote
  #6  
Old 04-24-2002, 03:32 PM
Steve Machol's Avatar
Steve Machol Steve Machol is offline
 
Join Date: Nov 2001
Posts: 1,896
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Yep, and I commend you for your honesty. Of course once you purchase vB you'll report the site where you downloaded the illegal copy, right?

P.S. You might want to search for an answer in the MySQL forum at vbulletin.com. There are a lot more messages there and it's possible your question has come up before.
Reply With Quote
  #7  
Old 04-24-2002, 03:45 PM
Admin's Avatar
Admin Admin is offline
Coder
  
Join Date: Oct 2023
Location: Server
Posts: 1
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Just to answer your question, it's LEFT().
Reply With Quote
  #8  
Old 04-24-2002, 08:34 PM
Orlandu's Avatar
Orlandu Orlandu is offline
 
Join Date: Apr 2002
Posts: 40
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
So how would that work? Like say I want a news script. And in this script I want it to have only a portion of the news message displayed, and a full story link. How would i only select X amount of characters from the given table?
Reply With Quote
  #9  
Old 04-24-2002, 08:41 PM
Steve Machol's Avatar
Steve Machol Steve Machol is offline
 
Join Date: Nov 2001
Posts: 1,896
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
I believe this is exactly how the PluhNews hack works.
Reply With Quote
  #10  
Old 04-24-2002, 09:46 PM
Orlandu's Avatar
Orlandu Orlandu is offline
 
Join Date: Apr 2002
Posts: 40
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Sure there are plenty of news scripts out there, but I want to have my own. Mainly so it is totally custom to my site, and so I can say I wrote my own news script
Reply With Quote
Reply
Page 1 of 2 1 2

« Previous Thread | Next Thread »
Thread Tools
Display Modes
Linear Mode Linear Mode

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 08:28 AM.

Contact Us - Archive - Top

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.04386 seconds
  • Memory Usage 2,243KB
  • Queries Executed 11 (?)
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
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (10)post_thanks_box
  • (10)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (10)post_thanks_postbit_info
  • (10)postbit
  • (10)postbit_onlinestatus
  • (10)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_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
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete