`date` varchar(12) NOT NULL DEFAULT '',should probably replaced with
`date` datetime NOT NULL DEFAULT '',when creating table...
451 2010-09-10 12:05
Re: Spreadsheet to MySQL - correct syntax for URLs? (11 replies, posted in Programming)
452 2010-09-10 11:40
Re: Spreadsheet to MySQL - correct syntax for URLs? (11 replies, posted in Programming)
Thanks, yes - I needed to add ' to the string values... so in my insert command....
'"&B&"'instead of
"&B&"RE: Date
`date` varchar(12) NOT NULL DEFAULT '',I'll try and get the cell to show what you just put in as date...
453 2010-09-10 09:43
Topic: Spreadsheet to MySQL - correct syntax for URLs? (11 replies, posted in Programming)
Trying to export from ods spreadsheet into mysql via phpmyadmin
[code=sql]
="INSERT INTO `spamurls` VALUES ("&A2&","&B2&","&C2&","&D2&","&E2&","&F2&""&");"
[/code]
like this; but 2 probs
1. Date is not in date format?
2. [code]://[/code] causes problem - any idea how to solve?
[code=sql]
INSERT INTO `spamurls` VALUES (2,http://www.mindmagiclive.com/,magicians toronto ,1,40409,S);
INSERT INTO `spamurls` VALUES (3,http://mobilemonopolyreview.easyonlinejobsreview.com/,mobile monopoly review ,1,40409,S);
INSERT INTO `spamurls` VALUES (4,http://doubleglazingleeds.org,double glazing leeds ,1,40409,S);
INSERT INTO `spamurls` VALUES (5,http://www.wordsworth.co.uk,industrial PC ,1,40409,S);
INSERT INTO `spamurls` VALUES (6,http://www.cheapipodnano.org,Cheap iPod Nano ,1,40409,S);
INSERT INTO `spamurls` VALUES (7,http://www.semenaxsale.com,semenax review ,1,40409,S);
[/code]
this is original code in spreadsheet:
[code]
2 http://www.mindmagiclive.com/ magicians toronto 1 19.08.10 S
3 http://mobilemonopolyreview.easyonlinejobsreview.com/ mobile monopoly review 1 19.08.10 S
4 http://doubleglazingleeds.org double glazing leeds 1 19.08.10 S
5 http://www.wordsworth.co.uk industrial PC 1 19.08.10 S
6 http://www.cheapipodnano.org Cheap iPod Nano 1 19.08.10 S
7 http://www.semenaxsale.com semenax review 1 19.08.10 S
[/code]
The SQL I used to create table
[code=sql]
CREATE TABLE `spamurls` (
`id` int(11) NOT NULL auto_increment,
`url` varchar(150) NOT NULL default '',
`keyword` varchar(100) NOT NULL default '',
`position` varchar(4) NOT NULL default '',
`date` varchar(12) NOT NULL default '',
`type` varchar(25) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM
[/code]
Error I'm getting
[code=sql]
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '://www.mindmagiclive.com/,magicians toronto ,1,40409,S)' at line 1
[/code]
454 2010-09-09 20:13
Topic: Adding IP To Welcome email template (and so admin sees it) (8 replies, posted in PunBB 1.3 discussion)
I'm just wondering about adding the IP
would I add a line
$mail_message = str_replace('<user_ip>',get_remote_address(), $mail_message);
or $mail_message = str_replace('<user_ip>','registration_ip', $mail_message);
or $mail_message = str_replace('<user_ip>',$registration_ip, $mail_message);
in include/functions.php
($hook = get_hook('fn_add_user_qr_insert_user')) ? eval($hook) : null;
$forum_db->query_build($query) or error(__FILE__, __LINE__);
$new_uid = $forum_db->insert_id();
// Must the user verify the registration?
if ($user_info['require_verification'])
{
// Load the "welcome" template
$mail_tpl = forum_trim(file_get_contents(FORUM_ROOT.'lang/'.$forum_user['language'].'/mail_templates/welcome.tpl'));
// The first row contains the subject
$first_crlf = strpos($mail_tpl, "\n");
$mail_subject = forum_trim(substr($mail_tpl, 8, $first_crlf-8));
$mail_message = forum_trim(substr($mail_tpl, $first_crlf));
$mail_subject = str_replace('<board_title>', $forum_config['o_board_title'], $mail_subject);
$mail_message = str_replace('<base_url>', $base_url.'/', $mail_message);
$mail_message = str_replace('<username>', $user_info['username'], $mail_message);
$mail_message = str_replace('<activation_url>', str_replace('&', '&', forum_link($forum_url['change_password_key'], array($new_uid, substr($user_info['activate_key'], 1, -1)))), $mail_message);
$mail_message = str_replace('<board_mailer>', sprintf($lang_common['Forum mailer'], $forum_config['o_board_title']), $mail_message);
($hook = get_hook('fn_add_user_send_verification')) ? eval($hook) : null;455 2010-09-09 19:53
Topic: Lightening up register.php / the registration page - without timezone (0 replies, posted in PunBB 1.3 discussion)
I just wanted to have less information to enter on registration page....
if you delete this from register.php
<div class="sf-set set<?php echo ++$forum_page['item_count'] ?>">
<div class="sf-box select">
<label for="fld<?php echo ++$forum_page['fld_count'] ?>"><span><?php echo $lang_profile['Timezone'] ?></span></label><br />
<span class="fld-input"><select id="fld<?php echo $forum_page['fld_count'] ?>" name="timezone">
<option value="-12"<?php if ($select_timezone == -12) echo ' selected="selected"' ?>><?php echo $lang_profile['UTC-12:00'] ?></option>
<option value="-11"<?php if ($select_timezone == -11) echo ' selected="selected"' ?>><?php echo $lang_profile['UTC-11:00'] ?></option>
<option value="-10"<?php if ($select_timezone == -10) echo ' selected="selected"' ?>><?php echo $lang_profile['UTC-10:00'] ?></option>
<option value="-9.5"<?php if ($select_timezone == -9.5) echo ' selected="selected"' ?>><?php echo $lang_profile['UTC-09:30'] ?></option>
<option value="-9"<?php if ($select_timezone == -9) echo ' selected="selected"' ?>><?php echo $lang_profile['UTC-09:00'] ?></option>
<option value="-8"<?php if ($select_timezone == -8) echo ' selected="selected"' ?>><?php echo $lang_profile['UTC-08:00'] ?></option>
<option value="-7"<?php if ($select_timezone == -7) echo ' selected="selected"' ?>><?php echo $lang_profile['UTC-07:00'] ?></option>
<option value="-6"<?php if ($select_timezone == -6) echo ' selected="selected"' ?>><?php echo $lang_profile['UTC-06:00'] ?></option>
<option value="-5"<?php if ($select_timezone == -5) echo ' selected="selected"' ?>><?php echo $lang_profile['UTC-05:00'] ?></option>
<option value="-4"<?php if ($select_timezone == -4) echo ' selected="selected"' ?>><?php echo $lang_profile['UTC-04:00'] ?></option>
<option value="-3.5"<?php if ($select_timezone == -3.5) echo ' selected="selected"' ?>><?php echo $lang_profile['UTC-03:30'] ?></option>
<option value="-3"<?php if ($select_timezone == -3) echo ' selected="selected"' ?>><?php echo $lang_profile['UTC-03:00'] ?></option>
<option value="-2"<?php if ($select_timezone == -2) echo ' selected="selected"' ?>><?php echo $lang_profile['UTC-02:00'] ?></option>
<option value="-1"<?php if ($select_timezone == -1) echo ' selected="selected"' ?>><?php echo $lang_profile['UTC-01:00'] ?></option>
<option value="0"<?php if ($select_timezone == 0) echo ' selected="selected"' ?>><?php echo $lang_profile['UTC'] ?></option>
<option value="1"<?php if ($select_timezone == 1) echo ' selected="selected"' ?>><?php echo $lang_profile['UTC+01:00'] ?></option>
<option value="2"<?php if ($select_timezone == 2) echo ' selected="selected"' ?>><?php echo $lang_profile['UTC+02:00'] ?></option>
<option value="3"<?php if ($select_timezone == 3) echo ' selected="selected"' ?>><?php echo $lang_profile['UTC+03:00'] ?></option>
<option value="3.5"<?php if ($select_timezone == 3.5) echo ' selected="selected"' ?>><?php echo $lang_profile['UTC+03:30'] ?></option>
<option value="4"<?php if ($select_timezone == 4) echo ' selected="selected"' ?>><?php echo $lang_profile['UTC+04:00'] ?></option>
<option value="4.5"<?php if ($select_timezone == 4.5) echo ' selected="selected"' ?>><?php echo $lang_profile['UTC+04:30'] ?></option>
<option value="5"<?php if ($select_timezone == 5) echo ' selected="selected"' ?>><?php echo $lang_profile['UTC+05:00'] ?></option>
<option value="5.5"<?php if ($select_timezone == 5.5) echo ' selected="selected"' ?>><?php echo $lang_profile['UTC+05:30'] ?></option>
<option value="5.75"<?php if ($select_timezone == 5.75) echo ' selected="selected"' ?>><?php echo $lang_profile['UTC+05:45'] ?></option>
<option value="6"<?php if ($select_timezone == 6) echo ' selected="selected"' ?>><?php echo $lang_profile['UTC+06:00'] ?></option>
<option value="6.5"<?php if ($select_timezone == 6.5) echo ' selected="selected"' ?>><?php echo $lang_profile['UTC+06:30'] ?></option>
<option value="7"<?php if ($select_timezone == 7) echo ' selected="selected"' ?>><?php echo $lang_profile['UTC+07:00'] ?></option>
<option value="8"<?php if ($select_timezone == 8) echo ' selected="selected"' ?>><?php echo $lang_profile['UTC+08:00'] ?></option>
<option value="8.75"<?php if ($select_timezone == 8.75) echo ' selected="selected"' ?>><?php echo $lang_profile['UTC+08:45'] ?></option>
<option value="9"<?php if ($select_timezone == 9) echo ' selected="selected"' ?>><?php echo $lang_profile['UTC+09:00'] ?></option>
<option value="9.5"<?php if ($select_timezone == 9.5) echo ' selected="selected"' ?>><?php echo $lang_profile['UTC+09:30'] ?></option>
<option value="10"<?php if ($select_timezone == 10) echo ' selected="selected"' ?>><?php echo $lang_profile['UTC+10:00'] ?></option>
<option value="10.5"<?php if ($select_timezone == 10.5) echo ' selected="selected"' ?>><?php echo $lang_profile['UTC+10:30'] ?></option>
<option value="11"<?php if ($select_timezone == 11) echo ' selected="selected"' ?>><?php echo $lang_profile['UTC+11:00'] ?></option>
<option value="11.5"<?php if ($select_timezone == 11.5) echo ' selected="selected"' ?>><?php echo $lang_profile['UTC+11:30'] ?></option>
<option value="12"<?php if ($select_timezone == 12) echo ' selected="selected"' ?>><?php echo $lang_profile['UTC+12:00'] ?></option>
<option value="12.75"<?php if ($select_timezone == 12.75) echo ' selected="selected"' ?>><?php echo $lang_profile['UTC+12:45'] ?></option>
<option value="13"<?php if ($select_timezone == 13) echo ' selected="selected"' ?>><?php echo $lang_profile['UTC+13:00'] ?></option>
<option value="14"<?php if ($select_timezone == 14) echo ' selected="selected"' ?>><?php echo $lang_profile['UTC+14:00'] ?></option>
</select></span>
</div>
</div>
<?php ($hook = get_hook('rg_register_pre_dst_checkbox')) ? eval($hook) : null; ?>
<div class="sf-set set<?php echo ++$forum_page['item_count'] ?>">
<div class="sf-box checkbox">
<span class="fld-input"><input type="checkbox" id="fld<?php echo ++$forum_page['fld_count'] ?>" name="dst"<?php if ($select_dst) echo ' checked="checked"' ?> /></span>
<label for="fld<?php echo $forum_page['fld_count'] ?>"><span><?php echo $lang_profile['Adjust for DST'] ?></span> <?php echo $lang_profile['DST label'] ?></label>
</div>
</div>you'll get just the other username, email, password (if you have stop bots extension activated and not captcha....
annyone know how do to this easy with one of these two hooks?
($hook = get_hook('rg_register_pre_timezone')) ? eval($hook) : null;<?php ($hook = get_hook('rg_register_pre_group_end')) ? eval($hook) : null; ?>456 2010-09-09 18:50
Re: Stop Spambot Extension (3 replies, posted in PunBB 1.3 troubleshooting)
Ok it is the easiest way.... 
457 2010-09-09 14:49
Re: Bug in Ext Pun_BBCode: bar is missing - Parse error in code (23 replies, posted in PunBB 1.3 bug reports)
Which other extensions (incl. version number) are you using?
Try this download:
http://punbb.informer.com/wiki/_media/p … bbcode.zip
Think there's something seriously wrong with bar.php of extension that is on repository....
458 2010-09-09 14:47
Re: Stop Spambot Extension (3 replies, posted in PunBB 1.3 troubleshooting)
Which version of the extension were you using?
Can you try this one:
http://punbb.informer.com/wiki/_media/p … p_bots.zip
459 2010-09-09 11:53
Re: Forum name / Change permission notice to link to registration (4 replies, posted in PunBB 1.3 troubleshooting)
Did you try Start > Forums and then edit whatever forum names you've given / same for Pages and Panels
460 2010-09-09 11:01
Re: Forum name / Change permission notice to link to registration (4 replies, posted in PunBB 1.3 troubleshooting)
kiejr wrote:
Where can I change this message:
/lang/English/common.php
// Notices
'No view' => 'You do not have permission to view these forums.',
'No permission' => 'You do not have permission to access this page.',Just replace by using html to add the link => 'You need to <a href="yourlink">register</a> to access / view etc';
461 2010-09-09 09:34
Re: URL file-access is disabled in the server configuration in (12 replies, posted in PunBB 1.3 troubleshooting)
added to trac
http://punbb.informer.com/trac/ticket/359
462 2010-09-09 09:25
Re: [Solved] subscribe to topics : no e-mail alerts (french - francais) (9 replies, posted in PunBB 1.3 troubleshooting)
463 2010-09-09 04:34
Re: posting new category? (2 replies, posted in PunBB 1.3 troubleshooting)
Once you created a category you need to create a forum aswell...
You did numbering correctly...
464 2010-09-08 19:15
Re: BmkDispatch.com PORTAL (1 replies, posted in PunBB show off)
Good job, let us know here if you have any spam issue....
465 2010-09-08 17:50
Re: Bug in Ext Pun_BBCode: bar is missing - Parse error in code (23 replies, posted in PunBB 1.3 bug reports)
Did you clear cache after reinstalling, and reactivate the extension? (by default after upgrade they're deactivated)
466 2010-09-08 16:53
Re: [Request]Image Verification every Reply Topic (3 replies, posted in PunBB 1.3 extensions)
With extension pun_stop_bots you can have a question appear before users can post
but be warned: your regulars will get pissed if they have to enter that all the time...
Also if they can register with your captchas on, I wonder how captcha before posting will help.
If you're getting registrations even with captchas on from spammers, try ReCaptcha extension or pun_stop_bots...
467 2010-09-08 16:27
Re: [Request]Image Verification every Reply Topic (3 replies, posted in PunBB 1.3 extensions)
Hi
Do you mean:
Users need to enter a captcha before posting reply / topic ?
or do you have an example of what you mean (on another site)?
468 2010-09-08 14:13
Re: Country Filter Enhancement Idea For Pun_Approval (5 replies, posted in PunBB 1.3 discussion)
Jürgen wrote:
pun_approval at the moment is either post and registration approval on or off
Did you ever try
Administration » Start » Forums » Edit forum
and the deactivate post approval for each forum .... (it's not most efficient way, but if you do it once it's worth it...)
469 2010-09-08 10:25
Re: [Solved] How change admin/forums.php (3 replies, posted in PunBB 1.3 discussion)
Cool, what did your code look like in the end?
470 2010-09-08 06:43
Re: Colored Usergroup bug; User Name Doesn't Show Anymore (16 replies, posted in PunBB 1.3 troubleshooting)
Thanks added the bug to trac
http://punbb.informer.com/trac/ticket/357
471 2010-09-08 06:29
Re: [Solved] How change admin/forums.php (3 replies, posted in PunBB 1.3 discussion)
I think you need to do something with
ob_start
//the code you don't want
ob_end_clean()
http://ch2.php.net/manual/en/function.ob-start.php
and/or
str_replace (old, new, ...)
472 2010-09-08 06:06
Re: Colored Usergroup bug; User Name Doesn't Show Anymore (16 replies, posted in PunBB 1.3 troubleshooting)
Which extension does that?
Can you uninstall/reinstall your extensions until you find the one causing problems?
473 2010-09-07 22:00
Re: 404 extention? (1 replies, posted in PunBB 1.3 extensions)
davepc wrote:
Is there a 404 extension? Redirect to the search page say.
I've never seen one...
Let us now if you make one yourself... sounds useful.
474 2010-09-07 15:23
Re: [Style Release] - All Released Styles By Rasel Ahmed (3 replies, posted in PunBB 1.3 additions)
Very nice overview of your styles at one glance on your page:
Nice job!
PS: portfolio not portfilo... 
475 2010-09-07 08:41
Re: [release] Impoved online list (61 replies, posted in PunBB 1.3 extensions)
Can you try this one