11
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*