标题: 物品发送脚本 [打印本页] 作者: admin 时间: 2016-1-10 03:43 标题: 物品发送脚本 <?php 3 i" {7 n- J, ~( |function Connect () {9 U5 U* p+ J: G2 u. S3 D- y
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB ( Q& L; m6 x$ l- k3 `/ ^1 x* R. O- B& I
Failed.'); # p2 Z9 F+ _: p, O! Q: {} ' ]- Z. r- I4 E7 A1 l( B' i8 \Connect();3 x) b; Z9 b% k( D
' y7 {% A, R: l; @3 p9 ^function InitForm(){ 6 G) t* w" g; B$ M. Q//layout for the form ; ?1 J+ c* q+ m7 P' H9 j. F( P- fecho "<strong>Send Items.</strong> 0 d' @6 q0 m. {<form name='select' method='post'># u6 H- `5 Q1 k* ~4 M2 M
<lable>Character Name</lable><br/>! a6 o5 @; {! A8 I/ N) ^& ?
<input type='text' name='char'/><br/>. r4 ~8 I) d( D1 m4 Q% C5 W
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/> ) d7 x) q9 @9 Q% o7 R' z& ?$ t<input type='text' name='item_name'/><br/>2 ]: C# g# V$ d2 J [
<lable>Item Amount</lable><br/> 3 m& x! Z: t, T1 V# [) L<input type='text' name='item_amount'/><br/> 4 z8 j W% ]$ N9 n3 j* Q<lable>Item Upgrade Amount</lable><br/> 2 a$ I( q* Y6 v E6 \4 ]3 B<input type='text' name='item_upgrade'/><br/>1 k; E1 ]0 h2 ]) I% Z* g& [4 m4 C2 a5 s, _& _
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.) R# [+ i! r6 e/ N0 {
: F% r3 X1 }8 ]- J* K</lable><br/>7 W" w1 q3 M- `! ?2 M& v
<input type='text' name='item_element'/><br/> ' G- |& n& K v7 g<lable>Element Upgrade Amount</lable><br/>& s5 S1 U- h* t8 h! l" W( `5 r
<input type='text' name='element_upgrade'/><br/> , T. f6 b' J4 M. ]<lable>Pierced Amount</lable><br/> ( X8 l) B% E, i5 v4 v, V8 k<input type='text' name='item_pierce'/><br/>1 T- I$ E. P- z
<input type='submit'/>% C; C' }; A7 A0 [; ^
</form>";# a7 A4 }, W, w) T$ b
}5 A4 {! j7 T' T6 C5 {
0 O* k( V& b; \function PostListener (){2 j: T/ \& S+ P7 m8 c7 H. s3 m
//Add more post variables if needed and add them to initform() function aswell0 G9 w# m3 k1 C7 {9 O+ d7 e/ D" o6 G
5 i4 {6 k9 U+ a3 m7 k################################3 r4 @" g9 N- s7 d! _# q0 g; d
##### Connection and Post ######8 L: x, W* O% M- n( @5 a
################################ + E @/ e+ R3 J! l6 y! s5 v5 y1 P+ m6 h5 e$name = @$_POST['char']; 3 Z i- v7 _& W4 W; U- \$ItemName = @$_POST['item_name']; " z6 T; S3 W. X7 ]3 l# p7 U$ItemAmount = @$_POST['item_amount'];. F" Z6 o& _2 _- L
$ItemId = @$_POST['item_id'];' D' E9 @- r# b& A
$ItemUpgrade = @$_POST['item_upgrade'];0 t2 Q/ E8 i/ ^4 b: {" t4 P9 k7 G2 x
$ItemElement = @$_POST['item_element'];' [' R3 C( h2 @7 U5 P4 I2 E* B
$ElementUpgrade = @$_POST['element_upgrade'];. c& M7 m* ]& a" F
$ItemPierce = @$_POST['item_pierce']; " L5 m& p7 K$ v* N################################ K4 Q8 L9 h Y5 N2 y+ \- {8 w& C " g' ~2 U6 t* m7 h1 L//Check both variables for empty value + V8 l5 S% |7 v0 |3 D; c! o! |+ J j ^/ K& u# Y. |
if (!empty($_POST['char'])){2 h9 T) j$ z- i5 q/ `! j. y
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where ' Y* I+ D1 p) |( D+ ` w7 _3 K: e5 b2 r3 O
m_szName = '{$name}'"); 8 e: e% M8 x, ?while ($row = mssql_fetch_object($find)){. \% C& [* [: j; c! J; u
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>"; ( U. U. h% r4 U) Z" m1 ^$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], 9 B- f3 m; l1 G; T$ L
; V: A+ B1 `, z! `) s1 {7 O
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], 9 J; ^& X9 b5 T. Z* X5 J: J$ o 5 X6 R& g: m0 r* D6 s' e[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', % i( ^" l1 B4 K2 E# C- l* x
3 b: P# Y# {. ^( A% o, ]. Q
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', . X& G' k6 B! g7 P