Facebook  Twitter 

SMFHacks.com

+-

SMFHacks.com

+- User Information

Welcome, Guest.
Please login or register.
 
 
 
Forgot your password?

+- Forum Stats

Members
Total Members: 4220
Latest: agolac
New This Month: 1
New This Week: 1
New Today: 0
Stats
Total Posts: 42854
Total Topics: 7464
Most Online Today: 112
Most Online Ever: 2482
(April 09, 2011, 07:02:45 pm)
Users Online
Members: 0
Guests: 47
Total: 47

Show Posts

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

Pages: [1] 2 3 ... 13
1
Feature Requests / Using SMF's Built-in Search Algorithm
« 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
General SMF Forum / SQL Help
« 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?

Code: [Select]
$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
Code: [Select]
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
Support / Changes to PayPal Recently
« 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
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
Support / Ideas
« 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:

Code: [Select]
<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
Support / Can the old store mod work on SMF 2.1?
« on: February 13, 2019, 08:49:44 pm »
Curious what would happen if I installed the old store on 2.1

8
Support / Adding Logo to Purchase Page
« 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
General SMF Forum / Adding argument into db_query
« on: September 05, 2018, 04:45:32 pm »
How do I add:

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

Code: [Select]
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
Support / Guest Voting
« 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
General SMF Forum / SCEditor implementation question
« 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
Support / Can the Store produce a unique code that you can sell?
« 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
General SMF Forum / Recording apostrophes into tables
« on: August 08, 2018, 04:27:44 pm »
Is it fine to record data containing apostrophe characters rather than their HTML codes?

14
General SMF Forum / htaccess redirect question
« 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
General SMF Forum / SQL Query Slow (Suggestions)
« 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.

Code: [Select]
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?

Pages: [1] 2 3 ... 13

+- Recent Topics

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

Powered by EzPortal