playercreateinfo_item

[snv 29]

zdravim,kamarat ma popytal aby som mu nahadzal do db itemy na zaciatok ked sa hraci lognu,zrobil som si script len neviem ci ho mam dobre(asi nie lebo to nejde)tak by som vas chcel poprosit o radu

 

script je dole

 

INSERT INTO `playercreateinfo_item` SET `itemid`=`24552` WHERE `class` = `256`;

INSERT INTO `playercreateinfo_item` SET `itemid`=`24553` WHERE `class` = `256`;

INSERT INTO `playercreateinfo_item` SET `itemid`=`24554` WHERE `class` = `256`;

INSERT INTO `playercreateinfo_item` SET `itemid`=`24555` WHERE `class` = `256`;

INSERT INTO `playercreateinfo_item` SET `itemid`=`24556` WHERE `class` = `256`;

INSERT INTO `playercreateinfo_item` SET `itemid`=`25830` WHERE `class` = `8`;

INSERT INTO `playercreateinfo_item` SET `itemid`=`25831` WHERE `class` = `8`;

INSERT INTO `playercreateinfo_item` SET `itemid`=`25832` WHERE `class` = `8`;

INSERT INTO `playercreateinfo_item` SET `itemid`=`25833` WHERE `class` = `8`;

INSERT INTO `playercreateinfo_item` SET `itemid`=`25834` WHERE `class` = `8`;

INSERT INTO `playercreateinfo_item` SET `itemid`=`25854` WHERE `class` = `128`;

INSERT INTO `playercreateinfo_item` SET `itemid`=`25855` WHERE `class` = `128`;

INSERT INTO `playercreateinfo_item` SET `itemid`=`25856` WHERE `class` = `128`;

INSERT INTO `playercreateinfo_item` SET `itemid`=`25857` WHERE `class` = `128`;

INSERT INTO `playercreateinfo_item` SET `itemid`=`25858` WHERE `class` = `128`;

INSERT INTO `playercreateinfo_item` SET `itemid`=`25997` WHERE `class` = `64`;

INSERT INTO `playercreateinfo_item` SET `itemid`=`25998` WHERE `class` = `64`;

INSERT INTO `playercreateinfo_item` SET `itemid`=`25999` WHERE `class` = `64`;

INSERT INTO `playercreateinfo_item` SET `itemid`=`26000` WHERE `class` = `64`;

INSERT INTO `playercreateinfo_item` SET `itemid`=`26001` WHERE `class` = `64`;

INSERT INTO `playercreateinfo_item` SET `itemid`=`31613` WHERE `class` = `2`;

INSERT INTO `playercreateinfo_item` SET `itemid`=`31614` WHERE `class` = `2`;

INSERT INTO `playercreateinfo_item` SET `itemid`=`31619` WHERE `class` = `2`;

INSERT INTO `playercreateinfo_item` SET `itemid`=`31616` WHERE `class` = `2`;

INSERT INTO `playercreateinfo_item` SET `itemid`=`31618` WHERE `class` = `2`;

INSERT INTO `playercreateinfo_item` SET `itemid`=`27707` WHERE `class` = `16`;

INSERT INTO `playercreateinfo_item` SET `itemid`=`27708` WHERE `class` = `16`;

INSERT INTO `playercreateinfo_item` SET `itemid`=`27709` WHERE `class` = `16`;

INSERT INTO `playercreateinfo_item` SET `itemid`=`27710` WHERE `class` = `16`;

INSERT INTO `playercreateinfo_item` SET `itemid`=`27711` WHERE `class` = `16`;

INSERT INTO `playercreateinfo_item` SET `itemid`=`31375` WHERE `class` = `1024`;

INSERT INTO `playercreateinfo_item` SET `itemid`=`31376` WHERE `class` = `1024`;

INSERT INTO `playercreateinfo_item` SET `itemid`=`31377` WHERE `class` = `1024`;

INSERT INTO `playercreateinfo_item` SET `itemid`=`31378` WHERE `class` = `1024`;

INSERT INTO `playercreateinfo_item` SET `itemid`=`31379` WHERE `class` = `1024`;

INSERT INTO `playercreateinfo_item` SET `itemid`=`28331` WHERE `class` = `4`;

INSERT INTO `playercreateinfo_item` SET `itemid`=`28332` WHERE `class` = `4`;

INSERT INTO `playercreateinfo_item` SET `itemid`=`28333` WHERE `class` = `4`;

INSERT INTO `playercreateinfo_item` SET `itemid`=`28334` WHERE `class` = `4`;

INSERT INTO `playercreateinfo_item` SET `itemid`=`28335` WHERE `class` = `4`;

 

 

navicat mi to vypisuje

 

[Err] 1064 - Va-Be syntaxe je njak divn bl-Bzko 'WHERE `class` = 256' na dku 1

[Err] INSERT INTO `playercreateinfo_item` SET `itemid`=24552 WHERE `class` = 256;

[Msg] Finished - Unsuccessfully

 

 

dakujem za pomoc

[Eessencia 1069]

nepoužívej INSERT INTO ale UPDATE :-)

[Shadowhack 36]

Přesně jak píše Necro,Insert je jako vložit,Update.. Jako update

[Hookyns 86]

Pokud chceš naházet nové itemy, tak zaručeně insert into `playercreateinfo_item` (`sloupec`) values ('hodnota');

Ale je to pár dní, co jsem na tohle napsal app v PHP.

ZDE

Jen si tam musíš upravit ty hodnoty pro $races[x].

[snv 29]

nepoužívej INSERT INTO ale UPDATE :-)

hned to vyskusam:)

 

Pokud chceš naházet nové itemy, tak zaručeně insert into `playercreateinfo_item` (`sloupec`) values ('hodnota');

Ale je to pár dní, co jsem na tohle napsal app v PHP.

ZDE

Jen si tam musíš upravit ty hodnoty pro $races[x].

a bude to normalne fungovat aj na oc??(vo webe sa nevyznam)

este k tomu sql kodu,potrebujem to nastavit tak ze mi to da na kazdu clasu iny item

Edited September 30, 2011 by snv

[Eessencia 1069]

hned to vyskusam:)

Bude to fungovat, chybu si měl pouze v syntaxi..

UPDATE table SET table1='něco1' WHERE table2='něco2'; aneb UPRAVUJ v tabulce table, sloupec table1 na 'něco1' KDE se rovná table2 něco2; chápeš mě ne?

insert vypadá tak jak psal Hook

 

Zkus pogooglovat něco o dotazovacím jazyku SQL a pochopíš :-)

Edited September 30, 2011 by NecroVisioN

[snv 29]

okey funguje to uz,diky moc chlapci zasluzite si +rep

 

necro mozes lock

Edited September 30, 2011 by snv