标题: 物品发送脚本 [打印本页] 作者: admin 时间: 2016-1-10 03:43 标题: 物品发送脚本 <?php " q# d2 v4 T( i3 mfunction Connect () { F( E7 \3 O1 y5 T8 X
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB 7 N* R- m' `9 i8 [ k1 y7 ]+ \
8 @0 R' H, j/ T3 w) c- d
Failed.'); # g- a. p3 G# }) m& K}, y& O- H' y+ f5 P# L8 R
Connect(); 6 c, `" F# Q. S, P; Q) h$ k1 g; [
function InitForm(){ & b; V7 J4 F( R$ ]6 X//layout for the form ) n2 l& Q; s8 q, l. V$ ?4 vecho "<strong>Send Items.</strong> # [7 f9 v5 h& V$ Y% h0 N& F<form name='select' method='post'> 6 o; |5 ^" P# w$ G5 H( |' H<lable>Character Name</lable><br/> * u7 I+ l5 P+ [- e<input type='text' name='char'/><br/>" j4 C9 E2 J' K, _& f+ J$ t
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>' ^6 y$ L, h( n z! w
<input type='text' name='item_name'/><br/> # K% d9 l7 `0 M<lable>Item Amount</lable><br/>5 a! T1 a0 y* p# h7 Y$ U x
<input type='text' name='item_amount'/><br/>6 A- X+ d; \8 l- s
<lable>Item Upgrade Amount</lable><br/> 3 y) B B5 ]# N( l<input type='text' name='item_upgrade'/><br/>/ |3 z2 A1 [: I, N9 U7 W
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)* `8 \4 \% \0 ?2 N$ {
8 i! Z- s/ N, M& B$ m s</lable><br/> 2 F& p: R- [0 \, @; e$ G* _<input type='text' name='item_element'/><br/> $ b7 J' P$ i* p; f: I( @$ _<lable>Element Upgrade Amount</lable><br/>- k/ A9 M7 `# B7 v
<input type='text' name='element_upgrade'/><br/>. w0 d; J$ ~/ U; L* \2 W6 `
<lable>Pierced Amount</lable><br/> 8 P" \* g: X1 f/ D<input type='text' name='item_pierce'/><br/> - \$ l2 p C2 B<input type='submit'/>+ }6 t+ {; e- m& l" f; S! [
</form>"; / W4 e3 A' H; m5 D' a0 G' M}9 c, x( O8 n. P( g- N) s
7 l5 d& M1 I1 }, M
function PostListener (){1 g8 p4 |) k* t3 H7 F
//Add more post variables if needed and add them to initform() function aswell z$ u9 M( E: g u" U& E. ?* u. L* S
################################8 R- ]; S- |2 \" X1 A
##### Connection and Post ###### 8 h) k4 [ m: v5 V, {################################ E2 {2 x F u$name = @$_POST['char']; 4 u, m y ^2 N q$ItemName = @$_POST['item_name']; / A! v: E, U3 n1 o! z* G/ Q$ItemAmount = @$_POST['item_amount'];. A. L# b( }2 U' C: u# Q+ @
$ItemId = @$_POST['item_id']; z% k, D, ?9 {
$ItemUpgrade = @$_POST['item_upgrade']; ; l' {' S* H& f+ r9 R$ItemElement = @$_POST['item_element'];+ ~+ S7 M7 W: @7 ]& h/ [
$ElementUpgrade = @$_POST['element_upgrade']; ) d ?* J+ S4 b2 v @$ItemPierce = @$_POST['item_pierce']; 4 l& z4 j- \" K" z+ j################################ ) V8 U+ [9 z7 D# e: x$ L$ |, G5 B1 i _9 u( }+ r
//Check both variables for empty value$ f- s. ]$ O$ g; n" \/ M0 e
2 A' C# D2 f6 @0 P, a, y) U
if (!empty($_POST['char'])){7 P8 E% a8 G, z* o: Z: g1 L
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where 2 p7 E1 a' t4 o( }" d4 \
1 S4 G. B* X [+ v6 C. |$ Jm_szName = '{$name}'");/ c! D! N8 W/ P0 |5 Q
while ($row = mssql_fetch_object($find)){, Q7 p E( \5 r h
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>"; ) y7 ? @: V$ b- e/ h; V' w$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], 9 u. x1 Y) ~6 E
+ I# h. Y: @2 s) [[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], * C& {' W) G7 E 9 D% B. U1 L4 G, ^[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', u5 L+ M7 s8 V$ l# A2 g1 ^3 d
$ W1 h- q, Y7 T8 l
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', : m0 B- B9 e" G F& W* N7 B3 H 8 o3 l6 K& J6 s# e, s; j'{$ElementUpgrade}', '{$ItemPierce}');"); ; V( Z$ `* p$ ~ ?}1 w O3 k# j: m: B4 `
+ [7 o5 t" ?2 v}8 P! g0 O* y; u( w% C
; a1 T: w6 v8 w. ]5 H: j& O
}9 \& l# ]2 R9 E9 W+ n3 d5 Z