• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Liutauras Vilda
  • Jeanne Boyarsky
  • Devaka Cooray
  • Paul Clapham
Sheriffs:
  • Tim Cooke
  • Knute Snortum
  • Bear Bibeault
Saloon Keepers:
  • Ron McLeod
  • Tim Moores
  • Stephan van Hulst
  • Piet Souris
  • Ganesh Patekar
Bartenders:
  • Frits Walraven
  • Carey Brown
  • Tim Holloway

jforum_users.user_active vs jforum_users.deleted

 
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
SELECT user_active, deleted FROM jforum_users WHERE username LIKE 'VVD'
user_active, deleted
NULL, NULL

http://myhost/adminUsers/list.page
I set checkbox for user VVD and press button "Lock/Unlock".
Then look at db:
SELECT user_active, deleted FROM jforum_users WHERE username LIKE 'VVD'
user_active, deleted
NULL, 1

Then I unlock user:
SELECT user_active, deleted FROM jforum_users WHERE username LIKE 'VVD'
user_active, deleted
NULL, 0

In file generic_queries.sql I found queries with user_active column, but I can't find how it used in forum...

P.S. On Russian I can describe my question better. :-)

[originally posted on jforum.net by VVD]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I want to add status to user:

SELECT * FROM users_status
sid, statusname
1, Request for regidtration of new User
2, Active User
3, Blocked User
4, Request rejected

I can add new column to table jforum_users with name sid, but better if forum & myapp will use same column for locking users.

By default user can self get account only on forum. In myapp only admistrator can confirm user registration. What column I can use for it: user_active or deleted? (Changes to forum cleasses I'll try to do self.)
[originally posted on jforum.net by VVD]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

VVD wrote:I want to add status to user:

SELECT * FROM users_status
sid, statusname
1, Request for regidtration of new User
2, Active User
3, Blocked User
4, Request rejected

I can add new column to table jforum_users with name sid, but better if forum & myapp will use same column for locking users.

By default user can self get account only on forum. In myapp only admistrator can confirm user registration. What column I can use for it: user_active or deleted? (Changes to forum cleasses I'll try to do self.)



If you want to implement this feature, best way is
- create SQL DDL script for update DB
- implement new DAO class for work user' s status
- create freemakers template for manipulate users status
- change jForum classes for support user's status work-flow
- and commit in CVS )
[originally posted on jforum.net by Serge Maslyukov]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
?�???���??�? ?���?� ����?? ?�?� �??�?��? ?���?�?��?��?�???Ȅ?�?�� �?��?� 2 ?�???Ȅ? ?� ???�??? ?�?� ???�??? ?�?� ???�� ?�??�???Ȅ�?�???���� ?�?Ȅ? ?�?�??? ��?�?�?�?
?�?�???�?�?�??�?�� ???�?���?���?�?�???�?�, ����?? ?? ��?�?�?�?�?� �??�?���??? ?��Ą�?� ???�?�??�???Ȅ�?��?�??�܄� ?�???�?�??, ?�??�?��???�� ???� ��??��?���?�? ?�???�?�???Ȅ?��� ?���� ???�???.
?�???�???�???, �? ��??��?�?� ?��?�???�? ��??�ۄ�???�, ?ȄĄ���?� ???� ?�?�?�?���� ��?�?�?�?�� users_status, ?� ?�??�???Ȅ�?�???���� ��?�???Ȅ� /WEB-INF/config/languages/* ?�?Ȅ? �Ʉ�?�???�???�? ???�?�???�???�?? �?��?���Ą???. ??? ???���??�? ??�?�� ��?�??? ???� ?? �?��???. :-)

?���� ???���??�?: ?�?� ?�?�?�?�� �???���?�?�?�???�?? ?���?�?? ��?���?�??? ?�??�???Ȅ�?�???���� ???� jsp, ?� freemarker? (?�???� ?���??�?��?? ?�??��?���?��??? ?� �??�?? ?���???��? - ???�?��� ?�?�??�?��???��?���??? ?�???�?��� �???�܄??�?...)
[originally posted on jforum.net by VVD]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

VVD wrote:?�???���??�? ?���?� ����?? ?�?� �??�?��? ?���?�?��?��?�???Ȅ?�?�� �?��?� 2 ?�???Ȅ? ?� ???�??? ?�?� ???�??? ?�?� ???�� ?�??�???Ȅ�?�???���� ?�?Ȅ? ?�?�??? ��?�?�?�?
?�?�???�?�?�??�?�� ???�?���?���?�?�???�?�, ����?? ?? ��?�?�?�?�?� �??�?���??? ?��Ą�?� ???�?�??�???Ȅ�?��?�??�܄� ?�???�?�??, ?�??�?��???�� ???� ��??��?���?�? ?�???�?�???Ȅ?��� ?���� ???�???.
?�???�???�???, �? ��??��?�?� ?��?�???�? ��??�ۄ�???�, ?ȄĄ���?� ???� ?�?�?�?���� ��?�?�?�?�� users_status, ?� ?�??�???Ȅ�?�???���� ��?�???Ȅ� /WEB-INF/config/languages/* ?�?Ȅ? �Ʉ�?�???�???�? ???�?�???�???�?? �?��?���Ą???. ??? ???���??�? ??�?�� ��?�??? ???� ?? �?��???. :-)

?���� ???���??�?: ?�?� ?�?�?�?�� �???���?�?�?�???�?? ?���?�?? ��?���?�??? ?�??�???Ȅ�?�???���� ???� jsp, ?� freemarker? (?�???� ?���??�?��?? ?�??��?���?��??? ?� �??�?? ?���???��? - ???�?��� ?�?�??�?��???��?���??? ?�???�?��� �???�܄??�?...)



��?�?� ?�?�?� �?��??�� ?���???�?��� open source. ?�??? ?�??�???Ȅ�?��?��� ?�???Ȅ΄�???� ?�???�?��?��?��??? �??�?���???. ?�?Ȅ? ��??? ����???��� ???� ???�???�?�?�?? ?�???��?�?�?���?� ?�??�???Ȅ�?�???�???�? ?�???�?�??, ??�?�? ???��? ���???���?�???�?Ȅ�???�?��� ?�???�?�???� ?�?�?�?���΄?�? ???�?�?�???�??�??? ??�� ��?�?��Ą�?�?? ?�?�.
?�???�?�???��� ?�???�?�?�?�?�?���?�? ?�?Ȅ? �?��?���Ą??? ???� ��ۄ�?�???. ?���?�?? ?��� ?� ��?�??�� ?�???�?�???Ȅ?��� )

???���??�? jsp vs freemaker ?ȄĄ���?� ?�?�?�?���� ???� ?�???�?�??�??�??? ?�?���?��??Ȅ?, ?�??��??�ۄ� ?���???�?���?�. ?? ?���?� ?��?��� ??��???�

[originally posted on jforum.net by Serge Maslyukov]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

Serge Maslyukov wrote:��?�?� ?�?�?� �?��??�� ?���???�?��� open source. ?�??? ?�??�???Ȅ�?��?��� ?�???Ȅ΄�???� ?�???�?��?��?��??? �??�?���???. ?�?Ȅ? ��??? ����???��� ???� ???�???�?�?�?? ?�???��?�?�?���?� ?�??�???Ȅ�?�???�???�? ?�???�?�??, ??�?�? ???��? ���???���?�???�?Ȅ�???�?��� ?�???�?�???� ?�?�?�?���΄?�? ???�?�?�???�??�??? ??�� ��?�?��Ą�?�?? ?�?�.
?�???�?�???��� ?�???�?�?�?�?�?���?�? ?�?Ȅ? �?��?���Ą??? ???� ��ۄ�?�???. ?���?�?? ?��� ?� ��?�??�� ?�???�?�???Ȅ?��� )


?�.?�. ��?�?�???�?��� ?�???��� ?�?� N ?�???�?�?? - �?��?? ?ȄĄ���?�?? ???���?�?�??��?
?�?Ȅ? �???��?��?�???�?��?� ???�?���?? ???� ???���?�?��� ?�???�?�???��� �??���?�?��� ?�?�?�?�??��?� ?�?�?�� ?? ?�?�?���?�?��Ą�?�?? ?� ???�?�?�??���� ?�???Ȅ΄�?�???� ?���?��???��???� ?�?��??��???� ?���?�???�?�???� ?? readme ����???��� ??�??� ?���?? ?�?�??��?�???��?��?�? �? ��?�?�???-��?? ??��?��??�?� ?�???�?�??�� ?�?�?��Ą?��?��� �?��??�� �??���?�?���. ?�?���?�?? ?�?� �???�??? ��?���?��� "??��?�?�?�?�" ?���??��?�???

???���??�? jsp vs freemaker ?ȄĄ���?� ?�?�?�?���� ???� ?�???�?�??�??�??? ?�?���?��??Ȅ?, ?�??��??�ۄ� ?���???�?���?�.


?�???�?��???.

?? ?���?� ?��?��� ??��???�


??��?? �? ��?�?� ?�??��?��?�?�. ???��?��� ?�?� ???���??�? ???� "����?? ��?�?�???� freemaker?", ?� "?�?� ?�?�?�?�?� ?�???�??? ?�?Ȅ?�?�� ?�?? �?��?�???�???�? �? jsp ??? ?���?� ??��?���?�???". ??�� ?�?� ?�?�?�???. :-)

?? ��?�?�?��ۄ� ?�?? �?�Ą�?��?���: ����?? ?�???���?�� ?�?�?�?�???� ?�?� �?��?�� ?�??�Ą� ?�???�?�?? ?� ?�?�?� ???�?�?�?�� ��?�?�?�?��??��?� ?�� ?�???���?�???�? ???� ��?�?�??��� ��??�ۄ�???�?
?�?�?? ?�???�???��?, ����?? ?��??�?�???�?�???��?�??? ?�???�?���, ??? �?��?? ??��?�??�?, ?� ??��?�??�? - �?��?? ?�?�??��???�... :-(
[originally posted on jforum.net by VVD]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

VVD wrote:
?�.?�. ��?�?�???�?��� ?�???��� ?�?� N ?�???�?�?? - �?��?? ?ȄĄ���?�?? ???���?�?�??��?
?�?Ȅ? �???��?��?�???�?��?� ???�?���?? ???� ???���?�?��� ?�???�?�???��� �??���?�?��� ?�?�?�?�??��?� ?�?�?�� ?? ?�?�?���?�?��Ą�?�?? ?� ???�?�?�??���� ?�???Ȅ΄�?�???� ?���?��???��???� ?�?��??��???� ?���?�???�?�???� ?? readme ����???��� ??�??� ?���?? ?�?�??��?�???��?��?�? �? ��?�?�???-��?? ??��?��??�?� ?�???�?�??�� ?�?�?��Ą?��?��� �?��??�� �??���?�?���. ?�?���?�?? ?�?� �???�??? ��?���?��� "??��?�?�?�?�" ?���??��?�???



?���?� ��?�?� ?�???��??�ۄ?�?�� - ?���???�?��� ???�?��ۄ???�ۄ? ?� ?��ۄ�???�?� ��?�?��?�?�??���?�?�?� ��?�?� ???�Ą� ?�??�???Ȅ�?�???���� �?��?� ?�???Ȅ? ?�?Ȅ? ?��ۄ�???�� ��?�?�?�??.
?��Ą� ��?�?�, ?���?? ?�?���??��?? ??�?��?�?� ��??? ?� ��?�?�?�?�, ��.?�. ?�???Ȅ?.


[originally posted on jforum.net by Serge Maslyukov]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
??�� ��?�?� ?�???ȄĄ�?��?�?, ����?? ???�??? ?� ��???�?� ?�?�??�?��???�?� - ?�?�???�?��???�?� ?�???Ȅ�?�???���?�?Ȅ? - ?���?�?��� ??��?�???�??�?��΄?�? ?�??��??�? ��?�?�??��???� �??�??�???�?�???�. ??��?? ???��???�?Ȅ�???

?�?�?�??? - ?�?Ȅ? �??�?��? �? ��?�?� ��?���?�?� ?�?�?� ?���?��� ?�?�?�?����.
?��??�?� ?�???ȄĄ�?��?�? ����??-��?? �?��??�?��?�?� - ???��??�?���?�?Ȅ�??? ??��?�???��� ?�?����.
[originally posted on jforum.net by VVD]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

VVD wrote:??�� ��?�?� ?�???ȄĄ�?��?�?, ����?? ???�??? ?� ��???�?� ?�?�??�?��???�?� - ?�?�???�?��???�?� ?�???Ȅ�?�???���?�?Ȅ? - ?���?�?��� ??��?�???�??�?��΄?�? ?�??��??�? ��?�?�??��???� �??�??�???�?�???�. ??��?? ???��???�?Ȅ�???

?�?�?�??? - ?�?Ȅ? �??�?��? �? ��?�?� ��?���?�?� ?�?�?� ?���?��� ?�?�?�?����.
?��??�?� ?�???ȄĄ�?��?�? ����??-��?? �?��??�?��?�?� - ???��??�?���?�?Ȅ�??? ??��?�???��� ?�?����.



�? ?�?�?� ?�???�??� ��?����� ��?�?� ???� ?���??�?��?? ?? ?�?�???�?��???�?�, ?� ???� ???���?�?�??��?�?� ��?�?�?�?��??�܄� �?��?���Ą??? - ?�?�?���??�? ��?�???�?���?���?�?�, ?�???���???���?�?�?�???�?� ��?�???�?���?���?�?�, ??��?�?�???�???�?�, �???��?��???�??? ?�?�???�?��???�?�.

?�?� ???��???�?Ȅ�???. ?�??��??? �?��?���?��? ���???���?�???�?Ȅ�???�?��� ?���?�?��� ?���??�?��?? ??��?�?Ȅ?��?�???� ?�?�?� �Ą�?���?�?� ???.
[originally posted on jforum.net by Serge Maslyukov]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
??�� ?�?�.
?��Ą� ?���� ??��?�??? ?���???���???���� ?�???�?��� - �? ?�?�?�?�???� �?��?���Ą??�???� ?�???Ȅ�?�???���?�?Ȅ� ???�?��� ?�???�???��΄?�? ???� ��??�ۄ�??, �? ?�?�?�?�???� ???� �??�??�� ?� ???�???�???�?��� �?��?? ???��?���?�?�???����.
?�???�?� �? �??�?�?�?��? �??�??��?? ?���??�?��??? ???���?�?�??�� - ��??�ۄ�?? ?���?�?��� ?�?��� �??? �???�???� ?�?�???�?��???�?�???�, ?� �??�??�� �??? �???�???�. ?� ?�???�?�?�?Ȅ�???�?� ��?�?� ??��?�??? ?�???�?�?�?���� ��??��� ?�?�?��Ą?-��?? ?�� ?�??��?�??��?���?�?...
[originally posted on jforum.net by VVD]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
?���� ?�???��Ą�??? ???���??�?: �? ???� ???�����?� ?? ?�?�?�?� ???� ???�??? Foreign Key. ?�.?�. ?�?�?��?�-��?? ?��?���, ��???Ȅ�?�?? �??���???��� ?�?�?� ?�?�???�܄� ???� ?�???�?��� ?? ��???, ����?? �?��?? ?�?Ȅ?��.
?�?? ?�?�?�?� �?��?? ???�???���?�??? �??�?�?��???�?���?�? ???� ?���???�?�???�?��?�?Ȅ�???�?��?�.
??��?? �??�?�?�?�??? ��???Ȅ�?�?? ?�?�-?�?� �???��?��?�???�?��?� �??? �?��?��ۄ�???� ?�?�, ?? ?�??��??�ۄ܄� ?�???���??�?��?? ???�?��� ???� ?��܄�� ��?�?�??? ?�???�?��?�? ?�?�?� Foreign Key, ?�?�?� ?���??�?��?? ???��??�?�?�?�?� ?�?�?� ��?�?� ??�� ��?�?�?�� ?�?�?
[originally posted on jforum.net by VVD]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

VVD wrote:?���� ?�???��Ą�??? ???���??�?: �? ???� ???�����?� ?? ?�?�?�?� ???� ???�??? Foreign Key. ?�.?�. ?�?�?��?�-��?? ?��?���, ��???Ȅ�?�?? �??���???��� ?�?�?� ?�?�???�܄� ???� ?�???�?��� ?? ��???, ����?? �?��?? ?�?Ȅ?��.
?�?? ?�?�?�?� �?��?? ???�???���?�??? �??�?�?��???�?���?�? ???� ?���???�?�???�?��?�?Ȅ�???�?��?�.
??��?? �??�?�?�?�??? ��???Ȅ�?�?? ?�?�-?�?� �???��?��?�???�?��?� �??? �?��?��ۄ�???� ?�?�, ?? ?�??��??�ۄ܄� ?�???���??�?��?? ???�?��� ???� ?��܄�� ��?�?�??? ?�???�?��?�? ?�?�?� Foreign Key, ?�?�?� ?���??�?��?? ???��??�?�?�?�?� ?�?�?� ��?�?� ??�� ��?�?�?�� ?�?�?



�? ???� ��?�?� ?�?�??? ��?�?�??��?��? �? jforum, ?�??�?��???�� ???� ?�???��? ?�??��?�??�� �??�??��?��? ???��� fk. ?ӄ�???��? ����?? �?��?? ???��??�?�?�?�?� ??�� mysql 3.x

???� ?���???�?�???�?��?�?Ȅ�???�?��� fk ???�?�?�?�� ?�?�?� ��?�?� �? ��??��???�?��΄? ?�?? ???�???�??��??��. ?Մ??� DML ???�?���?���?�?� ��?�?�??��?��?�� ???�?�?�?�???�?�.

?���???�?�???�?��?�?Ȅ�???�?��� ��???�?�?��?�???�?���?�? ???�?�?��?�?�?? ?�???�?�?��???. Fk ???� ?�???�?�?��?
[originally posted on jforum.net by Serge Maslyukov]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
??�� ?��?��?��?��???�??? ???� fk ??��?�??? ?� ?�???�?�?��? ???���?���� ?�???���?� ?�???�???�???� �???�܄??�?� ?�?��?�?�?�?���.
[originally posted on jforum.net by VVD]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
?�???�?� user_lastvisit ��???�?� ??�??�???�?� null...
???�?�?��?�?�� ?��??�?� �? ?�??? ?�?��??�?��?, ��?? ???��?�??? ???� ??��???�?�?��?�?. :-)
[originally posted on jforum.net by VVD]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Russian test.
??? ??? ???.

[originally posted on jforum.net by VVD]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hm...
Who has broken support of cyrillic? :evil:
[originally posted on jforum.net by VVD]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I guess it was me.. sorry

Rafael
[originally posted on jforum.net by Rafael Steil]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Can u fix?
plz :-)
[originally posted on jforum.net by VVD]
 
Consider Paul's rocket mass heater.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!