|
|
<?php
( F2 P5 D' ` jfunction Connect () {
; x$ {3 K r) w5 hmssql_connect('Server','UserName','Password') or die('Error: Connection to DB
5 i, I- @8 D+ d# k7 u$ f. _$ L) L5 V) x0 V& c
Failed.');- T/ V& C+ I$ ~6 y
}
7 R2 ~4 n7 A: A/ M- e4 D" M g h# PConnect();
& ^3 i7 C. D. a1 w6 K' n' u7 h6 A6 j
function InitForm(){
( ^# f% s2 p- ^ G' d$ H& |//layout for the form
& _. G! l S7 s: l/ B8 `( Aecho "<strong>Send Items.</strong>
. y( X% X8 \8 m0 |' n: T<form name='select' method='post'>8 P7 z8 D- {& N! F' u
<lable>Character Name</lable><br/>
& @1 ?4 [9 R% E3 L) @" i<input type='text' name='char'/><br/>
7 S O9 b% J8 L4 n& g* m- v' G' |5 K<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>1 v5 @1 T( Z# b6 y
<input type='text' name='item_name'/><br/>
5 b# t7 K% M, N) ~<lable>Item Amount</lable><br/>
: N+ P: H! D$ K$ p [<input type='text' name='item_amount'/><br/>
; S6 |: |* I Y1 G1 `<lable>Item Upgrade Amount</lable><br/>
3 X: u T- l) Z7 l% S+ I<input type='text' name='item_upgrade'/><br/>
: a; s. u9 j; L7 C; c<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)# M! p+ w9 \' v$ t A8 f7 m
8 n, Z4 z, z. D3 A' K5 }: T6 \
</lable><br/>
3 r. _6 d( B0 J) J. F, W" b0 D<input type='text' name='item_element'/><br/>
?0 p# x& i% n1 p6 b/ U M<lable>Element Upgrade Amount</lable><br/>/ i, M! F! C! r$ T `7 @
<input type='text' name='element_upgrade'/><br/>
) L- N1 Z# m+ r$ C8 ?) U; `7 B" P8 c$ U<lable>Pierced Amount</lable><br/>
7 w3 }4 J- b+ I0 g, y<input type='text' name='item_pierce'/><br/>
w2 G; U! ~( g4 y' N/ j- R- c" j1 x<input type='submit'/>" K, C2 m0 l% h5 h
</form>";6 p/ E: h% X, Z2 q( z
}
9 x8 l% Q. C$ A& a
H' A* t9 Z X0 N* w' Z+ ?function PostListener (){
( s4 q9 p p0 F7 o//Add more post variables if needed and add them to initform() function aswell
4 h7 M+ L( l( O p2 E: m1 d& b
# l$ i( `4 x3 |4 m################################
0 p9 M# }/ c, B' Z9 j" t##### Connection and Post ######
8 ]; h; j5 [3 c9 i' Q7 T################################" N; i7 ~5 p Q* e5 ]6 S9 E
$name = @$_POST['char'];$ u5 L) k# n# P5 A* L' N8 a
$ItemName = @$_POST['item_name']; T" x) x/ @* T3 K. Z6 A2 l% j
$ItemAmount = @$_POST['item_amount'];( h% L8 A6 c2 F% {
$ItemId = @$_POST['item_id'];
, {& [7 k( P' p$ItemUpgrade = @$_POST['item_upgrade'];+ d6 T( X _8 C; L6 I9 m
$ItemElement = @$_POST['item_element'];
" I! K( N2 `1 b# o4 ?0 q. X$ElementUpgrade = @$_POST['element_upgrade'];
/ l; _2 r4 t; ]' }! @( L$ItemPierce = @$_POST['item_pierce'];' N1 u1 T- e; @- Y4 L1 I# v
################################9 B9 l, z/ I* b7 j* y& z3 O+ H; o
4 @7 g! Q" e4 n( t
//Check both variables for empty value
! e. o( I6 J: E! }2 x# K2 d+ r, W7 N* E$ B3 c) ^
if (!empty($_POST['char'])){4 K; z* h7 y A; W9 ]
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where 6 E- X3 r! b; w
, {# g. u3 |1 ]
m_szName = '{$name}'");- h8 K b5 M0 i; A! n) t D/ {
while ($row = mssql_fetch_object($find)){
* C# Q* S1 c7 H( Q$ {/ recho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";+ _; P4 r6 a& B1 T" Z, n" s
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
/ V( M) G. Q* U! u' w1 s9 N0 }8 Y6 u7 R1 @/ k$ b0 [
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], - ]4 a2 X! y3 }; P* w
3 \$ z2 \& o1 E" j& D, Y
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', . }) T$ V; W7 s& [: M* o' V! O
: p& W; Q2 J: Z/ }8 U
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', , v% _0 k6 D; p
: T: |5 F3 E" c2 {& y3 n$ _
'{$ElementUpgrade}', '{$ItemPierce}');");
- A: [$ \0 y# g' \6 l. P4 d}
- [3 B7 [+ a4 M q/ t# N; j8 G
; o- s* b# A8 j: Y5 D8 V! I2 t}
- l: D3 p# g+ n0 B
, K6 l+ `3 J5 F4 N& y. `# m}
4 `# S- n' B5 M( e
2 W/ j5 z8 w8 I& v$ N$InitForm = InitForm();2 z* f: {. D2 j3 t3 f1 {3 E
$Listener = PostListener();4 w. ?( r; M e; w! D* t' E5 L
+ m* r, e" r1 N9 Y0 T2 H?>( a! ~4 ]' E5 D( `3 [) G5 W
: [. h1 Z9 v7 ]% e1 v! O. L
8 l: V; X* p! `( V2 D/ ?) T. v$ r$ k
^( L! w6 O1 O, M- X1 H1 t% r
|
|