Jump to content

~!M@R@SL@K0SsS!~

Members
  • Posts

    371
  • Joined

  • Last visited

  • Feedback

    0%

Everything posted by ~!M@R@SL@K0SsS!~

  1. ma s leo pos ksanaegine topic alla oxi se afto to selection sto cliend mods
  2. poio poli mas endiaferi oti tin doulia tin eklepse apo alous para to selection tora....
  3. Nice copy paste throzen! you take the wings for other topics and you get in your pack and after you send us topic! http://www.maxcheaters.com/forum/index.php?topic=23048.0 <-------Black wings http://www.maxcheaters.com/forum/index.php?topic=23052.0 <-------Tears wings(and no Teras.....) Any moderator lock the topic
  4. den ginete mono an kanei to quest an exeis quest manager mporeis na t doseis ta items 8elei 5 lunargets kai 1 hell fire....
  5. prepi na exeis disk w gia na to dior8oseis apo to mysqlbinpath
  6. li8ike to zitima lock and this topic
  7. ok li8ike to 8ema kapoios lock
  8. i open the navicat and all its ok i get in local host and in data base's but i want to update the l2jdb ....
  9. i re-install the navicat and mySQL server and now i keep a backup of tables now i want to install Db to get new files.This is my question now i have pass in my conection and if i go to do install Db say my root@localhost Using password: YES. I put my pass ****** REM ############################################## REM ## Interactive script setup - (by TanelTM) ## REM ############################################## REM Default values: set mysqlBinPath=C:\Program Files\MySQL\MySQL Server 5.0\bin REM LOGINSERVER set lsuser=root set lspass= <--------****** set lsdb=l2jdb set lshost=localhost REM GAMESERVER set gsuser=root set gspass= <----****** set gsdb=l2jdb set gshost=localhost set workdir="%cd%" :loadVars if not exist vars.txt goto createVars ren vars.txt *.bat call vars.bat ren vars.bat *.txt cls goto start :createVars echo This is the first time you run database_installer so we need to set it up... echo. echo Your mysqlBinPath is? (default: C:\Program Files\MySQL\MySQL Server 5.0\bin) set /P mysqlBinPath=": " echo. echo LoginServer settings echo -------------------- set /P lsuser="User (default is 'root'): " set /P lspass="Pass(will be shown and saved as clear text): " set /P lsdb="Database (default is 'l2jdb'): " set /P lshost="Host (default is 'localhost'): " echo. echo GameServer settings echo ------------------- set /P gsuser="User (default is 'root'): " set /P gspass="Pass (will be shown and saved as clear text): " set /P gsdb="Database (default is 'l2jdb'): " set /P gshost="Host (default is 'localhost'): " echo. echo @set mysqlPath="%mysqlBinPath%\mysql"> vars.txt echo @set mysqlBinPath="%mysqlBinPath%">> vars.txt echo @set mysqldumpPath="%mysqlBinPath%\mysqldump">> vars.txt echo @set lsuser=%lsuser%>> vars.txt echo @set lspass=%lspass%>> vars.txt echo @set lsdb=%lsdb%>> vars.txt echo @set lshost=%lshost%>> vars.txt echo @set gsuser=%gsuser%>> vars.txt echo @set gspass=%gspass%>> vars.txt echo @set gsdb=%gsdb%>> vars.txt echo @set gshost=%gshost%>> vars.txt echo. echo Script setup complete, press any key to continue... pause> nul goto loadVars :start REM ############################################ echo. echo Making a backup of the original loginserver database. %mysqldumpPath% --add-drop-table -h %lshost% -u %lsuser% --password=%lspass% %lsdb% > loginserver_backup.sql echo. echo WARNING: Full install (f) will destroy data in your `accounts` and `gameserver` echo tables. echo. echo Choose upgrade (u) if you already have an `accounts` table but no `gameserver` echo table (ie. your server is a pre LS/GS split version.) echo. echo Choose skip (s) to skip loginserver DB installation and go to gameserver DB echo installation/upgrade. echo. :asklogin set loginprompt=x set /p loginprompt=LOGINSERVER DB install type: (f) full or (u) upgrade or {s} skip or (q) quit? if /i %loginprompt%==f goto logininstall if /i %loginprompt%==u goto loginupgrade if /i %loginprompt%==s goto gsbackup if /i %loginprompt%==q goto end goto asklogin :logininstall echo Deleting loginserver tables for new content. %mysqlPath% -h %lshost% -u %lsuser% --password=%lspass% -D %lsdb% < login_install.sql :loginupgrade echo Installing new loginserver content. %mysqlPath% -h %lshost% -u %lsuser% --password=%lspass% -D %lsdb% < ../sql/accounts.sql %mysqlPath% -h %lshost% -u %lsuser% --password=%lspass% -D %lsdb% < ../sql/gameservers.sql :gsbackup echo. echo Making a backup of the original gameserver database. %mysqldumpPath% --add-drop-table -h %gshost% -u %gsuser% --password=%gspass% %gsdb% > gameserver_backup.sql echo. echo. echo WARNING: A full install (f) will destroy all existing character data. :asktype set installtype=x set /p installtype=GAMESERVER DB install type: (f) full install or (u) upgrade or (s) skip or (q) quit? if /i %installtype%==f goto fullinstall if /i %installtype%==u goto upgradeinstall if /i %installtype%==s goto experimental if /i %installtype%==q goto end goto asktype :fullinstall echo Deleting all gameserver tables for new content. %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < full_install.sql :upgradeinstall echo Installing new gameserver content. %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/chat_filter.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/account_data.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/armor.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/armorsets.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/autoanounce.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/auction.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/auction_bid.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/auction_watch.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/auto_chat.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/auto_chat_text.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/augmentations.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/boxaccess.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/boxes.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/buff_templates.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/castle.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/castle_door.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/castle_doorupgrade.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/castle_manor_procure.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/castle_manor_production.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/castle_siege_guards.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/char_templates.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/character_colors.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/character_friends.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/character_hennas.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/character_macroses.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/character_quests.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/character_raidpoints.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/character_recipebook.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/character_recommends.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/character_shortcuts.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/character_skills.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/character_skills_save.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/character_subclasses.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/characters.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/clan_data.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/clan_privs.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/clan_subpledges.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/clan_skills.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/clan_wars.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/clanhall.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/clanhall_functions.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/class_list.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/couples.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/cursed_weapons.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/custom_armor.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/custom_armorsets.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/custom_etcitem.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/custom_npc.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/custom_spawnlist.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/custom_teleport.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/custom_weapon.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/dimensional_rift.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/droplist.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/enchant_skill_trees.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/etcitem.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/fish.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/fishing_skill_trees.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/forums.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/games.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/global_tasks.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/gm_edit.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/helper_buff_list.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/henna.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/henna_trees.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/heroes.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/items.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/itemsonground.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/locations.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/lvlupgain.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/mapregion.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/merchant_areas_list.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/merchant_buylists.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/merchant_lease.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/merchant_shopids.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/merchants.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/minions.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/npc.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/pets.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/pets_stats.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/pledge_skill_trees.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/posts.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/raid_events_spawnlist.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/raid_prizes.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/npcskills.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/olympiad_nobles.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/raidboss_spawnlist.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/random_spawn.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/random_spawn_loc.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/seven_signs.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/seven_signs_festival.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/seven_signs_status.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/siege_clans.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/skill_learn.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/skill_spellbooks.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/skill_trees.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/spawnlist.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/teleport.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/topic.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/vanhalter_spawnlist.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/vipinfo.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/weapon.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/zone.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/zone_cuboid.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/zone_cylinder.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/zone_npoly.sql echo. :end echo. echo Script complete. pause What ealse i must do to start the install.....??????
  10. Now i re-install navicat and mysql server.i have take backup of me tables :) i keep the folder data in c:\program files\mysql server/data<---
  11. Hello.I have in my db a password how i can change it because if i go to change my pass says me root@localhost using password:YES
  12. malon prepi na kaneis ena ena weapon apo to weapongrp.dat na ta baleis na ta kratane (den eimai sigouros malon einai la8os)
  13. ok perimene na to kano kai 8a s doso to link
  14. miso giati den exo ksanakani upload ama kseris pes m na min psaxnomai :\
  15. koita mesa sto pack 8a pas gameserver/L2Addons<---- eki mesa den s exei buffer se emena eixe kai gia costume buffs 9h...
  16. exeis tou themental??
  17. nai omos na les kai giati pack ton 8es kai giati client...
  18. nai dikio exei otan kaneis ena topick 8a koitas se poio selection briskese giati ta kanoun lock......
  19. terrorXcrew an kai eimai 70% sigouros oti afto to topic kapou....to exo ksanadi Tespa den mporo na to bro tora na sto dikso.......Pantos den einai dikos s 8a psapkso kai 8a to bro na s to dikso
  20. mporeis na psaksis edo http://www.maxcheaters.com/forum/index.php?board=61.0
  21. a ok se eyxaristo.8a to dokimaso kai 8a s po...
  22. ego monos m ta kano kai petixenoune panta.Alla afto to prog m to kaneis share na to exo kai ego?
  23. omg kai 3 lol re c ade esena s aresi na pezeis c3 server ama ton anebaseis pes m poios 8a 8eleisi na mpei e??? :):D
  24. afto einai spam na ksereis......des tous rules tou forum..
  25. koita.Profanos to sql arxeio s den einai sosta grameno i den tergiazi sto client p exeis (interlude i kamael i hellbound) an ksereis kala mporeis na to dior8oseis alios kanto m share edo na to katebaso olo to arxeio na sto ftiakso(8a prospa8iso)kai na ton balo kai ego mesa sto server m.....
×
×
  • Create New...

AdBlock Extension Detected!

Our website is made possible by displaying online advertisements to our members.

Please disable AdBlock browser extension first, to be able to use our community.

I've Disabled AdBlock