|
|
<?php
* D$ C+ `9 m9 k1 Ffunction Connect () {
" Q7 k) l( o4 omssql_connect('Server','UserName','Password') or die('Error: Connection to DB
* ?! I3 o3 O+ r8 x7 z# R& ?6 u1 I% R3 L1 i1 t
Failed.');' ?4 I/ X. T, D- a7 ?+ T M7 e
} z. @' x3 x2 |
Connect();
* N h7 _& j+ Z& v" C/ |. T; s( W1 |: D# A2 e3 a
function InitForm(){, X8 `' M5 T" T2 H7 r4 C, Y
//layout for the form
9 H @* N% M6 ]. v' F2 p" Hecho "<strong>Send Items.</strong>
' D8 Y$ E; Y& f D: a<form name='select' method='post'>
. _- |4 X. ^% n, l1 v<lable>Character Name</lable><br/>
6 N! Q) ]3 j- n1 B& r1 x7 K<input type='text' name='char'/><br/>
: O3 m; q/ D* t- d; C0 k7 O8 E<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
; S9 C* p) m( i$ W<input type='text' name='item_name'/><br/>, P% m* i* F& a; x# }# y1 z
<lable>Item Amount</lable><br/>. ~7 z3 p7 x; a
<input type='text' name='item_amount'/><br/>
3 O* h8 U0 m. u& ~<lable>Item Upgrade Amount</lable><br/>, q% O$ }, H4 J) ~& d5 Y; f, e
<input type='text' name='item_upgrade'/><br/>: L; K$ F0 Q( j7 a
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)" l c( w$ k/ L
0 o6 h/ C/ L2 n; M7 c8 S
</lable><br/>
) i) k' o, t: f3 g9 w. H<input type='text' name='item_element'/><br/>3 u: Q0 P/ Y$ L1 s. W h" r
<lable>Element Upgrade Amount</lable><br/>) a. l7 Y$ F6 p- \+ c9 K Z V
<input type='text' name='element_upgrade'/><br/>
5 t- o8 h; D4 t+ L+ [8 ~' \<lable>Pierced Amount</lable><br/>; X6 o& r d3 \5 ^+ q8 r1 r
<input type='text' name='item_pierce'/><br/>
0 v% b4 b. ~9 Z7 w<input type='submit'/>, f8 s4 q1 x/ u4 [3 y
</form>";: O, H& B0 p4 P! d* J, Y3 q& i: G7 C
}
! S+ z x& Y) j) t$ s( N
3 L5 z7 E5 e; \9 cfunction PostListener (){. X3 ]+ s+ ^4 {. F! D& E) z! d
//Add more post variables if needed and add them to initform() function aswell
; y# G: w" _; t4 p: o
. R2 K+ ^" Y$ `4 V4 v7 `1 t/ l################################
6 \% o% `- @. v9 W. j##### Connection and Post ######
# e4 L/ A% E$ A7 m################################6 l9 ~7 t. L2 X! o; }0 J4 T* }" k
$name = @$_POST['char'];
" R( {2 T) a9 F; D+ @: H$ItemName = @$_POST['item_name'];/ ?; u7 s8 F* J
$ItemAmount = @$_POST['item_amount'];# r$ ?+ q$ R1 D' R6 D6 w4 L
$ItemId = @$_POST['item_id'];5 p, W$ e8 O# |& Q0 {
$ItemUpgrade = @$_POST['item_upgrade'];9 N5 w" p" p( n. _1 S
$ItemElement = @$_POST['item_element'];
, {, K7 p a- t' m/ p. h0 X: N- W$ElementUpgrade = @$_POST['element_upgrade'];
& i5 J9 T$ K& E% {# p$ItemPierce = @$_POST['item_pierce'];
0 p/ x }9 W5 T. P1 V################################
! f8 D, L7 J+ o! I: l8 p9 }* g6 x" @# v8 ~% t6 v
//Check both variables for empty value. c- H2 N0 c- v# K4 Z+ e/ N
3 z# k: U" Z: ~$ j9 R0 xif (!empty($_POST['char'])){7 q/ Y7 @. P% J+ ?
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
8 U7 v9 u! a* j; i/ X0 o
5 D- U. O7 Y% ~- Ym_szName = '{$name}'");* ^& ]+ R- I, y2 O( j8 p* p2 O
while ($row = mssql_fetch_object($find)){# p% Z! [- w5 _
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
' K* [- T0 I) E' ?; @, e$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], / S! i7 d4 ^, {" h, ^) E
+ v. R; [2 {* {* @0 n. M' c5 N& u
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
# x5 |. Q9 I+ T4 V9 F# |" |% a: j: k* a& z1 J5 a1 b( K7 s' x
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
4 \4 R0 s6 u+ t+ V9 m
; x, [. f2 d. S0 X( q& A. RN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', 7 ]0 b' `5 V6 H% T
5 i/ `7 g4 b4 q" o, g6 @
'{$ElementUpgrade}', '{$ItemPierce}');");
- I6 s* c# ]/ g$ \# q2 ^}
8 j" c& R8 T7 S+ h$ C% f9 D% E$ ` z& ^$ u& ]" D
}7 |" N: c' K, E: e0 u9 l
$ I7 j2 n& ~9 k% Z2 W
}, _1 R- g* o8 y& h3 q3 [
8 u6 z. q9 b( S" A- M3 m& n
$InitForm = InitForm();/ s1 U) }& A% ^* W
$Listener = PostListener();, K) U. v. [3 e
7 I9 \, t. S6 ^- k?>: {6 ] e* q6 t$ W
, m( `; j4 `8 R3 {5 x k$ U* A8 u# z! ?8 A7 r% s: D# K1 d, s
. J3 h5 G: e2 r8 a9 Q* p U2 S+ K9 `* c& `. S4 g$ d
|
|