[PHP] Problem beim Script

[loltown]

Habe mir ein Script proggen lassen, also eine Refrally. Jedoch zählt diese Rally falsch, d.h. 9 ist mehr wert als 10. Es wird also nur die erste Ziffer beachtet. Und ich weiß nicht, wie man das ändern kann


Das Script

<? include('header.php'); ?>
<?function form_cont_vals() {
global $contest;
$result = array();
	$query = mysql_query("SELECT SUM(referals) as cnt FROM tb_users") or die (mysql_error()); $refusk = mysql_fetch_array($query); 
	$query = mysql_query("SELECT gained_mems FROM tb_contest_info WHERE type='ref' AND status = 'active'") or die (mysql_error()); $cont_rsk = mysql_fetch_array($query); 
	$result['gained_refs'] = $cont_rsk['gained_mems'] +  $refusk['cnt'];

	$result['date_start'] = date('Y m d', $contest['timestamp_start']);

	if ($contest['expire_type']=='date') $result['expire'] = date('Y m d', $contest['expire_value']);
	else if ($contest['expire_type']=='memsk') $result['expire'] = $contest['expire_value']." members";
	else echo "Error accured! Please contact support";
return $result;
}
?>
<?
require('config.php');
$query = mysql_query("SELECT * FROM tb_contest_info WHERE type='ref' AND (status = 'active' OR status = 'ended') ORDER BY timestamp_start DESC");
if ($contest = mysql_fetch_array($query)) {	
    $result = form_cont_vals();
    if ($contest['status'] == 'active') {
        echo "<p align=center class=pavblack>Referral contest running untill {$result['expire']}!</p><br />";?>
<!- -----------------THIS IS A PLACE TO SHOW CONTEST PRIZES AND OTHER INFO ------------------------->
        
        
        
        
        
        
        
        
        
        <?
        // ----------------- END OF PLACE TO EDIT  ------------------------>
        echo "
        <table width=400 align=center border=1 cellpadding=3>
        <tr align=center class=pavblue>
         <td>Place</td>
         <td>Member</td>
         <td>Referrals</td>
        </tr>";
        $query = mysql_query("SELECT username, referals FROM tb_users WHERE referals ORDER BY referals DESC LIMIT 0, 30") or die (mysql_error()); $i=1;
        while ($member = mysql_fetch_array($query)) 
        echo "
        <tr align=center class=blsimpb>
         <td>".($i++)."</td>
         <td>{$member['username']}</td>
         <td>{$member['referals']}</td>
        </tr>"; echo "</table>";
        } 
    else {
        echo "<p align=center class=pavblack>Referral contest ended at {$result['expire']}.</p><br /><br /><br />";?>
        <!- -----------------THIS IS A PLACE TO PUT WINNERS AND WRITE ABOUT THEIR PRIZES... ------------------------->
        
        
        
        <p align=center class=pavblue>Contest results soon will be posted</p>
        
        
        
        
        
        <!- ----------------- END OF PLACE TO EDIT  ------------------------->
        <?
    }
} 
else echo "<p align=center class=redalert>No Referral contests found!</p>";
?>
<? include('footer.php'); ?>

Die MySQL

--
-- Tabel structuur voor tabel `tb_contest_info`
--

CREATE TABLE IF NOT EXISTS `tb_contest_info` (
  `ID` int(6) NOT NULL default '0',
  `type` varchar(10) NOT NULL default '',
  `timestamp_start` int(14) NOT NULL default '0',
  `expire_type` varchar(10) NOT NULL default '',
  `expire_value` int(12) NOT NULL default '0',
  `gained_mems` int(6) NOT NULL default '0',
  `status` varchar(10) NOT NULL default '',
  UNIQUE KEY `ID` (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Gegevens worden uitgevoerd voor tabel `tb_contest_info`
--


-- --------------------------------------------------------

--
-- Tabel structuur voor tabel `tb_contest_winners`
--

CREATE TABLE IF NOT EXISTS `tb_contest_winners` (
  `cont_ID` int(6) NOT NULL default '0',
  `login` varchar(15) NOT NULL default '',
  `amount` int(6) NOT NULL default '0',
  `place` int(4) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Gegevens worden uitgevoerd voor tabel `tb_contest_winners`
--

 

[LasMiranda]

referals ist sicherlich varchar

 

[Benutzer-2472]

referals ist sicherlich varchar

Entweder explizit casten oder in der DB schauen

Scripts & Software