UDB PROBLEM

[dexx 1]

Dozvedel som sa ze od revizie tusim 5633 sa UDB rozhodla robit DB cisto pre blizzlike takze loot v dungoch ako TK , BT a pod. sa us neda nastavit alebo obmedzit v mangos configom .. Takze by som vas tymto topicom poziadal o radu ako z UDB spravit Fun DB co sa tyka dropov a pod ...THX

[Method-man 1]

no nejspise bych zkusil

 

UPDATE `creature_loot_template` SET `ChanceOrQuestChance` = 100 WHERE (neco);

 

kde za neco dosadis co si prejes "zfunovat"

 

edit reason: spatne zadany strednik

Edited May 24, 2008 by Method-man

[dexx 1]

no prave ono padne sice nieco na 100 percent ale je tu hacit padnu max 3 veci UDB tam nieco pomenila a us to neni to co predtym config nic nevyriesi a ja zreovna nechcem aby bolo vsetko na 100 percent pretoze chcem tak povediac High server nie fun .

[dexx 1]

naviac mi mi tym prikazom fakt padalo vsetko vlastne by vsetko ostalo tak ako predtym UDB to posrala

[spider 1]

Cuss skusal sem toto:

 

UPDATE `creature_loot_template` SET `ChanceOrQuestChance` = 100; WHERE (neco)

 

Ale aj tak pada maly drop y bossov nechapem totis co mam napsat tu?? "WHERE (neco)" (neco) = ???

 

Pls help jak to uppravit aby padalo zo vsech bosov aj npc Maximalny Loot ???

[Anathema 0]

Cuss skusal sem toto:

Ale aj tak pada maly drop y bossov nechapem totis co mam napsat tu?? "WHERE (neco)" (neco) = ???

 

Pls help jak to uppravit aby padalo zo vsech bosov aj npc Maximalny Loot ???

 

 

UPDATE `creature_loot_template` SET `ChanceOrQuestChance` = '100' WHERE `entry` = 'ID';

 

za ID dosadis ID itemu a za 100 nedas ;

 

popripade WHERE `entry` in (xxx, xxx, xxx);

 

za xxx dosadis IDcka jednotlivych itemu, u kterych chces, aby mely 100% drop

Edited May 24, 2008 by Anathema

[spider 1]

Ale napis mi sem pls ako spravit to aby to zmenilo U vsetkych creaturach proste u vsech NPC aby bol maximalny LOOT

 

Ja sem to nejak nepochopil sry

[Method-man 1]

jaj sry, v tom mem 1. postu je opravdu navic stednik ... sry

[Anathema 0]

Ale napis mi sem pls ako spravit to aby to zmenilo U vsetkych creaturach proste u vsech NPC aby bol maximalny LOOT

 

Ja sem to nejak nepochopil sry

 

Hele, vsechny creepy, ktere dropuji item, jehoz id zadas / jejichz id zadas budou ten item dropovat na 100%.

[swordik 1]

Hele, vsechny creepy, ktere dropuji item, jehoz id zadas / jejichz id zadas budou ten item dropovat na 100%.

 

Tak jsem to testnul

UPDATE `creature_loot_template` SET `ChanceOrQuestChance` = '100' WHERE `entry` = '22921, 25956, 25955, 25957, 25954, 25962, 25953, 28490, 28558';

 

ale z bosse mi pada vždy jedna věc ...

Edited May 24, 2008 by swordik

[Method-man 1]

to bude nejspise tim, ze je ted dojeb loot ... staci si precist mangos/udb forka ...

[Method-man 1]

pouze pro fun servery - totalni prekopani lootu na high fun

 

UPDATE `creature_loot_template` SET `ChanceOrQuestChance` = '100' WHERE `entry` > 0;

a co toto? , popr. jeste

UPDATE `creature_loot_template` SET `freeforall` = '1' WHERE `entry` > 0;
UPDATE `creature_loot_template` SET `mincountOrRef` = '5' WHERE `entry` > 0;
UPDATE `creature_loot_template` SET `maxcount` = '10' WHERE `entry` > 0;

to uz je trosku brutalnejsi

Edited May 24, 2008 by Method-man

[spider 1]

Stalle mi to nejak nejde najde sa tu dakdo pls kdo to vie spravit aby komplet zo vsetkych npc padalo secko na 100% ?? PLS HELP

[Anathema 0]

pouze pro fun servery - totalni prekopani lootu na high fun

 

UPDATE `creature_loot_template` SET `ChanceOrQuestChance` = '100' WHERE `entry` > 0;

a co toto? , popr. jeste

UPDATE `creature_loot_template` SET `freeforall` = '1' WHERE `entry` > 0;
UPDATE `creature_loot_template` SET `mincountOrRef` = '5' WHERE `entry` > 0;
UPDATE `creature_loot_template` SET `maxcount` = '10' WHERE `entry` > 0;

to uz je trosku brutalnejsi

No tak to potes, vis jaky loot maji nektere creepy? i stovky itemu s 0,0000... % sanci, tim si leda tak zalagujes server, kdyz ti nejakou takovou creepu killne vic lidi, a ze takovych creep je.

 

Btw. zmeny v SQL se projevi samozrejme po restartu serveru, pokud nemate ve hre prikaz reload creature_loot__template

[spider 1]

Tak ako to pls spravit aby som mal Maximalny Loot zo vsetkych crepou aj World Bossov pls help...???

[Pavloperkosko 2]

Ak sa ty nechce menit confg ani po jednom menit sprav to takto

 

CREATE TABLE `creature_loot_template` (
 `entry` mediumint(8) unsigned NOT NULL default '0',
 `item` mediumint(8) unsigned NOT NULL default '0',
 `ChanceOrQuestChance` float NOT NULL default '100',
 `groupid` tinyint(3) unsigned NOT NULL default '0',
 `mincountOrRef` mediumint(9) NOT NULL default '1',
 `maxcount` tinyint(3) unsigned NOT NULL default '1',
 `freeforall` tinyint(3) unsigned NOT NULL default '0',
 `lootcondition` tinyint(3) unsigned NOT NULL default '0',
 `condition_value1` mediumint(8) unsigned NOT NULL default '0',
 `condition_value2` mediumint(8) unsigned NOT NULL default '0',
 PRIMARY KEY  (`entry`,`item`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Loot System';

 

zmen za

 

CREATE TABLE `creature_loot_template` (

`entry` mediumint(8) unsigned NOT NULL default '0',

`item` mediumint(8) unsigned NOT NULL default '0',

`ChanceOrQuestChance` unsigned NOT NULL default '100',

`groupid` tinyint(3) unsigned NOT NULL default '0',

`mincountOrRef` mediumint(9) NOT NULL default '1',

`maxcount` tinyint(3) unsigned NOT NULL default '1',

`freeforall` tinyint(3) unsigned NOT NULL default '0',

`lootcondition` tinyint(3) unsigned NOT NULL default '0',

`condition_value1` mediumint(8) unsigned NOT NULL default '0',

`condition_value2` mediumint(8) unsigned NOT NULL default '0',

PRIMARY KEY (`entry`,`item`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Loot System';

 

Proste bude hodnota stlpca ChanceOrQuestChance 100 ... a je

 

 

[Method-man 1]

me je to jedno, pro me to neni ... chtel to zfunovat, tady to ma

[spider 1]

CREATE TABLE `creature_loot_template` (

`entry` mediumint(8) unsigned NOT NULL default '0',

`item` mediumint(8) unsigned NOT NULL default '0',

`ChanceOrQuestChance` unsigned NOT NULL default '100',

`groupid` tinyint(3) unsigned NOT NULL default '0',

`mincountOrRef` mediumint(9) NOT NULL default '1',

`maxcount` tinyint(3) unsigned NOT NULL default '1',

`freeforall` tinyint(3) unsigned NOT NULL default '0',

`lootcondition` tinyint(3) unsigned NOT NULL default '0',

`condition_value1` mediumint(8) unsigned NOT NULL default '0',

`condition_value2` mediumint(8) unsigned NOT NULL default '0',

PRIMARY KEY (`entry`,`item`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Loot System';

 

PLS HELP HADZE MI TO TOTO::::

 

ERROR 1064 : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'unsigned NOT NULL default '100',

`groupid` tinyint(3) unsigned NOT NULL default' at line 4

 

 

[spider 1]

Np tak som to tam dal toto:

 

CREATE TABLE `creature_loot_template` (

`entry` mediumint(8) unsigned NOT NULL default '0',

`item` mediumint(8) unsigned NOT NULL default '0',

`ChanceOrQuestChance` float NOT NULL default '100',

`groupid` tinyint(3) unsigned NOT NULL default '0',

`mincountOrRef` mediumint(9) NOT NULL default '1',

`maxcount` tinyint(3) unsigned NOT NULL default '1',

`freeforall` tinyint(3) unsigned NOT NULL default '0',

`lootcondition` tinyint(3) unsigned NOT NULL default '0',

`condition_value1` mediumint(8) unsigned NOT NULL default '0',

`condition_value2` mediumint(8) unsigned NOT NULL default '0',

PRIMARY KEY (`entry`,`item`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Loot System';

 

A tearz ked tam zase povkladam secky Inserty pre Loot Tak stale je ChanceOrQuestChance podla UDB spravena tak ako potom ..??

[spider 1]

Poradi mi niekdo ako to spravit pls stale mi to nejde z World Bossov....

[Pavloperkosko 2]

nespamuj a skus zapojit mozek

 

 

skus trebars

ALTER TABLE

 

samozejme pouzi to co som ty pisal hotove sql ty sem snad nemusim pisat

[spider 1]

Ludia co to v tejto novej revizii "Revision 351" je v tabulke "creature_loot_template" 49974" riadkov pricom v starsich Db bolo ovela viac Loot menil sa dako celkovvy Loot Struktura ? Vie o tom dakdo daco??

[swordik 1]

Nevěděl by někdo jak to spravit ten loot teda ??? , viděl jsem naněkolika serverech Funkach a ty méli UDB v pohodě .. loot...

[axxxa 78]

Loot JE v pohodě, pokud JE, ten topic už je dosti zatuchlý

[swordik 1]

Loot JE v pohodě, pokud JE, ten topic už je dosti zatuchlý

 

v Pohodě ??? mam UDB 0.10.4 .... a mam stim problém furt ... v mangoši mam třeba drop na 90x ratech a nepadá to .. Jak by mělo ..