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


« 1 ... 83 84 85 (86) 87 88 89 ... 29424 »


851
Mamba
Re: Default templates vs Bootstrap 3, 4 and 5 Templates during module installation

  • 2021/5/4 20:46

  • Mamba

  • Moderator

  • Posts: 11375

  • Since: 2004/4/23


I see a potential issues with it - the module doesn't know which version of Bootstrap the currently selected theme is using.

And what happens when the user/admin changes the theme to a different one? Should the Core go through all installed modules and check if there are the templates for this theme? But the Core should be first aware of the Bootstrap version used by the theme.

This would probably require a major rewrite of the Core...
Support XOOPS => DONATE
Use 2.5.10 | Docs | Modules | Bugs
Topic | Forum


852
Mamba
Re: Tutorial for wgSimpleAcc

  • 2021/5/4 20:37

  • Mamba

  • Moderator

  • Posts: 11375

  • Since: 2004/4/23


Very nice work, Goffy! Congratulations!

And thank you for sharing!!!
Support XOOPS => DONATE
Use 2.5.10 | Docs | Modules | Bugs
Topic | Forum


853
goffy
Tutorial for wgSimpleAcc

  • 2021/5/4 14:20

  • goffy

  • Just can't stay away

  • Posts: 535

  • Since: 2010/12/27


Hallo to all

the tutorial for wgSimpleAcc is now available in english

https://xoops.gitbook.io/wgsimpleacc-tutorial/english
Topic | Forum


854
alain01
Re: Default templates vs Bootstrap 3, 4 and 5 Templates during module installation

  • 2021/5/3 13:24

  • alain01

  • Just can't stay away

  • Posts: 530

  • Since: 2003/6/20


Beep !
Topic | Forum


855
DrakenJ35J
Re: xoRewriteModule - Simplified, Short URLs?

  • 2021/4/25 19:14

  • DrakenJ35J

  • Just popping in

  • Posts: 2

  • Since: 2021/4/23


Still, thanks for the URL shortening trick, I'm using Xoops for work and always have issues with kilometric URLs that fudge up texts and make it hard to share information quickly...
Topic | Forum


856
DrakenJ35J
Re: Many users admin->users timing out, mysql pegged at 100% CPU

  • 2021/4/23 17:02

  • DrakenJ35J

  • Just popping in

  • Posts: 2

  • Since: 2021/4/23


Thanks, I had similar issues with users timing out (which was especially problematic when they're supposed to stay logged on for extended periods of time as Xoops is one of our working tools...), clearing the cached did the job!
Topic | Forum


857
liomj
Re: user and group maintenance help

  • 2021/4/23 3:18

  • liomj

  • Just popping in

  • Posts: 80

  • Since: 2012/4/10


Quote:

goffy wrote:
hi

i would suggest:
first determine all relevant uids/links from group 5 and store them in a temporary table
Quote:
CREATE TABLE temp as SELECT linkid, groupid FROM xe07_groups_users_link as query1 INNER JOIN (SELECTxe07_groups_users_link.uid FROM xe07_groups_users_link WHERE (((xe07_groups_users_link.groupid)=5))) AS query2 ON query1.uid = query2.uid;


then delete all items from table groups_users_link from this uids where group_id <> 5
Quote:
DELETE xe07_groups_users_link,temp FROM xe07_groups_users_link INNER JOIN temp ON temp.linkid = xe07_groups_users_link.linkid WHERE xe07_groups_users_link.groupid <> 5


please make data backup before


thank you all

im using geekwright method for now

i need to use php to deal with array
DELETE FROM `xxxx_groups_users_link` WHERE `uid` in (SELECT `uid` from `xxxx_users` where uid in (396,12))
DELETE FROM `xxxx_groups_users_link` WHERE `uid` in (SELECT `uid` from `xxxx_users` where uid='396')
INSERT INTO `xxxx_groups_users_link`(groupid, uid) VALUES (5,396)
Topic | Forum


858
goffy
Re: user and group maintenance help

  • 2021/4/22 18:06

  • goffy

  • Just can't stay away

  • Posts: 535

  • Since: 2010/12/27


hi

i would suggest:
first determine all relevant uids/links from group 5 and store them in a temporary table
Quote:
CREATE TABLE temp as SELECT linkid, groupid FROM xe07_groups_users_link as query1 INNER JOIN (SELECTxe07_groups_users_link.uid FROM xe07_groups_users_link WHERE (((xe07_groups_users_link.groupid)=5))) AS query2 ON query1.uid = query2.uid;


then delete all items from table groups_users_link from this uids where group_id <> 5
Quote:
DELETE xe07_groups_users_link,temp FROM xe07_groups_users_link INNER JOIN temp ON temp.linkid = xe07_groups_users_link.linkid WHERE xe07_groups_users_link.groupid <> 5


please make data backup before
Topic | Forum


859
geekwright
Re: user and group maintenance help

The table you want is groups_users_link

I would suggest
DELETE FROM groups_users_link WHERE uid = uid-to-remove


followed by
INSERT INTO groups_users_link(groupid, uid) VALUES ([special-group-id],[uid-to-remove])
Topic | Forum


860
alain01
Re: user and group maintenance help

  • 2021/4/22 10:46

  • alain01

  • Just can't stay away

  • Posts: 530

  • Since: 2003/6/20


Interresting,

I 've tryed but my MYSQL courses are too far in my head...

I understand what we should do it but not in SQL !

1 - find all uid with with groupid = 5 (easy : SELECT * FROM `xe07_groups_users_link` WHERE `groupid` = 5)
2 - List for each uid with groupid=5, and find their other groupid <> 5
3 - delete these lines

So you keep all uid with groupid = 5

I want to see the SQL request

"remove duplicate occurrence in SQL" but dont keep the first occurrence (keep the occurence with groupid = 5 )
Topic | Forum



TopTop
« 1 ... 83 84 85 (86) 87 88 89 ... 29424 »



[Advanced Search]

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

300 user(s) are online (227 user(s) are browsing Support Forums)

Members: 0

Guests: 300

more...

Donat-O-Meter

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

Latest GitHub Commits