The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
On the forum I help run, I would like to have user groups AND user status based on post counts. So a person might be a member of a group called "Abc Def" and might have 304 posts making them a "Xyz".
------------------------ Username Member of Abc Def Xyz Avatar stuff 304 ------------------------ There is only 1 $usertitle that is shared by groups and post count user status. I tried to add a new value into: $DB_site->query("INSERT INTO post (postid... But I got the error of unknown colume and stuff. Where are they defined? |
#3
|
|||
|
|||
I'm not licensed, I HELP run the forum. Does this mean you can't help me?
|
#4
|
||||
|
||||
Quote:
|
#5
|
|||
|
|||
Alright can you just answer one question until I can get a hold of him and get the license info?
What is the difference in $DB_site->query("INSERT INTO user... and $DB_site->query("UPDATE user... ? |
#6
|
||||
|
||||
Just like it sounds....
an UPDATE query updates an existing record an INSERT query puts a new record into the DB But then... you get stuff like UPDATE INTO. |
#7
|
|||
|
|||
I knew that What I meant was if I use INSERT on xyz when xyz is already there, then it overrights it or replaces it?
BTW, I got in contact with my friend (the license owner) and he said he would put it on the site under my name tonight. |
#8
|
||||
|
||||
INSERT will never overwrite. It will either insert a new record, or give an error.
|
#9
|
|||
|
|||
I'm crossing my fingers that the way to get around that isn't extremely complicated, but I won't ask any more questions until I get the licence.
|
#10
|
||||
|
||||
Then you could ask this in the appropriate forum. See ya there.
|
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|