|
<?php
1 P3 `+ `8 N* Y% tfunction Connect () {5 ~% s' q! T* F ~( D
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB r& t! t' V5 \
: s# {1 n$ Z5 \) C% H
Failed.');$ t! p `. [0 k/ t* r( m
}' r2 ^: M3 t$ M% r4 a8 r$ _
Connect();
4 \& K5 ?! v# Q1 z( _1 D' g1 Z* d( Z% n6 K' U, L0 b* S# d
function InitForm(){
5 ^2 U' y% i: [//layout for the form
4 ~ c) ]8 q+ X Fecho "<strong>Send Items.</strong>' \; X. j# _( r5 J+ J* Z5 `
<form name='select' method='post'>/ o" u6 i2 a; s5 s/ l
<lable>Character Name</lable><br/>
6 B: v# H4 P1 {+ ^# k) i8 q# |<input type='text' name='char'/><br/>
; C- i" R" |/ \5 B" h. q3 j# j; q<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>& j8 K& C* q- _- q
<input type='text' name='item_name'/><br/>
1 K A1 b1 v+ e<lable>Item Amount</lable><br/>
2 w# l( f% T0 S2 o" P) D<input type='text' name='item_amount'/><br/>5 q$ @" t/ F7 k/ e
<lable>Item Upgrade Amount</lable><br/>
) B+ F' ^" p% ~, {0 r( e( O<input type='text' name='item_upgrade'/><br/>$ a( w8 u( |. t
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)1 x' }# T; m3 V
$ }8 ~" I$ ]+ Z2 e2 Y% u7 o/ ]: T* `
</lable><br/>. r' [# _. @3 L6 X
<input type='text' name='item_element'/><br/>$ z: k3 o( Z# W4 ]/ w) _
<lable>Element Upgrade Amount</lable><br/>
: h3 m% C5 ^4 e- Y5 p2 A7 o<input type='text' name='element_upgrade'/><br/>
4 h" j- o, u# f4 V<lable>Pierced Amount</lable><br/>7 M, D+ z% Y9 u. T
<input type='text' name='item_pierce'/><br/>- R4 A$ N3 {' {& P4 _. o! n2 Z
<input type='submit'/>
& |) y# J! S( ?& ~( X</form>";
/ T; a; P6 E% A$ r& u}0 T% S- b5 J2 |) F7 e+ @
# A9 X) C& \/ [; _/ x3 k rfunction PostListener (){! ~% x9 d$ a; ?
//Add more post variables if needed and add them to initform() function aswell F2 {1 @8 ?, r& D5 Y3 @; z6 |) Y
7 M+ q+ v& `) k% O9 w7 L
################################' i1 I# L% J3 d; ?& [
##### Connection and Post ######
! Q/ g1 X7 C: U" Z7 f1 n/ w ?################################
0 u4 d& ^9 b, t3 T+ O0 u* Q$name = @$_POST['char'];# v# S/ b3 D8 a8 `, i8 v, H
$ItemName = @$_POST['item_name'];
2 i, `6 S' `. l4 z0 e% [$ItemAmount = @$_POST['item_amount'];( p: d8 j, t6 R& |
$ItemId = @$_POST['item_id'];( j3 e, y& c3 {4 G' Y
$ItemUpgrade = @$_POST['item_upgrade'];9 ]$ a3 q1 T" l- L! d6 H. I& K6 B
$ItemElement = @$_POST['item_element'];4 V0 z" k5 _( `( _8 M
$ElementUpgrade = @$_POST['element_upgrade'];% \( v" O3 D; D- r
$ItemPierce = @$_POST['item_pierce'];7 s0 Q" ]1 S% N. X- B
################################6 R1 z0 W+ H; m L" r0 X
- u7 `- O6 z/ L- P
//Check both variables for empty value
/ C: f) P' ^4 Z$ o* n
w) U( R8 @/ U0 \( k; [if (!empty($_POST['char'])){( a6 s+ W+ ~+ _0 {
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
9 y# ^# c% |1 S( u H" k1 Q) ^
. i$ f2 h, T" H( ]! km_szName = '{$name}'");/ @' S) Y+ {8 ]; l
while ($row = mssql_fetch_object($find)){
2 Q( r ]% b: |2 hecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
B: } M K: u; d& e; N+ y$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], * d( |0 Z# _+ Z+ J
, O+ E* I# K. x# r7 X. t
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
* Z+ Q' G z6 A m: L, p/ W- B0 r& ^2 X
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
: T, n9 Q$ `* \
. b6 V/ r' v: q/ n# c$ A/ L# ^9 HN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', 6 }. d; W, o# S1 Y' d6 P% c9 ~
$ |$ ^$ o' N2 v8 ]4 r
'{$ElementUpgrade}', '{$ItemPierce}');");
' Y/ K& f! |& j" O, t- _}0 S' b! z# O6 }4 [2 B$ C
9 q/ Y( j8 w- P* |" x}
1 \: m0 p1 z, x3 D2 Z4 P. M2 X. o, q
. a2 g, f/ Y4 {/ ^) ?}$ d( N7 F9 o5 n$ C9 h/ l
' l5 T k; z8 n- f
$InitForm = InitForm();1 d" R1 Q) L7 `. a8 P
$Listener = PostListener();0 X( `4 p" _3 g( F% i. j
. l. m5 p! e# r h9 i5 F?>. @- o+ @; O2 C- }; a) x, |
' S1 ~% V2 W) ^* E
( I$ g& [6 `& l& @& F% l# D% M
& u5 N l* r1 _( |1 T- ?! M
/ d- \% o+ G$ n1 G' a |
|