Go Back   vb.org Archive > Search Forums
Reload this Page Search Results
FAQ Community Calendar Today's Posts Search

Page 1 of 20 1 2311 Last »
Showing results 1 to 25 of 500
Search took 0.01 seconds. Search: Posts Made By: Eikinskjaldi
Forum: vB3 Programming Discussions 11-06-2008, 11:20 PM
Replies: 4
Views: 729
Posted By Eikinskjaldi
update post set pagetext =...

update post set pagetext = replace(pagetext,'domain .com','domain.net')


You will need to rebuild your post cache to see the changes.

Both of these operations are very server intensive and...
Forum: vB3 Programming Discussions 11-03-2008, 08:26 PM
Replies: 2
Views: 680
Posted By Eikinskjaldi
vbadvance might do the first part, it can...

vbadvance might do the first part, it can summarize forums on the portal page

Your usercp shows messages and the like, not sure what more you need there.

You also win my vote for worst thread...
Forum: vB3 Programming Discussions 11-02-2008, 09:40 PM
Replies: 4
Views: 1,585
Posted By Eikinskjaldi
What field does hold the info per user you need? ...

What field does hold the info per user you need? i.e. what query would you run to get the latest picture(s) or what ever it is you want for just one user (e.g. you)
Forum: vB3 Programming Discussions 10-30-2008, 10:04 PM
Replies: 4
Views: 1,585
Posted By Eikinskjaldi
You can do this with a nested query ...

You can do this with a nested query


SELECT albumpicture.*, album.*, user.username, user.usergroupid,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
FROM " ....
Forum: vB3 Programming Discussions 10-28-2008, 04:21 AM
Replies: 1
Views: 933
Posted By Eikinskjaldi
select u.username, u.email, u.usertitle, f.field2...

select u.username, u.email, u.usertitle, f.field2
from user u
join userfield f
using (userid)
where f.field2='whatever location it is you are interested in'
and date(from_unixtime(joindate)) =...
Forum: Forum and Server Management 10-26-2008, 09:42 PM
Replies: 4
Views: 1,212
Posted By Eikinskjaldi
That wont help. The forumcache exists in the...

That wont help. The forumcache exists in the database. a server reboot will just load the old cached entries back into memory.
Forum: vB3 Programming Discussions 10-26-2008, 09:40 PM
Replies: 1
Views: 867
Posted By Eikinskjaldi
select u.userid, uf.field19 from user u join...

select u.userid, uf.field19
from user u
join userfield uf using (userid)
where find_in_set('15',u.membergroupids) > 0
and to_days(now()) - to_days(from_unixtime(u.lastactivity)) <= 30
Forum: Forum and Server Management 10-21-2008, 10:35 PM
Replies: 4
Views: 1,140
Posted By Eikinskjaldi
This kind of whiteout can occur if your http...

This kind of whiteout can occur if your http timeout is set too low.
Forum: Forum and Server Management 10-21-2008, 10:33 PM
Replies: 4
Views: 1,212
Posted By Eikinskjaldi
No it wont. However you can rebuild the...

No it wont. However you can rebuild the forumcache within code, so you could set up a cron job to do it.

Probably be a bit server intensive though.
Forum: Modification Requests/Questions (Unpaid) 10-21-2008, 10:30 PM
Replies: 5
Views: 1,358
Posted By Eikinskjaldi
Like this? ...

Like this?

http://www.myth-weavers.com/sheets/?

You need to register to see the full functionality, but other versions of the 3eprofiler code are out there.

We are the only site I am aware...
Forum: vB3 Programming Discussions 10-20-2008, 02:10 AM
Replies: 4
Views: 779
Posted By Eikinskjaldi
If you are looking for specific words then regex...

If you are looking for specific words then regex is not necessary. You only need it when looking for patterns (like words containing "abc")

For exact string matches you should use the php exact...
Forum: vB3 General Discussions 10-06-2008, 11:58 PM
Replies: 8
Views: 1,178
Posted By Eikinskjaldi
You can drop a vb script (with access to the...

You can drop a vb script (with access to the mysql classes) into includes/cron and set it up as a cron in the admincp.

Alternatively, you can use a scripting language with mysql support and set it...
Forum: Forum and Server Management 10-06-2008, 11:56 PM
Replies: 27
Views: 3,607
Posted By Eikinskjaldi
That error on page means there is a javascript...

That error on page means there is a javascript error. It might be a "real" error, or it might be that the browser you are using does not support some nifty javascript function. It also quite...
Forum: Forum and Server Management 10-06-2008, 11:50 PM
Replies: 9
Views: 2,244
Posted By Eikinskjaldi
There is more than one way to skin this cat. ...

There is more than one way to skin this cat.

http://www.ducea.com/2008/02/14/increase-php-memory-limit/
Forum: News and Announcements 09-26-2008, 02:25 AM
Replies: 114
Views: 24,490
Posted By Eikinskjaldi
I really think some of the larger feature sets...

I really think some of the larger feature sets like social groups, albums, and things like that should be opt-out. Additionally, there are a lot of things just added to the datastore that, under...
Forum: vB3 Programming Discussions 09-15-2008, 11:25 PM
Replies: 4
Views: 938
Posted By Eikinskjaldi
The actual error is the "user not in ()"

The actual error is the "user not in ()"
Forum: Forum and Server Management 09-11-2008, 10:34 PM
Replies: 9
Views: 1,717
Posted By Eikinskjaldi
No, that's the job of the large hadron collider. ...

No, that's the job of the large hadron collider.

A crashed table usually means your DB went through some kind of crisis.
Forum: vB3 Programming Discussions 09-11-2008, 10:29 PM
Replies: 2
Views: 612
Posted By Eikinskjaldi
If both boards are on the same mysql server then...

If both boards are on the same mysql server then all you have to do is prefix tables with the database name

e.g.

Select blah from database1.table1
join database2.table1
on...
Forum: vB3 General Discussions 09-09-2008, 11:28 PM
Replies: 19
HEy
Views: 1,633
Posted By Eikinskjaldi
What is the address for you rsite What is the...

What is the address for you rsite
What is the error message you recieve
Does it work in other browsers
Is it only PCs that have the problem
Have you considered a better thread title might result...
Forum: vB3 General Discussions 09-09-2008, 12:17 AM
Replies: 9
Views: 1,812
Posted By Eikinskjaldi
Could I ask what the board is? I have trouble...

Could I ask what the board is? I have trouble getting my head around 100 forums with so few posts that you want email notification for each one.

Perhaps less forums, more threads?
Forum: vB3 General Discussions 09-07-2008, 10:57 PM
Replies: 5
Views: 894
Posted By Eikinskjaldi
Don't bother with regex, just trim the field and...

Don't bother with regex, just trim the field and see if the result is an empty string

$field = trim($field)
if ($field != '') ...
Forum: vB3 Programming Discussions 09-04-2008, 04:32 AM
Replies: 2
Views: 716
Posted By Eikinskjaldi
Your question is not making alot of sense. ...

Your question is not making alot of sense.

What do you mean "repeat various amounts of time"? is the ratieid supposed to be the same in each case, so effectively an identical entry 158 times? If...
Forum: vB3 Programming Discussions 09-03-2008, 11:01 PM
Replies: 1
Views: 701
Posted By Eikinskjaldi
Probably easiest to run a script over the...

Probably easiest to run a script over the database which capitalises the first name. The default collation that vb uses is not case sensitive, so it wont affect the code. You (or someone you...
Forum: vB3 General Discussions 09-03-2008, 02:48 AM
Replies: 2
Views: 752
Posted By Eikinskjaldi
What do you mean by OK? It's not going to...

What do you mean by OK?

It's not going to hurt your board, except that searching will be turned off, and you can doit from the admincp ->vbulletin options->message searching options
Forum: vB3 General Discussions 09-03-2008, 02:42 AM
Replies: 4
Views: 859
Posted By Eikinskjaldi
No, it requires code...and quite a bit of it. ...

No, it requires code...and quite a bit of it.

Might I ask what makes you think this is easy? or even stupid?

Perhaps in future the title of your posts can reflect the content of your post
Showing results 1 to 25 of 500
Page 1 of 20 1 2311 Last »

 
Forum Jump

All times are GMT. The time now is 02:19 AM.

Contact Us - Archive - Top

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.02345 seconds
  • Memory Usage 2,072KB
  • 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
  • (1)footer
  • (1)forumjump
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (2)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)search_results
  • (25)search_results_postbit
  • (1)spacer_close
  • (1)spacer_open
  • (8)threadbit_pagelink 
Phrase Groups Available:
  • global
  • inlinemod
  • prefix
  • search
Included Files:
  • ./search.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_search.php
  • ./includes/functions_databuild.php
  • ./includes/functions_forumlist.php
  • ./includes/functions_misc.php
  • ./includes/functions_forumdisplay.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • search_before_process
  • search_start
  • search_results_start
  • search_results_query_posts
  • search_results_prebits
  • threadbit_process
  • search_results_postbit
  • pagenav_page
  • pagenav_complete
  • forumjump
  • search_complete
  • navbits
  • navbits_complete