Jump to content
MakeWebGames

V2 Mining mod


Dustin Rohel

Recommended Posts

  • 5 months later...
  • 3 months later...
On 10/1/2022 at 6:11 PM, Oracle said:

NEED correct  SQL please 😃

alter table 'users'`mine_level` int(11) NOT NULL DEFAULT '1';
 alter table 'users' `mine_exp` int(11) NOT NULL DEFAULT '1';
 alter table 'users' `mine_needed` int(11) NOT NULL DEFAULT '1000',

 

is not working even if adding one at a time. 

Link to comment
Share on other sites

Try

You're unable to view this code.

Viewing code within this forum requires registration, you can register here for free.

Notice:

  • The ADD keyword is needed.
  • INT(11) -- The (11) is useless, it has no bearing on the size of the value that can be stored.
  • I've used UNSIGNED as it's unlikely your mine level and/or experience will go below zero.
  • I've change the default mine_exp to 0 -- feel free to adjust to suit.
Link to comment
Share on other sites

15 hours ago, Inveteratus said:

Try

ALTER TABLE `users` ADD `mine_level` INT UNSIGNED NOT NULL DEFAULT 1; ALTER TABLE `users` ADD `mine_exp` INT UNSIGNED NOT NULL DEFAULT 0; ALTER TABLE `users` ADD `mine_needed` INT UNSIGNED NOT NULL DEFAULT 1000;

You're unable to view this code.

Viewing code within this forum requires registration, you can register here for free.

Notice:

  • The ADD keyword is needed.
  • INT(11) -- The (11) is useless, it has no bearing on the size of the value that can be stored.
  • I've used UNSIGNED as it's unlikely your mine level and/or experience will go below zero.
  • I've change the default mine_exp to 0 -- feel free to adjust to suit.

oh boy add might have helped make me look good at helping 😂

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...