System of accounts

[Chelsea]

Hello, I'm just saying that my English is bad, then I'll explain in a few details not to confuse them.

I use an script who made the following change in the "login", as you can see below:

ALTER TABLE `login` ADD `diasvip` INT NOT NULL ;

What I'd like is a script (SQL), example:

I register on my server, and add 30 log table> `diasvip`.

My English is bad and the google translator did not help.

[en_dev]

can you explain further more, sorry that i'm kinda confused what you're trying to achieve.

[Arcenciel]

My English is bad and the google translator did not help.

There's a forum that might be able to help you more easily.

http://rathena.org/board/forum/74-portuguese-support/

[Chelsea]

can you explain further more, sorry that i'm kinda confused what you're trying to achieve.

Exemple: New account > Database: Ragnarok, Table> Login > `diasvip`.

Add 30 in `diasvip`.

My English is bad and the google translator did not help.

There's a forum that might be able to help you more easily.

http://rathena.org/b...uguese-support/

Ta bad support there.

[EvilPuncker]

post there and i'll help you

[Chelsea]

post there and i'll help you

http://rathena.org/board/topic/66323-sistema-de-registro/

[en_dev]

So its just adding value 30 in your diasvip table.

Mysql Script example below.

Insert into ragnarokTable (col1, col2, col3, diasvip) Values ('','','','30')

You can run that on mysql sql or any mysql program you got. Change ragnarokTable to your target table, change col1 col2 or col3 to your login table columns, you can add as long as it exist in your table.

if you can give me a screenshot of your login table, I could give you the whole code.

Edited June 26, 2012 by en_dev

[clydelion]

ALTER TABLE `login` ADD `diasvip` TINYINT(3) NOT NULL DEFAULT '30';

I think he wants this: Add a column in login table named 'diasvip' and set '30' as default value.

Edited June 26, 2012 by clydelion

[Chelsea]

So its just adding value 30 in your diasvip table.

Mysql Script example below.

Insert into ragnarokTable (col1, col2, col3, diasvip) Values ('','','','30')

You can run that on mysql sql or any mysql program you got. Change ragnarokTable to your target table, change col1 col2 or col3 to your login table columns, you can add as long as it exist in your table.

if you can give me a screenshot of your login table, I could give you the whole code.

That's right, I was just confused. Thank you for your attention.

ALTER TABLE `login` ADD `diasvip` TINYINT(3) NOT NULL DEFAULT '30';

I think he wants this: Add a column in login table named 'diasvip' and set '30' as default value.

Oh my god, this will help me alot. Thank you.

@topic

I hope to help the community when I go further in college programming. Thank you all.

.