Recent Posts

Pages: 1 [2] 3 4 ... 10
SMF 2.1.x Support / Re: Parse Error: Syntax Error Unexpected
« Last post by Illori on Today at 05:22:34 AM »
also which version of SMF are you using that has this issue?
SMF 2.1.x Support / Re: malware?
« Last post by Illori on Today at 05:20:25 AM »
without seeing the actual files content we cant tell you anything.
what host are you using that is flagging these files?
also which version of SMF are you using?
wow, there's 5317 of them

as you can tell SQL isn't my thing... Is there a script/whatever I can run that will delete the extra ones for me?
SMF 2.1.x Support / malware?
« Last post by horisize on Today at 04:08:03 AM »
I am moving a forum to a new host. They suspect some files are malware. Can anyone confirm this?

[STR]php_self_delete_1 [23/05/19] /home/csscpsg2/public_html/smf/Sources/Subs.php
[STR]php_self_delete_1 [06/04/19] /home/csscpsg2/public_html/smf/Packages/New directory/Sources/Subs.php
[STR]php_self_delete_1 [25/05/19] /home/csscpsg2/public_html/smf_2-1-rc2_install/Sources/Subs.php
OK so that at least answers the question of what the column contains - it contains multiple IP addresses. Quite *why* it contains multiple IP addresses is another story and you should probably just trim the ones that are over-long by hand rather than trying modify the installer.

To find all the ones that are weird like this:

SELECT * FROM smf_messages WHERE poster_ip LIKE '% %';

This will find all the ones with spaces in so you can prune off the IP addresses after the first one.
Not the same ID...

176217   5525   9   1105461436   4   0   Newcastle Meet - 15 &amp; 16 April   Ashley_Davidson   sales@mar****** 81.133.2...   0   1113178706   Ashley_Davidson   Update - Update<br><br>Friday night 15th.<br><br>W...   xx   1
Define “doesn’t work”.
Mod Requests / Re: Popup Announcement before Post
« Last post by Arantor on Today at 03:41:14 AM »
Ah, so you want to have every user close this before posting. Good way to annoy them.
What version of SMF do you have?
Then: SELECT * FROM smf_messages WHERE LENGTH(poster_ip) = 217
Pages: 1 [2] 3 4 ... 10