|
|
<?php
1 h; d+ ?1 J0 L: n% I1 ~2 H7 ]3 _function Connect () {
( I+ B( N. R! J& z' t' K% ~. omssql_connect('Server','UserName','Password') or die('Error: Connection to DB ' r9 A, e! {. P! M' W! r) a
0 W( ~( \3 }& p" F; f( l7 {Failed.');
+ L) F$ U2 _0 c' X}. d6 H. }" z! S6 z3 M& {! a# d
Connect();0 z4 ^9 T [3 e5 E2 g: e8 p E
/ c$ v& I" E4 u8 I2 A* efunction InitForm(){& u" e7 E% i F
//layout for the form
j$ V4 f8 r1 B6 F0 E# t; g, d+ Xecho "<strong>Send Items.</strong>
7 F" C- s& B% L. A8 b, q2 i' x<form name='select' method='post'>
' B3 q3 \! G; f6 o; x+ G9 H<lable>Character Name</lable><br/>3 a; B; {; `8 _1 V$ _* N
<input type='text' name='char'/><br/>
* C: ~+ l$ T% p/ ?* L3 q, C<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>/ i2 S) v0 b) }: E, S/ z
<input type='text' name='item_name'/><br/>
9 i+ `# [+ a- J2 p5 l) @2 {$ o<lable>Item Amount</lable><br/>1 S$ W/ B4 t X: v" S4 v8 o
<input type='text' name='item_amount'/><br/>) M: S( O0 n8 d% |3 N6 ^: k
<lable>Item Upgrade Amount</lable><br/>5 A) B0 ?* P7 \' L& E( l8 [
<input type='text' name='item_upgrade'/><br/>
6 H: Q+ f% R8 O" A<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
$ P; Y3 n# @. ]
' K/ D# D& d6 i5 p" J; @9 V</lable><br/>
0 @, A5 t, s! t<input type='text' name='item_element'/><br/>: e0 h) F. n" A5 `; }
<lable>Element Upgrade Amount</lable><br/>& |7 X, ?) Y1 `
<input type='text' name='element_upgrade'/><br/>: M* x b: s% e8 F& m( {& b, f4 d
<lable>Pierced Amount</lable><br/>! w( p2 k% C) G9 I' {+ v4 w
<input type='text' name='item_pierce'/><br/>
O% ?5 h& i+ C5 e) G5 ~5 m% }<input type='submit'/>
! `: f* a) u, S+ L" i; v</form>";4 |& a2 d/ K: u) H, k8 \1 z7 B
}4 \) J% y" b2 `# j8 @2 Y7 J
, A1 m: @* H0 R0 t( yfunction PostListener (){2 C$ _1 r" b: T. ?6 j/ K
//Add more post variables if needed and add them to initform() function aswell j* k4 o$ \3 X/ p# v! I; k) d
) Z1 o( s: P" l' j) e8 M* r################################
, i+ o8 I. W, y8 p$ {1 g% c0 X* X5 r##### Connection and Post ######
* S, z; Z2 Y- {! [8 M################################
3 w( A" {& V7 |' R/ o# h$name = @$_POST['char'];& b9 _- y( q. y6 W4 M; o$ ]% |
$ItemName = @$_POST['item_name'];
* ^7 C8 ]2 J, c( I w- l& M3 Q0 ]3 Q$ItemAmount = @$_POST['item_amount'];
. R! y3 y; m) H' M8 w U( X+ \# \$ItemId = @$_POST['item_id'];
- K, O( t* V+ G: I6 i$ItemUpgrade = @$_POST['item_upgrade'];8 a/ e0 O5 x- P2 ]% y
$ItemElement = @$_POST['item_element'];
! o y) a" R% E$ElementUpgrade = @$_POST['element_upgrade'];, l' M& `3 B `+ E
$ItemPierce = @$_POST['item_pierce'];
) h Z) U P; z) M c7 Q################################
8 V* j6 W1 d5 P8 G/ f
; s# Y+ }/ J/ S" `. M; ]5 ~2 v, ~//Check both variables for empty value2 U4 r4 E2 j. g) {2 L" L7 h) E
$ ]% |- d0 W9 L9 r; r. }
if (!empty($_POST['char'])){" B/ z3 O0 {. D9 Y
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
+ I' @# g- ~; G8 i0 D; X8 Q! C# a B3 L; T( j
m_szName = '{$name}'");
{5 G, p* L' G$ rwhile ($row = mssql_fetch_object($find)){
5 ~5 F7 I: `/ eecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
% r! v* W4 h i5 v$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
6 i. @3 u! F5 T9 D1 K# g
# N0 Q* P& `7 M6 w8 E[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
) B. U/ }/ [. K' W/ K/ J8 g- z2 u* `0 M. a( k1 B
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
) B7 T C1 m: O/ v* H# E' y
( I( q6 C& R Y1 zN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
1 H9 @; l( H/ B5 Q1 M2 P3 L: P- U2 J- v9 J& w z
'{$ElementUpgrade}', '{$ItemPierce}');");
' i5 M$ T- g7 j}
1 r3 o6 {8 ]1 Z$ @; {/ h
. i2 M8 }/ M# U: r" z, Y9 h}, o: r! V9 z- ~! X9 k0 R E) l
4 r3 ^% A5 ~3 Q! w" k
}
3 z f2 Q7 a0 G" g9 J" Z& V! d8 O# j/ C1 u! h, G, Z
$InitForm = InitForm();# z( p& G) o# u A' Q: L
$Listener = PostListener();
* {6 M$ z& q6 Q' o$ w% Q1 m/ X" c* H6 d! _# ?9 I
?>
( l/ q1 M! F' u5 S" g; V i$ I2 f" \
" O0 j/ R. r* `4 Y5 q& b& z* S) z, V" W G4 ~+ N9 N. V @
|. s; m u- f1 n6 n |
|