Ok thx.

And then put the next codebox in a file named view_itemlogs.php into your evil ro directory...
It should also work on older apache/php versions
(I use XAMPP 1.3 -> www.apachefriends.org)

You need to make sure IIS is configured so users can "run scripts" from the folder you've got AegisCP installed. It's in there somewhere.... just don't know where anymore. Haven't used IIS in a while

insert this into cp_user.php

after

Replace:

Save and close cp_user.php

Have fun

i use time to tell how fast things are going. right now i'm actually trying to alter it more by making it highlight anything that occurect within the last 1minute and everything in the last 10 minutes and another color for the last 1 hour. just to make admin really worthwile, but i'm trying to find the syntax for measuring elapsed time.

any suggestions?

Fatal error: Call to undefined function: mssql_connect() in c:\inetpub\wwwroot\cp\memory.php on line 58

I have enabled it in php.ini. I'm currently using PHP 4.35 with ISS, tell me if there are any compatibilities .

Thanks

and change it to:

this will add cart items to the active item list. if they have cart items, it will appear, otherwise, nothing will appear in the item table.




now... for the storage. it's controlled by account and not by character, so you're gonna have to modifiy user_act.php

edit: storage wasn't working correctly. removed till i fix it.

*sigh* i need sleep...

toodles

I suggest you go with the following or something along similar lines:

Then, instead of getting 600,000, you get how ever many you set $rspp to.

I can only find two php.ini files and also two php_safe.ini files all of which have the line:

extension=php_mssql.dll

inside. I've removed the ; from all four in an attempt to fix the error:

with no luck. I can't see any other fix for this on this topic nor anywhere else on these forums. I've also searched google and php.net but can't find anything different to what's already been said here. Any other possible fixes?

I'm using xampp if that helps you come to a possible solution for me

Thanks

two things.

1) i believe i'm going to be splitting this command into two sections, one for searching and one for entire query. your command may be useful, but it will only show you the currently offset pages, being 50 on my system, which covers an expanse of about 1 minute worth of item results, during low time. it's very hard to scan through what's going on when your results leave the window faster than you can believe.

2) LIMIT is a MySQL command. i did some research (i'm an SQL noob but this is tons of fun) and found the appropriate command for MSSQL would be as follows:

you use a subquery to find a returned var inside a returned var.

the only problem, is that you're still only querying for the RSPP and then an offset inside of it, so multiple pages wont even appear due to the fact there is only one RSPP available. if you want the first page of results, that's "50", per example. well only one page is going to appear, since you've only got 50 responses. the code doesn't work as intended.


toodles

the only problem with this is that to return and count the rows available, you'd still have to query the entire structure and then divide them into pages, which then could give you the page count, the only problem is that you're still having to return all the data, which defeats the purpose of counting.

What I'm trying to do is limit the amount of work the web server has to do. Arrays take massive amounts of memory. In your case, you have an array with 600,000 or however many rows. In each row there is an array with another 10 or so rows of data. If all of the data were 1 byte, then that's 6MB that the mssql server has to give to the web server to output/count/whatever.

In my case, I would have an array with 50 or however many rows you wanted to see per page. Each row having 10 rows associated with it, 1 byte per row, would be 0.5KB. I would have the mssql server do the grunt work of figuring out how many total rows there are in the databse with the help of some simple math on the web server side.

In the end, it's either:

query the database once and loop through everything to count/output

-or-

query the database 3 times and loop through how ever many you want to see per page to output

If you could I would like to see the timed results of both, since I do not have over 600,000 entries in my itemLog or any log table for that matter. I'm sure I have a timer class somewhere if you don't. Hell, I'll even write a script for it if you wanted; I just want to see which is faster

yeah the default extract folder is funky cuz of my network's webserver.

the "fast ticker" should work for both IE and Opera. *shrug* i use opera but i had a friend check the IE compatability.

hello... how i open my mssql port ??

cause i still get error when try to login...

Warning: MS SQL message: Login failed for user 'auth'. (severity 14) in c:\apache\htdocs\kings\memory.php on line 58

Warning: MS SQL: Unable to connect to server: 192.168.0.203 in c:\apache\htdocs\kings\memory.php on line 58

Warning: Supplied argument is not a valid MS SQL-Link resource in c:\apache\htdocs\kings\index.php on line 26



please.. anyone can help me?? cause there are 2 member that posting the same problem n i never see the answer in room .. thx

Replace:

Then:

Search:

Replace:

Yes, there is a difference between equipment and non-equipment in the item table. However, it looks like Gravity stayed consistent with this item syntax, as the storeItem table works exactly the same as the item table. In fact, I could pretty much copy+paste the item section of char_act.php and add it to user_act.php. The only important change I made was the query:
Change:

to

The rest is just copying and pasting, and adding something to the drop-down boxes to access that.

To answer another question, you said that you wanted to highlight things in the item log that happened in the last 1 minute, 10 minute, and hour. This can be easily done with the MSSQL "datediff" function. I looked in view_itemlogs.php for the query you used in the "View Current Logs" section. It was this:

To add a little part for the elapsed time, I did this:

That datediff function will return the time difference between the time in the log, and the current time, in an amount of minutes. Notice that I named the column "elapsed," so you could use:

Now that it has the elapsed time, you could use some simple if-statements to change the colors:

Then, change the lines where it prints the table to use "$color" for the bgcolor instead of "#b6b6b6".

are you using the default configuration of ACP?

also, make sure you're connecting to the correct DSN for your database. it seems these errors are being generated due to the fact it cannot communicate correctly with your DSN. make sure your configation files are correct for your system.

I figured out that the problem was caused by PHP and MSSQL. When you run a query through PHP, only the first 255 bytes of a column are returned. Because storage has so many items, 255 bytes could not nearly be enough. To fix this, I made it run multiple queries, taking 255 bytes at a time. Here's how... If you did what I said in my previous post, you'll have an almost-working-storage viewer. To fix it, change this:

to this:

The same problem could occur with normal item viewing, so you might wanna make a similar change to that.

im using same exact one