V2 Mining mod

[Dustin Rohel]

Hey, I've been looking for a decent mining mod, can't find a working one here. If you have something please let me know.

[Canjucks]

You're unable to view this code.

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

Try that out ... create a page called mine.php

[peterisgb]

Don't forget to post the SQL 😄

[Dustin Rohel]

Need SQL like Peterisgb said 

[Canjucks]

add the below to your users table:

 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',

[Dustin Rohel]

Thanks will try this

Didn't work, got a critical error

[Canjucks]

which part?

[Dustin Rohel]

??? Is it more than 1 sql? Or is that all 1?

A critical error has occurred, and this page cannot be displayed. Please try again later.
Query failed

[Canjucks]

Did you add them to the database? Each row must go in your users table. Do one at a time and see if it adds, but only try the game once they're in the users table.

[Dustin Rohel]

Yeah I added to data base, ill try 1 at a time

Still not working for me...

[Canjucks]

do you have an error log for the game page? need a few more clues to how i can help you fix it....

[Dustin Rohel]

Not sure, I'm new at this

[Oracle]

NEED correct  SQL please 😃

[Veramys]

Power isn't a native part of V2 users table, so of course that's not gonna work with the sqls given.

 

Edit to add: Also neither is Safehouse for that matter.

Edited October 2, 2022 by Veramys

[Oracle]

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. 

[Inveteratus]

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.

[Canjucks]

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 😂