[Guide] Item mall

[kingzxc]

For activation item moll it is necessary to make the following:

1. To execute server installation according to a management from pushdx.

2. In folders billingServer and itemMallServer to add bat files:
download it At the end of this topic

3. In a folder \Server\game\data\Packs\to create a file
XDB_ItemMall. Server.pak to place in it a folder
\Server\game\data\ItemMall\without txt and pos files.
Just in case îٌٍàâٍه a folder \Server\game\data\ItemMall\in its initial condition.

4. In the Database allods_online_billing... To bring data. If this base at you is not present, start bat a file startbilingServerCommon.bat at its start there will be an error in which it will be possible to find a full name of an absent database. Create it.

The table category:

INSERT INTO ` category ` VALUES (' 1 ', ' Chests.txt ', ' 151291907 ', ' 578289787 ', ' 1 ');
INSERT INTO ` category ` VALUES (' 2 ', ' Halo.txt ', ' 151291922 ', ' 578289787 ', ' 2 ');
INSERT INTO ` category ` VALUES (' 3 ', ' Mounts.txt ', ' 151291926 ', ' 578289787 ', ' 3 ');
INSERT INTO ` category ` VALUES (' 4 ', ' Runes.txt ', ' 151291910 ', ' 578289787 ', ' 4 ');
INSERT INTO ` category ` VALUES (' 5 ', ' DressShop.txt ', ' 151291924 ', ' 578289700 ', ' 1 ');
INSERT INTO ` category ` VALUES (' 6 ', ' Fireworks.txt ', ' 151291927 ', ' 578289700 ', ' 2 ');
INSERT INTO ` category ` VALUES (' 7 ', ' Heads.txt ', ' 172021769 ', ' 578289700 ', ' 3 ');
INSERT INTO ` category ` VALUES (' 8 ', ' Bags.txt ', ' 151291915 ', ' 578289708 ', ' 1 ');
INSERT INTO ` category ` VALUES (' 9 ', ' Bank.txt ', ' 151291913 ', ' 578289708 ', ' 2 ');
INSERT INTO ` category ` VALUES (' 10 ', ' Chat.txt ', ' 151291921 ', ' 578289708 ', ' 3 ');
INSERT INTO ` category ` VALUES (' 11 ', ' Exchange.txt ', ' 151291929 ', ' 578289708 ', ' 4 ');
INSERT INTO ` category ` VALUES (' 12 ', ' Portals.txt ', ' 151291904 ', ' 578289708 ', ' 5 ');
INSERT INTO ` category ` VALUES (' 13 ', ' Quiz.txt ', ' 151291909 ', ' 578289708 ', ' 6 ');
INSERT INTO ` category ` VALUES (' 14 ', ' Training.txt ', ' 151291912 ', ' 578289708 ', ' 7 ');
INSERT INTO ` category ` VALUES (' 15 ', ' Craftings.txt ', ' 151291920 ', ' 578289674 ', ' 1 ');
INSERT INTO ` category ` VALUES (' 16 ', ' Enchanting.txt ', ' 151291918 ', ' 578289674 ', ' 2 ');
INSERT INTO ` category ` VALUES (' 17 ', ' Items.txt ', ' 155176960 ', ' 578289674 ', ' 3 ');
INSERT INTO ` category ` VALUES (' 18 ', ' Marks.txt ', ' 151291916 ', ' 578289674 ', ' 4 ');
INSERT INTO ` category ` VALUES (' 19 ', ' MountFood.txt ', ' 151291911 ', ' 578289674 ', ' 5 ');
INSERT INTO ` category ` VALUES (' 20 ', ' Rituals.txt ', ' 151291928 ', ' 578289674 ', ' 6 ');
INSERT INTO ` category ` VALUES (' 21 ', ' Sets.txt ', ' 151291919 ', ' 578289674 ', ' 7 ');
INSERT INTO ` category ` VALUES (' 22 ', ' Ships.txt ', ' 151291906 ', ' 578289674 ', ' 8 ');
INSERT INTO ` category ` VALUES (' 23 ', ' Defence.txt ', ' 151291917 ', ' 133507106 ', ' 1 ');
INSERT INTO ` category ` VALUES (' 24 ', ' Magical.txt ', ' 151291925 ', ' 133507106 ', ' 2 ');
INSERT INTO ` category ` VALUES (' 25 ', ' Physical.txt ', ' 151291923 ', ' 133507106 ', ' 3 ');
INSERT INTO ` category ` VALUES (' 26 ', ' Special.txt ', ' 151291905 ', ' 133507106 ', ' 4 ');
INSERT INTO ` category ` VALUES (' 27 ', ' February.txt ', ' 151291914 ', ' 136991753 ', ' 1 ');
INSERT INTO ` category ` VALUES (' 28 ', ' May.txt ', ' 163871771 ', ' 136991753 ', ' 2 ');
INSERT INTO ` category ` VALUES (' 29 ', ' NewYear.txt ', ' 151291908 ', ' 136991753 ', ' 3 ');

The table item:

INSERT INTO ` item ` VALUES (' 1 ', ' 82893824 ', ' 1 ', ' 1 ', ' 1 ', ' 1 ');
INSERT INTO ` item ` VALUES (' 2 ', ' 108157952 ', ' 1 ', ' 1 ', ' 1 ', ' 2 ');
INSERT INTO ` item ` VALUES (' 3 ', ' 148976641 ', ' 10 ', ' 1 ', ' 1 ', ' 3 ');
INSERT INTO ` item ` VALUES (' 4 ', ' 167888917 ', ' 1 ', ' 1 ', ' 1 ', ' 4 ');
INSERT INTO ` item ` VALUES (' 5 ', ' 168781834 ', ' 1 ', ' 1 ', ' 1 ', ' 5 ');
INSERT INTO ` item ` VALUES (' 6 ', ' 157877248 ', ' 1 ', ' 1 ', ' 1 ', ' 6 ');
INSERT INTO ` item ` VALUES (' 7 ', ' 164876291 ', ' 1 ', ' 1 ', ' 1 ', ' 7 ');
INSERT INTO ` item ` VALUES (' 8 ', ' 169723906 ', ' 1 ', ' 1 ', ' 1 ', ' 8 ');
INSERT INTO ` item ` VALUES (' 9 ', ' 82894851 ', ' 1 ', ' 1 ', ' 1 ', ' 9 ');
INSERT INTO ` item ` VALUES (' 10 ', ' 82898945 ', ' 1 ', ' 1 ', ' 1 ', ' 10 ');
INSERT INTO ` item ` VALUES (' 11 ', ' 134049794 ', ' 1 ', ' 1 ', ' 1 ', ' 11 ');
INSERT INTO ` item ` VALUES (' 12 ', ' 161004564 ', ' 1 ', ' 1 ', ' 1 ', ' 12 ');
INSERT INTO ` item ` VALUES (' 13 ', ' 82898949 ', ' 1 ', ' 1 ', ' 1 ', ' 13 ');
INSERT INTO ` item ` VALUES (' 14 ', ' 156172291 ', ' 1 ', ' 2 ', ' 1 ', ' 1 ');
INSERT INTO ` item ` VALUES (' 15 ', ' 83118088 ', ' 1 ', ' 2 ', ' 1 ', ' 2 ');
INSERT INTO ` item ` VALUES (' 16 ', ' 83118082 ', ' 1 ', ' 2 ', ' 1 ', ' 3 ');
INSERT INTO ` item ` VALUES (' 17 ', ' 136705030 ', ' 1 ', ' 3 ', ' 1 ', ' 1 ');
INSERT INTO ` item ` VALUES (' 18 ', ' 145395717 ', ' 1 ', ' 4 ', ' 1 ', ' 1 ');
INSERT INTO ` item ` VALUES (' 19 ', ' 145395712 ', ' 1 ', ' 4 ', ' 1 ', ' 2 ');
INSERT INTO ` item ` VALUES (' 20 ', ' 82915334 ', ' 1 ', ' 4 ', ' 1 ', ' 3 ');
INSERT INTO ` item ` VALUES (' 21 ', ' 145395713 ', ' 1 ', ' 4 ', ' 1 ', ' 4 ');
INSERT INTO ` item ` VALUES (' 22 ', ' 82915330 ', ' 1 ', ' 4 ', ' 1 ', ' 5 ');
INSERT INTO ` item ` VALUES (' 23 ', ' 145395716 ', ' 1 ', ' 4 ', ' 1 ', ' 6 ');
INSERT INTO ` item ` VALUES (' 24 ', ' 116434088 ', ' 1 ', ' 5 ', ' 1 ', ' 1 ');
INSERT INTO ` item ` VALUES (' 25 ', ' 116433965 ', ' 1 ', ' 5 ', ' 1 ', ' 2 ');
INSERT INTO ` item ` VALUES (' 26 ', ' 116434094 ', ' 1 ', ' 5 ', ' 1 ', ' 3 ');
INSERT INTO ` item ` VALUES (' 27 ', ' 116433966 ', ' 1 ', ' 5 ', ' 1 ', ' 4 ');
INSERT INTO ` item ` VALUES (' 28 ', ' 116434098 ', ' 1 ', ' 5 ', ' 1 ', ' 5 ');
INSERT INTO ` item ` VALUES (' 29 ', ' 116433951 ', ' 1 ', ' 5 ', ' 1 ', ' 6 ');
INSERT INTO ` item ` VALUES (' 30 ', ' 116434068 ', ' 1 ', ' 5 ', ' 1 ', ' 7 ');
INSERT INTO ` item ` VALUES (' 31 ', ' 116434134 ', ' 1 ', ' 5 ', ' 1 ', ' 8 ');
INSERT INTO ` item ` VALUES (' 32 ', ' 124385283 ', ' 1 ', ' 6 ', ' 1 ', ' 1 ');
INSERT INTO ` item ` VALUES (' 33 ', ' 122832924 ', ' 1 ', ' 6 ', ' 1 ', ' 2 ');
INSERT INTO ` item ` VALUES (' 34 ', ' 578289672 ', ' 1 ', ' 6 ', ' 1 ', ' 3 ');
INSERT INTO ` item ` VALUES (' 35 ', ' 77339650 ', ' 1 ', ' 6 ', ' 1 ', ' 4 ');
INSERT INTO ` item ` VALUES (' 36 ', ' 122832904 ', ' 1 ', ' 6 ', ' 1 ', ' 5 ');
INSERT INTO ` item ` VALUES (' 37 ', ' 122832920 ', ' 1 ', ' 6 ', ' 1 ', ' 6 ');
INSERT INTO ` item ` VALUES (' 38 ', ' 578289715 ', ' 1 ', ' 6 ', ' 1 ', ' 7 ');
INSERT INTO ` item ` VALUES (' 39 ', ' 172021765 ', ' 1 ', ' 7 ', ' 1 ', ' 1 ');
INSERT INTO ` item ` VALUES (' 40 ', ' 172021788 ', ' 1 ', ' 7 ', ' 1 ', ' 2 ');
INSERT INTO ` item ` VALUES (' 41 ', ' 90741761 ', ' 1 ', ' 8 ', ' 1 ', ' 1 ');
INSERT INTO ` item ` VALUES (' 42 ', ' 108144700 ', ' 1 ', ' 8 ', ' 1 ', ' 2 ');
INSERT INTO ` item ` VALUES (' 43 ', ' 144046080 ', ' 1 ', ' 8 ', ' 1 ', ' 3 ');
INSERT INTO ` item ` VALUES (' 44 ', ' 108144683 ', ' 1 ', ' 8 ', ' 1 ', ' 4 ');
INSERT INTO ` item ` VALUES (' 45 ', ' 115565623 ', ' 1 ', ' 9 ', ' 1 ', ' 1 ');
INSERT INTO ` item ` VALUES (' 46 ', ' 115565571 ', ' 1 ', ' 9 ', ' 1 ', ' 2 ');
INSERT INTO ` item ` VALUES (' 47 ', ' 115565573 ', ' 1 ', ' 9 ', ' 1 ', ' 3 ');
INSERT INTO ` item ` VALUES (' 48 ', ' 125548549 ', ' 1 ', ' 9 ', ' 1 ', ' 4 ');
INSERT INTO ` item ` VALUES (' 49 ', ' 167407623 ', ' 1 ', ' 9 ', ' 1 ', ' 5 ');
INSERT INTO ` item ` VALUES (' 50 ', ' 115565622 ', ' 1 ', ' 9 ', ' 1 ', ' 6 ');
INSERT INTO ` item ` VALUES (' 51 ', ' 125548556 ', ' 1 ', ' 9 ', ' 1 ', ' 7 ');
INSERT INTO ` item ` VALUES (' 52 ', ' 125548552 ', ' 1 ', ' 9 ', ' 1 ', ' 8 ');
INSERT INTO ` item ` VALUES (' 53 ', ' 81348615 ', ' 1 ', ' 10 ', ' 1 ', ' 1 ');
INSERT INTO ` item ` VALUES (' 54 ', ' 81348608 ', ' 1 ', ' 10 ', ' 1 ', ' 2 ');
INSERT INTO ` item ` VALUES (' 55 ', ' 169217029 ', ' 1 ', ' 10 ', ' 1 ', ' 3 ');
INSERT INTO ` item ` VALUES (' 56 ', ' 160164868 ', ' 1 ', ' 10 ', ' 1 ', ' 4 ');
INSERT INTO ` item ` VALUES (' 57 ', ' 153317376 ', ' 1 ', ' 11 ', ' 1 ', ' 1 ');
INSERT INTO ` item ` VALUES (' 58 ', ' 139406339 ', ' 1 ', ' 11 ', ' 1 ', ' 2 ');
INSERT INTO ` item ` VALUES (' 59 ', ' 139406336 ', ' 1 ', ' 11 ', ' 1 ', ' 3 ');
INSERT INTO ` item ` VALUES (' 60 ', ' 92134406 ', ' 1 ', ' 11 ', ' 1 ', ' 4 ');
INSERT INTO ` item ` VALUES (' 61 ', ' 92134415 ', ' 1 ', ' 11 ', ' 1 ', ' 5 ');
INSERT INTO ` item ` VALUES (' 62 ', ' 92134422 ', ' 1 ', ' 11 ', ' 1 ', ' 6 ');
INSERT INTO ` item ` VALUES (' 63 ', ' 92134400 ', ' 1 ', ' 11 ', ' 1 ', ' 7 ');
INSERT INTO ` item ` VALUES (' 64 ', ' 108144692 ', ' 1 ', ' 12 ', ' 1 ', ' 2 ');
INSERT INTO ` item ` VALUES (' 65 ', ' 8144670 ', ' 1 ', ' 12 ', ' 1 ', ' 3 ');
INSERT INTO ` item ` VALUES (' 66 ', ' 108824576 ', ' 1 ', ' 13 ', ' 1 ', ' 1 ');
INSERT INTO ` item ` VALUES (' 67 ', ' 108824580 ', ' 1 ', ' 13 ', ' 1 ', ' 2 ');
INSERT INTO ` item ` VALUES (' 68 ', ' 103920643 ', ' 1 ', ' 14 ', ' 1 ', ' 1 ');
INSERT INTO ` item ` VALUES (' 69 ', ' 95143937 ', ' 1 ', ' 14 ', ' 1 ', ' 2 ');
INSERT INTO ` item ` VALUES (' 70 ', ' 155033600 ', ' 1 ', ' 15 ', ' 1 ', ' 1 ');
INSERT INTO ` item ` VALUES (' 71 ', ' 155033601 ', ' 1 ', ' 15 ', ' 1 ', ' 2 ');
INSERT INTO ` item ` VALUES (' 72 ', ' 108106811 ', ' 1 ', ' 15 ', ' 1 ', ' 3 ');
INSERT INTO ` item ` VALUES (' 73 ', ' 108106762 ', ' 1 ', ' 15 ', ' 1 ', ' 4 ');
INSERT INTO ` item ` VALUES (' 74 ', ' 108106815 ', ' 1 ', ' 15 ', ' 1 ', ' 5 ');
INSERT INTO ` item ` VALUES (' 75 ', ' 108106767 ', ' 1 ', ' 15 ', ' 1 ', ' 6 ');
INSERT INTO ` item ` VALUES (' 76 ', ' 108106769 ', ' 1 ', ' 15 ', ' 1 ', ' 7 ');
INSERT INTO ` item ` VALUES (' 77 ', ' 109405194 ', ' 1 ', ' 16 ', ' 1 ', ' 1 ');
INSERT INTO ` item ` VALUES (' 78 ', ' 109405188 ', ' 1 ', ' 16 ', ' 1 ', ' 2 ');
INSERT INTO ` item ` VALUES (' 79 ', ' 109405195 ', ' 1 ', ' 16 ', ' 1 ', ' 3 ');
INSERT INTO ` item ` VALUES (' 80 ', ' 169183234 ', ' 1 ', ' 16 ', ' 1 ', ' 4 ');
INSERT INTO ` item ` VALUES (' 81 ', ' 151267328 ', ' 1 ', ' 17 ', ' 1 ', ' 1 ');
INSERT INTO ` item ` VALUES (' 82 ', ' 151267337 ', ' 1 ', ' 17 ', ' 1 ', ' 2 ');
INSERT INTO ` item ` VALUES (' 83 ', ' 151267329 ', ' 1 ', ' 17 ', ' 1 ', ' 3 ');
INSERT INTO ` item ` VALUES (' 84 ', ' 151267332 ', ' 1 ', ' 17 ', ' 1 ', ' 4 ');
INSERT INTO ` item ` VALUES (' 85 ', ' 132810770 ', ' 1 ', ' 18 ', ' 1 ', ' 1 ');
INSERT INTO ` item ` VALUES (' 86 ', ' 132810758 ', ' 1 ', ' 18 ', ' 1 ', ' 2 ');
INSERT INTO ` item ` VALUES (' 87 ', ' 132810763 ', ' 1 ', ' 18 ', ' 1 ', ' 3 ');
INSERT INTO ` item ` VALUES (' 88 ', ' 132810768 ', ' 1 ', ' 18 ', ' 1 ', ' 4 ');
INSERT INTO ` item ` VALUES (' 89 ', ' 132810766 ', ' 1 ', ' 18 ', ' 1 ', ' 5 ');
INSERT INTO ` item ` VALUES (' 90 ', ' 132810781 ', ' 1 ', ' 18 ', ' 1 ', ' 6 ');
INSERT INTO ` item ` VALUES (' 91 ', ' 132810761 ', ' 1 ', ' 18 ', ' 1 ', ' 7 ');
INSERT INTO ` item ` VALUES (' 92 ', ' 132810780 ', ' 1 ', ' 18 ', ' 1 ', ' 8 ');
INSERT INTO ` item ` VALUES (' 93 ', ' 132810779 ', ' 1 ', ' 18 ', ' 1 ', ' 9 ');
INSERT INTO ` item ` VALUES (' 94 ', ' 132810769 ', ' 1 ', ' 18 ', ' 1 ', ' 10 ');
INSERT INTO ` item ` VALUES (' 95 ', ' 147145739 ', ' 1 ', ' 19 ', ' 1 ', ' 1 ');
INSERT INTO ` item ` VALUES (' 96 ', ' 147145744 ', ' 1 ', ' 19 ', ' 1 ', ' 2 ');
INSERT INTO ` item ` VALUES (' 97 ', ' 154597376 ', ' 1 ', ' 20 ', ' 1 ', ' 1 ');
INSERT INTO ` item ` VALUES (' 98 ', ' 154597378 ', ' 1 ', ' 20 ', ' 1 ', ' 2 ');
INSERT INTO ` item ` VALUES (' 99 ', ' 108041234 ', ' 1 ', ' 20 ', ' 1 ', ' 3 ');
INSERT INTO ` item ` VALUES (' 100 ', ' 108041263 ', ' 1 ', ' 20 ', ' 1 ', ' 4 ');
INSERT INTO ` item ` VALUES (' 101 ', ' 155185152 ', ' 1 ', ' 20 ', ' 1 ', ' 5 ');
INSERT INTO ` item ` VALUES (' 102 ', ' 108041260 ', ' 1 ', ' 20 ', ' 1 ', ' 6 ');
INSERT INTO ` item ` VALUES (' 103 ', ' 108041273 ', ' 1 ', ' 20 ', ' 1 ', ' 7 ');
INSERT INTO ` item ` VALUES (' 104 ', ' 108041277 ', ' 1 ', ' 20 ', ' 1 ', ' 8 ');
INSERT INTO ` item ` VALUES (' 105 ', ' 108041285 ', ' 1 ', ' 20 ', ' 1 ', ' 9 ');
INSERT INTO ` item ` VALUES (' 106 ', ' 162319365 ', ' 1 ', ' 21 ', ' 1 ', ' 1 ');
INSERT INTO ` item ` VALUES (' 107 ', ' 108106759 ', ' 1 ', ' 21 ', ' 1 ', ' 2 ');
INSERT INTO ` item ` VALUES (' 108 ', ' 578289691 ', ' 1 ', ' 21 ', ' 1 ', ' 3 ');
INSERT INTO ` item ` VALUES (' 109 ', ' 108106771 ', ' 1 ', ' 21 ', ' 1 ', ' 4 ');
INSERT INTO ` item ` VALUES (' 110 ', ' 108106797 ', ' 1 ', ' 21 ', ' 1 ', ' 5 ');
INSERT INTO ` item ` VALUES (' 111 ', ' 111281262 ', ' 1 ', ' 21 ', ' 1 ', ' 6 ');
INSERT INTO ` item ` VALUES (' 112 ', ' 111281185 ', ' 1 ', ' 21 ', ' 1 ', ' 7 ');
INSERT INTO ` item ` VALUES (' 113 ', ' 111281171 ', ' 1 ', ' 21 ', ' 1 ', ' 8 ');
INSERT INTO ` item ` VALUES (' 114 ', ' 111281208 ', ' 1 ', ' 21 ', ' 1 ', ' 9 ');
INSERT INTO ` item ` VALUES (' 115 ', ' 145971212 ', ' 1 ', ' 21 ', ' 1 ', ' 10 ');
INSERT INTO ` item ` VALUES (' 116 ', ' 145971200 ', ' 1 ', ' 21 ', ' 1 ', ' 11 ');
INSERT INTO ` item ` VALUES (' 117 ', ' 145971210 ', ' 1 ', ' 21 ', ' 1 ', ' 12 ');
INSERT INTO ` item ` VALUES (' 118 ', ' 152419413 ', ' 1 ', ' 21 ', ' 1 ', ' 13 ');
INSERT INTO ` item ` VALUES (' 119 ', ' 154170370 ', ' 1 ', ' 21 ', ' 1 ', ' 14 ');
INSERT INTO ` item ` VALUES (' 120 ', ' 154170369 ', ' 1 ', ' 21 ', ' 1 ', ' 15 ');
INSERT INTO ` item ` VALUES (' 121 ', ' 145971229 ', ' 1 ', ' 21 ', ' 1 ', ' 16 ');
INSERT INTO ` item ` VALUES (' 122 ', ' 152419345 ', ' 1 ', ' 21 ', ' 1 ', ' 17 ');
INSERT INTO ` item ` VALUES (' 123 ', ' 154170374 ', ' 1 ', ' 21 ', ' 1 ', ' 18 ');
INSERT INTO ` item ` VALUES (' 124 ', ' 154170372 ', ' 1 ', ' 21 ', ' 1 ', ' 19 ');
INSERT INTO ` item ` VALUES (' 125 ', ' 145421314 ', ' 1 ', ' 22 ', ' 1 ', ' 1 ');
INSERT INTO ` item ` VALUES (' 126 ', ' 156735493 ', ' 1 ', ' 22 ', ' 1 ', ' 2 ');
INSERT INTO ` item ` VALUES (' 127 ', ' 161019909 ', ' 1 ', ' 22 ', ' 1 ', ' 3 ');
INSERT INTO ` item ` VALUES (' 128 ', ' 156671007 ', ' 1 ', ' 22 ', ' 1 ', ' 4 ');
INSERT INTO ` item ` VALUES (' 129 ', ' 135547904 ', ' 1 ', ' 22 ', ' 1 ', ' 5 ');
INSERT INTO ` item ` VALUES (' 130 ', ' 128615432 ', ' 1 ', ' 22 ', ' 1 ', ' 6 ');
INSERT INTO ` item ` VALUES (' 131 ', ' 145421318 ', ' 1 ', ' 22 ', ' 1 ', ' 7 ');
INSERT INTO ` item ` VALUES (' 132 ', ' 156825600 ', ' 1 ', ' 22 ', ' 1 ', ' 8 ');
INSERT INTO ` item ` VALUES (' 133 ', ' 145421322 ', ' 1 ', ' 22 ', ' 1 ', ' 9 ');
INSERT INTO ` item ` VALUES (' 134 ', ' 145421313 ', ' 1 ', ' 22 ', ' 1 ', ' 10 ');
INSERT INTO ` item ` VALUES (' 135 ', ' 156694530 ', ' 1 ', ' 22 ', ' 1 ', ' 11 ');
INSERT INTO ` item ` VALUES (' 136 ', ' 133507138 ', ' 5 ', ' 23 ', ' 1 ', ' 1 ');
INSERT INTO ` item ` VALUES (' 137 ', ' 133507079 ', ' 5 ', ' 23 ', ' 1 ', ' 2 ');
INSERT INTO ` item ` VALUES (' 138 ', ' 133507166 ', ' 5 ', ' 23 ', ' 1 ', ' 3 ');
INSERT INTO ` item ` VALUES (' 139 ', ' 133507111 ', ' 5 ', ' 23 ', ' 1 ', ' 4 ');
INSERT INTO ` item ` VALUES (' 140 ', ' 133507110 ', ' 5 ', ' 23 ', ' 1 ', ' 5 ');
INSERT INTO ` item ` VALUES (' 141 ', ' 133507180 ', ' 5 ', ' 23 ', ' 1 ', ' 6 ');
INSERT INTO ` item ` VALUES (' 142 ', ' 133507201 ', ' 5 ', ' 24 ', ' 1 ', ' 1 ');
INSERT INTO ` item ` VALUES (' 143 ', ' 133507139 ', ' 5 ', ' 24 ', ' 1 ', ' 2 ');
INSERT INTO ` item ` VALUES (' 144 ', ' 133507190 ', ' 5 ', ' 24 ', ' 1 ', ' 3 ');
INSERT INTO ` item ` VALUES (' 145 ', ' 133507129 ', ' 5 ', ' 24 ', ' 1 ', ' 4 ');
INSERT INTO ` item ` VALUES (' 146 ', ' 133507163 ', ' 5 ', ' 24 ', ' 1 ', ' 5 ');
INSERT INTO ` item ` VALUES (' 147 ', ' 133507107 ', ' 5 ', ' 24 ', ' 1 ', ' 6 ');
INSERT INTO ` item ` VALUES (' 148 ', ' 133507160 ', ' 5 ', ' 24 ', ' 1 ', ' 7 ');
INSERT INTO ` item ` VALUES (' 149 ', ' 133507099 ', ' 5 ', ' 24 ', ' 1 ', ' 8 ');
INSERT INTO ` item ` VALUES (' 150 ', ' 133507140 ', ' 5 ', ' 25 ', ' 1 ', ' 1 ');
INSERT INTO ` item ` VALUES (' 151 ', ' 133507080 ', ' 5 ', ' 25 ', ' 1 ', ' 2 ');
INSERT INTO ` item ` VALUES (' 152 ', ' 133507150 ', ' 5 ', ' 25 ', ' 1 ', ' 3 ');
INSERT INTO ` item ` VALUES (' 153 ', ' 133507092 ', ' 5 ', ' 25 ', ' 1 ', ' 4 ');
INSERT INTO ` item ` VALUES (' 154 ', ' 133507144 ', ' 5 ', ' 25 ', ' 1 ', ' 5 ');
INSERT INTO ` item ` VALUES (' 155 ', ' 133507086 ', ' 5 ', ' 25 ', ' 1 ', ' 6 ');
INSERT INTO ` item ` VALUES (' 156 ', ' 133507082 ', ' 5 ', ' 26 ', ' 1 ', ' 1 ');
INSERT INTO ` item ` VALUES (' 157 ', ' 133507157 ', ' 5 ', ' 26 ', ' 1 ', ' 2 ');
INSERT INTO ` item ` VALUES (' 158 ', ' 133507081 ', ' 5 ', ' 26 ', ' 1 ', ' 3 ');
INSERT INTO ` item ` VALUES (' 159 ', ' 133507153 ', ' 5 ', ' 26 ', ' 1 ', ' 4 ');
INSERT INTO ` item ` VALUES (' 160 ', ' 133507130 ', ' 5 ', ' 26 ', ' 1 ', ' 5 ');
INSERT INTO ` item ` VALUES (' 161 ', ' 133507199 ', ' 5 ', ' 26 ', ' 1 ', ' 6 ');
INSERT INTO ` item ` VALUES (' 162 ', ' 133507154 ', ' 5 ', ' 26 ', ' 1 ', ' 7 ');
INSERT INTO ` item ` VALUES (' 163 ', ' 133507095 ', ' 5 ', ' 26 ', ' 1 ', ' 8 ');
INSERT INTO ` item ` VALUES (' 164 ', ' 147116079 ', ' 1 ', ' 27 ', ' 1 ', ' 1 ');
INSERT INTO ` item ` VALUES (' 165 ', ' 147116053 ', ' 1 ', ' 27 ', ' 1 ', ' 2 ');
INSERT INTO ` item ` VALUES (' 166 ', ' 147116045 ', ' 1 ', ' 27 ', ' 1 ', ' 3 ');
INSERT INTO ` item ` VALUES (' 167 ', ' 147116064 ', ' 1 ', ' 27 ', ' 1 ', ' 4 ');
INSERT INTO ` item ` VALUES (' 168 ', ' 147116076 ', ' 1 ', ' 27 ', ' 1 ', ' 5 ');
INSERT INTO ` item ` VALUES (' 169 ', ' 147116055 ', ' 1 ', ' 27 ', ' 1 ', ' 6 ');
INSERT INTO ` item ` VALUES (' 170 ', ' 147901453 ', ' 1 ', ' 27 ', ' 1 ', ' 7 ');
INSERT INTO ` item ` VALUES (' 171 ', ' 163871744 ', ' 1 ', ' 28 ', ' 1 ', ' 1 ');
INSERT INTO ` item ` VALUES (' 172 ', ' 163871745 ', ' 1 ', ' 28 ', ' 1 ', ' 2 ');
INSERT INTO ` item ` VALUES (' 173 ', ' 163871747 ', ' 1 ', ' 28 ', ' 1 ', ' 3 ');
INSERT INTO ` item ` VALUES (' 174 ', ' 163871750 ', ' 1 ', ' 28 ', ' 1 ', ' 4 ');
INSERT INTO ` item ` VALUES (' 175 ', ' 163871751 ', ' 1 ', ' 28 ', ' 1 ', ' 5 ');
INSERT INTO ` item ` VALUES (' 176 ', ' 136991744 ', ' 1 ', ' 29 ', ' 1 ', ' 1 ');
INSERT INTO ` item ` VALUES (' 177 ', ' 136991751 ', ' 1 ', ' 29 ', ' 1 ', ' 2 ');
INSERT INTO ` item ` VALUES (' 178 ', ' 136991746 ', ' 1 ', ' 29 ', ' 1 ', ' 3 ');
INSERT INTO ` item ` VALUES (' 179 ', ' 136991745 ', ' 1 ', ' 29 ', ' 1 ', ' 4 ');
INSERT INTO ` item ` VALUES (' 180 ', ' 136991748 ', ' 1 ', ' 29 ', ' 1 ', ' 5 ');
INSERT INTO ` item ` VALUES (' 181 ', ' 137461762 ', ' 1 ', ' 29 ', ' 1 ', ' 6 ');
INSERT INTO ` item ` VALUES (' 182 ', ' 136991754 ', ' 1 ', ' 29 ', ' 1 ', ' 7 ');

Can edit these data as it is necessary to you. Crystals on the account can add through the table account...

5. Start a server. Come into game. Through what that time if all has been made truly item mall will earn..


files READY (Bat)
Screen

SQL files
_ Screen _


thanks to: KuraiNeko & Kreeate
for fix and share the files




Credit to obiako
plz test and give answer if you have any error
:8:

​

 

[brezos]

Re: [GUIDE] Item mall

I have problem with 3. please send files,and patch..

 

[chinaspm]

Re: [GUIDE] Item mall

I use it to get a mistake. Direct disappear, please share your file!!!! Thank you!

 

[KuraiNeko]

Re: [GUIDE] Item mall

It's ok. And items now on itemmail, but status from account not read.
Table structure:
ID: id of acc or transaction??
Name - Account login name i think?
Money - walue of cri
Status - wtf?? - what need add to this part?

 

[Kreeate]

Re: [GUIDE] Item mall

Removed

 

[KuraiNeko]

Re: [GUIDE] Item mall

Here:

 

[KuraiNeko]

Re: [GUIDE] Item mall

I also need info about table structure.
Have no money to itemmail on acc.

Try stand status on active etc. No changes

 

[Kreeate]

Re: [GUIDE] Item mall

Removed

 

[KuraiNeko]

Re: [GUIDE] Item mall

Show more from log. Start billing at first and next itemmail?

 

[KuraiNeko]

Re: [GUIDE] Item mall

With cfg to localhost play^
Try another time^


And you take sucess with add money to itemmail? To account?

 

[Kreeate]

Re: [GUIDE] Item mall

Removed

 

[KuraiNeko]

Re: [GUIDE] Item mall

You should configure your billing server as i see in log - itemmail server could not seen billing

 

[Kreeate]

Re: [GUIDE] Item mall

Removed

 

[KuraiNeko]

Re: [GUIDE] Item mall

I use SQLyog for manage MySQL, many years.

You should use it. But i have no idea what need to add at status column in table.

You must be registered to see links

Someone can say status for transactions?

 

[Kreeate]

Re: [GUIDE] Item mall

Removed

 

[KuraiNeko]

Re: [GUIDE] Item mall

DB correctly filled?

 

[Kreeate]

Re: [GUIDE] Item mall

Removed

 

[KuraiNeko]

Re: [GUIDE] Item mall

Why txt at end?
Make .pak only

I add in files.

And ask about db in MySQL

 

[Kreeate]

Re: [GUIDE] Item mall

Removed

 

[KuraiNeko]

Re: [GUIDE] Item mall

to db, i hope you known how to fill