Raised This Month: $51 Target: $400
 12% 

[TF2 Stats] With Web Ranking and Item Logger [v9.1.0]


Post New Thread Reply   
 
Thread Tools Display Modes
dave_with_beer_bottle
Senior Member
Join Date: Jul 2009
Old 04-30-2012 , 22:30   Re: [TF2 Stats] With Web Ranking and Item Logger [v8.18.1]
Reply With Quote #2191

hi, sorry did read, and probably missed it :/ how do i reset the stats via cvar, i mean all players stats back to 0, (i'm using only sqlite)
thank you in advance
dave_with_beer_bottle is offline
DarthNinja
SourceMod Plugin Approver
Join Date: Mar 2009
Location: PreThinkHook()
Old 05-01-2012 , 00:51   Re: [TF2 Stats] With Web Ranking and Item Logger [v8.18.1]
Reply With Quote #2192

Stop the server, and delete or rename the sqlite database file to something else.
The file is data\sqlite\tf2stats.sq3
__________________
DarthNinja is offline
perry
Member
Join Date: May 2010
Old 05-01-2012 , 07:12   Re: [TF2 Stats] With Web Ranking and Item Logger [v8.18.1]
Reply With Quote #2193

Due to structure differences in the SQLite and MySQL database versions, you will have to do an INSERT INTO VALUES statement. You may be able to generate the required SQL by first importing in to intermediary database, exporting, and re-importing.

How can i do that? can anyone give me some example? please!
perry is offline
perry
Member
Join Date: May 2010
Old 05-01-2012 , 08:57   Re: [TF2 Stats] With Web Ranking and Item Logger [v8.18.1]
Reply With Quote #2194

PHP Code:
Fatal errorCall to undefined function curl_init() in C:\wamp\www\player.php on line 384Call Stack#TimeMemoryFunctionLocation10.0024690040{main}( )..\player.php:0 

why i have this error??
perry is offline
Leonardo
Veteran Member
Join Date: Feb 2010
Location: 90's
Old 05-01-2012 , 09:20   Re: [TF2 Stats] With Web Ranking and Item Logger [v8.18.1]
Reply With Quote #2195

turn on cUrl extension in php.ini
__________________
Leonardo is offline
perry
Member
Join Date: May 2010
Old 05-01-2012 , 09:51   Re: [TF2 Stats] With Web Ranking and Item Logger [v8.18.1]
Reply With Quote #2196

can someone help me convert the sqlite into mysql?? please!
perry is offline
perry
Member
Join Date: May 2010
Old 05-01-2012 , 10:19   Re: [TF2 Stats] With Web Ranking and Item Logger [v8.18.1]
Reply With Quote #2197

why it has this error?

#1054 - Unknown column 'IPAddress' in 'field list'
perry is offline
DarthNinja
SourceMod Plugin Approver
Join Date: Mar 2009
Location: PreThinkHook()
Old 05-01-2012 , 13:14   Re: TF2 Stats With Web Ranking and Item Logger
Reply With Quote #2198

Quote:
Originally Posted by DarthNinja View Post
Moving to MySQL from SQLite:
I do not support doing this any more, but you are welcome to try on your own.
  1. Grab your SQLite DB file located at /sourcemod/data/sqlite/tf2stats.sq3
  2. Use this program to open the file export the data from it.
  3. Setup the TF2 stats plugin with MySQL and let it create the table structures.
  4. Import the data *only the data* from the SQLite database.
If you directly copy the SQLite database to MySQL you will be missing a few columns which will cause plugin errors.

Note: Due to structure differences in the SQLite and MySQL database versions, you will have to do an INSERT INTO VALUES statement. You may be able to generate the required SQL by first importing in to intermediary database, exporting, and re-importing.
__________________
DarthNinja is offline
galadril
Senior Member
Join Date: Apr 2009
Old 05-03-2012 , 03:27   Re: [TF2 Stats] With Web Ranking and Item Logger [v8.18.1]
Reply With Quote #2199

Small update for the WebUI. (7.6.1)
I've added all the latest found items to the items.sql + images.

http://www.multiupload.nl/EKXW1KRPX0

Quote:
Originally Posted by jameless View Post
Maybe it's my pc but that link didn't work for me?
Here are some other mirrors:
http://www.mirrorcreator.com/files/0URHETEK/TF2_Ranking_Web_Interface_v7.6.1.zip_links
http://d01.megashares.com/index.php?d01=1bclHCf

https://www.rapidshare.com/files/247...ace_v7.6.1.zip


Added items:
Code:
all_class_ring.db646946bd6898ff304654837e55407cf124b88d.png
all_reckoning_badge.d5d5f44aa6f7aba7ec4767a7bfc114574f68a424.png
all_reckoning_bolgan_demo.0060148eaa66df11caecb2f1356a88831fdfbb46.png
all_reckoning_eagonn_spy.cb361972b3d48c4f3f9634c94a289c4cebe47a48.png
boombox.846e55d239dbf729b3f3ab5eb6fef3292ba3661e.png
cowboyboots_soldier.5211120f4ea54d243bdeb979ab85df5f342f473f.png
crimecraft_helmet_demo.9fb1a334248d8141a3a1c62df355244e18bed898.png
c_ava_roseknife_v.a4c74f0cbff68c2d8700273e56adeda4c4eb2018.png
c_soda_popper.c2bdd7385a26175e9e7a8d0a8f5a4345f90afec2.png
djinn_lamp.76b9a582eba7dbc3a40d5983e75d9e959138cb92.png
drg_badge_copper.084625905ae25e3534674c72d02c45ab02992715.png
drg_badge_silver.3e177b3a4a665203c14ddcb13259ec4f971bc070.png
dueler_demo.3b4e679819841779c710903ab51a82b8bc08570a.png
engineer_chaps.98720e78fc3bc211907d481815ceeab31edfea88.png
eyephoto.ef273a68caea50aa6c86f27b9182c25bc7977df8.png
generous_demo.baed158c7c15916bf4b7182a08840ff945a8585e.png
heavy_boxingtowel.3377e51fca2c3ae1630bc42f6bc03c68959a0d04.png
jag_badge.86597df81a821b9d08d80b948df3ed3dbc51d2b2.png
jag_bob_haircut.30e88c5a13fbcec379d18c83d19e7295b94ac443.png
jag_shadow.4b496f1ea52575be62e34f8daf9349e7da05e523.png
luckyshot.4edc33dce64e4f76c94113169baea5a8bf01335c.png
mapper_medal.c8640471f8e59ce9ce26f7336e65d4e3df292659.png
medic_smokingpipe.732a8d19f2ac57b574b8727dde8b41c4068fc68b.png
morion.f67c835708dc34e5d960a72e60a8a2f8bdc2eecc.png
paintcan.9046edf23b64960a4084dad29d05d2c902feec78.png
pyro_candle.8f06a4026cf7b8ee00cb13f39a215f05548eef30.png
scout_prep_shirt.accbdd22191a4d42a27982a1306cd480c8685ceb.png
shootmanyrobots_pyro.b5b8307105cd1e90faaac9ec66ff607d5bc7ed2f.png
stamper_demo.7d44a04c8da248d384272e6b91a0d2a9438d9020.png
strange_parts.c634ebd3dd467c6828d8df27661d99dfceeb0f71.png
strange_part_airborne_killed.84c965e80225b02093e5e663fa8f54451ad64bbe.png
strange_part_buildings_destroyed.5d0bfb83d35b075fb4dfbb8fd6aa452f73348baf.png
strange_part_burningallyextinguished.c75bcbcf249853c0de883bc11f6f26720c470d5d.png
strange_part_enemies_gibbed.0c8c98fc4bcb6b29e6e4f52e94d13c3e1f897eee.png
strange_part_headshots.ed0baf70cda89a5b0e3896102e0785064efced44.png
strange_part_heavies_killed.d653c80f2b4c0a44977015ddb409d1eb81326798.png
strange_part_playerkillposthumous.b868bb1c34552badadf0c314cc477c1c39230cb7.png
strange_part_projectiles_deflected.72a3c0116b56308d2ea4cf111b2f4f34fa6c7d4c.png
w_builder.a98ad31120795e8cceadd3040dd94b0ea08b5369.png
w_sapper.75e1eda80ea4ba1c12162cb8c562920d9a1deac6.png
xmas_elf_bundle.d606f85105bda3827b99809999fe6cb14d4bbfe0.png
xms_allclass_giftbadge.40cc28f4484227f412e60c1df62df4b06be983bc.png
xms_sniper_commandobackpack.b6424a3ced8f91e3d9f6e3c6cdec5d759c369cdc.png
xms_stickybomb_launcher.5761ea7ec513323f41fd5c130bb6d779f47154f4.png
Cheers
__________________

Last edited by DarthNinja; 08-21-2012 at 17:46. Reason: Most of the links are down, the rapidshare one works though
galadril is offline
jameless
Veteran Member
Join Date: Jan 2010
Old 05-03-2012 , 06:52   Re: [TF2 Stats] With Web Ranking and Item Logger [v8.18.1]
Reply With Quote #2200

Maybe it's my pc but that link didn't work for me?
jameless is offline
Reply



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 09:59.


Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Theme made by Freecode