Printable View
Done. Be careful between "SET" and "GIVES". Gives will add to their current credit amount, SET will override their current amount (read the commented out part in green for details above each query).Quote:
Originally Posted by AnthonyColon
Mass credits Done. Badge - Doing. Rank - Done already.Quote:
Originally Posted by iJay
Nice queries, some of they're all useful, i probably wont need them though :').
Quote:
Originally Posted by TheJacob
Well done mate ;)
You're welcome and thanks.Quote:
Originally Posted by Sledmore
You're welcome.Quote:
Originally Posted by iJay
If anyone has any requests, post them here. Requests/Ideas are appreciated (I am trying to setup a big list of useful queries - personal reasons).
How about a pixels query?Quote:
Originally Posted by TheJacob
Or even queries to insert pets, bots etc.
Not sure.. Just ideas :?:
I've already setup a query to insert Pixels (activity points). Pets, hmm... like to just give a pet to someone? and what do you mean by bots?Quote:
Originally Posted by iJay
thanks Jacob
The first four are fucking useless, you could just post one and let the user edit the code, turn:
to:PHP Code://Update users email
UPDATE <user table> SET <email column> = '<email>' WHERE <username column> = '<username>'
//Update users rank
UPDATE <user table> SET <rank column> = '<rank>' WHERE <username column> = '<username>'
//Update users motto
UPDATE <user table> SET <motto column> = '<motto>' WHERE <username column> = '<username>'
//Sets a user a specific amount of activity points (pixels)
UPDATE <user table> SET <activity_points column> = '<pixel amount>' WHERE <username column> = '<username>'
Sorted?PHP Code://Update user row
UPDATE <user table> SET <user_row> = '<update_with>' WHERE <user_name> = '<user_name>'
Yo can you release the snippet of checking weather a user is online to display the online image or offline image.
This is for phpretro, if not don't warry.
Ontopic: This is great, but pretty simple haha.
Like how to tell if a user is online and/or offline? Sure I'll post a query above. Good suggestion.Quote:
Originally Posted by Hydros1
Does anyone else have any suggestions?
//Give credits to all users online.
UPDATE users SET credits + <amount> WHERE online=1
I don't know if the online column exists, but you guys know what I mean.
I see what you mean, I'll see what I can do. This would be pretty useful. I think a easier way of doing this would be to just make a php script (make it a lot simpler).Quote:
Originally Posted by Idiotic
Thanks bruh!!
Are there any more queries needed?
Sorry but these are as easy as shit to make.
PHP MySQL Insert Into