mrmaxey

Re: No Job Payout lol well thnx but i already reinstalled the game 3 times the jobs still dont really wanna work :P

Re: No Job Payout BUMP. no one can help me :S ? or know what i could chainge in jobs.php or cron_hour.php or must i chainge something else

Re: No Job Payout jup that is why im here kinda bummed it dont work

im really wondering why my players dont get a job pay out.. i installed the game fresh and created a job and toke it after 1 week nothing then i tested somethings and still nothing. the only place i know in the crons is in the hour cron should there be in a other cron a job update ?. the 5minute cron works fine so its not my server.. if(date('G')==17) { $db->query("UPDATE users u LEFT JOIN userstats us ON u.userid=us.userid LEFT JOIN jobs j ON j.jID=u.job LEFT JOIN jobranks jr ON u.jobrank=jr.jrID SET u.money=u.money+jr.jrPAY, u.exp=u.exp+(jr.jrPAY/20) WHERE u.job > 0 AND u.jobrank > 0"); $db->query("UPDATE userstats us LEFT JOIN users u ON u.userid=us.userid LEFT JOIN jobs j ON j.jID=u.job LEFT JOIN jobranks jr ON u.jobrank=jr.jrID SET us.strength=(us.strength+1)+jr.jrSTRG-1,us.labour=(us.labour+1)+jr.jrLABOURG-1,us.IQ=(us.IQ+1)+jr.jrIQG-1 WHERE u.job > 0 AND u.jobrank > 0"); } if($set['validate_period'] == 60 && $set['validate_on']) that is the code in the cron or must i edit or add something in the job php ?

Re: Businesses Mod [Mccode V2] Fatal error: Call to undefined function business_alert() in /home/mrmaxey/public_html/business_manage.php on line 384 still the same there are 12 global $ir, $inf; in that script and i assume you only ment on line 347 edited that nothing happend still the same error chainged all. still the same $fr = mysql_fetch_assoc($fetch_rank); line384 business_alert($inf['busId'], "Member ID".$it['appMember']." has been accepted into the business."); mysql_query(sprintf("INSERT INTO `businesses_members` (`bmembId`, `bmembMember`, `bmembBusiness`, `bmembCash`, `bmembRank`) VALUES ('NULL', '%u', '%d', '%d', '%d')", $it['appMember'], $inf['busId'], $fr['rankCash'], $fr['rankId']));

Re: [McCodes V2] Assassinate user (donator only) and what if i wanna update on kill the whole account to be set back to start.. it needs allot of db query

Re: [mccodes] Simple Theme Selector   spelling error :P $header = $ir['header']; require ($header.".php"); [/php]

Re: NO DONATION.. ey is there a donator mod ? that you can add like package without editing the script..

Re: [McCodes V2] Assassinate user (donator only) include("globals.php"); if ($ir['jail']) if ($in['money']) etc ? and $db->query("UPDATE `users` SET `jail`=`jail` + '25', `jail_reason`='stupidkillers' WHERE `userid` = {$ir['userid']}"); $db->query("UPDATE `users` SET `money`= `0', WHERE `userid` = $ir['userid']}");

Re: [McCodes V2] Assassinate user (donator only)   $db->query("UPDATE `users` SET `jail`=`jail` + '25', `jail_reason`='stupidkillers' WHERE `userid` = {$ir['userid']}"); and what if i want to add more updates to it like money crystals inventory etc. how do i do a multiple update cause i keep getting errors

hello when i installed my game on a submap in my server it did not allow me to install thnx to some of ya i was able to install it in a submap but now a new problem pops up and that is that the link go's to the root exemple: this is the submap i installed my game on: www.domain.nl/game/ still my game refers to www.domain.com that is a huge issue in donation etc.

Re: [MCCODES V2+V1] Easiest Editing System you will ever need... awsome lots better thnx

Re: [McCodes V2] Assassinate user (donator only) event_add($user,"Some one attepted to assassinate you!",$c); $db->query("UPDATE users SET hp=1,hospital=25 ,hospreason='Failed Assassination' WHERE userid={$ir['userid']}"); cant i chainge this to like jail ? tryed it dont work. update users set jail=25,jail_reason=stupidkillers;P where userid={$ir['userid']}");

Re: [mccodes v2]New and improved inventory code sources for free!   yeah found that out when i wanted to use this script THNX btw. that the sql queries where wrong placed so this one below will fix the odd difference with the boots and helmet:   ALTER TABLE `users` ADD `equip_helmet` int(11) NOT NULL default '0'; ALTER TABLE `users` ADD `equip_boots` int(11) NOT NULL default '0'; ALTER TABLE `users` ADD `equip_amulet` int(11) NOT NULL default '0'; ALTER TABLE `users` ADD `equip_braclet` int(11) NOT NULL default '0'; ALTER TABLE `users` ADD `equip_ring` int(11) NOT NULL default '0'; ALTER TABLE `users` ADD `equip_special` int(11) NOT NULL default '0'; ALTER TABLE `items` ADD `helmet` int(11) NOT NULL default '0'; ALTER TABLE `items` ADD `boots` int(11) NOT NULL default '0'; ALTER TABLE `items` ADD `amulet` int(11) NOT NULL default '0'; ALTER TABLE `items` ADD `braclet` int(11) NOT NULL default '0'; ALTER TABLE `items` ADD `ring` int(11) NOT NULL default '0'; ALTER TABLE `items` ADD `special` int(11) NOT NULL default '0';   dude they work unless you edited the core..

Re: NO DONATION..   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 ',0, '0', 'a:4:{s:4:\"stat\";s:4:\"will\";s:3:\"dir\";s:3:\"pos\";s:8:\"inc_type\' at line 1 Query was INSERT INTO items VALUES('',1,'Will Potion2','',,,0, '0', 'a:4:{s:4:\"stat\";s:4:\"will\";s:3:\"dir\";s:3:\"pos\";s:8:\"inc_type\";s:6:\"figure\";s:10:\"inc_amount\";i:100;}', '0', 'a:4:{s:4:\"stat\";s:6:\"energy\";s:3:\"dir\";s:3:\"pos\";s:8:\"inc_type\";s:6:\"figure\";s:10:\"inc_amount\";i:0;}', '0', 'a:4:{s:4:\"stat\";s:6:\"energy\";s:3:\"dir\";s:3:\"pos\";s:8:\"inc_type\";s:6:\"figure\";s:10:\"inc_amount\";i:0;}', 0, 0) this error is create cause the form of create an item wasnt succesfully filled in so without a buy or sell price attached to the item its never able to complete the query... yeah very easy to find out but not when hangover :P the cron question stays.. why does my job never pays me out ? could that be cause i messed around with the cron to make the game faster ? or is it a other error.. i did not edit the cron files but specific the cron jobs. make 5 minutes 1 minute etc. kinda figure it could mess it up so. im wondering edit the cron php files or leave it be :)