[New Topic]   [Reply]
[Edit Profile]  [Edit Your Preferences]  [Search]
[Private Messages]  [Memberslist]  [FAQ]  [Login]
MUDII Forum Index General Technical Questions Another BB bug (sorry foddy :E) v2.0
Author Another BB bug (sorry foddy :E) v2.0
Eric
cleric

Joined: Aug 19, 2001
Posts: 134
From: Liverpool
Posted: 01-09-2001 16:28   
On the General chat, djs spam post is at the bottom, when it was the one updated most recently. Could it be the date doing this?

  View Profile of Eric   Goto the website of Eric   ICQ status           Edit/Delete This Post   Reply with quote
Foddy
Arch-Wizard



Joined: Aug 19, 2001
Posts: 138
Posted: 01-09-2001 22:01   
Quote:

On 01-09-2001 16:28, Eric wrote:
On the General chat, djs spam post is at the bottom, when it was the one updated most recently. Could it be the date doing this?


Eric,

Yet another bit of shoddy coding - the times are stored in the database as varchars instead of datetime or timestamps. Someone asked me to change the date formats from Y-m-d to d-m-Y ... which caused this problem.

I've put an extra field in the topics table and sorted on that, so all should be well (hacked) now.

I also spotted another security bug. The sooner I dump phpBB1, the better.

Thanks for pointing it out,

Foddy


  View Profile of Foddy      Edit/Delete This Post   Reply with quote
Foddy
Arch-Wizard



Joined: Aug 19, 2001
Posts: 138
Posted: 01-09-2001 22:12   
Quote:

I also spotted another security bug. The sooner I dump phpBB1, the better.


I should point out that this bug doesn't affect us - it would only be a security hole if we were using a different database.

The forum database user is also restricted to accessing the phpBB database, so even if it was a problem, the administration database would remain safe.

I hope this makes sense,

Foddy


  View Profile of Foddy      Edit/Delete This Post   Reply with quote
Theman
cleric

Joined: Aug 31, 2001
Posts: 167
From: My chair
Posted: 02-09-2001 12:54   
Umm...ehh..well as long as you understand then I'm happy...

  View Profile of Theman   Email Theman      Edit/Delete This Post   Reply with quote
Marmite
cabalist

Joined: Sep 12, 2001
Posts: 49
Posted: 17-09-2001 08:24   
What database do you use, mySql?

  View Profile of Marmite      Edit/Delete This Post   Reply with quote
Foddy
Arch-Wizard



Joined: Aug 19, 2001
Posts: 138
Posted: 18-09-2001 21:19   
Quote:

On 17-09-2001 08:24, Marmite wrote:
What database do you use, mySql?


Yup, phpbb only works with mySql, it seems. It's not a problem, it's just shoddy code.

Foddy


  View Profile of Foddy      Edit/Delete This Post   Reply with quote
[New Topic]   [Reply]
Lock this Topic Move this Topic Delete this Topic

These forums may be read by anyone, but only registered mudII.co.uk
players may post. When posting, please refrain from behaviour
not tolerated in the game.

These forums are moderated.

Powered by phpBB
Copyright © 2000 - 2001 The phpBB Group

phpBB Created this page in 0.011794 seconds.