create a clan with an existing tag

by **Giuvannaru91** on Fri Dec 30, 2011 1:17 am

AWWWWWWWWWWW [evilmonkey]

I am not aware that members were added to the DRI

by **Purzel** on Fri Dec 30, 2011 3:53 am

i said "DRI is trying", which doesn't automatically mean it has happened in the past days. But i predict, if someone is seeing your toptimes and compares it with my toptimes, he will choose the DRI clan.

by **Giuvannaru91** on Fri Dec 30, 2011 5:20 am

you're kidding right?
The DRI is closed...can not recruit anyone.
if they do not accept that there noobs.
I do not think others do.

by **[M4D]FULL_METAL** on Fri Dec 30, 2011 2:47 pm

No faith...

That is all

by **TD Mystic** on Sat Dec 31, 2011 12:34 am

Purzel wrote:so as this clan is still there, even if it was called to be closing, Lost Leaders hereby declare a clan war with Dirty Rotten Idiots or whatever they are called now.

DRI is trying to steal LL members and destroy our clan, so i have no other chance and there will be evil between this clans forever until one of them gets closed.

oh and ex-DRI members cant join the LL clan from now on as this is an action which could be made for spying on our clan.

I have absolutely no idea what's going on, but that made me laugh. :lol:

by **Gametaff** on Sat Dec 31, 2011 1:50 am

[SiK]DemonSeed wrote:This topic doesn't make any sense, why would you want to close a clan that was growing bigger and bigger?

And most of you guys are cool dudes.

Are you the owner of DRI and what does it stand for anyway?

"Damn Really Intoxicated"?

Agreed Demon that is bullshit, i lost 60000 points, and i don't crying like a kid because i'm going to lose all my points and records ohh

And no, the owners are lalo and poxi, come on have some dignity and don't be stupid guys

by **[DRuG]NikT** on Sat Dec 31, 2011 3:37 pm

[DRuG]NikT tries to stay out of it

I hope things work out for u guys.

I wish there was a way to transfer your stats, but it isn't just a case of editing a field in a database.. game databases just file "events" each time you get a point, then the ladder script totals all those events to display people's stats and order them. It's arranged this way to minimize load on the game client and server... but it makes changing things very difficult.

Not sure if that makes sense, but it's complicated - you know how I wrote that ladder script?? Maybe the source code for it will explain why editing a users points isn't simple, like, say, editing a cell in a spreadsheet (which is how I expected it would be).... you don't need to know how to code to get a rough idea of what this script is doing... it looks for events for each player id, then totals and sorts them:

Code: Select all: <? date_default_timezone_set("UTC"); /* MTADM 1.0.x Web Ladder v 1.0 - AcidBrain's 'Scores' Based scriptname: webladder2 author: [DRuG]NikT website: http://forums.drugcrew.com requires: php capable web server on same box as race server, or access to a current registry.db for stats -]alw[-AcidBrain's race_scoringsystem, race_playerstats, race_playerstatsgui from http://mta-sa.chewbakkas.net/ settings: Just one - but feel free to tweak.. just don't rerelease without due credit. Adjust $dbfolder to reference the MTADM server's registry.db The default is serverdir/mods/deathmatch unless you have a script getting registry.db to the web server from the mta server. install: Copy webstats2.php & ttstyle.css to the same directory on a web server relative to the path you edited for dbfolder. run: Tweak address to your server from http://webserverurl/webstats.php */ $dbfolder = "/home/nikt/104/mods/deathmatch/"; $dbname = "registry.db"; $logdb = new PDO("sqlite:".$dbfolder.$dbname); $head = "<!DOCTYPE html PUBLIC '-//W3C//DTD XHTML 1.1//EN' 'http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd'> <html xmlns='http://www.w3.org/1999/xhtml'> <head> <title>Live Ladder for MTADM</title> <meta http-equiv='Content-Type' content='text/html; charset=iso-8859-1' /> <meta http-equiv='content-style-type' content='text/css' /> <link rel='stylesheet' href='ttstyle.css' type='text/css' /> </head> <body style='background-color: transparent;'> <div style='text-align:center; opacity: 0.75; -ms-filter: 'alpha (opacity=75)'; filter: alpha (opacity=75);'> "; $starttable = "<table cellpadding='4' cellspacing='2' style='margin:auto' style='z-index:2;' style='-moz-opacity:0.20;' style='opacity:0.6;' style='filter: alpha (opacity=75); opacity: 0.75; -ms-filter: 'alpha (opacity=75)'; filter: alpha (opacity=75);' width='800px'>"; $endtable = " </table> </div> </body> </html>"; $tablecontents = ""; $rowcount = 0; echo $head; echo $starttable; $tablecontents = ""; echo " <tr style='background-color: rgb(17, 0, 68);'> <td colspan='10' style='color: rgb(255, 255, 255);'><b>[DRuG] MTADM 1.0.4 RACE - LIVE LADDER</b></td> </tr> <tr style='background-color: rgb(17, 0, 68);'> <td colspan='10' style='color: rgb(200, 200, 200);'>Scores are awarded at a rate of 10 points for a win, with an additional 10 for a record • <a href='webstats.php'>Top Times</a></td> </tr> <tr style='background-color: rgb(17, 0, 68);'> <td width=7%>Position</td> <td width=20%>Name</td> <td width=8%><a href='webstats2.php'>Score</a></td> <td width=9%><a href='webstats3.php'>Records</a> <img src='ord.png'></td> <td width=7%><a href='webstats4.php'>1st</a></td> <td width=7%><a href='webstats5.php'>2nd</a></td> <td width=7%><a href='webstats6.php'>3rd</a></td> <td width=11%><a href='webstats7.php'>Race Time</a></td> <td width=7%><a href='webstats8.php'>Races</a></td> <td width=17%><a href='webstats9.php'>Last Seen</a></td> </tr>"; $names=""; $nick=""; $rowcount = 0; $names=$logdb->query("SELECT * from 'PlayerStats_Players'"); foreach ($names as $nick) { $nickid=($rowcount+1); $nickname[$nickid]=$nick[nick]; $rowcount=$rowcount+1; }; $rowcount = 0; $wins=$logdb->query("SELECT * from 'PlayerStats_Stats' WHERE key in ('1026')"); foreach ($wins as $win) { $nickid=$win[id_player]; $won[$nickid]=$win[val]; $rowcount=$rowcount+1; }; $rowcount = 0; $seconds=$logdb->query("SELECT * from 'PlayerStats_Stats' WHERE key in ('1032')"); foreach ($seconds as $second) { $nickid=$second[id_player]; $secondtot[$nickid]=$second[val]; $rowcount=$rowcount+1; }; $rowcount = 0; $thirds=$logdb->query("SELECT * from 'PlayerStats_Stats' WHERE key in ('1033')"); foreach ($thirds as $third) { $nickid=$third[id_player]; $thirdtot[$nickid]=$third[val]; $rowcount=$rowcount+1; }; $rowcount = 0; $times=$logdb->query("SELECT * from 'PlayerStats_Stats' WHERE key in ('1001')"); foreach ($times as $time) { $nickid=$time[id_player]; $timetot[$nickid]=$time[val]; $rowcount=$rowcount+1; }; $rowcount = 0; $races=$logdb->query("SELECT * from 'PlayerStats_Stats' WHERE key in ('1025')"); foreach ($races as $race) { $nickid=$race[id_player]; $racetot[$nickid]=$race[val]; $rowcount=$rowcount+1; }; $rowcount = 0; $seens=$logdb->query("SELECT * from 'PlayerStats_Stats' WHERE key in ('1002')"); foreach ($seens as $seen) { $nickid=$seen[id_player]; $seenout[$nickid]=$seen[val]; $rowcount=$rowcount+1; }; $rowcount = 0; $times=""; $times=$logdb->query("SELECT * from 'PlayerStats_Stats' WHERE key in ('2010')"); foreach ($times as $row) { $nickid=$row[id_player]; $idnum=($row[id_player]); $position=($rowcount+1); $timetotal=round((($timetot[$idnum]/60)/60),1); $seentime=date("d/m/Y g:ia",$seenout[$idnum]); $scoreout[$nickid]=$row[val]; $rowcount=$rowcount+1; }; $rowcount = 0; $tops=$logdb->query("SELECT * from 'PlayerStats_Stats' WHERE key in ('1027') ORDER BY val DESC"); foreach ($tops as $top) { $idnum=($top[id_player]); $position=($rowcount+1); $nickid=$top[id_player]; $toptimes[$nickid]=$top[val]; $timetotal=round((($timetot[$idnum]/60)/60),1); $seentime=date("d/m/Y g:ia",$seenout[$idnum]); $rowcount=$rowcount+1; $tablecontents .= " <tr style='background-color:#000000; color: rgb(200, 200, 200);'> <td>$position</td> <td>$nickname[$idnum]</td> <td>$scoreout[$idnum]</td> <td>$toptimes[$idnum]</td> <td>$won[$idnum]</td> <td>$secondtot[$idnum]</td> <td>$thirdtot[$idnum]</td> <td>$timetotal hrs</td> <td>$racetot[$idnum]</td> <td>$seentime</td> </tr>"; }; echo $tablecontents; echo $endtable; // close connection $logdb = null; ?>

eg. "SELECT * from 'PlayerStats_Stats' WHERE key in ('1033')" lists all the events in the database where a player won a race... each win is recorded separately and unindexed... that's mta.

by **Giuvannaru91** on Sat Dec 31, 2011 10:49 pm

I lost the first place ranking..does not matter I can not wait to change clans and do even better.

by **[SiK]DemonSeed** on Sun Jan 01, 2012 12:46 am

I pretty sure it's possible to keep your points, nikt you try and go into the registry.db, Playerstats_Players find their name and just rename to remove the tag?

I just tested it out and it worked.
Just your toptimes will still have the tags on it though.

And to be known under the same account/password just go into the internal.db, accounts and then edit the name to remove the tag.

by **[DK]Vectra16V** on Sun Jan 01, 2012 1:30 am

[SiK]DemonSeed wrote:I pretty sure it's possible to keep your points, nikt you try and go into the registry.db, Playerstats_Players find their name and just rename to remove the tag?

I just tested it out and it worked.
Just your toptimes will still have the tags on it though.

And to be known under the same account/password just go into the internal.db, accounts and then edit the name to remove the tag.

*bump*
Tried it too, it is possible, but make a backup, I fucked it up the first time

create a clan with an existing tag

Re: create a clan with an existing tag

Re: create a clan with an existing tag

Re: create a clan with an existing tag

Re: create a clan with an existing tag

Re: create a clan with an existing tag

Re: create a clan with an existing tag

Re: create a clan with an existing tag

Re: create a clan with an existing tag

Re: create a clan with an existing tag

Re: create a clan with an existing tag

Who is online