Jameoo

Re: Staff Apps Event please can you help me with this please as i dont know notting about updating

Re: Staff Apps Event so whats the code to updat the event to Events (1)

Hi It Sends Out The Event But It Dosent Got From Events ( 0 ) to Events ( 1 ) For App Accept $_GET['ID'] = abs((int) $_GET['ID']); mysql_query("DELETE FROM staffapps WHERE appID={$_GET['ID']}",$c); mysql_query("UPDATE users SET user_level='{$_GET['staff']}' WHERE userid='{$_GET['user']}'",$c); mysql_query("INSERT INTO mail VALUES('1', 1, 'System', '{$_GET['user']}', unix_timestamp(),'Your application' ,'Congrats, your application has been reviwed and you are now a staff member. Please view our rules so you do not loose this job.')",$c); Updated It Dosent Do The Same For App Deny   $_GET['ID'] = abs((int) $_GET['ID']); mysql_query("DELETE FROM staffapps WHERE appID={$_GET['ID']}",$c); mysql_query("INSERT INTO mail VALUES('', 0, 'System', '{$_GET['user']}', unix_timestamp(),'Your application' ,'Our staff has reviewed your staff application and unfortunately we feel you are not qualified to be a staff member. Feel free to fill in another application.')",$c);

Re: Steps Market [V2] no to prevent the mod from getting attaked its in ths mod topics and you put it in header.php

Re: [v2]Attack Ban[v2] Yet Another Great Mod From This User Thank Youuuu

Re: Steps Market [V2] I HAve Got The All The Market And Fourm Protection

Hi Im Doing This Cause No One Converted It On The Other Post Run This SQL   CREATE TABLE `stepsmarket` ( `stepsID` int(11) NOT NULL auto_increment, `stepsQTY` int(11) NOT NULL default '0', `stepsADDER` int(11) NOT NULL default '0', `stepsPRICE` int(11) NOT NULL default '0', PRIMARY KEY (`stepsID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;   Create A File Called stepsmarket.php And Put This In IT   <?php include "globals.php"; print "<center><table width=100% border=1><tr style bgcolor='black'><th><font color='red'>Steps Market</font></th></table></center> "; switch($_GET['action']) { case "buy": steps_buy(); break; case "remove": steps_remove(); break; case "add": steps_add(); break; default: steps_index(); break; } function steps_index() { global $ir,$c,$userid,$h; print "<center>[url='stepsmarket.php?action=add']Add A Listing[/url] Viewing all listings <table width=100% border=1> <tr style='background:black'> <th><font color='red'>Adder</font></th> <th><font color='red'>Qty</font></th> <th><font color='red'>Price each</font></th> <th><font color='red'>Price total</font></th> <th><font color='red'>Links</font></th> </tr>"; $q=mysql_query("SELECT steps.*, u.* FROM stepsmarket steps LEFT JOIN users u ON u.userid=steps.stepsADDER ORDER BY stepsPRICE/stepsQTY ASC",$c); while($r=mysql_fetch_array($q)) { if($r['stepsADDER'] == $userid) { $link = "[url='stepsmarket.php?action=remove&ID={$r[']Remove[/url]"; } else { $link = "[url='stepsmarket.php?action=buy&ID={$r[']Buy[/url]"; } $each= (int) $r['stepsPRICE'] / $r['stepsQTY']; print "\n<tr> <td>[url='viewuser.php?u={$r[']{$r['username']}[/url] [{$r['userid']}]</td> <td>{$r['stepsQTY']}</td> <td> \$" . number_format($each)."</td> <td>\$".number_format($r['stepsPRICE'])."</td> <td>[$link]</td> </tr>"; } print "</table></center>"; } function steps_remove() { global $ir,$c,$userid,$h; $q=mysql_query("SELECT * FROM stepsmarket WHERE stepsID={$_GET['ID']} AND stepsADDER=$userid",$c); if(!mysql_num_rows($q)) { print "Error, either these Steps do not exist, or you are not the owner. [url='stepsmarket.php']Back[/url]"; $h->endpage(); exit; } $r=mysql_fetch_array($q); mysql_query("UPDATE users SET turns=turns+{$r['stepsQTY']} where userid=$userid",$c) or die(mysql_error()); mysql_query("DELETE FROM stepsmarket WHERE stepsID={$_GET['ID']}",$c); print "Steps removed from market! [url='stepsmarket.php'] Back[/url]"; } function steps_buy() { global $ir,$c,$userid,$h; $q=mysql_query("SELECT * FROM stepsmarket steps WHERE stepsID={$_GET['ID']}",$c); if(!mysql_num_rows($q)) { print "Error, either these Steps do not exist, or they have already been bought. [url='stepsmarket.php']Back[/url]"; $h->endpage(); exit; } $r=mysql_fetch_array($q); if($r['stepsPRICE'] > $ir['money']) { print "Error, you do not have the funds to buy these Steps. [url='stepsmarket.php'] Back[/url]"; $h->endpage(); exit; } mysql_query("UPDATE users SET turns=turns+{$r['stepsQTY']} where userid=$userid",$c) or die(mysql_error()); mysql_query("DELETE FROM stepsmarket WHERE stepsID={$_GET['ID']}",$c); mysql_query("UPDATE users SET money=money-{$r['stepsPRICE']} where userid=$userid",$c); mysql_query("UPDATE users SET money=money+{$r['stepsPRICE']} where userid={$r['stepsADDER']}",$c); event_add($r['stepsADDER'],"[url='viewuser.php?u=$userid']{$ir['username']}[/url] bought your {$r['stepsQTY']} Steps from the market for \$".number_format($r['stepsPRICE']).".",$c); print "You bought the {$r['ddQTY']} Steps from the market for \$".number_format($r['stepsPRICE'])."."; } function steps_add() { global $ir,$c,$userid,$h; $_POST['amnt'] = abs((int) $_POST['amnt']); $_POST['price'] = abs((int) $_POST['price']); if($_POST['amnt']) { if($_POST['amnt'] > $ir['turns']) { die ("You are trying to add more Steps to the market than you have."); } $tp=$_POST['amnt']*$_POST['price']; mysql_query("INSERT INTO stepsmarket VALUES('',{$_POST['amnt']},$userid,$tp)", $c); mysql_query("UPDATE users SET turns=turns-{$_POST['amnt']} WHERE userid=$userid", $c); print "Steps added to market! [url='stepsmarket.php']> Back[/url]"; } else { print "<center>[b]Adding a listing...[/b] You have [b]{$ir['turns']}[/b] Steps that you can add to the market.<form action='stepsmarket.php?action=add' method='post'><table width=50% border=2><tr> <td>Steps:</td> <td><input type='text' name='amnt' value='{$ir['turns']}' /></td></tr><tr> <td>Price Each:</td> <td><input type='text' name='price' value='1000000' /></td></tr><tr> <td colspan=2 align=center><input type='submit' value='Add To Market' /></tr></table></form></center>"; } } $h->endpage(); ?>   Works And It On My Site So You Will HAve No Probs Thanks Killah999

Hi How Do I Make A New Staff Rank For mccodes V2 Thanks

Re: Attacking its ok i reset it all :cry: dam and its v2 can u help me any way :-D

this just pops up ded randomly :( Warning: Division by zero in /home/ufruh/public_html/attack.php on line 145 Warning: Division by zero in /home/ufruh/public_html/attack.php on line 146 39. Using your Knuckle Dusters you hit Solo doing 1 damage (549) Warning: Division by zero in /home/ufruh/public_html/attack.php on line 200 Warning: Division by zero in /home/ufruh/public_html/attack.php on line 202 40. Solo tried to hit you but missed (400)   Can u help me plz i tryed to replace it with the backup and new 1 but it dont work

Re: Hi I Got An Error here is the db but dno wa u mean by the co ordanate Link removed for security -- Nyna

Re: 50/50 {crystal} V2 and could you help me with this post please thanks http://criminalexistence.com/ceforums/index.php?topic=19000.0

Re: [v2]***UPDATED*** Staff Action: Full User Details[v2] Thank You This IS Some Mod And A Half Thaks Very Much

Re: 50/50 {crystal} V2 well i made it just last nite m8 and changed the file name table and money to crystals and the event thts all i done no halm i didnt know who eva dun it before me sorry (UPDATE) as i sed im new to CE so i dont know

Hi Im New Here At CE i modified the 50/50 to do crystals and im gonna do turns im just a noob with noob ideas lol   Create a table and put this in it   CREATE TABLE `chancec` ( `logID` int(20) NOT NULL auto_increment, `userID` int(11) NOT NULL default '0', `amount` int(11) NOT NULL default '0', `active` tinyint(1) NOT NULL default '0', PRIMARY KEY (`logID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=194 ;   create a php file with this called chancec.php in it   <?php include "globals.php"; $minbet=1; $maxg=10; echo "<big>50 / 50 Chance Game</big> "; function add_game() { global $ir,$c,$userid, $db, $minbet, $maxg; if(!isset($_POST['amt'])) { echo "<big>Adding a game</big> <form action='chancec.php?add=1' method='post'> Amount $<input type='text' name='amt' size=10 maxlength=10> <input type='submit' value='Add!'></form> ($maxg games max per user) [url='chancec.php']Back[/url]"; } else { $_POST['amt'] = abs((int) $_POST['amt']); if($_POST['amt'] < $minbet){echo "The minimum bet is 1 crystal [url='chancec.php?add=1']Back[/url]";exit;} $checkcount=$db->query("SELECT logID FROM chancec WHERE userID={$ir['userid']} and active=1"); if($db->num_rows($checkcount) > ($maxg-1)){echo "There is a maximum of $maxg games per user. [url='chancec.php']Back[/url]";exit;} if($ir['crystals'] < $_POST['amt']){echo "You cannot afford that amount. [url='chancec.php']Back[/url]";exit;} $db->query("UPDATE users SET crystals = crystals - {$_POST['amt']} WHERE userid = {$ir['userid']}"); $ir['money']=$ir['money'] - $_POST['amt']; $db->query("INSERT INTO chancec VALUES ('', {$ir['userid']}, {$_POST['amt']}, 1)"); echo "Your game has been set. Good Luck. [url='chancec.php']Back[/url]"; } } function view_games() { global $ir,$c,$userid, $db, $maxg; $q=$db->query("SELECT c.*, u.username FROM chancec c left join users u on u.userid = c.userID WHERE c.active = 1 ORDER BY c.logID ASC"); echo "[url='chancec.php?add=1']Add Game[/url] Table of users awaiting a challenge <table class='table' width=50%><tr><th>Game ID</th><th>User</th><th>Amount</th><th>Challenge</th><th>Cancel</th></tr>"; if($db->num_rows($q) < 1){echo "<tr><td colspan=5>There are currenly no challenges</td></tr>";} while($r=$db->fetch_row($q)) { echo "<tr><td>{$r['logID']}</td><td>[url='viewuser.php?u={$r[']{$r['username']}[/url] [{$r['userID']}]</td><td>".($r['amount'])."</td><td>[url='chancec.php?chal={$r[']Challenge[/url]</td><td>"; if($ir['userid']==$r['userID']){echo "[url='chancec.php?cancel={$r[']Cancel[/url]";} echo "</td></tr>"; } echo "</table>"; } function dogame() { global $ir,$c,$userid, $db; $_GET['chal'] = abs((int) $_GET['chal']); $q=$db->query("SELECT c.*, u.username from chancec c LEFT JOIN users u ON c.userID = u.userid Where c.logID={$_GET['chal']} AND c.active = 1 LIMIT 1"); if($db->num_rows($q) > 0) { $r=$db->fetch_row($q); if($ir['crystals'] < $r['amount']){echo "You cannot afford the challenge amount. [url='chancec.php']Back[/url]";exit;} if($ir['userid'] == $r['userID']){echo "You cannot accept your own challenge. [url='chancec.php']Back[/url]";exit;} if(rand(1,2) == 1) { $winner=$r['userID']; $loser=$ir['userid']; $winnername=$r['username']; $losername=$ir['username']; $tstring="Sorry, you Lost. Better luck next time. [url='chancec.php']Back[/url]"; $db->query("UPDATE users SET crystals = crystals - {$r['amount']} WHERE userid={$ir['userid']}"); $db->query("UPDATE users SET crystals = crystals + ({$r['amount']} * 2) WHERE userid={$r['userID']}"); } else { $winner=$ir['userid']; $loser=$r['userID']; $winnername=$ir['username']; $losername=$r['username']; $tstring="You Won! Congratulations! You Won ".($r['amount'])."crystals [url='chancec.php']Back[/url]"; $db->query("UPDATE users SET crystals = crystals + {$r['amount']} WHERE userid={$ir['userid']}"); } event_add($winner, "The game of ".($r['amount'])."crystals challenged by [url='viewuser.php?u={$r[']{$r['username']}[/url] was won by [url='viewuser.php?u={$winner}']{$winnername}[/url].", $c); event_add($loser, "The game of ".($r['amount'])."crystals challenged by [url='viewuser.php?u={$r[']{$r['username']}[/url] was won by [url='viewuser.php?u={$winner}']{$winnername}[/url].", $c); $db->query("UPDATE chancec SET active = 0 WHERE logID={$_GET['chal']}"); echo $tstring; } else { echo "This game has either been cancelled or someone played before you got the chance. [url='chancec.php']Back[/url]"; exit; } } function cancel() { global $ir,$c,$userid, $db; $_GET['cancel'] = abs((int) $_GET['cancel']); $q=$db->query("SELECT * from chancec where logID={$_GET['cancel']} AND active = 1"); if($db->num_rows($q) > 0) { $r=$db->fetch_row($q); $db->query("UPDATE users SET crystals = crystals + {$r['amount']} WHERE userid = {$ir['userid']}"); $ir['crystals']=$ir['crystals'] + $r['amount']; $db->query("UPDATE chancec SET active = -1 WHERE logID = {$_GET['cancel']}"); echo "The game has been cancelled, and your money has been returned. [url='chancec.php']Back[/url]"; } else { echo "This game has already been canceled, does not exist, or someone already played. [url='chancec.php']Back[/url]"; } } if(isset($_GET['cancel'])){cancel();} elseif(isset($_GET['chal'])){dogame();} elseif(isset($_GET['add'])){add_game();} else{view_games();} ?>

hi i got this error when i installed my game cand you please help me and tell me what i forhot i get it as soon as i log in   Warning: mysql_result() [function.mysql-result]: Unable to jump to row 0 on MySQL result index 11 in /home/ufruh/public_html/class/class_db_mysql.php on line 94