PHP - Php Help - Simple Ranking System

Hey guys first of all I got 3 files -

index.php
require_once('/libs/template.class.php');

$template = new Template;

$template->assign("title","test");

template.php
<?php echo $title; ?>

template.class.php
function assign($var, $val)
    {
        $var = $val;
    }

I'm trying to assign a variable in index.php, then recall it in the template.php, how would I go about this?

Thank you!

Hello,

I have a simple dice system script I am using in a chat program for a website and I was wondering if someone could simply tell me how to limit the number of dice being rolled. Here are the two chunks of script that make it work:

if($irc_cmd == '/d') {
    if($irc_cmd == $txt) {
        // this can only happen with a no dice - '/d' - a help request
        // return an explanation of the correct format
        $text = "dice command is /d [[n]D]s[Xm|+a|-d|/q]*";
        $this->sendToUser(null, new Message($type, $this->userid, null, $text, $this->color));
        return 'ok';
    }
    // create standard failure message
    $invalid_msg = new Message($type, $this->userid, null, 'ERROR: invalid dice command - '.$txt.' - enter /d for help', $this->color);
    // remove the original command from the dice string
    $dicestring = str_replace($irc_cmd,'', $txt);
    // use lowercase versions of D and X to make parsing simpler
    $dicestring = strtolower($dicestring);
    // remove any user entered spaces
    $dicestring = str_replace(' ', '', $dicestring);
    // note that all modifiers will follow the dice spec 'nDs'
    // number of dice is optional e.g. 1d4 d4 and 4 all represent a single 4-sided die
    // if the first token is blank, then the user intended for one die e.g. /d d20 means /d 1d20
    // if the is no 'd' then the user intended one die e.g. /d 20 means /d 1d20
    $parts = explode('d', $dicestring);
    if(count($parts)>2) {
        // only one 'd' is allowed
        $this->sendToUser(null, $invalid_msg);
        return 'ok';
    } elseif(count($parts)==1) {
        // if no 'D' assume '1' die
        $number = 1;
    } else {
        $number = (int)$parts[0];
        if ($parts[0] == "") { // if $number == 0
            // if no number assume '1' die
            $number=1;
        } elseif ("$number" != "$parts[0]") {
            // only integers allowed
            $this->sendToUser(null, $invalid_msg);
            return 'ok';
        }
        $dicestring = $parts[1];
    }
    if($number < 1) {
        // can't allow a negative number of dice
        $this->sendToUser(null, $invalid_msg);
        return 'ok';
    }
    // check for sides and modifiers
    // expand the string to put spaces around all the tokens we want
    $dicestring = str_replace('+', ' + ', $dicestring);
    $dicestring = str_replace('-', ' - ', $dicestring);
    $dicestring = str_replace('x', ' x ', $dicestring);
    $dicestring = str_replace('/', ' / ', $dicestring);
    // explode the whole thing to create tokens
    $parts = explode(' ', $dicestring);
    // the only other tokens should be integers
    // allowed formats from here are s[Xm][+a][-d][/q]
    // we should allow any series of these in any order, applying them left to right
    // the first part must be the sides
    $sides = (int)$parts[0];
    if ("$sides" != "$parts[0]") {
        $this->sendToUser(null, $invalid_msg);
        return 'ok';
    }
    if($sides < 1) {
        // can't allow a negative number of sides
        $this->sendToUser(null, $invalid_msg);
        return 'ok';
    }
    // get the user's name
    //$user = ChatServer::getUser($this->userid);
    //$name= $user['login'];
    // start writing the reply string
    $text = '*rolls* '.$number.'d'.$sides.': ';
    // seed the randomizer
    srand(time());
    // with number and sides, roll the dice, adding them up
    $total = 0;
    for($i = 0; $i < $number; $i++) {
        $roll = (rand()%$sides)+1;
        if($i != 0)
            $text .= '+';
        $text .= $roll;
        $total += $roll;
    }
    // now apply all the modifiers to the roll, in the order the user specified them
    for ($i = 1; $i < count($parts); $i+=2) {
        // the value needs to be an integer
        $value = (int)$parts[$i+1];
        $v = $parts[$i+1];
        if ("$value" != "$v") {
            $this->sendToUser(null, $invalid_msg);
            return 'ok';
        }
        // the token needs to be one of the operators - otherwise abort
        $token = $parts[$i];
        switch ($token) {
        case '+':
            // add
            $total += $value;
            break;
        case '-':
            // subtract
            $total -= $value;
            // make minimum 1 - remove this like to allow 0 and lower
            if ($total<1) $total=1;
            break;
        case 'x':
            // multiply
            $total *= $value;
            break;
        case '/':
            // divide - round up so 1d6/3 will be the same as 1d2
            $total = ceil($total/$value);
            break;
        default:
            $this->sendToUser(null, $invalid_msg);
            return 'ok';
        }
        // add the modifier to the display string
        $text .= $token.$value;
    }
    // and display the final result
    $text .= ': '.$total;
    // gets sent to particular room, but with users name tacked on, so a user could spoof it
    // at least 'msgu' looks different
    $this->sendToRoom(null, new Message('rpg', $this->userid, $this->roomid, $text));
    return 'ok';
}


and

function Message($command, $userid = null, $roomid = null, $txt = null, $color = null) {

$this->command = $command;
                        if ($command == 'rpg') $this->command = 'msgu';

$this->userid = $userid;

$this->roomid = $roomid;

$this->color = htmlColor($color);

if($command != 'rpg') {

$txt = str_replace('*rolls*', 'rolls', $txt);

}

if(isset($txt)) {

$this->txt = $this->parse($txt);

}

}

So again all I want it to do is limit the number of dice being rolled because right now someone can do a /d 1000000d100000 and completely crash the chat for everyone. I am thinking 100 on either variable would be plenty. Thanks for your help!

I'm attempting to implement a simple social networking system but at the moment am confused about how to create a multiple query which will display a certain user's friends list.

The database contains four tables, the two tables that I'm using at the moment at 'usersTable' and 'friendshipsTable' are detailed below.


usersTable           | Table that stores all the user data

UserID         | Default primary key
Forename              |
Surname         |
Username           |
Password              |
Email Address      |


friendshipTable   | Table that stores information about friendships between users

FriendshipID      |  Default primary key
userID_1                |  UserID
userID_2         |  UserID
Status         |  Either Pending or Confirmed.

The user's id is parsed into the url, and then saved into a variable.

blah.com/userprofile.php?id=6

$id = $_GET['id']; 

I am familiar with creating simple queries, but can't quite work out how to set up multiple table queries.

What the query needs to do is to check the userID that is parsed with the url, and then check the friendshipsTable by checking if either the userID_1 or userID_2 field  matches the userID to grab the records from the table where there is a match.

The next step is to check to see if the friendship is 'Confirmed' or 'Pending' and if it is 'Pending' to ignore it. Once the records have then been chosen I need the query to then check the value in either userID_1 or userID_2 that doesn't match userID and then pull the user's username and name from the usersTable so it can be displayed on a webpage.

I've no idea hoe much I may or may not be overcomplicating this, an example of the code that I've got so far for this query can be found below, but that's as far as I've got at the moment.

$displayFriends = mysql_query("SELECT * FROM friendshipTable, usersTable WHERE friendshipTable.userID_1='$id' OR friendshipTable.userID_2='$id' ");

Cheers for any help.

I am trying to figure out how to assign a number rank to a set of results, but I need to reset the ranking when a certain column changes.  For example:

Brand    Rank
a   1
a   2
a   3
b   1
b   2
b   3

I set $rank=0; and then for each item in my loop I add $rank++;  How do I get the rank to reset in the loop when the brand changes?  Thanks for any help.

I would like to create something like foursquare badges. When ppl upload files, the most downloaded files will have a new badge, how do i create that?

Hey guys and girls,

Okay so am trying to provide a rank for each user within my database but I cant seem to get it working here is my code

Code: [Select]
SELECT

`Table`.`Id`,
`Table`.`Photo`,
`Table`.`Fname`,
`Table`.`Lname`,
`Table`.`Gender`,
`Table`.`Gd`,
`Table`.`Bd`,
`Table`.`Point`,

(SELECT COUNT(*) + 1 FROM
(SELECT U.Id, T.`User Id` FROM `u_account` U
LEFT JOIN `score_system` T ON `T`.`User Id` = `U`.`Id`) x

WHERE Table.Point > (SELECT SUM(Good)-SUM(Bad) FROM `score_system` GROUP BY `User Id`)
) AS RANK

FROM
(SELECT
`C`.`Id`,
`C`.`Photo`,
`C`.`Fname`,
`C`.`Lname`,
`C`.`Gender`,

CASE WHEN COALESCE( SUM(`S`.`Good`), '') = '' THEN '0' ELSE SUM(`S`.`Good`) END AS Gd,
CASE WHEN COALESCE( SUM(`S`.`Bad`), '') = '' THEN '0' ELSE SUM(`S`.`Bad`) END AS Bd,

CASE WHEN COALESCE( SUM(`S`.`Good` - `S`.`Bad`), '') = ''
THEN '0' ELSE SUM(`S`.`Good` - `S`.`Bad`) END AS Point

FROM
`u_account` AS `C`
LEFT JOIN `score_system` AS `S` ON `C`.`Id` = `S`.`Child Id`

AND (SELECT Start FROM event_schedule WHERE CURDATE() >= Start AND End >= CURDATE()) < `S`.`Date`
AND (SELECT End FROM event_schedule WHERE  CURDATE() >= Start AND End >= CURDATE()) > `S`.`Date`

GROUP BY `C`.`Id`

) AS `Table`

ORDER BY Point DESC, Fname ASC

I cant seem to pull the users rank from this and its donig my head in I've tried different things and they all dont work this is perhaps as close as I've got to figuring it out.

This is the part that creates the users rank now its saying the Subquery returns more than 1 row but I just cant seem to think of away to implement this into my query above so that it displays the rank for each user.

Code: [Select]
(SELECT COUNT(*) + 1 FROM
(SELECT U.Id, T.`User Id` FROM `u_account` U
LEFT JOIN `score_system` T ON `T`.`User Id` = `U`.`Id`) x

WHERE Table.Point >= (SELECT SUM(Good - Bad) FROM `score_system` GROUP BY `User Id`)
) AS RANK

I'm also looking for this to display the same rank for both users with the same points so If bill and ben have 200points then they would both have the same rank but if bill was to have 201points then he would be higher up than ben.

So can anyone lend me a hand.

Thanks in advance

I have a txt file of numbers e.g. 1,4,3,5,19,3,11 all in a column. Is it possible to echo only the highest 3 numbers?

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

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 ?

Hello   I have a mysql table like this: id | user | car
1 | 1 | fiat 500
2 | 2 | vw polo
3 | 2 | vw golf
4 | 3 | renault clio
5 | 2 | fiat panda 6 | 3 | seat ibiza

From this table how can i get a query that the result be like:   user 2 - 3 cars user 3 - 2 cars user 1 - 1 cars   Thanks

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

This topic has been moved to Miscellaneous.

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

hello dear PHP-Fans - greetings to you - and a happy new year!!


i set up a WAMP-System on my openSuse 11.4 system.  In order to learn as much as i can bout PHP i want to do some tests and write some scripts.

Well the WAMP is allready up and running.  Now i try to give the writing access to the folder

mkdir /srv/www/

where the php-scripts should go in...

i want  to give write permission to all to all files in /srv/www

As root I generally:

mkdir /srv/www/
chown <webmaster usrername> /srv/www/

/srv/www/ should be readable and traversable by all, but only writeable by it's owner (the user designated as the webmaster.)

can i do this like mentioned above,...

Love to hear from you

greetings
db1