forum.coppermine-gallery.net

Support => cpg1.3.x Support => Older/other versions => cpg1.3 Miscellaneous => Topic started by: Andi on August 22, 2004, 03:38:23 pm

Title: 2 unnecessary fields are added to the tables
Post by: Andi 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 ?

Title: Re: 2 unnecessary fields are added to the tables
Post by: lamama 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?

Title: Re: 2 unnecessary fields are added to the tables
Post by: Nibbler 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