1
tamerlo
Re: howto synchronize all users
  • 2008/4/17 19:41

  • tamerlo

  • Just popping in

  • Posts: 71

  • Since: 2004/1/30


of course

the following code use to temporary table, instead of use sub-quaries, because my host supports am old MySQL version.

create table temp (uid intuname varchar(20), nposts int);
create table temp2 (uid intuname varchar(20), nposts int);

insert into temp
(select xoops_users.uid as uidxoops_users.unamecount(xoops_users.uid) as total from xoops_usersxoops_bb_posts where xoops_bb_posts.uid xoops_users.uid group by xoops_users.uid)
union (select xoops_users.uid as uidxoops_users.unamecount(xoops_users.uid) as total from xoops_usersxoops_xoopscomments where xoops_users.uid xoops_xoopscomments.com_uid group by xoops_users.uid)
union (select xoops_users.uid as uidxoops_users.unamecount(xoops_users.uid) as total from xoops_usersxoops_xcgal_pictures where xoops_users.uid xoops_xcgal_pictures.owner_id group by xoops_users.uid)
order by uid;

insert into temp2 select uidunamesum(*) from temp group by uid;

update temp2xoops_users set xoops_users.posts temp2.nposts where xoops_users.uid temp2.uid;

DROP TABLE `temp`, `temp2`;


with respect to the php function I also added into the count the xcgal posted pictures.



2
tamerlo
Re: howto synchronize all users
  • 2008/4/17 16:52

  • tamerlo

  • Just popping in

  • Posts: 71

  • Since: 2004/1/30


I solved using sql command without go through php script.



3
tamerlo
howto synchronize all users
  • 2008/4/17 9:09

  • tamerlo

  • Just popping in

  • Posts: 71

  • Since: 2004/1/30


Hi, after a problem in my MySQL db I recovered successfully the forum posts. The only issue is the number of posts assigned to each user, this number appears to be reseted.

Looking into the modules/admin/users directory I found that in the file users.php the method synchronize(%id,$type) could synchronize again all users but I don't find any link in the admin section to call this function, also I'm not able to call it in any way

I tried forming the link:

mysite/modules/system/admin.php?fct=users&op=synchronize&type=all+users

but this doesn't work.

Any of you knows how to use this "hidden" feature?

I'm also trying to figure out why the number of posts was reseted when the db lost the entries, but this doesn't happen when the db was repopulated.



4
tamerlo
best chat module
  • 2008/1/11 11:46

  • tamerlo

  • Just popping in

  • Posts: 71

  • Since: 2004/1/30


Hi all, I like to add a chat module to my XOOPS based site. Looking in the module repository is not easy to understand which module is still in development or not, and which characteristics has.

So I like too know which are the most common used modules for XOOPS 2.0 for this task.

thanks



5
tamerlo
Re: Problem with 2.0.14 and comment previews
  • 2006/7/6 12:11

  • tamerlo

  • Just popping in

  • Posts: 71

  • Since: 2004/1/30


many thanks, this solve the problem at the moment.



6
tamerlo
Re: Problem with 2.0.14 and comment previews
  • 2006/7/6 10:05

  • tamerlo

  • Just popping in

  • Posts: 71

  • Since: 2004/1/30


Thank you, I will take in account the SF XOOPS pages too.



7
tamerlo
Re: Problem with 2.0.14 and comment previews
  • 2006/7/6 8:13

  • tamerlo

  • Just popping in

  • Posts: 71

  • Since: 2004/1/30


I only have this problem?

any suggestion?



8
tamerlo
Problem with 2.0.14 and comment previews
  • 2006/7/5 20:52

  • tamerlo

  • Just popping in

  • Posts: 71

  • Since: 2004/1/30


Hi, after the upgrade to 2.0.14 the comment preview function don't work.

If in example I try to insert a comment with a smile and use the preview the comment preview is right, in the text area indeed the text is modified changing the smile with an html tag that have as src the image of the smile. After a further preview the code is changend with the use of slashes.

I have tried to delete the command in include/comment_post.php that strip slashes but this solution don't work.

anyone can help me to solve the problem?



9
tamerlo
Exist security problem in 2.0.13?
  • 2005/8/15 16:38

  • tamerlo

  • Just popping in

  • Posts: 71

  • Since: 2004/1/30


Some hacker send me an e-mail announcing that my XOOPS portal is exposed to a secourity bug correlated to the xmlrpc.php file. This is a real bug?



10
tamerlo
Re: newbb2 problem after upgrading to 2.0.12
  • 2005/7/1 13:31

  • tamerlo

  • Just popping in

  • Posts: 71

  • Since: 2004/1/30


2.0.12a patch change contain an update for newbb1, the file modules/newbb/post.php, if you have applied this patch without remove moudles/newbb directory you have overwrite this file. I think that you can only overwrite again this file from the original post.php script of newbb2.




TopTop
(1) 2 3 4 ... 7 »



Login

Who's Online

675 user(s) are online (500 user(s) are browsing Support Forums)


Members: 0


Guests: 675


more...

Donat-O-Meter

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

Latest GitHub Commits