PDA

View Full Version : Newreply.php help


RogueFrequency
11 Feb 2002, 18:17
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?

Chen
11 Feb 2002, 19:32
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
11 Feb 2002, 19:50
I'm not licensed, I HELP run the forum. Does this mean you can't help me?

FWC
11 Feb 2002, 20:06
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
11 Feb 2002, 20:36
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
11 Feb 2002, 20:55
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
11 Feb 2002, 21:12
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
12 Feb 2002, 03:46
INSERT will never overwrite. It will either insert a new record, or give an error.

RogueFrequency
12 Feb 2002, 03:56
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.

Chen
12 Feb 2002, 10:51
Then you could ask this in the appropriate forum. See ya there. :)