Hardstyle

yes you can...but you need to modify it... a lot

last revision..

i added a new jar file to lib folder i have added the path in .classpath but i dont know how to acces it ...whats the import import com.myname dosent work...how i access it ...plz answer

post updated ...read the 1stpost

when i made that code myserver was on freya....you can use it on any cronic but you may need to change some code in bank.java if there are any different classes... try this: clear the reward table from your data base and if you still get this error check if you modefied the php....you may have change something so is trying to insert into db when he should only update....

more then 70% of websites are made using php and i think more then 90% from l2 sites use it....iframes are used in any sites... but if you use it using a little css/javascript u dont see them....

check your banking.java

check if you have the part of the sql command to insert into ........ if you removed some lines ....you may removed the wrong one:) check the username and password of your mysql server....if you dont have a password put it like this "" if you realy want it can be done.....but i dont have a server online and i didnt have the motivation to make more....its realy easy if you use javascript/jquery....to check if a button is clicked.,... like i did it you must make a iframe for the verify.php.......if you want iou can change it No.

i think it work in any chronic from interlude..... i don't know for sure

go to \data\scripts\handlers\itemhandlers\itemskilltemplate.java and put a line like this if (item.getItemId()==728 && playable.getPvpFlag() > 0) { return; }

sorry im not so active on the forum like i have said this was my second script in php... i will make a new update in a few days for this one just for mxc cuz i dont have a l2 server anymore ^.^ for now i will answer to replays please tell me what you have "fix" just want to know.. post what correction i need to do...im a beginer in php but u will see the difference in vs...i promise:D dose it give any e in your server you need to instal a php server...easy php/wamp or any other will work...after you install the program you go it's folder and seach for the root folder usual it is www or htdocs or something like that...paste verify.php there and make a link or iframe to your site to it.. first post you game server version... it was made for freya...if you want to do add it in other send me the bank.java and i will make a file for you if the player can vote i don't see any thing wrong.... add a log to php to log any errors...and give me a response will add sone allready answered

sorry for not giving answer 2 you i was in vacation :D 2 possibilities.. proxy/sql injection(i will add anti sql injection in a v2) i have some ideas and i will make a v2 of it when i have a little time maybe you have changed the name of the tables or something... you can put in any l2 project (l2jfree/l2j ....) but you need to rework a little the ".reward" command...

then its from your php server ...or you use it in some other script or something ....for me it works perfectly :)

you did something wrong in the $SiteUrl or you changed the line...(i just want to know...)

script updated

i don't see why you get this error ....the script is tested ....but still try this: replace this: header('Location:'.$SiteUrl[$SiteId]); with: echo '<SCRIPT LANGUAGE="javascript">window.location=\''.$SiteUrl[$SiteId].'\'</SCRIPT>'; i recomand to first check the: $SiteUrl=array(1=>'http://l2.hopzone.net/vote.php?site=86781' ,2=>'http://l2topzone.com/vote.php?id=3409' ,3=>'http://www.gamesites200.com/lineage2/in.php?id=25341' ,4=>'http://www.l2gamesites.net/vote/455.html' ); to see if you write something wrong

one small question... what class is that st in all quests made in py? L2PcInstance don't have getQuestItemsCount and i need something similar for l2pcinstance...

i have seen similar systems on other servers and i don't see any reason why hopzone won't allow this system and allow that mass reward... you don't force players to vote and its not a script that spams ore vote w/o user's aware...

it will totaly change the gameplay for low/mid server... for high rate server..i don't know...

its a good geodata but i think is from other version's not freya... or it has some bugs.... you can find invisible walls in new freya's areas and i have found some near elven village...(and i didn't seach for them..)

======update 2====== some1 requested it for l2jfrozen pack i've modifed the banking, the rest must be the same.. but i don't have a l2jfrozen server so i can't test it, the only thing that may be wrong is the import you can download it here http://www.4shared.com/file/oN08HXxg/BankingCmd.html change the factory import to :com.l2jfrozen.util.database import L2DatabaseFactory to fix the script i have made a 2.0 version of this but i don't feel like shareing it... but you can check it live on http://www.l2epicwarriors.org/ One important thing! : Hopzone dose not allow this type of system, you will get warnings and maybe even the server removed from them, any other sites dose not have a problem(as far as i know) =========update========== for 2 data base and one connection $DBLoc='localhost'; $DBUser='root'; $DBPass='123123'; $DBName='l2jdb'; $DBLName='l2jlogin'; ........................................... if (!$con){ die('Could not connect: ' . mysql_error());} echo '<br/><center>'; if($Username) { mysql_select_db($DBLName, $con); if(exista($Username,"characters")) { mysql_select_db($DBName, $con); if($SiteId > 0 && $SiteId <1+ count($SiteUrl)) { i didnt test the update cuz i dont have a server but i dont see any reason why it wont work... and if you need to different conection just make another one for the login and use it where the DBLName is used.... WAS It THIS HARD?....realy... ========1st post========= Hi ppl! Today i will share my vote reward system! Some time ago i've seach mxc and other forums for some reward system but what i could find was the system with mass reward and one couind of similar to this one but a lot more complex, and i didn't like them! SO i've made my own one ... all credits to me... notice:i didn't even look at that similar system:P To use it you will need a php server Lets Start: 1) download links: Banking.java votesystem.sql verify.php How To Install it: 1. copy verify.php to your root www folder 2.config verify.php: (Sorry i was to lazy to delete my configuration... but this will help to explain it easyer:P) at the 1st lines of this fille you will see this...go one and modify it like i explain $ServerName='AresKnights'; Replace AresKnights with your server name $ReardName="AK Slver Coint"; Replace Ak Silver Coint with your reward name ...Gold Bar or whatever u use for the next part be shore to use this layout 1=>'value1',2=>'Value2'.... You can put as many websites you want but make shore you don't make mistakes $DelayTime=array(1=>43200,2=>43200,3=>43200,4=>(12*60*60));//in secons is the delay between votes on that site in seconds ....for hopzone is 12h you can even yous somthing like this to make it easyer :4=>(12*60*60) $rewarda-beep-t=array(1=>800,2=>200,3=>100,4=>900); i wanted to give more reward for some links...and i have added this:) $SiteUrl=array(1=>'http://l2.hopzone.net/vote.php?site=86781' ,2=>'http://l2topzone.com/vote.php?id=3409' ,3=>'http://www.gamesites200.com/lineage2/in.php?id=25341' ,4=>'http://www.l2gamesites.net/vote/455.html' ); Put the url's of your voting page...to get this click to vote for your server and before entering the cod for confirmation copy the url $SiteName=array(1=>'Hopzone' ,2=>'TopZone' ,3=>'Gamesite200' ,4=>'l2gamesite' ); Put a name for every vote page ...this name will be visible for players on the select box Next data base and we are done!:P $DBLoc='localhost'; $DBUser='root'; $DBPass='123123'; $DBName='l2jdb'; i don't think this needs more explication . for security reason i recomand to make other user and replace root with that one and give right to that user only on votesystem and votesystemtime tables! 3) go to navicat open your data base right click on it and click on 'execute Batch File..' and open fotesystem.sql that you just download it.. click start and close the navicat:) 4)copy bank.java to your \gameserver\data\scripts\handlers\voicedcommandhandlers and replace the old one 5) configure the bank.java: private int itemid = 3470; replace the 3470 with your reward item id activeChar.sendMessage("you have got "+(votecount)+" AK Silver Coints"); replace ak silver coints with your reward name.... activeChar.sendMessage("First go to aresknights.ucoz.com and vote!"); replace areskingts.ucoz.com with your server url(sorry abount my lazyness) Notice: I have made this system for the last l2j revisions...for older packs you will not need to replace the bank.java ...you will need to make somthing similar by yourself:P this is my second php scripts ...my 1st one was the top pvp/pk/online/rbstatus ..you can find them on mxc a GREAT FORUM!!! All Credits to me (HardStyle) again and i'm waiting for feedback and i'm know that some things can be done better ...so please help me improve myself :D I'm seaching for ways to get mac address of client using php cuz this system can be spam if the player changes his ip address (but how cares...you get the votes :P) Edite: use .reward in game to get the reward:P

no man look at this part only: if (playable.getPvpFlag() > 0) //if the player is flaged { super.useItem(playable, item, forceUse);//just use the normal mana potion from skill 10001 } else//else if is not flaged {super.useItem(playable, item, forceUse); //use the mana potion playable.setCurrentMp(playable.getCurrentMp()+800);// and add aditional 800 mana bonus } i think this will clear your mind

this fix is shared on mxc allready ...i say'd it 2 time i think...you should mention this is a fix for the bug when you get the error "blablabla out of range at colum id" or something similar 2 that on your gs... i had this on my spawnlist table ... and thx:)

nice share and thx for the ppl who qoute the download links..... i think mxc form must make somthing about qouts a hidded post