Joshua

To prevent LFI/RFI that's used. May be a bit overkill, but not all hacks are lame sql hacks. rtfm.

Yep, Danke ^_- Stupid Fetch_arrays were bugging so I did away with them. ***NOTE TO ALL USERS**** If you are Reading this the Original Post has been updated. I will try to continue to do this for easy install. Saves reading through all the garble :P So far as I "know" There are no more bugs. Working on additions to this mod now, FINALLY ><

Ok, It only took me half the day >,< But I managed to fix the Crons. Now everything is updating as it should You will need to do the following Open up PHPMYADMIN and Drop the table Businessess_ranks ( unless you want to manually go through and change everything ) Then install This Businessess_ranks table   CREATE TABLE IF NOT EXISTS `businesses_ranks` ( `rankId` int(11) NOT NULL auto_increment, `rankName` varchar(255) NOT NULL, `rankClass` int(11) NOT NULL, `rankCash` int(11) NOT NULL, `rankPrim` enum('labour','IQ','strength') NOT NULL, `rankSec` enum('labour','IQ','strength') NOT NULL, `rankPGain` decimal(11,2) NOT NULL, `rankSGain` decimal(11,2) NOT NULL, PRIMARY KEY (`rankId`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=18 ; -- -- Dumping data for table `businesses_ranks` -- INSERT INTO `businesses_ranks` (`rankId`, `rankName`, `rankClass`, `rankCash`, `rankPrim`, `rankSec`, `rankPGain`, `rankSGain`) VALUES (1, 'Sales person', 1, 1000, 'IQ', 'labour', '30.50', '15.25'), (2, 'Product manager', 1, 2500, 'labour', 'strength', '20.00', '10.00'), (3, 'Cashier', 1, 5000, 'IQ', 'strength', '25.00', '12.00'), (4, 'Stylist', 2, 800, 'IQ', 'labour', '25.00', '12.50'), (5, 'Cleaner', 2, 1400, 'labour', 'strength', '20.00', '10.00'), (6, 'Shampooist', 2, 2100, 'strength', 'labour', '25.00', '12.50'), (7, 'Lawyer', 3, 1200, 'IQ', 'labour', '40.00', '20.00'), (8, 'Cleaner', 3, 800, 'labour', 'strength', '20.00', '10.00'), (9, 'Receptionist', 3, 600, 'IQ', 'labour', '30.00', '15.00'), (10, 'Florist', 4, 500, 'labour', 'strength', '25.00', '12.50'), (11, 'Cleaner', 4, 750, 'labour', 'IQ', '20.00', '10.00'), (12, 'Salesman', 5, 3400, 'labour', 'strength', '30.00', '15.00'), (13, 'Cleaner', 5, 1400, 'labour', 'strength', '20.00', '10.00'), (14, 'Receptionist', 5, 900, 'IQ', 'labour', '34.00', '17.00'), (15, 'Referee', 6, 3150, 'labour', 'strength', '15.00', '10.00'), (16, 'Player', 6, 3500, 'labour', 'IQ', '28.00', '7.00'), (17, 'Goal Keeper', 6, 3100, 'labour', 'strength', '25.00', '7.00');   After that, Overwrite your Old business_cron with this one   <?php include "config.php"; include "global_func.php"; global $_CONFIG; if($_GET['code'] != $_CONFIG['code']) { die(""); } define("MONO_ON", 1); require "class/class_db_{$_CONFIG['driver']}.php"; $db=new database; $db->configure($_CONFIG['hostname'], $_CONFIG['username'], $_CONFIG['password'], $_CONFIG['database'], $_CONFIG['persistent']); $db->connect(); $c=$db->connection_id; $set=array(); $settq=$db->query("SELECT * FROM settings"); while($r=$db->fetch_row($settq)) { $set[$r['conf_name']]=$r['conf_value']; } $db->query("UPDATE `businesses` SET `brank` = '100000' WHERE `brank` > '100000'"); $select_businesses = $db->query("SELECT * FROM `businesses` LEFT JOIN `businesses_classes` ON (`classId` = `busClass`) ORDER BY `busId` ASC"); while($bs=$db->fetch_row($select_businesses)) { $amount = $db->num_rows($db->query(sprintf("SELECT * FROM `businesses_members` WHERE `bmembBusiness` = '%u'", $bs['busId']))); $active = $db->num_rows($db->query(sprintf("SELECT * FROM `users` WHERE `business` = '%u' AND active='%d'", $bs['busId'], 1))); $new_customers = ($bs['brank']*($active)+ rand(10, 20)*$bs['classCost'] / 200); $new_profit = (($new_customers)+ rand(110, 990)); $new_rank = ($bs['classId']*($active)/2); $db->query(sprintf("UPDATE `businesses` SET `busYCust` = `busCust`, `busYProfit` = `busProfit`, `busCust` = '%d', `busProfit` = '%d', `busCash` = '%d' WHERE `busId` = '%u'", $new_customers, $new_profit, ($new_profit + $bs['busCash']), $bs['busId'])); $db->query(sprintf("UPDATE `businesses` SET `busDays` = `busDays` + '1'")); $db->query(sprintf("UPDATE `users` SET `activedays` = `activedays` + '1' WHERE `active` = '1'")); $db->query(sprintf("UPDATE `users` SET `active` = '0' WHERE `active` = '1'")); $db->query(sprintf("UPDATE `businesses` SET `brank` = `brank` + '%d' WHERE `busId` = '%u'", $new_rank, $bs['busId'])); $fetch_members = $db->query(sprintf("SELECT * FROM `businesses_members` LEFT JOIN `users` ON (`userid` = `bmembMember`) LEFT JOIN `businesses_ranks` ON (`rankId` = `bmembRank`) WHERE `bmembBusiness` = '%u'", $bs['busId'])) OR die('Cron not run'); $db->query("UPDATE userstats SET labour = labour + 50, IQ = IQ + 50, strength = strength + 50 WHERE userid = {$bs['busDirector']}"); $db->query("UPDATE users SET comppoints = comppoints + 1 WHERE userid = {$bs['busDirector']}"); while($fm=$db->fetch_row($fetch_members)) { $db->query(sprintf("UPDATE `userstats` SET `{$fm['rankPrim']}` = `{$fm['rankPrim']}` + '%.6f', `{$fm['rankSec']}` = `{$fm['rankSec']}` + '%.6f' WHERE (`userid` = '%u')", $fm['rankPGain'], $fm['rankSGain'], $fm['userid'])) OR die('Cron not run'); $db->query(sprintf("UPDATE `users` SET `money` = `money` + '%d' WHERE `userid` = '%u'", $fm['bmembCash'], $fm['userid'])) OR die('Cron not run'); $db->query(sprintf("UPDATE `users` SET `comppoints` = `comppoints` + '1' WHERE `userid` = '%u'", $fm['userid'])) OR die('Cron not run'); if($bs['busCash'] < $fm['bmembCash']) { $text = "Member ID {$fm['bmembMember']} was not paid their \$".number_format($fm['bmembCash'])." due to lack of funds." OR die('Cron not run'); $db->query(sprintf("INSERT INTO `businesses_alerts` (`alertId`, `alertBusiness`, `alertText`, `alertTime`) VALUES ('NULL', '%u', '%s', '%d')", $bs['busId'], $text, time())) OR die('Cron not run'); $db->query(sprintf("UPDATE `businesses` SET `busDebt` = `busDebt` + '%d' WHERE `busId` = '%u'", $fm['bmembCash'], $bs['busId'])) OR die('Cron not run'); } else { $db->query(sprintf("UPDATE `businesses` SET `busCash` = `busCash` - '%d' WHERE `busId` = '%u'", $fm['bmembCash'], $bs['busId'])) OR die('Cron not run'); } } if($bs['busDebt'] > $bs['classCost']) { $send_event = $db->query(sprintf("SELECT `bmembMember` FROM WHERE `bmembBusiness` = '%u' ORDER BY `bmembId` DESC", $bs['busId'])) OR die('Cron not run') ; while($se=$db->fetch_row($send_event)) { $text = "The {$bs['busName']} business went bankrupt\, all members have been made redundent." OR die('Cron not run'); insert_event($se['bmembMember'], $text); } $db->query(sprintf("DELETE FROM `businesses_members` WHERE (`bmembBusiness` = '%u')", $bs['busId'])) OR die('Cron not run'); $db->query(sprintf("DELETE FROM `businesses` WHERE (`busId` = '%u')", $bs['busId'])) OR die('Cron not run'); } } ?>

Thanks Shad, and you're welcome. When I get this cron bit fixed "if and when" I'll go ahead and add the events :P   Oh and DjKanna there better :O

Hm... Is there a space above <?php sometimes it does that to some people   make sure the VERY first space on the script is < not a blank space so it should look like ___ <?php also make sure it <?php and not <<?php That might be the prob.

I dno, the only problem anyone is having with the mod so far is the cron isnt updating properly and i cant for the life of me figure out why >,< gonna hit it in the A.M But the session failed to connect is a new error to me.....that's the strangest thing.

Ok, If any of the pro's could take a look at this I beleive the problem is in here somewhere >,<   mysql_query(sprintf("UPDATE `userstats` SET `{$fetch_stat[$fm['rankPrim']]}` = `{$fetch_stat[$fm['rankPrim']]}` + '%.6f', `{$fetch_stat[$fm['rankSec']]}` = `{$fetch_stat[$fm['rankSec']]}` + '%.6f' WHERE (`userid` = '%u')", $fm['rankPGain'], $fm['rankSGain'], $fm['userid'])); mysql_query(sprintf("UPDATE `userstats` SET `labour` = `labour` + '25', `IQ` = `IQ` + '25', `strength` = `strength` + '25' WHERE (`userid` = '%u')", $bs['busDirector']));   But I for the life of me can't see it. It's Not Updating company ranks properly, and the business Director is getting Double the Stats. If no one figures it out i'll hit it up in the a.m :\

I can't for the life of me figure it out atm, It's sudo late tho.... For some reason it is Doubleing the cron I reduced the stat raise for the director and it's doubling it on the cron loop so 25 in each stat becomes 200..it's taking all the stats and adding them together when it shouldnt. Stupid crons >,<

Strange I havent gotten an Invite yet. Upon further investigation i'm getting x's 4 on stats and comppoints, so i'm going to try and figure out what's making it do that as it doesnt make sense off hand >,<

add me, i am curious why this isnt working right for you :\ [email protected] it may have something to do with the endurance instance bugging the cron but I just corrected that updating original post now

Crap, again..found another bug though I dno why it's working on my site >,< Find in Business_cron in the arrays do a page search for endurance change any instance of endurance to strength

Although I'm 99.9% sure this cron is identical to the one on the first page..this is the one running on my game and working 100%   <?php include "config.php"; global $_CONFIG; if($_GET['code'] != $_CONFIG['code']) { die(""); } define("MONO_ON", 1); require "class/class_db_{$_CONFIG['driver']}.php"; $db=new database; $db->configure($_CONFIG['hostname'], $_CONFIG['username'], $_CONFIG['password'], $_CONFIG['database'], $_CONFIG['persistent']); $db->connect(); $c=$db->connection_id; $set=array(); $settq=$db->query("SELECT * FROM settings"); while($r=$db->fetch_row($settq)) { $set[$r['conf_name']]=$r['conf_value']; } include "global_func.php"; mysql_query("UPDATE `businesses` SET `brank` = '100000' WHERE `brank` > '100000'"); $select_businesses = mysql_query("SELECT * FROM `businesses` LEFT JOIN `businesses_classes` ON (`classId` = `busClass`) ORDER BY `busId` ASC"); while($bs = mysql_fetch_assoc($select_businesses)) { $amount = mysql_num_rows(mysql_query(sprintf("SELECT * FROM `businesses_members` WHERE `bmembBusiness` = '%u'", $bs['busId']))); $active = mysql_num_rows(mysql_query(sprintf("SELECT * FROM `users` WHERE `business` = '%u' AND active='1'", $bs['busId']))); $new_customers = ($bs['brank']*($active)+ rand(10, 20)*$bs['classCost'] / 200); $new_profit = (($new_customers)+ rand(110, 990)); $new_rank = ($bs['classId']*($active)/2); //$new_customers = ((($bs['classCost'] / 95000) * ($amount + 1) + rand(5, 18)) / 10); //$new_profit = (($new_customers + rand(4, 8)) * ((($bs['classCost'] / 2500) * rand(2, 8)) / 13) * ($amount + 1)); mysql_query(sprintf("UPDATE `businesses` SET `busYCust` = `busCust`, `busYProfit` = `busProfit`, `busCust` = '%d', `busProfit` = '%d', `busCash` = '%d' WHERE `busId` = '%u'", $new_customers, $new_profit, ($new_profit + $bs['busCash']), $bs['busId'])) OR die('Cron not run'); mysql_query(sprintf("UPDATE `businesses` SET `busDays` = `busDays` + '1'")); mysql_query(sprintf("UPDATE `users` SET `activedays` = `activedays` + '1' WHERE `active` = '1'")); mysql_query(sprintf("UPDATE `users` SET `active` = '0' WHERE `active` = '1'")); mysql_query(sprintf("UPDATE `businesses` SET `brank` = `brank` + '%d' WHERE `busId` = '%u'", $new_rank, $bs['busId'])) OR die('Cron not run'); $fetch_members = mysql_query(sprintf("SELECT * FROM `businesses_members` LEFT JOIN `users` ON (`userid` = `bmembMember`) LEFT JOIN `businesses_ranks` ON (`rankId` = `bmembRank`) WHERE `bmembBusiness` = '%u'", $bs['busId'])); while($fm = mysql_fetch_assoc($fetch_members)) { $fetch_stat = array( 'endurance' => 'endurance', 'intel' => 'IQ', 'labour' => 'labour' ); mysql_query(sprintf("UPDATE `users` SET `money` = `money` + '%d' WHERE `userid` = '%u'", $fm['bmembCash'], $fm['userid'])); mysql_query(sprintf("UPDATE `users` SET `comppoints` = `comppoints` + '1' WHERE `userid` = '%u'", $fm['userid'])); mysql_query(sprintf("UPDATE `userstats` SET `{$fetch_stat[$fm['rankPrim']]}` = `{$fetch_stat[$fm['rankPrim']]}` + '%.6f', `{$fetch_stat[$fm['rankSec']]}` = `{$fetch_stat[$fm['rankSec']]}` + '%.6f' WHERE (`userid` = '%u')", $fm['rankPGain'], $fm['rankSGain'], $fm['userid'])); mysql_query(sprintf("UPDATE `userstats` SET `labour` = `labour` + '50', `IQ` = `IQ` + '50', `strength` = `strength` + '50' WHERE (`userid` = '%u')", $bs['busDirector'])); if($bs['busCash'] < $fm['bmembCash']) { $text = "Member ID {$fm['bmembMember']} was not paid their \$".number_format($fm['bmembCash'])." due to lack of funds."; mysql_query(sprintf("INSERT INTO `businesses_alerts` (`alertId`, `alertBusiness`, `alertText`, `alertTime`) VALUES ('NULL', '%u', '%s', '%d')", $bs['busId'], $text, time())); mysql_query(sprintf("UPDATE `businesses` SET `busDebt` = `busDebt` + '%d' WHERE `busId` = '%u'", $fm['bmembCash'], $bs['busId'])); } else { mysql_query(sprintf("UPDATE `businesses` SET `busCash` = `busCash` - '%d' WHERE `busId` = '%u'", $fm['bmembCash'], $bs['busId'])); } } if($bs['busDebt'] > $bs['classCost']) { $send_event = mysql_query(sprintf("SELECT `bmembMember` FROM WHERE `bmembBusiness` = '%u' ORDER BY `bmembId` DESC", $bs['busId'])); while($se = mysql_fetch_assoc($send_event)) { $text = "The {$bs['busName']} business went bankrupt\, all members have been made redundent."; insert_event($se['bmembMember'], $text); } mysql_query(sprintf("DELETE FROM `businesses_members` WHERE (`bmembBusiness` = '%u')", $bs['busId'])); mysql_query(sprintf("DELETE FROM `businesses` WHERE (`busId` = '%u')", $bs['busId'])); } } ?>

Also, the Business Director doesnt get company points He gets stats and money in the vault. mysql_query(sprintf("UPDATE `userstats` SET `labour` = `labour` + '50', `IQ` = `IQ` + '50', `strength` = `strength` + '50' WHERE (`userid` = '%u')", $bs['busDirector'])); that's the query for it nothin wrong with it...

Did you use the original one from the first page? Because I copy/pasted that directly from mine and ran it and it worked just fine...

Whoops On Business Manage find $_POST['member'] = abs(@intval($_POST['member''])); change to $_POST['member'] = abs(@intval($_POST['member'])); Original Post updated.

Sounds like you didnt copy/paste correctly. There are 2 pages to copy/paste make sure you copy them in order =P

I already asked you in the other thread... Is your game Version 1 or Version 2. If it's Version 1 the mod i posted won't work on your game.

So I take it it's fine now? ;-)

Woops, sorry Copy paste let me down and copied original, Page One Original Cron has been updated...AGAIN >,<

******edit********* manually run the cron and see if it is pitching an error as it's working on mine >,< ********* You are very welcome, again, let me know if you find any problems :) My goal is to get this bit working 100% then expand on it for the users of MWG. Mainly because w/o MWG I would still be staring at <?php ?> trying to figure out wth they meant >,< ************* As a side note to all the new members here at MWG, 6 months ago or so I couldnt so much as Install McCodes properly ....... But...Thanks to these forums....and a bit of persistance.....I'm well on my way to actuallying being a coder..... Why am i saying all this? Because you can to :D Little tips, If you have a problem...Save a back-up and play with it...try various differant things until you get it to work.....Sometimes you may suprise yourself then when you do get it to work..You've learned something. Baby steps =P If you have problems post here, always someone willing to help out, THANKS to-------MagicTallGuy, Zero-Affect,Danny696,DjKhanna,Sniko,MdShare,Karlos,Richard, and countless others for posting tips and tricks as they have helped me immensely. +1000.

**********ORIGINAL POST******************* *************UPDATED************************ So you don't have to scroll through all the pages and find this bug or that bug I will try and keep the regular post Updated to the One I run as i find any bugs. Again, if you find any post here and I'll look into it, i'm getting fairly familiar with this mod as iv'e been staring at it for 2 days >,< lol.   Thank you DjKhanna :)

I know just tinkered with it REPLACE your OLD cron with this one Tested it and it's working good now. There were two problems, when I converted all the mysql_queries to $db->queries it wasnt fetching them properly and So i went back to the mysql_queries. Also fixed the comp points there were 2 calls to 1 sprint f %u so it wasnt functioning right. Stats weren't updating because it was trying to update a stat called "endurance" which no one has i beleive :P so changed that to strength. As far as I know everything is now updating as it should as It's running 100% now on my game. I've also found a "small" bug in Business manage and will be Updating the original post shortly. Sorry folks! It's not an easy mod to play with >,<   <?php include "config.php"; global $_CONFIG; if($_GET['code'] != $_CONFIG['code']) { die(""); } define("MONO_ON", 1); require "class/class_db_{$_CONFIG['driver']}.php"; $db=new database; $db->configure($_CONFIG['hostname'], $_CONFIG['username'], $_CONFIG['password'], $_CONFIG['database'], $_CONFIG['persistent']); $db->connect(); $c=$db->connection_id; $set=array(); $settq=$db->query("SELECT * FROM settings"); while($r=$db->fetch_row($settq)) { $set[$r['conf_name']]=$r['conf_value']; } include "global_func.php"; mysql_query("UPDATE `businesses` SET `brank` = '100000' WHERE `brank` > '100000'"); $select_businesses = mysql_query("SELECT * FROM `businesses` LEFT JOIN `businesses_classes` ON (`classId` = `busClass`) ORDER BY `busId` ASC"); while($bs = mysql_fetch_assoc($select_businesses)) { $amount = mysql_num_rows(mysql_query(sprintf("SELECT * FROM `businesses_members` WHERE `bmembBusiness` = '%u'", $bs['busId']))); $active = mysql_num_rows(mysql_query(sprintf("SELECT * FROM `users` WHERE `business` = '%u' AND active='1'", $bs['busId']))); $new_customers = ($bs['brank']*($active)+ rand(10, 20)*$bs['classCost'] / 200); $new_profit = (($new_customers)+ rand(110, 990)); $new_rank = ($bs['classId']*($active)/2); //$new_customers = ((($bs['classCost'] / 95000) * ($amount + 1) + rand(5, 18)) / 10); //$new_profit = (($new_customers + rand(4, 8)) * ((($bs['classCost'] / 2500) * rand(2, 8)) / 13) * ($amount + 1)); mysql_query(sprintf("UPDATE `businesses` SET `busYCust` = `busCust`, `busYProfit` = `busProfit`, `busCust` = '%d', `busProfit` = '%d', `busCash` = '%d' WHERE `busId` = '%u'", $new_customers, $new_profit, ($new_profit + $bs['busCash']), $bs['busId'])) OR die('Cron not run'); mysql_query(sprintf("UPDATE `businesses` SET `busDays` = `busDays` + '1'")); mysql_query(sprintf("UPDATE `users` SET `activedays` = `activedays` + '1' WHERE `active` = '1'")); mysql_query(sprintf("UPDATE `users` SET `active` = '0', `rob` = '1' WHERE `active` = '1'")); mysql_query(sprintf("UPDATE `businesses` SET `brank` = `brank` + '%d' WHERE `busId` = '%u'", $new_rank, $bs['busId'])) OR die('Cron not run'); $fetch_members = mysql_query(sprintf("SELECT * FROM `businesses_members` LEFT JOIN `users` ON (`userid` = `bmembMember`) LEFT JOIN `businesses_ranks` ON (`rankId` = `bmembRank`) WHERE `bmembBusiness` = '%u'", $bs['busId'])); while($fm = mysql_fetch_assoc($fetch_members)) { $fetch_stat = array( 'endurance' => 'endurance', 'intel' => 'IQ', 'labour' => 'labour' ); mysql_query(sprintf("UPDATE `users` SET `money` = `money` + '%d' WHERE `userid` = '%u'", $fm['bmembCash'], $fm['userid'])); mysql_query(sprintf("UPDATE `users` SET `comppoints` = `comppoints` + '1' WHERE `userid` = '%u'", $fm['userid'])); mysql_query(sprintf("UPDATE `userstats` SET `{$fetch_stat[$fm['rankPrim']]}` = `{$fetch_stat[$fm['rankPrim']]}` + '%.6f', `{$fetch_stat[$fm['rankSec']]}` = `{$fetch_stat[$fm['rankSec']]}` + '%.6f' WHERE (`userid` = '%u')", $fm['rankPGain'], $fm['rankSGain'], $fm['userid'])); mysql_query(sprintf("UPDATE `userstats` SET `labour` = `labour` + '50', `IQ` = `IQ` + '50', `endurance` = `endurance` + '50' WHERE (`userid` = '%u')", $bs['busDirector'])); if($bs['busCash'] < $fm['bmembCash']) { $text = "Member ID {$fm['bmembMember']} was not paid their \$".number_format($fm['bmembCash'])." due to lack of funds."; mysql_query(sprintf("INSERT INTO `businesses_alerts` (`alertId`, `alertBusiness`, `alertText`, `alertTime`) VALUES ('NULL', '%u', '%s', '%d')", $bs['busId'], $text, time())); mysql_query(sprintf("UPDATE `businesses` SET `busDebt` = `busDebt` + '%d' WHERE `busId` = '%u'", $fm['bmembCash'], $bs['busId'])); } else { mysql_query(sprintf("UPDATE `businesses` SET `busCash` = `busCash` - '%d' WHERE `busId` = '%u'", $fm['bmembCash'], $bs['busId'])); } } if($bs['busDebt'] > $bs['classCost']) { $send_event = mysql_query(sprintf("SELECT `bmembMember` FROM WHERE `bmembBusiness` = '%u' ORDER BY `bmembId` DESC", $bs['busId'])); while($se = mysql_fetch_assoc($send_event)) { $text = "The {$bs['busName']} business went bankrupt\, all members have been made redundent."; insert_event($se['bmembMember'], $text); } mysql_query(sprintf("DELETE FROM `businesses_members` WHERE (`bmembBusiness` = '%u')", $bs['busId'])); mysql_query(sprintf("DELETE FROM `businesses` WHERE (`busId` = '%u')", $bs['busId'])); } } ?>

"You cannot attempt to rob a company more than once a day!"   Thats what I get trying to rob it. Did you ever think about adding an event when ever someone applies to your company? That's because the Default for Rob is set to 0 You have to have a cron run and Update it daily to 1. When they try to rob it goes back to 0. The other problem i'll look into.. I dno what the problem is with the session start unless you're on V1....

actually upon further review...the arrays should work fine.

Oh god another one? lol ...... I'll fix it danny one sec >,<