Posts by cp2
-
-
-
-
-
-
-
-
-
-
Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in /usr/home/larsisgoed9/domains/pretpark-online.nl/public_html/newmafia/rechtbank.php on line 176
post dat stukje script is anders..
-
Als je dit in Cronjobs doet op je server wel..
-
alstu
PHP
Toon Meer<?php include ("includes/config.php"); Login(); echo "<html> <head> <title>Crimini</title> <link href="static/layout/css/menu.css" rel="stylesheet" type="text/css"> </head> <body>"; $sortArray = ('alive','dead','nickname','xp','regtime'); if (in_array($_GET['sort'],$sortArray)) { $sMaxpage = 10; $sBegin = ($_GET['n'] >= 0) ? $_GET['n'] * $sMaxpage : 0; if (isset($_GET['sort']) { $sQuery = mysql_query("SELECT * FROM `Members` WHERE `status`='".$_GET['sort']."' LIMIT $sBegin, $sMaxpage"); $iRow = mysql_num_rows($sQuery); if ($iRow == 0) { echo "Geen gebruikers"; } else { echo "<table> <tr> <td>Nicknaam</td> <td>Familie</td> <td>Rang</td> </tr>"; while($sResult = mysql_fetch_assoc($sQuery)) { $sQueryUser = mysql_query("SELECT * FROM `Members` WHERE `nickname`='" .$sResult['nickname']. "'"); $sUser = mysql_fetch_assoc($sQueryUser); if (empty($sResult['family'])) { $sFamily = "Geen"; } else { $sQueryFam = mysql_query("SELECT * FROM `Family` WHERE `name`='" .$sResult['family']. "'"); $sFam = mysql_fetch_assoc($sQueryFam); $sFamily = "<a href="family-profile.php?id=" .$sFam['id']. "">" .$sResult['family']. "</a>"; } if ($sResult['xp'] < 10) { $sRang = "Empty-suit"; } elseif ($sResult['xp'] < 20 AND $sResult['sex'] == "male") { $sRang = "Deliveryboy"; } elseif ($sResult['xp'] < 20 AND $sResult['sex'] == "female") { $sRang = "Delivery Girl"; } elseif ($sResult['xp'] < 50) { $sRang = "Picciotto"; } // komen nog meer rangen erbij $sNickname = "<a href="user-profile.php?id=" .$sUser['id']. "">" .$sResult['nickname']. "</a>"; echo " <tr> <td>" .$sNickname. "</td> <td>" .$sFamily. "</td> <td>" .$sRang. "</td> </tr>"; } echo " <tr> <td colspan="3">Pagina</td> <td colspan="3">"; foreach(range(1, ceil($iRow / $sMaxpage)) AS $i) { $i--; echo "<a href="?page=" .$i. "">" .($i+1). "</a>"; } echo " </td> </tr>"; } } } else { echo "deze functie bestaat niet"; } echo "</body> </html>"; mysql_close(); ?>
Nieuwe reactie samengevoegd met originele reactie op 31.01.10 00:36:50:
Ik zou overigens voor die rangen een functie maken ofz... beetje onnodig om die op elke pagina opnieuw aan te vragen.. -
ow iets te ijverig geweest met deleten moment
-
tsja.. eigenwijs? nee valt best mee;)
ik zou het persoonlijk zo doenPHP
Toon Meer<?php include ("includes/config.php"); Login(); echo "<html> <head> <title>Crimini</title> <link href=\"static/layout/css/menu.css\" rel=\"stylesheet\" type=\"text/css\"> </head> <body>"; $sortArray = ('alive','dead','nickname','xp','regtime'); if (in_array($_GET['sort'],$sortArray)) { $sMaxpage = 10; $sBegin = ($_GET['n'] >= 0) ? $_GET['n'] * $sMaxpage : 0; $iRow = mysql_num_rows($sQuery); if ($iRow == 0) { echo "Geen gebruikers"; } else { echo "<table> <tr> <td>Nicknaam</td> <td>Familie</td> <td>Rang</td> </tr>"; while($sResult = mysql_fetch_assoc($sQuery)) { $sQueryUser = mysql_query("SELECT * FROM `Members` WHERE `nickname`='" .$sResult['nickname']. "'"); $sUser = mysql_fetch_assoc($sQueryUser); if (empty($sResult['family'])) { $sFamily = "Geen"; } else { $sQueryFam = mysql_query("SELECT * FROM `Family` WHERE `name`='" .$sResult['family']. "'"); $sFam = mysql_fetch_assoc($sQueryFam); $sFamily = "<a href=\"family-profile.php?id=" .$sFam['id']. "\">" .$sResult['family']. "</a>"; } if ($sResult['xp'] < 10) { $sRang = "Empty-suit"; } elseif ($sResult['xp'] < 20 AND $sResult['sex'] == "male") { $sRang = "Deliveryboy"; } elseif ($sResult['xp'] < 20 AND $sResult['sex'] == "female") { $sRang = "Delivery Girl"; } elseif ($sResult['xp'] < 50) { $sRang = "Picciotto"; } // komen nog meer rangen erbij $sNickname = "<a href=\"user-profile.php?id=" .$sUser['id']. "\">" .$sResult['nickname']. "</a>"; echo " <tr> <td>" .$sNickname. "</td> <td>" .$sFamily. "</td> <td>" .$sRang. "</td> </tr>"; } echo " <tr> <td colspan=\"3\">Pagina</td> <td colspan=\"3\">"; foreach(range(1, ceil($iRow / $sMaxpage)) AS $i) { $i--; echo "<a href=\"?page=" .$i. "\">" .($i+1). "</a>"; } echo " </td> </tr>"; } } else { echo "deze functie bestaat niet"; } echo "</body> </html>"; mysql_close(); ?>
-
-
PHP
Toon Meerif ($_GET['sort'] == "alive") { $sQuery = mysql_query("SELECT * FROM `Members` WHERE `status`='alive'"); } elseif ($_GET['sort'] == "dead") { $sQuery = mysql_query("SELECT * FROM `Members` WHERE `status`='dead'"); } elseif ($_GET['sort'] == "nickname") { $sQuery = mysql_query("SELECT * FROM `Members` ORDER BY `nickname` ASC"); } elseif ($_GET['sort'] == "xp") { $sQuery = mysql_query("SELECT * FROM `Members` ORDER BY `xp` ASC"); } else { $sQuery = mysql_query("SELECT * FROM `Members` ORDER BY `regtime` ASC"); }
dit kan toch ook een stuk korter?
bijv
wel even checken natuurlijk of de SORT bestaat,
-
uhm YVMdesign je post nou iets stompzinnigs lijkt me.
if ($ip == "0.0.0.0")
elseif ($ip == "0.0.0.0")is hetzelfde
-
Pharox leer lezen:P hij wil 2 verbindingen per 1 ip accepteren..
dit is idd mogelijk bij iedere aamelding bijv ip +1 doen staat deze op 2 mogen er geen acc meer aangevraagd worden..
Nieuwe reactie samengevoegd met originele reactie op 30.01.10 19:25:07:
als ik het goed heb zit zoiets in banditi ook ingebouwd.. -
-