SQLite + queries

[zniC]

CLICKK ->> http://otland.net/f16/sqlite-queries-40110/index2.html#post406354

 

[zniC]

up.

 

[Wiw3K]

PhpMyAdmin -> YourDB -> Accounts -> Structure -> Add on the bottom.

 

[zniC]

I am on SQLite, not mySQL. Thanks tho...

 

[Paxton]

Query.

ALTER TABLE `accounts` ADD COLUMN `group_id` int(10)

Look in google for statements 'ALTER'

 

[zniC]

I love you ;DD
edit: Seems I need some further guidance...

I tried this query, what I want to do is change all characters with account_id 2 outfit to color X;
UPDATE players WHERE account_id = 2 SET lookfeet = 200, lookbody = 200, looklegs = 200, lookhead = 200;

But, SQL Error: near "WHERE": syntax error

 

[Paxton]

I love you ;DD
edit: Seems I need some further guidance...

I tried this query, what I want to do is change all characters with account_id 2 outfit to color X;
UPDATE players WHERE account_id = 2 SET lookfeet = 200, lookbody = 200, looklegs = 200, lookhead = 200;

But, SQL Error: near "WHERE": syntax error

UPDATE `players` SET `lookfeet` = 'X' AND `lookbody` = 'X' AND `looklegs` = 'X' AND `lookhead` = 'X' WHERE `account_id` = '2'

Here u go.

 

[zniC]

Thanks lots. Seems like it's working ;D Although, I get that "choose outfit window" and I really don't like it to show, because I think it makes all my characters light blue again...

Is it because of something like lastlogin is 0 or a storagevalue missing?

Seems I can't rep twice

 

[Paxton]

Thanks lots. Seems like it's working ;D Although, I get that "choose outfit window" and I really don't like it to show, because I think it makes all my characters light blue again...

Is it because of something like lastlogin is 0 or a storagevalue missing?

Seems I can't rep twice

I think it's declared somewhere in source code.

 

[zniC]

edit:
Actually, the last query won't work. :s
The fields remain the same (the colours doesn't change)

Any clues?

- remember I'm on SQLite

 

[zniC]

edit:
Actually, the last query won't work. :s
The fields remain the same (the colours doesn't change)

Any clues?

- remember I'm on SQLite

ahh, I need help

 

[zniC]

up.

 

[Jag]

' robin säger (17:00):
skriv up
;D

 

[zniC]

up;o

 

[zniC]

solved