1 Topic by play75010

(2 replies, posted in Programming)

Hello,

Sorry to trouble you but I just cannot find a solution for a pretty straightforward SQL request I want to add in extern.php

I want to have a the last records for a set of records.

if I have the following table

idx   relate_idx    creation
1          2             3
2          3             2
3          2             1
4          4             4
5          2             5

I would like to sort my request according to the time AND to relate_idx but with only the last record (according to the time) in the relate_idx series.

so that the result would be

idx   relate_idx    creation
5          2              5
4          4              4
2          3              2

Hope this is clear. Once again sorry if this sounds basic to you but I just cannot find out how to make the SQL request.

Go to forum: Programming

2 Reply by play75010

(23 replies, posted in PunBB 1.2 discussion)

OK. OK. I see. Here is a warning from the CERT dating 2000 ! http://www.cert.org/advisories/CA-2000-02.html

Oh dear. By bye customization.

So it means that on myspace, people can do whatever they want since they can include any code they want. I really wonder how this has not lead to a major security catastrophy.

I thought I had the key to customizing my users profiles and posts. Need to think about something else I guess. One user has already done a copy/paste of a <object> from a music website and is complaining that it's not playing.

Go to forum: PunBB 1.2 discussion

3 Reply by play75010

(23 replies, posted in PunBB 1.2 discussion)

OK. Thanks for your replies.

So, if <script> is NOT allowed, then, there should be no security issue ? Is that all I should not allow ?

Well, as for liquidatOr, the big difference is that users just need to do a cut/paste from YouTube of the <object><embed... to their post. As a techie myself, I thought that the [youtube] solution was quite good, but believe me it is not obvious for MOST people. And when I see what people can do on myspace, I really wonder how they manage.

Go to forum: PunBB 1.2 discussion

4 Topic by play75010

(23 replies, posted in PunBB 1.2 discussion)

Hello,

I'm using PunBB1.2.14 and HTML mod.

Basically, I want the users of my website to add simple HTML code, YouTube videos, linked MP3s and linked images.

I run PunBB as a hidden forum meaning that users will see posts as being part of a user's profile. So if the user screws up his/her HTML, well it's not a problem for me.

From what I can see, allowing HTML within posts is completely safe (appart from the possible screwing up of pages). But is that entirely true ?

PS: [youtube]...[/youtube], [google, etc. are already in place but the users of my website just don't understand how to use them. So allowing copy/paste <embed> and <object> is the only solution I can think of.

Go to forum: PunBB 1.2 discussion

5 Topic by play75010

(3 replies, posted in PunBB 1.2 troubleshooting)

Hello.

I'm using Punbb and have about 300 users using the forum. All my website is actually based on punbb authentification.

Everything works fine except for a very small number of users.

They have created an account and have logged in at least once.

But ! When they try to login again, it seems that the password hash doesn't correspond to the password they have used (I've saved a clear version of the password as a separate new field). If I try to rehash their password with punbb's algorithm, I get a completely different hash string. If I change the password hash with the newly created hash string, they can login again.

I have no idea why and on which condition this is happening.

Any idea ?

Go to forum: PunBB 1.2 troubleshooting

6 Topic by play75010

(9 replies, posted in PunBB 1.2 modifications, plugins and integrations)

Hello.

I'm looking for a nice chat mod which would integrate nicely with my current punbb data. The chat would not only allow everybody who's online to chat together but would also allow one to one chat.

I've checked and installed several chat scripts and mods but none of them seems to do the trick.

The most relevant I've tested was PBB ChatBox which is written in AJAX but only seems to allow global chat and not one to one chat although it integrates nicely with PunBB.

I've followed several posts but, from my understanding, most of them are based on an IRC like mod which would seem (I might be wrong) to demand quite a lot of work to be integrated so that IRC commands are hidden for a non techie interface.

Can you please help me on that one. Or maybe we could give a state of the art regarding existing chatroom solutions.

Go to forum: PunBB 1.2 modifications, plugins and integrations

7 Reply by play75010

(10 replies, posted in PunBB 1.2 discussion)

OK. No worries. I was just trying to contribute.

In my last job, my code would have been automatically rejected if "if" statements were not surrounded by '{' and I've seen numerous situations where it made sense especially when several people worked on the same code.

Go to forum: PunBB 1.2 discussion

8 Topic by play75010

(10 replies, posted in PunBB 1.2 discussion)

Hello.

I'm discovering the code of punbb and I've just installed a mod.

It seems that the code would be much better if all "if" statements had a '{' after even if there is only one line after and then a "else" statement.

I know it is not a bug but this could:
1) enhance code readability
2) mod insertion (for example, if you need to add a line for a mod after a "if" statement and want to keep the original as a comment, then it is much better to have a '{' before and '}' after, isn't it ?)

I have been working as a programmer for more than 10 years and I can tell you that this is absolutely essential.

Also, please note that in most programming guides or code rules, you will find that the '{' is on the same line as the "if" or "else" statement. This is the de facto standard.

Hope this will help.

EDIT: Moved

Go to forum: PunBB 1.2 discussion