(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 = 1487 ORDER BY c.ts DESC LIMIT 5
>> EASTERNPOKERTOUR.COM
(mysqli): SELECT p.first, opt.nickname FROM player p LEFT JOIN player_opt opt ON p.id = opt.player_id WHERE p.id = 1487
(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 = 1487
(mysqli): SELECT activated, monthly_primary_tournament_id, primary_tournament_id FROM player WHERE id = 1487
(mysqli): SELECT COUNT(id) as cnt FROM friend WHERE player_id = 1487
(mysqli): SELECT COUNT(id) as cnt FROM friend WHERE player_id = 1487 AND final_table = 1
(mysqli): SELECT COUNT(id) as cnt FROM player_photo WHERE player_id = 1487
(mysqli): SELECT COUNT(id) as cnt FROM comment WHERE type = 'player' AND _id = 1487
(mysqli): SELECT COUNT(id) as cnt FROM comment WHERE made_by = 1487
(mysqli): SELECT COUNT(id) as cnt FROM blog WHERE player_id = 1487
(mysqli): SELECT COUNT(id) as cnt FROM blog_comment WHERE made_by = 1487
Query: SELECT COUNT(id) as cnt FROM blog_comment WHERE made_by = 1487 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 = 1487) % line 1195, file: adodb-mysqli.inc.php ADODB_mysqli.execute(SELECT COUNT(id) as cnt FROM blog_comment WHERE made_by = 1487) % line 2100, file: player.class.php player.get_all_flags(1487) % 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 = 1487
(mysqli): SELECT id FROM player_photo WHERE player_id = 1487 AND dflt = 1
(mysqli): SELECT COUNT(id) as cnt FROM friend_request WHERE sent_to = 1487
(mysqli): SELECT COUNT(id) as cnt FROM player_rankings WHERE player_id = 1487
(mysqli): SELECT player_id FROM player_bpo_qualified WHERE player_id = 1487
(mysqli): SELECT COUNT(DISTINCT(event_id)) as cnt FROM player_pts WHERE player_id = 1487
(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 = 1487 AND r.rank_type = 'Seasonal' AND r.rank_period = '36' AND r.tournament_id = '11'
(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 = 1487 AND r.rank_type = 'Monthly' AND r.rank_period = '202610' AND r.tournament_id = '11'
(mysqli): SELECT photo_name, thumb_name FROM player_photo WHERE player_id = 1487 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 = 1487 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 = '1487' GROUP BY r.player_id LIMIT 1
(mysqli): SELECT id, name, city FROM location WHERE active = 1 ORDER BY name ASC
(mysqli): SELECT id, name, state FROM tournament WHERE 1 ORDER BY name ASC
(mysqli): SELECT name FROM location WHERE id = 13
(mysqli): UPDATE `profile_views` SET `views`=views + 1 WHERE `player_id`=1487
(mysqli): select count(*) from `profile_views` where `player_id`=1487
(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 = 1487 ORDER BY c.ts DESC LIMIT 5
(mysqli): SELECT opt.player_id, pp.thumb_name as thumb, CONCAT(p.first,' ',p.last) as name FROM player_opt opt LEFT JOIN player_photo pp ON opt.player_id = pp.player_id INNER JOIN player p ON p.id = opt.player_id WHERE opt.featured = 1 AND pp.dflt = 1
FEATURED
PLAYERS
The Mick
08-21-2008 08:29:38 PM
Hey Rock. It's three in the morning. I went up to your house there and they told me you was here. It's a 3:00am kid. You know Billy, he's a good guy. Me, you know I'm sorry for both of ya. There's nothing I can do about it. Except uh I wanna tell you this once and then uh I ain't gonna say it again. But Rock, you got another shot. This is the second shot.
The Mick
08-21-2008 08:29:13 PM
At uh I don't know the biggest title in the Jockey Club, and you're gonna be swappin' chips with, with the most dangerous players in the Southern Mass. And just in case you don’t know your brain ain't workin' so good. All this happens pretty soon and you ain't ready. You know you're no where near in shape. So I say for God's sake.
The Mick
08-21-2008 08:28:58 PM
Why don't you stand up and fight these guys HARD? Like you done before that was beautiful! But don't lay down like this! Like uh I don't know like some kind of mongrel or something. Cause they’re gonna kick your face in pieces! That's right!
The Mick
08-21-2008 08:28:42 PM
These guys don't just wanna win you know, they wants to bury ya, they wants to humiliate ya, they wants to prove to the whole EPT that you was nothin but some kind of freak the last time out. John Coelho said you were a one time lucky bum! Well now I don't wanna get mad in a biblical place like this. But I think you're a hell of a lot more than that kid!
The Mick
08-21-2008 08:28:24 PM
A hell of a lot! But now wait a minute if you wanna blow this thing if you wanna blow it then damn it I'm gonna blow it with ya. If you wanna stay here I'll stay with ya. I stay with ya. I'll stay and pray. What do I got to lose?