物品发送脚本

admin

<?php
1 {, G3 A! T. _function Connect () {
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB

$ t0 |# A( C" w: W+ a; c- XFailed.');
}
Connect();

function InitForm(){
$ A* x+ O) [. V' _9 Q* W//layout for the form
' S" J4 F- @% N- q" ^$ Techo "<strong>Send Items.</strong>
<form name='select' method='post'>
- Z; |% o2 G& X<lable>Character Name</lable><br/>
<input type='text' name='char'/><br/>
0 H' A  i3 V8 k; r. U6 F. D<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
<input type='text' name='item_name'/><br/>
' w* d! `* D* a2 \+ X  R1 o<lable>Item Amount</lable><br/>
<input type='text' name='item_amount'/><br/>
<lable>Item Upgrade Amount</lable><br/>
# ^0 D6 b0 Q! A+ V3 T: a% x) m<input type='text' name='item_upgrade'/><br/>
  t. z& d1 t; b  G. F<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)

: _. J8 k; S" z5 a) k# ]$ [- g0 ]</lable><br/>
<input type='text' name='item_element'/><br/>
0 d! X5 @$ b- Z: A1 E- q  T5 {) q<lable>Element Upgrade Amount</lable><br/>
<input type='text' name='element_upgrade'/><br/>
<lable>Pierced Amount</lable><br/>
+ v6 n5 ~8 U9 v; U( J<input type='text' name='item_pierce'/><br/>
<input type='submit'/>
</form>";
}

function PostListener (){
//Add more post variables if needed and add them to initform() function aswell
+ T7 [( U- q& s1 s" p/ k: u; n5 S
/ a4 K0 O9 m: d; R3 o################################
; S$ y/ `2 H& t( p5 w##### Connection and Post ######
################################
$name = @$_POST['char'];
$ItemName = @$_POST['item_name'];
$ItemAmount = @$_POST['item_amount'];
0 |5 V3 _& S: t% c5 l, Y1 R$ItemId = @$_POST['item_id'];
8 h) Z' _- R& V8 g0 |$ItemUpgrade = @$_POST['item_upgrade'];
$ItemElement = @$_POST['item_element'];
9 y9 |( ^5 D  P% o+ K" T. M$ElementUpgrade = @$_POST['element_upgrade'];
) W6 n5 }' C+ U7 H% `5 @/ Q$ItemPierce = @$_POST['item_pierce'];
################################

9 V8 b: c( I( d' l5 q5 _* j3 Z//Check both variables for empty value

& ?( \( |; Q: m1 \, p  a8 Tif (!empty($_POST['char'])){
/ `0 Y/ B( `/ N1 h: q8 M) s$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where

0 j# o  C& `9 J. wm_szName = '{$name}'");
% Z8 I9 l+ M- _+ h+ o- w% A+ Lwhile ($row = mssql_fetch_object($find)){
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
# W" R; i+ X- @- Y# w, V) u$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
/ C; u) H1 [! j& ^) F" n3 P
& [- k! c/ u4 q; K% B6 F/ w! {[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
- Q& H+ A8 q; C  W2 w* f
# G: {6 W# X+ [& t0 G. C& a2 H[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',

5 M9 c- l. t2 r" C$ d* v* ~N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
. H5 S' H; Y( q) q1 ]
% P" a' l7 P! F& P$ ^$ G'{$ElementUpgrade}', '{$ItemPierce}');");
) D4 h* Z0 w; V0 J5 ?; z}
4 v$ m) q2 Z: L/ y9 _! X3 ~$ e
% N% Y# l: S' |2 F: K. ~) H8 r+ C}

8 j& a2 l# a4 J( B" N4 O0 X/ n0 f9 i# M}
/ I4 w, f2 }0 L) e) P! D4 _6 U% z
2 |1 t/ s& M% Y$InitForm = InitForm();
$Listener = PostListener();

1 q( @# f8 S* |+ h. w6 n) C! C  C?>
9 g/ V) C5 I. C$ Z3 j* |
* J1 P( H% I, F