|
|
<?php g2 w3 r2 q3 i( m6 o
function Connect () {
8 `9 K+ }$ P! f0 _0 \mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
D3 S+ j0 o4 y
* Z3 E+ `( c/ f/ X' V) I& VFailed.');
" e* \* {' b/ y3 D6 g. G}0 c) r0 b. y% R/ W
Connect();
( o# [7 O7 x! x9 W6 N
/ C" f c" K0 l6 Wfunction InitForm(){
0 P" a; h% H4 t//layout for the form, Y" g' _$ e4 A R5 E
echo "<strong>Send Items.</strong>
; a/ H# R: U% F3 I<form name='select' method='post'>/ s- ~; [! e2 b/ m- j y9 p
<lable>Character Name</lable><br/>
# F! [0 k! P3 ^2 }<input type='text' name='char'/><br/>
# A" {8 w* {, s% q( ]! E9 B+ L<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
: `; x, D+ P/ F; }* L<input type='text' name='item_name'/><br/>2 @, P* v3 v, C7 ^ W2 r7 G
<lable>Item Amount</lable><br/>! Q4 N1 X1 { {9 \3 F; J! t {. c; p
<input type='text' name='item_amount'/><br/>+ @0 f; e I+ ]; j Y
<lable>Item Upgrade Amount</lable><br/>
; M- h! s$ b: d4 ], ]<input type='text' name='item_upgrade'/><br/>
- |" a" m, M! G2 t, l<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)3 C- P. m3 k# `& M# p/ G0 z
8 s& S& y; m1 X% ~</lable><br/>) g3 |* a( G4 ], s
<input type='text' name='item_element'/><br/>
5 \0 l. I" U. A" y7 x<lable>Element Upgrade Amount</lable><br/>
' ~6 f: r- j6 j<input type='text' name='element_upgrade'/><br/>6 q5 i. D1 ~! y6 M& |/ x' a0 U8 ?
<lable>Pierced Amount</lable><br/>' n/ D( U, P/ O1 d: j) `& L
<input type='text' name='item_pierce'/><br/>
# G2 P$ o/ L: {) K# { \<input type='submit'/>
7 g' j* U1 h6 ~; u</form>";
2 n3 Y0 J) |0 t: s ]}
9 D0 _/ t( n6 L4 g7 {) i% E& M0 v' _9 G( q/ B
function PostListener (){
6 ?1 N0 ~$ f T4 L4 \2 M) @//Add more post variables if needed and add them to initform() function aswell
8 C5 c0 H# ^3 P
" Y$ a9 ]4 r8 {2 t1 _################################- d9 T. s {( b- j0 I* N1 J
##### Connection and Post ######% F" ^0 `. b! o J
################################; v; q0 d. ]9 s$ r5 Y, o& P) M& j! N
$name = @$_POST['char'];1 k0 X4 T" P. g' Z& p( h
$ItemName = @$_POST['item_name'];
. J* D: _$ w+ t; o4 f" Z; C" ^$ItemAmount = @$_POST['item_amount'];
, B+ r9 o! l$ t2 }0 `" @# n- u$ Q$ItemId = @$_POST['item_id'];
4 [% O' r# k4 d, W$ItemUpgrade = @$_POST['item_upgrade'];
1 A; Y. g* K1 F2 y$ItemElement = @$_POST['item_element'];
* e0 b5 v# ]6 X, j2 l6 [# v2 R9 f" n$ElementUpgrade = @$_POST['element_upgrade'];3 a. w9 {# U c E5 D( w
$ItemPierce = @$_POST['item_pierce'];0 F/ O5 I! {5 p9 g# u" E4 E( i# U
################################
+ N/ U9 S" z J$ Z! Z9 e' }2 F6 }) x, `! ^; t9 Z
//Check both variables for empty value
( I N3 L( D+ m$ {
n3 ^7 N4 e; F8 tif (!empty($_POST['char'])){
! ]1 h V0 j; ~( d! B, b$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where : F A$ I( X ^- V* k0 }- D, P) L
, I5 d0 v; P: T/ A
m_szName = '{$name}'");/ E/ e$ L8 g( M7 j. u6 f9 V
while ($row = mssql_fetch_object($find)){& u* E7 [6 ~# ]
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
! h _/ D; j- ~$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
4 G7 E) x% u4 s$ F7 c5 y( G; A
4 p! E X6 D, F9 V[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], H) A, s9 m9 r0 ?1 t8 O$ U& q
, c" a% a5 n* ^/ j# G0 [% @[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
+ `/ A# U- c: ~$ [6 Z- z- R r3 t2 G/ `6 F
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', 5 t2 u" c; P+ i8 H) p. ^; _
- D3 Y: h' {4 l, p, r) R. \'{$ElementUpgrade}', '{$ItemPierce}');");' D' `* Z/ I7 r Q) h% g! D
}0 \% t4 ~; J- X
6 a5 X, l9 X+ l7 L+ \; z
}- Y. {$ v5 y5 |" G
6 v' O+ N3 W8 }; f) x( X
}" ^8 V+ P% ~: c0 n* i
% C/ {3 M* c, @& |$InitForm = InitForm();; d' E3 s: D8 M$ L' ^
$Listener = PostListener();7 y2 H" j7 }& x& e* D
) d+ j' B( @2 Q1 ^4 J- d6 d?>0 F# Q, S, o6 a, q
5 [9 A8 n+ J/ Q( g! ^
( l8 X4 \& C4 d- [. q" c5 i
$ Y& v: o" x2 m m' ~5 U5 |( o8 Y, f
|
|