hey i need a phew commands for Ether HeidiSQL Or navicat

[Bloodprince]

I need commands for All items 80 and Creatures 80 Etc.
We are making a fun server, so thats why im trying to get all commands as posible
thanks in advance.
And If your a coder/devolper that wonna join let me know ^.^

[shadowknight513]

I'm not quite sure what exactly you are asking / requesting... could you be a little more clear on what you are trying to do, and how you want to do it?

[Aellya]

I think what he means is that he wants a command created that'll give players the ability to receive all level 80 items? or... that he wants all players to be level 80 on creation? or ...uh.

If you want ingame commands created (so players can do ".char additem") its a bigger operation and is done within the core. This cannot be done with sql, sorreh

If you want characters to begin with certain items, levels etc it can be done.

So yeah, please be more specific and we'll try to help out

[Bloodprince]

Ive got told you can make every single creature ingame level 80 with navicat, same with all of the items. you just need the " Command " for it.

[shadowknight513]

I still can hardly understand what you are asking... and why would you want all creatures level 80?

[Bloodprince]

Because im making an All server 80. A server no one has ever seen before thats why.

[shadowknight513]

That just seems impractical to me, and going about doing so, seems even more impractical.

[Bloodprince]

Yeah well =p
Im just looking for the commands, its a query command for heidiSQL/Navicat.

[shadowknight513]

Yeah well =p
Im just looking for the commands, its a query command for heidiSQL/Navicat.

That last part makes no sense... I believe you have no idea what you are talking about. "Query Command" doesn't make sense. Queries are used to insert data into the table of the selected database.

[Elidan0]

/sigh

so you want to turn every single creature to level 80? so there will be level 80 kobolds that were originaly level 1 and have 6dmg and 100 health while there are other level 80 creatures with actual level 80 stats?

seem sensible to me. /end sarcasm

i really wouldn't suggest doing this, if you want the creatures to scale properly so you set them to 80 and they have balanced stats for level 80 then that will require a pretty complex script and you are much better off editing them yourself in the DB

[shadowknight513]

/sigh

so you want to turn every single creature to level 80? so there will be level 80 kobolds that were originaly level 1 and have 6dmg and 100 health while there are other level 80 creatures with actual level 80 stats?

seem sensible to me. /end sarcasm

i really wouldn't suggest doing this, if you want the creatures to scale properly so you set them to 80 and they have balanced stats for level 80 then that will require a pretty complex script and you are much better off editing them yourself in the DB

For arguments sake, let's just say there is 27,000 creatures in the game. (There is actually more). Judging that (If you're fast) editing each creature's stats to be balanced to level 80 takes about 30 seconds, that would mean that's 810,000 seconds, which translates to 13,500 minutes, which is 225 hours, which is 9.375 DAYS of time spent editing. Tedious, monotonous, editing. Have fun Bloodprince.

*8th grade mental math ftw.

[Bloodprince]

Oh well, rather wonna do it properly then do it sloppy. ive seen servers with fcked creatures and shizzle. and i wonna make my server right so. w.e

[shadowknight513]

Dude... what are you saying?!

[Elidan0]

Dude... what are you saying?!

he be sayin shizzle dawg, don ya know da speak of da hood?

[shadowknight513]

Ye G, but da hood he be from ain't no hood I been stormin' ya hear?