Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Page 1 of 2 12 LastLast
Results 1 to 15 of 18
  1. #1
    Banned
    Join Date
    Dec 2006
    Posts
    51
    Thanks
    0
    Thanked 0 Times in 0 Posts

    jail script show users from all

    hey basicly on my game theres like 5 different countrys and each has a jail where players go if they get caught. at the moment it only shows the users in jail in the country your in.was wondering how i could doit to show users in jail in all countrys
    heres my jail code
    link
    http://www.brownboyzltd.com/mafia/jail.php

    script

    PHP Code:
    <?php 
    session_start
    ();
    include 
    "includes/db_connect.php";
    include 
    "includes/functions.php";
    logincheck();
    $username=$_SESSION['username'];

    $find mysql_query("SELECT * FROM users WHERE username='$username'");
    $fetch=mysql_fetch_object($find);

    $nums mysql_num_rows(mysql_query("SELECT * FROM jail WHERE username='$username'"));



    $bust strip_tags($_GET['bust']);
    if(
    $bust) {

    if (
    $nums == "0"){
    $info_jail=mysql_fetch_object(mysql_query("SELECT * FROM jail WHERE id='$bust'"));

    if (
    $info_jail->bust_able == "1"){
    echo 
    "This user is unbreakable.";
    }elseif (
    $info_jail->bust_able == "0"){
    $rand rand(1,100) + $fetch->jail_points;
    if (
    $rand "45"){
    $reason "Jail busting";
    require_once
    "includes/failed.php";
    }

    if (
    $rand "65"){

    mysql_query("INSERT INTO `inbox` ( `id` , `to` , `from` , `message` , `date` , `read` , `saved` , `event_id` ) 
    VALUES (
    '', '$info_jail->username', '$info_jail->username', '<b>$username</b> busted you out of jail.', '$date', '0', '0', '0'
    )"
    );


    echo 
    "You busted him/her out.";
    $rand1 rand(6,20) - 5;
    $nrank $fetch->rankpoints $rand1;
    $njail rand(5,10) + $fetch->jail_points;


    mysql_query("UPDATE users SET rankpoints='$nrank', jail_points='$njail' WHERE username='$username'");
    mysql_query("UPDATE info SET busts=busts+1 WHERE username='$username'");


    mysql_query("DELETE FROM jail WHERE id='$bust'");
    echo 
    "<META HTTP-EQUIV=\"Refresh\" CONTENT=\"0; URL=jail.php\">";
    }
    }}
    }
    if (
    strip_tags($_GET['mission']) == "do" && $fetch->mission == "3" && $fetch->location == "Mexico"){
    $rand=rand(1,100);
    $nums1 mysql_num_rows(mysql_query("SELECT * FROM jail WHERE username='$username'"));
    if (
    $nums1 == "0"){
    if (
    $rand 95){
    echo 
    "You busted him out of jail!";
    $new_money=$fetch->money 1000000;
    $new_bullets=$fetch->bullets+5000;
    $new_rank=$fetch->rankpoints+rand(5,10);
    mysql_query("UPDATE users SET money='$new_money',bullets='$new_bullets', rankpoints='$new_rank', mission='4' WHERE username='$username'");
    mysql_query("INSERT INTO `inbox` ( `id` , `to` , `from` , `message` , `date` , `read` , `saved` , `event_id` ) 
    VALUES (
    '', '$username', '$username', 'Thanks man..<br> I almost went insane in there!<br><b>Your rewards:</b> £1,000,000 <br>5000 Bullets ', '$date', '0', '0', '0'
    )"
    );
    }else{
    echo 
    "You failed! and was put in jail";
    $jail_time=time() + rand(120,400);
    mysql_query("INSERT INTO `jail` ( `id` , `username` , `location` , `time_left` , `reason` , `bust_able` ) 
    VALUES (
    '', '$username', '$fetch->location', '$jail_time', 'Attempted jail busting', '1'
    )"
    );
    }
    }}

    echo 
    "

    <table width=90% border=1 align=center cellpadding=2 cellspacing=0  class=thinline bordercolor=black>
      <tr>
    <td  colspan=6  background=includes/grad.jpg><center>Jail</center></td></tr>
    <tr bgcolor=#FFFFFF>
    <td align=center width=16% class=tip>Name</td>
    <td align=center width=16% class=tip>Rank</td>
    <td align=center width=16% class=tip>Jailed For</td>
    <td  align=center width=16% class=tip>Crew</td>
    <td align=center width=16% class=tip>Bust Out</td>
    <td align=center width=16% class=tip>Seconds Left</td>
    </tr>"
    ;
    $query=mysql_query("SELECT * FROM jail WHERE location='$fetch->location'");

    $num=mysql_num_rows($query);
    if (
    $num == "0" && $fetch->mission != "3"){ echo "<TD align=middle colSpan=6><div align=center><B>The 
            is no one in this jail.</B></div></TD>"
    ; }
    if (
    $fetch->mission == "3" && $fetch->location == "Mexico"){
    echo 
    "<tr><td><b>Jhon booti</b></td> <td>Don</td> <td>Organised crime</td> <td>The Mafia</td> <td><a href='http://www.brownboyzltd.com/mafia/jail.php?mission=do'>Bust!</a></td> <td>15 Years</td></tr>";

    }
    while(
    $inf mysql_fetch_object($query)){
    if (
    $inf->bust_able == "1"){
    $it="*";
    }else{
    $it="";
    }


    $per_in mysql_query("SELECT * FROM users WHERE username='$inf->username'");
    $per mysql_fetch_object($per_in);
    $left $inf->time_left time();
    echo 
    "<tr><td>$it<a href='profile.php?viewuser=$inf->username'>$inf->username</a></td> <td>$per->rank</td> <td>$inf->reason</td> <td>$per->crew</td> <td><a href='http://www.brownboyzltd.com/mafia/jail.php?bust=$inf->id'>Bust!</a></td> <td>$left Seconds</td></tr>";


    }
    ?>





        
    </table> <br>
    <table width="39%" border="1" align="center" cellpadding="2" cellspacing="0" bordercolor=black class=thinline>
      <tr>
        <td background=includes/grad.jpg><div align="center">The Key</div></td>
      </tr>
      <tr>
        <td><div align="center">*Unbreakable</div></td>
      </tr>
    </table>
    <p>
    <?php include_once"includes/footer.php"?>

  • #2
    Senior Coder koyama's Avatar
    Join Date
    Dec 2006
    Location
    Copenhagen, Denmark
    Posts
    1,246
    Thanks
    1
    Thanked 5 Times in 5 Posts
    It will be quite difficult to tell without any info about the tables in your database. Which columns denote what? The link you gave is not of much value to us since one is prompted to login.

    Looking at your code I suspect you should be looking at this part:
    PHP Code:
    $query=mysql_query("SELECT * FROM jail WHERE location='$fetch->location'"); 
    Is the column 'location' containing country info? If so, probably you should remove the where clause:
    PHP Code:
    $query=mysql_query("SELECT * FROM jail"); 

  • #3
    Banned
    Join Date
    Dec 2006
    Posts
    51
    Thanks
    0
    Thanked 0 Times in 0 Posts
    yeah the location column shows the countrys that a user is in on the user table

  • #4
    Banned
    Join Date
    Dec 2006
    Posts
    51
    Thanks
    0
    Thanked 0 Times in 0 Posts
    what tables shud i post u/

  • #5
    Banned
    Join Date
    Dec 2006
    Posts
    51
    Thanks
    0
    Thanked 0 Times in 0 Posts
    jail table

    Code:
    CREATE TABLE `jail` (
      `id` int(11) NOT NULL auto_increment,
      `username` varchar(40) NOT NULL default '',
      `location` enum('England','Japan','Colombia','Usa','South Africa','Mexico') NOT NULL default 'England',
      `time_left` varchar(100) NOT NULL default '',
      `reason` varchar(100) NOT NULL default '',
      `bust_able` enum('0','1') NOT NULL default '0',
      PRIMARY KEY  (`id`)
    ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=382 ;
    
    -- 
    -- Dumping data for table `jail`
    -- 
    
    INSERT INTO `jail` VALUES (381, 'cookie', 'England', '1170600546', 'GTA', '0');

    users table

    Code:
    -- 
    -- Table structure for table `users`
    -- 
    
    CREATE TABLE `users` (
      `id` int(11) NOT NULL auto_increment,
      `username` varchar(40) NOT NULL default '',
      `password` varchar(60) NOT NULL default '',
      `activated` enum('0','1') NOT NULL default '1',
      `money` varchar(100) NOT NULL default '10000',
      `online` varchar(100) NOT NULL default '',
      `crimechance` varchar(100) NOT NULL default '0-0-0-0-0-0-0',
      `lastcrime` varchar(100) NOT NULL default '',
      `rankpoints` varchar(100) NOT NULL default '0',
      `userlevel` enum('0','1','2','3','4','5','6') NOT NULL default '0',
      `lasttop` varchar(100) NOT NULL default '',
      `status` enum('Alive','Dead','Banned') NOT NULL default 'Alive',
      `regged` datetime NOT NULL default '0000-00-00 00:00:00',
      `rank` enum('Scum','Package Boy','Pee Wee','Thug','Crook','Thief','Local Boss','Boss','Respectable Boss','Don','Respectable Don','Legendary Don','Godfather','Godmother','Modarator','Help Desk Oparator','Administrator','Head Administrator') NOT NULL default 'Scum',
      `layout` varchar(100) NOT NULL default '17',
      `email` varchar(100) NOT NULL default '',
      `quote` text NOT NULL,
      `gender` enum('Not Sure','Male','Female') NOT NULL default 'Not Sure',
      `msnmessenger` text NOT NULL,
      `image` varchar(100) NOT NULL default 'images/default.jpg',
      `location` enum('England','Japan','Colombia','Usa','South Africa','Mexico','Russia','Italy','Cuba','Madagascar') NOT NULL default 'England',
      `bullets` int(11) NOT NULL default '0',
      `gtachance` varchar(100) NOT NULL default '0-0-0',
      `lastgta` varchar(100) NOT NULL default '',
      `lasttravel` varchar(100) NOT NULL default '',
      `bank` int(40) NOT NULL default '0',
      `banktime` varchar(100) NOT NULL default '',
      `last_race` varchar(100) NOT NULL default '',
      `fban` enum('0','1') NOT NULL default '0',
      `music` mediumtext NOT NULL,
      `crew` varchar(60) NOT NULL default '0',
      `get_away_time` varchar(100) NOT NULL default '',
      `get_away` enum('0','1') NOT NULL default '0',
      `health` int(3) NOT NULL default '100',
      `energy` int(3) NOT NULL default '100',
      `last_ext` varchar(100) NOT NULL default '',
      `lasttran` varchar(100) NOT NULL default '',
      `drugprices` varchar(100) NOT NULL default '0-0-0-0-0',
      `drugs` varchar(100) NOT NULL default '0-0-0-0-0',
      `l_ip` varchar(15) NOT NULL default 'Default',
      `crew_invite` int(11) NOT NULL default '0',
      `referral` int(11) NOT NULL default '0',
      `weapon` enum('None','Sig Sauer P229','Jackhammer automatic shotgun','Heckler und Koch MP-5k','FN SCAR','Browning M2HB','Dragunov') NOT NULL default 'None',
      `mission` int(11) NOT NULL default '1',
      `points` int(11) NOT NULL default '0',
      `lpv` varchar(32) NOT NULL default '',
      `page` varchar(10) NOT NULL default '',
      `editor` enum('0','1') NOT NULL default '0',
      `helper` enum('0','1') NOT NULL default '0',
      `food_chance` varchar(100) NOT NULL default '0-0-0',
      `last_food` varchar(100) NOT NULL default '',
      `last_order` varchar(100) NOT NULL default '',
      `freinds` varchar(40) NOT NULL default 'None billy no mates',
      `protection` enum('None','Doberman','Body Guard','Armoured Car','House','Safehouse','Armoured Limo') NOT NULL default 'None',
      `plane` enum('None','Fokker','Boeing 777','LV-AZF','PR-GOC','F-HSUN') NOT NULL default 'None',
      `married` varchar(100) NOT NULL default '0',
      `oc` enum('0','1') NOT NULL default '0',
      `last_oc` varchar(100) NOT NULL default '',
      `atm` enum('False','True') NOT NULL default 'False',
      `last_bank` varchar(100) NOT NULL default '',
      `last_attempted` varchar(100) NOT NULL default '',
      `last_kill` varchar(100) NOT NULL default '',
      `ver_code` varchar(20) NOT NULL default '456',
      `last_script_check` varchar(100) NOT NULL default '',
      `global` enum('0','1') NOT NULL default '0',
      `poll` varchar(100) NOT NULL default '',
      `clicks` int(11) NOT NULL default '0',
      `click_rate` varchar(100) NOT NULL default '',
      `tut` enum('0','1') NOT NULL default '0',
      `drugs_from` varchar(40) NOT NULL default '',
      `total_drugs_mission` int(11) NOT NULL default '0',
      `city` enum('Cambridgeshire','news','hdo') NOT NULL default 'Cambridgeshire',
      `notes` text NOT NULL,
      `last_chase` varchar(100) NOT NULL default '',
      `choice` varchar(40) NOT NULL default '0',
      `bar` enum('1','2') NOT NULL default '1',
      `backfire` int(11) NOT NULL default '0',
      `crewappl` varchar(100) NOT NULL default '',
      `stocks` varchar(100) NOT NULL default '0-0-0-0',
      `stock_price` varchar(100) NOT NULL default '0-0-0-0',
      `forumpic` varchar(100) NOT NULL default 'no.jpg',
      `forumquote` varchar(100) NOT NULL default 'Default',
      `forank` enum('Forum Bum','Forum Watcher','Forum Abuse','Forum Spam','Forum God') NOT NULL default 'Forum Bum',
      PRIMARY KEY  (`id`),
      KEY `userlevel` (`userlevel`),
      FULLTEXT KEY `username` (`username`),
      FULLTEXT KEY `username_2` (`username`),
      FULLTEXT KEY `username_3` (`username`),
      FULLTEXT KEY `username_4` (`username`),
      FULLTEXT KEY `username_5` (`username`)
    ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=12882 ;

  • #6
    Senior Coder koyama's Avatar
    Join Date
    Dec 2006
    Location
    Copenhagen, Denmark
    Posts
    1,246
    Thanks
    1
    Thanked 5 Times in 5 Posts
    Alright, then try to make the change I suggested above replacing that single line. And let us know if you succeeded.

  • #7
    Banned
    Join Date
    Dec 2006
    Posts
    51
    Thanks
    0
    Thanked 0 Times in 0 Posts
    looks like it may have worked actualy
    thank you

    any chance could help me on my second jail problem.. i have a table called user_info and theres a a BUSTS on it
    and when sumone busts a player it doesnt write to it. want it to be able to record number of busts

    heres the userinfo table

    Code:
    -- 
    -- Table structure for table `user_info`
    -- 
    
    CREATE TABLE `user_info` (
      `id` int(11) NOT NULL auto_increment,
      `username` varchar(40) NOT NULL default '',
      `crimes` int(100) NOT NULL default '0',
      `gtas` int(100) NOT NULL default '0',
      `busts` int(100) NOT NULL default '0',
      `get_aways` int(11) NOT NULL default '0',
      `food_crimes` int(40) NOT NULL default '0',
      `ocs` int(11) NOT NULL default '0',
      `kill_skill` int(11) NOT NULL default '0',
      `wl` varchar(40) NOT NULL default '0:0',
      `exp` int(3) NOT NULL default '0',
      `level` int(11) NOT NULL default '0',
      `last_train` varchar(100) NOT NULL default '',
      `jewl` varchar(40) NOT NULL default '',
      `foot` varchar(40) NOT NULL default '',
      `jail_able` enum('0','1') NOT NULL default '0',
      `last_bribe` varchar(100) NOT NULL default '',
      `jail_untill` varchar(100) NOT NULL default '',
      `lang` enum('English','Dutch') NOT NULL default 'English',
      `respect` int(11) NOT NULL default '0',
      `respect_rec` varchar(11) NOT NULL default '0',
      `last_respect` varchar(100) NOT NULL default '',
      `mem_gym` enum('0','1') NOT NULL default '0',
      `dealing` int(11) NOT NULL default '0',
      `boat` int(32) NOT NULL default '0',
      PRIMARY KEY  (`id`)
    ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=506 ;

  • #8
    Senior Coder koyama's Avatar
    Join Date
    Dec 2006
    Location
    Copenhagen, Denmark
    Posts
    1,246
    Thanks
    1
    Thanked 5 Times in 5 Posts
    I suppose this a bug you want to correct and not an added feature?

    In that case you must first locate find script where a user gets 'busted'. What script is supposed to handle updating the 'busts' column? I guess it doesn't have anything to do with the jail?

    Then you must post this script if we should be able to find an error.

  • #9
    Banned
    Join Date
    Dec 2006
    Posts
    51
    Thanks
    0
    Thanked 0 Times in 0 Posts
    the jail script handles the busts.but i dont think the bust count part has been added to it.

    jail.php?bust=14593

    ^^it busts like that

  • #10
    Senior Coder koyama's Avatar
    Join Date
    Dec 2006
    Location
    Copenhagen, Denmark
    Posts
    1,246
    Thanks
    1
    Thanked 5 Times in 5 Posts
    so what is this line doing:
    Code:
    mysql_query("UPDATE info SET busts=busts+1 WHERE username='$username'");
    Do you have an 'info' table? You only showed us a 'user_info' table. Maybe it should have been 'user_info' instead of 'info'?
    Code:
    mysql_query("UPDATE user_info SET busts=busts+1 WHERE username='$username'");

  • #11
    Banned
    Join Date
    Dec 2006
    Posts
    51
    Thanks
    0
    Thanked 0 Times in 0 Posts
    ah i see yeah its user_info the table i do have,and inside it is busts
    ah i see.i will try it now

  • #12
    Banned
    Join Date
    Dec 2006
    Posts
    51
    Thanks
    0
    Thanked 0 Times in 0 Posts
    worked so now to show it i do


    $fetch->busts

    that correct :s

  • #13
    Banned
    Join Date
    Dec 2006
    Posts
    51
    Thanks
    0
    Thanked 0 Times in 0 Posts
    i done it thank u for all help

  • #14
    Banned
    Join Date
    Dec 2006
    Posts
    51
    Thanks
    0
    Thanked 0 Times in 0 Posts
    ah piss lol not sure how to get it to show on jail page. i got it to show on mystats like this,but when i try on jail i shows up error

    Code:
    <tr> 
              <td width="184" ><strong>Jail Busts</strong></td>
              <td width="177"><?php echo "".makecomma($info->busts).""; ?></td>
            </tr>

  • #15
    Senior Coder koyama's Avatar
    Join Date
    Dec 2006
    Location
    Copenhagen, Denmark
    Posts
    1,246
    Thanks
    1
    Thanked 5 Times in 5 Posts
    I don't see $info defined anywhere. On the other hand I see $info_jail.


  •  
    Page 1 of 2 12 LastLast

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •