(mysqli): SELECT p.first, opt.nickname FROM player p LEFT JOIN player_opt opt ON p.id = opt.player_id WHERE p.id = 5843
(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 = 5843
(mysqli): SELECT activated, monthly_primary_tournament_id, primary_tournament_id FROM player WHERE id = 5843
(mysqli): SELECT COUNT(id) as cnt FROM friend WHERE player_id = 5843
(mysqli): SELECT COUNT(id) as cnt FROM friend WHERE player_id = 5843 AND final_table = 1
(mysqli): SELECT COUNT(id) as cnt FROM player_photo WHERE player_id = 5843
(mysqli): SELECT COUNT(id) as cnt FROM comment WHERE type = 'player' AND _id = 5843
(mysqli): SELECT COUNT(id) as cnt FROM comment WHERE made_by = 5843
(mysqli): SELECT COUNT(id) as cnt FROM blog WHERE player_id = 5843
(mysqli): SELECT COUNT(id) as cnt FROM blog_comment WHERE made_by = 5843
Query: SELECT COUNT(id) as cnt FROM blog_comment WHERE made_by = 5843 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 = 5843) % line 1195, file: adodb-mysqli.inc.php
ADODB_mysqli.execute(SELECT COUNT(id) as cnt FROM blog_comment WHERE made_by = 5843) % line 2100, file: player.class.php
player.get_all_flags(5843) % 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 = 5843
(mysqli): SELECT id FROM player_photo WHERE player_id = 5843 AND dflt = 1
(mysqli): SELECT COUNT(id) as cnt FROM friend_request WHERE sent_to = 5843
(mysqli): SELECT COUNT(id) as cnt FROM player_rankings WHERE player_id = 5843
(mysqli): SELECT player_id FROM player_bpo_qualified WHERE player_id = 5843
(mysqli): SELECT COUNT(DISTINCT(event_id)) as cnt FROM player_pts WHERE player_id = 5843
(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 = 5843 AND r.rank_type = 'Seasonal' AND r.rank_period = '36' AND r.tournament_id = '6'
(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 = 5843 AND r.rank_type = 'Monthly' AND r.rank_period = '202610' AND r.tournament_id = '0'
(mysqli): SELECT photo_name, thumb_name FROM player_photo WHERE player_id = 5843 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 = 5843 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 = '5843' 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 = 430
(mysqli): UPDATE `profile_views` SET `views`=views + 1 WHERE `player_id`=5843
(mysqli): select count(*) from `profile_views` where `player_id`=5843
(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 = 5843 AND f.final_table = 1
FINAL TABLE
(mysqli): SELECT b.* FROM blog b WHERE b.player_id = 5843 ORDER BY b.ts DESC LIMIT 5
(mysqli): SELECT COUNT(id) as comment_count FROM comment WHERE _id = 79 AND type = 'blog'
RECENT BLOG POSTS
Home Games Anyone?
03-26-2008 11:47:18 AM View Post >>
(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 = 5843 ORDER BY c.ts DESC LIMIT 5
COMMENTS
Money Bags
05-07-2008 08:01:11 PM
so when are we going to one of these things man???? where the hell are you?
Money Bags
03-26-2008 08:35:57 PM
im interested in home games!!!! cuz i'll take your money!!! Providing i dont lose my K10 suited against a crappy Q8!!!!
Jess
03-26-2008 07:36:25 PM
Hey Dan, thanks for wanting to be my friend. I hope to see you around at some tournaments.. -Jess ..and Rounders.. Fabulous ; )
Jess
03-26-2008 07:36:09 PM
Hey Dan, thanks for wanting to be my friend. I hope to see you around at some tournaments.. -Jess ..and Rounders.. Fabulous ; )
Money Bags
03-21-2008 12:54:09 PM
All right Bro, this is it.....ARE YOU READY!!!! Im trying to make some friends on here who have been in the league for a long time. You should do the same! later man!