SA-MP Forums

Go Back   SA-MP Forums > SA-MP Scripting and Plugins > Scripting Help

Reply
 
Thread Tools Display Modes
Old 10/02/2013, 11:37 AM   #1
-=Dar[K]Lord=-
Huge Clucker
 
-=Dar[K]Lord=-'s Avatar
 
Join Date: Oct 2012
Posts: 351
Reputation: 48
Default Database help

Hey guys i have come up with another problem . Its of Database that i want to reset each and every players Score even if hes not connected to the server.

UsersThis Whole coloums/row's data to be set to 0
DarklordScore
__________________
Discussion is an exchange of knowledge; argument is an exchange of ignorance...- Robert Quillen

At times, it is better to keep your mouth shut and let people wonder if you are a fool than to open it and remove all their doubts - James Sinelair
-=Dar[K]Lord=- is offline   Reply With Quote
Old 10/02/2013, 12:02 PM   #2
Mean
High-roller
 
Join Date: Jul 2010
Location: 14th annual lemon party
Posts: 2,726
Reputation: 229
Default Re: Database help

uh

pawn Code:
mysql_query("UPDATE `users` SET `score` = '0' WHERE `score` > 0");

is that what you want?
Mean is offline   Reply With Quote
Old 10/02/2013, 12:05 PM   #3
Jeffry
High-roller
 
Jeffry's Avatar
 
Join Date: Oct 2009
Location: Germany
Posts: 1,594
Reputation: 69
Default Re: Database help

Do you already have a code? If yes, post it.

EDIT: What Mean just posted will do it. If you know how to use it, it's good. Else, do above thing. ^
__________________
Jeffry is offline   Reply With Quote
Old 10/02/2013, 04:08 PM   #4
-=Dar[K]Lord=-
Huge Clucker
 
-=Dar[K]Lord=-'s Avatar
 
Join Date: Oct 2012
Posts: 351
Reputation: 48
Default Re: Database help

Quote:
Originally Posted by Mean View Post
uh

pawn Code:
mysql_query("UPDATE `users` SET `score` = '0' WHERE `score` > 0");

is that what you want?
i am new to database [its db_query] and as far as i studied db it must be same will try
__________________
Discussion is an exchange of knowledge; argument is an exchange of ignorance...- Robert Quillen

At times, it is better to keep your mouth shut and let people wonder if you are a fool than to open it and remove all their doubts - James Sinelair
-=Dar[K]Lord=- is offline   Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Database Height Server Support 4 13/11/2012 02:09 PM
Database Sanady Everything and Nothing 15 01/09/2012 12:03 AM
Database help. Cyniic Scripting Help 3 10/05/2012 05:01 PM
help database/php iJumbo Help Archive 3 06/09/2010 01:36 PM
DataBase Sascha Help Archive 0 29/04/2010 05:02 PM


All times are GMT. The time now is 11:41 PM.


Powered by vBulletin® Version 3.8.6
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.