| Author |
 Topic  |
|
Kat
Advanced Member
United Kingdom
3065 Posts |
 Posted - 19 January 2001 : 06:17:56
|
So you don't have any clues then?
KatsKorner
|
 |
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 19 January 2001 : 06:45:26
|
I am checkin, I am just hunting down my original code changes, to see what the difference is in my original coe, I used a nested select, which was taken out as MySQL does not support it
'Resistance is futile' |
|
|
|
Kat
Advanced Member
United Kingdom
3065 Posts |
Posted - 19 January 2001 : 06:46:47
|
ok - I shall see if i can do anything too. But let me know as soon as you find a fix if you are not too busy.
Catch you later! 
KatsKorner
Edited by - kat on 19 January 2001 06:47:09 |
|
|
|
Kat
Advanced Member
United Kingdom
3065 Posts |
Posted - 19 January 2001 : 08:53:14
|
Ok. update on what I have found is as follows:
add three members to the userlist. this updates correctly.
remove one user leaving two users in userlist. This updates correctly.
remove one more user leaving one user in userlist. This is where it retains the value of the user you have removed. it does not update properly.
IT ONLY HAPPENS WHEN YOU HAVE ONE USER LEFT IN THE LIST AND YOU PREVIOUSLY HAD MORE. No idea if this helps Huw but I am stuck now..
KatsKorner
|
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 19 January 2001 : 09:04:14
|
Thanks for the info, I am a bit tied up, for an hour or two, but will get back to you later.
'Resistance is futile' |
|
|
|
Kat
Advanced Member
United Kingdom
3065 Posts |
Posted - 19 January 2001 : 09:20:26
|
ok no problem.. I am trying it myself anyway! 
KatsKorner
|
|
|
|
Kat
Advanced Member
United Kingdom
3065 Posts |
Posted - 19 January 2001 : 11:35:16
|
Right.. I have solved it.. fantastic. Might not be the best way but I figured it and it works so I shall post it here in a sec..
...watch this space..
KatsKorner
|
|
|
|
Kat
Advanced Member
United Kingdom
3065 Posts |
Posted - 19 January 2001 : 12:16:00
|
In post_info.asp I changed the function for newForumMembers..
sub newForumMembers(fForumID)
on error resume next
if Request.Form("AuthUsers") = "" then
exit Sub
end if
Users = split(Request.Form("AuthUsers"),",")
for count = Lbound(Users) to Ubound(Users)
if Trim(Users(count)) <> "" then
strSql = "INSERT INTO FORUM_ALLOWED_MEMBERS ("
strSql = strSql & " MEMBER_ID, FORUM_ID) VALUES ( "& Users(count) & ", " & fForumID & ")"
'Response.Write("<p>sql: " & strsql)
my_conn.execute (strSql)
if err.number <> 0 then
Go_REsult err.description, 0
end if
end if
next
end sub
Then in post.asp I changed the following to make new script functions:
In InsertSection("Del"):
//finished adding
finished = false;
count = document.PostTopic.AuthUsers.length - 1;
do //remove from source
{
try{
if (document.PostTopic.AuthUsers.options[count].text == "")
{
--count;
continue;
}
}
catch(e)
{
return;
}
if (document.PostTopic.AuthUsers.options[count].selected )
{
for ( z = count ; z < document.PostTopic.AuthUsers.length-1;z++)
{
if ((document.PostTopic.AuthUsers.length-count) == 2)
{
document.PostTopic.AuthUsers.options[z].value = "";
document.PostTopic.AuthUsers.options[z].text = "";
}
else
{
document.PostTopic.AuthUsers.options[z].value = document.PostTopic.AuthUsers.options[z+1].value;
document.PostTopic.AuthUsers.options[z].text = document.PostTopic.AuthUsers.options[z+1].text;
}
}
document.PostTopic.AuthUsers.length -= 1;
}--count;
if (count < 0)
finished = true;
}while(!finished) //finished removing
no time to post any more now but I will Monday .. but this basically fixes it.
KatsKorner
|
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 19 January 2001 : 12:32:05
|
Looks pretty good, will do some testing over the weekend.
'Resistance is futile' |
|
|
|
Reinsnitz
Snitz Forums Admin
USA
3545 Posts |
Posted - 29 January 2001 : 21:35:44
|
how'd it go Huw? 
Reinsnitz (Mike)
><)))'>
"The glory of young men is their strength, and the honor of old men is their gray hair." - Proverbs 20:29
|
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 30 January 2001 : 04:04:47
|
works ok
'Resistance is futile' |
|
|
|
Kat
Advanced Member
United Kingdom
3065 Posts |
Posted - 30 January 2001 : 04:13:43
|
Very happy to hear it! I was hoping you would approve..
KatsKorner
|
|
|
|
Reinsnitz
Snitz Forums Admin
USA
3545 Posts |
Posted - 20 February 2001 : 23:53:04
|
for some reason I'm thinking that this has been addressed... but part of me is saying it hasn't... gah... looking
-bump-
Reinsnitz (Mike)
><)))'>
"Therefore go and make disciples of all nations,..." Matthew 28:19a |
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 21 February 2001 : 00:08:29
|
no it was'nt, if you want me to make the changes, I can do it later. or you can do them.
|
|
|
|
Reinsnitz
Snitz Forums Admin
USA
3545 Posts |
Posted - 21 February 2001 : 20:21:34
|
fixed in the source of sf2k_31sr5a9.zip
Reinsnitz (Mike)
><)))'>
"Therefore go and make disciples of all nations,..." Matthew 28:19a |
|
|
|
Topic |
|
Forum Locked
Topic Locked
