간이몰 스킨에서요..문의드립니다..ㅠㅠ 정보
간이몰 스킨에서요..문의드립니다..ㅠㅠ
본문
간이몰 스킨에서 부가옵션가격을 더 추가를 하고 싶은데요..
--------------------------------------------------------------------------------------------
view 화면에서
96번째줄에
<?
$cn=0;
for($i=1;$i<10;$i++) {
if($view["wr_opt{$i}_price"]) {
$cn++;
?>
<tr>
<td><font color="#7A8FDB"><?=$view["wr_opt{$i}_name"]?></font></td>
<td><?=number_format($view["wr_opt{$i}_price"])?>
<input type=hidden name=wr_opt<?=$i?>_price value='<?=$view["wr_opt{$i}_price"]?>'>
<input type=checkbox name=chk_opt<?=$i?> value='1' onclick='add_sum()'>
</td>
</tr>
<? } ?>
<? } ?>
--------------------------------------------------------------------------------------------
write.skin.php파일의122번째줄에서
--------------------------------------------------------------------------------------------
<tr><td colspan=2 height=1 class='w_line'></td></tr>
<tr><td style='padding-left:20px; height:30px;'><span class='w_text'>· 부가옵션가격</span></td>
<td><input type=text name=wr_opt1_name class='input' style='IME-MODE: active' value='<?=($w=='u')?$write[wr_opt1_name]:"";?>'> :
<input type=text name=wr_opt1_price class='input' style="width:60;" dir='rtl' style='IME-MODE: inactive;' onkeyup='this.value=numchk(this.value);' value='<?=$write[wr_opt1_price]?>'>원
<input type=text name=wr_opt2_name class='input' style='IME-MODE: active' value='<?=($w=='u')?$write[wr_opt2_name]:"";?>'> :
<input type=text name=wr_opt2_price class='input' style="width:60;" dir='rtl' style='IME-MODE: inactive;' onkeyup='this.value=numchk(this.value);' value='<?=$write[wr_opt2_price]?>'>원<br>
<input type=text name=wr_opt3_name class='input' style='IME-MODE: active' value='<?=$write[wr_opt3_name]?>'> :
<input type=text name=wr_opt3_price class='input' style="width:60;" dir='rtl' style='IME-MODE: inactive;' onkeyup='this.value=numchk(this.value);' value='<?=$write[wr_opt3_price]?>'>원
<input type=text name=wr_opt4_name class='input' style='IME-MODE: active' value='<?=$write[wr_opt4_name]?>'> :
<input type=text name=wr_opt4_price class='input' style="width:60;" dir='rtl' style='IME-MODE: inactive;' onkeyup='this.value=numchk(this.value);' value='<?=$write[wr_opt4_price]?>'>원
<input type=text name=wr_opt5_name class='input' style='IME-MODE: active' value='<?=$write[wr_opt5_name]?>'> :
<input type=text name=wr_opt5_price class='input' style="width:60;" dir='rtl' style='IME-MODE: inactive;' onkeyup='this.value=numchk(this.value);' value='<?=$write[wr_opt5_price]?>'>원
<input type=text name=wr_opt6_name class='input' style='IME-MODE: active' value='<?=$write[wr_opt6_name]?>'> :
<input type=text name=wr_opt6_price class='input' style="width:60;" dir='rtl' style='IME-MODE: inactive;' onkeyup='this.value=numchk(this.value);' value='<?=$write[wr_opt6_price]?>'>원
<input type=text name=wr_opt7_name class='input' style='IME-MODE: active' value='<?=$write[wr_opt7_name]?>'> :
<input type=text name=wr_opt7_price class='input' style="width:60;" dir='rtl' style='IME-MODE: inactive;' onkeyup='this.value=numchk(this.value);' value='<?=$write[wr_opt7_price]?>'>원
<input type=text name=wr_opt8_name class='input' style='IME-MODE: active' value='<?=$write[wr_opt8_name]?>'> :
<input type=text name=wr_opt8_price class='input' style="width:60;" dir='rtl' style='IME-MODE: inactive;' onkeyup='this.value=numchk(this.value);' value='<?=$write[wr_opt8_price]?>'>원
<input type=text name=wr_opt9_name class='input' style='IME-MODE: active' value='<?=$write[wr_opt9_name]?>'> :
<input type=text name=wr_opt9_price class='input' style="width:60;" dir='rtl' style='IME-MODE: inactive;' onkeyup='this.value=numchk(this.value);' value='<?=$write[wr_opt9_price]?>'>원
<input type=text name=wr_opt10_name class='input' style='IME-MODE: active' value='<?=$write[wr_opt10_name]?>'> :
<input type=text name=wr_opt10_price class='input' style="width:60;" dir='rtl' style='IME-MODE: inactive;' onkeyup='this.value=numchk(this.value);' value='<?=$write[wr_opt10_price]?>'>원
</td>
</tr>
<tr><td colspan=2 height=1 class='w_line'></td></tr>
<? if($w=='u') { ?>
<script>
var f = document.fwrite;
f.wr_price.value=number_format(f.wr_price.value);
f.wr_opt1_price.value=number_format(f.wr_opt1_price.value);
f.wr_opt2_price.value=number_format(f.wr_opt2_price.value);
f.wr_opt3_price.value=number_format(f.wr_opt3_price.value);
f.wr_opt4_price.value=number_format(f.wr_opt4_price.value);
f.wr_opt5_price.value=number_format(f.wr_opt5_price.value);
f.wr_opt6_price.value=number_format(f.wr_opt6_price.value);
f.wr_opt7_price.value=number_format(f.wr_opt7_price.value);
f.wr_opt8_price.value=number_format(f.wr_opt8_price.value);
f.wr_opt9_price.value=number_format(f.wr_opt9_price.value);
f.wr_opt10_price.value=number_format(f.wr_opt10_price.value);
</script>
<? } ?>
--------------------------------------------------------------------------------------------
config.php파일에서
--------------------------------------------------------------------------------------------
// 2006-02-22 필드추가
@mysql_query(" ALTER TABLE `$write_table`
ADD `wr_type1` TINYINT NOT NULL,
ADD `wr_type2` TINYINT NOT NULL,
ADD `wr_type3` TINYINT NOT NULL,
ADD `wr_type4` TINYINT NOT NULL,
ADD `wr_type5` TINYINT NOT NULL,
ADD `wr_price` INT NOT NULL,
ADD `wr_opt1_name` VARCHAR(30) NOT NULL,
ADD `wr_opt1_price` INT NOT NULL,
ADD `wr_opt2_name` VARCHAR(30) NOT NULL,
ADD `wr_opt2_price` INT NOT NULL,
ADD `wr_opt3_name` VARCHAR(30) NOT NULL,
ADD `wr_opt3_price` INT NOT NULL,
ADD `wr_opt4_name` VARCHAR(30) NOT NULL,
ADD `wr_opt4_price` INT NOT NULL,
ADD `wr_opt5_name` VARCHAR(30) NOT NULL,
ADD `wr_opt5_price` INT NOT NULL,
ADD `wr_opt6_name` VARCHAR(30) NOT NULL,
ADD `wr_opt6_price` INT NOT NULL,
ADD `wr_opt7_name` VARCHAR(30) NOT NULL,
ADD `wr_opt7_price` INT NOT NULL,
ADD `wr_opt8_name` VARCHAR(30) NOT NULL,
ADD `wr_opt8_price` INT NOT NULL,
ADD `wr_opt9_name` VARCHAR(30) NOT NULL,
ADD `wr_opt9_price` INT NOT NULL,
ADD `wr_opt10_name` VARCHAR(30) NOT NULL,
ADD `wr_opt10_price` INT NOT NULL,
ADD `wr_transport` MEDIUMTEXT NOT NULL ");
--------------------------------------------------------------------------------------------
write_update.skin.php파일에서
--------------------------------------------------------------------------------------------
$wr_price = ereg_replace(',','',$wr_price);
$wr_opt1_price = ereg_replace(',','',$wr_opt1_price);
$wr_opt2_price = ereg_replace(',','',$wr_opt2_price);
$wr_opt3_price = ereg_replace(',','',$wr_opt3_price);
$wr_opt4_price = ereg_replace(',','',$wr_opt4_price);
$wr_opt5_price = ereg_replace(',','',$wr_opt5_price);
$wr_opt6_price = ereg_replace(',','',$wr_opt6_price);
$wr_opt7_price = ereg_replace(',','',$wr_opt7_price);
$wr_opt8_price = ereg_replace(',','',$wr_opt8_price);
$wr_opt9_price = ereg_replace(',','',$wr_opt9_price);
$wr_opt10_price = ereg_replace(',','',$wr_opt10_price);
$sql = "UPDATE $write_table
SET wr_type1 = '$wr_type1',
wr_type2 = '$wr_type2',
wr_type3 = '$wr_type3',
wr_type4 = '$wr_type4',
wr_type5 = '$wr_type5',
wr_price = '$wr_price',
wr_opt1_price = '$wr_opt1_price',
wr_opt2_price = '$wr_opt2_price',
wr_opt3_price = '$wr_opt3_price',
wr_opt4_price = '$wr_opt4_price',
wr_opt1_name = '$wr_opt1_name',
wr_opt2_name = '$wr_opt2_name',
wr_opt3_name = '$wr_opt3_name',
wr_opt4_name = '$wr_opt4_name',
wr_opt5_name = '$wr_opt5_name',
wr_opt6_name = '$wr_opt6_name',
wr_opt7_name = '$wr_opt7_name',
wr_opt8_name = '$wr_opt8_name',
wr_opt9_name = '$wr_opt9_name',
wr_opt10_name = '$wr_opt10_name',
wr_transport = '$wr_transport'
WHERE wr_id = '$wr_id' ";
sql_query($sql);
?>
--------------------------------------------------------------------------------------------
이렇게 추가를 했는데 오류가 나오더라구요..ㅜㅜ
--------------------------------------------------------------------------------------------
UPDATE g4_write_menu10 SET wr_type1 = '', wr_type2 = '', wr_type3 = '', wr_type4 = '', wr_type5 = '', wr_price = '3231232', wr_opt1_price = '21321', wr_opt2_price = '12312', wr_opt3_price = '3123', wr_opt4_price = '23', wr_opt1_name = '213', wr_opt2_name = '3123', wr_opt3_name = '312', wr_opt4_name = '123123', wr_opt5_name = '12312', wr_opt6_name = '3', wr_opt7_name = '123', wr_opt8_name = '123213', wr_opt9_name = '123', wr_opt10_name = '1321123', wr_transport = '123' WHERE wr_id = '12'
1054 : Unknown column 'wr_opt5_name' in 'field list'
error file : /bbs/write_update.php
--------------------------------------------------------------------------------------------
이런 오류가 나오는데..
부가옵션가격을 추가할려면 어떻게 해야하나요??ㅠㅠ
--------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------
view 화면에서
96번째줄에
<?
$cn=0;
for($i=1;$i<10;$i++) {
if($view["wr_opt{$i}_price"]) {
$cn++;
?>
<tr>
<td><font color="#7A8FDB"><?=$view["wr_opt{$i}_name"]?></font></td>
<td><?=number_format($view["wr_opt{$i}_price"])?>
<input type=hidden name=wr_opt<?=$i?>_price value='<?=$view["wr_opt{$i}_price"]?>'>
<input type=checkbox name=chk_opt<?=$i?> value='1' onclick='add_sum()'>
</td>
</tr>
<? } ?>
<? } ?>
--------------------------------------------------------------------------------------------
write.skin.php파일의122번째줄에서
--------------------------------------------------------------------------------------------
<tr><td colspan=2 height=1 class='w_line'></td></tr>
<tr><td style='padding-left:20px; height:30px;'><span class='w_text'>· 부가옵션가격</span></td>
<td><input type=text name=wr_opt1_name class='input' style='IME-MODE: active' value='<?=($w=='u')?$write[wr_opt1_name]:"";?>'> :
<input type=text name=wr_opt1_price class='input' style="width:60;" dir='rtl' style='IME-MODE: inactive;' onkeyup='this.value=numchk(this.value);' value='<?=$write[wr_opt1_price]?>'>원
<input type=text name=wr_opt2_name class='input' style='IME-MODE: active' value='<?=($w=='u')?$write[wr_opt2_name]:"";?>'> :
<input type=text name=wr_opt2_price class='input' style="width:60;" dir='rtl' style='IME-MODE: inactive;' onkeyup='this.value=numchk(this.value);' value='<?=$write[wr_opt2_price]?>'>원<br>
<input type=text name=wr_opt3_name class='input' style='IME-MODE: active' value='<?=$write[wr_opt3_name]?>'> :
<input type=text name=wr_opt3_price class='input' style="width:60;" dir='rtl' style='IME-MODE: inactive;' onkeyup='this.value=numchk(this.value);' value='<?=$write[wr_opt3_price]?>'>원
<input type=text name=wr_opt4_name class='input' style='IME-MODE: active' value='<?=$write[wr_opt4_name]?>'> :
<input type=text name=wr_opt4_price class='input' style="width:60;" dir='rtl' style='IME-MODE: inactive;' onkeyup='this.value=numchk(this.value);' value='<?=$write[wr_opt4_price]?>'>원
<input type=text name=wr_opt5_name class='input' style='IME-MODE: active' value='<?=$write[wr_opt5_name]?>'> :
<input type=text name=wr_opt5_price class='input' style="width:60;" dir='rtl' style='IME-MODE: inactive;' onkeyup='this.value=numchk(this.value);' value='<?=$write[wr_opt5_price]?>'>원
<input type=text name=wr_opt6_name class='input' style='IME-MODE: active' value='<?=$write[wr_opt6_name]?>'> :
<input type=text name=wr_opt6_price class='input' style="width:60;" dir='rtl' style='IME-MODE: inactive;' onkeyup='this.value=numchk(this.value);' value='<?=$write[wr_opt6_price]?>'>원
<input type=text name=wr_opt7_name class='input' style='IME-MODE: active' value='<?=$write[wr_opt7_name]?>'> :
<input type=text name=wr_opt7_price class='input' style="width:60;" dir='rtl' style='IME-MODE: inactive;' onkeyup='this.value=numchk(this.value);' value='<?=$write[wr_opt7_price]?>'>원
<input type=text name=wr_opt8_name class='input' style='IME-MODE: active' value='<?=$write[wr_opt8_name]?>'> :
<input type=text name=wr_opt8_price class='input' style="width:60;" dir='rtl' style='IME-MODE: inactive;' onkeyup='this.value=numchk(this.value);' value='<?=$write[wr_opt8_price]?>'>원
<input type=text name=wr_opt9_name class='input' style='IME-MODE: active' value='<?=$write[wr_opt9_name]?>'> :
<input type=text name=wr_opt9_price class='input' style="width:60;" dir='rtl' style='IME-MODE: inactive;' onkeyup='this.value=numchk(this.value);' value='<?=$write[wr_opt9_price]?>'>원
<input type=text name=wr_opt10_name class='input' style='IME-MODE: active' value='<?=$write[wr_opt10_name]?>'> :
<input type=text name=wr_opt10_price class='input' style="width:60;" dir='rtl' style='IME-MODE: inactive;' onkeyup='this.value=numchk(this.value);' value='<?=$write[wr_opt10_price]?>'>원
</td>
</tr>
<tr><td colspan=2 height=1 class='w_line'></td></tr>
<? if($w=='u') { ?>
<script>
var f = document.fwrite;
f.wr_price.value=number_format(f.wr_price.value);
f.wr_opt1_price.value=number_format(f.wr_opt1_price.value);
f.wr_opt2_price.value=number_format(f.wr_opt2_price.value);
f.wr_opt3_price.value=number_format(f.wr_opt3_price.value);
f.wr_opt4_price.value=number_format(f.wr_opt4_price.value);
f.wr_opt5_price.value=number_format(f.wr_opt5_price.value);
f.wr_opt6_price.value=number_format(f.wr_opt6_price.value);
f.wr_opt7_price.value=number_format(f.wr_opt7_price.value);
f.wr_opt8_price.value=number_format(f.wr_opt8_price.value);
f.wr_opt9_price.value=number_format(f.wr_opt9_price.value);
f.wr_opt10_price.value=number_format(f.wr_opt10_price.value);
</script>
<? } ?>
--------------------------------------------------------------------------------------------
config.php파일에서
--------------------------------------------------------------------------------------------
// 2006-02-22 필드추가
@mysql_query(" ALTER TABLE `$write_table`
ADD `wr_type1` TINYINT NOT NULL,
ADD `wr_type2` TINYINT NOT NULL,
ADD `wr_type3` TINYINT NOT NULL,
ADD `wr_type4` TINYINT NOT NULL,
ADD `wr_type5` TINYINT NOT NULL,
ADD `wr_price` INT NOT NULL,
ADD `wr_opt1_name` VARCHAR(30) NOT NULL,
ADD `wr_opt1_price` INT NOT NULL,
ADD `wr_opt2_name` VARCHAR(30) NOT NULL,
ADD `wr_opt2_price` INT NOT NULL,
ADD `wr_opt3_name` VARCHAR(30) NOT NULL,
ADD `wr_opt3_price` INT NOT NULL,
ADD `wr_opt4_name` VARCHAR(30) NOT NULL,
ADD `wr_opt4_price` INT NOT NULL,
ADD `wr_opt5_name` VARCHAR(30) NOT NULL,
ADD `wr_opt5_price` INT NOT NULL,
ADD `wr_opt6_name` VARCHAR(30) NOT NULL,
ADD `wr_opt6_price` INT NOT NULL,
ADD `wr_opt7_name` VARCHAR(30) NOT NULL,
ADD `wr_opt7_price` INT NOT NULL,
ADD `wr_opt8_name` VARCHAR(30) NOT NULL,
ADD `wr_opt8_price` INT NOT NULL,
ADD `wr_opt9_name` VARCHAR(30) NOT NULL,
ADD `wr_opt9_price` INT NOT NULL,
ADD `wr_opt10_name` VARCHAR(30) NOT NULL,
ADD `wr_opt10_price` INT NOT NULL,
ADD `wr_transport` MEDIUMTEXT NOT NULL ");
--------------------------------------------------------------------------------------------
write_update.skin.php파일에서
--------------------------------------------------------------------------------------------
$wr_price = ereg_replace(',','',$wr_price);
$wr_opt1_price = ereg_replace(',','',$wr_opt1_price);
$wr_opt2_price = ereg_replace(',','',$wr_opt2_price);
$wr_opt3_price = ereg_replace(',','',$wr_opt3_price);
$wr_opt4_price = ereg_replace(',','',$wr_opt4_price);
$wr_opt5_price = ereg_replace(',','',$wr_opt5_price);
$wr_opt6_price = ereg_replace(',','',$wr_opt6_price);
$wr_opt7_price = ereg_replace(',','',$wr_opt7_price);
$wr_opt8_price = ereg_replace(',','',$wr_opt8_price);
$wr_opt9_price = ereg_replace(',','',$wr_opt9_price);
$wr_opt10_price = ereg_replace(',','',$wr_opt10_price);
$sql = "UPDATE $write_table
SET wr_type1 = '$wr_type1',
wr_type2 = '$wr_type2',
wr_type3 = '$wr_type3',
wr_type4 = '$wr_type4',
wr_type5 = '$wr_type5',
wr_price = '$wr_price',
wr_opt1_price = '$wr_opt1_price',
wr_opt2_price = '$wr_opt2_price',
wr_opt3_price = '$wr_opt3_price',
wr_opt4_price = '$wr_opt4_price',
wr_opt1_name = '$wr_opt1_name',
wr_opt2_name = '$wr_opt2_name',
wr_opt3_name = '$wr_opt3_name',
wr_opt4_name = '$wr_opt4_name',
wr_opt5_name = '$wr_opt5_name',
wr_opt6_name = '$wr_opt6_name',
wr_opt7_name = '$wr_opt7_name',
wr_opt8_name = '$wr_opt8_name',
wr_opt9_name = '$wr_opt9_name',
wr_opt10_name = '$wr_opt10_name',
wr_transport = '$wr_transport'
WHERE wr_id = '$wr_id' ";
sql_query($sql);
?>
--------------------------------------------------------------------------------------------
이렇게 추가를 했는데 오류가 나오더라구요..ㅜㅜ
--------------------------------------------------------------------------------------------
UPDATE g4_write_menu10 SET wr_type1 = '', wr_type2 = '', wr_type3 = '', wr_type4 = '', wr_type5 = '', wr_price = '3231232', wr_opt1_price = '21321', wr_opt2_price = '12312', wr_opt3_price = '3123', wr_opt4_price = '23', wr_opt1_name = '213', wr_opt2_name = '3123', wr_opt3_name = '312', wr_opt4_name = '123123', wr_opt5_name = '12312', wr_opt6_name = '3', wr_opt7_name = '123', wr_opt8_name = '123213', wr_opt9_name = '123', wr_opt10_name = '1321123', wr_transport = '123' WHERE wr_id = '12'
1054 : Unknown column 'wr_opt5_name' in 'field list'
error file : /bbs/write_update.php
--------------------------------------------------------------------------------------------
이런 오류가 나오는데..
부가옵션가격을 추가할려면 어떻게 해야하나요??ㅠㅠ
--------------------------------------------------------------------------------------------
추천
0
0
댓글 전체
자바스크립트상에서도 추가하셔야합니다.
자바스크립트요???
어떤 파일인가요??ㅠㅜ
어떤 파일인가요??ㅠㅜ
