[Resolved] Adding custom games to Avarcade?

[bbalegere]

Adding custom games to avarcade?

I have avaracde script installed.
http://www.avscripts.net/avarcade/
I want to install to install these
games into the avarcade script.
How do I do it?
Please help.

 

[Alex.]

Well, perhaps it'd help if you showed us the layout of the files, rather than linking to a 500mb file.

 

[bbalegere]

From what i know to add a games to avarcade script we need to add an entry in the mysql database.
Check this
http://www.forum.avscripts.net/lofiversion/index.php?t1264.html
I have listed the files names as it is when the zip file is unpacked.
It only contains swf files.

img	
04022301.swf	
10.swf	
1000.swf	
1002.swf

1003.swf	
1004.swf	
1005.swf	
1006.swf	
1009.swf

1010.swf	
1011.swf	
1017.swf	
1019.swf	
1020.swf

1021.swf	
1022.swf	
1023.swf	
1024.swf	
1027.swf

1028.swf	
1029.swf	
1030.swf	
1031.swf	
1032.swf

1033.swf	
1034.swf	
1038.swf	
1039.swf	
1040.swf

1042.swf	
1043.swf	
1048.swf	
1050.swf	
1051.swf

1052.swf	
1053.swf	
1055.swf	
1057.swf	
1059.swf

1060.swf	
1063.swf	
1065.swf	
1068.swf	
1069.swf

1070.swf	
1072.dcr	
1073.swf	
1075.swf	
1077.swf

1078.swf	
1079.swf	
1080.swf	
1081.swf	
1082.swf

1083.swf	
1085.swf	
1086.swf	
1087.swf	
1088.swf

1089.swf	
1090.swf	
1092.swf	
1093.swf	
1097.swf

1099.swf	
1100.swf	
1101.swf	
1102.swf	
1103.swf

1104.swf	
1107.swf	
1109.swf	
1110.swf	
1112.swf

1113.swf	
1114.swf	
1115.swf	
1116.swf	
1117.swf

1121.swf	
1122.swf	
1124.swf	
1125.swf	
1126.swf

1127.swf	
1128.swf	
1129.swf	
1131.swf	
1133.swf

1144.swf	
1154.swf	
1155.swf	
1161.swf	
1172.swf

1221.swf	
1222.swf	
1223.swf	
1227.swf	
1228.swf

1230.swf	
1233.swf	
1234.swf	
1236.swf	
1238.swf

1248.swf	
1249.swf	
1252.swf	
1253.swf	
1254.swf

1255.swf	
1256.swf	
1258.swf	
1260.swf	
1261.swf

1264.swf	
1266.swf	
1267.swf	
1272.swf	
1275.swf

1276.swf	
1277.swf	
1278.swf	
1279.swf	
1282.swf

1285.swf	
1286.swf	
1289.swf	
1290.dcr	
1299.swf

12puzzle.swf	
1302.swf	
1303.swf	
1305.swf	
1306.swf

1307.swf	
1309.swf	
1310.swf	
1312.swf	
1313.swf

1316.swf	
1318.dcr	
1319.swf	
1320.swf	
1322.swf

1323.swf	
1324.swf	
1327.swf	
1329.swf	
1330.swf

1331.swf	
1333.swf	
1336.swf	
1340.swf	
1342.swf

1350.swf	
1353.swf	
1354.swf	
1355.swf	
1358.swf

1366.dcr	
1370.swf	
1371.swf	
1372.swf	
1374.swf

1377.swf	
1378.swf	
1380.swf	
1381.swf	
1384.swf

1385.swf	
1386.swf	
1387.swf	
139.dcr	
1391.swf

1392.swf	
1393.swf	
1398.swf	
140.swf	
1400.swf

1401.dcr	
1404.swf	
1408.swf	
1410.dcr	
1416.swf

1417.swf	
1419.swf	
1420.swf	
1422.swf	
1423.swf

1424.swf	
1425.swf	
1426.swf	
1427.swf	
1435.swf

1436.swf	
1438.swf	
1439.swf	
1440.swf	
1441.swf

1442.swf	
1446.swf	
1447.swf	
1448.swf	
1449.swf

1450.swf	
1451.swf	
1452.dcr	
1454.swf	
1455.swf

1456.swf	
1460.swf	
1461.swf	
1464.swf	
1468.swf

1469.swf	
1470.swf	
1472.swf	
1474.swf	
1475.swf

1476.swf	
1477.swf	
1478.swf	
1479.swf	
1481.swf

1483.swf	
1494.swf	
1499.swf	
1500.swf	
1501.swf

1502.swf	
1503.swf	
1505.swf	
1507.swf	
1508.swf

1509.swf	
151.swf	
1511.dcr	
1512.swf	
1513.swf

1514.swf	
1516.swf	
1519.swf	
152.dcr	
1523.swf

1527.swf	
153.swf	
1530.swf	
1532.swf	
1533.swf

1534.swf	
1535.swf	
1536.swf	
1537.swf	
154.swf

1541.dcr	
1545.swf	
1547.swf	
1548.swf	
155.swf

1550.swf	
1554.swf	
1559.swf	
156.swf	
1560.swf

1561.swf	
1562.swf	
1565.swf	
1568.swf	
157.swf

1572.swf	
1578.swf	
1579.swf	
158.swf	
1582.swf

1585.dcr	
1586.swf	
1587.swf	
159.swf	
1590.dcr

1591.swf	
1592.swf	
1595.swf	
1596.swf	
160.swf

1600.swf	
1602.swf	
1603.swf	
161.swf	
1610.swf

1612.swf	
1613.swf	
1616.swf	
1617.swf	
1619.swf

162.swf	
1620.swf	
1621.swf	
1622.swf	
1624.dcr

1627.swf	
1629.swf	
1630.swf	
1631.swf	
1633.swf

1638.swf	
164.swf	
1641.swf	
1642.swf	
1643.swf

1644.swf	
1646.swf	
1648.swf	
1649.swf	
165.swf

1650.swf	
1651.swf	
1652.swf	
1653.swf	
1654.swf

1655.swf	
1660.swf	
1661.swf	
1662.swf	
1665.swf

1667.swf	
1668.swf	
167.swf	
1670.swf	
1671.dcr

1672.swf	
1675.swf	
1676.swf	
1677.swf	
1678.swf

1679.swf	
1681.swf	
1687.swf	
1689.swf	
169.swf

1690.dcr	
1691.swf	
1692.swf	
169262_Mini_Golf.swf	
1693.swf

1695.swf	
1698.swf	
1699.swf	
1700.swf	
1705.dcr

1706.swf	
1707.swf	
1708.swf	
171.swf	
1710.swf

1711.swf	
1712.swf	
1718.swf	
172.swf	
1723.swf

1724.swf	
1725.swf	
1726.swf	
1727.dcr	
1728.swf

1729.swf	
173.swf	
1731.swf	
1733.swf	
1736.swf

1737.swf	
1738.swf	
1742.swf	
1746.swf	
1755.dcr

1756.swf	
1757.swf	
1758.swf	
1759.dcr	
176.swf

1766.swf	
177.swf	
1771.swf	
1772.swf	
1776.swf

1778.swf	
1783.swf	
1792.swf	
1797.swf	
1801.swf

1805.swf	
1806.swf	
1808.swf	
1810.dcr	
1813.swf

1814.swf	
1815.swf	
1816.swf	
1817.swf	
1819.swf

1820.swf	
1823.swf	
1824.swf	
1827.swf	
1832.swf

1833.swf	
1834.swf	
1835.swf	
1839.swf	
184.swf

1840.swf	
1844.swf	
1845.swf	
1846.swf	
1847.swf

1848.swf	
1849.swf	
185.swf	
1856.dcr	
1857.swf

1859.swf	
186.swf	
1860.swf	
1861.swf	
1863.swf

1864.swf	
1869.swf	
187.swf	
1871.swf	
1872.swf

188.swf	
1882.swf	
1885.swf	
189.swf	
1890.swf

1892.swf	
1894.swf	
1897.swf	
19.dcr	
190.swf

1905.swf	
1906.swf	
1907.swf	
1908.swf	
191.swf

1910.swf	
1914.dcr	
1916.swf	
1919.swf	
192.swf

1923.swf	
1924.swf	
1926.swf	
1928.swf	
1929.swf

193.swf	
1930.swf	
1932.swf	
1934.swf	
1937.swf

194.swf	
1940.swf	
1941.swf	
1944.swf	
1955.swf

1965.swf	
1966.swf	
1968.swf	
1970.swf	
1972.swf

1976.swf	
1981.swf	
1985.swf	
1986.swf	
1988.swf

199.swf	
1990.swf	
1994.swf	
1i.swf	
2.swf

20001.swf	
20002.swf	
20003.swf	
20004.swf	
20005.swf

20006.dcr	
20007.swf	
20008.swf	
20009.swf	
20010.swf

20011.swf	
20012.swf	
20013.swf	
20014.swf	
20015.swf

20016.swf	
20017.swf	
276119_krazykar.swf	
35000_chevyracer.swf	
76734_ck_ng.swf

8.swf

 

[Alex.]

EDIT: I can make some queries that will put all of these games into avarcade, but it won't put the games proper name, description or width and height in.

What is the id of the category you want all these games to be put into?

 

[bbalegere]

any category will do for now.
I need SQl code to add the games to category with id 1.
I will change the category later.

 

[Alex.]

http://pastebin.com/m50d23426
Search and replace URL_TO_GAMES_FOLDER with the url to your games folder :P.
i.e. http://www.example.com/path/to/games/folder/ <- The trailing slash is important!

All your games will be imported into cat 1, and they will all have a width and height of 400.

Rep appreciated

EDIT: Oh, and if your games table isn't ava_games, you'll need to change that to the name of your games table.

 

[bbalegere]

Thanks a lot.REP added.
but how did u generate the sql script?

 

[Alex.]

I did a search and replace with regexp in notepad++.
I replaced the filename with the sql query, and put the filename into the description and name field etc.

 

[bbalegere]

Thanks a lot.
This idea did not occur to me as I am using ubuntu.
Must find something similar in Ubuntu to do the above.