Chelsea Posted June 25, 2012 Group: Members Topic Count: 2 Topics Per Day: 0.00 Content Count: 7 Reputation: 0 Joined: 06/03/12 Last Seen: June 11, 2013 Share Posted June 25, 2012 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. Quote Link to comment Share on other sites More sharing options...
en_dev Posted June 25, 2012 Group: Members Topic Count: 7 Topics Per Day: 0.00 Content Count: 113 Reputation: 5 Joined: 06/06/12 Last Seen: December 25, 2013 Share Posted June 25, 2012 can you explain further more, sorry that i'm kinda confused what you're trying to achieve. Quote Link to comment Share on other sites More sharing options...
Arcenciel Posted June 25, 2012 Group: Members Topic Count: 69 Topics Per Day: 0.02 Content Count: 1315 Reputation: 372 Joined: 12/10/11 Last Seen: August 31, 2013 Share Posted June 25, 2012 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/ Quote Link to comment Share on other sites More sharing options...
Chelsea Posted June 25, 2012 Group: Members Topic Count: 2 Topics Per Day: 0.00 Content Count: 7 Reputation: 0 Joined: 06/03/12 Last Seen: June 11, 2013 Author Share Posted June 25, 2012 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. Quote Link to comment Share on other sites More sharing options...
EvilPuncker Posted June 25, 2012 Group: Members Topic Count: 19 Topics Per Day: 0.00 Content Count: 713 Reputation: 70 Joined: 11/08/11 Last Seen: April 9, 2023 Share Posted June 25, 2012 post there and i'll help you Quote Link to comment Share on other sites More sharing options...
Chelsea Posted June 25, 2012 Group: Members Topic Count: 2 Topics Per Day: 0.00 Content Count: 7 Reputation: 0 Joined: 06/03/12 Last Seen: June 11, 2013 Author Share Posted June 25, 2012 post there and i'll help you http://rathena.org/board/topic/66323-sistema-de-registro/ Quote Link to comment Share on other sites More sharing options...
en_dev Posted June 26, 2012 Group: Members Topic Count: 7 Topics Per Day: 0.00 Content Count: 113 Reputation: 5 Joined: 06/06/12 Last Seen: December 25, 2013 Share Posted June 26, 2012 (edited) 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 1 Quote Link to comment Share on other sites More sharing options...
clydelion Posted June 26, 2012 Group: Members Topic Count: 17 Topics Per Day: 0.00 Content Count: 754 Reputation: 186 Joined: 05/22/12 Last Seen: October 15, 2022 Share Posted June 26, 2012 (edited) 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 1 Quote Link to comment Share on other sites More sharing options...
Chelsea Posted June 26, 2012 Group: Members Topic Count: 2 Topics Per Day: 0.00 Content Count: 7 Reputation: 0 Joined: 06/03/12 Last Seen: June 11, 2013 Author Share Posted June 26, 2012 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. . Quote Link to comment Share on other sites More sharing options...
Question
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:
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.
Link to comment
Share on other sites
8 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.