[Guide] Fixing base BP bugs (Gift bugs)

[funhacker]

honestly there isn't much you can do to prevent the multiple queries without complex scripting
most you can do is clean up the "'" with the numbers.
Also personaly I would set the talent to 255 to still keep the block open..

update cq_eudemon set
talent1=255 where
talent1 NOT IN (51,52,53,54,55,192,191,190,255,0); 
update cq_eudemon set
talent2=255 where
talent2 NOT IN (51,52,53,54,55,192,191,190,255,0); 
update cq_eudemon set
talent3=255 where
talent3 NOT IN (51,52,53,54,55,192,191,190,255,0); 
update cq_eudemon set
talent4=255 where
talent4 NOT IN (51,52,53,54,55,192,191,190,255,0); 
update cq_eudemon set
talent5=255 where
talent5 NOT IN (51,52,53,54,55,192,191,190,255,0);

[hio77]

Originally Posted by funhacker

honestly there isn't much you can do to prevent the multiple queries without complex scripting
most you can do is clean up the "'" with the numbers.
Also personaly I would set the talent to 255 to still keep the block open..

update cq_eudemon set
talent1=255 where
talent1 NOT IN (51,52,53,54,55,192,191,190,255,0); 
update cq_eudemon set
talent2=255 where
talent2 NOT IN (51,52,53,54,55,192,191,190,255,0); 
update cq_eudemon set
talent3=255 where
talent3 NOT IN (51,52,53,54,55,192,191,190,255,0); 
update cq_eudemon set
talent4=255 where
talent4 NOT IN (51,52,53,54,55,192,191,190,255,0); 
update cq_eudemon set
talent5=255 where
talent5 NOT IN (51,52,53,54,55,192,191,190,255,0);

updated the query i looked at the ones you rewrote and tried to make it like yours :P didn't know that you could take the "" out of a list

[magewarior2]

Originally Posted by hio77

:P or you could do that ....


i can easily give you an old db and just remove the chance of a new pet with a gift

this is maybe oftopic, but can you give me a cq_levexp_x
and cq_levexp (normal xp not a X10 or something a normal


that goes to level 255 or level 137 is fine to

cq_levexp.frm
cq_levexp.MYI
cq_levexp.MYD
cq_levexp_x.frm
cq_levexp_x.MYI
cq_levexp_x.MYD

this file's please ... not a MySQL drop.

Thank you.

my file's are harder than normal i think 0.0 i put expball on level 35 and it goes to level 37 0.0

[BetuDM]

Originally Posted by hio77

urmmmmm i dont see any bugs there

The Knight Should be give to player only +14 bp, if the player have apointed the pet on knight with 105* +
and the player are winning 200+ of potency
where i can fix it?

[hio77]

Originally Posted by magewarior2

this is maybe oftopic, but can you give me a cq_levexp_x
and cq_levexp (normal xp not a X10 or something a normal


that goes to level 255 or level 137 is fine to

cq_levexp.frm
cq_levexp.MYI
cq_levexp.MYD
cq_levexp_x.frm
cq_levexp_x.MYI
cq_levexp_x.MYD

this file's please ... not a MySQL drop.

Thank you.

my file's are harder than normal i think 0.0 i put expball on level 35 and it goes to level 37 0.0

hit me up on msn lol

Originally Posted by BetuDM

The Knight Should be give to player only +14 bp, if the player have apointed the pet on knight with 105* +
and the player are winning 200+ of potency
where i can fix it?

dose it really matter? everyone sees it like this which is fine ....

its the officals table and ini (cant think of the name)

[magewarior2]

Originally Posted by BetuDM

The Knight Should be give to player only +14 bp, if the player have apointed the pet on knight with 105* +
and the player are winning 200+ of potency
where i can fix it?

follow the steps ... (read above)


that will fix that also ....

[BetuDM]

Originally Posted by hio77

hit me up on msn lol




dose it really matter? everyone sees it like this which is fine ....

its the officals table and ini (cant think of the name)

can u add me on msn?


i will w8 4 u

[hio77]

Originally Posted by BetuDM

can u add me on msn?


i will w8 4 u

added

[luzia]

Hello people ... Good night
The topic is very good helped me a lot about the Gif It was perfect instead of +2 to +20 gave up the 2, Thank you for Help ...
So now I have a Problem Same as "BetuDM" And read a thread I saw that it found a solution ... Pos the query up there not consult this BUG. I wish people could see the pot of players right. And the Gift is correct but now has the knight. If I put in a PET Knight 20 * appears to me to POT +2. But others appear to +20 pot, acab changing the power of the players. you see the BP EXAMPLE: 500 to see 580 people, I wonder if you would know where I can stir this for me to see this giving q +2 points and the rest of the staff also look to me to see.


See the SS of what I'm talking ..



Lo instead of 98 was to appear +3 and not 98, pot = / this is wrong and I do not know but where to look, but once I am grateful to help.

[hio77]

this is to do with the knights system .... you need to compare your officials type in the db and ini

[luzia]

How do I do that? if the DB has +3 my ini but that has 3 so that everything is +3 ... The problem I do not know where to see it in the DB and not INI = (do not know the locations

[hio77]

Originally Posted by luzia

How do I do that? if the DB has +3 my ini but that has 3 so that everything is +3 ... The problem I do not know where to see it in the DB and not INI = (do not know the locations

cant really tell you how atm but ill give you the files its in ...

Database: cq_official_type 
Ini: OfficialType.ini

[funhacker]

if you upload a Text format of your cq_official_type I will convert it into a OfficialType.ini for you

[luzia]

hio77 Thanks.
Funhacker, I am grateful Tanks If you do, you guys.

[funhacker]

Originally Posted by luzia

hio77 Thanks.
Funhacker, I am grateful Tanks If you do, you guys.

...were you going to upload the txt file?