Advanced search  

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Pages: [1]   Go Down

Author Topic: 2 unnecessary fields are added to the tables  (Read 4517 times)

0 Members and 1 Guest are viewing this topic.

Andi

  • VIP
  • Coppermine regular visitor
  • ***
  • Offline Offline
  • Gender: Male
  • Posts: 85
  • Join the Future
    • www.pragmamx.org
2 unnecessary fields are added to the tables
« on: August 22, 2004, 03:38:23 pm »

Hello :)

Version 1.3.2

In update.sql 2 (apparent) unnecessary fields are added to the tables.
Not surely perhaps already for version 1.4?

line # 209
ALTER TABLE `CPG_pictures` ADD `lasthit_ip` TINYTEXT ;
line # 215
ALTER TABLE `CPG_users` ADD `user_favpics` TEXT ;

I think this 2 fields are not used in v1.3.2 ?
Logged
hope, I could help you... :)

lamama

  • Contributor
  • Coppermine frequent poster
  • ***
  • Offline Offline
  • Gender: Male
  • Posts: 404
Re: 2 unnecessary fields are added to the tables
« Reply #1 on: December 02, 2004, 10:27:46 am »

No answer since August?

I have a question that goes the same direction:
- is the field lasthit_ip already used for something inside 1.3.2 (or probalby 1.4),
- can it be used it for some 1.3.2-hack (actually: write the users ip here) or will this crash with some future use?

Logged

Nibbler

  • Guest
Re: 2 unnecessary fields are added to the tables
« Reply #2 on: December 02, 2004, 12:11:29 pm »

lasthit_ip is used to store the last ip to see that picture, that's why it is full of ip addresses. You can see them in the lasthits meta album. user_favpics shouldn't be there, and has its own table as of 1.4
Logged
Pages: [1]   Go Up
 

Page created in 0.019 seconds with 20 queries.