![]() |
|
|
Thread Tools |
|
#1
|
||||
|
||||
|
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? No members have liked this post.
|
|
#2
|
||||
|
||||
|
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.
__________________
Steve Machol, vBulletin Moderator Please do not email or PM me for vBulletin support. I will try to answer all questions on the vB Forums. Thank you for respecting this request! No members have liked this post.
|
|
#3
|
||||
|
||||
|
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. No members have liked this post.
|
|
#4
|
||||
|
||||
|
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.
http://www.vbulletin.org/forum/showt...911#post243911
__________________
Steve Machol, vBulletin Moderator Please do not email or PM me for vBulletin support. I will try to answer all questions on the vB Forums. Thank you for respecting this request! No members have liked this post.
|
|
#5
|
||||
|
||||
|
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.
No members have liked this post.
|
|
#6
|
||||
|
||||
|
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.
__________________
Steve Machol, vBulletin Moderator Please do not email or PM me for vBulletin support. I will try to answer all questions on the vB Forums. Thank you for respecting this request! No members have liked this post.
|
|
#7
|
||||
|
||||
|
Just to answer your question, it's LEFT().
__________________
Chen Avinadav Formerly vBulletin.org Owner and Founder chen@avinadav.com No members have liked this post.
|
|
#8
|
||||
|
||||
|
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?
No members have liked this post.
Last edited by Orlandu : 24 Apr 2002 at 21:36. |
|
#9
|
||||
|
||||
|
I believe this is exactly how the PluhNews hack works.
__________________
Steve Machol, vBulletin Moderator Please do not email or PM me for vBulletin support. I will try to answer all questions on the vB Forums. Thank you for respecting this request! No members have liked this post.
|
|
#10
|
||||
|
||||
|
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
![]() No members have liked this post.
|
|
#11
|
||||
|
||||
|
The MySQL docs are your friend.
It's either LEFT(fieldName, length) or the other way around, just experiment.
__________________
Chen Avinadav Formerly vBulletin.org Owner and Founder chen@avinadav.com No members have liked this post.
|
|
#12
|
||||
|
||||
|
Thank you so much. I will look for it, but atleast I have a general idea now. You can lose this if you want cause I got what I needed. Also, this my help in a hack I want to create aswell.
No members have liked this post.
|
![]() |
«
Previous Thread
|
Next Thread
»
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| IRC /me command | El_Muerte | vBulletin 3.5 Add-ons | 3 | 05 Feb 2010 20:00 |
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) |
| Thread Tools | |
|
|
| New To Site? | Need Help? |
All times are GMT. The time now is 02:24.



It's either LEFT(fieldName, length) or the other way around, just experiment.
