Register Members List Search Today's Posts Mark Forums Read

Showing results 1 to 25 of 27
Search took 0.01 seconds.
Search: Posts Made By: sparky2
Forum: vB3 General Discussions 18 Mar 2003, 03:58
Replies: 8
Views: 767
Posted By sparky2
then conserve database space by just storing a...

then conserve database space by just storing a hyperlink in the field
(a link to an external rules page) :rambo:
Forum: vBulletin 2.x Full Releases 18 Mar 2003, 03:56
Replies: 18
Views: 3,028
Posted By sparky2
this is quite similar to Velocd's "custom page...

this is quite similar to Velocd's "custom page hack":
http://www.vbulletin.org/forum/showthread.php?s=&threadid=41616
Forum: vB3 Programming Discussions 17 Mar 2003, 15:19
Replies: 4
Views: 844
Posted By sparky2
Thanks for the fulltext suggestion. Before...

Thanks for the fulltext suggestion.
Before starting this thread, I had considered (and dismissed) using the LOW PRIORITY directive & had tried using the DELAYED directive -- it had no apparent effect.
Forum: vB3 Programming Discussions 15 Mar 2003, 22:09
Replies: 1
Views: 886
Posted By sparky2
You want to export data from ALL the rows in a db...

You want to export data from ALL the rows in a db table into ONE file, right? If that's the case, and you are comfortable executing queries from the MySQL commandline (or you have mysqladmin...
Forum: vBulletin 2.x Full Releases 15 Mar 2003, 15:50
Replies: 124
Views: 22,866
Posted By sparky2
Thanks for releasing this hack. It's opens a...

Thanks for releasing this hack. It's opens a fresh can o' worms, though.

---------------------------
Use of password-protected subforums will probably cause resentment among the excluded members,...
Forum: vB3 Programming Discussions 13 Mar 2003, 01:09
Replies: 4
Views: 844
Posted By sparky2
MySQL INSERT DELAYED directive

Anyone care to offer an opinion as to whether using the DELAYED directive within the search.php INSERT queries might be beneficial toward easing/leveling the search-induced spikes in server...
Forum: Modification Requests/Questions (Unpaid) 10 Mar 2003, 13:52
Replies: 2
Views: 723
Posted By sparky2
Thanks, Xenon.

Thanks, Xenon.
Forum: vBulletin 2.x Full Releases 10 Mar 2003, 11:17
Replies: 67
Views: 8,473
Posted By sparky2
No. The user.userid field is the primary key for...

No.
The user.userid field is the primary key for the user table.
Mysql autoincrements & assigns the field value as each row is created.
Anyhow, if you could change it, and did... all the posts, PMs,...
Forum: vB3 Programming Discussions 07 Mar 2003, 22:32
Replies: 2
Views: 747
Posted By sparky2
"just save the URL for the results page" is not a...

"just save the URL for the results page" is not a viable idea.
Here's why:

1)
Each time search.php runs, one of its subroutines
deletes any search (row in the search table) that has
a dateline older...
Forum: Modification Requests/Questions (Unpaid) 07 Mar 2003, 21:05
Replies: 2
Views: 723
Posted By sparky2
remove identical (imported twice, a long time ago?) threads

A while back, when we imported from UBB, someone apparently imported some of the subforums more than once.

Now, in these subforums there are identical pairs (and triplets) of threads, with identical...
Forum: Modification Requests/Questions (Unpaid) 07 Mar 2003, 20:49
Replies: 4
Views: 650
Posted By sparky2
there's at least one hack already available to do...

there's at least one hack already available to do this
http://www.vbulletin.org/forum/showthread.php?s=&threadid=37775

if you search (titles only): bookmar* OR favorit*
you'll also find quite a few...
Forum: vB3 General Discussions 05 Mar 2003, 21:44
Replies: 15
Views: 1,252
Posted By sparky2
Atop this thread you asked "How do you like...

Atop this thread you asked "How do you like it?"
The interface is beautiful, but the "reason" field is way too small to be practical. Needs to be datatype mediumtext, with a textarea form field in...
Forum: vBulletin 2.x Full Releases 26 Feb 2003, 02:26
Replies: 108
Views: 14,831
Posted By sparky2
Can a "question" have multiple answers? In other...

Can a "question" have multiple answers?

In other words, if you enter a question twice, with a different answer each time, are there 2 possible answers (chosen later at random) or will the second of...
Forum: vB3 General Discussions 19 Feb 2003, 21:10
Replies: 2
Views: 732
Posted By sparky2
I'm responding to "how it could possibly be done"...

I'm responding to "how it could possibly be done" b/c I'll probably end up doing this for our forums (one subforum alone has 986,000+ posts). I too had searched & haven't seen previous discussion on...
Forum: vB3 General Discussions 30 Dec 2002, 19:30
Replies: 6
Views: 1,074
Posted By sparky2
That will have you chasing your tail ~~ in...

That will have you chasing your tail ~~ in circles.
block "boobies"
and the miscreants will come back with "bewbies"...

...block THAT, and they'll use some other variation, ad nauseum
(bewbs,...
Forum: vB3 General Discussions 27 Dec 2002, 12:23
Replies: 6
Views: 1,074
Posted By sparky2
where are you using the list of words? In...

where are you using the list of words?

In badwords.php ?
As a list of "censored" words ?
Forum: vBulletin 2.x Full Releases 27 Dec 2002, 12:18
Replies: 132
Views: 13,773
Posted By sparky2
Huh??? run this query: show create table...

Huh???

run this query:
show create table word

and you'll see that both (of the 2) columns are indexed
Forum: vBulletin 2.x Full Releases 24 Dec 2002, 04:41
Replies: 132
Views: 13,773
Posted By sparky2
Slick hack, but I'd prefer a LINK ~~ rather than...

Slick hack, but I'd prefer a LINK ~~ rather than assuming each user wants to "view similar threads" every showthread.php page view.

Also, it seems like this hack is a LOT of work just to duplicate...
Forum: vB3 General Discussions 13 Dec 2002, 04:00
Replies: 1
Views: 645
Posted By sparky2
Is the unindexpost() function unnecessarily complicated, or am I missing something?

an observation based on v2.2.9 code:

Although 3 arguments are passed to the function
(the post id, the post title, and post.pagetext)
only ONE ~~ postid ~~ is needed.

Further:
the preg_replace...
Forum: vB3 Programming Discussions 04 Dec 2002, 21:30
Replies: 5
Views: 764
Posted By sparky2
new orphan-finding capability

The following is PARTIALLY
code excerpted from v2.2.9 admin/misc.php
and
PARTIALLY code I added (remove EMPTY thread routine)
based on a suggestion offered by "Sadler"
which has apparently been...
Forum: vB3 General Discussions 17 Oct 2002, 19:53
Replies: 13
Views: 899
Posted By sparky2
Aren't there multiple versions of th "Thread...

Aren't there multiple versions of th "Thread Preview Hack" floating around? I seem to recall that the older hack adds an extra query...




floridaideal:
check how many subscribedTo threads (and...
Forum: News and Announcements 26 Sep 2002, 18:52
Replies: 203
Views: 10,076
Posted By sparky2
I would appreciate it if we could adopt a...

I would appreciate it if we could adopt a convention where hacks are ALWAYS made available as straight code...

...and the "hand-holding installer version" would be the "optional" version.
Forum: vBulletin.org Site Feedback 23 Sep 2002, 19:36
Replies: 5
Views: 946
Posted By sparky2
(sigh) (*yes, I'm replying to myself.) Dropping...

(sigh)
(*yes, I'm replying to myself.)

Dropping this function, and opting to include a user-defined "badwords" array
probably seemed (to the developers, at the time) as a necessary
step in allowing...
Forum: vBulletin.org Site Feedback 23 Sep 2002, 19:10
Replies: 5
Views: 946
Posted By sparky2
there is a wordsonly() function in...

there is a wordsonly() function in ~admin/functions.php
which looks like it's designed to do EXACTLY what I'm suggesting/describing. However, I can't find any place in any of the vBulletin code that...
Forum: vBulletin.org Site Feedback 23 Sep 2002, 14:35
Replies: 5
Views: 946
Posted By sparky2
Logician, your point about other chars / other...

Logician, your point about other chars / other languages is well-taken.

If you page through the contents of your WORD table though, using queries like this:

SELECT title FROM word where wordid>1000...
Showing results 1 to 25 of 27

 
Forum Jump

New To Site? Need Help?

All times are GMT. The time now is 09:50.

Layout Options | Width: Wide Color: