Db Sql Format
well im having some problems with heldenian
in heldenian when i click in gail to teleport to btfield i go to an invalid map , and at btfield the cannons dont appear ..
and after the heldenian begins, the war dont start, so i cant cast spells or hit anything.. dunno what is wrong
can any1 help me?
edit - i fixed magestic upgrade
ty
in heldenian when i click in gail to teleport to btfield i go to an invalid map , and at btfield the cannons dont appear ..
and after the heldenian begins, the war dont start, so i cant cast spells or hit anything.. dunno what is wrong
can any1 help me?
edit - i fixed magestic upgrade
ty
-
- Outpost bitch
- Posts: 559
- Joined: Wed Mar 30, 2005 6:45 am
in a hurry I made few SQLs to bind DK weapons, I'm shure these SQL can be written better.. but still they work:-)
update item_t set sid1= (select sid1 from character_t where ccharname='RageGM'),
sid2= (select sid2 from character_t where ccharname='RageGM'),
sid3= (select sid3 from character_t where ccharname='RageGM')
where charid=(select charid from character_t where ccharname='RageGM')
and sitemid in (709, 714); <--from item3.cfg itemIDs of DKflam and DKstaff
you have to change only character name...
update item_t set sid1= (select sid1 from character_t where ccharname='RageGM'),
sid2= (select sid2 from character_t where ccharname='RageGM'),
sid3= (select sid3 from character_t where ccharname='RageGM')
where charid=(select charid from character_t where ccharname='RageGM')
and sitemid in (709, 714); <--from item3.cfg itemIDs of DKflam and DKstaff
you have to change only character name...
<img src='http://helbreath.pri.ee/userbars/hbest-gamemaster2.jpg' border='0' alt='user posted image' /> <img src='http://helbreath.pri.ee/userbars/hbsoccer-owner.jpg' border='0' alt='user posted image' /> <img src='http://helbreath.pri.ee/userbars/scorpa-rider.jpg' border='0' alt='user posted image' /> <img src='http://helbreath.pri.ee/userbars/logout-master.jpg' border='0' alt='user posted image' /> <br>.<br>................................Ego sum Rage, flagellum Dei!<br><br>The problem with America is stupidity. I'm not saying there should be a capital punishment for stupidity, but why don't we just take the safety labels off of everything and let the problem solve itself? (bash.org)
-
- Outpost bitch
- Posts: 559
- Joined: Wed Mar 30, 2005 6:45 am
Enterprise manager tools menu... take sql analyzer..Stik wrote: OK total noob here as far as sql is concerned, so how do i use them pls Rage'
then you paste this script to that code window.. and make shure.. that in at the top middle dropdown.. you have selected WS1, not mainlog or some other database...
then you change character name anywhere is written RageGM.. and then execute script with F5 (your char must be loged out and he has to wear or carry in bag DKsword or DKwand)
if you want to bind some other item, then you should add this item number (from item.cfg you can look for this number) to the "IN (itemnumber, itemnumber, itemnumber)" clause..
thats it...
I plan to write SQL script that makes all this binding automatically... and put it into the database job.. that executes this automatic script once in a hour... then you can put DK items to the BS, but them can wear and upgrade only 180 lvl ppl.. who has completed requirements (for DKwand INT must be 100+ and for other weapons must be lvl 180 and only one DKweapon present...)
<img src='http://helbreath.pri.ee/userbars/hbest-gamemaster2.jpg' border='0' alt='user posted image' /> <img src='http://helbreath.pri.ee/userbars/hbsoccer-owner.jpg' border='0' alt='user posted image' /> <img src='http://helbreath.pri.ee/userbars/scorpa-rider.jpg' border='0' alt='user posted image' /> <img src='http://helbreath.pri.ee/userbars/logout-master.jpg' border='0' alt='user posted image' /> <br>.<br>................................Ego sum Rage, flagellum Dei!<br><br>The problem with America is stupidity. I'm not saying there should be a capital punishment for stupidity, but why don't we just take the safety labels off of everything and let the problem solve itself? (bash.org)
About logging to different hgservers, the problem is, usually the hgserver connects to the World server port and world and main server communicates through the internal ports. However for us to log into the game, the main log has connected to the world log port and the hgservers are connected to the internal ports. So there's a possibility that this problem (about logging out and loggin back in when changing servers) may not be resolved...
I also have the same problem when trying to teleport to BtField using Gail. It could have something to do with the teleport.cfg....
I also have the same problem when trying to teleport to BtField using Gail. It could have something to do with the teleport.cfg....
-
- Outpost bitch
- Posts: 559
- Joined: Wed Mar 30, 2005 6:45 am
If its true.. then I stop wasting my time on chinaHGserver.. and try to make my own 2.24b HGserver to work with MSSQL...Sparda wrote: So there's a possibility that this problem (about logging out and loggin back in when changing servers) may not be resolved...
good point.. I try to think about it.. but how I can prevent it? its possible to upgrade item that isn't yours? or explain to me.. how you can upgrade item.. that is binded to other player?regi this is easy tro do dude, but u will have one problem, the unic code, if u dont put that everybody will be able to upgrade it, and this isnt good, couse u can cheat, using a lot of friends to make a really fucking good dk item, just like we did in one non oficial server
<img src='http://helbreath.pri.ee/userbars/hbest-gamemaster2.jpg' border='0' alt='user posted image' /> <img src='http://helbreath.pri.ee/userbars/hbsoccer-owner.jpg' border='0' alt='user posted image' /> <img src='http://helbreath.pri.ee/userbars/scorpa-rider.jpg' border='0' alt='user posted image' /> <img src='http://helbreath.pri.ee/userbars/logout-master.jpg' border='0' alt='user posted image' /> <br>.<br>................................Ego sum Rage, flagellum Dei!<br><br>The problem with America is stupidity. I'm not saying there should be a capital punishment for stupidity, but why don't we just take the safety labels off of everything and let the problem solve itself? (bash.org)
no, i dont
<a href='http://www.beehivemail.com/pages/index.php?refid=jmh1' target='_blank'><img src='http://img235.imageshack.us/img235/7226 ... er16vn.gif' border='0' alt='user posted image' /></a>
-
- Outpost bitch
- Posts: 559
- Joined: Wed Mar 30, 2005 6:45 am
mhm.. thinked out the solution... before binding DKstaff or DKsword... script checks.. if this DKitem is allready binded to another user... It can be checked via sID1-sID3 and if you make index on these three golumns in table character_t then this query even don't make any performance issues:-)nef wrote: regi this is easy tro do dude, but u will have one problem, the unic code, if u dont put that everybody will be able to upgrade it, and this isnt good, couse u can cheat, using a lot of friends to make a really fucking good dk item, just like we did in one non oficial server ¬¬
<img src='http://helbreath.pri.ee/userbars/hbest-gamemaster2.jpg' border='0' alt='user posted image' /> <img src='http://helbreath.pri.ee/userbars/hbsoccer-owner.jpg' border='0' alt='user posted image' /> <img src='http://helbreath.pri.ee/userbars/scorpa-rider.jpg' border='0' alt='user posted image' /> <img src='http://helbreath.pri.ee/userbars/logout-master.jpg' border='0' alt='user posted image' /> <br>.<br>................................Ego sum Rage, flagellum Dei!<br><br>The problem with America is stupidity. I'm not saying there should be a capital punishment for stupidity, but why don't we just take the safety labels off of everything and let the problem solve itself? (bash.org)
woa... I had busy days these weeks and I was about to post a guide and a working files pack but It seems people is learning, working togheter and helping others so... I will let you our own way
*clap clap*
I will release some toys more in some days
*clap clap*
I will release some toys more in some days
<img src='http://213.149.231.16/avatars/firma.jpg' border='0' alt='user posted image' />