help with commands

04/27/2013 09:11 delux153#1
people tell command to add AP????
04/28/2013 03:05 JohnHeatz#2
I'm sorry but this is such a basic question that it simply shows how people laziness has gone to unimaginable lines and therefore it is required for me to tell you that you must use the search before asking questions, this is showing how you won't even search for something so basic.
04/28/2013 13:21 Philipp_#3
Quote:
Originally Posted by delux153 View Post
people tell command to add AP????
There is no command to add (aeria) points to an account. You will have to run a query in your database:
Open SQL Server Management Studio, login and click on the button whose caption is something like "New Query". Afterwards you copy & paste the following lines and click on the execute button at the top
Code:
UPDATE PS_UserData.dbo.Users_Master
SET Points = (Points + x) -- Replace the 'x' with the amount of points
WHERE UserID = 'username' -- Enter the username here
As John already said, you should better use the search engine next time.

Cheers
04/28/2013 15:25 infinite59#4
This question got answered on
[Only registered and activated users can see links. Click Here To Register...]
[Only registered and activated users can see links. Click Here To Register...]
then
[Only registered and activated users can see links. Click Here To Register...]
04/28/2013 18:16 delux153#5
Philipp_ please make a screenshot I'm doing this 1 time
how does it look in the SQL
04/28/2013 18:23 Frostix™#6
Quote:
Originally Posted by delux153 View Post
Philipp_ please make a screenshot I'm doing this 1 time
how does it look in the SQL
Quote:
Originally Posted by Philipp_ View Post
T
Code:
UPDATE PS_UserData.dbo.Users_Master
SET Points = (Points + x) -- Replace the 'x' with the amount of points
WHERE UserID = 'username' -- Enter the username here
Cheers
Philipp already sent the SQl , you need to edit the userid ( 3rd row " UserID = ' UserID here ' )
and the Points you wish to add ( 2nd row " Points = (Points + 'Points you wish to add')
04/28/2013 18:54 delux153#7
you did not understand I do not know how to find these strings!
04/28/2013 19:29 JohnHeatz#8
We can't teach you how to use SQL, everything you need is here. I'm not trying to be rude, yet, if you can't search something as basic as this, and you don't know how to run a simply query in SQL, I can't see any near future with a server of yours, and if that happens, believe me, it won't really last as you won't be able to maintain it.

Please, go learn how to use SQL, these basic questions are just showing laziness on your part.