

UPDATE vcard_setting SET value='2.8' WHERE varname='vcardversion' ;

UPDATE vcard_template SET title='unavailablepage' WHERE title='unavaiablepage' ;



ALTER TABLE vcard_stats DROP card_stamp ;

ALTER TABLE vcard_stats DROP card_background ;

ALTER TABLE vcard_stats DROP card_poem ;

ALTER TABLE vcard_stats DROP card_sound ;

ALTER TABLE vcard_cards ADD hits INT( 11 ) UNSIGNED NOT NULL ;

ALTER TABLE vcard_category ADD hits INT( 11 ) UNSIGNED NOT NULL ;

ALTER TABLE vcard_pattern ADD hits INT( 11 ) UNSIGNED NOT NULL ;

ALTER TABLE vcard_poem ADD hits INT( 11 ) UNSIGNED NOT NULL ;

ALTER TABLE vcard_sound ADD hits INT( 11 ) UNSIGNED NOT NULL ;

ALTER TABLE vcard_stamp ADD hits INT( 11 ) UNSIGNED NOT NULL ;



INSERT INTO vcard_setting (setting_id,settinggroup_id,varname,value,optioncode,displayorder) VALUES (NULL,'8','gallery_toplist_usetotal','1','yesno','1');



UPDATE vcard_setting SET displayorder='1' WHERE varname='online_users' ;

UPDATE vcard_setting SET displayorder='2' WHERE varname='gallery_toplist_allow' ;

UPDATE vcard_setting SET displayorder='3' WHERE varname='gallery_toplist_value' ;

UPDATE vcard_setting SET displayorder='4' WHERE varname='gallery_toplist_usetotal' ;

UPDATE vcard_setting SET displayorder='5' WHERE varname='gallery_random' ;

UPDATE vcard_setting SET displayorder='6' WHERE varname='gallery_newlist_value' ;

UPDATE vcard_setting SET displayorder='7' WHERE varname='site_new_days' ;

UPDATE vcard_setting SET displayorder='8' WHERE varname='gallery_thm_width' ;

UPDATE vcard_setting SET displayorder='9' WHERE varname='gallery_thm_height' ;

UPDATE vcard_setting SET displayorder='10' WHERE varname='gallery_thm_per_page' ;

UPDATE vcard_setting SET displayorder='11' WHERE varname='gallery_table_width' ;

UPDATE vcard_setting SET displayorder='12' WHERE varname='gallery_table_cols' ;

