JayLewis's Content - PHP Freaks

DESC Records

JayLewis replied to JayLewis's topic in PHP Coding Help

Yer mate, its deffo ID i need it sorting by... its starting to do my nut in!

DESC Records

JayLewis replied to JayLewis's topic in PHP Coding Help

Nope, still not workin :|

DESC Records

JayLewis posted a topic in PHP Coding Help

i want to make all the records be shown in a decending order, i've tried using: $sql = 'SELECT * FROM `repair` ORDER BY `repair` . `id` DESC'; but its not working, any help please? Heres the code: <?php $host="xxxxxx"; // Host name $username="xxxxxxx"; // Mysql username $password="xxxxx"; // Mysql password $db_name="xxxx"; // Database name $tbl_name="xxx"; // Table name // Connect to server and select database. mysql_connect("$host", "$username", "$password")or die("cannot connect"); mysql_select_db("$db_name")or die("cannot select DB"); $sql="SELECT * FROM $tbl_name"; $result=mysql_query($sql); ?> <html> <head> <meta http-equiv="Content-Language" content="en-gb"> <meta http-equiv="Content-Type" content="text/html; charset=windows-1252"> <title>Search For A Birkenheader</title> </head> <body bgcolor="#0D3C8A"> <?php xxxx // Connect to server and select database. mysql_connect("$host", "$username", "$password")or die("cannot connect"); mysql_select_db("$db_name")or die("cannot select DB"); $sql="SELECT * FROM $tbl_name"; $result=mysql_query($sql); $count=mysql_num_rows($result); ?> <html> <head> <meta http-equiv="Content-Language" content="en-gb"> <meta http-equiv="Content-Type" content="text/html; charset=windows-1252"> <title>Search For A Birkenheader</title> </head> <body bgcolor="#0D3C8A"> <div align="center"> <table border="1" width="752" height="172" bgcolor="#FFFFFF" bordercolorlight="#000000" bordercolordark="#000000"> <tr> <td height="144" width="742" colspan="9"> <img border="0" src="banner.jpg" width="742" height="140"></td> </tr> <tr> <td height="20" width="13" bgcolor="#1C3867" align="center"> ID</td> <td height="20" width="104" bgcolor="#1C3867" align="center"> Contact Name</td> <td height="20" width="113" bgcolor="#1C3867" align="center"> Contact Number</td> <td height="20" width="70" bgcolor="#1C3867" align="center"> Make</td> <td height="20" width="75" bgcolor="#1C3867" align="center"> Model</td> <td height="20" width="89" bgcolor="#1C3867" align="center"> IMEI</td> <td height="20" width="136" bgcolor="#1C3867" align="center"> Fault</td> <td height="20" width="44" bgcolor="#1C3867" align="center"> Price</td> <td height="20" width="50" bgcolor="#1C3867" align="center"> Update</td></tr> <?php while($rows=mysql_fetch_array($result)) { ?> <tr> <td height="20" width="13" bgcolor="#1C3867" align="center"> <a href="reciept.php?id=<? echo $rows['id']; ?>" style="text-decoration: none"> <? echo $rows['id']; ?></a> </td> <td height="20" width="104" bgcolor="#1C3867" align="center"> <? echo $rows['name']; ?></td> <td height="20" width="113" bgcolor="#1C3867" align="center"> <? echo $rows['number']; ?></td> <td height="20" width="70" bgcolor="#1C3867" align="center"> <? echo $rows['make']; ?></td> <td height="20" width="75" bgcolor="#1C3867" align="center"> <? echo $rows['model']; ?></td> <td height="20" width="89" bgcolor="#1C3867" align="center"> <? echo $rows['imei']; ?></td> <td height="20" width="136" bgcolor="#1C3867" align="center"> <? echo $rows['fault']; ?></td> <td height="20" width="44" bgcolor="#1C3867" align="center"> <? echo $rows['price']; ?></td> <td height="20" width="50" bgcolor="#1C3867" align="center"> <a href="update.php?id=<? echo $rows['id']; ?>" style="text-decoration: none"> Edit</a></td></tr> <? } mysql_close(); ?>

Reading an ID onto another page

JayLewis replied to JayLewis's topic in PHP Coding Help

Yer, i know its easy to do. And i should be able to do it, using the $__GET[id] but its just not working for me :|

Reading an ID onto another page

JayLewis replied to JayLewis's topic in PHP Coding Help

Any one?

Reading an ID onto another page

JayLewis posted a topic in PHP Coding Help

I want to set up a profile for each ID.. So there is a list of sold items on a webpage with a "Reciept" link. I want to click that and it will take me to the reciept of the ID i click. So i click "Nokia 3310" and on the new page it give me all the details on another page from everything in the nokia 3310 row in the database. Thanks, Jay heres my code: <html> <head> <meta http-equiv="Content-Language" content="en-gb"> <meta http-equiv="Content-Type" content="text/html; charset=windows-1252"> <title>New Page 1</title> </head> <body bgcolor="#D0E0F0"> <table width="100%" border="1" cellspacing="0" cellpadding="3" bordercolor="#000000" height="52"> <tr> <td width="100%" bordercolorlight="#000000" bordercolordark="#000000" bgcolor="#8DA3BA" align="center"> Control Panel You are currently on page: "View Client List" Move to Pages: <a href="insert.php" style="text-decoration: none">Add A Client</a> - View Client List</td> </tr> <table width="100%" border="1" cellspacing="0" cellpadding="3" bordercolor="#3C79BD"> <tr> <td width="16" bordercolorlight="#000000" bordercolordark="#000000" bgcolor="#8DA3BA"> ID</td> <td width="76" bordercolorlight="#000000" bordercolordark="#000000" bgcolor="#8DA3BA"> Client Name</td> <td width="186" bordercolorlight="#000000" bordercolordark="#000000" bgcolor="#8DA3BA"> Address</td> <td width="114" bordercolorlight="#000000" bordercolordark="#000000" bgcolor="#8DA3BA"> Telephone Number</td> <td width="93" bordercolorlight="#000000" bordercolordark="#000000" bgcolor="#8DA3BA"> Phone/Model</td> <td width="171" bordercolorlight="#000000" bordercolordark="#000000" bgcolor="#8DA3BA"> Repair Comments</td> <td width="86" bordercolorlight="#000000" bordercolordark="#000000" bgcolor="#8DA3BA"> Start Date</td> <td width="33" bordercolorlight="#000000" bordercolordark="#000000" bgcolor="#8DA3BA"> Cost</td> <td width="58" bordercolorlight="#000000" bordercolordark="#000000" bgcolor="#8DA3BA" align="center"> Receipt </td> <td width="76" bordercolorlight="#000000" bordercolordark="#000000" bgcolor="#8DA3BA" align="center" valign="middle"> Fixed?</td> </tr> <?php $host="localhost"; // Host name $username="customcl_jay"; // Mysql username $password="123456"; // Mysql password $db_name="customcl_elitephones"; // Database name $tbl_name="test_mysql"; // Table name // Connect to server and select database. mysql_connect("$host", "$username", "$password")or die("cannot connect"); mysql_select_db("$db_name")or die("cannot select DB"); // Retrieve data from database $sql="SELECT * FROM $tbl_name"; $result=mysql_query($sql); // Start looping rows in mysql database. while($rows=mysql_fetch_array($result)){ ?> <tr> <td width="16" bordercolorlight="#000000" bordercolordark="#000000" bgcolor="#B6CCE4" align="center"><? echo $rows['id']; ?></td> <td width="76" bordercolorlight="#000000" bordercolordark="#000000" bgcolor="#B6CCE4" align="center"><? echo $rows['name']; ?> <? echo $rows['lastname']; ?></td> <td width="186" bordercolorlight="#000000" bordercolordark="#000000" bgcolor="#B6CCE4" align="center"><? echo $rows['email']; ?></td> <td width="114" bordercolorlight="#000000" bordercolordark="#000000" bgcolor="#B6CCE4" align="center"><? echo $rows['tel']; ?></td> <td width="93" bordercolorlight="#000000" bordercolordark="#000000" bgcolor="#B6CCE4" align="center"><? echo $rows['model']; ?></td> <td width="171" bordercolorlight="#000000" bordercolordark="#000000" bgcolor="#B6CCE4" align="center"><? echo $rows['repair']; ?></td> <td width="86" bordercolorlight="#000000" bordercolordark="#000000" bgcolor="#B6CCE4" align="center"><? echo $rows['dropoff']; ?></td> <td width="33" bordercolorlight="#000000" bordercolordark="#000000" bgcolor="#B6CCE4" align="center"> <? echo $rows['price']; ?></td> <td width="58" bordercolorlight="#000000" bordercolordark="#000000" bgcolor="#B6CCE4" align="center"> Receipt</td> <td width="76" bordercolorlight="#000000" bordercolordark="#000000" bgcolor="#B6CCE4" align="center" valign="middle"> <form method="POST" action="--WEBBOT-SELF--">  <select size="1" name="D1" style="border: 1px solid #000000; padding-left: 4px; padding-right: 4px; padding-top: 1px; padding-bottom: 1px; background-color: #8DA3BA"> <option>Yes</option> <option>BER</option> <option selected>Pending</option> </select> </form> </td> </tr> <? // close while loop } // close connection mysql_close(); ?> </body> </html>

Lottery Script... Working But...

JayLewis replied to JayLewis's topic in PHP Coding Help

n00b

Display name on site after login

JayLewis replied to ow-design's topic in PHP Coding Help

post your script up. or add me on msn Jay_Lewis@Jaydiocity.co.uk

Lottery Script... Working But...

JayLewis replied to JayLewis's topic in PHP Coding Help

i want it to work every hour like i said. but it doesnt. it just need the times sorting out, wich i cant do.

Lottery Script... Working But...

JayLewis posted a topic in PHP Coding Help

Hey everyone! I've got this Lottery Script and i want it to work like this: The lottery will be every two hours... So say the lotto starts at 12 oclock, you've got till 1 oclock to buy your tickets but after that, you must wait an hour after the last lottery for the new lottery to start. Confusing Ey? Heres the code: <?php $page = 'Lottery'; $count_aantal = 0; $q1 = mysql_query("SELECT * FROM lotterij WHERE user='$this_user->id' AND name='hour'"); while($admin = mysql_fetch_object($q1)) { $count_aantal++; } $q2 = mysql_query("SELECT * FROM lot WHERE lotterij='hour'"); $win = mysql_fetch_object($q2); $count_mny = 0; $q1 = mysql_query("SELECT * FROM lotterij WHERE name='hour'"); while($admin = mysql_fetch_object($q1)) { $count_mny++; } $price = 10000; /// prijs wat de lotterij kost $mny = $count_mny * $price; /*Cron voor lotterij van elk uur*/ $q1 = mysql_query("SELECT * FROM cron WHERE name='hour'"); $day = mysql_fetch_object($q1); /*einde van cron elk uur*/ mysql_query("INSERT INTO cron (endt) VALUES($day+3600)"); /*begin post van lotterij uur*/ if(isset($_POST['submit'])) { /*checken of de users meer als 50 loten heeft,of meer als 50 wil kopen*/ if($count_aantal >=50) { Messagebox("$page","You already have more then 50 tickets."); return; } if($tickets >=51) { Messagebox("$page","You cannot buy more then 50 tickets."); return; } $geld = $price * $tickets; $geld1 = $this_user->hand - $geld; if($this_user->hand - $geld <= -1) { MessageBox("$page","You dont have enough money."); return; } /*einde check*/ // aantal $aantal= $_POST['tickets']; //$aantal keer herhalen for($i=1;$i<=$aantal;$i++){ mysql_query("INSERT INTO lotterij (id,user,tickets,name) VALUES('','$this_user->id','1','hour')"); } MessageBox("Lotery","You bought some tickets."); mysql_query("UPDATE users SET hand='$geld1' WHERE id='$this_user->id'"); return; } /*einde post*/ AddLog($this_user->id, "$this_user->username visit lottery", $tijd); echo "<table width='300' align='center'>"; echo "<form method='post' name='lotterij'>"; echo "<tr>"; echo "<th class='pic' colspan='6'>Lottery Hour</th>"; echo "</tr>"; echo "<tr>"; echo "<th class='empty' colspan='6'> </th>"; echo "</tr>"; echo "<tr>"; echo "<th width='1%' class='empty'> </th>"; echo "<td width='49%' class='empty'>Buy: <input type'text' name='tickets' maxlength='2' class='trade'> </td>"; echo "<td width='49%' class='empty'>Tickets $count_aantal / 50 </td>"; echo "<th width='1%' class='empty'> </th>"; echo "</tr>"; echo "<tr>"; echo "<th width='1%' class='empty'> </th>"; echo "<td width='49%' class='empty'>Ticket Cost:</td>"; echo "<td width='49%' class='empty'>".Tomoney($price)."</td>"; echo "<th width='1%' class='empty'> </th>"; echo "</tr>"; echo "<tr>"; echo "<th width='1%' class='empty'> </th>"; echo "<td width='49%' class='empty'>Money in Pot:</td>"; echo "<td width='49%' class='empty'>".Tomoney($mny)."</td>"; echo "<th width='1%' class='empty'> </th>"; echo "</tr>"; echo "<tr>"; echo "<th width='1%' class='empty'> </th>"; echo "<td width='49%' class='empty'>Start Time:</td>"; echo "<td width='49%' class='empty'>". date('D M jS, H:i:s', $day) ."</td>"; echo "<th width='1%' class='empty'> </th>"; echo "</tr>"; echo "<tr>"; echo "<th width='1%' class='empty'> </th>"; echo "<td width='49%' class='empty'>Buying:</td>"; echo "<td width='49%' class='empty'>". date('D M jS, H:i:s', $tijd) ."</td>"; echo "<th width='1%' class='empty'> </th>"; echo "</tr>"; echo "<tr>"; echo "<th width='1%' class='empty'> </th>"; echo "<td width='49%' class='empty'>Buying Time Ends:</td>"; echo "<td width='49%' class='empty'>". date('D M jS, H:i:s', $tijd+3600) ." </td>"; echo "<th width='1%' class='empty'> </th>"; echo "</tr>"; echo "<tr>"; echo "<th width='1%' class='empty'> </th>"; echo "<td width='49%' class='empty'>Last Winner:</td>"; echo "<td width='49%' class='empty'>"; if($win->winner =='0') { echo "None"; } else { echo "".to_name($win->winner)."</td>"; } echo "<th width='1%' class='empty'> </th>"; echo "</tr>"; echo "<tr>"; echo "<th class='empty' colspan='6'> </th>"; echo "</tr>"; echo "<tr>"; echo "<th class='pic' colspan='6'> <input type='submit' name='submit' class='knop' value='Buy'> </th>"; echo "</tr>"; echo "</table>"; echo "</form>"; /*einde lotterij van elk uur*/ echo " "; ?>

Display name on site after login

JayLewis replied to ow-design's topic in PHP Coding Help

it depends on how you have set it up. I suggest using sessions instead of cookies.

makecomma error

JayLewis replied to JayLewis's topic in PHP Coding Help

aah, nice one mate

makecomma error

JayLewis replied to JayLewis's topic in PHP Coding Help

ok ... ???

makecomma error

JayLewis replied to JayLewis's topic in PHP Coding Help

any ideas why its not working? thanks JayLewis x

makecomma error

JayLewis posted a topic in PHP Coding Help

i get this error: Fatal error: Call to undefined function: makecomma() in /home/frozenf/public_html/Lottery.php on line 88 when using this on line 88: <?php echo "$".makecomma($lotto_inf->jackpot)."";

[SOLVED] Random Number/Letter

JayLewis replied to JayLewis's topic in PHP Coding Help

Thanks alot man, works a treat! And thanks for the quick relpy JayLewis x

[SOLVED] Random Number/Letter

JayLewis posted a topic in PHP Coding Help

I have a anti-scripting check on my site, it displays 2 random number or letters. I want it to show just numbers. can anyone help? <? // *** CAPTCHA image generation *** // *** http://frikk.tk *** session_start(); // *** Tell the browser what kind of file is come'n at 'em! *** header("Content-Type: image/jpeg"); // *** Send a generated image to the browser *** create_image(); die(); // *** Function List *** function create_image() { // *** Generate a passcode using md5 // (it will be all lowercase hex letters and numbers *** $md5 = md5(rand(0,9999)); $pass = substr($md5, 10, 2); // *** Set the session cookie so we know what the passcode is *** $_SESSION["pass"] = $pass; // *** Create the image resource *** $image = ImageCreatetruecolor(100, 20); // *** We are making two colors, white and black *** $clr_white = ImageColorAllocate($image, 255, 255, 255); $clr_black = ImageColorAllocate($image, 0, 0, 0); // *** Make the background black *** imagefill($image, 0, 0, $clr_black); // *** Set the image height and width *** imagefontheight(15); imagefontwidth(15); // *** Add the passcode in white to the image *** imagestring($image, 5, 30, 3, $pass, $clr_white); // *** Throw in some lines to trick those cheeky bots! *** imageline($image, 5, 1, 50, 20, $clr_white); imageline($image, 60, 1, 96, 20, $clr_white); // *** Output the newly created image in jpeg format *** imagejpeg($image); // *** Clear up some memory... *** imagedestroy($image); } ?>

Testing My Community site

JayLewis replied to liam1412's topic in Beta Test Your Stuff!

cant register

Live Webcam Feed.

JayLewis replied to JayLewis's topic in Miscellaneous

Anyone?

My Game in BETA Stages

JayLewis replied to JayLewis's topic in Beta Test Your Stuff!

Thanks everyone, im looking into it all

Live Webcam Feed.

JayLewis posted a topic in Miscellaneous

Hey all! How would i go about creating a live webcam feed? I have been told it can be done with Windows Media Encoder, but i can only get it working over a local network. I'm not even sure if i'm posting in the correct section. So anybody got any ideas? Regards, Jay Lewis

My Game in BETA Stages

JayLewis replied to JayLewis's topic in Beta Test Your Stuff!

Yer... it may seem that your loosing nothing, you need to refresh the bar to see you've lost it. im gonna turn that into an iFrame and make it update every 15 seconds.

Reload Then Open In an Iframe.

JayLewis replied to JayLewis's topic in PHP Coding Help

My whole logged in page. <? session_start(); include "includes/functions.php"; include "includes/db_connect.php"; logincheck(); $username=$_SESSION['username']; $total_regged=mysql_num_rows(mysql_query("SELECT * FROM users")); $admins=mysql_num_rows(mysql_query("SELECT * FROM users WHERE userlevel='2'")); $mods=mysql_num_rows(mysql_query("SELECT * FROM users WHERE userlevel='1'")); $iti=mysql_fetch_object(mysql_query("SELECT * FROM site_stats WHERE id='1'")); $most=$iti->online; $currank=$fetch->rank; $rankp = $fetch->rankpoints; ?> <? $fetch=mysql_fetch_object(mysql_query("SELECT * FROM users WHERE username='$username'")); ?> <?php $check = mysql_query("SELECT * FROM `inbox` WHERE `read`='0' AND `to`='$username'"); $inbox=mysql_num_rows($check); ?> <? $query1=mysql_query("SELECT * FROM user_info WHERE username='$username'"); $info=mysql_fetch_object($query1); $currank=$fetch->rank; $rankp = $fetch->rankpoints; if ($currank == "Nobody"){ $max = "100"; $old="0"; }elseif ($currank == "Begger"){ $max = "200"; $old="100"; }elseif ($currank == "Rat"){ $max = '400'; $old="200"; }elseif ($currank == "Bag Head"){ $max = '800'; $old="400"; }elseif ($currank == "Scum"){ $max = '1600'; $old="800"; }elseif ($currank == "Tramp"){ $max = '3200'; $old="1600"; }elseif ($currank == "Paper Boy"){ $max = '6400'; $old="3200"; }elseif ($currank == "Thief"){ $max = '12800'; $old="6400"; }elseif ($currank == "Wannabe Thug"){ $max = '25600'; $old="12800"; }elseif ($currank == "Thug"){ $max = '51200'; $old="25600"; }elseif ($currank == "Whygee"){ $max = '102400'; $old="51200"; }elseif ($currank == "Wankster"){ $max = '204800'; $old="102400"; }elseif ($currank == "Gangster"){ $max = '409600'; $old="204800"; }elseif ($currank == "Drug Dealer"){ $max = '819200'; $old="409600"; }elseif ($currank == "Associate"){ $max = '1638400'; $old="819200"; }elseif ($currank == "Made Man"){ $max = '3276800'; $old="1638400"; }elseif ($currank == "Hitman"){ $max = '6553600'; $old="3276800"; }elseif ($currank == "Underboss"){ $max = '13107200'; $old="6553600"; }elseif ($currank == "Godfather"){ $max = '26214400'; $old="131027200"; }elseif ($currank == "God"){ $max = '52428800'; $old="26214400"; }elseif ($currank == "Legend"){ $max = '104857600'; $old="52428800"; }elseif ($currank == "Scouse Saint"){ $max = '209715200'; $old="104857600"; } $percent = round((($rankp-$old)/($max-$old))*100); ?> <SCRIPT LANGUAGE="JavaScript" TYPE="text/javascript">  </SCRIPT> <SCRIPT language=JavaScript id="disable right clicking">  </SCRIPT> <script language="javascript"> function Ismell (){ var del = confirm("Are you sure you want to log out?"); if (del == true){ var loc = "index.php?logout=yes"; parent.top.location.href=loc; } } function Toggle(item) { obj=document.getElementById(item); visible=(obj.style.display!="none") key=document.getElementById("x" + item); if (visible) { obj.style.display="none"; } else { obj.style.display="block"; } } </script> <meta http-equiv="refresh" content="300"> <link rel="stylesheet" href="./styles.css" type="text/css"> <body background="images/bg.jpg"> <form name="" method="post" > <table align=center border="1" width="722" height="714" class="tdcell"> <tr> <td height="100" width="712" class="tdcell" colspan="2" style="background-image: url('images/banner.jpg')" valign="bottom"> </td> </tr> <tr> <td height="17" width="712" class="tdcell" colspan="2" style="background-image: url('images/banner.jpg')" valign="bottom"> Name: <?php echo "$fetch->username"; ?> Rank: <?php echo "$fetch->rank"; ?> Money: <?php echo "£".makecomma($fetch->money).""; ?> Progress: <?php echo "$percent"; ?>% Energy: <?php echo "$fetch->energy%"; ?> Location: <?php echo "$fetch->location"; ?> <a href="logged_in3.php" style="text-decoration: none">[Refresh]</a></td> </tr> <tr> <head> </head><? $fetch=mysql_fetch_object(mysql_query("SELECT * FROM users WHERE username='$username'")); ?><td height="17" width="177" class="tdcell" style="background-image: url('images/menubg.jpg')"> Make Money</td> <td height="483" width="529" class="tdcell" style="background-image: url('images/tdbg.jpg')" rowspan="12"> <iframe width="529" height="550" src="mainframe.php" name="main" align="middle" border="0" frameborder="0"></iframe> </td> <tr> <td height="82" width="177" class="tdcell" style="background-image: url('images/menubg2.jpg')"> <a style="text-decoration: none" target="main" href="jack.php"> Car Theft</a> <a style="text-decoration: none" target="main" href="drugs.php"> Drugs</a> <a style="text-decoration: none" target="main" href="bank.php"> Bank</a> <a style="text-decoration: none" target="main" href="mission.php"> Missions</a> <a style="text-decoration: none" target="main" href="ext.php"> Extortion</a> <a style="text-decoration: none" target="main" href="crime.php"> Petty Crime</a> </td> </tr> <tr> <td height="16" width="177" class="tdcell" style="background-image: url('images/menubg.jpg')"> Your Cpanel</td> </tr> <tr> <td height="69" width="177" class="tdcell" style="background-image: url('images/menubg2.jpg')"> <a target="main" href="user.php" style="text-decoration: none"> Edit Your Profile</a> <a target="main" href="you.php" style="text-decoration: none"> Your Stats</a> <a target="main" href="crew.php" style="text-decoration: none"> Your Crew</a> <a target="main" href="baf.php" style="text-decoration: none"> Buddy List</a> <a target="main" href="garage.php" style="text-decoration: none"> Your Cars</a> <a target="main" href="rest.php" style="text-decoration: none"> Restraunt</a> </td> </tr> <tr> <td height="16" width="177" class="tdcell" style="background-image: url('images/menubg.jpg')"> Message Centre</td> </tr> <tr> <td height="43" width="177" class="tdcell" style="background-image: url('images/menubg2.jpg')"> <a href=inbox.php onclick="javascript:window.opener.location.reload();" target=main> Inbox<?php if ($inbox > 0){ echo " ($inbox)"; } ?> </a> <a style="text-decoration: none" target="main" href="send2.php"> Compose</a> </a><a href="chat.php" target="main"> Chat</a> </tr> <tr> <td height="16" width="177" class="tdcell" style="background-image: url('images/menubg.jpg')"> War</td> </tr> <tr> <td height="56" width="177" class="tdcell" style="background-image: url('images/menubg2.jpg')"> <a target="main" href="kill.php" style="text-decoration: none">Kill</a> <a target="main" href="buy.php" style="text-decoration: none">Buy Weapons</a> <a target="main" href="sell.php" style="text-decoration: none">Sell Weapons</a> <a target="main" href="hitlist.php" style="text-decoration: none">Hit List</a> <a target="main" href="bf.php" style="text-decoration: none">Ammo Shop</a></td> </tr> <tr> <td height="16" width="177" class="tdcell" style="background-image: url('images/menubg.jpg')"> Gambling</td> </tr> <tr> <td height="43" width="177" class="tdcell" style="background-image: url('images/menubg2.jpg')"> <a target="main" href="rr.php" style="text-decoration: none"> Russian Roulette</a> <a target="main" href="race.php" style="text-decoration: none"> Horses</a> <a target="main" href="slots.php" style="text-decoration: none"> Slots</a> </td> </tr> <tr> <td height="16" width="177" class="tdcell" style="background-image: url('images/menubg.jpg')"> MIsc</td> </tr> <tr> <td height="69" width="177" class="tdcell" style="background-image: url('images/menubg2.jpg')"> <a target="main" href="jail.php" style="text-decoration: none"> Jail</a> <a target="main" href="fly.php" style="text-decoration: none"> Travel</a> <a style="text-decoration: none" target="main" href="countrys.php"> Owners</a> <a target="main" href="search.php" style="text-decoration: none"> Search A User</a> <a target="main" href="stats.php" style="text-decoration: none"> Game Stats</a> <a href="javascript:Ismell()" style="text-decoration: none"> Logout</td> </tr> <tr> <td height="17" width="712" class="tdcell" style="background-image: url('images/menubg.jpg')" colspan="2"> Users Online</td> </tr> <tr> <td height="4" width="712" class="tdcell" style="background-image: url('images/tdbg.jpg')" colspan="2"> <? $timenow=time(); $select = mysql_query("SELECT * FROM users WHERE online > '$timenow' ORDER BY 'users',`rankpoints` DESC "); $num = mysql_num_rows($select); while ($i = mysql_fetch_object($select)){ if ($i->crew == "0"){ $crew="None"; }else{ $crew=$i->crew; } if ($i->last_oc > time()){ $oc="No"; }else{ $oc="Yes"; } if($i->userlevel=="2"){ $echo = "$i->username"; }elseif ($i->userlevel=="1"){ $echo = "$i->username"; }elseif ($i->helper=="1"){ $echo = "$i->username"; }else{ $echo = "$i->username"; } $don=mysql_num_rows(mysql_query("SELECT * FROM donaters WHERE username='$i->username'")); if ($don != "0"){ $echo .= "*"; } $rhm=mysql_num_rows(mysql_query("SELECT * FROM crews WHERE rhm='$i->username'")); if ($rhm != "0"){ $echo = "$echo"; } $leader=mysql_num_rows(mysql_query("SELECT * FROM crews WHERE owner='$i->username'")); if ($leader != "0"){ $echo = "$echo"; } $casino=mysql_num_rows(mysql_query("SELECT * FROM casinos WHERE owner='$i->username'")); if ($casino != "0"){ $echo = "$echo"; } $friend=mysql_num_rows(mysql_query("SELECT * FROM friends WHERE person='$i->username' AND type='Friend' AND username='$username'")); if ($friend != "0"){ $echo = "$echo"; } echo "<a href='profile.php?viewuser=$i->username' target=main> $echo </a>,"; } ?></td> </tr> </table> </body> </html>

[SOLVED] thanks, then redirect

JayLewis replied to Ninjakreborn's topic in PHP Coding Help

Refreshing a page.

JayLewis replied to JayLewis's topic in Javascript Help

do you know the JS?

Sign In

JayLewis

Posts

Joined

Last visited

Content Type

Profiles

Forums

Everything posted by JayLewis

DESC Records

DESC Records

DESC Records

Reading an ID onto another page

Reading an ID onto another page

Reading an ID onto another page

Lottery Script... Working But...

Display name on site after login

Lottery Script... Working But...

Lottery Script... Working But...

Display name on site after login

makecomma error

makecomma error

makecomma error

makecomma error

[SOLVED] Random Number/Letter

[SOLVED] Random Number/Letter

Testing My Community site

Live Webcam Feed.

My Game in BETA Stages

Live Webcam Feed.

My Game in BETA Stages

Reload Then Open In an Iframe.

[SOLVED] thanks, then redirect

Refreshing a page.

Browse

Activity

Important Information