Could you paste some of that here?
1,801 2007-11-25 19:58
Re: phpBB 3 to punbb convertor ? (55 replies, posted in PunBB 1.2 discussion)
1,802 2007-11-25 19:41
Re: phpBB 3 to punbb convertor ? (55 replies, posted in PunBB 1.2 discussion)
Assuming you're running the converter from the start, that shouldn't be an issue. However, try running it from a clean install.
1,803 2007-11-25 19:35
Re: Updating a db count (13 replies, posted in Programming)
More info:
http://us.php.net/mysql_real_escape_string
Escapes special characters in the unescaped_string, taking into account the current character set of the connection so that it is safe to place it in a mysql_query(). If binary data is to be inserted, this function must be used.
mysql_real_escape_string() calls MySQL's library function mysql_real_escape_string, which prepends backslashes to the following characters: \x00, \n, \r, \, ', " and \x1a.
This function must always (with few exceptions) be used to make data safe before sending a query to MySQL.
1,804 2007-11-25 19:33
Re: phpBB 3 to punbb convertor ? (55 replies, posted in PunBB 1.2 discussion)
I'm not exactly sure how that's possible, since forum_id is a primary key for phpBB. Unless the converter isn't deleting the old PunBB data, which I've always seen it do, I don't know how that could happen.
1,805 2007-11-25 19:01
Re: Updating a db count (13 replies, posted in Programming)
It is not about inserting or selecting. It is about escaping input in a query. If you're surrounding something with a " or a ' and the input could potentially have a " or a ' in it, you need to escape it so that it can't "break out," which would be an SQL inject.
1,806 2007-11-25 18:22
Re: Updating a db count (13 replies, posted in Programming)
Oh, I think you'll want to $db->escape the poster value from the database.
1,807 2007-11-25 18:08
Re: Updating a db count (13 replies, posted in Programming)
while (false !== ($topic = $db->fetch_assoc($result)))
can be
while ($topic = $db->fetch_assoc($result))
Otherwise, looks fine to me
1,808 2007-11-25 16:57
Re: Updating a db count (13 replies, posted in Programming)
I just tested the original script you pasted, it worked perfectly for me
1,809 2007-11-25 15:38
Re: Updating a db count (13 replies, posted in Programming)
There is no num_topics column in users by default: did you mean num_posts?
Other than that, I see no issue, the code looks correct to me.
Yeah, and as you figured out you can safely not use that expensive join
1,810 2007-11-24 20:42
Re: [1045] dbconn: mysql_connect: Access denied for user 'www-data'@'local (7 replies, posted in PunBB 1.2 troubleshooting)
config table, conf value where conf name is o_base_url
1,811 2007-11-24 12:25
Re: [1045] dbconn: mysql_connect: Access denied for user 'www-data'@'local (7 replies, posted in PunBB 1.2 troubleshooting)
It doesn't make up the www-data name, you must have it set in config.php
And if I were you, I would delete all the .php files in the cache directory and make sure base URL is set correctly in the database. That way, there should be no reason for it to reset.
1,812 2007-11-24 03:57
Re: Question.. (2 replies, posted in PunBB 1.2 troubleshooting)
http://punbb.org/about.php
PunBB is open source, it is released under the GPL. You can alter it however you like, you can distribute it as long as you follow the GPL.
1,813 2007-11-24 01:18
Re: Validation issue that makes no sense (26 replies, posted in General discussion)
Got it and replied
1,814 2007-11-24 01:08
Re: Change the root dir (3 replies, posted in PunBB 1.2 troubleshooting)
No, because if your base URL is invalid you can't change it except by manually editing the database
1,815 2007-11-24 01:04
Re: Validation issue that makes no sense (26 replies, posted in General discussion)
I don't know what to tell you: I just created a Hotmail account and I was able to send myself an email with no issue.
1,816 2007-11-24 00:49
Re: Validation issue that makes no sense (26 replies, posted in General discussion)
Could you paste the whole bounce message?
1,817 2007-11-24 00:28
Re: Validation issue that makes no sense (26 replies, posted in General discussion)
I just sent myself an email from several different accounts. No bounces.
1,818 2007-11-24 00:07
Re: Validation issue that makes no sense (26 replies, posted in General discussion)
bingiman: yup, email, smartys at this domain
1,819 2007-11-23 15:04
Re: PunBB 1.2.16 (71 replies, posted in News)
Hello All, developers,
I think there is still an oversight in the code for 1.2.16:
in include/functions.php, look for line:if ($register_globals === "" || $register_globals === "0" || strtolower($register_globals) === "off")
I think you will find that should be:
if ($register_globals === "" || $register_globals === "0" || strtolower($register_globals) === "off"))
Hendrik-Jan
Mmm, no, that's an extra closing parenthesis: that would give a parse error
1,820 2007-11-23 12:44
Re: Change the root dir (3 replies, posted in PunBB 1.2 troubleshooting)
Update the base URL and then move the files?
1,821 2007-11-23 04:01
Re: Validation issue that makes no sense (26 replies, posted in General discussion)
What's the site that's having the issue?
1,822 2007-11-23 00:02
Re: Administrator with normal user rights (7 replies, posted in PunBB 1.2 troubleshooting)
Have you modified your code at all?
1,823 2007-11-23 00:01
Re: How do I make a clickable image in my signature? (7 replies, posted in PunBB 1.2 troubleshooting)
1,824 2007-11-22 23:06
Re: Attachment mod question but mainly a path issue. (13 replies, posted in General discussion)
Yes, put a ' before admin_loader (the text in the redirect link)
1,825 2007-11-22 19:34
Re: Marking topics as read (5 replies, posted in Programming)
From looking at the other code, it seems to be far more 'extravagant' than it has to be, however, or is my view too simplistic?
It also allows you to mark an entire forum as read, other than that it doesn't seem to extravagant to me.
I believe it also fetches the post id's as well as just, (or rather than)?, the topic id's?
Nope
Is there any valid reason for serialising the id's before placing into the db as in the existing mod, btw?
Because you can unserialize it when you take it out of the database and keep the array pairing of topic IDs to last viewed times.
I'll be honest in that I haven't looked at the existing mod indepth, but from the cursory glance I've had, it would appear possible to do the same with approximately half the code?
I haven't looked at the code for it in a while, but I doubt it