girardz

I have it set up on my game so that you can try as many times as you want on the two paid safes but limited to 10 tries on the free safe. Just open cracksafe.php   if($ir['safetries'] < 1) { print " <font color=#800517>You have no more FREE safe attempts</font>   somewhere near the top under: <?php include "globals.php";

I added it to my first post it must have been missed. :rolleyes:   if ($ir ['safetries']<= 0) { print "<font color=#800517>[b]<h3>You have no more try's today come back tomorow"; $h->endpage(); exit; }

I added total attempts to each pot: Replace crackasafe.php <?php //****Modified by Immortal Thug // //***Please keep this notice. include "globals.php"; if(isset($_SESSION['view'])) { $_SESSION['view']=$_SESSION['view']+1; } else { $_SESSION['view']=1; } print "Page Views This Session: ".$_SESSION['view']; $safe=$db->query("SELECT * FROM `cracksafe` WHERE `sname`='1'"); $r=$db->fetch_row($safe); $safe=$db->query("SELECT * FROM `cracksafe2` WHERE `sname`='1'"); $r2=$db->fetch_row($safe); $safe=$db->query("SELECT * FROM `cracksafe3` WHERE `sname`='1'"); $r3=$db->fetch_row($safe); $r['winnings']=number_format($r['winnings']); $r2['winnings']=number_format($r2['winnings']); $r3['winnings']=number_format($r3['winnings']); $r['winnings2']=number_format($r['winnings2']); $r2['winnings2']=number_format($r2['winnings2']); $r3['winnings2']=number_format($r3['winnings2']); print " <table width=50% border=1 class=table> <tr align=center> <td colspan=3>Attempts Remaining:</td> <td colspan=2><font size=3><font color=green>[b]{$ir ['safetries']}[/b]</font></font></td> <tr> <th class=h colspan=2>Crack The Safe's</th> <th colspan=2>Pot Amounts</th><th></th> </tr> <tr> <th class=h colspan=2></th> <th>Cash</th><th>Credits</th><th>Attempts</th> </tr> <tr align=center> <td align=center>Safe 1 [ Free ]</td> <td>[url='cracksafe.php']Crack[/url]</td> <td>[b]<font color=green>\${$r ['winnings']}[/b]</font></td> <td>[b]<font color=green>{$r ['winnings2']}[/b]</font></td><td>[b]<font color=green>{$r ['attempts_1']}[/b]</font></td> </tr> <tr align=center> <td align=center>Safe 2 [ 10K ]</td><td>[url='cracksafe2.php']Crack[/url]</td><td>[b]<font color=green>\${$r2 ['winnings']}[/b]</font></td><td>[b]<font color=green>{$r2 ['winnings2']}[/b]</font></td><td>[b]<font color=green>{$r2 ['attempts_2']}[/b]</font></td> </tr> <tr align=center> <td align=center>Safe 3 [ 100K ]</td><td>[url='cracksafe3.php']Crack[/url]</td><td>[b]<font color=green>\${$r3 ['winnings']}[/b]</font></td><td>[b]<font color=green>{$r3 ['winnings2']}[/b]</font></td><td>[b]<font color=green>{$r3 ['attempts_3']}[/b]</font></td> </tr> </table>"; $h->endpage(); ?> Add these to DB [mysql] ALTER TABLE `cracksafe` ADD `attempts_1` INT(11) NOT NULL DEFAULT '0'; ALTER TABLE `cracksafe2` ADD `attempts_2` INT(11) NOT NULL DEFAULT '0'; ALTER TABLE `cracksafe3` ADD `attempts_3` INT(11) NOT NULL DEFAULT '0'; [/mysql] OPEN cracksafe.php FIND: <input type='submit' name='submit' value='submit'> </form>"; Add Under: $db->query("UPDATE cracksafe SET attempts_1=attempts_1+1 WHERE sname = 1"); Then Find: $db->query("UPDATE cracksafe SET pot={$r1},pot2={$r2},pot3={$r3} WHERE sname = 1"); Add Under: $db->query("UPDATE cracksafe SET attempts_1=0 WHERE sname = 1"); OPEN cracksafe2.php FIND: <input type='submit' name='submit' value='submit'> </form>"; Add Under: $db->query("UPDATE cracksafe2 SET attempts_2=attempts_2+1 WHERE sname = 1"); Then Find: $db->query("UPDATE cracksafe2 SET pot={$r1}, pot2={$r2},pot3={$r3} WHERE sname = 1"); Add Under: $db->query("UPDATE cracksafe2 SET attempts_2=0 WHERE sname = 1"); OPEN cracksafe3.php FIND: <input type='submit' name='submit' value='submit'> </form>"; Add Under: $db->query("UPDATE cracksafe3 SET attempts_3=attempts_3+1 WHERE sname = 1"); Then Find: $db->query("UPDATE cracksafe3 SET pot={$r1},pot2={$r2},pot3={$r3} WHERE sname = 1"); Add Under: $db->query("UPDATE cracksafe3 SET attempts_1=0 WHERE sname = 1"); Will reset to 0 when the pot is won.

crackasafe.php with table showing pot amounts and attempts remaining. crackasafe.php <?php //****Modified by Immortal Thug // //***Please keep this notice. include "globals.php"; if ($ir ['safetries']<= 0) { print "<font color=#800517>[b]<h3>You have no more try's today come back tomorow"; $h->endpage(); exit; } $safe=$db->query("SELECT * FROM `cracksafe` WHERE `sname`='1'"); $r=$db->fetch_row($safe); $safe=$db->query("SELECT * FROM `cracksafe2` WHERE `sname`='1'"); $r2=$db->fetch_row($safe); $safe=$db->query("SELECT * FROM `cracksafe3` WHERE `sname`='1'"); $r3=$db->fetch_row($safe); $r['winnings']=number_format($r['winnings']); $r2['winnings']=number_format($r2['winnings']); $r3['winnings']=number_format($r3['winnings']); $r['winnings2']=number_format($r['winnings2']); $r2['winnings2']=number_format($r2['winnings2']); $r3['winnings2']=number_format($r3['winnings2']); print " <table width=50% border=1 class=table> <tr align=center> <td colspan=3>Attempts Remaining:</td><td colspan=2><font size=3><font color=green>[b]{$ir ['safetries']}[/b]</font></font></td> <tr> <th class=h colspan=2>Crack The Safe's</th><th colspan=2>Pot Amounts</th> </tr> <tr> <th class=h colspan=2></th><th>Cash</th><th>Credits</th> </tr> <tr align=center> <td align=center>Safe 1 [ Free ]</td><td>[url='cracksafe.php']Crack[/url]</td><td>[b]<font color=green>\${$r ['winnings']}[/b]</font></td><td>[b]<font color=green>{$r ['winnings2']}[/b]</font></td> </tr> <tr align=center> <td align=center>Safe 2 [ 10K ]</td><td>[url='cracksafe2.php']Crack[/url]</td><td>[b]<font color=green>\${$r2 ['winnings']}[/b]</font></td><td>[b]<font color=green>{$r2 ['winnings2']}[/b]</font></td> </tr> <tr align=center> <td align=center>Safe 3 [ 100K ]</td><td>[url='cracksafe3.php']Crack[/url]</td><td>[b]<font color=green>\${$r3 ['winnings']}[/b]</font></td><td>[b]<font color=green>{$r3 ['winnings2']}[/b]</font></td> </tr> </table>"; $h->endpage(); ?> EDIT: added coding to prevent users from going into negative turns.

Not a big deal here but the original post had:   you will probably have <td colspan='3' class='c'> you need to change the 3 to a 4 to get it to display right.

OK Thanks that works But now I have: $q=$db->query("SELECT cb.*,u.*,c.npcid,cy.cityname FROM challengebots cb LEFT JOIN users u ON cb.cb_npcid=u.userid LEFT JOIN challengesbeaten c ON c.npcid=u.userid AND c.userid=$userid LEFT JOIN cities cy ON u.location=cy.cityid"); while($r=$db->fetch_row($q)) { $v=$r['userid']; $a=$db->query("SELECT count(*) FROM challengesbeaten WHERE npcid=$v"); $times=$db->fetch_single($a); $q2=$db->query("SELECT u.*,us.* FROM users u LEFT JOIN userstats us ON u.userid=us.userid WHERE u.user_level = 0 "); while($stat=$db->fetch_row($q2))   I currently have 16 NPC's in my game and its showing the same NPC 16 times then shows the next NPC 16 times and so on ???????????? the stats and other info are correct except the stats go in the correct order for the 16 and then start over on the next 16.   If that makes any sence...lol :huh:

in Immortalthug's defence he did get into my game but didnt do anything malicious, instead he notified one of my head admins who was online at the time who reported it to me, took me a few minutes to figure out how but its now fixed temporarily so thanks!

tried that it gives me: 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 '' at line 1 Query was SELECT count(*) FROM challengesbeaten WHERE npcid=

I had: [mysql]$count = mysql_query("SELECT * FROM challengebots WHERE cb_npcid=".$user['userid']) or die(mysql_error()); $count = mysql_fetch_assoc($count);[/mysql] but I couldnt get it to work.

Im trying to create a page that shows all the NPC's in my game along with each NPC's stats, weapons and armor equiped. I also want to show the number of times each NPC has been beaten. I was going to post it here when completed but I need a little help finishing it, lol I cant get the query for the count to show. NPCstats.php <?php include "sglobals.php"; { print " <table width=100% border=1 class=table> <tr align=center> <td class=h>ID</td> <td class=h>NPC Username</td> <td class=h>Level</td> <td class=h>Unit</td> <td class=h>Beaten</td> <td class=h>STRENGHT</td> <td class=h>AGILITY</td> <td class=h>GRUARD</td> <td class=h>PRI</td> <td class=h>SEC</td> <td class=h>ARM</td> </tr>"; $q=$db->query("SELECT u.*,us.* FROM users u LEFT JOIN userstats us ON u.userid=us.userid WHERE u.user_level = 0 "); while($r=$db->fetch_row($q)) print "<tr align=center> <td>{$r['userid']}</td> <td align=left>{$r['username']}</td> <td>{$r['level']}</td> <td>{$r['location']}</td> <td>COUNT CODE HERE</td> <td>{$r['strength']}</td> <td>{$r['agility']}</td> <td>{$r['guard']}</td> <td>{$r['equip_primary']}</td> <td>{$r['equip_secondary']}</td> <td>{$r['equip_armor']}</td> </tr>"; } print "</table>"; $h->endpage(); ?>   Any help finishing this would be greatly appriciated

Look in header.php for any blank images EXAMPLE: background-image:url(); If there is nothing there the page will do exactly as Floydian mentioned. FIX: I created a blank image called blank.png and inserted it into my header: EXAMPLE: background-image:url(blank.png); This should fix this issue.

RE: Re: [mccode v2] Ignore User Mail   Hate to bring this back up but has anyone fixed this, I just cant seem to find the prob. User shows up in block list ok but that user can still mail. but you cant send mail. ??

Wouldnt it be: [mysql]ALTER TABLE `gangs` ADD (`gangTER1` int(1) NOT NULL default '0', `gangTER2` int(1) NOT NULL default '0',`gangTER3` int(1) NOT NULL default '0',`gangTER4` int(1) NOT NULL default '0',`gangTER5` int(1) NOT NULL default '0',`gangTER6` int(1) NOT NULL default '0',`gangTER7` int(1) NOT NULL default '0',`gangTER8` int(1) NOT NULL default '0', `gangTER9` int(1) NOT NULL default '0',`gangTER10` int(1) NOT NULL default '0',`gangTER11` int(1) NOT NULL default '0',`gangTER12` int(1) NOT NULL default '0',`gangTER13` int(1) NOT NULL default '0',`gangTER14` int(1) NOT NULL default '0',`gangTER15` int(1) NOT NULL default '0', `gangTER16` int(1) NOT NULL default '0',`gangTER17` int(1) NOT NULL default '0',`gangTER18` int(1) NOT NULL default '0',`gangTER19` int(1) NOT NULL default '0',`gangTER20` int(1) NOT NULL default '0',`gangTER21` int(1) NOT NULL default '0',`gangTER22` int(1) NOT NULL default '0', `gangTER23` int(1) NOT NULL default '0',`gangTER24` int(1) NOT NULL default '0',`gangTER25` int(1) NOT NULL default '0');[/mysql]

Re: [mccode v2] ***UPDATED*** Staff Action: Full User Details One problem though it shows the wrong ranks   $ts=$ir['strength']+$ir['agility']+$ir['guard']+$ir['labour']+$ir['IQ']; $ir['strank']=get_rank($ir['strength'],'strength'); $ir['agirank']=get_rank($ir['agility'],'agility'); $ir['guarank']=get_rank($ir['guard'],'guard'); $ir['labrank']=get_rank($ir['labour'],'labour'); $ir['IQrank']=get_rank($ir['IQ'],'IQ'); $tsrank=get_rank($ts,'strength+agility+guard+labour+IQ'); $ir['strength']=number_format($ir['strength']); $ir['agility']=number_format($ir['agility']); $ir['guard']=number_format($ir['guard']); $ir['labour']=number_format($ir['labour']); $ir['IQ']=number_format($ir['IQ']); $ts=number_format($ts); Shows your rank and stats not the player your viewing doesnt it need to be $ts=$r['strength']+$r['agility']+$r['guard']+$r['labour']+$r['IQ']; $r['strank']=get_rank($r['strength'],'strength'); $r['agirank']=get_rank($r['agility'],'agility'); $r['guarank']=get_rank($r['guard'],'guard'); $r['labrank']=get_rank($r['labour'],'labour'); $r['IQrank']=get_rank($r['IQ'],'IQ'); $tsrank=get_rank($ts,'strength+agility+guard+labour+IQ'); $r['strength']=number_format($r['strength']); $r['agility']=number_format($r['agility']); $r['guard']=number_format($r['guard']); $r['labour']=number_format($r['labour']); $r['IQ']=number_format($r['IQ']); $ts=number_format($ts);   and change: <u>Stats Infomation</u> Strength: {$r['strength']} [Ranked: {$ir['strank']}] Agilty: {$r['agility']} [Ranked: {$ir['agirank']}] Gaurd: {$r['guard']} [Ranked: {$ir['guarank']}] Labour: {$r['labour']} [Ranked: {$ir['labrank']}] IQ: {$r['IQ']} [Ranked: {$ir['IQrank']}] Total Stats: {$ts} [Ranked: $tsrank]   Replace with: <u>Stats Infomation</u> Strength: {$r['strength']} [Ranked: {$r['strank']}] Agilty: {$r['agility']} [Ranked: {$r['agirank']}] Gaurd: {$r['guard']} [Ranked: {$r['guarank']}] Labour: {$r['labour']} [Ranked: {$r['labrank']}] IQ: {$r['IQ']} [Ranked: {$r['IQrank']}] Total Stats: {$ts} [Ranked: $tsrank]

Re: [mccode] Stalemate for attacks If a user hits F5 instead of the attack or weapon link it doesnt count hits, they could hit F5 all day. Anyone know how to fix that ?