Hem ttcoordinator.com | 2025-06-01 Huvudmeny Hem TT Coordinator Licensvillkor Priser Beställa Ladda hem FAQ Versionshistorik Kontakta oss Fjärrhjälp Inloggning Användarnamn Lösenord Kom ihåg mig Glömt ditt lösenord?       TT Coordinator TT Coordinator är uppföljaren till det mest använda tävlingsprogrammet inom svensk bordtennis, ON Data Pingis. Med ett helt nytt menysystem, många nya funktioner samt stöd för Windows XP/Vista/7/8/10, är det en stor ansiktslyftning från föregående version. Har du tidigare använt ON Data Pingis, kommer du ändå att känna igen logik och tillvägagångssätt i det nya programmet. Samarbete sker för närvarande också med Svenska, Norska och Danska Bordtennisförbundet för att integrera TT Coordinator med de centrala system som används i respektive land. Programmet har nu import/export-funktioner mot dessa system vilket möjliggör nedladdning av klubb- och spelarregister samt aktuell ranking. Efter avslutad tävling kan resultaten exporteras till förbundet för resultatpresentation och bearbetning av rankingpoäng. Programmet används idag av ca 200 tävlingsarrangörer i Sverige, Norge & Danmark.

1
SELECT id, link
 FROM mos_menu
 WHERE menutype='mainmenu' AND published='1'
 ORDER BY parent, ordering LIMIT 1
2
SELECT template FROM mos_templates_menu WHERE client_id='0' AND menuid='0'
3
SELECT template FROM mos_templates_menu WHERE client_id='0' AND menuid='1' LIMIT 1
4
DELETE FROM mos_session
WHERE (time < 1748741581)
5
SELECT * FROM mos_session WHERE session_id='8f7bf1714006c3eb3dd54b4559b9f489'
6
SELECT session_id FROM mos_session WHERE session_id=MD5('2c32a7820476aa56dc161d0f010fbd58')
7
INSERT INTO mos_session ( `session_id`,`time`,`username`,`gid`,`guest` ) VALUES ( 'a3a0168e05b0b186f757d4ec0c46fd0a','1748742481','','0','1' )
8
SELECT folder, element, published, CONCAT_WS('/',folder,element) AS lookup
FROM mos_mambots
WHERE published >= 1 AND access <= 0 AND folder='editors'
ORDER BY ordering
9
SELECT folder, element, published, CONCAT_WS('/',folder,element) AS lookup
FROM mos_mambots
WHERE published >= 1 AND access <= 0 AND folder='editors-xtd'
ORDER BY ordering
10
SELECT access FROM mos_menu WHERE id='1'
11
SELECT * FROM mos_menu WHERE id='1'
12
SELECT a.*, ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count, u.name AS author, u.usertype, s.name AS section, cc.name AS category, g.name AS groups
 FROM mos_content AS a
 INNER JOIN mos_content_frontpage AS f ON f.content_id = a.id
 INNER JOIN mos_categories AS cc ON cc.id = a.catid
 INNER JOIN mos_sections AS s ON s.id = a.sectionid
 LEFT JOIN mos_users AS u ON u.id = a.created_by
 LEFT JOIN mos_content_rating AS v ON a.id = v.content_id
 LEFT JOIN mos_groups AS g ON a.access = g.id
 WHERE a.state = '1'
 AND a.access <= '0'
 AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2025-06-01 03:48:01'  )
 AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2025-06-01 03:48:01' )
 ORDER BY f.ordering
13
SELECT COUNT( m.id )
 FROM mos_content AS i
 LEFT JOIN mos_sections AS s ON i.sectionid=s.id
 LEFT JOIN mos_menu AS m ON m.componentid=s.id 
 WHERE m.type='content_blog_section'
 AND m.published='1'
14
SELECT COUNT( m.id )
 FROM mos_content AS i
 LEFT JOIN mos_categories AS c ON i.catid=c.id
 LEFT JOIN mos_menu AS m ON m.componentid=c.id 
 WHERE m.type='content_blog_category'
  AND m.published='1'
15
SELECT COUNT( id )
 FROM mos_menu 
 WHERE type='content_blog_section'
 AND published='1'
 AND componentid=0
16
SELECT folder, element, published, CONCAT_WS('/',folder,element) AS lookup
FROM mos_mambots
WHERE published >= 1 AND access <= 0 AND folder='content'
ORDER BY ordering
17
SELECT m.id 
FROM mos_content AS i
LEFT JOIN mos_sections AS s ON i.sectionid=s.id
LEFT JOIN mos_menu AS m ON m.componentid=s.id 
WHERE m.type='content_section' AND m.published='1' AND i.id=10
18
SELECT id, link
FROM mos_menu
WHERE menutype='mainmenu' AND published='1'
ORDER BY parent, ordering LIMIT 1
19
SELECT id, name, link, parent, type
FROM mos_menu
WHERE published='1'
ORDER BY parent, ordering
20
SELECT id, title, module, position, content, showtitle, params
FROM mos_modules AS m, mos_modules_menu AS mm
WHERE m.published='1' AND m.access <= '0' AND m.client_id='0'
AND mm.moduleid=m.id
AND (mm.menuid = '1' OR mm.menuid = '0')
ORDER BY ordering
21
SELECT m.* FROM mos_menu AS m
WHERE menutype='mainmenu' AND published='1' AND access <= '0'
ORDER BY parent,ordering
22
SELECT id 
FROM mos_menu 
WHERE type='content_typed' AND published='1' AND link='index.php?option=com_content&task=view&id=53'
23
SELECT id 
FROM mos_menu 
WHERE type='content_item_link' AND published='1' AND link='index.php?option=com_content&task=view&id=53'
24
SELECT name FROM mos_users WHERE id = 0
25
SELECT count(*) AS numrows FROM mos_banner WHERE showBanner=1
26
SELECT * FROM mos_banner WHERE showBanner=1 LIMIT 0,1