vSro free to use PHP Scripts [UPDATED]

[RevoLand]

#What we have for now
_Items table cleaner for better performance.
will be have more, that's why it's in development section.

#Warning#
Be sure about get backup before executing _Items cleaner!

#SVN URL# / need to be updated. \

You must be registered to see links

#About _Items Cleaner#

[SIZE=1]Getting ItemID from _Items and start to checking tables for this item using or not, checking this tables:
_InvCos
_Inventory
_InventoryForAvatar
_InventoryForLinkedStorage
_Chest
_GuildChest
_OpenMarket
and if this id not used in this tables deleting from _Items table.[/SIZE]

# F.A.Q #
-How to use?
--Put cleanitems.php to your web root and edit config inside of it and execute _CheckItem.sql

And don't forget write results to here !
(it's not tested yet so results are important)

 

[Caosfox]

Re: [Release] vSro free to use PHP Scripts

cant test it, but good job, i love when people release things

 

[RevoLand]

Re: [Release] vSro free to use PHP Scripts

cant test it, but good job, i love when people release things

thanks, feel free to suggest anything

 

[nonesense1]

Re: [Release] vSro free to use PHP Scripts

First of all , nice release
2nd , doesn't work- white screen :s
3rd , can be done from SQL... -better-

thanks anyway

 

[RevoLand]

Re: [Release] vSro free to use PHP Scripts

First of all , nice release
2nd , doesn't work- white screen :s
3rd , can be done from SQL... -better-

thanks anyway

1; thanks
2; will check what is wrong

 

[Caosfox]

Re: [Release] vSro free to use PHP Scripts

thanks, feel free to suggest anything

i fail at php.. and my server have sqldrv, dont works with the old mssql commands.
so cant test or event suggest anything Y_Y

 

[InsaneDev]

Re: [Release] vSro free to use PHP Scripts

Not working For me:

You must be registered to see links

 

[RevoLand]

Re: [Release] vSro free to use PHP Scripts

Hello everyone !

If you guys still interested in this script i can make this script as a program so it won't return with timeout.

Thanks.

 

[Mixizi]

Re: [Release] vSro free to use PHP Scripts

On php is good , just you made the thing hard , there is simple way , I'll release an admin panel for Silkroad server ^^

 

[ModGift]

Re: [Release] vSro free to use PHP Scripts

On php is good , just you made the thing hard , there is simple way , I'll release an admin panel for Silkroad server ^^

Php is giving error 'time out' or 'memory out' for big servers ^^

 

[Jangan]

Re: [Release] vSro free to use PHP Scripts

Nice script! so many if statments :O but yeah, it is a good idea to destroy the connection after you are done

mssql_close($baglan);

also a fix to the problems with connection timeouts "i think standard is 60-120 seconds per query" is to either increase the time in MSSQL "BAD IDEA DONT DO IT EVER! unless you know wtf you doing"

or

build a stored procedures and just execute the procedure threw php, instead of running the sql queries inside of php <-- "BEST SOLUTION"


good luck!

 

[RevoLand]

Re: [Release] vSro free to use PHP Scripts [UPDATED]

#Updated.

 

[GusToma]

Re: [Release] vSro free to use PHP Scripts [UPDATED]

ummm i understand this Thread Also i need it important for my server

i`am edited A Perfect DB I Worked on it for 1 month

but i`am afraid from makeing the website cuz of the F@king DDOS Attack

IF You can shows us what u mean i will be pleasure

(Sorry for my english)

 

[Herclues]

Re: [Release] vSro free to use PHP Scripts [UPDATED]

good jop

 

[B1QB0SS]

you stopped this project?!