Jump to content
MakeWebGames

rockwood

Members
  • Posts

    416
  • Joined

  • Last visited

  • Days Won

    10

Everything posted by rockwood

  1. you should escape values
  2. rockwood

    Need a bot

    if(array_key_exists('id', $_POST)) i think if(isset($_POST['id'])) is better bcz is much faster
  3. it is ruthless engine as far as i can guess
  4. FULLTEXT searches are absolutely going to be faster select COUNT(columnname) FROM table WHERE INSTR(columnname,'keyword') > 0; or follow this http://www.joedolson.com/boolean-query-in-mysql.php
  5. it is very weird problem
  6. possible to see your url for testing purpose ?
  7. i think reasonable amt as per game
  8. onmouseout='style.backgroundColor='#ECEAEA ';' is looking fine ? may be it is error part
  9. Looking Awesome and Best of luck
  10. But few Cheap too
  11. my suggestion :-buy a nice VPS
  12. Monthly Most Active Player on random basis with attached activates
  13. promise from my side you can't remove this error without change
  14. your provided link is not working for me otherwise i can check properly
  15. good worked
  16. * is doing what ? its not for db problem ?? if you can do this vi /etc/my.cnf "mysql -e "set global max_connections = 700;"" and you should optimize your queries yes. But you can also run the command i gave u
  17. in html bad quotes also make some difference (due to quotes reading matter )
  18. <?php require("top.php"); ?> <?php require("usercheck.php"); require("prison_check.php"); ?> <form method="post"> <table width="550" border="0" align="center" cellpadding="0" cellspacing="2" class="table"> <tr> <td colspan="3" align="left" class="head">Top 10 Ranked Players:</td> </tr> <tr> <td width="150" align="left" class="sub">Name:</td> <td width="150" align="left" class="sub">Rank:</td> <td width="250" align="left" class="sub">Gang:</td> </tr> <?php $result = mysql_query("SELECT name,gang,exp,rank FROM login WHERE staff='0' AND sitestate='0' ORDER BY exp + 0 DESC LIMIT 0,10") or die(mysql_error()); // keeps getting the next row until there are no more to get while ($row = mysql_fetch_array($result)) { // Print out the contents of each row into a table ?> <tr> <td width="150" align="left" class="cell"><?php echo "<a href=\"view_profile.php?name=" . $row['name'] . "\" onFocus=\"if(this.blur)this.blur()\">" . $row['name'] . "</a>"; ?></td> <td width="150" align="left" class="cell"><?php echo $rank_array[$row['rank']]; ?></td> <td width="250" align="left" class="cell"><?php if (empty($row['gang'])) { echo "No Gang."; } else { echo "<a href=\"view_gang.php?name=" . $row['gang'] . "\" onFocus=\"if(this.blur)this.blur()\" >" . $row['gang'] . "</a>"; }?></td> </tr> <?php } // while ?> </table> <table width="550" border="0" align="center" cellpadding="0" cellspacing="2" class="table"> <tr> <td colspan="3" align="left" class="head">Top 10 wealthiest Players:</td> </tr> <tr> <td width="150" align="left" class="sub">Name:</td> <td width="150" align="left" class="sub">Wealth:</td> <td width="250" align="left" class="sub">Gang:</td> </tr> <?php $result = mysql_query("SELECT money,name,gang FROM login WHERE staff='0' AND sitestate='0' ORDER BY money + 0 DESC LIMIT 0,10") or die(mysql_error()); // keeps getting the next row until there are no more to get while ($row = mysql_fetch_array($result)) { // Print out the contents of each row into a table ?> <tr> <td width="150" align="left" class="cell"><?php echo "<a href=\"view_profile.php?name=" . $row['name'] . "\" onFocus=\"if(this.blur)this.blur()\">" . $row['name'] . "</a>"; ?></td> <td width="150" align="left" class="cell"><?php if ($row['money'] >= 0) { $profile_wealth = $wealth_array[0]; } if ($row['money'] >= 25000) { $profile_wealth = $wealth_array[1]; } if ($row['money'] >= 50000) { $profile_wealth = $wealth_array[2]; } if ($row['money'] >= 100000) { $profile_wealth = $wealth_array[3]; } if ($row['money'] >= 250000) { $profile_wealth = $wealth_array[4]; } if ($row['money'] >= 500000) { $profile_wealth = $wealth_array[5]; } if ($row['money'] >= 1000000) { $profile_wealth = $wealth_array[6]; } if ($row['money'] >= 10000000) { $profile_wealth = $wealth_array[7]; } if ($row['money'] >= 1000000000) { $profile_wealth = $wealth_array[8]; } if ($row['money'] >= 10000000000) { $profile_wealth = $wealth_array[9]; } echo $profile_wealth;?> </td> <td width="250" align="left" class="cell"><?php if (empty($row['gang'])) { echo "No Gang."; } else { echo "<a href=\"view_gang.php?name=" . $row['gang'] . "\" onFocus=\"if(this.blur)this.blur()\" >" . $row['gang'] . "</a>"; }?></td> </tr> <?php } // while ?> </table> </p> </form> <?php require("bottom.php"); ?> try now
  19. still having problem ? thats a mysql limitation, but you may need to just add db indexes(http://dev.mysql.com/doc/refman/5.0/en/create-index.html) if your queries are taking so long that 30 of them are processing at the same time (unless you have thousands of users on at once) help link :- https://dev.mysql.com/doc/refman/5.0/en/user-resources.html you could release your connection as soon as you're finished with it, you could perform faster queries, you could raise your limit on the mysql side, there's no easy debugging that in a jiffy
  20. me too do when my complete
  21. from where are you using JQuery lib ??(means using by online or on your server)
  22. for mod rewriting, you have to know Regex properly and as per my view by mod_rewriting you can make url nicer and less input way for users
  23. please click on Tools->Web Developer->Error Console and if you get any error paste here note : - after execution of code it will be show error
  24. what is url link ?
  25. sent example code and i can do any work in NWE easily
×
×
  • Create New...