Joshua

Ok, so I'm going all out trying to get my game 100% before i actually bring it up for the public. I dont know who all can do what and how much they'd charge for it so I'm just going to post a few things that I would like to have and if you can do this let me know price, and how soon. Bare in mind i dont feel like spending a whole lot now as most of the mods I have are fine. I am looking for a Unique Layout. I have found a few browsing that I like but I dont want to replace all the scripts ..etc from my header, explore, index. as they are vital parts of other scripts I already have installed. If it comes down to it I may have to but "shrugz" So I'm looking for Unique Layout "login/register/explore/mainmenu Bots that show Always on-line that I can program to do random attacks as well as adjust their stats etc. Not sure how I can work this. I dont know the depths of this, but i'd also like to get a quote on how much it would cost to have a script installed where users can be differant charachter classes. Get back to me a.s.a.p as I'd like to get this game up and running :-) New email on my server so not sure if it's working but here it is [email protected] If it doesnt [email protected] will do.

Re: New Houses Mod [Mccodes V2] "edit" figured i'd edit instead of double post >< Anyone want to show me how i can implement using a Credit Card on the Buy House feature? Trying to find other places to use the Credit card. So far, I've got partner transfers, Individual transfers, Item Market.   Yea, I know they don't "have" to be on-line. I just seen on another game where they had it set up so they were always on-line, You could attack them over and over "for minimal xp" and they'd never go in the Hospital and occasionally ...course it was a bug for them lol...the monsters would do Random Attacks I need to go talk to the admin/coder there see what he'd charge me to design me that function >< hope not to much as I still gotta pay someone to do the graphics for my site, ahh.

Re: New Houses Mod [Mccodes V2] Na, referring to the Free mod via this forum a few pages back. The housing update. Managed to get everything 100% functional except when I purchase an Uprgrade ingame for the house, it shows up blank on the Viewusers. As I said not a biggy, gives me something to work with. But original poster asked we post any bugs/issues we find with his script :)   Now about paid mod.. About how much would it cost me to have someone write me a script where I have NPC bots that show ON-LINE all the time that I can have do Random Attacks? Gettin paid this friday and looking to upgrade my site before i open it to public. Thats really all i have left to do, that and find a graphics designer.

Re: New Houses Mod [Mccodes V2] Ah, so Like you said, it's best to keep them in Order. Good to know for future referance. Again, thanks.   One problem I've noted with this script, well the only one other than I'm a n00b ^_- When you purchase a house it shows up in your Viewuser. However, when you purchase an Upgrade for the house your Property Link is Blank.

Re: New Houses Mod [Mccodes V2] The missing { or } was my first assumption but when I corrected one that I found I got an entirely differant error, so i put it back to normal, figured one bug at a time.   This is now working 99% functional except when I add an Upgrade to the housing, i go on my Viewuser function and where Properties is listed it's blank. Think i'ma go snoop around in viewuser, should be easy to fix, i hopez.

Re: New Houses Mod [Mccodes V2] Yep, that did it. Now i have to go through what I just had and what you just posted and find the differance, i gotta learn :P Thanks a lot +1 for u :D

Re: New Houses Mod [Mccodes V2] I may have my problem but i'm not 100% could anyone Verify this   >>>>>$db->query("INSERT INTO house_upgrades VALUES(NULL, '$uname', '$uprice', '$uwill')"); print "<h3>House upgrade {$uname} added to the game.</h3> "; stafflog_add("Created House Upgrade $uname");   in my House_upgrades on MySQL I dont have a place in their for uPRICE and uWILL I only have ID, NAME, MOOD,COST in House_Upgrades table. Would this be causing my error? And if so, since i'm a noob at SQL what What would be exact name of tables I need to add and is it INT (11) Default 0? or what? Sorry to be a pest, trying to catch on to this

Re: New Houses Mod [Mccodes V2] Oh sorry, wasnt sure how that worked on this board, but I will in the future, thanks :)

Re: New Houses Mod [Mccodes V2]   :>>>>>>><<<<<<<<<?php include "sglobals.php"; if($ir['user_level'] > 2) { die("403"); } //This contains shop stuffs switch($_GET['action']) { case "addhouse": addhouse(); break; case "edithouse": edithouse(); break; case "delhouse": delhouse(); break; case "addupgrade": addupgrade(); break; case "editupgrade": editupgrade(); break; case "delupgrade": delupgrade(); break; case "delupgradesub": delupgradesub(); break; function addupgrade() { global $db, $ir, $c, $h, $userid; $uprice=abs((int) $_POST['price']); $uwill=abs((int) $_POST['will']); $uname=$_POST['name']; if($uprice and $uwill and $uname) { $q=$db->query("SELECT * FROM house_upgrades WHERE upgradeName='{$_POST['name']}'"); if($db->num_rows($q) != 0) { print "<h3>Sorry, you cannot have two upgrades with the same name.</h3> "; $h->endpage(); exit; } $db->query("INSERT INTO house_upgrades VALUES(NULL, '$uname', '$uprice', '$uwill')"); print "<h3>House upgrade {$uname} added to the game.</h3> "; stafflog_add("Created House Upgrade $uname"); } else { print "<h3>Add House Upgrade</h3> <form action='staff_houses.php?action=addupgrade' method='post'> Name: <input type='text' name='name' /> Price: <input type='text' name='price' /> Max Will: <input type='text' name='will' /> <input type='submit' value='Add Upgrade' /></form>"; } } function editupgrade() { global $db, $ir, $c, $h, $userid; switch($_POST['step']) { case "2": $uprice=abs((int) $_POST['price']); $uwill=abs((int) $_POST['will']); $q=$db->query("SELECT * FROM house_upgrades WHERE upgradeMood={$uwill} AND upgradeId!={$_POST['upgrade']}"); if($db->num_rows($q)) { print "<h3>Sorry, you cannot have two upgrades with the same maximum will.</h3> "; $h->endpage(); exit; } $uname=$_POST['name']; $q=$db->query("SELECT * FROM house_upgrades WHERE upgradeId={$_POST['upgrade']}"); $old=$db->fetch_row($q); if($old['upgradeMood'] == 100 && $old['upgradeMood'] != $uwill) { die("Sorry, this house's upgrade cannot be edited."); } $db->query("UPDATE house_upgrades SET upgradeMood=$uwill, upgradeCost=$uprice, upgradeName='$uname' WHERE upgradeId={$_POST['upgrade']}"); //$db->query("UPDATE users SET maxwill=$will WHERE maxwill={$old['hWILL']}"); //$db->query("UPDATE users SET will=maxwill WHERE will > maxwill"); print "<h3>House upgrade \"$uname\" was edited successfully.</h3> "; stafflog_add("Edited house upgrade $uname"); break; case "1": $q=$db->query("SELECT * FROM house_upgrades WHERE upgradeId={$_POST['upgrade']}"); $old=$db->fetch_row($q); print "<h3>Editing house Upgrade</h3> <form action='staff_houses.php?action=editupgrade' method='post'> <input type='hidden' name='step' value='2' /> <input type='hidden' name='upgrade' value='{$_POST['upgrade']}' /> Name: <input type='text' name='name' value='{$old['upgradeName']}' /> Price: <input type='text' name='price' value='{$old['upgradeCost']}' /> Max Will: <input type='text' name='will' value='{$old['upgradeMood']}' /> <input type='submit' value='Edit House' /></form>"; break; default: print "<h3>Editing an Upgrade</h3> <form action='staff_houses.php?action=editupgrade' method='post'> <input type='hidden' name='step' value='1' /> House: ".upgrade_dropdown($c, "upgrade")." <input type='submit' value='Edit Upgrade' /></form>"; break; } } function delupgrade() { global $db,$ir,$c,$h,$userid; if($ir['user_level'] > 2) { die("403"); } print "<h3>House House Upgrade</h3> The upgrade will be permanently removed from the game. <form action='staff_houses.php?action=delupgradesub' method='post'> Item: ".upgrade_dropdown($c,'upgrade')." <input type='submit' value='Delete Upgrade' /></form>"; } function delupgradesub() { global $db,$ir,$c,$h,$userid; if($ir['user_level'] > 2) { die("403"); } $d=$db->query("SELECT * FROM house_upgrades WHERE upgradeId={$_POST['upgrade']}"); $old=$db->fetch_row($d); $db->query("DELETE FROM house_upgrades WHERE upgradeId={$_POST['upgrade']}"); print "<h3>The \"{$old['upgradeName']}\" Upgrade was removed from the game.</h3>[url='staff_houses.php?action=delupgrade']>Back[/url]"; stafflog_add("Deleted house upgrade {$old['upgradeName']}"); } default: print "Error: This script requires an action."; break; } function addhouse() { global $db, $ir, $c, $h, $userid; $price=abs((int) $_POST['price']); $will=abs((int) $_POST['will']); $name=$_POST['name']; if($price and $will and $name) { $q=$db->query("SELECT * FROM houses WHERE hWILL={$will}"); if($db->num_rows($q)) { print "Sorry, you cannot have two houses with the same maximum will."; $h->endpage(); exit; } $db->query("INSERT INTO houses VALUES(NULL, '$name', '$price', '$will')"); print "House {$name} added to the game."; stafflog_add("Created House $name"); } else { print "<h3>Add House</h3><hr /> <form action='staff_houses.php?action=addhouse' method='post'> Name: <input type='text' name='name' /> Price: <input type='text' name='price' /> Max Will: <input type='text' name='will' /> <input type='submit' value='Add House' /></form>"; } } function edithouse() { global $db, $ir, $c, $h, $userid; switch($_POST['step']) { case "2": $price=abs((int) $_POST['price']); $will=abs((int) $_POST['will']); $q=$db->query("SELECT * FROM houses WHERE hWILL={$will} AND hID!={$_POST['id']}"); if($db->num_rows($q)) { print "Sorry, you cannot have two houses with the same maximum will."; $h->endpage(); exit; } $name=$_POST['name']; $q=$db->query("SELECT * FROM houses WHERE hID={$_POST['id']}"); $old=$db->fetch_row($q); if($old['hWILL'] == 100 && $old['hWILL'] != $will) { die("Sorry, this house's will bar cannot be edited."); } $db->query("UPDATE houses SET hWILL=$will, hPRICE=$price, hNAME='$name' WHERE hID={$_POST['id']}"); $db->query("UPDATE users SET maxwill=$will WHERE maxwill={$old['hWILL']}"); $db->query("UPDATE users SET will=maxwill WHERE will > maxwill"); print "House $name was edited successfully."; stafflog_add("Edited house $name"); break; case "1": $q=$db->query("SELECT * FROM houses WHERE hID={$_POST['house']}"); $old=$db->fetch_row($q); print "<h3>Editing a House</h3><hr /> <form action='staff_houses.php?action=edithouse' method='post'> <input type='hidden' name='step' value='2' /> <input type='hidden' name='id' value='{$_POST['house']}' /> Name: <input type='text' name='name' value='{$old['hNAME']}' /> Price: <input type='text' name='price' value='{$old['hPRICE']}' /> Max Will: <input type='text' name='will' value='{$old['hWILL']}' /> <input type='submit' value='Edit House' /></form>"; break; default: print "<h3>Editing a House</h3><hr /> <form action='staff_houses.php?action=edithouse' method='post'> <input type='hidden' name='step' value='1' /> House: ".house_dropdown($c, "house")." <input type='submit' value='Edit House' /></form>"; break; } } function delhouse() { global $db,$ir,$c,$h,$userid; if($_POST['house']) { $q=$db->query("SELECT * FROM houses WHERE hID={$_POST['house']}"); $old=$db->fetch_row($q); if($old['hWILL']==100) { die("This house cannot be deleted."); } $q2=$db->query("SELECT * FROM users WHERE maxwill={$old['hWILL']}"); $ids=array(); while($r=$db->fetch_row($q2)) { $ids[]=$r['userid']; } if(count($ids)) { $db->query("UPDATE users SET money=money+{$old['hPRICE']}, maxwill=100 WHERE userid IN(".implode(', ', $ids).")"); } $db->query("UPDATE users SET will=maxwill WHERE will > maxwill"); $db->query("DELETE FROM houses WHERE hID={$old['hID']}"); print "House {$old['hNAME']} deleted."; stafflog_add("Deleted house {$old['hNAME']}"); } else { print "<h3>Delete House</h3><hr /> Deleting a house is permanent - be sure. Any users that are currently on the house you delete will be returned to the first house, and their money will be refunded.<form action='staff_houses.php?action=delhouse' method='post'> House: ".house_dropdown($c, "house")." <input type='submit' value='Delete House' /></form>"; } } function report_clear() { global $db,$ir,$c,$h,$userid; if($ir['user_level'] > 3) { die("403"); } $_GET['ID'] = abs((int) $_GET['ID']); stafflog_add("Cleared player report ID {$_GET['ID']}"); $db->query("DELETE FROM preports WHERE prID={$_GET['ID']}"); print "Report cleared and deleted! [url='staff_users.php?action=reportsview']> Back[/url]"; } $h->endpage(); ?>>>>>>>>> >>>>>>>> :This is what I have for my Staff_Houses, Everything is working 100% With exception of this. I get the Call to Undefined function error Fatal error: Call to undefined function addupgrade() in /home/*****/public_html/staff_houses.php on line 13   Anyone see my error? I can't see anything wrong :\

Re: New Houses Mod [Mccodes V2] Bingo, That's what it was. I erased my hSELLPRICE table and my houses are working again. phew, had me nervous i'm trying to remember which all files I went through and altered to make this work incase I had to go back, like a dummy i didnt back-up ><

Re: New Houses Mod [Mccodes V2] May sound like a stupid question, but then I dont beleive in stupid questions ^_^ I have houses under Users created, but I also have Houses as a Table. In the Table Houses I have an insert so I can add a sell price to houses, which wasn't in the script posted for this set-up. IS IT possible that my hSELLPRICE field could be the culprit throwing all this coding off? :P thanks for replying btw.

Re: New Houses Mod [Mccodes V2] Doh yea i'll check that, still cant figure out my SQL prob QUERY ERROR: Column count doesn't match value count at row 1 Query was INSERT INTO houses VALUES(NULL, 'Test', '10000', '1000') Any ideas? Been on this awhile perhaps i have a typo somewhere..

Re: New Houses Mod [Mccodes V2] Just added the Updated Mod posted above and got Fatal error: Call to undefined function addupgrade() in /home/thug/public_html/staff_houses.php on line 13   So now i'm 2 errors in the hole, think i'll be removing this mod ><

Re: New Houses Mod [Mccodes V2] Anyone explain why I'm getting this error when I try to create the houses in the Staff panel QUERY ERROR: Column count doesn't match value count at row 1 Query was INSERT INTO houses VALUES(NULL, 'Test', '10000', '1000')

Re: [MCCODES V2] 100% Working Copy Enhanced Schooling I'm not 100% i'm still working on it myself. For whatever reason my Crons do NOT want to work, really frustrating to having to wait an hour to find this out >< hehe

Re: [MCCODES V2] 100% Working Copy Enhanced Schooling I just wanted to give a Shout Out to all you guys posting these free mods. I've just recently gotten into learining PhP and mySQL and you guys have been a terrific help. It took me forever but I finally managed to get this app to work right on my game. I'm not 100% sure of the crons just of yet, but we shall see. Great job guys, I'm envious of your talents :)

Re: So i've searched here and still can't find. Help with cities. oops, sorry for the triple posts, I figured it out ^_- Had tried using a code from V1 in V2 and apparently it through everything off :P

Re: So i've searched here and still can't find. Help with cities. Probably would have helped if I added this is McCodes Version 2.

At first I had problems creating cities. Figured this one out, moved on. Now when I create the city, and go to the Monorail to actually use the city and travel, I get this error   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 'location=2 WHERE userid=1' at line 1 Query was UPDATE users SET money=money-,location=2 WHERE userid=1   Any help would be most greatly appreciated.