LCKB
The Most Important Querry - Printable Version

+- LCKB (https://lckb.dev/forum)
+-- Forum: ** OLD LCKB DATABASE ** (https://lckb.dev/forum/forumdisplay.php?fid=109)
+--- Forum: Release Zone (https://lckb.dev/forum/forumdisplay.php?fid=190)
+---- Forum: Episode 2 Releases (https://lckb.dev/forum/forumdisplay.php?fid=186)
+----- Forum: Server Side (https://lckb.dev/forum/forumdisplay.php?fid=143)
+----- Thread: The Most Important Querry (/showthread.php?tid=1652)

Pages: 1 2 3


- Ph3NoM - 02-28-2013


Nice Copy paste DrGeniuse From xNiceEinz =)))

 

 

---->2

 

the @NiceEinz guide is more better your guide 80% wrong ..... 




- Janebug - 02-28-2013


2not really all his codes are nice but since these sql files have been used 10000 times and who knows how many times them querrys have been ran ...half of them would be hurt full to you db then help full.

 

and 

2 your right and thanks for making them user friendly ... Jane




- Janebug - 02-28-2013


hey Wizatek can u make a statment in sql as u have above but to dump it to a text file ..

 

SELECT * FROM t_npc WHERE a_flag & (1 << 20) OR a_flag & (1 << 21)

 

for the bosses..

 

as for others would be nice to see some of you hit the THANK you

 

Jane




- Wizatek - 02-28-2013


SELECT a_index, a_name_usa, a_level FROM t_npc WHERE a_flag & (1

 

Should be something lime that




- Janebug - 02-28-2013



SELECT a_index, a_name_usa, a_level FROM t_npc WHERE a_flag & (1 << 20) OR a_flag & (1 << 21) INTO OUTFILE "c:\boss.txt";
 

 

worked great thanks wiz




- DrGenius - 02-28-2013


Nice Copy paste DrGeniuse From xNiceEinz =))) 

 

---->2

 

the @NiceEinz guide is more better your guide 80% wrong ..... 

im not an noob like you, check hes codes if are same of mine, also i have give credits to people that have posted these codes i only want help people to get codes, like that stop posting in this post if you want post something here, post one code or something to help. Haters everywhere.




- luoo - 02-28-2013


credits for so simpel sql querys, really?????

omg...




- DrGenius - 03-01-2013


credits for so simpel sql querys, really?????omg...

well xd you see here all time dramatics people thats why i say thanks to the people that has posted these querry they think we win something for post here, im only post here to help people cuz everytime i need help all here are available to help, and i think thats the point of this community if im not wrong.




- Douglas Farias - 03-01-2013

query is very simple all noob make . come to google




- Janebug - 03-01-2013


Not everyone are pros, out there and i post these sqls to help others like this forum is for ?   but yeah i can stop ..if its that big of deal for you. dont come here too look. Alot of these sql querys are easy, but helps alot with the server..... I will not post any sql that would be destructive to the db.. all thou a lot of these querys posted in other post on this server are not very good for your server its the one that count, that helps..

 

As for credit, I dont really care about the credit, but if you use what i post or someone else has posted, hitting  "thank you" button or just posting say "thanks for the help or what ever", is just common courtesy as a Forum MEMEBER...

 

 

JANE Smile