标题: 物品发送脚本 [打印本页] 作者: admin 时间: 2016-1-10 03:43 标题: 物品发送脚本 <?php , a: o, T3 V+ T) Xfunction Connect () { 0 z( P# g* i: F0 N: kmssql_connect('Server','UserName','Password') or die('Error: Connection to DB 1 J0 y1 j+ E) q; H1 A1 I' V 0 \8 |) L8 _ UFailed.'); + x2 i* j3 I& j+ u# A! B7 R; {: ^} 7 f" G, w3 p7 b. q2 ?- s2 Z$ D% LConnect(); . N" ~; b* n# N! F - h7 B( a- h2 a, O" efunction InitForm(){ ( X! p4 w0 S7 b& C* d! {1 t0 I9 F//layout for the form0 t9 h, k+ l$ C. A* D
echo "<strong>Send Items.</strong> - A/ |. H, {( m6 U9 B+ e<form name='select' method='post'> . v( J/ t, r# q% b<lable>Character Name</lable><br/> 3 c& z, E# A; I, _<input type='text' name='char'/><br/>% N; d' R7 S& v2 S3 x
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>6 [9 X+ _( t% T
<input type='text' name='item_name'/><br/> . K' M8 U0 V i# I% D<lable>Item Amount</lable><br/> : A& H9 o7 X* P- M$ ], f6 h- [, y<input type='text' name='item_amount'/><br/>! @ H" A* I, D: h1 h
<lable>Item Upgrade Amount</lable><br/> r6 K' o& H0 T* n& I( e<input type='text' name='item_upgrade'/><br/>: `) L' c" @ {7 a
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)6 `3 d/ P3 g# N: N. l
& {4 `! M+ z! r5 W7 ?
</lable><br/> - y& a! \( r! e/ b<input type='text' name='item_element'/><br/>: w1 u8 s. x* P e/ P
<lable>Element Upgrade Amount</lable><br/> : Y: d: z) S( V6 u0 b, H0 K6 e<input type='text' name='element_upgrade'/><br/>: p8 ^ {+ z; m# e
<lable>Pierced Amount</lable><br/>8 J9 Y- O0 Q, x* w* r p8 @
<input type='text' name='item_pierce'/><br/>7 V- W6 S! o9 _0 |" L& T$ e
<input type='submit'/> # k& X4 A( d& R; N</form>";" x+ A4 j0 X @4 J6 X
}8 C' I9 X7 T7 R8 ^
. D7 h; y3 `' @! p* {
function PostListener (){ # ^9 O4 Z; h" ~3 l* t; U& F//Add more post variables if needed and add them to initform() function aswell $ x, R1 r9 M8 N1 z: W5 d' t2 t# r- h3 M* k) g8 L/ r
################################% I# b. c4 X9 w- F7 d
##### Connection and Post ###### 3 x* c% ^' A, L8 v4 ?4 r! |################################9 z9 J( [9 ]* g0 J; L) ^% x
$name = @$_POST['char']; 9 f$ [6 V7 V8 Z0 \/ T; j3 {: m$ItemName = @$_POST['item_name']; * v2 b9 Q# \$ r; E$ItemAmount = @$_POST['item_amount'];- j& m& X- ~- f/ g- |
$ItemId = @$_POST['item_id']; : c! c+ p% i- t k$ItemUpgrade = @$_POST['item_upgrade'];4 y% V: { ~. g8 Z. H6 d
$ItemElement = @$_POST['item_element'];7 @+ ?9 x( L2 v) U/ w r; w- x
$ElementUpgrade = @$_POST['element_upgrade'];! R3 B! c+ J0 |; P
$ItemPierce = @$_POST['item_pierce']; 9 p9 R( Q) ]+ h2 l/ k3 n, {* J################################ 4 k# w( b0 y B5 M" ^! C4 u+ ]* T5 B, {. r( [# G
//Check both variables for empty value ?2 x/ B( B, Y2 A; ~0 d
5 d. {* A+ Y U5 Q3 s% `# zif (!empty($_POST['char'])){/ h+ T# [3 V4 y z Y+ c8 ?; L- N4 F
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where ! I- D3 Z+ I1 x6 |
3 X; r, f$ \3 hm_szName = '{$name}'"); m. Y+ T4 u- T; q* m
while ($row = mssql_fetch_object($find)){5 }+ Z) z7 e1 J9 L$ t5 s9 Q
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>"; # D, ? j6 C3 A$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], , P, M" y3 {7 N7 O ! H. ]% ^' V% {1 H; |+ D[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], * R) q* ?- `6 Z6 a5 D