jack bro

I mean CURL, not perl.

An external website, I'm fetching the data using perl Jack.

Hello, I have the following HTML code: <tr> <td> </td></tr><tr><td><table class=blackborder width=315><tr><td><b>W. 48</b></td><td><B>Date</B></td><td><B>Work</B></td><td><B>Suggested break</B></td><td><B>Total</B></td><tr><td></td></tr><tr><td>-</td></tr><tr><td>-</td></tr><tr><td>-</td></tr><tr><td>-</td></tr><tr><td>-</tr><tr><td>Saturday</tr><tr><td>Sunday</td></tr><tr><td>Total:</td><td></td><td></td><td></td><td>0</td></tr></table></td><td><table class=blackborder width=315><tr><td><b>W. 49</b></td><td><B>Date</B></td><td><B>Work</B></td><td><B>Suggested break</B></td><td><B>Total</B></td><tr><td></tr><tr><td>Monday</tr><tr><td>Tuesday<td>4/12</td><td>17:00-01:00</td><td>19:00-19:45</td><td>7:15</td></tr><tr><td>Wednesday<td>5/12</td><td>17:00-01:00</td><td>21:00-21:45</td><td>7:15</td></tr><tr><td>Thursday</tr><tr><td>Friday</tr><tr><td>Saturday<td>8/12</td><td>23:00-07:00</td><td>01:00-01:45</td><td>7:15</td></tr><tr><td>Sunday</td></tr><tr><td>Total:</td><td></td><td></td><td></td><td>21:45</td></tr></table></td></tr><tr><td><table class=blackborder width=315><tr><td><b>W. 50</b></td><td><B>Date</B></td><td><B>Work</B></td><td><B>Suggested break</B></td><td><B>Total</B></td><tr><td></tr><tr><td>Monday</tr><tr><td>Tuesday<td>11/12</td><td>17:00-01:00</td><td>20:30-21:15</td><td>7:15</td></tr><tr><td>Wednesday<td>12/12</td><td>17:00-01:00</td><td>19:00-19:45</td><td>7:15</td></tr><tr><td>Thursday</tr><tr><td>Friday</tr><tr><td>Saturday<td>15/12</td><td>16:00-23:00</td><td>20:00-20:45</td><td>6:15</td></tr><tr><td>Sunday<td>16/12</td><td>17:00-01:00</td><td>21:00-21:45</td><td>7:15</td></td></tr><tr><td>Total:</td><td></td><td></td><td></td><td>28</td></tr></table></td><td><table class=blackborder width=315><tr><td><b>W. 51</b></td><td><B>Date</B></td><td><B>Work</B></td><td><B>Suggested break</B></td><td><B>Total</B></td><tr><td></tr><tr><td>Monday<td>17/12</td><td>17:00-01:00</td><td>19:00-19:45</td><td>7:15</td></tr><tr><td>Tuesday</tr><tr><td>Wednesday<td>19/12</td><td>17:00-00:00</td><td>21:00-21:45</td><td>6:15</td></tr><tr><td>Thursday<td>20/12</td><td>23:00-07:00</td><td>03:00-03:45</td><td>7:15</td></tr><tr><td>Friday<td>21/12</td><td>23:00-07:00</td><td>02:30-03:15</td><td>7:15</td></tr><tr><td>Saturday</tr><tr><td>Sunday</td></tr><tr><td>Total:</td><td></td><td></td><td></td><td>28</td></tr></table></td></tr><tr><td><table class=blackborder width=315><tr><td><b>W. 52</b></td><td><B>Date</B></td><td><B>Work</B></td><td><B>Suggested break</B></td><td><B>Total</B></td><tr><td></tr><tr><td>Monday</tr><tr><td>Tuesday</tr><tr><td>Wednesday</tr><tr><td>Thursday</tr><tr><td>Friday</tr><tr><td>Saturday</tr><tr><td>Sunday</td></tr><tr><td>Total:</td><td></td><td></td><td></td><td>0</td></tr></table></td><td><table class=blackborder width=315><tr><td><b>W. 1</b></td><td><B>Date</B></td><td><B>Work</B></td><td><B>Suggested break</B></td><td><B>Total</B></td><tr><td></tr><tr><td>Monday</td></tr><tr><td>-</td></tr><tr><td>-</td></tr><tr><td>-</td></tr><tr><td>-</td></tr><tr><td>-</td></tr><tr><td>-</td></tr><tr><td>Total:</td><td></td><td></td><td></td><td>0</td></tr></table> I need to extract it so that its in an array like this 1: Monday 2: Tuesday 4/12 17:00-01:00 3: Wednesday 5/12 17:00-01:00 4: Thursday 5: Friday 6: Saturday 8/12 23:00-07:00 7: Sunday Tried removing HTML tags and using code like: $str = 'W. 50DateWorkSuggested breakTotalMondayTuesday11/1217:00-01:0020:30-21:157:15Wednesday12/1217:00-01:0019:00-19:457:15ThursdayFridaySaturday15/1216:00-23:0020:00-20:456:15Sunday16/1217:00-01:0021:00-21:457:15Total:28W. 51DateWorkSuggested breakTotalMonday17/1217:00-01:0019:00-19:457:15TuesdayWednesday19/1217:00-00:0021:00-21:456:15Thursday20/1223:00-07:0003:00-03:457:15Friday21/1223:00-07:0002:30-03:157:15SaturdaySundayTotal:28W. 52DateWorkSuggested breakTotalMondayTuesdayWednesdayThursdayFridaySaturdaySundayTotal:0W. 1DateWorkSuggested breakTotalMonday------Total:0 Total number of hours: 77:45 Schedule for Month: December'; $ptr = "/(?P<day>:Monday|Tuesday|Wednesday|Thusday|Fiday|Saturday|Sunday?)(?P<time>([0-9:\/\- ]?)+)/"; preg_match_all($ptr, $str, $data); echo '<pre>'; print_r($data); echo '</pre>'; Which gives me close results like: Array ( [0] => Array ( [0] => Tuesday11/1217:00-01:0020:30-21:157:15 [1] => Wednesday12/1217:00-01:0019:00-19:457:15 [2] => Saturday15/1216:00-23:0020:00-20:456:15 [3] => Sunday16/1217:00-01:0021:00-21:457:15 [4] => Tuesday [5] => Wednesday19/1217:00-00:0021:00-21:456:15 [6] => Saturday [7] => Sunday [8] => Tuesday [9] => Wednesday [10] => Saturday [11] => Sunday ) [day] => Array ( [0] => Tuesday [1] => Wednesday [2] => Saturday [3] => Sunday [4] => Tuesday [5] => Wednesday [6] => Saturday [7] => Sunday [8] => Tuesday [9] => Wednesday [10] => Saturday [11] => Sunday ) [1] => Array ( [0] => Tuesday [1] => Wednesday [2] => Saturday [3] => Sunday [4] => Tuesday [5] => Wednesday [6] => Saturday [7] => Sunday [8] => Tuesday [9] => Wednesday [10] => Saturday [11] => Sunday ) [time] => Array ( [0] => 11/1217:00-01:0020:30-21:157:15 [1] => 12/1217:00-01:0019:00-19:457:15 [2] => 15/1216:00-23:0020:00-20:456:15 [3] => 16/1217:00-01:0021:00-21:457:15 [4] => [5] => 19/1217:00-00:0021:00-21:456:15 [6] => [7] => [8] => [9] => [10] => [11] => ) [2] => Array Any help please? Thanks, Jack.

Solved, has to re arrange code. Jack.

I have this code for a place where admins can create promotion codes. $username=$_SESSION['username']; if ($_POST['Submit']){ // Define post fields into simple variables $code=strip_tags($_POST['PromoCode']); $info=strip_tags($_POST['Info']); if((!$code) || (!$info)){ $message="Fill in all fields"; } elseif (strlen($code) > 0 || strlen($info) >0){ $sql_promo_check = mysql_query("SELECT * FROM promocodes WHERE code='$code'"); $code_check = mysql_num_rows($sql_promo_check); if($code_check > 0){ $message= "Promo code $code already exsists in database."; } elseif ($code_check < 1){ mysql_query("INSERT INTO `promocodes` (`id`, `code`, 'info', 'createdby') VALUES ('', '$code', '$info', '$username')") or die (mysql_error()); $message= "Promotion code $code has been inserted into the database and is now active."; } } } ?> When I submit the form if the code exists in database I get the right message but when I try to insert one that don't exist I get this message. 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 ''info', 'createdby') VALUES ('', 'test2', 'test2', 'Jack')' at line 1 Any ideas? Thanks, Jack.

I'm trying to insert captcha into my register page and need to know why this is working, link to register page is http://www.midcity-mafia.com/register/ Nothing happens when register form is submitted, here is relevant code: if ($_POST['Submit']){ // Define post fields into simple variables $reg_username = $_POST['reg_username']; $pwd2 = $_POST['pwd2']; $email = $_POST['email']; $email1 = $_POST['email1']; $location=strip_tags($_POST['location']); $ref = $_POST['ref']; $reg_username=trim($reg_username); $pwd2=trim($pwd2); $today = gmdate('Y-m-d h:i:s'); $reg_username = stripslashes($reg_username); $email = stripslashes($email); $quote = stripslashes($quote); $reg_username = strip_tags($reg_username); $email = strip_tags($email); $resp = recaptcha_check_answer ($privatekey, $_SERVER["REMOTE_ADDR"], $_POST["recaptcha_challenge_field"], $_POST["recaptcha_response_field"]); if (strlen($reg_username) > 3 || strlen($reg_username) < 40){ $sql_email_check = mysql_query("SELECT email FROM users WHERE email='$email' AND status='Alive'"); $sql_username_check = mysql_query("SELECT username FROM users WHERE username='$reg_username'"); $email_check = mysql_num_rows($sql_email_check); $username_check = mysql_num_rows($sql_username_check); if($email_check > 0){ $message= "Your email address has already been used by another player!"; unset($email); } if($username_check > 0){ $message="Your desired username is already in use, please choose another one."; unset($reg_username); } } elseif ($resp->is_valid) { //if captcha is vaild $userid = mysql_insert_id(); $ip = $_SERVER['REMOTE_ADDR']; $random_password22=rand(11111,99999999); mysql_query("INSERT INTO `user_info` ( `id` , `username`) VALUES ('', '$reg_username')") or die (mysql_error()); mysql_query("INSERT INTO users (`id` , `username` , `password` , `regged`, `email`, `location`, `r_ip`) VALUES ('', '$reg_username', '$pwd2', '$today', '$email', '$location', '$ip')") or die (mysql_error()); $sql = "UPDATE users SET totalref=totalref+1 WHERE username='$ref'"; mysql_query($sql) or die("Error executing: $sql" . mysql_error()); $message= '<font color="#000000"> <br />Account created, </font> <a href="index.php"> <font color="#FFFF00">You may now log in.</font></a> '; } else { $message = '$resp->error'; // Captcha error } } ?> Any help is apprechiated thanks. Jack.

if ($currentime > $endtime){ $winner = rand(1,$winner); $winz=mysql_fetch_object(mysql_query("SELECT * FROM lotto WHERE id='$winner'")); $winner_stuff=mysql_fetch_object(mysql_query("SELECT * FROM users WHERE username='$winz->owner'")); mysql_query("UPDATE users SET money = money+'$lotto_info->jackpot' WHERE username='$winz->owner'"); $time = time() +(86400 * 3); $new_num =$lotto_inf->lotto_num + 1; mysql_query("UPDATE lotto_info SET lotto_num = '$new_num', time_to='$time', winning_ticket='$winner', winner='$fetch_win->username', jackpot='0'"); mysql_query("TRUNCATE TABLE lotto"); } $currenttime=time(); $endtime=$lotto_inf->time_to; Current database: `lotto_info` (`id`, `price`, `time_to`, `jackpot`, `lotto_num`, `winning_ticket`, `winner`) VALUES (1, 5000, 1239234730, 10055000, 1, 1, ''); Some reason it isn't starting a new lottery. Thanks, Jack.

Wow, I'm such a goon, thanks Maq and everyone else, sorry for wasting your time. Jack.

Was VARCHAR(100) now is INT(11) and still not working. http://www.midcity-mafia.com/leaderboard.php Jack.

I have a leaderboard which i want to sort highest to lowest by rankpoints top 10 players I have this code. $c=mysql_query("SELECT * FROM users ORDER BY rankpoints DESC LIMIT 10"); while($d=mysql_fetch_object($c)){ echo "<tr><td><a href='profile.php?viewuser=$d->username'>$d->username</a></td><td>$d->totalref</td><td>$d->rank</td></tr>"; Don't sort into order for some reason. Jack.

Changed to: }elseif (strtolower($match_fetch->column_name) != strtolower($username)){ and still same error. Jack.

$match_fetch=mysql_fetch_object($match_info);

In my game you can post a boxing challenging and if another player accepts you fight. When you go to accept a challenge I get this error. Catchable fatal error: Object of class stdClass could not be converted to string in /home/thebestj/public_html/arm.php on line 114 Line 114 of arm.php is }elseif (strtolower($match_fetch) != strtolower($username)){ Any help would be apprechiated. Jack.

My stupid mistrake of adding reff instead of ref can't believe I didn't realise before. Sorry for wasting your time. Thanks, Jack.

I have this on register page to keep track how many people each user has refereed. mysql_query("UPDATE users SET totalref=totalref+1 WHERE username='$reff'"); Some reason the value dont increase. Jack.

Yes.

I'm sure its a database problem, there is a page where people can "Grab" the blackjack when they click grab this happens. First it checks to see if another user owns this item: <tr> <td class="TableArea">BlackJack</td> <td class="TableArea"><?php if (!$bj->bjowner){ echo "No owner-<a href='?grab=blackjack&location=$locations[$i]'><font color=red>Grab It</font></a>"; }else{ echo "<a href='profile.php?viewuser=$bj->bjowner'>$bj->bjowner</a>"; } ?></td> <td class="TableArea"><? echo "$".makecomma($bj->bjmaxbet).""; ?></td> </tr> If the item is not owned by another use the grab link is displayed. When the grab button is pressed it should trigger this: elseif ($grab == "blackjack"){ $check = mysql_query("SELECT * FROM bj WHERE bjowner= '0' AND location='$fetch->location'"); $num_rows = mysql_num_rows($check); if ($num_rows != "0"){ if ($fetch->location == $location){ mysql_query("UPDATE bj SET bjowner='$username', profit='0' WHERE location='$fetch->location'"); echo "You got the BlackJack!"; }}} Where it updates the database to make it that whatever user grabbed this now owns it. The table in the database related to this item is "bj" and it layed out like this: CREATE TABLE `bj` ( `id` int(11) NOT NULL auto_increment, `bjowner` varchar(100) NOT NULL default '', `bjmaxbet` int(100) NOT NULL default '0', `bjearnings` int(100) NOT NULL default '0', `bjminbet` int(100) NOT NULL default '0', `location` enum('England','Japan','Colombia','Usa','South Africa','Mexico') NOT NULL default 'England', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ; Hopefully this makes things clearer. Jack.

Still doesn't work, I have many other of these things which work in the same php file, so I think it's the database. Jack.

I replaced the code and still nothing. What code can I use to echo the variables? And the full code is: elseif ($grab == "Blackjack"){ $check = mysql_query("SELECT * FROM bj WHERE bjowner= '0' AND location='$fetch->location'"); $num_rows = mysql_num_rows($check); if ($num_rows != "0"){ if ($fetch->location == $location){ mysql_query("UPDATE bj SET bjowner='$username',bjmaxbet='0',bjearnings='0',bjminbet='0' WHERE location='$fetch->location'"); echo "You got the Blackjack!"; }}} Thanks, Jack.

CREATE TABLE `bj` ( `id` int(11) NOT NULL auto_increment, `bjowner` varchar(100) NOT NULL default '', `bjmaxbet` int(100) NOT NULL default '0', `bjearnings` int(100) NOT NULL default '0', `bjminbet` int(100) NOT NULL default '0', `location` enum('England','Japan','Colombia','Usa','South Africa','Mexico') NOT NULL default 'England', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ; Thats the SQL

First of all I would like to say hello as this is my first post! I have a maffia game and you can own the Blackjack game this is the script for claiming the game. elseif ($grab == "Blackjack"){ $check = mysql_query("SELECT * FROM bj WHERE bjowner= '0' AND location='$fetch->location'"); $num_rows = mysql_num_rows($check); if ($num_rows != "0"){ if ($fetch->location == $location){ mysql_query("UPDATE bj SET bjowner='$username',bjmaxbet='0',bjearni... WHERE location='$fetch->location'"); echo "You got the Blackjack!"; It won't let me have the Blackjack game for some reason, the MYSQL table is: -- Table structure for table `bj` -- CREATE TABLE `bj` ( `id` int(11) NOT NULL auto_increment, `bjowner` varchar(100) NOT NULL default '', `bjmaxbet` int(100) NOT NULL default '0', `bjearnings` int(100) NOT NULL default '0', `bjminbet` int(100) NOT NULL default '0', `location` enum('England','Japan','Colombia','Usa',... Africa','Mexico') NOT NULL default 'England', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ; -- -- Dumping data for table `bj` -- Any help is apprechiated., when I click buy blackjack nothing happens. Jack.