Clearing out Favorites

[bkenobi]

I was pretty sure it was possible to just use the Admin screen in the Advanced Configuration to remove all favorites, but it appears that doesn't currently work. In case that is not supposed to do that and you want to delete the favorites data WITHOUT deleting all the other data, there is a way (provided you have a way to run a query on data.mdb).

If you create an update query and add the favorites column, set criteria to 1, then put null in the update field, you will remove all 1's from the DB. Here's the SQL for those that read it:

UPDATE Data SET Data.Favorite = Null
WHERE (((Data.Favorite)=1));

Incidentally, I figured there might be a REALLY easy way for Tom to implement multiple favorites categories in GameEx. Currently, the favorites field contains numerical boolean data (1's and 0's). This could be changed slightly in the logic so that it's slightly extended. 0 is still false, but if you made 1 for user 1, 2 for user 2, etc then it would just be a matter of allowing for the creation of a favorites category on the fly I guess. I can explain better, but I figured a programmer would probably understand without all the words...

[greatflash]

I was pretty sure it was possible to just use the Admin screen in the Advanced Configuration to remove all favorites, but it appears that doesn't currently work. In case that is not supposed to do that and you want to delete the favorites data WITHOUT deleting all the other data, there is a way (provided you have a way to run a query on data.mdb).

If you create an update query and add the favorites column, set criteria to 1, then put null in the update field, you will remove all 1's from the DB. Here's the SQL for those that read it:

UPDATE Data SET Data.Favorite = Null
WHERE (((Data.Favorite)=1));

Incidentally, I figured there might be a REALLY easy way for Tom to implement multiple favorites categories in GameEx. Currently, the favorites field contains numerical boolean data (1's and 0's). This could be changed slightly in the logic so that it's slightly extended. 0 is still false, but if you made 1 for user 1, 2 for user 2, etc then it would just be a matter of allowing for the creation of a favorites category on the fly I guess. I can explain better, but I figured a programmer would probably understand without all the words...

I dont really understand what you mean, but... What if user 1 & 2 add a favourite for the same game? or are you implying a binary string (say 8 users, 1=user 1, 2=user 2, 3=user 1+2, 5=user 1+3, etc)?

[bkenobi]

Hmm, I forgot that you could have multiple users that want to play the same game. I suppose binary wouldn't be bad though. Bit 1 for user 1, bit 2 for user 2, etc. I like it!

[greatflash]

Hmm, I forgot that you could have multiple users that want to play the same game. I suppose binary wouldn't be bad though. Bit 1 for user 1, bit 2 for user 2, etc. I like it!

My god! I thought of something and was RIGHT!