Sql query guild points

[The extros]

Hi everyone, I am having some problems, I want to give 500 points to all the players from X guild, but it has like 60 players, does anyone knows any sql query that gives 500 points to everyone in guild id X ?

Thanks!

 

[Xibecaman]

Hello!!

First search the table of contains Points, i look this and I have not found.

please respond and tell me what this table, and try to create the sql query

 

[Cronox]

why don't use this is good script
http://otland.net/f81/premium-points-big-guilds-automatic-137190/

 

[averatec]

UPDATE accounts SET premium_points = premium_points+500 WHERE id IN 
(SELECT DISTINCT account_id FROM players WHERE rank_id in 
	(SELECT id FROM guild_ranks WHERE guild_id = 
		(SELECT id FROM guilds WHERE name = 'name')))

 

[Xibecaman]

I don't have a 'premium_point' attribute on account table.. :S

 

[The extros]

reeplace it for ur table of premium points -.-

 

[Loney]

Try this:

DROP TABLE IF EXISTS `accounts`
(
	`premium_points` INT NOT NULL DEFAULT 0,
	PRIMARY KEY (`id`), UNIQUE (`name`)
) ENGINE = InnoDB;