Reset game

[alexandarciric]

I need help in script reset.

In reset game, i need this in playerdb:

code: Select all

$result = mysql_query("UPDATE $playerdb SET 
  online=0,
  era=1,
  rank=0,
  attacks=0,
  offsucc=0,
  offtotal=0,
  defsucc=0,
  deftotal=0,
  kills=0,
  turns=$config[initturns],
  turnsstored=0,
  turnsused=0,
  networth=147810,
  cash=100000,
  food=10000,
  peasants=500,
  armtrp=100,
  lndtrp=15,
  flytrp=10,
  seatrp=0,
  health=100,
  wizards=0,
  runes=500,
  shield=0,
  gate=0,
  ind_armtrp=25,
  ind_lndtrp=25,
  ind_flytrp=25,
  ind_seatrp=25,
  land=250,
  shops=5,
  homes=20,
  industry=0,
  barracks=5,
  labs=0,
  farms=15,
  towers=0,
  freeland=205,
  tax=10,
  savings=0,
  loan=0,
  pmkt_armtrp=5000,
  pmkt_lndtrp=5000,
  pmkt_flytrp=5000,
  pmkt_seatrp=5000,
  pmkt_food=100000,
  bmperarmtrp=0,
  bmperlndtrp=0,
  bmperflytrp=0,
  bmperseatrp=0,
  aidcred=5,
  msgcred=5");

this need in file sql-setup.php


Help please

[The Beatles]

Be more specific?

Anyway you can stick this in the reset code, which is dbadmin.php.

[Turock]

If you have the most recent release of the code and have not edited the database in anyway then the server reset should be working fine. Login as admin #1, click database administration, then click the reset server button.

If you are reseting and getting any error messages please post them so we can have a better idea of whats happening.

[alexandarciric]

but, i lost clandb and playerdb.... i want reset score list...

[windhound]

you seem to be confused
the game will do everything for you, no mucking around. just login to the admin account and hit the "Server Administration" link at the top. There's a reset button there

unless, ofcourse, you mangled the database (how did you "lose" playerdb and clandb?) in which case just trash it and start over

[alexandarciric]

...yes but players need registar again...

[Ruddertail]

That's normal - most games, including FAF, work that way. Actually, most people appreciate it, as it gives them a chance to change names, races, etc.

[The Beatles]

But as I said, if you don't like that, put your code in dbadmin.php.

[alexandarciric]

ii put in code, and word good.

Thex beatles