|
|
<?php
# G" r' y7 G4 f, s3 v5 K: Wfunction Connect () {
. n' C# E' M: d# _& Z3 X' \" x$ u- [mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
$ ^( q! {; ]8 I) E6 n9 A% N- b
( S5 `' g# H/ _6 W' ]- tFailed.');, ~ S- D$ `8 Q& \ F7 y9 o
}0 ^, R8 I; z7 G7 c z
Connect();# R/ v; g5 t, |- Y4 W
: R' i5 x% Z5 n' T
function InitForm(){* e- N: w" p3 n$ C
//layout for the form
5 d8 y1 l5 T3 a- o- n9 U1 ]/ P; Jecho "<strong>Send Items.</strong>' l& Z! I! n/ i4 H2 `
<form name='select' method='post'>
1 F2 T9 q- s% V0 M0 _5 ]<lable>Character Name</lable><br/>7 Y9 b/ V% H; x; K2 P$ ]6 r
<input type='text' name='char'/><br/>
) m. n! U1 M+ R0 Z) o# t<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
# \9 C; F6 n6 |6 M; \<input type='text' name='item_name'/><br/>
6 N/ N# p7 r) Z9 R& S9 H2 ]+ K<lable>Item Amount</lable><br/>
7 _" q7 G) ^# @ H. a, y* l3 l<input type='text' name='item_amount'/><br/>; T: V+ }7 E% e! A W
<lable>Item Upgrade Amount</lable><br/>1 h& e5 E* G; i- V1 u
<input type='text' name='item_upgrade'/><br/>
9 x! t0 Q$ `" l6 O" w8 e0 i0 {<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)2 X1 H7 \7 N8 q, U9 ~" N
: }; P6 L+ Y" h) t</lable><br/>
3 o- _/ A, L: g. X; g9 `/ O% N4 y. s<input type='text' name='item_element'/><br/>% n# @$ N0 S. Z" W9 A" S. y/ k6 }
<lable>Element Upgrade Amount</lable><br/>
L* ? T. N6 D: d: i4 w9 U<input type='text' name='element_upgrade'/><br/>
. P, n9 p: F$ I8 e* d: S<lable>Pierced Amount</lable><br/>- i$ [( Z0 |' k' w& ]
<input type='text' name='item_pierce'/><br/>
7 @# d: I$ v3 o9 t$ Q: u, l<input type='submit'/> `, I) L7 H% o# l; y5 q1 y" g
</form>";
' h8 J/ ?7 n) b& z/ G7 z' |}
W( l& o, ^9 D7 n8 c' w1 r n7 W7 I1 L
function PostListener (){
8 W& q9 f! u6 X( v9 }' |6 p0 J//Add more post variables if needed and add them to initform() function aswell
- ]/ E( M" u0 L# x: y
& X! }% i6 T1 i0 F: G################################
0 R0 J$ o3 i0 Y/ {9 \9 r! _##### Connection and Post ######/ |8 C2 r) A2 ?, C P R
################################/ @9 E: s/ G# O9 @( A6 n' U
$name = @$_POST['char'];" [1 \9 r1 `9 b; [; y( l C
$ItemName = @$_POST['item_name'];2 C0 z+ }* _" P* }
$ItemAmount = @$_POST['item_amount'];: ] U; H# `7 l+ P* [+ A
$ItemId = @$_POST['item_id'];5 X8 I; f4 `5 n9 T5 U: N- g1 r
$ItemUpgrade = @$_POST['item_upgrade'];
0 n% M) {% l; T# m3 K4 P$ItemElement = @$_POST['item_element'];- Y4 R( |7 h1 c$ Y: Q' w
$ElementUpgrade = @$_POST['element_upgrade'];
2 O( y3 ?4 T6 o: G$ItemPierce = @$_POST['item_pierce'];+ I6 T) ]5 s2 N1 e8 T. M1 D
################################
, A4 {. q, r r! K/ z& J( m6 Q3 @# p \+ J
//Check both variables for empty value- N# \! N! N8 S3 T/ a/ M* s( F
6 o: ~/ N9 B. ^8 v8 W4 I3 F
if (!empty($_POST['char'])){
5 Q+ r4 J% c3 I1 g5 i$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
8 S! @& E& D8 y8 S" X
/ @- y- B) k5 |0 |9 a0 Vm_szName = '{$name}'");& [5 j1 l U7 n; o7 i
while ($row = mssql_fetch_object($find)){$ h8 N$ K4 @* n! P( q
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
3 R' D2 P3 |' r& M" M& M% W$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
4 A/ _6 R5 `7 k" r$ k$ B
* s8 G. U& [+ Z[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], ; r* Q x5 O1 [: r
% U. s& l2 [$ I) m5 S) W8 P# @+ X[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', 8 f( D o+ Y+ w9 U
; q6 p* G# k) G' O3 z# o7 C c
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
$ B4 C0 p" j8 K1 r' q. m
$ }8 ]6 ]/ n7 x2 H/ P, j'{$ElementUpgrade}', '{$ItemPierce}');");
. u( X( o( h6 j4 i* ]}
' y' F' a, _+ ]. V" V0 V4 j$ E! _* Q- o+ `
}
P% q* Q: f, J8 \/ ?+ i& `+ L. `0 `/ N% j3 e, F
}
( y+ `8 j" Q; Z: b; W( S
( j9 a, \: g$ W @7 K$InitForm = InitForm();
4 U3 z$ I# h8 ]$Listener = PostListener();
( `+ N" y) ^. X4 w( X
0 W8 A4 O# k" K6 p?>* s% V( ]; v( S6 v# w! X
. z) A% V8 Q0 F' A [
% a! R/ d9 L" r0 T) i+ J" c, _, [4 @8 B. t
% t0 ?1 m _ I4 B1 L" Z* [, ` |
|