Advertisement:

Author Topic: Pm email notify encourage all members.  (Read 17880 times)

Offline brunob

  • Semi-Newbie
  • *
  • Posts: 49
Pm email notify encourage all members.
« on: October 14, 2013, 04:58:31 PM »
Hello,

I'm using the following.

I want all the zeros in Table pm_email_notify zero on a set.

How can I do this all at once? Involves more than 1,000 members to do so manually each is almost impossible to do.

Can do this through phpadmin? and then build through query?

Regards Bruno

Offline margarett

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,761
  • Gender: Male
Re: Pm email notify encourage all members.
« Reply #1 on: October 14, 2013, 05:03:28 PM »
That's a nice name you have :P

I've never ever see this kind of DB type but you should look into something like
UPDATE table_name
SET column_name = 0

This would work in MySQL...
Se forem conduzir, não bebam. Se forem beber... CHAMEM-ME!!!! :D

Quote
Over 90% of all computer problems can be traced back to the interface between the keyboard and the chair

Offline Herman's Mixen

  • SMF Hero
  • ******
  • Posts: 7,228
    • Herman's Mixen
Re: Pm email notify encourage all members.
« Reply #2 on: October 14, 2013, 05:57:52 PM »
Bruno please do not cross post between boards you already have your answer in the Dutch boards ;)
Met vriendelijke groet, The Burglar!

 House Mixes | Mixcloud | Any Intelligent fool can make things bigger, more complex, and more violent.
It takes a touch of genius - and a lot of courage - to move in the opposite direction. - Albert Einstein

Former Godfather of our dutch community ;)

Offline brunob

  • Semi-Newbie
  • *
  • Posts: 49
Re: Pm email notify encourage all members.
« Reply #3 on: October 14, 2013, 06:19:04 PM »
Hello The Bulgar,

there are people the don't  can't read Dutch  ;) And they also don't speak Dutch  ;D

I will ensure you that I do not do that again about cross posting.

Greetings (groetjes) Bruno  ;D