Sawadee

Deque main account one of the oldest around the forum, was very active (8k posts and some nice shares) i paid my debt for 5 years and now i think that actually i deserve to get unbanned with deque, everybody deserve a fresh start and i believe i can help this community, thanks. Deque was a normal account anyway no vip no donator so no problem :)

Ksereis ti paei straba mazi s? prepei na bris mia douleia gia na bgalis kana frago epidi ta fake adibas pou tros se kanoun zimia poutanaki tou tsipra.

I could use the elf for buffer too but i prefer fake npcs XD

Well lets be honest, i see them first time and they are pretty nice :not bad:

Lol im gonna agree with you on this

And i didnt say that u offend him, i just wanted to say try to answer more gently when a person like demev offers you his work for free when nobody will do it. :)

Because people are arrogance and stupid, they guy asked gently for an opinion but look at the comments such negative plebs here.

your answer is shit as like as your opinion mate theres no need to argue with people like you :)

Lucera is still alive :not bad: i thought the project owners were found dead from overcoding.

Make the half of this job and lets see what u can do i bet you dont even know which programs he uses but you can talk with such arrogance for his share lmao.

Thank u guys :)

`Romeo here u cockbeggar.

I remember you XD

He can also start with my Deque too :) http://prntscr.com/dsgqj9

I know him very well and he knows me too we were like the cat and the dog (that sounds gey) but nevermind he might surprise you too :-beep- yeah: Also Raule was the best guy back then.

Welcome mate, i wish you to have a good experience on mxc forum :)

Dask? please dont remind me that guy.

Hi! Since all the SQL tutorials here seem to be very much outdated (non existent). I wanted to write a tutorial on how to write basic SQL statements. SQL is a VERY complex and nasty language, there's so much more to know than I can cover in a simple tutorial, but I will try my best. I will start with a tutorial about selecting data, but if you guys want me to make more for updating, deleting, creating, subqueries, counting, summing or whatever, tell me. Let's say we own a website which has users and these users can all update their profile with a certain country. Our tables look like this: user id country_id name 1 1 Example Name1 2 1 Example Name2 3 2 Example Name3 4 2 Example Name4 5 NULL Example Name5 country id name 1 Australia 2 Germany 3 China The most basic select statement looks like this: SELECT columnname, columnname, columnname FROM tablename; Let’s say we want to select the name and the id of all users, we would write it like this: SELECT id, name FROM user; This will return the name and id of ALL the records. It will look like this: id name 1 Example Name1 2 Example Name2 3 Example Name3 4 Example Name4 5 Example Name5 But what if we only want to know the name and id from the users who live in Australia? We first need to look in our country table and we see that Australia has id 1. Now we have to add a ‘WHERE’ statement to our SELECT. The most basic SELECT WHERE statement looks like this: SELECT columnname, columname, columnname FROM tablename WHERE columname = 'value' OR columname = 'value' AND columnname = 'value'; As you can see, you can add ORs and ANDs to your statement, this works just like you would expect it to work. If you are a programmer, you can see OR as || and AND as &&. Now let’s select our Australian users: SELECT id, name FROM user WHERE country_id = 1; This will return only Australian users. It will look like this: id name 1 Example Name1 2 Example Name2 But what if we want to select id, name and country name? How do we do that? We can do that with a JOIN. There are a lot of different joins; INNER JOIN, OUTER JOIN, RIGHT JOIN, LEFT JOIN, RIGHT OUTER JOIN, etc. This is a lot of information to take in at once, so we’ll keep it simple and narrow this guide down to two JOINs: the LEFT JOIN and the INNER JOIN. So what is the difference? I’ll show you this in the following examples, since writing it down is difficult. The most basic JOIN looks like this: SELECT tablename1.columnname , tablename1.columname, tablename2.columname FROM tablename1 JOIN tablename2 ON tablename2.keycolumn1 = tablename1.keycolumn2; The key columns represent a column belonging to table2 which is also present in table1. Now to ALSO select the country name for all users, we write our SELECT statement like this: SELECT user.id, user.name, country.name FROM user LEFT JOIN country ON country.id = user.country_id; We can add some aliases to make our query a bit more readable: SELECT u.id, u.name, c.name FROM user u LEFT JOIN country c ON c.id = u.country_id; Using aliases is NOT a must, it just comes down to a matter of preference whether you want to use it or not. However if you are selecting two columns with the same column name, in our example this is u.name and c.name, you have to add an alias to one of them. I would do it like this: SELECT u.id, u.name, c.name country_name FROM user u LEFT JOIN country c ON c.id = u.country_id; This query will return the following: id name country_name 1 Example Name1 Australia 2 Example Name2 Australia 3 Example Name3 Germany 4 Example Name4 Germany 5 Example Name5 NULL But wait.. Example Name5 hasn’t got a country_id filled in, what if we only want users who do have a country_id? This is where the INNER JOIN comes in handy, it will remove all those NULL records from the query result. We use the exact same query and only change LEFT JOIN to INNER JOIN, which will look like: SELECT u.id, u.name, c.name country_name FROM user u INNER JOIN country c ON c.id = u.country_id; Now our result is: id name country_name 1 Example Name1 Australia 2 Example Name2 Australia 3 Example Name3 Germany 4 Example Name4 Germany Thanks. PS: I dont own this guide, i copied it from a pdf file to share it with people keep in mind and thanks again.

Hello everyone, today we will be looking at PL/SQL the basic syntax into the SQL programming language. PL-SQL is a block-structure language.. this means that the actual program that you write is splitted into diffirent parts. Every PL/SQL block is split into 3 parts: Declarations Executable Commands Exception Handling The declaration section will start with the keyword DECLARE this section is not required as you don't always need variables in your PL/SQL program. The Executable section is enclosed between The BEGIN and the END. this section is required as this is the core of your SQL program. A simple example of a PL/SQL program: DECLARE message varchar2(20) := 'Hello MaxCheaters; BEGIN dbms_output.put_line(message); END; As you see in the exampe, we decalre a variabele called message as a varchar with a length of 20. the := means that your gonna give the variabele a value, 'Hello MaxCheaters' in our example. Dbms_output.put_line(); dbms_output.put_line(); will print a line, as of our example, the dbms_output.put_line() has a variabele passed within the () which holds our text. The dbms will show 'Hello MaxCheaters' in our sql terminal. You can compare the dbms_output.put_line() with a System.out.println() or a Console.writeLine(); in java or C#. Cheers!

lememermaster is a skilled guy ;)

Adapted from TERA for Lineage2 another nice work of zSnow of Perfect Team. 720p HD Vid Available. Credits: zSnow. Ps: If the item not appears in inventory try to change id to 5 numbers. `Thanks.

Blue and Red buttons are nice the others nah... :)

Demev is a very skiled businessman, his work is pure art.

Im not talkin for players brother, lineage2 community mostly sucks because you see undeveloped servers are opening every day, you see some flashy ads tricky features and when you log in its just a trashcan real server are not made in 1 month.

People like Tryskell must be rewarded very well, this guy is very experienced and he deserves that place also maxtor must make a new vote poll with tryskell and others and people can vote thats and option too