dopetalk does not endorse any advertised product nor does it accept any liability for it's use or misuse

This website has run out of funding so feel free to contribute if you can afford it (see footer)

Author Topic: We Need Some php + SQL Code Written  (Read 6143 times)

Offline Opus

  • Tech
  • Sr. Member
  • *
  • SA_Chat+
  • **
  • Join Date: Aug 2015
  • Location: long windy bumpy ass road
  • Posts: 542
  • Reputation Power: 31
  • Opus is working their way up.Opus is working their way up.Opus is working their way up.
  • Last Login:May 06, 2018, 01:21:20 AM
  • 110, 100, 90, 80, 76, 70, 64, 60, 58
Re: We Need Some php + SQL Code Written
« Reply #14 from previous page: August 28, 2015, 09:11:48 AM »
Nah, not too late at all. Just shutdown/remove the shit you don't need and find a cheap box to dedicate for admin tasks..

You're doing fine buddy.
friendly
0
funny
0
informative
0
agree
0
disagree
0
like
0
dislike
0
No reactions
No reactions
No reactions
No reactions
No reactions
No reactions
No reactions
No artist tolerates reality -- Freidrich Neitzsche

The word "republican" comes in the dictionary right after "reptile" and just before "repugnant." -- Julia Roberts

It is no measure of health to be well adjusted to a profoundly sick society -- Krishnamurti

Offline Chip (OP)

  • Server Admin
  • Hero Member
  • *****
  • Administrator
  • *****
  • Join Date: Dec 2014
  • Location: Australia
  • Posts: 6649
  • Reputation Power: 0
  • Chip has hidden their reputation power
  • Gender: Male
  • Last Login:Today at 02:42:05 PM
  • Deeply Confused Learner
  • Profession: IT Engineer
Re: We Need Some php + SQL Code Written
« Reply #15 on: August 28, 2015, 09:15:59 AM »
i'm too worried about removing stuff and i don't have access to another virtual server unless i pay.

thanks for the encouragement.

i'll leave it be for now but thanks for the solid advice.
friendly
0
funny
0
informative
0
agree
0
disagree
0
like
0
dislike
0
No reactions
No reactions
No reactions
No reactions
No reactions
No reactions
No reactions
Our Discord Server invitation link is https://discord.gg/jB2qmRrxyD

Offline somnambule

  • Newbie
  • Join Date: Sep 2015
  • Location:
  • Posts: 9
  • Reputation Power: 2
  • somnambule is new on the scene.
  • Gender: Male
  • Last Login:September 09, 2016, 10:10:51 PM
  • Hmmm.
Re: We Need Some php + SQL Code Written
« Reply #16 on: September 11, 2015, 11:19:23 AM »
I'm late to this thread, and maybe you have it sorted already, but....  You looking for PHP/MySQL help particularly for blocking ip ranges, right?  Cuz'. if you have root access (and aren't on a cheap virtual host or something), why not do thissimply through IP tables. 

Something like this to block a whole subnet:
Code: [Select]
iptables -A INPUT -s 192.168.100.0/24 -j DROP
I just stumbled onto this site which creates country specific IP ranges for blocking.  It seems really spot on, even generates P tables rules.

If you can't use iptables, you can always do something similar using .htaccess.  This way you don't need to add much of anything to the box.

friendly
0
funny
0
informative
0
agree
0
disagree
0
like
0
dislike
0
No reactions
No reactions
No reactions
No reactions
No reactions
No reactions
No reactions
--jesus is coming - hide the bong!--

Offline Chip (OP)

  • Server Admin
  • Hero Member
  • *****
  • Administrator
  • *****
  • Join Date: Dec 2014
  • Location: Australia
  • Posts: 6649
  • Reputation Power: 0
  • Chip has hidden their reputation power
  • Gender: Male
  • Last Login:Today at 02:42:05 PM
  • Deeply Confused Learner
  • Profession: IT Engineer
Re: We Need Some php + SQL Code Written
« Reply #17 on: September 11, 2015, 12:23:21 PM »
we have our own server.

your suggestion is valid but the SMF software also supports ranges too.

I'm going to sit on this one and cross that bridge when I come to it.

my current problem is that I have made so many mods to the software that removing them is now near impossible unless I rebuild it.

so I have opted for a freeze on mods as they are also starting to conflict.

I was aiming for as close as possible functionality with Opiophile so users could move between the two systems with relative ease.
friendly
0
funny
0
informative
0
agree
0
disagree
0
like
0
dislike
0
No reactions
No reactions
No reactions
No reactions
No reactions
No reactions
No reactions
Our Discord Server invitation link is https://discord.gg/jB2qmRrxyD

Offline _Enduser

  • Full Member
  • ***
  • Join Date: Jun 2015
  • Location: Capital Shitty/Filthadelphia
  • Posts: 282
  • Reputation Power: 8
  • _Enduser is new on the scene.
  • Gender: Male
  • Last Login:June 22, 2019, 09:36:28 AM
  • Lex Produca da Original Ableton Killa
    • My original Productions
Re: We Need Some php + SQL Code Written
« Reply #18 on: September 11, 2015, 09:47:04 PM »
Quote
I'm late to this thread, and maybe you have it sorted already, but....  You looking for PHP/MySQL help particularly for blocking ip ranges, right?

Uh oh, what did I do wrong?

 :'( :'( :'( :'( :'( :'( :'( :'( :'( :'( :'( :'( :'( :'( :'( :'( :'( :'( :'( :'(
friendly
0
funny
0
informative
0
agree
0
disagree
0
like
0
dislike
0
No reactions
No reactions
No reactions
No reactions
No reactions
No reactions
No reactions
http://www.soundcloud.com/lexproduca

Please Check out my music!

Offline Chip (OP)

  • Server Admin
  • Hero Member
  • *****
  • Administrator
  • *****
  • Join Date: Dec 2014
  • Location: Australia
  • Posts: 6649
  • Reputation Power: 0
  • Chip has hidden their reputation power
  • Gender: Male
  • Last Login:Today at 02:42:05 PM
  • Deeply Confused Learner
  • Profession: IT Engineer
Re: We Need Some php + SQL Code Written
« Reply #19 on: September 12, 2015, 11:50:49 AM »
Nothing at all, silly.

I wanted to weed out any non-administrative duplicate members in the future and perhaps restrict any banned members from sneaking back in.

just for the future ... everybody is cool so far.
friendly
0
funny
0
informative
0
agree
0
disagree
0
like
0
dislike
0
No reactions
No reactions
No reactions
No reactions
No reactions
No reactions
No reactions
Our Discord Server invitation link is https://discord.gg/jB2qmRrxyD

Offline newphone

  • Newbie
  • Join Date: Jul 2016
  • Location:
  • Posts: 5
  • Reputation Power: 2
  • newphone is new on the scene.
  • Last Login:July 09, 2016, 11:04:22 PM
  • dopetalk.org
Re: We Need Some php + SQL Code Written
« Reply #20 on: July 09, 2016, 10:40:42 PM »
I'm not volunteering to do anything, but you should really use some sort of configuration management tools like puppet or chef to configure the server. That way you can tear it down and rebuild easily. I am a software developer, a systems developer with a background in web development too, but I do enough of that stuff at my day job.
friendly
0
funny
0
informative
0
agree
0
disagree
0
like
0
dislike
0
No reactions
No reactions
No reactions
No reactions
No reactions
No reactions
No reactions

Offline Chip (OP)

  • Server Admin
  • Hero Member
  • *****
  • Administrator
  • *****
  • Join Date: Dec 2014
  • Location: Australia
  • Posts: 6649
  • Reputation Power: 0
  • Chip has hidden their reputation power
  • Gender: Male
  • Last Login:Today at 02:42:05 PM
  • Deeply Confused Learner
  • Profession: IT Engineer
Re: We Need Some php + SQL Code Written
« Reply #21 on: July 10, 2016, 02:37:35 AM »
if I had to rebuild it then putting on the near 100 mods. is the main issue - i run a mirror of the forum at home and update it frequently plus I have copies of all the settings of CentOS /etc libs etc.

Right now, we image the server weekly and at worst it can be simply restored from it. A rebuild is something that will have to be done when the disk space fills up.
friendly
0
funny
0
informative
0
agree
0
disagree
0
like
0
dislike
0
No reactions
No reactions
No reactions
No reactions
No reactions
No reactions
No reactions
Our Discord Server invitation link is https://discord.gg/jB2qmRrxyD

Tags:
 

Related Topics

  Subject / Started by Replies Last post
3 Replies
158 Views
Last post March 09, 2015, 03:57:56 PM
by Chip
3 Replies
9974 Views
Last post July 21, 2015, 03:53:45 AM
by candy
11 Replies
11626 Views
Last post September 29, 2015, 09:11:31 PM
by St. Theresa
7 Replies
10292 Views
Last post November 09, 2015, 01:37:57 PM
by Chip
0 Replies
762 Views
Last post January 18, 2016, 12:04:31 PM
by Z
7 Replies
8241 Views
Last post October 28, 2016, 11:40:39 PM
by Dopeless Hopefiend
26 Replies
22116 Views
Last post August 09, 2018, 04:13:16 AM
by bignasty
11 Replies
11199 Views
Last post January 10, 2017, 10:34:33 AM
by Lolleedee
13 Replies
13994 Views
Last post December 25, 2016, 04:21:53 PM
by dysmorphic
9 Replies
11190 Views
Last post January 11, 2020, 07:47:40 PM
by Hooman


dopetalk does not endorse any advertised product nor does it accept any liability for it's use or misuse





TERMS AND CONDITIONS

In no event will d&u or any person involved in creating, producing, or distributing site information be liable for any direct, indirect, incidental, punitive, special or consequential damages arising out of the use of or inability to use d&u. You agree to indemnify and hold harmless d&u, its domain founders, sponsors, maintainers, server administrators, volunteers and contributors from and against all liability, claims, damages, costs and expenses, including legal fees, that arise directly or indirectly from the use of any part of the d&u site.


TO USE THIS WEBSITE YOU MUST AGREE TO THE TERMS AND CONDITIONS ABOVE


Founded December 2014
SimplePortal 2.3.6 © 2008-2014, SimplePortal