UID325906
帖子
精華
主題
積分-70
現金
積極性
威望
違規
熱心
推廣次數
閱讀權限0
註冊時間2014-7-21
在線時間 小時
最後登錄1970-1-1
TA的每日心情 | 無聊 2014-8-26 02:43 PM |
---|
簽到天數: 31 天 連續簽到: 1 天 [LV.5]常住居民I
|
EA
私服版號: |
Rathena 12234 |
問題內容: |
腳本問題 |
本帖最後由 sdpeanut 於 2014-8-5 11:54 AM 編輯
- - shop groceries -1,12257:8000,526:6000,610:5000,663:2500,522:1500,501:50,502:100,503:200,504:300,505:400,12020:1000,523:1000,525:500,606:1000,682:1000,683:1000,645:-1,656:-1,657:-1,601:-1,602:-1,611:-1,1065:-1,717:-1,715:-1,716:-1,1025:-1,1751:1,1752:1,1765:1,1772:1,1771:1,1773:1,7135:12000,7136:12000,678:50000,12622:1000000,26001:50000,6377:100000
- - shop shell2 -1,12257:8000
- mora,123,102,4 script 道具商人 606,{
- switch(select("^0000FF購買物品","^0000FF販賣物品","^00FF50自動販賣","^D95401支票","^FF0000設定常用販賣列表","^FF8833重設販賣列表"))
- {
- case 1:
- callshop "groceries",1;
- break;
- case 2:
- callshop "groceries",2;
- break;
- case 3:
- query_sql("SELECT count(`char_id`) FROM `peddle` WHERE `char_id` = "+getcharid(0),.@count);
- mes "[ ^FF00C7自動販售^000000 ]";
- mes "^FF0000相同物品穿著也將一併售出^000000";
- mes "^FF0000自動販售之售價將不會因技能而變動^000000";
- mes "";
- mes "==== [ 以下是您將販售的列表 ] ====";
- for( set .@a,0; .@a < .@count; set .@a,.@a+100 )
- {
- set .@arrsize,query_sql2("SELECT `item_id` FROM `peddle` WHERE `char_id` = "+getcharid(0) ,.@item );
- for(set .@i,0;.@i<.@arrsize;set .@i,.@i+1)
- {
- set .@itemid,getd(".@item"+.@i);
- if( countitem(.@itemid) )
- mes getitemname(.@itemid) + "^0000FF " + countitem(.@itemid) + "^000000 個 x ^FF0000" + getiteminfo(.@itemid,1) + " z^000000";
- }
- }
- if(select("^0000FF確定販售^000000","取消")==1)
- {
- for(set .@i,0;.@i<.@arrsize;set .@i,.@i+1)
- {
- set .@itemid,getd(".@item"+.@i);
- if( set(.@c, countitem(.@itemid) ) )
- {
- delitem .@itemid,.@c;
- set Zeny,Zeny+getiteminfo(.@itemid,1)*.@c;
- }
- }
- }
- close;
- case 4:
- switch(select("^0000FF購買支票","^037D01支票換幣")){
- case 1:
- mes "[ ^FF00C7購買支票^000000 ]";
- mes "請問您要購買幾張支票呢 ?";
- mes "一張支票 ^FF0000100,000,000^000000 z";
- mes "另外要酌收^0000FF單筆^000000交易手續費 ^FF00004,000,000^000000";
- next;
- input .@i;
- if( .@i <= 0 )
- {
- mes "[ ^FF00C7購買支票^000000 ]";
- mes "取消交易";
- mes "歡迎再來 !";
- close;
- }
- if( Zeny < (.@i*100000000+4000000) )
- {
- mes "[ ^FF00C7購買支票^000000 ]";
- mes "您的金錢不夠";
- mes "歡迎再來 !";
- close;
- }
- set Zeny,Zeny-(.@i*100000000+4000000);
- getitem2 26020,.@i,0,0,0,254,0,getcharid(0),0;
- close;
- case 2:
- mes "[ ^FF00C7支票換幣^000000 ]";
- mes "請問您有幾張支票要換幣 ?";
- next;
- input .@i;
- if(.@i > countitem(26020))
- {
- mes "[ ^FF00C7支票換幣^000000 ]";
- mes "您支票不夠";
- close;
- }
- if( Zeny + ( .@i * 100000000 ) > 2000000000 )
- {
- mes "[ ^FF00C7支票換幣^000000 ]";
- mes "兌換後您的錢超過20E";
- close;
- }
- delitem 26020,.@i;
- set Zeny,Zeny+( .@i * 100000000 );
- close;
- }
- break;
- case 5:
- callshop "shell2",2;
- npcshopattach "shell2";
- break;
- case 6:
- query_sql("DELETE FROM `peddle` WHERE `char_id` = "+getcharid(0));
- mes "[ ^FF00C7自動販售^000000 ]";
- mes "^FF0000已經重新設定 ! 謝謝您的光臨^000000";
- break;
- }
- close;
- OnBuyItem:
- set .@arrsize,getarraysize(@bought_nameid);
- for(set .@i,0;.@i<.@arrsize;set .@i,.@i+1)
- announce @bought_nameid[.@i]+" "+getitemname(@bought_nameid[.@i])+" "+@bought_quantity[.@i],bc_all;
- end;
- OnSellItem:
- set .@cid,getcharid(0);
- set .@arrsize,getarraysize(@sold_quantity);
- for(set .@i,0;.@i<.@arrsize;set .@i,.@i+1)
- {
- query_sql("SELECT `item_id` FROM `peddle` WHERE `char_id` = "+.@cid+" AND `item_id` = "+@sold_nameid[.@i],.@sql$);
- //announce .@sql$,bc_all;
- if(.@sql$=="")
- query_sql("INSERT INTO `peddle` (`char_id`, `item_id`) VALUES ( "+.@cid+","+@sold_nameid[.@i]+");");
- set .@sql$,"";
- }
- end;
- }
-
複製代碼
我依照 腳本內 SELECT `item_id` FROM `peddle` WHERE `char_id`
然後就在資料庫添加 peddle
peddle 裡面再添加 pid , char_id , item_id
是腳本的問題嗎?? 還是我操作的問題
|
|