Jump to content
MakeWebGames

keez123

Members
  • Posts

    42
  • Joined

  • Last visited

Everything posted by keez123

  1. iv done it
  2. thats exactly what i meant thankyou
  3. this may be a stupid question but none of the mods add to the game, i follow all step but none of them add to the explore or anything?
  4. im sorry but what do i do with the cron?..
  5. i figured that out for myself, their advise didnt help me
  6. could anyone tell me how to convert from v2 to v1 please?
  7. i realized all of that just after i posted
  8. i think i found my problem, there isnt a users.php file or anything
  9. what am i doing with this exactly?
  10. right, before this is what it says Writing game configuration... Unknown column 'pass_salt' in 'field list' i found "writing game configuration..." does this help me at all?
  11. this error comes up while trying to install
  12. i dont know what table to add it to, otherwise i know
  13. thats the part i dont know
  14. thats fine, sorry for doing that
  15. delete or add pass_salt?
  16. im learning.. slowly but learning
  17. how do i add a field to my database table?
  18. i dont know what query..
  19. remove what from where?!
  20. Unknown column 'pass_salt' in 'field list' does anyone know how to fix this?
  21. that made it worse
  22. where am i putting this?
  23. 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 'r+IQ > 500 AND us.userid != 1 AND u.user_level != 0' at line 1 Query was SELECT count(*) FROM userstats us LEFT JOIN users u ON us.userid=u.userid WHERE us.strength+agility+guard+labou r+IQ > 500 AND us.userid != 1 AND u.user_level != 0 do you know what my problem is?
  24. that works, thankyou very much!
  25. <?php /* session_start(); require "global_func.php"; if ($_SESSION['loggedin'] == 0) { header("Location: login.php"); exit; } $userid = $_SESSION['userid']; require "header.php"; $h = new headers; $h->startheaders(); include "mysql.php"; global $c; $is = mysql_query( "SELECT u.*,us.*,h.* FROM users u LEFT JOIN userstats us ON u.userid=us.userid LEFT JOIN houses h ON h.hWILL=u.maxwill WHERE u.userid=$userid", $c) or die(mysql_error()); $ir = mysql_fetch_array($is); check_level(); $fm = money_formatter($ir['money']); $cm = money_formatter($ir['crystals'], ''); $lv = date('F j, Y, g:i a', $ir['laston']); $h->userdata($ir, $lv, $fm, $cm); $h->menuarea(); print "<h3>General Info:</h2>"; $exp = (int) ($ir['exp'] / $ir['exp_needed'] * 100); print "<table><tr><td><b>Name:</b> {$ir['username']}</td><td><b>Crystals:</b> {$cm}</td></tr><tr> <td><b>Level:</b> {$ir['level']}</td> <td><b>Exp:</b> {$exp}%</td></tr><tr> <td><b>Money:</b> $fm</td> <td><b>HP:</b> {$ir['hp']}/{$ir['maxhp']}</td></tr> <tr><td><b>Property:</b> {$ir['hNAME']}</td></tr></table>"; print "<hr><h3>Stats Info:</h3>"; $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); print "<table><tr><td><b>Strength:</b> {$ir['strength']} [Ranked: {$ir['strank']}]</td><td><b>Agility:</b> {$ir['agility']} [Ranked: {$ir['agirank']}]</td></tr> <tr><td><b>Guard:</b> {$ir['guard']} [Ranked: {$ir['guarank']}]</td><td><b>Labour:</b> {$ir['labour']} [Ranked: {$ir['labrank']}]</td></tr> <tr><td><b>IQ: </b> {$ir['IQ']} [Ranked: {$ir['IQrank']}]</td><td><b>Total stats:</b> {$ts} [Ranked: $tsrank]</td></tr></table>"; $h->endpage();
×
×
  • Create New...