Hi,
I think there are two bugs in Activity Plugin::
FIRST:
when I try to update scores from ACP panel it give me an SQL error:
ACP --> Extra Settings --> Scores update
Quote:
SQL ERROR [ mysql4 ]
Table 'ip_scores_fixer' already exists [1050]
SQL
CREATE TABLE ip_scores_fixer (`game_name` varchar(255) default NULL, `player` varchar(40) default NULL, `score` FLOAT(10,2) DEFAULT '0' NOT NULL, `date` int(11) default NULL)
BACKTRACE
FILE: includes/db/mysql.php
LINE: 295
CALL: sql_db->sql_error()
FILE: plugins/activity/adm/admin_ina_xtras.php
LINE: 1385
CALL: sql_db->sql_query()
I tried deleting the table ip_score_fixer said that already existed, and I did update again: it give me another SQL error and practically all the scores records are cleared.
Quote:
SQL ERROR [ mysql4 ]
Column count doesn't match value count at row 1 [1136]
SQL
INSERT INTO ip_ina_scores VALUES ('2deep', 'Kiu', '1.00', '0')
BACKTRACE
FILE: includes/db/mysql.php
LINE: 295
CALL: sql_db->sql_error()
FILE: plugins/activity/adm/admin_ina_xtras.php
LINE: 1424
CALL: sql_db->sql_query()
SECOND:
In the category page there is no link to access the games. (see screenshoot)
