Questions regarding TD's 2.3

Mu online season 21 - grand opening

NightScare

Legend
Legendary
Nov 11, 2005
3,071
225
290
Nottingham
1) How do i delete everything in the Tbl_Mongen,

get the error displayed below when i try.
1b) can u delete all Mapinfo ct, as i wont be useing ne euro maps either, so is it possiable, to wipe it all.

2), Wil's, Is there a way to, e.g go into weapon.wil extract all images, then build each weapon into a single wil, to be used in graphics folder,

tryed useing LOMimage viewer,
extracted everything,
went to- Build new libary, entered the image numbers, e.g 0-00254, it builds weapon51.wil,/wix, and says its completed, then fk knows were it saved it...lol.

basiclly i want to make every weapon into a single wil for graphics folder, same with armours, as its hard to find armours ect,

3)also how do u edit Dnitem/Stateitems/items.wil?, ne rules with the numbering ect,
as i want to make my items/dnitem/stateitems/graphics folders, only contain images im useing.


4) Also, is there a way to make e.g a scroll, so wen u click it add's a certain amount of gamepoints (obvs done through Qfunction, just is there a command to add gamepoints?)>


5) also dont suppose ne1' knows of ne Weapons/armours graphics folders, with decent fair few in, as fourheros is completly different as they useing 2.6 ¬_¬, or if ne1's got the oldskool project 69 weapons such as the dragonclaw lightningstaff ect, :P



6) Also all Hum.wil's that are avilable now days, have mount images, and obvs mounts r gash on 2.3 and i have no intention of putting them ingame,

so How does it work, can u just use them wil's and if u havnt got mounts it will ignore them images, or what?

and im usin fourheros data ect as thats only half decent server out atm, lol. and there's a few releases in release section, but nothing like there used 2 be.



7) also how do i change sabukwall, to another map, basiclly i wanna make a brand new sabuk, lol, do i just change the map number and co-ords in the castle.txt? or nething more to it.
 
Last edited:

^G0trex

Golden Oldie
Golden Oldie
Nov 7, 2003
1,946
28
135
Bham
1) How do i delete everything in the Tbl_Mongen,

get the error displayed below when i try.
1b) can u delete all Mapinfo ct, as i wont be useing ne euro maps either, so is it possiable, to wipe it all.

2), Wil's, Is there a way to, e.g go into weapon.wil extract all images, then build each weapon into a single wil, to be used in graphics folder,

tryed useing LOMimage viewer,
extracted everything,
went to- Build new libary, entered the image numbers, e.g 0-00254, it builds weapon51.wil,/wix, and says its completed, then fk knows were it saved it...lol.

basiclly i want to make every weapon into a single wil for graphics folder, same with armours, as its hard to find armours ect,

3)also how do u edit Dnitem/Stateitems/items.wil?, ne rules with the numbering ect,
as i want to make my items/dnitem/stateitems/graphics folders, only contain images im useing.


4) Also, is there a way to make e.g a scroll, so wen u click it add's a certain amount of gamepoints (obvs done through Qfunction, just is there a command to add gamepoints?)>


5) also dont suppose ne1' knows of ne Weapons/armours graphics folders, with decent fair few in, as fourheros is completly different as they useing 2.6 ¬_¬, or if ne1's got the oldskool project 69 weapons such as the dragonclaw lightningstaff ect, :P



6) Also all Hum.wil's that are avilable now days, have mount images, and obvs mounts r gash on 2.3 and i have no intention of putting them ingame,

so How does it work, can u just use them wil's and if u havnt got mounts it will ignore them images, or what?

and im usin fourheros data ect as thats only half decent server out atm, lol. and there's a few releases in release section, but nothing like there used 2 be.



7) also how do i change sabukwall, to another map, basiclly i wanna make a brand new sabuk, lol, do i just change the map number and co-ords in the castle.txt? or nething more to it.

1) I don't know about in SQL itself as I just use Access and import/export when necessary. I'd recommend doing that as I think Access is much easier to use for editing, especially en masse.

2) Open the Weapon.wil with HH8 and use the Export button? Though personally I'd use WeMade's LibEdit instead cos it's easier to select the images you want and you can simply copy/paste into a new wil. But bear in mind that there is a limit on how many wil's you can use in the Graphics folder.. All the weapons/armours imgindex's are already in a standard db so I don't see the complication myself.

3) The img index's need to be the same throughout Dnitems/StateItem/Items otherwise the items will mismatch ingame.

4)

Code:
#ACT
GAMEPOINT + 50

5) Don't know.

6) Not true you just have to find them from a 2.3 server client. If you want to use a 2.6 Hum.wil then you'd have to manually delete all the ride images or they'll just mess up ingame.

7) Don't know.
 
Last edited:
Upvote 0

jasper

Golden Oldie
Golden Oldie
Sep 10, 2005
890
3
105
1) How do i delete everything in the Tbl_Mongen,

get the error displayed below when i try.
1b) can u delete all Mapinfo ct, as i wont be useing ne euro maps either, so is it possiable, to wipe it all.


use a query statement, "truncate" or "delete"

TRUNCATE TABLE MAPINFO
or
DELETE FROM MAPINFO

not sure on SQL version you are using to tell you how to open up your query window, or the query program,, google will help you use the statements


7: adding a second castle

http://www.lomcn.co.uk/forum/showthread.php?t=45610&highlight=add+castle
 
Last edited:
Upvote 0

NightScare

Legend
Legendary
Nov 11, 2005
3,071
225
290
Nottingham
Upvote 0

NightScare

Legend
Legendary
Nov 11, 2005
3,071
225
290
Nottingham
1) I don't know about in SQL itself as I just use Access and import/export when necessary. I'd recommend doing that as I think Access is much easier to use for editing, especially en masse.

2) Open the Weapon.wil with HH8 and use the Export button? Though personally I'd use WeMade's LibEdit instead cos it's easier to select the images you want and you can simply copy/paste into a new wil. But bear in mind that there is a limit on how many wil's you can use in the Graphics folder.. All the weapons/armours imgindex's are already in a standard db so I don't see the complication myself.

3) The img index's need to be the same throughout Dnitems/StateItem/Items otherwise the items will mismatch ingame.

4)

Code:
#ACT
GAMEPOINT + 50
5) Don't know.

6) Not true you just have to find them from a 2.3 server client. If you want to use a 2.6 Hum.wil then you'd have to manually delete all the ride images or they'll just mess up ingame.

7) Don't know.


very helpful :) awnsered my question about 2.6 hums,


tho there isnt many 2.3 servers about as all servers rly is fourheros+elysian and there coded personally lol.
 
Upvote 0

jasper

Golden Oldie
Golden Oldie
Sep 10, 2005
890
3
105
open up sql,
navigate down to the table you want emptying
open that table
along the top left hand side under "new query" click the button that highlights "show SQL Pane"
in the new window that opens in the right hand window
type Truncate "and the table you want clearing"
click the red exclamation button, "execute SQL"
make sure you have the correct table open!!!
 
Upvote 0

NightScare

Legend
Legendary
Nov 11, 2005
3,071
225
290
Nottingham
open up sql,
navigate down to the table you want emptying
open that table
along the top left hand side under "new query" click the button that highlights "show SQL Pane"
in the new window that opens in the right hand window
type Truncate "and the table you want clearing"
click the red exclamation button, "execute SQL"
make sure you have the correct table open!!!


"nable to parse query text." error message


FROM TRUNCATE TBL_MONGEN wat i typed
 
Last edited:
Upvote 0

Gezza

Golden Oldie
Golden Oldie
Sep 23, 2008
2,202
65
135
uk
What i do is right click table mongen click modify and then copy all that in there using (ctril c) then make a new table and paiste (using ctil v) the info in, works everytime. Delete the old table and rename the new one :) .
 
Upvote 0

^G0trex

Golden Oldie
Golden Oldie
Nov 7, 2003
1,946
28
135
Bham
open up sql,
navigate down to the table you want emptying
open that table
along the top left hand side under "new query" click the button that highlights "show SQL Pane"
in the new window that opens in the right hand window
type Truncate "and the table you want clearing"
click the red exclamation button, "execute SQL"
make sure you have the correct table open!!!

Sooo much easier to just Select All > Delete in Access.
 
Upvote 0

NightScare

Legend
Legendary
Nov 11, 2005
3,071
225
290
Nottingham
What i do is right click table mongen click modify and then copy all that in there using (ctril c) then make a new table and paiste (using ctil v) the info in, works everytime. Delete the old table and rename the new one :) .


ah nice one :)







Question about graphics folder

can u only have images 100-127 in Weapon

as it doesnt work for like 62.wil ect, only 100+ >< and i rly dont wanna merge all them wils wit weapon.wil (as im crap at that).

and if this is the case, whats max number of weapons weapon.wil can hold in TD's files, and max number of armours, and what number shud armours start at in Graphics folder.

also the numbers start at 0, in .wil's dont they? (well armour 0, shud be naked image), 1 basedress ect,

weapons start from 0 tho? 0=woodensword? or w/e first, or is it 1?.
 
Last edited:
Upvote 0

^G0trex

Golden Oldie
Golden Oldie
Nov 7, 2003
1,946
28
135
Bham
Question about graphics folder

can u only have images 100-127 in Weapon

as it doesnt work for like 62.wil ect, only 100+ >< and i rly dont wanna merge all them wils wit weapon.wil (as im crap at that).

and if this is the case, whats max number of weapons weapon.wil can hold in TD's files, and max number of armours, and what number shud armours start at in Graphics folder.

also the numbers start at 0, in .wil's dont they? (well armour 0, shud be naked image), 1 basedress ect,

weapons start from 0 tho? 0=woodensword? or w/e first, or is it 1?.

Yes you can only have 27 Weapons in Graphics folder (100-127).

Armours start at 51 I think...

I don't remember how many weapons you can get in Weapon.wil, but quite a lot. You have to use it if you want more than 27 weps ingame...

As for what numbers they start with in the database, your db should already have that info. Just look up WoodenSword.
 
Upvote 0

NightScare

Legend
Legendary
Nov 11, 2005
3,071
225
290
Nottingham
Yes you can only have 27 Weapons in Graphics folder (100-127).

Armours start at 51 I think...

I don't remember how many weapons you can get in Weapon.wil, but quite a lot. You have to use it if you want more than 27 weps ingame...

As for what numbers they start with in the database, your db should already have that info. Just look up WoodenSword.


ive cleared all my DB's of everything euro lol

sept para's/pro's/benes/spell's lol.

oops?
 
Upvote 0

^G0trex

Golden Oldie
Golden Oldie
Nov 7, 2003
1,946
28
135
Bham
As I always tell people...there's no point. It's just making things a whole lot harder for yourself. I suggest you download another db for reference purposes.
 
Upvote 0

^G0trex

Golden Oldie
Golden Oldie
Nov 7, 2003
1,946
28
135
Bham
You don't NEED to use them in your server, it's just 100x more logical to have a copy WITH them in...
 
Upvote 0