标题: 物品发送脚本 [打印本页] 作者: admin 时间: 2016-1-10 03:43 标题: 物品发送脚本 <?php5 T4 b' u b; m% P n2 S7 z
function Connect () {4 Y6 j+ V2 z L* o8 y
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB " x7 x# Y- }1 T' e$ B
$ u: Y7 C6 W( G# {$ K @Failed.');* h+ u, b% o3 S7 |
} 4 V) @, u7 U, ?, v$ EConnect(); ' F) |8 ]( H2 V1 N6 R- {1 ^% O6 H7 d# g7 I* G5 @1 X
function InitForm(){ 5 y e- X9 {% v//layout for the form/ S! W2 J |; T
echo "<strong>Send Items.</strong>. N! o' _+ T4 N; ^# R7 c. S q. q
<form name='select' method='post'>5 S8 O. u( S P3 [9 E
<lable>Character Name</lable><br/>' r) ?5 X5 S+ ]4 M
<input type='text' name='char'/><br/>& ?3 E' W+ H% O+ p9 C+ e* J
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/> / q, \) F$ K. M4 @2 R ?0 I0 u<input type='text' name='item_name'/><br/>3 b0 ^9 [1 P) z( {6 B/ H7 h
<lable>Item Amount</lable><br/> ! \( o* F9 `# I) v: h+ t<input type='text' name='item_amount'/><br/>' l1 B. g. p) R. a* j [% Z/ |
<lable>Item Upgrade Amount</lable><br/># J- x6 P8 q( m0 v) B9 e; g4 k4 t& S
<input type='text' name='item_upgrade'/><br/> 2 d9 d. a& S; \* m9 P; D- h<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)" J( n. \: R" g) s9 G
# S1 j! U1 w/ b' ?0 K( G8 H
</lable><br/>. b7 Z" Z% _. F. s$ H8 ]) [* n
<input type='text' name='item_element'/><br/>- z9 q+ N% I2 u! l6 Q- ]
<lable>Element Upgrade Amount</lable><br/>& C+ Y4 g/ W. e7 x
<input type='text' name='element_upgrade'/><br/>) H) Y4 d; _1 s! m& o3 h
<lable>Pierced Amount</lable><br/> ) P% f7 f" e* ^, h& [2 A; I1 @0 j9 `<input type='text' name='item_pierce'/><br/> 5 k" W( h: L* q8 S7 U<input type='submit'/> ! x/ F; x2 b+ e. r% ]</form>";1 o8 t" G' e2 t$ X
} 5 G9 m2 h& z$ k: C# U4 U ~+ U0 S3 P + b3 |' {, g+ ?; @' w* Rfunction PostListener (){4 K* l' b1 r/ ~7 u
//Add more post variables if needed and add them to initform() function aswell * N4 A7 e8 O3 U% E5 ]3 N& ]0 J9 J* x: ]0 M* I
################################4 T; I6 M4 d6 _' y4 g7 Q
##### Connection and Post ######+ D1 N. F. C1 j0 |/ d6 X
################################ 9 S1 j& F8 i5 {6 `" Y& p$name = @$_POST['char'];; ]2 V# b! x5 z* S: v3 D+ Z
$ItemName = @$_POST['item_name'];: G8 o ~) S% ]1 U( {8 M4 p- {1 e
$ItemAmount = @$_POST['item_amount'];0 ?( n/ W5 g) R$ b, h4 L( x
$ItemId = @$_POST['item_id']; ' Y( d$ U+ e9 ]# {: [. B; q9 f$ItemUpgrade = @$_POST['item_upgrade'];) @! h# ~7 p) }% z/ v
$ItemElement = @$_POST['item_element'];! d0 L" B" F5 I3 H
$ElementUpgrade = @$_POST['element_upgrade'];' `* N2 ?2 e" A; z
$ItemPierce = @$_POST['item_pierce']; 3 h! d6 k1 T8 n+ F1 [################################, n5 _5 H$ A8 c4 p" X7 Y
4 F' M4 l a; w, ^9 u//Check both variables for empty value8 N( }+ ^# ~% z1 n9 C5 v& G
6 U/ J# L2 I- j4 n# Jif (!empty($_POST['char'])){5 b. ]+ N7 q' d2 E2 [" p
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where 6 C" b- d" W0 w" F 0 i$ x2 K5 K: o* q9 N$ xm_szName = '{$name}'");/ I9 D% p: {$ T( Y- N
while ($row = mssql_fetch_object($find)){ 0 a$ I" f) @9 S# `( W$ eecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";* A& C9 [6 {- D2 L+ r7 d
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], 6 d E2 S" K9 {3 V* t# F! D