Register for your free account! | Forgot your password?

You last visited: Today at 12:33

  • Please register to post and access all features, it's quick, easy and FREE!

 

Delete Gold

Closed Thread
 
Old   #1
 
elite*gold: 0
Join Date: Apr 2013
Posts: 136
Received Thanks: 16
Delete Gold

I know I'm asking a lot of questions. How can i delete character gold from character table ?

I'm trying to like this :
Quote:
USE [telecaster]
GO

UPDATE [dbo].[Character]
SET [gold] = '0'
WHERE gold< 0
GO
But says 0 rows affected. How should I write code ?



TRTeta is offline  
Thanks
1 User
Old   #2
 
elite*gold: 0
Join Date: Jul 2011
Posts: 111
Received Thanks: 85
set gold=0 where gold<0 lolll maybe where gold>0 don't you think ?
take care, this will set gold=0 to all character in dbo.character


Ne0@NCarbon is offline  
Old   #3
 
elite*gold: 0
Join Date: Apr 2013
Posts: 136
Received Thanks: 16
I've tried it. It did not.
TRTeta is offline  
Old   #4
 
elite*gold: 0
Join Date: Jul 2011
Posts: 111
Received Thanks: 85
Code:
USE [telecaster]
GO

UPDATE [dbo].[Character]
SET [gold] = '0'
WHERE [gold] > 0
GO


Ne0@NCarbon is offline  
Old   #5
 
elite*gold: 0
Join Date: Apr 2013
Posts: 136
Received Thanks: 16
work, thx bro

can you add me on facebook , and how can i fix guild icon , you tell me
TRTeta is offline  
Old   #6
 
elite*gold: 0
Join Date: Sep 2008
Posts: 1,570
Received Thanks: 1,154
Could you please start to use the helpthread for questions like that. Creating a new thread for every of your question will mess up the forum.

The helpthread was created for people like you...
c1ph3r is offline  
Thanks
3 Users
Old   #7
 
elite*gold: 0
Join Date: Jul 2011
Posts: 5
Received Thanks: 2


al oç al
Trustly is offline  
Old   #8


 
elite*gold: 30
Join Date: May 2011
Posts: 4,795
Received Thanks: 3,179
Quote:
Originally Posted by c1ph3r View Post
Could you please start to use the helpthread for questions like that. Creating a new thread for every of your question will mess up the forum.

The helpthread was created for people like you...
^this

#closed


Xijezu is offline  
Closed Thread



« Previous Thread | Next Thread »

Similar Threads
Is possible GM delete your cha?
well 2 day's ago my warrior got PS5, today i logged to try get 2nd role, but at my suprise when i logged to my account is just show my BoT LM5 and my...
2 Replies - 9Dragons



All times are GMT +2. The time now is 12:33.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

Support | Contact Us | FAQ | Advertising | Privacy Policy
Copyright ©2017 elitepvpers All Rights Reserved.