26 Reply by ollyno1uk

(11 replies, posted in Programming)

Excellent! I am pleased that you found a solution!

Go to forum: Programming

27 Reply by ollyno1uk

(11 replies, posted in Programming)

I do not have openoffice on this PC but if you do not get any joy then let me know as I do have it on my home PC that I will be on tomorrow! big_smile

Go to forum: Programming

28 Reply by ollyno1uk

(11 replies, posted in Programming)

I think if you are in Excel you can change to a custom field specifying exactly what I put above and it will convert all your dates to this format(I think)

Go to forum: Programming

29 Reply by ollyno1uk

(11 replies, posted in Programming)

yes it doesn't matter that it doesn't know it is a date though it does need to be in the datetime format which is

YYYY-MM-DD HH:MM:SS

So you need to really format your spreadsheet to accommodate the date looking exactly like that, or if you have to have your date as per your past examples you will have to store them as a string which will need the '' or "" around it!

Hope this helps!

Go to forum: Programming

30 Reply by ollyno1uk

(11 replies, posted in Programming)

yes then you may find you need to include the time as well

so

2010-08-19 00:00:00

Though I am not sure if you could get away with just the date part

Go to forum: Programming

31 Reply by ollyno1uk

(8 replies, posted in PunBB 1.3 discussion)

I think you would need 

$mail_message = str_replace('<user_ip>', $user_info['registration_ip'], $mail_message);

This will look for <user_ip> in the mail template and will replace with the IP address.

Is this what you wanted?

Go to forum: PunBB 1.3 discussion

32 Reply by ollyno1uk

(11 replies, posted in Programming)

If you have selected date as the format for your table then it needs to be in this format


2010-08-19

you other issue is because strings need to be enclosed by ""

Hope this helps!

Go to forum: Programming

33 Reply by ollyno1uk

(35 replies, posted in PunBB 1.3 extensions)

ah excellent - thanks!

Go to forum: PunBB 1.3 extensions

34 Reply by ollyno1uk

(35 replies, posted in PunBB 1.3 extensions)

How do you get the code in those nice colours?

Go to forum: PunBB 1.3 extensions

35 Reply by ollyno1uk

(35 replies, posted in PunBB 1.3 extensions)

I managed to combine the two mods to get this working. Please test at your own risk

http://forums.ollysguitar.com/mp3tag.zip

Go to forum: PunBB 1.3 extensions

36 Reply by ollyno1uk

(35 replies, posted in PunBB 1.3 extensions)

I'm going to guess that it is almost certainly this section though I have not tested it yet. Will do so shorty and report back

<hook id="ps_start"><![CDATA[
 
// tag handling function
function handle_video_tag($videoUri) {
    global $forum_config;
    $match = array();
 
    // dirty trick to play arround do_clickable
    preg_match('`href="([^"]+)"`', stripslashes($videoUri), $match);
    if(!empty($match[1])) {
        $videoUri = $match[1];
    }
}
 
        ]]></hook>

and

<hook id="ps_do_bbcode_replace"><![CDATA[
 
// add pattern to catch [video]blahblah[/video]
$pattern[] = '`\[video\]([^\[]+)\[/video\]`e';
$replace[] = 'handle_video_tag(\'$1\')';
 
        ]]></hook>

Go to forum: PunBB 1.3 extensions

37 Reply by ollyno1uk

(41 replies, posted in PunBB 1.3 extensions)

Ok, I have managed to accomplish a few things.

Firstly, the confusing first line that looks to be in Russian can be changed in data/chat.dat to something more fitting.

There is then an option within each user profile to expand or retract the chat box for those who do not want it taking up the whole of the top of their forum.

I managed to move mine to the bottom of the forum nicely. To do this I uninstalled the extension and  edited this (around line 136) on manifest.xml

<hook id="in_main_output_start">

to

<hook id="in_info_output_start">

Hope this helps someone

Go to forum: PunBB 1.3 extensions

38 Reply by ollyno1uk

(41 replies, posted in PunBB 1.3 extensions)

Ah perhaps that is what threw me in the first instance! I did change the language file with success but I do not like how much of the top of my forum it takes up..

I will try to understand the code more and maybe I can move it to the bottom of the forum!

Thanks for your prompt reply - I see you are very active with Punbb which is great to see!

Go to forum: PunBB 1.3 extensions

39 Reply by ollyno1uk

(41 replies, posted in PunBB 1.3 extensions)

Hi there

This does work for me though I would like to know two things:

1. - How to change from Russian to English?

2. - I would prefer the chat to be at the bottom of the forum and not the top - is this possible?

Thanks a lot for a great extension

Go to forum: PunBB 1.3 extensions

40 Reply by ollyno1uk

(8 replies, posted in PunBB 1.3 extensions)

Thanks! That is reassuring!

I look forward to hearing about your extensions! I'm already very intrigued!

All the best!

Olly

Go to forum: PunBB 1.3 extensions

41 Reply by ollyno1uk

(8 replies, posted in PunBB 1.3 extensions)

Hi bedroom

Thanks a lot for the quick reply.

I have done this and I get no warnings although I personally do not get any new posts so I am unsure if it working or not at the moment.

Have you done any other extensions at all? If so, do you have a list? It is nice to see someone still active around here!

Go to forum: PunBB 1.3 extensions

42 Reply by ollyno1uk

(8 replies, posted in PunBB 1.3 extensions)

Hi there

I have been looking for something like this however on installing I get this error - can you help?

Warning: Missing argument 4 for DBLayer::add_field(), called in /var/www/vhosts/ollysguitar.com/subdomains/forums/httpdocs/admin/extensions.php(176) : eval()'d code on line 3 and defined in /var/www/vhosts/ollysguitar.com/subdomains/forums/httpdocs/include/dblayer/mysqli.php on line 364

Go to forum: PunBB 1.3 extensions

43 Reply by ollyno1uk

(76 replies, posted in PunBB 1.3 extensions)

Actually I got it resolved by creating a file called sitemap.xml and changing the permissions to 777 then it now works.

Go to forum: PunBB 1.3 extensions

44 Reply by ollyno1uk

(85 replies, posted in Supported extensions)

Hi there

I seem have an issue with the latest version.

Firstly it would seem that when I approve posts for some reason the post count stays at zero?

Also I am trying to approve a post and I get this:

The error occurred on line 1506 in /var/www/vhosts/domain.com/subdomains/forums/httpdocs/extensions/pun_approval/functions.php

Database reported: 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 '' at line 1 (Errno: 1064).

Any ideas?

Thanks a lot

Go to forum: Supported extensions

45 Reply by ollyno1uk

(76 replies, posted in PunBB 1.3 extensions)

Hi there

Does this work with the latest version? I have isntalled today and hoped to find something like this extension however when I install I get

"Could not create sitemap.xml on forum root."

Any ideas would be gratefully received.

Cheers

Olly

Go to forum: PunBB 1.3 extensions