Little script for add item in the itemmall, edit SQL code for you and use.
Maybe later complete this script.
Don't foget restart ItemMall Server and Relogin in the game.
Code:
<?php
$conn = mysql_connect ("localhost", "root", "")
or die ("Соединение не установлено!/Not to connect to MySQL!");
print ("Соединение установлено!/Connect to MySQL!");
$v = mysql_select_db("allods_online_billing_trunk_rc2")
or die ("Не существует базы!/Base not found!");
print ("База выбрана успешно/Connect to Base!");
$select = mysql_query('CREATE TABLE IF NOT EXISTS item (
id bigint(20) NOT NULL AUTO_INCREMENT,
res_id int(11) NOT NULL,
stack_count int(11) NOT NULL,
category_id bigint(20) NOT NULL,
price int(11) NOT NULL,
position int(11) NOT NULL,
PRIMARY KEY (id),
UNIQUE KEY IDX_ITEM_POSITION (category_id,position)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=183');
mysql_query ('INSERT INTO item (id, res_id, stack_count, category_id, price, position) VALUES
(190, 129619968, 1, 29, 1000, 15)'); /// This edit and upload on the host of wamp and refresh this page.
mysql_close($conn);
?>
Maybe later complete this script.
Don't foget restart ItemMall Server and Relogin in the game.
Last edited: