|
You last visited: Today at 07:22
Advertisement
Shop
Discussion on Shop within the Metin2 Private Server forum part of the Metin2 category.
10/10/2010, 15:55
|
#1
|
elite*gold: 17
Join Date: Aug 2010
Posts: 424
Received Thanks: 64
|
Shop
Hallo Leutei ch wollte heute den Waffen händler bearbeiten (was er vkt)
und jetzt weiss ich aber nicht wirklich wie das geht
also ich habe mir nen shop maker geholt und alles eingetragen
und wo muss ich jetzt den Query einfügen??
Code:
INSERT INTO `shop_item` (shop_vnum, item_vnum, count, name) VALUES (9001,299,1, ' ');
UPDATE item_proto SET shop_buy_price = '2100000', gold = 500000 WHERE vnum = 299;
INSERT INTO `shop_item` (shop_vnum, item_vnum, count, name) VALUES (9001,3219,1, ' ');
UPDATE item_proto SET shop_buy_price = '2100000', gold = 525000 WHERE vnum = 3219;
INSERT INTO `shop_item` (shop_vnum, item_vnum, count, name) VALUES (9001,5119,1, ' ');
UPDATE item_proto SET shop_buy_price = '2100000', gold = 525000 WHERE vnum = 5119;
INSERT INTO `shop_item` (shop_vnum, item_vnum, count, name) VALUES (9001,7169,1, ' ');
UPDATE item_proto SET shop_buy_price = '2100000', gold = 525000 WHERE vnum = 7169;
INSERT INTO `shop_item` (shop_vnum, item_vnum, count, name) VALUES (9001,1179,1, ' ');
UPDATE item_proto SET shop_buy_price = '2100000', gold = 525000 WHERE vnum = 1179;
INSERT INTO `shop_item` (shop_vnum, item_vnum, count, name) VALUES (9001,2159,1, ' ');
UPDATE item_proto SET shop_buy_price = '2100000', gold = 525000 WHERE vnum = 2159;
|
|
|
10/10/2010, 16:06
|
#2
|
elite*gold: 0
Join Date: Aug 2008
Posts: 502
Received Thanks: 174
|
Du öffnest deine DB.
Dann öffnest du player.
Da steht dann ja Tabelle usw. da müsste dann auch Query stehen.
Dann machste einfache ne neue Query und fügst das aus dem Shopmaker da ein und drückst auf Run.
|
|
|
10/10/2010, 16:17
|
#3
|
elite*gold: 17
Join Date: Aug 2010
Posts: 424
Received Thanks: 64
|
ich dachte mann muss da in Shop oder so rein ?
|
|
|
10/10/2010, 16:37
|
#4
|
elite*gold: 0
Join Date: Aug 2008
Posts: 502
Received Thanks: 174
|
Nein du musst in die DB player.
Also links und dann steht da ja tabelen usw.
|
|
|
10/10/2010, 17:46
|
#5
|
elite*gold: 17
Join Date: Aug 2010
Posts: 424
Received Thanks: 64
|
ich chek das net
kannst du es mal pls über tv machen???
|
|
|
10/10/2010, 18:11
|
#6
|
elite*gold: 0
Join Date: Aug 2008
Posts: 502
Received Thanks: 174
|
Links haste doch Sachen wie
Account
Mysql
player
etc.
und dann drückste auf player das es grün wird
und da kommen dann so kleine symbole tabelle und so
und dann guckste nach query.
Einfach Links in dem teil player nach query suchen
|
|
|
10/11/2010, 08:02
|
#7
|
elite*gold: 17
Join Date: Aug 2010
Posts: 424
Received Thanks: 64
|
ja habs jetzt abe r query ist falsch -.-
|
|
|
10/11/2010, 10:18
|
#8
|
elite*gold: 0
Join Date: Aug 2008
Posts: 502
Received Thanks: 174
|
Die sieht aber eig richtig aus, was kommt den für ein Fehler?
|
|
|
10/11/2010, 10:44
|
#9
|
elite*gold: 17
Join Date: Aug 2010
Posts: 424
Received Thanks: 64
|
Mom kann ich dir glei sagen
ich editiere dan
€- [SQL] INSERT INTO `shop_item` (shop_vnum, item_vnum, count, name) VALUES (9001,299,1, ' ');
[Err] 1054 - Unknown column 'name' in 'field list'
|
|
|
10/11/2010, 11:33
|
#10
|
elite*gold: 0
Join Date: Aug 2008
Posts: 502
Received Thanks: 174
|
Achso du hast das Feld "name" nicht in deiner shop_item Tabelle
Die Query muss so aussehen.
PHP Code:
INSERT INTO `shop_item` (shop_vnum, item_vnum, count) VALUES (9001,299,1, ' '); UPDATE item_proto SET shop_buy_price = '2100000', gold = 500000 WHERE vnum = 299; INSERT INTO `shop_item` (shop_vnum, item_vnum, count) VALUES (9001,3219,1, ' '); UPDATE item_proto SET shop_buy_price = '2100000', gold = 525000 WHERE vnum = 3219; INSERT INTO `shop_item` (shop_vnum, item_vnum, count) VALUES (9001,5119,1, ' '); UPDATE item_proto SET shop_buy_price = '2100000', gold = 525000 WHERE vnum = 5119; INSERT INTO `shop_item` (shop_vnum, item_vnum, count) VALUES (9001,7169,1, ' '); UPDATE item_proto SET shop_buy_price = '2100000', gold = 525000 WHERE vnum = 7169; INSERT INTO `shop_item` (shop_vnum, item_vnum, count) VALUES (9001,1179,1, ' '); UPDATE item_proto SET shop_buy_price = '2100000', gold = 525000 WHERE vnum = 1179; INSERT INTO `shop_item` (shop_vnum, item_vnum, count) VALUES (9001,2159,1, ' '); UPDATE item_proto SET shop_buy_price = '2100000', gold = 525000 WHERE vnum = 2159;
Viel Spaß damit!
Mfg
McIlrath
|
|
|
10/11/2010, 11:48
|
#11
|
elite*gold: 17
Join Date: Aug 2010
Posts: 424
Received Thanks: 64
|
Thx
mal gucken vlt geht es xD
jetzt kommt das :
Code:
[SQL] INSERT INTO `shop_item` (shop_vnum, item_vnum, count) VALUES (9001,299,1, ' ');
[Err] 1136 - Column count doesn't match value count at row 1
vlt liegts an den Serverfiles
ich ich zieh mir mal Pfrofiezocker 94 seine
|
|
|
10/11/2010, 11:59
|
#12
|
elite*gold: 0
Join Date: Aug 2008
Posts: 502
Received Thanks: 174
|
Naja an den Files kanns eig nciht liegen.
Sonst trag die doch einfach manuel ein.
Das haste in 5 Minuten fertig anstatt sich jetzt solche Problme mit der Query zu machen.
|
|
|
10/11/2010, 19:28
|
#13
|
elite*gold: 17
Join Date: Aug 2010
Posts: 424
Received Thanks: 64
|
ich weiss nicht wie das geht
|
|
|
Similar Threads
|
Spam shop aber wie naja besser gesagt info shop ^^ :)
01/12/2011 - Metin2 Private Server - 24 Replies
Also leute ich gebe es zu ich hab das bei fantasyMt2 gesehen am anfang und jetzt will ich das auch machen und zwar also ich erklär das ganze mal genauer
Ich will ein shop hinstellen der die ganze zeit was sagt z.b willkommen aus dirtymt2 viel erfolg... aber nicht nur 1 satz sondern also sätze das er die immer hintereinander sagt und immer wieder von vorne weiss jemand wie das geht ?
Mfg hakan
|
[ACCOUNT SHOP]**013oopt45's NEW SHOP**[10+ACCS] CHEAP !
12/11/2009 - Runescape Trading - 10 Replies
013oopt45'S ACCOUNT SHOP -- NEW
----> I am starting to sell accounts for all of the people with needs <-----
I will offer here 10+ Accounts that you can choose between them , so here we GO :
(BIDS ARE ACCEPTED !)
1. Account HAS 245 DAYS OF MEMBERSHIP LEFT !
http://img138.imageshack.us/img138/5749/dakidofod s245days.png
A/W --> 59.95$ -- SOLD SOLD SOLD !
|
All times are GMT +2. The time now is 07:22.
|
|