Syntax

I cant create new user since i dont have writing rigths :) How did i managed to change the admin settings? Simple. With navicat. Im working for an online server. And exactly this was the point. I wanted to check if mysql allows and admin to delete his admin rights. I prefer to do this kind of tests now. Not when i will be online. And my conclusion is: This is a really lol situation. Is like deleting windows system partition from windows. =)))))))))))) WTF were they thinking when they build mysql? So, seems like my only solution is to reinstall my OS :-\ :-\ :-\

Its not working. As i was saying. It keeps the old user name (and that user has no rights now). It stops at "Apply security settings" and it tells me: You dont have UPDATE rights ( :o :o :o :o)

I unistalled mysql server, i deleted the mysql directory from program files... and still cant do anything. Same problem

yeap. it keeps the same user ... and dont let me install it again. I dont have enough rights lol

Like someone said. Keep it on topic. A server is unbalanced from the moment you are using 2x rates. Depends on the admins to do their job right. I have a certain age, and i like wings. So we rich to the conclusion that is only your opinion. Tks

Well, i must give it a big LOOOOOOOOOOOOL I was trying to make a second user with reading rights only and i modified he's settings. After that i had an impulse to modify my admin settings. And guess what? It worked. LOL I cant do anything now. I cant create another users, i cant create tables i cant do anything. GZ to mysql developers. To be so stupid to let you to modify the admin rights. Now i tryed everything. I cant get my admin back. Do you know if there is any posibility to get my admin back without reinstaling my windows?

Cause the wings are a cool accesory and most of lineage players love them.

Yes, i liked the cloaks you made. But i still want to say to you that im unhappy with the kamael cloak. Since im using wings, the cloaks for kamael is not looking so good. Yes its gracia final. PS: Lauq, check PM

I need a good staff for a serious project. I worked very hard for a good l2jServer with custom stuff added. This server will guarantee 0% coruption. I have my ways to keep my word on it. Also, we will encourage the team spirit, party farming and mass pvp's. Here are some features: NORMAL SERVER FEATURES Rates: EXP: 100x SP: 100x Adena: 250x Drop: 5x Spoil: 5x Autolearn Skills: - No SP & spellbooks needed. - Gain your skills by the level you reach. NPC Buffers: - Second profession buffs, dances and songs. - Buffs/Dances/Songs last 1 Hour and 30 minutes. - Renewal & Champion last 1 Hour and 30 minutes - Third profession special buffs last 30 minutes | COV, Magnus, POW etc. - Possibility to create an "AIO buffer" near the Subclass Changers. SPECIAL SERVER FEATURES Bank System Adena (normal adena) Gold Bar = 500.000.000 Adena Coins (Custom exchange item) Legendary Coins = 10.000 Coins = 4 Gold Bars Epic Coins = 100 Legendary Coins Custom Armors Legendary Armors (Better then dinasty with Mid Grade Stats) Epic Armors (Better then Legendary with top grade stats) Custom Wings (nice looking items) Legendary Wings (Mid Grade Stats) Epic Wings (Top Grade Stats) Custom Weapons Legendary Weapons (Icarus stats + 2 Mid Special Ability) Epic Weapons (Vesper stats + 2 Top Special Ability) Custom Castle Cloaks Every clan member from a clan who owns a castle can wear a cloak with the castle name Inscription on it. Gives 3-5% P/Mdef (the castles are splitted in 3 categories) Custom Drop Zones - Solo farming zones (in Parnasus/ Cave of Trials) - Party farming zones (with some special mobs. Only a full party will resist there :) ) - in Parnasus / Cave of Trials ..... and many other features. Better see them in game :) So, we need: - a good core developer - a good client mooder - a good web developer for the website The server will be opened very soon. If anyone is interested please send me a pm or give a reply here, so we can talk.

Hi, I worked 2 months for one project and i think i managed to make a very good server. 100x Rates, with some custom stuff added, Custom Raid Bosses etc. I planned to open the server on 9 Octomber. The problem is that i dont have a website. And i dont have the right skills for making one very fast. I think i can learn how to do it, but it will take me another month or so. Or i need it in 4-5 days to have at least one week for promoting the server. Basicly i need a simple website with the basic stuff like: Home Server Features Register Forum (i know how to make the forum. You will have to do only the link button :) ) Rules Server stats: (Server status, raid boss status, Castle Controll) Player ranks (Top 15 PVP, Top 15 PK, Top 15 Online) Whats really important for me is the template. I want to look nice and finished. :) All i can offer you is: - the right credits on the bottom of the site (maby you need for portofolio); - we can iclude you on our develepors list if you like to keep manage the website and maby to be moderator on forum; - gm status (we will discuss about privileges); - items in game for a certain amount (we can discuss also); - i can offer you help for an l2j project (since i learned alot the past 2 months); Unfortunelly i can give you any money since im from Romania and we are not very strong from this point of view :) If anyone is interested please send me a pm or a repply here.

im sure that is not a gate ;)) . I want an elegant one like the one from the Aden Castle.

Yeap, tks. From then i resolve it. I maked a new modified script. :P Tks

So, there is the mob with the id: 22267. Is non agro. If you hit it... it spawns about 6-7 minions. I want to use this effect for another mobs too. But i dont know where the minions spawn is defined. I checked the minions table from sql, and the mob with id 21089 is not there. So basicly those arent considered minions. Also, i tryed to make another mobs that are using the same skills, but the result was that minions didnt spawned. So, my question is. How that minions spawns? Any ideas? Check the photo's: 1. The main mob (you see that he is alone and no minions are near him). 2. After i hit him (it spawned this minions)

Hi, can anyone tell me how can i put a gate in some place? I have to restrict an area by putting a gate into a canyon. Any sugestions how to do it?

He dont atack. Thats what i mean. He wakes up, he have an impulse to atack me and thats it. After that he just stays and do nothing. Since last night i discover what the issue is. Its reacting like this only when i have gm status. I deactivated the gm status and seems to work.

So, if i enter to Baium and wake him up, he stucks. He try to atack me and right after that he get stucked. And it remain like this. I tryed 2 diferent server revisions. The same thing. And its strange cause i dont found anything here on forum so i guess its not a general issue. But with a clean server installed and a clean client, i get the same bug. I dont understand what could be the problem. Any sugestions? I use L2jserver latest server pack.

Im using l2j Server version 3410, ct 2.3. Im not using any pack. Im trying to create my own custom stuff.

About the speed issue, its still wrong. Im really going near to madness with this. So, it still gives me different vallues, but in other circumstances. Like it gives me 10 bonus speed instead of 8 when i have cov. Or it gives me 6 instead of 8 when im not buffed. Its very annoying cause i got that line that defines the speed from the dark crystal robe. And the fking robe it working properly :(

That worked. Ty very much. You have +1 Karma from me. You helped me very much. PS: Since i dont want to just copy paste like a canary :))), can you explain to me whats that "0x30" "0x40" means?

That worked. Ty so much. Can you find a fix about mdef, pdef alternation? I guess its kinda the same story.

So, I want to add for a wings one skill. With 5% pdef, 5% mdef and 4 Speed. I entered the lines bellow... but the problem is that in game i didnt obtain fixed values. Without buffs for example i get +6 speed instead of +4. When im buffed, its all ok. Also when im on a mage char, the pdef, is +5% indeed but the mdef its a little smaller. When im on fighter class, the mdef is 5% and the pdef is a little smaller then normal. There are apropiate values. But i dont get it. Why the fk is happening? It should be fixed numbers. Easy to calculate. Anyone has any idea whats wrong here? <skill id="75912" levels="1" name="Legendary Wings Speed"> <set name="power" val="0.0"/> <set name="target" val="TARGET_SELF"/> <set name="skillType" val="BUFF"/> <set name="operateType" val="OP_PASSIVE"/> <set name="castRange" val="-1"/> <set name="effectRange" val="-1"/> <for> <mul order="0x30" stat="pDef" val="1.05"/> <!-- P Def. +5% --> <mul order="0x30" stat="mDef" val="1.05"/> <!-- M Def. +5% --> <add order="0x40" stat="runSpd" val="4"/> <!-- Movement Speed +4 --> </for> </skill> So basicly, this is what happens in game: On figher: Pdef 5% (the bonus is a little smaller then 5%. Why?) Mdef 5% (the bonus is exactly 5% so its ok) Run speed +4 (if im not buffed it gives me 6 speed bonus. Why? If im buffed is ok) On mage: Mdef 5% (the bonus is a little smaller then 5%. Why?) Pdef 5% (the bonus is exactly 5% so its ok) Run speed +4 (if im not buffed it gives me 6 speed bonus. Why? If im buffed is ok)

Ty Chandy. Nice work. +1 Karma from me :) (sry for double post. It was a freeze or smth)

Tks mate, just what i was looking for. +1 Karma from me :)

LauQ, this is one of the coolest shares. Ty, but answer me pls. This effects apply to all type of weapons? Like, can you put akamanah effect on a bow? Or caravan fire?

Only the basic and hero effect can be used on weapons? I mean that custom effects apply to all weapons (like bow for ex.)???? Or it applyes just for the weapons from those pictures?