PHP - Create Ranking

Hey,

I've been working on a script to match playing card hands in a poker game against the river to return what the hand the user has and who won against other players.

The problem is how do i approach an algorithm to do this in the first place.

Cards are stored and structured by 2 characters seperated by a full stop.

Example - 2 of diamonds and 3 of clubs is:
D.2,C.3

now imagine a line of 5 cards (the river) and im trying to work out what they have and return the answer such as:

2 pairs or royal flush etc

I so far decided my easiest way is to explode on the comma to get each card - then explode a second time on the full stop to get the suit and value into different variables.

How ever - after that point im lost how i can do this up against the river to check what hand the user has.

Any one got any tips on the best approach ?

Hi

I've set-up a multidimensional PHP array from a SQL query which pulls back parcels despatched per item on a daily basis.

e.g.

Item|Day1|Day2 |Day3|Day4|Day5
1   |100 | 120 | 90 |150 |60
2   |150 | 200 | 80 |90  |100
3   | 1  |  2  | 3  | 4  | 5

I want to be able to assign a ranked value to each day based upon the amount of items sent out each day and put that either into the existing array, or create a new array to which it can reference

Hello everyone... I made point system that ranks users in my app.  There are two parts to the system, a primary score and a dynamic score.  The primary score is based on how you well you perform and the dynamic score is based on how well your friends perform.  Both of these get added together to equal your total score.  The problem is that I have a lot of looping occurring which results in about 400 queries being run when I access the page that executes this class.  Can this be optimized?  What's the best way to do this?  I don't want to store the data as I want this presented in real-time.

Code: [Select]
<?php

class edge
{
public function get_all_users_edge()
{
$sql = "SELECT id FROM users WHERE status = 3";

$result = mysql_query($sql) or die(mysql_error());

$ids = array();
while (($row = mysql_fetch_assoc($result)) !== false)
{
$ids[] = $row;
}

$all_edges = array();

foreach ($ids as $k => $id)
{
$edge = $this->get_users_edge($id['id']);
$all_edges[$k] = $edge;

}

return $all_edges;
}

public function get_users_edge($uid)
{
$users_primary_edge = $this->get_users_primary_edge($uid);
$users_dynamic_edge = $this->get_users_dynamic_edge($uid);

return $users_primary_edge + $users_dynamic_edge;
}

public function get_users_primary_edge($uid)
{
if (active_id($uid) === false)
{
return false;
}

$uid = (int)$uid;

$sql = "SELECT
CHAR_LENGTH(`users`.`credentials`) AS `cred_chars`,
CHAR_LENGTH(`users`.`specialties`) AS `spec_chars`,
`companies`.`companyvideo` AS `video`,
`investor_info`.`accredited` AS `accredited`,
           ( SELECT COUNT(`user_id`) FROM `blog_posts` WHERE `user_id` = '${uid}' ) AS `post_count`,
           ( SELECT COUNT(`uid`) FROM `votes` WHERE `uid` = '${uid}' ) AS `vote_sent_count`,
`votes_received`.`inv_vote_received_count`,
`votes_received`.`pub_vote_received_count`,
           ( SELECT COUNT(`userid`) FROM `employees` WHERE `userid` = '${uid}' ) AS `joined_count`,
`votes2`.`ent_count`,
`votes2`.`inv_count`,
(
SELECT
COUNT(`company_id`)
FROM `company_fans`
LEFT JOIN `companies` ON `company_fans`.`company_id` = `companies`.`companyid`
LEFT JOIN `employees` ON `employees`.`companyid` = `companies`.`companyid`
WHERE `userid` = '${uid}'
) AS `company_fans_count`,
        ( 
         SELECT 
         COUNT(`user_id`) 
         FROM `recommendations` 
         WHERE `user_id` = '${uid}' 
        ) AS `recommendation_count`,
        ( 
         SELECT 
         COUNT(`partner_id`) 
         FROM `partners` 
         WHERE (`user_id` = '${uid}' OR `friend_id` = '${uid}') 
         AND `approved` = '1' 
        ) AS `associate_count`
FROM `users`
        LEFT JOIN `investor_info` ON `investor_info`.`uid` = `users`.`id`
LEFT JOIN `employees` ON `employees`.`userid` = `users`.`id`
LEFT JOIN `companies` ON `employees`.`companyid` = `companies`.`companyid`
LEFT JOIN (
SELECT
`employees`.`userid`,
               SUM( IF( `votes`.`vote_type` = 1, 1, 0 ) ) AS `inv_vote_received_count`,
               SUM( IF( `votes`.`vote_type` = 0, 1, 0 ) ) AS `pub_vote_received_count`
FROM `votes`
INNER JOIN `employees` ON `employees`.`companyid` = `votes`.`company_id`
WHERE `employees`.`userid` = '${uid}'
             GROUP BY `employees`.`userid`
         ) AS `votes_received` ON `votes_received`.`userid` = `users`.`id`
LEFT JOIN (
SELECT
`beta_keys`.`ref_id`,
               SUM( IF( `users`.`accounttype` = 1, 1, 0 ) ) AS `ent_count`,
               SUM( IF( `users`.`accounttype` = 0, 1, 0 ) ) AS `inv_count`
FROM `beta_keys`
INNER JOIN `users` ON `users`.`id` = `beta_keys`.`userid`
WHERE `beta_keys`.`ref_id` = '${uid}' AND `users`.`status` = 3
             GROUP BY `users`.`id`
         ) AS `votes2` ON `votes2`.`ref_id` = `users`.`id`
WHERE `users`.`id` = '${uid}'";

$result = mysql_query($sql) or die(mysql_error());
$row = mysql_fetch_assoc($result);

$score = 0;

if((!empty($row['cred_chars'])) && (!empty($row['spec_chars'])))
{
$score += 200;
}

if(!empty($row['video']))
{
$score += 50;
}

if($row['accredited'] == 1)
{
$score += 100;
}

$score += (50 * $row['post_count']);
$score += (5 * $row['vote_sent_count']);
$score += (3 * $row['inv_vote_received_count']);
$score += (1 * $row['pub_vote_received_count']);
$score += (200 * $row['joined_count']);
$score += (40 * $row['ent_count']);
$score += (200 * $row['inv_count']);
$score += (10 * $row['company_fans_count']);
$score += (30 * $row['recommendation_count']);
$score += (20 * $row['associate_count']);

return $score;
}

public function get_users_dynamic_edge($uid)
{
$uid = (int)$uid;

$sql = "(
SELECT 
`users`.`id`
FROM partners
INNER JOIN `users`
ON `partners`.`user_id` = `users`.`id`
WHERE partners.friend_id = '${uid}'
AND `approved` = 1
)
UNION ALL
(
SELECT 
`users`.`id`
FROM `partners`
INNER JOIN `users`
ON `partners`.`friend_id` = `users`.`id`
WHERE `partners`.`user_id` = '${uid}'
AND `approved` = 1
)";

$result = mysql_query($sql) or die(mysql_error());

$i  = 0;
$score  = 0;

while (($row = mysql_fetch_assoc($result)) !== false)
{
$dynamic_scores[$i] = array(
'uid'  => $row['id'],
'score' => $this->get_users_primary_edge($row['id']),
);

$i++;
}

if(!empty($dynamic_scores))
{
foreach($dynamic_scores as $k => $dynamic_score)
{
$score += $dynamic_score['score'];
}
}

return ($score * 0.1);
}
}

?>

Hello everyone...

My following code is supposed to order rank by from Greatest covertaction but for some reason it is ranking the greatest last eg.
900,000 Rank 1
900,001 Rank 2
900,002 Rank 3

Here is the code:

Code: [Select]
<?php
$q = "SELECT * FROM `accountinfo_db` ORDER BY `covertaction`, `anticovertaction` ASC";
$res = mysql_query($q) or die(mysql_error());
$i = 1;
while($player=mysql_fetch_array($res)){
$id = securevar($player['id']);
$time = time();
$user = securevar($player['username']);
$q = "UPDATE `accountinfo_db` SET `covertrank` = '$i', `lastTurnTime` = '$time' WHERE `id` = '$id'";
if(mysql_query($q)){
echo "Covert & Anti Covert Rank set to $user as ".number_format($i)."!<br />";
} else {
// query failed with an error
// put your error reporting/logging code here...
}
$i++;
}
?>

Any help will be appreciated!
Brian

hi i have a table like this


rank        xp
1              0
2             50
3             100
4             200

say my username has 75xp how would a select which rank i am

not sure how i can do this? :S

cheers matt

This topic has been moved to Miscellaneous.

http://www.phpfreaks.com/forums/index.php?topic=333654.0

Hello everyone, I am working on a form that is similar to a shopping cart system and I am thinking of creating a button that submits the checked value and saves them to a $_SESSION variable. And also a link that links to a cart.html that takes the values of a $_SESSION variable. I am have trouble figuring what tag/attribute should I use in order to achieve that.   Right now my code attached below submits the checked values to cart.html directly. However I want my submit button to save the checked box to a $_SESSION variable and STAY on the same page. And then I will implement a <a> to link to the cart.php.   I researched a little bit about this subject and I know it's somewhat related to ajax/jquery. I just wanted to know more about it from you guys. I appreciate your attention for reading the post and Thanks!   Below is the form that I currently have:

<form name= "finalForm" method="POST" action="cart.php">
<input type="Submit" name="finalSelected"/>

<?php foreach($FinalName as $key => $item) {?>
<tr>
<td><input type="checkbox" name="fSelected[]" value="<?php echo htmlspecialchars($FinalID[$key])?>" />
<?php echo "$FinalID[$key] & $item";?>
</td>
</tr>
<?php } ;?>

Below is the code for cart.php

<?php
require ('connect_db.php');
if(isset($_POST['finalSelected']))
{
	if(!empty($_POST['fSelected']))
	{
		$chosen = $_POST['fSelected'];
		foreach ($chosen as $item)
			echo "aID selected: $item </br>";
		$delimit = implode(", ", $chosen);
		print_r($delimit);
	}

}
if(isset($delimit))
{
$cartSQL = "SELECT * from article where aID in ($delimit)";
$cartQuery = mysqli_query($dbc, $cartSQL) or die (mysqli_error($dbc));
while($row = mysqli_fetch_array($cartQuery, MYSQLI_BOTH))
{
	$aTitle[] = $row[ 'name' ];
}
}
?>

<table>
	
		<?php if(isset($delimit)) { 
		$c=0; foreach($aTitle as $item) {?>
		<tr>
		<td>
			<?php echo $aTitle[$c]; $c++;?>
		</td>
		</tr>
		<?php }}?>
</table>

Hii i want to create an api of the short url site ( http://torrentz.0fees.net ). In the api page it is says that Code: [Select]
API  Our API allows you to provide short url functionality to any of your existing websites.

Url Only
To generate a url via the API, send a POST or GET request to the site in the following format:

- http://torrentz.0fees.net/index.php?api=1&return_url_text=1&longUrl={URL}

This site will then generate the short url and return it as plain text. i.e:

- http://torrentz.0fees.net/a1
I have created an form but not able to use it. The form script is shown below.

Code: [Select]
<form name="input" action="html_form_action.asp" method="get">
 Username: <input type="text" name="user" />
 <input type="submit" value="Submit" />
 </form>
Whenever i'm putting the ( http://torrentz.0fees.net/index.php?api=1&return_url_text=1&longUrl={URL} )
it shows an error.

I know that the input url must be used in the ( {URL} ) section but how can i do that using php

Can anyone help me with code...

HOw to create this header?     I give +. thx http://i.snag.gy/15Ep4.jpg

hi, I'm currently trying to resize and create pictures and .jpg/jpeg & .gif works perfectly but .png just creates an empty 0bit image, why?!

Code: [Select]
$ = imagecreatefrompng();
imagecopyresampled();
imagepng();

I'm doing something like that and it - as said - works great with .jpg and gif but at png it just fucks up. :/

Please i have questions on how to create a file system server.
were you clients could upload files
and download their files in the future.

Is this professional to store the files in database

I have a table in my database for users. On the registration page I want to create another table with the id of the user as the table name.

$sql = "CREATE TABLE IF NOT EXISTS `id_prod` (
)

how do i modify this line so that it takes the id from the user table and creates a new table with id as name followed by prod.

I am trying create my xml file in this format:
Code: [Select]
<?xml version="1.0" encoding="UTF-8" ?>
- <playlist id="Adobe">
  <vid desc="5 minute cardio warm-up" contenu="side jumps, arm curls ..." src="videos/set2_first_5min.flv" thumb="thumbs/set2_first.png" />
  <vid desc="5 minutes of no rest workout moves" contenu="Football drills, front kicks ..." src="videos/set2_second_5min.flv" thumb="thumbs/set2_second.png" />
  <vid desc="last 5 minutes of Set 1" contenu="MC Hammer ..." src="videos/set2_third_5min.flv" thumb="thumbs/set2_third.png" />
  <vid desc="5 minute cardio warm-up" contenu="jumping jacks, presses and squats" src="videos/Set1_first.flv" thumb="thumbs/set1_first.jpg" />
  <vid desc="5 minutes of no rest workout moves" contenu="shin kicks ..." src="videos/Set1_mid.flv" thumb="thumbs/set1_mid.jpg" />
  <vid desc="last 5 minutes of Set 1" contenu="MC Hammer ..." src="videos/Set1_last.flv" thumb="thumbs/set1_last.jpg" />
  </playlist>[/color]

I'm not having trouble getting and looping through the data from mySQL.
I'm getting confused with what's a child element, attribute node, and attribute value.

Can someone who has worked with the DOMDocument steer me in the right direction?
sample code is the best request 

Thanks!

Hello all
That forum is my last desperate attemp to do what i want to do.
Ok here is the story

I want to create  a simple rss feed in conjuction with php and mysql.
I dont want admin areas ect , i just want when i insert a new listing to my database to be able shown up to my (future) rss subscribers.
To be more technically specific i want to show to my surfers updates about 2 tables in my database not all the tables.
The example i found so far were about only 1 table, plus i was encounting errors to my script.

I would like some ideas, directions if someone is kind enough to help a sad developer 

Thanks in advance!

When creating a PHP document we use echo ''; to wrap HTML into PHP, so why does it seem to me that people always say to create a form using PHP you must break it up by using HTML to show the form itself?

Is there a way to create the form, and do all that is required using PHP and wrapping PHP around HTML to make it work?

I can't imagine its impossible.