Scratch

I was just replying to comments on my projects, and I got this weird message:

Warning (512): SQL Error: 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 't[ \t\n\r\f\v]*play[ \t\n\r\f\v]*roblox.[ \t\n\r\f\v]*:/' AND `Pcomment`.`create' at line 1 [CORE/cake/libs/model/datasources/dbo_source.php, line 512]

Code | Context

$sql    =    "SELECT `Pcomment`.`id`, `Pcomment`.`project_id`, `Pcomment`.`user_id`, `Pcomment`.`content`, `Pcomment`.`visibility`, `Pcomment`.`timestamp`, `Pcomment`.`reply_to_id`, `Pcomment`.`created`, `Pcomment`.`reply_to`, `Pcomment`.`comment_visibility`, `User`.`id`, `User`.`username`, `User`.`villager`, `User`.`firstname`, `User`.`lastname`, `User`.`gender`, `User`.`urlname`, `User`.`role`, `User`.`email`, `User`.`password`, `User`.`buddyicon`, `User`.`organization`, `User`.`city`, `User`.`created`, `User`.`timestamp`, `User`.`state`, `User`.`country`, `User`.`hearabout`, `User`.`interestsabout`, `User`.`comments`, `User`.`bmonth`, `User`.`byear`, `User`.`notify_pcomment`, `User`.`notify_gcomment`, `User`.`ipaddress`, `User`.`status`, `User`.`blocked_till`, `User`.`userpicext`, `User`.`userpic_suffix`, `User`.`login_attempt`, `Project`.`id`, `Project`.`user_id`, `Project`.`name`, `Project`.`description`, `Project`.`rating`, `Project`.`views`, `Project`.`anonviews`, `Project`.`num_favoriters`, `Project`.`num_raters`, `Project`.`created`, `Project`.`modified`, `Project`.`timestamp`, `Project`.`loveit`, `Project`.`loveitsuniqueip`, `Project`.`num_bookmarks`, `Project`.`version`, `Project`.`flagit`, `Project`.`numberOfSprites`, `Project`.`totalScripts`, `Project`.`has_sound_blocks`, `Project`.`has_sensorboard_blocks`, `Project`.`related_project_id`, `Project`.`based_on_pid`, `Project`.`root_based_on_pid`, `Project`.`related_username`, `Project`.`proj_visibility`, `Project`.`vischangedbyid`, `Project`.`vischangedtime`, `Project`.`safe`, `Project`.`status`, `Project`.`locked`, `Project`.`remixes`, `Project`.`remixer`, `Project`.`upload_ip`, `Project`.`country`, `Project`.`scratch_version_date` FROM `pcomments` AS `Pcomment` LEFT JOIN `users` AS `User` ON (`Pcomment`.`user_id` = `User`.`id`) LEFT JOIN `projects` AS `Project` ON (`Pcomment`.`project_id` = `Project`.`id`)  WHERE (proj_visibility='visible' OR proj_visibility='censbycomm' OR proj_visibility='censbyadmin')AND `Pcomment`.`content` RLIKE 'Erm,[ \t\n\r\f\v]*I[ \t\n\r\f\v]*don't[ \t\n\r\f\v]*play[ \t\n\r\f\v]*roblox.[ \t\n\r\f\v]*:/' AND `Pcomment`.`created` > now() - interval 3  day AND `Pcomment`.`user_id` = 80131   "
$error    =    "1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 't[ \t\n\r\f\v]*play[ \t\n\r\f\v]*roblox.[ \t\n\r\f\v]*:/' AND `Pcomment`.`create' at line 1"
$out    =    null

            $out = null;
            if ($error) {
                trigger_error("<span style = \"color:Red;text-align:left\"><b>SQL Error:</b> {$this->error}</span>", E_USER_WARNING);

DboSource::showQuery() - CORE/cake/libs/model/datasources/dbo_source.php, line 512
DboSource::execute() - CORE/cake/libs/model/datasources/dbo_source.php, line 202
DboSource::fetchAll() - CORE/cake/libs/model/datasources/dbo_source.php, line 338
DboSource::read() - CORE/cake/libs/model/datasources/dbo_source.php, line 627
Model::find() - CORE/cake/libs/model/model.php, line 1795
Pcomment::find() - APP/models/pcomment.php, line 12
Model::findAll() - CORE/cake/libs/model/model.php, line 2631
Pcomment::findAll() - APP/models/pcomment.php, line 23
ProjectsController::comment_reply() - APP/controllers/projects_controller.php, line 2845
Object::dispatchMethod() - CORE/cake/libs/object.php, line 118
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 256
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 230
[main] - APP/webroot/index.php, line 91

Query: SELECT `Pcomment`.`id`, `Pcomment`.`project_id`, `Pcomment`.`user_id`, `Pcomment`.`content`, `Pcomment`.`visibility`, `Pcomment`.`timestamp`, `Pcomment`.`reply_to_id`, `Pcomment`.`created`, `Pcomment`.`reply_to`, `Pcomment`.`comment_visibility`, `User`.`id`, `User`.`username`, `User`.`villager`, `User`.`firstname`, `User`.`lastname`, `User`.`gender`, `User`.`urlname`, `User`.`role`, `User`.`email`, `User`.`password`, `User`.`buddyicon`, `User`.`organization`, `User`.`city`, `User`.`created`, `User`.`timestamp`, `User`.`state`, `User`.`country`, `User`.`hearabout`, `User`.`interestsabout`, `User`.`comments`, `User`.`bmonth`, `User`.`byear`, `User`.`notify_pcomment`, `User`.`notify_gcomment`, `User`.`ipaddress`, `User`.`status`, `User`.`blocked_till`, `User`.`userpicext`, `User`.`userpic_suffix`, `User`.`login_attempt`, `Project`.`id`, `Project`.`user_id`, `Project`.`name`, `Project`.`description`, `Project`.`rating`, `Project`.`views`, `Project`.`anonviews`, `Project`.`num_favoriters`, `Project`.`num_raters`, `Project`.`created`, `Project`.`modified`, `Project`.`timestamp`, `Project`.`loveit`, `Project`.`loveitsuniqueip`, `Project`.`num_bookmarks`, `Project`.`version`, `Project`.`flagit`, `Project`.`numberOfSprites`, `Project`.`totalScripts`, `Project`.`has_sound_blocks`, `Project`.`has_sensorboard_blocks`, `Project`.`related_project_id`, `Project`.`based_on_pid`, `Project`.`root_based_on_pid`, `Project`.`related_username`, `Project`.`proj_visibility`, `Project`.`vischangedbyid`, `Project`.`vischangedtime`, `Project`.`safe`, `Project`.`status`, `Project`.`locked`, `Project`.`remixes`, `Project`.`remixer`, `Project`.`upload_ip`, `Project`.`country`, `Project`.`scratch_version_date` FROM `pcomments` AS `Pcomment` LEFT JOIN `users` AS `User` ON (`Pcomment`.`user_id` = `User`.`id`) LEFT JOIN `projects` AS `Project` ON (`Pcomment`.`project_id` = `Project`.`id`) WHERE (proj_visibility='visible' OR proj_visibility='censbycomm' OR proj_visibility='censbyadmin')AND `Pcomment`.`content` RLIKE 'Erm,[ \t\n\r\f\v]*I[ \t\n\r\f\v]*don't[ \t\n\r\f\v]*play[ \t\n\r\f\v]*roblox.[ \t\n\r\f\v]*:/' AND `Pcomment`.`created` > now() - interval 3 day AND `Pcomment`.`user_id` = 80131

Warning (512): SQL Error: 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 't play roblox. :/' AND `Pcomment`.`reply_to`!= -100    LIMIT 1' at line 1 [CORE/cake/libs/model/datasources/dbo_source.php, line 512]

Code | Context

$sql    =    "SELECT `Pcomment`.`id`, `Pcomment`.`project_id`, `Pcomment`.`user_id`, `Pcomment`.`content`, `Pcomment`.`visibility`, `Pcomment`.`timestamp`, `Pcomment`.`reply_to_id`, `Pcomment`.`created`, `Pcomment`.`reply_to`, `Pcomment`.`comment_visibility`, `User`.`id`, `User`.`username`, `User`.`villager`, `User`.`firstname`, `User`.`lastname`, `User`.`gender`, `User`.`urlname`, `User`.`role`, `User`.`email`, `User`.`password`, `User`.`buddyicon`, `User`.`organization`, `User`.`city`, `User`.`created`, `User`.`timestamp`, `User`.`state`, `User`.`country`, `User`.`hearabout`, `User`.`interestsabout`, `User`.`comments`, `User`.`bmonth`, `User`.`byear`, `User`.`notify_pcomment`, `User`.`notify_gcomment`, `User`.`ipaddress`, `User`.`status`, `User`.`blocked_till`, `User`.`userpicext`, `User`.`userpic_suffix`, `User`.`login_attempt`, `Project`.`id`, `Project`.`user_id`, `Project`.`name`, `Project`.`description`, `Project`.`rating`, `Project`.`views`, `Project`.`anonviews`, `Project`.`num_favoriters`, `Project`.`num_raters`, `Project`.`created`, `Project`.`modified`, `Project`.`timestamp`, `Project`.`loveit`, `Project`.`loveitsuniqueip`, `Project`.`num_bookmarks`, `Project`.`version`, `Project`.`flagit`, `Project`.`numberOfSprites`, `Project`.`totalScripts`, `Project`.`has_sound_blocks`, `Project`.`has_sensorboard_blocks`, `Project`.`related_project_id`, `Project`.`based_on_pid`, `Project`.`root_based_on_pid`, `Project`.`related_username`, `Project`.`proj_visibility`, `Project`.`vischangedbyid`, `Project`.`vischangedtime`, `Project`.`safe`, `Project`.`status`, `Project`.`locked`, `Project`.`remixes`, `Project`.`remixer`, `Project`.`upload_ip`, `Project`.`country`, `Project`.`scratch_version_date` FROM `pcomments` AS `Pcomment` LEFT JOIN `users` AS `User` ON (`Pcomment`.`user_id` = `User`.`id`) LEFT JOIN `projects` AS `Project` ON (`Pcomment`.`project_id` = `Project`.`id`)  WHERE `Pcomment`.`project_id` = 1966591 AND `Pcomment`.`user_id` = 80131 AND `Pcomment`.`content` = 'Erm, I don't play roblox. :/' AND `Pcomment`.`reply_to`!= -100    LIMIT 1"
$error    =    "1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 't play roblox. :/' AND `Pcomment`.`reply_to`!= -100    LIMIT 1' at line 1"
$out    =    null

            $out = null;
            if ($error) {
                trigger_error("<span style = \"color:Red;text-align:left\"><b>SQL Error:</b> {$this->error}</span>", E_USER_WARNING);

DboSource::showQuery() - CORE/cake/libs/model/datasources/dbo_source.php, line 512
DboSource::execute() - CORE/cake/libs/model/datasources/dbo_source.php, line 202
DboSource::fetchAll() - CORE/cake/libs/model/datasources/dbo_source.php, line 338
DboSource::read() - CORE/cake/libs/model/datasources/dbo_source.php, line 627
Model::find() - CORE/cake/libs/model/model.php, line 1795
Pcomment::find() - APP/models/pcomment.php, line 12
ProjectsController::comment_reply() - APP/controllers/projects_controller.php, line 2896
Object::dispatchMethod() - CORE/cake/libs/object.php, line 118
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 256
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 230
[main] - APP/webroot/index.php, line 91

Query: SELECT `Pcomment`.`id`, `Pcomment`.`project_id`, `Pcomment`.`user_id`, `Pcomment`.`content`, `Pcomment`.`visibility`, `Pcomment`.`timestamp`, `Pcomment`.`reply_to_id`, `Pcomment`.`created`, `Pcomment`.`reply_to`, `Pcomment`.`comment_visibility`, `User`.`id`, `User`.`username`, `User`.`villager`, `User`.`firstname`, `User`.`lastname`, `User`.`gender`, `User`.`urlname`, `User`.`role`, `User`.`email`, `User`.`password`, `User`.`buddyicon`, `User`.`organization`, `User`.`city`, `User`.`created`, `User`.`timestamp`, `User`.`state`, `User`.`country`, `User`.`hearabout`, `User`.`interestsabout`, `User`.`comments`, `User`.`bmonth`, `User`.`byear`, `User`.`notify_pcomment`, `User`.`notify_gcomment`, `User`.`ipaddress`, `User`.`status`, `User`.`blocked_till`, `User`.`userpicext`, `User`.`userpic_suffix`, `User`.`login_attempt`, `Project`.`id`, `Project`.`user_id`, `Project`.`name`, `Project`.`description`, `Project`.`rating`, `Project`.`views`, `Project`.`anonviews`, `Project`.`num_favoriters`, `Project`.`num_raters`, `Project`.`created`, `Project`.`modified`, `Project`.`timestamp`, `Project`.`loveit`, `Project`.`loveitsuniqueip`, `Project`.`num_bookmarks`, `Project`.`version`, `Project`.`flagit`, `Project`.`numberOfSprites`, `Project`.`totalScripts`, `Project`.`has_sound_blocks`, `Project`.`has_sensorboard_blocks`, `Project`.`related_project_id`, `Project`.`based_on_pid`, `Project`.`root_based_on_pid`, `Project`.`related_username`, `Project`.`proj_visibility`, `Project`.`vischangedbyid`, `Project`.`vischangedtime`, `Project`.`safe`, `Project`.`status`, `Project`.`locked`, `Project`.`remixes`, `Project`.`remixer`, `Project`.`upload_ip`, `Project`.`country`, `Project`.`scratch_version_date` FROM `pcomments` AS `Pcomment` LEFT JOIN `users` AS `User` ON (`Pcomment`.`user_id` = `User`.`id`) LEFT JOIN `projects` AS `Project` ON (`Pcomment`.`project_id` = `Project`.`id`) WHERE `Pcomment`.`project_id` = 1966591 AND `Pcomment`.`user_id` = 80131 AND `Pcomment`.`content` = 'Erm, I don't play roblox. :/' AND `Pcomment`.`reply_to`!= -100 LIMIT 1 Nr    Query    Error    Affected    Num. rows    Took (ms)
1    SELECT `User`.`status` FROM `users` AS `User` WHERE `User`.`id` = 80131 LIMIT 1        1    1    0
2    SELECT `Pcomment`.`id`, `Pcomment`.`project_id`, `Pcomment`.`user_id`, `Pcomment`.`content`, `Pcomment`.`visibility`, `Pcomment`.`timestamp`, `Pcomment`.`reply_to_id`, `Pcomment`.`created`, `Pcomment`.`reply_to`, `Pcomment`.`comment_visibility`, `User`.`id`, `User`.`username`, `User`.`villager`, `User`.`firstname`, `User`.`lastname`, `User`.`gender`, `User`.`urlname`, `User`.`role`, `User`.`email`, `User`.`password`, `User`.`buddyicon`, `User`.`organization`, `User`.`city`, `User`.`created`, `User`.`timestamp`, `User`.`state`, `User`.`country`, `User`.`hearabout`, `User`.`interestsabout`, `User`.`comments`, `User`.`bmonth`, `User`.`byear`, `User`.`notify_pcomment`, `User`.`notify_gcomment`, `User`.`ipaddress`, `User`.`status`, `User`.`blocked_till`, `User`.`userpicext`, `User`.`userpic_suffix`, `User`.`login_attempt`, `Project`.`id`, `Project`.`user_id`, `Project`.`name`, `Project`.`description`, `Project`.`rating`, `Project`.`views`, `Project`.`anonviews`, `Project`.`num_favoriters`, `Project`.`num_raters`, `Project`.`created`, `Project`.`modified`, `Project`.`timestamp`, `Project`.`loveit`, `Project`.`loveitsuniqueip`, `Project`.`num_bookmarks`, `Project`.`version`, `Project`.`flagit`, `Project`.`numberOfSprites`, `Project`.`totalScripts`, `Project`.`has_sound_blocks`, `Project`.`has_sensorboard_blocks`, `Project`.`related_project_id`, `Project`.`based_on_pid`, `Project`.`root_based_on_pid`, `Project`.`related_username`, `Project`.`proj_visibility`, `Project`.`vischangedbyid`, `Project`.`vischangedtime`, `Project`.`safe`, `Project`.`status`, `Project`.`locked`, `Project`.`remixes`, `Project`.`remixer`, `Project`.`upload_ip`, `Project`.`country`, `Project`.`scratch_version_date` FROM `pcomments` AS `Pcomment` LEFT JOIN `users` AS `User` ON (`Pcomment`.`user_id` = `User`.`id`) LEFT JOIN `projects` AS `Project` ON (`Pcomment`.`project_id` = `Project`.`id`) WHERE `Pcomment`.`id` = 8407167 LIMIT 1        1    1    2
3    SELECT `Project`.`id`, `Project`.`name`, `Project`.`locked`, `User`.`id`, `User`.`urlname` FROM `projects` AS `Project` LEFT JOIN `users` AS `User` ON (`Project`.`user_id` = `User`.`id`) WHERE `Project`.`id` = 1966591 LIMIT 1        1    1    1
4    SELECT `Pcomment`.`id`, `Pcomment`.`project_id`, `Pcomment`.`user_id`, `Pcomment`.`content`, `Pcomment`.`visibility`, `Pcomment`.`timestamp`, `Pcomment`.`reply_to_id`, `Pcomment`.`created`, `Pcomment`.`reply_to`, `Pcomment`.`comment_visibility`, `User`.`id`, `User`.`username`, `User`.`villager`, `User`.`firstname`, `User`.`lastname`, `User`.`gender`, `User`.`urlname`, `User`.`role`, `User`.`email`, `User`.`password`, `User`.`buddyicon`, `User`.`organization`, `User`.`city`, `User`.`created`, `User`.`timestamp`, `User`.`state`, `User`.`country`, `User`.`hearabout`, `User`.`interestsabout`, `User`.`comments`, `User`.`bmonth`, `User`.`byear`, `User`.`notify_pcomment`, `User`.`notify_gcomment`, `User`.`ipaddress`, `User`.`status`, `User`.`blocked_till`, `User`.`userpicext`, `User`.`userpic_suffix`, `User`.`login_attempt`, `Project`.`id`, `Project`.`user_id`, `Project`.`name`, `Project`.`description`, `Project`.`rating`, `Project`.`views`, `Project`.`anonviews`, `Project`.`num_favoriters`, `Project`.`num_raters`, `Project`.`created`, `Project`.`modified`, `Project`.`timestamp`, `Project`.`loveit`, `Project`.`loveitsuniqueip`, `Project`.`num_bookmarks`, `Project`.`version`, `Project`.`flagit`, `Project`.`numberOfSprites`, `Project`.`totalScripts`, `Project`.`has_sound_blocks`, `Project`.`has_sensorboard_blocks`, `Project`.`related_project_id`, `Project`.`based_on_pid`, `Project`.`root_based_on_pid`, `Project`.`related_username`, `Project`.`proj_visibility`, `Project`.`vischangedbyid`, `Project`.`vischangedtime`, `Project`.`safe`, `Project`.`status`, `Project`.`locked`, `Project`.`remixes`, `Project`.`remixer`, `Project`.`upload_ip`, `Project`.`country`, `Project`.`scratch_version_date` FROM `pcomments` AS `Pcomment` LEFT JOIN `users` AS `User` ON (`Pcomment`.`user_id` = `User`.`id`) LEFT JOIN `projects` AS `Project` ON (`Pcomment`.`project_id` = `Project`.`id`) WHERE (proj_visibility='visible' OR proj_visibility='censbycomm' OR proj_visibility='censbyadmin')AND `Pcomment`.`user_id` = 80131 AND `Pcomment`.`created` > now() - interval 2 minute AND `Pcomment`.`project_id` = 1966591         1    1    2
5    SELECT `Pcomment`.`id`, `Pcomment`.`project_id`, `Pcomment`.`user_id`, `Pcomment`.`content`, `Pcomment`.`visibility`, `Pcomment`.`timestamp`, `Pcomment`.`reply_to_id`, `Pcomment`.`created`, `Pcomment`.`reply_to`, `Pcomment`.`comment_visibility`, `User`.`id`, `User`.`username`, `User`.`villager`, `User`.`firstname`, `User`.`lastname`, `User`.`gender`, `User`.`urlname`, `User`.`role`, `User`.`email`, `User`.`password`, `User`.`buddyicon`, `User`.`organization`, `User`.`city`, `User`.`created`, `User`.`timestamp`, `User`.`state`, `User`.`country`, `User`.`hearabout`, `User`.`interestsabout`, `User`.`comments`, `User`.`bmonth`, `User`.`byear`, `User`.`notify_pcomment`, `User`.`notify_gcomment`, `User`.`ipaddress`, `User`.`status`, `User`.`blocked_till`, `User`.`userpicext`, `User`.`userpic_suffix`, `User`.`login_attempt`, `Project`.`id`, `Project`.`user_id`, `Project`.`name`, `Project`.`description`, `Project`.`rating`, `Project`.`views`, `Project`.`anonviews`, `Project`.`num_favoriters`, `Project`.`num_raters`, `Project`.`created`, `Project`.`modified`, `Project`.`timestamp`, `Project`.`loveit`, `Project`.`loveitsuniqueip`, `Project`.`num_bookmarks`, `Project`.`version`, `Project`.`flagit`, `Project`.`numberOfSprites`, `Project`.`totalScripts`, `Project`.`has_sound_blocks`, `Project`.`has_sensorboard_blocks`, `Project`.`related_project_id`, `Project`.`based_on_pid`, `Project`.`root_based_on_pid`, `Project`.`related_username`, `Project`.`proj_visibility`, `Project`.`vischangedbyid`, `Project`.`vischangedtime`, `Project`.`safe`, `Project`.`status`, `Project`.`locked`, `Project`.`remixes`, `Project`.`remixer`, `Project`.`upload_ip`, `Project`.`country`, `Project`.`scratch_version_date` FROM `pcomments` AS `Pcomment` LEFT JOIN `users` AS `User` ON (`Pcomment`.`user_id` = `User`.`id`) LEFT JOIN `projects` AS `Project` ON (`Pcomment`.`project_id` = `Project`.`id`) WHERE (proj_visibility='visible' OR proj_visibility='censbycomm' OR proj_visibility='censbyadmin')AND `Pcomment`.`content` RLIKE 'Erm,[ \t\n\r\f\v]*I[ \t\n\r\f\v]*don't[ \t\n\r\f\v]*play[ \t\n\r\f\v]*roblox.[ \t\n\r\f\v]*:/' AND `Pcomment`.`created` > now() - interval 3 day AND `Pcomment`.`user_id` = 80131     1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 't[ \t\n\r\f\v]*play[ \t\n\r\f\v]*roblox.[ \t\n\r\f\v]*:/' AND `Pcomment`.`create' at line 1            1
6    SELECT COUNT(*) AS `count` FROM `projects` AS `Project` WHERE `Project`.`user_id` = 80131         1    1    1
7    SELECT `Pcomment`.`id`, `Pcomment`.`project_id`, `Pcomment`.`user_id`, `Pcomment`.`content`, `Pcomment`.`visibility`, `Pcomment`.`timestamp`, `Pcomment`.`reply_to_id`, `Pcomment`.`created`, `Pcomment`.`reply_to`, `Pcomment`.`comment_visibility`, `User`.`id`, `User`.`username`, `User`.`villager`, `User`.`firstname`, `User`.`lastname`, `User`.`gender`, `User`.`urlname`, `User`.`role`, `User`.`email`, `User`.`password`, `User`.`buddyicon`, `User`.`organization`, `User`.`city`, `User`.`created`, `User`.`timestamp`, `User`.`state`, `User`.`country`, `User`.`hearabout`, `User`.`interestsabout`, `User`.`comments`, `User`.`bmonth`, `User`.`byear`, `User`.`notify_pcomment`, `User`.`notify_gcomment`, `User`.`ipaddress`, `User`.`status`, `User`.`blocked_till`, `User`.`userpicext`, `User`.`userpic_suffix`, `User`.`login_attempt`, `Project`.`id`, `Project`.`user_id`, `Project`.`name`, `Project`.`description`, `Project`.`rating`, `Project`.`views`, `Project`.`anonviews`, `Project`.`num_favoriters`, `Project`.`num_raters`, `Project`.`created`, `Project`.`modified`, `Project`.`timestamp`, `Project`.`loveit`, `Project`.`loveitsuniqueip`, `Project`.`num_bookmarks`, `Project`.`version`, `Project`.`flagit`, `Project`.`numberOfSprites`, `Project`.`totalScripts`, `Project`.`has_sound_blocks`, `Project`.`has_sensorboard_blocks`, `Project`.`related_project_id`, `Project`.`based_on_pid`, `Project`.`root_based_on_pid`, `Project`.`related_username`, `Project`.`proj_visibility`, `Project`.`vischangedbyid`, `Project`.`vischangedtime`, `Project`.`safe`, `Project`.`status`, `Project`.`locked`, `Project`.`remixes`, `Project`.`remixer`, `Project`.`upload_ip`, `Project`.`country`, `Project`.`scratch_version_date` FROM `pcomments` AS `Pcomment` LEFT JOIN `users` AS `User` ON (`Pcomment`.`user_id` = `User`.`id`) LEFT JOIN `projects` AS `Project` ON (`Pcomment`.`project_id` = `Project`.`id`) WHERE `Pcomment`.`project_id` = 1966591 AND `Pcomment`.`user_id` = 80131 AND `Pcomment`.`content` = 'Erm, I don't play roblox. :/' AND `Pcomment`.`reply_to`!= -100 LIMIT 1    1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 't play roblox. :/' AND `Pcomment`.`reply_to`!= -100 LIMIT 1' at line 1            1
8    INSERT INTO `pcomments` (`id`,`project_id`,`user_id`,`content`,`comment_visibility`,`reply_to`,`created`) VALUES (NULL,1966591,80131,'Erm, I don\'t play roblox. :/','visible',8407167,'2011-08-08 17:18:13')        1        3
9    SELECT LAST_INSERT_ID() AS insertID        1    1    3
10    SELECT COUNT(*) AS `count` FROM `ignored_users` AS `IgnoredUser` LEFT JOIN `users` AS `User` ON (`IgnoredUser`.`user_id` = `User`.`id`) WHERE `IgnoredUser`.`user_id` = 80131 AND (`IgnoredUser`.`blocker_id` = 80131 OR `IgnoredUser`.`blocker_id` = 776830)         1    1    1
11    SELECT `User`.`id`, `User`.`username`, `User`.`villager`, `User`.`firstname`, `User`.`lastname`, `User`.`gender`, `User`.`urlname`, `User`.`role`, `User`.`email`, `User`.`password`, `User`.`buddyicon`, `User`.`organization`, `User`.`city`, `User`.`created`, `User`.`timestamp`, `User`.`state`, `User`.`country`, `User`.`hearabout`, `User`.`interestsabout`, `User`.`comments`, `User`.`bmonth`, `User`.`byear`, `User`.`notify_pcomment`, `User`.`notify_gcomment`, `User`.`ipaddress`, `User`.`status`, `User`.`blocked_till`, `User`.`userpicext`, `User`.`userpic_suffix`, `User`.`login_attempt` FROM `users` AS `User` WHERE `User`.`id` = 776830 LIMIT 1        1    1    0
12    SELECT `NotificationType`.`id` FROM `notification_types` AS `NotificationType` WHERE `type` = 'new_pcomment_reply' LIMIT 1        1    1    0
13    INSERT INTO `notifications` (`status`,`project_id`,`project_owner_name`,`from_user_name`,`comment_id`,`to_user_id`,`notification_type_id`,`created`) VALUES ('UNREAD',1966591,'ElectricSparx','ElectricSparx',8407558,776830,4,'2011-08-08 17:18:13')        1        1
14    SELECT LAST_INSERT_ID() AS insertID        1    1    0
15    SELECT `Pcomment`.*, `User`.`id`, `User`.`username`, `User`.`urlname`, `User`.`role`, `User`.`timestamp` FROM `pcomments` AS `Pcomment` LEFT JOIN `users` AS `User` ON (`Pcomment`.`user_id` = `User`.`id`) WHERE project_id = 1966591 AND `Pcomment`.`comment_visibility` = "visible" AND reply_to = 8407167 ORDER BY `Pcomment`.`created` DESC         1    1    37
16    SELECT COUNT(*) AS `count` FROM `projects` AS `Project` WHERE `Project`.`user_id` = 80131         1    1    0
17    SELECT COUNT(*) AS `count` FROM `pcomments` AS `Pcomment` LEFT JOIN `users` AS `User` ON (`Pcomment`.`user_id` = `User`.`id`) LEFT JOIN `projects` AS `Project` ON (`Pcomment`.`project_id` = `Project`.`id`) WHERE (proj_visibility='visible' OR proj_visibility='censbycomm' OR proj_visibility='censbyadmin')AND comment_visibility = "visible" AND project_id = 1966591 AND reply_to = 8407558         1    1    1
18    SELECT `IgnoredUser`.`id`, `IgnoredUser`.`user_id` FROM `ignored_users` AS `IgnoredUser` WHERE blocker_id = 80131 AND user_id IN ("80131")         0    0    1
19    SELECT `User`.`id` FROM `users` AS `User` WHERE `User`.`id` IN ("80131") AND (`User`.`status` = 'delbyadmin' OR `User`.`status` = 'delbyusr')         0    0    0
20    SELECT `IgnoredUser`.`id`, `IgnoredUser`.`user_id` FROM `ignored_users` AS `IgnoredUser` WHERE blocker_id = 80131 AND user_id IN ("80131")         0    0    0
21    SELECT `Mpcomment`.`id`, `Mpcomment`.`comment_id` FROM `mpcomments` AS `Mpcomment` WHERE user_id = 80131 AND comment_id IN ("8407558")         0    0    0
22    SELECT COUNT(*) AS `count` FROM `blocked_ips` AS `BlockedIp` LEFT JOIN `users` AS `User` ON (`BlockedIp`.`user_id` = `User`.`id`) WHERE ip = 1136089447         1    1    14
23    SELECT `User`.`id`, `User`.`username`, `User`.`villager`, `User`.`firstname`, `User`.`lastname`, `User`.`gender`, `User`.`urlname`, `User`.`role`, `User`.`email`, `User`.`password`, `User`.`buddyicon`, `User`.`organization`, `User`.`city`, `User`.`created`, `User`.`timestamp`, `User`.`state`, `User`.`country`, `User`.`hearabout`, `User`.`interestsabout`, `User`.`comments`, `User`.`bmonth`, `User`.`byear`, `User`.`notify_pcomment`, `User`.`notify_gcomment`, `User`.`ipaddress`, `User`.`status`, `User`.`blocked_till`, `User`.`userpicext`, `User`.`userpic_suffix`, `User`.`login_attempt`, `BlockedUser`.`id`, `BlockedUser`.`user_id`, `BlockedUser`.`admin_id`, `BlockedUser`.`reason`, `BlockedUser`.`timestamp`, `BlockedUser`.`unblock_date`, `BlockedUser`.`active` FROM `users` AS `User` LEFT JOIN `blocked_users` AS `BlockedUser` ON (`BlockedUser`.`user_id` = `User`.`id`) WHERE `User`.`id` = 80131 LIMIT 1        1    1    1
24    SELECT `AdminTag`.`id`, `AdminTag`.`user_id`, `AdminTag`.`tag_id`, `AdminTag`.`status`, `AdminTag`.`timestamp`, `Tag`.`id`, `Tag`.`name`, `Tag`.`timestamp`, `User`.`id`, `User`.`username`, `User`.`villager`, `User`.`firstname`, `User`.`lastname`, `User`.`gender`, `User`.`urlname`, `User`.`role`, `User`.`email`, `User`.`password`, `User`.`buddyicon`, `User`.`organization`, `User`.`city`, `User`.`created`, `User`.`timestamp`, `User`.`state`, `User`.`country`, `User`.`hearabout`, `User`.`interestsabout`, `User`.`comments`, `User`.`bmonth`, `User`.`byear`, `User`.`notify_pcomment`, `User`.`notify_gcomment`, `User`.`ipaddress`, `User`.`status`, `User`.`blocked_till`, `User`.`userpicext`, `User`.`userpic_suffix`, `User`.`login_attempt` FROM `admin_tags` AS `AdminTag` LEFT JOIN `tags` AS `Tag` ON (`AdminTag`.`tag_id` = `Tag`.`id`) LEFT JOIN `users` AS `User` ON (`AdminTag`.`user_id` = `User`.`id`) WHERE `AdminTag`.`status` = 'active'         7    7    1
25    SELECT user_id FROM special_survey_users

Last edited by ElectricSparx (2011-08-08 18:44:12)