Dazza

Hello, I have V2. I'v got an idea that I'd like to explore, so could someone please help me out. I'd like ALL the code that involves the newspaper and updating it. Obviously newspaper.php is needed but I think there is relevant code in staff_special and some other files. I'd need everything for the newspaper and everything to update it. Thanks in advance guys and gals

Re: 3 Word Game that she wears

Re: [mccode] My forgot password   I think people that cant typetalk correctly should be ignored, especially when they are after help

Re: 3 Word Game throat as she

Re: How did your RPG gaming start? Started with Dope/Drug wars - Dont think its the one your thinking of though, all you did was travelled and bought/sold drugs. First proper rpg was thecrims, then TC...

Re: 3 Word Game jellotine as it

Re: [MOD] ALL VERSIONS Interactive Radio station for your members Any screen shots for this?

Re: [v2] Faction with Armoury Leave faction function leave_faction() { global $ir,$c,$userid,$h; $sql = sprintf("SELECT * FROM `factions` fa WHERE (faID = %u)", mysql_real_escape_string($ir['faction'])); $q = mysql_query($sql); $r = mysql_fetch_array($q); if (!$_GET['act']) { print " Would you like to leave the {$r['faNAME']} faction: <form action='manage_faction.php?step=leave&act=conf' method='post'> <input type='submit' value='Leave'></form> <hr width='90%'>> [url='manage_faction.php']Back[/url]<hr width='90%'>"; } else if ($_GET['act'] == 'conf') { if ($_POST['user'] AND ($r['faLEADER'] != $_POST['user']) AND ($r['faCOLEADER'] != $_POST['user'])) { $sql3 = sprintf("UPDATE `users` SET `faction` = '%d' WHERE (`userid` = %u)", 0, $userid); mysql_query($sql3); print " You left the faction! <hr width='90%'>> [url='explore.php']Back[/url]<hr width='90%'>"; } else { print " You cannot leave while you are still leader or co-leader! <hr width='90%'>> [url='manage_faction.php']Back[/url]<hr width='90%'>"; } } }   Thanks, let me know if it all works and if anyone can solve the problem I have were it does not give items out

Re: [v2] Faction with Armoury Hmm, here are the functions for the above: Kick function kick_member() { global $ir,$c,$userid,$h; $sql = sprintf("SELECT * FROM `factions` fa WHERE (faID = %u)", mysql_real_escape_string($ir['faction'])); $q = mysql_query($sql); $r = mysql_fetch_array($q); if ($r['faLEADER'] != $userid) { print " You are not authorised to access this page. <hr width='90%'>> [url='factions.php']Back[/url]<hr width='90%'>"; } else if (!$_GET['act']) { print " Please select a faction member to kick out: <form action='manage_faction.php?step=kick&act=submit' method='post'> <select name='user' type='dropdown'>"; $users = sprintf("SELECT * FROM `users` WHERE (faction = %u)", mysql_real_escape_string($ir['faction'])); $use = mysql_query($users); while($us = mysql_fetch_array($use)) { print "<option value='{$us['userid']}'>{$us['username']}</option>"; } print "</select> <input type='submit' value='Kick'></form> <hr width='90%'>> [url='manage_faction.php']Back[/url]<hr width='90%'>"; } else if ($_GET['act'] == 'submit') { if ($_POST['user'] AND ($r['faLEADER'] != $_POST['user']) AND ($r['faCOLEADER'] != $_POST['user'])) { $sql3 = sprintf("UPDATE `users` SET `faction` = '%d' WHERE (`userid` = %u)", 0, $_POST['user']); mysql_query($sql3); print " This user was kicked out of the faction! <hr width='90%'>> [url='manage_faction.php']Back[/url]<hr width='90%'>"; } else { print " You did not select a user to kick out! <hr width='90%'>> [url='manage_faction.php?step=kick']Back[/url]<hr width='90%'>"; } } }   App manage function app_manage() { global $ir,$c,$userid,$h; $sql = sprintf("SELECT * FROM `factions` fa WHERE (faID = %u)", mysql_real_escape_string($ir['faction'])); $q = mysql_query($sql); $r = mysql_fetch_array($q); if ($r['faLEADER'] != $userid) { print " You are not authorised to access this page. <hr width='90%'>> [url='factions.php']Back[/url]<hr width='90%'>"; } else if (!$_GET['act']) { $sql2 = sprintf("SELECT * FROM `faction_apps` fp LEFT JOIN `users` u ON (u.userid = fp.fpUSER) LEFT JOIN `factions` fa ON (fa.faID = fp.fpFACTION) WHERE (fp.fpFACTION = %u)", mysql_real_escape_string($ir['faction'])); $q2 = mysql_query($sql2); print "This is a list of all applications to your faction. <table width='90%' cellspacing='1'><tr bgcolor='#AAAAAA'><th width='15%'>User</th><th width='50%'>Application</th><th width='15%'>Time</th><th width='20%'>Manage</th></tr>"; while($r2 = mysql_fetch_array($q2)) { print "<tr><td>[url='viewuser.php?u={$r2[']{$r2['username']}[/url]</td> <td>{$r2['fpAPP']}</td> <td>".date('F j Y, g:i:s a',$r2['fpTIME'])."</td> <td>[[url='manage_faction.php?step=apps&act=accept&ID={$r2[']Accept[/url] | [url='manage_faction.php?step=apps&act=decline&ID={$r2[']Decline[/url]]</td></tr>"; } print "</table> <hr width='90%'>> [url='manage_faction.php']Back[/url]<hr width='90%'>"; } else if ($_GET['act'] == 'accept') { if ($_GET['ID']) { $sql2 = sprintf("SELECT * FROM `faction_apps` fp LEFT JOIN `users` u ON (u.userid = fp.fpUSER) LEFT JOIN `factions` fa ON (fa.faID = fp.fpFACTION) WHERE (fp.fpFACTION = %u)", mysql_real_escape_string($ir['faction'])); $q2 = mysql_query($sql2); $r2 = mysql_fetch_array($q2); $sql3 = sprintf("UPDATE `users` SET `faction` = '%s' WHERE (`userid` = %u)", mysql_escape_string($r2['fpFACTION']), $r2['fpUSER']); mysql_query($sql3); $sql4 = sprintf("DELETE FROM `faction_apps` WHERE (`fpID` = %u)", mysql_escape_string($_GET['ID'])); mysql_query($sql4); print " [url='viewuser.php?u={$r2[']{$r2['username']}[/url] was accepted into your faction! <hr width='90%'>> [url='manage_faction.php']Back[/url]<hr width='90%'>"; } else { print " Invalid application ID! <hr width='90%'>> [url='manage_faction.php?step=pref']Back[/url]<hr width='90%'>"; } } else if ($_GET['act'] == 'decline') { if ($_GET['ID']) { $sql2 = sprintf("SELECT * FROM `faction_apps` fp LEFT JOIN `users` u ON (u.userid = fp.fpUSER) LEFT JOIN `factions` fa ON (fa.faID = fp.fpFACTION) WHERE (fp.fpFACTION = %u)", mysql_real_escape_string($ir['faction'])); $q2 = mysql_query($sql2); $r2 = mysql_fetch_array($q2); $sql4 = sprintf("DELETE FROM `faction_apps` WHERE (`fpID` = %u)", mysql_escape_string($_GET['ID'])); mysql_query($sql4); print " [url='viewuser.php?u={$r2[']{$r2['username']}[/url]'s application was denied! <hr width='90%'>> [url='manage_faction.php']Back[/url]<hr width='90%'>"; } else { print " Invalid application ID! <hr width='90%'>> [url='manage_faction.php?step=pref']Back[/url]<hr width='90%'>"; } } }   Give function give_vault() { global $ir,$c,$userid,$h; $sql = sprintf("SELECT * FROM `factions` fa WHERE (faID = %u)", mysql_real_escape_string($ir['faction'])); $q = mysql_query($sql); $r = mysql_fetch_array($q); if ($r['faLEADER'] != $userid) { print " You are not authorised to access this page. <hr width='90%'>> [url='factions.php']Back[/url]<hr width='90%'>"; } else if (($_POST['money'] || $_POST['points']) AND $_POST['user']) { $sql2 = sprintf("SELECT * FROM `users` WHERE (userid = %u)", mysql_real_escape_string($_POST['user'])); $q2 = mysql_query($sql2); $r2 = mysql_fetch_array($q2); if($_POST['money'] > $r['faVAULT']) { print " You are trying to give more money than your faction has. <hr width='90%'>> [url='manage_faction.php?step=give']Back[/url]<hr width='90%'>"; } else if($_POST['points'] > $r['faPOINTS']) { print " You are trying to give more tokens than your faction has. <hr width='90%'>> [url='manage_faction.php?step=give']Back[/url]<hr width='90%'>"; } else { $fac = sprintf("UPDATE `users` SET crystals=crystals+%d, money=money+%d WHERE (userid = %u)", mysql_real_escape_string($_POST['points']), mysql_real_escape_string($_POST['money']), mysql_real_escape_string($_POST['user'])); $use = sprintf("UPDATE `factions` SET faVAULT = faVAULT - %d, faPOINTS = faPOINTS - %d WHERE (faID = %u)", mysql_real_escape_string($_POST['money']), mysql_real_escape_string($_POST['points']), mysql_real_escape_string($ir['faction'])); mysql_query($fac); mysql_query($use); print " You gave ".money_formatter($_POST['money'])." and {$_POST['points']} Tokens to [url='viewuser.php?u={$r2[']{$r2['username']}[/url]. <hr width='90%'>> [url='manage_faction.php?step=give']Back[/url]<hr width='90%'>"; } } else { print " <form action='manage_faction.php?step=give' method='post'> <table width='50%' cellspacing='1'> <tr bgcolor='#AAAAAA'><th colspan='2'>Faction Vault</th></tr> <tr bgcolor='#DFDFDF' height='100'><td align='center' colspan='2'>Your faction vault currently contains ".money_formatter($r['faVAULT'])." and {$r['faPOINTS']} Tokens.</td></tr> <tr bgcolor='#AAAAAA'><th colspan='2'>Give</th></tr> <tr bgcolor='#DFDFDF'><td align='center'> Money: <input type='text' name='money'> </td> <td align='center'> Points: <input type='text' name='points'> </td> </tr> <tr bgcolor='#DFDFDF'><td colspan='2' align='center' height='50'> <select name='user' type='dropdown'>"; $users = sprintf("SELECT * FROM `users` WHERE (faction = %u)", mysql_real_escape_string($ir['faction'])); $use = mysql_query($users); while($us = mysql_fetch_array($use)) { print "<option value='{$us['userid']}'>{$us['username']}</option>"; } print "</select></td></tr> <tr bgcolor='#AAAAAA'><th colspan='2'><input type='submit' value='Give'></th></tr> </table> <hr width='90%'>> [url='manage_faction.php']Back[/url]<hr width='90%'>"; } }   That what you need?

Re: [v2] Faction with Armoury   Give money - Works, just tried it Manage Apps - Works, just tried it Kick - Works just tried it

Re: in need of hosting What country are you in? try: www.firstpro.co.uk

Re: Jail Bust That Requires 5 brave Am pretty sure you need to look at this bit of script:   if($ir['energy'] < 10) { die("Sorry, it costs 10 energy to bust someone. You only have {$ir['energy']} energy. Come back later."); }   Have a look at some of your crime scripts and get the info you need

Re: [v2] Faction with Armoury Not sure am following you? I'v come across a problem, you can donate fine but when you give to user it doesnt appear in the inventory - It disappears! Going to have a look after tea incase its something obvious

Re: [v2] Faction with Armoury Add this into manage_faction.php: case 'armory': donate_armory(); break; case 'agive': give_armory(); break;   Add this function into manage_faction.php function donate_armory() { global $ir,$c,$userid,$h; if ($_POST['amount'] AND $_POST['item']) { $_POST['amount'] = abs((int) $_POST['amount']); $_POST['item'] = abs((int) $_POST['item']); $sql = sprintf("SELECT * FROM `inventory` inv LEFT JOIN `items` i ON (i.itmid = inv.inv_itemid) WHERE inv_userid = %d AND (inv.inv_id = %u)", $ir['userid'], mysql_real_escape_string($_POST['item'])); $q = mysql_query($sql); $ir['itmHAVE'] = mysql_num_rows($q); $r = mysql_fetch_array($q); if(!$ir['itmHAVE']) { print " You do not own that item. <hr width='90%'>> [url='manage_faction.php?step=armory']Back[/url]<hr width='90%'>"; } else if($r['inv_qty'] < $_POST['amount']) { print " You dont have enough of this item. <hr width='90%'>> [url='manage_faction.php?step=armory']Back[/url]<hr width='90%'>"; } else { $ins = sprintf("INSERT INTO `faction_armoury` (`fiID`, `fiFACTION`, `fiUSER`, `fiITEM`, `fiAMOUNT`) VALUES ('NULL','%d', '%d', '%d', '%d')", $ir['faction'], $ir['userid'], $r['itmid'], $_POST['amount']); if ($r['inv_qty'] > $_POST['amount']) { $use = sprintf("UPDATE `inventory` SET inv_qty = inv_qty - %d WHERE inv_userid = %d AND (inv_id = %u)", mysql_real_escape_string($_POST['amount']), mysql_real_escape_string($ir['userid']), mysql_real_escape_string($_POST['item'])); } else { $use = sprintf("DELETE FROM `inventory` WHERE (inv_id = %u)", mysql_real_escape_string($_POST['item'])); } mysql_query($ins); mysql_query($use); print " You donated ".number_format($_POST['amount'])." {$r['itmname']}'s to the faction. <hr width='90%'>> [url='manage_faction.php?step=armory']Back[/url]<hr width='90%'>"; } } else { $sql = sprintf("SELECT * FROM `faction_armoury` fi LEFT JOIN `items` i ON (i.itmid = fi.fiITEM) LEFT JOIN `users` u ON (u.userid = fi.fiUSER) WHERE (fi.fiFACTION = %u)", $ir['faction']); $q = mysql_query($sql); print "<table width='90%' cellspacing='1'><tr bgcolor='#AAAAAA'> <th width='40%'>Item</th><th width='40%'>Donator</th><th width='20%'>Amount</th></tr>"; while ($r = mysql_fetch_array($q)) { print "<tr><td>{$r['itmname']}</td><td>[url='viewuser.php?u={$r[']{$r['username']}[/url]</td><td>{$r['fiAMOUNT']}</td></tr>"; } print "</table> [b]Donate:[/b] <form action='manage_faction.php?step=armory' method='post'> <select name='item' type='dropdown'> <option value='0'>None</option>"; $itm = sprintf("SELECT * FROM `inventory` inv LEFT JOIN `items` i ON (i.itmid = inv.inv_itemid) WHERE (inv.inv_userid = %u)", $ir['userid']); $itm = mysql_query($itm); while($it = mysql_fetch_array($itm)) { print "<option value='{$it['inv_id']}'>{$it['itmname']}</option>"; } print "</select> <input type='text' name='amount' size='5' maxlength='3'> <input type='submit' value='Submit'></form>"; print "<hr width='90%'>> [url='manage_faction.php?step=armory']Back[/url]<hr width='90%'>"; } } function give_armory() { global $ir,$c,$userid,$h; $sql2 = sprintf("SELECT * FROM `factions` fa WHERE (faID = %u)", mysql_real_escape_string($ir['faction'])); $q2 = mysql_query($sql2); $r2 = mysql_fetch_array($q2); if ($r2['faLEADER'] != $userid) { print " You are not authorised to access this page. <hr width='90%'>> [url='factions.php']Back[/url]<hr width='90%'>"; } else if ($_POST['amount'] AND $_POST['item'] AND $_POST['user']) { $_POST['amount'] = abs((int) $_POST['amount']); $_POST['item'] = abs((int) $_POST['item']); $_POST['user'] = abs((int) $_POST['user']); $sql = sprintf("SELECT * FROM `faction_armoury` fi LEFT JOIN `items` i ON (i.itmid = fi.fiITEM) LEFT JOIN `users` u ON (u.userid = %d) WHERE fiFACTION = %d AND (fi.fiID = %u)", $_POST['user'], $ir['faction'], mysql_real_escape_string($_POST['item'])); $q = mysql_query($sql); $ir['itmHAVE'] = mysql_num_rows($q); $r = mysql_fetch_array($q); if(!$ir['itmHAVE']) { print " Your faction does not own that item. <hr width='90%'>> [url='manage_faction.php?step=armory']Back[/url]<hr width='90%'>"; } else if($r['fiAMOUNT'] < $_POST['amount']) { print " Your faction does not have enough of this item. <hr width='90%'>> [url='manage_faction.php?step=armory']Back[/url]<hr width='90%'>"; } else { $ins = sprintf("INSERT INTO `inventory` (`inv_id`, `inv_itemid`, `inv_userid`, `inv_qty`) VALUES ('NULL','%d', '%d', '%d')", $_POST['item'], $_POST['user'], $_POST['amount']); if ($r['fiAMOUNT'] > $_POST['amount']) { $use = sprintf("UPDATE `faction_armoury` SET fiAMOUNT = fiAMOUNT - %d WHERE fiFACTION = %d AND (fiID = %u)", mysql_real_escape_string($_POST['amount']), mysql_real_escape_string($ir['faction']), mysql_real_escape_string($_POST['item'])); } else { $use = sprintf("DELETE FROM `faction_armoury` WHERE (fiID = %u)", mysql_real_escape_string($_POST['item'])); } mysql_query($ins); mysql_query($use); print " You gave ".number_format($_POST['amount'])." {$r['itmname']}'s to {$r['username']}. <hr width='90%'>> [url='manage_faction.php?step=armory']Back[/url]<hr width='90%'>"; } } else { $sql = sprintf("SELECT * FROM `faction_armoury` fi LEFT JOIN `items` i ON (i.itmid = fi.fiITEM) LEFT JOIN `users` u ON (u.userid = fi.fiUSER) WHERE (fi.fiFACTION = %u)", $ir['faction']); $q = mysql_query($sql); print "<table width='90%' cellspacing='1'><tr bgcolor='#AAAAAA'> <th width='40%'>Item</th><th width='40%'>Donator</th><th width='20%'>Amount</th></tr>"; while ($r = mysql_fetch_array($q)) { print "<tr><td>{$r['itmname']}</td><td>[url='viewuser.php?u={$r[']{$r['username']}[/url]</td><td>{$r['fiAMOUNT']}</td></tr>"; } print "</table> [b]Give:[/b] <form action='manage_faction.php?step=agive' method='post'> <select name='item' type='dropdown'> <option value='0'>None</option>"; $itm = sprintf("SELECT * FROM `faction_armoury` fi LEFT JOIN `items` i ON (i.itmid = fi.fiITEM) WHERE (fi.fiFACTION = %u)", $ir['faction']); $itm = mysql_query($itm); while($it = mysql_fetch_array($itm)) { print "<option value='{$it['fiID']}'>{$it['itmname']}</option>"; } print "</select> <select name='user' type='dropdown'> <option value='0'>None</option>"; $usr = sprintf("SELECT * FROM `users` WHERE (faction = %u)", $ir['faction']); $usr = mysql_query($usr); while($us = mysql_fetch_array($usr)) { print "<option value='{$us['userid']}'>{$us['username']}</option>"; } print "</select> <input type='text' name='amount' size='5' maxlength='3'> <input type='submit' value='Submit'></form>"; print "<hr width='90%'>> [url='manage_faction.php']Back[/url]<hr width='90%'>"; } }   Add these links into explore.php [url='manage_faction.php?step=armory']Faction Armory[/url] < [url='manage_faction.php?step=agive']Give Items[/url] <   There you go. I'v done this and it works perfectly on my V2 game so it should for you. I know the discussion of the V2 gangs system may be better, but I dont know what the differences are.

Re: [v2] Faction with Armoury Create manage_faction.php: <?php include "globals.php"; print "<font face='Arial' size='4'>Your Faction</font><hr width='90%'>"; if (!$ir['faction']) { die (" You are not in a faction at this time. <hr width='90%'>> [url='explore.php']Back[/url]<hr width='90%'>"); } switch ($_GET['step']) { case 'name': change_name(); break; case 'desc': change_desc(); break; case 'vault': faction_vault(); break; case 'donate': donate_vault(); break; case 'status': change_status(); break; case 'give': give_vault(); break; case 'leave': leave_faction(); break; case 'image': change_image(); break; case 'pref': change_pref(); break; case 'coleader': change_coleader(); break; case 'apps': app_manage(); break; case 'kick': kick_member(); break; default: leader_panel(); break; } function leader_panel() { global $ir,$c,$userid,$h; print " <table width='50%' cellspacing='1'> <tr><td align='center' width='50%'>[b]Leader Options[/b]</td> <td align='center' width='50%'>[b]Member Options[/b]</td></tr> <tr><td align='left' valign='top'> > [url='manage_faction.php?step=name']Change Name[/url] > [url='manage_faction.php?step=desc']Change Description[/url] > [url='manage_faction.php?step=status']Change Status[/url] > [url='manage_faction.php?step=image']Change Image[/url] > [url='manage_faction.php?step=pref']Change Prefix[/url] > [url='manage_faction.php?step=coleader']Change Co-Leader[/url] > [url='manage_faction.php?step=give']Give Money / Points[/url] > [url='manage_faction.php?step=apps']Manage Apps[/url] > [url='manage_faction.php?step=kick']Kick Member[/url] </td><td align='right' valign='top'> [url='manage_faction.php?step=vault']Faction Vault[/url] < [url='manage_faction.php?step=leave']Leave Faction[/url] <</td></tr> </table> <hr width='90%'>> [url='factions.php']Back[/url]<hr width='90%'>"; } function change_name() { global $ir,$c,$userid,$h; $sql = sprintf("SELECT * FROM `factions` fa WHERE (faID = %u)", mysql_real_escape_string($ir['faction'])); $q = mysql_query($sql); $r = mysql_fetch_array($q); if ($r['faLEADER'] != $userid) { print " You are not authorised to access this page. <hr width='90%'>> [url='factions.php']Back[/url]<hr width='90%'>"; } else if (!$_GET['act']) { print " Please type a new faction name below: <form action='manage_faction.php?step=name&act=submit' method='post'> <input type='text' name='name'> <input type='submit' value='Change'></form> <hr width='90%'>> [url='manage_faction.php']Back[/url]<hr width='90%'>"; } else if ($_GET['act'] == 'submit') { $sql2 = sprintf("SELECT * FROM `factions` WHERE (`faNAME` LIKE '%%%s%%')", mysql_real_escape_string($_POST['name'])); $cn = mysql_query($sql2); $rows = mysql_num_rows($cn); if ($_POST['name'] AND !$rows) { $sql3 = sprintf("UPDATE `factions` SET `faNAME` = '%s' WHERE (`faID` = %u)", mysql_escape_string($_POST['name']), $ir['faction']); mysql_query($sql3); print " Faction name changed to {$_POST['name']}! <hr width='90%'>> [url='manage_faction.php']Back[/url]<hr width='90%'>"; } else { print " You did not type a new name or the faction name is already taken! <hr width='90%'>> [url='manage_faction.php?step=name']Back[/url]<hr width='90%'>"; } } } function change_desc() { global $ir,$c,$userid,$h; $sql = sprintf("SELECT * FROM `factions` fa WHERE (faID = %u)", mysql_real_escape_string($ir['faction'])); $q = mysql_query($sql); $r = mysql_fetch_array($q); if ($r['faLEADER'] != $userid) { print " You are not authorised to access this page. <hr width='90%'>> [url='factions.php']Back[/url]<hr width='90%'>"; } else if (!$_GET['act']) { print " Please type a new faction description below: <form action='manage_faction.php?step=desc&act=submit' method='post'> <textarea type='text' name='desc' cols='50' rows='8'>{$r['faDESC']}</textarea> <input type='submit' value='Change'></form> <hr width='90%'>> [url='manage_faction.php']Back[/url]<hr width='90%'>"; } else if ($_GET['act'] == 'submit') { if ($_POST['desc']) { $sql3 = sprintf("UPDATE `factions` SET `faDESC` = '%s' WHERE (`faID` = %u)", mysql_escape_string($_POST['desc']), $ir['faction']); mysql_query($sql3); print " Faction description changed! <hr width='90%'>> [url='manage_faction.php']Back[/url]<hr width='90%'>"; } else { print " You did not type a new faction description! <hr width='90%'>> [url='manage_faction.php?step=desc']Back[/url]<hr width='90%'>"; } } } function change_status() { global $ir,$c,$userid,$h; $sql = sprintf("SELECT * FROM `factions` fa WHERE (faID = %u)", mysql_real_escape_string($ir['faction'])); $q = mysql_query($sql); $r = mysql_fetch_array($q); if ($r['faLEADER'] != $userid) { print " You are not authorised to access this page. <hr width='90%'>> [url='factions.php']Back[/url]<hr width='90%'>"; } else if (!$_GET['act']) { print " Please select a new faction status below: <form action='manage_faction.php?step=status&act=submit' method='post'> <select name='status' type='dropdown'> <option value='Peaceful'>Peaceful</option> <option value='Aggressive'>Aggressive</option> </select> <input type='submit' value='Change'></form> <hr width='90%'>> [url='manage_faction.php']Back[/url]<hr width='90%'>"; } else if ($_GET['act'] == 'submit') { if ($_POST['status']) { $sql3 = sprintf("UPDATE `factions` SET `faSTATUS` = '%s' WHERE (`faID` = %u)", mysql_escape_string($_POST['status']), $ir['faction']); mysql_query($sql3); print " Faction status changed! <hr width='90%'>> [url='manage_faction.php']Back[/url]<hr width='90%'>"; } else { print " You did not select a new faction status! <hr width='90%'>> [url='manage_faction.php?step=status']Back[/url]<hr width='90%'>"; } } } function change_image() { global $ir,$c,$userid,$h; $sql = sprintf("SELECT * FROM `factions` fa WHERE (faID = %u)", mysql_real_escape_string($ir['faction'])); $q = mysql_query($sql); $r = mysql_fetch_array($q); if ($r['faLEADER'] != $userid) { print " You are not authorised to access this page. <hr width='90%'>> [url='factions.php']Back[/url]<hr width='90%'>"; } else if (!$_GET['act']) { print " Please type a new faction image location below: <form action='manage_faction.php?step=image&act=submit' method='post'> <input type='text' name='image'> <input type='submit' value='Change'></form> <hr width='90%'>> [url='manage_faction.php']Back[/url]<hr width='90%'>"; } else if ($_GET['act'] == 'submit') { if ($_POST['image']) { $sql3 = sprintf("UPDATE `factions` SET `faIMAGE` = '%s' WHERE (`faID` = %u)", mysql_escape_string($_POST['image']), $ir['faction']); mysql_query($sql3); print " Faction image changed! <hr width='90%'>> [url='manage_faction.php']Back[/url]<hr width='90%'>"; } else { print " You did not type a new faction image location! <hr width='90%'>> [url='manage_faction.php?step=image']Back[/url]<hr width='90%'>"; } } } function change_pref() { global $ir,$c,$userid,$h; $sql = sprintf("SELECT * FROM `factions` fa WHERE (faID = %u)", mysql_real_escape_string($ir['faction'])); $q = mysql_query($sql); $r = mysql_fetch_array($q); if ($r['faLEADER'] != $userid) { print " You are not authorised to access this page. <hr width='90%'>> [url='factions.php']Back[/url]<hr width='90%'>"; } else if (!$_GET['act']) { print " Please type a new faction prefix below: <form action='manage_faction.php?step=pref&act=submit' method='post'> <input type='text' name='pref'> <input type='submit' value='Change'></form> <hr width='90%'>> [url='manage_faction.php']Back[/url]<hr width='90%'>"; } else if ($_GET['act'] == 'submit') { if ($_POST['pref']) { $sql3 = sprintf("UPDATE `factions` SET `faPREF` = '%s' WHERE (`faID` = %u)", mysql_escape_string($_POST['pref']), $ir['faction']); mysql_query($sql3); print " Faction prefix changed! <hr width='90%'>> [url='manage_faction.php']Back[/url]<hr width='90%'>"; } else { print " You did not type a new faction prefix! <hr width='90%'>> [url='manage_faction.php?step=pref']Back[/url]<hr width='90%'>"; } } } function change_coleader() { global $ir,$c,$userid,$h; $sql = sprintf("SELECT * FROM `factions` fa WHERE (faID = %u)", mysql_real_escape_string($ir['faction'])); $q = mysql_query($sql); $r = mysql_fetch_array($q); if ($r['faLEADER'] != $userid) { print " You are not authorised to access this page. <hr width='90%'>> [url='factions.php']Back[/url]<hr width='90%'>"; } else if (!$_GET['act']) { print " Please select a new faction co-leader below: <form action='manage_faction.php?step=coleader&act=submit' method='post'> <select name='user' type='dropdown'>"; $users = sprintf("SELECT * FROM `users` WHERE (faction = %u)", mysql_real_escape_string($ir['faction'])); $use = mysql_query($users); while($us = mysql_fetch_array($use)) { print "<option value='{$us['userid']}'>{$us['username']}</option>"; } print "</select> <input type='submit' value='Change'></form> <hr width='90%'>> [url='manage_faction.php']Back[/url]<hr width='90%'>"; } else if ($_GET['act'] == 'submit') { if ($_POST['user']) { $sql3 = sprintf("UPDATE `factions` SET `faCOLEADER` = '%s' WHERE (`faID` = %u)", mysql_escape_string($_POST['user']), $ir['faction']); mysql_query($sql3); print " Faction co-leader changed! <hr width='90%'>> [url='manage_faction.php']Back[/url]<hr width='90%'>"; } else { print " You did not select a new faction co-leader! <hr width='90%'>> [url='manage_faction.php?step=coleader']Back[/url]<hr width='90%'>"; } } } function faction_vault() { global $ir,$c,$userid,$h; $sql = sprintf("SELECT * FROM `factions` fa WHERE (faID = %u)", mysql_real_escape_string($ir['faction'])); $q = mysql_query($sql); $r = mysql_fetch_array($q); print "<form action='manage_faction.php?step=donate' method='post'> <table width='50%' cellspacing='1'> <tr bgcolor='#AAAAAA'><th colspan='2'>Faction Vault</th></tr> <tr bgcolor='#DFDFDF' height='100'><td align='center' colspan='2'>Your faction vault currently contains ".money_formatter($r['faVAULT'])." and {$r['faPOINTS']} Points.</td></tr> <tr bgcolor='#AAAAAA'><th colspan='2'>Donate</th></tr> <tr bgcolor='#DFDFDF'><td align='center'> Money: <input type='text' name='money'> </td> <td align='center'> Points: <input type='text' name='points'> </td> </tr> <tr bgcolor='#AAAAAA'><th colspan='2'><input type='submit' value='Donate'></th></tr> </table><hr width='90%'>> [url='manage_faction.php']Back[/url]<hr width='90%'>"; } function donate_vault() { global $ir,$c,$userid,$h; $sql = sprintf("SELECT * FROM `factions` fa WHERE (faID = %u)", mysql_real_escape_string($ir['faction'])); $q = mysql_query($sql); $r = mysql_fetch_array($q); if ($_POST['money'] || $_POST['points']) { if($_POST['money'] > $ir['money']) { print " You are trying to donate more money than you have. <hr width='90%'>> [url='manage_faction.php?step=vault']Back[/url]<hr width='90%'>"; } else if($_POST['points'] > $ir['crystals']) { print " You are trying to donate more Points than you have. <hr width='90%'>> [url='manage_faction.php?step=vault']Back[/url]<hr width='90%'>"; } else { $fac = sprintf("UPDATE `users` SET crystals=crystals-%d, money=money-%d WHERE (userid = %u)", mysql_real_escape_string($_POST['points']), mysql_real_escape_string($_POST['money']), $userid); $use = sprintf("UPDATE `factions` SET faVAULT = faVAULT + %d, faPOINTS = faPOINTS + %d WHERE (faID = %u)", mysql_real_escape_string($_POST['money']), mysql_real_escape_string($_POST['points']), mysql_real_escape_string($ir['faction'])); mysql_query($fac); mysql_query($use); print " You donated ".money_formatter($_POST['money'])." and {$_POST['points']} Points to the faction. <hr width='90%'>> [url='manage_faction.php?step=vault']Back[/url]<hr width='90%'>"; } } else { print " You did not type an amount of money to donate to the faction. <hr width='90%'>> [url='manage_faction.php?step=vault']Back[/url]<hr width='90%'>"; } }   and finally....

Re: [v2] Faction with Armoury Find in attacklost.php $expgainp=round($expgain/$ir['exp_needed']*100,4); print " and lost $expgainp% EXP!";   Add: if ($ir['faction'] AND $r['faction']) { mysql_query("UPDATE factions SET faREPUTATION=faREPUTATION-1 WHERE faID={$ir['faction']}",$c); mysql_query("UPDATE factions SET faREPUTATION=faREPUTATION+1 WHERE faID={$r['faction']}",$c); mysql_query("UPDATE factions SET faCHAIN=faCHAIN+1 WHERE faID={$r['faction']}",$c); mysql_query("UPDATE factions SET faBCHAIN=faCHAIN WHERE faCHAIN > faBCHAIN faID={$ir['faction']}",$c); mysql_query("UPDATE factions SET faCHAIN=0 WHERE faID={$ir['faction']}",$c); print " You have lost <font color='red'>-1</font> Reputation for your faction and broken your chain."; }   Find in attackwon.php print " and gained $expperc% EXP!"; mysql_query("UPDATE users SET exp=exp+$expgain,money=money+$stole WHERE userid=$userid",$c);   Add below: if ($ir['faction'] AND $r['faction']) { mysql_query("UPDATE factions SET faREPUTATION=faREPUTATION-1 WHERE faID={$r['faction']}",$c); mysql_query("UPDATE factions SET faREPUTATION=faREPUTATION+1 WHERE faID={$ir['faction']}",$c); mysql_query("UPDATE factions SET faCHAIN=faCHAIN+1 WHERE faID={$ir['faction']}",$c); mysql_query("UPDATE factions SET faBCHAIN=faCHAIN WHERE faCHAIN > faBCHAIN faID={$r['faction']}",$c); mysql_query("UPDATE factions SET faCHAIN=0 WHERE faID={$r['faction']}",$c); print " You have gained <font color='green'>+1</font> Reputation for your faction."; }   Add into mainmenu.php if($ir['faction']) { print "[url='manage_faction.php']Your Faction[/url] "; }   Add into explore.php: [url='factions.php?step=create']Create Faction[/url] [url='factions.php']View Factions[/url] [url='factions.php?step=search']Search Factions[/url] [url='manage_faction.php']Your Faction[/url]   Then....

Hello, First I will say I DID NOT make this mod, Richard did in this topic: http://criminalexistence.com/ceforums/index.php?topic=26678.0 He created a Faction system for the Mc Code Lite version that included an armoury. Due to myself and others wanting an armoury as the one posted up lately was 'illegal' I found this, converted it to V2 and tested it. Give Richard a nice comment and a +1 for making the mod, I just converted it to V2. Run SQL: ALTER TABLE users ADD faction INT(11) NOT NULL DEFAULT 0; ALTER TABLE users ADD faction_days INT(11) NOT NULL DEFAULT 0; CREATE TABLE `factions` ( `faID` int(11) NOT NULL auto_increment, `faNAME` varchar(255) NOT NULL default '', `faDESC` text NOT NULL, `faSTATUS` enum('Peaceful','Aggressive') NOT NULL, `faIMAGE` varchar(255) NOT NULL, `faPREF` varchar(12) NOT NULL default '', `faVAULT` int(11) NOT NULL default '0', `faPOINTS` int(11) NOT NULL default '0', `faCHAIN` int(11) NOT NULL, `faBCHAIN` int(11) NOT NULL, `faREPUTATION` int(11) NOT NULL default '0', `faLEADER` int(11) NOT NULL default '0', `faCOLEADER` int(11) NOT NULL default '0', `faCAPACITY` int(11) NOT NULL default '0', `faCRIME` int(11) NOT NULL default '0', `faTIME` int(11) NOT NULL default '0', PRIMARY KEY (`faID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; CREATE TABLE `faction_apps` ( `fpID` int(11) NOT NULL auto_increment, `fpUSER` int(11) NOT NULL, `fpFACTION` int(11) NOT NULL, `fpAPP` varchar(255) NOT NULL, `fpTIME` int(11) NOT NULL, PRIMARY KEY (`fpID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; CREATE TABLE `faction_armoury` ( `fiID` int(11) NOT NULL auto_increment, `fiFACTION` int(11) NOT NULL default '0', `fiUSER` int(11) NOT NULL, `fiITEM` int(11) NOT NULL default '0', `fiAMOUNT` bigint(20) NOT NULL default '0', PRIMARY KEY (`fiID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;   Create factions.php: <?php include "globals.php"; print "<font face='Arial' size='4'>Factions</font><hr width='90%'>"; switch ($_GET['step']) { case 'create': create_faction(); break; case 'profile': faction_profile(); break; case 'users': faction_members(); break; case 'search': search_factions(); break; case 'apply': faction_apply(); break; default: factions_index(); break; } function factions_index() { global $ir,$c,$userid,$h; $sql = sprintf("SELECT * FROM `factions` fa LEFT JOIN `users` u ON (u.userid = fa.faLEADER) ORDER BY faID DESC"); $q = mysql_query($sql); print "This is a list of all factions by ID <table width='90%' cellspacing='1'><tr bgcolor='#AAAAAA'><th width='25%'>Name</th><th width='13%'>Members</th><th width='12%'>Reputation</th><th width='50%'>Image</th></tr>"; while($r = mysql_fetch_array($q)) { print "<tr><td>[url='factions.php?step=profile&ID={$r[']<h3>{$r['faNAME']}</h3>[/url]</td><td>"; $membs = sprintf("SELECT * FROM `users` WHERE faction = %u", mysql_real_escape_string($r['faID'])); $mems = mysql_query($membs); print mysql_num_rows($mems)."</td> <td>{$r['faREPUTATION']}</td> <td>[img={$r[]</td></tr>"; } print "</table> <hr width='90%'>> [url='explore.php']Back[/url]<hr width='90%'>"; } function create_faction() { global $ir,$c,$userid,$h; $sql = sprintf("SELECT * FROM `factions` WHERE faID > 0"); $q = mysql_query($sql); $fcs = mysql_num_rows($q); $r['faCOST'] = ($fcs*10000); if($ir['money'] < $r['faCOST']) { print " You don't have enough money. It costs ".money_formatter($r['faCOST'])." to create a new Faction. <hr width='90%'>> [url='explore.php']Back[/url]<hr width='90%'>"; } else if($ir['faction'] > 0) { print " You are already part of a Faction. Leave before creating a new one. <hr width='90%'>> [url='explore.php']Back[/url]<hr width='90%'>"; } else if($_POST['name'] AND $_POST['description'] AND $_POST['status']) { $ins = sprintf("INSERT INTO `factions` (`faID`, `faNAME`, `faDESC`, `faSTATUS`, `faLEADER`, `faCOLEADER`, `faCAPACITY`, `faREPUTATION`) VALUES ('NULL','%s', '%s', '%s', '%d', '%d', '%d', '%d')", mysql_real_escape_string($_POST['name']), mysql_real_escape_string($_POST['description']), mysql_real_escape_string($_POST['status']), $userid, $userid, 10, 100); mysql_query($ins); $r['insID'] = mysql_insert_id($c); $fac = sprintf("UPDATE `users` SET faction = %d, money=money-%d WHERE (userid = %u)", $r['insID'], $r['faCOST'], $userid); mysql_query($fac); print " The {$_POST['name']} faction was successfully created. <hr width='90%'>> [url='factions.php?step=manage']Back[/url]<hr width='90%'>"; } else { print " <form action='factions.php?step=create' method='post'> A new faction will cost $10,000 times the amount of factions in existence. The current price is [b]".money_formatter($r['faCOST'])."[/b]. Name your Faction <input type='text' name='name' /> Choose a Status <select type='dropdown' name='status'> <option value='Peaceful'>Peaceful</option> <option value='Aggressive'>Aggressive</option> </select> Description <textarea name='description' cols='40' rows='7'></textarea> <input type='submit' value='Create' /></form> <hr width='90%'>> [url='factions.php']Back[/url]<hr width='90%'>"; } } function faction_profile() { global $ir,$c,$userid,$h; $sql = sprintf("SELECT * FROM `factions` fa LEFT JOIN `users` u ON (u.userid = fa.faLEADER) WHERE (fa.faID = %u)", mysql_real_escape_string($_GET['ID'])); $q = mysql_query($sql); $r = mysql_fetch_array($q); print " <table width='400' bgcolor='#DFDFDF'><tr><td align='center'>[b]<font size='5'>{$r['faNAME']}</font>[/b]</td></tr></table> [img={$r[] <table width='400' bgcolor='#DFDFDF'><tr><td valign='middle' align='center'><font size='5'>[b]{$r['faREPUTATION']}[/b]</font></td></tr></table> <table width='400' bgcolor='#DFDFDF'><tr><td width='200' valign='middle'> [b]Leader: [/b][url='viewuser.php?u={$r[']{$r['username']}[/url] "; $col = sprintf("SELECT * FROM `users` WHERE (userid = %u)", mysql_real_escape_string($r['faCOLEADER'])); $q2 = mysql_query($col); $co = mysql_fetch_array($q2); print "[b]Co-Leader: [/b][url='viewuser.php?u={$r[']{$co['username']}[/url] "; $membs = sprintf("SELECT * FROM `users` WHERE faction = %u", mysql_real_escape_string($r['faID'])); $mems = mysql_query($membs); print "[b]Members: [/b]".mysql_num_rows($mems)." [b]Reputation: [/b]{$r['faREPUTATION']} [b]Current chain: [/b]{$r['faCHAIN']} attacks [b]Best chain: [/b]{$r['faBCHAIN']} attacks [b]Status: [/b]"; if ($r['faSTATUS'] == 'Peaceful') { print "<font color='green'>[b]Peaceful[/b]</font>"; } else { print "<font color='red'>[b]Aggressive[/b]</font>"; } print " </td> <td valign='top' align='right' width='200'>[url='factions.php?step=users&ID={$r[']User list[/url] < [url='factions.php?step=apply&ID={$r[']Apply[/url] < </td></tr></table> <table width='400' bgcolor='#DFDFDF'><tr> <td width='50%' height='100%'> <table width='100%' height='100%'><tr> <td align='center'> {$r['faDESC']} </td> </tr></table></td></tr></table> <hr width='90%'>> [url='factions.php']Back[/url]<hr width='90%'>"; } function faction_members() { global $ir,$c,$userid,$h; $sql = sprintf("SELECT * FROM `factions` fa LEFT JOIN `users` u ON (u.faction = fa.faID) WHERE (fa.faID = %u)", mysql_real_escape_string($_GET['ID'])); $q = mysql_query($sql); print "<table width='90%' cellspacing='1'><tr bgcolor='#AAAAAA'><th width='25%'>Num</th><th width='25%'>Name</th><th width='25%'>Level</th><th width='25%'>Days in Faction</th></tr>"; while ($r = mysql_fetch_array($q)) { $cn++; print "<tr><td>$cn.</td><td>[url='viewuser.php?u={$r[']{$r['username']}[/url]</td><td>{$r['level']}</td><td>{$r['faction_days']}</td></tr>"; } print "</table> <hr width='90%'>> [url='factions.php?step=profile&ID={$_GET[']Back[/url]<hr width='90%'>"; } function search_factions() { global $ir,$c,$userid,$h; if (!$_POST['name']) { print "<form action='factions.php?step=search' method='post'> [b]Search by Keyword[/b] Insert the keyword that you'd like to search for Factions: <input type='text' name='name'> <input type='submit' value='Search'></form> <hr width='90%'>> [url='factions.php']Back[/url]<hr width='90%'>"; } else { $sql = sprintf("SELECT * FROM `factions` fa LEFT JOIN `users` u ON (u.userid = fa.faLEADER) WHERE (`faNAME` LIKE '%%%s%%')", mysql_real_escape_string($_POST['name'])); $q = mysql_query($sql); print "[b]Search by Keyword[/b] Keyword: {$_POST['name']} <table width='90%' cellspacing='1'><tr bgcolor='#AAAAAA'><th width='25%'>Name</th><th width='13%'>Members</th><th width='12%'>Reputation</th><th width='50%'>Image</th></tr>"; while($r = mysql_fetch_array($q)) { print "<tr><td>[url='factions.php?step=profile&ID={$r[']<h3>{$r['faNAME']}</h3>[/url]</td><td>"; $membs = sprintf("SELECT * FROM `users` WHERE faction = %u", mysql_real_escape_string($r['faID'])); $mems = mysql_query($membs); print mysql_num_rows($mems)."</td> <td>{$r['faREPUTATION']}</td> <td>[img={$r[]</td></tr>"; } print "</table> <hr width='90%'>> [url='factions.php?step=search']Back[/url]<hr width='90%'>"; } } function faction_apply() { global $ir,$c,$userid,$h; if ($ir['faction']) { print " You are already in a faction at this time. <hr width='90%'>> [url='factions.php']Back[/url]<hr width='90%'>"; } else if (!$_GET['act']) { print " Please type an application to this faction below: <form action='factions.php?step=apply&act=submit&ID={$_GET['ID']}' method='post'> <textarea type='text' name='app' cols='50' rows='8'>Type your application here</textarea> <input type='submit' value='Submit'></form> <hr width='90%'>> [url='factions.php?step=profile&ID={$_GET[']Back[/url]<hr width='90%'>"; } else if ($_GET['act'] == 'submit') { if ($_POST['app']) { $ins = sprintf("INSERT INTO `faction_apps` (`fpID`, `fpUSER`, `fpFACTION`, `fpAPP`, `fpTIME`) VALUES ('NULL','%d', '%d', '%s', '%d')", mysql_real_escape_string($ir['userid']), mysql_real_escape_string($_GET['ID']), mysql_real_escape_string($_POST['app']), time()); mysql_query($ins); print " Your application was submitted! <hr width='90%'>> [url='factions.php?step=profile&ID={$_GET[']Back[/url]<hr width='90%'>"; } else { print " You did not type an application to send! <hr width='90%'>> [url='factions.php?step=apply&ID={$_GET[']Back[/url]<hr width='90%'>"; } } } $h->endpage(); ?>

Re: [ADDON] V2 Refill A Specific User Aswell as Refill All Users Very nice +1

Re: [mccode v2] streets.php includes image + ability to fight NPCS   I'm not signing up to check am afraid. I'd hazard a guess and say you have the wrong path or filename

Re: Bars? OMG this is ATLEAST the THIRD topic you've made asking this question. You've been told yout crons are not set up - What more do you want? If your insistant on asking the same question, why not pay someone afew $ to sort it for you. -1

Re: [HELP] Crons wont update   Thats abit unclear. If you mean the code in config.php then yes i'v double checked it.

Hello, I'll explain everything. I have entered the crons correctly in crontab, with the followong command line: curl http://********/crons/cron_hour.php?cod ... ********** The code is the same as the one in config.php I have contacted my host and they told me a file was corrupted, they fixed it and said it works. I must agree, because the day cron updates perfect (So I think) but the others are still not working, nor are they working manually. I'm no coder but decided to have a look at the cron scripts, I noticed an error on one of the hospital lines that I have corrected or so I believe. It was: $db->query("UPDATE users set hospital=hospital-1 WHERE hospital>0"); Its now: $db->query("UPDATE users SET hospital=hospital-1 WHERE 'hospital' > 0"); Now, after doing this I decide to run the cron manually and see if it works but I got this error msg (I believe its not related to the above change I made). Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'root'@'localhost' (using password: NO) in /home/*****/public_html/class/class_db_mysql.php on line 46 FATAL ERROR: Could not connect to database on localhost (Access denied for user 'root'@'localhost' (using password: NO)) Line 41 { $this->connection_id=mysql_pconnect($this->host, $this->user, $this->pass) or $this->connection_error(); } else { Line 46 $this->connection_id=mysql_connect($this->host, $this->user, $this->pass, 1) or $this->connection_error(); } mysql_select_db($this->database, $this->connection_id); return $this->connection_id; Line 50 } I realise the error msg says it cannot connect the my db, where/how can I change/view the log in details for this? The rest of my game works fine. Thanks in advance

Re: [mccode] Voting token exchange Vote at Mpogr (Points 2) dont think the " should be infront of votempotg.php

Re: [mccode v2] Drugs Corner Love this mod +1 Now, I want it so at the start of every day the drug amount refreshes. Please note I am new to coding. If I go into the cron_day.php would this work? $db->query("UPDATE drugs SET dQTY=1000"); If not where am I going wrong? Thanks

Re: [mccode] Itempedia [$5.00] I cant think of a reason why anyone would want this, surely listing all possible items available takes something away from the game? Like someone telling you the main character of a film dies at the end, before you've seen it....