0.00053906
SELECT * FROM Nuke84Pex_authors
---------------------------------------
0.00013805
SET NAMES 'latin1'
---------------------------------------
0.00012588
SET NAMES 'latin1'
---------------------------------------
0.00043797
SELECT *
FROM `phpnuke_84f`.`NukePex_bb3users`
WHERE user_id = :_p0
---------------------------------------
0.00022102
SELECT *
FROM `phpnuke_84f`.`NukePex_bb3profile_fields_data`
WHERE user_id = 1 ORDER BY user_id ASC LIMIT 0,1
---------------------------------------
0.00026011
DELETE FROM `phpnuke_84f`.`NukePex_bb3sessions` WHERE session_id = :_p0 AND session_user_id = :_p1
---------------------------------------
0.00033307
UPDATE `phpnuke_84f`.`NukePex_bb3config` SET config_value = CASE
WHEN config_name = 'rand_seed_last_update' THEN '1610751090'
WHEN config_name = 'rand_seed' THEN '88268a6cb1dbc5eab1122fec4d551f12'
END
WHERE config_name IN('rand_seed_last_update','rand_seed')
---------------------------------------
0.00030088
INSERT INTO `phpnuke_84f`.`NukePex_bb3sessions` (`session_user_id`,`session_start`,`session_last_visit`,`session_time`,`session_browser`,`session_forwarded_for`,`session_ip`,`session_autologin`,`session_admin`,`session_viewonline`,`session_page`,`session_id`) VALUES(:_p0, :_p1, :_p2, :_p3, :_p4, :_p5, :_p6, :_p7, :_p8, :_p9, :_p10, :_p11)
---------------------------------------
0.00019502
SELECT *
FROM `phpnuke_84f`.`NukePex_bb3profile_fields_data`
WHERE user_id = 1 ORDER BY user_id ASC LIMIT 0,1
---------------------------------------
0.87132001
SELECT COUNT(session_id) AS sessions FROM `phpnuke_84f`.`NukePex_bb3sessions` WHERE session_user_id = :_p0 AND session_time >= :_p1
---------------------------------------
0.00013589000000003
SET NAMES 'utf8mb4'
---------------------------------------
0.00407386
SELECT s.*
, s1.sid as psid, s1.title as ptitle, s1.post_url as ppost_url, s1.time as ptime, s1.cat_link as pcat_link,
s2.sid as nsid, s2.title as ntitle, s2.post_url as npost_url, s2.time as ntime, s2.cat_link as ncat_link
FROM Nuke84Pex_posts AS s
LEFT JOIN Nuke84Pex_posts AS s1 ON s1.sid = (
SELECT MAX(sid)
FROM Nuke84Pex_posts
WHERE sid < s.sid AND post_type = s.post_type AND status = :status
)
LEFT JOIN Nuke84Pex_posts AS s2 ON s2.sid = (
SELECT MIN(sid)
FROM Nuke84Pex_posts
WHERE sid > s.sid AND post_type = s.post_type AND status = :status
)
WHERE (s.post_url=:post_url OR s.sid=:post_url) AND s.status = :status AND s.post_type = :post_type
---------------------------------------
0.00060486999999998
SELECT post_id, meta_key, meta_value, meta_part FROM Nuke84Pex_postsmeta WHERE post_id IN (84) AND ((meta_part IN ('Articles')) OR (meta_part = 'module_boxes' AND meta_key = 'post'))
---------------------------------------
0.0036539999999999
SELECT s.post_id, s.db_table, SUM(IF(score >= 1, 1, 0)) AS likes, SUM(IF(score < 0, 1, 0)) AS dislikes, COUNT(id) AS ratings, 0 as score, (SELECT sc.id FROM Nuke84Pex_scores as sc WHERE (sc.rating_ip = :visitor_ip) AND s.post_id = sc.post_id AND sc.db_table = s.db_table ORDER BY sc.id ASC LIMIT 1) AS you_rated FROM Nuke84Pex_scores as s WHERE s.post_id IN (84) AND s.votetype IN (2,3) AND s.db_table IN ('Articles') GROUP BY s.post_id, s.db_table
---------------------------------------
0.00476789
UPDATE Nuke84Pex_posts SET counter = counter+1 WHERE sid = :_p0
---------------------------------------
0.00212097
SELECT c.*,
IF(c.username IS NULL OR c.username = '', '', (SELECT CONCAT_WS(',', group_id, user_avatar, user_avatar_type, user_email) FROM `phpnuke_84f`.`NukePex_bb3users` WHERE username = c.username)) as user_data,
(SELECT 1 FROM Nuke84Pex_comments WHERE pid= c.cid LIMIT 1) as replies,
(SELECT 1 FROM Nuke84Pex_reports WHERE post_id= c.cid AND module='comments' LIMIT 1) as reported
, COUNT(tc.cid) as total_rows
FROM Nuke84Pex_comments AS c
LEFT JOIN Nuke84Pex_comments AS tc ON tc.module = :module AND tc.post_id = :post_id AND (tc.status = '1' OR tc.username = :username OR tc.ip = :visitor_ip) AND tc.pid = '0'
WHERE c.pid = '0' AND c.module = :module AND c.post_id = :post_id AND (c.status = '1' OR c.username = :username OR c.ip = :visitor_ip)
GROUP BY c.cid
ORDER BY c.cid DESC LIMIT 0, 20
---------------------------------------
0.00053287000000002
SELECT c.*,
IF(c.username IS NULL OR c.username = '', '', (SELECT CONCAT_WS(',', group_id, user_avatar, user_avatar_type, user_email) FROM `phpnuke_84f`.`NukePex_bb3users` WHERE username = c.username)) as user_data,
(SELECT 1 FROM Nuke84Pex_comments WHERE pid= c.cid LIMIT 1) as replies,
(SELECT 1 FROM Nuke84Pex_reports WHERE post_id= c.cid AND module='comments' LIMIT 1) as reported
FROM Nuke84Pex_comments AS c
WHERE c.main_parent IN (570) AND c.module = :module AND c.post_id = :post_id AND (c.status = '1' OR c.username = :username OR c.ip = :visitor_ip)
GROUP BY c.cid
ORDER BY c.cid DESC
---------------------------------------
0.00056504999999996
SELECT
s.post_id, SUM(IF(score >= 1, 1, 0)) AS likes, SUM(IF(score < 0, 1, 0)) AS dislikes, COUNT(id) AS ratings, 0 as score, EXISTS(SELECT 1 FROM Nuke84Pex_scores as sc WHERE (rating_ip = :visitor_ip) AND s.post_id = sc.post_id AND sc.db_table = 'comments' LIMIT 1) AS you_rated FROM Nuke84Pex_scores as s WHERE s.post_id IN (570) AND s.votetype IN (2,3) AND s.db_table = 'comments' GROUP BY s.post_id
---------------------------------------
Warning: Cannot modify header information - headers already sent by (output started at /home/phpnuke/domains/phpnuke.ir/private_html/includes/class.Database.php:531) in /home/phpnuke/domains/phpnuke.ir/private_html/includes/class.cookies.php on line 154
Warning: Cannot modify header information - headers already sent by (output started at /home/phpnuke/domains/phpnuke.ir/private_html/includes/class.Database.php:531) in /home/phpnuke/domains/phpnuke.ir/private_html/includes/functions.php on line 127
با توجه به اینکه فعالیت در انجمن نیوک فارسی مستلزم رعایت قوانین انجمن جهت نظم در تاپیک ها و جلوگیری از ارسال های اسپم میباشد در این پست به منظور تاکید در ارتباط با چند بند از قوانین مرجع نیوک فارسی به توضیحات بیشتر در این رابطه میپردازیم.