Error in database

[HoundFromHell]

Hy, i just try some days ago to add some weapons from other repack and i added them all sides how should add in init and config and pk all places, when i write code in game i dont get anything not write any with green or any in inventory but in MainSrvT window i still see i get the item without any error and now when opened database is some specific error on IID ill atach photo so u can see what i mean.

Pls help me with this, any idea why that IID have error and how can i fix it?

 

[skye]

Does they have the same index on both server and client side?
Is the index repeated either side?
Is the hypertext image client side with the correct name?

Kind regards,

Skye

 

[Ace-SG1-]

Try and run this. its the negative IID is causation the errors that you have. this should fix.

   <?php $db_host = ""; $auth_db = ""; $data_db = ""; 
mssql_connect($db_host); mssql_select_db($data_db); $query_item = mssql_query("SELECT [IID] FROM [Item] ORDER BY [IID] DESC"); $query_item_data = mssql_fetch_array($query_item); $item_id = $query_item_data[0]; if($item_id < 0) $item_id =0; $query = mssql_query("SELECT * FROM [Item] WHERE [IID] < 0"); while($data = mssql_fetch_array($query)) {     extract($data);     $item_id++;     mssql_query("UPDATE [Item] SET [IID] = $item_id WHERE [IID] = $IID");     echo "Changing ID: $IID to $item_id<br>"; } echo "Done"; ?>

 

[HoundFromHell]

seems is not that the problem in database cuz i created other items and apears same.... i really dont know reason why they doesent apear i have the ones with 13000 made by me indexes and the other is from the other repack and both kinds same problem not getting anything

 

[Ace-SG1-]

do you have skype?

 

[HoundFromHell]

i will make one now

do you have skype?

give me ur skype pm

i will make one now




give me ur skype pm

i think i found and invited u^^ so just need to accept request^^

 

[Ace-SG1-]

sent it. no odds are thats my old one.

 

[HoundFromHell]

my skype is MadHellHound ^^

 

[Iriis]

IID is not the problem, just write the inititem.txt and config.pk lines here.

 

[HoundFromHell]

This is the Inititem.txt:

;G75 Heavenly Executioner Swords
(item (name 3057) (Index 1914) (Image "Wea219") (Action 23 1) (class weapon sword) (code 1 1 1 1) (country 0 2) (level 75) (wear 1) (limit knight 75) (range 30) (buy 0) (sell 547200) (endurance 140) (maxprotect 150) (specialty (aspeed 700) (Str 19) (Hth 25) (Dex 17) (Attack 920 990) (hp 1938) (hit 132) ) )
(item (name 3058) (Index 1915) (Image "Wea220") (Action 23 2) (class weapon sword2h) (code 1 2 1 1) (country 0 2) (level 75) (wear 1) (limit knight 75) (range 32) (buy 0) (sell 547200) (endurance 140) (maxprotect 150) (specialty (aspeed 1400) (Str 27) (Hth 17) (Dex 14) (Attack 1540 1810) (hp 1875) (hit 131) ) )
;G85 Blue Dragon Wing Stick
(item (name 13024) (Index 13024) (Image "Wea2222") (Action 22 1) (class weapon wand) (code 1 2 1 3) (country 2) (level 85) (wear 1) (limit mage 85) (range 18) (buy 3000000) (sell 500000) (endurance 236) (maxprotect 255) (specialty (aspeed 1000) (Int 65) (Wis 62) (Attack 1145 1155) (Magic 3250 4340) (hp 3250) (mp 3250) (hit 228) ) )



and this is from pk

;G75 Heavenly Executioner Swords
(item (name 3057) (Index 1914) (Image "Wea219") (Action 23 1) (class weapon sword) (code 1 1 1 1) (country 0 2) (level 75) (wear 1) (limit knight 75) (range 30) (buy 0) (sell 547200) (endurance 140) (maxprotect 150) (specialty (aspeed 700) (Str 19) (Hth 25) (Dex 17) (Attack 920 990) (hp 1938) (hit 132) ) )
(item (name 3058) (Index 1915) (Image "Wea220") (Action 23 2) (class weapon sword2h) (code 1 2 1 1) (country 0 2) (level 75) (wear 1) (limit knight 75) (range 32) (buy 0) (sell 547200) (endurance 140) (maxprotect 150) (specialty (aspeed 1400) (Str 27) (Hth 17) (Dex 14) (Attack 1540 1810) (hp 1875) (hit 131) ) )
;G85 Blue Dragon Wing Stick(item (name 13024) (Index 13024) (Image "Wea2222") (Action 22 1) (class weapon wand) (code 1 2 1 3) (country 2) (level 85) (wear 1) (limit mage 85) (range 18) (buy 3000000) (sell 500000) (endurance 236) (maxprotect 255) (specialty (aspeed 1000) (Int 65) (Wis 62) (Attack 1145 1155) (Magic 3250 4340) (hp 3250) (mp 3250) (hit 228) ) )


) )