Doch

The problem ,per example, is if i want to list all the items that swordmans can wear, i have to have some way to know which items have the swordman mask/number/w.e in the column equip_jobs, because if i use its mask (swordman -> 0x00000002) we will list items that ONLY are for swordman. but there are a lot of items that can be wore also by other jobs that are also for swordman, and won't be listed because are combination with others. And get first the equip_jobs number, use the algo and then check, is a mess.. so this is the main problem that i have: list items by the job that i want EDIT: didn't know about the existence of bitwise operators in mysql, i guess that are the solution for this case thanks @Lighta and @Pneuma for all

Well, what im trying to learn is how to descompose the job number to know which jobs combinations are in it, and also know how to make them, because some jobs are listed but some other not. so the algorithm i thought to know the jobs in the number ( jobs that are listed ) is to represent the number in binary, and then from right to left, a counter that counts the positions ( zeros ) and when founds a 1 we get the first job, then the number is subtracted (?) from the job number and keeps counting till the end. more or less: for ( i = jobNumber.lenght(); i > 0; i--){ if(job[i] == 0){ continue; }else{ // we get the number till now, and then substract to the job number } } probably the algorithm is bullshit but right know i what i got. For know the jobs that are combinations of job and upper still don't have the clue because i don't undestand it at all. Everything im making, at the end, is for make a SQL query to get the item that just some job can wear

but how I combine both numbers, class and job into equip_jobs? or how is supposed that equip_jobs work? i understand that every job has its number but i want to know how to make that classes that doesn't appear in the list, and how to descompose the number to know which jobs are in. I know that per example in binary the thief class is 1000000 = 64 in decimal and mage is 100 = 4 in decimal so it will be 1000100, and both are combined, but also i want to know a way to descompose that number, i could check the position where is every 1 and know which numbers have, but in hexadecimal im not sure at all how to do it, or if there is the correct/easier way to do it (im coding in php btw)

but as there no is job and class column i guess that equip_jobs has to have some kind of combination of both, the question is how, let's see if somebody knows

uuhmm i see.., but the item_db structure doesn't have the class column like custom item has : so, how I calculate the number to allow some object just to be used by a job? or how I decompose the number to know which jobs are in the number? EX. 263168 -> Alchemist + Blacksmith btw: thanks for the fast response

http://rathena.org/wiki/Custom_Items I have been looking the wiki, but the list of jobs doesn't have some like sniper, clown etc, there's is another page with the list updated or something or what? or maybe im not understanding the function of the list and I can achieve these jobs making combinations of others or something? 0o thanks in advance.

as roBrowser is a client, it sends the data to the server and the server manages all the sql stuff, I guess

<li> <a href="{$list_url}/item_advanced_search">{$lng->asearch_id_legend}</a> </li>

http://top.ragnarokonline.es/ ,or you want V4P?

maybe an option to set the camera in a flat objective adjusted with the size of the map by clicking just with a hotkey? amazing program

what font is the small text in black and white? cool banner

itemdbtosql_texto_inicial

What's the point of implementing vote 4 points in servers if nobody searches a RO server in that websites? or people does?

they should be with exams and stuff to do, like everybody

si que hablo español, enviame un pm si eso, but i guess that in global forum we have to speak in english im quite sure that the program has to have an option to select the color of the background to make it invisible, or at least have some color that the program will read as transparent.

idk anything about this program but did you try the background with pink color? hex color -> ff00ff maybe there is some option to select the color you want to be hid because is the background or smth

maybe you should ask for help in openkore forum, no?

I love rates 3x 3x 3x

awesome the final image of the dark priest

Nombre Real: Nick: Doch / OverDoch Edad: 20 Nacionalidad: Española Contacto: Por private message Sobre Mi: Descubrí RO por un amigo, mi primer server al igual que Ziu fue ValhallaRO, hasta que se descubrio toda la mierda que habia por detras de clonaciones chetos etc etc y lo cerraron, luego jugue en OrimRO y puede que alguno más, por poco tiempo, ya que cerraron los servidores aproveche para dejarlo despues de 3 - 4 años de jugar. Mi Job favorito es el Sniper y el LK. Ahora mismo no juego ningun servidor, y espero no hacerlo porque chupa mucho tiempo(aunque haya tentacion jaja) Me gusta la programacion (PHP,java, javascript,c++...) y actualmente estoy acabando un proyecto que espero presentaren Rathena a principios de verano como muy tarde, debido a que con la universidad estoy demasiado liado.

When you log in a website you check if the username and the password matches with some account stored in your database, if it does, you log in, so you have to have something (id, username w/e) that is unique in that account to be able to select just the account you want, so id is the perfect value to do this because two accounts cannot have the same id, and something similar to the username. you have to store somewhere the username or the id, depending how you code your website, to later be able to fill that parameter(account_id, username, [unique_parameter]) to search in the row you want the value. Hope you understand me

didn't really understand what you are trying but if you want to show the value of the cashpoints row you have to make a query like this: SELECT value FROM acc_reg_num_db WHERE KEY = '#CASHPOINTS' AND account_id = xxx so you are selecting the value in the row that the key has stored #CASHPOINTS and the account_id is the number of the account id you want to search, ( i guess you need it i dont know how you got coded everything) maybe all of this isn't what you are looking for

Toda la razon, pero yo pregunto sobre los vote4points como metodo de obtencion de players, y el rollo de las listas y tal

Solo un par de preguntillas que me rondan la cabeza.. Cual creeis que es la mejor manera de hacer conocer a los players un servidor de ragnarok? Es mejor tener un servidor sin vote4points y poder meterlo en ciertas listas que no lo permiten, o poner este sistema de votacion? Llegariais a pagar por publicidad en una pagina de listas que permitiera vote4points? La verdad es que los que tienen vote4points no se como consiguen players, me pica la curiosidad