1 - allow the use of icons themes
- Is growing operation
UPDATE forum SET options = options + 1024 WHERE NOT (options & 1024);
- Ordered the suspension cultivation
forum SET options = options - 1024 WHERE options & 1024;
2 - To allow assessment of subjects
- Is growing operation
UPDATE forum SET options = options + 2048 WHERE NOT (options & 2048);
- Ordered the suspension cultivation
UPDATE forum SET options = options - 2048 WHERE options & 2048;
3 - Showing Avatars
- Is growing operation
UPDATE user SET options = options + 2 WHERE NOT (options & 2)
- Ordered the suspension cultivation
UPDATE user SET options = options - 2 WHERE options & 2
4 - View signatures
- Is growing operation
UPDATE user SET options = options + 1 WHERE NOT (options & 1)
- Ordered the suspension cultivation
user SET options = options - 1 WHERE options & 1
5 - View Photo
- Is growing operation
UPDATE user SET options = options + 4 WHERE NOT (options & 4)
- Ordered the suspension cultivation
UPDATE user SET options = options - 4 WHERE options & 4
6 - Activating the members of the palace
- Is growing ऑपरेशन
user
SET options = options + 8 WHERE NOT (options & 8) UPDATE user SET options = options + 8 WHERE NOT (options & 8)
- ordered the suspension cultivation
user SET options = options - 8 WHERE options & 8
7 - Receiving messages from and to the Director-General
- Is growing operation
user SET options = options + 16 WHERE NOT (options & 16)
- Ordered the suspension cultivation
user SET options = options - 16 WHERE options & 16
8 - Show e-mail Member
- Is growing operation
UPDATE user SET options = options + 256 WHERE NOT (options & 256)
- Ordered the suspension cultivation
UPDATE user SET options = options - 256 WHERE options & 256
9 - incognito mode
- Is growing operation
UPDATE user SET options = options + 512 WHERE NOT (options & 512)
- Ordered the suspension cultivation
UPDATE user SET options = options - 512 WHERE options & 512
10 - Property Members assess the reputation of
- Is growing operation
UPDATE user SET options = options + 1024 WHERE NOT (options & 1024)
- Ordered the suspension cultivation
UPDATE user SET options = options - 1024 WHERE options & 1024
11 - Download Membership of the members
- Is growing operation
UPDATE user SET options = options + 32 WHERE NOT (options & 32)
- ordered the suspension cultivation
UPDATE user SET options = options - 32 WHERE options & 32
12 - Receive new private messages
- Is growing operation
UPDATE user SET options = options + 2048 WHERE NOT (options & 2048)
- ordered the suspension cultivation
UPDATE user SET options = options - 2048 WHERE options & 2048
13 - receive an e-If you receive a private message
- Is growing operation
UPDATE user SET options = options + 4096 WHERE NOT (options & 4096)
- Ordered the suspension cultivation
UPDATE user SET options = options - 4096 WHERE options & 4096
14 - View Topic
- Oldest First
UPDATE user SET options = options - 32768 WHERE options & 32768
- Talk first
UPDATE user SET options = options + 32768 WHERE NOT (options & 32768)
15 - Show a window if you receive a new private message
- Is growing operation
UPDATE user SET pmpopup = 1
- Ordered the suspension cultivation
UPDATE user SET pmpopup = 0
16 - Selection of a specific language
- A change of language
UPDATE user SET languageid = X
Example language
I've got in my forum here
Forum Butcher 99 .. ALGZAR99.COM - Powered by vBulletin
The number two language first and second developer Arabization Arabization of immigrant guest
I would like to run
Tarrib Top Line
UPDATE user SET languageid = 1
If you want to run Powered immigrant guest
UPDATE user SET languageid = 2
17 - funds earmarked for writing topics
- Is a simple operation of the editor
UPDATE user SET showvbcode = 0
- Is standard operating panel
UPDATE user SET showvbcode = 1
- the operation of painting developed
UPDATE user SET showvbcode = 2
18 - Thread subscriptions
- Is not running Thread Subscription
UPDATE user SET autosubscribe =- 1;
- is silently my subscription
UPDATE user SET autosubscribe = 0;
- is an alert when my immediate reply to any topic
UPDATE user SET autosubscribe = 1;
- is an alert on my updates
UPDATE user SET autosubscribe = 2;
- Alert Weekly recently given my
UPDATE user SET autosubscribe = 3;
19 - allow the inclusion of codes bb
- Is growing operation
UPDATE forum SET options = options + 64 WHERE NOT (options & 64);
- Ordered the suspension cultivation
UPDATE forum SET options = options - 64 WHERE options & 64;
20 - allow the inclusion of the Kompass image img
- Is growing operation
UPDATE forum SET options = options + 128 WHERE NOT (options & 128);
- Ordered the suspension cultivation
UPDATE forum SET options = options - 128 WHERE options & 128;
21 - allow the inclusion of the Kompass ([html])
- Is growing operation
UPDATE forum SET options = options 256 WHERE NOT (options & 256);
- Is growing suspension
UPDATE forum SET options = options - 256 WHERE options & 256;
[quote]NotePlease do not activate this, to keep your board from the breachOh God, I have reached testified [/ quote]22 - allow the inclusion of Smiles
- Is growing operation
UPDATE forum SET options = options 512 WHERE NOT (options & 512);
- Is growing suspension
UPDATE forum SET options = options - 512 WHERE options & 512;
23 - the transfer of members of the group to another group
Agriculture is
update user set usergroupid = 'm' where usergroupid = 't'
, such as Ali Malk
M is the number to organic Elly Anholha have ended and the t Elly are then about ...
You you want a movement of members of the Group No. 7 to No. 2 Kit
Means the transfer of supervisors to total members
update user set usergroupid = '2 'where usergroupid = '7'
the thought of the letter m and the letter "L" t
Ermzo not a thing
And I compare the two mtwer
24 - Delete Visitor Messages
Plant each condition and
TRUNCATE `visitormessage`
and this
TRUNCATE `visitormessage_hash`
and this
UPDATE `user` SET `vmunreadcount` = 0;
and, God willing, we Bkda we have exhausted Visitor Messages
Been if the new orders, I will update the topic