Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

[guide mini] How to add the crystals in the Item Shop

Experienced Elementalist
Joined
Jan 28, 2013
Messages
235
Reaction score
124
===ru==original===>

Open phpMyAdmin (WAMP server)We go further:
WAMP > phpMyAdmin > allods_billing_rc_4_0_02 > account_money > SQL
Press the button: "INSERT" - clear the field from the example of data entry:
witcherivan - [guide mini] How to add the crystals in the Item Shop - RaGEZONE Forums
and add by hand:
Code:
INSERT INTO `account_money` (`[COLOR=#ff0000]id[/COLOR]`, `[COLOR=#ff8c00]version[/COLOR]`, `[COLOR=#ffd700]account_id[/COLOR]`, `[COLOR=#008000]money[/COLOR]`, `[COLOR=#0000ff]currency_id[/COLOR]`) VALUES([COLOR=#ff0000]1[/COLOR], [COLOR=#ff8c00]141[/COLOR], [COLOR=#ffd700]1[/COLOR], [COLOR=#008000]1000000[/COLOR], [COLOR=#0000ff]1[/COLOR]),([COLOR=#ff0000]2[/COLOR], [COLOR=#ff8c00]8[/COLOR], [COLOR=#ffd700]1[/COLOR], [COLOR=#008000]1000000[/COLOR], [COLOR=#800080]2[/COLOR]),
Press the button: "GO"
witcherivan - [guide mini] How to add the crystals in the Item Shop - RaGEZONE Forums
Consider the value of:
id = (1)|(2) - the number of the order
version = (141)|(8) - version (introduced an arbitrary value (141))
account_id = (1) - account id (value found in: phpMyAdmin > allods_billing_rc_4_0_02 > account)
money = (1000000) - number of crystals
currency_id = (1)|(2) - currency id (1 = standard crystals. 2 = bonus crystals)
 

Attachments

You must be registered for see attachments list
Last edited:
Newbie Spellweaver
Joined
Aug 29, 2010
Messages
37
Reaction score
7
I gon an error
Статический анализ:

Найдено 1 ошибок при анализе.

An opening bracket followed by a set of values was expected. (near "" at position 0)
SQL запрос:

INSERT INTO `account_money`(`id`, `version`, `account_id`, `money`, `currency_id`) VALUES (1, 141, 1, 1000000, 1), (2, 8, 1, 1000000, 2),

Ответ MySQL: Документация

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 4

also when i tryed this method -http://eternal-call.ru/index.php?threads/gajd-ru-kak-dobavit-kristally-v-lavku-redkostej.7/

i got another error

SQL запрос:


INSERT INTO `currency` (`id`, `name`) VALUES
(2, 'HAPPY'),
(1, 'MAIN'),
(3, 'REFERRAL')
Ответ MySQL: Документация

#1062 - Duplicate entry '2' for key 'PRIMARY'


Is my DB "allods_billing_rc_4_0_02" corrupted and i should rebuild it or something else ?

thx
 
Experienced Elementalist
Joined
Jan 28, 2013
Messages
235
Reaction score
124
I gon an error
Статический анализ:

Найдено 1 ошибок при анализе.

An opening bracket followed by a set of values was expected. (near "" at position 0)
SQL запрос:

INSERT INTO `account_money`(`id`, `version`, `account_id`, `money`, `currency_id`) VALUES (1, 141, 1, 1000000, 1), (2, 8, 1, 1000000, 2),

Ответ MySQL: Документация

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 4

also when i tryed this method -http://eternal-call.ru/index.php?threads/gajd-ru-kak-dobavit-kristally-v-lavku-redkostej.7/

i got another error

SQL запрос:


INSERT INTO `currency` (`id`, `name`) VALUES
(2, 'HAPPY'),
(1, 'MAIN'),
(3, 'REFERRAL')
Ответ MySQL: Документация

#1062 - Duplicate entry '2' for key 'PRIMARY'


Is my DB "allods_billing_rc_4_0_02" corrupted and i should rebuild it or something else ?

thx
try so: clear the table account_money
If it doesn't turn out recreate a DB of allods_billing_rc_4_0_02 and restart billingServer
in the first case:
Code:
INSERT INTO `account_money`(`id`, `version`, `account_id`, `money`, `currency_id`) VALUES 
(1, 10, 1, 1000000, 1), 
(2, 20, 1, 1000000, 2),
(3, 30, 1, 1000000, 3);
in the second case:
Code:
INSERT INTO `currency` (`id`, `name`) VALUES
(2, 'HAPPY'),
(1, 'MAIN'),
(3, 'REFERRAL');

---ru-translate---
Попробуй так: очисти таблицу account_money
Если не получится пересоздай БД allods_billing_rc_4_0_02 и перезапусти billingServer

В первом случае:
Code:
INSERT INTO `account_money`(`id`, `version`, `account_id`, `money`, `currency_id`) VALUES 
(1, 10, 1, 1000000, 1), 
(2, 20, 1, 1000000, 2),
(3, 30, 1, 1000000, 3);
Во втором случае:
Code:
INSERT INTO `currency` (`id`, `name`) VALUES
(2, 'HAPPY'),
(1, 'MAIN'),
(3, 'REFERRAL');
 
Back
Top