[mccode v2] Mining V2 Converted

[danger boy]

Re: Mining V2 Converted

i addedd it but when u clik on something it dont owrk and it says go mining u have 0/0

[John1]

Re: Mining V2 Converted

you need to go into your sql database and change the following values

mine_level = 1 mine_exp = 0 mine_needed = 1000 power = 10 max_power = 10

[danger boy]

Re: Mining V2 Converted

 

you need to go into your sql database and change the following values

mine_level = 1 mine_exp = 0 mine_needed = 1000 power = 10 max_power = 10

i dnoe that6 i put this in the sql query

ALTER TABLE `users` ADD `mine_level = 1` int(11) NOT NULL ;

ALTER TABLE `users` ADD `mine_exp = 0` int(11) NOT NULL ;

ALTER TABLE `users` ADD `mine_needed = 1000` int(11) NOT NULL ;

ALTER TABLE `users` ADD `power = 10` int(11) NOT NULL ;

ALTER TABLE `users` ADD `max_power = 10` int(11) NOT NULL ;

but still dont work any help please?

[endo]

Re: Mining V2 Converted

im getting this from that code

Fatal error: Call to undefined function get_mine() in /home/endo/public_html/mine.php on line 6

this is the code

You're unable to view this code.

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

[jds137]

Re: Mining V2 Converted

I added it as well, using all the info given but when u click on something it don't work and it says go mining you have 0/0

 

Welcome to the mine shaft.

There are 3 spots to go mining but thay are restricted depending on your mine level.

Your mining level is 0 and you have 0/0 mining experience

Crystal Mines

[Level 1 mine]

[Level 20 mine]

[Level 40 mine]

Money Mines

[Level 10 mine]

[Level 30 mine]

[Level 40 mine]

[SpEcKs]

Re: Mining V2 Converted

But no one has included the bar greens or anything like that so this dont actually work good

[jds137]

Re: Mining V2 Converted

Go to header.php and you can add this, just look for: $hpperc=(int) ($ir['hp']/$ir['maxhp']*100); add after each one, pretty easy...

 

$power=(int) ($ir['power']/$ir['max_power']*100);

$minexp=(int) ($ir['mine_exp']/$ir['mine_needed']*100);

 

}

if($power > 100)

{

$power = ceil(100);

}

if($minexp > 100)

{

$minexp = ceil(100);

}

 

$pow=100-$power;

$minex=100-$minexp;

 

Power: {$ir['power']}/{$ir['max_power']}

Mine Exp: {$minexp}%

[avguste]

Re: Mining V2 Converted

Do we need to run SQL for the code below? if yes,what is the SQL code

 

You're unable to view this code.

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

Not Tested But Should Work...

[BluntMan]

Re: [mccode v2] Mining V2 Converted

ok ive added it but i have the problem everyone scemes to have

 

ALTER TABLE `users` ADD `mine_level` int(11) NOT NULL ;

ALTER TABLE `users` ADD `mine_exp` int(11) NOT NULL ;

ALTER TABLE `users` ADD `mine_needed` int(11) NOT NULL ;

ALTER TABLE `users` ADD `power` int(11) NOT NULL ;

ALTER TABLE `users` ADD `max_power` int(11) NOT NULL ;

this is the sql but it doesnt work people complained but there was not a fix does anybody know what i need to add to make it work

[BluntMan]

Re: [mccode v2] Mining V2 Converted

:mrgreen:BUMP

[AlabamaHit]

Re: [mccode v2] Mining V2 Converted

bluntman

Set some defualts.. I would imagine that would fix it.

[Zero-Affect]

Re: [mccode v2] Mining V2 Converted

won't be that difficult if you read a quick sql manual first mate

[Wprincess]

with the code in and sql in i am still getting errors

You begin mining in the level 20 mine and found 9 crystal(s).

QUERY ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '+'228' WHERE userid=1' at line 1

Query was UPDATE users SET crystals=crystals+'9',mine_exp+'228' WHERE userid=1

wats all that mean please help :love:

[p_T_s]

Use these sql's

[mysql]ALTER TABLE `users` ADD`mine_level` INT(11) NOT NULL DEFAULT '1';

ALTER TABLE `users` ADD`mine_exp` INT(11) NOT NULL DEFAULT '1';

ALTER TABLE `users` ADD`mine_needed` INT(11) NOT NULL DEFAULT '1000';

ALTER TABLE `users` ADD`power` INT(11) NOT NULL DEFAULT '10';

ALTER TABLE `users` ADD`max_power` INT(11) NOT NULL DEFAULT '10';

[/mysql]

[DELETE-ME-NOW-]

is there crons for this? As power doesnt seem to be refilling :(

[Dominion]

there is an update of this mod posted here -[mccode v2.x] Mines--Fixed

cron is in the 1st post