XOOPS 
Forum
Forum Index General Forums Community Support Modules Support Themes Support Development International Support Module Hack Reviews Theme Designer Talk


« 1 ... 229 230 231 (232) 233 234 235 ... 29422 »


2311
JammerPro
Re: PHP 7.0 Mods and Responsive Themes

  • 2018/12/17 15:36

  • JammerPro

  • Just popping in

  • Posts: 39

  • Since: 2008/8/24


1) All new publications, I am the only writer...

2) MyIFrame gives the message after you submit the iframe info that "you have not filled in all fields" even though I did.

3) How about what is the procedure for deleting all users but me (admin) in Phpmyadmin. What table and procedure should I use... I can isolate the bad users by selecting those who have "no connection" but I don't know what table and syntax to use...

.
Topic | Forum


2312
Mamba
Re: PHP 7.0 Mods and Responsive Themes -Last Question

  • 2018/12/17 5:06

  • Mamba

  • Moderator

  • Posts: 11366

  • Since: 2004/4/23


1) Is this for all new publications?

2) Why problems do you have with myiframe? What errors are you getting? How can we reproduce it?

3) The best way would be to use phpMyAdmin:
a) save the record for webmaster, manually, or via a query (e.g. for all users with user id = 1)
b) delete all records
c) import the webmaster record
Support XOOPS => DONATE
Use 2.5.10 | Docs | Modules | Bugs
Topic | Forum


2313
JammerPro
Re: PHP 7.0 Mods and Responsive Themes -Last Question

  • 2018/12/16 22:11

  • JammerPro

  • Just popping in

  • Posts: 39

  • Since: 2008/8/24


First, thanks for all the help!

I am getting back up to speed and now understand how to install and upgrade Xoops, and use the xbootstrap generated themes.

Take a look! http://CyberEntertainmentLaw.com

I got publisher working, but its acting up a little with respect to approving the new publications. They show up under published within the summary section right away, but not in the articles section.

I did manage to load myiframe, and thought it might work, but it didn't because it thought I hadn't filled out all the fields. Would love to see that mod work.

LAST, BUT MOST IMPORTANT. At the above referenced site, I was hit by some kind of mass register spam bot in the past and have over 10,000 users... Is there a MASS DELETION TOOL in 2.5.9? Couldn't find it.

I WOULD LOVE TO DELETE ALL USERS BUT ME... admin. Is there a single command or table I can drop?

I remember we discussed this years ago. It would take me quite some time to dump users 100 at a time.

Anyhow, one older Xoops site updated to php 7.0, 4 to go LOL.

All the best.

JammerPro
Topic | Forum


2314
geekwright
Re: Database: How do I set a column value to NULL

Quote:
luciorota wrote:
...
I think it is a Xoops limit...

Sadly, you are correct.

I did a dive into the code when I saw your question, and the XoopsObject family seems to have no direct support for NULLs. Updating a column to NULL presently would require building the update query manually and running it with the database query() method.

Likewise the handling of a NULL value in selects seems to be datatype dependent, more like a side effect.
Topic | Forum


2315
geekwright
Re: xoops Password rules and password expiry

XOOPS could really use some modern password policy management tools.

My first impulse was to suggest expanding the profile module, but on closer inspection, using existing events and adding a few new ones would allow us to support a module(s) dedicated just to enhanced password policy. Unfortunately, that solution isn't available to deploy today

I will make sure that we have all the events needed to support such a module in place very soon.

Meanwhile, the fastest "hack" I can think of would be to tap into an existing Active Directory, using it as the authentication option for your XOOPS system. I don't know it that would be possible or practical for your environment.

As to resetting all passwords, you could update the "pass" column on the users table with some garbage string for all the users you want to reset. Each user would then have to go through the lost password mechanism to set a new password.
Topic | Forum


2316
luciorota
Re: Database: How do I set a column value to NULL

  • 2018/12/15 11:37

  • luciorota

  • Module Developer

  • Posts: 216

  • Since: 2007/4/20


Hi Mamba
Everything checked

I think it is a Xoops limit...
Topic | Forum


2317
Mamba
Re: Database: How do I set a column value to NULL

  • 2018/12/15 2:44

  • Mamba

  • Moderator

  • Posts: 11366

  • Since: 2004/4/23


Are you testing it on Windows? Maybe you need to turn off the "STRICT_MODE" in the MySQL configuration
You might also use "datetime" instead of "date"
See:
https://stackoverflow.com/questions/1691117/how-to-store-null-values-in-datetime-fields-in-mysql
Support XOOPS => DONATE
Use 2.5.10 | Docs | Modules | Bugs
Topic | Forum


2318
luciorota
Re: Database: How do I set a column value to NULL

  • 2018/12/14 22:15

  • luciorota

  • Module Developer

  • Posts: 216

  • Since: 2007/4/20


Thanks Mamba
I would like to reset time_update value to NULL
When i use an expression like this:

$itemObj->setVar('myDate', NULL);


does note set 'MyDate' field to NULL but to '0000-00-00'
are there some tips to solve my question?

Thanks again
Topic | Forum


2319
sarahmx
Re: xoops Password rules and password expiry

  • 2018/12/14 9:18

  • sarahmx

  • Quite a regular

  • Posts: 381

  • Since: 2007/10/28


Thank you for the answer Mamba

Im not sure if i can do this myself ..thinking of creating a custom module just to make this work using jquery validation or something else

Any other pointers will be great
Topic | Forum


2320
Mamba
Re: xoops Password rules and password expiry

  • 2018/12/14 5:20

  • Mamba

  • Moderator

  • Posts: 11366

  • Since: 2004/4/23


I don't think that there would be an easy hack for it.

a) to keep track of the 6-months interval, you would have to record the date for each user. Maybe you could add an extra field in the Profile and make visible only to the admin. Then you would have hack the core to check at login when user changed that login last time and force him/her to change it.
Or you could add a field to Profile for a reset, and then run a cron every six months to reset all users to yes, and thus force the user to change the password.

b) you could set the check in your new hack as a field validation

c) while checking for the reset, if it is on, you could then save the current password and compare it to the new one, to make sure that they don't match

Another way that might be easier, would be to run a cron job that would use the "lostpass.php" to fake for each user a request for a new password, sending them a new password and forcing them to use it, and to change to whatever they want.

Richard is the guru in this area, so maybe he could come up with better...
Support XOOPS => DONATE
Use 2.5.10 | Docs | Modules | Bugs
Topic | Forum



TopTop
« 1 ... 229 230 231 (232) 233 234 235 ... 29422 »



[Advanced Search]

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

67 user(s) are online (48 user(s) are browsing Support Forums)

Members: 0

Guests: 67

more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: May 31
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits