Cheers. 
I'll have a further delve into those procedures.
651 2008-04-07 23:21
Re: Incrementing identical db values question (5 replies, posted in General discussion)
652 2008-04-07 23:19
Re: When is 1.3 going to be released? (31 replies, posted in PunBB 1.3 troubleshooting)
Hate to say this, but I actually can see the point of running a beta in production. (If one knows of, and is willing to take the risks involved). At the end of the day, no matter how poor a choice it may be if something goes wrong, conversely, it is also hard to give something a thorough testing unless it is being subjected to normal types of use. And users can abuse the socks off the best of systems. 
What better method for bug crunching. It is risky though.
653 2008-04-07 14:55
Re: Incrementing identical db values question (5 replies, posted in General discussion)
elbekko wrote:
You could create a stored procedure, if pgSQL supports those.
It does indeed. http://www.postgresql.org/docs/8.3/stat … igger.html
How would one need to setup that to achieve it? Wouldn't it just update each one by the same amount, i.e: +1? Or, would it be able to increment as it ran through the update?
654 2008-04-07 10:39
Topic: Incrementing identical db values question (5 replies, posted in General discussion)
If one has several or more entries in the db with the exact same value, (i.e: a timestamp), is there a straight forward command one could run to make all of those values be incremented by, for example, 1 respectively for each entry? So that the first entry would be plus one, the second entry plus two, etc.
Sole reason for this one is that I altered the timestamp layout I used on one of the mods, and so changed all the existing old style entries to a Unix timestamp, but all of the same value. Just want to alter them now so that the Atom validator doesn't give me identical ID suggestion messages. Sad, I know, but.......
Cheers.
655 2008-04-06 15:14
Re: edit.php, l. 159, miss > (3 replies, posted in PunBB 1.2 bug reports)
Running in XML mode is a good way to catch problems like that. It'll throw a hissy fit over the slightest of code errors.
656 2008-04-06 10:07
Re: A SQL question (6 replies, posted in General discussion)
Smartys wrote:
Not necessarily.
Did a Google on the subject to try and get an idea of things. It's a very expansive subject, ain't it? One doesn't appreciate just how many possibilities there are until you actually start researching the subject. It's a veritable minefield.
657 2008-04-05 22:58
Re: A SQL question (6 replies, posted in General discussion)
Just whilst on this subject, is there a certain string that would always be used when someone is attempting something like this? Just thought it might be worthwhile settting up a special redirect, for any muppets who decide to try again.
658 2008-04-05 21:54
Re: A SQL question (6 replies, posted in General discussion)
It's times like this when I'm glad I've heeded your advice to triple check and sanitise all input.
Btw, that length restriction is the same one that bit me on the backside the other day with that new function. That's why it's up at 2000 now.
659 2008-04-05 21:38
Topic: A SQL question (6 replies, posted in General discussion)
Just been having a peek through the SQL logs, and noticed several entries along this line:
<2008-04-05 13:49:38 GMT>ERROR: 22001: value too long for type character varying(2000)
<2008-04-05 13:49:38 GMT>LOCATION: varchar, varchar.c:608
<2008-04-05 13:49:38 GMT>STATEMENT: UPDATE punbb_online SET logged=1207403378, prev_uri='[snipped]downloads.php?cat_id=6+and+1=2+union+select+concat[rest of line snipped for brevity]Was this a case of someone trying to exploit the db?
660 2008-04-05 19:55
Re: Function question (5 replies, posted in Programming)
Smartys wrote:
What you're doing.
test_function() does not run the command
test_function(false) does not run the command
test_function(true) runs the commandWhen Bekko said run, he meant the function.
So I have the basics correct then. That must mean I'm mucking things up elsewhere, within the command itself, or the logic behind it.
You ever notice that when you're having one of those days, everything conspires against you?
661 2008-04-05 19:47
Re: Function question (5 replies, posted in Programming)
elbekko wrote:
It's optional, so it'll run with or without any arguments.
That's where I've been going wrong then. What would be the way to make it run only if a specific value was passed, but not complain about a missing argument if none was supplied?
Thanks again.
662 2008-04-05 19:26
Topic: Function question (5 replies, posted in Programming)
Just a quickie. If one creates a function like follows:
function test_function($value = false)
{
if ($value)
{
[run this command]
}
}Would that command only be executed if some value was passed to that function within the ()?
Cheers.
663 2008-04-05 13:18
Re: Request: remind unconfirmed members (6 replies, posted in PunBB 1.2 modifications, plugins and integrations)
mixart wrote:
It would also need to be able to generate the same welcome email with the link to verify membership so it's not as simple as just broadcasting a generic one-off email to all users.
That's very little extra work to accomplish, however.
664 2008-04-04 09:05
Re: Base URL (13 replies, posted in General discussion)
Cache files in the root forum directory. [path/to/forum/dir/]cache/*.php. Remove those files.
665 2008-04-03 18:41
Re: Base URL (13 replies, posted in General discussion)
In the database. [your-db-prefix]config. It's the o_base_url setting.
666 2008-04-01 14:44
Re: The age-old line 58 error! (30 replies, posted in PunBB 1.2 troubleshooting)
As far as I know, this covers everything needed to convert the setup to UTF-8.
667 2008-04-01 12:48
Re: When is 1.3 going to be released? (31 replies, posted in PunBB 1.3 troubleshooting)
elbekko wrote:
Doubt it
Me too. That does sound a bit optimistic.
668 2008-04-01 12:46
Re: The age-old line 58 error! (30 replies, posted in PunBB 1.2 troubleshooting)
It's one of the latin character sets. Can't remember the specific name offhand, though.
669 2008-04-01 12:44
Re: Nissan Sentra - SpecV enthusiasts! (8 replies, posted in PunBB 1.2 show off)
NiCk Newman wrote:
See there you go trying to start stuff with me bro just relax, he replied.. are u jealous or somthing?
Nope. Just beginning to get pissed off reading your meaningless twaddle.
670 2008-04-01 02:36
Re: pun_user question/advice (14 replies, posted in Programming)
Good point. I hadn't considered redirects.
671 2008-04-01 01:46
Re: When is 1.3 going to be released? (31 replies, posted in PunBB 1.3 troubleshooting)
Backwards.
672 2008-04-01 01:42
Re: Nissan Sentra - SpecV enthusiasts! (8 replies, posted in PunBB 1.2 show off)
NiCk Newman wrote:
www.specv.net was created on: March 31 2008
Domain age (approximately):
0 Months, 0 days..Older domains tend to rank better, and they also tend to be worth more money.
lol u just made site in last 24hours
And that bears what relation to the O.P's post?
@Bawls. Looks quite tidy. One thing I might suggest though is some horizontal division between the forums on the index page. The lack of any dividing lines makes things seem to merge a tad.
673 2008-04-01 01:38
Re: pun_user question/advice (14 replies, posted in Programming)
My apologies. I wasn't trying to suggest how to do the MySQL side of things. I was merely trying to provide info for PgSQL.
Just on a slight sidenote, might I make one request/suggestion? I haven't gone through the 1.3 code to any degree, so don't know if it's applied later, but it may be worthwhile doing a str_replace for the ampersand to it's numeric entity in the get_current_url function before it's returned. Might save someone a bit of head scratching if they switch to XHTML1.1.
674 2008-03-31 22:25
Re: pun_user question/advice (14 replies, posted in Programming)
I believe it works the opposite way round with this one. The limit has to be implicitly specified, otherwise there is no limit on the length of input, by default. http://www.postgresql.org/docs/8.2/stat … acter.html
675 2008-03-31 22:07
Re: pun_user question/advice (14 replies, posted in Programming)
Just whilst on the subject, btw, would I be best setting the character limit to something like 1000, or just removing the column limit altogether? Or, would I be better off stripping the URI down to length if it exceeds?