i need mccodes Posted October 28, 2007 Posted October 28, 2007 Re: [mccode] Mining mod wen i run this sql it says #1064 - 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 'update `users` set `max_power`=10 WHERE `max_power`=0' at line 2 anymore ideas ??? Quote
i need mccodes Posted October 28, 2007 Posted October 28, 2007 Re: [mccode] Mining mod thanx for all your help ppl i fixed this problem Quote
i need mccodes Posted October 28, 2007 Posted October 28, 2007 Re: [mccode] Mining mod Fatal error: Call to a member function on a non-object in /home/www/********************************/mine.php on line 51 Quote
Isomerizer Posted October 28, 2007 Posted October 28, 2007 Re: [mccode] Mining mod Fatal error: Call to a member function on a non-object in /home/www/********************************/mine.php on line 51 I see no function on line 51.. You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. Quote
i need mccodes Posted October 28, 2007 Posted October 28, 2007 Re: [mccode] Mining mod thanx alot mate :roll: Quote
i need mccodes Posted October 28, 2007 Posted October 28, 2007 Re: [mccode] Mining mod hold on mate this is line 51 $db->query("UPDATE users SET power=power-10 WHERE userid=$userid",$c); :S Quote
i need mccodes Posted October 29, 2007 Posted October 29, 2007 Re: [mccode] Mining mod hold on mate this is line 51 $db->query("UPDATE users SET power=power-10 WHERE userid=$userid",$c); :S can any 1 help with this error ??? ??? ??? ??? ??? ??? ??? ??? Quote
Klikoka Posted October 31, 2007 Posted October 31, 2007 Re: [mccode] Mining mod Change The "s With ' Quote
iseeyou94056 Posted November 5, 2007 Posted November 5, 2007 Re: [mccode] Mining mod that wont work Quote
tahmid Posted November 16, 2007 Posted November 16, 2007 Re: [mccode] Mining mod The whole thing in one please my eyes are going :roll: by looking at them split up. Quote
gurpreet Posted November 16, 2007 Posted November 16, 2007 Re: [mccode] Mining mod ffs dude thats how you do it. :roll: :roll: If you cant add that on 1st page then dont make a game... I didnt like this mod as users got too many crystals :evil: Quote
tahmid Posted November 16, 2007 Posted November 16, 2007 Re: [mccode] Mining mod doesn't it need no crons to update. Quote
Absolute Zero Posted November 16, 2007 Posted November 16, 2007 Re: [mccode] Mining mod ffs dude thats how you do it. :roll: :roll: If you cant add that on 1st page then dont make a game... I didnt like this mod as users got too many crystals :evil: Sorry but you must be pretty dull if you can't edit it yourself to not give so many crystals. Quote
tahmid Posted November 16, 2007 Posted November 16, 2007 Re: [mccode] Mining mod Warning: Unexpected character in input: '\' (ASCII=92) state=1 in /home/topu/public_html/mine.php on line 2 Parse error: syntax error, unexpected T_STRING in /home/topu/public_html/mine.php on line 2 Quote
tahmid Posted November 16, 2007 Posted November 16, 2007 Re: [mccode] Mining mod Warning: Unexpected character in input: '\' (ASCII=92) state=1 in /home/topu/public_html/mine.php on line 2 Parse error: syntax error, unexpected T_STRING in /home/topu/public_html/mine.php on line 2 :-( Quote
Guest Anonymous Posted November 16, 2007 Posted November 16, 2007 Re: [mccode] Mining mod why post it twice Quote
gurpreet Posted November 16, 2007 Posted November 16, 2007 Re: [mccode] Mining mod ffs dude thats how you do it. :roll: :roll: If you cant add that on 1st page then dont make a game... I didnt like this mod as users got too many crystals :evil: Sorry but you must be pretty dull if you can't edit it yourself to not give so many crystals. I could and i did, but even so some people found ways dont know how to keep doing it.. so they had like 400 crystals in a day which is kinda bad for everyone except them.. Quote
~Spooky~ Posted November 19, 2007 Posted November 19, 2007 Re: [mccode] Mining mod thats sad simple edit to lessen the CRYSTALS gained in mining. $db->query("UPDATE users SET power=power-10 WHERE userid=$userid",$c); Post error whoever has this one. And never knew they were taking POWER but have to add power, so to fix that put + instead of - and put 5 instead 10 and yes there is a CRON that runs the MINING. I have had no problems with this mod and crystal gains not that high and I added more levels and GEM levels also. Anyone needing help just ask. Been busy but kinda slacking off now. Quote
HITMAN 17 Posted February 9, 2008 Posted February 9, 2008 Re: [mccode] Mining mod anyone have the v2 one that they could post here please that works and that includes crons Quote
Ragnar Posted February 13, 2008 Posted February 13, 2008 Re: [mccode] Mining mod To get the experience and leveling up stuff working for version 2, in mine.php, replace if ($ir['jailtime'] > 0){ with if ($ir['jailtime'] > 0){ $db->query("UPDATE users SET max_power=mine_level*10 WHERE userid=$userid",$c); $db->query("UPDATE users SET mine_level=mine_level+1 WHERE mine_exp > mine_needed AND userid=$userid",$c); $db->query("UPDATE users SET mine_exp=0 WHERE mine_needed < mine_exp AND userid=$userid",$c); $db->query("UPDATE users SET mine_needed=mine_level*1000 WHERE userid=$userid",$c); Quote
HITMAN 17 Posted February 13, 2008 Posted February 13, 2008 Re: [mccode] Mining mod i really need the mine v2 badly has anyone get a working one that they will post for me plz Quote
Ragnar Posted February 14, 2008 Posted February 14, 2008 Re: [mccode] Mining mod Working version 2, with the screwed up issues fixed.... mine.php You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. In phpMyAdmin, if you already got the tables, first enter ALTER TABLE `users` DROP `mine_level` , DROP `mine_exp` , DROP `mine_needed` , DROP `power` , DROP `max_power` ; to delete them, and then re-add them using... 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; In cron_fivemins.php add $db->query("UPDATE users SET power=power+5 WHERE power<max_power"); In global_func.php replace function get_rank($stat, $mykey) with You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. Quote
HITMAN 17 Posted February 14, 2008 Posted February 14, 2008 Re: [mccode] Mining mod works perfect except wrong cron $query7="UPDATE users SET power=power+5 WHERE power<max_power"; $db->query($query7); Quote
zbirc3 Posted February 15, 2008 Posted February 15, 2008 Re: [mccode] Mining mod Been waiting for this for ages. THX! :D Quote
HITMAN 17 Posted February 15, 2008 Posted February 15, 2008 Re: [mccode] Mining mod Been waiting for this for ages. THX! :D we all have now u can see it working at www.tbrpg.890m.com Quote
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.