Register Members List Search Today's Posts Mark Forums Read

Showing results 1 to 25 of 150
Search took 0.01 seconds.
Search: Posts Made By: Eikinskjaldi
Forum: vB3 Programming Discussions 07 Nov 2008, 01:20
Replies: 4
Views: 656
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 03 Nov 2008, 22:26
Replies: 2
Views: 613
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 02 Nov 2008, 23:40
Replies: 4
Views: 1,547
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 31 Oct 2008, 00:04
Replies: 4
Views: 1,547
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 28 Oct 2008, 06:21
Replies: 1
Views: 824
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 26 Oct 2008, 23:42
Replies: 4
Views: 1,086
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 26 Oct 2008, 23:40
Replies: 1
Views: 813
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 22 Oct 2008, 00:35
Replies: 4
Views: 873
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 22 Oct 2008, 00:33
Replies: 4
Views: 1,086
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) 22 Oct 2008, 00:30
Replies: 5
Views: 1,275
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 20 Oct 2008, 04:10
Replies: 4
Views: 718
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 07 Oct 2008, 01:58
Replies: 8
Views: 1,045
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 07 Oct 2008, 01:56
Replies: 27
Views: 3,406
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 07 Oct 2008, 01:50
Replies: 9
Views: 1,888
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 26 Sep 2008, 04:25
Replies: 114
Views: 22,999
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 16 Sep 2008, 01:25
Replies: 4
Views: 885
Posted By Eikinskjaldi
The actual error is the "user not in ()"

The actual error is the "user not in ()"
Forum: Forum and Server Management 12 Sep 2008, 00:34
Replies: 9
Views: 1,598
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 12 Sep 2008, 00:29
Replies: 2
Views: 548
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 10 Sep 2008, 01:28
Replies: 19
HEy
Views: 1,557
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 Sep 2008, 02:17
Replies: 9
Views: 1,600
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 08 Sep 2008, 00:57
Replies: 5
Views: 748
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 04 Sep 2008, 06:32
Replies: 2
Views: 656
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 04 Sep 2008, 01:01
Replies: 1
Views: 634
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 03 Sep 2008, 04:48
Replies: 2
Views: 692
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 03 Sep 2008, 04:42
Replies: 4
Views: 718
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 150

 

New To Site? Need Help?

All times are GMT. The time now is 10:56.

Layout Options | Width: Wide Color: