Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $host = "localhost";
- $user = "root";
- $pass = "root";
- $db = "world";
- if(!empty($_POST))
- {
- $con = mysql_connect($host,$user,$pass) or die(mysql_error());
- mysql_select_db($db) or die(mysql_error());
- $itemsetid = mysql_real_escape_string($_POST['itemsetid']);
- $vendorid = mysql_real_escape_string($_POST['vendorid']);
- $itemextendedcost= mysql_real_escape_string($_POST['itemextendedcost']);
- $query = mysql_query("SELECT * FROM item_template WHERE itemset='$itemsetid'") or die (mysql_error());
- while($itemek = mysql_fetch_assoc($query))
- {
- $entry = $itemek["entry"];
- mysql_query("INSERT INTO `npc_vendor` (`entry`,`item`,`ExtendedCost`) VALUES ('".$vendorid."','".$entry."','".$itemextendedcost."')") or die(mysql_error());
- }
- echo "Sikeres addolás!";
- mysql_close($con);
- }
- ?>
- <html>
- <head>
- <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
- <title>Itemadd</title>
- </head>
- <body>
- <form action="" method="post">
- ItemSet:<br /> <input type='text' name='itemsetid' /><br />
- Vendor:<br /> <input type='text' name='vendorid' /><br />
- ItemExtendedCost(ár):<br /> <input type='text' name='itemextendedcost' /><br />
- <input type='submit' value='Beküld' />
- </form>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement