(mysqli): SELECT p.first, opt.nickname FROM player p LEFT JOIN player_opt opt ON p.id = opt.player_id WHERE p.id = 1192
(mysqli): SELECT p.*, o.*, monthly_t.nickname as monthly_primary_tournament_nickname, t.nickname as primary_tournament_nickname FROM player p LEFT JOIN player_opt AS o ON o.player_id = p.id LEFT JOIN tournament AS t ON t.id = p.primary_tournament_id LEFT JOIN tournament AS monthly_t ON monthly_t.id = p.monthly_primary_tournament_id WHERE p.id = 1192
(mysqli): SELECT activated, monthly_primary_tournament_id, primary_tournament_id FROM player WHERE id = 1192
(mysqli): SELECT COUNT(id) as cnt FROM friend WHERE player_id = 1192
(mysqli): SELECT COUNT(id) as cnt FROM friend WHERE player_id = 1192 AND final_table = 1
(mysqli): SELECT COUNT(id) as cnt FROM player_photo WHERE player_id = 1192
(mysqli): SELECT COUNT(id) as cnt FROM comment WHERE type = 'player' AND _id = 1192
(mysqli): SELECT COUNT(id) as cnt FROM comment WHERE made_by = 1192
(mysqli): SELECT COUNT(id) as cnt FROM blog WHERE player_id = 1192
(mysqli): SELECT COUNT(id) as cnt FROM blog_comment WHERE made_by = 1192
Query: SELECT COUNT(id) as cnt FROM blog_comment WHERE made_by = 1192 failed. Table 'easternpokertour.blog_comment' doesn't exist
1146: Table 'easternpokertour.blog_comment' doesn't exist
ADOConnection._Execute(SELECT COUNT(id) as cnt FROM blog_comment WHERE made_by = 1192) % line 1195, file: adodb-mysqli.inc.php
ADODB_mysqli.execute(SELECT COUNT(id) as cnt FROM blog_comment WHERE made_by = 1192) % line 2100, file: player.class.php
player.get_all_flags(1192) % line 55, file: player.class.php
player.profile() % line 119, file: block.class.php
block.execute() % line 34, file: block.class.php
block.display(player:profile) % line 30, file: e1a753c219907d149f22a84059dd290238f48124_0.file_main.tpl.php
content_6adb646d2d80a4_39446619(Object:Smarty\Template) % line 111, file: GeneratedPhpFile.php
Smarty\Template\GeneratedPhpFile.getRenderedTemplateCode(Object:Smarty\Template, content_6adb646d2d80a4_39446619) % line 110, file: Compiled.php
Smarty\Template\Compiled.render(Object:Smarty\Template) % line 180, file: Template.php
Smarty\Template.render(false, 1) % line 655, file: Template.php
Smarty\Template._execute(1) % line 594, file: Template.php
Smarty\Template.display() % line 2135, file: Smarty.php
Smarty\Smarty.display(main.tpl) % line 72, file: index.php
(mysqli): SELECT views FROM profile_views WHERE player_id = 1192
(mysqli): SELECT id FROM player_photo WHERE player_id = 1192 AND dflt = 1
(mysqli): SELECT COUNT(id) as cnt FROM friend_request WHERE sent_to = 1192
(mysqli): SELECT COUNT(id) as cnt FROM player_rankings WHERE player_id = 1192
(mysqli): SELECT player_id FROM player_bpo_qualified WHERE player_id = 1192
(mysqli): SELECT COUNT(DISTINCT(event_id)) as cnt FROM player_pts WHERE player_id = 1192
(mysqli): SELECT r.pri_event_count, r.neu_event_count, r.sec_event_count FROM rankings AS r LEFT JOIN player AS p ON p.id = r.player_id WHERE r.player_id = 1192 AND r.rank_type = 'Seasonal' AND r.rank_period = '36' AND r.tournament_id = '1'
(mysqli): SELECT r.pri_event_count, r.neu_event_count, r.sec_event_count FROM rankings AS r LEFT JOIN player AS p ON p.id = r.player_id WHERE r.player_id = 1192 AND r.rank_type = 'Monthly' AND r.rank_period = '202610' AND r.tournament_id = '1'
(mysqli): SELECT photo_name, thumb_name FROM player_photo WHERE player_id = 1192 AND dflt = 1 LIMIT 1
(mysqli): SELECT COUNT(pts.id) as total_season_wins FROM player_pts AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.player_id = 1192 AND pts.action = '1' AND e.date >= 1775779200 AND e.date <= 1806451200 GROUP BY pts.player_id
(mysqli): SELECT r.player_id, p.last, p.first, opt.nickname, p.date_created, SUM((r.pri_event_points + r.pri_bonus_points)) AS total, SUM(r.pri_event_count) as event_count, ROUND((SUM((r.pri_event_points + r.pri_bonus_points)) / SUM(r.pri_event_count)), 2) AS average, SUM(r.pri_wins) AS wins, SUM(r.pri_top_16s) AS top16 FROM rankings AS r LEFT JOIN player AS p ON p.id = r.player_id LEFT JOIN player_opt AS opt ON opt.player_id = p.id WHERE r.rank_type = 'Alltime' AND r.rank_basic != '0' AND r.rank_w_addl_pts != '0' AND p.id = '1192' GROUP BY r.player_id LIMIT 1
(mysqli): UPDATE `profile_views` SET `views`=views + 1 WHERE `player_id`=1192
(mysqli): select count(*) from `profile_views` where `player_id`=1192
(mysqli): SELECT f.*, CONCAT(p.first,' ',p.last) as name, pp.thumb_name as thumb FROM friend f INNER JOIN player p ON p.id = f.friend_id LEFT JOIN player_photo pp ON (f.friend_id = pp.player_id AND pp.dflt = 1) WHERE f.player_id = 1192 AND f.final_table = 1
FINAL TABLE
(mysqli): SELECT c.*, p.first, opt.nickname, pp.thumb_name FROM comment c LEFT JOIN player p ON c.made_by = p.id LEFT JOIN player_opt opt ON c.made_by = opt.player_id LEFT JOIN player_photo pp ON (c.made_by = pp.player_id AND pp.dflt = 1) WHERE c.type = 'player' AND c._id = 1192 ORDER BY c.ts DESC LIMIT 5
COMMENTS
President
08-14-2009 06:47:32 PM
haha.. come on tait! wayyy ahead of ya :)
Anthony
07-19-2009 03:12:41 PM
Not to mention...I should be at your final table....spite? hmmmm, very possible!!
Anthony
07-19-2009 03:11:33 PM
Tait...it appears your point average keeps getting further away from me...not really sure what's going on with that but for some reason you have gone in the opposite direction. It must be the whole retroactive theory that's effecting so much! Keep working at it kiddo....you'll get there some day..goals are great to have..if you have any questions or need any tips you just say the word buddy i'm there for ya!!!
The Zim
07-02-2009 06:21:47 AM
Oh yea. That is most def. one of the many secrets of tait
President
05-08-2009 06:58:56 PM
the moose.... i'll write the directions