[SQL Codes] Usefull Codes for Ep2!

[filix_93]

Affinity-Rate 

UPDATE t_affinity_work SET a_value = a_value * 1;

dont work , Ive tried that command 4days ago , if you do that comand so you wont be able to donate items for affinity .

[Simkana]

...and do not you find out wheres the error?... haha

You need to change all "a_worktype 0"-Listings to normal value or customize your client.

 

But is easier to change in first step all, and editing after that "a_worktype 0"... because there are more npcs than donate-items.

[robino1996]

why cant i use "console" in my centos???

[Darquise]

I have no console in my Navicat, do I need to register it for the console funktion?

I also searched on the internet but my navicat definitly has no console!

[chris-2012]

Navicat Console? no Console/terminal do you have in Centos

[robino1996]

mysql> UPDATE t_npc SET a_exp = a_exp * 30;Navicat Console? no Console/terminal do you have in Centos

thanks but if i type in my console (navicat) for example UPDATE T_npc.... it says UPDATE invalid command :=0

[chris-2012]

no you are here mixing wrong things...

Console = a Linux Terminal (Putty)

about to change things in the db just use phpMyAdmin

[robino1996]

no you are here mixing wrong things...Console = a Linux Terminal (Putty)

about to change things in the db just use phpMyAdmin

but i cant use phpmyadmin in my virtual machine >.<

[xMostHateD]

quest SP:

UPDATE t_quest SET a_prize_data0 = a_prize_data0*1 WHERE a_prize_index0 = 0 and a_prize_type0 = 3 ;
UPDATE t_quest SET a_prize_data1 = a_prize_data1*1 WHERE a_prize_index1 = 0 and a_prize_type1 = 3 ;
UPDATE t_quest SET a_prize_data2 = a_prize_data2*1 WHERE a_prize_index2 = 0 and a_prize_type2 = 3 ;

just change the Type to whatever u want so u can even edit the gold and more.

[GuXPw]

Divide exp table :

 

UPDATE t_exp SET a_exp = a_exp / 1;

 

Multiply exp table

 

UPDATE t_exp SET a_exp = a_exp * 1;

 

Change 1 by your number

 

Rate of genericname02 : /20 of original exp table (for an idea)

 

Nice when you want original game (quest, exp mob ...) with less exp per level