Search found 288 matches

by haravikk
Wed Jan 28, 2004 10:58 pm
Forum: Chit Chat
Topic: Finding unused integer values with MySQL
Replies: 13
Views: 6809

Re: Finding unused integer values with MySQL

Actually someone has suggested a query which seems to be working perfectly over at the Dev Shed forums: Click here to view the solution The reason is that I really want to be able to replace rows in a table. A shoutbox I think is probably a bad example but it wasn't an important table so I decided t...
by haravikk
Wed Jan 28, 2004 1:38 pm
Forum: Chit Chat
Topic: Finding unused integer values with MySQL
Replies: 13
Views: 6809

Re: Finding unused integer values with MySQL

Roberdin that query doesn't work, it's much the same as the one I posted earlier and the problem seems to be that the + 1 in the WHERE part is being ignored entirely. The query returns the same value regardless of anything, in your case '2'. The query should theoretically look at each row in the sho...
by haravikk
Tue Jan 27, 2004 12:58 pm
Forum: [3.0/Olympus] Discussion
Topic: Karma Level
Replies: 18
Views: 8582

Re: Karma Level

Hmm has karma been reset? Mine seems to be at 0 now
by haravikk
Tue Jan 27, 2004 12:56 pm
Forum: Chit Chat
Topic: Finding unused integer values with MySQL
Replies: 13
Views: 6809

Re: Finding unused integer values with MySQL

Thanks for the idea sparkster but that's not it either, in the example info I gave in the first post that query would return 7 instead of 2. Thing is that I'm certain that the query I posted at the start should work (theoretically :)) but it doesn't which suggest that MySQL isn't doing anything with...
by haravikk
Mon Jan 26, 2004 7:01 pm
Forum: Chit Chat
Topic: Finding unused integer values with MySQL
Replies: 13
Views: 6809

Re: Finding unused integer values with MySQL

Thanks for the idea but it doesn't work, it simply returns 1 instead of 0
by haravikk
Mon Jan 26, 2004 5:02 pm
Forum: Chit Chat
Topic: Finding unused integer values with MySQL
Replies: 13
Views: 6809

Finding unused integer values with MySQL

Okay, I know I'm all problems lately but here it goes with another problem that is probably simple but I can't find the answer to myself: Quite simply I want a MySQL query than can search a column of a table and return the earliest unused integer. For example, I have five rows in a table as follows:...
by haravikk
Mon Jan 26, 2004 2:14 pm
Forum: [3.0/Olympus] Discussion
Topic: Portal Status?
Replies: 10
Views: 7996

Re: Portal Status?

Yeah, I expect the portal will use much the same technology as phpBB 2.2 and it will likely be developed with integrating with phpBB forums in mind. Since the template system is receiving quite a big overhaul with caching and the various nifty features in it it would be unrealistic to do a whole lot...
by haravikk
Mon Jan 26, 2004 2:08 pm
Forum: [3.0/Olympus] Discussion
Topic: Karma Level
Replies: 18
Views: 8582

Re: Karma Level

I'm not sure what the exact formula is but I expect that it takes into account the same person rating all your posts bad by devaluing them and only taking the bad votes into account if several people are voting your posts as 'bad'
by haravikk
Mon Jan 26, 2004 2:04 pm
Forum: [3.0/Olympus] New features discussion
Topic: Invisionfeatures: Most active in..., calender, birthdays
Replies: 79
Views: 36423

Re: Invisionfeatures: Most active in..., calender, birthdays

I'm from England as well (currently in Scotland) and can't spell to save myself half the time.
by haravikk
Sun Jan 25, 2004 9:47 pm
Forum: Chit Chat
Topic: Tags within tags and preg_replace
Replies: 7
Views: 4059

Re: Tags within tags and preg_replace

psoTFX wrote:\\1
Hey thanks psoTFX! I must admit to spend hours trying to figure it out only to have you point out I missed a single backslash is a tag frustrating :X
Oh well, just a reminder who the PHP king around here is I suppose :)