物品发送脚本

admin

<?php
function Connect () {
8 Z  ?4 A" N0 nmssql_connect('Server','UserName','Password') or die('Error: Connection to DB
  A+ Z( K: f! Q: x% p6 Z' b
1 p$ }- p2 B3 LFailed.');
}
Connect();
) M$ K* P# x/ ]0 P. x, y
6 Q. q9 N' T& {! ^; ifunction InitForm(){
, L3 t1 c% C2 |+ k3 Q//layout for the form
1 [! [4 ]  C2 |7 ~, X1 J2 w' necho "<strong>Send Items.</strong>
<form name='select' method='post'>
# `1 {& u1 l9 S. ~! j( b+ b<lable>Character Name</lable><br/>
<input type='text' name='char'/><br/>
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
<input type='text' name='item_name'/><br/>
' g9 w; i/ }) ?! U/ }<lable>Item Amount</lable><br/>
<input type='text' name='item_amount'/><br/>
<lable>Item Upgrade Amount</lable><br/>
<input type='text' name='item_upgrade'/><br/>
6 q& t- k2 h+ Y- d<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
5 s; ~1 [) t8 p! W* {( L6 F$ T$ X
8 ?# \; V; v' d- |1 n3 V  V</lable><br/>
<input type='text' name='item_element'/><br/>
<lable>Element Upgrade Amount</lable><br/>
<input type='text' name='element_upgrade'/><br/>
<lable>Pierced Amount</lable><br/>
7 X* g; G# t8 k8 s  c' j' @, x# ?<input type='text' name='item_pierce'/><br/>
<input type='submit'/>
</form>";
}

function PostListener (){
" t1 h) b/ z& V/ D//Add more post variables if needed and add them to initform() function aswell

' j( ]  F, W3 |$ [9 b! ^& J################################
- N. x* Q! q. I. n/ L, T( k##### Connection and Post ######
+ g4 k$ B$ n1 d# q################################
$name = @$_POST['char'];
$ItemName = @$_POST['item_name'];
$ItemAmount = @$_POST['item_amount'];
$ItemId = @$_POST['item_id'];
$ItemUpgrade = @$_POST['item_upgrade'];
+ D: v  b( V7 H( p( }( n$ItemElement = @$_POST['item_element'];
$ElementUpgrade = @$_POST['element_upgrade'];
$ItemPierce = @$_POST['item_pierce'];
################################
" D) q: C! ~" h
4 n* n, W) |  {. i//Check both variables for empty value
# ~0 w5 h; W4 |. G# k: ?, V( {
3 u% u7 n( @6 Cif (!empty($_POST['char'])){
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where

m_szName = '{$name}'");
9 t! E8 L- W$ _+ E8 j. iwhile ($row = mssql_fetch_object($find)){
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],

  N: \7 l7 i3 K% ~2 y* B7 m[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
+ n: z3 J) y2 V
7 v+ a2 |9 R! ~2 y, x  `7 k  m1 t1 @1 F[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
1 b6 X( j" v" i1 _& F
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
6 B3 z& e. D" E, {
'{$ElementUpgrade}', '{$ItemPierce}');");
1 e1 f4 y* [2 Y}
* X, S# k5 X3 X! m3 A8 J
  R: f2 r- L" m& w}

}
( ~9 b7 n2 e, b# G- e( {
$InitForm = InitForm();
$Listener = PostListener();
+ W1 M. d2 n: [+ o0 y" c1 |
- S2 o2 M7 R9 ]# P. @?>
0 y1 M* `$ W3 H