SMFHacks.com

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__);

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?

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.

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?

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?

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?

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]