11
MS-2001
Re: User Rank
  • 2005/4/9 13:45

  • MS-2001

  • Quite a regular

  • Posts: 204

  • Since: 2004/7/27


ahhhhhhh, thx. thats it!!! why didnt you say that earlier?
when i imported my userlist from phpnuke to XOOPS i did the mistake to set rank by default to 1...

so the ranks wont change anymore. is it possible to do that:

UPDATE xoops_users SET rank=0 WHERE rank=1 ???


edit: i just found out that this woulnt be all to do. there are still users like that:

uid:20
uname:Michi
rank:3
posts:648

he should have rank:10....

so the sql query should be like that:
UPDATE xoops_users SET rank=0 WHERE 1

after that i have to give some users back their special rank. is that ok?

edit2:
rank with rankid 6,7,13,14,15 are special ranks. so everything would be done with one sql query:

UPDATE xoops_users SET rank=0 WHERE rank<>6 AND rank<>7 AND rank<>13 AND rank<>14 AND rank<>15

i think this was the last edit. so: is it ok? *gg*

12
Mithrandir
Re: User Rank

Sounds fine.

13
MS-2001
Re: User Rank
  • 2005/4/9 15:36

  • MS-2001

  • Quite a regular

  • Posts: 204

  • Since: 2004/7/27


ok, now it works again. thanks a lot

if the field would be named as "specialrank" and not only "rank" i would have known it from the beginning

14
fititnt2
Re: User Rank
  • 2005/4/10 16:38

  • fititnt2

  • Just popping in

  • Posts: 6

  • Since: 2005/4/10


This problem is the same for me =/

15
MS-2001
Re: User Rank
  • 2005/4/11 18:32

  • MS-2001

  • Quite a regular

  • Posts: 204

  • Since: 2004/7/27


Then you've got the solution now. It works fine for me

Login

Who's Online

462 user(s) are online (63 user(s) are browsing Support Forums)


Members: 0


Guests: 462


more...

Donat-O-Meter

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

Latest GitHub Commits