SMFHacks.com

Guest 14 minutes ago
https://myurl.com/index.php?action=login2;sa=check;member=1004XXX
You were unable to login. Please check your cookie settings
Hello, I keep getting these errors, but I don't know how to replicate them. Could you explain what's causing this error, and how sa=check is activated?

Since the last I deleted my error messages around 3, I've gotten 3 pages worth of these errors for different member IDs.

For example,

Let's say I have a personal gallery associated with my account, and I have one category made with 10 pictures uploaded.

If I delete my account, are the picture records that point to the personal category updated as well?

The reason why that's important is because if the pictures don't get deleted in the deletion process, how will other users be able to see those pictures indexed if the personal category doesn't exist any more?

Curious what would happen if I installed the old store on 2.1

How do I add:

".isset($password) && !empty($password) ? ',password='" . $password . "':''."
into

db_query("INSERT INTO {$db_prefix}oneall_social_login_identities SET ID_MEMBER='" . intval($id_member) . "', user_token='" . $user_token . "', identity_token='" . $identity_token . "'", __FILE__, __LINE__);
After the identity_token='" . $identity_token . "' part?

How did you get around quoting posts in the quick reply. I can't seem to link the two together

Is it fine to record data containing apostrophe characters rather than their HTML codes?

I posted this on the main SMF forum, but didn't get a favorable response. Was hoping to get SMFHack's expertise.

SELECT
mso.subject AS first_subject, ml.ID_MSG, mso.ID_MSG AS id_msg_first, ml.posterTime AS first_poster_time, t.ID_TOPIC, t.ID_BOARD, b.name AS bname,
t.numReplies, t.numViews, t.ID_MEMBER_STARTED AS id_first_member, ml.ID_MEMBER AS id_last_member,
ml.posterTime AS last_poster_time, mso.posterName AS first_poster_name,
IFNULL(meml.realName, ml.posterName) AS last_poster_name, ml.subject AS last_subject,
ml.icon AS last_icon, mso.icon AS first_icon,t.ID_POLL, t.isSticky, t.locked, ml.modifiedTime AS last_modified_time,
CASE WHEN IFNULL(lt.ID_MSG, IFNULL(lmr.ID_MSG, 0)) < t.ID_LAST_MSG THEN 1 ELSE 0 END AS is_new, SUBSTRING(ml.body, 1, 385) AS last_body,
SUBSTRING(mso.body, 1, 385) AS first_body, ml.smileysEnabled AS last_smileys, mso.smileysEnabled AS first_smileys, t.ID_FIRST_MSG, t.ID_LAST_MSG
FROM smf_topics AS t
INNER JOIN smf_messages AS ml ON (ml.ID_MSG = t.ID_LAST_MSG)
INNER JOIN smf_messages AS mso ON (mso.ID_MSG = t.ID_FIRST_MSG)
LEFT JOIN smf_boards AS b ON (b.ID_BOARD = ml.ID_BOARD)
LEFT JOIN smf_members AS meml ON (meml.ID_MEMBER = ml.ID_MEMBER)
LEFT JOIN smf_log_topics AS lt ON (lt.ID_TOPIC = ml.ID_TOPIC AND lt.ID_MEMBER = 6)
LEFT JOIN smf_log_mark_read AS lmr ON (lmr.ID_BOARD = t.ID_BOARD AND lmr.ID_MEMBER = 6)
WHERE t.ID_BOARD IN (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 17, 20, 21, 22, 23, 24, 25, 33, 34, 35, 38, 41, 43, 48, 49, 50, 55, 59, 61, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 95, 96, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 110, 111, 112, 113, 114, 115, 116, 117)
AND t.ID_LAST_MSG >= 4708323 AND ml.posterTime > unix_timestamp(now() - interval 14 day)
ORDER BY t.ID_LAST_MSG DESC
LIMIT 0, 40
Sometimes takes a minute to load, what gives?

Got many of these links in my error log:

https://biology-forums.com/index.php?action=downloads;sa=view;down=9931\"%20or%20(1,2)=(select*from(select%20name_const(CHAR(111,108,111,108,111,115,104,101,114),1),name_const(CHAR(111,108,111,108,111,115,104,101,114),1))a)%20--%20\"x\"=\"x

https://biology-forums.com/index.php?action=downloads;sa=view;down=9931\%27%20or%20(1,2)=(select*from(select%20name_const(CHAR(111,108,111,108,111,115,104,101,114),1),name_const(CHAR(111,108,111,108,111,115,104,101,114),1))a)%20--%20\%27x\%27=\%27x

https://biology-forums.com/index.php?action=downloads;sa=view;down=9931%20or%20(1,2)=(select*from(select%20name_const(CHAR(111,108,111,108,111,115,104,101,114),1),name_const(CHAR(111,108,111,108,111,115,104,101,114),1))a)%20--%20and%201=1



Thanks