Bitfields??

[rogersnm]

I need to work on a mod which i have already made but i need to make it ajaxed the original mod is here:
https://vborg.vbsupport.ru/showthread.php?t=116902

i would like to learn ajax as well all the code is written for the normal version i just need someone to tell me how and where to change it (or do it for me) to make it ajax supported.

Currently it You click on the link and it goes through to page which has an if on it:

PHP Code:

if ($vbulletin->userinfo[sig])
{
                        $userid = $vbulletin->userinfo[userid];
                        $db->query_write("UPDATE " . TABLE_PREFIX . "user
                                SET sig='0'
                                WHERE userid='$userid'
                        ");
}
else
{
                        $userid = $vbulletin->userinfo[userid];
                        $db->query_write("UPDATE " . TABLE_PREFIX . "user
                                SET sig='1'
                                WHERE userid='$userid'
                        ");
} 


and then around the signature code i have:

PHP Code:

<if condition="$bbuserinfo[sig] == 0">
        <!-- sig -->
        Signature Code
        <!-- / sig -->
</if> 


I need it so when you click on the link it runs the sql query on the page it is on and then updates it via ajax.

I don't think it'll be to hard (he hopes).

Regards,
Nick.

[Zachery]

Like i commented before, you should really work on updating the real user permissions instead of a new one youu have added.

[rogersnm]

yes, but which user permission do you think i should work on?

[Zachery]

Since the permission to view or not view sigs already exists, you should update that one.

[rogersnm]

where? whats it's column name?

[Zachery]

Its not a column, its stored as a bitfield. Look its permission up in the user datamanager.

[rogersnm]

bump still the same question...

[Zachery]

Did you look at the user datamanager like I suggested?

[rogersnm]

everyone i asked just didn't know ie. the administrator of vbhackers (Deaths) can you tell me where it is or point me to a tutorial....
and tell em what to put in a file to retrieve the bitfield value ie:

PHP Code:

$sigpermission = who_knows; 


Regards,
Nick

[Zachery]

The setting is stored in the options field in the user table. the option is stored as a bitfield. You can lookup what bitfields do what in includes/xml/bitfield_vbulletin.xml

PHP Code:

            <group name="useroptions">
                <bitfield name="showsignatures">1</bitfield>
                <bitfield name="showavatars">2</bitfield>
                <bitfield name="showimages">4</bitfield>
                <bitfield name="coppauser">8</bitfield>
                <bitfield name="adminemail">16</bitfield>
                <bitfield name="showvcard">32</bitfield>
                <bitfield name="dstauto">64</bitfield>
                <bitfield name="dstonoff">128</bitfield>
                <bitfield name="showemail">256</bitfield>
                <bitfield name="invisible">512</bitfield>
                <bitfield name="showreputation">1024</bitfield>
                <bitfield name="receivepm">2048</bitfield>
                <bitfield name="emailonpm">4096</bitfield>
                <bitfield name="hasaccessmask">8192</bitfield>
                <bitfield name="postorder">32768</bitfield>
                <bitfield name="showbirthdays">65536</bitfield>
                <bitfield name="noactivationmails">262144</bitfield>
            </group