Quote:
Originally Posted by Tory
Erreur request sql users how to thank you
Une fois creer la requete sql users je recois une erreur merci de m aider
Et comment creer ceci
Added:addjeton
Added:movies
Added:kpschangebonus streaming
merci
|
ROOT/admin/addjeton.php
addjeton.php
PHP Code:
<?
function class_amount ()
{
echo '<select name="classamount" style="width: 145px;" id="specialboxes">
<option value="0" style="color: gray;">( amount )</option>';
$i = 1;
while ($i < 51)
{
print '' . '<option value=' . $i . '>' . $i . ' droits_film</option>
';
++$i;
}
echo '</select>';
}
if (!defined ('STAFF_PANEL_TSSEv56'))
{
exit ('<font face=\'verdana\' size=\'2\' color=\'darkred\'><b>Error!</b> Direct initialization of this file is not allowed.</font>');
}
define ('UA_VERSION', '0.3 by xam');
if ($HTTP_SERVER_VARS['REQUEST_METHOD'] == 'POST')
{
$class = (int)$_POST['usergroup'];
if (($class == '-' OR !is_valid_id ($class)))
{
$class = '';
}
$query = 'enabled=\'yes\' AND status=\'confirmed\'' . ($class ? ' AND usergroup=' . $class : '');
if ($_POST['doit'] == 'yes')
{
if (($_POST['classamount'] < 1 OR 51 < $_POST['classamount']))
{
stderr ('Error', 'Don\'t leave any fields blank!');
}
$modcomment = gmdate ('Y-m-d') . ' - Got ' . ($_POST['classamount']) . ' droits_film Amount from ' . $CURUSER['username'] . ' (droits_film Add Tool)' . $eol;
$ulamount = sqlesc ($_POST['classamount']);
(sql_query ('' . 'UPDATE users SET droits_film = droits_film + ' . $ulamount . ', modcomment=CONCAT(' . sqlesc ($modcomment . '') . ('' . ', modcomment) WHERE ' . $query)) OR sqlerr (__FILE__, 45));
stderr ('droits_film', $_POST['classamount'] . 'droits_film is sent to ' . ($class ? 'following class: ' . get_user_class_name ($class) : 'everyone...'));
exit ();
}
if (($_POST['username'] == '' OR $_POST['droits_film'] == ''))
{
stderr ('Error', 'Don\'t leave any fields blank!');
}
$username = sqlesc ($_POST['username']);
$droits_film = sqlesc ($_POST['droits_film']);
$modcomment = gmdate ('Y-m-d') . ' - Got ' . ($_POST['droits_film']) . ' droits_film Amount from ' . $CURUSER['username'] . ' (jeton Add Tool)' . $eol;
(sql_query ('' . 'UPDATE users SET droits_film= droits_film + ' . $droits_film . ', modcomment=CONCAT(' . sqlesc ($modcomment . '') . ('' . ', modcomment) WHERE username=' . $username . ' AND ' . $query)) OR sqlerr (__FILE__, 56));
($res = sql_query ('' . 'SELECT id FROM users WHERE username=' . $username) OR sqlerr (__FILE__, 57));
$arr = mysql_fetch_row ($res);
if (!$arr)
{
stderr ('Error', 'Unable to update account.');
}
header ('' . 'Location: ' . $BASEURL . '/userdetails.php?id=' . $arr['0']);
exit ();
}
$usergroups = _selectbox_ (NULL, 'usergroup');
stdhead ('Update Users droits_film Amounts');
_form_header_open_ ('Update Users droits_film Amounts');
echo '<form method="post" action="' . $_this_script_ . '">';
begin_table (true);
echo '<tr><td class="rowhead">User name: </td><td class="row1"><input type="text" name="username" id="specialboxn" size="40"/></td></tr>';
echo '<tr><td class="rowhead">droits_film: </td><td class="row1"><input type="text" name="droits_film" size="40" id="specialboxes"/> <input type="submit" value="do it" class="btn"/></td></tr>';
echo '</form>';
end_table ();
_form_header_close_ ();
echo '<br>';
_form_header_open_ ('Send xdroits_film amount to everyone!');
echo '<form action="' . $_this_script_ . '" method="post">';
begin_table (true);
echo '<tr><td class="row1" align="center">Usergroup:
<input type = "hidden" name = "doit" value = "yes" />';
echo $usergroups . ' ';
class_amount ();
echo '<input type="submit" value="do it" class="btn" />
</td></tr>';
end_table ();
echo '</form>';
_form_header_close_ ();
stdfoot ();
?>
---------------------------------------------------------------------------------
Added:movies
ROOT/admin/movies.php
movies.php
PHP Code:
<?php
$rootpath = './../';
require_once $rootpath . 'global.php';
dbconn ();
loggedinorreturn ();
stdhead ('divx add');
if (!defined ('STAFF_PANEL_TSSEv56'))
{
exit ('<font face=\'verdana\' size=\'2\' color=\'darkred\'><b>Error!</b> Direct initialization of this file is not allowed.</font>');
}
?>
<html>
<form method="POST" action="streamingmovies.php">
<center>
<center><font size=4 color=red>Ajouter un film</font><br></center>
<center><font color=green>Lien url</font></center><input type="text" name="url" size="50" value="" maxlength="350"><br>
<center><font color=green>Image</font></center><input type="text" name="image" size="50" value="" maxlength="350"><br>
<center><font color=green>titre</font></center><input type="text" name="title" size="50" value="" maxlength="350"><br>
<center><font color=green>synopsis</font></center><input type="text" name="synopsis" size="50" value="" maxlength="350"><br>
<input type="submit" value="Ajouter" name="envoyer">
</center>
</form>
</html>
<html>
<form method="POST" action="streamingmovies3.php">
<center>
<center><br><br><font size=4 color=red>editer un film</font><br></center>
<center><font color=green>Entrez le ID du film à editer</font></center><input type="text" name="id" size="50" value="" maxlength="350"><br>
<center><font color=green>Lien url</font></center><input type="text" name="url" size="50" value="" maxlength="350"><br>
<center><font color=green>Image</font></center><input type="text" name="image" size="50" value="" maxlength="350"><br>
<center><font color=green>titre</font></center><input type="text" name="title" size="50" value="" maxlength="350"><br>
<center><font color=green>synopsis</font></center><input type="text" name="synopsis" size="50" value="" maxlength="350"><br>
<input type="submit" value="edit" name="edit">
</center>
</form>
</html>
<html>
<form method="POST" action="streamingmovies2.php">
<center>
<center><br><br><font size=4 color=red>Supprimez un film</font><br></center>
<center><font color=green>Entrez le ID du film à supprimez</font></center><input type="text" name="id" size="50" value="" maxlength="350"><br>
<input type="submit" value="Supprimer" name="envoyer">
</center><br><br>
</form>
</html>
<?php
// on crée la requête SQL
$sql = 'SELECT id FROM divx ORDER BY id DESC LIMIT 0,1 ';
// on envoie la requête
$req = mysql_query($sql) or die('Erreur SQL !<br>'.$sql.'<br>'.mysql_error());
// on fait une boucle qui va faire un tour pour chaque enregistrement
while($data = mysql_fetch_assoc($req))
{
// on affiche les informations de l'enregistrement en cours
echo '<center><b><font size=4 color=red>Le dernier ID utilisé</font></b><br><br></center> ';
echo '<center><b><font size=5 color=green>'.$data['id'].' '.$data['title'].'</font></b><br></center> ';
}
?>
<?
stdfoot ('');
?>
Added:movies
ROOT/admin/
streamingmovies.php
streamingmovies.php
PHP Code:
<?php
$rootpath = './../';
require_once $rootpath . 'global.php';
dbconn ();
loggedinorreturn ();
stdhead ('streaming add');
if(isset($_POST['url'])) $url=$_POST['url'];
else $url="";
if(isset($_POST['image'])) $image=$_POST['image'];
else $image="";
if(isset($_POST['title'])) $title=$_POST['title'];
else $image="";
if(isset($_POST['synopsis'])) $synopsis=$_POST['synopsis'];
else $image="";
// On vérifie si les champs sont vides
if(empty($url) OR empty($image))
{
echo '<center><font color="red">Attention, aucun champ ne peut rester vide !</font></center>';
}
// Aucun champ n'est vide, on peut enregistrer dans la table
else
{
// connexion à la base
// on écrit la requête sql
$sql = "INSERT INTO divx(url,image,title,synopsis) VALUES('$url','$image','$title','$synopsis')";
// on insère les informations du formulaire dans la table
mysql_query($sql) or die('Erreur SQL !'.$sql.'<br>'.mysql_error());
// on affiche le résultat pour le visiteur
echo '<br><br><center><font size=5 color=green>Vos infos on été ajoutées.</font></center>';
echo '<br><br><a rel="nofollow" href="/admin/index.php?act=movies" class="" title="Ajoutez un autre film"><center><font color=red size=4>Ajoutez un autre film</a></font></center><br><br>';
mysql_close(); // on ferme la connexion
}
stdfoot ('');