|
This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.
Topics - shuban
1
« on: March 27, 2023, 08:56:44 am »
The current search feature for this mod is badly lacking, especially for galleries that feature 1000's of pictures. Are there any plans to improve the search function so that it searches the database more like the way SMF's search feature does for topics?
2
« on: October 17, 2022, 09:34:28 pm »
Hello, I am seeking to get a count of topics given the following code. However, it produces over 500,000 topics, which is exhausting the server. I want to limit it to the first 1000 results, but the LIMIT feature isn't working. Apparently there is a solution here, but I can't get it to work. Do you have any suggestions? $request = db_query(" SELECT COUNT(DISTINCT t.ID_TOPIC) FROM ({$db_prefix}topics AS t, {$db_prefix}boards AS b) INNER JOIN {$db_prefix}messages AS m ON (m.ID_MSG = t.ID_FIRST_MSG) WHERE b.ID_BOARD = t.ID_BOARD AND $query_this_board AND m.topicSolved = 0 AND t.ID_FIRST_MSG = t.ID_LAST_MSG", __FILE__, __LINE__);
3
« on: April 20, 2021, 07:46:54 pm »
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.
4
« on: December 05, 2020, 10:20:23 pm »
Recently, when people checkout via PayPal, it doesn't activate the group membership (since last week actually).
Have there been any prominent changes from PayPal that need updating here?
5
« on: April 21, 2020, 12:42:38 pm »
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?
6
« on: September 30, 2019, 10:06:42 pm »
I know that when a document is uploaded, such as .doc, the mod stores the file without the file extension. I am looking to implement a document reader, such as google docs to display the file as a preview. It is done by using an iframe: <iframe src="https://docs.google.com/gview?url=https://WEBSITE-URL.com/to/doc/file.doc&embedded=true"></iframe> So for this to work, I need to use: https://WEBSITE-URL.com/downloads/'.$context['downloads_file']['filename'].' BUT, $context['downloads_file']['filename'] excludes the file's actual extension type. Even if I add the extension, such as .doc to the end of the string, it will not work because obviously the file stored is extension-less. What ideas do you have that can help me overcome this issue? Of course, I could always create a temporary file in another folder with the extension, but when files get too big, it'd slow down the server.
7
« on: February 13, 2019, 08:49:44 pm »
Curious what would happen if I installed the old store on 2.1
8
« on: October 23, 2018, 11:56:46 pm »
I remember there used to be a way to add your logo rather than email address as the header for the PayPal purchase page. It was done by adding a code to the <input parts.
Could you remind me how it's done?
9
« on: September 05, 2018, 04:45:32 pm »
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?
10
« on: September 05, 2018, 10:00:25 am »
I'd like to use the sessions table to allow guest voting.
In SMF, how do you create a session and how do you customize it to include information about the picture, your IP address, etc.
How does SMF record sessions into the database, what file controls that?
11
« on: August 31, 2018, 02:21:12 am »
How did you get around quoting posts in the quick reply. I can't seem to link the two together
12
« on: August 11, 2018, 11:34:47 am »
I'd like the ability to sell a unique code, i.e. 7sd7;dsh@yu1 that the end user can use in various places in the website, does the store currently have this capability?
13
« on: August 08, 2018, 04:27:44 pm »
Is it fine to record data containing apostrophe characters rather than their HTML codes?
14
« on: July 25, 2018, 01:47:29 pm »
I'd like to redirect all my topics (only) to another url. I tried the following, but it didn't work RewriteEngine On RewriteRule ^/?topic/([^/d]+)/?$ https://NEWURL.com/index.php?topic=$1 [R=301,L]
15
« on: July 09, 2018, 11:58:04 am »
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?
|
Is the PayPal Sandbox still working?
by Nicole
Today at 06:51:18 am
|
Question on Completed Listing & Reserve Price
by Nicole
June 01, 2023, 06:06:12 pm
|
[Mod]GDPR Helper
by Nicole
May 29, 2023, 11:58:49 pm
|
RSS Feed Poster Database Error
by SMFHacks
May 22, 2023, 06:26:18 pm
|
Errors With Older Version.
by Ken.
May 09, 2023, 05:35:40 pm
|
Pretty Urls SEO Pro
by SMFHacks
May 06, 2023, 03:30:11 pm
|
New Post Image Upload Error
by Mike66
April 28, 2023, 07:30:28 am
|
Copyright Removal Key
by SMFHacks
April 03, 2023, 02:44:28 pm
|
Converting from Aeva Media
by sudhakar
April 02, 2023, 11:09:54 am
|
Using SMF's Built-in Search Algorithm
by shuban
March 27, 2023, 09:15:10 am
|
|
|