The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
how do you set negative integers?
I heard you have to make the integers signed, but I don't know how, in specific I'm trying to make the post count negative. Anyone know how?
|
#2
|
|||
|
|||
You could try (untested, backup your database first!!!):
[sql]ALTER TABLE user CHANGE COLUMN post posts int(10) NOT NULL default 0;[/sql] |
#3
|
|||
|
|||
Alright, trying
EDIT: I got this Quote:
|
#4
|
|||
|
|||
Oops the first one should have been posts also:
[sql]ALTER TABLE user CHANGE COLUMN posts posts int(10) NOT NULL default 0;[/sql] |
#5
|
|||
|
|||
trying
EDIT: okay, the query worked but when I set my post count to -1 it said post count 0 instead. |
#6
|
||||
|
||||
I've got to ask - why do you want negative post counts ?
|
#7
|
|||
|
|||
Quote:
Spammers, they don't deserve to be banned, but I don't think 0 is enough of a set back. |
#8
|
|||
|
|||
bump
|
#9
|
|||
|
|||
Quote:
Do you still get "0"? Can you determine of what kind your posts column in the DB is? I tried this myself a week ago and worked perfectely.... Man, without your bump I would have totally missed this |
#10
|
|||
|
|||
Quote:
I can't find the posts column, what's it under? |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|