New Row in VB3 DB

[Mike Cout]

Hello,
I am currently working on a hack in which the user has "points". I have written everything out involving the points on a seperate DB and have it working fine. Now I would like to insert a "point" row in for each of my current users and have it work for future users.

Could anyone help me with how I would do this?

-Mike

P.S. I do have phpmyadmin.

[Andreas]

[sql]
ALTER TABLE user ADD point INT NOT NULL
[/sql]

[Mike Cout]

Now I'm just having trouble selecting the points row.

PHP Code:

$query = 'SELECT * FROM `dev_user`';
$result = mysql_query($query);
echo mysql_result($result); 


What do I need to change to my query to read the value of points?

Thanks!
-Mike

[AN-net]

PHP Code:

mysql_select_db("vbulletin"); 


[Andreas]

Try

PHP Code:

$query = 'SELECT point FROM dev_user';
$result = mysql_query($query);
echo mysql_result($result); 


[Mike Cout]

Worked perfectly.

Best Regards,
-Mike

[Mike Cout]

Im having trouble writing to a specific user. Any idea on how I would write the points to the database by userid?

I've been trying to use LIMIT but have been unsuccessful.

Thanks,
-Mike

[Andreas]

[SQL]
UPDATE dev_user SET point=1234 WHERE userid=4321
[/SQL]

Of course the numbers must be replaced with the actual values
If you just want to increase/decrase the points use SET point=point+value.

[Mike Cout]

Thank you!

[Mike Cout]

I'm having trouble getting the users point total to display in the postbit. Could you help me with this?

I was thinking I would add into showthread a way to query the DB using each post's information.

$query = 'SELECT dev_user FROM points WHERE username=post[musername]';

Im not very familar with the way VB does queries and am having trouble understanding it.

-Mike