| Author |
 Topic  |
|
|
chotie
Starting Member
25 Posts |
 Posted - 10 April 2003 : 14:13:08
|
Hello Snitz Admins.
I am looking for 3 functions.
I am not sure but i think i might find it in register.asp?
1. The function where i create and save a [new member].
2. The function where i update or change settings on a member.
3. The function which removes a member.
Is it possible to POST a new member to register.asp?
I am very grateful for help with this!!
Br,
Christian O.
chot@home.se
============================================================
Background:
I am trying to find a way to merge the logins between
an external xml database and this snitz database.
(The external xml database are used by the portal
FullXML and the goal are to use snitz forum with this.)
|
Br,
Christian O.
chot@home.se |
Edited by - chotie on 10 April 2003 16:33:11 |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 10 April 2003 : 17:18:23
|
| There no functions to do that, AFAIK. The code to create a member is in register.asp, in fact it is just some code to get the values from the form and generate the corresponding SQL statement. Member deletion is done through pop_delete.asp, starting at line# 562 and editing a member. Member profile updating is done in inc_profile.asp, starting around line #1157. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
 |
|
|
chotie
Starting Member
25 Posts |
Posted - 11 April 2003 : 07:43:47
|
Hello again and thank you very much for helping! :)
I am trying to find out som points.
In pop_delete.asp:
Do i have to change or delete the posts a member have done
before i remove him?
When i call pop_delete.asp i use:
'pop_delete.asp?mode=Member&MEMBER_ID=" & Members_MemberID & "')""" dwstatus
from member.asp. Which attributes should i send to be able to delete a member?
mode=Member for deleting a member i can see.
MEMBER_ID for telling which member it is
dwstatus ?
Thanks for helping. :)
Christian O.
chot@home.se |
Br,
Christian O.
chot@home.se |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 11 April 2003 : 07:53:35
|
pop_delete won't really delete the member from the DB, if he has posts. Instead his name his changed to n/a (only if he has posts) and his posts will be kept. If a member to be deleted has no posts, pop_delete will delete it.
pop_delete only requires the two parameters you described: mode=Member & MEMBER_ID= desired member id. Never mind the dwstatus function, it allows a message display when you hover the link in your browser. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
GauravBhabu
Advanced Member
4288 Posts |
Posted - 11 April 2003 : 08:01:47
|
When a member is deleted (by clicking on  from members page) it is processed as below:
1. If the member has made no posts the record is deleted from the database.
2. If the member has made posts the record is not deleted from the database. Instead USERNAME for the member is changed to "n/a" and TITLE is changed to "deleted" |
|
|
|
chotie
Starting Member
25 Posts |
Posted - 11 April 2003 : 08:58:05
|
Thank you both of you. I must be really tired today (friday
and everything..)
I am reading the code, (pop_delete.asp), but keep missing the
control when validating the admin that deletes the user.
Thanks for helping!!
/Christian O. |
Br,
Christian O.
chot@home.se |
Edited by - chotie on 11 April 2003 09:41:20 |
|
|
|
chotie
Starting Member
25 Posts |
Posted - 11 April 2003 : 12:21:02
|
quote:
Originally posted by ruirib
pop_delete won't really delete the member from the DB, if he has posts. Instead his name his changed to n/a (only if he has posts) and his posts will be kept. If a member to be deleted has no posts, pop_delete will delete it.
pop_delete only requires the two parameters you described: mode=Member & MEMBER_ID= desired member id. Never mind the dwstatus function, it allows a message display when you hover the link in your browser.
Thank you!
I am sorry for bugging you but i still have 2 questions.
1.
When deleting a regular "member" (from the member group),
is it sufficient to check if the user has posts, and if
he has i rename the user N/A.
If no posts exists i can delete the member?
2.
When creating a user:
I check that the username and the email does not exist
since before.
Is it ok to just add the new "database-posts" and a secuentiall
"MEMBER_ID" to the snitz-database?
Thanks for helping! :)
Have a great holiday...
Br,
Christian O.
chot@home.se |
Br,
Christian O.
chot@home.se |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 11 April 2003 : 18:00:58
|
quote:
Originally posted by chotie
1.
When deleting a regular "member" (from the member group),
is it sufficient to check if the user has posts, and if
he has i rename the user N/A.
If no posts exists i can delete the member?
I guess so.
quote:
2.
When creating a user:
I check that the username and the email does not exist
since before.
Is it ok to just add the new "database-posts" and a secuentiall
"MEMBER_ID" to the snitz-database?
No it's not enough. There are other required fields. Maybe this post can help: http://forum.snitz.com/forum/topic.asp?TOPIC_ID=43209
The last replies have some info on required fields. Anyway I'm not completely sure on what are the required fields, but those I mention in the other thread are required for sure. I can only advise to test the code you plan to add thoroughly. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
chotie
Starting Member
25 Posts |
Posted - 12 April 2003 : 09:58:00
|
Thanks Ruirib!
One last question on this:
MEMBER_ID is also a required field i understand.
Should i run a stored proc and get the member ID
that i should put into its table?
I dont see code for it.
I am thinking that creation of the member ID
are made when the user are saved into the database.
Are member ID created automaticly and also
automaticly stored when i save the member?
Thanks again!!
Have a great weekend!! :)
Br,
Christian O.
chot@home.se |
Br,
Christian O.
chot@home.se |
|
|
|
GauravBhabu
Advanced Member
4288 Posts |
Posted - 12 April 2003 : 15:05:45
|
quote:
Should i run a stored proc and get the member ID
There is a function getMemberID in inc_func_**** file. It gets the memberid for a username (passed to the function as an argument).
quote:
Are member ID created automaticly and also
automaticly stored when i save the member?
Correct. |
|
|
|
chotie
Starting Member
25 Posts |
Posted - 14 April 2003 : 07:37:39
|
Thk you very much GauravBhabu.
I saw a loop function in pop_delete.asp.
It was on line 568.
I am just thinking: Is this function taking out the last
MEMBER_ID in the database?
loop:
----------------------------------
delAr = split(Member_ID, ",")
for i = 0 to ubound(delAr)
----------------------------------
I am sure i am missunderstanding this.
What are this loop doing?
Thanks a million.. :)
Br,
Christian O.
chot@home.se |
Br,
Christian O.
chot@home.se |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
chotie
Starting Member
25 Posts |
Posted - 14 April 2003 : 08:46:43
|
Yes. I tried it here and it a (ubound of delAR) putted the
MEMBER_ID in the first element. That would make it to execute once.
Thank you ruirib, for clearing that up for me. :)
Br,
Christian O.
chot@home.se |
Br,
Christian O.
chot@home.se |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
| |
Topic |
|
Topic Locked
