+- LCKB (https://lckb.dev/forum)
+-- Forum: ** OLD LCKB DATABASE ** (https://lckb.dev/forum/forumdisplay.php?fid=109)
+--- Forum: Guides & Help Section (https://lckb.dev/forum/forumdisplay.php?fid=193)
+---- Forum: Tutorials & Guides (https://lckb.dev/forum/forumdisplay.php?fid=124)
+----- Forum: Ep2 Guides (https://lckb.dev/forum/forumdisplay.php?fid=165)
+----- Thread: [SQL Codes] Usefull Codes for Ep2! (/showthread.php?tid=1244)
- filix_93 - 01-26-2013
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 - 01-26-2013
...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 - 02-11-2013
why cant i use "console" in my centos???
- Darquise - 02-11-2013
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 - 02-12-2013
Navicat Console? no Console/terminal do you have in Centos
- robino1996 - 02-12-2013
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 - 02-12-2013
no you are here mixing wrong things...
Console = a Linux Terminal (Putty)
about to change things in the db just use phpMyAdmin
- robino1996 - 02-13-2013
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 - 07-31-2013
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 - 08-15-2013
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
