#3
Aw:: automatische Bestätigungsmail bei neuer PM
14.12.2010 22:26 Hallo,
Danke für die Antwort. Ich bin ziemlich neu in der materie aber ich hoffe, das ich das richtig gemacht habe und ihr damit was anfangen könnt.
raimcomputi
0,000088 - SET NAMES 'utf8'
0,000054 - SET SQL_BIG_SELECTS = 1
0,000097 - SELECT * FROM config WHERE (conf_modid = '0' AND conf_catid = '1') ORDER BY conf_order ASC
0,000524 - SELECT sess_data, sess_ip FROM session WHERE sess_id = '087ededf9c0f727db0a98bcf5e2e4553'
0,000082 - SELECT * FROM users WHERE uid = '1'
0,000072 - SELECT * FROM modules WHERE dirname = 'profile'
0,000109 - SELECT * FROM config WHERE (conf_modid = '21') ORDER BY conf_order ASC
0,000083 - SELECT * FROM modules WHERE dirname = 'protector'
0,000548 - DELETE FROM protector_access WHERE expire < UNIX_TIMESTAMP()
0,000319 - SELECT COUNT(*) FROM protector_access WHERE ip='78.48.104.246' AND request_uri='/Kontakt/modules/profile/pmlite.php'
0,000166 - SELECT COUNT(*) FROM protector_access WHERE ip='78.48.104.246'
0,000202 - INSERT INTO protector_access SET ip='78.48.104.246',request_uri='/Kontakt/modules/profile/pmlite.php',expire=UNIX_TIMESTAMP()+'60'
0,000088 - SELECT * FROM config WHERE (conf_modid = '0' AND conf_catid = '2') ORDER BY conf_order ASC
0,000116 - SELECT * FROM config WHERE (conf_modid = '0' AND conf_catid = '3') ORDER BY conf_order ASC
0,000075 - SELECT DISTINCT gperm_itemid FROM group_permission WHERE gperm_name = 'block_read' AND gperm_modid = 1 AND gperm_groupid IN (1)
0,000080 - SELECT b.* FROM newblocks b, block_module_link m WHERE m.block_id=b.bid AND b.isactive=1 AND b.visible=1 AND m.module_id IN (0,21) AND b.bid IN (1,2,3,4,5,6,7,8,9,10,11,12,14,15,16,21,13,58,166,170,171) ORDER BY b.weight, m.block_id
0,000092 - SELECT COUNT(*) FROM priv_msgs WHERE (read_msg = '0' AND to_userid = '1')
0,000080 - SELECT f.*, s.tpl_source FROM tplfile f LEFT JOIN tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'Meins' AND tpl_file = 'system_block_user.html') ORDER BY tpl_refid
0,000097 - SELECT * FROM modules WHERE dirname = 'onlinehistory'
0,000052 - SELECT * FROM config WHERE (conf_modid = '3') ORDER BY conf_order ASC
0,000541 - SELECT uid,uagent,module FROM lastseen WHERE online=1
0,000478 - SELECT l.uid, l.username, u.name FROM lastseen as l, users as u WHERE l.uid>0 AND l.online=1 AND l.uid=u.uid AND 1=1 LIMIT 10
0,000332 - SELECT l.uid, l.username, l.time, u.name FROM lastseen as l, users as u WHERE l.uid>0 AND l.time>1291497227 AND l.uid=u.uid AND 1=1 ORDER BY l.time DESC LIMIT 0, 20
0,000069 - SELECT f.*, s.tpl_source FROM tplfile f LEFT JOIN tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'Meins' AND tpl_file = 'history_block_online.html') ORDER BY tpl_refid
0,000194 - DELETE FROM lastseen WHERE (uid<1 AND time<=1292360927) OR (uid>0 AND time<=1291756427)
0,000114 - UPDATE lastseen SET online=0 WHERE uid>0 AND time< 1292360927
0,000188 - SELECT count(uid) as cuid FROM lastseen WHERE uid=1
0,000210 - UPDATE lastseen SET time = 1292361227, ip='78.48.104.246' ,uagent='Mozilla/5.0 (Windows; U; Windows NT 6.0; de; rv:1.9.2.13) Gecko/20101203 Firefox/3.6.13', username='EAEC', module=21, online=1 WHERE uid=1
0,000231 - SELECT COUNT(uid) as count FROM lastseen WHERE (online > '0' AND uid > '-1')
0,000080 - SELECT * FROM modules WHERE dirname = 'info'
0,000054 - SELECT * FROM config WHERE (conf_modid = '2') ORDER BY conf_order ASC
0,000057 - SELECT storyid,homepage FROM info WHERE address ='/Kontakt/modules/profile/pmlite.php'
0,000128 - SELECT * FROM info WHERE parent_id=0 ORDER BY blockid
0,000067 - SELECT f.*, s.tpl_source FROM tplfile f LEFT JOIN tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'Meins' AND tpl_file = 'info_nav_block.html') ORDER BY tpl_refid
0,000102 - SELECT * FROM `users` WHERE (level > '0') ORDER BY user_regdate DESC LIMIT 0, 10
0,000075 - SELECT f.*, s.tpl_source FROM tplfile f LEFT JOIN tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'Meins' AND tpl_file = 'system_block_newusers.html') ORDER BY tpl_refid
0,000069 - SELECT storyid,homepage FROM info WHERE address ='/Kontakt/modules/profile/pmlite.php'
0,000126 - SELECT * FROM info WHERE parent_id=0 ORDER BY blockid
0,000083 - SELECT cfgname, cfgvalue FROM logcounterx_cfg
0,000051 - SELECT cnt FROM logcounterx_count WHERE ymd = '2010-12-14'
0,000043 - SELECT cnt FROM logcounterx_count WHERE ymd = '2010-12-13'
0,000043 - SELECT sum(cnt) as CNT FROM logcounterx_count WHERE ymd >= '2010-12-12'
0,000450 - SELECT sum(cnt) as CNT FROM logcounterx_count WHERE (ymd like '2010-12-%') OR (ymd like '2010/12/%')
0,000042 - SELECT cnt FROM logcounterx_count WHERE (ymd = '1111-11-11') OR (ymd = '1111/11/11')
0,000040 - SELECT count(ymd) AS DAYS, sum(cnt) as CNT FROM logcounterx_count WHERE ymd > '1111-11-11'
0,000070 - SELECT f.*, s.tpl_source FROM tplfile f LEFT JOIN tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'Meins' AND tpl_file = 'lcx_block_display.html') ORDER BY tpl_refid
0,000053 - SELECT f.*, s.tpl_source FROM tplfile f LEFT JOIN tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'lcx_block_display.html') ORDER BY tpl_refid
0,000082 - SELECT rank_title AS title, rank_image AS image FROM ranks WHERE rank_id = 7
0,000079 - SELECT * FROM `profile_configs` WHERE config_uid = '1'
0,000100 - SELECT COUNT(*) FROM profile_friends WHERE self_uid=1 AND level=2
0,000047 - SELECT COUNT(*) FROM profile_friends WHERE friend_uid=1 AND level=2
0,000070 - SELECT COUNT(*) FROM `profile_friends` WHERE (friend_uid = '1' AND level = '1')
0,000308 - SELECT COUNT(*) FROM `users` WHERE uid = '10'
0,000389 - INSERT INTO `priv_msgs` (`subject`, `from_userid`, `to_userid`, `msg_time`, `msg_text`) VALUES ('Versuch',1,10,1292361227,'nur zur probe')
0,000071 - SELECT * FROM users WHERE uid = '10'
Zusammen: 55
