Site Help
View Members link not working
the link is here http://tofu.guildlaunch.com/rapid_raid/members.php?gid=1284&raidId=696
"select `vre`.`guild_id` AS `guild_id`,`cp`.`character_id` AS `character_id`,`cp`.`character_name` AS `character_name`, `cp`.`hier_1` AS `hier_1`,`cp`.`hier_2` AS `hier_2`,`cp`.`hier_3` AS `hier_3`,`cp`.`hier_4` AS `hier_4`,`cp`.`level` AS `level`, `vre`.`total` AS `total`,ifnull(`vrs`.`spent`,0) AS `spent`,(`vre`.`total` - ifnull(`vrs`.`spent`,0)) AS `current`, (select sql_no_cache max(`vrecd`.`date`) AS `max(vrecd.date)` from `guild_launch`.`uv_raid_event_character_detail` `vrecd` where ((`vre`.`guild_id` = `vrecd`.`guild_id` and vre.guild_id = 1284) and (`vre`.`character_id` = `vrecd`.`character_id`))) AS `last_raid`,`vrecad`.`raids_attended_30` AS `raids_attended_30`, `vrecad`.`raids_attended_60` AS `raids_attended_60`,`vrecad`.`total_events30` AS `guild_total_events30`,`vrecad`.`total_events60` AS ` guild_total_events60`, ((`vrecad`.`raids_attended_30` / `vrecad`.`total_events30`) * 100) AS `attendance_30`, ((`vrecad`.`raids_attended_60` / `vrecad`.`total_events60`) * 100) AS `attendance_60` from (((`guild_launch`.`character_profile` `cp` join `guild_launch`.`uv_rm_earned` `vre`) join `guild_launch`.`uv_rm_spent` `vrs`) join ` guild_launch`.`uv_raid_event_character_attendance_detail` `vrecad`) where ((`vre`.`guild_id` = `vrecad`.`guild_id` and vre.guild_id = 1284) and (`vre`.`guild_id` = `vrs`.`guild_id`) and (`cp`.`character_id` = `vre`.`character_id`) and (`vre`.`character_id` = `vrecad`.`character_id`) and (`vre`.`character_id` = `vrs`.`character_id`)) group by character_id order by 2 asc SELECT command denied to user 'bob_the_dwarf'@'10.30.0.2' for table 'uv_raid_event_character_attendance_detail'"
not sure if it is related, but it happens after I give dkp to unclaimed characters
"select `vre`.`guild_id` AS `guild_id`,`cp`.`character_id` AS `character_id`,`cp`.`character_name` AS `character_name`, `cp`.`hier_1` AS `hier_1`,`cp`.`hier_2` AS `hier_2`,`cp`.`hier_3` AS `hier_3`,`cp`.`hier_4` AS `hier_4`,`cp`.`level` AS `level`, `vre`.`total` AS `total`,ifnull(`vrs`.`spent`,0) AS `spent`,(`vre`.`total` - ifnull(`vrs`.`spent`,0)) AS `current`, (select sql_no_cache max(`vrecd`.`date`) AS `max(vrecd.date)` from `guild_launch`.`uv_raid_event_character_detail` `vrecd` where ((`vre`.`guild_id` = `vrecd`.`guild_id` and vre.guild_id = 1284) and (`vre`.`character_id` = `vrecd`.`character_id`))) AS `last_raid`,`vrecad`.`raids_attended_30` AS `raids_attended_30`, `vrecad`.`raids_attended_60` AS `raids_attended_60`,`vrecad`.`total_events30` AS `guild_total_events30`,`vrecad`.`total_events60` AS ` guild_total_events60`, ((`vrecad`.`raids_attended_30` / `vrecad`.`total_events30`) * 100) AS `attendance_30`, ((`vrecad`.`raids_attended_60` / `vrecad`.`total_events60`) * 100) AS `attendance_60` from (((`guild_launch`.`character_profile` `cp` join `guild_launch`.`uv_rm_earned` `vre`) join `guild_launch`.`uv_rm_spent` `vrs`) join ` guild_launch`.`uv_raid_event_character_attendance_detail` `vrecad`) where ((`vre`.`guild_id` = `vrecad`.`guild_id` and vre.guild_id = 1284) and (`vre`.`guild_id` = `vrs`.`guild_id`) and (`cp`.`character_id` = `vre`.`character_id`) and (`vre`.`character_id` = `vrecad`.`character_id`) and (`vre`.`character_id` = `vrs`.`character_id`)) group by character_id order by 2 asc SELECT command denied to user 'bob_the_dwarf'@'10.30.0.2' for table 'uv_raid_event_character_attendance_detail'"
not sure if it is related, but it happens after I give dkp to unclaimed characters
