-
Posts
371 -
Joined
-
Last visited
-
Feedback
0%
Content Type
Articles
Profiles
Forums
Store
Everything posted by ~!M@R@SL@K0SsS!~
-
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
-
den ginete mono an kanei to quest an exeis quest manager mporeis na t doseis ta items 8elei 5 lunargets kai 1 hell fire....
-
prepi na exeis disk w gia na to dior8oseis apo to mysqlbinpath
-
li8ike to zitima lock and this topic
-
ok li8ike to 8ema kapoios lock
-
[Help]Navicat
~!M@R@SL@K0SsS!~ replied to ~!M@R@SL@K0SsS!~'s question in Request Server Development Help [L2J]
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 .... -
[Help]Navicat
~!M@R@SL@K0SsS!~ replied to ~!M@R@SL@K0SsS!~'s question in Request Server Development Help [L2J]
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.....?????? -
[Help]Navicat
~!M@R@SL@K0SsS!~ replied to ~!M@R@SL@K0SsS!~'s question in Request Server Development Help [L2J]
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<--- -
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
-
[Help]Hero Weapons
~!M@R@SL@K0SsS!~ replied to MrPeos's topic in Server Development Discussion [Greek]
malon prepi na kaneis ena ena weapon apo to weapongrp.dat na ta baleis na ta kratane (den eimai sigouros malon einai la8os) -
ok perimene na to kano kai 8a s doso to link
-
miso giati den exo ksanakani upload ama kseris pes m na min psaxnomai :\
-
koita mesa sto pack 8a pas gameserver/L2Addons<---- eki mesa den s exei buffer se emena eixe kai gia costume buffs 9h...
-
exeis tou themental??
-
nai omos na les kai giati pack ton 8es kai giati client...
-
nai dikio exei otan kaneis ena topick 8a koitas se poio selection briskese giati ta kanoun lock......
-
[Share]Hero Trader!!!
~!M@R@SL@K0SsS!~ replied to TerrorXCrew's topic in Server Development Discussion [Greek]
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 -
hi guys
~!M@R@SL@K0SsS!~ replied to gilerakatos's question in Request Server Development Help [Greek]
mporeis na psaksis edo http://www.maxcheaters.com/forum/index.php?board=61.0 -
a ok se eyxaristo.8a to dokimaso kai 8a s po...
-
ego monos m ta kano kai petixenoune panta.Alla afto to prog m to kaneis share na to exo kai ego?
-
afto einai spam na ksereis......des tous rules tou forum..
-
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.....
