|
|
<?php
; Y* }& K) n9 ^( \( t1 {! ofunction Connect () {
4 a0 @7 K7 ^% [& o! g! r& ^% amssql_connect('Server','UserName','Password') or die('Error: Connection to DB : k: I: j7 h% |
9 |. T ^1 L8 p. V0 E, Q! lFailed.');
% o9 K9 ?5 d5 @1 ^/ z3 X/ w, M1 r}$ r3 Z+ O1 q" B9 T
Connect();
; v0 [; M( i6 B- |, s+ H3 g; u
7 W7 I- \# l. t: e2 Mfunction InitForm(){
4 b1 N0 l. { i b) m* v//layout for the form
! g9 b: c1 R8 o9 X- `+ }echo "<strong>Send Items.</strong>
: p& L. ` F! b* l3 N; G<form name='select' method='post'>
: Z, w/ f' w* _1 m) i; p+ x<lable>Character Name</lable><br/>0 X. k3 S1 T! W2 @0 u9 |5 ]
<input type='text' name='char'/><br/>
: j1 C7 r" ]: V N) V<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
1 H5 x: e6 S$ ]9 ^<input type='text' name='item_name'/><br/>$ f1 n/ A+ S2 w$ S) K5 I
<lable>Item Amount</lable><br/>
) x1 ?" B& c. k3 m6 z<input type='text' name='item_amount'/><br/>/ e4 m# u5 X: U0 w1 F6 L
<lable>Item Upgrade Amount</lable><br/>, p+ `: ^% X2 x* p9 Q/ a w. k
<input type='text' name='item_upgrade'/><br/>
" d, f. ^# S* j2 I7 \" r; w<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
0 Z! n4 E1 S" h* D. R7 P- e+ u) X7 s. A5 y
</lable><br/>4 A; a/ \8 ~0 {# {/ j2 `4 C X
<input type='text' name='item_element'/><br/>
6 q1 ]6 B1 x+ `2 `4 E% q9 j( c6 g<lable>Element Upgrade Amount</lable><br/>! _% D' e. ?# c; I# S
<input type='text' name='element_upgrade'/><br/>( u& i ^9 k0 p" @ k+ }8 b
<lable>Pierced Amount</lable><br/>+ b& `7 k- ?$ _3 v- x) f, {* t4 j1 F
<input type='text' name='item_pierce'/><br/>
- V$ F e! t& e, f. X) H c( C, q- t<input type='submit'/>
) E) W T1 q, }4 R1 w4 {</form>";
; ?6 E: [) \- t3 I0 Z/ w} m3 V9 q0 H* n% d( q* Z
1 m4 A9 z2 c+ r' z
function PostListener (){# E9 Q! e5 m' c0 [# _; m* {1 U
//Add more post variables if needed and add them to initform() function aswell
2 f8 U; v/ y7 E( d ?+ G; O8 f$ H; H: o2 B
################################- y" ^! m; x6 ^' p4 G- w; {- ~
##### Connection and Post ######
P& e. y p" K* I# P" ^2 n0 ~################################
/ B5 v2 g* X& n3 ^$name = @$_POST['char'];
% `6 k/ t' N% _5 l$ItemName = @$_POST['item_name'];
) W" j$ W' R+ G* U' Q$ItemAmount = @$_POST['item_amount'];& b8 z( |: R4 \9 F; F
$ItemId = @$_POST['item_id'];* J6 R/ x: B A$ @. A! D* L5 [
$ItemUpgrade = @$_POST['item_upgrade'];
2 @/ ?( [/ `- s( D; g; K$ItemElement = @$_POST['item_element'];
* S' y7 i4 r3 y `& R+ e$ElementUpgrade = @$_POST['element_upgrade'];% Q+ ?9 [( [! k
$ItemPierce = @$_POST['item_pierce'];6 b# }3 ^4 }+ x* ~
################################
) V. Y4 a3 [# `, [% E: @( h# Z; n- `
//Check both variables for empty value# r$ b- F. V* ]5 D2 U5 m2 R. `% W! S
: Z$ Y3 U$ d! n$ E2 g% {
if (!empty($_POST['char'])){9 o8 I; ~1 A) G
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where I/ `( q9 W; E. [: h# h; U
* x. |, [! @1 A& Mm_szName = '{$name}'");/ q* Y$ Z& A5 }( K
while ($row = mssql_fetch_object($find)){
+ z _3 y% P+ B( m. Secho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
: D" [4 p, X4 P. _- L$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
/ {( a5 ~0 V5 p: |0 P# c% B5 q. k: X0 G+ @; J; g7 G- R
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
1 q$ u" ?6 d; B4 f( r" R0 U8 h
8 s7 }! a2 _1 R7 T0 [" l. p' M& {[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', : u. _+ a" L$ O% e; C7 d
( H$ l8 g- w, K) Q% }" _
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
3 s: o# C8 p4 R# `: E' K U
& T* \& J- L- C+ F0 ~'{$ElementUpgrade}', '{$ItemPierce}');");6 \+ r. G+ ?7 G2 O* N: S, Z
}6 z! }! ?3 V- J8 C. ]# w
0 E' A/ c1 W5 h( D% |; ^}% g5 E& u, Z; S2 r1 y4 _* |/ l1 |
' d& h+ V) M2 c: Q! D8 y}
% H5 E4 f: X. o0 `* b0 \ q5 b
D: _, ]# X! ]3 v* r4 U1 `$InitForm = InitForm();& d3 `7 L0 Y0 }$ A- ^, l
$Listener = PostListener();# n: N( W. ^- e: H2 ]& V
; g' U" X1 Z6 g P: Q
?>
4 m* m; W3 B4 J5 ?& e
, Z) w" X# |) X* C- l4 B" B& ~2 [% v9 c5 h% o/ M p. K9 W. p8 @) a
! {+ x C6 `; |, [3 o! j. J9 x
6 m& \: L8 l- b! h# o |
|