[RELEASE] Gate To Heavens Last Build

[DevilSpeak]

Hello, I have cleaned up the client interface a bit.
@lucky40990 feel free to add this to your main thread if you wish. ;)



Place this file into your client data folder and replace old. TinyUpload.com - best file hosting solution, with no limits, totaly free
*Remember to make backup to data folder before you replace any of your default files.
Enjoy

PS...

I have dedicated box open 24/7 for editing, and test work on my home network.
IDK if I will open one as it takes alot of time & staff to open a private server add content ect.
First thing would have to get a website created, I do not have one that works.

[DevilSpeak]

Here is the Item List for the server I found at item_table.kr translated.

[ITEM_TABLE]// --------------------------------------------
// Item name Totatl 755
// --------------------------------------------


1000: "NULL"
1001: "BLANK"
1002: "Sword of Passover"
1003: "Sword of Honor"
1004: "Baron's one-handed sword"
1005: "X blunt"
1006: "Hodo's two-handed sword"
1007: "Blue Saver"
1008: "Two-handed sword of deterioration"
1009: "Two-handed sword of blood"
1010: "Mystic Palace of the Unicorn"
1011: "Zeppin's Magic Bow"
1012: "The Magic Bow of Anor"
1013: "The Magic Bow of Avita"
1014: "Beaver's Magic Bow"
1015: "BLANK"
1016: "BLANK"
1017: "Bottom of the Sutta"
1018: "Mandala's Bottom"
1019: "Sword of the Wanderers"
1020: "Mandala Protector"
1021: "Great Wall Protector"
1022: "Gloves of the Kracien Iceberg"
1023: "Gloves of Major Womis"
1024: "Teacher Minmin's Shoes"
1025: "The shoes of the Kracien Iceberg"
1026: "Nereck Protector"
1027: "Bottom of Château"
1028: "Basic Energy Pack"
1029: "Master Minmin's Gloves"
1030: "Great Womens Shoes"
1031: "Protector of Month"
1032: "Energy Pack of Harmony"
1033: "Rahla Protector"
1034: "Protectors of Château"
1035: "JUA Protector"
1036: "Soul Energy Pack"
1037: "Energy Pack of Light"
1038: "Suho Energy Pack"
1039: "Ring of Wandering"
1040: "Ring of Wisdom"
1041: "Ring of Courage"
1042: "Flow of Flash"
1043: "the period of selfishness"
1044: "The Necklace of Darkness"
1045: "The Essence of Destruction"
1046: "[Auto] Quest Scrolls"
1047: "Adventurer's Magic Bow"
1048: "Energy Pack of the Mist"
1049: "The Energy Pack of Horin"
1050: "Honen Energy Pack"
1051: "Great Wall"
1052: "The Juana"
1053: "Rahullah Bottom"
1054: "Une's Energy Pack"
1055: "Yamon's Energy Pack"
1056: "The Memory of the Wind"
1057: "Fragments of Time"
1058: "The song of the wind"
1059: "One handed sword"
1060: "Dragon Spiriter"
1061: "Campanula pitch"
1062: "Ipnir Spiriter"
1063: "The spirits of Vulgidia"
1064: "Spirits of return"
1065: "Two-handed sword"
1066: "Magic Bow"
1067: "Dagger"
1068: "Chrysanthemum coupe"
1069: "Dark Shavers"
1070: "The mystery piece"
1071: "12 swords of the good man"
1072: "Dwarf Dagger"
1073: "Mandala's Two-Handed Sword"
1074: "Sulta's one-handed sword"
1075: "Arlene Slasher"
1076: "Orichalcone"
1077: "Agony of Tribulation"
1078: "Spirits"
1079: "The Sword of Extravagues"
1080: "Niminata's side"
1081: "Mogarina of the Rocks"
1082: "Claw"
1083: "Cattleya's father"
1084: "Ring"
1085: "Bracelet"
1086: "Ultra Scrolls"
1087: "Necklace"
1088: "Top"
1089: "Bottom"
1090: "Protector"
1091: "Gloves"
1092: "Shoes"
1093: "The Balken Knot"
1094: "The Lord of the Oak"
1095: "Ning Ha"
1096: "Pingha Ha"
1097: "Energy Pack"
1098: "???"
1099: "Songpyeon"
1100: "Fazha's"
1101: "Only Manza Bottom"
1102: "Kauri"
1103: "Ham moon"
1104: "Egg Moon"
1105: "Flour"
1106: "Hwangyu"
1107: "Walnut"
1108: "Ham"
1109: "Eggs"
1110: "Map Rice Flour"
1111:
1112: "sugar"
1113: "pine needles"
1114: "Mugwort"
1115: "Mate's earrings"
1116: "Penex Bottom"
1117: "Earrings of Takae"
1118: "Tinia Protector"
1119: "Verse"
1120: "Vs."
1121: "W"
1122: "God"
1123: "God (Fri)"
1124: "Psychedelia"
1125: "Ring of the Guardian"
1126: "Production of the first edition"
1127: "Rakki-man mid-range bag"
1128: "Horn of Beetle"
1129: "The Ring of the Soul"
1130: "The spit of Gion of Gush"
1131: "The Baron's Tattoo"
1132: "Guardian necklace"
1133: "Necklace of Love"
1134: "Necklace of the Soul"
1135: "Under the statute"
1136: "Zen Spear"
1137: "Sansna Hahn"
1138: "Dagger of Daylight"
1139: "Perain's Magic Bow"
1140: "Harrod's Magic Bow"
1141: "Dagger of Bones"
1142: "Return to Arayan"
1143: "One-Handed Sword Mastery"
1144: "[Dan] Mad Neria"
1145: "Return to City"
1146: "[Dan] The Sword of the Wanderers"
1147: "Two-Handed Sword Mastery"
1148: "Defend Mastery"
1149: "Strike"
1150: "Focus"
1151: "INSERT"
1152:
1153: "Meditation"
1154: "Magic Bow Mastery"
1155: "Dagger Mastery"
1156: "light movement"
1157: "Blindness"
1158: "Concentration"
1159: "Wind up"
1160: "Range"
1161: "Meditation 2"
1162: "cut out"
1163: "True"
1164: "Magic Mastery"
1165: "Faction Mastery"
1166: "Pita Protector"
1167: "Haun's letter"
1168: "The letter of the chi"
1169: "The letter of the pre-arrival"
1170: "Uda's letter"
1171: "Energy Pack of Challenge"
1172: "Energy Pack of Containers"
1173: "Energy Pack of Wisdom"
1174: "Casting"
1175: "Water freezer"
1176: "Shield Mastery"
1177: "Soulling Lana"
1178: "Max Soul"
1179: "Water Barrier"
1180: "Ice Trap"
1181: "Meditation"
1182: "Spirit Mastery"
1183: "Soul of blood"
1184: "The Beacon of Beat"
1185: "Master Lakey's Shoes"
1186: "Bong's Flour"
1187: "An earth continent soil complex"
1188: "Fragment of the coyote"
1189: "Master Lakin's Gloves"
1190: "Ramonis jewelry"
1191: "Nara Ya Protector"
1192: "Sutta's Protector"
1193: "Protector of the Hollow"
1194: "Razvan top floor return"
1195: "Return to the Upper Level of Razan"
1196: "Rajanan middle class return home"
1197:
1198: "Zantman Hark Protector"
1199: "Decaravia Ha"
1200: "Darbah's"
1201: "Clau Mastery"
1202: "Skin Mastery"
1203: "Bang"
1204: "scratch"
1205: "Mud Skin"
1206: "Polymorph (Koyo)"
1207: "Life of the earth"
1208: "Meditation"
1209: "Sand Wind"
1210: "Time of the year"
1211: "Koyo's ivory"
1212: "The Scales of Worms"
1213: "Worms necklace"
1214: "The Necklace of Van Nets"
1215: "Caraban's Necklace"
1216: "The Loneliness of Fortune"
1217: "The Thinnitus"
1218: "Sister Blessing"
1219: "Modern Quartz Bottoms"
1220: "Sword of Carton"
1221: "Pleasure"
1222: "Glutan Tippon Protector"
1223: "Remy Gap Protector"
1224: "Road Albert Protector"
1225: "Bottom of the Blood"
1226: "Monthly Bottom"
1227: "Bottom of the Hollow"
1228: "Teacher Beetle's Shoes"
1229: "Teacher's Shoes of Zion"
1230: "Gloves of the Teacher Beetle"
1231: "The gloves of the Master Gion Zion"
1232: "Hanon Gentiha"
1233: "Nara Zaha"
1234: "PITA Ha"
1235: "Anorhas"
1236: "Magic Bow of Arkhart"
1237: "Moon's side"
1238: "The Magic Bow of Karancho"
1239: "San Carra Spiriter"
1240: "Tarte Spiriter"
1241: "Wonomi Spiriter"
1242: "Dart of Fortune"
1243: "Lakshmi's Spirits"
1244: "Ornament of the Upscale"
1245: "Corrosion of Gushion"
1246: "Horn's side"
1247: "The Noble Fire of Pleasure"
1248: "Oil of Amplification"
1249: "The Flower of Bellomarine"
1250: "The Stone of Truth"
1251: "The half net of truth"
1252: "Number of USD"
1253: "Akkadaraja"
1254: "Untitled"
1255: "Good luck"
1256: "Akada Ramonis"
1257: "On the Lemigap"
1258: "crushing area"
1259: "Thunderbolt"
1260: "Gon's Spirits"
1261: "Kumho Cho"
1262: "Hahaha the Moon"
1263: "Lakshmi Hae"
1264:
1265: "Uda Panic Claw"
1266: "On the part of the irrigation"
1267: "Brightness"
1268: "Yanti's Necklace"
1269: "The Skin of Yanti"
1270: "The Magic Bow of Surugon Wagon"
1271: "Part of the Honolulu"
1272: "The Bone of Truth"
1273: "Beads of the Soul"
1274: "The ball of glory"
1275: "Beads of awakening"
1276: "Mark of wandering"
1277: "A token of commitment"
1278: "germination of fate"
1279: "germination of awakening"
1280: "germination of the bridle"
1281: "Germination of combined use"
1282: "The egg of the past"
1283: "the current egg"
1284: "The egg of the future"
1285: "Eyes of Acumen"
1286: "[Dan] exine spirits"
1287: "Bessa's mercy piece"
1288: "The chapter of Mausoleum"
1289: "The chapter of the dream"
1290: "Chief of the Blue House"
1291: "Sheet music of life"
1292: "Sheet music of Nephrite"
1293: "Hell's score"
1294: "The Book of the Lost Poet"
1295: "The wind hole of the Great Wall"
1296: "Chin Bhat's Magic Bow"
1297: "Magic Bow of Miltonia"
1298: "Leaves of spirit"
1299: "of the regression

Odmit "1" from /additem - example = /additem 298 = Leaves of spirit

	        604		//EXP Potion				466		//Seed Power
			607		//Combative potion
			613		//Soul Potion
			632		//Ghostly Potion
			609		//Focus Potion	
			620		//lucky stone
			135   // Skill Orb 
			571 	//Space map
			610		// NEW POTION	
			611		//	NEW POTION
			612   // NEW POTION
			615 	//NEW POTION
			98		//MoonCake
			102   // Cake 
			103 	//Cake 	
			862   // Cake 
			863 	//Cake 	
			635 	//Cake 	
			588   // Dumpling 
			589 	// Rice Cracker
			480  //	ROM	
			53		//	??? ??? ?	Level	70
			54		//	??? ??? ?	Level	70	
			467		//	??? ??? ?	Level	70
			598		//	??? ??? ?	Level	70

[lucky40990]

Yes everything is located on client side now for this part ( All languages strings ). and you have a folder language to update in .lv with the language u want i think there is already few languages avalaibles.

Cordialy,

[GateToHeavens]

Dear Respect Lucky
Can you make a Korean client with a level limit of 150?
I really really really want it
please ....help me....

[bin850825]

HI，Lucky。。I would like to ask, when I enter the account password， Client display“database error occurs”
I modified the "server.cfg and config.ini" in the IP
Where is the problem?
please ....help me....

[lucky40990]

HI，Lucky。。I would like to ask, when I enter the account password， Client display“database error occurs”
I modified the "server.cfg and config.ini" in the IP
Where is the problem?
please ....help me....

You made something wrong with SQL user rights ( if you don't use SA user ) , or with ODBC driver configuration.

Cordialy,

[bin850825]

You made something wrong with SQL user rights ( if you don't use SA user ) , or with ODBC driver configuration.

Cordialy,

Thanks for help! The problem may not be the reason why the computer did not restart. Now you can get into the game

[lucky40990]

I updated first post I have fixed many bugs in gameserver . ( monster damages ... ) please update again your gameserver.exe to have no more monster bug damages.

[Sataniceaden]

Hi Lucky,
firstly thank you for the upload i managed to get the server running however i am having some issues and am requesting a little help if possible (has been a long time since i did a GTH server and last time i was using GTH twilight client"

1: cannot seam to dual anyone player talk to "nemes" and they just get asked to wait a moment nothing else happens

2: last zone "mystic lake-23" cannot enter portal to get to this zone

3: DAN battles have no way of starting and clicking battle gives error notice "fail"

4: Cannot get the game servers to start using WAN ip (running on pc behind router servers will only start using 192.*.*.* or 127.*.*.*)

5: client cant connect using "url" rather than IP (using no-ip hostname) / looking at your other post you have talked about client updates but i am unable to find this functionality - is the client still the master for the server files(am i able to still port the scripts and maps from client over to server and just restart?)

also looking through the files i cannot find the commands list for all player/gm commands as i am trying to run scripts/ events but nothing seams to happen using the "GM window" there is also items from the gambler that asks you to goto abys lvl 5 but it does not appear to be included in your files

other questions
sql tables from this version do not appear to be populating the accountdb group (and this is the same for a fair ammount of the GTH_account/game sections (comparing this to the old tables i have from GTH twilight server files "i dont have the full files anymore only the sql& configs (so no maps/data)


sorry for the barrage but i figured i would try and iron out everything before asking

[lucky40990]

1 - You need add a first row in the tbl.battle to make gunryun ... working
2 - This zone was in test but it should works. are you sure the world is started on one of the game_server ?
3 - Refer to 1
5 - You need update everything with 192.XXX.XXX.XXX and put 127.0.0.1 only in YLSERVICE_IP ( master server ) or update everything to 127.0.0.1 and only 192.XXX.XXX.XXX in YLSERVICE_IP ( master server ) i don't remember test both and tell me.
6 - cmds are : /help. and all gm cmds are on first post.
7 - Don't miss to update the files from the first topic i'm doing some updates ...
8 - accountdb was used for website but add accountdb with same users and right i have no tested without and i think they are linked in somehow ...

[loveGTH]

I GOT this error while trying to restore from backup. im using sql server 2005
TITLE: Microsoft SQL Server Management Studio Express
------------------------------

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo)

------------------------------
ADDITIONAL INFORMATION:

The media family on device 'D:\New folder (6)\New folder\DB\accountdb.bak' is incorrectly formed. SQL Server cannot process this media family.
RESTORE HEADERONLY is terminating abnormally. (Microsoft SQL Server, Error: 3241)

For help, click: Microsoft – Officiële startpagina

------------------------------
BUTTONS:

OK
------------------------------


another question: how to create ODBC pleas explain

[Sataniceaden]

I GOT this error while trying to restore from backup. im using sql server 2005
TITLE: Microsoft SQL Server Management Studio Express
------------------------------

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo)

------------------------------
ADDITIONAL INFORMATION:

The media family on device 'D:\New folder (6)\New folder\DB\accountdb.bak' is incorrectly formed. SQL Server cannot process this media family.
RESTORE HEADERONLY is terminating abnormally. (Microsoft SQL Server, Error: 3241)

For help, click: Microsoft – Officiële startpagina

------------------------------
BUTTONS:

OK
------------------------------


another question: how to create ODBC pleas explain

SQL db's got updated you will need to upgrade to have R2 version of SQL (2008) for the import to work correctly
in regards to creating OBDC jump back to the first page and read all the information is in there
@Lucky sorry i didn't get a chance to respond mate been extremely busy at work
cannot get the server to go live with my router in place no matter what i do it cannot resolve host names i did manage to find my original GTH files 1004 checking the inis in them as it was all bat based in those days interestingly enough the bat launcher is allowing my to get the server online so is something to do the the server launcher build only using IP if i was good whit VS or C i would rip hem appart haha

anyway thanks for the help much appreciated

[cheeyuen94]

1 - You need add a first row in the tbl.battle to make gunryun ... working
2 - This zone was in test but it should works. are you sure the world is started on one of the game_server ?
3 - Refer to 1
5 - You need update everything with 192.XXX.XXX.XXX and put 127.0.0.1 only in YLSERVICE_IP ( master server ) or update everything to 127.0.0.1 and only 192.XXX.XXX.XXX in YLSERVICE_IP ( master server ) i don't remember test both and tell me.
6 - cmds are : /help. and all gm cmds are on first post.
7 - Don't miss to update the files from the first topic i'm doing some updates ...
8 - accountdb was used for website but add accountdb with same users and right i have no tested without and i think they are linked in somehow ...

Hi Lucky, I am new to server setup but I have done a lot of research and have a proper idea on how to setup this GTH.

May I know what extra thing should I do if I want to make it WAN connect but not only LAN?

[cheeyuen94]

Hey guys, I need help, there is no server to select in game.
I can login to the game but then there is no server. What is the common issue of this problem?

[pengsaizhen]

@lucky40990 ,thanks...could you share the lasted full source?