Newreply.php help

[RogueFrequency]

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?

[Admin]

RogueFrequency, please go to this (http://www.vbulletin.com/members/vbulletin.org.php) page and enter your username, to show you are licensed. (you will need to use your customer number and password to access that page)
Thank you.

[RogueFrequency]

I'm not licensed, I HELP run the forum. Does this mean you can't help me?

[FWC]

Originally posted by RogueFrequency
I'm not licensed, I HELP run the forum. Does this mean you can't help me? Have the owner of the license enter your name of the page FireFly gave you. You won't get any help until your name is there.

[RogueFrequency]

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... ?

[Mark Hensler]

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. :D

[RogueFrequency]

I knew that :rolleyes: 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.

[Mark Hensler]

INSERT will never overwrite. It will either insert a new record, or give an error.

[RogueFrequency]

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.

[Admin]

Then you could ask this in the appropriate forum. See ya there. :)