Any chance of this being upgraded to work with SQLite?
Or can anyone help me upgrade it?
226 2007-02-01 11:17
Topic: Forum Cleanup (4 replies, posted in PunBB 1.2 modifications, plugins and integrations)
227 2007-02-01 11:16
Topic: Global Topic (5 replies, posted in PunBB 1.2 modifications, plugins and integrations)
Is there any chance this plugin can be upgraded for SQLite?
Or can anyone help me figure out how to do it?
228 2007-01-30 19:22
Re: admin_ranks.php error in query syntax (3 replies, posted in PunBB 1.2 bug reports)
bah 
Good to hear its fixed for the next version.
229 2007-01-30 13:59
Topic: admin_ranks.php error in query syntax (3 replies, posted in PunBB 1.2 bug reports)
As I am using SQLite I may be just one of few where this bug becomes apparent. On trying to update a rank I found that an error was generated - yet it worked fine with MySQL. After a little hunting and testing I found this:
// Make sure there isn't already a rank with the same min_posts value
$result = $db->query('SELECT 1 FROM '.$db->prefix.'ranks WHERE id!='.$id.' && min_posts='.$min_posts) or error('Unable to fetch rank info', __FILE__, __LINE__, $db->error());It appears that SQLite doesn't like the shorthand && and you have to use AND, so the affected part becomes
// Make sure there isn't already a rank with the same min_posts value
$result = $db->query('SELECT * FROM '.$db->prefix.'ranks WHERE id!='.$id.' AND min_posts='.$min_posts) or error('Unable to fetch rank info', __FILE__, __LINE__, $db->error());providing I didn't mistype my search, a quick check on the other scripts doesn't reveal any more instances of utilising &&
230 2007-01-29 20:15
Re: PunBB 1.3 Preview (49 replies, posted in PunBB 1.2 discussion)
flx wrote:
yes, why not? i don't know if you realized that nothing is working - just .html files
oops, no I didn't! mutter grumble.
231 2007-01-29 19:32
Re: PunBB 1.3 Preview (49 replies, posted in PunBB 1.2 discussion)
and did you mean to allow everyone access to the admin side of things...
232 2007-01-26 11:53
Re: subscribe/unsubscribe link (2 replies, posted in Feature requests)
ok even better!
thanks.
233 2007-01-26 10:52
Topic: subscribe/unsubscribe link (2 replies, posted in Feature requests)
apologies if this has already been asked for, though I did try and check first!
Currently the subscribe and unsubscribe links have the same container e.g.
<p class="subscribelink clearb"><a href="misc.php?subscribe=5052">Subscribe to this topic</a></p>and
<p class="subscribelink clearb">You are currently subscribed to this topic - <a href="misc.php?unsubscribe=146">Unsubscribe</a></p>Could the unsubscribe container have a class of unsubscribe?
from viewtopic.php
// I apologize for the variable naming here. It's a mix of subscription and action I guess :-)
$subscraction = '<p class="subscribelink clearb">'.$lang_topic['Is subscribed'].' - <a href="misc.php?unsubscribe='.$id.'">'.$lang_topic['Unsubscribe'].'</a></p>'."\n";
//amend to
// I apologize for the variable naming here. It's a mix of subscription and action I guess :-)
$subscraction = '<p class="unsubscribelink clearb">'.$lang_topic['Is subscribed'].' - <a href="misc.php?unsubscribe='.$id.'">'.$lang_topic['Unsubscribe'].'</a></p>'."\n";Would be nice if this was available out of the box so to speak
234 2007-01-24 19:27
Topic: Sudo Private Messaging (1 replies, posted in PunBB 1.2 modifications, plugins and integrations)
This isn't a proper announcement, more a tester to see if anyone likes it well enough for a proper Mod Release.
I took one look at the private messaging mod and decided it can wait until 1.3 came out But I still wanted some of the functionality, i.e. the ability to hide your email but still let others contact you. I came up with the following:
open misc.php
----------------------
find
----------------------
$mail_message = str_replace('<board_mailer>', $pun_config['o_board_title'].' '.$lang_common['Mailer'], $mail_message);
----------------------
add after
----------------------
$mail_message = str_replace('<send_reply_to>', $pun_config['o_base_url'].'/misc.php?email='.$pun_user['id'], $mail_message);
----------------------
find
----------------------
pun_mail($recipient_email, $mail_subject, $mail_message, '"'.str_replace('"', '', $pun_user['username']).'" <'.$pun_user['email'].'>');
----------------------
replace with
----------------------
pun_mail($recipient_email, $mail_subject, $mail_message, '"'.str_replace('"', '', $pun_user['username']).'" <'.$pun_config['o_webmaster_email'].'>');
----------------------
----------------------
open form_email.tpl
----------------------
find
----------------------
<sender> from <board_title> has sent you a message. You can reply to <sender> by replying to this e-mail.
----------------------
replace with
----------------------
<sender> from <board_title> has sent you a message. You can reply to <sender> by going
to <send_reply_to>. Please **do not** reply to this e-mail.
----------------------
----------------------
open Lang/<YOUR LANG>/misc.php
----------------------
find
----------------------
'E-mail disclosure note' => 'Please note that by using this form, your e-mail address will be disclosed to the recipient.',
----------------------
replace with
----------------------
'E-mail disclosure note' => 'Please note that your e-mail address will <strong>not</strong> be disclosed to the recipient.',
----------------------Plus if there is anything wrong with my approach please let me know.
235 2007-01-24 11:56
Re: Google Sitemaps (27 replies, posted in Feature requests)
note to self: when querying that something is incorrect assume I am wrong and double check everything first.
aye my bad - checked on local copy that didn't have all the permissions altered *sigh* I will get there one day!
236 2007-01-24 10:05
Re: Google Sitemaps (27 replies, posted in Feature requests)
I have just tried to run the google sitemap plugin and noticed some problems with it.
It is listing everything, even if you have boards set for viewing by admin/moderators. Any chance of upgrading it to hide those from the listing?
237 2007-01-23 09:33
Re: iclosed isticky (9 replies, posted in Feature requests)
Start messing with the order of other CSS and you can run into problems! But yes dropping IE on the Mac from the list of tested browsers certainly helps.
238 2007-01-22 21:50
Re: iclosed isticky (9 replies, posted in Feature requests)
works in IE7 and IE6, but haven't been able to test in IE5.5. Though it did work in a copy of IE5!
239 2007-01-22 20:47
Re: iclosed isticky (9 replies, posted in Feature requests)
Paul wrote:
Moved it back. It was a definite feature request and multiple classes doesn't help in this case though a sneaky use of descendant selectors might ie. putting classes on the tr and on the td which should give an infinite variety.
actually I'd have to agree with Smartys - as his responce led me to the bit of CSS that was eluding me, and hence enabling me to change the icon.
240 2007-01-22 20:44
Re: iclosed isticky (9 replies, posted in Feature requests)
I should learn more css I really should - apologies for posting I should have known that one!
*sigh* and for those who like me didn't know then use this:
.isticky.iclosed .icon{}Note: no space between the .isticky and .iclosed.
Thanks for pointing me to the right place Smartys.
241 2007-01-22 19:32
Topic: iclosed isticky (9 replies, posted in Feature requests)
I have been skinning, sorry creating a theme for, an installation of punBB and come across a smallish problem.
I can add a default icon, I can add a new icon, I can add a sticky icon, and I can even add a closed icon (and not forgetting the moved icon!). But I cannot add a closed but sticky icon.
Is there any chance that viewforum.php, in a future release, could add in iclosedandsticky (or whatever) to enable me to add that specific icon.
I am trying to keep mods down to a minimum, but I assume adding in this line:
if($item_status=='iclosed isticky')$item_status='iclosedandsticky';at around line 206 would be the quick and dirty method.
242 2007-01-19 19:14
Re: [Release] PunBB Backup v1.0 (31 replies, posted in PunBB 1.2 modifications, plugins and integrations)
It was a memory problem, got it upped to 32Mb and it appears to create/download the file with no problem.
However, I've no come across another problem - handling of NULL is not working correctly, don't know if anyone has come across this before but I get something like the following:
'z¶"@ø'±', 'z¶"@hiP', 'z¶"@(?r'It could be a server issue, again! But if anyone knows how to correctly alter this I'd be grateful.
I should be able to adapt it, but my solution, used elsewhere, is not elegant and there is probably an easier way.
243 2007-01-19 12:37
Re: [Release] PunBB Backup v1.0 (31 replies, posted in PunBB 1.2 modifications, plugins and integrations)
I can copy the physical file with no problem, but I need access to all the INSERT statements etc.
It may be related to a memory problem, so I've contacted the relevant people on the hosting side to see if then can up the limit - even if it just rules that out as the problem.
244 2007-01-19 12:14
Re: [Release] PunBB Backup v1.0 (31 replies, posted in PunBB 1.2 modifications, plugins and integrations)
Normally I'd agree, but what if some where down the line I get access to another database? Having access to an sql back up is preferable.
245 2007-01-19 11:10
Re: [Release] PunBB Backup v1.0 (31 replies, posted in PunBB 1.2 modifications, plugins and integrations)
Has anyone got this to successfully work with SQLite? The db is currently 14Mb and I am trying to track down why I can't back the thing up!
246 2007-01-18 21:34
Re: version 1.3 (9 replies, posted in PunBB 1.2 discussion)
elbekko wrote:
1.3 will come with a script that updates the 1.2 database to work with 1.3
Well that is great news, I was sort of hoping that would be the case
Connorhd - thanks, already seen that but don't know how fast you guys work! Though looks like it is still going to take a while.
Keep up the good work.
247 2007-01-18 21:28
Re: possible - last visited not updating (4 replies, posted in PunBB 1.2 troubleshooting)
aha thanks Smartys.
248 2007-01-18 18:51
Re: possible - last visited not updating (4 replies, posted in PunBB 1.2 troubleshooting)
at the moment yes I am the only one.
erm and I just checked, it appears to have sorted itself. Strange because it definitely did not change for the first few visits. Though I had to reset my password, so maybe that nudged it into working.
Sorry to have troubled you :blush:
[edit]
just realised what it may be. Could it relate to last activity, as opposed to last actual visit. If you visit and do nothing is the system still picking up on the fact you are there lurking?
249 2007-01-18 14:19
Topic: version 1.3 (9 replies, posted in PunBB 1.2 discussion)
I realise asking this may be asking for trouble but...
Any idea when 1.3 will be available for download?
there, I've said.
Also, are there any changes in the database that would affect existing installations?
250 2007-01-18 11:59
Topic: possible - last visited not updating (4 replies, posted in PunBB 1.2 troubleshooting)
Hi,
having a problem with version 1.2.12 (it'll be updated soon) where the last visited time is not updating. I am using SQLite. The data in last_visit stays as 0.
Looks like SQLite has the following set up for last_visit :
Type : INTEGER
Null : No
Default : 0
Is this a bug?
The data was imported from Yabb 1 Gold, via YabbSE, via punBB(mysql), could that have caused an error?