|
smartmusic
|
« Antworten #2 am: 06 September 2005, 12:21:36 » |
|
SQL query:
select pwd from mx_authors where aid='Christopher';
SQL query:
select uid, pass from mx_users where uid=2 and uname='Christopher' and user_stat=1;
SQL query:
select * from mx_authors where aid='Christopher'
SQL query:
update mx_counter set count=count+1 where (type='total' and var='hits') or (var='MSIE' and type='browser') or (var='Windows' and type='os')
SQL query:
select count(hour) from mx_stats where (year='2005') and (month='9') and (date='6')
SQL query:
update mx_stats set hits=hits+1 where (year='2005') and (month='9') and (date='6') and (hour='12')
SQL query:
select bg_color, image_dir, lastline, user_message, scrolling_block, scroll_height, scroll_direction, scroll_amount, scroll_hspace, scroll_vspace, scroll_delay from mx_infoblock_cnf where cid='1'
SQL query:
select url, description, image_name, image_line, infotext, line_break from mx_infoblock_data_1 ORDER BY iid ASC
SQL query:
select *, (YEAR(CURRENT_DATE) - YEAR(user_bday)) - ( RIGHT(CURRENT_DATE, 5) < RIGHT(user_bday, 5)) AS user_age from mx_users where uname='Christopher' and pass='xxxxxxxxxxxxx' and user_stat=1
SQL query:
select main_module from mx_main WHERE main_module <> ''
SQL query:
SELECT m.mid, m.title FROM mx_modules AS m LEFT JOIN mx_groups_modules AS g ON m.mid = g.module_id WHERE ((title = 'blank_Home') OR (view = 0 AND active=1) OR (view = 1 AND g.group_id=3 AND active=1) OR (view = 2)) ORDER BY m.title ASC
SQL query:
SELECT Count(msg_id) FROM mx_priv_msgs WHERE to_userid=2 AND read_msg=0
SQL query:
SELECT Count(gid) FROM mx_userguest WHERE touserid='2' AND touser = 'Christopher' AND dummy=0
SQL query:
SELECT Count(ip) FROM mx_visitors WHERE time>1126001992 AND uid=0
SQL query:
SELECT COUNT(uid) FROM mx_users WHERE (user_lastvisit >= 1126001992 AND user_stat=1 AND user_lastmod<>'logout')
SQL query:
SELECT ban_val FROM mx_user_ban WHERE ban_type='ban_ip' AND ban_val='194.231.187.86'
pragmaMx 0.1.6 Debug-Mode, PHP Error-Reporting (E_ALL) enabled
GET: Array
(
[op] => Configure
[ok] => 11299
)
Auf Grund von Serverarbeiten kann es zu Ausfällen kommen!
momentan kann sich keiner einloggen !!!
SQL query:
SELECT block_id FROM mx_groups_blocks WHERE (group_id=3)
SQL query:
SELECT * FROM mx_blocks WHERE (active=1) AND ((blanguage='german' OR blanguage='')) AND ((view = 0) OR (view = 2) OR (view = 1 AND bid in(5, 14, 19, 30, 40, 55, 61, 93, 94))) AND (position <> 'r') AND position NOT IN('c', 'd') ORDER BY position, weight ASC
SQL query:
select count(uid) from mx_users WHERE user_stat=0
SQL query:
select count(qid) from mx_queue
SQL query:
select count(id) from mx_reviews WHERE active='0'
SQL query:
select count(lid) from mx_links_newlink
SQL query:
select count(requestid) from mx_links_modrequest where brokenlink=0
SQL query:
select count(requestid) from mx_links_modrequest where brokenlink=1
SQL query:
select count(lid) from mx_downloads_newdownload
SQL query:
select count(requestid) from mx_downloads_modrequest where brokendownload=0
SQL query:
select count(requestid) from mx_downloads_modrequest where brokendownload=1
SQL query:
select count(pid) from mx_gallery_pictures_newpicture
SQL query:
select count(faq_id) from mx_faqnew
SQL query:
select count(id) from mx_nukebook_queue
SQL query:
SELECT Count(eid) FROM mx_events WHERE activ=0
SQL query:
SELECT uname, (YEAR( CURRENT_DATE ) - YEAR( user_bday )) - ( RIGHT( CURRENT_DATE, 5 ) < RIGHT( user_bday, 5 ) ) AS user_age FROM mx_users WHERE MONTH(user_bday)=MONTH(CURRENT_DATE) AND DAYOFMONTH(user_bday)=DAYOFMONTH(CURRENT_DATE) ORDER BY user_age DESC
SQL query:
select mid, title, custom_title, active, main_id from mx_modules
SQL query:
SELECT mx_userpoints.punkte, mx_users.uname FROM mx_userpoints LEFT JOIN mx_users ON mx_userpoints.uid = mx_users.uid WHERE mx_users.uid>1 AND mx_users.user_stat=1 AND mx_userpoints.punkte>0 AND (mx_users.uname not in('Gast', 'Anonymous')) ORDER BY mx_userpoints.punkte DESC, mx_userpoints.uid LIMIT 0, 10
|
