物品发送脚本

admin

<?php
, @: i+ b( o. L  I  R( `function Connect () {
$ i. f5 j, C1 Z$ M% Kmssql_connect('Server','UserName','Password') or die('Error: Connection to DB
$ H' s# Y% L' L! U, W/ k
% ?/ t1 b( O5 g, Q* TFailed.');
* B- ?4 _1 U" p' l}
8 F% A9 v* Q4 ]' iConnect();

function InitForm(){
//layout for the form
$ x: H: f* B, B+ eecho "<strong>Send Items.</strong>
3 ]& N, r, w$ O0 P) S<form name='select' method='post'>
<lable>Character Name</lable><br/>
<input type='text' name='char'/><br/>
" I5 R+ `4 `" D8 S7 ^5 M2 w. t8 u<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
<input type='text' name='item_name'/><br/>
<lable>Item Amount</lable><br/>
4 p- y- ^/ |* j* Z% a" F<input type='text' name='item_amount'/><br/>
<lable>Item Upgrade Amount</lable><br/>
/ O+ G& t  e8 h( R4 H<input type='text' name='item_upgrade'/><br/>
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)

</lable><br/>
( A! l9 f2 I0 D6 _$ Z<input type='text' name='item_element'/><br/>
<lable>Element Upgrade Amount</lable><br/>
4 j4 j4 A; D% f8 ^  d) e; K<input type='text' name='element_upgrade'/><br/>
<lable>Pierced Amount</lable><br/>
<input type='text' name='item_pierce'/><br/>
<input type='submit'/>
</form>";
8 d( a& \8 w! S; {- @}
% ?9 r7 {2 ]; N- R# `
! ~2 J1 f3 w- `, z" pfunction PostListener (){
//Add more post variables if needed and add them to initform() function aswell

################################
2 J. u" n+ I  c3 q* N##### Connection and Post ######
4 q  ]5 a6 q2 |, m& D2 l  L8 G: z################################
$name = @$_POST['char'];
1 G, A. A& R, O  x5 a2 \$ItemName = @$_POST['item_name'];
% d  r7 h7 p, a! ?6 n# s) r& _$ItemAmount = @$_POST['item_amount'];
$ L4 B8 _+ v2 ]) u& h9 o# U! O0 J$ItemId = @$_POST['item_id'];
$ItemUpgrade = @$_POST['item_upgrade'];
$ItemElement = @$_POST['item_element'];
$ElementUpgrade = @$_POST['element_upgrade'];
2 T# S) v* s% `& {: e6 c  N( ?6 @$ItemPierce = @$_POST['item_pierce'];
################################

//Check both variables for empty value
- T  M0 o1 T- U. O$ a0 ^  {( E
if (!empty($_POST['char'])){
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
$ f0 O+ J. {" t) |& f1 G
# w7 U# W5 j! um_szName = '{$name}'");
3 Z. }" h1 [3 N5 `) ?while ($row = mssql_fetch_object($find)){
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
4 |+ ?- c" T- J% d6 r$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
! @" G  y  ?' I
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],

* q9 j7 l8 v* A" X* P[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',

N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
+ S1 e  L7 }+ B2 p5 ?
'{$ElementUpgrade}', '{$ItemPierce}');");
}
- ^9 z* d+ E& `( {& Q1 J5 S
}
/ `2 d) m2 `9 _& y2 G, {
}
5 J; B: n: j) K$ S+ @1 k
0 Z+ D) p: W( [0 t$InitForm = InitForm();
$Listener = PostListener();
2 Z3 s8 P- ?0 D2 ?6 z  x# {
. n9 `) k7 X1 Z  V% I  f?>
3 W+ M! I& b3 z2 j
. h  _2 P, E2 |1 W! z6 E

4 q; [+ Y! E( `9 C5 _/ V" t