|
|
<?php
9 B! H! S; _, yfunction Connect () {
7 O( ?3 h; Y. Q# K8 nmssql_connect('Server','UserName','Password') or die('Error: Connection to DB
8 i+ U: Z0 M0 l1 N3 n% `' R" S& A }
Failed.');$ v0 H% Z( l5 P5 h$ j# i! z' q
}
# G( |, _) [" f% V, JConnect();
4 T* [- i1 p# w1 z: ? }" Q
; y3 z L' J- Hfunction InitForm(){
5 ~$ S4 R- O4 ?//layout for the form
F! b* a4 K9 }7 R9 M! d2 iecho "<strong>Send Items.</strong>
' Q; b/ p3 a7 n. p9 m2 M& l+ X<form name='select' method='post'>0 t* j! M t# h
<lable>Character Name</lable><br/>
* Z4 |2 c1 W$ k: k<input type='text' name='char'/><br/>. R) z9 j; I# z
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>+ P0 N9 c B$ t- u
<input type='text' name='item_name'/><br/>
; v3 k$ s" Q9 c' X<lable>Item Amount</lable><br/>+ B* k4 b2 {- g, t5 v9 p$ N' t
<input type='text' name='item_amount'/><br/>
3 `. r& H5 t% S/ ~$ Y4 I& w<lable>Item Upgrade Amount</lable><br/>
( z9 T( V! l' X2 v3 R/ q. ?+ u# i% N: a<input type='text' name='item_upgrade'/><br/>9 Q. U1 m. @" @4 i6 U+ o7 Z6 \- l
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)" P0 w! Q. S, ]: s
! t6 a. x+ U+ @- b
</lable><br/>1 L6 H( u7 M6 O& R7 Q A
<input type='text' name='item_element'/><br/>
4 J3 S& r$ b/ X. M1 t3 x<lable>Element Upgrade Amount</lable><br/>
: ]6 l& G4 M3 Z3 e; a# l<input type='text' name='element_upgrade'/><br/>
4 }/ {5 y3 C* j<lable>Pierced Amount</lable><br/>) ?7 Q) Z/ v2 j. |. ~. T7 x
<input type='text' name='item_pierce'/><br/>
^: A( n% B% d9 ~, }' [<input type='submit'/>0 I9 W D( \. T5 U
</form>";
& a' ^( N0 g. ~3 y' [7 p6 {7 [# G* L}- Z# r, G# a+ M% `3 c; G* N9 n
7 P1 z, \! \6 @+ A* a- z; n& k
function PostListener (){
8 a+ J l' q: K/ g& m5 F8 h//Add more post variables if needed and add them to initform() function aswell: F6 y C" u: ^7 m
w: D8 I' K9 k################################" H: L9 @% i: V% i3 C
##### Connection and Post ######+ j9 X# L% B4 g: R+ e. K" ` S. l$ B
################################
, [" V0 [2 t! O* B$name = @$_POST['char'];
5 @4 w# m( r; k4 C7 F( U4 Z) B: ~$ItemName = @$_POST['item_name'];
* Y0 y$ I1 b$ t' W6 z" b, F9 M4 J$ItemAmount = @$_POST['item_amount'];! D+ |+ _ Z1 P1 \1 |: U
$ItemId = @$_POST['item_id'];( k8 D1 H' [: a: }6 o3 m! r# {) c
$ItemUpgrade = @$_POST['item_upgrade'];
9 {. H$ `# X4 r2 x9 D; b- K3 m$ItemElement = @$_POST['item_element'];1 d+ F$ C3 e; d' l
$ElementUpgrade = @$_POST['element_upgrade'];
6 Z5 C0 a5 E4 M$ItemPierce = @$_POST['item_pierce'];+ j- V2 z" u% }/ j8 U/ b, O; I7 `
################################
) y. T- F1 Z5 G3 z6 k; m+ s
' O, p1 t) x _* e0 w, f//Check both variables for empty value' E# E) c: D! j3 H d
/ J* [, ~; d2 @. r8 oif (!empty($_POST['char'])){
5 _9 V9 K. ^! f3 \" q$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where ; t% P$ |9 S0 l$ D0 q
4 h5 M2 ?: b1 G J; j# p1 v1 w; K. g
m_szName = '{$name}'"); v5 ~. G2 {% w. Z& u5 _. Q, Q) \
while ($row = mssql_fetch_object($find)){ C$ E% Q8 {, A* F0 u
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
0 H& Y {$ G% v$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], # W) p2 H+ j, j% _( Q+ Y* l
0 P, t) C9 A3 p+ [/ j[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], ( v0 k% `" @( Y. G1 G% K& n2 N0 U x
2 a: ?# @* Q/ j: c, K7 ~+ Z" E/ U[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
2 Q, s9 F. F7 N% c3 A; d) J* O& @4 ?8 [- q. G6 n$ e; s* ~
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', 6 i) P' `; C, v" {0 Z
$ E, C9 |1 N8 I+ x0 [! S5 h
'{$ElementUpgrade}', '{$ItemPierce}');");7 B% S! C$ a/ Q) C
}0 F$ d7 }. u: y2 h- F
- x1 T Y& |* K+ N}$ T4 e' o; f) H( E9 ?! d
# c# M" V0 G" E0 _6 {5 i* K
}+ X- W: j% ~4 u
7 j8 M' E; h1 M+ J. \$InitForm = InitForm();
e' w9 d5 H% e: B- S+ a/ ^; R$Listener = PostListener();: g! P6 B9 j7 h4 A* X6 v2 E
0 ?1 t+ }8 {0 { W. c7 I0 V. ??>0 ?1 A, i( T& _: ]- I- S+ t
; H6 j; Q6 v9 a* a9 n- L4 n% V; P$ Y4 ?) B% v0 [
# J" f2 L- @0 n, g- n
4 B4 K2 i) |- x: [* v |
|