• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

[PHP5][SQL] How many items on server? who is first owner?

Azi

Banned User
Joined
Aug 12, 2007
Messages
1,167
Reaction score
53
Location
Włocławek
Hello, recently I wrote a script which I decided to share with you! The script requires OTS SQL database and PHP version 5 or higher. The script is displaying how much the server is currently at things in the houses in the inventories of players and their deposits and who was the first this thing and what time
Ersiu is my current nickname, in this forum have an old, used once.

Installation:
1. Download a the rar pack with script.
2. Unpack all to your htdocs folder.
3. Copy to htdocs folder your items.xml.
4. Edit config.php and set your database info.
5. http://127.0.0.1/install_items.php to install new table in our server database.
6. goto http://127.0.0.1/itemsconventer.php and pull values and convert items to sql database!
7. http://127.0.0.1/itemscan.php and rename itemscan.php to other name for safe! and add cron job on this file to auto-update item count!
8. Delete install_items.php and itemsconverter.php From htdocs.

Link: http://rapidshare.com/files/157700445/htdocs.rar

Your,
ersiu!
 
Last edited:
o.0 if it's true, then it is AMAZING:D
btw, can anybody look, is this script will reduce server security? Or I speaking about bullshit? xd
 
Ohh! It's really working, nice work ersiu!

Ersiu please edit in all files (connect to mysql & select database)
function die();
"Cannoct"
 
It roxs man =) is it a problem if i convert all the items?
 
Sounds like this could utterly destroy your database if there are 300+ players on, due to all the information updating constantly.

Is that an issue? If not, sounds more than fantastic o_o
 
#up
information updates you can make or set cron job. Informations can be update 1 time at the day, like 3:00 in night. In this time is not many players. : )
 
~bump*
1) Pages are blank when I go to them, so I cant configure them
2) itemscan.php gives me 404
I included items.xml in htdocs
I use gesior for 0.2, tfs 0.2.2.so I had to change the name from index.php to itemconfig.php, so I did fix the index.php names inside the files.. any help??
 
Back
Top